Alabama 2000 race_id 807 duplicates and divided percentages. #3
Description
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