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
| 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"