LEMP_CD

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 345,160 rows of data published on Tuesday, Sept. 18, 2018*.

Download latest   85M 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.


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
LEMP LEMP
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


Forms

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


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

Archive

Download previous versions of this file from our archive.

Last 10 downloads

Date Records
Sept. 18, 2018 345,160 Download »
Sept. 17, 2018 344,907 Download »
Sept. 16, 2018 344,907 Download »
Sept. 15, 2018 344,907 Download »
Sept. 14, 2018 344,885 Download »
Sept. 13, 2018 344,819 Download »
Sept. 12, 2018 344,819 Download »
Sept. 11, 2018 344,819 Download »
Sept. 10, 2018 344,813 Download »
Sept. 9, 2018 344,813 Download »
More past downloads »

References

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)