openelections-data-ny
openelections-data-ny copied to clipboard
2020 Richmond County primary file has inconsistent number of columns
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]