Bridge Conditions - Bridge Condition Type by Owner and NHS Types by Region

Data Dictionary

Column	Type	Description
year	numeric	Condition year
geography	text	Region name
owner_type	text	Agency owner
nhs_type	text	Whether the bridge carries a roadway that's part of the National Highway System (NHS)
poor_deck_area_thou	numeric	Deck area of deficient bridges, in thousands of square feet
all_deck_area_thou	numeric	Deck area of all bridges, in thousands of square feet
pct_poor_deck_area	numeric	Percent of all bridge deck area that's deficient
good_deck_area_thou	numeric	Deck area of sufficient bridges, in thousands of square feet
pct_good_deck_area	numeric	Percent of all bridge deck area that's sufficient
count_poor_bridges	numeric	Number of deficient bridges
count_all_bridges	numeric	Number of bridges in all conditions
pct_poor_bridges	numeric	Percent of all bridges which are deficient
count_good_bridges	numeric	Number of sufficient bridges
pct_good_bridges	numeric	Percent of all bridges which are sufficient