LPAY_CD

Payments made or received by lobbying firms.

Latest download

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

Download latest   74M CSV

Alternatively, retrieve with curl.

Or, explore past downloads of this file.

Sample

A few sample rows.

Fields

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


ADVAN_AMT   Decimal number

Advance and other payments amount


ADVAN_DSCR   String (up to 100)

Description of advance and other payments


AMEND_ID   Integer · Unique

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


BAKREF_TID   String (up to 20)

Backreference to transaction identifer of parent record


CUM_TOTAL   Decimal number

Cumulative total to date


EMPLR_CITY   String (up to 30)

Employer city


EMPLR_ID   String (up to 9)

This field is undocumented


EMPLR_NAMF   String (up to 45)

Employer first name


EMPLR_NAML   String (up to 200)

Name of firm, employer or coalition


EMPLR_NAMS   String (up to 10)

Employer suffix


EMPLR_NAMT   String (up to 10)

Employer title or prefix


EMPLR_PHON   String (up to 20)

Employer phone number


EMPLR_ST   String (up to 2)

Employer state


EMPLR_ZIP4   String (up to 10)

Employer ZIP Code


ENTITY_CD   String (up to 3)

Entity Code of the Employer Values

Code Definition
FRM Lobbying Firm
LCO Lobbying Coalition
LEM Lobbying Employer
OTH Other
128 Unknown
Sources: .CAL Format Layout (Version 1.05.02) (62), .CAL Format Layout (Version 2.01) (76)

FEES_AMT   Decimal number

Fees and retainers amount


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
F625P2 Form 625 (Report of Lobbying Firm): Part 2, Payments Received in Connection with Lobbying Activity
F635P3B Form 635 (Report of Lobbyist Employer or Report of Lobbying Coalition): Part 3, Payments Made in Connection with Lobbying Activities, Section B, Payments To Lobbying Firms
Sources: .CAL Format Layout (Version 1.05.02) (62), .CAL Format Layout (Version 2.01) (76)

LBY_ACTVTY   String (up to 200)

Description of lobbying activity


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


PER_TOTAL   Decimal number

Total this reporting period


REC_TYPE   String (up to 4) · Unique

Record Type Value: LPAY

Code Definition
LPAY LPAY
Sources: .CAL Format Layout (Version 1.05.02) (62), .CAL Format Layout (Version 2.01) (76)

REIMB_AMT   Decimal number

Reimbursements of expense amount


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 625: Report of Lobbying Firm

Part 2, Payments Received in Connection with Lobbying Activity


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

Part 3, Payments Made in Connection with Lobbying Activities, Section B, Payments To Lobbying Firms


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 81 records out of 490,644 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 490,563 Download »
Oct. 16, 2017 490,450 Download »
Oct. 15, 2017 490,441 Download »
Oct. 14, 2017 490,411 Download »
Oct. 13, 2017 490,363 Download »
Oct. 12, 2017 490,319 Download »
Oct. 11, 2017 490,283 Download »
Oct. 10, 2017 490,228 Download »
Oct. 9, 2017 490,120 Download »
Oct. 8, 2017 490,117 Download »
More past downloads »

References

The documents that provided the information on this page.

  • .CAL Format Layout (Version 2.01) (p. 76-77)

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

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

  • CAL-ACCESS Tables, Columns and Indexes (p. 107-109)