Note: The "10 Year Rule" was applied in the determination of deficiency status within these data tables. The "10 Year Rule" excludes bridges built or reconstructed within the past 10 years since they are not generally eligible for Highway Bridge Program funding.
Some of the data files are large and can take some time to load. After you click on the link, please make sure the file is loaded before saving. Below are examples of a file loading and a file completely loaded.
To import into Excel, choose the Data Tab, then From Text, choose your file from saved directory and import. Import wizard pops up. Choose Delimited File, Comma Separated and the Text Qualifier is a single quote (not double which is excel default), on the next screen which is the Column Data Format screen highlight the structure number column (column 2) and choose "TEXT" for the structure number column format rather than the default of "GENERAL" this will import the structure numbers correctly and keep the formatting.
After downloading the data you will need to distinguish the subset of "highway bridges". To obtain this set items 5a=1; 49>=6.1meters; 112=Y and 42a=1 or 4 or 5 or 6 or 7 or 8.