LOBBYING_CHG_LOG_CD
Log of lobbyist filings compiled for display on the state website.
Latest download
The most recent release from CAL-ACCESS, the database that tracks campaign finance and lobbying activity in California politics. It contains 74,578 rows of data published on Friday, Dec. 25, 2020*.
Download latest 11M CSV
Alternatively, retrieve with curl
.
Sample
A few sample rows.
Fields
Information about the 25 fields and the definitions of any abbreviated values.
Filer's unique identification number
Number of changes this session
Legislative session identification number
This field is undocumented
Foreign key referencing FilerTypesCd.filer_type
This field is undocumented
This field is undocumented
This field is undocumented
This field is undocumented
This field is undocumented
Full name of filer
City address of filer
State address of filer
ZIP Code of filer
Phone number of filer
This field is undocumented. The values might refer to either FILER_TYPES_CD.FILER_TYPE or GROUP_TYPES_CD.GRP_ID, but that's just a guess.
Code | Definition |
---|---|
0 |
n/a |
1 |
Client |
2 |
Employer |
3 |
Firm |
4 |
Lobbyist |
10 |
Major Donor |
16 |
Recipient Committee |
20 |
Treasurer/Responsible Officer |
This field is undocumented
This field is undocumented
This field is undocumented
This field is undocumented
Entity phone number
Entity identification number
This field is undocumented
This field is undocumented
Errata
The raw data provided by the state contains errors in how some values are escaped, quoted and delimited. The result is a small number of records in the latest download were lost when we prepared files for download.
However, only 14 records out of 74,592 total rows were lost (you can download them here).
Archive
Download previous versions of this file from our archive.
Last 10 downloads
Date | Records | ||
---|---|---|---|
Dec. 25, 2020 | 74,578 | Download » | |
Dec. 24, 2020 | 74,578 | Download » | |
Dec. 13, 2020 | 74,546 | Download » | |
Dec. 12, 2020 | 74,546 | Download » | |
Dec. 11, 2020 | 74,546 | Download » | |
Dec. 10, 2020 | 74,540 | Download » | |
Dec. 9, 2020 | 74,539 | Download » | |
Dec. 8, 2020 | 74,539 | Download » | |
Dec. 7, 2020 | 74,529 | Download » | |
Dec. 6, 2020 | 74,529 | Download » | |
More past downloads » |
References
The documents that provided the information on this page.