people
2 rows where team = 5
This data as json, CSV (advanced)
Suggested facets: dob (date)
id ▲ | series | seat | name | dob | gender | hand | team | champion | TMI |
---|---|---|---|---|---|---|---|---|---|
16 | Series 3 3 | 4 | Rob Beckett | 1986-01-02 | M | R | Rob and Sara 5 | ✓ | ➚ |
17 | Series 3 3 | 5 | Sara Pascoe | 1981-05-22 | F | R | Rob and Sara 5 | ➚ |
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 );