openelections/openelections-data-ny

2020 Bronx County general file has inconsistent number of columns

warwickmm opened this issue · 1 comments

2020/counties/20201103__ny__general__bronx__precinct.csv has rows with an inconsistent number of columns:

Header ['county', 'precinct', 'office', 'district', 'party', 'candidate', 'votes', 'public_counter_votes', 'emergency_votes', 'absentee_military_votes', 'federal_votes', 'affidavit_votes', 'manually_counted_emergency', 'special_presidential'] has 14 entries, but there are 15640 rows with an inconsistent number of columns:

	Row 2 (15 entries): ['Bronx', '1~77', 'President', '', 'Republican', 'Donald J. Trump / Michael R. Pence', '23', '178', '', '46', '0', '3', '1', '0', '0']
	Row 3 (15 entries): ['Bronx', '1~77', 'State Senate', '29', 'Democratic', 'Jose M. Serrano', '199', '178', '', '46', '0', '3', '1', '0', '0']
	Row 4 (15 entries): ['Bronx', '1~77', 'President', '', 'Green', 'Howie Hawkins / Angela Nicole Walker', '0', '178', '', '46', '0', '3', '1', '0', '0']
	Row 5 (15 entries): ['Bronx', '1~77', 'State Assembly', '77', 'Democratic', 'Latoya Joyner', '194', '178', '', '46', '0', '3', '1', '0', '0']
	Row 6 (15 entries): ['Bronx', '1~77', 'State Senate', '29', 'Republican', 'Jose A. Colon', '18', '178', '', '46', '0', '3', '1', '0', '0']
	Row 7 (15 entries): ['Bronx', '1~77', 'President', '', 'Independence', 'Brock Pierce / Karla Ballard', '0', '178', '', '46', '0', '3', '1', '0', '0']
	Row 8 (15 entries): ['Bronx', '1~77', 'State Assembly', '77', 'Conservative', 'Benjamin Eggleston', '4', '178', '', '46', '0', '3', '1', '0', '0']
	Row 9 (15 entries): ['Bronx', '1~77', 'President', '', 'Working Families', 'Joseph R. Biden / Kamala D. Harris', '3', '178', '', '46', '0', '3', '1', '0', '0']
	Row 10 (15 entries): ['Bronx', '1~77', 'President', '', 'Democratic', 'Joseph R. Biden / Kamala D. Harris', '196', '178', '', '46', '0', '3', '1', '0', '0']
	Row 11 (15 entries): ['Bronx', '1~77', 'State Assembly', '77', 'Republican', 'Tanya Carmichael', '18', '178', '', '46', '0', '3', '1', '0', '0']
	[Truncated to 10 examples]

There appears to be a larger issue with all the NYC counties. NYC provides ballot type counts at the precinct level, but not broken down by candidate. The files seem to copy these values for each candidate, which is incorrect.

See official data here