CVR_LOBBY_DISCLOSURE_CD

The cover page of lobbying-disclosure forms.

Latest download

The most recent release from CAL-ACCESS, the database that tracks campaign finance and lobbying activity in California politics. It contains 325,228 rows of data published on Sunday, Dec. 10, 2017*.

Download latest   118M CSV

Alternatively, retrieve with curl.

Or, explore past downloads of this file.

Sample

A few sample rows.

Fields

Information about the 53 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.


CTRIB_N_CB   String (up to 1)

'Campaign contribtions? P4 attached' checkbox. Applies to forms 625, 635, 645.


CTRIB_Y_CB   String (up to 1)

'Campaign contribtions? P4 attached' checkbox. Applies to forms 625, 635, 645.


CUM_BEG_DT   Date (without time)

Cumulative period beginning date


ENTITY_CD   String (up to 3)

Entity Code describing the filer

Code Definition
CLI Unknown
FRM Lobbying Firm
IND Person (spending > $5000)
LBY Lobbyist (an individual)
LCO Lobbying Coalition
LEM Lobbying Employer
OTH Other
Sources: .CAL Format Layout (Version 1.05.02) (53), .CAL Format Layout (Version 2.01) (67)

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 or business 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_CITY   String (up to 30)

Firm, employer or coalition business city


FIRM_ID   String (up to 9)

Identification number of firm, employer or coalition


FIRM_NAME   String (up to 200)

Name of firm, employer or coalition


FIRM_PHON   String (up to 20)

Firm, employer or coalition business phone number


FIRM_ST   String (up to 2)

Firm, employer or coalition business state


FIRM_ZIP4   String (up to 10)

Form, employer or coalition business ZIP Code


FORM_TYPE   String (up to 4) · Unique

Name of the source filing form or schedule

Code Definition
F615 Form 615: Lobbyist Report
F625 Form 625: Report of Lobbying Firm
F635 Form 635: Report of Lobbyist Employer or Report of Lobbying Coalition
F645 Form 645: Report of Person Spending $5,000 or More
Sources: .CAL Format Layout (Version 1.05.02) (53), .CAL Format Layout (Version 2.01) (66)

FROM_DATE   Date (without time)

Reporting period from date


LBY_ACTVTY   String (up to 400)

Description of lobbying activity. Applies to forms 635 and 645. Additional description may be provided in text records.


LOBBY_N_CB   String (up to 1)

'Lobbying activity none' checkbox. Applies only to Form 625.


LOBBY_Y_CB   String (up to 1)

'Lobbying activity Form 630 attached' checkbox. Applies only to Form 625.


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


MAJOR_NAMF   String (up to 45)

Major donor first name. Applies only to individuals and forms 625, 635, 645.


MAJOR_NAML   String (up to 200)

Major donor last name. Applies only to individuals and forms 625, 635, 645.


MAJOR_NAMS   String (up to 10)

Major donor suffix. Applies only to individuals and forms 625, 635, 645.


MAJOR_NAMT   String (up to 10)

Major donor title or prefix. Applies only to individuals and forms 625, 635, 645.


NOPART1_CB   String (up to 1)

'No Part I information' checkbox. Applies only to Form 615.


NOPART2_CB   String (up to 1)

'No Part II information' checkbox. Applies only to Form 615.


PART1_1_CB   String (up to 1)

'Partners, owners Form 615 attached ...' checkbox. Applies only to form 625.


PART1_2_CB   String (up to 1)

'Partners, owners listed below ...' checkbox. Applies only to Form 625.


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


RCPCMTE_ID   String (up to 9)

Recipient committee or major donor identification number


RCPCMTE_NM   String (up to 200)

Recipient committee name


REC_TYPE   String (up to 4) · Unique

Record Type Value: CVR

Code Definition
CVR CVR
Sources: .CAL Format Layout (Version 1.05.02) (53), .CAL Format Layout (Version 2.01) (66)

REPORT_NUM   String (up to 3)

Amendment number. 000 is the original. 001-999 are amendments.


RPT_DATE   Date (without time)

Date this report was filed, as reported by the filer


SENDER_ID   String (up to 9)

Identification number of lobbyist entity that is submitting this report. The field is used to authenticate the filer and allows the firm to submit forms for its lobbyists.


SIG_DATE   Date (without time)

Date when 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


THRU_DATE   Date (without time)

Reporting period through date


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

Archive

Download previous versions of this file from our archive.

Last 10 downloads

Date Records
Dec. 10, 2017 325,228 Download »
Dec. 9, 2017 325,228 Download »
Dec. 8, 2017 325,202 Download »
Dec. 7, 2017 325,200 Download »
Dec. 6, 2017 325,199 Download »
Dec. 5, 2017 325,192 Download »
Dec. 4, 2017 325,191 Download »
Dec. 2, 2017 325,190 Download »
Dec. 1, 2017 325,178 Download »
Nov. 30, 2017 325,173 Download »
More past downloads »

References

The documents that provided the information on this page.

  • .CAL Format Layout (Version 2.01) (p. 66-70)

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

  • .CAL Format Layout (Version 1.05.02) (p. 53-56)

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