people
2 rows where team = 1
This data as json, CSV (advanced)
Suggested facets: dob (date)
id ▲ | series | seat | name | dob | gender | hand | team | champion | TMI |
---|---|---|---|---|---|---|---|---|---|
3 | Series 1 1 | 1 | Frank Skinner | 1957-01-28 | M | R | Frank and Tim 1 | ➚ | |
7 | Series 1 1 | 5 | Tim Key | 1976-09-02 | M | R | Frank and Tim 1 | ➚ |
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 );