Home About Chat Users Issues Party Candidates Polling Firms Media News Polls Calendar Key Races United States President Senate House Governors International

New User Account
"A historical political resource." 
Email: Password:

  To-Do List Suggestion

TO-DO SUGGESTION
Back to List [Back to To-Do Listing]
Suggested RP on Aug 05, 2019 09:39pm
Last Modified RP on Dec 06, 2019 11:00am
Title Current County-Level offices and race-results
Description Feel free to modify. Put Done when complete, your name when working on it.

AL -
AK -
AZ - Done - IndyGeorgia 8/8
AR -
CA - Labour Dem
CO - Done - BrentinCO 9/17
CT -
DE - Done - RBH
FL - Done - RP 9/21
GA -
HI - Done - RBH
ID -
IL - ev
IN -
IA - ev
KS -
KY -
LA -
ME -
MD -
MA -
MI - RP
MN - Done - RP
MS -
MO -
MT -
NV -
NH -
NJ -
NM -
NY -
NC -
ND -
OH -
OK -
OR -
PA -
RI -
SC -
SD -
TN -
TX -
UT -
VT -
VA - An62190
WA - Done - RP 8/3/2019
WV -
WI -
WY - Done - RP 8/19/2019
INFORMATION LINKS
Other Map Formats to KML online tool  Discuss
DISCUSSION
[View All
29
Previous Messages]
 
D:7918Labour Dem ( 152.8636 points)
Tue, August 6, 2019 12:35:25 AM UTC0:00
I can do California if no one else wants to.

 
I:1038PA Indy ( 1352.2366 points)
Tue, August 6, 2019 01:20:34 AM UTC0:00
RP: All the current county-level offices for WA state have been entered. Who wants to pick a state and do the same?

Is there a tracker so we know who has signed up and which states are lacking?

 
D:1989RBH ( 4353.9746 points)
Thu, August 8, 2019 10:23:52 PM UTC0:00
Hawaii has been done for awhile. Doesn't hurt that it's a state that has county office results on the statewide canvass pdf

 
I:6738IndyGeorgia ( 3015.9092 points)
Sun, August 18, 2019 04:31:04 PM UTC0:00
So in an act of self-punishment, I decided to start on Georgia. The Georgia SOS's office only includes the first initial for each candidate, so I have to look all of those up. In other words, this may take a while.

I think my job jar for the rest of the year will involve these GA races, Canada races, and a possible UK election.

 
R:9757BrentinCO ( 3307.2993 points)
Sun, August 18, 2019 04:51:02 PM UTC0:00
Fortunately the Colorado SoS only did that for one year and realized their mistake. Hopefully you can find a secondary source to help with the names.

 
R:9757BrentinCO ( 3307.2993 points)
Sun, August 18, 2019 06:04:18 PM UTC0:00
IndyGeorgia: So in an act of self-punishment, I decided to start on Georgia. The Georgia SOS's office only includes the first initial for each candidate, so I have to look all of those up. In other words, this may take a while.

I found a good secondary source for Colorado results in the Colorado Counties Inc website [Link]

Great for names and election results back further than the SoS site.

I wondered if there was something similar for Georgia.

Sorta. [Link]

Might help with names of winners. The parent website is [Link]

 
I:6738IndyGeorgia ( 3015.9092 points)
Sun, August 18, 2019 06:13:16 PM UTC0:00
Thanks, I appreciate it! I also found Votesmart.org as a decent resource.

 
D:7918Labour Dem ( 152.8636 points)
Sun, August 18, 2019 07:45:43 PM UTC0:00
I want to get started, but needed to ask a question. How do I create the offices under the county government category? Like District Attorney, Assessor, etc.

 
R:9757BrentinCO ( 3307.2993 points)
x2
Mon, August 19, 2019 12:15:42 AM UTC0:00
Labour Dem: I want to get started, but needed to ask a question. How do I create the offices under the county government category? Like District Attorney, Assessor, etc.

Here's my advice on how to get started with a few tips / tricks to make it go easier. I'll use Bent County, Colorado as example [Link]

1. Create containers for the offices with the correct categories.

When I started none of the offices existed. The county container had cities and that's about it, so I needed to create containers for each office.

A. On the left hand side underneath the cities on the county page there is a link labeled Add New Subcategory To Bent (There will be a link like this in every container in the same relative location). A new page will open up titled "ADD NEW CONTAINER Country"

B. Select the right category - in my case I scrolled down in the drop down list to select County Government (This seems to be what most people are selecting for the executive elected positions in each county)

The other trick here is to try to use existing categories rather than create new ones. For example, use "County Government" rather than create a new category named "Bent County Government". The latter would be too specific for a container category.

C. In the name box I entered in the title of the office - Assessor.

D. I hit save to create the container for the County Assessor.

E. To navigate back to the county page, I went to the top of the page and clicked the Bent link on the parents line just above the category. (This is more of a tip, as this is a quicker way to get back to the county and reduces the number of clicks to get back to county. This will come in handy if you do are doing lots of entry.)

F. Repeat A - E for each office.

2. Create containers for another category of offices like the legislative body.

A. On the left hand side underneath the cities, use the link labeled Add New Subcategory To Bent - ADD NEW CONTAINER Country will open.

B. Select the right category - in my case I scrolled down in the drop down list to select County Commission (This was most close to Board of County Commissioners. Again try to re-use whats in there before creating a new category. Looks like there are containers for County Council, County Board. Find a county that is similar to the one you are creating and model yours after it)

C. In the name box I entered in the title of the office and district - Board of Commissioners District 1. (All Colorado Counties have 3 or more County Commissioners elected by Districts. You might have some At-large county legislators, so you might need to create containers for them.)

D. I hit save to create the container for the Board of Commissioners District 1.

E. To navigate back to the county page, I went to the top of the page and clicked the Bent link on the parents line just above the category.

F. Repeat A - E for each legislator.

3. Go back and add the races

A. Just as easy as clicking on the containers you created and going to the page for the office.

B. Add Race.

C. Repeat for each new container.

Other tips
I find that I'm prone to make some errors when I'm entering in lots of races. I reccomend taking the step doing a Data Quality check before leaving the County. My Data Quality Checklist is something like this.
- Make Sure office type and race in sync (Sheriff is correct for the race Bent County - Sheriff. When you go quickly sometimes you might accidentally re-use the last office that was in the add race since this is the default.)
[Link]
- Check Poll open and Poll close dates and times.
- Check Term Start and End Dates
- Did I check a winner?
- Precincts - For this I usually put 1 and 1 if I don't the specifics.
- Did I check the certified results box (I check this for historical races since that is generally assumed to be true).
- Did I cite my source.

Hope all this helps.

 
D:1RP ( 5218.4644 points)
Mon, August 19, 2019 04:20:17 PM UTC0:00
IndyGeorgia: So in an act of self-punishment, I decided to start on Georgia.

You are a braver soul than I.

Wyoming is done. Also organized the municipalities and added map data for cities and towns.

 
R:9757BrentinCO ( 3307.2993 points)
x2
Wed, September 18, 2019 03:02:05 AM UTC0:00
Indy Georgia I think you were asking me about possible sources for county level election results in Georgia. I believe I find a source playing around with the Scytl/Clarity Elections URL I used for finding Colorado results.

Enter in the following URL Formula

results.enr.clarityelections. com / XX / County_Name/

Remove the spaces and put in the GA for the XX and then the county name. If the county is two words, use the underscore between the two words.

For example, here is Dodge County Georgia
[Link]

It goes back to 2012. I haven't checked all counties, but I have spot checked.

Even small counties like Taliaferro have the results up.
[Link]

Also for others looking to find possible results in a state, it might be worth it to try to see if that Secretary of State has contracted Scytl software (makers of Clarity) to manage their state results using the same URL formula cutting of the county

results.enr.clarityelections. com / XX /

 
I:6738IndyGeorgia ( 3015.9092 points)
Wed, September 18, 2019 03:06:57 AM UTC0:00
That's awesome! Thanks so much!

 
D:1989RBH ( 4353.9746 points)
Wed, September 18, 2019 07:44:29 PM UTC0:00
yeah, I just realized that feature a few days ago because South Carolina's site redesign made it difficult to find the results for a special election (the results were on the Clarity page though)

 
D:1RP ( 5218.4644 points)
x2
Sun, September 22, 2019 12:03:56 AM UTC0:00
I'm going to call Florida done in spite of Seminole County not having the 2016 results available online. Which in this day and age I can only think could be malfeasance or incompetence.

I organized the cities into City, Town, Village, Census Designated Area and Unincorporated and got rid of extras that Wikipedia didn't list. I added all the city maps per county.

Added links to the websites for all the constitutional offices and graphics/logos if they were available.

Tried to find commissioner district maps where I could.

Did not yet add judicial or school board races.

FL is irritating in that they do not have any information whatsoever about uncontested races.

 
D:1RP ( 5218.4644 points)
Sun, September 22, 2019 12:57:04 AM UTC0:00
So another issue has presented itself - some of the counties have commissioners that represent districts, but they are elected county-wide. So the maps that show the elections results by district aren't exactly accurate. Wondering if I need to do something about that - like make Maps or MapLocations have an option for non-vote areas or something. And how/if to display the results.

 
D:1989RBH ( 4353.9746 points)
Sun, September 22, 2019 07:03:45 AM UTC0:00
I put the Seminole County website into the Wayback Machine and I couldn't find anything listed from 2016. But I did find that they had the ability to translate the Seminole County elections site into Klingon.

As for Florida and unopposed races. Yeah, that's sorta at the mercy of the county having a candidate filings page that could mention which candidates are unopposed.

Kansas City's city council has 6 districts where there's a member elected by only the people in the district and there's an at-large member elected from the district. If I ever found a shapefile for Kansas City's council, my quick instinct would be to have the districts for the in-district but not for the at-large.

 
D:1RP ( 5218.4644 points)
Sun, September 22, 2019 01:59:14 PM UTC0:00
Oh, and I put some general information on the county page that I though would be nice/useful to have. [Link]

 
D:1RP ( 5218.4644 points)
Thu, October 3, 2019 02:47:31 AM UTC0:00
Slightly OT: I have organized the CO municipalities (Cities, Towns, Census Designated Places, Unincorporated and Ghost Towns) and added the maps for them (Cities, Towns, CDPs).

 
D:1RP ( 5218.4644 points)
Thu, October 3, 2019 03:33:39 PM UTC0:00
Speaking of which, the US Census Bureau has the municipality maps for 2019 all available here per state: [Link]

They download as shapefile zips. You can take those and use this online tool [Link] to convert them to .kml files, which are the easiest to use to put into OurCampaigns.

 
D:1RP ( 5218.4644 points)
Thu, October 3, 2019 03:41:20 PM UTC0:00
NOTE: Use LIBKML and not KML in the tool or all the Lat/Lon coordinates will be backwards.

 
R:10739Max Rohtbart ( 132.8893 points)
Sat, July 25, 2020 10:44:57 PM UTC0:00
If the smaller counties in Michigan dont have the data on the web i suggest contacting the county clerk. They are supposed to keep the records of county elections. Although I would wait until after the august primary, they are all swamped with absentee ballots administration now.

 
D:1RP ( 5218.4644 points)
Sun, July 26, 2020 03:51:38 AM UTC0:00
They are hit and miss. I don't think I'm going to have the time to bother with contacting the county clerks themselves, so feel free if you want to do so.