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 2016

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,098
Alaska1,488
Arizona8,154
Arkansas12,871
California25,431
Colorado8,682
Connecticut4,214
Delaware877
District of Columbia245
Florida12,313
Georgia14,835
Hawaii1,132
Idaho4,445
Illinois26,704
Indiana19,245
Iowa24,184
Kansas25,013
Kentucky14,265
Louisiana12,915
Maine2,450
Maryland5,321
Massachusetts5,171
Michigan11,156
Minnesota13,355
Mississippi17,068
Missouri24,468
Montana5,276
Nebraska15,334
Nevada1,933
New Hampshire2,486
New Jersey6,730
New Mexico3,973
New York17,462
North Carolina18,099
North Dakota4,400
Ohio28,284
Oklahoma23,053
Oregon8,118
Pennsylvania22,791
Puerto Rico2,308
Rhode Island772
South Carolina9,358
South Dakota5,849
Tennessee20,123
Texas53,488
Utah3,039
Vermont2,766
Virginia13,892
Washington8,178
West Virginia7,217
Wisconsin14,230
Wyoming3,128
Totals614,387

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,098
Alaska1,488
Arizona8,154
Arkansas12,871
California25,431
Colorado8,682
Connecticut4,214
Delaware877
District of Columbia245
Florida12,313
Georgia14,835
Hawaii1,132
Idaho4,445
Illinois26,704
Indiana19,245
Iowa24,184
Kansas25,013
Kentucky14,265
Louisiana12,915
Maine2,450
Maryland5,321
Massachusetts5,171
Michigan11,156
Minnesota13,355
Mississippi17,068
Missouri24,468
Montana5,276
Nebraska15,334
Nevada1,933
New Hampshire2,486
New Jersey6,730
New Mexico3,973
New York17,462
North Carolina18,099
North Dakota4,400
Ohio28,284
Oklahoma23,053
Oregon8,118
Pennsylvania22,791
Puerto Rico2,308
Rhode Island772
South Carolina9,358
South Dakota5,849
Tennessee20,123
Texas53,488
Utah3,039
Vermont2,766
Virginia13,892
Washington8,178
West Virginia7,217
Wisconsin14,230
Wyoming3,128
Totals614,387
Updated: 03/14/2019
Federal Highway Administration | 1200 New Jersey Avenue, SE | Washington, DC 20590 | 202-366-4000