LOBBY_AMENDMENTS_CD

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

Download latest   2M CSV

Alternatively, retrieve with curl.

Or, explore past downloads of this file.

Sample

A few sample rows.

Fields

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


Forms

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




Archive

Download previous versions of this file from our archive.

Last 10 downloads

Date Records
April 17, 2019 14,848 Download »
April 16, 2019 14,839 Download »
April 15, 2019 14,831 Download »
April 14, 2019 14,831 Download »
April 13, 2019 14,831 Download »
April 12, 2019 14,823 Download »
April 11, 2019 14,818 Download »
April 9, 2019 14,804 Download »
April 8, 2019 14,797 Download »
April 7, 2019 14,794 Download »
More past downloads »

References

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)