Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

2023 Yellow Taxi Trip Data

4b4i-vvecTransportation19 columns
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.
View on NYC Open Data↗

Quality

C78.0 / 100

From a 500-row sample across 19 columns.

completeness100/ 25% weight
consistency53/ 20% weight
accuracy98/ 20% weight
timeliness25/ 15% weight
usability95/ 20% weight

Related datasets

  • 2021 Yellow Taxi Trip Data0.92
    joins onpassenger_counttpep_dropoff_datetimecongestion_surcharge+15
  • 2020 Yellow Taxi Trip Data0.91
    joins onpassenger_counttpep_dropoff_datetimecongestion_surcharge+15
  • 2017 Yellow Taxi Trip Data0.91
    joins onpassenger_counttpep_dropoff_datetimetotal_amount+14
  • 2018 Yellow Taxi Trip Data

Sample rows

vendoridtpep_pickup_datetimetpep_dropoff_datetimepassenger_counttrip_distanceratecodeidstore_and_fwd_flagpulocationiddolocationidpayment_typefare_amountextra
22023-01-01T00:32:10.0002023-01-01T00:40:36.0001.00.971.0N16114129.31.0
2

Columns

19 queryable · 19 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
vendoridcategoricalA code indicating the TPEP provider that provided the record.0%216of 3
tpep_pickup_datetimedatetimeThe date and time when the meter was engaged.0%2023-02-03T18:43:00.0002023-03-30T18:09:19.0002023-10-19T21:42:30.000
tpep_dropoff_datetimedatetimeThe date and time when the meter was disengaged.0%2023-05-27T00:00:00.0002023-06-10T00:00:00.0002023-12-16T00:00:00.000
passenger_countcategoricalThe number of passengers in the vehicle.3%

Query this from your own app

GET /api/datasets/4b4i-vvec
GET /api/datasets/4b4i-vvec/quality
GET /api/datasets/4b4i-vvec/related
GET /api/columns?dataset=4b4i-vvec
0.90
joins onpassenger_counttpep_dropoff_datetimetotal_amount+14
  • 2019 Yellow Taxi Trip Data0.89
    joins onpassenger_counttpep_dropoff_datetimecongestion_surcharge+15
  • 2022 Yellow Taxi Trip Data0.88
    joins onpassenger_counttpep_dropoff_datetimecongestion_surcharge+16
  • 2016 Yellow Taxi Trip Data0.84
    joins onpassenger_counttpep_dropoff_datetimetotal_amount+14
  • 2014 Yellow Taxi Trip Data0.78
    joins onpassenger_counttotal_amounttolls_amount+7
    • 2023-01-01T00:55:08.000
    2023-01-01T01:01:27.000
    1.0
    1.1
    1.0
    N
    43
    237
    1
    7.9
    1.0
    22023-01-01T00:25:04.0002023-01-01T00:37:49.0001.02.511.0N48238114.91.0
    12023-01-01T00:03:48.0002023-01-01T00:13:25.0000.01.91.0N1387112.17.25
    22023-01-01T00:10:29.0002023-01-01T00:21:19.0001.01.431.0N10779111.41.0
    22023-01-01T00:50:34.0002023-01-01T01:02:52.0001.01.841.0N161137112.81.0
    22023-01-01T00:09:22.0002023-01-01T00:19:49.0001.01.661.0N239143112.11.0
    22023-01-01T00:27:12.0002023-01-01T00:49:56.0001.011.71.0N142200145.71.0
    22023-01-01T00:21:44.0002023-01-01T00:36:40.0001.02.951.0N164236117.71.0
    22023-01-01T00:39:42.0002023-01-01T00:50:36.0001.03.011.0N141107214.91.0

    Showing 12 of 19 columns. All of them are listed below.

    1.02.03.0of 10
    trip_distancefloatThe elapsed trip distance in miles reported by the taximeter.0%0.00.91.0
    ratecodeidcategoricalThe final rate code in effect at the end of the trip.3%1.02.05.0of 7
    store_and_fwd_flagcategoricalThis 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.3%NYof 2
    pulocationidintegerTLC Taxi Zone in which the taximeter was engaged0%132237161
    dolocationidintegerTLC Taxi Zone in which the taximeter was disengaged0%236237161
    payment_typecategoricalA numeric code signifying how the passenger paid for the trip.0%120of 6
    fare_amountfloatThe 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.page0%8.69.310.0
    extrafloatMiscellaneous extras and surcharges.0%0.02.51.0
    mta_taxfloatTax that is automatically triggered based on the metered rate in use.0%0.50.0-0.5
    tip_amountfloatTip amount – This field is automatically populated for credit card tips. Cash tips are not included.0%0.02.01.0
    tolls_amountfloatTotal amount of all tolls paid in trip.0%0.06.556.94
    improvement_surchargecategoricalImprovement surcharge assessed trips at the flag drop. The improvement surcharge began being levied in 2015.0%1.0-1.00.3of 5
    total_amountfloatThe total amount charged to passengers. Does not include cash tips.0%16.812.621.0
    congestion_surchargecategoricalTotal amount collected in trip for NYS congestion surcharge.3%2.50.0-2.5of 7
    airport_feecategoricalFor pick up only at LaGuardia and John F. Kennedy Airports.3%0.01.751.25of 7