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 2004

  • These are prior data that apply a cancelled agency policy known as the 10-year rule. When applied, the '10-year rule' excluded bridges built or reconstructed within the prior 10 years since they were not generally eligible for Highway Bridge Program funding.

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 (54 mb).
No Delimiters
State5a=15a=25a=A to Z
Alabama15,7261,097249
Alaska1,258960
Arizona7,1741,16553
Arkansas12,4785001,016
California24,2027,3762,992
Colorado8,42191222
Connecticut4,167952289
Delaware85219182
District of Columbia255860
Florida11,5212,840510
Georgia14,4951,879471
Hawaii1,154280
Idaho4,0964255
Illinois25,7323,660267
Indiana18,1842,0050
Iowa24,9121,118120
Kansas25,8651,3482
Kentucky13,6831,82111
Louisiana13,466600252
Maine2,3714410
Maryland5,0829370
Massachusetts4,96570550
Michigan10,8323,2503
Minnesota19,6501,996811
Mississippi16,8551731,129
Missouri23,8186672,428
Montana5,2926786
Nebraska15,457604182
Nevada1,65728436
New Hampshire3,7882754
New Jersey6,5102,101852
New Mexico3,86359129
New York17,3974,270562
North Carolina18,6184,0990
North Dakota4,5132601
Ohio27,9185,1480
Oklahoma23,3262,0125
Oregon7,276668184
Pennsylvania22,2753,9981,195
Puerto Rico2,13857129
Rhode Island7492180
South Carolina9,2371,0390
South Dakota5,96142126
Tennessee19,9892,645275
Texas49,0465,8735
Utah2,83390410
Vermont2,6943136
Virginia13,9092,512881
Washington8,036870315
West Virginia6,8991,131304
Wisconsin13,6882,6130
Wyoming3,0562960
Totals607,33980,02716,169

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)
Comma Delimited
State5a=15a=25a=A to Z
Alabama15,7261,097249
Alaska1,258960
Arizona7,1741,16553
Arkansas12,4785001,016
California24,2027,3762,992
Colorado8,42191222
Connecticut4,167952289
Delaware85219182
District of Columbia255860
Florida11,5212,840510
Georgia14,4951,879471
Hawaii1,154280
Idaho4,0964255
Illinois25,7323,660267
Indiana18,1842,0050
Iowa24,9121,118120
Kansas25,8651,3482
Kentucky13,6831,82111
Louisiana13,466600252
Maine2,3714410
Maryland5,0829370
Massachusetts4,96570550
Michigan10,8323,2503
Minnesota19,6501,996811
Mississippi16,8551731,129
Missouri23,8186672,428
Montana5,2926786
Nebraska15,457604182
Nevada1,65728436
New Hampshire3,7882754
New Jersey6,5102,101852
New Mexico3,86359129
New York17,3974,270562
North Carolina18,6184,0990
North Dakota4,5132601
Ohio27,9185,1480
Oklahoma23,3262,0125
Oregon7,276668184
Pennsylvania22,2753,9981,195
Puerto Rico2,13857129
Rhode Island7492180
South Carolina9,2371,0390
South Dakota5,96142126
Tennessee19,9892,645275
Texas49,0465,8735
Utah2,83390410
Vermont2,6943136
Virginia13,9092,512881
Washington8,036870315
West Virginia6,8991,131304
Wisconsin13,6882,6130
Wyoming3,0562960
Totals607,33980,02716,169
Updated: 08/12/2020
Federal Highway Administration | 1200 New Jersey Avenue, SE | Washington, DC 20590 | 202-366-4000