Dataset: 2022 Yellow Taxi Trip Data

About this Dataset

2022 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: 2023-12-16T05:29:49.917457
Tags: base, fhv, high-volume, lyft, trip, trip-data, uber, via, yellow-taxi

Tables

Table 1

@usgov.city_of_new_york_2022_yellow_taxi_trip_data.table_1

156.7 MB
15539808 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" DOUBLE,
  "dolocationid" DOUBLE,
  "payment_type" DOUBLE,
  "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
);