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 Richmond County primary file has inconsistent number of columns #106

Open
warwickmm opened this issue Jun 25, 2021 · 0 comments
Open

Comments

@warwickmm
Copy link
Member

warwickmm commented Jun 25, 2021

2020/counties/20200623__ny__primary__richmond__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 5894 rows with an inconsistent number of columns:

	Row 2 (15 entries): ['Richmond', '1~61', 'President', '', 'Green', 'Howie Hawkins / Angela Nicole Walker', '2', '651', '', '147', '0', '2', '2', '0', '']
	Row 3 (15 entries): ['Richmond', '1~61', 'State Senate', '23', 'Conservative', 'Justin DeFillippo', '43', '651', '', '147', '0', '2', '2', '0', '']
	Row 4 (15 entries): ['Richmond', '1~61', 'State Assembly', '61', 'Democratic', 'Charles D. Fall', '652', '651', '', '147', '0', '2', '2', '0', '']
	Row 5 (15 entries): ['Richmond', '1~61', 'President', '', 'Conservative', 'Donald J. Trump / Michael R. Pence', '12', '651', '', '147', '0', '2', '2', '0', '']
	Row 6 (15 entries): ['Richmond', '1~61', 'State Senate', '23', 'Independence', 'Diane J. Savino', '7', '651', '', '147', '0', '2', '2', '0', '']
	Row 7 (15 entries): ['Richmond', '1~61', 'President', '', 'Republican', 'Donald J. Trump / Michael R. Pence', '83', '651', '', '147', '0', '2', '2', '0', '']
	Row 8 (15 entries): ['Richmond', '1~61', 'U.S. House', '11', 'Democratic', 'Max N. Rose', '673', '651', '', '147', '0', '2', '2', '0', '']
	Row 9 (15 entries): ['Richmond', '1~61', 'State Senate', '23', 'SAM', 'John Jairo Rodriguez', '11', '651', '', '147', '0', '2', '2', '0', '']
	Row 10 (15 entries): ['Richmond', '1~61', 'State Assembly', '61', 'Independence', 'Charles D. Fall', '9', '651', '', '147', '0', '2', '2', '0', '']
	Row 11 (15 entries): ['Richmond', '1~61', 'President', '', 'Libertarian', 'Jo Jorgensen / Jeremy Cohen', '2', '651', '', '147', '0', '2', '2', '0', '']
	[Truncated to 10 examples]
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

1 participant