Table: senator_succession
Columns: district
vacator
reason_for_change
successor
date_successor_seated

Question: How many vacators have October 22, 1808 as date successor seated?
SQL: SELECT COUNT("vacator") FROM senator_succession WHERE "date_successor_seated" = 'October 22, 1808'

Question: What is the date successor seated where Massachusetts 2nd is the district?
SQL: SELECT "date_successor_seated" FROM senator_succession WHERE "district" = 'Massachusetts 2nd'

Question: Who is the successor when the reason for change is seat declared vacant January 2, 1808
SQL: SELECT "successor" FROM senator_succession WHERE "reason_for_change" = 'Seat declared vacant January 2, 1808'

Question: Which district has John Culpepper (f) as the vacator?
SQL: SELECT "district" FROM senator_succession WHERE "vacator" = 'John Culpepper (F)'