people
2 rows where team = 21
This data as json, CSV (advanced)
Suggested facets: dob (date)
id ▲ | series | seat | name | dob | gender | hand | team | champion | TMI |
---|---|---|---|---|---|---|---|---|---|
53 | Series 10 10 | 1 | Daisy May Cooper | 1986-08-01 | F | R | Daisy and Richard 21 | ➚ | |
57 | Series 10 10 | 5 | Richard Herring | 1967-07-12 | M | R | Daisy and Richard 21 | ✓ | ➚ |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE people ( id INTEGER PRIMARY KEY, series INTEGER REFERENCES series(id), seat INTEGER, name TEXT, dob TEXT, gender TEXT, hand TEXT, team INTEGER REFERENCES teams(id), champion INTEGER, TMI INTEGER );