office_holders

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 past and current elected officeholders from ballotready, which we've linked to our districts docid\ kdauezki9ijql2gz9 l3z and voters docid 3oen1vuistn6yqclc0u9u tables overview the officeholders dataset, one of the many datasets available through ballotready’s data packages, is used to explore current and historical elected officials at all levels of government across the country, from congress to local school boards you can easily filter this dataset to focus on positions of interest by location, government level, position types, and officeholders who started or ended their term off cycle our dataset includes officeholder phone, email, mailing address, government website, social media links, and the party of the officeholder listed on the ballot when they ran for office whether you are looking to contact elected officials that your organization wants to reach for advocacy around policy or legislative decisions; identify officeholders that you want to challenge or support in an upcoming election; or search for officeholders at a lower level of government that you want to recruit to run for higher office, the officeholders dataset is a perfect starting point for your programming as with all of our datasets, the officeholders dataset can be combined with other datasets to build a data package that meets all of your needs our candidate education, work experience, issue stances, and endorsements datasets can seamlessly combine with our officeholders dataset to provide you with a holistic picture of each individual's background when they ran for office our elections & races dataset will help you identify the upcoming primary and general election dates for each position, and our candidacies dataset will give you a full picture of each person the officeholder faced in their races to win their seat data structure this dataset includes one row per person and office term for example, if a person has held a congressional seat across multiple elections, they will have an individual record for each 2 year term in the house when a position is vacant, we create an officeholder record with no associated candidate record or associated name information, but we still provide the approximate dates that the position has been vacant various id fields can be used to track people and positions across terms candidate id can be used to identify all of the terms a person has held across multiple years and elected positions position id can be used to track the people who have held a given position over time a position id will remain static even through redistricting, when the position changes geographic boundaries normalized position id can be used to identify positions of the same type, such as state senators, city mayors, or local school boards other fields in the dataset serve as attributes about the officeholder term, but can also be used to filter down to the elected officials that are most applicable for your needs for example, you could choose to filter on level to take a deeper look at city level positions, or filter on appointed and is off cycle to find the people who gained the office outside of regularly scheduled elections field type description office holder id integer a unique identifier for each instance of an officeholder's term for a position in the ballotready database start at timestamp a date corresponding the start date of the officeholder's term end at timestamp a date corresponding the end date of the officeholder's term term date specificity enumerated ('day,' 'month', 'year') a word that represents how accurate to our start/end dates are for the term for example, if we know the exact date that an officeholder is sworn in, we will have term specificity = 'day' for those entries whereas, for local office holders, start and end dates can vary slightly from term to term in relation to the election date in cases where we know they were elected in november 2020 but do not have an exact start date, we would have start at = 2021 01 01 and term specificity = 'year' to mark that only the portion of the date up to the year should be considered position id integer a unique identifier for each position in the ballotready database position name character varying the name of the position that encompasses both official ballot and ballotready position naming conventions sub area name character varying a parsed portion of the position name, used to help identify the specific area the position represents sub area name is used to identify the type of sub area (e g , "district" or "region") sub area value character varying a parsed portion of the position name, used to help identify the specific area the position represents sub area value is used to identify the number or office of the subarea (e g , "1" or "west") sub area name secondary character varying a second parsed portion of the position name, used to help identify the specific area the position represents when there are two levels of sub area for example, a position with the name "smith county council region 1, seat 2" would have sub area name = 'region', sub area value = '1', sub area name secondary = 'seat' and sub area value secondary = '2' sub area value secondary character varying a second parsed portion of the position name, used to help identify the specific area the position represents when there are two levels of sub area for example, a position with the name "smith county council region 1, seat 2" would have sub area name = 'region', sub area value = '1', sub area name secondary = 'seat' and sub area value secondary = '2' state character varying the state in which the position is elected level character varying an identifier for the level of the position federal, state, regional, county, city, or local tier integer ballotready defined tiers of coverage (1 5), as described here https //support ballotready org/ballotready data tiers position and candidate research normalized position id integer a unique identifier for each generic position type (e g , county clerk, city legislative, etc ) normalized position name character varying describes the generic position type (e g , county clerk, city legislative, etc ) double slash symbols "//" represent an "or", typically when the same type of position can go by different terms a single slash accompanied by "(joint)" represents a position that is responsible for functions typically performed by multiple positions is judicial boolean a boolean marked as true if the position is for electing a judge number of seats integer the maximum number of people who will be elected to that position during a given race note that staggered term positions will have seats on a board split over multiple positions for example, a 5 member board that elects 2 members in 2024 and 3 members in 2026 will have two separate position records, one with 2 seats and one with 3 seats office title character varying an alternative position name, intended to be used with officeholder data when the position listed on a ballot is different than the officeholder's position name this is primarily used for judicial retention positions where a position is listed as "jefferson county court judge (retain melton?)" on the ballot, but once the person is in office they should just be referred to as "jefferson county court judge" mtfcc character varying tabulation area defined by the census bureau values starting with x are from ballotready's custom research maf/tiger feature class code (mtfcc) is a 5 digit code assigned by the census bureau intended to classify and describe geographic objects or features https //www census gov/library/reference/code lists/mt feature class codes html# text=the%20maf%2ftiger%20feature%20class,in%20the%20tiger%2fline%20products geo id character varying geographic identifier defined by the census bureau geo id/fips code describing the type of place the body is associated with, according to the census specification https //www census gov/programs surveys/geography/guidance/geo identifiers html geofence id bigint a unique identifier for each geofence which encapsulates the geographic region related to the officeholder's record in the ballotready database candidate id integer a unique identifier for the person in the ballotready database officeholder records without a candidate id represent a position that is vacant during the given term dates first name character varying the first name of the person as it appears on the ballot or an official government website middle name character varying the middle name of the person as it appears on the ballot or an official government website last name character varying the last name of the person as it appears on the ballot or an official government website suffix character varying the suffix of the person as it appears on the ballot or an official government website nickname character varying the nickname of the person as it appears on the ballot or an official government website candidacy id integer a unique identifier for each instance of a candidate running for a position for a certain election in the ballotready database this field will be null if ballotready did not cover the candidacy of the officeholder when they were elected for this term contacts json the office holder's phone number and email address, sourced from the government website or the relevant election/appointment authority central phone used to record the capitol office phone number for elected federal and state level office holders office phone used to record the home district phone number for federal and state level office holders as well as is the primary office phone number for all other office holders; there is no classification of numbers by mobile or landline other phone used when an additional option is presented on an office holder website, typically a toll free number or secondary office party names array identifies the name of the party or parties the officeholder was listed under on a ballot party affiliations are not provided for appointed officeholders appointed boolean a boolean marked as true if the office holder was appointed rather than elected this can be true for regularly appointed positions or regularly elected positions where an office holder was appointed to fill a vacancy most exports do not include regularly appointed positions, unless requested refer to positions data for information on whether the position is regularly appointed or elected is off cycle boolean a boolean marked as true if the office holder is holding a partial term that does not adhere to scheduled start and end dates this may be due to an office holder leaving office early, a vacancy, a new office holder from a special election or mid term appointment office holder mailing address line 1 character varying the mailing address of the office holder parsed into distinct fields this address may be at the capitol office or a po box, which is not physically within the office holder's district office holder mailing address line 2 character varying the mailing address of the office holder parsed into distinct fields office holder mailing city character varying the mailing address of the office holder parsed into distinct fields office holder mailing state character varying the mailing address of the office holder parsed into distinct fields office holder mailing zip character varying the mailing address of the office holder parsed into distinct fields urls json identifies the officeholder's government website or social media link and the type of url is vacant boolean a boolean marked as true if the position is vacant for the given term dates office holder created at timestamp a timestamp of when the office holder record was created office holder updated at timestamp a timestamp of when the office holder record was most recently updated