SPLT_CD

Split transaction records used as a child record for a number of forms.

Latest download

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

Download latest   196M CSV

Alternatively, retrieve with curl.

Or, explore past downloads of this file.

Sample

A few sample rows.

Fields

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


ELEC_AMOUNT   Decimal number

Per election to date amount


ELEC_CODE   String (up to 2)

Per election to date code

Code Definition
P Primary
G General
S Special
R Runoff
g General
p primary
C Unknown
D Unknown
F Unknown
M Unknown
N Unknown
X Unknown
O Unknown
0 Unknown
1 Unknown
2 Unknown
Sources: .CAL Format Layout (Version 2.01) (18)

ELEC_DATE   Date (without time)

Date of election


FILING_ID   Integer · Unique

Unique filing identification number


LINE_ITEM   Integer · Unique

Line item number of this record


PFORM_TYPE   String (up to 7) · Unique

Parent Schedule Type

Code Definition
A Form 460 (Campaign Disclosure Statement (Recipient Committee)): Schedule A, Monetary Contributions Received
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
C Form 460 (Campaign Disclosure Statement (Recipient Committee)): Schedule C, Non-Monetary Contributions Received
D Form 460 (Campaign Disclosure Statement (Recipient Committee)): Schedule D, Summary of Expenditures Supporting / Opposing Other Candidates, Measures and Committees
F450P5 Form 450 (Campaign Disclosure Statement, Short Form (Recipient Committee)): Part 5, Payments Made
H Form 460 (Campaign Disclosure Statement (Recipient Committee)): Schedule H, Loans Made to Others
Sources: .CAL Format Layout (Version 2.01) (18)

PTRAN_ID   String (up to 32)

Parent transaction ID


Forms

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



Form 460: Campaign Disclosure Statement (Recipient Committee)

Schedule A, Monetary Contributions Received

Schedule B, Part 1, Loans Received

Schedule B, Part 2, Loan Guarantors

Schedule C, Non-Monetary Contributions Received

Schedule D, Summary of Expenditures Supporting / Opposing Other Candidates, Measures and Committees

Schedule H, Loans Made to Others


Archive

Download previous versions of this file from our archive.

Last 10 downloads

Date Records
June 18, 2019 4,038,164 Download »
June 17, 2019 4,038,162 Download »
June 16, 2019 4,038,162 Download »
June 15, 2019 4,038,162 Download »
June 14, 2019 4,038,103 Download »
June 13, 2019 4,037,721 Download »
June 12, 2019 4,037,580 Download »
June 11, 2019 4,037,580 Download »
June 10, 2019 4,037,580 Download »
June 9, 2019 4,037,562 Download »
More past downloads »

References

The documents that provided the information on this page.

  • .CAL Format Layout (Version 2.01) (p. 18)

  • Map from .CAL Format to Database Table and Fields (p. 88)

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