TdlM / taskmaster

Menu
  • Make shortlink

episode_scores

10 rows where contestant = 92

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: score, rank, srank

id ▲ episode contestant score rank series srank
590 The chassis, the wings. 118 Sarah Millican 92 18 1 18 1
595 Enormous hugeness. 119 Sarah Millican 92 16 3 34 3
600 Dafty in the middle. 120 Sarah Millican 92 17 2= 51 2
605 Crumbs in my bralette. 121 Sarah Millican 92 22 1 73 2
610 Chip Biffington. 122 Sarah Millican 92 17 5 90 2
615 Long-legged lobster. 123 Sarah Millican 92 19 1 109 2
620 The system of endless plates. 124 Sarah Millican 92 15 4 124 2
625 The one that bats do. 125 Sarah Millican 92 17 2 141 2
630 A new business end. 126 Sarah Millican 92 18 4 159 2
635 Did I meet these potatoes before? 127 Sarah Millican 92 15 3 174 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 9.362ms