2016 Green Taxi Trip Data by US Government | Transportation and Logistics

About this Dataset

2016 Green Taxi Trip Data

These records are generated from the trip record submissions made by green taxi Technology Service Providers (TSPs). Each row represents a single trip in a green 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: 2020-11-10T17:03:26.615347
Tags: base, fhv, green-taxi, high-volume, lyft, trip, trip-data, uber, via

Tables

Table 1

@usgov.city_of_new_york_2016_green_taxi_trip_data.table_1

330.02 MB
16385532 rows
23 columns


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