LATT_CD

Attachments for lobbying payments.

Latest download

The most recent release from CAL-ACCESS, the database that tracks campaign finance and lobbying activity in California politics. It contains 113,295 rows of data published on Tuesday, June 18, 2019.

Download latest   12M CSV

Alternatively, retrieve with curl.

Or, explore past downloads of this file.

Sample

A few sample rows.

Fields

Information about the 21 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


CUM_AMT   Decimal number

Cumulative total to date


CUMBEG_DT   Date (without time)

Cumulative period beginning to date


ENTITY_CD   String (up to 3)

Entity Code of the Payment Recipient/Payee

Code Definition
FRM Lobbying Firm
IND Person (spending > $5000)
LBY Lobbyist (an individual)
LCO Lobbying Coalition
LEM Lobbying Employer
OTH Other
RCP Recipient Committee
Sources: .CAL Format Layout (Version 1.05.02) (65), .CAL Format Layout (Version 2.01) (80)

FILING_ID   Integer · Unique

Unique filing identification number


FORM_TYPE   String (up to 6) · Unique

Name of the source filing form or schedule

Code Definition
Schedule 630: Payments Made to Lobbying Coalitions (Attachment to Form 625 or 635)
S635-C Schedule 635C: Payments Received by Lobbying Coalitions
Schedule 640: Governmental Agencies Reporting (Attachment to Form 635 or Form 645)
Sources: Map from .CAL Format to Database Table and Fields (52), .CAL Format Layout (Version 1.05.02) (65), .CAL Format Layout (Version 2.01) (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 in a TEXT record


PMT_DATE   Date (without time)

Date of payment


REC_TYPE   String (up to 4) · Unique

Record Type Value: LATT

Code Definition
LATT LATT
Sources: .CAL Format Layout (Version 1.05.02) (65), .CAL Format Layout (Version 2.01) (79)

RECIP_CITY   String (up to 30)

Recipient city


RECIP_NAMF   String (up to 45)

Recipient first name


RECIP_NAML   String (up to 200)

Recipient last name or business name


RECIP_NAMS   String (up to 10)

Recipient suffix


RECIP_NAMT   String (up to 10)

Recipient title or prefix


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.





Archive

Download previous versions of this file from our archive.

Last 10 downloads

Date Records
June 18, 2019 113,295 Download »
June 17, 2019 113,288 Download »
June 16, 2019 113,278 Download »
June 15, 2019 113,278 Download »
June 14, 2019 113,273 Download »
June 13, 2019 113,273 Download »
June 12, 2019 113,256 Download »
June 11, 2019 113,256 Download »
June 10, 2019 113,251 Download »
June 9, 2019 113,251 Download »
More past downloads »

References

The documents that provided the information on this page.

  • Map from .CAL Format to Database Table and Fields (p. 52-53)

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

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

  • CAL-ACCESS Tables, Columns and Indexes (p. 81-82)