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

2012 NBI ASCII Files

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 http://www.fhwa.dot.gov/bridge/britab.cfm.

Delimited Files

No Delimiter

  • Download Highway Bridges for all States (individual state files) as a ZIP file (54 mb).
  • Download Highway Bridges for all States (all records, all states in a single file) as a zip file (54 mb).
No Delimiters
State 5a=15a=25a=A to Z
Alabama 16,091 1,160 262
Alaska 1,173 113 0
Arizona 7,865 1,303 62
Arkansas 12,699 522 1,144
California 24,812 6,378 2,872
Colorado 8,629 1,041 30
Connecticut 4,208 953 320
Delaware 862 210 86
District of Columbia 242 69 0
Florida 11,993 2,817 1,224
Georgia 14,740 1,958 558
Hawaii 1,164 48 0
Idaho 4,214 439 15
Illinois 26,514 3,788 312
Indiana 18,793 1,293 1,456
Iowa 24,502 1,141 153
Kansas 25,210 1,391 51
Kentucky 14,036 1,808 407
Louisiana 13,301 563 355
Maine 2,408 440 4
Maryland 5,300 1,094 163
Massachusetts 5,141 76 534
Michigan 11,000 3,300 14
Minnesota 13,122 2,069 873
Mississippi 17,063 196 1,200
Missouri 24,356 843 2,444
Montana 5,120 666 4
Nebraska 15,393 621 188
Nevada 1,842 379 56
New Hampshire 3,845 312 10
New Jersey 6,559 2,126 1,029
New Mexico 3,924 616 76
New York 17,492 4,523 679
North Carolina 18,280 2,653 1,076
North Dakota 4,458 157 388
Ohio 27,055 5,346 0
Oklahoma 23,781 1,921 512
Oregon 7,634 964 271
Pennsylvania 22,671 2,687 4,357
Puerto Rico 2,248 494 37
Rhode Island 757 268 60
South Carolina 9,271 1,077 0
South Dakota 5,870 409 58
Tennessee 20,320 2,727 347
Texas 52,368 9,151 0
Utah 2,947 850 8
Vermont 2,730 315 6
Virginia 13,770 2,572 1,250
Washington 7,841 1,183 25
West Virginia 7,095 1,186 306
Wisconsin 14,098 2,732 0
Wyoming 3,101 299 0
Totals 609,908 81,247 25,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 (55 mb).
  • Download Highway Bridges for all States (all records, all states in a single file) as a ZIP file (55 mb)
  • Download Highway Bridges for all States (in a single file) as a zip file ZIP file (50 mb)
Comma Delimited
State 5a=15a=25a=A to Z
Alabama 16,091 1,160 262
Alaska 1,173 113 0
Arizona 7,865 1,303 62
Arkansas 12,699 522 1,144
California 24,812 6,378 2,872
Colorado 8,629 1,041 30
Connecticut 4,208 953 320
Delaware 862 210 86
District of Columbia 242 69 0
Florida 11,993 2,817 1,224
Georgia 14,740 1,958 558
Hawaii 1,164 48 0
Idaho 4,214 439 15
Illinois 26,514 3,788 312
Indiana 18,793 1,293 1,456
Iowa 24,502 1,141 153
Kansas 25,210 1,391 51
Kentucky 14,036 1,808 407
Louisiana 13,301 563 355
Maine 2,408 440 4
Maryland 5,300 1,094 163
Massachusetts 5,141 76 534
Michigan 11,000 3,300 14
Minnesota 13,122 2,069 873
Mississippi 17,063 196 1,200
Missouri 24,356 843 2,444
Montana 5,120 666 4
Nebraska 15,393 621 188
Nevada 1,842 379 56
New Hampshire 3,845 312 10
New Jersey 6,559 2,126 1,029
New Mexico 3,924 616 76
New York 17,492 4,523 679
North Carolina 18,280 2,653 1,076
North Dakota 4,458 157 388
Ohio 27,055 5,346 0
Oklahoma 23,781 1,921 512
Oregon 7,634 964 271
Pennsylvania 22,671 2,687 4,357
Puerto Rico 2,248 494 37
Rhode Island 757 268 60
South Carolina 9,271 1,077 0
South Dakota 5,870 409 58
Tennessee 20,320 2,727 347
Texas 52,368 9,151 0
Utah 2,947 850 8
Vermont 2,730 315 6
Virginia 13,770 2,572 1,250
Washington 7,841 1,183 25
West Virginia 7,095 1,186 306
Wisconsin 14,098 2,732 0
Wyoming 3,101 299 0
Totals 609,908 81,247 25,282
Word files can be viewed with the Word Viewer
PDF files can be viewed with the Acrobat® Reader®
Updated: 08/13/2014
Federal Highway Administration | 1200 New Jersey Avenue, SE | Washington, DC 20590 | 202-366-4000