U.S. Department of Transportation
Federal Highway Administration
1200 New Jersey Avenue, SE
Washington, DC 20590
202-366-4000


Skip to content U.S. Department of Transportation/Federal Highway AdministrationU.S. Department of Transportation/Federal Highway Administration

Bridges & Structures

 

Download NBI ASCII files 1997

  • 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

Delimited Files

No Delimiter

  • Download Highway Bridges for all States (individual state files) as a zip file (46 mb).
No Delimiters
State5a=15a=25a=A to Z
Alabama15,5791,007335
Alaska1,393700
Arizona6,6698540
Arkansas12,496565682
California23,2926,4151,050
Colorado8,09582910
Connecticut4,148955290
Delaware1,29193289
District of Columbia250740
Florida11,0492,057137
Georgia14,3581,857441
Hawaii1,14160
Idaho4,1954216
Illinois25,2563,658206
Indiana17,8721,2300
Iowa24,7461,220114
Kansas25,9221,2910
Kentucky13,2311,8137
Louisiana13,662601243
Maine2,3574400
Maryland4,8798780
Massachusetts5,077224466
Michigan10,7393,1410
Minnesota18,8791,913754
Mississippi16,805164952
Missouri22,9634132,079
Montana5,3376780
Nebraska15,577592159
Nevada1,34625911
New Hampshire3,7082482
New Jersey6,3042,306818
New Mexico3,64455514
New York17,4044,136570
North Carolina16,9653,1600
North Dakota4,57400
Ohio27,8144,9940
Oklahoma22,8651,8990
Oregon7,246607190
Pennsylvania23,1943,8541,075
Puerto Rico1,94953320
Rhode Island7382190
South Carolina9,0589120
South Dakota6,06541629
Tennessee19,5172,586226
Texas47,9425,2032
Utah2,7128626
Vermont2,6993136
Virginia13,0852,613382
Washington7,670734858
West Virginia6,6021,088306
Wisconsin13,2552,4380
Wyoming3,0182840
Totals596,63273,67812,735

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 (48 mb).
  • Download Highway Bridges for all States (in a single file) as a zip file zip file (48 mb)
Comma Delimited
State5a=15a=25a=A to Z
Alabama15,5791,007335
Alaska1,393700
Arizona6,6698540
Arkansas12,496565682
California23,2926,4151,050
Colorado8,09582910
Connecticut4,148955290
Delaware1,29193289
District of Columbia250740
Florida11,0492,057137
Georgia14,3581,857441
Hawaii1,14160
Idaho4,1954216
Illinois25,2563,658206
Indiana17,8721,2300
Iowa24,7461,220114
Kansas25,9221,2910
Kentucky13,2311,8137
Louisiana13,662601243
Maine2,3574400
Maryland4,8798780
Massachusetts5,077224466
Michigan10,7393,1410
Minnesota18,8791,913754
Mississippi16,805164952
Missouri22,9634132,079
Montana5,3376780
Nebraska15,577592159
Nevada1,34625911
New Hampshire3,7082482
New Jersey6,3042,306818
New Mexico3,64455514
New York17,4044,136570
North Carolina16,9653,1600
North Dakota4,57400
Ohio27,8144,9940
Oklahoma22,8651,8990
Oregon7,246607190
Pennsylvania23,1943,8541,075
Puerto Rico1,94953320
Rhode Island7382190
South Carolina9,0589120
South Dakota6,06541629
Tennessee19,5172,586226
Texas47,9425,2032
Utah2,7128626
Vermont2,6993136
Virginia13,0852,613382
Washington7,670734858
West Virginia6,6021,088306
Wisconsin13,2552,4380
Wyoming3,0182840
Totals596,63273,67812,735
Updated: 08/17/2020
Federal Highway Administration | 1200 New Jersey Avenue, SE | Washington, DC 20590 | 202-366-4000