CVR_REGISTRATION_CD

The cover page of 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 51,593 rows of data published on Tuesday, Oct. 17, 2017*.

Download latest   18M CSV

Alternatively, retrieve with curl.

Or, explore past downloads of this file.

Sample

A few sample rows.

Fields

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


A_B_CITY   String (up to 30)

Individual or business entity city


A_B_NAME   String (up to 200)

Name of individual or business entity


A_B_ST   String (up to 2)

Individual or business entity state


A_B_ZIP4   String (up to 10)

Individual or business entity ZIP Code.


AMEND_ID   Integer · Unique

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


AUTH_CITY   String (up to 30)

Authorized lobbying firm business address city


AUTH_NAME   String (up to 200)

Authorized lobbying firm business name. Applies to Form 602.


AUTH_ST   String (up to 2)

Authorized lobbying firm business address state


AUTH_ZIP4   String (up to 10)

Authorized lobbying firm business address ZIP Code


BUS_CB   String (up to 1)

Business included activity checkbox


BUS_CITY   String (up to 30)

Filer business address city


BUS_CLASS   String (up to 3)

Classifiction values of business related entities. This field is exclusive of the business class field. One these must be populated but not both.

Code Definition
ENT Entertainment/Recreation
FIN Finance/Insurance
LOG Lodging/Restaurants
MAN Manufacturing/Industrial
MER Merchandise/Retail
OIL Oil and Gas
OTH Other
PRO Professional/Trade
REA Real Estate
TRN Transportation
Sources: .CAL Format Layout (Version 1.05.02) (70), .CAL Format Layout (Version 2.01) (82)

BUS_DESCR   String (up to 100)

Description of business classification if coded as other


BUS_EMAIL   String (up to 60)

Filer business address email


BUS_FAX   String (up to 20)

Filer business address fax number


BUS_PHON   String (up to 20)

Filer business address phone number


BUS_ST   String (up to 2)

Filer business address state


BUS_ZIP4   String (up to 10)

Filer business address ZIP Code


C_LESS50   String (up to 1)

Industry associations with fewer than 50 members check this box


C_MORE50   String (up to 1)

Industry associations with more than 50 check this box.


COMPLET_DT   Date (without time)

Ethics orientation class completion date. Applies to Form 604. As filed by the lobbyist.


DESCRIP_1   String (up to 300)

Description of business activity, industry or other


DESCRIP_2   String (up to 300)

Description of specific or other lobbying interest


EFF_DATE   Date (without time)

Effective date of authoarization or termination


ENTITY_CD   String (up to 3)

Entity Code describing the filer

Code Definition
BUS Unknown
FRM Lobbying Firm
LBY Lobbyist (an individual)
LCO Lobbying Coalition
LEM Lobbying Employer
Sources: .CAL Format Layout (Version 1.05.02) (68), .CAL Format Layout (Version 2.01) (82)

FILER_ID   String (up to 9)

Filer's unique identification number


FILER_NAMF   String (up to 45)

Filer first name


FILER_NAML   String (up to 200)

Filer last name


FILER_NAMS   String (up to 10)

Filer suffix


FILER_NAMT   String (up to 10)

Filer title or prefix


FILING_ID   Integer · Unique

Unique filing identification number


FIRM_NAME   String (up to 200)

Name of the lobbyist employer or firm. Applies to Forms 604, 606, 607.


FORM_TYPE   String (up to 4) · 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
F604 Form 604: Lobbyist Certification Statement
F606 Form 606: Notice of Termination
F607 Form 607: Notice of Withdrawal
Sources: .CAL Format Layout (Version 1.05.02) (68), .CAL Format Layout (Version 2.01) (82)

IND_CB   String (up to 1)

Individual checkbox


IND_CLASS   String (up to 3)

Classification values to category industry related entities. This field is exclusive of the business class field. One these must be populated but not both.

Code Definition
AGR Agriculture
EDU Education
GOV Government
HEA Health
LAB Labor Unions
LEG Legal
OTH Other
POL Political Organizations
PUB Public Employees
UTL Utilities
Sources: .CAL Format Layout (Version 1.05.02) (70), .CAL Format Layout (Version 2.01) (85)

IND_DESCR   String (up to 100)

Description of industry classification if coded as other


INFLUEN_YN   String (up to 1)

Attempt to influence state legislation

Code Definition
Y Yes
y Yes
N No
n No
X Yes
Sources: .CAL Format Layout (Version 1.05.02) (71), .CAL Format Layout (Version 2.01) (86)

L_FIRM_CB   String (up to 1)

'Lobbying firm within the ... ' checkbox. Applies to Form 607.


LBY_604_CB   String (up to 1)

'Lobbying Agency in this 604 statement' checkbox. Applies to Form 604.


LBY_REG_CB   String (up to 1)

'Lobbying Agency in form 601/603 registration statement' checkbox. Applies to Form 604.


LOBBY_CB   String (up to 1)

'Lobbying within the meaning...' checkbox. Applies to Form 607.


LOBBY_INT   String (up to 300)

Description of Part III lobbying interests. Applies to Form 603


LS_BEG_YR   String (up to 5)

Year legislative session begins


LS_END_YR   String (up to 5)

Year legislative sessions ends


MAIL_CITY   String (up to 30)

Filer mailing address city


MAIL_PHON   String (up to 20)

Filer mailing address phone number


MAIL_ST   String (up to 2)

Filer mailing address state


MAIL_ZIP4   String (up to 10)

Filer mailing address ZIP Code


NEWCERT_CB   String (up to 1)

Will require a new certification checkbox. Applies to Form 604.


OTH_CB   String (up to 1)

Other checkbox


PRN_NAMF   String (up to 45)

Signer first name


PRN_NAML   String (up to 200)

Signer last name


PRN_NAMS   String (up to 10)

Signer suffix


PRN_NAMT   String (up to 10)

Signer title or prefix


QUAL_DATE   Date (without time)

Date qualified. Applies to forms 601 and 603. Only occurs once in lobbying filings.


REC_TYPE   String (up to 4) · Unique

Record Type Value: CVR

Code Definition
CVR CVR
Sources: .CAL Format Layout (Version 1.05.02) (68), .CAL Format Layout (Version 2.01) (82)

RENCERT_CB   String (up to 1)

Will take a renewel certification checkbox. Applies to Form 604.


REPORT_NUM   String (up to 3)

Amendment number as reported by the filer. 000 is the original. 001-999 are amendments.


RPT_DATE   Date (without time)

Date this report or amendment is filed, as reported by the filer


SENDER_ID   String (up to 9)

Identification number of the lobbyist entity submitting this report. This is equal to the filer ID if the filer is the submitting the report and the firm or employer if they are submitting the report.


SIG_DATE   Date (without time)

Date signed


SIG_LOC   String (up to 45)

Signer city and state


SIG_NAMF   String (up to 45)

Signer first name


SIG_NAML   String (up to 200)

Signer last name


SIG_NAMS   String (up to 10)

Signer suffix


SIG_NAMT   String (up to 10)

Signer title or prefix


SIG_TITLE   String (up to 45)

Title of signer


ST_AGENCY   String (up to 100)

List of identified state agencies. Applies to Form 604.


ST_LEG_YN   String (up to 1)

Will lobby state legislature checkbox. Applies to Form 604.

Code Definition
Y Yes
y Yes
N No
n No
X Yes
x Yes
Sources: .CAL Format Layout (Version 1.05.02) (71), .CAL Format Layout (Version 2.01) (86)

STMT_FIRM   String (up to 90)

Lobby firm named in 'Statement of Responsible Officer'This field only applies to Form 601.


TRADE_CB   String (up to 1)

Industry, trade or professional checkbox


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 1 records out of 51,594 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 51,593 Download »
Oct. 16, 2017 51,593 Download »
Oct. 15, 2017 51,593 Download »
Oct. 14, 2017 51,593 Download »
Oct. 13, 2017 51,582 Download »
Oct. 12, 2017 51,577 Download »
Oct. 11, 2017 51,570 Download »
Oct. 10, 2017 51,565 Download »
Oct. 9, 2017 51,564 Download »
Oct. 8, 2017 51,564 Download »
More past downloads »

References

The documents that provided the information on this page.

  • .CAL Format Layout (Version 2.01) (p. 82-86)

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

  • .CAL Format Layout (Version 1.05.02) (p. 68-71)

  • CAL-ACCESS Tables, Columns and Indexes (p. 8, 35-39)