Tuesday, May 28, 2019

2018 Reconciliation Reports

GE 2018 Reconciliation data from an Excel spreadsheet at  For more information about WA GE 2018 turnout see this link. Click to enlarge the chart.

Friday, May 24, 2019

Some information on WA voter data in anticipation of 2019

This post gives examples of data publicly available for candidates look to understand voter registration and participation. Below the break are some interesting tables from a SOS WA site that has a useful (historical) voter participation excel spreadsheet. There is also a very detailed 2018 Election Report which has excellent graphs and tables describing the effect the new "stampless ballot" on returns for 2018 primary and general elections. As always, there is very detailed data available for every recent election. Your local county or WA State can provide you with voter registration data or historical matchbacks and results for local elections. Some of that this data may require data analyst skills to parse.   There are essentially three different types of elections below:

  • Presidential year (every four years)
  • Congressional without Presidential (e.g. 'midterm') (every fourth even year)
  • Local Election Year only (every other year)

2019 will be a local election year only. I have appended the GE 2018 turnout percentage to each column below to give some idea how much increased recent turnout has become.  There are two different types of turnout here:

  • Total Ballots / Total Voters
  • Total Ballots / Total Population

King (pop 2.2M ) and Whatcom (pop 225K) counties usually have very high turnout and registration numbers despite having very different sized populations. Only populations over 18 can vote. A special Census tabulation gives 'CVAP' (Citizen Voting Age Population) information about voting populations per county by demographic groups. In Appendices 1 & 2 below current citizen, CVAP, registration statistics are displayed.  This data is probably best viewed on a wide screen.

Friday, May 17, 2019

2018 Net Migration

Below are some charts I created with the help of Kyle Walker's excellent tidycensus library and also a few other important libraries like tidyverse and sf. For more information, please see:


For me, the effect of this map is to show vast swaths of the midwest and northeast draining into states like Florida, Georgia,Texas, Washington, Oregon and to a lesser degree Colorado, North Dakota, Nevada and Arizona. Washington and Georgia Counties are shown as separate maps. If I had to guess, I would say much of the country is fed up with polar freezes, drought, fire and hurricanes. Apparently, they have decided to trade all of that for continual drizzle and rain in Portland and Seattle. Or maybe there are only three choices now for really smart youth seeking high incomes: San Francisco, Portland, or Seattle. Some example data and 2015:2018 growth Census derived tables for King and Whatcom Counties are far below.   Click to enlarge the maps.