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.
Sample rows
preview · 8 of 85 rows · all 27 columns| accessibility_upgrade_idstring | upgrade_typestring | estimated_costfloat | government_agency_namestring | transit_stop_idstring | transit_stop_namestring | transit_stop_typestring | address_streetstring | address_citystring | address_statestring | address_postal_codestring | address_countrystring | community_idstring | community_namestring | community_typestring | upgrade_statusstring | date_reporteddate | date_completeddate | impact_scorefloat | compliance_statusstring | nonprofit_partner_idstring | nonprofit_partner_namestring | smart_city_initiative_idstring | smart_city_initiative_namestring | government_agency_idstring | funding_sourcestring | upgrade_descriptionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AUG-10001 | elevator | 145000 | Springfield Transit Authority | TS-2001 | Main St Bus Terminal | bus | 101 Main St | Springfield | IL | 62701 | USA | C-3001 | Eastside Seniors | senior | completed | 2023-03-12 | 2023-05-01 | 0.88 | compliant | NP-4001 | Access Mobility Foundation | SCI-5001 | Springfield Smart Transit | GA-6001 | city | Installed elevator for wheelchair access. |
| AUG-10002 | ramp | 78000 | Springfield Transit Authority | TS-2002 | Jefferson Subway Station | subway | 200 Jefferson Ave | Springfield | IL | 62702 | USA | C-3002 | Northside Residents | low-income | in-progress | 2023-06-20 | blank | 0.74 | pending | NP-4002 | Transit for All | SCI-5001 | Springfield Smart Transit | GA-6001 | state | Ramp under construction at main entrance. |
| AUG-10003 | audio-assistance | 23000 | Riverside Transportation Bureau | TS-2003 | Lincoln Ferry Terminal | ferry | 500 River Rd | Riverside | MO | 64150 | USA | C-3003 | Riverside Disabled | disabled | completed | 2022-11-01 | 2022-12-15 | 0.93 | compliant | NP-4003 | Voices for Inclusion | SCI-5002 | Riverside Mobility | GA-6002 | federal | Installed audio guides for visually impaired. |
| AUG-10004 | signage | 16000 | Lakeview Transit Agency | TS-2004 | Central Tram Depot | tram | 12 Depot St | Lakeview | IL | 60657 | USA | C-3004 | Lakeview Minorities | minority | planned | 2023-12-10 | blank | 0.61 | pending | blank | blank | SCI-5003 | Lakeview Inclusion | GA-6003 | city | Braille and multilingual signage scheduled. |
| AUG-10005 | gap | blank | Springfield Transit Authority | TS-2005 | Westside Train Station | train | 99 Rail Ave | Springfield | IL | 62704 | USA | C-3005 | Westside Families | low-income | gap-identified | 2024-01-09 | blank | 0.35 | non-compliant | blank | blank | blank | blank | GA-6001 | federal | No wheelchair access at platform. |
| AUG-10006 | ramp | 39000 | Riverside Transportation Bureau | TS-2006 | Market St Bus Shelter | bus | 400 Market St | Riverside | MO | 64151 | USA | C-3003 | Riverside Disabled | disabled | completed | 2023-07-02 | 2023-09-11 | 0.85 | compliant | blank | blank | SCI-5002 | Riverside Mobility | GA-6002 | state | Ramp added to shelter entrance. |
| AUG-10007 | elevator | 142000 | Lakeview Transit Agency | TS-2007 | Roosevelt Tram Stop | tram | 45 Roosevelt Blvd | Lakeview | IL | 60658 | USA | C-3004 | Lakeview Minorities | minority | planned | 2023-12-17 | blank | 0.67 | pending | NP-4004 | Inclusive Cities | SCI-5003 | Lakeview Inclusion | GA-6003 | private | Elevator installation for accessibility. |
| AUG-10008 | signage | 12000 | Baytown Urban Transit | TS-2008 | Harbor Ferry Pier | ferry | 11 Pier St | Baytown | CA | 94017 | USA | C-3006 | Baytown Seniors | senior | completed | 2022-08-10 | 2022-09-20 | 0.78 | compliant | NP-4005 | Better Mobility | SCI-5004 | Baytown Smart Access | GA-6004 | city | Large-print signage installed at entrance. |
| AUG-10009 | gap | blank | Springfield Transit Authority | TS-2009 | Oak St Subway Entrance | subway | 67 Oak St | Springfield | IL | 62705 | USA | C-3002 | Northside Residents | low-income | gap-identified | 2024-02-05 | blank | 0.22 | non-compliant | blank | blank | blank | blank | GA-6001 | state | Gap identified: No audio announcements for arrivals. |
| AUG-10010 | audio-assistance | 21000 | Lakeview Transit Agency | TS-2010 | Elm St Bus Stop | bus | 801 Elm St | Lakeview | IL | 60659 | USA | C-3004 | Lakeview Minorities | minority | completed | 2023-02-18 | 2023-03-25 | 0.79 | compliant | NP-4004 | Inclusive Cities | SCI-5003 | Lakeview Inclusion | GA-6003 | nonprofit | Installed audio assistance for announcements. |
| AUG-10011 | ramp | 82000 | Springfield Transit Authority | TS-2011 | Broadway Train Station | train | 102 Broadway | Springfield | IL | 62706 | USA | C-3005 | Westside Families | low-income | in-progress | 2023-10-03 | blank | 0.56 | pending | NP-4002 | Transit for All | blank | blank | GA-6001 | city | Ramp construction started on east platform. |
| AUG-10012 | signage | 15500 | Baytown Urban Transit | TS-2012 | Central Ferry Terminal | ferry | 300 Dock Rd | Baytown | CA | 94018 | USA | C-3006 | Baytown Seniors | senior | planned | 2024-03-11 | blank | 0.53 | pending | NP-4005 | Better Mobility | SCI-5004 | Baytown Smart Access | GA-6004 | federal | Multilingual signage for senior community. |
| AUG-10013 | elevator | 99000 | Springfield Transit Authority | TS-2013 | Green St Subway | subway | 900 Green St | Springfield | IL | 62707 | USA | C-3002 | Northside Residents | low-income | planned | 2024-02-19 | blank | 0.71 | pending | blank | blank | SCI-5001 | Springfield Smart Transit | GA-6001 | private | Elevator planned for south entrance. |
| AUG-10014 | gap | blank | Lakeview Transit Agency | TS-2014 | Sunset Bus Shelter | bus | 400 Sunset Blvd | Lakeview | IL | 60660 | USA | C-3004 | Lakeview Minorities | minority | gap-identified | 2024-01-28 | blank | 0.19 | non-compliant | blank | blank | blank | blank | GA-6003 | city | No tactile paving for the visually impaired. |
| AUG-10015 | ramp | 32000 | Riverside Transportation Bureau | TS-2015 | Forest Park Tram | tram | 150 Forest Dr | Riverside | MO | 64152 | USA | C-3003 | Riverside Disabled | disabled | completed | 2023-03-30 | 2023-05-12 | 0.81 | compliant | NP-4003 | Voices for Inclusion | SCI-5002 | Riverside Mobility | GA-6002 | state | Ramp installed at tram entry. |
| AUG-10016 | audio-assistance | 18000 | Baytown Urban Transit | TS-2016 | Bayfront Ferry Dock | ferry | 700 Bayfront Rd | Baytown | CA | 94019 | USA | C-3006 | Baytown Seniors | senior | completed | 2022-07-21 | 2022-08-15 | 0.83 | compliant | NP-4005 | Better Mobility | SCI-5004 | Baytown Smart Access | GA-6004 | federal | Audio announcements implemented for dock area. |
| AUG-10017 | signage | 14000 | Springfield Transit Authority | TS-2017 | Cedar St Train | train | 100 Cedar St | Springfield | IL | 62708 | USA | C-3005 | Westside Families | low-income | in-progress | 2023-08-12 | blank | 0.48 | pending | blank | blank | SCI-5001 | Springfield Smart Transit | GA-6001 | city | Installing signage for improved accessibility. |
| AUG-10018 | elevator | 120000 | Lakeview Transit Agency | TS-2018 | Liberty Plaza Bus | bus | 10 Liberty Pl | Lakeview | IL | 60661 | USA | C-3004 | Lakeview Minorities | minority | planned | 2024-03-03 | blank | 0.65 | pending | blank | blank | SCI-5003 | Lakeview Inclusion | GA-6003 | private | Elevator planned for platform access. |
| AUG-10019 | audio-assistance | 25000 | Riverside Transportation Bureau | TS-2019 | Ocean Blvd Tram | tram | 350 Ocean Blvd | Riverside | MO | 64154 | USA | C-3003 | Riverside Disabled | disabled | in-progress | 2023-09-06 | blank | 0.76 | pending | NP-4003 | Voices for Inclusion | SCI-5002 | Riverside Mobility | GA-6002 | state | Audio assistance installation ongoing. |
| AUG-10020 | gap | blank | Springfield Transit Authority | TS-2020 | Pine St Bus Terminal | bus | 900 Pine St | Springfield | IL | 62709 | USA | C-3001 | Eastside Seniors | senior | gap-identified | 2024-01-14 | blank | 0.27 | non-compliant | blank | blank | blank | blank | GA-6001 | federal | Gap: No accessible entrance. |
What the 85 rows show
from the 85-row sampleElevator (upgrade type) stands out: mean estimated_
- 37,000median estimated_
cost - 3compliance statuses
- 4address states
- 4community types
- 4upgrade statuses
- 5transit stop types
Median 37,000, from 7,800 to 320,001.
- string 23
- float 2
- date 2
Columns
27 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 23 columns | |||
accessibility_upgrade_id | string | Unique identifier for each recorded accessibility upgrade or gapunique | AUG-10001 |
transit_stop_id | string | Unique identifier for the public transit stop or station | TS-2001 |
transit_stop_name | string | Official name of the transit stop or station | Main St Bus Terminal |
transit_stop_type | string | Type of transit stop (e.g., bus, subway, tram, train)6 values | bus |
address_street | string | Street address of the transit stop | 101 Main St |
address_city | string | City where the transit stop is located | Springfield |
address_state | string | State or province of the transit stop4 states | IL |
address_postal_code | string | Postal code of the transit stop | 62701 |
address_country | string | Country of the transit stop | USA |
community_id | string | Unique identifier for the underserved community served by the transit stop | C-3001 |
community_name | string | Name of the underserved community | Eastside Seniors |
community_type | string | Type of community (e.g., low-income, senior, disabled, minority)low-income · senior · disabled · minority · other | senior |
upgrade_type | string | Type of accessibility upgrade or gap (e.g., ramp installation, elevator, signage, audio assistance, gap)6 values | elevator |
upgrade_status | string | Current status of the upgrade or gap (e.g., planned, in-progress, completed, gap-identified)planned · in-progress · completed · gap-identified | completed |
upgrade_description | string | Detailed description of the upgrade or gapoptional | Installed elevator for wh… |
compliance_status | string | Accessibility compliance status (e.g., compliant, non-compliant, pending)compliant · non-compliant · pending | compliant |
nonprofit_partner_id | string | Unique identifier for the nonprofit partner involved (if any)optional | NP-4001 |
nonprofit_partner_name | string | Name of the nonprofit partner organizationoptional | Transit for All |
smart_city_initiative_id | string | Unique identifier for the smart city initiative related to the upgradeoptional | SCI-5001 |
smart_city_initiative_name | string | Name of the smart city initiativeoptional | Riverside Mobility |
government_agency_id | string | Unique identifier for the government agency responsibleoptional | GA-6001 |
government_agency_name | string | Name of the government agency responsibleoptional | Lakeview Transit Agency |
funding_source | string | Primary source of funding for the upgrade (e.g., city, state, federal, nonprofit, private)6 values · optional | city |
| Numbers 2 columns | |||
impact_score | float | Estimated impact score (0-1) of the upgrade for the community0 to 1 · optional | 0.88 |
estimated_cost | float | Estimated cost of the upgrade in local currency0 or more · optional | 145000 |
| Dates and times 2 columns | |||
date_reported | date | Date when the upgrade or gap was reported | 2023-03-12 |
date_completed | date | Date when the upgrade was completed (null if not completed)optional | 2023-05-01 |
Use it for
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.
- Accessibility upgrades85AUG-10001145000elevatorAUG-1000278000rampAUG-1000323000audio-as…
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.
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.
- 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.
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