Download NBI ASCII files 2019
Note: The record format has been adjusted to accommodate the Pavement and Bridge Condition Performance Measures final rule. The updated format can be found at https://www.fhwa.dot.gov/bridge/nbi/format.cfm. Further discussion of the affected data items 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 (53 mb).
- Download Highway Bridges for all States (all states in a single file) as a zip file (53 mb).
- Download all records. Includes non-highway and routes under bridges zip file (58 mb).
| State | No. Highway Bridges |
|---|---|
| Alabama | 16,162 |
| Alaska | 1,595 |
| Arizona | 8,320 |
| Arkansas | 12,902 |
| California | 25,771 |
| Colorado | 8,785 |
| Connecticut | 4,336 |
| Delaware | 879 |
| District of Columbia | 244 |
| Florida | 12,518 |
| Georgia | 14,940 |
| Hawaii | 1,138 |
| Idaho | 4,493 |
| Illinois | 26,825 |
| Indiana | 19,284 |
| Iowa | 24,043 |
| Kansas | 24,934 |
| Kentucky | 14,394 |
| Louisiana | 12,884 |
| Maine | 2,461 |
| Maryland | 5,402 |
| Massachusetts | 5,233 |
| Michigan | 11,244 |
| Minnesota | 13,346 |
| Mississippi | 17,019 |
| Missouri | 24,494 |
| Montana | 5,278 |
| Nebraska | 15,332 |
| Nevada | 2,029 |
| New Hampshire | 2,502 |
| New Jersey | 6,786 |
| New Mexico | 4,014 |
| New York | 17,540 |
| North Carolina | 18,407 |
| North Dakota | 4,329 |
| Ohio | 27,167 |
| Oklahoma | 23,138 |
| Oregon | 8,211 |
| Pennsylvania | 22,911 |
| Rhode Island | 779 |
| South Carolina | 9,419 |
| South Dakota | 5,821 |
| Tennessee | 20,226 |
| Texas | 54,432 |
| Utah | 3,063 |
| Vermont | 2,818 |
| Virginia | 13,933 |
| Washington | 8,300 |
| West Virginia | 7,291 |
| Wisconsin | 14,249 |
| Wyoming | 3,114 |
| Guam | 10 |
| Puerto Rico | 2,315 |
| U.S. Virgin Islands | 24 |
| Totals | 617,084 |
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 (in a single file) as a zip file zip file (55 mb)
- Download all records. Includes non-highway and routes under bridges zip file (60 mb).
| State | No. Highway Bridges |
|---|---|
| Alabama | 16,162 |
| Alaska | 1,595 |
| Arizona | 8,320 |
| Arkansas | 12,902 |
| California | 25,771 |
| Colorado | 8,785 |
| Connecticut | 4,336 |
| Delaware | 879 |
| District of Columbia | 244 |
| Florida | 12,518 |
| Georgia | 14,940 |
| Hawaii | 1,138 |
| Idaho | 4,493 |
| Illinois | 26,825 |
| Indiana | 19,284 |
| Iowa | 24,043 |
| Kansas | 24,934 |
| Kentucky | 14,394 |
| Louisiana | 12,884 |
| Maine | 2,461 |
| Maryland | 5,402 |
| Massachusetts | 5,233 |
| Michigan | 11,244 |
| Minnesota | 13,346 |
| Mississippi | 17,019 |
| Missouri | 24,494 |
| Montana | 5,278 |
| Nebraska | 15,332 |
| Nevada | 2,029 |
| New Hampshire | 2,502 |
| New Jersey | 6,786 |
| New Mexico | 4,014 |
| New York | 17,540 |
| North Carolina | 18,407 |
| North Dakota | 4,329 |
| Ohio | 27,167 |
| Oklahoma | 23,138 |
| Oregon | 8,211 |
| Pennsylvania | 22,911 |
| Rhode Island | 779 |
| South Carolina | 9,419 |
| South Dakota | 5,821 |
| Tennessee | 20,226 |
| Texas | 54,432 |
| Utah | 3,063 |
| Vermont | 2,818 |
| Virginia | 13,933 |
| Washington | 8,300 |
| West Virginia | 7,291 |
| Wisconsin | 14,249 |
| Wyoming | 3,114 |
| Guam | 10 |
| Puerto Rico | 2,315 |
| U.S. Virgin Islands | 24 |
| Totals | 617,084 |

