runs
1 row where "RunDate" is on date 2017-04-01
This data as json, CSV (advanced)
Run ▼ | Event | RunDate | RunNumber | Pos | Time | AgeGrade | PB | Latitude | Longitude |
---|---|---|---|---|---|---|---|---|---|
15 | Tooting Common parkrun | 2017-04-01 | 62 | 117 | 00:22:41 | 58.85 | 0 | 51.433342 | -0.14677 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [runs] ( [Run] INTEGER PRIMARY KEY, [Event] TEXT, [RunDate] TEXT, [RunNumber] TEXT, [Pos] INTEGER, [Time] TEXT, [AgeGrade] TEXT, [PB] INTEGER, [Latitude] FLOAT, [Longitude] FLOAT );