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 15,260 rows of data published on Tuesday, Oct. 17, 2017.

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
Oct. 17, 2017 15,260 Download »
Oct. 16, 2017 15,254 Download »
Oct. 15, 2017 15,254 Download »
Oct. 14, 2017 15,254 Download »
Oct. 13, 2017 15,252 Download »
Oct. 12, 2017 15,251 Download »
Oct. 11, 2017 15,251 Download »
Oct. 10, 2017 15,251 Download »
Oct. 9, 2017 15,245 Download »
Oct. 8, 2017 15,245 Download »
More past downloads »

References

The documents that provided the information on this page.

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

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

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

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