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 300,938 rows of data published on Tuesday, June 18, 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
June 18, 2019 300,938 Download »
June 17, 2019 300,917 Download »
June 16, 2019 300,917 Download »
June 15, 2019 300,917 Download »
June 14, 2019 300,898 Download »
June 13, 2019 300,881 Download »
June 12, 2019 300,861 Download »
June 11, 2019 300,827 Download »
June 10, 2019 300,781 Download »
June 9, 2019 300,781 Download »
More past downloads »

References

The documents that provided the information on this page.

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