runs
14 rows where Event = "{"href": "https://www.parkrun.org.uk/claphamcommon/", "label": "Clapham Common parkrun"}"
This data as json, CSV (advanced)
Suggested facets: Time, PB, RunDate (date)
| Run ▼ | Event | RunDate | RunNumber | Pos | Time | AgeGrade | PB | Latitude | Longitude |
|---|---|---|---|---|---|---|---|---|---|
| 41 | Clapham Common parkrun | 2018-11-03 | 27 | 95 | 00:21:01 | 64.47 | 1 | 51.455873 | -0.151331 |
| 42 | Clapham Common parkrun | 2018-11-17 | 29 | 98 | 00:22:09 | 61.17 | 0 | 51.455873 | -0.151331 |
| 46 | Clapham Common parkrun | 2019-02-16 | 41 | 128 | 00:22:10 | 61.13 | 0 | 51.455873 | -0.151331 |
| 49 | Clapham Common parkrun | 2019-03-23 | 46 | 133 | 00:21:55 | 61.83 | 0 | 51.455873 | -0.151331 |
| 50 | Clapham Common parkrun | 2019-04-06 | 48 | 78 | 00:20:22 | 66.53 | 1 | 51.455873 | -0.151331 |
| 51 | Clapham Common parkrun | 2019-05-11 | 53 | 86 | 00:21:09 | 64.07 | 0 | 51.455873 | -0.151331 |
| 53 | Clapham Common parkrun | 2019-09-14 | 69 | 107 | 00:21:44 | 62.81 | 0 | 51.455873 | -0.151331 |
| 55 | Clapham Common parkrun | 2019-11-30 | 78 | 61 | 00:21:04 | 64.79 | 0 | 51.455873 | -0.151331 |
| 59 | Clapham Common parkrun | 2021-11-13 | 106 | 125 | 00:22:29 | 61.60 | 0 | 51.455873 | -0.151331 |
| 60 | Clapham Common parkrun | 2021-11-27 | 108 | 60 | 00:21:09 | 65.48 | 0 | 51.455873 | -0.151331 |
| 61 | Clapham Common parkrun | 2021-12-11 | 110 | 91 | 00:22:01 | 62.91 | 0 | 51.455873 | -0.151331 |
| 62 | Clapham Common parkrun | 2021-12-18 | 111 | 50 | 00:20:51 | 66.43 | 0 | 51.455873 | -0.151331 |
| 63 | Clapham Common parkrun | 2022-06-25 | 133 | 143 | 00:23:02 | 60.13 | 0 | 51.455873 | -0.151331 |
| 64 | Clapham Common parkrun | 2022-09-17 | 144 | 103 | 00:21:40 | 64.46 | 0 | 51.455873 | -0.151331 |
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 );