LCCM_CD

Lobbyist campaign contributions.

Latest download

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

Download latest   10M CSV

Alternatively, retrieve with curl.

Or, explore past downloads of this file.

Sample

A few sample rows.

Fields

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


AMOUNT   Decimal number

Amount of contribution


BAKREF_TID   String (up to 20)

Back reference to transaction identifier of parent record


CTRIB_DATE   Date (without time)

Date of contribution


CTRIB_NAMF   String (up to 45)

Contributor first name


CTRIB_NAML   String (up to 200)

Contributor last name or business name


CTRIB_NAMS   String (up to 10)

Contributor suffix


CTRIB_NAMT   String (up to 10)

Contributor prefix or title.


ENTITY_CD   String (up to 3)

Entity Code for Recipient of the Campaign Contribution Value

Code Definition
COM Committee
RCP Recipient Committee
CTL Controlled committee
Sources: .CAL Format Layout (Version 1.05.02) (64), .CAL Format Layout (Version 2.01) (78)

FILING_ID   Integer · Unique

Unique filing identification number


FORM_TYPE   String (up to 7) · Unique

Name of the source filing form or schedule

Code Definition
F615P2 Form 615 (Lobbyist Report): Part 2, Campaign Contributions Made or Delivered
F625P4B Form 625 (Report of Lobbying Firm): Part 4, Campaign Contributions Made
F635P4B Form 635 (Report of Lobbyist Employer or Report of Lobbying Coalition): Part 4, Campaign Contributions Made
F645P3B Form 645 (Report of Person Spending $5,000 or More): Part 3, Campaign Contributions Made
Sources: .CAL Format Layout (Version 1.05.02) (64), .CAL Format Layout (Version 2.01) (78-79)

LINE_ITEM   Integer · Unique

Line item number of this record


MEMO_CODE   String (up to 1)

Memo amount flag


MEMO_REFNO   String (up to 20)

Reference to the text contained in the TEXT record


REC_TYPE   String (up to 4) · Unique

Record Type Value: LCCM

Code Definition
LCCM LCCM
Sources: .CAL Format Layout (Version 1.05.02) (64), .CAL Format Layout (Version 2.01) (78)

RECIP_CITY   String (up to 30)

Recipient city


RECIP_ID   String (up to 9)

Recipient identification number


RECIP_NAMF   String (up to 45)

Recipient first name


RECIP_NAML   String (up to 200)

Recipient last name


RECIP_NAMS   String (up to 10)

Recipient name suffix


RECIP_NAMT   String (up to 10)

Recipient name prefix or title


RECIP_ST   String (up to 2)

Recipient state


RECIP_ZIP4   String (up to 10)

Recipient ZIP Code


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.


Form 615: Lobbyist Report

Part 2, Campaign Contributions Made or Delivered


Form 625: Report of Lobbying Firm

Part 4, Campaign Contributions Made



Form 645: Report of Person Spending $5,000 or More

Part 3, Campaign Contributions Made


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 17 records out of 95,463 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 95,446 Download »
Oct. 16, 2017 95,444 Download »
Oct. 15, 2017 95,444 Download »
Oct. 14, 2017 95,444 Download »
Oct. 13, 2017 95,443 Download »
Oct. 12, 2017 95,438 Download »
Oct. 11, 2017 95,421 Download »
Oct. 10, 2017 95,410 Download »
Oct. 9, 2017 95,410 Download »
Oct. 8, 2017 95,410 Download »
More past downloads »

References

The documents that provided the information on this page.

  • .CAL Format Layout (Version 2.01) (p. 78-79)

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

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

  • CAL-ACCESS Tables, Columns and Indexes (p. 10, 83-84)