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 280,585 rows of data published on Tuesday, Oct. 17, 2017.

Download latest   22M 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
Oct. 17, 2017 280,585 Download »
Oct. 16, 2017 280,570 Download »
Oct. 15, 2017 280,570 Download »
Oct. 14, 2017 280,570 Download »
Oct. 13, 2017 280,565 Download »
Oct. 12, 2017 280,555 Download »
Oct. 11, 2017 280,533 Download »
Oct. 10, 2017 280,521 Download »
Oct. 9, 2017 280,512 Download »
Oct. 8, 2017 280,512 Download »
More past downloads »

References

The documents that provided the information on this page.

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