# Data dictionary: Officeholders

The officeholders data set includes current, elected officeholders for Congress, statewide positions, state legislative positions, as well as elected officials in the [top 100 cities by population](https://ballotpedia.org/Largest_cities_in_the_United_States_by_population#America.27s_largest_cities).

{% hint style="info" %}
Ballotpedia also maintains a comprehensive directory of school board members across the U.S. Please inquire with our sales team for more information about this.
{% endhint %}

## Office, District (Geography)

| column\_name           | description                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| ---------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| state                  | The state in which the office has jurisdiction (postal abbreviation)                                                                                                                                                                                                                                                                                                                                                                                             |
| office\_id             | Ballotpedia unique identifier (stable across officeholders)                                                                                                                                                                                                                                                                                                                                                                                                      |
| office\_name           | Name of the office                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| office\_level          | <p>Level of government:</p><p>-Federal</p><p>-State</p><p>-Local</p>                                                                                                                                                                                                                                                                                                                                                                                             |
| office\_branch         | <p>Branch of government:</p><p>-Executive</p><p>-Legislative</p><p>-Judicial</p>                                                                                                                                                                                                                                                                                                                                                                                 |
| district\_id           | Ballotpedia unique identifier                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| district\_ocdid        | The[ Open Civic Data Division Identifiers](https://github.com/opencivicdata/ocd-division-ids) project seeks to assign somewhat predictable and globally unique identifiers to political divisions. This field is not uniformly filled due to data availability.                                                                                                                                                                                                  |
| district\_name         | Name of district (geographical area) that elects the office.                                                                                                                                                                                                                                                                                                                                                                                                     |
| district\_type         | <p>Type of district that elects the office:</p><p>-Country</p><p>-State</p><p>-Congress</p><p>-State Legislative (Upper)</p><p>-State Legislative (Lower)</p><p>-County</p><p>-School District</p><p>-City-town</p><p>-Judicial District</p><p>-Special District</p><p>-State subdivision</p><p>-County subdivision</p><p>-Judicial district subdivision</p><p>-Special district subdivision</p><p>-City-town subdivision</p><p>-School district subdivision</p> |
| parent\_district\_id   | Ballotpedia unique identifier used to associate a "subdivision" district with its parent (not comprehensive). Example: "X City Council, District 1" and "X City Council, District 2" have a parent district of "X City".                                                                                                                                                                                                                                         |
| parent\_district\_name | Name of parent district                                                                                                                                                                                                                                                                                                                                                                                                                                          |

## Officeholder

| column\_name          | description                                                                                                                                               |
| --------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------- |
| officeholder\_id      | Ballotpedia unique identifier                                                                                                                             |
| person\_id            | Ballotpedia unique identifier (stable across time or offices held)                                                                                        |
| name                  | Full name of the officeholder                                                                                                                             |
| first\_name           | First name of the officeholder                                                                                                                            |
| last\_name            | Last name of the officeholder                                                                                                                             |
| url                   | Link to the Ballotpedia profile about this person                                                                                                         |
| gender                | <p>One of the following, or NULL:</p><p>-Male</p><p>-Female</p><p>-Neither/Both (if the person explicitly identifies as neither or both of the above)</p> |
| status                | <p>Describes the status of the officeholder. One of the following:</p><p>-Current</p><p>-Acting</p><p>-Elect</p><p>-Magistrate</p><p>-Senior</p>          |
| party\_affiliation    | Primarily for officeholders elected in partisan elections, this is the political party with which they are/were affiliated.                               |
| date\_assumed\_office | Date on which they assumed this office (swearing in date or similar)                                                                                      |
| appointed\_by         | If relevant, the name of the person who appointed this officeholder to this office (such as a Governor)                                                   |
| date\_appointed       | Date of the appointment                                                                                                                                   |
| date\_confirmed       | Date of the confirmation (judicial)                                                                                                                       |
| date\_term\_ends      | For former or outgoing officeholders, the date on which they left or will leave office                                                                    |

## Contact information (add-on)

*Contact information is optional, available for an additional charge.*

Values are listed below. The "officeholder" contact is the one used in an official capacity, while "personal" represents contacts or accounts that may not relate to the person's current position.

Values:

* officeholder\_email
* other\_email
* officeholder\_website
* personal\_website
* officeholder\_facebook
* personal\_facebook
* officeholder\_x
* personal\_x
* officeholder\_tiktok
* personal\_tiktok
* officeholder\_instagram
* personal\_instagram
* officeholder\_youtube
* personal\_youtube
* officeholder\_mailing\_address
* officeholder\_phone
* linkedin