LOBBYIST_FIRM_EMPLOYER1_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 170 rows of data published on Tuesday, Oct. 17, 2017.

Download latest   31K 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.


FIRM_ID   Integer

Identification number of the firm, employer or coalition


FILING_ID   Integer

Unique filing identification number


FILING_SEQUENCE   Integer

Amendment number. 0 is the original filing. 1 to 999 are amendments


FIRM_NAME   String (up to 400)

Name of firm, employer or coalition


EMPLOYER_NAME   String (up to 300)

Employer name


RPT_START   Date (without time)

Starting date for the period the report covers


RPT_END   Date (without time)

Ending date for the period the report covers


PER_TOTAL   Floating point number

Total this reporting period


CUM_TOTAL   Floating point number

Cumulative total to date


LBY_ACTVTY   String (up to 182)

Description of lobbying activity


EXT_LBY_ACTVTY   String (up to 32)

This field is undocumented


Archive

Download previous versions of this file from our archive.

Last 10 downloads

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

References

The documents that provided the information on this page.

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