LOBBYIST_EMPLOYER_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 21 fields and the definitions of any abbreviated values.


CONTRIBUTOR_ID   Integer

Contributor identification number.


CURRENT_QTR_AMT   Integer

Current Quarter Amount


EMPLOYER_ID   Integer

Employer identification number.


EMPLOYER_NAME   String (up to 300)

Employer Name


INTEREST_CD   Integer

Interest Code

Code Definition
40301 AGRICULTURE
40302 EDUCATION
40303 ENTERTAINMENT/RECREATION
40304 FINANCE/INSURANCE
40305 GOVERNMENT
40306 HEALTH
40307 LABOR UNIONS
40308 LEGAL
40309 LODGING/RESTAURANTS
40310 MANUFACTURING/INDUSTRIAL
40311 MERCHANDISE/RETAIL
40312 MISCELLANEOUS
40313 OIL AND GAS
40314 POLITICAL ORGANIZATIONS
40315 PROFESSIONAL/TRADE
40316 PUBLIC EMPLOYEES
40317 REAL ESTATE
40318 TRANSPORTATION
40319 UTILITIES
Sources: Lookup-Codes-Cd (19)

INTEREST_NAME   String (up to 300)

Interest name.


QTR_1   Integer

Quarter 1 total amount.


QTR_2   Integer

Quarter 2 total amount.


QTR_3   Integer

Quarter 3 total amount.


QTR_4   Integer

Quarter 4 total amount.


QTR_5   Integer

Quarter 5 total amount.


QTR_6   Integer

Quarter 6 total amount.


QTR_7   Integer

Quarter 7 total amount.


QTR_8   Integer

Quarter 8 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. 11, 96-97)