CREATE TABLE table_45896 ("Name" CLOB, "Listed" CLOB, "Location" CLOB, "County" CLOB, "Type" CLOB)

What type of bridge is Colton's Crossing Bridge?
SELECT "Type" FROM table_45896 WHERE "Name" = 'colton''s crossing bridge'
SELECT "Type" FROM "table_45896" WHERE "Name" = 'colton''s crossing bridge'