Bikeshare (Docked and Dockless) and E-scooter Systems 2020 by Month and System Status
List of cities served by a bikeshare (docked or dockless) and/or e-scooter system by month in 2020. Some systems serve more than one city. The layer lists just the primary city served. Bikeshare includes systems that are open to the general public, IT-automated, and station based (contain hubs to which users can grab and return a bike) as well as dockless systems. The layer includes a count of the number of docking stations, the number of dockless bikeshare systems, and the number of e-scooter systems serving a city (if applicable) in each month and the status of the system - whether temporarily suspended or closed. Many systems temporarily suspended operations and/or closed permanently in response to COVID-19.
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \ -H "Content-Type: application/json" \ -d@-<<EOF {"sql": " SELECT * FROM \"bts-gov/bikeshare-docked-and-dockless-and-escooter-systems-8cjz-h8bz\".\"bikeshare_docked_and_dockless_and_escooter_systems\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.