def METHOD_NAME(self, candidate_data):
    sql_insert = (
        "INSERT INTO disclosure.cand_valid_fec_yr \
        (cand_valid_yr_id, cand_id, fec_election_yr, cand_election_yr, \
        cand_status, cand_office, cand_office_st, cand_office_district, date_entered) \
        VALUES (%(cand_valid_yr_id)s, %(cand_id)s, \
        %(fec_election_yr)s, %(cand_election_yr)s, %(cand_status)s, %(cand_office)s, \
        %(cand_office_st)s, %(cand_office_district)s, %(date_entered)s)"
    )
    self.connection.execute(sql_insert, candidate_data)