home / parkruns

runs

1 row where "RunDate" is on date 2017-06-10 sorted by Latitude

✎ View and edit SQL

This data as json, CSV (advanced)

RunDate (date) 1 ✖

  • 2017-06-10 · 1 ✖
Run Event RunDate RunNumber Pos Time AgeGrade PB Latitude ▼ Longitude
21 Fulham Palace parkrun 2017-06-10 195 35 00:20:33 64.96 0 51.472465 -0.218493

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