Dataset
2021 Green Taxi Trip Data
nyc.djnb-wcxt
Ask your agent
Use escrito dataset nyc.djnb-wcxt
Connect an agent at https://data.escrito.io/mcp
About
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.
Cite as: Taxi and Limousine Commission (TLC). 2021 Green Taxi Trip Data. https://data.cityofnewyork.us/d/djnb-wcxt
- Publisher
- City of New York
- Tier
- Official
- Covers
- not stated
- Places
- New York City
- Updated
- irregular
- Last modified
- 2022-04-26
- Units
- not stated
- License
- NYC Open Data Terms of Use
- Method
- https://www.nyc.gov/site/tlc/about/tlc-trip-record-data.page
Columns
| Name | Type | Description |
|---|---|---|
| improvement_surcharge | number | $0.30 improvement surcharge assessed trips at the flag drop. The improvement surcharge began being levied in 2015. |
| mta_tax | number | Tax that is automatically triggered based on the metered rate in use. |
| pulocationid | number | TLC Taxi Zone in which the taximeter was engaged |
| lpep_dropoff_datetime | calendar_date | The date and time when the meter was disengaged. |
| ehail_fee | text | |
| total_amount | number | The total amount charged to passengers. Does not include cash tips. |
| passenger_count | number | The number of passengers in the vehicle |
| payment_type | number | A numeric code signifying how the passenger paid for the trip. |
| tip_amount | number | Tip amount – This field is automatically populated for credit card tips. Cash tips are not included. |
| ratecodeid | number | The final rate code in effect at the end of the trip. |
| extra | number | Miscellaneous extras and surcharges. Currently, this only includes the $0.50 and $1 rush hour and overnight charges. |
| trip_distance | number | The elapsed trip distance in miles reported by the taximeter. |
| dolocationid | number | TLC Taxi Zone in which the taximeter was disengaged |
| fare_amount | number | The time-and-distance fare calculated by the meter. |
| store_and_fwd_flag | text | This flag indicates whether the trip record was held in vehicle memory before sending to the vendor, aka “store and forward,” because the vehicle did not have a connection to the server. |
| congestion_surcharge | number | |
| tolls_amount | number | Total amount of all tolls paid in trip. |
| vendorid | number | A code indicating the TPEP provider that provided the record. |
| lpep_pickup_datetime | calendar_date | The date and time when the meter was engaged. |
| trip_type | number |