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

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

VariableFormatDescription
started_atTimestampTimestamp of when the trip started
ended_atTimestampTimestamp of when the trip ended
durationIntegerDuration of trip in seconds
start_station_idStringUnique ID for start station
start_station_nameStringName of start station
start_station_descriptionStringDescription of where start station is located
start_station_latitudeDecimal degrees in WGS84Latitude of start station
start_station_longitudeDecimal degrees in WGS84Longitude of start station
end_station_idStringUnique ID for end station
end_station_nameStringName of end station
end_station_descriptionStringDescription of where end station is located
end_station_latitudeDecimal degrees in WGS84Latitude of end station
end_station_longitudeDecimal degrees in WGS84Longitude 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"

Real time data

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