BigQuery dataset with historic station status data

[Panos Ipeirotis]

I have been collecting the status of the Citibike stations every 5 minutes for over a year now (since Spring 2023).

In the notebook at 

https://github.com/ipeirotis-org/datasets/blob/main/Citibike/example.ipynb

I provide an example of how to access the data.

The raw dataset is available through Google BigQuery in the following two tables:

1. SELECT * FROM `nyu-datasets.citibike.station_information_external`

2. SELECT * FROM `nyu-datasets.citibike.station_status_external`

You will need to create a Google Cloud account and grant permission to query BigQuery.

By running the query:

SELECT * FROM `nyu-datasets.citibike.dataset`

you will get a table with hourly dock data after some basic preprocessing of the raw data.

Happy to answer any questions.

Best,

Panos