home / parkruns

runs

2 rows where Longitude = "-0.053151"

✎ View and edit SQL

This data as json, CSV (advanced)

RunDate (date) 2 ✖

  • 2018-06-02 1
  • 2021-07-31 1

Longitude 1 ✖

  • -0.053151 · 2 ✖

Event 1 ✖

  • {"href": "https://www.parkrun.org.uk/southwark/", "label": "Southwark parkrun"} 2
Run ▼ Event RunDate RunNumber Pos Time AgeGrade PB Latitude Longitude
36 Southwark parkrun 2018-06-02 239 24 00:19:56 67.47 1 51.494242 -0.053151
58 Southwark parkrun 2021-07-31 334 81 00:21:44 63.27 0 51.494242 -0.053151

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 27.217ms