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 2012

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 records, all states in a single file) as a zip file (49 mb).
No Delimiters
State5a=15a=25a=A to Z
Alabama16,0911,160262
Alaska1,1731130
Arizona7,8651,30362
Arkansas12,6995221,144
California24,8126,3782,872
Colorado8,6291,04130
Connecticut4,208953320
Delaware86221086
District of Columbia242690
Florida11,9932,8171,224
Georgia14,7401,958558
Hawaii1,164480
Idaho4,21443915
Illinois26,5143,788312
Indiana18,7931,2931,456
Iowa24,5021,141153
Kansas25,2101,39151
Kentucky14,0361,808407
Louisiana13,301563355
Maine2,4084404
Maryland5,3001,094163
Massachusetts5,14176534
Michigan11,0003,30014
Minnesota13,1222,069873
Mississippi17,0631961,200
Missouri24,3568432,444
Montana5,1206664
Nebraska15,393621188
Nevada1,84237956
New Hampshire3,84531210
New Jersey6,5592,1261,029
New Mexico3,92461676
New York17,4924,523679
North Carolina18,2802,6531,076
North Dakota4,458157388
Ohio27,0555,3460
Oklahoma23,7811,921512
Oregon7,634964271
Pennsylvania22,6712,6874,357
Puerto Rico2,24849437
Rhode Island75726860
South Carolina9,2711,0770
South Dakota5,87040958
Tennessee20,3202,727347
Texas52,3689,1510
Utah2,9478508
Vermont2,7303156
Virginia13,7702,5721,250
Washington7,8411,18325
West Virginia7,0951,186306
Wisconsin14,0982,7320
Wyoming3,1012990
Totals609,90881,24725,282

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 (50 mb).
  • Download Highway Bridges for all States (in a single file) as a zip file zip file (50 mb)
Comma Delimited
State5a=15a=25a=A to Z
Alabama16,0911,160262
Alaska1,1731130
Arizona7,8651,30362
Arkansas12,6995221,144
California24,8126,3782,872
Colorado8,6291,04130
Connecticut4,208953320
Delaware86221086
District of Columbia242690
Florida11,9932,8171,224
Georgia14,7401,958558
Hawaii1,164480
Idaho4,21443915
Illinois26,5143,788312
Indiana18,7931,2931,456
Iowa24,5021,141153
Kansas25,2101,39151
Kentucky14,0361,808407
Louisiana13,301563355
Maine2,4084404
Maryland5,3001,094163
Massachusetts5,14176534
Michigan11,0003,30014
Minnesota13,1222,069873
Mississippi17,0631961,200
Missouri24,3568432,444
Montana5,1206664
Nebraska15,393621188
Nevada1,84237956
New Hampshire3,84531210
New Jersey6,5592,1261,029
New Mexico3,92461676
New York17,4924,523679
North Carolina18,2802,6531,076
North Dakota4,458157388
Ohio27,0555,3460
Oklahoma23,7811,921512
Oregon7,634964271
Pennsylvania22,6712,6874,357
Puerto Rico2,24849437
Rhode Island75726860
South Carolina9,2711,0770
South Dakota5,87040958
Tennessee20,3202,727347
Texas52,3689,1510
Utah2,9478508
Vermont2,7303156
Virginia13,7702,5721,250
Washington7,8411,18325
West Virginia7,0951,186306
Wisconsin14,0982,7320
Wyoming3,1012990
Totals609,90881,24725,282
Updated: 03/14/2019
Federal Highway Administration | 1200 New Jersey Avenue, SE | Washington, DC 20590 | 202-366-4000