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

Custom SQL query

charades

rowid, charade, answer, clue_rowids

55,712 rows

clues

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

634,501 rows

indicators

rowid, wordplay, indicator, clue_rowids

14,706 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

122,345 rows

charades_fts (hidden)

charade, answer, charades_fts, rank

55,712 rows

charades_fts_config (hidden)

k, v

1 row

charades_fts_data (hidden)

id, block

215 rows

charades_fts_docsize (hidden)

id, sz

55,712 rows

charades_fts_idx (hidden)

segid, term, pgno

210 rows

clues_fts (hidden)

clue, answer, clues_fts, rank

634,501 rows

clues_fts_config (hidden)

k, v

1 row

clues_fts_data (hidden)

id, block

6,205 rows

clues_fts_docsize (hidden)

id, sz

634,501 rows

clues_fts_idx (hidden)

segid, term, pgno

5,180 rows

indicators_by_clue (hidden)

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

78,969 rows

indicators_fts (hidden)

indicator, indicators_fts, rank

14,706 rows

indicators_fts_config (hidden)

k, v

1 row

indicators_fts_data (hidden)

id, block

36 rows

indicators_fts_docsize (hidden)

id, sz

14,706 rows

indicators_fts_idx (hidden)

segid, term, pgno

34 rows

Download SQLite DB: data.db 180.3 MB