Table: lost_candidates
Columns: name
election_year
party
birth_state
resident_state

Question: What was the birth state of Charles Cotesworth Pinckney who was elected in 1808?
SQL: SELECT "birth_state" FROM lost_candidates WHERE "name" = 'charles cotesworth pinckney' AND "election_year" = 1808