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 0 rows of data published on Friday, July 30, 2021.

Download unavailable

Or, explore past downloads of this file.

Fields

Information about the 25 fields and the definitions of any abbreviated values.


FILER_ID   Integer · Unique

Filer's unique identification number


CHANGE_NO   Integer · Unique

Number of changes this session


SESSION_ID   Integer

Legislative session identification number


LOG_DT   Date (without time)

This field is undocumented


FILER_TYPE   Integer

Foreign key referencing FilerTypesCd.filer_type


CORRECTION_FLG   String (up to 200)

This field is undocumented


ACTION   String (up to 200)

This field is undocumented


ATTRIBUTE_CHANGED   String (up to 200)

This field is undocumented


ETHICS_DT   Date (without time)

This field is undocumented


INTERESTS   String (up to 200)

This field is undocumented


FILER_FULL_NAME   String (up to 200)

Full name of filer


FILER_CITY   String (up to 200)

City address of filer


FILER_ST   String (up to 200)

State address of filer


FILER_ZIP   Integer

ZIP Code of filer


FILER_PHONE   String (up to 12)

Phone number of filer


ENTITY_TYPE   Integer

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

ENTITY_NAME   String (up to 500)

This field is undocumented


ENTITY_CITY   String (up to 500)

This field is undocumented


ENTITY_ST   String (up to 500)

This field is undocumented


ENTITY_ZIP   String (up to 10)

This field is undocumented


ENTITY_PHONE   String (up to 12)

Entity phone number


ENTITY_ID   Integer

Entity identification number


RESPONSIBLE_OFFICER   String (up to 500)

This field is undocumented


EFFECT_DT   Date (without time)

This field is undocumented


Archive

Download previous versions of this file from our archive.

Last 10 downloads

Date Records
July 30, 2021 Unavailable
July 25, 2021 75,684 Download »
July 22, 2021 75,653 Download »
July 18, 2021 75,637 Download »
July 17, 2021 75,637 Download »
July 16, 2021 75,633 Download »
July 15, 2021 75,621 Download »
July 14, 2021 75,614 Download »
July 12, 2021 75,596 Download »
July 11, 2021 75,596 Download »
More past downloads »

References

The documents that provided the information on this page.

  • CAL-ACCESS Tables, Columns and Indexes (p. 10, 91-92)