About this Dataset

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. For earlier trips, see the link in the Featured Content section below. Due to the data reporting process, not all trips are reported but the City believes that most are.
Organization: City of Chicago
Last updated: 2024-02-09T16:49:23.594788
Tags: taxis, transportation

Tables

Table 1

@usgov.city_of_chicago_taxi_trips_2024.table_1

523 MB
7,917,844 rows
23 columns

CREATE TABLE table_1 (
  "trip_id" VARCHAR,
  "taxi_id" VARCHAR,
  "trip_start_timestamp" VARCHAR,
  "trip_end_timestamp" VARCHAR,
  "trip_seconds" DOUBLE,
  "trip_miles" DOUBLE,
  "pickup_census_tract" DOUBLE,
  "dropoff_census_tract" DOUBLE,
  "pickup_community_area" DOUBLE,
  "dropoff_community_area" DOUBLE,
  "fare" DOUBLE,
  "tips" DOUBLE,
  "tolls" DOUBLE,
  "extras" DOUBLE,
  "trip_total" DOUBLE,
  "payment_type" VARCHAR,
  "company" VARCHAR,
  "pickup_centroid_latitude" DOUBLE,
  "pickup_centroid_longitude" DOUBLE,
  "pickup_centroid_location" VARCHAR,
  "dropoff_centroid_latitude" DOUBLE,
  "dropoff_centroid_longitude" DOUBLE,
  "dropoff_centroid_location" VARCHAR
);