experience

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 past experiences of past and current candidates from ballotready, which we've linked to our districts docid\ kdauezki9ijql2gz9 l3z and voters docid 3oen1vuistn6yqclc0u9u tables overview the experience dataset, one of the many datasets available through ballotready’s data packages, is used to explore the work, elected office, and military history of candidates and officeholders at all levels of government across the country, from congress to local school boards this dataset serves as an addendum to either our candidacies or officeholders dataset, to provide a more holistic view of the person’s background you can easily filter this dataset to identify people who have previous military or elected office experience, and you can search for certain backgrounds using keywords whether you are looking to contact candidates or officeholders with specific backgrounds, such as teachers, engineers, or military veterans; identify people with specific experience relevant to local positions; or decide which candidates your organization wants to support this election year, the experience dataset helps you hone in on your specific goals data structure this dataset includes one record per role per person for example, a person will have one record for each role they held at a company, if they provide those details these records will be accurate as of the most recent candidacy for the person information on the person's experience is provided as presented on their campaign website(s) or social media using the candidate's own words some records may be more generic if that is how the candidate chooses to communicate their experience, such as “teacher” or “10 years at the department of justice ” we attempt to capture as much relevant information as possible within the given fields various id fields can be used to track people and positions between this dataset and our candidacies or officeholders datasets candidate id can be used to join this dataset to the candidacies or officeholders datasets, and to find all of the experience records held by the same person position id can be used to track the candidates that have all run 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 a person's experience records may be repeated for each position they ran for, because our experience records are associated with the candidate record candidate id integer a unique identifier for the person in the ballotready database experience id integer a unique identifier for the experience record in the ballotready database entry type character varying a classification for the type of experience (elected office, employment, or military) information on the person's employment, elected office, and military experience is provided as presented on their campaign website(s) or social media using the candidate's own words volunteer experience is not included in our coverage this information is only provided where ballotready covered the person's candidacy company character varying the employer or branch of the military where the person has experience for experience in elected office, this represents the body or government entity that the person served on position character varying the title of the position that the person held start year character varying the year that the person started in this specific position end year character varying the year that the person ended their experience in this specific position when the person is still working in a position at the time of their candidacy, the end year value will be "present " this information is valid at the time of research, indicated by the timestamp in the experience created at field duration integer the total number of years that the person held this specific position, if exact years are not given we return values for the start year and end year fields where available however, this duration field is used when candidates report information such as "i was an elementary school teacher for 12 years" without specifying the dates experience created at timestamp a timestamp of when the experience record was created experience updated at timestamp a timestamp of when the experience record was most recently updated