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 2002

  • 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 (52 mb).
No Delimiters
State5a=15a=25a=A to Z
Alabama15,7761,080242
Alaska1,520870
Arizona7,1381,08649
Arkansas12,477496965
California24,0267,0762,657
Colorado8,34187813
Connecticut4,173955291
Delaware84019363
District of Columbia249730
Florida11,4362,805423
Georgia14,4971,873468
Hawaii1,154190
Idaho4,1934215
Illinois25,6183,680259
Indiana18,0901,3520
Iowa24,9841,074124
Kansas25,9181,3320
Kentucky13,4931,8578
Louisiana13,517626270
Maine2,3644410
Maryland4,9829160
Massachusetts4,932210465
Michigan10,8053,2403
Minnesota19,3091,954775
Mississippi16,8321701,091
Missouri23,5483842,126
Montana5,3516805
Nebraska15,463601176
Nevada1,66932625
New Hampshire3,7532562
New Jersey6,3882,354863
New Mexico3,82554914
New York17,4434,132528
North Carolina18,4313,7220
North Dakota4,5232591
Ohio27,9025,1270
Oklahoma23,0001,9390
Oregon7,373661185
Pennsylvania22,1743,9501,163
Puerto Rico2,10957628
Rhode Island7492180
South Carolina9,1249390
South Dakota5,98141727
Tennessee19,9532,636268
Texas48,3315,6033
Utah2,83489811
Vermont2,7203126
Virginia13,6902,488834
Washington7,672843313
West Virginia6,8401,106312
Wisconsin13,6252,5480
Wyoming3,0982940
Totals604,23377,71215,061

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)
Comma Delimited
State5a=15a=25a=A to Z
Alabama15,7761,080242
Alaska1,520870
Arizona7,1381,08649
Arkansas12,477496965
California24,0267,0762,657
Colorado8,34187813
Connecticut4,173955291
Delaware84019363
District of Columbia249730
Florida11,4362,805423
Georgia14,4971,873468
Hawaii1,154190
Idaho4,1934215
Illinois25,6183,680259
Indiana18,0901,3520
Iowa24,9841,074124
Kansas25,9181,3320
Kentucky13,4931,8578
Louisiana13,517626270
Maine2,3644410
Maryland4,9829160
Massachusetts4,932210465
Michigan10,8053,2403
Minnesota19,3091,954775
Mississippi16,8321701,091
Missouri23,5483842,126
Montana5,3516805
Nebraska15,463601176
Nevada1,66932625
New Hampshire3,7532562
New Jersey6,3882,354863
New Mexico3,82554914
New York17,4434,132528
North Carolina18,4313,7220
North Dakota4,5232591
Ohio27,9025,1270
Oklahoma23,0001,9390
Oregon7,373661185
Pennsylvania22,1743,9501,163
Puerto Rico2,10957628
Rhode Island7492180
South Carolina9,1249390
South Dakota5,98141727
Tennessee19,9532,636268
Texas48,3315,6033
Utah2,83489811
Vermont2,7203126
Virginia13,6902,488834
Washington7,672843313
West Virginia6,8401,106312
Wisconsin13,6252,5480
Wyoming3,0982940
Totals604,23377,71215,061
Updated: 08/12/2020
Federal Highway Administration | 1200 New Jersey Avenue, SE | Washington, DC 20590 | 202-366-4000