LOBBYIST_FIRM_HISTORY_CD

Undocumented.

Latest download

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

Download unavailable

Or, explore past downloads of this file.

Sample

A few sample rows.

Fields

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


CONTRIBUTOR_ID   Integer

Contributor identification number.


CURRENT_QTR_AMT   Integer

Current Quarter Amount


FIRM_ID   Integer

Identification number of the Firm/Employer/Coalition.


FIRM_NAME   String (up to 300)

Name of Firm/Employer/Coalition


QTR_1   Integer

Quarter total amount.


QTR_2   Integer

Quarter total amount.


QTR_3   Integer

Quarter total amount.


QTR_4   Integer

Quarter total amount.


QTR_5   Integer

Quarter total amount.


QTR_6   Integer

Quarter total amount.


QTR_7   Integer

Quarter total amount.


QTR_8   Integer

Quarter total amount.


SESSION_ID   Integer

Session identification number.


SESSION_TOTAL_AMT   Integer

Total amount for the session.


SESSION_YR_1   Integer

Total amount for year 1 of the session.


SESSION_YR_2   Integer

Total amount for year 2 of the session.


YR_1_YTD_AMT   Integer

Year 1 year to date amount.


YR_2_YTD_AMT   Integer

Year 2 year to date amount


Archive

Download previous versions of this file from our archive.

Last 10 downloads

Date Records
April 17, 2019 Unavailable
April 16, 2019 Unavailable
April 15, 2019 Unavailable
April 14, 2019 Unavailable
April 13, 2019 Unavailable
April 12, 2019 Unavailable
April 11, 2019 Unavailable
April 9, 2019 Unavailable
April 8, 2019 Unavailable
April 7, 2019 Unavailable
More past downloads »

References

The documents that provided the information on this page.

  • CAL-ACCESS Tables, Columns and Indexes (p. 12, 101-102)