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 70,051 rows of data published on Wednesday, April 17, 2019.

Download latest   10M CSV

Alternatively, retrieve with curl.

Or, explore past downloads of this file.

Sample

A few sample rows.

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
April 17, 2019 70,051 Download »
April 16, 2019 69,988 Download »
April 15, 2019 69,935 Download »
April 14, 2019 69,935 Download »
April 13, 2019 69,883 Download »
April 12, 2019 69,868 Download »
April 11, 2019 69,865 Download »
April 9, 2019 69,769 Download »
April 8, 2019 69,717 Download »
April 7, 2019 69,717 Download »
More past downloads »

References

The documents that provided the information on this page.

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