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

2024 Yellow Taxi Trip Data

rwwi-khbcTransportation19 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

B88.6 / 100

From a 500-row sample across 19 columns.

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

Related datasets

  • 2022 Yellow Taxi Trip Data0.84
    joins onairport_feetip_amountstore_and_fwd_flag+16
  • 2023 Yellow Taxi Trip Data0.84
    joins onairport_feetip_amountstore_and_fwd_flag+16
  • 2020 Yellow Taxi Trip Data0.83
    joins ontip_amountstore_and_fwd_flagdolocationid+15
  • 2019 Yellow Taxi Trip Data

Sample rows

vendoridtpep_pickup_datetimetpep_dropoff_datetimepassenger_counttrip_distanceratecodeidstore_and_fwd_flagpulocationiddolocationidpayment_typefare_amountextra
22024-01-01T00:57:55.0002024-01-01T01:17:43.0001.01.721.0N18679217.71.0
1

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 4
tpep_pickup_datetimedatetimeThe date and time when the meter was engaged.0%2024-04-02T18:15:00.0002024-06-14T19:33:00.0002024-11-06T12:00:00.000
tpep_dropoff_datetimedatetimeThe date and time when the meter was disengaged.0%2024-04-20T00:00:00.0002024-12-13T07:59:20.0002024-12-13T07:59:19.000
passenger_countcategoricalThe number of passengers in the vehicle.10%

Query this from your own app

GET /api/datasets/rwwi-khbc
GET /api/datasets/rwwi-khbc/quality
GET /api/datasets/rwwi-khbc/related
GET /api/columns?dataset=rwwi-khbc
0.83
joins ontip_amountstore_and_fwd_flagdolocationid+15
  • 2021 Yellow Taxi Trip Data0.82
    joins ontip_amountstore_and_fwd_flagdolocationid+15
  • 2017 Yellow Taxi Trip Data0.81
    joins ontip_amountstore_and_fwd_flagdolocationid+14
  • 2018 Yellow Taxi Trip Data0.81
    joins ontip_amountstore_and_fwd_flagdolocationid+14
  • 2016 Yellow Taxi Trip Data0.80
    joins ontip_amountstore_and_fwd_flagdolocationid+14
    • 2024-01-01T00:03:00.000
    2024-01-01T00:09:36.000
    1.0
    1.8
    1.0
    N
    140
    236
    1
    10.0
    3.5
    12024-01-01T00:17:06.0002024-01-01T00:35:01.0001.04.71.0N23679123.33.5
    12024-01-01T00:36:38.0002024-01-01T00:44:56.0001.01.41.0N79211110.03.5
    12024-01-01T00:46:51.0002024-01-01T00:52:57.0001.00.81.0N21114817.93.5
    12024-01-01T00:54:08.0002024-01-01T01:26:31.0001.04.71.0N148141129.63.5
    22024-01-01T00:49:44.0002024-01-01T01:15:47.0002.010.821.0N138181145.76.0
    12024-01-01T00:30:40.0002024-01-01T00:58:40.0000.03.01.0N246231225.43.5
    22024-01-01T00:26:01.0002024-01-01T00:54:12.0001.05.441.0N161261231.01.0
    22024-01-01T00:28:08.0002024-01-01T00:29:16.0001.00.041.0N11311323.01.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.10%1.02.099.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.10%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.5-0.50.0
    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.9413.38
    improvement_surchargecategoricalImprovement surcharge assessed trips at the flag drop. The improvement surcharge began being levied in 2015.0%1.0-1.00.0of 7
    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.10%2.50.0-2.5of 8
    airport_feecategoricalFor pick up only at LaGuardia and John F. Kennedy Airports.10%0.01.75-1.75of 4