NBI ASCII Files
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.
- Recording and Coding Guide for the Structure Inventory and Appraisal of the Nations Bridges (pdf, 0.8 Mb) (doc, 2.2 mb)
- Errata Sheet for Coding Guide (03/2004)
- Record Format
- 1992 Data
- 1993 Data
- 1994 Data
- 1995 Data
- 1996 Data
- 1997 Data
- 1998 Data
- 1999 Data
- 2000 Data
- 2001 Data
- 2002 Data
- 2003 Data
- 2004 Data
- 2005 Data
- 2006 Data
- 2007 Data
- 2008 Data
- 2009 Data
- 2010 Data
- 2011 Data
- 2012 Data
Note on saving data files:
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.
Note on importing the data:
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.
Note on using the data:
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.