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

January 2020
Updated daily
December 2019
November 2019
October 2019
September 2019
August 2019
July 2019
June 2019
May 2019
April 2019
March 2019
February 2019
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