TdlM / taskmaster

Menu
  • Make shortlink

episode_scores

10 rows where contestant = 107

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: score, rank, srank

id ▲ episode contestant score rank series srank
695 The natural friends. 139 Susan Wokoma 107 14 3 14 3
700 Hell is here. 140 Susan Wokoma 107 19 1= 33 2=
705 Languidly. 141 Susan Wokoma 107 6 5 39 5
710 Dynamite chicks. 142 Susan Wokoma 107 11 5 50 5
715 Skateboard Division. 143 Susan Wokoma 107 13 3 63 5
720 Brother Alex. 144 Susan Wokoma 107 17 3= 80 5
725 I'm off to find a robin. 145 Susan Wokoma 107 12 4 92 5
730 Never packed a boot. 146 Susan Wokoma 107 17 1 109 3
735 Fagin at the disco. 147 Susan Wokoma 107 14 3 123 4
740 Always forks and marbles. 148 Susan Wokoma 107 16 2= 139 3

Advanced export

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

CSV options:

CREATE TABLE episode_scores (
   id         INTEGER PRIMARY KEY,
   episode    INTEGER REFERENCES episodes(id),
   contestant INTEGER REFERENCES people(id),
   score      INTEGER,
   rank       TEXT,
   series     INTEGER,
   srank      TEXT
);
Powered by Datasette · Queries took 244.957ms