2018 Filing week is over... (Part III)

Click to Enlarge WA Map of LD, CD, Precincts.

WA State filing week is over. The state lists 416 Legislative, Congressional, Judicial and Federal candidates for office.  Each county also has local offices.You can find more information at these URLs:
https://weiapplets.sos.wa.gov/elections/Candidates/WhoFiled? 

Download:
https://weiapplets.sos.wa.gov/Elections/Candidates/ExportToExcel?electionYear=0&countyCode=XX # all state
https://weiapplets.sos.wa.gov/Elections/Candidates/ExportToExcel?electionYear=0&countyCode=WM # Whatcom 


Some lists with R Code (from data.table library) below the break. Font needs wide screen and probably some zoom.

Here Comes Filing Week : Part II

Filing week is upon us. You can check here:

 

https://weiapplets.sos.wa.gov/elections/Candidates/WhoFiled? # Entire State

https://weiapplets.sos.wa.gov/elections/Candidates/WhoFiled?countyCode=wm # Whatcom County

 

Below the break are tables of GE 2016 Presidential and Legislative votes by County and Legislative District.

A Postgres query  like this:

 Guy Palumbo        | Legislative District 1 - State Senator  | 28003 #KI only

 Mindie Wirth       | Legislative District 1 - State Senator  | 22395 #KI only

 Mindie Wirth       | Legislative District 1 State Senator    | 30850 # “Rest of State” not KI

 Guy Palumbo        | Legislative District 1 State Senator    | 40758 # “Rest of State” not KI

can be confusing because it shows King County ("KI") and Rest of the State ("ROS") in two separate entries.

Far below, LDs split between KI and “ROS” are expressed like this as an R (data.table) query:

  LD KI_TRUMP ROS_TRUMP KI_CLINTON ROS_CLINTON Trump Clinton

  1     5987     16836      14921       31482 22823   46403

or split between LD ~ County for KI and “ROS” like this:

   LD County KI_TRUMP ROS_TRUMP KI_CLINTON ROS_CLINTON Trump Clinton

   1     KI     5987         0      14921           0  5987   14921

   1     SN        0     16836          0       31482 16836   31482

Let me know if you have any questions or find any errors. No warranty for this data is expressed or implied. Use at your own risk.

-RMF 1:12 PM 5/14/2018

Here Comes Filing Week 2018 (Part I)

Filing week starts May 14th. 2018 is a Congressional and Legislative District election year. The maps of WA state above give counties in blue outline, LDs in solid color and CDs in black outline.  The more densely populated the district the smaller the size of the  district.  The maps above are created data from WA OFM. Click to enlarge charts in a separate window. Let me know if you have any questions or find any errors. No warranty for this data is expressed or implied. Use at your own risk.