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

Pickups and Drop-offs by Taxi Zone and Industry

c5iv-bn4sTransportation7 columns
These records are generated from trip record submissions made by FHV - High Volume companies and green and yellow taxi Technology Service Providers. This dataset aggregates the trip records to monthly pickup and drop-off counts for different TLC-regulated industries (FHV - High Volume, Green Cab, Yellow Taxi) by taxi zone. It is designed to make this information accessible to a wider audience, including those without the technical expertise to work with raw trip record data.
View on NYC Open Data↗

Quality

A95.3 / 100

From a 500-row sample across 7 columns.

completeness100/ 25% weight
consistency79/ 20% weight
accuracy99/ 20% weight
timeliness99/ 15% weight
usability100/ 20% weight
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • TLC Industry Indicators0.40
  • Taxi and For Hire Vehicle (FHV) Relief Stands0.34
    joins onborough
  • FHV Base Aggregate Report0.33
  • 2009 Yellow Taxi Trip Data0.33
  • 2024 Yellow Taxi Trip Data0.32
  • 2013 Yellow Taxi Trip Data0.32
  • For Hire Vehicles (FHV) - Active Drivers0.31

Geography

Has borough codes (`borough`) — joinable, but needs boundary shapes to draw.

Sample rows

metric_monthindustrypickup_dropofflocationidboroughzonetrip_count
2026-08-01FHV - High VolumeDrop-off1EWRNewark Airport148979
2026-08-01FHV - High VolumeDrop-off2QueensJamaica Bay77
2026-08-01FHV - High VolumePick-up2

Columns

7 queryable · 7 profiled

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

FieldTypeDescriptionNullValues
metric_monthdateThe year and month of the report0%2019-09-012021-10-012019-10-01
industrycategoricalThe broad license class used to describe the industry0%FHV - High VolumeYellow TaxiGreen Cabof 3
pickup_dropoffcategoricalWhether the counts reflect pickups or drop-offs0%Drop-offPick-upof 2
locationidintegerTaxi zone number0%323328

Query this from your own app

GET /api/datasets/c5iv-bn4s
GET /api/datasets/c5iv-bn4s/quality
GET /api/datasets/c5iv-bn4s/related
GET /api/columns?dataset=c5iv-bn4s
2025 Yellow Taxi Trip Data
0.31
Queens
Jamaica Bay
89
2026-08-01FHV - High VolumeDrop-off3BronxAllerton/Pelham Gardens47930
2026-08-01FHV - High VolumePick-up3BronxAllerton/Pelham Gardens49806
2026-08-01FHV - High VolumeDrop-off4ManhattanAlphabet City45650
2026-08-01FHV - High VolumePick-up4ManhattanAlphabet City53056
2026-08-01FHV - High VolumeDrop-off5Staten IslandArden Heights5790
2026-08-01FHV - High VolumePick-up5Staten IslandArden Heights6078
2026-08-01FHV - High VolumeDrop-off6Staten IslandArrochar/Fort Wadsworth13307
boroughcategoricalNYC borough0%QueensManhattanBrooklynof 8
zonetextTaxi zone name0%CoronaBrooklyn HeightsBedford Park
trip_countintegerCount of trips0%123