HDR_CD

Electronic-filing headers with vendor and CalFormat version.

Latest download

The most recent release from CAL-ACCESS, the database that tracks campaign finance and lobbying activity in California politics. It contains 894,148 rows of data published on Wednesday, April 17, 2019.

Download latest   39M 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.


AMEND_ID   Integer · Unique

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


CAL_VER   String (up to 4)

CAL Version number the filing was made using


EF_TYPE   String (up to 3)

Electronic filing type. This will always have the value of "CAL".

Code Definition
CAL .CAL format
Sources: .CAL Format Layout (Version 1.05.02) (4), .CAL Format Layout (Version 2.01) (5)

FILING_ID   Integer · Unique

Unique filing identification number


HDRCOMMENT   String (up to 200)

Typically used for development and test filings


REC_TYPE   String (up to 4)

Record Type. Value: HDR

Code Definition
HDR HDR
Sources: .CAL Format Layout (Version 1.05.02) (4), .CAL Format Layout (Version 2.01) (5)

SOFT_NAME   String (up to 90)

Filing software name used to electronically file


SOFT_VER   String (up to 16)

Filing software version number


STATE_CD   String (up to 2)

The state code value entered in the electronic filing

Code Definition
CA California
Sources: .CAL Format Layout (Version 1.05.02) (4), .CAL Format Layout (Version 2.01) (5)

Archive

Download previous versions of this file from our archive.

Last 10 downloads

Date Records
April 17, 2019 894,148 Download »
April 16, 2019 893,991 Download »
April 15, 2019 893,817 Download »
April 14, 2019 893,786 Download »
April 13, 2019 893,781 Download »
April 12, 2019 893,659 Download »
April 11, 2019 893,549 Download »
April 9, 2019 893,319 Download »
April 8, 2019 893,188 Download »
April 7, 2019 893,185 Download »
More past downloads »

References

The documents that provided the information on this page.

  • Map from .CAL Format to Database Table and Fields (p. 1, 51)

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

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

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