LOTH_CD

Payments to other 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 17,053 rows of data published on Tuesday, June 18, 2019.

Download latest   2M 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


FILING_ID   Integer · Unique

Unique filing identification number


FIRM_CITY   String (up to 30)

Firm, employer or coalition's city


FIRM_NAME   String (up to 200)

Firm, employer or coalition's name


FIRM_PHON   String (up to 20)

Firm, employer or coalition's phone number


FIRM_ST   String (up to 2)

Firm, employer or coalition's ZIP Code


FIRM_ZIP4   String (up to 10)

Firm ZIP Code


FORM_TYPE   String (up to 7) · Unique

Name of the source filing form or schedule

Code Definition
F625P3B Form 625 (Report of Lobbying Firm): Part 3, Payments Made In Connection With Lobbying Activities, Section B, Payments Made
Sources: .CAL Format Layout (Version 1.05.02) (63), .CAL Format Layout (Version 2.01) (77)

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


PMT_DATE   Date (without time)

Date of payment


REC_TYPE   String (up to 4) · Unique

Record Type Value: LOTH

Code Definition
LOTH LOTH
Sources: .CAL Format Layout (Version 1.05.02) (63), .CAL Format Layout (Version 2.01) (77)

SUBJ_NAMF   String (up to 45)

First name of employer/client subject of lobbying


SUBJ_NAML   String (up to 200)

Last name of employer/client subject of lobbying


SUBJ_NAMS   String (up to 45)

Suffix of employer/client subject of lobbying


SUBJ_NAMT   String (up to 45)

Prefix or title of employer/client subject of lobbying


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 3, Payments Made In Connection With Lobbying Activities, Section B, Payments Made


Archive

Download previous versions of this file from our archive.

Last 10 downloads

Date Records
June 18, 2019 17,053 Download »
June 17, 2019 17,053 Download »
June 16, 2019 17,053 Download »
June 15, 2019 17,053 Download »
June 14, 2019 17,053 Download »
June 13, 2019 17,053 Download »
June 12, 2019 17,053 Download »
June 11, 2019 17,053 Download »
June 10, 2019 17,053 Download »
June 9, 2019 17,053 Download »
More past downloads »

References

The documents that provided the information on this page.

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

  • Map from .CAL Format to Database Table and Fields (p. 67-68)

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

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