clues
Data license: Open Database License (ODbL) v1.0 · About: Datasheet
101,240 rows where source = "times_xwd_times" sorted by clue_number descending
This data as json, CSV (advanced)
source 1
- times_xwd_times · 101,040 ✖
rowid | clue | answer | definition | clue_number ▲ | puzzle_date | puzzle_name | source_url | source |
---|---|---|---|---|---|---|---|---|
45787 | BLUE - NIL [nothing] + {pal}E + BLUE [gloomy] | NILEa | 2018-06-02 | Times Cryptic Jumbo No 1324 | https://times-xwd-times.livejournal.com/1954265.html | times_xwd_times | ||
28545 | TO NOTHING: NEXT TO [not far removed] then H [husband] in NOTING [observing]. | NEXTa | 2017-04-01 | Times Saturday 26682 | https://times-xwd-times.livejournal.com/1713172.html | times_xwd_times | ||
39340 | - NAST{y} ["mostly" mean] + A L IQ [a | large | measure of intelligence] | P | NASTALIQd | 2018-02-01 | Monthly Club Special 20,208 | https://times-xwd-times.livejournal.com/1887836.html | times_xwd_times | |
54582 | - If SIGH is "short sight", then it is the thing that is the matter with a MYOPIC viewer. I wish this had clued "short sight" rather than a word that needs to be convolutedly derived from a cryptic depiction of short sight :P | MYOPICa | 2019-07-25 | Times 27,413 | https://times-xwd-times.livejournal.com/2178641.html | times_xwd_times | ||
28542 | DEER: M{o}R{e} around USK and DEE [rivers in Wales (or Scotland, dare I add)] | MUSKa | 2017-04-01 | Times Saturday 26682 | https://times-xwd-times.livejournal.com/1713172.html | times_xwd_times | ||
36867 | MO [flash] ER [queen] in NASTY [vile]. | MONASTERYa | 2017-03-25 | Times Saturday 26676 | https://times-xwd-times.livejournal.com/1708591.html | times_xwd_times | ||
55633 | “mods” as opposed to “rockers”, if you remember the sixties. (They do say that those who remember weren’t there!) M.O.D. being the Ministry of Defence. | MODa | 2018-04-28 | Times Cryptic No 27018 | https://times-xwd-times.livejournal.com/1932820.html | times_xwd_times | ||
2479 | - (MEETING NOT*) ["for reorganising"] | MIGNONETTEa | 2018-04-06 | Times 27,005 | https://times-xwd-times.livejournal.com/1920959.html | times_xwd_times | ||
35573 | MET[ropolitan Police] from London, R[oyal] I[rish] C[onstabulary] from Dublin once. Metric units – metres, kilograms etc. | METRICa | 2018-09-22 | Times Cryptic No 27144 | https://times-xwd-times.livejournal.com/2011597.html | times_xwd_times | ||
34374 | T in MERE. | METREa | 2019-04-13 | Times Cryptic No 27318 | https://times-xwd-times.livejournal.com/2122406.html | times_xwd_times | ||
39933 | UP - MESS [place to eat] + UP, as in up in the air, as in maybe on a plane. | MESSa | 2018-06-15 | Times Cryptic No 27,065 | https://times-xwd-times.livejournal.com/1958785.html | times_xwd_times | ||
34081 | or, MA’S TIC. Apparently mastic can be used as a glue. | MASTICa | 2019-03-30 | Times Cryptic No 27306 | https://times-xwd-times.livejournal.com/2113746.html | times_xwd_times | ||
26312 | My last in' fooled into thinking of haircuts. Thick hair is MANE and the current dog is I (symbol for electric current) and CUR | MANICUREa | 2021-01-14 | 27874 | https://times-xwd-times.livejournal.com/2472343.html | times_xwd_times | ||
28631 | NO ODDS - a bookmaker makes odds for a betting customer; or in this case doesn't. | MAKEa | 2016-10-28 | Times 26,555 | https://times-xwd-times.livejournal.com/1619474.html | times_xwd_times | ||
43083 | COURSE - a double def of a sort. A salt being a sailor, the main being the sea: if you squint you can just about see how a "salt" would always stick to a "course" across the "main". | MAINa | 2019-05-16 | Times 27,353 | https://times-xwd-times.livejournal.com/2141043.html | times_xwd_times | ||
21467 | - MAG NET O [glossy, potentially; clear; O{intment}] | MAGNETa | 2018-07-13 | Times 27,089 | https://times-xwd-times.livejournal.com/1974160.html | times_xwd_times | ||
26311 | Raincoat MAC (what else) and fighting man therein GI | MAGICa | 2021-01-14 | 27874 | https://times-xwd-times.livejournal.com/2472343.html | times_xwd_times | ||
2477 | - AN NOD AM [an | agreement | earlier in the day] reversed | MADONNAa | 2018-04-06 | Times 27,005 | https://times-xwd-times.livejournal.com/1920959.html | times_xwd_times | ||
18914 | BUTTERFLY - MAD [out to lunch] + (MET BY TEARFUL*) ["unexpectedly"]. | M | MADAMEa | 2019-07-04 | Times 27,395 | https://times-xwd-times.livejournal.com/2167580.html | times_xwd_times | |
37913 | clue. Navel gazing indeed! I could see only one possible answer, but only saw how it worked after I peeled the “IT” off and looked at the rest. | Lovelya | 2017-04-29 | Times Saturday 26706 | https://times-xwd-times.livejournal.com/1730137.html | times_xwd_times | ||
51583 | - OP + SIDE in LD (lord) | LOPSIDEDa | 2018-01-08 | Times 26929 | https://times-xwd-times.livejournal.com/1874457.html | times_xwd_times | ||
39924 | - K [king] on LOO [throne] | LOOKa | 2018-06-15 | Times Cryptic No 27,065 | https://times-xwd-times.livejournal.com/1958785.html | times_xwd_times | ||
18911 | - L IKE MINDED [Liberal | President (Eisenhower) | tended] | LIKE-MINDEDa | 2019-07-04 | Times 27,395 | https://times-xwd-times.livejournal.com/2167580.html | times_xwd_times | ||
58804 | STRIKE - double definition or as near as dammit | LIGHTNINGa | 2018-08-06 | Times 27109 | https://times-xwd-times.livejournal.com/1986608.html | times_xwd_times | ||
5072 | BACK: double definition, the first facetious. | LIEa | 2018-07-28 | Times Cryptic No 27096 | https://times-xwd-times.livejournal.com/1981841.html | times_xwd_times | ||
2474 | RIP - sounds like "LET'S RIP", which could be an invitation to copy software or what have you | LETSa | 2018-04-06 | Times 27,005 | https://times-xwd-times.livejournal.com/1920959.html | times_xwd_times | ||
35574 | reverse (“retrospective”) hidden answer (“in part”). | LETITIAa | 2018-09-22 | Times Cryptic No 27144 | https://times-xwd-times.livejournal.com/2011597.html | times_xwd_times | ||
36868 | TENDER: LEG [“on” at cricket] then END [tip] in ALTER [reform]. | LEGALa | 2017-03-25 | Times Saturday 26676 | https://times-xwd-times.livejournal.com/1708591.html | times_xwd_times | ||
57350 | - {s}LAYER'S "headless". LOI: spent way too long wondering if there might have been a murderous individual called RAVENS at any point. | LAYERSa | 2020-04-09 | Times 27,635 | https://times-xwd-times.livejournal.com/2319188.html | times_xwd_times | ||
51586 | - ON RAVEL G* (good) | LAVENGROa | 2018-01-08 | Times 26929 | https://times-xwd-times.livejournal.com/1874457.html | times_xwd_times | ||
28544 | (PLAY ROMEO N{eglecting}*) | LAMPOONERYa | 2017-04-01 | Times Saturday 26682 | https://times-xwd-times.livejournal.com/1713172.html | times_xwd_times | ||
34078 | this made me laugh. A den might be a lair, so if DENNY means “like a den”, LAIRY can do likewise. I suspected “lairy” might be an Aussie word, and Chambers agrees, but here it is! | LAIRYa | 2019-03-30 | Times Cryptic No 27306 | https://times-xwd-times.livejournal.com/2113746.html | times_xwd_times | ||
28908 | - ALE WK [beer | week], the whole "recalled" | KWELAa | 2018-05-01 | Monthly Club Special 20,211 | https://times-xwd-times.livejournal.com/1935023.html | times_xwd_times | ||
51580 | - KINK + A + JO + U[ncovered] | KINKAJOUa | 2018-01-08 | Times 26929 | https://times-xwd-times.livejournal.com/1874457.html | times_xwd_times | ||
28529 | KEEN [lament] NES [= SEN reversed] S{showing}. | KEENNESSa | 2017-04-01 | Times Saturday 26682 | https://times-xwd-times.livejournal.com/1713172.html | times_xwd_times | ||
28905 | - ({w}ORK HAS*) ["ruined"] + I [one], semi-&lit | KAROSHIa | 2018-05-01 | Monthly Club Special 20,211 | https://times-xwd-times.livejournal.com/1935023.html | times_xwd_times | ||
36874 | JUNK [ship] ET [the canonical alien]. | JUNKETa | 2017-03-25 | Times Saturday 26676 | https://times-xwd-times.livejournal.com/1708591.html | times_xwd_times | ||
28630 | - RIDER [addition], needing JOY [transport] first | JOYRIDERa | 2016-10-28 | Times 26,555 | https://times-xwd-times.livejournal.com/1619474.html | times_xwd_times | ||
28634 | - homophone of JACK [sailor "in speech"] + 0 BITE [zero | effect] | JACOBITEa | 2016-10-28 | Times 26,555 | https://times-xwd-times.livejournal.com/1619474.html | times_xwd_times | ||
34075 | took a lot of time looking at C---T- to come up with COMITY as an option, and more time to decide whether I knew what the word actually meant. | Ita | 2019-03-30 | Times Cryptic No 27306 | https://times-xwd-times.livejournal.com/2113746.html | times_xwd_times | ||
64170 | the Philippines they have lovely screens to protect you from the glare. | I | Ind | 2018-05-05 | Times Cryptic No 27024 | https://times-xwd-times.livejournal.com/1936726.html | times_xwd_times | |
39321 | Dickens' Tale of Two Cities, a tricoteuse who, Fate-like, encodes in her knitting the names of people to be killed. | Ina | 2018-02-01 | Monthly Club Special 20,208 | https://times-xwd-times.livejournal.com/1887836.html | times_xwd_times | ||
10891 | there's one thing that I like | I | Ifa | 2019-06-08 | Times Cryptic No 27366 | https://times-xwd-times.livejournal.com/2153206.html | times_xwd_times | |
21459 | you didn't know the second definition, as I didn't, it's "a disc or wheel mounted eccentrically on a revolving shaft in order to transform rotation into backward-and-forward motion, e.g. a cam in an internal combustion engine". | Ifa | 2018-07-13 | Times 27,089 | https://times-xwd-times.livejournal.com/1974160.html | times_xwd_times | ||
5070 | do like to be beside the sea! | I | Ia | 2018-07-28 | Times Cryptic No 27096 | https://times-xwd-times.livejournal.com/1981841.html | times_xwd_times | |
11037 | had great trouble with this clue! On my first pass I confidently wrote in TRAPPED = T[ape] + RAPPED, meaning “caught”. Then 19dn had an “I”, not an “A”. Oh well … I suppose TRIPPED works pretty much equally well! Only when I decided 3dn couldn’t possibly end “I-P” did I realise the definition must be “caught on”! Well done, setter. | Ia | 2018-11-24 | Times Cryptic No 27198 | https://times-xwd-times.livejournal.com/2045072.html | times_xwd_times | ||
28618 | don't know about you but this put me in mind of an Agatha Christie plotline - And Then There Were None | Ia | 2016-10-28 | Times 26,555 | https://times-xwd-times.livejournal.com/1619474.html | times_xwd_times | ||
34370 | struggled for some time trying to think of a three-letter word for “Ice Age”! The key is to realise you need to separate “Ice” and “Age”. | S | Ia | 2019-04-13 | Times Cryptic No 27318 | https://times-xwd-times.livejournal.com/2122406.html | times_xwd_times | |
57356 | PURITANI - PUN about RITA in I and I. A work by Bellini, which I'm pretty sure has come up at least once before. | Ia | 2020-04-09 | Times 27,635 | https://times-xwd-times.livejournal.com/2319188.html | times_xwd_times | ||
20649 | - IX [nine] to I ON [one | on]. Better known for being bound to a fiery wheel for eternity than for being any kind of wise and just monarch to the Lapiths. | IXIONa | 2017-04-21 | TLS Crossword 1169 | https://times-xwd-times.livejournal.com/1724989.html | times_xwd_times | ||
55629 | LIT (reading) inside (engrossed in) (EASIER*). (Thanks, Kevin, for pointing out what I'd missed: LIT., short for "literature", could be a reading.) I'm not sure all Israelites are Hebrews! | Hebrew | ISRAELITEa | 2018-04-28 | Times Cryptic No 27018 | https://times-xwd-times.livejournal.com/1932820.html | times_xwd_times | |
35624 | O=old QUO=word often linked with status(!), all “in” IRIS=the girl of the moment. | T | IROQUOISd | 2017-04-08 | Times Saturday 26688 | https://times-xwd-times.livejournal.com/1717260.html | times_xwd_times | |
34082 | IN=batting, SI=IS “over”, ST=stumped. A double helping of cricket! | INSISTa | 2019-03-30 | Times Cryptic No 27306 | https://times-xwd-times.livejournal.com/2113746.html | times_xwd_times | ||
20646 | - Meursault being Camus's Outsider. | INSIDERa | 2017-04-21 | TLS Crossword 1169 | https://times-xwd-times.livejournal.com/1724989.html | times_xwd_times | ||
5073 | IN (hip), HALER (more robust). A pedant might object that it expands the bronchi, not the chest, but near enough. | INHALERa | 2018-07-28 | Times Cryptic No 27096 | https://times-xwd-times.livejournal.com/1981841.html | times_xwd_times | ||
28536 | IN ELI (BILGE*). | D | INELIGIBLEa | 2017-04-01 | Times Saturday 26682 | https://times-xwd-times.livejournal.com/1713172.html | times_xwd_times | |
21468 | - I'M BRO [sibling's declaration] + GI [soldier] (with) L [left] inside + O{fficers} | IMBROGLIOa | 2018-07-13 | Times 27,089 | https://times-xwd-times.livejournal.com/1974160.html | times_xwd_times | ||
21465 | - I with MAM [one; mother in Newcastle, perhaps] | IMAMa | 2018-07-13 | Times 27,089 | https://times-xwd-times.livejournal.com/1974160.html | times_xwd_times | ||
28636 | - L [large] "filling" ID EST [that is] | IDLESTa | 2016-10-28 | Times 26,555 | https://times-xwd-times.livejournal.com/1619474.html | times_xwd_times | ||
35610 | IN “holding” CO. | ICONa | 2017-04-08 | Times Saturday 26688 | https://times-xwd-times.livejournal.com/1717260.html | times_xwd_times | ||
2473 | this clue didn't remind anyone else of the epoch-shatteringly bad Bennifer movie... | Hopea | 2018-04-06 | Times 27,005 | https://times-xwd-times.livejournal.com/1920959.html | times_xwd_times | ||
54576 | to construct this unknown name from the cryptic, but it seems like a fair clue... given that he penned the script for a movie everyone's heard of, King Kong! | Hada | 2019-07-25 | Times 27,413 | https://times-xwd-times.livejournal.com/2178641.html | times_xwd_times | ||
18905 | - HUB [activity centre] at/before BY [times] | DOWN | HUBBYa | 2019-07-04 | Times 27,395 | https://times-xwd-times.livejournal.com/2167580.html | times_xwd_times | |
11217 | - (O THE S S S) ["played"]. Mistress Quickly from the same Shakespeare plays in which you'll find Falstaff. | HOSTESSa | 2019-11-21 | Times 27,515 | https://times-xwd-times.livejournal.com/2243399.html | times_xwd_times | ||
8589 | IT: PI [the mathematical constant] “punctures” HOT. | D | HOPa | 2017-04-22 | Times Saturday 26700 | https://times-xwd-times.livejournal.com/1725548.html | times_xwd_times | |
21462 | for governor or ambassador comes up in crosswords an awful lot, and is short for His/Her Excellency. | HEa | 2018-07-13 | Times 27,089 | https://times-xwd-times.livejournal.com/1974160.html | times_xwd_times | ||
26313 | Ambassadors to the court of crossword are HE (His/er Excellency) and say is EG, the two surrounding DIN for noise | HEEDINGa | 2021-01-14 | 27874 | https://times-xwd-times.livejournal.com/2472343.html | times_xwd_times | ||
51591 | - HEAT (passion) + HER (a woman) + Y (unknown); Erica may be heather to some, but to me she | HEATHERYa | 2018-01-08 | Times 26929 | https://times-xwd-times.livejournal.com/1874457.html | times_xwd_times | ||
39934 | - (THE E{nglish} LADY*) ["trembling"] | DOWN | HEATEDLYa | 2018-06-15 | Times Cryptic No 27,065 | https://times-xwd-times.livejournal.com/1958785.html | times_xwd_times | |
45789 | - R [right], covered in HEAT BEAT [warm | batter] | HEARTBEATa | 2018-06-02 | Times Cryptic Jumbo No 1324 | https://times-xwd-times.livejournal.com/1954265.html | times_xwd_times | ||
50984 | - No GEN on HALOGEN [information; fluorine, perhaps] | HALOa | 2018-07-06 | Times Cryptic 27,083 | https://times-xwd-times.livejournal.com/1970809.html | times_xwd_times | ||
13559 | Greene surely must be the author to have made most appearances in cryptics due to his helpful letters. Are there any other contenders? | Grahama | 2018-05-18 | Times 27,041 | https://times-xwd-times.livejournal.com/1943595.html | times_xwd_times | ||
45788 | - G UTTER [good | say] to be beside SNIPE [fire (gun from distance)] | GUTTERSNIPEa | 2018-06-02 | Times Cryptic Jumbo No 1324 | https://times-xwd-times.livejournal.com/1954265.html | times_xwd_times | ||
63046 | BEER: from BEST GEAR. | D | GUESTa | 2018-10-20 | Times Cryptic No 27168 | https://times-xwd-times.livejournal.com/2026252.html | times_xwd_times | |
63040 | MP “tucked into” GRUY[ere]. | GRUMPYa | 2018-10-20 | Times Cryptic No 27168 | https://times-xwd-times.livejournal.com/2026252.html | times_xwd_times | ||
54580 | - a cryptic definition for this presumably gregarious fish | GROUPERa | 2019-07-25 | Times 27,413 | https://times-xwd-times.livejournal.com/2178641.html | times_xwd_times | ||
11222 | - GRIM [threatening] + AL{ad}DI{n}. Joseph Grimaldi of Victorian times. | GRIMALDIa | 2019-11-21 | Times 27,515 | https://times-xwd-times.livejournal.com/2243399.html | times_xwd_times | ||
28619 | - G RIDDLE [grand | poser] | GRIDDLEa | 2016-10-28 | Times 26,555 | https://times-xwd-times.livejournal.com/1619474.html | times_xwd_times | ||
39352 | - GO [board game] + LP [one played for longer] | A | GOLPd | 2018-02-01 | Monthly Club Special 20,208 | https://times-xwd-times.livejournal.com/1887836.html | times_xwd_times | |
13544 | A [area] at end of GO [journey] | GOAa | 2018-05-18 | Times 27,041 | https://times-xwd-times.livejournal.com/1943595.html | times_xwd_times | ||
35607 | GI=soldier, MM=2 x masses, ICKY=revolting. No, not an anagram of masses! | GIMMICKYa | 2017-04-08 | Times Saturday 26688 | https://times-xwd-times.livejournal.com/1717260.html | times_xwd_times | ||
5077 | ACROSS: GET CROSS (“fume”), around A (“article”). | D | GETa | 2018-07-28 | Times Cryptic No 27096 | https://times-xwd-times.livejournal.com/1981841.html | times_xwd_times | |
26308 | Tempe’s vale next ancient Peneus came, | T | Froma | 2021-01-14 | 27874 | https://times-xwd-times.livejournal.com/2472343.html | times_xwd_times | |
58004 | knowledge gap: Dido and Aeneas is an opera in a prologue and three acts, written by the English Baroque composer Henry Purcell with a libretto by Nahum Tate. | Fourthd | 2018-08-25 | Times Cryptic No 27120 | https://times-xwd-times.livejournal.com/1996676.html | times_xwd_times | ||
57988 | knowledge gap: apparently, in British and Irish tradition, the quarter days were the four dates in each year on which servants were hired, school terms started, and rents were due. They fell on four religious festivals roughly three months apart and close to the two solstices and two equinoxes. | Firsta | 2018-08-25 | Times Cryptic No 27120 | https://times-xwd-times.livejournal.com/1996676.html | times_xwd_times | ||
13563 | F [loud] with UNCTION [obsequiousness] meeting A-LIST [bunch of celebs]. | H | FUNCTIONALISTa | 2018-05-18 | Times 27,041 | https://times-xwd-times.livejournal.com/1943595.html | times_xwd_times | |
39346 | - FRIES IS H [junk food | is | hard] | O | FRIESISHd | 2018-02-01 | Monthly Club Special 20,208 | https://times-xwd-times.livejournal.com/1887836.html | times_xwd_times | |
39927 | - FRET about SHE [worry; woman]. "The flood of a river from heavy rain or melted snow." I know it was something watery but probably would have guessed at a babbling brook or suchlike. | flood | FRESHETa | 2018-06-15 | Times Cryptic No 27,065 | https://times-xwd-times.livejournal.com/1958785.html | times_xwd_times | |
57357 | ENTERPRISE - (PEERS INTERFERE*) | DOWN | FREEa | 2020-04-09 | Times 27,635 | https://times-xwd-times.livejournal.com/2319188.html | times_xwd_times | |
57352 | - FOX {producin}G LOVE. A foxglove is the source of the drug digitalis. | FOXGLOVEa | 2020-04-09 | Times 27,635 | https://times-xwd-times.livejournal.com/2319188.html | times_xwd_times | ||
5074 | MILL: FLOUR sounds like “flower”, as in “the flower of English womanhood”. The philosopher is John Stuart MILL. | FLOURa | 2018-07-28 | Times Cryptic No 27096 | https://times-xwd-times.livejournal.com/1981841.html | times_xwd_times | ||
58811 | - a flat, as well as a sharp, a natural, a double sharp, a dou (that's enough, ed), may be found on a clef | DOWN | FLATa | 2018-08-06 | Times 27109 | https://times-xwd-times.livejournal.com/1986608.html | times_xwd_times | |
11415 | FIX = difficulty, ATE = worried. | FIXATEa | 2018-03-24 | Times Cryptic No 26988 | https://times-xwd-times.livejournal.com/1914094.html | times_xwd_times | ||
55639 | FIELD (retrieve a ball for example), FARE (food). Another frustrating clue. Unless you know the bird, which I didn’t, it’s a matter of guessing between FARE, CAKE, PÂTÉ, BAKE or whatever else comes to mind as food. None of them sounded like a bird to me! | D | bird | FIELDFAREa | 2018-04-28 | Times Cryptic No 27018 | https://times-xwd-times.livejournal.com/1932820.html | times_xwd_times |
63039 | FASCI[st] / A. | FASCIAa | 2018-10-20 | Times Cryptic No 27168 | https://times-xwd-times.livejournal.com/2026252.html | times_xwd_times | ||
39930 | GODMOTHER - (GOOD FAITH + MERRY*) ["fooling around"]. Charming not as in pleasant, but as in casting magic spells. | FAIRYa | 2018-06-15 | Times Cryptic No 27,065 | https://times-xwd-times.livejournal.com/1958785.html | times_xwd_times | ||
41785 | - FACT I ON [truth | I | attached to] | FACTIONa | 2017-04-14 | Times 26,699 | https://times-xwd-times.livejournal.com/1720827.html | times_xwd_times | ||
39316 | cuerpo" seems to be Spanish for "out of formal dress", or "without a coat" and apparently if you're English you can spell this almost any way you like. | Ena | 2018-02-01 | Monthly Club Special 20,208 | https://times-xwd-times.livejournal.com/1887836.html | times_xwd_times | ||
50029 | Thanks to guy_du_sable for telling me there is no apostrophe in the actual title. Joyce wanted it to also be an imperative, with an invisible comma and exclamation point: "Finnegans, Wake!") | D | Edita | 2018-06-23 | Times Cryptic No 27066 | https://times-xwd-times.livejournal.com/1962802.html | times_xwd_times | |
39328 | - EH A{n}G{r}Y [what? | "regularly" angry] "hosts" OP [work] on X [by] | E | EXOPHAGYa | 2018-02-01 | Monthly Club Special 20,208 | https://times-xwd-times.livejournal.com/1887836.html | times_xwd_times |
Advanced export
JSON shape: default, array, newline-delimited, object
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");