openelections-data-ny icon indicating copy to clipboard operation
openelections-data-ny copied to clipboard

2020 Bronx County general file has inconsistent number of columns

Open warwickmm opened this issue 3 years ago • 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]

warwickmm avatar Jun 25 '21 17:06 warwickmm

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

afischer avatar Jan 17 '22 02:01 afischer