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

2022 Green Taxi Trip Data

8nfn-ifajTransportation20 columns
These records are generated from the trip record submissions made by green taxi Technology Service Providers (TSPs). Each row represents a single trip in a green 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.8 / 100

From a 500-row sample across 19 columns.

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

Related datasets

  • 2019 Green Taxi Trip Data0.96
    joins onpulocationidlpep_dropoff_datetimecongestion_surcharge+17
  • 2023 Green Taxi Trip Data0.94
    joins onpulocationidlpep_dropoff_datetimecongestion_surcharge+17
  • 2018 Green Taxi Trip Data0.92
    joins onpulocationidlpep_dropoff_datetimetolls_amount+16

Sample rows

vendoridlpep_pickup_datetimelpep_dropoff_datetimestore_and_fwd_flagratecodeidpulocationiddolocationidpassenger_counttrip_distancefare_amountextramta_tax
22022-09-01T00:45:23.0002022-09-01T00:52:39.000N1.074421.01.517.50.50.5
2

Columns

20 queryable · 20 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%215of 3
lpep_pickup_datetimedatetimeThe date and time when the meter was engaged.0%2022-12-31T21:39:00.0002022-05-08T12:06:00.0002022-06-18T14:25:00.000
lpep_dropoff_datetimedatetimeThe date and time when the meter was disengaged.0%2022-03-06T00:00:00.0002022-01-07T00:00:00.0002022-09-09T00:00:00.000
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.

Query this from your own app

GET /api/datasets/8nfn-ifaj
GET /api/datasets/8nfn-ifaj/quality
GET /api/datasets/8nfn-ifaj/related
GET /api/columns?dataset=8nfn-ifaj
2014 Green Taxi Trip Data
0.89
joins onlpep_dropoff_datetimetolls_amounttip_amount+13
  • 2015 Green Taxi Trip Data0.87
    joins onlpep_dropoff_datetimetolls_amounttip_amount+14
  • 2016 Green Taxi Trip Data0.87
    joins onpulocationidlpep_dropoff_datetimetolls_amount+16
  • 2022 Yellow Taxi Trip Data0.84
    joins onpulocationidcongestion_surchargetolls_amount+13
  • 2019 Yellow Taxi Trip Data0.81
    joins onpulocationidcongestion_surchargetolls_amount+13
    • 2022-09-01T00:40:58.000
    2022-09-01T01:11:42.000
    N
    5.0
    93
    79
    3.0
    14.51
    65.0
    0.0
    0.0
    22022-09-01T00:03:27.0002022-09-01T00:08:31.000N1.01341342.01.015.50.50.5
    22022-09-01T00:31:17.0002022-09-01T00:35:20.000N1.071791.00.594.50.50.5
    22022-08-31T23:58:32.0002022-09-01T00:15:52.000N5.0932331.010.670.00.00.0
    22022-09-01T00:42:08.0002022-09-01T00:47:53.000N5.093702.02.0425.00.00.0
    22022-09-01T00:18:36.0002022-09-01T00:26:02.000N1.075241.01.737.50.50.5
    22022-09-01T00:09:50.0002022-09-01T00:16:13.000N1.02442432.01.116.00.50.5
    12022-09-01T00:00:54.0002022-09-01T00:44:17.000N5.0932312.016.295.00.00.0
    22022-09-01T00:18:37.0002022-09-01T00:41:17.000N5.0932302.010.6960.00.00.0

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

    11%
    NYof 2
    ratecodeidcategoricalThe final rate code in effect at the end of the trip.11%1.05.02.0of 7
    pulocationidintegerTLC Taxi Zone in which the taximeter was engaged0%747541
    dolocationidintegerTLC Taxi Zone in which the taximeter was disengaged0%747541
    passenger_countcategoricalThe number of passengers in the vehicle.11%1.02.05.0of 10
    trip_distancefloatThe elapsed trip distance in miles reported by the taximeter.0%0.01.41.3
    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%7.08.010.0
    extracategoricalMiscellaneous extras and surcharges.0%0.01.00.5of 19
    mta_taxcategoricalTax that is automatically triggered based on the metered rate in use.0%0.50.01.5of 11
    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.553.0
    ehail_feetextCurrently unused100%—
    improvement_surchargecategoricalImprovement surcharge assessed trips at the flag drop. The improvement surcharge began being levied in 2015.0%0.31.00.0of 5
    total_amountfloatThe total amount charged to passengers. Does not include cash tips.0%8.37.810.3
    payment_typecategoricalA numeric code signifying how the passenger paid for the trip.11%1.02.03.0of 5
    trip_typecategoricalA code indicating whether the trip was a street-hail or a dispatch that is automatically assigned based on the metered rate in use but can be altered by the driver.11%1.02.0of 2
    congestion_surchargecategoricalTotal amount collected in trip for NYS congestion surcharge.11%0.02.752.5of 5