Alabama 2000 race_id 807 duplicates and divided percentages.

[bengowan]

Hello 538!

In election_results_presidential.csv there appears to be duplicate listings of all candidates in race 807 for Alabama in 2000.
The duplicate entries all appear to be half of the actual precentage results per candidate, i.e. Al Gore received ~41.5% but has 2 listings for ~20.75%, but it does shows the correct number of votes. (I suspect the % is calculated from the sum of the duplicated total votes).

election_results_presidential |> filter(race_id == 807) |> arrange(candidate_id) |> select(id:percent) |> knitr::kable()

id	race_id	state_abbrev	state	office_id	office_name	office_seat_name	cycle	stage	special	party	politician_id	candidate_id	candidate_name	ballot_party	votes	percent
2	807	AL	Alabama	1	U.S. President	NA	2000	general	FALSE	NA	55	222	Al Gore	DEM	692611	20.7832515
9	807	AL	Alabama	1	U.S. President	NA	2000	general	FALSE	NA	55	222	Al Gore	DEM	692611	20.7832515
11	807	AL	Alabama	1	U.S. President	NA	2000	general	FALSE	NA	176	230	Patrick J. Buchanan	IND	6351	0.1905751
4	807	AL	Alabama	1	U.S. President	NA	2000	general	FALSE	NA	176	230	Patrick J. Buchanan	IND	6351	0.1905751
3	807	AL	Alabama	1	U.S. President	NA	2000	general	FALSE	NA	38	240	Ralph Nader	IND	18323	0.5498202
10	807	AL	Alabama	1	U.S. President	NA	2000	general	FALSE	NA	38	240	Ralph Nader	IND	18323	0.5498202
1	807	AL	Alabama	1	U.S. President	NA	2000	general	FALSE	NA	26	241	George W. Bush	REP	941173	28.2418777
15	807	AL	Alabama	1	U.S. President	NA	2000	general	FALSE	NA	26	241	George W. Bush	REP	941173	28.2418777
5	807	AL	Alabama	1	U.S. President	NA	2000	general	FALSE	NA	185	243	Harry Browne	LIB	5893	0.1768319
14	807	AL	Alabama	1	U.S. President	NA	2000	general	FALSE	NA	185	243	Harry Browne	LIB	5893	0.1768319
12	807	AL	Alabama	1	U.S. President	NA	2000	general	FALSE	NA	186	244	Howard Phillips	IND	775	0.0232555
6	807	AL	Alabama	1	U.S. President	NA	2000	general	FALSE	NA	186	244	Howard Phillips	IND	775	0.0232555
13	807	AL	Alabama	1	U.S. President	NA	2000	general	FALSE	NA	187	245	John Hagelin	IND	447	0.0134132
8	807	AL	Alabama	1	U.S. President	NA	2000	general	FALSE	NA	187	245	John Hagelin	IND	447	0.0134132
16	807	AL	Alabama	1	U.S. President	NA	2000	general	FALSE	NA	NA	NA	NA	NA	699	0.0209750
7	807	AL	Alabama	1	U.S. President	NA	2000	general	FALSE	NA	NA	NA	NA	NA	699	0.0209750

Compared topline candidates to https://en.wikipedia.org/wiki/2000_United_States_presidential_election_in_Alabama (which is slightly different than the in-file source).

Cheers,
Ben