ctc-catalogue

Data source: Cracking the Cryptic Catalogue · About: View on GitHub

Custom SQL query

Tables

crossword_puzzles

Id, Puzzle Title, Date, Solver, Setter, Constraints, Video, Video Length, Video Length (Minutes)

451 rows

gas_puzzles

Id, Puzzle Title, Date, GAS Date, GAS #, Solver, Setter, Constraints, Video, Video Length, Video Length (Minutes)

905 rows

not_gas_puzzles

Id, Puzzle Title, Date, Solver, Setter, Constraints, Video, Video Length, Video Length (Minutes)

4,082 rows

pencil_puzzles

Id, Puzzle Title, Date, Solver, Type, Setter, Constraints, Video, Video Length, Video Length (Minutes)

291 rows

sudoku_puzzles

Id, Puzzle Title, Date, Solver, Setter, Constraints, Video, Video Length, Video Length (Minutes)

4,987 rows

db_metadata (hidden)

last_updated_utc

1 row

puzzle (hidden)

id, title, type, super_category, video_id, video_offset, source, collection, gas_date, gas_num

6,156 rows

puzzle_setter (hidden)

puzzle_id, setter, aka

5,146 rows

puzzle_subtype (hidden)

puzzle_id, subtype

12,455 rows

video (hidden)

id, title, video_type, super_category, date, length_seconds, youtube_link

5,274 rows

video_host (hidden)

video_id, host

5,383 rows

Views

Download SQLite DB: ctc-catalogue.db 10.3 MB