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

2013 Green Taxi Trip Data

ghpb-fpeaTransportation20 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.0 / 100

From a 500-row sample across 19 columns.

completeness95/ 25% weight
consistency53/ 20% weight
accuracy94/ 20% weight
timeliness6/ 15% weight
usability100/ 20% weight
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • 2015 Green Taxi Trip Data0.93
    joins ontolls_amountmta_taxratecodeid+17
  • 2016 Green Taxi Trip Data0.89
    joins ontolls_amountmta_taxratecodeid+17
  • 2022 Yellow Taxi Trip Data0.81
    joins ontolls_amountmta_taxratecodeid+9
  • 2019 Yellow Taxi Trip Data0.78

Sample rows

vendoridlpep_pickup_datetimelpep_dropoff_datetimestore_and_fwd_flagratecodeiddropoff_latitudepassenger_counttrip_distancefare_amountextramta_taxtip_amount
22013-09-23T10:52:00.0002013-09-23T10:52:00.000N10101.8000.25
12013-11-09T00:55:29.000

Columns

20 queryable · 20 profiled

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

FieldTypeDescriptionNullValues
vendoridcategorical—0%21of 2
lpep_pickup_datetimedatetime—0%2013-10-22T12:40:36.0002013-10-02T23:08:00.0002013-10-02T23:17:00.000
lpep_dropoff_datetimedatetime—0%2013-10-22T12:43:33.0002013-10-02T23:08:09.0002013-10-02T23:22:54.000
store_and_fwd_flagcategorical—0%NYof 2

Query this from your own app

GET /api/datasets/ghpb-fpea
GET /api/datasets/ghpb-fpea/quality
GET /api/datasets/ghpb-fpea/related
GET /api/columns?dataset=ghpb-fpea
joins ontolls_amountmta_taxratecodeid+9
  • 2020 Yellow Taxi Trip Data0.77
    joins ontolls_amountmta_taxratecodeid+9
  • 2021 Yellow Taxi Trip Data0.77
    joins ontolls_amountmta_taxratecodeid+9
  • 2017 Yellow Taxi Trip Data0.77
    joins ontolls_amountmta_taxratecodeid+9
  • 2018 Yellow Taxi Trip Data0.76
    joins ontolls_amountmta_taxratecodeid+9
  • 2013-11-09T00:55:29.000
    N
    1
    0
    1
    0
    0
    0
    0
    0
    22013-09-17T21:45:09.0002013-09-17T21:52:20.000N40108.500.50
    22013-10-02T23:17:00.0002013-10-02T23:22:54.000N10102.800.50
    22013-10-02T23:17:00.0002013-10-02T23:22:54.000N10102.800.50
    22013-10-02T23:17:00.0002013-10-02T23:22:54.000N10102.800.50
    22013-10-02T23:17:00.0002013-10-02T23:22:54.000N10102.800.50
    22013-10-02T23:17:00.0002013-10-02T23:22:54.000N10102.800.50
    22013-10-02T23:17:00.0002013-10-02T23:22:54.000N10102.800.50
    22013-10-02T23:17:00.0002013-10-02T23:22:54.000N10102.800.50

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

    ratecodeidcategorical—0%152of 7
    dropoff_latitudefloat—0%040.75807571411132840.758186340332031
    passenger_countcategorical—0%152of 10
    trip_distancefloat—0%010.9
    fare_amountfloat—0%66.55.5
    extrafloat—0%00.51
    mta_taxcategorical—0%0.500.25of 10
    tip_amountfloat—0%012
    tolls_amountfloat—0%05.332.44
    ehail_feenumeric—100%—
    total_amountfloat—0%786.5
    payment_typecategorical—0%213of 4
    trip_typeinteger—99%1of 1
    pickup_longitudefloat—0%0-73.844268798828125-73.844276428222656
    pickup_latitudefloat—0%040.72133636474609440.721328735351562
    dropoff_longitudefloat—0%0-73.937301635742188-73.939071655273437