LOAN_CD

Itemized campaign loans.

Latest download

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

Download latest   13M CSV

Alternatively, retrieve with curl.

Or, explore past downloads of this file.

Sample

A few sample rows.

Fields

Information about the 50 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.


BAKREF_TID   String (up to 20)

Back Reference to transaction identifier of parent record


CMTE_ID   String (up to 9)

Committee identification number


ENTITY_CD   String (up to 3)

Entity code describing the lender

Code Definition
COM Committee
IND Individual
OTH Other
PTY Political Party
RCP Recipient committee
SCC Small Contributor Committee
Sources: .CAL Format Layout (Version 1.05.02) (35), .CAL Format Layout (Version 2.01) (47)

FILING_ID   Integer · Unique

Unique filing identification number


FORM_TYPE   String (up to 2) · Unique

Name of the source filing form or schedule

Code Definition
B1 Form 460 (Campaign Disclosure Statement (Recipient Committee)): Schedule B, Part 1, Loans Received
B2 Form 460 (Campaign Disclosure Statement (Recipient Committee)): Schedule B, Part 2, Loan Guarantors
B3 Form 460 (Campaign Disclosure Statement (Recipient Committee)): Schedule B, Part 3, Outstanding Balance
H Form 460 (Campaign Disclosure Statement (Recipient Committee)): Schedule H, Loans Made to Others
H1 Form 460 (Campaign Disclosure Statement (Recipient Committee)): Schedule H, Part 1, Loans Made
H2 Form 460 (Campaign Disclosure Statement (Recipient Committee)): Schedule H, Part 2, Repayments Rcvd
H3 Form 460 (Campaign Disclosure Statement (Recipient Committee)): Schedule H, Part 3, Outstanding Loans
Sources: .CAL Format Layout (Version 1.05.02) (35), .CAL Format Layout (Version 2.01) (47)

INTR_CITY   String (up to 30)

Intermediary's city


INTR_NAMF   String (up to 45)

Intermediary's first name


INTR_NAML   String (up to 200)

Intermediary's last name


INTR_NAMS   String (up to 10)

Intermediary's suffix


INTR_NAMT   String (up to 10)

Intermediary's title or prefix


INTR_ST   String (up to 2)

Intermediary's state


INTR_ZIP4   String (up to 10)

Intermediary's ZIP Code


LINE_ITEM   Integer · Unique

Line item number of this record


LNDR_NAMF   String (up to 45)

Lender's first name


LNDR_NAML   String (up to 200)

Lender's last name or business name


LNDR_NAMS   String (up to 10)

Lender's suffix


LNDR_NAMT   String (up to 10)

Lender's title or prefix


LOAN_AMT1   Decimal number

Repaid or forgiven amount; Original loan amount. The content of this column varies based on the schedule/part that the record applies to. See the CAL document for a description of the value of this field.


LOAN_AMT2   Decimal number

Outstanding Principal; unpaid balance. The content of this column varies based on the schedule/part that the record applies to. See the CAL document for a description of the value of this field.


LOAN_AMT3   Decimal number

Interest Paid; Unpaid interest; Interest received. The content of this column varies based on the schedule/part that the record applies to. See the CAL document for a description of the value of this field.


LOAN_AMT4   Decimal number

Cumulative Amount/Other. The content of this column varies based on the schedule/part that the record applies to. See the CAL document for a description of the value of this field.


LOAN_AMT5   Decimal number

This field is undocumented


LOAN_AMT6   Decimal number

This field is undocumented


LOAN_AMT7   Decimal number

This field is undocumented


LOAN_AMT8   Decimal number

This field is undocumented


LOAN_CITY   String (up to 30)

Lender's city


LOAN_DATE1   Date (without time)

Date the loan was made or received. The content of this column varies based on the schedule/part that the record applies to. See the CAL document for a description of the value.


LOAN_DATE2   Date (without time)

Date repaid/forgiven; date loan due. The content of this column varies based on the schedule/part that the record applies to. See the CAL document for a description of the value of this field.


LOAN_EMP   String (up to 200)

Loan employer. Applies to the Form 460 Schedule B Part 1.


LOAN_OCC   String (up to 60)

Loan occupation. Applies to the Form 460 Schedule B Part 1.


LOAN_RATE   String (up to 30)

Interest Rate. The content of this column varies based on the schedule/part that the record applies to. See the CAL document for a description of the value of this field.


LOAN_SELF   String (up to 1)

Self-employed checkbox


LOAN_ST   String (up to 2)

Lender's state


LOAN_TYPE   String (up to 3)

Type of loan

Code Definition
H2T Third party payment
H2F Forgiven
H2R Repay
B2T Third party payment
B2F Forgiven
B2R Repay
B1G Guarantor
B1L Lender
Sources: .CAL Format Layout (Version 1.05.02) (35), .CAL Format Layout (Version 2.01) (47)

LOAN_ZIP4   String (up to 10)

Lender's ZIP Code


MEMO_CODE   String (up to 1)

Memo amount flag


MEMO_REFNO   String (up to 20)

Reference to text contained in a TEXT record


REC_TYPE   String (up to 4) · Unique

Record Type Value: LOAN

Code Definition
LOAN LOAN
Sources: .CAL Format Layout (Version 1.05.02) (35), .CAL Format Layout (Version 2.01) (47)

TRAN_ID   String (up to 20)

Permanent value unique to this item


TRES_CITY   String (up to 30)

Treasurer or responsible officer's city


TRES_NAMF   String (up to 45)

Treasurer or responsible officer's first name


TRES_NAML   String (up to 200)

Treasurer or responsible officer's last name


TRES_NAMS   String (up to 10)

Treasurer or responsible officer's suffix


TRES_NAMT   String (up to 10)

Treasurer or responsible officer's title or prefix


TRES_ST   String (up to 2)

Treasurer or responsible officer's street address


TRES_ZIP4   String (up to 10)

Treasurer or responsible officer's ZIP Code


XREF_MATCH   String (up to 1)

Related item on other schedule has same transaction identifier. "X" indicates this condition is true.


XREF_SCHNM   String (up to 2)

Related record is included on Form 460 Schedule 'A' or 'E'


Forms

The forms that the state uses to collect the information that populates this file.


Form 460: Campaign Disclosure Statement (Recipient Committee)

Schedule B, Part 1, Loans Received

Schedule B, Part 2, Loan Guarantors

Schedule B, Part 3, Outstanding Balance

Schedule H, Loans Made to Others

Schedule H, Part 1, Loans Made

Schedule H, Part 2, Repayments Rcvd

Schedule H, Part 3, Outstanding Loans


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 12 records out of 73,940 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 73,928 Download »
Oct. 16, 2017 73,927 Download »
Oct. 15, 2017 73,927 Download »
Oct. 14, 2017 73,927 Download »
Oct. 13, 2017 73,921 Download »
Oct. 12, 2017 73,920 Download »
Oct. 11, 2017 73,920 Download »
Oct. 10, 2017 73,920 Download »
Oct. 9, 2017 73,920 Download »
Oct. 8, 2017 73,920 Download »
More past downloads »

References

The documents that provided the information on this page.

  • .CAL Format Layout (Version 1.05.02) (p. 35-39)

  • .CAL Format Layout (Version 2.01) (p. 47-50)

  • CAL-ACCESS Tables, Columns and Indexes (p. 87-90)

  • Map from .CAL Format to Database Table and Fields (p. 60-63)