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 110,340 rows of data published on Wednesday, April 17, 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
April 17, 2019 110,340 Download »
April 16, 2019 110,298 Download »
April 15, 2019 110,261 Download »
April 14, 2019 110,241 Download »
April 13, 2019 110,241 Download »
April 12, 2019 110,235 Download »
April 11, 2019 110,220 Download »
April 9, 2019 110,218 Download »
April 8, 2019 110,165 Download »
April 7, 2019 110,165 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)