Baselight
Sign In

Taxi Trips (2024-)

City of Chicago

@usgov.city_of_chicago_taxi_trips_2024

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
  • 498.77 MB
  • 7917844 rows
  • 23 columns
Loading...
 

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
);