Dataset: 2023 Green Taxi Trip Data

About this Dataset

2023 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: 2024-07-20T21:19:04.367498
Tags: base, fhv, green-taxi, high-volume, lyft, trip, trip-data, uber, via

Tables

Table 1

@usgov.city_of_new_york_2023_green_taxi_trip_data.table_1

18.13 MB
787060 rows
20 columns


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