New York City Yellow Taxi Trip Records for 2009

2009 Yellow Taxi Trip Data contains individual trip records submitted by Technology Service Providers for New York City's yellow taxi fleet. Each row details pick-up and drop-off times and locations, trip distance, itemized fares, and payment type. The dataset is hosted by data.cityofnewyork.us and was last updated in December 2023.

Use Cases

• Predict total_amount from trip_distance, fare_amount, and tolls_amount using regression models.
• Cluster pickup_location and dropoff_location coordinates to identify high-demand zones and routes.
• Analyze seasonal or hourly demand patterns using the tpep_pickup_datetime field.
• Classify payment_type based on trip characteristics like passenger_count and ratecodeid.
• Estimate trip duration by calculating the interval between tpep_pickup_datetime and tpep_dropoff_datetime.

Strengths

• Includes 20 detailed columns per trip, such as geographic coordinates and itemized fares.
• Data is sourced from official Technology Service Provider submissions to the city.

Limitations

• The dataset's total row count and file size are unknown, limiting assessment of statistical power.
• Data is from a single year (2009), which may not reflect current mobility patterns or pricing.

Provenance

Source

data.cityofnewyork.us

Collection Method

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

Time Range

2009

Freshness

Metadata was last updated in December 2023, but the underlying trip data is from 2009.

Geography

New York City, based on taxi zone locations and latitude/longitude coordinates.