This table includes a single row for almost every campaign in state and federal elections since 2010. It includes the candidate’s name, party affiliation, and incumbency status. It also includes foreign keys to our `district` and `election` tables.
A given candidate might have many entries in this table. For example, as of December 19, 2020, Alexandria Ocasio-Cortez has four entries. That includes one entry for each of her congressional primaries and general election contests. Each of those entries would share the same
district_id, but have unique values for
Unique ID maintained by Deck representing a specific campaign. We define a campaign as an instance of a specific candidate running for a specific office or party nomination. If the same candidate ran in a primary and general election in both 2018 and 2020, they would have four campaign entries across those contests.
Unique ID maintained by Deck representing a specific person running for a specific office in a specific district, which is kept the same across elections.
Unique ID maintained by Deck representing a specific political district. We define a district as a geographic subdivision of a jurisdiction that is associated with a specific office. For example, Idaho State House District 2 is a single district. Its associated office is Idaho State House and its associated jurisdiction is Idaho. (For jurisdiction-wide offices, like Governor and Mayor, the district can encompass the entirety of its jurisdiction.)
Unique ID maintained by Deck representing a specific election. We define an election as an opportunity for registered voters in a given jurisdiction to cast a ballot for one or more offices.
The election date of a given campaign as a float ex.
Proper case office name such as U.S. Senate, U.S. House and State House.
The name of a given district. Georgia State House District 2 will be named “2,” for example.
name first primary
A candidate’s primary first name -- typically their legal first name.
name first alternate
A candidate’s alternate first name, if applicable. This would typically be a nickname.
A candidate’s middle name.
name last primary
A candidate’s primary last name -- typically their full, legal last name.
name last alternate
A candidate’s alternate last name, if applicable. This could be a maiden name, an alternate presentation of a hyphenated or accented name, or a variation of the primary last name in the event of ambiguity.
A value of “incumbent” if the candidate is currently holding the office in question, “challenger” if the candidate is running against the current office-holder, or “open” if the current office-holder is not running for the office.
The candidate’s stated party affiliation. Note: if a candidate is on the ballot in affiliation with multiple parties (such as the Working Families Party, which is a common second ballot line for New York progressives), we only include one party here: the one with the most electoral success.
"office_name": "State House",