data

Data license: Open Database License (ODbL) v1.0 · About: Datasheet

Custom SQL query

Tables

charades

rowid, charade, answer, clue_rowids

57,289 rows

clues

rowid, clue, answer, definition, clue_number, puzzle_date, puzzle_name, source_url, source

660,613 rows

indicators

rowid, wordplay, indicator, clue_rowids

15,735 rows

indicators_consolidated

alternation, anagram, container, deletion, hidden, homophone, insertion, reversal

1 row

metadata

key, value

3 rows

charades_by_clue (hidden)

clue_rowid, charade, answer

126,825 rows

charades_fts (hidden)

charade, answer, charades_fts, rank

57,289 rows

charades_fts_config (hidden)

k, v

1 row

charades_fts_data (hidden)

id, block

222 rows

charades_fts_docsize (hidden)

id, sz

57,289 rows

charades_fts_idx (hidden)

segid, term, pgno

220 rows

clues_fts (hidden)

clue, answer, clues_fts, rank

660,613 rows

clues_fts_config (hidden)

k, v

1 row

clues_fts_data (hidden)

id, block

6,302 rows

clues_fts_docsize (hidden)

id, sz

660,613 rows

clues_fts_idx (hidden)

segid, term, pgno

4,707 rows

indicators_by_clue (hidden)

clue_rowid, alternation, anagram, container, deletion, hidden, homophone, insertion, reversal

88,037 rows

indicators_fts (hidden)

indicator, indicators_fts, rank

15,735 rows

indicators_fts_config (hidden)

k, v

1 row

indicators_fts_data (hidden)

id, block

38 rows

indicators_fts_docsize (hidden)

id, sz

15,735 rows

indicators_fts_idx (hidden)

segid, term, pgno

36 rows

Download SQLite DB: data.db 187.1 MB