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

How many vacant seats were filled by newcomer Joseph H. Bottum (r)?
SELECT COUNT("Vacator") FROM table_1797 WHERE "Successor" = 'Joseph H. Bottum (R)'
SELECT COUNT("Vacator") FROM "table_1797" WHERE "Successor" = 'Joseph H. Bottum (R)'