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

2014 Suffolk County general file has inconsistent number of columns

Open warwickmm opened this issue 3 years ago • 0 comments

2014/counties/20141104__ny__general__suffolk__precinct.csv has rows with an inconsistent number of columns:

Header ['county', 'precinct', 'office', 'district', 'party', 'candidate', 'votes'] has 7 entries, but there are 18290 rows with an inconsistent number of columns:

	Row 98383 (9 entries): ['Suffolk', 'Brookhaven #: 01', 'District Court Judge', '6th District', 'Town', '1', 'REP', 'Linda J Kevins', '182']
	Row 98384 (9 entries): ['Suffolk', 'Brookhaven #: 01', 'District Court Judge', '6th District', 'Town', '1', 'CON', 'Linda J Kevins', '46']
	Row 98385 (9 entries): ['Suffolk', 'Brookhaven #: 01', 'District Court Judge', '6th District', 'Town', '1', 'IND', 'Linda J Kevins', '13']
	Row 98386 (9 entries): ['Suffolk', 'Brookhaven #: 01', 'District Court Judge', '6th District', 'Town', '1', 'DEM', 'Stephen L Ukeiley', '206']
	Row 98387 (9 entries): ['Suffolk', 'Brookhaven #: 01', 'District Court Judge', '6th District', 'Town', '1', 'WOR', 'Stephen L Ukeiley', '16']
	Row 98388 (9 entries): ['Suffolk', 'Brookhaven #: 01', 'District Court Judge', '6th District', 'Town', '1', '', 'Blank', '40']
	Row 98389 (9 entries): ['Suffolk', 'Brookhaven #: 02', 'District Court Judge', '6th District', 'Town', '1', 'REP', 'Linda J Kevins', '211']
	Row 98390 (9 entries): ['Suffolk', 'Brookhaven #: 02', 'District Court Judge', '6th District', 'Town', '1', 'CON', 'Linda J Kevins', '35']
	Row 98391 (9 entries): ['Suffolk', 'Brookhaven #: 02', 'District Court Judge', '6th District', 'Town', '1', 'IND', 'Linda J Kevins', '15']
	Row 98392 (9 entries): ['Suffolk', 'Brookhaven #: 02', 'District Court Judge', '6th District', 'Town', '1', 'DEM', 'Stephen L Ukeiley', '244']
	[Truncated to 10 examples]

warwickmm avatar Jun 25 '21 17:06 warwickmm