runs

1 row where Event = "{"href": "https://www.parkrun.org.uk/brockwell/", "label": "Brockwell parkrun, Herne Hill"}"

✎ View and edit SQL

This data as json, CSV (advanced)

RunDate (date) 1 ✖

Longitude 1 ✖

Event 1 ✖

  • {"href": "https://www.parkrun.org.uk/brockwell/", "label": "Brockwell parkrun, Herne Hill"} · 1 ✖
Run ▼ Event RunDate RunNumber Pos Time AgeGrade PB Latitude Longitude
4 Brockwell parkrun, Herne Hill 2016-08-13 287 14 00:20:03 66.17 1 51.452538 -0.105464

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
);