TdlM / taskmaster

Menu
  • Make shortlink

series_scores

5 rows where series = 13

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲ series contestant score rank
76 Series 13 13 Ardal O'Hanlon 78 153 4
77 Series 13 13 Bridget Christie 79 157 3
78 Series 13 13 Chris Ramsey 80 170 2
79 Series 13 13 Judi Love 81 142 5
80 Series 13 13 Sophie Duker 82 173 1

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE series_scores (
   id         INTEGER PRIMARY KEY,
   series     INTEGER REFERENCES series(id),
   contestant INTEGER REFERENCES people(id),
   score      INTEGER,
   rank       TEXT
);
Powered by Datasette · Queries took 5.944ms