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

2016 Richmond County primary file has inconsistent number of columns

Open warwickmm opened this issue 3 years ago • 0 comments

2016/counties/20160913__ny__republican__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'] has 12 entries, but there are 132 rows with an inconsistent number of columns:

	Row 2 (11 entries): ['Richmond', '002/62', 'State Assembly', '62', 'Republican', 'Ronald Castorina Jr.', '53', '83', '0', '5', '0']
	Row 3 (11 entries): ['Richmond', '002/62', 'State Assembly', '62', 'Republican', 'Janine Materna', '35', '83', '0', '5', '0']
	Row 4 (11 entries): ['Richmond', '056/62', 'State Assembly', '62', 'Republican', 'Ronald Castorina Jr.', '24', '32', '0', '6', '0']
	Row 5 (11 entries): ['Richmond', '056/62', 'State Assembly', '62', 'Republican', 'Janine Materna', '12', '32', '0', '6', '0']
	Row 8 (11 entries): ['Richmond', '021/62', 'State Assembly', '62', 'Republican', 'Ronald Castorina Jr.', '32', '49', '0', '2', '0']
	Row 9 (11 entries): ['Richmond', '021/62', 'State Assembly', '62', 'Republican', 'Janine Materna', '19', '49', '0', '2', '0']
	Row 10 (11 entries): ['Richmond', '019/62', 'State Assembly', '62', 'Republican', 'Ronald Castorina Jr.', '52', '65', '0', '4', '0']
	Row 11 (11 entries): ['Richmond', '019/62', 'State Assembly', '62', 'Republican', 'Janine Materna', '17', '65', '0', '4', '0']
	Row 12 (11 entries): ['Richmond', '037/62', 'State Assembly', '62', 'Republican', 'Ronald Castorina Jr.', '50', '77', '0', '5', '0']
	Row 13 (11 entries): ['Richmond', '037/62', 'State Assembly', '62', 'Republican', 'Janine Materna', '31', '77', '0', '5', '0']
	[Truncated to 10 examples]

warwickmm avatar Jun 25 '21 17:06 warwickmm