Dataset
2023 Yellow Taxi Trip Data
nyc.4b4i-vvec
Ask your agent
Use escrito dataset nyc.4b4i-vvec
Connect an agent at https://data.escrito.io/mcp
About
These records are generated from the trip record submissions made by yellow taxi Technology Service Providers (TSPs). Each row represents a single trip in a yellow 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). 2023 Yellow Taxi Trip Data. https://data.cityofnewyork.us/d/4b4i-vvec
- Publisher
- City of New York
- Tier
- Official
- Covers
- not stated
- Places
- New York City
- Updated
- never
- Last modified
- 2024-07-01
- 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 |
|---|---|---|
| mta_tax | number | Tax that is automatically triggered based on the metered rate in use. |
| dolocationid | number | TLC Taxi Zone in which the taximeter was disengaged |
| ratecodeid | number | The final rate code in effect at the end of the trip. |
| trip_distance | number | The elapsed trip distance in miles reported by the taximeter. |
| tpep_pickup_datetime | calendar_date | The date and time when the meter was engaged. |
| extra | number | Miscellaneous extras and surcharges. |
| tpep_dropoff_datetime | calendar_date | The date and time when the meter was disengaged. |
| passenger_count | number | The number of passengers in the vehicle. |
| 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. |
| total_amount | number | The total amount charged to passengers. Does not include cash tips. |
| payment_type | number | A numeric code signifying how the passenger paid for the trip. |
| pulocationid | number | TLC Taxi Zone in which the taximeter was engaged |
| airport_fee | number | For pick up only at LaGuardia and John F. Kennedy Airports. |
| vendorid | number | A code indicating the TPEP provider that provided the record. |
| tolls_amount | number | Total amount of all tolls paid in trip. |
| fare_amount | number | The time-and-distance fare calculated by the meter. For additional information on the following columns, see https://www.nyc.gov/site/tlc/passengers/taxi-fare.page |
| congestion_surcharge | number | Total amount collected in trip for NYS congestion surcharge. |
| tip_amount | number | Tip amount – This field is automatically populated for credit card tips. Cash tips are not included. |
| improvement_surcharge | number | Improvement surcharge assessed trips at the flag drop. The improvement surcharge began being levied in 2015. |