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

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

VariableFormatDescription
started_at
TimestampTimestamp of when the trip started
ended_at
TimestampTimestamp of when the trip ended
duration
IntegerDuration of trip in seconds
start_station_id
StringUnique ID for start station
start_station_name
StringName of start station
start_station_description
StringDescription of where start station is located
start_station_latitude
Decimal degrees in WGS84Latitude of start station
start_station_longitude
Decimal degrees in WGS84Longitude of start station
end_station_id
StringUnique ID for end station
end_station_name
StringName of end station
end_station_description
StringDescription of where end station is located
end_station_latitude
Decimal degrees in WGS84Latitude of end station
end_station_longitude
Decimal degrees in WGS84Longitude 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