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.