E-Scooter Trips - 2020
Electric scooter trips taken during the 2020 Chicago pilot program. For more information on the pilot, see https://www.chicago.gov/scooters.
In contrast to the 2019 E-Scooters dataset (https://data.cityofchicago.org/d/2kfw-zvte), vendor names are included. Additionally, Census Tracts are provided in a separate dataset to allow for providing more data while still protecting privacy. See "E-Scooter Trips - Census Tract Summary - 2020" dataset (https://data.cityofchicago.org/d/3srm-twg4).
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 \"cityofchicago/escooter-trips-2020-3rse-fbp6\".\"escooter_trips_2020\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.