PCount2013 | PCount2014 | Precincts2014 | PCountDiff |
443 | 384 | 158 | -59 | |||||||||
643 | 581 | 611 | -62 | |||||||||
917 | 851 | 144 | -66 | |||||||||
865 | 772 | 106 | -93 | |||||||||
1128 | 999 | 126 | -129 | |||||||||
1004 | 828 | 135 | -176 | |||||||||
1043 | 836 | 136 | -207 | |||||||||
746 | 530 | 154 | -216 | |||||||||
1113 | 884 | 145 | -229 | |||||||||
1293 | 1056 | 108 | -237 | |||||||||
85,338 | 85,375 | 37 | ||||||||||
PCount2013 | PCount2014 | Precincts2014 | PCountDiff |
Changes in Active 42nd voterdb last month by week
Select Count(registrationnumber) from voterdb090514 where statuscode = 'A' and precinctid in (Select precincts42 from ld42);count
-------
86593
Select Count(registrationnumber) from voterdb091014 where statuscode = 'A' and precinctid in (Select precincts42 from ld42);
count
-------
85794
Select Count(registrationnumber) from voterdb092314 where statuscode = 'A' and precinctid in (Select precincts42 from ld42);
count
-------
85053
Select Count(registrationnumber) from voterdb100214 where statuscode = 'A' and precinctid in (Select precincts42 from ld42);
count
-------
85427
Changes in Inactive 42nd voterdb last month by week
Select Count(registrationnumber) from voterdb090514 where statuscode = 'I' and precinctid in (Select precincts42 from ld42);count
-------
6616
Select Count(registrationnumber) from voterdb091014 where statuscode = 'I' and precinctid in (Select precincts42 from ld42);
count
-------
7459
Select Count(registrationnumber) from voterdb092314 where statuscode = 'I' and precinctid in (Select precincts42 from ld42);
count
-------
8470
Select Count(registrationnumber) from voterdb100214 where statuscode = 'I' and precinctid in (Select precincts42 from ld42);
count
-------
8295
No comments:
Post a Comment