About this Dataset

2016 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-02T05:48:24.944430
Tags: base, fhv, high-volume, lyft, trip, trip-data, uber, via, yellow-taxi

Tables

Table 1

@usgov.city_of_new_york_2016_yellow_taxi_trip_data_dfc77.table_1

238.51 MB
13049653 rows
21 columns


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