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)

473 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,382 rows

pencil_puzzles

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

312 rows

sudoku_puzzles

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

5,287 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,517 rows

puzzle_setter (hidden)

puzzle_id, setter, aka

5,495 rows

puzzle_subtype (hidden)

puzzle_id, subtype

13,651 rows

video (hidden)

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

5,611 rows

video_host (hidden)

video_id, host

5,738 rows

Views

Download SQLite DB: ctc-catalogue.db 11.0 MB