Download NBI ASCII files 2020
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
Delimited files are comma separated, and the text qualifier is a single quote.
No Delimiter
- 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 (50 mb).
- Download all records. Includes non-highway and routes under bridges zip file (56 mb).
| State | No. Highway Bridges |
|---|---|
| Alabama | 16,155 |
| Alaska | 1,645 |
| Arizona | 8,428 |
| Arkansas | 12,946 |
| California | 25,763 |
| Colorado | 8,829 |
| Connecticut | 4,357 |
| Delaware | 882 |
| District of Columbia | 243 |
| Florida | 12,592 |
| Georgia | 14,964 |
| Hawaii | 1,153 |
| Idaho | 4,522 |
| Illinois | 26,848 |
| Indiana | 19,327 |
| Iowa | 23,982 |
| Kansas | 24,948 |
| Kentucky | 14,422 |
| Louisiana | 12,853 |
| Maine | 2,472 |
| Maryland | 5,430 |
| Massachusetts | 5,229 |
| Michigan | 11,271 |
| Minnesota | 13,471 |
| Mississippi | 16,878 |
| Missouri | 24,538 |
| Montana | 5,271 |
| Nebraska | 15,348 |
| Nevada | 2,056 |
| New Hampshire | 2,514 |
| New Jersey | 6,801 |
| New Mexico | 4,024 |
| New York | 17,552 |
| North Carolina | 18,749 |
| North Dakota | 4,312 |
| Ohio | 27,072 |
| Oklahoma | 23,155 |
| Oregon | 8,214 |
| Pennsylvania | 22,965 |
| Rhode Island | 777 |
| South Carolina | 9,455 |
| South Dakota | 5,880 |
| Tennessee | 20,235 |
| Texas | 54,682 |
| Utah | 3,062 |
| Vermont | 2,827 |
| Virginia | 13,963 |
| Washington | 8,338 |
| West Virginia | 7,295 |
| Wisconsin | 14,271 |
| Wyoming | 3,122 |
| Guam | 10 |
| Puerto Rico | 2,334 |
| U.S. Virgin Islands | 24 |
| Totals | 618,456 |
Delimited Files
- 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 (50 mb).
- Download all records. Includes non-highway and routes under bridges zip file (55 mb).
| State | No. Highway Bridges |
|---|---|
| Alabama | 16,155 |
| Alaska | 1,645 |
| Arizona | 8,428 |
| Arkansas | 12,946 |
| California | 25,763 |
| Colorado | 8,829 |
| Connecticut | 4,357 |
| Delaware | 882 |
| District of Columbia | 243 |
| Florida | 12,592 |
| Georgia | 14,964 |
| Hawaii | 1,153 |
| Idaho | 4,522 |
| Illinois | 26,848 |
| Indiana | 19,327 |
| Iowa | 23,982 |
| Kansas | 24,948 |
| Kentucky | 14,422 |
| Louisiana | 12,853 |
| Maine | 2,472 |
| Maryland | 5,430 |
| Massachusetts | 5,229 |
| Michigan | 11,271 |
| Minnesota | 13,471 |
| Mississippi | 16,878 |
| Missouri | 24,538 |
| Montana | 5,271 |
| Nebraska | 15,348 |
| Nevada | 2,056 |
| New Hampshire | 2,514 |
| New Jersey | 6,801 |
| New Mexico | 4,024 |
| New York | 17,552 |
| North Carolina | 18,749 |
| North Dakota | 4,312 |
| Ohio | 27,072 |
| Oklahoma | 23,155 |
| Oregon | 8,214 |
| Pennsylvania | 22,965 |
| Rhode Island | 777 |
| South Carolina | 9,455 |
| South Dakota | 5,880 |
| Tennessee | 20,235 |
| Texas | 54,682 |
| Utah | 3,062 |
| Vermont | 2,827 |
| Virginia | 13,963 |
| Washington | 8,338 |
| West Virginia | 7,295 |
| Wisconsin | 14,271 |
| Wyoming | 3,122 |
| Guam | 10 |
| Puerto Rico | 2,334 |
| U.S. Virgin Islands | 24 |
| Totals | 618,456 |