Election Database FTP Site Attention all-- The Format is complete, sample pages are posted. Im adding the web site http://press.sosaz.com for those who are having trouble seeing the ftp site ok. I havent been releasing the tables because the format kept changing. Instead of confusing you, Ive just prolonged your wait. I think we finally have something to work with. Again I apologize for the wait. Attached is the table description. Ive posted the Warnning.txt file too so you all should see it. If you see this pop up election night, be sure to read it. Basically there are two key files now, the CANDIDATE file and the OFFICE file. The OFFICE file gives you the base information on which to base statistics: voter reg counts, counties participating in different races, race names etc. The Candidate file is the file that will be changing the most election night. The only thing changing in the OFFICE file is the last field, Number of precincts reported election night. The CANDIDATE Table has three fields in it that makes up the UNIQUE ID, The OfficeId The CandidateId The CountyId If you look for everyone OFFICEID of 8, which by lookup in the OFFICE table is Gov and COUNTYID of 8 which by lookup in the COUNTY table is Maricopa You find that there are 8 candidates: OFFICEID CANDIDATEID COUNTYID PARTYID VOTES NAME 8 6 8 2 0 JOHNSON, PAUL 8 38 8 1 0 HOWL, JIM 8 79 8 4 0 MALCOMSON, SCOTT ALAN 8 128 8 1 0 HULL, JANE DEE 8 139 8 3 0 RAWLES, TOM 8 147 8 1 0 BROWN, CHARLES "CHARLIE" 8 167 8 3 0 GALLANT, KATHERINE "KAT" Each of the number of votes received is zero. To sum for the a single candidate: Lookup OFFICEID of 8 CANDIDATEID of 128 OFFICEID CANDIDATEID COUNTYID PARTYID VOTES NAME 8 128 1 1 0 HULL, JANE DEE 8 128 2 1 0 HULL, JANE DEE 8 128 3 1 0 HULL, JANE DEE 8 128 4 1 0 HULL, JANE DEE 8 128 5 1 0 HULL, JANE DEE 8 128 6 1 0 HULL, JANE DEE 8 128 7 1 0 HULL, JANE DEE 8 128 8 1 0 HULL, JANE DEE 8 128 9 1 0 HULL, JANE DEE 8 128 10 1 0 HULL, JANE DEE 8 128 11 1 0 HULL, JANE DEE 8 128 12 1 0 HULL, JANE DEE 8 128 13 1 0 HULL, JANE DEE 8 128 14 1 0 HULL, JANE DEE 8 128 15 1 0 HULL, JANE DEE which would be: ----------> 0 votes. To get the percentage of the vote obtained by CandidateId =128, simply divide that number by the sum of From the OFFICE table Lookup OFFICEID 8, and sum the registration OFFICEID NAME SLOTS SHORTNAME DISTRICTID COUNTYID PRECINCTS REGISTRATION REPORTING_PRECINCTS RP_BALLOTS_CAST 8 Governor 1 Governor 0 1 44 36521 0 0 8 Governor 1 Governor 0 2 62 48571 0 0 8 Governor 1 Governor 0 3 75 62235 0 0 8 Governor 1 Governor 0 4 40 26499 0 0 8 Governor 1 Governor 0 5 18 15473 0 0 8 Governor 1 Governor 0 6 10 5412 0 0 8 Governor 1 Governor 0 7 10 7858 0 0 8 Governor 1 Governor 0 8 1004 1330145 0 0 8 Governor 1 Governor 0 9 70 67754 0 0 8 Governor 1 Governor 0 10 69 46905 0 0 8 Governor 1 Governor 0 11 402 378584 0 0 8 Governor 1 Governor 0 12 62 63839 0 0 8 Governor 1 Governor 0 13 23 15748 0 0 8 Governor 1 Governor 0 14 100 87078 0 0 8 Governor 1 Governor 0 15 38 46454 0 0 which would be -----------------------> . Please note that in the Offices table, each office is listed the same number of times that each county participates to the vote total. Please also note that the CANDIDATEID's are not unique in this setup, because it is based off of the race and candidate combination. Ill be in this weekend, obviously. Please email me for questions or needs. Remember the CSV file and still our web pages are available for use. (Most of the stats you may want are calculated already.) Thank you for your patience, miket Michael Totherow, CIO Office of the Secretary of State 1700 W Washington Phoenix AZ 85007 Tel: 602.542-6170 Fax: 602.542-1575 email: mtotherow@mail.sosaz.com