Taxi Trips (2013-2023)

<b>This dataset ends with 2023. Please see the Featured Content link below for the dataset that starts in 2024.</b>

Taxi trips from 2013 to 2023 reported to the City of Chicago in its role as a regulatory agency. To protect privacy but allow for aggregate analyses, the Taxi ID is consistent for any given taxi medallion number but does not show the number, Census Tracts are suppressed in some cases, and times are rounded to the nearest 15 minutes.

Due to the data reporting process, not all trips are reported but the City believes that most are.

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/taxi-trips-20132023-wrvz-psew\".\"taxi_trips_20132023\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.