runs
4 rows where Event = "{"href": "https://www.parkrun.org.uk/southsea/", "label": "Southsea parkrun"}"
This data as json, CSV (advanced)
Suggested facets: PB, RunDate (date)
Run ▼ | Event | RunDate | RunNumber | Pos | Time | AgeGrade | PB | Latitude | Longitude |
---|---|---|---|---|---|---|---|---|---|
9 | Southsea parkrun | 2016-11-05 | 161 | 29 | 00:19:56 | 66.97 | 1 | 50.778853 | -1.081316 |
52 | Southsea parkrun | 2019-05-18 | 297 | 21 | 00:19:25 | 69.79 | 1 | 50.778853 | -1.081316 |
76 | Southsea parkrun | 2023-05-27 | 435 | 12 | 00:18:36 | 75.09 | 1 | 50.778853 | -1.081316 |
83 | Southsea parkrun | 2023-10-14 | 455 | 5 | 00:18:45 | 75.02 | 0 | 50.778853 | -1.081316 |
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 );