Colorado overview: privacy-based redaction

[kuriwaki]

@canemutlu is planning on looking into Colorado but here is an overview plus an interesting thing I found from the Colorado SOS.

• Colorado's 2017 guidance recommends county to "redact" vote choices (remove the vote choice from a cell) for a precinct part with fewer than 10 votes (see a screenshot of my ESRA presentation below), before releasing to FOIA requests. That will make us a few Biden+Trump votes short. In fact, I realized some Excel files from votedatabase are called Logan 2020 Redacted CVR Export.csv. Counties have a hash for the file pre-redaction apparently
• Out of 62 CO counties, H and M and returns agree on 35. But here are 26 where they don't match with returns. Often H and M disagree in their "errors". In Pitkin, El Paso, Jefferson, Larimer, Douglas, etc., the sign of the error is the opposite: e.g. H undershoots (negative numbers below) but M overshoots. So that's likely a place where one team can fix

class_harvard	class_medsl	county_name	diff_harvard	diff_medsl
0 difference	any < 5% mismatch	DOLORES	0	3
0 difference	red	ROUTT	0	-11052
any < 1% mismatch	any < 1% mismatch	GRAND	-1	-1
any < 1% mismatch	any < 1% mismatch	PARK	-1	-1
any < 1% mismatch	any < 1% mismatch	CLEAR CREEK	-2	-2
any < 1% mismatch	any < 1% mismatch	CUSTER	-4	-4
any < 1% mismatch	0 difference	LA PLATA	-4	0
any < 1% mismatch	any < 1% mismatch	RIO BLANCO	-4	-4
any < 1% mismatch	any < 1% mismatch	MORGAN	-5	-5
any < 1% mismatch	red	MESA	-9	-9
any < 1% mismatch	red	EAGLE	-10	-11044
any < 1% mismatch	any < 1% mismatch	ARAPAHOE	-15	-15
any < 1% mismatch	any < 1% mismatch	ADAMS	-16	-16
any < 1% mismatch	any < 1% mismatch	LOGAN	-21	-21
any < 1% mismatch	any < 5% mismatch	PITKIN	-22	47
any < 1% mismatch	any < 5% mismatch	EL PASO	-35	97
any < 1% mismatch	red	JEFFERSON	-35	76
any < 1% mismatch	any < 1% mismatch	WELD	-36	-36
any < 1% mismatch	any < 1% mismatch	PUEBLO	-46	-46
any < 1% mismatch	any < 1% mismatch	LARIMER	-55	2
any < 1% mismatch	any < 5% mismatch	DOUGLAS	-56	112
any < 1% mismatch	any < 10% mismatch	DENVER	-170	-24968
any < 5% mismatch	any < 5% mismatch	SUMMIT	-166	-166
any < 5% mismatch	any < 5% mismatch	BOULDER	-2600	-2600
any < 10% mismatch	any < 10% mismatch	JACKSON	-3	-3
red	red	LAS ANIMAS	-7843	-7843

Slides with an example

[kuriwaki]

Another overview of Colorado:

There are 64 counties in CO. Harvard has collected 62, and MEDSL has collected 61.

• Missing in MEDSL but in Harvard: GARFIELD (https://votedatabase.com/cvr/Colorado/Garfield/)
• Missing in both MEDSL and Harvard: BACA (a csv is in votedatabase, not sure why neither team has collected it) and SAN JUAN (not in votedatabase)
• In votedatabase but not assigned to a county: Roosevelt (this is in NM; it is duplicated in the NM site) and Monroe (this is in IL, it is duplicated in the IL site)
• Watch out for Arapahoe -- the cvr_ids seem messed up #119

[kuriwaki]

@canemutlu Perhaps you can go through https://votedatabase.com/cvr/Colorado/ and list which counties (in my first table) have the word "redacted" in their filename. If they do, the small negative discrepancies are likely due to privacy redaction.

For the counties that do not have "redacted", that suggests we need to dig deeper.