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 2017

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 (51 mb).
  • Download Highway Bridges for all States (all states in a single file) as a zip file (51 mb).
  • Download all records. Includes non-highway and routes under bridges zip file (56 mb).
No Delimiters
StateNo. Highway Bridges
Alabama16,129
Alaska1,569
Arizona8,289
Arkansas12,864
California25,657
Colorado8,717
Connecticut4,238
Delaware879
District of Columbia245
Florida12,355
Georgia14,863
Hawaii1,135
Idaho4,492
Illinois26,775
Indiana19,291
Iowa24,215
Kansas25,001
Kentucky14,280
Louisiana12,910
Maine2,458
Maryland5,335
Massachusetts5,192
Michigan11,180
Minnesota13,329
Mississippi17,072
Missouri24,487
Montana5,302
Nebraska15,330
Nevada1,944
New Hampshire2,479
New Jersey6,737
New Mexico3,999
New York17,456
North Carolina18,183
North Dakota4,377
Ohio27,345
Oklahoma23,071
Oregon8,147
Pennsylvania22,779
Puerto Rico2,325
Rhode Island778
South Carolina9,341
South Dakota5,818
Tennessee20,169
Texas53,869
Utah3,051
Vermont2,772
Virginia13,932
Washington8,233
West Virginia7,228
Wisconsin14,253
Wyoming3,127
Totals615,002

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 (52 mb)
  • Download all records. Includes non-highway and routes under bridges zip file (55 mb).
Comma Delimited
StateNo. Highway Bridges
Alabama16,129
Alaska1,569
Arizona8,289
Arkansas12,864
California25,657
Colorado8,717
Connecticut4,238
Delaware879
District of Columbia245
Florida12,355
Georgia14,863
Hawaii1,135
Idaho4,492
Illinois26,775
Indiana19,291
Iowa24,215
Kansas25,001
Kentucky14,280
Louisiana12,910
Maine2,458
Maryland5,335
Massachusetts5,192
Michigan11,180
Minnesota13,329
Mississippi17,072
Missouri24,487
Montana5,302
Nebraska15,330
Nevada1,944
New Hampshire2,479
New Jersey6,737
New Mexico3,999
New York17,456
North Carolina18,183
North Dakota4,377
Ohio27,345
Oklahoma23,071
Oregon8,147
Pennsylvania22,779
Puerto Rico2,325
Rhode Island778
South Carolina9,341
South Dakota5,818
Tennessee20,169
Texas53,869
Utah3,051
Vermont2,772
Virginia13,932
Washington8,233
West Virginia7,228
Wisconsin14,253
Wyoming3,127
Totals615,002
Updated: 03/14/2019
Federal Highway Administration | 1200 New Jersey Avenue, SE | Washington, DC 20590 | 202-366-4000