Public Transit Accessibility Tracker

This dataset provides a detailed record of public transit accessibility upgrades and gaps for underserved communities, including information on nonprofit collaborations, smart city initiatives, and compliance status. It enables planners and analysts to monitor progress, assess impact, and identify areas needing further improvement, supporting data-driven decision making for equitable transportation access.

  • last updated 13 Dec 2025
  • by GoMask
The brief that made it

Track and analyze accessibility improvements for underserved communities

Sample rows

preview · 8 of 85 rows · all 27 columns
accessibility_upgrade_idstringupgrade_typestringestimated_costfloatgovernment_agency_namestringtransit_stop_idstringtransit_stop_namestringtransit_stop_typestringaddress_streetstringaddress_citystringaddress_statestringaddress_postal_codestringaddress_countrystringcommunity_idstringcommunity_namestringcommunity_typestringupgrade_statusstringdate_reporteddatedate_completeddateimpact_scorefloatcompliance_statusstringnonprofit_partner_idstringnonprofit_partner_namestringsmart_city_initiative_idstringsmart_city_initiative_namestringgovernment_agency_idstringfunding_sourcestringupgrade_descriptionstring
AUG-10001elevator145000Springfield Transit AuthorityTS-2001Main St Bus Terminalbus101 Main StSpringfieldIL62701USAC-3001Eastside Seniorsseniorcompleted2023-03-122023-05-010.88compliantNP-4001Access Mobility FoundationSCI-5001Springfield Smart TransitGA-6001cityInstalled elevator for wheelchair access.
AUG-10002ramp78000Springfield Transit AuthorityTS-2002Jefferson Subway Stationsubway200 Jefferson AveSpringfieldIL62702USAC-3002Northside Residentslow-incomein-progress2023-06-20blank0.74pendingNP-4002Transit for AllSCI-5001Springfield Smart TransitGA-6001stateRamp under construction at main entrance.
AUG-10003audio-assistance23000Riverside Transportation BureauTS-2003Lincoln Ferry Terminalferry500 River RdRiversideMO64150USAC-3003Riverside Disableddisabledcompleted2022-11-012022-12-150.93compliantNP-4003Voices for InclusionSCI-5002Riverside MobilityGA-6002federalInstalled audio guides for visually impaired.
AUG-10004signage16000Lakeview Transit AgencyTS-2004Central Tram Depottram12 Depot StLakeviewIL60657USAC-3004Lakeview Minoritiesminorityplanned2023-12-10blank0.61pendingblankblankSCI-5003Lakeview InclusionGA-6003cityBraille and multilingual signage scheduled.
AUG-10005gapblankSpringfield Transit AuthorityTS-2005Westside Train Stationtrain99 Rail AveSpringfieldIL62704USAC-3005Westside Familieslow-incomegap-identified2024-01-09blank0.35non-compliantblankblankblankblankGA-6001federalNo wheelchair access at platform.
AUG-10006ramp39000Riverside Transportation BureauTS-2006Market St Bus Shelterbus400 Market StRiversideMO64151USAC-3003Riverside Disableddisabledcompleted2023-07-022023-09-110.85compliantblankblankSCI-5002Riverside MobilityGA-6002stateRamp added to shelter entrance.
AUG-10007elevator142000Lakeview Transit AgencyTS-2007Roosevelt Tram Stoptram45 Roosevelt BlvdLakeviewIL60658USAC-3004Lakeview Minoritiesminorityplanned2023-12-17blank0.67pendingNP-4004Inclusive CitiesSCI-5003Lakeview InclusionGA-6003privateElevator installation for accessibility.
AUG-10008signage12000Baytown Urban TransitTS-2008Harbor Ferry Pierferry11 Pier StBaytownCA94017USAC-3006Baytown Seniorsseniorcompleted2022-08-102022-09-200.78compliantNP-4005Better MobilitySCI-5004Baytown Smart AccessGA-6004cityLarge-print signage installed at entrance.

What the 85 rows show

from the 85-row sample

Elevator (upgrade type) stands out: mean estimated_cost is 176,700, against 33,096 for the rest.

  • 37,000median estimated_cost
  • 3compliance statuses
  • 4address states
  • 4community types
  • 4upgrade statuses
  • 5transit stop types
Mean estimated_cost by upgrade_type69 rows
0100k200k57,658ramp19 rows176.7kelevator15 rows10,844signage18 rows29,206audio-as…17 rows
estimated_cost69 rows, in bands of 50k
025504114633020200k350kestimated_cost →

Median 37,000, from 7,800 to 320,001.

government_agency_name85 rows · top 10 of 37 values
  1. Springfield Transit Authority18
  2. Riverside Transportation Bureau9
  3. Lakeview Transit Agency8
  4. Baytown Urban Transit8
  5. MBTA7
  6. Worcester Transit2
  7. Lowell Transit2
  8. Framingham Bus2
  9. Boston Harbor Commission1
  10. Quincy Transit1
27 columns by typefrom the column list below
  • string 23
  • float 2
  • date 2

Columns

27 columns in three groups
blueprint · 27 columns
columntypedescriptionexample
Text 23 columns
accessibility_upgrade_idstringUnique identifier for each recorded accessibility upgrade or gapuniqueAUG-10001
transit_stop_idstringUnique identifier for the public transit stop or stationTS-2001
transit_stop_namestringOfficial name of the transit stop or stationMain St Bus Terminal
transit_stop_typestringType of transit stop (e.g., bus, subway, tram, train)6 valuesbus
address_streetstringStreet address of the transit stop101 Main St
address_citystringCity where the transit stop is locatedSpringfield
address_statestringState or province of the transit stop4 statesIL
address_postal_codestringPostal code of the transit stop62701
address_countrystringCountry of the transit stopUSA
community_idstringUnique identifier for the underserved community served by the transit stopC-3001
community_namestringName of the underserved communityEastside Seniors
community_typestringType of community (e.g., low-income, senior, disabled, minority)low-income · senior · disabled · minority · othersenior
upgrade_typestringType of accessibility upgrade or gap (e.g., ramp installation, elevator, signage, audio assistance, gap)6 valueselevator
upgrade_statusstringCurrent status of the upgrade or gap (e.g., planned, in-progress, completed, gap-identified)planned · in-progress · completed · gap-identifiedcompleted
upgrade_descriptionstringDetailed description of the upgrade or gapoptionalInstalled elevator for wh…
compliance_statusstringAccessibility compliance status (e.g., compliant, non-compliant, pending)compliant · non-compliant · pendingcompliant
nonprofit_partner_idstringUnique identifier for the nonprofit partner involved (if any)optionalNP-4001
nonprofit_partner_namestringName of the nonprofit partner organizationoptionalTransit for All
smart_city_initiative_idstringUnique identifier for the smart city initiative related to the upgradeoptionalSCI-5001
smart_city_initiative_namestringName of the smart city initiativeoptionalRiverside Mobility
government_agency_idstringUnique identifier for the government agency responsibleoptionalGA-6001
government_agency_namestringName of the government agency responsibleoptionalLakeview Transit Agency
funding_sourcestringPrimary source of funding for the upgrade (e.g., city, state, federal, nonprofit, private)6 values · optionalcity
Numbers 2 columns
impact_scorefloatEstimated impact score (0-1) of the upgrade for the community0 to 1 · optional0.88
estimated_costfloatEstimated cost of the upgrade in local currency0 or more · optional145000
Dates and times 2 columns
date_reporteddateDate when the upgrade or gap was reported2023-03-12
date_completeddateDate when the upgrade was completed (null if not completed)optional2023-05-01

Use it for

  • median estimat…37,00069 rowsmean estimated cost b…57.7kramp176.7kelev…10.8ksign…29.2kaudi…

    A transportation dashboard

    Estimated_cost by upgrade_type and a breakdown of government_agency_name. Excel, Power BI or Tableau.

  • Why do the 15 elevator rows have a mean estimated_cost of 176,700?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable accessibility upgrades with transit_stop_id, transit_stop_name and transit_stop_type to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 27 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset85 rows27 columns
Yours1,000 rows27 columnsaddress_street: UK only

blueprint · public-transit-accessibility-tracker

Behind this dataset

Same schema. As many rows as you need.

These 85 rows came out of a blueprint — 27 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Each record must reference a specific transit stop or route.
  • Accessibility improvements must be tagged as physical, digital, or service-based.
  • Nonprofit involvement is logged with project IDs and collaboration type.
  • Impact metrics include rider count change and community feedback score.
  • Compliance status is flagged based on local accessibility regulations.
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
public-transit-accessibility-tracker

What should your data show?

Preview 20 rows free
No signup. No card.