campaign generic

This table includes a single row for future campaigns through 2027. It includes the type of hypothetical candidate (moderate, Democrat, progressive, or Republican). As such each contest will have four rows. All of the campaigns are considered to be open for incumbency status. It also includes foreign keys to our `district` and `election` tables.
Schema
Field
Description
district id
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.)
office id
Unique ID maintained by Deck representing a specific office. For example, Idaho State House District 2 is a single district. Its associated office is Idaho State House.
district name
This will provide district information for the office. For statewide races it will be the two letter state id. For numbered districts like house and senate, it will be a number.
jurisdiction id
Unique ID maintained by Deck representing a jurisdiction. 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.
office name
Office name (all caps) such as TREASURER, CLERK or GOVERNOR.
office name alt 
The alternative office name (all caps) such as CITY TREASURER or TOWN CLERK. 
state
The two-letter abbreviation for the state.
contest id 
Unique ID maintained by Deck representing a specific contest where contest is defined as a unique combination of a district and an election.
election id
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.
election type 
If a given election was held at a regularly scheduled interval, it is “standard.” If it was held outside of a regular schedule to fill an unexpected vacancy, it is “special.” Elections with unknown types have a null value.
election stage
One of six values (“primary”, “primary run-off”, “general”, or “general run-off”, "convention", "convention run-off") indicating which stage a given election’s contests were at.
election date
The final date (or only date) of voting for a given election as yyyymmdd.
campaign id 
Unique ID maintained by Deck representing a specific generic campaign. We define a campaign as an instance of a specific candidate running for a specific office or party nomination.
candidate id
Unique ID maintained by Deck representing a   running for a specific office in a specific district, which is kept the same across elections.
party 
The party of the hypothetical candidate: Democratic or Republican (all caps).
incumbent
The incumbent status of the hypothetical candidate: open. 
name full
The type of hypothetical candidate: generic moderate, generic progressive, generic Democrat or generic Republican (all caps).
jurisdiction name
The name of the jurisdiction associated with a given district.

Field	Description
district id	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.)
office id	Unique ID maintained by Deck representing a specific office. For example, Idaho State House District 2 is a single district. Its associated office is Idaho State House.
district name	This will provide district information for the office. For statewide races it will be the two letter state id. For numbered districts like house and senate, it will be a number.
jurisdiction id	Unique ID maintained by Deck representing a jurisdiction. 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.
office name	Office name (all caps) such as TREASURER, CLERK or GOVERNOR.
office name alt	The alternative office name (all caps) such as CITY TREASURER or TOWN CLERK.
state	The two-letter abbreviation for the state.
contest id	Unique ID maintained by Deck representing a specific contest where contest is defined as a unique combination of a district and an election.
election id	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.
election type	If a given election was held at a regularly scheduled interval, it is “standard.” If it was held outside of a regular schedule to fill an unexpected vacancy, it is “special.” Elections with unknown types have a null value.
election stage	One of six values (“primary”, “primary run-off”, “general”, or “general run-off”, "convention", "convention run-off") indicating which stage a given election’s contests were at.
election date	The final date (or only date) of voting for a given election as yyyymmdd.
campaign id	Unique ID maintained by Deck representing a specific generic campaign. We define a campaign as an instance of a specific candidate running for a specific office or party nomination.
candidate id	Unique ID maintained by Deck representing a running for a specific office in a specific district, which is kept the same across elections.
party	The party of the hypothetical candidate: Democratic or Republican (all caps).
incumbent	The incumbent status of the hypothetical candidate: open.
name full	The type of hypothetical candidate: generic moderate, generic progressive, generic Democrat or generic Republican (all caps).
jurisdiction name	The name of the jurisdiction associated with a given district.

campaign

district

Last modified 1mo ago