home / parkruns

runs

4 rows where Event = "{"href": "https://www.parkrun.org.uk/southsea/", "label": "Southsea parkrun"}"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: PB, RunDate (date)

Longitude 1 ✖

  • -1.081316 4

Event 1 ✖

  • {"href": "https://www.parkrun.org.uk/southsea/", "label": "Southsea parkrun"} · 4 ✖
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

CSV options:

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
);
Powered by Datasette · Queries took 35.615ms