series_scores
5 rows where series = "-4"
This data as json, CSV (advanced)
id ▲ | series | contestant | score | rank |
---|---|---|---|---|
81 | CoC II -4 | Ed Gamble 83 | 11 | 5 |
82 | CoC II -4 | Kerry Godliman 84 | 12 | 3= |
83 | CoC II -4 | Liza Tarbuck 85 | 14 | 2 |
84 | CoC II -4 | Lou Sanders 86 | 12 | 3= |
85 | CoC II -4 | Richard Herring 87 | 17 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE series_scores ( id INTEGER PRIMARY KEY, series INTEGER REFERENCES series(id), contestant INTEGER REFERENCES people(id), score INTEGER, rank TEXT );