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 322,466 rows of data published on Sunday, June 20, 2021.

Download latest   25M 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 20, 2021 322,466 Download »
June 19, 2021 322,466 Download »
June 18, 2021 322,464 Download »
June 17, 2021 322,438 Download »
June 16, 2021 322,401 Download »
June 15, 2021 322,385 Download »
June 14, 2021 322,370 Download »
June 13, 2021 322,370 Download »
June 12, 2021 322,370 Download »
June 11, 2021 322,279 Download »
More past downloads »

References

The documents that provided the information on this page.

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