people
2 rows where team = 15
This data as json, CSV (advanced)
Suggested facets: dob (date)
id ▲ | series | seat | name | dob | gender | hand | team | champion | TMI |
---|---|---|---|---|---|---|---|---|---|
44 | Series 8 8 | 2 | Joe Thomas | 1983-10-28 | M | R | Joe and Sian 15 | ➚ | |
47 | Series 8 8 | 5 | Sian Gibson | 1976-07-30 | F | R | Joe and Sian 15 | ➚ |
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 );