RBH's Maps (Now, Atlas Election Entry Script & County Map Generation)

[Grad Students are the Worst]

#%@!

Thanks for the change data script.  That will make this a little easier. 

EDIT: It will be until later in the day when I have access to the computer with the MT files.  I'll try to make a macro and see if I can swap the two lines automatically, but for now I'll add Delaware.

EDIT 2: The DE 2000 file needs read rights too.  Thanks

[Dave Leip]

I've changed the permissions to allow for write-access.  Note that with Delaware, later years separate out the City of Wilmington from 'Rural New Castle County'.  You'll need to add the two for the New Castle figure.

Also for the DE documents, use the "Document" source choice with the following information:
example: for 1996:
Author: Thomas J. Cook
Author Title: Commissioner of Elections
Author Compiled: prep.
Agency: Delaware Department of Elections
Title: State of Delaware 1996 Election Results
Article: State of Delaware Official Results of General Election for Statewide Offices November 5, 1996
Source Pages: p. 2

Also note the write-ins starting on p. 36.
So Lt. Governor should also have a total figure for write-ins of 22 votes, even though there are no county-level data.

[Grad Students are the Worst]

Done.  Note that with Delaware, later years separate out the City of Wilmington from New Castle County.  You'll need to add the two for the New Castle figure.

Yeah, that's a little annoying.  In earlier years, they also don't provide the losing candidate's full names - just the last names.  There doesn't appear to be any place online with this information.  Is it OK to just enter their last names for now, and update them when they're found?

[Dave Leip]

Done.  Note that with Delaware, later years separate out the City of Wilmington from New Castle County.  You'll need to add the two for the New Castle figure.

Yeah, that's a little annoying.  In earlier years, they also don't provide the losing candidate's full names - just the last names.  There doesn't appear to be any place online with this information.  Is it OK to just enter their last names for now, and update them when they're found?

Hi Alcon,
Sure, that is ok.  Post the names and offices in a thread and maybe you can enlist some help digging them up.  I'll also add a script to more easily edit candidate names/source info.
Also read the edits to my previous post as well.
Enjoy,
Dave

[Dave Leip]

Also, for the many Maryland members, there is always the Maryland Manual.  From the present back into the 19th century, they have compilation of scanned pdfs of the original manuals.  It takes a bit of getting used to finding the right pages with the election results - I tend to start in the index and find "E", look for election results and then go to that page.  Be sure to use the pdf versions and not the attempted OCR html data as there are often incorrect data in the html.  If you find the right pages, please also download them and send them to me, letting me know which edition of the manual they are from.  Finally, use the "Document" source choice with the appropriate information.
Thanks,
Dave

[Dave Leip]

For the Illinois Buff, there are the Illinois Blue Books back to 1900.  These also include election data as part of the document.  Also use "Document" for the source from any data here, including all the pertinant info: For example:
Goveror Illinois 1912

Source Author: Harry Woods
Source Author Title: Secretary of State
Source Author Compiled: comp.
Source Agency: Illinois Secretary of State
Source Title: Blue Book of the State of Illinois 1913-1914
Source Article: Vote for Governor - November 5, 1912
Source Publisher: Illinois Printing Company
Source City: Danville
Source Year: 1914
Source Pages: pp. 569-570

[Bleeding heart conservative, HTMLdon]

Dave,

All of the maps created before Texaslefty's CA Prop 81 map (2007-01-15   01:55:05) are coming up with db errors.  The maps are still showing, but the features of the pages are non-operational.

[Dave Leip]

Thanks - All should be well soon.  I made some modifications to the database table and a script is working to update the table.  Should be done soon.
Dave

[Grad Students are the Worst]

It would be nice to have a quick way to change the title for idiots like me who can't spell or in instances where initiatives could be better-named.

This needs to be transferred to 1991 (the SoS site lists the year incorrectly).

[bgwah]

Hi Dave,

I was wondering it would be possible to add Presidential primary results?

[Grad Students are the Worst]

Additional bugs:

- Initiative titles with apostrophes do not show up at all
- 1980s years without population generate MySQL errors

[Grad Students are the Worst]

I just finished up all Washington initiatives back until 1970.  Naturally, on the second to last (of, what, 100+ or so?) I noticed that there was a much, much easier way to do it involving a weird sort method.  So I wasted at least several hours.  Oh well.

Once primaries are done, Jesus and I will have all the inputtable Washington election results back 'til 1970 done.  That just leaves Senate Joint Resolutions, House Joint Resolutions, Commissioner of Public Lands and Superintendent of Public Instruction -- not too much work now that we've discovered the easier way of doing this. 

There's a race where 5 candidates won counties (here).  Should we just treat that normally for now?  Maybe orange or purple could be added, or something, when that happens?

Thanks again for adding this, Dave.

[Dave Leip]

Great Job all!
This is turning out to be quite a feature!  I have created the ability to edit just the information (candidate names, initiative name, notes, and source info).  At the bottom of each page that you contributed, there is a new link titled "Change Info for this Contest".  This will take you to an edit form that has all the previously-entered data already in the boxes.  Just edit and hit submit.  Please let me know if you have any difficulties or find new introdced bugs.

There's a race where 5 candidates won counties (here).  Should we just treat that normally for now?  Maybe orange or purple could be added, or something, when that happens?

Yes.  I'll have to add support for all these contests that you dig up with 5 winning candidates (and RBH's < 20% win county!!!)

- Initiative titles with apostrophes do not show up at all

Could you give me an example contest?

I was wondering it would be possible to add Presidential primary results?

at some point, possibly - I have a bunch more work here though for delegates, etc.

[bgwah]

Possible bug; I added Alabama gubernatorial election results for 1946-1986 (I've assumed 1990 and 1994 will be added soon) and noticed that the party buttons don't work for for the elections before 1970.

And, somewhat off topic, Louisiana has their 1987 runoff election online but not the general. Strange...

[Grad Students are the Worst]

Here is an example of the apostrophe bug.

By the way, Jesus, you might want to use the new feature to fix "Socialistt Workers" on the last Louisiana one you did (with all the colors).

[True Democrat]

Possible bug; I added Alabama gubernatorial election results for 1946-1986 (I've assumed 1990 and 1994 will be added soon) and noticed that the party buttons don't work for for the elections before 1970.

And, somewhat off topic, Louisiana has their 1987 runoff election online but not the general. Strange...

In 1966, Lurleen Wallace, his wife ran, since Wallace term limited and still wanted to be governor.

[So the Heroes Fall]

I just added the 2000 Minnesota Senate Democratic primary: http://uselectionatlas.org/RESULTS/state.php?year=2000&off=3&elect=1&fips=27&f=0

It's there, but there are no links to it on the main contributions page, or on the Minnesota page. What's up?

[RBH]

And, somewhat off topic, Louisiana has their 1987 runoff election online but not the general. Strange...

Edwards refused to go a runoff with Roemer in 1987

[Dave Leip]

This contest for AZ Prop 107 is way off - it has unofficial CNN data that are short by over 300,000 votes.  Please avoid using CNN or other unofficial/secondary sources for data.  The AZ 2006 Official Canvass has all these official data. 
Thanks,
Dave

[RBH]

I don't think the script can upload results from O'Brien County Iowa due to the comma.

[Dave Leip]

Yep, the 'quote' was messed up because I had the variable in single quotes.  It should work now.

[Grad Students are the Worst]

Dave,

Any plans to add new offices, such as Commissioner of Public Lands or Superintendent of Public Instruction?  Or House & Senate Joint Resolutions?

[Joe Republic]

I'm not sure what I did wrong here:

http://uselectionatlas.org/RESULTS/state.php?year=2006&off=11&elect=0&fips=39&f=0

Could somebody do a user's guide or something?  It's all a little baffling, and I have plenty of time and resources to make a bunch of maps.

[So the Heroes Fall]

You probably either left commas in the digits or didn't delete the top line.

[Dave Leip]

I'm not sure what I did wrong here:

http://uselectionatlas.org/RESULTS/state.php?year=2006&off=11&elect=0&fips=39&f=0

Could somebody do a user's guide or something?  It's all a little baffling, and I have plenty of time and resources to make a bunch of maps.

Hi Joe,
Thanks - the effort would be great!
the file that you uploaded is for some reason blank.  Check that it is tab-delimited file from the template provided via the link on the script page.  It should only include lines from one state, including the statewide total.  The "?" next to each item in the form has a pop-up that gives info on that item of the form.  I'm not sure why the script actually entered the election - could you email me the file?
Thanks,
Dave