DistrictID |
text |
The DistrictID is pulled from the Secretary of State's tblDistrictPreceinct table by joining on PrecinctID.The District ID along with the Precinct ID, Precinct Code, Levy code, and County Code are links between the "My Candidates Address" dataset and "My Candidates Jurisdictions" dataset to convert WA ST jurisdictions into PDC jurisdictions. |
PrecinctID |
text |
The PrecinctID is pulled from the tblPrecinct table in the Secretary of State database. The Precinct ID along with the District ID, Precinct Code, Levy code, and County Code are links between the "My Candidates Address" dataset and "My Candidates Jurisdictions" dataset to convert WA ST jurisdictions into PDC jurisdictions. |
PrecinctCode |
text |
The PrecinctCode comes from the tblPrecinct table in the Secretary of State database. The Precinct Code along with the District ID, Precinct ID, Levy code, and County Code are links between the "My Candidates Address" dataset and "My Candidates Jurisdictions" dataset to convert WA ST jurisdictions into PDC jurisdictions. |
LevyCode |
text |
The LevyCode is queried from the tblPrecinct table in the Secretary of State database.The Levy Code along with the District ID, Precinct Code, Precinct ID, and County Code are links between the "My Candidates Address" dataset and "My Candidates Jurisdictions" dataset to convert WA ST jurisdictions into PDC jurisdictions. |
CountyCode |
text |
The CountyCode is the abbreviation recognized by the Secretary of State that represents a county. The County Code along with the District ID, Precinct Code, Levy code, and Precinct ID are links between the "My Candidates Address" dataset and "My Candidates Jurisdictions" dataset to convert WA ST jurisdictions into PDC jurisdictions. |
jurisdiction_code |
text |
This is a unique code that represent a jurisdiction as recognized by the PDC. |
office_code |
text |
This is a unique code that represents an office within the PDC. |
jurisdiction_county |
text |
This is the county name where a jurisdiction is located. |