series_scores

5 rows where series = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: score, rank

id ▲ series contestant score rank
1 Series 1 1 Frank Skinner 3 93 2=
2 Series 1 1 Josh Widdicombe 4 94 1
3 Series 1 1 Roisin Conaty 5 68 5
4 Series 1 1 Romesh Ranganathan 6 93 2=
5 Series 1 1 Tim Key 7 88 4

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
);