datamade / illinois-sunshine

:sunny: Illinois Sunshine. Keep an eye on money in Illinois politics.
http://illinoissunshine.org/
MIT License
3 stars 1 forks source link

Rolling list of data problems #2

Open evz opened 8 years ago

evz commented 8 years ago

Originally created by evz on 2015-06-04T14:57:05Z

It would seem that there are a few issues with the data so far:

Lets keep updating this as the issues crop up. Perhaps we can report them back to the IL Board of Elections eventually.

evz commented 8 years ago

Originally posted by evz on 2015-06-26T15:56:12Z

Ed Burke did not magically received and spend $17,000,000 in 1996. It seems more plausible that this is the correct number: http://www.elections.il.gov/CampaignDisclosure/D2Semi.aspx?id=113261 and this one is not correct: http://www.elections.il.gov/CampaignDisclosure/D2Pre.aspx?id=117466 Note the extra digit.

evz commented 8 years ago

Originally posted by evz on 2015-07-19T14:46:13Z

It would seem that there are things that go missing from the data. It seems that at some point since we started updating every day, there are a few candidates that went missing from the candidates data:

http://elections.il.gov/CampaignDisclosure/CandidateDetail.aspx?ID=2812 http://elections.il.gov/CampaignDisclosure/CandidateDetail.aspx?ID=3086

And these went missing from the committees data:

http://elections.il.gov/CampaignDisclosure/CommitteeDetail.aspx?id=21057 http://elections.il.gov/CampaignDisclosure/CommitteeDetail.aspx?id=15504

Related to #20

evz commented 8 years ago

Originally posted by derekeder on 2015-07-28T20:46:59Z

Let's keep track of the known data issues here: https://docs.google.com/spreadsheets/d/19yXMVn-hpO9mUrlnipLMnAEHm0kxVcqaegRPeYrtKSA/edit#gid=0

evz commented 8 years ago

Originally posted by evz on 2015-10-02T21:13:11Z

The candidate_position field in the committees table seems quite often wrong when it comes to opposing committees. This is different from when a committee makes an expense in support of or in opposition to a candidate (that's listed individually per expenditure). These are explicit links made between committees and candidates in a separate file that we get from ISBE.

Below are all of the committees that have a candidate_position of oppose and the names of the candidates they are supposedly opposing. As you can see, they just seem kinda wrong.

  id   |                             name                              |   first_name    |  last_name  | active 
-------+---------------------------------------------------------------+-----------------+-------------+--------
  5937 | The New 3rd Ward Democratic Org                               | Henry           | Tellis, Jr  | f
 17364 | Gary R Amato                                                  | Gary R          | Amato       | f
 21989 | The Dolton South Suburban Party                               | Ernesto E       | Mickens, Jr | f
  6503 | Comm To Elect Gary L Bramblett & Dale Hewitt                  | Gary L          | Bramblett   | f
  6503 | Comm To Elect Gary L Bramblett & Dale Hewitt                  | Dale L          | Hewitt      | f
 17235 | Committee to Re-Elect Paul F Farris                           | Paul F          | Farris      | f
 21876 | John Goss Campaign Fund                                       | John            | Goss        | f
 11702 | Citizens for Donald R Havis                                   | Donald R        | Havis       | f
 22131 | Citizens for Brian Henderson                                  | Brian           | Henderson   | f
  9179 | The Future Of Highwood Party                                  | John            | Sirotti     | f
  9179 | The Future Of Highwood Party                                  | Michael         | Lovering    | f
  9179 | The Future Of Highwood Party                                  | Ron             | Ori         | f
  9179 | The Future Of Highwood Party                                  | Sante           | Ori         | f
  9179 | The Future Of Highwood Party                                  | Jacqueline      | Schechter   | f
  9179 | The Future Of Highwood Party                                  | Thomas          | Scopelliti  | f
  9179 | The Future Of Highwood Party                                  | April M         | Powers      | f
  9179 | The Future Of Highwood Party                                  | Janice          | Mann        | f
 20037 | Friends for Larry Brown                                       | Larry           | Brown       | t
 20037 | Friends for Larry Brown                                       | Robert K        | Travis      | t
 20037 | Friends for Larry Brown                                       | Sheryl          | Holman      | t
 20037 | Friends for Larry Brown                                       | Oscar H         | Brown Jr    | t
 20037 | Friends for Larry Brown                                       | Larry           | Brown       | t
 21656 | United for Rudy Lozano Jr                                     | Rudy            | Lozano      | f
 21656 | United for Rudy Lozano Jr                                     | Rudy            | Lozano      | f
 17200 | Committee to Elect Pat McAllister                             | Pat             | McAllister  | f
 17337 | Citizens for Thomas T Morris                                  | Thomas T        | Morris      | f
 17337 | Citizens for Thomas T Morris                                  | Thomas T        | Morris      | f
 17337 | Citizens for Thomas T Morris                                  | Thomas T        | Morris      | f
  5916 | Sharon I Allison                                              | Sharon I        | Allison     | f
 30603 | Citizens for Better Government                                | Patti           | Meroni      | f
 30603 | Citizens for Better Government                                | Karen           | Selman      | f
 30603 | Citizens for Better Government                                | Mary            | Naumann     | f
  6191 | Russell Oxford For Sheriff                                    | Russell         | Oxford      | f
  9261 | Independent Palos Township Party                              | Beverly         | Lebloch     | f
  9261 | Independent Palos Township Party                              | Barbara S       | Eastman     | f
  9261 | Independent Palos Township Party                              | Leonard J       | Surdyk      | f
  9261 | Independent Palos Township Party                              | William B       | Williams    | f
  9261 | Independent Palos Township Party                              | Henry A         | Zwartz      | f
  9261 | Independent Palos Township Party                              | Dorothy E       | Tomes       | f
  9261 | Independent Palos Township Party                              | Diana           | Bezanis     | f
  9261 | Independent Palos Township Party                              | John E          | Griffin     | f
  9261 | Independent Palos Township Party                              | Andrew          | Cisarik     | f
 22971 | Committee to Defeat Judge Kathleen Pantle                     | Kathleen        | Pantle      | f
  6708 | Elect Bob D Pitchford                                         | Bob D           | Pitchford   | f
 21869 | Will County Progressive Political Action                      | Richard         | Rodriguez   | f
  6906 | Gordon Bush Campaign Committee                                | Gordon D        | Bush        | f
     8 | 38th Ward Regular Republican Organization                     | Roger P         | McAuliffe   | f
     8 | 38th Ward Regular Republican Organization                     | Roger P         | McAuliffe   | f
     8 | 38th Ward Regular Republican Organization                     | Fredrick A      | Rupley      | f
 17338 | Committee to Elect Vanessa Romeo                              | Vanessa         | Romeo       | f
 14577 | Citizens for Baikauskas                                       | Patrick         | Baikauskas  | f
  9455 | Unified Party Of Westmont                                     | Charles         | Matthei     | f
  9455 | Unified Party Of Westmont                                     | Caterina        | Varvaro     | f
  9455 | Unified Party Of Westmont                                     | Timothy C "Tim" | Debs        | f
  9455 | Unified Party Of Westmont                                     | Christopher     | Olson       | f
  9455 | Unified Party Of Westmont                                     | Debra           | Siwinski    | f
 16292 | Robert L Smith                                                | Robert L.       | Smith       | f
  7745 | Concerned Candidates Of Dist 205                              | William         | Hespel      | f
  7745 | Concerned Candidates Of Dist 205                              | John            | Bivins      | f
  7745 | Concerned Candidates Of Dist 205                              | George          | Robinson    | f
 20192 | Robert K Travis                                               | Robert K        | Travis      | f
 11194 | Peoples Unified Party                                         | David R         | O'Rear      | f
 11194 | Peoples Unified Party                                         | Reggie          | Mosley      | f
 11194 | Peoples Unified Party                                         | Jim             | Gustafson   | f
 21719 | Citizens for Varga                                            | Nancy L         | Varga       | f
 16148 | Citizens for Young                                            | John H          | Young       | f
 11713 | Comm To Elect Phillip "phil"carlson Kane County Circuit Clerk | Phillip "Phil"  | Carlson     | f
 12660 | Political Implement Management Pty                            | Larry           | Jackson     | f
 20490 | Friends for Mike Kurgan                                       | R Michael       | Kurgan      | f
 20490 | Friends for Mike Kurgan                                       | R Michael       | Kurgan      | f
 14835 | Earl L Ware                                                   | Earl            | Ware        | f
(71 rows)

We're not using this information anywhere on the site so it's not super urgent to figure out but it seems like something we may want to at least inquire about.