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

2021 Green Taxi Trip Data

djnb-wcxtTransportation20 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

  • 2015 Green Taxi Trip Data0.90
    joins ontolls_amounttrip_typeehail_fee+14
  • 2016 Green Taxi Trip Data0.88
    joins ontolls_amounttrip_typeehail_fee+16
  • 2022 Yellow Taxi Trip Data0.86
    joins oncongestion_surchargetolls_amountstore_and_fwd_flag+13
  • 2021 Yellow Taxi Trip Data0.83

Sample rows

vendoridlpep_pickup_datetimelpep_dropoff_datetimestore_and_fwd_flagratecodeidpulocationiddolocationidpassenger_counttrip_distancefare_amountextramta_tax
22021-01-01T00:15:56.0002021-01-01T00:19:52.000N14315111.015.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.23%215of 3
lpep_pickup_datetimedatetimeThe date and time when the meter was engaged.0%2021-08-11T12:37:00.0002021-09-02T11:40:00.0002021-02-05T10:43:00.000
lpep_dropoff_datetimedatetimeThe date and time when the meter was disengaged.0%2021-12-19T00:00:00.0002021-11-06T00:00:00.0002021-01-14T09:58: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/djnb-wcxt
GET /api/datasets/djnb-wcxt/quality
GET /api/datasets/djnb-wcxt/related
GET /api/columns?dataset=djnb-wcxt
joins oncongestion_surchargetolls_amountstore_and_fwd_flag+13
  • 2019 Yellow Taxi Trip Data0.83
    joins oncongestion_surchargetolls_amountstore_and_fwd_flag+13
  • 2020 Yellow Taxi Trip Data0.82
    joins oncongestion_surchargetolls_amountstore_and_fwd_flag+13
  • 2017 Yellow Taxi Trip Data0.80
    joins ontolls_amountstore_and_fwd_flagpulocationid+12
  • 2018 Yellow Taxi Trip Data0.79
    joins ontolls_amountstore_and_fwd_flagpulocationid+12
    • 2021-01-01T00:25:59.000
    2021-01-01T00:34:44.000
    N
    1
    166
    239
    1
    2.53
    10
    0.5
    0.5
    22021-01-01T00:45:57.0002021-01-01T00:51:55.000N1414211.1260.50.5
    22020-12-31T23:57:51.0002021-01-01T00:04:56.000N11687511.9980.50.5
    22021-01-01T00:16:36.0002021-01-01T00:16:40.000N226526530.00-520-0.5
    22021-01-01T00:16:36.0002021-01-01T00:16:40.000N226526530.005200.5
    22021-01-01T00:19:14.0002021-01-01T00:19:21.000N526526510.0018000
    22021-01-01T00:26:31.0002021-01-01T00:28:50.000N1757560.453.50.50.5
    22021-01-01T00:57:46.0002021-01-01T00:57:57.000N122522510.002.50.50.5
    22021-01-01T00:58:32.0002021-01-01T01:32:34.000N1225265112.19380.50.5

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

    39%
    NYof 2
    ratecodeidcategoricalThe final rate code in effect at the end of the trip.39%152of 7
    pulocationidintegerTLC Taxi Zone in which the taximeter was engaged0%747541
    dolocationidintegerTLC Taxi Zone in which the taximeter was disengaged0%747542
    passenger_countcategoricalThe number of passengers in the vehicle39%125of 12
    trip_distancefloatThe elapsed trip distance in miles reported by the taximeter.0%0.001.401.30
    fare_amountfloatThe time-and-distance fare calculated by the meter.0%76.58
    extrafloatMiscellaneous extras and surcharges. Currently, this only includes the $0.50 and $1 rush hour and overnight charges.0%02.751
    mta_taxcategoricalTax that is automatically triggered based on the metered rate in use.0%0.50-0.5of 6
    tip_amountfloatTip amount – This field is automatically populated for credit card tips. Cash tips are not included.0%02.752
    tolls_amountfloatTotal amount of all tolls paid in trip.0%06.556.12
    ehail_feetext—100%—
    improvement_surchargecategorical$0.30 improvement surcharge assessed trips at the flag drop. The improvement surcharge began being levied in 2015.0%0.30-0.3of 3
    total_amountfloatThe total amount charged to passengers. Does not include cash tips.0%8.37.87.3
    payment_typecategoricalA numeric code signifying how the passenger paid for the trip.39%123of 5
    trip_typecategorical—39%12of 2
    congestion_surchargecategorical—39%02.752.5of 5