TdlM / taskmaster

Menu
  • Make shortlink

episode_scores

10 rows where contestant = 102

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: score, rank, srank

id ▲ episode contestant score rank series srank
645 The curse of politeness. 129 Mae Martin 102 19 1 19 1
650 Trapped in a loveless marriage. 130 Mae Martin 102 16 2= 35 1
655 I love to squander promise. 131 Mae Martin 102 14 4 49 2
660 How heavy is the water? 132 Mae Martin 102 10 4 59 2
665 Old Honkfoot. 133 Mae Martin 102 28 1 87 2
670 It's my milk now. 134 Mae Martin 102 21 1 108 1
675 Schrödinger's egg. 135 Mae Martin 102 15 3 123 1
680 100% Bosco. 136 Mae Martin 102 18 2 141 1
685 A show about pedantry. 137 Mae Martin 102 15 4 156 1
690 A yardstick for failure. 138 Mae Martin 102 18 1= 174 1

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.329ms