Questions for Kari

[jeancochrane]

• Any automated data on races/winners?
• Current table refresh (missing Debenedditis loan, Nate Gentry as a candidate)
• Need update ASAP after the Feb 6 filing deadline (esp for candidates)
• Can we get lobbyist data as part of the refresh?
  • Plus: can we get refreshes on the LobbyistRegistration and Organization tables too, in case new lobbyists register? Or is it impossible to have new lobbyists?
• Natalie Figueroa has a district ID of 62 for her 2016 campaign, which contrasts with her opponent Nate Gentry's district ID (107). The district with the ID 62 appears to correspond to the right geographic area, District 30, but for the wrong office (State Senator).
• Independent Expenditures -- what does it look like? How much extra work?
• Two Susan Herreras, one with no contributions and the other with the wrong "District" value for her campaign: https://opennessproject.com/search/?term=susan+herrera&table_name=candidate&table_name=pac&table_name=contribution&table_name=expenditure&table_name=lobbyist&table_name=organization

[jeancochrane]

Additional question:

Currently, when looking at a lobbyist's contributions, there isn't a column that says on whose behalf the contribution was made. Unfortunately, there isn't a way to do this with the data we have. Contributions and expenditures are stored in the same table, so there's potential for the SOS to store contributions in the same way they store expenditures, but so far in the tables we've received for political contributions never have any value for this column (called "beneficiary" in the table camp_fin_lobbyisttransaction). I'm not sure why this data is missing, since it's stored in the lobbyist reports! On page 5 of Stephen Perry's January 2016 filing you can see that he donated $2,500 to William Burt on behalf of Chevron; in our data, however, that field is missing, as it is for all contributions:

  id   |     name     | beneficiary | expenditure_purpose |     received_date      | amount |          date_added           |
-------+--------------+-------------+---------------------+------------------------+--------+-------------------------------+
 17526 | William Burt |             |                     | 2015-10-29 02:00:00-04 |   2500 | 2016-01-06 02:00:00-05        |