Data downloads
Stable CSVs, refreshed with each inventory vintage
United States Bridge Conditions2025 National Bridge Inventory, FHWACompiled
Every number on this site, as stable CSV downloads. Free to use with attribution; the underlying inventory is public domain.
bridge-conditions-by-state.csv
Good/Fair/Poor bridge counts per state, with poor percentage.
| Column | Meaning |
|---|---|
state | state name |
bridges | inventoried bridges |
good | |
fair | |
poor | |
poor_pct |
bridge-conditions-by-county.csv
Good/Fair/Poor bridge counts for every U.S. county.
| Column | Meaning |
|---|---|
state | |
county | |
bridges | |
good | |
fair | |
poor | |
poor_pct |
poor-bridges.csv
Every bridge rated poor in the current inventory: location, year built, traffic, and component ratings.
| Column | Meaning |
|---|---|
state | |
county | |
structure_number | NBI id |
facility | road carried |
feature | what it crosses |
year_built | |
adt | avg daily traffic |
deck | rating 0-9 |
superstructure | |
substructure | |
culvert | |
lat | |
lon |
closed-and-posted-bridges.csv
Every bridge coded closed, posted for load, or open on temporary measures (NBI item 41).
| Column | Meaning |
|---|---|
state | |
county | |
structure_number | NBI id |
facility | road carried |
feature | what it crosses |
status_code | NBI item 41 |
status | coding-guide meaning |
year_built | |
adt | avg daily traffic |
condition | G/F/P |
last_inspection | YYYY-MM |
permalink | this site's page |
condition-changes-2024-2025.csv
Every bridge whose condition class, component ratings, or open/posted/closed status changed between the 2024 and 2025 inventories (matched by state + structure number).
| Column | Meaning |
|---|---|
state | |
county | |
structure_number | NBI id |
facility | |
feature | |
adt | |
condition_2024 | G/F/P |
condition_2025 | G/F/P |
deck_2024 | |
deck_2025 | |
superstructure_2024 | |
superstructure_2025 | |
substructure_2024 | |
substructure_2025 | |
culvert_2024 | |
culvert_2025 | |
status_2024 | item 41 |
status_2025 | item 41 |
direction | worse / better / mixed |
permalink |
Every bridge, one CSV per state
The complete 2025 inventory for each state - every bridge, all conditions - with the fields this site renders and a permalink column. Files are named bridges-<state>.csv:
AL · AK · AZ · AR · CA · CO · CT · DE · DC · FL · GA · HI · ID · IL · IN · IA · KS · KY · LA · ME · MD · MA · MI · MN · MS · MO · MT · NE · NV · NH · NJ · NM · NY · NC · ND · OH · OK · OR · PA · PR · RI · SC · SD · TN · TX · UT · VT · VA · WA · WV · WI · WY
| Column | Meaning |
|---|---|
state | |
county | |
structure_number | NBI id |
facility | road carried |
feature | what it crosses |
location | inventory location text |
year_built | |
year_reconstructed | |
adt | avg daily traffic |
adt_year | traffic count year |
condition | G/F/P, FHWA computed |
deck | rating 0-9 |
superstructure | |
substructure | |
culvert | |
structure_kind | NBI item 43A code |
structure_type | NBI item 43B code |
length_m | structure length, metres |
owner_code | NBI item 22 |
lat | |
lon | |
permalink | this site's page |
status_code | NBI item 41: A open, P/R posted, K closed, B/D/E temporary |
last_inspection | NBI item 90, YYYY-MM |
inspection_interval_months | NBI item 91 |
scour_code | NBI item 113; 0-3 = scour critical |
fracture_critical | NBI item 92A, Y when flagged |
prior_condition | G/F/P in the previous vintage; blank if not listed or not compared |
Source: FHWA National Bridge Inventory, 2025 vintage.