Table: adamson_bridge
Columns: name
built
listed
location
county

Question: When was la vista built?
SQL: SELECT "built" FROM adamson_bridge WHERE "location" = 'la vista'

Question: When was the sargent bridge built?
SQL: SELECT "built" FROM adamson_bridge WHERE "name" = 'sargent bridge'

Question: What's the location for the country of platte?
SQL: SELECT "location" FROM adamson_bridge WHERE "county" = 'platte'

Question: what is the listing date for nuckolls county?
SQL: SELECT "listed" FROM adamson_bridge WHERE "county" = 'nuckolls'

Question: what's the listing date for the verdigris creek bridge in royal of antelope county?
SQL: SELECT "listed" FROM adamson_bridge WHERE "county" = 'antelope' AND "location" = 'royal' AND "name" = 'verdigris creek bridge'

Question: what's the county name for the republican river bridge listed on 1992-06-29?
SQL: SELECT "county" FROM adamson_bridge WHERE "listed" = '1992-06-29' AND "name" = 'republican river bridge'