Categories
Election Data Analysis Election Forensics Election Integrity programming technical

Number of duplicated voter records in each VA locality

Computed below is the number of duplicated voter records in each locality as of the 11/06/21 VA Registered Voter List (RVL). The computation is based on performing an exact match of LAST_NAME, DOB and ADDRESS fields between records in the file.

Note: If the combination of the name “Jane Smith”, with DOB “1/1/1980”, at “12345 Some Road, Ln.” appears 3 times in the file, there are 3 counts added to the results below. If the combination appears only once, there are 0 counts added to the results below, as there is no repetition.

Additionally I’ve done an even more restrictive matching which requires exact match on FIRST, MIDDLE and LAST name, DOB and ADDRESS fields in the second graphic and list presented below.

The first, more lenient, criteria will correctly flag multiple records with the same first or middle name, but misspelled such as “Muhammad” vs “Mahammad”, but could also include occurrences of voting age twins who live together or spouses with the same DOB.

The second, more strict, criteria requires that multiple rows flagged have exactly the same spelling and punctuation for FIRST, MIDDLE, LAST, DOB and ADDRESS fields. This has less false positive, but more false negatives, as it will likely miss common misspellings between entries, etc.

There are no attempts to match for common misspellings, etc. I did do a simple cleanup for multiple contiguous whitespace elements, etc., before attempting to match.

I have summarized the data here so as not to reveal any personally identifiable information (PII) from the RVL in adherence to VA law.

Update 2022-07-13 12:30: I have sent the full information, for both the lenient and strict criteria queries, to the Prince William County and Loudoun County Registrars. The Loudoun deputy registrar has responded and stated that all but 1 of the duplications in the stricter criteria had already been caught by the elections staff, but he has not yet looked at the entries in the more lenient criteria results file. I have also attempted to contact the Henrico County, Lynchburg City, and York County registrars but have not yet received a response or request to provide them with the full data.

Update 2022-07-31 23:03: I have also heard back from the PWC Registrar (Eric Olsen). Most of the entries that I had flagged in the 11/6/2021 RVL list have already been taken care of by the PWC staff already. There were only a couple that had not yet been noticed or marked as duplicates. Also, per our discussion, I should reiterate and clarify that the titles on the plots below simply refer to duplicated entries of the data files according to the filtering choice. It is a technically accurate description and should not be read as I am asserting other than the results of the matching operation.

Locality NameNumber of repeated entries
ACCOMACK COUNTY64
ALBEMARLE COUNTY311
ALEXANDRIA CITY225
ALLEGHANY COUNTY16
AMELIA COUNTY32
AMHERST COUNTY84
APPOMATTOX COUNTY18
ARLINGTON COUNTY446
AUGUSTA COUNTY119
BATH COUNTY2
BEDFORD COUNTY170
BLAND COUNTY4
BOTETOURT COUNTY45
BRISTOL CITY22
BRUNSWICK COUNTY30
BUCHANAN COUNTY30
BUCKINGHAM COUNTY32
BUENA VISTA CITY10
CAMPBELL COUNTY82
CAROLINE COUNTY67
CARROLL COUNTY42
CHARLES CITY COUNTY18
CHARLOTTE COUNTY28
CHARLOTTESVILLE CITY80
CHESAPEAKE CITY545
CHESTERFIELD COUNTY948
CLARKE COUNTY40
COLONIAL HEIGHTS CITY18
COVINGTON CITY2
CRAIG COUNTY4
CULPEPER COUNTY114
CUMBERLAND COUNTY8
DANVILLE CITY88
DICKENSON COUNTY22
DINWIDDIE COUNTY44
EMPORIA CITY6
ESSEX COUNTY25
FAIRFAX CITY38
FAIRFAX COUNTY2962
FALLS CHURCH CITY39
FAUQUIER COUNTY203
FLOYD COUNTY28
FLUVANNA COUNTY36
FRANKLIN CITY23
FRANKLIN COUNTY84
FREDERICK COUNTY210
FREDERICKSBURG CITY54
GALAX CITY0
GILES COUNTY24
GLOUCESTER COUNTY52
GOOCHLAND COUNTY84
GRAYSON COUNTY18
GREENE COUNTY32
GREENSVILLE COUNTY16
HALIFAX COUNTY48
HAMPTON CITY285
HANOVER COUNTY316
HARRISONBURG CITY40
HENRICO COUNTY676
HENRY COUNTY74
HIGHLAND COUNTY4
HOPEWELL CITY34
ISLE OF WIGHT COUNTY98
JAMES CITY COUNTY217
KING & QUEEN COUNTY13
KING GEORGE COUNTY42
KING WILLIAM COUNTY43
LANCASTER COUNTY10
LEE COUNTY24
LEXINGTON CITY12
LOUDOUN COUNTY1245
LOUISA COUNTY74
LUNENBURG COUNTY26
LYNCHBURG CITY165
MADISON COUNTY12
MANASSAS CITY64
MANASSAS PARK CITY24
MARTINSVILLE CITY14
MATHEWS COUNTY18
MECKLENBURG COUNTY54
MIDDLESEX COUNTY12
MONTGOMERY COUNTY159
NELSON COUNTY30
NEW KENT COUNTY26
NEWPORT NEWS CITY329
NORFOLK CITY411
NORTHAMPTON COUNTY18
NORTHUMBERLAND COUNTY22
NORTON CITY6
NOTTOWAY COUNTY12
ORANGE COUNTY70
PAGE COUNTY47
PATRICK COUNTY28
PETERSBURG CITY68
PITTSYLVANIA COUNTY84
POQUOSON CITY28
PORTSMOUTH CITY186
POWHATAN COUNTY55
PRINCE EDWARD COUNTY43
PRINCE GEORGE COUNTY77
PRINCE WILLIAM COUNTY1159
PULASKI COUNTY59
RADFORD CITY14
RAPPAHANNOCK COUNTY10
RICHMOND CITY300
RICHMOND COUNTY14
ROANOKE CITY133
ROANOKE COUNTY233
ROCKBRIDGE COUNTY28
ROCKINGHAM COUNTY113
RUSSELL COUNTY28
SALEM CITY58
SCOTT COUNTY18
SHENANDOAH COUNTY48
SMYTH COUNTY40
SOUTHAMPTON COUNTY28
SPOTSYLVANIA COUNTY345
STAFFORD COUNTY410
STAUNTON CITY14
SUFFOLK CITY194
SURRY COUNTY10
SUSSEX COUNTY14
TAZEWELL COUNTY52
VIRGINIA BEACH CITY922
WARREN COUNTY46
WASHINGTON COUNTY78
WAYNESBORO CITY26
WESTMORELAND COUNTY24
WILLIAMSBURG CITY22
WINCHESTER CITY42
WISE COUNTY40
WYTHE COUNTY35
YORK COUNTY178
Locality NameNumber of repeated entries
ACCOMACK COUNTY0
ALBEMARLE COUNTY4
ALEXANDRIA CITY0
ALLEGHANY COUNTY0
AMELIA COUNTY0
AMHERST COUNTY2
APPOMATTOX COUNTY0
ARLINGTON COUNTY10
AUGUSTA COUNTY0
BATH COUNTY0
BEDFORD COUNTY4
BLAND COUNTY0
BOTETOURT COUNTY0
BRISTOL CITY0
BRUNSWICK COUNTY0
BUCHANAN COUNTY2
BUCKINGHAM COUNTY0
BUENA VISTA CITY0
CAMPBELL COUNTY2
CAROLINE COUNTY0
CARROLL COUNTY0
CHARLES CITY COUNTY0
CHARLOTTE COUNTY0
CHARLOTTESVILLE CITY0
CHESAPEAKE CITY8
CHESTERFIELD COUNTY8
CLARKE COUNTY0
COLONIAL HEIGHTS CITY0
COVINGTON CITY0
CRAIG COUNTY0
CULPEPER COUNTY0
CUMBERLAND COUNTY0
DANVILLE CITY0
DICKENSON COUNTY0
DINWIDDIE COUNTY0
EMPORIA CITY0
ESSEX COUNTY0
FAIRFAX CITY0
FAIRFAX COUNTY54
FALLS CHURCH CITY0
FAUQUIER COUNTY2
FLOYD COUNTY0
FLUVANNA COUNTY0
FRANKLIN CITY3
FRANKLIN COUNTY0
FREDERICK COUNTY6
FREDERICKSBURG CITY0
GALAX CITY0
GILES COUNTY2
GLOUCESTER COUNTY0
GOOCHLAND COUNTY0
GRAYSON COUNTY0
GREENE COUNTY0
GREENSVILLE COUNTY0
HALIFAX COUNTY0
HAMPTON CITY8
HANOVER COUNTY0
HARRISONBURG CITY0
HENRICO COUNTY24
HENRY COUNTY2
HIGHLAND COUNTY0
HOPEWELL CITY2
ISLE OF WIGHT COUNTY4
JAMES CITY COUNTY0
KING & QUEEN COUNTY0
KING GEORGE COUNTY0
KING WILLIAM COUNTY0
LANCASTER COUNTY0
LEE COUNTY0
LEXINGTON CITY0
LOUDOUN COUNTY23
LOUISA COUNTY0
LUNENBURG COUNTY0
LYNCHBURG CITY16
MADISON COUNTY0
MANASSAS CITY0
MANASSAS PARK CITY0
MARTINSVILLE CITY0
MATHEWS COUNTY2
MECKLENBURG COUNTY0
MIDDLESEX COUNTY0
MONTGOMERY COUNTY2
NELSON COUNTY0
NEW KENT COUNTY0
NEWPORT NEWS CITY0
NORFOLK CITY0
NORTHAMPTON COUNTY0
NORTHUMBERLAND COUNTY0
NORTON CITY0
NOTTOWAY COUNTY0
ORANGE COUNTY0
PAGE COUNTY0
PATRICK COUNTY0
PETERSBURG CITY0
PITTSYLVANIA COUNTY4
POQUOSON CITY0
PORTSMOUTH CITY0
POWHATAN COUNTY0
PRINCE EDWARD COUNTY0
PRINCE GEORGE COUNTY0
PRINCE WILLIAM COUNTY8
PULASKI COUNTY0
RADFORD CITY0
RAPPAHANNOCK COUNTY0
RICHMOND CITY10
RICHMOND COUNTY0
ROANOKE CITY0
ROANOKE COUNTY11
ROCKBRIDGE COUNTY0
ROCKINGHAM COUNTY4
RUSSELL COUNTY0
SALEM CITY0
SCOTT COUNTY0
SHENANDOAH COUNTY0
SMYTH COUNTY0
SOUTHAMPTON COUNTY0
SPOTSYLVANIA COUNTY4
STAFFORD COUNTY4
STAUNTON CITY0
SUFFOLK CITY4
SURRY COUNTY0
SUSSEX COUNTY0
TAZEWELL COUNTY2
VIRGINIA BEACH CITY4
WARREN COUNTY0
WASHINGTON COUNTY0
WAYNESBORO CITY0
WESTMORELAND COUNTY2
WILLIAMSBURG CITY0
WINCHESTER CITY0
WISE COUNTY0
WYTHE COUNTY2
YORK COUNTY0