TdlM / taskmaster

Menu
  • Make shortlink

episode_scores

10 rows where contestant = 70

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: score, rank, srank

id ▲ episode contestant score rank series srank
478 An imbalance in the poppability. 96 Guz Khan 70 14 4 14 4
483 Oatmeal and death. 97 Guz Khan 70 20 1 34 1=
488 The end of the franchise. 98 Guz Khan 70 14 3= 48 3
493 The customised inhaler. 99 Guz Khan 70 14 4 62 4
498 Croissants is croissants. 100 Guz Khan 70 21 1 83 1
503 A chair in a sweet. 101 Guz Khan 70 19 1 102 1
508 The integrity of the product. 102 Guz Khan 70 8 5 110 2=
513 A couple of Ethels. 103 Guz Khan 70 21 1= 131 2=
518 Nothing matters. 104 Guz Khan 70 14 3 145 2
523 Caring Uncle Minpict. 105 Guz Khan 70 22 1 167 2

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