CREATE TABLE table_25074 ("State  ( class ) " CLOB, "Vacator" CLOB, "Reason for change" CLOB, "Successor" CLOB, "Date of successors formal installation" CLOB)

what is the state for reason for change is resigned may 15, 1820?
SELECT "State (class)" FROM table_25074 WHERE "Reason for change" = 'Resigned May 15, 1820'
SELECT "State (class)" FROM "table_25074" WHERE "Reason for change" = 'Resigned May 15, 1820'