2018 New York City Yellow Taxi Trip Records with Fares and Locations

Records generated from trip submissions by yellow taxi Technology Service Providers (TSPs). Each row represents a single yellow taxi trip, including pick-up and drop-off times, taxi zone locations, distances, itemized fares, and passenger counts. The data is hosted by data.cityofnewyork.us and was last updated on 2023-12-14.

Use Cases

• Predict total_amount from trip_distance, fare_amount, and tolls_amount using regression models.
• Analyze peak demand times by aggregating passenger_count and trip_distance by tpep_pickup_datetime hour.
• Cluster popular routes by mapping PULocationID and DOLocationID pairs.
• Classify payment_type based on fare_amount, tip_amount, and total_amount.
• Model trip duration from tpep_pickup_datetime and tpep_dropoff_datetime with geospatial features.

Strengths

• Includes 17 detailed columns covering temporal, geospatial, fare, and trip characteristics.
• Data is sourced from official city platform data.cityofnewyork.us and was last updated in 2023.
• Columns suggest itemized fare breakdown with fare_amount, extra, mta_tax, tip_amount, tolls_amount, and improvement_surcharge.

Limitations

• Row count and total dataset size are unknown, which may limit suitability assessment.
• Description metadata is limited; actual data quality, such as missing value rates, requires manual inspection after download.

Provenance

Source

data.cityofnewyork.us

Collection Method

Records generated from trip record submissions made by yellow taxi Technology Service Providers (TSPs).

Time Range

2018

Freshness

Last updated 2023-12-14 20:46:24; freshness should be verified for 2018 data.

Geography

New York City (indicated by taxi zone location IDs)