education

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 education attainment of past and current candidates from ballotready, which we've linked to our districts docid\ kdauezki9ijql2gz9 l3z and voters docid 3oen1vuistn6yqclc0u9u tables overview the education dataset, one of the many datasets available through ballotready’s data packages, is used to explore the education 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 the type of degree the person attained, or search for specific areas of study or universities whether you are looking to contact candidates or officeholders with specific backgrounds, such as teachers, engineers, or military veterans; identify people with roots in your geographic area; or decide which candidates your organization wants to support this election year, the education dataset helps you hone in on your specific goals data structure this dataset includes one row per degree attained per person if a candidate has multiple degrees from the same university, those will appear as separate records these records will be accurate as of the most recent candidacy for the person information on the person's education is provided as presented on their campaign website(s) or social media using the candidate's own words education that is not for progress towards a degree or diploma is not included 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 degrees attained 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 education records may be repeated for each position they ran for, because our education records are associated with the candidate record candidate id integer a unique identifier for the person in the ballotready database education id integer a unique identifier for the education record in the ballotready database school character varying the name of the school where the person received their degree information on the person's education is provided as presented on their campaign website(s) or social media using the candidate's own words education that is not for progress towards a degree or diploma is not included this information is only provided where ballotready covered the person's candidacy degree character varying the type of degree that the person received (e g , high school diploma, associate's, bachelor's, master's, jd, etc ) major character varying the specific field of study related to the person's degree, typically used for associate's, bachelor's, and master's degree types grad year integer the graduation year of the person for the degree, if provided education created at timestamp a timestamp of when the education record was created education updated at timestamp a timestamp of when the education record was most recently updated