About this Dataset

2023 Yellow Taxi Trip Data

These records are generated from the trip record submissions made by yellow taxi Technology Service Providers (TSPs). Each row represents a single trip in a yellow taxi. The trip records include fields capturing pick-up and drop-off dates/times, pick-up and drop-off taxi zone locations, trip distances, itemized fares, rate types, payment types, and driver-reported passenger counts.
Organization: City of New York
Last updated: 2024-07-20T21:10:56.585520
Tags: base, fhv, high-volume, lyft, trip, trip-data, uber, via, yellow-taxi

Tables

Table 1

@usgov.city_of_new_york_2023_yellow_taxi_trip_data.table_1

720.64 MB
38310226 rows
19 columns


CREATE TABLE table_1 (
  "vendorid" BIGINT,
  "tpep_pickup_datetime" VARCHAR,
  "tpep_dropoff_datetime" VARCHAR,
  "passenger_count" DOUBLE,
  "trip_distance" DOUBLE,
  "ratecodeid" DOUBLE,
  "store_and_fwd_flag" VARCHAR,
  "pulocationid" BIGINT,
  "dolocationid" BIGINT,
  "payment_type" BIGINT,
  "fare_amount" DOUBLE,
  "extra" DOUBLE,
  "mta_tax" DOUBLE,
  "tip_amount" DOUBLE,
  "tolls_amount" DOUBLE,
  "improvement_surcharge" DOUBLE,
  "total_amount" DOUBLE,
  "congestion_surcharge" DOUBLE,
  "airport_fee" DOUBLE
);