Historical data
Here you can find monthly anonymised trip data from Trondheim City Bike. Are you doing anything cool with this data? Let us know on post@trondheimbysykkel.no.
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 Trondheim
- ⚡️ Map out the "rush hour" of different stations
- 📈 Make a neat infographic based on these numbers
Documentation
Licence
The data is published under the Norwegian Licence for Open Government Data (NLOD) 2.0
Data selection
The data include trips with a duration of at least one minute, made during Trondheim City Bike 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
[
{
"start_station_id": "51",
"duration": 1630,
"start_station_longitude": 10.37476971745491,
"end_station_longitude": 10.39729356765747,
"start_station_latitude": 63.430403126559675,
"end_station_description": "Ved hurtigbåtterminalen ",
"ended_at": "2018-10-01 04:27:59.869000+00:00",
"end_station_id": "9",
"end_station_latitude": 63.43740318294613,
"end_station_name": "Brattørkaia",
"start_station_description": " ved kryss Mellomila / Illevollen",
"start_station_name": "Skansen",
"started_at": "2018-10-01 04:00:49.531000+00:00"
},
{
"start_station_id": "6",
"duration": 455,
"start_station_longitude": 10.425844341516495,
"end_station_longitude": 10.39729356765747,
"start_station_latitude": 63.43660495943216,
"end_station_description": "Ved hurtigbåtterminalen ",
"ended_at": "2018-10-01 04:13:48.137000+00:00",
"end_station_id": "9",
"end_station_latitude": 63.43740318294613,
"end_station_name": "Brattørkaia",
"start_station_description": " ved kryss Mellomveien / Innherredsveien",
"start_station_name": "Lademoparken ",
"started_at": "2018-10-01 04:06:12.953000+00:00"
},
{
"start_station_id": "51",
"duration": 343,
"start_station_longitude": 10.37476971745491,
"end_station_longitude": 10.39729356765747,
"start_station_latitude": 63.430403126559675,
"end_station_description": "Ved hurtigbåtterminalen ",
"ended_at": "2018-10-01 04:13:36.356000+00:00",
"end_station_id": "9",
"end_station_latitude": 63.43740318294613,
"end_station_name": "Brattørkaia",
"start_station_description": " ved kryss Mellomila / Illevollen",
"start_station_name": "Skansen",
"started_at": "2018-10-01 04:07:52.671000+00:00"
}
]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 04:00:49.531000+00:00","2018-10-01 04:27:59.869000+00:00","1630","51","Skansen"," ved kryss Mellomila / Illevollen","63.430403126559675","10.37476971745491","9","Brattørkaia","Ved hurtigbåtterminalen ","63.43740318294613","10.39729356765747" "2018-10-01 04:06:12.953000+00:00","2018-10-01 04:13:48.137000+00:00","455","6","Lademoparken "," ved kryss Mellomveien / Innherredsveien","63.43660495943216","10.425844341516495","9","Brattørkaia","Ved hurtigbåtterminalen ","63.43740318294613","10.39729356765747" "2018-10-01 04:07:52.671000+00:00","2018-10-01 04:13:36.356000+00:00","343","51","Skansen"," ved kryss Mellomila / Illevollen","63.430403126559675","10.37476971745491","9","Brattørkaia","Ved hurtigbåtterminalen ","63.43740318294613","10.39729356765747" "2018-10-01 04:26:35.388000+00:00","2018-10-01 04:30:05.929000+00:00","210","118","Abels gate","Ved Udbyes gate","63.41614341778847","10.396314561367035","86","Lerkendal"," I Strindvegen ved Klæbuveien","63.412525462202666","10.40068656206131" "2018-10-01 04:38:11.066000+00:00","2018-10-01 04:42:29.483000+00:00","258","30","St Olavs gate","Ved trikkeholdeplass ","63.431170931099416","10.390283614397049","45","Studentersamfundet","sør for Eddaparken","63.42185871322338","10.39451614022255" "2018-10-01 04:44:34.038000+00:00","2018-10-01 04:49:12.629000+00:00","278","105","Trondheim S","Ved Sentralstasjonen","63.43605560561","10.399405807256699","30","St Olavs gate","Ved trikkeholdeplass ","63.431170931099416","10.390283614397049" "2018-10-01 05:01:46.410000+00:00","2018-10-01 05:06:18.326000+00:00","271","25","Thornesparken ","I Kirkegata ","63.43289961569575","10.412772931158543","105","Trondheim S","Ved Sentralstasjonen","63.43605560561","10.399405807256699" "2018-10-01 05:15:51.990000+00:00","2018-10-01 05:22:06.244000+00:00","374","44","Prinsen kinosenter"," ved kryss prinsens gate / Verftsgata","63.42663458755783","10.392784774303436","1","Dokkparken"," Ved kryss Innherredsveien / Verftsgata","63.433509009133566","10.411412715911865"