NAMES_CD

A collection of names from across the database.

Latest download

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

Download latest   29M CSV

Alternatively, retrieve with curl.

Or, explore past downloads of this file.

Sample

A few sample rows.

Fields

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


NAMID   Integer

Identification number unique to the name


NAML   String (up to 200)

Last name


NAMF   String (up to 50)

First name


NAMT   String (up to 100)

Name title or prefix


NAMS   String (up to 30)

Name suffix


MONIKER   String (up to 30)

Entity's moniker


MONIKER_POS   String (up to 9)

Location of the entity's moniker


NAMM   String (up to 20)

Middle name


FULLNAME   String (up to 200)

Full name


NAML_SEARCH   String (up to 200)

Last name


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 54 records out of 465,964 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 465,910 Download »
April 22, 2018 465,910 Download »
April 21, 2018 465,910 Download »
April 20, 2018 465,874 Download »
April 19, 2018 465,826 Download »
April 18, 2018 465,768 Download »
April 17, 2018 465,705 Download »
April 16, 2018 465,648 Download »
April 15, 2018 465,648 Download »
April 14, 2018 465,648 Download »
More past downloads »

References

The documents that provided the information on this page.

  • CAL-ACCESS Tables, Columns and Indexes (p. 13, 112)