The New York TLC Dataset
This well-known dataset contains trip details of all taxi trips conducted in New York City in December 2018.
https://csvbase.com/mdfarragher/Taxi-Trips
9,998
Details
The New York City Taxi and Limousine Commission (TLC), created in 1971, is the agency responsible for licensing and regulating New York City’s yellow taxi cabs, for-hire vehicles, commuter vans, and paratransit vehicles. Over 200,000 TLC licensed drivers complete approximately 1,000,000 trips each day. To operate for hire, drivers must first undergo a background check, have a safe driving record, and complete 24 hours of driver training.
In partnership with the New York City Department of Information Technology and Telecommunications, TLC has published millions of trip records from both yellow and green taxis. The taxi trip records include fields capturing pick-up and drop-off dates/times, pick-up and drop-off locations, trip distances, itemized fares, rate types, payment types, and driver-reported passenger counts.
Data Schema
The dataset can be downloaded in CSV, Parquet, XLSX or JSONL format and has the following schema:
| Column name | Column type | Missing data? |
|---|---|---|
| Row ID | Integer | Not allowed |
| VendorID | Integer | Allowed |
| tpep_pickup_datetime | Text | Allowed |
| tpep_dropoff_datetime | Text | Allowed |
| passenger_count | Integer | Allowed |
| trip_distance | Float | Allowed |
| RatecodeID | Integer | Allowed |
| store_and_fwd_flag | Boolean | Allowed |
| PULocationID | Integer | Allowed |
| DOLocationID | Integer | Allowed |
| payment_type | Integer | Allowed |
| fare_amount | Float | Allowed |
| extra | Float | Allowed |
| mta_tax | Float | Allowed |
| tip_amount | Float | Allowed |
| tolls_amount | Float | Allowed |
| improvement_surcharge | Float | Allowed |
| total_amount | Float | Allowed |
