Hubble by Deck


This table includes a single row for a district -- representing a political geography associated with an office-holder (or, in the case of multimember districts, two or more office-holders).
Each district has a larger jurisdiction that it belongs to and an office that it is associated with. For example, Georgia State House District 2 is associated with the jurisdiction “Georgia” and the office “State House.” For jurisdiction-wide offices like Governor, Mayor, and County Administrator, a district will encompass its entire jurisdiction. We define jurisdictions as political entities associated with a geography that have the legal power to administer elections, define districts, and create elected offices.
When redistricting occurs and a given district is redrawn, a new record in this table is created with the new version of that district. For example, John Lewis represented the 5th Congressional District of Georgia from 1986 through 2020. In that time, there would have been four unique versions for his district -- from the 1980, 1990, 2000, and 2010 Census redistricting periods (Districts may also have unique entries between redistricting cycles, though their shape values will not have changed.)


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.)
What type of political geography a given district represents. Possible values include “state,” “county,” “incorporated place,” “congressional district,” “state legislative district upper” (i.e., state senate districts), “state legislative district lower” (i.e., state house districts), “city council,” and “county council.”
The name of a given district. Georgia State House District 2 will be named “2,” for example.
The position of a given district. This field is only relevant when the same district elects multiple office-holders in distinct contests. It should only vary in “staggered” or “post”-style multimember districts.
The year a given district was active. If there is not a district for a given jurisdiction, office, and district name/position defined for a subsequent year, it should be assumed that the most recent year's version is still in effect. (If this value is NULL, as in the case of states and counties, the district's shape is not assumed to change.)
jurisdiction state
The state (two-letter abbreviation) that the district’s jurisdiction is associated with.
jurisdiction type
The type of jurisdiction this district is associated with. Possible values are “state,” “county,” and “incorporated place.” Districts can also be associated with local education agencies, but those are currently outside the scope of Hubble.
jurisdiction name
The name of the jurisdiction associated with a given district.
office name
The name of the elected office associated with a given district.
winners elected
The number of office-holders elected for a given district. This field should only be higher than 1 in “bloc”-style multimember districts.
A polygon of the district's shape, represented in BigQuery's GEOGRAPHY data type.

Example entry

"district_id": "d817c310-ce8f-4df0-94d5-d8a5634e4193",
"type": "state legislative district lower",
"name": "5",
"position": "1",
"year": "2010",
"jurisdiction_state": "AK",
"jurisdiction_type": "state",
"jurisdiction_name": "AK",
"office_name": "State House",
"winners_elected": "1",
"shape": "POLYGON((-112.016347 33.370803, -112.016591 33.370742, ...))"