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

Custom SQL query

charades

charade, answer, clue_rowids

63,745 rows

clues

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

603,554 rows

indicators

wordplay, indicator, clue_rowids

11,819 rows

metadata

key, value

3 rows

charades_by_clue (hidden)

clue_rowid, charade, answer

163,951 rows

charades_fts (hidden)

charade, answer, charades_fts, rank

63,745 rows

charades_fts_config (hidden)

k, v

1 row

charades_fts_data (hidden)

id, block

245 rows

charades_fts_docsize (hidden)

id, sz

63,745 rows

charades_fts_idx (hidden)

segid, term, pgno

242 rows

clues_fts (hidden)

clue, answer, clues_fts, rank

603,554 rows

clues_fts_config (hidden)

k, v

1 row

clues_fts_data (hidden)

id, block

5,881 rows

clues_fts_docsize (hidden)

id, sz

603,554 rows

clues_fts_idx (hidden)

segid, term, pgno

4,546 rows

indicators_by_clue (hidden)

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

65,078 rows

indicators_fts (hidden)

indicator, indicators_fts, rank

11,819 rows

indicators_fts_config (hidden)

k, v

1 row

indicators_fts_data (hidden)

id, block

30 rows

indicators_fts_docsize (hidden)

id, sz

11,819 rows

indicators_fts_idx (hidden)

segid, term, pgno

28 rows

Download SQLite DB: data.db 172.4 MB