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)

485 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,457 rows

pencil_puzzles

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

314 rows

sudoku_puzzles

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

5,362 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,616 rows

puzzle_setter (hidden)

puzzle_id, setter, aka

5,587 rows

puzzle_subtype (hidden)

puzzle_id, subtype

14,000 rows

video (hidden)

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

5,703 rows

video_host (hidden)

video_id, host

5,837 rows

Views

Download SQLite DB: ctc-catalogue.db 11.2 MB