user: ### NOW ANSWER:
Question: How many Vacators were listed when the district was North Carolina 3rd?
Columns: ['District', 'Vacator', 'Reason for change', 'Successor', 'Date successor seated']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['Massachusetts 4th', 'Joseph B. Varnum (DR)', 'Resigned June 29, 1811 to become U.S. Senator', 'William M. Richardson (DR)', 'Seated November 4, 1811']
SQL:

assistant: SELECT COUNT("Vacator") FROM "Table" WHERE "District" = 'North Carolina 3rd';