Datadory notebook

How Competitive Intel Product Teams Use Passenger Ground Transportation Data

Competitive intelligence product teams use passenger ground transportation data to track Uber, Lyft and Via trip volumes and fares in Chicago's mandated TNP filings, document platform-versus-cab share across 258 NYC TLC zones, catch operator changes in 7,207 UK BODS timetables, and benchmark demand with NTD ridership - all 14 cataloged datasets are free.

1,744 datasets. Pick your catch.

Where can you document ride-hail disruption trip by trip?

Because each class ships separately, platform-versus-cab share is arithmetic: divide HVFHV trips by yellow trips in the same month and zone, and you have a defensible disruption curve built from primary records rather than vendor estimates. Two cautions shape the alerting window - files land monthly, and the newest months are the slowest to settle, so baseline against a trailing three-month average before calling a shift.

How do you turn transit feeds into service-change alerts?

Transit agencies move faster than their press offices, and their feeds double as demand telemetry for any mobility product competing for the same riders.

The National Transit Database is the peer benchmark underneath them: roughly 370,000 agency-by-mode-by-month rows across 834 NTD IDs since January 2002, refreshed weekly and carrying unlinked passenger trips, vehicle revenue miles, hours and peak vehicles in the commercial delivery terms. It is what tells you whether a rival's claimed ridership surge is execution or simply the market moving.

Can you catch a market entrant before the press release?

Entry signals surface in registries first, and three of them cover the ground transport map.

How do you separate a rival's gain from a market-wide shift?

Every operational signal above needs a demand denominator, and four slower sources supply it.

American Community Survey - Journey to Work / Commuting Data gives the structural baseline: Table B08301 mode shares splitting workers into drove alone, carpool, transit, walk, bike and worked from home, plus county-to-county worker flow tables that size catchments precisely. Five-year estimates reach block groups - roughly 85,000 tract geographies - while one-year estimates cover populations of 65,000 and up; releases run annually since 2005, currently the 2024 1-year and 2020-2024 5-year files, all commercial delivery terms.

National Household Travel Survey (NHTS) microdata adds behaviour: the 2022 wave's public-use core carries 31,074 trip records with full survey weights in a csv.zip of about 4.5 MB, downloadable with no registration, and waves reach back to 1969 for mode-choice trendlines. It is static, so treat it as calibration rather than monitoring.

What does a five-step competitor-tracking stack look like?

Ranked by how soon each step pays off, using only the sources named above:

  1. Diff fares where they are legal to diff - query the Chicago TNP tables anonymously over SODA, comparing fare-per-mile and shared-trip mix by platform across the 2018-2022, 2023-2024 and 2025-plus tables.
  1. Wire service-change alerts - poll the TfL Unified API within its 500 calls-per-minute allowance, diff BODS timetable registrations, and watch Mobility Database merges for new agency feeds.
  1. Normalize against demand - benchmark every anomaly against NTD monthly peers, MTA and CTA daily boards, ACS commuting flows and Eurostat modal split before briefing anyone.

Where to go next

This cluster is the competitive-intelligence angle on the industry. For the dataset-by-dataset treatment, read the passenger-ground-transportation data guide; for the same evidence base as a ranked shortlist, open the passenger ground transportation data for competitive intel product teams page. The industry hub ties together the best-of, free-list and API pages, and the persona hub collects every vertical covered for this team.

Pick up where this leaves off

Every one of these ships with sample rows before you commit to anything.

Passenger Ground Transportation City of Chicago plus surrounding region

Chicago Transportation Network Providers Trips (Uber/Lyft/Via)

fare · tip · additional_charges …+4 more

Passenger Ground Transportation City of Chicago plus surrounding region

Chicago Taxi Trips

pickup_community_area · dropoff_community_area · payment_type …+1 more

Passenger Ground Transportation New York City, coded as TLC Taxi Zones (258 zones) plus…

NYC TLC Trip Record Data (Yellow/Green Taxi & FHV/HVFHV Uber/Lyft)

PULocationID · DOLocationID · payment_type …+7 more

Passenger Ground Transportation Greater London and surrounding TfL service area

TfL Open Data & Unified API

naptanId · stationName · lineId …+6 more

Passenger Ground Transportation Metropolitan Transportation Authority service region: New York…

MTA Daily Ridership Data: Beginning 2020

Passenger Ground Transportation City of Chicago and the CTA service area across Cook County…

CTA Ridership - Daily Boarding Totals

service_date · day_type · bus …+2 more

Want rows instead of a pitch? Name the datasets.

API, files, or your warehouse. Daily, weekly, or hourly.

Get a sample

Questions worth asking

How do I measure taxi versus ride-hail share shifts?

Run two markets side by side. NYC TLC publishes yellow cab trips back to January 2009 and high-volume for-hire trips from February 2019 across 258 zones, and Chicago Taxi Trips logs roughly 1.7 billion cab trips for 2013-2023 against TNP tables covering November 2018 onward.

Which source signals a new transit operator first?

The Mobility Database. Community pull requests merge roughly one to three times a month, adding newly launched feeds to a commercial delivery terms catalog of 6,487 GTFS Schedule and GTFS-Realtime feeds across 94 countries, usually before trade press notices. BODS provides the equivalent UK bus registry with 7,207 timetables.