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 486,023 rows of data published on Thursday, Jan. 17, 2019*.

Download latest   30M 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 69 records out of 486,092 total rows were lost (you can download them here).

Archive

Download previous versions of this file from our archive.

Last 10 downloads

Date Records
Jan. 17, 2019 486,023 Download »
Jan. 16, 2019 485,982 Download »
Jan. 15, 2019 485,947 Download »
Jan. 14, 2019 485,908 Download »
Jan. 13, 2019 485,908 Download »
Jan. 12, 2019 485,908 Download »
Jan. 11, 2019 485,873 Download »
Jan. 10, 2019 485,856 Download »
Jan. 9, 2019 485,815 Download »
Jan. 8, 2019 485,779 Download »
More past downloads »

References

The documents that provided the information on this page.

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