TdlM / taskmaster

Menu
  • Make shortlink

episode_scores

10 rows where contestant = 99

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: score, rank, srank

id ▲ episode contestant score rank series srank
642 The curse of politeness. 129 Ivo Graham 99 9 5 9 5
647 Trapped in a loveless marriage. 130 Ivo Graham 99 17 1 26 5
652 I love to squander promise. 131 Ivo Graham 99 21 1 47 3
657 How heavy is the water? 132 Ivo Graham 99 7 5 54 4
662 Old Honkfoot. 133 Ivo Graham 99 9 5 63 5
667 It's my milk now. 134 Ivo Graham 99 14 3 77 5
672 Schrödinger's egg. 135 Ivo Graham 99 14 4 91 5
677 100% Bosco. 136 Ivo Graham 99 12 5 103 5
682 A show about pedantry. 137 Ivo Graham 99 16 3 119 5
687 A yardstick for failure. 138 Ivo Graham 99 12 3 131 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 7.7ms