Map of Countywide Elected Officials, 2011-2015
       |           

Welcome, Guest. Please login or register.
Did you miss your activation email?
May 17, 2024, 03:57:31 PM
News: Election Simulator 2.0 Released. Senate/Gubernatorial maps, proportional electoral votes, and more - Read more

  Talk Elections
  General Politics
  Political Geography & Demographics (Moderators: muon2, 100% pro-life no matter what)
  Map of Countywide Elected Officials, 2011-2015
« previous next »
Pages: [1] 2
Author Topic: Map of Countywide Elected Officials, 2011-2015  (Read 9648 times)
Adam Griffin
Atlas Star
*****
Posts: 20,092
Greece


Political Matrix
E: -7.35, S: -6.26

Show only this user's posts in this thread
« on: March 20, 2016, 08:22:35 PM »
« edited: May 01, 2016, 03:18:59 AM by President Griffin »

I originally started this close to two years ago by doing the results of each countywide race in Georgia in 2012. In the summer of last year, I decided to do MS in the run-up to the 2015 elections. Later, I did South Carolina.

Recently, I've compiled three more states and am probably going to (slowly but surely) complete the map as much as possible. I wanted to get the Solid South completed, but TN, AL & KY (if you want to call it Southern) do not keep county-level results on their websites. As such, I've completed six states thus far:

If Imgur links do not display the image after clicking, then click on the URL in your browser and hit 'enter' to load it again, or hit refresh. Stupid Imgur is blocking direct links from Atlas but once you do that, it should work.



The maps above use the "Blue = Democratic & Red = Republican" color scheme. The map below, however, uses standard Atlas colors.

Don't cry for Southron Democrats just yet:

Full-size image

Logged
Vern
vern1988
Sr. Member
****
Posts: 2,252
United States


Political Matrix
E: -1.30, S: -0.70

P P P

Show only this user's posts in this thread
« Reply #1 on: March 20, 2016, 09:03:17 PM »

Awesome work!
Logged
Miles
MilesC56
Atlas Icon
*****
Posts: 19,325
United States


Show only this user's posts in this thread
« Reply #2 on: March 20, 2016, 09:32:47 PM »

Logged
smoltchanov
Junior Chimp
*****
Posts: 7,386
Russian Federation


Show only this user's posts in this thread
« Reply #3 on: March 20, 2016, 11:25:20 PM »

Thanks a lot! The only problem -i don't see pictures on imgur (empty screen). Snag.gy links work fine for me...
Logged
Adam Griffin
Atlas Star
*****
Posts: 20,092
Greece


Political Matrix
E: -7.35, S: -6.26

Show only this user's posts in this thread
« Reply #4 on: March 21, 2016, 01:08:59 AM »
« Edited: March 21, 2016, 01:17:37 AM by President Griffin »

Thanks a lot! The only problem -i don't see pictures on imgur (empty screen). Snag.gy links work fine for me...

Click on the URL in your browser and hit 'enter' to load it again, or hit refresh. Stupid Imgur is blocking direct links from Atlas but once you do that, it should work.
Logged
smoltchanov
Junior Chimp
*****
Posts: 7,386
Russian Federation


Show only this user's posts in this thread
« Reply #5 on: March 21, 2016, 03:28:13 AM »
« Edited: March 21, 2016, 03:40:53 AM by smoltchanov »

Thanks a lot! The only problem -i don't see pictures on imgur (empty screen). Snag.gy links work fine for me...

Click on the URL in your browser and hit 'enter' to load it again, or hit refresh. Stupid Imgur is blocking direct links from Atlas but once you do that, it should work.

Thanks, it works! But i don't see an explanation of abbreviations for Louisiana (though i can make an educated guess about most)...

P.S. Of special interest to me there are 2 main regions: South (especially - Deep South and surrounding areas, like Northern Florida and Arkansas) and New England. I hope to see something about them in the future (and remain thankful for those you already made)
Logged
Adam Griffin
Atlas Star
*****
Posts: 20,092
Greece


Political Matrix
E: -7.35, S: -6.26

Show only this user's posts in this thread
« Reply #6 on: March 21, 2016, 06:46:24 PM »

Thanks a lot! The only problem -i don't see pictures on imgur (empty screen). Snag.gy links work fine for me...

Click on the URL in your browser and hit 'enter' to load it again, or hit refresh. Stupid Imgur is blocking direct links from Atlas but once you do that, it should work.

Thanks, it works! But i don't see an explanation of abbreviations for Louisiana (though i can make an educated guess about most)...

P.S. Of special interest to me there are 2 main regions: South (especially - Deep South and surrounding areas, like Northern Florida and Arkansas) and New England. I hope to see something about them in the future (and remain thankful for those you already made)

I had actually starting working on Florida last night, as luck would have it!



Florida has now been added to the map.
Logged
smoltchanov
Junior Chimp
*****
Posts: 7,386
Russian Federation


Show only this user's posts in this thread
« Reply #7 on: March 22, 2016, 03:47:44 AM »
« Edited: March 22, 2016, 09:24:12 AM by smoltchanov »

Some short (and incomplete) observations:

1. West Virginia. Republicans sweep (or prevail) most of the Ohio river counties plus some in Panhandle. Democrats prevail in other parts of the state, especially in "Tomblin country"....

2. North Carolina. Republican sweep (or prevail) far far West of the state, "textile" and some other counties NW and NE of Charlotte, and far South-East  (probably - the most "Dixie" area of the state), Democrats prevail or sweep most of the East (Black majority areas +Triangle) and Central-South.

3. South Carolina. Republicans dominate the coast, far NW (most "Appalachian" and populist part of the state) and Central-West (around Aiken), Democrats - majority Black areas plus, generally, most of the central part of the state

4 Georgia. Democrats dominate to varying extent in Black Belt and big city areas (Atlanta, Savannah and so on), Republicans are especially strong in the North (outside of Atlanta area) and South-East, closer to the coast (Savannah excluded). Most of the rural counties gradually become republican-leaning, but Democrats still have residual strength there...

5. Louisiana. Besides Orleans i don't see parishes swept by one party: even conservative Bossier, West Carroll and Livingston elect some Democrats and even majority Black Mississippi river counties - some Republicans. Probably - Democrats from conservative parishes are "old school conservative Democrats" (even extremely conservative LaSalle parish, where Obama got slightly over 11% in 2012, elects considerable number of Democrats), and Republicans from majority Black parishes learned how to tend their Black voters and get their vote.

6. Mississippi. As expected Republicans dominate big city suburbs (DeSoto, Rankin, Madison) and South-East (including coast), Democrats - almost everything else. It's interesting how long the Democratic dominance of North-East (and most of the Cetral-East) on local level will hold.

7. Florida. I would make a sort of imaginary split of the state in two: "old Dixie Florida" (approximately N and W of Alachua county), and the rest. In the second part it's "all normal": Democrats dominate big city Gold Coast, Orlando area, St. Petersburg area, Republicans - almost everything else..  But first is really interesting. On Presidential level almost all this area (except Gadsden, Leon, Jefferson and Alachua counties (blacks + big university)) is Republican, in many cases - extremely Republican (for example - 15% for Obama in Holmes and 20% - in Lafayette county), but many counties are much more Democratic locally. For example - Holmes officeholders are almost equally split between Indies, Republicans and Democrats, and Lafayette - between Democrats and Indies with minimal Republican representation. Even better: Liberty county (28% Obama in 2012) elects a lot of Democrats locally, substantial number of Indies and NO Republicans... An exception seems to be area around "Redneck Riviera" - Santa Rosa, Ocaloosa and Walton counties, where we observe a lot of Indies, substantial number of Republicans and no Democrats at all. Again - i expect many of Democratic officeholders in this part of the state being a conservatives (some even in "old" sense of the word, not present, according to  which even centrist Democrats are frequently called this name...)

P.S. Waiting for  Arkansas, where Democrats cratered recently not only on Presidential, but on Congressional and even state legislative level. Would like to get at least some information about Alabama too (the same situation), bit if it's impossible - .....

P.S. 2 Hope these observation will be useful at least to some people...

Logged
Adam Griffin
Atlas Star
*****
Posts: 20,092
Greece


Political Matrix
E: -7.35, S: -6.26

Show only this user's posts in this thread
« Reply #8 on: March 22, 2016, 06:16:04 PM »

P.S. Waiting for  Arkansas, where Democrats cratered recently not only on Presidential, but on Congressional and even state legislative level. Would like to get at least some information about Alabama too (the same situation), bit if it's impossible - .....

I spent over an hour last night trying to (again) dig through potential sources for AL countywide election results. I first attempted to track them down through each county's website...but a lot of counties either don't have websites or don't have the results listed. I then went back and really dug through AL SoS' offerings, and buried within one obscure section, I found election results for 2012 and 2014. In the case of 2012, the results by precinct and the partisan affiliations are there, but not many countywide offices seem to be elected in presidential years there. For most counties, it was only 2 or 3 offices (usually 1 or 2 each of School Boards & County Commissions).

Turning to the 2014 spreadsheet, all of the results are there...but partisan affiliation is not included in the spreadsheet (for whatever reason!). Therefore, I know who won but I have no idea who is a D and who is a R. Even though I was happy to find the actual county-level results that I could not find previously for AL, they are still functionally useless and it would take tons of time to track down the affiliations of each, and even then, I'm sure there'd be plenty of holes where there is no internet reference to various officials' affiliations.
Logged
Adam Griffin
Atlas Star
*****
Posts: 20,092
Greece


Political Matrix
E: -7.35, S: -6.26

Show only this user's posts in this thread
« Reply #9 on: March 22, 2016, 07:54:20 PM »

Just added (most of) Virginia. Barring the significantly-populated ones, I eliminated cities from this measurement. Virginia is just...exhausting for me. I don't know why: I'm guessing the combination of counties/municipalities paired with the frustrating map parameters (whether you're using shapefiles or hand-drawn ones). Additionally and here, the # of counties that have transitioned to all non-partisan/independent offices makes it tedious and throws off the map's flow.

My original metric for measuring partisan control this has been put to the test here; there are several counties where all but one office are held by independents/non-partisans, and as such, those counties are colored "sweeps" for the party with literally one office-holder. Throughout the Deep South, this isn't an issue.

At any rate, I need a break from Virginia, so I've uploaded my progress thus far and will come back to it sooner or later. Ugh, I'd rather do Texas when it comes to county-level map machinations than Virginia.
Logged
smoltchanov
Junior Chimp
*****
Posts: 7,386
Russian Federation


Show only this user's posts in this thread
« Reply #10 on: March 22, 2016, 08:09:00 PM »

One word - thanks!
Logged
/
darthebearnc
Junior Chimp
*****
Posts: 7,367
Show only this user's posts in this thread
« Reply #11 on: March 22, 2016, 11:35:11 PM »

Great job, Griff!

I am, however, wondering why Wilson County, NC is left blank for the 2014 countywide office election results. If you need them, they are as follows:

Clerk of Superior Court - D
Sheriff - D
Board of Commissioners - 4 D; 3 R (7 total)
Board of Education - 4 Nonpartisan (3 elected in other year)
Soil and Water - 2 Nonpartisan

Their Register of Deeds was elected in 2012 and they don't have an elected Tax Commissioner.
Logged
Adam Griffin
Atlas Star
*****
Posts: 20,092
Greece


Political Matrix
E: -7.35, S: -6.26

Show only this user's posts in this thread
« Reply #12 on: March 23, 2016, 12:31:42 AM »

Great job, Griff!

I am, however, wondering why Wilson County, NC is left blank for the 2014 countywide office election results. If you need them, they are as follows:

Clerk of Superior Court - D
Sheriff - D
Board of Commissioners - 4 D; 3 R (7 total)
Board of Education - 4 Nonpartisan (3 elected in other year)
Soil and Water - 2 Nonpartisan

Their Register of Deeds was elected in 2012 and they don't have an elected Tax Commissioner.

You know, what I think happened was that I clicked the wrong setting on the website (perhaps referendums or whatever) and it showed no election results. I'll correct that shortly. Thanks!


You're welcome!



Up next: Arkansas
Logged
Adam Griffin
Atlas Star
*****
Posts: 20,092
Greece


Political Matrix
E: -7.35, S: -6.26

Show only this user's posts in this thread
« Reply #13 on: March 23, 2016, 04:36:37 AM »

Arkansas has been added.

For some of those counties, we have to take it with a grain of salt. Why? Because for some damn reason, the SoS only shows 1 or 2 offices being up for election in both 2012 and 2014. I noticed that in some cases, there was an "unopposed races" entry in the results, but I also observed many counties with officers listed that were not opposed, so it doesn't appear to be a case of "we're only going to show the elections if there was competition". I have no idea why this is, but I decided to proceed with completing the state, anyway.

I sometimes gripe about my GOP SoS, but the more I see from other states...the more I realize that Georgia has one of the most comprehensive and straightforward sets of election results, voter registration/turnout statistics and easily-accessible voter/elections information in the country.
Logged
smoltchanov
Junior Chimp
*****
Posts: 7,386
Russian Federation


Show only this user's posts in this thread
« Reply #14 on: March 23, 2016, 10:18:31 AM »

Arkansas has been added.

For some of those counties, we have to take it with a grain of salt. Why? Because for some damn reason, the SoS only shows 1 or 2 offices being up for election in both 2012 and 2014. I noticed that in some cases, there was an "unopposed races" entry in the results, but I also observed many counties with officers listed that were not opposed, so it doesn't appear to be a case of "we're only going to show the elections if there was competition". I have no idea why this is, but I decided to proceed with completing the state, anyway.

I sometimes gripe about my GOP SoS, but the more I see from other states...the more I realize that Georgia has one of the most comprehensive and straightforward sets of election results, voter registration/turnout statistics and easily-accessible voter/elections information in the country.

Generally what i expected. Republicans prevail in North-West and Central-West, plus suburban counties around Little Rock and Texarkana suburbs, Democrats - almost everywhere else (in many counties - rather strongly). So, Democrats are still strong in Arkansas on local level. Another proof is that Republicans sweep only couple of counties, Democrats - much more...

P.S. What next? Texas with it's myriad of counties?Huh
Logged
Adam Griffin
Atlas Star
*****
Posts: 20,092
Greece


Political Matrix
E: -7.35, S: -6.26

Show only this user's posts in this thread
« Reply #15 on: March 23, 2016, 03:54:55 PM »

P.S. What next? Texas with it's myriad of counties?Huh

Ugh, I have no idea. Even though the South has tons of counties, it's sort of "familiar" to me in terms of geography and the lack of monotony. In any direction from here, I run into one set of problems or another.

With TX, the issue is file size. Since I'm having to manually extract the data for a lot of states, I don't save any time by using shapefiles (hence why my maps have been hand-drawn for this). To make a template for TX that's big enough to fit the data into it, it'll be something like 6000x4500 pixels. Immense. I mean, it'll probably be OK but it'll crash older computers.

Moving NW (into the Great Plains and Midwest) is a personal nightmare for me because of the lack of variance in county shapes. It just bores the hell out of me...the number of counties and the fact that most are just silly squares.

I probably need to finish Virginia first (I hate VA - my least favorite state to do because of city issue, number of counties, coloration difficulty on hand-drawn maps, etc). I *probably* will continue moving NE in the short-term and try to finish the mid-Atlantic and New England before going any further west.
Logged
smoltchanov
Junior Chimp
*****
Posts: 7,386
Russian Federation


Show only this user's posts in this thread
« Reply #16 on: March 23, 2016, 11:30:06 PM »

Excellent! Especially New England. It' in some sense a "South in reverse": with present strong domination by Democrats even in states with past Republican tradition (Vermont a.o.). It would be VERY interesting to see whether Republicans preserve some local strength there (as Democrats in North Florida, Arkansas, Mississippi and Louisiana still do).

Waiting....
Logged
Adam Griffin
Atlas Star
*****
Posts: 20,092
Greece


Political Matrix
E: -7.35, S: -6.26

Show only this user's posts in this thread
« Reply #17 on: March 24, 2016, 12:05:01 AM »

Maryland has now been added.
Logged
smoltchanov
Junior Chimp
*****
Posts: 7,386
Russian Federation


Show only this user's posts in this thread
« Reply #18 on: March 24, 2016, 04:18:31 AM »


More thanks! Generally - what could be expected: Republican NW, many Baltimore suburbs, most of the Eastern Shore (though Democrats still hold some offices there), and Ann Arundel. But Democrats absolutely dominate Baltimore city, Prince George and Montgomery county (in the past - a good source of moderate-to-liberal Republicans of Charles Mathias-style)
Logged
Gass3268
Moderators
Atlas Star
*****
Posts: 27,540
United States


Show only this user's posts in this thread
« Reply #19 on: March 24, 2016, 08:29:10 AM »

I think you miscolored Charles County, Maryland for the Presidential map. Great work on this. Great to see how Maryland is considering it's my home state, which I only know a little bit about.
Logged
jimrtex
Atlas Icon
*****
Posts: 11,817
Marshall Islands


Show only this user's posts in this thread
« Reply #20 on: March 26, 2016, 03:38:01 AM »

P.S. What next? Texas with it's myriad of counties?Huh

Ugh, I have no idea. Even though the South has tons of counties, it's sort of "familiar" to me in terms of geography and the lack of monotony. In any direction from here, I run into one set of problems or another.

With TX, the issue is file size. Since I'm having to manually extract the data for a lot of states, I don't save any time by using shapefiles (hence why my maps have been hand-drawn for this). To make a template for TX that's big enough to fit the data into it, it'll be something like 6000x4500 pixels. Immense. I mean, it'll probably be OK but it'll crash older computers.
If you use QGIS you can join spreadsheets to shapefiles.
Logged
Adam Griffin
Atlas Star
*****
Posts: 20,092
Greece


Political Matrix
E: -7.35, S: -6.26

Show only this user's posts in this thread
« Reply #21 on: May 01, 2016, 03:42:17 AM »

P.S. What next? Texas with it's myriad of counties?Huh

Ugh, I have no idea. Even though the South has tons of counties, it's sort of "familiar" to me in terms of geography and the lack of monotony. In any direction from here, I run into one set of problems or another.

With TX, the issue is file size. Since I'm having to manually extract the data for a lot of states, I don't save any time by using shapefiles (hence why my maps have been hand-drawn for this). To make a template for TX that's big enough to fit the data into it, it'll be something like 6000x4500 pixels. Immense. I mean, it'll probably be OK but it'll crash older computers.
If you use QGIS you can join spreadsheets to shapefiles.


If the data was already compiled in an effective format (at least for me), I would definitely be doing something like that (I usually just use Google Fusion Tables, since I have yet to get the learn how to get CartoDB's system to not geocode random columns that have nothing to do with coordinates). It's so relatively quick to just eye-ball, count, and color at this point since I'm needing to extract the results manually, anyway. Presumably I am going to at least create a FT map with the percentage of offices held by each party in each county, but I understand that's not going to be as interesting necessarily.



I have now finished the 2014 elections for Georgia and have merged 2012/2014 into one map.
Logged
OneJ
OneJ_
YaBB God
*****
Posts: 4,833
United States


Show only this user's posts in this thread
« Reply #22 on: April 16, 2017, 07:52:27 PM »

Nice work (even though I'm like a year behind Tongue)!
Logged
RINO Tom
Atlas Icon
*****
Posts: 17,053
United States


Political Matrix
E: 2.45, S: -0.52

Show only this user's posts in this thread
« Reply #23 on: April 18, 2017, 09:59:44 AM »

I originally started this close to two years ago by doing the results of each countywide race in Georgia in 2012. In the summer of last year, I decided to do MS in the run-up to the 2015 elections. Later, I did South Carolina.

Recently, I've compiled three more states and am probably going to (slowly but surely) complete the map as much as possible. I wanted to get the Solid South completed, but TN, AL & KY (if you want to call it Southern) do not keep county-level results on their websites. As such, I've completed six states thus far:

If Imgur links do not display the image after clicking, then click on the URL in your browser and hit 'enter' to load it again, or hit refresh. Stupid Imgur is blocking direct links from Atlas but once you do that, it should work.



The maps above use the "Blue = Democratic & Red = Republican" color scheme. The map below, however, uses standard Atlas colors.

Don't cry for Southron Democrats just yet:

Full-size image



1) Amazing work, this is fascinating!

2) I officially motion for the bolded to become Forum tradition to describe not just a "Southern Democrat" (i.e., a Democrat who lives in the South, with no other implications) but a "traditional Southern Democrat" (with implications of being mostly White, culturally conservative and economically to the left of the Republicans who took their place).
Logged
VPH
vivaportugalhabs
YaBB God
*****
Posts: 4,705
United States


Political Matrix
E: -4.13, S: -0.17

Show only this user's posts in this thread
« Reply #24 on: April 18, 2017, 05:51:36 PM »

Are most of these Democrats probably as conservative as Republicans, or do they hang onto some vestiges of their party's stances?
Logged
Pages: [1] 2  
« previous next »
Jump to:  


Login with username, password and session length

Terms of Service - DMCA Agent and Policy - Privacy Policy and Cookies

Powered by SMF 1.1.21 | SMF © 2015, Simple Machines

Page created in 0.064 seconds with 11 queries.