LEXP_CD

Lobbying activity expenditures.

Latest download

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

Download latest   32M CSV

Alternatively, retrieve with curl.

Or, explore past downloads of this file.

Sample

A few sample rows.

Fields

Information about the 26 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 payment


BAKREF_TID   String (up to 20)

Backreference to the tranaction identifer of parent record


BENE_AMT   String (up to 12)

Amount benefiting benficiary


BENE_NAME   String (up to 90)

Name of the person beneifiting


BENE_POSIT   String (up to 90)

Official position of the person beneifiting


CREDCARDCO   String (up to 200)

Name of the credit card company, if paid using a card


ENTITY_CD   String (up to 3)

Entity Code of the Payee

Code Definition
IND Person (spending > $5000)
OTH Other
Sources: .CAL Format Layout (Version 1.05.02) (61), .CAL Format Layout (Version 2.01) (75)

EXPN_DATE   Date (without time)

Date of expenditure


EXPN_DSCR   String (up to 90)

Purpose of the expense and a description or explanation


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
F615P1 Form 615 (Lobbyist Report): Part 1, Activity Expenses Paid, Incurred, Arranged or Provided by the Lobbyist
F625P3A Form 625 (Report of Lobbying Firm): Part 3, Payments Made In Connection With Lobbying Activities, Section A, Activity Expenses
F635P3C Form 635 (Report of Lobbyist Employer or Report of Lobbying Coalition): Part 3, Payments Made in Connection with Lobbying Activities, Section C, Activity Expenses
F645P2A Form 645 (Report of Person Spending $5,000 or More): Part 2, Payments Made this Period, Section A, Activity Expenses
Sources: .CAL Format Layout (Version 1.05.02) (61), .CAL Format Layout (Version 2.01) (74)

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 in a TEXT record


PAYEE_CITY   String (up to 30)

Payee city


PAYEE_NAMF   String (up to 45)

Payee first name


PAYEE_NAML   String (up to 200)

Payee last name or business name


PAYEE_NAMS   String (up to 10)

Payee suffix


PAYEE_NAMT   String (up to 10)

Payee title or prefix


PAYEE_ST   String (up to 2)

Payee state


PAYEE_ZIP4   String (up to 10)

Payee ZIP Code


REC_TYPE   String (up to 4) · Unique

Record Type Value: LEXP

Code Definition
LEXP LEXP
Sources: .CAL Format Layout (Version 1.05.02) (61), .CAL Format Layout (Version 2.01) (74)

RECSUBTYPE   String (up to 1)

Record Subtype

Code Definition
1 Main
2 Detail
Sources: .CAL Format Layout (Version 1.05.02) (61), .CAL Format Layout (Version 2.01) (74)

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 1, Activity Expenses Paid, Incurred, Arranged or Provided by the Lobbyist


Form 625: Report of Lobbying Firm

Part 3, Payments Made In Connection With Lobbying Activities, Section A, Activity Expenses


Form 635: Report of Lobbyist Employer or Report of Lobbying Coalition

Part 3, Payments Made in Connection with Lobbying Activities, Section C, Activity Expenses


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

Part 2, Payments Made this Period, Section A, Activity Expenses


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 106 records out of 201,958 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 201,852 Download »
Dec. 9, 2017 201,852 Download »
Dec. 8, 2017 201,850 Download »
Dec. 7, 2017 201,850 Download »
Dec. 6, 2017 201,850 Download »
Dec. 5, 2017 201,850 Download »
Dec. 4, 2017 201,850 Download »
Dec. 2, 2017 201,850 Download »
Dec. 1, 2017 201,825 Download »
Nov. 30, 2017 201,825 Download »
More past downloads »

References

The documents that provided the information on this page.

  • .CAL Format Layout (Version 2.01) (p. 74-75)

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

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

  • CAL-ACCESS Tables, Columns and Indexes (p. 10, 86-87)