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

2019 Yellow Taxi Trip Data

2upf-qytpTransportation18 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

C74.9 / 100

From a 500-row sample across 17 columns.

completeness100/ 25% weight
consistency53/ 20% weight
accuracy97/ 20% weight
timeliness6/ 15% weight
usability95/ 20% weight

Related datasets

  • 2021 Yellow Taxi Trip Data0.95
    joins ontotal_amounttolls_amountmta_tax+15
  • 2020 Yellow Taxi Trip Data0.94
    joins ontotal_amounttolls_amountmta_tax+15
  • 2017 Yellow Taxi Trip Data0.93
    joins ontotal_amounttolls_amountmta_tax+14
  • 2022 Yellow Taxi Trip Data

Sample rows

vendoridtpep_pickup_datetimetpep_dropoff_datetimepassenger_counttrip_distanceratecodeidstore_and_fwd_flagpulocationiddolocationidpayment_typefare_amountextra
12019-01-01T00:46:40.0002019-01-01T00:53:20.00011.501N151239170.5
1

Columns

18 queryable · 18 profiled

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

FieldTypeDescriptionNullValues
vendoridcategorical—0%214of 3
tpep_pickup_datetimedatetime—0%2019-02-02T12:19:58.0002019-01-11T15:15:27.0002019-01-08T15:15:01.000
tpep_dropoff_datetimedatetime—0%2019-10-27T00:00:00.0002019-08-04T00:00:00.0002019-12-29T00:00:00.000
passenger_countcategorical—0%123

Query this from your own app

GET /api/datasets/2upf-qytp
GET /api/datasets/2upf-qytp/quality
GET /api/datasets/2upf-qytp/related
GET /api/columns?dataset=2upf-qytp
0.93
joins ontotal_amounttolls_amountmta_tax+15
  • 2018 Yellow Taxi Trip Data0.91
    joins ontotal_amounttolls_amountmta_tax+14
  • 2016 Yellow Taxi Trip Data0.89
    joins ontotal_amounttolls_amountmta_tax+14
  • 2023 Yellow Taxi Trip Data0.89
    joins ontotal_amounttolls_amountmta_tax+15
  • 2016 Green Taxi Trip Data0.84
    joins ontotal_amounttolls_amountmta_tax+12
    • 2019-01-01T00:59:47.000
    2019-01-01T01:18:59.000
    1
    2.60
    1
    N
    239
    246
    1
    14
    0.5
    22018-12-21T13:48:30.0002018-12-21T13:52:40.00030.001N23623614.50.5
    22018-11-28T15:52:25.0002018-11-28T15:55:45.00050.001N19319323.50.5
    22018-11-28T15:56:57.0002018-11-28T15:58:33.00050.002N1931932520
    22018-11-28T16:25:49.0002018-11-28T16:28:26.00050.001N19319323.50.5
    22018-11-28T16:29:37.0002018-11-28T16:33:43.00050.002N1931932520
    12019-01-01T00:21:28.0002019-01-01T00:28:37.00011.301N16322916.50.5
    12019-01-01T00:32:01.0002019-01-01T00:45:39.00013.701N2297113.50.5
    12019-01-01T00:57:32.0002019-01-01T01:09:32.00022.101N1412341100.5

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

    of 10
    trip_distancefloat—0%0.900.801.00
    ratecodeidcategorical—0%125of 7
    store_and_fwd_flagcategorical—0%NYof 2
    pulocationidinteger—0%237161236
    dolocationidinteger—0%236161237
    payment_typecategorical—0%123of 5
    fare_amountfloat—0%66.57
    extrafloat—0%00.52.5
    mta_taxfloat—0%0.50-0.5
    tip_amountfloat—0%012
    tolls_amountfloat—0%06.125.76
    improvement_surchargecategorical—0%0.3-0.30of 6
    total_amountfloat—0%9.810.39.3
    congestion_surchargecoordinate—6%2.50-2.5of 15