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 788,825 rows of data published on Tuesday, Oct. 17, 2017*.

Download latest   98M 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 75 records out of 788,900 total rows were lost (you can download them here).

Archive

Download previous versions of this file from our archive.

Last 10 downloads

Date Records
Oct. 17, 2017 788,825 Download »
Oct. 16, 2017 788,746 Download »
Oct. 15, 2017 788,746 Download »
Oct. 14, 2017 788,746 Download »
Oct. 13, 2017 788,681 Download »
Oct. 12, 2017 788,659 Download »
Oct. 11, 2017 788,592 Download »
Oct. 10, 2017 788,566 Download »
Oct. 9, 2017 788,569 Download »
Oct. 8, 2017 788,569 Download »
More past downloads »

References

The documents that provided the information on this page.

  • FAQ (p. 2)