CVR2_LOBBY_DISCLOSURE_CD

Extra information from the cover sheets of lobbyist-disclosure form.

Latest download

The most recent release from CAL-ACCESS, the database that tracks campaign finance and lobbying activity in California politics. It contains 111,069 rows of data published on Tuesday, Oct. 17, 2017.

Download latest   6M CSV

Alternatively, retrieve with curl.

Or, explore past downloads of this file.

Sample

A few sample rows.

Fields

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


AMEND_ID   Integer · Unique

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


ENTITY_CD   String (up to 3)

Entity code of the entity described by the record

Code Definition
EMP Employer
OFF Officer
OWN Owner
PTN Partner
Sources: .CAL Format Layout (Version 1.05.02) (57), .CAL Format Layout (Version 2.01) (71)

ENTITY_ID   String (up to 9)

Entity identification number


ENTY_NAMF   String (up to 45)

Entity first name


ENTY_NAML   String (up to 200)

Entity last name or business name


ENTY_NAMS   String (up to 10)

Entity suffix


ENTY_NAMT   String (up to 10)

Entity title or prefix


ENTY_TITLE   String (up to 45)

Title of partner, owner, officer, employer if the entity is an individual. Only required by Form 635.


FILING_ID   Integer · Unique

Unique filing identification number


FORM_TYPE   String (up to 4) · Unique

Name of the source filing form or schedule

Code Definition
F625 Form 625: Report of Lobbying Firm
F635 Form 635: Report of Lobbyist Employer or Report of Lobbying Coalition
Sources: .CAL Format Layout (Version 1.05.02) (57), .CAL Format Layout (Version 2.01) (71)

LINE_ITEM   Integer · Unique

Line item number of this record


REC_TYPE   String (up to 4) · Unique

Record Type Value: CVR2

Code Definition
CVR2 CVR2
Sources: .CAL Format Layout (Version 1.05.02) (57), .CAL Format Layout (Version 2.01) (71)

TRAN_ID   String (up to 20)

Permanent value unique to this item


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
Oct. 17, 2017 111,069 Download »
Oct. 16, 2017 111,020 Download »
Oct. 15, 2017 111,019 Download »
Oct. 14, 2017 111,009 Download »
Oct. 13, 2017 110,988 Download »
Oct. 12, 2017 110,960 Download »
Oct. 11, 2017 110,950 Download »
Oct. 10, 2017 110,928 Download »
Oct. 9, 2017 110,901 Download »
Oct. 8, 2017 110,900 Download »
More past downloads »

References

The documents that provided the information on this page.

  • .CAL Format Layout (Version 2.01) (p. 71)

  • Map from .CAL Format to Database Table and Fields (p. 36)

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

  • CAL-ACCESS Tables, Columns and Indexes (p. 8, 43-44)