Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

2020 Bronx County general file has inconsistent number of columns #102

Open
warwickmm opened this issue Jun 25, 2021 · 1 comment
Open

Comments

@warwickmm
Copy link
Member

warwickmm commented Jun 25, 2021

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]
@afischer
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants