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)

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

2,961 rows

pencil_puzzles

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

237 rows

sudoku_puzzles

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

3,866 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

4,808 rows

puzzle_setter (hidden)

puzzle_id, setter, aka

3,899 rows

puzzle_subtype (hidden)

puzzle_id, subtype

8,348 rows

video (hidden)

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

3,965 rows

video_host (hidden)

video_id, host

4,030 rows

Views

Download SQLite DB: ctc-catalogue.db 7.8 MB