endorsements

to help users get the best information about past and future elections, we've worked with ballotready to build a crosswalk between our datasets this table includes proprietary data on the endorsements received by past and current campaigns from ballotready, which we've linked to our campaigns docid\ ddif6z6lr1 lmr6ov4exm , districts docid\ kdauezki9ijql2gz9 l3z , and voters docid 3oen1vuistn6yqclc0u9u tables overview the endorsements dataset, one of the many datasets available through ballotready’s data packages, is used to explore the endorsements that candidacies have received, sourced from hundreds of endorsing organizations across the country this dataset serves as an addendum to our candidacies dataset to provide information on the groups that are supporting candidates and cues as to where they stand on various policy issues you can easily filter this dataset to identify the issue area of the endorsing organization or the organization’s name whether you are looking for historical endorsement information to recruit candidates aligned with your values; analyze the impact of specific endorsing organizations; or decide which candidates your organization wants to support this election year, the endorsements dataset helps you hone in on your specific goals data structure this dataset includes one record per endorsement per race for example, if a person was endorsed by an organization in both their primary and general race, they will have two separate records for each various id fields can be used to track people and positions between this dataset and our candidacies datasets candidacy id can be used to to join this dataset to the candidacies dataset and identify the endorsements that the candidate received during a given race candidate id can be used to find all of the endorsements received by a person over multiple election years and races position id can be used to track the endorsements given for the same position across multiple cycles field type description position id integer a unique identifier for each position on a ballot in the ballotready database candidate id integer a unique identifier for the person in the ballotready database candidacy id integer a unique identifier for each instance of a candidate running for a position for a certain election in the ballotready database endorsement id integer a unique identifier for the endorsement record in the ballotready database issue id integer a unique identifier for the issue category in the ballotready database issue category character varying the type of policy area that the organization focuses on for their endorsements (e g , civil rights, guns) or the type of organization if they do not make endorsements based on specific policy issues (e g , media organization) organization id integer a unique identifier for the endorsing organization in the ballotready database; for organizations that ballotready regularly tracks for endorsement gathering organization name character varying the name of the organization making the endorsement; for organizations that ballotready regularly tracks for endorsement gathering endorser character varying the name of the organization or person making the endorsement this is typically the same as the value in organization name when ballotready regularly tracks that organization's endorsements organization description text a description of the endorsing organization, pulled from the organization's website website url character varying a link to the website where the organization publishes their endorsements endorsement created at timestamp a timestamp of when the endorsement record was created endorsement updated at timestamp a timestamp of when the endorsement record was most recently updated