runs
1 row where "RunDate" is on date 2017-06-10 sorted by RunNumber
This data as json, CSV (advanced)
Run | Event | RunDate | RunNumber ▼ | Pos | Time | AgeGrade | PB | Latitude | Longitude |
---|---|---|---|---|---|---|---|---|---|
21 | Fulham Palace parkrun | 2017-06-10 | 195 | 35 | 00:20:33 | 64.96 | 0 | 51.472465 | -0.218493 |
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 );