BridgeReportCard
Home › Data

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.

ColumnMeaning
statestate name
bridgesinventoried bridges
good
fair
poor
poor_pct

bridge-conditions-by-county.csv

Good/Fair/Poor bridge counts for every U.S. county.

ColumnMeaning
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.

ColumnMeaning
state
county
structure_numberNBI id
facilityroad carried
featurewhat it crosses
year_built
adtavg daily traffic
deckrating 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).

ColumnMeaning
state
county
structure_numberNBI id
facilityroad carried
featurewhat it crosses
status_codeNBI item 41
statuscoding-guide meaning
year_built
adtavg daily traffic
conditionG/F/P
last_inspectionYYYY-MM
permalinkthis 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).

ColumnMeaning
state
county
structure_numberNBI id
facility
feature
adt
condition_2024G/F/P
condition_2025G/F/P
deck_2024
deck_2025
superstructure_2024
superstructure_2025
substructure_2024
substructure_2025
culvert_2024
culvert_2025
status_2024item 41
status_2025item 41
directionworse / 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

ColumnMeaning
state
county
structure_numberNBI id
facilityroad carried
featurewhat it crosses
locationinventory location text
year_built
year_reconstructed
adtavg daily traffic
adt_yeartraffic count year
conditionG/F/P, FHWA computed
deckrating 0-9
superstructure
substructure
culvert
structure_kindNBI item 43A code
structure_typeNBI item 43B code
length_mstructure length, metres
owner_codeNBI item 22
lat
lon
permalinkthis site's page
status_codeNBI item 41: A open, P/R posted, K closed, B/D/E temporary
last_inspectionNBI item 90, YYYY-MM
inspection_interval_monthsNBI item 91
scour_codeNBI item 113; 0-3 = scour critical
fracture_criticalNBI item 92A, Y when flagged
prior_conditionG/F/P in the previous vintage; blank if not listed or not compared

Source: FHWA National Bridge Inventory, 2025 vintage.