Historical data

Here you can find monthly anonymised trip data from Just Eat Cycles. Are you doing anything cool with this data? Let us know!

Trip data

February 2019
Updated daily
January 2019
December 2018
November 2018
October 2018
September 2018

Ideas to get you started

🚌 Compare the speed of cycling to other forms of public transport
🚲 Visualise the most popular cycling routes in Edinburgh
⚡️ Map out the "rush hour" of different stations
📈 Make a neat infographic based on these numbers

Documentation

Licence

The data is published under the Open Government Licence (OGL) v3.0

Data selection

The data include trips with a duration of at least one minute, made during Just Eat Cycles regular opening times. This excludes cancelled trips and bikes moved by our team. The data is published at midnight UTC, meaning there will be different number of trips for a day in this data, compared to the numbers on the live station page that is following local timezone.

Variables

Variable	Format	Description
started_at	Timestamp	Timestamp of when the trip started
ended_at	Timestamp	Timestamp of when the trip ended
duration	Integer	Duration of trip in seconds
start_station_id	String	Unique ID for start station
start_station_name	String	Name of start station
start_station_description	String	Description of where start station is located
start_station_latitude	Decimal degrees in WGS84	Latitude of start station
start_station_longitude	Decimal degrees in WGS84	Longitude of start station
end_station_id	String	Unique ID for end station
end_station_name	String	Name of end station
end_station_description	String	Description of where end station is located
end_station_latitude	Decimal degrees in WGS84	Latitude of end station
end_station_longitude	Decimal degrees in WGS84	Longitude of end station

Example JSON

[
  {
    "started_at":"2018-10-01 01:21:40.555000+00:00",
    "start_station_name":"St Andrew Square",
    "ended_at":"2018-10-01 01:26:57.840000+00:00",
    "start_station_longitude":-3.1927736686587878,
    "end_station_description":"near Tesco's",
    "end_station_name":"Canonmills",
    "start_station_description":"North East corner",
    "start_station_id":"259",
    "start_station_latitude":55.95474881217642,
    "end_station_id":"262",
    "end_station_latitude":55.96280408759764,
    "end_station_longitude":-3.196283585062929,
    "duration":317
  },
  {
    "started_at":"2018-10-01 04:44:47.775000+00:00",
    "start_station_name":"Kings Building 3",
    "ended_at":"2018-10-01 04:47:27.430000+00:00",
    "start_station_longitude":-3.1753845849070785,
    "end_station_description":"Kings Building House",
    "end_station_name":"Kings Building 3",
    "start_station_description":"Kings Building House",
    "start_station_id":"254",
    "start_station_latitude":55.923478807846635,
    "end_station_id":"254",
    "end_station_latitude":55.923478807846635,
    "end_station_longitude":-3.1753845849070785,
    "duration":159
  },
  {
    "started_at":"2018-10-01 04:45:03.548000+00:00",
    "start_station_name":"Kings Building 3",
    "ended_at":"2018-10-01 05:14:10.466000+00:00",
    "start_station_longitude":-3.1753845849070785,
    "end_station_description":"Melville Terrace",
    "end_station_name":"Meadows East",
    "start_station_description":"Kings Building House",
    "start_station_id":"254",
    "start_station_latitude":55.923478807846635,
    "end_station_id":"265",
    "end_station_latitude":55.939809466328285,
    "end_station_longitude":-3.182738850746432,
    "duration":1746
  }
]

Example CSV

  "started_at","ended_at","duration","start_station_id","start_station_name","start_station_description","start_station_latitude","start_station_longitude","end_station_id","end_station_name","end_station_description","end_station_latitude","end_station_longitude"
  "2018-10-01 01:21:40.555000+00:00","2018-10-01 01:26:57.840000+00:00","317","259","St Andrew Square","North East corner","55.95474881217642","-3.1927736686587878","262","Canonmills","near Tesco's","55.96280408759764","-3.196283585062929"
  "2018-10-01 04:44:47.775000+00:00","2018-10-01 04:47:27.430000+00:00","159","254","Kings Building 3","Kings Building House","55.923478807846635","-3.1753845849070785","254","Kings Building 3","Kings Building House","55.923478807846635","-3.1753845849070785"
  "2018-10-01 04:45:03.548000+00:00","2018-10-01 05:14:10.466000+00:00","1746","254","Kings Building 3","Kings Building House","55.923478807846635","-3.1753845849070785","265","Meadows East","Melville Terrace","55.939809466328285","-3.182738850746432"
  "2018-10-01 04:53:03.261000+00:00","2018-10-01 04:58:42.537000+00:00","339","255","Kings Buildings 4","X-Y Cafe","55.92200087060626","-3.1769018141649212","254","Kings Building 3","Kings Building House","55.923478807846635","-3.1753845849070785"
  "2018-10-01 05:01:40.443000+00:00","2018-10-01 05:15:36.416000+00:00","835","252","Kings Buildings 1","Grant Institute","55.92418540667696","-3.173830830087809","265","Meadows East","Melville Terrace","55.939809466328285","-3.182738850746432"
  "2018-10-01 05:11:01.537000+00:00","2018-10-01 05:22:27.201000+00:00","685","262","Canonmills","near Tesco's","55.96280408759764","-3.196283585062929","250","Victoria Quay","Entrance to Scottish Government Office","55.977637787726984","-3.174115590621568"
  "2018-10-01 05:38:50.062000+00:00","2018-10-01 05:45:17.345000+00:00","387","261","Brunswick Place","Junction Brunswick Street and Elm Row","55.960929747664","-3.1810053147805775","225","Waverley Court","On Waverley Court forecourt","55.95173449698344","-3.1841785354060903"
  "2018-10-01 06:19:11.895000+00:00","2018-10-01 06:31:44.031000+00:00","752","250","Victoria Quay","Entrance to Scottish Government Office","55.977637787726984","-3.174115590621568","262","Canonmills","near Tesco's","55.96280408759764","-3.196283585062929"

Real time data

You may also get real time data about bike and station availability