The online registration and update period for existing voters has ended ....

The online registration and update period for existing voters has ended. New WA State voters may continue to register in person (at the Whatcom County Courthouse) until October 27th. The columns below represent the delta (Orig Election Total - Active Vote Total) by week last month in the Active voter rolls for those who voted in the August Primary and the November 2013 GE. Your ballots will be mailed in Whatcom County starting October 15th.

 42,736 08/19/2014 < Total Votes in August Primary
 42,671 09/05  65
 42,658 09/10  78
 42,568 09/19  168
 42,633 09/23  103
 42,629 10/06  107


 69,709 11/25/2013 < Total Votes in November 2013 General
 68,602 09/05 1107
 68,579 09/14 1130
 67,620 09/19 2089
 68,501 09/23 1208
 68,368 10/02 1341


SQL below the break


-- ballotcounted_1 is the August Primary

 Select Count(registrationnumber) from voterdb090514 where ballotcounted_1 = '1';
 count
-------
 42671
(1 row)

Select Count(registrationnumber) from voterdb091014 where ballotcounted_1 = '1';
 count
-------
 42658
(1 row)

Select Count(registrationnumber) from voterdb091914 where ballotcounted_1 = '1';
 count
-------
 42568
(1 row)

Select Count(registrationnumber) from voterdb092314 where ballotcounted_1 = '1';
 count
-------
 42633
(1 row)

-- using state database fields
Select Count(lastvoted) from voterdb100614_s where lastvoted LIKE '08/05/2014' and CountyCode = 'WM';
 count
-------
 42629



-- ballotcounted_x is the 2013 General Election
Select Count(registrationnumber) from voterdb090514 where ballotcounted_2 = '1';
 count
-------
 68602
(1 row)

Select Count(registrationnumber) from voterdb091014 where ballotcounted_4 = '1';
 count
-------
 68579
(1 row)

Select Count(registrationnumber) from voterdb091914 where ballotcounted_2 = '1';
 count
-------
 67620
(1 row)

 Select Count(registrationnumber) from voterdb092314 where ballotcounted_2 = '1';
 count
-------
 68501
(1 row)

 Select Count(registrationnumber) from voterdb100214 where ballotcounted_1 = '1';
 count
-------
 68368
(1 row)