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
No Delimiter
- Download Highway Bridges for all States (individual state files) as a zip file (52 mb).
| State | 5a=1 | 5a=2 | 5a=A to Z |
|---|---|---|---|
| Alabama | 15,776 | 1,080 | 242 |
| Alaska | 1,520 | 87 | 0 |
| Arizona | 7,138 | 1,086 | 49 |
| Arkansas | 12,477 | 496 | 965 |
| California | 24,026 | 7,076 | 2,657 |
| Colorado | 8,341 | 878 | 13 |
| Connecticut | 4,173 | 955 | 291 |
| Delaware | 840 | 193 | 63 |
| District of Columbia | 249 | 73 | 0 |
| Florida | 11,436 | 2,805 | 423 |
| Georgia | 14,497 | 1,873 | 468 |
| Hawaii | 1,154 | 19 | 0 |
| Idaho | 4,193 | 421 | 5 |
| Illinois | 25,618 | 3,680 | 259 |
| Indiana | 18,090 | 1,352 | 0 |
| Iowa | 24,984 | 1,074 | 124 |
| Kansas | 25,918 | 1,332 | 0 |
| Kentucky | 13,493 | 1,857 | 8 |
| Louisiana | 13,517 | 626 | 270 |
| Maine | 2,364 | 441 | 0 |
| Maryland | 4,982 | 916 | 0 |
| Massachusetts | 4,932 | 210 | 465 |
| Michigan | 10,805 | 3,240 | 3 |
| Minnesota | 19,309 | 1,954 | 775 |
| Mississippi | 16,832 | 170 | 1,091 |
| Missouri | 23,548 | 384 | 2,126 |
| Montana | 5,351 | 680 | 5 |
| Nebraska | 15,463 | 601 | 176 |
| Nevada | 1,669 | 326 | 25 |
| New Hampshire | 3,753 | 256 | 2 |
| New Jersey | 6,388 | 2,354 | 863 |
| New Mexico | 3,825 | 549 | 14 |
| New York | 17,443 | 4,132 | 528 |
| North Carolina | 18,431 | 3,722 | 0 |
| North Dakota | 4,523 | 259 | 1 |
| Ohio | 27,902 | 5,127 | 0 |
| Oklahoma | 23,000 | 1,939 | 0 |
| Oregon | 7,373 | 661 | 185 |
| Pennsylvania | 22,174 | 3,950 | 1,163 |
| Puerto Rico | 2,109 | 576 | 28 |
| Rhode Island | 749 | 218 | 0 |
| South Carolina | 9,124 | 939 | 0 |
| South Dakota | 5,981 | 417 | 27 |
| Tennessee | 19,953 | 2,636 | 268 |
| Texas | 48,331 | 5,603 | 3 |
| Utah | 2,834 | 898 | 11 |
| Vermont | 2,720 | 312 | 6 |
| Virginia | 13,690 | 2,488 | 834 |
| Washington | 7,672 | 843 | 313 |
| West Virginia | 6,840 | 1,106 | 312 |
| Wisconsin | 13,625 | 2,548 | 0 |
| Wyoming | 3,098 | 294 | 0 |
| Totals | 604,233 | 77,712 | 15,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)
| State | 5a=1 | 5a=2 | 5a=A to Z |
|---|---|---|---|
| Alabama | 15,776 | 1,080 | 242 |
| Alaska | 1,520 | 87 | 0 |
| Arizona | 7,138 | 1,086 | 49 |
| Arkansas | 12,477 | 496 | 965 |
| California | 24,026 | 7,076 | 2,657 |
| Colorado | 8,341 | 878 | 13 |
| Connecticut | 4,173 | 955 | 291 |
| Delaware | 840 | 193 | 63 |
| District of Columbia | 249 | 73 | 0 |
| Florida | 11,436 | 2,805 | 423 |
| Georgia | 14,497 | 1,873 | 468 |
| Hawaii | 1,154 | 19 | 0 |
| Idaho | 4,193 | 421 | 5 |
| Illinois | 25,618 | 3,680 | 259 |
| Indiana | 18,090 | 1,352 | 0 |
| Iowa | 24,984 | 1,074 | 124 |
| Kansas | 25,918 | 1,332 | 0 |
| Kentucky | 13,493 | 1,857 | 8 |
| Louisiana | 13,517 | 626 | 270 |
| Maine | 2,364 | 441 | 0 |
| Maryland | 4,982 | 916 | 0 |
| Massachusetts | 4,932 | 210 | 465 |
| Michigan | 10,805 | 3,240 | 3 |
| Minnesota | 19,309 | 1,954 | 775 |
| Mississippi | 16,832 | 170 | 1,091 |
| Missouri | 23,548 | 384 | 2,126 |
| Montana | 5,351 | 680 | 5 |
| Nebraska | 15,463 | 601 | 176 |
| Nevada | 1,669 | 326 | 25 |
| New Hampshire | 3,753 | 256 | 2 |
| New Jersey | 6,388 | 2,354 | 863 |
| New Mexico | 3,825 | 549 | 14 |
| New York | 17,443 | 4,132 | 528 |
| North Carolina | 18,431 | 3,722 | 0 |
| North Dakota | 4,523 | 259 | 1 |
| Ohio | 27,902 | 5,127 | 0 |
| Oklahoma | 23,000 | 1,939 | 0 |
| Oregon | 7,373 | 661 | 185 |
| Pennsylvania | 22,174 | 3,950 | 1,163 |
| Puerto Rico | 2,109 | 576 | 28 |
| Rhode Island | 749 | 218 | 0 |
| South Carolina | 9,124 | 939 | 0 |
| South Dakota | 5,981 | 417 | 27 |
| Tennessee | 19,953 | 2,636 | 268 |
| Texas | 48,331 | 5,603 | 3 |
| Utah | 2,834 | 898 | 11 |
| Vermont | 2,720 | 312 | 6 |
| Virginia | 13,690 | 2,488 | 834 |
| Washington | 7,672 | 843 | 313 |
| West Virginia | 6,840 | 1,106 | 312 |
| Wisconsin | 13,625 | 2,548 | 0 |
| Wyoming | 3,098 | 294 | 0 |
| Totals | 604,233 | 77,712 | 15,061 |