About this Dataset

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

Tables

Table 1

@usgov.city_of_new_york_2014_green_taxi_trip_data.table_1

639.96 MB
15837001 rows
20 columns


CREATE TABLE table_1 (
  "vendorid" BIGINT,
  "pickup_datetime" VARCHAR,
  "dropoff_datetime" VARCHAR,
  "store_and_fwd_flag" VARCHAR,
  "rate_code" 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,
  "total_amount" DOUBLE,
  "payment_type" BIGINT,
  "trip_type" DOUBLE
);