Data dictionary: Endorsements
There are two types of endorsements files — one for ballot measures and one for candidates.
Candidate endorsements
year
candidate_id
The candidate that is receiving the endorsement (endorsee). This is a unique identifier that links to the candidates file.
endorsement_id
Unique identifier for this endorsement
endorsement_stage
If the endorsement is relevant to a specific stage of the election, as opposed to the entire campaign, this can be defined here with one of the following values: -Convention -Primary -Primary Runoff -General -General Runoff
Primarily, this is used to distinguish "General" from "Primary" endorsements.
endorser_type
May be one of the following categories, or NULL: -Candidate -Former Official -Government-Federal Administration -Government-Governors -Government-Judicial -Government-Local -Government-Mayors -Government-Other -Government-President -Government-State Representatives -Government-State Senators -Government-U.S. House -Government-U.S. Senate -Individual-Community Leader -Individual-Other -Media-Newspaper -Media-Other -Organization
endorser_name
The person or organization that is making the endorsement
endorser_organizations_id
Unique identifier if the endorsement is made by an organization
endorser_person_id
Unique identifier if the endorsement is made by a person (individual)
source
office_level
One of the following, based on the office sought by endorsee: -Federal -State -Local -ultralocal*
*This is a Ballotpedia-specific designation for local elected offices outside of the top 100 cities in the U.S. by population
office_branch
One of the following (or NULL), based on the office sought by endorsee: -Executive -Legislative -Judicial
state
State postal abbreviation (i.e. "AL")
Ballot measure endorsements
ballot_measure_id
Unique identifier that links to the ballot measure file
support_oppose
Either "Support" or "Oppose", where the latter means the endorser is campaigning against the measure.
endorsement_id
Unique identifier for this endorsement
endorser_type
May be one of the following categories, or NULL: -Candidate -Former Official -Government-Federal Administration -Government-Governors -Government-Judicial -Government-Local -Government-Mayors -Government-Other -Government-President -Government-State Representatives -Government-State Senators -Government-U.S. House -Government-U.S. Senate -Individual-Community Leader -Individual-Other -Media-Newspaper -Media-Other -Organization
endorser_name
The person or organization that is making the endorsement
endorser_organizations_id
Unique identifier if the endorsement is made by an organization
endorser_person_id
Unique identifier if the endorsement is made by a person (individual)
source
election_year
state
State postal abbreviation (i.e. "AL")
Last updated