Obtain data on current county commissioners

[ejaxon]

We will need to get the current name and address of all current county commissioners so that we can match them against their demographic information in their voter registration. Once we have their names, we can probably use the candidate information to match them to their addresses.

Ideally we want a repeatable (and, ideally, automatable) procedure for obtaining this information in the future.

[LauraMB12]

we found this info on the NC Association of County Commissioners site. i've emailed them to get more info on how it was collected. http://www.ncacc.org/197/Election-Results

[wandernat]

I went ahead and created a (non-repeatable, non-automated, sorry!) spreadsheet of North Carolina commissioners. I uploaded it to Kaggle so that it is now a public database: https://www.kaggle.com/wandernat/north-carolina-county-commissioners/data

(I'm happy to add it to the data folder on here but I currently do not have permissions.)

It should now be able to be matched against the voter database to gain gender and race information. Party affiliation is already included in the spreadsheet. Some of the addresses may be campaign office addresses instead of home addresses listed in the voter records. So I may need to look those up manually as well.

[cassiodorus]

very nice david hopp

…

________________________________ From: Nat <notifications@github.com> Sent: Wednesday, June 6, 2018 11:02:59 PM To: Open-NC/Are-We-Represented Cc: Subscribed Subject: Re: [Open-NC/Are-We-Represented] Obtain data on current county commissioners (#8) I went ahead and created a (non-repeatable, non-automated, sorry!) spreadsheet of North Carolina commissioners. I uploaded it to Kaggle so that it is now a public database: https://www.kaggle.com/wandernat/north-carolina-county-commissioners/data (I'm happy to add it to the data folder on here but I currently do not have permissions.) It should now be able to be matched against the voter database to gain gender and race information. Party affiliation is already included in the spreadsheet. Some of the addresses may be campaign office addresses instead of home addresses listed in the voter records. So I may need to look those up manually as well. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub<#8 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/ACI2OechAClhsKYfcfFuEvWEUC2CZVw1ks5t6JfjgaJpZM4SL3ed>.

[cassiodorus]

BTW, 2016 Election Demographics for Website_1.csv is on the S3. Here is a copy ... It is an almost organized file from the NCACC web site. David

…

________________________________ From: Nat <notifications@github.com> Sent: Wednesday, June 6, 2018 11:02:59 PM To: Open-NC/Are-We-Represented Cc: Subscribed Subject: Re: [Open-NC/Are-We-Represented] Obtain data on current county commissioners (#8) I went ahead and created a (non-repeatable, non-automated, sorry!) spreadsheet of North Carolina commissioners. I uploaded it to Kaggle so that it is now a public database: https://www.kaggle.com/wandernat/north-carolina-county-commissioners/data (I'm happy to add it to the data folder on here but I currently do not have permissions.) It should now be able to be matched against the voter database to gain gender and race information. Party affiliation is already included in the spreadsheet. Some of the addresses may be campaign office addresses instead of home addresses listed in the voter records. So I may need to look those up manually as well. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub<#8 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/ACI2OechAClhsKYfcfFuEvWEUC2CZVw1ks5t6JfjgaJpZM4SL3ed>.

[wandernat]

I have cross-referenced the County Commissioner dataset I made a couple weeks ago with the state voter registration database. It is now complete with party, race, and gender information.

Note: you may see VR and CL in the column names - VR means the data came from their voter registration, CL means the data came from their candidate listing.

https://www.kaggle.com/wandernat/north-carolina-county-commissioners/data

This dataset is current as of June 18, 2018. There have been many vacancies, subsequent appointments and party changes since 2016. That's why I prefer this current data to the NCACC data from 2016.

I'm new to GitHub, but I'll try to upload the dataset to this git in the near future. I don't want to mess anything up, lol.

[cassiodorus]

How are you handling the requirements for repeatable (replicable) research? For instance, are all your R scripts and data files available? Most helpful to organize this as a rmarkdown script. David Hopp

…

________________________________ From: Nat <notifications@github.com> Sent: Tuesday, June 19, 2018 2:12:18 PM To: Open-NC/Are-We-Represented Cc: David Hopp; Comment Subject: Re: [Open-NC/Are-We-Represented] Obtain data on current county commissioners (#8) I have cross-referenced the County Commissioner dataset I made a couple weeks ago with the state voter registration database. It is now complete with party, race, and gender information. Note: you may see VR and CL in the column names - VR means the data came from their voter registration, CL means the data came from their candidate listing. https://www.kaggle.com/wandernat/north-carolina-county-commissioners/data This dataset is current as of June 18, 2018. There have been many vacancies, subsequent appointments and party changes since 2016. That's why I prefer this current data to the NCACC data from 2016. I'm new to GitHub, but I'll try to upload the dataset to this git in the near future. I don't want to mess anything up, lol. — You are receiving this because you commented. Reply to this email directly, view it on GitHub<#8 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/ACI2OUx_b25hRvVqSAbQ6fwZOB5zhKh0ks5t-T8CgaJpZM4SL3ed>.

[wandernat]

I ran a few versions of a one line inner join, couldn't get an exact match. Chose the closest one > 583 which is the number of commissioners (actually, it's 582 right now, a commissioner died recently).

The rest was good ol' fashioned administrative assistant-style data entry and research grunt work.

It is not possible for this basic web app project to be 100% automatic as the SBOE does not provide a downloadable list of current county commissioners. Manual work will always be involved until/unless that changes.

[cassiodorus]

Yup, that is a problem. Nevertheless, what you have done has to be replicable by someone else. Perhaps by creating a narrative that would allow replication. Anyway, your valuable work might have to be repeated for another year in order to demonstrate the effect of any intervention. Change has to be measured. Your work might be carried out by someone else. Indeed, even if you were to do it again you would need a process to follow. Dadvid

…

________________________________ From: Nat <notifications@github.com> Sent: Thursday, June 21, 2018 5:30:16 PM To: Open-NC/Are-We-Represented Cc: David Hopp; Comment Subject: Re: [Open-NC/Are-We-Represented] Obtain data on current county commissioners (#8) I ran a few versions of a one line inner join, couldn't get an exact match. Chose the closest one > 583 which is the number of commissioners (actually, it's 582 right now, a commissioner died recently). The rest was good ol' fashioned administrative assistant-style data entry and research grunt work. It is not possible for this basic web app project to be 100% automatic as the SBOE does not provide a downloadable list of current county commissioners. Manual work will always be involved until/unless that changes. — You are receiving this because you commented. Reply to this email directly, view it on GitHub<#8 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/ACI2ObD7qKoHEyfO27DJC9cb_yIIIB4cks5t_BBogaJpZM4SL3ed>.

[wandernat]

I kept notes on my process. Here are the steps I took:

1.	I visited each county’s website and found the roster of commissioners
2.	I copied each name to a text document. I double checked this by going back and counting the number of commissioners and comparing it to the count on my text document. If the numbers matched and there were no duplicate names on my text document, I proceeded.
3.	I checked each name individually in the FOIA-ed candidate listing xls (FINAL-candidate_listing_by_election-1.xlsx)
4.	I made sure the city associated with their address is in the county in which they are a commissioner to make sure I had the correct person (Some people have common names.)(Please note that some cities extend into counties where you wouldn’t expect. For example, New Bern is mostly in Craven County, but extends into Pamlico County as well.)
5.	I created a column for County since that it wasn’t included in the FOIA’d candidate listing spreadsheet. Once I confirmed a candidate, I typed their county into either their most recent record since many have listings for multiple terms. If a candidate had a date outside of 11/4/14 or 11/8/16, this meant that they were appointed to a vacant seat after losing an election. I googled to confirm each case. (It’s possible that some of the 11/4/14 and 11/8/16 names actually lost those elections and were appointed later.)
6.	If I couldn’t find a commissioner’s record in the xls document, I conducted a google search. Every time, it turned out that the commissioner had been appointed to a vacant spot, hence no candidate listing since they were not a candidate. I made a list of these names to add later.
7.	After going through steps 1-6 for all counties, I went back and checked the spreadsheet against the text document. I had 7 errors out of 555 candidate listings, 2 were not marked in the county column and 5 were assigned to the wrong county. I fixed those errors.
8.	Then I added the appointed commissioners to the database. Since most of them are now running for election for their seats, it was easy to find addresses for them via their candidate listing and/or voter registration. Also, many counties list commissioner addresses. The few that were harder to pin down simply took a little internet sleuthing, but a combination of news articles and voter registration lookup did the trick.
9.	I checked my text document against my new spreadsheet one more time. No more errors.
10.	I did a very simple inner join to contrast this spreadsheet against the state database. It did not yield the exact results. So I chose a join that gave 784 results.
11.	I manually combed through the results. Most duplicates were fathers/sons sharing the same name. I had to figure out which one was in office.
12.	I made a list of missing commissioners from the inner join. Most of the time, I had to learn their true legal name which was different from their name on the candidate listing, which is why it didn’t get paired up in the inner join. Once I had better info, I could run the inner join again to get their voter registration information. I researched/inner joined until I had a complete list.

13. I then went back and doublechecked (it's really more like triple or quadruple checking at this point) names and addresses to be 100% sure. Everything checked out including the total number of 583 county commissioners (I learned soon after that one had died in May, he's still listed on the site and has no replacement yet).

Also, here are notes on various things I learned when resolving discrepancies:

ALAMANCE - Eddie Boswell (R) - missing from inner join, found a different address than candidate listing on https://www.alamance-nc.com/commissioners/home-1/our-commissioners-2/commissioner-eddie-boswell/ the address has a hyphen in it’s not always listed that way, so that’s probably why it didn’t show in inner join. First legal name is Eddie not Edward or Ed

ALLEGHANY James Evans (R) (goes by Mark) double record - One is currently registered unaffiliated, one Republican. candidate listing for 2018 is Republican. Safe to assume that’s a re-election. Campaign FB page for current commissioner running for re-election promotes local GOP meeting on 3/31. Safe to select Rep over Una.
http://alleghanyelections.com/wp-content/uploads/2018/02/candidate-list-2018-5.pdf

ANSON - Jarvis T. Woodburn (D) - double record - for Jarvis Woodburn in Anson. Since this commissioner’s middle initial is T, it makes sense to choose the record with the middle name Thomas vs the one with middle name Devante.

ASHE - William Sands (R) - missing from inner join, there is only one William Sands registered in Ashe County. The candidate listing matches up with the voter registration so it is unclear why his record did not come up with the inner join.

AVERY - Martha J. Hicks (R) - double record for Martha Hicks - chose the one with middle name Jaynes instead of Berneice

AVERY - Wood Hall Young, Jr’s (R) missing from inner join, candidate listing address is different from his voter registration mailing address, which is why it didn’t connect in the inner join

BLADEN - David R. Gooden (R) - 2 records with same first and last name but only one matches middle name

BLADEN - Charles Ray Peterson (D) - 2 records popped up b/c I couldn’t do a middle name join - removed Charles Daniel Peterson

BLADEN - Russell Priest (D)- 2 records, both first name Daniel, middle name Leon-Russell, etc only difference is birth year. Manual lookup of voter registrations reveals a Jr and a III. candidate listing shows record for Jr http://bladennc.govoffice3.com/vertical/Sites/%7B3428E8B4-BA8D-4BCE-9B92-0A719CB4C4FB%7D/uploads/candidate_listing_for_may_2018_primary.pdf, safe to select older Priest

BLADEN Daniel Dowless - changed from D to R current reg is R but this 2016 article shows he used to be Democrat https://www.bladenjournal.com/top-stories/9363/bladen-county-board-of-commissioners-gets-three-new-faces

BLADEN Charles Ray Peterson - changed from D to R in 2015 https://bladenonline.com/a-note-from-charles-ray-peterson/

BLADEN - Dr. Ophelia Munn-Goins (D) - missing from inner join, address the same. likely due to issue with hyphenated last name - not hyphenated in candidate listing but hyphenated in the voter record

BRUNSWICK - Michael Forte (R) - 2 records, different birth years - this guy is definitely older than 26

BUNCOMBE - Joseph Belcher (R) - 2 records, different middle names and birth years, this guy is definitely older than 33

BURKE - Wayne F. Abele Sr. (R) missing from inner join, possibly due to Sr on last name, addresses for candidate listing match voter registration

BURKE - Jeffrey C. Brittain (R) - 2 records, middle initial C. corresponds with Coy, removed middle name Weldon

BURKE - Scott Mulwee (R) - 2 records for legal first name Rondal - Scott is middle name, removed Teral middle name record

CABARRUS - Elizabeth Poole (R) - two records, different middle names, only one matches address

CALDWELL - Donnie Potter (R) - two records, different middle names, only one address matches

CAMDEN - Tom White (R) - 3 results - all first name george, which is his first name, only one with the middle name Thomas, that same record - the residential address matches the candidate listing address

CARTERET - Mark Mansfiseld (R) missing record inner join, 1 Mark Mansfield in voter search results for Carteret county, middle name Frazier, same as candidate listing for 2018 http://carteretcountync.gov/DocumentCenter/View/4599/candidate-list-2-20-18

CARTERET - Jonathan Robinson (R), 2 records , birth years different, this guy is definitely older than 27

CARTERET - Bill Smith (R) - 2 records, different addresses, only one matches candidate listing

CARTERET - George Ed Wheatly (R) - 2 records, different addresses, only one matches candidate listing

CASWELL - David Owen switched from D to R, currently an R article shows was a D http://www.caswellmessenger.com/news/article_ab7a5d80-4eea-11e4-b885-2fa94fdc0480.html

CHEROKEE - Cal Stiles (R) first name Calvin - first last name matches voter reg as does address, not sure why it didn’t pop up in inner join

CHEROKEE - C.B. McKinnon (R) first name David, missing from inner join, candidate listing address matches voter registration (so does first and last name) so not sure why missing from inner join

CHOWAN Greg Bonner (D) 2 records, diff birth years, this grey bearded man seems a couple decades older than 41

CHOWAN Don Faircloth (D) 2 records, diff birth years, this man doesn’t look 78 years old

CLAY Robert Cline Penland (R) 2 records for first, last name but only one w/ correct middle, removed other

COLUMBUS - Ricky Bullard (D) 2 records first name James, only one with middle Ricky

CRAVEN Johnnie Sampson, Jr. (D) 2 records first name Johnnie, diff ages, found an article about commissioner sampson talking about civil rights in the 60s and meeting MLK, probably the 1933 record and not the record with the 1956 birth date, removed younger http://www.newbernsj.com/photogallery/NC/20180403/NEWS/403009986/PH/1

CUMBERLAND Michael C. Boose (R) 2 records, diff birth years, this guy looks older than 34

CUMBERLAND Charles Evans (D) , 6 records, found documentation that middle initial is E, which leaves one record with Edward as middle name - that record’s mailing address matches candidate listing address https://fayettevillenc.gov/Home/ShowDocument?id=2701

CUMBERLAND W. Marshall Faircloth (D), 3 records matching William Faircloth, but only one with Marshall as the middle

CUMBERLAND Mike D. Hall (R) - 2 records matching Michael Hall, but only one with middle name to match middle initial D = Dennis

CUMBERLAND - James “Jimmy” Keefe switched from D to R http://www.fayobserver.com/news/20170914/inside-politics-clerk-candidate-blackwell-joins-gop

DARE Jack Shea (first name is John) (R) missing from inner join. first, last and address all match so not sure why not showing up in inner join

DARE Steve House (first name is Markis), (R) missing from inner join. first, last and address all match so not sure why not showing up in inner join

DAVIDSON Steve Jarvis (R) 2 records, diff addresses and birth years, this grandfather is older than 30 years old

DAVIDSON Steve Shell (R) re-election candidate listing has middle name as Franklin https://s3.amazonaws.com/dl.ncsbe.gov/Elections/2018/Candidate%20Filing/Candidate_Listing_2018_fullcounty.pdf

DAVIE Mark Jones (Mark S. Jones) (R), 2 records matching first and last names, but only one with middle name that starts with S

DUPLIN - Kennedy Thompson switched from UNA to R- candidate listing party Unaffiliated (double checked, he ran unaffiliated), current voter registration Republican

EDGECOMBE - Leonard Wiggins (D), 2 records, voter reg mailing address matches candidate listing address from 2016 http://www.edgecombecountync.gov/Departments/Board%20of%20Elections/candidate%20list%20grouped%20by%20contest%20092016.pdf, removed other record

EDGECOMBE William (Billy) Wooten (D), 2 records found record with his middle initial listed as B http://www.edgecombecountync.gov/Departments/Board%20of%20Elections/important%20notices/Elected%20Officials-JANUARY%2025%202017.pdf, one record matches that, removed other

FORSYTH Richard V. Linville (R) , 2 records matching first and last names but only one matching middle initial V,

FORSYTH Everette Witherspoon (D), 2 records, middle name L according to 2018 candidate listing, matches 1 record, removed other (Witherspoon lost primary, will be replaced 2019) https://s3.amazonaws.com/dl.ncsbe.gov/Elections/2018/Candidate%20Filing/Candidate_Listing_2018_fullcounty.pdf

FORSYTH Fleming El-Amin (D), missing from inner join probably due to lowercase first name entered in the cc database - that was my fault.

FRANKLIN Cedric K. Jones, Sr. (D), 2 records, diff birth years, older than 31, had a 30 year career as Cooperative Extension Director b4 becoming commissionerrecord https://www.thefranklintimes.com/mod/pubext/index.php?viewDay=2009-10-02

FRANKLIN Michael Schriver (R) 2 records, diff birth years, this guy looks older than 19, https://www.linkedin.com/in/michael-schriver-13752630

GASTON - Don Grant (R), 2 records matching first and last names, diff birth years, he looks older than 26 http://www.gastongazette.com/news/20170717/woman-makes-sexual-battery-allegation-against-commissioner

GASTON Bob Hovis (W. R. (Bob) Hovis) (R) , 2 records matching first and last names, only one matches R middle initial

GATES Billy F. Felton (D), 2 records matching first and last names, only one matches F middle initial

GATES J. Ray Freeman III (J stands for Joseph) (D) 2 records matching first and last names, only one matches Ray middle name, removed other

GATES Jack Owens (D) missing from inner join, candidate listing for 2018 lists legal name as Michael C Owens with nickname Jack Owens, https://s3.amazonaws.com/dl.ncsbe.gov/Elections/2018/Candidate%20Filing/Candidate_Listing_2018_fullcounty.pdf

GRAHAM Raymond Williams (R), 3 records, 2018 candidate listing has legal name as Raymond David Williams Sr. , which still matches 2 records (Since the Sr was not included with the last name) with diff birth years. a manual voter reg lookup showed Sr reg date as 1969 and Jr. registration date as 2016, so it is reasonable to conclude that the older record is the correct one, younger removed https://s3.amazonaws.com/dl.ncsbe.gov/Elections/2018/Candidate%20Filing/Candidate_Listing_2018_fullcounty.pdf

GRANVILLE David T Smith (D), 5 records matching first and last but only one matches middle initial

GREENE Jerry R Jones (R) 2 records matching first and last but only one matches middle initial

GUILFORD Jeff Phillips (6108 Mountain Brook Road, Greensboro, NC 27455), 2 records matching first and last but only one matching address, which was recorded putting the cc database together, to voter reg

HALIFAX Vernon J. Bryant (D) , 2 records matching first and last but only one matches middle initial

HARNETT William “Abe” Elmore (R), 2 records matching first and last name, diff birth years, he looks more like 86 than 61 to me https://www.facebook.com/HarnettCounty/posts/10154616111885971:0, also mailing address on cc web page matches the older record: Contact Info: PO Box 668, Dunn, NC 28335

HARNETT Barbara McKoy (D) , 2 records matching first and last name, diff birth years close in age, cc web page lists address as Contact Info: PO Box 553, Lillington, NC 27546, which matches one

HARNETT - Howard Penny (R), 2 records matching first and last name, cc web page lists address Contact Info: PO Box 736, Coats, NC 27521, which matches both records, lists name as Howard L. Penny, Jr. - but he does not look like the younger record which is 1969 or 49 years old, he looks like the 1947 / 71 years old record. a manual voter lookup shows the two records as being Howard Penny Jr (reg 1983) and Howard Penny III (reg 1992), so this confirms that the commissioner is the older record.

HAYWOOD - J. W. (KIRK) KIRKPATRICK, Ill (D), 4 records, only 2 have middle name to match middle initial, a manual voter lookup revealed just one J. W. (KIRK) KIRKPATRICK, Ill, the address matched one record

HENDERSON Charles Messer (R), 2 records matching first and last, close in birth year, according to cc website, Messer was born in 1954 https://www.hendersoncountync.gov/directory-listing/charles-messer, which matches one record

HERTFORD Curtis Anthony Freeman, Sr., 2 records matching first and last name, manual voter lookup reveals Curtis Anthony Freeman and Curtis Anthony Freeman, Jr., safe to assume the one without the Jr is the Sr. and the older record

HERTFORD John D. Horton (D)missing from inner join, only one John Horton in voter manual look up search results, address matches candidate listing

HOKE James A. Leach (D), 2 records same first and last name, only one middle name matches middle initial

HOKE Robert A. (Bobby) Wright, (D) 3 records matching first and last names, 1 record middle name didn’t match, remaining 2 diff ages, diff addresses, candidate listing matches older record

HOKE Tony Hunt (D)missing from inner join, cc website lists first name as Anthony, manual voter lookup yields 2 anthony hunts, both with middle names beginning with D (Dakota and Derek), Hunt was 51 in 2013 https://www.wral.com/hoke-commissioner-charged-in-domestic-dispute/13163099/, Dakota registered 2016, so likely not the commissioner who was in office prior to that date, Derek reg date is 1990 which works

HYDE Earl D. Pugh, Jr. (R), 2 records matching first and last, manual voter lookup yields Pugh Jr and Pugh III

HYDE Benjamin Simmons III (R), 2 records matching first and last, manual voter lookup yields Simmons Jr and Simmons III, the latter matches the residential address of one of the records

HYDE Barry Swindell switched from DEM to UNA - article shows he was democrat in 2014 http://islandfreepress.org/2014Archives/11.05.2014-DemocratsBuckTheStatewideTrendInHydeCounty.html but his current registration shows him as unaffiliated

IREDELL Marvin Norman (R), 2 records matching first and last name, one doesn’t match party affiliation or address so it’s removed

JACKSON Ronald Mau (R), 2 records matching first and last name, guy looks older than 27, also younger record party affiliation didn’t match

JACKSON BRIAN T. MCMAHAN (D) missing from inner join, unsure why, only one record matching the name and county upon manual voter lookup, address matches candidate listing

JONES Joseph F. Wiggins , 2 records matching first name, last name and middle name to middle initial, only one record matches party affiliation or candidate listing address

JONES Frank Emory (R) missing from inner join, 2018 candidate listing shows name as Charlie Franklin Emory Jr https://www.jonescountync.gov/vertical/sites/%7B9E2432B0-642B-4C2F-A31B-CDE7082E88E9%7D/uploads/candidate_list_as_of_june_11.pdf, my cc database had first name as Charles, which is why it wasn’t matched in inner join

JACKSON Charles R. Elders (R) - missing from inner join, somehow the inner join pulled in the wrong Charles Elders. The middle name does not match the middle initial, caught by double checking address matches

LEE Amy M. Dalrymple (D), 2 records matching first and last names, but only one matches middle initial to middle name or party affiliation

LEE Kevin Craig Dodson (R), 2 records matching first and last names, but only one matches middle name, he also switched from REP to DEM http://www.sanfordherald.com/news/election-democratic-county-commissioner-kevin-dodson-announces-run-for-lee/article_c0b83d12-05ca-11e8-aad5-8fb3a26dbaca.html

LENOIR Linda Rouse Sutton (D) , 6 records matching first and last names, but only one matching middle name

LENOIR Eric S. Rouse (R), 2 records matching first and last names, but only one matching middle initial to middle name and party affiliation

LENOIR Reuben J. Davis , 2 records matching first and last names and both match middle name to middle initial but they are diff mid names Jeffery and Joshua. cc web site lists address as 2141 Oakridge Rd, Kinston, NC 28504, which means Joshua is the correct middle name

LENOIR J. Mac Daughety ran as UNA in 2014 but is registered REP - he may have run unaffiliated by petition and been a REP all along, or he may have switched

MACON James P. Tate (R), 2 records matching first and last names, only one matches middle name to middle initial and party affiliation

MADISON William Briggs (C. William (Bill) Briggs) (R) 2 records matching first and last names, diff birth years, Briggs has served for two terms, so unlikely that he is the 30 year old, https://www.citizen-times.com/story/news/madison/2018/04/16/madison-county-primary-election-guide/514608002/

MARTIN Elmo Butch Lilley ran as UNA in 2014 but is registered DEM - he may have run unaffiliated by petition and been a DEM all along, or he may have switched

MCDOWELL Tony G. Brown (R), missing from inner join, 2018 candidate listing shows G stands for Garrett and Tony is not short for Anthony, which matches a Tony Garrett Brown in a manual voter lookup https://s3.amazonaws.com/dl.ncsbe.gov/Elections/2018/Candidate%20Filing/Candidate_Listing_2018_fullcounty.pdf, voter reg address doesn’t match candidate listing address which is probably why he didn’t turn up in inner join

MECKLENBURG Bill James (R) - 5 records matching first and last names, 2 are 31 year olds which seems to young for this man; one is 89 which seems to old; of the 2 remaining, only one voter reg address matches the candidate listing address

MECKLENBURG George Dunlap (D) 2 records matching first and last names, diff middle names and birth years; according to campaign website, he retired from the police dept in 2005 after a 27 year career so unlikely he is the 42 year old, since that would have required him to become a police officer at 17 http://www.vote4dunlap.com/about-george/

MECKLENBURG Ella Scarborough (D), her voting record is listed as inactive? but she just won her primary May 2018. missing a vote record for that day but has voted 70 times otherwise - perhaps she got married or changed her name?

MITCHELL Danny Ray Burleson (R), 2 records matching first, last and middle names, 10 years apart. only 1 matches voter reg address to candidate listing

MITCHELL Ken W. Hollifield (R) 2 records matching first and last names, only one matches middle name to middle initial plus voter reg address to candidate listing address

MITCHELL Matthew “Vern” Grindstaff - his middle initial is A according to his 2018 candidate listing.

MOORE Louis Gregory (first name Samuel) (R), missing from inner join, probably b/c his full name is Samuel Louis Gregory III - maybe the voter reg includes III as part of the last name

NEW HANOVER Jonathan Barfield, Jr. (D) 2 records matching first and last names but only one record matched voter reg address to candidate listing address

NEW HANOVER Brian Calvin “Skip” Watkins (R), 2 records matching first and last name and address but this guy’s profile says he’s lived in Wilmington for over 35 years so he’s not the 25 year old https://commissioners.nhcgov.com/commissioners/vice-chair/

NEW HANOVER Haywood Edwin “Woody” White (R), 2 records matching first and last name and address, but this guy’s profile says he received a law degree in 1994 so he’s not the one born in 2000 https://commissioners.nhcgov.com/commissioners/chair/

NEW HANOVER Patricia Kusek missing from inner join

NORTHAMPTON Chester Johnell Deloatch, Sr. (D), 2 records matching first and last name and address, manual voter lookup shows a Jr and Sr. Sr’s voter reg is 1966 Jr’s birth year is 1966 so that one is removed

NORTHAMPTON Charles R. Tyner, Sr. (D) 2 records matching first and last name but only one matches voter reg address to candidate listing address

PAMLICO Paul J. Delamar (R) - 2 records matching first and last name and middle name to middle initial. Manual voter lookup reveals Delamar Jr and Delamar III - both are involved in local politics. Delamar Jr is a Democrat on the Board of Education, Delamar III is the county commissioner who apparently has switched from Dem to Rep

PAMLICO Edward Riggs, Jr (R), missing from inner join

PAMLICO Carl J. Ollison (D), missing from inner join

PASQUOTANK Joe Winslow (D) 2 records matching first and last name and address, Winslow is 70, selected record that matched that age http://www.dailyadvance.com/News/2018/01/17/Winslow-to-seek-re-election.html

PASQUOTANK Cecil Perry (D), 2 records matching first and last name, but only one matched on address

PENDER George Brown (R) 2 records matching first and last name and address, birth year diff - looks older than 26

PENDER James David Williams (R) 2 records matching first and last name but only one matches voter reg address to candidate listing address

PERQUIMANS Thomas Kyle Jones (R) - 3 records matching first and last name but only one matching middle name

PERQUIMANS Charles Woodard (D) , 2 records matching first and last name, but only one matched on address

PERQUIMANS Ed Muzzulin switched from DEM to UNA, article shows he used to be Democrat

PITT Elizabeth “Beth” Baker Ward (D) , 5 records matching first and last name, but only one matched address

PITT Mary Perkins Williams (listed as middle name Perkins, last name Williams) (D) , 14 records match first and last name, only one matched middle name, addresses weren’t the same, but voter reg mailing address matches the addresses given on her county profile https://www.pittcountync.gov/directory.aspx?EID=45

PITT Glen T Webb II (R), voter registration address already outdated, perhaps he moved or simply finally updated his address, his old address is his father’s address, left old address in residential section, updated address in mail address section

POLK Myron Yoder (R) missing from inner join

RANDOLPH Haywood has died and no one has been appointed to his seat yet (6/21/18)

ROBESON Berlister Campbell (D) 2 records, same first and last name, diff birth dates, Campbell has 14 non-consecutive years as commissioner and 3 years of service in the U.S. army, so likely not the 38 year old. not impossible but not likely. https://www.robesonian.com/news/108291/campbell-seeks-re-election-as-district-2-commissioner

ROBESON Raymond Cummings (D) 2 records, same first and last name, diff birth dates, this guy looks older than 31

ROBESON David Edge (R) 2 records, same first and last name, diff birth dates, this guy looks older than 37

ROBESON Jerry L. Stephens, Sr. (D) 2 records, same first and last name (minus the Sr), diff birth years, manual voter lookup reveals there is a Sr and Jr , selected older record since Jr just registered to vote in 2018

RUTHERFORD James Gregory (R) Lovelace 2 records, same first and last name but not middle

RUTHERFORD Alan Toney (R) , 2 records, same first, last and middle name and address, one guy is 24 doesn’t seem old enough to have teenage kids in campaign photo on FB https://www.facebook.com/AlanToneyCCD5/

SAMPSON Robert Jerol Kivett (R) , missing from inner join

SAMPSON Clark Wooten missing from inner join, weirdly there are two Clark Wootens in Sampson county so even stranger it didn’t get included in inner join, Wooten III registered to vote in 2014, the same year Wooten was first elected as commissioner, safe to assume the commissioner was registered well before that. the older Wooten registered in 1980, that makes more sense https://www.clintonnc.com/top-stories/15495/wooten-selected-as-new-chairman-of-county-board

SCOTLAND John T. Alford , 3 records matching first and last name but only one matching middle name to middle initial

SCOTLAND Robert Craig Davis, 2 records matching first and last name and middle but only one matching address (double checked voter registration for both)

SCOTLAND Guy McCook 2 records matching first and last name but only one address matches one on county commissioner profile https://www.scotlandcounty.org/directory.aspx?EID=103

STANLY Joseph L. Burleson (R) missing from inner join, weirdly two Joseph Burleson’s did show up in the inner join but neither has the correct middle name

SURRY Larry Phillips (R) 3 records matching first and last name, 2018 candidate listing has his full legal name as Larry Ray Phillips which matches one record

SURRY Larry D. Johnson (R) 3 records matching first and last name and middle initial, matched the voter reg address to the address on county commissioner page http://www.co.surry.nc.us/departments/(a_through_j)/commissioners/board_members.php

SWAIN Phil Carson (R) 2 records matching first and last name and middle name and address, diff ages, he looks older than 27 https://mountainx.com/blogwire/swain-gets-4-million-in-partial-fulfillment-of-fontana-settlement/

SWAIN Ben Bushyhead (D) missing from inner join, probably because his full name was not in the cc db. Benjamin Lee Bushyhead

TRANSYLVANIA KELVIN PHILLIPS (first name James) 2 records first and last name match but not middle

TRANSYLVANIA JASON CHAPPELL (Jason Robert Chappell) (R) missing from inner join

VANCE Robert Dan Brummitt (R) 2 records matching first and last name but only one matching middle initial to middle name

VANCE Carolyn Faines (D) 2 records matching first and last name, only one matches address on county commissioner page http://www.vancecounty.org/departments/board-of-commissioners/

VANCE Thomas S. Hester, Jr. (R) 2 records matching first and last name, only one matches middle initial to middle name

VANCE Archie B. Taylor, Jr. (D) 2 records matching first and last name, only one matches address on county commissioner page http://www.vancecounty.org/departments/board-of-commissioners/

VANCE Gordon Wilder (D) missing from inner join, didn’t have his legal first name which is William https://homeinhenderson.com/2009/12/14/wilder-to-run-for-county-commission-district-3/

WAKE John Burns (D) 2 records matching first and last name, only one matches middle name; according to candidate listing full name John David Burns https://s3.amazonaws.com/dl.ncsbe.gov/Elections/2018/Candidate%20Filing/Candidate_Listing_2018_fullcounty.pdf

WAKE Jessica Holmes (D) 2 records matching first and last name, diff birth years. In December 2014 she was 30, making the 1984 the correct record. Holmes is also black and the 1984 record is black while the 1971 record is white

WAKE James West (D) 8 records same first and last name, only one matches the address on his county profile http://www.wakegov.com/commissioners/districts/Pages/district5.aspx

WARREN Victor Hunt (D), missing from inner join, there are two Victor Hunts, one Jr and one Sr, both have the same address which matches the one on the county profile http://www.warrencountync.com/469/Victor-Hunt Sr registered in 1978 and has been farming in Warren County since 1978 http://www.warrenrecord.com/news/article_15face9c-4083-11e7-a24b-7b8b53f00c3a.html Jr didn’t vote in the 2014 general when the commissioner was elected. and has only voted 3 times since 2008 that seems very unlikely for an elected official.

WASHINGTON David Cole Phelps (D) - 2 records matching first and last name, but only one matching middle

WATAUGA James Hodges, 3 records matching first and last name, only one matching address on county page http://www.wataugacounty.org/App_Pages/Dept/BOC/members.aspx

WATAUGA Henry Perry Yates (R), 2 records matching first and last name, only one matching address on county page http://www.wataugacounty.org/App_Pages/Dept/BOC/members.aspx

WAYNE Edward Cromartie (D) 2 records matching first and last name, only one matching address on county page http://nc-waynecounty.civicplus.com/655/Edward-Cromartie

WAYNE William “Bill” Pate (R) 4 records matching first and last name only one matching address on county page http://nc-waynecounty.civicplus.com/659/Bill-Pate

WAYNE John Bell , 2 records matching first and last name only one matching middle initial to middle name and address on county page http://nc-waynecounty.civicplus.com/654/John-M-Bell - I had the wrong John Bell in the county commissioners - the other john bell is a white republican who is in the state house. so it looked like he had been a Republican that switched to a Democrat. But he’s been a Democrat all along.

WILKES David Gambill (R) , 3 records matching first and last name, 2018 candidate listing shows full legal name as David Duane Gambill Jr, which removes the record with middle name Paul, manual voter lookup confirms address, other record removed https://s3.amazonaws.com/dl.ncsbe.gov/Elections/2018/Candidate%20Filing/Candidate_Listing_2018_fullcounty.pdf

WILKES Gary D. Blevins 2 records matching first and last name but only one matching middle initial to middle name

WILKES Gregory A. Minton (R) - missing from inner join, inner join pulled just one of the Gregory Minton records from Wilkes County. Minton’s middle initial is officially A according to 2018 candidate listing. but inner join pulled the record with the middle name Van and not the one with Alan. This was caught during voter reg/candidate listing address comparison.

WILSON JoAnne Daniels (D), missing from inner join, her name was not capitalized which is probably why it didn’t get included in the inner join - my fault when creating cc db

YADKIN David Moxley (R), 2 records matching first and last name, only one matching address on county page http://www.yadkincountync.gov/Directory.aspx?EID=19

YANCEY Jerry Mark Ledford 2 records matching first and last name only one matching middle name

YANCEY John “Johnny” Riddle (D), 2018 candidate listing shows full legal name as John Ransom Riddle, matching one of the records for middle name

YANCEY Lesa “Jill” Austin (D), missing from inner join, her full legal name is Lesa Jill McIntosh Austin according to 2018 candidate listing - i misspelled her first name as Lisa in cc db

[wandernat]

David, since you're using the NCACC dataset for your choropleths, please provide notes about how they collected the data, what their process was, and any reproducible research you're able to get from them. Thanks.

[wandernat]

Josh helped me use GitHub tonight, so I uploaded the county commissioner database and all my notes from the process here: https://github.com/Open-NC/Are-We-Represented/tree/master/nc-cc-data