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 2014

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 (49 mb).
  • Download Highway Bridges for all States (all states in a single file) as a zip file (49 mb).
  • Download all records. Includes non-highway and routes under bridges zip file (55 mb).
No Delimiters
StateNo. Highway Bridges
Alabama16,088
Alaska1,544
Arizona8,035
Arkansas12,806
California25,406
Colorado8,668
Connecticut4,218
Delaware865
District of Columbia253
Florida12,137
Georgia14,795
Hawaii1,137
Idaho4,431
Illinois26,588
Indiana19,019
Iowa24,300
Kansas25,085
Kentucky14,194
Louisiana12,982
Maine2,419
Maryland5,305
Massachusetts5,141
Michigan11,072
Minnesota12,961
Mississippi17,091
Missouri24,385
Montana5,251
Nebraska15,374
Nevada1,898
New Hampshire2,467
New Jersey6,609
New Mexico3,951
New York17,456
North Carolina18,117
North Dakota4,429
Ohio26,986
Oklahoma23,147
Oregon8,052
Pennsylvania22,691
Puerto Rico2,304
Rhode Island766
South Carolina9,338
South Dakota5,872
Tennessee20,077
Texas52,937
Utah3,014
Vermont2,745
Virginia13,800
Washington8,120
West Virginia7,187
Wisconsin14,109
Wyoming3,127
Totals610,749

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 (51 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,088
Alaska1,544
Arizona8,035
Arkansas12,806
California25,406
Colorado8,668
Connecticut4,218
Delaware865
District of Columbia253
Florida12,137
Georgia14,795
Hawaii1,137
Idaho4,431
Illinois26,588
Indiana19,019
Iowa24,300
Kansas25,085
Kentucky14,194
Louisiana12,982
Maine2,419
Maryland5,305
Massachusetts5,141
Michigan11,072
Minnesota12,961
Mississippi17,091
Missouri24,385
Montana5,251
Nebraska15,374
Nevada1,898
New Hampshire2,467
New Jersey6,609
New Mexico3,951
New York17,456
North Carolina18,117
North Dakota4,429
Ohio26,986
Oklahoma23,147
Oregon8,052
Pennsylvania22,691
Puerto Rico2,304
Rhode Island766
South Carolina9,338
South Dakota5,872
Tennessee20,077
Texas52,937
Utah3,014
Vermont2,745
Virginia13,800
Washington8,120
West Virginia7,187
Wisconsin14,109
Wyoming3,127
Totals610,749
Updated: 03/14/2019
Federal Highway Administration | 1200 New Jersey Avenue, SE | Washington, DC 20590 | 202-366-4000