openelections-data-ny
openelections-data-ny copied to clipboard
2014 Suffolk County general file has inconsistent number of columns
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]