FILERNAME_CD

A combination of CAL-ACCESS tables created by the state to consolidate filer information.

Latest download

The most recent release from CAL-ACCESS, the database that tracks campaign finance and lobbying activity in California politics. It contains 792,069 rows of data published on Monday, April 23, 2018*.

Download latest   99M CSV

Alternatively, retrieve with curl.

Or, explore past downloads of this file.

Sample

A few sample rows.

Fields

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


XREF_FILER_ID   String (up to 15)

Alternative filer ID found on many forms


FILER_ID   Integer · Unique

Filer's unique identification number


FILER_TYPE   String (up to 45)

The type of filer. These values are found FILER_TYPES_CD.DESCRIPTION

Code Definition
NOT DEFINED Undefined
ALL FILERS All filers
CANDIDATE/OFFICEHOLDER Candidate/officeholder
CLIENT Client
EMPLOYER Employer
FIRM Firm
INDIVIDUAL Individual
INITIATIVE Initiative
LOBBYIST Lobbyist
MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE Major donor or indenpendent expenditure committee
PAYMENT TO INFLUENCE Payment to influence
PREPAID ACCOUNT Prepaid account
PROPONENT Proponent
PROPOSITION Proposition
RECIPIENT COMMITTEE Recipient committee
SLATE MAILER ORGANIZATIONS Slate mailer organization
TREASURER/RESPONSIBLE OFFICER Treasurer/responsible officer
Sources: Filer-Types-Cd (1)

STATUS   String (up to 10)

The status of the filer. Includes a mixture of values found in the STATUS_TYPE and STATUS_DESC columns on FILER_STATUS_TYPES_CD

Code Definition
Undefined
A ACTIVE
P PENDING
R REVOKED
S SUSPENDED
W WITHDRAWN
Y ACTIVE
N INACTIVE
T TERMINATED
ACTIVE ACTIVE
INACTIVE INACTIVE
TERMINATED TERMINATED
Sources: Filer-Status-Types-Cd (1)

EFFECT_DT   Date (without time)

Effective date for status


NAML   String (up to 200)

Last name, sometimes full name in the case of PACs, firms and employers. Major donors can be split between first and last name fields, but usually are contained in the last name field only. Individual names of lobbyists, politicans and officers tend to use both the first and last name.


NAMF   String (up to 55)

First name


NAMT   String (up to 70)

Name prefix or title


NAMS   String (up to 32)

Name suffix


ADR1   String (up to 200)

First line of street address


ADR2   String (up to 200)

Second line of street address


CITY   String (up to 55)

City address


ST   String (up to 4)

State


ZIP4   String (up to 10)

ZIP Code


PHON   String (up to 60)

Phone number


FAX   String (up to 60)

Fax number


EMAIL   String (up to 60)

Email address


Errata

The raw data provided by the state contains errors in how some values are escaped, quoted and delimited. The result is a small number of records in the latest download were lost when we prepared files for download.

However, only 87 records out of 792,156 total rows were lost (you can download them here).

Archive

Download previous versions of this file from our archive.

Last 10 downloads

Date Records
April 23, 2018 792,069 Download »
April 22, 2018 792,069 Download »
April 21, 2018 792,069 Download »
April 20, 2018 791,872 Download »
April 19, 2018 791,669 Download »
April 18, 2018 791,485 Download »
April 17, 2018 791,350 Download »
April 16, 2018 791,223 Download »
April 15, 2018 791,219 Download »
April 14, 2018 791,219 Download »
More past downloads »

References

The documents that provided the information on this page.

  • FAQ (p. 2)