Amendments to lobbyist-registration forms.

Latest download

The most recent release from CAL-ACCESS, the database that tracks campaign finance and lobbying activity in California politics. It contains 17,742 rows of data published on Sunday, June 20, 2021.

Download latest   3M CSV

Alternatively, retrieve with curl.

Or, explore past downloads of this file.


A few sample rows.


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

FILING_ID   Integer · Unique

Unique filing identification number

AMEND_ID   Integer · Unique

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

REC_TYPE   String (up to 4) · Unique

Record Type Value: F605

Code Definition
F605 F605
Sources: .CAL Format Layout (Version 1.05.02) (74), .CAL Format Layout (Version 2.01) (88)

FORM_TYPE   String (up to 9) · Unique

Name of the source filing form or schedule

Code Definition
Form 601: Lobbying Firm Registration Statement
Form 603: Lobbyist Employer or Lobbying Coalition Registration Statement
Sources: .CAL Format Layout (Version 1.05.02) (74), .CAL Format Layout (Version 2.01) (88)

EXEC_DATE   Date (without time)

Date this amendment executed on

FROM_DATE   Date (without time)

Reporting period from date of original report

THRU_DATE   Date (without time)

Reporting date to/through date of original

ADD_L_CB   String (up to 1)

Add lobbyist checkbox

ADD_L_EFF   Date (without time)

Add lobbyist effective date

A_L_NAML   String (up to 200)

Add lobbyist last name

A_L_NAMF   String (up to 45)

Add lobbyist first name

A_L_NAMT   String (up to 10)

Add lobbyist title or prefix

A_L_NAMS   String (up to 10)

Add lobbyist suffix

DEL_L_CB   String (up to 8)

Delete lobbyist checkbox

DEL_L_EFF   String (up to 22)

Delete lobbyist effective date

D_L_NAML   String (up to 200)

Delete lobbyist last name

D_L_NAMF   String (up to 45)

Delete lobbyist first name

D_L_NAMT   String (up to 10)

Delete lobbyist title or prefix

D_L_NAMS   String (up to 10)

Delete lobbyiest suffix

ADD_LE_CB   String (up to 1)

Add lobbyiest employer checkbox

ADD_LE_EFF   Date (without time)

Add lobbyist employer effective date

A_LE_NAML   String (up to 200)

Add lobbyist employer last name

A_LE_NAMF   String (up to 45)

Add lobbyist or employer first name

A_LE_NAMT   String (up to 10)

Add lobbyist employer title or prefix

A_LE_NAMS   String (up to 10)

Add lobbyist employer suffix

DEL_LE_CB   String (up to 9)

Delete lobbyist employer check box

DEL_LE_EFF   String (up to 22)

Delete lobbyist employer effective date

D_LE_NAML   String (up to 200)

Delete lobbyist employer last name

D_LE_NAMF   String (up to 45)

Delete lobbyiest employer first name

D_LE_NAMT   String (up to 12)

Delete lobbyist employer name title or prefix

D_LE_NAMS   String (up to 10)

Delete lobbyist employer name

ADD_LF_CB   String (up to 1)

Add lobbying firm checkbox

ADD_LF_EFF   Date (without time)

Add lobbying firm effective date

A_LF_NAME   String (up to 200)

Add lobbying firm name

DEL_LF_CB   String (up to 1)

Delete lobbying firm checkbox

DEL_LF_EFF   Date (without time)

Delete lobbying firm effective date

D_LF_NAME   String (up to 200)

Delete lobbying firm name

OTHER_CB   String (up to 1)

Other amendments checkbox

OTHER_EFF   Date (without time)

Other amendments effective date

OTHER_DESC   String (up to 100)

Description of changes

F606_YES   String (up to 1)

Lobbyist ceasing all activity

F606_NO   String (up to 1)

Lobbyist ceasing employment but staying active


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


Download previous versions of this file from our archive.

Last 10 downloads

Date Records
June 20, 2021 17,742 Download »
June 19, 2021 17,739 Download »
June 18, 2021 17,739 Download »
June 17, 2021 17,739 Download »
June 16, 2021 17,736 Download »
June 15, 2021 17,728 Download »
June 14, 2021 17,724 Download »
June 13, 2021 17,724 Download »
June 12, 2021 17,720 Download »
June 11, 2021 17,718 Download »
More past downloads »


The documents that provided the information on this page.

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

  • Map from .CAL Format to Database Table and Fields (p. 64-66)

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

  • .CAL Format Layout (Version 2.01) (p. 88-89)