LOBBYIST_EMPLOYER3_CD

Deprecated table for the disclosure of lobbyist relationships.

Latest download

The most recent release from CAL-ACCESS, the database that tracks campaign finance and lobbying activity in California politics. It contains 1,730 rows of data published on Tuesday, Oct. 17, 2017.

Download latest   213K CSV

Alternatively, retrieve with curl.

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.


EMPLOYER_ID   Integer

Employer identification number


SESSION_ID   Integer

Legislative session identification number


EMPLOYER_NAME   String (up to 300)

Employer name


CURRENT_QTR_AMT   Floating point number

Current quarter amount


SESSION_TOTAL_AMT   Floating point number

Total amount for the session


CONTRIBUTOR_ID   Integer

Contributor identification number


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 24)

Interest name


SESSION_YR_1   Integer

Total amount of year 1 of the session


SESSION_YR_2   Integer

Total amount of year 2 of the session


YR_1_YTD_AMT   Floating point number

Year 1 year-to-date-amount


YR_2_YTD_AMT   Floating point number

Year 2 year-to-date-amount


QTR_1   Floating point number

Quarter total amount


QTR_2   Floating point number

Quarter total amount


QTR_3   Floating point number

Quarter total amount


QTR_4   Floating point number

Quarter total amount


QTR_5   Floating point number

Quarter total amount


QTR_6   Floating point number

Quarter total amount


QTR_7   Floating point number

Quarter total amount


QTR_8   Floating point number

Quarter total amount


Archive

Download previous versions of this file from our archive.

Last 10 downloads

Date Records
Oct. 17, 2017 1,730 Download »
Oct. 16, 2017 1,730 Download »
Oct. 15, 2017 1,730 Download »
Oct. 14, 2017 1,730 Download »
Oct. 13, 2017 1,730 Download »
Oct. 12, 2017 1,730 Download »
Oct. 11, 2017 1,730 Download »
Oct. 10, 2017 1,730 Download »
Oct. 9, 2017 1,730 Download »
Oct. 8, 2017 1,730 Download »
More past downloads »

References

The documents that provided the information on this page.

  • CAL-ACCESS Tables, Columns and Indexes (p. 11, 99)