F690P2_CD

Amendments to lobbying-disclosure filings.

Latest download

The most recent release from CAL-ACCESS, the database that tracks campaign finance and lobbying activity in California politics. It contains 21,023 rows of data published on Tuesday, Oct. 17, 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 12 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: F690

Code Definition
F690 F690
Sources: .CAL Format Layout (Version 1.05.02) (58), .CAL Format Layout (Version 2.01) (72)

FORM_TYPE   String (up to 4) · Unique

Name of the source filing form or schedule

Code Definition
F615 Form 615: Lobbyist Report
F625 Form 625: Report of Lobbying Firm
F635 Form 635: Report of Lobbyist Employer or Report of Lobbying Coalition
F645 Form 645: Report of Person Spending $5,000 or More
Sources: .CAL Format Layout (Version 1.05.02) (58), .CAL Format Layout (Version 2.01) (72)

EXEC_DATE   Date (without time)

Date the original report (or prior amendment to the original report) was executed on.


FROM_DATE   Date (without time)

Reporting period from date of original report


THRU_DATE   Date (without time)

Report period to/through date of original.


CHG_PARTS   String (up to 100)

Amended into affects items on part(s) text description.


CHG_SECTS   String (up to 100)

Amended into affects items on sections(s) text description.


AMEND_TXT1   String (up to 330)

Description of changes to the filing


Forms

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






Archive

Download previous versions of this file from our archive.

Last 10 downloads

Date Records
Oct. 17, 2017 21,023 Download »
Oct. 16, 2017 21,011 Download »
Oct. 15, 2017 21,011 Download »
Oct. 14, 2017 21,009 Download »
Oct. 13, 2017 21,007 Download »
Oct. 12, 2017 20,998 Download »
Oct. 11, 2017 20,994 Download »
Oct. 10, 2017 20,991 Download »
Oct. 9, 2017 20,987 Download »
Oct. 8, 2017 20,987 Download »
More past downloads »

References

The documents that provided the information on this page.

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

  • Map from .CAL Format to Database Table and Fields (p. 50-51)

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

  • CAL-ACCESS Tables, Columns and Indexes (p. 8, 59-60)