CVR2_REGISTRATION_CD

Additional names provided on lobbying-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 112,353 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 13 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.


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) (72), .CAL Format Layout (Version 2.01) (87)

FORM_TYPE   String (up to 10) · Unique

Name of the source filing form or schedule

Code Definition
F601 Form 601: Lobbying Firm Registration Statement
F602 Form 602: Lobbying Firm Activity Authorization
F603 Form 603: Lobbyist Employer or Lobbying Coalition Registration Statement
Sources: .CAL Format Layout (Version 1.05.02) (72), .CAL Format Layout (Version 2.01) (87)

TRAN_ID   String (up to 20)

Permanent value unique to this item


ENTITY_CD   String (up to 3)

Entity code of the entity described by the record

Code Definition
AGY State Agency
EMP Employer
FRM Lobbying Firm
LBY Lobbyist (an individual)
MBR Member of Associaton
SCL Subcontracted Client
Sources: .CAL Format Layout (Version 1.05.02) (72), .CAL Format Layout (Version 2.01) (87)

ENTITY_ID   String (up to 9)

Identification number of the entity described by the record


ENTY_NAML   String (up to 200)

Entity last name


ENTY_NAMF   String (up to 45)

Entity first name


ENTY_NAMT   String (up to 10)

Entity title or suffix


ENTY_NAMS   String (up to 10)

Entity suffix


Forms

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





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

Archive

Download previous versions of this file from our archive.

Last 10 downloads

Date Records
Oct. 17, 2017 112,353 Download »
Oct. 16, 2017 112,353 Download »
Oct. 15, 2017 112,353 Download »
Oct. 14, 2017 112,353 Download »
Oct. 13, 2017 112,297 Download »
Oct. 12, 2017 112,287 Download »
Oct. 11, 2017 112,276 Download »
Oct. 10, 2017 112,270 Download »
Oct. 9, 2017 112,269 Download »
Oct. 8, 2017 112,269 Download »
More past downloads »

References

The documents that provided the information on this page.

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

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

  • .CAL Format Layout (Version 1.05.02) (p. 72-73)

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