data

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

Custom SQL query

Tables

charades

rowid, charade, answer, clue_rowids

56,237 rows

clues

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

639,699 rows

indicators

rowid, wordplay, indicator, clue_rowids

15,249 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

123,781 rows

charades_fts (hidden)

charade, answer, charades_fts, rank

56,237 rows

charades_fts_config (hidden)

k, v

1 row

charades_fts_data (hidden)

id, block

218 rows

charades_fts_docsize (hidden)

id, sz

56,237 rows

charades_fts_idx (hidden)

segid, term, pgno

216 rows

clues_fts (hidden)

clue, answer, clues_fts, rank

639,699 rows

clues_fts_config (hidden)

k, v

1 row

clues_fts_data (hidden)

id, block

6,100 rows

clues_fts_docsize (hidden)

id, sz

639,699 rows

clues_fts_idx (hidden)

segid, term, pgno

4,397 rows

indicators_by_clue (hidden)

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

83,247 rows

indicators_fts (hidden)

indicator, indicators_fts, rank

15,249 rows

indicators_fts_config (hidden)

k, v

1 row

indicators_fts_data (hidden)

id, block

37 rows

indicators_fts_docsize (hidden)

id, sz

15,249 rows

indicators_fts_idx (hidden)

segid, term, pgno

35 rows

Download SQLite DB: data.db 181.4 MB