right? I am doing it in perl, but that's because mysql not complying with a table import at this moment and mysqlworkbench has decided to not work either.
Oh i'm just limiting it because the dataset is huge for now. if we start getting hits I'll open it all the way.
comparing old ass michigansers to the SSN file now
there are 13k voters registered as of 2020 born before 1920
cat EntireStateVoters.csv | awk -F, '$5 ~ /19[0-1][0-9]/ {print $0}' > Migichan-Voters-2020-born-before-1920.csv
wc 13144 Migichan-Voters-2020-born-before-1920.csv
update to update:
882311 EntireStateVoter.csv.
(source http://69.64.83.144/~mi/download/20200302/EntireStateVoter.zip
28607399 ssdm1_formatted 29245005 ssdm2_formatted 28607399 ssdm3_formatted 86459803 total
ssdm records (i think it's as of 2011, not sure, source is http://ssdmf.info/download.html)
update to my other comment
I have the michigan registration records (says 2020)
I have social security death records.
I will now compend the registration records against the ballot received from curl requsts, i guess? then if they voted match it against the death index.
Hi. Here's the update
I just got the SSN death index rolls formatted and plugging them into a database. gives first last, date death, date birth.
I am now looking for a copy of michigan voter rolls in complete.
I will then do a "JOIN" query in mysql, essentially matching up the columns
then i will give you the results.
I need the voter rolls in a CSV or database format. if anyone has it please give it tome
You don't need help, you need a programer. working on it .
--data-raw 'FirstName=WILMA&LastName=MCINTOSH&NameBirthMonth=5&NameBirthYear=1918&ZipCode=48864&Dln=&DlnBirthMonth=0&DlnBirthYear=&DpaID=0&Months=&VoterNotFound=false&TransistionVoter=false'
so I'm writing a script to request this for everything and your csv, any that contain ballot received in the response indicated they voted.
EDIT: or i could just look at the last column, crap.
EDIT: making progress, upvote for visibility. might need help.
my wife asked me if I thought Trump would win at dinner. I realized, that even if he lost, I would go on with my life, a little sad, but not triggered or reeing into the night. That made me realize I am not insane.
I am looking forward to PA, AZ, and the recounts in the rust belt.
yep. keep fighting, every damn day!
If anything a 270-260ish race is not a 'we won handidly' as much it is a 'we got 4 more years to finish the job.
Trump is winning PA by 700k. 75% of results are in, with 7 mill currently cast so, that leaves about 1.75 mill votes left
lol nah me and my neighbors have work tomorrow
Philly has already tabulated 75k mail in votes.
https://results.philadelphiavotes.com/VoterTurnoutDetails.aspx?
Here's our city site
EDIT: South philly based italians and Bridesburg, and the north east might just carry this entire election.
try living in philly. People are cucked for democrats and literally seethe over trump doing anything. You'd be suprised how powerful the plantation is
about 700k up. 5 counties in SE are the stronghold for dems and not reporting too much. However, philadelphia is voting 25% for TRUMP which is unprecidented and bucks one of those 5 counties is red, another county, chester is about 50/50 so not a huge help. That leaves allegheny (Pittsburgh),montco, delco, and phila county to need to make up 700k lead for biden to win
votes still coming in from PA.
up 700k in PA.... that's big league
uh. 25% in philadelphia is AMAZING news. Obama won all surrounding counties for philadelphia. and won philadelphia with 86%. Being the most populus part of the state, dems depend on it heavily to win. I think it looks good in PA,
CNN POLLSTERS NOW HANGING DRYWALL
BUCKS county going red red red
OHIO IS FOR LOVERS
love to hear more, I am doing nationwide death records so it's a hunk of rows. data is kind of crap so i am cleaning it up to import.