S496_CD

Itemized independent expenditures made in the 90 days before an election.

Latest download

The most recent release from CAL-ACCESS, the database that tracks campaign finance and lobbying activity in California politics. It contains 46,861 rows of data published on Sunday, Dec. 10, 2017*.

Download latest   3M CSV

Alternatively, retrieve with curl.

Or, explore past downloads of this file.

Sample

A few sample rows.

Fields

Information about the 13 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   Integer · Unique

Line item number of this record


REC_TYPE   String (up to 4) · Unique

Record Type Value: S496

Code Definition
S496 S496
Sources: .CAL Format Layout (Version 1.05.02) (40), .CAL Format Layout (Version 2.01) (53)

FORM_TYPE   String (up to 4) · Unique

Name of the source filing form or schedule

Code Definition
F496 Form 496: Late Independent Expenditure Report
Sources: .CAL Format Layout (Version 1.05.02) (40), .CAL Format Layout (Version 2.01) (53)

TRAN_ID   String (up to 20)

Permanent value unique to this item


AMOUNT   Decimal number

Expenditure amount


EXP_DATE   Date (without time)

Expenditure dates


EXPN_DSCR   String (up to 90)

Purpose of expense and/or description/explanation


MEMO_CODE   String (up to 1)

Memo amount flag


MEMO_REFNO   String (up to 20)

Reference to text contained in a TEXT record


DATE_THRU   Date (without time)

End of date range for items paid


Forms

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



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 28 records out of 46,889 total rows were lost (you can download them here).

Archive

Download previous versions of this file from our archive.

Last 10 downloads

Date Records
Dec. 10, 2017 46,861 Download »
Dec. 9, 2017 46,861 Download »
Dec. 8, 2017 46,860 Download »
Dec. 7, 2017 46,860 Download »
Dec. 6, 2017 46,860 Download »
Dec. 5, 2017 46,857 Download »
Dec. 4, 2017 46,845 Download »
Dec. 2, 2017 46,845 Download »
Dec. 1, 2017 46,842 Download »
Nov. 30, 2017 46,817 Download »
More past downloads »

References

The documents that provided the information on this page.

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

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

  • CAL-ACCESS Tables, Columns and Indexes (p. 12, 124-125)

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