data

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

Custom SQL query

Tables

charades

rowid, charade, answer, clue_rowids

56,527 rows

clues

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

648,078 rows

indicators

rowid, wordplay, indicator, clue_rowids

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

124,618 rows

charades_fts (hidden)

charade, answer, charades_fts, rank

56,527 rows

charades_fts_config (hidden)

k, v

1 row

charades_fts_data (hidden)

id, block

220 rows

charades_fts_docsize (hidden)

id, sz

56,527 rows

charades_fts_idx (hidden)

segid, term, pgno

218 rows

clues_fts (hidden)

clue, answer, clues_fts, rank

648,078 rows

clues_fts_config (hidden)

k, v

1 row

clues_fts_data (hidden)

id, block

6,200 rows

clues_fts_docsize (hidden)

id, sz

648,078 rows

clues_fts_idx (hidden)

segid, term, pgno

4,499 rows

indicators_by_clue (hidden)

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

85,236 rows

indicators_fts (hidden)

indicator, indicators_fts, rank

15,470 rows

indicators_fts_config (hidden)

k, v

1 row

indicators_fts_data (hidden)

id, block

37 rows

indicators_fts_docsize (hidden)

id, sz

15,470 rows

indicators_fts_idx (hidden)

segid, term, pgno

35 rows

Download SQLite DB: data.db 183.7 MB