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)

443 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)

3,953 rows

pencil_puzzles

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

286 rows

sudoku_puzzles

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

4,858 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,008 rows

puzzle_setter (hidden)

puzzle_id, setter, aka

4,999 rows

puzzle_subtype (hidden)

puzzle_id, subtype

11,949 rows

video (hidden)

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

5,150 rows

video_host (hidden)

video_id, host

5,253 rows

Views

Download SQLite DB: ctc-catalogue.db 10.0 MB