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

2017 Green Taxi Trip Data

5gj9-2kzxTransportation19 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

C75.1 / 100

From a 500-row sample across 18 columns.

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

Related datasets

  • 2018 Green Taxi Trip Data0.97
    joins ontrip_typevendoridpayment_type+16
  • 2021 Green Taxi Trip Data0.96
    joins ontrip_typevendoridpayment_type+16
  • 2015 Green Taxi Trip Data0.91
    joins ontrip_typevendoridpayment_type+14
  • 2014 Green Taxi Trip Data

Sample rows

vendoridlpep_pickup_datetimelpep_dropoff_datetimestore_and_fwd_flagratecodeidpulocationiddolocationidpassenger_counttrip_distancefare_amountextramta_tax
22017-01-01T00:01:15.0002017-01-01T00:11:05.000N14216611.71900.5
22017-01-01T00:03:34.000

Columns

19 queryable · 19 profiled

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

FieldTypeDescriptionNullValues
vendoridcategorical—0%21of 2
lpep_pickup_datetimedatetime—0%2017-06-29T17:01:37.0002017-01-20T11:08:51.0002017-01-31T11:26:50.000
lpep_dropoff_datetimedatetime—0%2017-03-26T00:00:00.0002017-03-04T00:00:00.0002017-02-05T00:00:00.000
store_and_fwd_flagcategorical—0%NYof 2

Query this from your own app

GET /api/datasets/5gj9-2kzx
GET /api/datasets/5gj9-2kzx/quality
GET /api/datasets/5gj9-2kzx/related
GET /api/columns?dataset=5gj9-2kzx
0.91
joins ontrip_typevendoridpayment_type+13
  • 2016 Green Taxi Trip Data0.89
    joins ontrip_typevendoridpayment_type+16
  • 2022 Yellow Taxi Trip Data0.87
    joins onvendoridpayment_typetotal_amount+12
  • 2016 Yellow Taxi Trip Data0.85
    joins onvendoridpayment_typetotal_amount+12
  • 2015 Yellow Taxi Trip Data0.84
    joins onpayment_typetotal_amounttolls_amount+8
    • 2017-01-01T00:09:00.000
    N
    1
    75
    74
    1
    1.44
    6.5
    0.5
    0.5
    22017-01-01T00:04:02.0002017-01-01T00:12:55.000N1827053.45120.50.5
    22017-01-01T00:01:40.0002017-01-01T00:14:23.000N125523212.1110.50.50.5
    22017-01-01T00:00:51.0002017-01-01T00:18:55.000N116623912.7611.50.50.5
    22017-01-01T00:00:28.0002017-01-01T00:13:31.000N117922614.14150.50.5
    22017-01-01T00:02:39.0002017-01-01T00:26:28.000N17416714.22190.50.5
    22017-01-01T00:15:21.0002017-01-01T00:28:06.000N11123712.83110.50.5
    22017-01-01T00:06:49.0002017-01-01T00:11:57.000N1363710.7850.50.5
    22017-01-01T00:14:34.0002017-01-01T00:28:57.000N112717453.4913.50.50.5

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

    ratecodeidcategorical—0%152of 7
    pulocationidinteger—0%744175
    dolocationidinteger—0%74427
    passenger_countcategorical—0%125of 10
    trip_distancefloat—0%0.901.000.80
    fare_amountfloat—0%65.56.5
    extrafloat—0%00.51
    mta_taxcategorical—0%0.50-0.5of 6
    tip_amountfloat—0%012
    tolls_amountfloat—0%05.765.54
    ehail_feetext—100%—
    improvement_surchargecategorical—0%0.30-0.3of 3
    total_amountfloat—0%6.87.87.3
    payment_typecategorical—0%123of 5
    trip_typecategorical—0%12of 2