SMRY_CD

Summary totals from filings.

Latest download

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

Download latest   287M CSV

Alternatively, retrieve with curl.

Or, explore past downloads of this file.

Sample

A few sample rows.

Fields

Information about the 10 fields and the definitions of any abbreviated values.


FILING_ID   Integer · Unique

Unique filing identification number


AMEND_ID   Integer · Unique

Amendment identification number. A number of 0 is the original filing and 1 to 999 amendments.


LINE_ITEM   String (up to 8) · Unique

Line item number of this record


REC_TYPE   String (up to 4) · Unique

Record Type Value: SMRY

Code Definition
SMRY SMRY
Sources: .CAL Format Layout (Version 1.05.02) (27, 59), .CAL Format Layout (Version 2.01) (35, 72)

FORM_TYPE   String (up to 8) · Unique

Name of the source filing form or schedule

Code Definition
Form 401: Campaign Disclosure Statement (Slate Mailer Organization)
F401A Form 401 (Campaign Disclosure Statement (Slate Mailer Organization)): Schedule A, Payments Received
F401B Form 401 (Campaign Disclosure Statement (Slate Mailer Organization)): Schedule B, Payments Made
F401B-1 Form 401 (Campaign Disclosure Statement (Slate Mailer Organization)): Schedule B-1, Payments Made by Agent or Independent Contractor
Form 450: Campaign Disclosure Statement, Short Form (Recipient Committee)
Form 460: Campaign Disclosure Statement (Recipient Committee)
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
B3 Form 460 (Campaign Disclosure Statement (Recipient Committee)): Schedule B, Part 3, Outstanding Balance
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
E Form 460 (Campaign Disclosure Statement (Recipient Committee)): Schedule E, Payments Made
F Form 460 (Campaign Disclosure Statement (Recipient Committee)): Schedule F, Accrued Expenses (Unpaid Bills)
G Form 460 (Campaign Disclosure Statement (Recipient Committee)): Schedule G, Payments Made by an Agent or Independent Contractor (on Behalf of This Committee)
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
I Form 460 (Campaign Disclosure Statement (Recipient Committee)): Schedule I, Miscellanous increases to cash
Form 461: Campaign Disclosure Statement (Independent Expenditure Committee & Major Donor Committee)
Form 465: Supplemental Independent Expenditure Report
Form 625: Report of Lobbying Firm
F625P2 Form 625 (Report of Lobbying Firm): Part 2, Payments Received in Connection with Lobbying Activity
F625P3A Form 625 (Report of Lobbying Firm): Part 3, Payments Made In Connection With Lobbying Activities, Section A, Activity Expenses
F625P3B Form 625 (Report of Lobbying Firm): Part 3, Payments Made In Connection With Lobbying Activities, Section B, Payments Made
Form 635: Report of Lobbyist Employer or Report of Lobbying Coalition
F635P3A Form 635 (Report of Lobbyist Employer or Report of Lobbying Coalition): Part 3, Payments Made in Connection with Lobbying Activities, Section A, Payments To In-house Employee Lobbyists
F635P3B Form 635 (Report of Lobbyist Employer or Report of Lobbying Coalition): Part 3, Payments Made in Connection with Lobbying Activities, Section B, Payments To Lobbying Firms
F635P3C Form 635 (Report of Lobbyist Employer or Report of Lobbying Coalition): Part 3, Payments Made in Connection with Lobbying Activities, Section C, Activity Expenses
F635P3D Form 635 (Report of Lobbyist Employer or Report of Lobbying Coalition): Part 3, Payments Made in Connection with Lobbying Activities, Section D, Other Payments to Influence Legislative or Administrative Action
F635P3E Form 635 (Report of Lobbyist Employer or Report of Lobbying Coalition): Part 3, Payments Made in Connection with Lobbying Activities, Section E, Payments in Connection with Administrative Testimony in Ratemaking Proceedings Before The California Public Utilities Commission
Schedule 640: Governmental Agencies Reporting (Attachment to Form 635 or Form 645)
Form 645: Report of Person Spending $5,000 or More
F645P2A Form 645 (Report of Person Spending $5,000 or More): Part 2, Payments Made this Period, Section A, Activity Expenses
F645P2B Form 645 (Report of Person Spending $5,000 or More): Part 2, Payments Made this Period, Section B, Other Payments to Influence Legislative or Administrative Action
F645P2C Form 645 (Report of Person Spending $5,000 or More): Part 2, Payments Made this Period, Section C, Payments in Connection with Administrative Testimony in Ratemaking Proceedings Before the California Public Utilities Commission
Form 900: Campaign Disclosure Statement (Public employee retirement board candidate)
401A A
401B B
401B-1 B-1
Sources: .CAL Format Layout (Version 1.05.02) (27-28, 59-60), .CAL Format Layout (Version 2.01) (36-37, 73-74), Map from .CAL Format to Database Table and Fields (86)

AMOUNT_A   Decimal number

Summary amount from column A


AMOUNT_B   Decimal number

Summary amount from column B


AMOUNT_C   Decimal number

Summary amount from column C


ELEC_DT   Date (without time)

Election date


Forms

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


Form 401: Campaign Disclosure Statement (Slate Mailer Organization)

Schedule A, Payments Received

Schedule B, Payments Made

Schedule B-1, Payments Made by Agent or Independent Contractor



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 B, Part 3, Outstanding Balance

Schedule C, Non-Monetary Contributions Received

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

Schedule E, Payments Made

Schedule F, Accrued Expenses (Unpaid Bills)

Schedule G, Payments Made by an Agent or Independent Contractor (on Behalf of This Committee)

Schedule H, Loans Made to Others

Schedule H, Part 1, Loans Made

Schedule H, Part 2, Repayments Rcvd

Schedule H, Part 3, Outstanding Loans

Schedule I, Miscellanous increases to cash




Form 625: Report of Lobbying Firm

Part 2, Payments Received in Connection with Lobbying Activity

Part 3, Payments Made In Connection With Lobbying Activities, Section A, Activity Expenses

Part 3, Payments Made In Connection With Lobbying Activities, Section B, Payments Made


Form 635: Report of Lobbyist Employer or Report of Lobbying Coalition

Part 3, Payments Made in Connection with Lobbying Activities, Section A, Payments To In-house Employee Lobbyists

Part 3, Payments Made in Connection with Lobbying Activities, Section B, Payments To Lobbying Firms

Part 3, Payments Made in Connection with Lobbying Activities, Section C, Activity Expenses

Part 3, Payments Made in Connection with Lobbying Activities, Section D, Other Payments to Influence Legislative or Administrative Action

Part 3, Payments Made in Connection with Lobbying Activities, Section E, Payments in Connection with Administrative Testimony in Ratemaking Proceedings Before The California Public Utilities Commission


Form 645: Report of Person Spending $5,000 or More

Part 2, Payments Made this Period, Section A, Activity Expenses

Part 2, Payments Made this Period, Section B, Other Payments to Influence Legislative or Administrative Action

Part 2, Payments Made this Period, Section C, Payments in Connection with Administrative Testimony in Ratemaking Proceedings Before the California Public Utilities Commission




Archive

Download previous versions of this file from our archive.

Last 10 downloads

Date Records
June 18, 2019 10,196,028 Download »
June 17, 2019 10,195,686 Download »
June 16, 2019 10,195,648 Download »
June 15, 2019 10,195,648 Download »
June 14, 2019 10,195,090 Download »
June 13, 2019 10,194,665 Download »
June 12, 2019 10,194,251 Download »
June 11, 2019 10,193,758 Download »
June 10, 2019 10,193,624 Download »
June 9, 2019 10,193,579 Download »
More past downloads »

References

The documents that provided the information on this page.

  • .CAL Format Layout (Version 1.05.02) (p. 27-28, 59-60)

  • .CAL Format Layout (Version 2.01) (p. 35-37, 72-74)

  • Map from .CAL Format to Database Table and Fields (p. 86-87)

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