About this Dataset

2017 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:00:48.349955
Tags: base, fhv, green-taxi, high-volume, lyft, trip, trip-data, uber, via

Tables

Table 1

@usgov.city_of_new_york_2017_green_taxi_trip_data.table_1

237.96 MB
11,740,667 rows
19 columns

CREATE TABLE table_1 (
  "vendorid" BIGINT,
  "lpep_pickup_datetime" VARCHAR,
  "lpep_dropoff_datetime" VARCHAR,
  "store_and_fwd_flag" VARCHAR,
  "ratecodeid" BIGINT,
  "pulocationid" BIGINT,
  "dolocationid" BIGINT,
  "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
);