Download NBI ASCII files 2023
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 (52 mb).
- Download Highway Bridges for all States (in a single file) as a zip file (52 mb).
- Download all records. Includes non-highway and routes under bridges zip file (58 mb).
| State | No. Highway Bridges |
|---|---|
| Alabama | 16,176 |
| Alaska | 1,675 |
| Arizona | 8,544 |
| Arkansas | 12,962 |
| California | 25,818 |
| Colorado | 8,954 |
| Connecticut | 4,362 |
| Delaware | 874 |
| District of Columbia | 252 |
| Florida | 12,881 |
| Georgia | 15,058 |
| Hawaii | 1,190 |
| Idaho | 4,588 |
| Illinois | 26,873 |
| Indiana | 19,381 |
| Iowa | 23,720 |
| Kansas | 24,907 |
| Kentucky | 14,493 |
| Louisiana | 12,717 |
| Maine | 2,521 |
| Maryland | 5,473 |
| Massachusetts | 5,281 |
| Michigan | 11,341 |
| Minnesota | 13,502 |
| Mississippi | 16,756 |
| Missouri | 24,617 |
| Montana | 5,218 |
| Nebraska | 15,348 |
| Nevada | 2,090 |
| New Hampshire | 2,537 |
| New Jersey | 6,820 |
| New Mexico | 4,037 |
| New York | 17,573 |
| North Carolina | 18,817 |
| North Dakota | 4,280 |
| Ohio | 26,960 |
| Oklahoma | 22,872 |
| Oregon | 8,292 |
| Pennsylvania | 23,257 |
| Rhode Island | 782 |
| South Carolina | 9,481 |
| South Dakota | 5,889 |
| Tennessee | 20,373 |
| Texas | 56,313 |
| Utah | 3,109 |
| Vermont | 2,856 |
| Virginia | 14,068 |
| Washington | 8,421 |
| West Virginia | 7,323 |
| Wisconsin | 14,412 |
| Wyoming | 3,131 |
| Guam | 47 |
| Puerto Rico | 2,335 |
| U.S. Virgin Islands | 24 |
| Totals | 621,581 |
Delimited Files
- Download Highway Bridges for all States (individual state files) as a zip file (52 mb).
- Download Highway Bridges for all States (in a single file) as a zip file (52 mb).
- Download all records. Includes non-highway and routes under bridges zip file (57 mb).
| State | No. Highway Bridges |
|---|---|
| Alabama | 16,176 |
| Alaska | 1,675 |
| Arizona | 8,544 |
| Arkansas | 12,962 |
| California | 25,818 |
| Colorado | 8,954 |
| Connecticut | 4,362 |
| Delaware | 874 |
| District of Columbia | 252 |
| Florida | 12,881 |
| Georgia | 15,058 |
| Hawaii | 1,190 |
| Idaho | 4,588 |
| Illinois | 26,873 |
| Indiana | 19,381 |
| Iowa | 23,720 |
| Kansas | 24,907 |
| Kentucky | 14,493 |
| Louisiana | 12,717 |
| Maine | 2,521 |
| Maryland | 5,473 |
| Massachusetts | 5,281 |
| Michigan | 11,341 |
| Minnesota | 13,502 |
| Mississippi | 16,756 |
| Missouri | 24,617 |
| Montana | 5,218 |
| Nebraska | 15,348 |
| Nevada | 2,090 |
| New Hampshire | 2,537 |
| New Jersey | 6,820 |
| New Mexico | 4,037 |
| New York | 17,573 |
| North Carolina | 18,817 |
| North Dakota | 4,280 |
| Ohio | 26,960 |
| Oklahoma | 22,872 |
| Oregon | 8,292 |
| Pennsylvania | 23,257 |
| Rhode Island | 782 |
| South Carolina | 9,481 |
| South Dakota | 5,889 |
| Tennessee | 20,373 |
| Texas | 56,313 |
| Utah | 3,109 |
| Vermont | 2,856 |
| Virginia | 14,068 |
| Washington | 8,421 |
| West Virginia | 7,323 |
| Wisconsin | 14,412 |
| Wyoming | 3,131 |
| Guam | 47 |
| Puerto Rico | 2,335 |
| U.S. Virgin Islands | 24 |
| Totals | 621,581 |