Taxi Trips (2024-)

Taxi trips, starting January 2024, 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. <b> For earlier trips, see the link in the Featured Content section below.</b>

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-2024-ajtu-isnz\".\"taxi_trips_2024\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.