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 75,192 rows of data published on Thursday, April 22, 2021*.
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 75,206 total rows were lost (you can download them here).
Archive
Download previous versions of this file from our archive.
Last 10 downloads
Date | Records | ||
---|---|---|---|
April 22, 2021 | 75,192 | Download » | |
April 20, 2021 | 75,180 | Download » | |
April 19, 2021 | 75,180 | Download » | |
April 18, 2021 | 75,180 | Download » | |
April 17, 2021 | 75,180 | Download » | |
April 16, 2021 | 75,179 | Download » | |
April 15, 2021 | 75,179 | Download » | |
April 14, 2021 | 75,175 | Download » | |
April 13, 2021 | 75,173 | Download » | |
April 12, 2021 | 75,172 | Download » | |
More past downloads » |
References
The documents that provided the information on this page.