About this Dataset

2010 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: 2022-06-09T03:25:57.274511
Tags: base, fhv, high-volume, lyft, trip, trip-data, uber, via, yellow-taxi

Tables

Table 1

@usgov.city_of_new_york_2010_yellow_taxi_trip_data.table_1

940.13 MB
15,057,430 rows
20 columns

CREATE TABLE table_1 (
  "vendorid" VARCHAR,
  "tpep_pickup_datetime" VARCHAR,
  "dropoff_datetime" VARCHAR,
  "passenger_count" BIGINT,
  "trip_distance" DOUBLE,
  "pickup_longitude" DOUBLE,
  "pickup_latitude" DOUBLE,
  "ratecodeid" BIGINT,
  "store_and_fwd_flag" VARCHAR,
  "dropoff_longitude" DOUBLE,
  "dropoff_latitude" DOUBLE,
  "payment_type" VARCHAR,
  "fare_amount" DOUBLE,
  "extra" DOUBLE,
  "mta_tax" DOUBLE,
  "tip_amount" DOUBLE,
  "tolls_amount" DOUBLE,
  "total_amount" DOUBLE,
  "pickup_location" VARCHAR,
  "dropoff_location" VARCHAR
);