Lobbyist employers and subcontracted clients.

Latest download

The most recent release from CAL-ACCESS, the database that tracks campaign finance and lobbying activity in California politics. It contains 380,103 rows of data published on Sunday, Sept. 22, 2019*.

Download latest   93M CSV

Alternatively, retrieve with curl.

Or, explore past downloads of this file.


A few sample rows.


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

AGENCYLIST   String (up to 200)

Agencies to be lobbied

AMEND_ID   Integer · Unique

Amendment identification number. A number of 0 is the original filing and 1 to 999 amendments.

CLI_CITY   String (up to 30)

Employing client city

CLI_NAMF   String (up to 45)

Employing client first name

CLI_NAML   String (up to 200)

Employing client last name

CLI_NAMS   String (up to 10)

Employing client suffix

CLI_NAMT   String (up to 10)

Employing client prefix or title

CLI_PHON   String (up to 20)

Employing client phone number

CLI_ST   String (up to 2)

Employing client state

CLI_ZIP4   String (up to 10)

Employing client ZIP Code

CLIENT_ID   String (up to 9)

Identification number of the Part 2A employer or Part 2B Client/Employer

CON_PERIOD   String (up to 30)

Period of the contract

DESCRIP   String (up to 100)

Description of employer/client lobbying interest

EFF_DATE   Date (without time)

Effective Date of Lobbying Contract

FILING_ID   Integer · Unique

Unique filing identification number

FORM_TYPE   String (up to 7) · Unique

Name of the source filing form or schedule

Code Definition
F601P2A Form 601 (Lobbying Firm Registration Statement): Part 2, Section A, Lobbyist Employers
F601P2B Form 601 (Lobbying Firm Registration Statement): Part 2, Section B, Subcontracted Clients
Sources: .CAL Format Layout (Version 1.05.02) (75), .CAL Format Layout (Version 2.01) (90)

LINE_ITEM   Integer · Unique

Line item number of this record

REC_TYPE   String (up to 4) · Unique

Record Type Value: LEMP

Code Definition
Sources: .CAL Format Layout (Version 1.05.02) (75), .CAL Format Layout (Version 2.01) (90)

SUB_CITY   String (up to 30)

Subcontracting lobbying firm city

SUB_NAME   String (up to 200)

Subcontracting lobbying firms name

SUB_PHON   String (up to 20)

Subcontracting lobbying firm phone number

SUB_ST   String (up to 2)

Subcontracting lobbying firm state

SUB_ZIP4   String (up to 10)

Subcontracting lobbying firm ZIP Code

SUBFIRM_ID   String (up to 9)

Identification number of subcontracting lobbying firm


The forms that the state uses to collect the information that populates this file.

Form 601: Lobbying Firm Registration Statement

Part 2, Section A, Lobbyist Employers

Part 2, Section B, Subcontracted Clients


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 142 records out of 380,245 total rows were lost (you can download them here).


Download previous versions of this file from our archive.

Last 10 downloads

Date Records
Sept. 22, 2019 380,103 Download »
Sept. 21, 2019 380,103 Download »
Sept. 20, 2019 380,075 Download »
Sept. 19, 2019 380,032 Download »
Sept. 18, 2019 379,688 Download »
Sept. 17, 2019 379,603 Download »
Sept. 16, 2019 379,463 Download »
Sept. 15, 2019 379,463 Download »
Sept. 14, 2019 379,416 Download »
Sept. 13, 2019 379,405 Download »
More past downloads »


The documents that provided the information on this page.

  • CAL-ACCESS Tables, Columns and Indexes (p. 10, 85-86)

  • Map from .CAL Format to Database Table and Fields (p. 56-57)

  • .CAL Format Layout (Version 1.05.02) (p. 75)

  • .CAL Format Layout (Version 2.01) (p. 90-91)