U.S. Department of Transportation
Federal Highway Administration
1200 New Jersey Avenue, SE
Washington, DC 20590
202-366-4000


Skip to content U.S. Department of Transportation/Federal Highway AdministrationU.S. Department of Transportation/Federal Highway Administration

Bridges & Structures

 

Download NBI ASCII files 2015

Note: A status considering the "10 Year Rule" and a status not considering the "10 Year Rule" is now contained in the data files available for download. Record layout describes the positioning of the data items. Further discussion of deficiency status can be found at https://www.fhwa.dot.gov/bridge/britab.cfm.

Instructions for importing the data into excel can be found here: Importing the data into MS Excel

Delimited Files

No Delimiter

  • Download Highway Bridges for all States (individual state files) as a zip file (50 mb).
  • Download Highway Bridges for all States (all states in a single file) as a zip file (50 mb).
  • Download all records. Includes non-highway and routes under bridges zip file (56 mb).
No Delimiters
StateNo. Highway Bridges
Alabama16,095
Alaska1,493
Arizona8,056
Arkansas12,853
California25,318
Colorado8,624
Connecticut4,225
Delaware875
District of Columbia254
Florida12,198
Georgia14,790
Hawaii1,142
Idaho4,369
Illinois26,674
Indiana19,145
Iowa24,242
Kansas25,047
Kentucky14,261
Louisiana13,012
Maine2,431
Maryland5,313
Massachusetts5,167
Michigan11,086
Minnesota13,301
Mississippi17,057
Missouri24,398
Montana5,243
Nebraska15,341
Nevada1,919
New Hampshire2,470
New Jersey6,686
New Mexico3,960
New York17,461
North Carolina18,124
North Dakota4,401
Ohio27,104
Oklahoma23,049
Oregon8,037
Pennsylvania22,783
Puerto Rico2,306
Rhode Island766
South Carolina9,344
South Dakota5,866
Tennessee20,106
Texas53,209
Utah3,019
Vermont2,749
Virginia13,884
Washington8,158
West Virginia7,215
Wisconsin14,134
Wyoming3,085
Totals611,845

Delimited files

files are comma separated and the single quote is the text qualifier.

  • Download Highway Bridges for all States (individual state files) as a zip file (52 mb).
  • Download Highway Bridges for all States (in a single file) as a zip file zip file (51 mb)
  • Download all records. Includes non-highway and routes under bridges zip file (55 mb).
Comma Delimited
StateNo. Highway Bridges
Alabama16,095
Alaska1,493
Arizona8,056
Arkansas12,853
California25,318
Colorado8,624
Connecticut4,225
Delaware875
District of Columbia254
Florida12,198
Georgia14,790
Hawaii1,142
Idaho4,369
Illinois26,674
Indiana19,145
Iowa24,242
Kansas25,047
Kentucky14,261
Louisiana13,012
Maine2,431
Maryland5,313
Massachusetts5,167
Michigan11,086
Minnesota13,301
Mississippi17,057
Missouri24,398
Montana5,243
Nebraska15,341
Nevada1,919
New Hampshire2,470
New Jersey6,686
New Mexico3,960
New York17,461
North Carolina18,124
North Dakota4,401
Ohio27,104
Oklahoma23,049
Oregon8,037
Pennsylvania22,783
Puerto Rico2,306
Rhode Island766
South Carolina9,344
South Dakota5,866
Tennessee20,106
Texas53,209
Utah3,019
Vermont2,749
Virginia13,884
Washington8,158
West Virginia7,215
Wisconsin14,134
Wyoming3,085
Totals611,845
Updated: 03/14/2019
Federal Highway Administration | 1200 New Jersey Avenue, SE | Washington, DC 20590 | 202-366-4000