CREATE TABLE table_49818 ("Name" CLOB, "Built" CLOB, "Listed" CLOB, "Location" CLOB, "County" CLOB)

In which county is the swann covered bridge located?
SELECT "County" FROM table_49818 WHERE "Name" = 'swann covered bridge'
SELECT "County" FROM "table_49818" WHERE "Name" = 'swann covered bridge'