clues

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

2 rows where rowid in ["607962", "607964"] and source = "fifteensquared"

✎ View and edit SQL

This data as json, CSV (advanced)

source 1

  • fifteensquared · 2 ✖
rowid ▼ clue answer definition clue_number puzzle_date puzzle_name source_url source
607962 She’s a discerning foodie, and a friend in trouble (7) FRIANDE She’s a discerning foodie 21d 2022-01-02 Azed 2585 https://www.fifteensquared.net/2022/01/02/azed-2585/ fifteensquared
607964 Party thrown, dukedom’s ruined immediately (5, 2 words) EK DUM immediately 26d 2022-01-02 Azed 2585 https://www.fifteensquared.net/2022/01/02/azed-2585/ fifteensquared

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "clues" (
    rowid INTEGER PRIMARY KEY,
    clue TEXT,
    answer TEXT,
    definition TEXT,
    clue_number TEXT,
    puzzle_date TEXT,
    puzzle_name TEXT,
    source_url TEXT NOT NULL,
    source TEXT
);
CREATE INDEX clues_source_index ON clues ("source");