Open ejaxon opened 6 years ago
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
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.
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 GitHubhttps://github.com/Open-NC/Are-We-Represented/issues/8#issuecomment-395277762, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ACI2OechAClhsKYfcfFuEvWEUC2CZVw1ks5t6JfjgaJpZM4SL3ed.
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 GitHubhttps://github.com/Open-NC/Are-We-Represented/issues/8#issuecomment-395277762, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ACI2OechAClhsKYfcfFuEvWEUC2CZVw1ks5t6JfjgaJpZM4SL3ed.
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.
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 GitHubhttps://github.com/Open-NC/Are-We-Represented/issues/8#issuecomment-398494144, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ACI2OUx_b25hRvVqSAbQ6fwZOB5zhKh0ks5t-T8CgaJpZM4SL3ed.
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.
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 GitHubhttps://github.com/Open-NC/Are-We-Represented/issues/8#issuecomment-399249811, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ACI2ObD7qKoHEyfO27DJC9cb_yIIIB4cks5t_BBogaJpZM4SL3ed.
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.
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
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.
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
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.