2010 Yellow Taxi Trip Data by US Government | Transportation and Logistics

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

896.57 MB
15057430 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
);