FILER_LINKS_CD

Links filers to each other.

Latest download

The most recent release from CAL-ACCESS, the database that tracks campaign finance and lobbying activity in California politics. It contains 299,838 rows of data published on Wednesday, April 17, 2019.

Download latest   23M CSV

Alternatively, retrieve with curl.

Or, explore past downloads of this file.

Sample

A few sample rows.

Fields

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


FILER_ID_A   Integer · Unique

Unique identification number for the first filer in the relationship


FILER_ID_B   Integer · Unique

Unique identification number for the second filer in the relationship


ACTIVE_FLG   String (up to 1) · Unique

Indicates if the link is active


SESSION_ID   Integer · Unique

Legislative session identification number


LINK_TYPE   Integer · Unique

Denotes the type of the link


LINK_DESC   String (up to 255)

Unused


EFFECT_DT   Date (without time)

Date the link became active


DOMINATE_FILER   String (up to 1)

Unused


TERMINATION_DT   Date (without time)

Termination effective date


Archive

Download previous versions of this file from our archive.

Last 10 downloads

Date Records
April 17, 2019 299,838 Download »
April 16, 2019 299,757 Download »
April 15, 2019 299,695 Download »
April 14, 2019 299,695 Download »
April 13, 2019 299,664 Download »
April 12, 2019 299,638 Download »
April 11, 2019 299,592 Download »
April 9, 2019 299,498 Download »
April 8, 2019 299,450 Download »
April 7, 2019 299,450 Download »
More past downloads »

References

The documents that provided the information on this page.

  • CAL-ACCESS Tables, Columns and Indexes (p. 9, 67)