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
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).
| State | 5a=1 | 5a=2 | 5a=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 (50 mb).
- Download Highway Bridges for all States (in a single file) as a zip file zip file (50 mb)
| State | 5a=1 | 5a=2 | 5a=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 |