20181106__pa__general__juniata__precinct.csv vote discrepancies

[rootsmusic]

In this file, Governor and U.S. Senate candidates have vote discrepancies in the following precincts when compared to the source file.

precinct	Louis J Barletta	Robert P Casey Jr	Scott R Wagner	Thomas W Wolf	Grand Total
0002 DELAWARE	1	2	1	2	6
0003 FAYETTE	2	1	2	1	6
0004 FERMANAGH	3		3		6
0008 MIFFLINTOWN	-1		2	1
0009 MILFORD	1		1	2
0010 MONROE	1		1		2
0015 TURBETT	1			1	2
0018 WALKER	1		1		2
Grand Total	9	3	8	7	27

[dwillis]

@rootsmusic I'm checking these against this file and don't see these discrepancies?

[rootsmusic]

(@dwillis, I'm just downloading the source files for this and Montour to investigate tomorrow.) Both versions had been downloaded from their respective county's website. Since both had printed within a couple days after the General Election, these uploaded versions were likely uncertified. If you have versions dated later, please upload for me to validate.

I'm partly validating against the state's uncertified results, which was printed over half a year later. So I suspect that both counties updated their results after the uploaded versions had printed.

[peter-redistricting-data-hub]

In 0008 MIFFLINTOWN there should be 106 votes for Bob Casey Jr. not, 109

[rootsmusic]

(Note that I've revised this issue's table of vote discrepancies.) What I suspected appears to be true. My validation sources are:

1. The County's Precinct Report (printed on election day).
2. The State's uncertified precinct-level results (7/26/2019).
3. The State's certified county-level results.

At county-level for Governor and Senate candidates, source 3 validates source 2 but not source 1. The county-level vote discrepancies (source 3 minus source 1) are tabulated below, and notice that they match the Grand Total row in this issue's first table.

	Louis J Barletta	Robert P Casey Jr	Scott R Wagner	Thomas W Wolf	Grand Total
source 3 - source 1	9	3	8	7	27

[peter-redistricting-data-hub]

@rootsmusic your differences look correct to me. It looks like VEST corrected these in their file using (2). I looked at their changes at the precinct-level, and in all cases what the OE value is (marked by (S)) is not a typo from the county precinct report. It's just that the precinct report totals do not match those of the state certified county-level results.

I opened a separate issue laying out the counties where this happens.

Barletta - 9 votes
G18USSRBAR .......................................................067000020DELAWARE (S) ..430 (V)..431 (D): -1
G18USSRBAR ........................................................067000030FAYETTE (S) ..961 (V)..963 (D): -2
G18USSRBAR ......................................................067000040FERMANAGH (S) ..747 (V)..750 (D): -3
G18USSRBAR .........................................................067000120MONROE (S) ..568 (V)..569 (D): -1
G18USSRBAR .........................................................067000200WALKER (S) ..604 (V)..605 (D): -1
G18USSRBAR ........................................................067000170TURBETT (S) ..226 (V)..227 (D): -1

Casey - 3 votes
G18USSDCAS .......................................................067000020DELAWARE (S) ..142 (V)..144 (D): -2
G18USSDCAS ........................................................067000030FAYETTE (S) ..291 (V)..292 (D): -1
G18USSDCAS ....................................................067000100MIFFLINTOWN (S) ..109 (V)..108 (D): 1
G18USSDCAS ........................................................067000110MILFORD (S) ..308 (V)..309 (D): -1

Wagner - 8 votes
G18GOVRWAG .......................................................067000020DELAWARE (S) ..415 (V)..416 (D): -1
G18GOVRWAG ........................................................067000030FAYETTE (S) ..960 (V)..962 (D): -2
G18GOVRWAG ......................................................067000040FERMANAGH (S) ..715 (V)..718 (D): -3
G18GOVRWAG .........................................................067000120MONROE (S) ..556 (V)..557 (D): -1
G18GOVRWAG .........................................................067000200WALKER (S) ..599 (V)..600 (D): -1

Wolf - 7 votes
G18GOVDWOL .......................................................067000020DELAWARE (S) ..152 (V)..154 (D): -2
G18GOVDWOL ........................................................067000030FAYETTE (S) ..295 (V)..296 (D): -1
G18GOVDWOL ....................................................067000100MIFFLINTOWN (S) ..106 (V)..108 (D): -2
G18GOVDWOL ........................................................067000110MILFORD (S) ..315 (V)..316 (D): -1
G18GOVDWOL ........................................................067000170TURBETT (S) ..112 (V)..113 (D): -1

[rootsmusic]

peter-redistricting-data-hub wrote:

what the OE value is (marked by (S)) is not a typo from the county precinct report.

@dwillis has already checked that this file doesn't have typos. If source 1 was indeed certified though, then VEST wouldn't have to replace with source 2. So he should confirm whether source 1 was later certified by the County.