TdlM / taskmaster

Menu
  • Make shortlink

episode_scores

8 rows where contestant = 26

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: score, rank, srank

id ▲ episode contestant score rank series srank
124 Dignity intact. 25 Nish Kumar 26 13 4= 13 4=
129 The leprechaun or the lesbian. 26 Nish Kumar 26 19 2= 32 4
134 Phoenix. 27 Nish Kumar 26 12 5 44 4
139 Residue around the hoof. 28 Nish Kumar 26 12 5 56 5
144 A wind-dried puffin. 29 Nish Kumar 26 13 5 69 5
149 Spoony Neeson. 30 Nish Kumar 26 12 5 81 5
154 Boing boing. 31 Nish Kumar 26 12 5 93 5
159 Their water's so delicious. 32 Nish Kumar 26 14 3 107 5

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 8.004ms