Home

Filer ID: 1399192

Table: cvr_campaign_disclosure
filing_id   2205475   2264673   2305512   2312950   2311858   2309320   2309319   2309319   2309320   2312950   2333550   2321873   2413160   2329895   2334373   2316370   2321877   2334373   2388164   2321877   2431552   2455260   2454093   2431552   2458630   2480126   2450390   2507302   2507323   2550513   2506885   2504582   2519585   2515474   2506885   2506885   2512357   2598555   2641329   2672336   2686602   2728921   2704142   2725526   2741739   2725526   2743145   2731734   2732814   2741740   2740703   2740704   2731211   2732754   2732755   2732849   2741746   2741729   2745134   2741728   2741730   2751808   2751809   2732278   2731734   2731734   2736298   2736299   2741748   2751105   2751305   2745136   2745137
amend_id   0   0   0   0   0   1   0   1   0   1   0   0   0   0   1   0   0   0   0   1   0   0   0   1   0   0   0   0   0   0   2   0   0   0   1   0   0   0   0   0   0   0   0   0   0   1   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1   2   0   0   0   0   0   0   0
rec_type   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR
form_type   F460   F460   F497   F460   F497   F496   F496   F496   F496   F460   F497   F496   F497   F497   F460   F496   F496   F460   F460   F496   F460   F497   F460   F460   F496   F460   F496   F496   F496   F460   F496   F460   F460   F496   F496   F496   F496   F460   F460   F460   F460   F496   F460   F460   F496   F460   F460   F496   F496   F496   F496   F496   F496   F496   F496   F496   F496   F496   F496   F496   F496   F496   F496   F496   F496   F496   F496   F496   F496   F496   F496   F496   F496
filer_id   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192
entity_cd   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP
filer_naml   Building a Healthy Future for California Facilitated by Agricultural Council of California   Building a Healthy Future for California Facilitated by Agricultural Council of California   Building a Healthy Future for California Facilitated by Agricultural Council of California   Building a Healthy Future for California Facilitated by Agricultural Council of California   Building a Healthy Future for California Facilitated by Agricultural Council of California   Building a Healthy Future for California Facilitated by Agricultural Council of California   Building a Healthy Future for California Facilitated by Agricultural Council of California   Building a Healthy Future for California Facilitated by Agricultural Council of California   Building a Healthy Future for California Facilitated by Agricultural Council of California   Building a Healthy Future for California Facilitated by Agricultural Council of California, Sponsored by Land O'Lakes, Inc.   Building a Healthy Future for CA Facilitated by Agricultural Council of CA, Sprd by Land O'Lakes, Inc.   Building a Healthy Future for California Facilitated by Agricultural Council of California, Sponsored by Land O'Lakes, Inc.   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA, Sprd by Land O'Lakes, Inc.   Building a Healthy Future for CA Facilitated by Agricultural Council of CA, Sprd by Land O'Lakes, Inc.   Building a Healthy Future for California Facilitated by Agricultural Council of California, Sponsored by Land O'Lakes, Inc.   Building a Healthy Future for California Facilitated by Agricultural Council of California, Sponsored by Land O'Lakes, Inc.   Building a Healthy Future for CA Facilitated by Agricultural Council of CA, Sprd by Land O'Lakes, Inc.   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for California Facilitated by Agricultural Council of California, Sponsored by Land O'Lakes, Inc.   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Independent Expenditure Committee Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Independent Expenditure Committee Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Independent Expenditure Committee Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Independent Expenditure Committee Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Independent Expenditure Committee Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Independent Expenditure Committee Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA
filer_namf   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
filer_namt   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
filer_nams   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
report_num   000   000   000   000   000   001   000   001   000   001   000   000   000   000   001   000   000   000   000   001   000   000   000   001   000   000   000   000   000   000   002   000   000   000   001   000   000   000   000   000   000   000   000   000   000   001   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   001   002   000   000   000   000   000   000   000
rpt_date   2018-01-24 00:00:00   2018-07-11 00:00:00   2018-10-11 00:00:00   2018-10-25 00:00:00   2018-10-24 00:00:00   2018-10-24 00:00:00   2018-10-19 00:00:00   2018-10-19 00:00:00   2018-10-19 00:00:00   2018-10-26 00:00:00   2019-01-10 00:00:00   2018-10-31 00:00:00   2019-10-15 00:00:00   2018-12-27 00:00:00   2019-01-24 00:00:00   2018-10-29 00:00:00   2018-10-31 00:00:00   2019-01-10 00:00:00   2019-07-01 00:00:00   2018-11-02 00:00:00   2020-01-07 00:00:00   2020-02-20 00:00:00   2020-02-17 00:00:00   2020-02-19 00:00:00   2020-02-26 00:00:00   2020-07-01 00:00:00   2020-02-11 00:00:00   2020-09-30 00:00:00   2020-09-30 00:00:00   2021-01-04 00:00:00   2020-10-28 00:00:00   2020-09-23 00:00:00   2020-10-21 00:00:00   2020-10-14 00:00:00   2020-09-30 00:00:00   2020-09-29 00:00:00   2020-10-09 00:00:00   2021-07-06 00:00:00   2022-01-11 00:00:00   2022-04-25 00:00:00   2022-05-22 00:00:00   2022-10-05 00:00:00   2022-07-13 00:00:00   2022-09-26 00:00:00   2022-10-26 00:00:00   2022-10-25 00:00:00   2022-10-26 00:00:00   2022-10-12 00:00:00   2022-10-13 00:00:00   2022-10-26 00:00:00   2022-10-25 00:00:00   2022-10-25 00:00:00   2022-10-11 00:00:00   2022-10-13 00:00:00   2022-10-13 00:00:00   2022-10-13 00:00:00   2022-10-26 00:00:00   2022-10-26 00:00:00   2022-10-28 00:00:00   2022-10-26 00:00:00   2022-10-26 00:00:00   2022-11-03 00:00:00   2022-11-03 00:00:00   2022-10-12 00:00:00   2022-10-12 00:00:00   2022-10-13 00:00:00   2022-10-19 00:00:00   2022-10-19 00:00:00   2022-10-26 00:00:00   2022-11-02 00:00:00   2022-11-02 00:00:00   2022-10-28 00:00:00   2022-10-28 00:00:00
stmt_type   SA   SA   None   PE   None   None   None   None   None   PE   None   None   None   None   SA   None   None   SA   SA   None   SA   None   PE   SA   None   SA   None   None   None   SA   None   PE   PE   None   None   None   None   SA   SA   PE   PE   None   SA   PE   None   PE   PE   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
late_rptno   None   None   G18-1   None   G18-2   IE18-2   IE18-1   IE18-1   IE18-2   None   IE18-7   IE18-5   GE1105#1   IE18-6   None   IE18-3   IE18-4   None   None   IE18.4   None   P2020.2   None   None   PE332020#1   None   IE P2020.1   GE113:IE#3   ge113:IE#4   None   GE113:IE#1   None   None   GE113:IE#3   GE113:IE#1   GE113:IE#1   GE113:IE#2   None   None   None   None   IE.Ashby.1   None   None   LIE#5Bains   None   None   LIE#1Bains   LIE1Alanis   LIE5Perez   LIE#4perez   LIE#4bains   LIE#1Mei   LIE#2Bains   LIE#2Perez   LIE#1Bains   LIE#1Jones   LIE2Alanis   LIE#6Perez   LIE#1AG   LIE#1Self   LIE#7Bains   LIE#7Perez   LIE#1Perez   LIE#1Bains   LIE#1Bains   LIE#3Bains   LIE#3Perez   LIE#2AA   LIE#2AG   LIE#1DA   LIE#6Bains   G2022#2Mei
from_date   2017-01-01 00:00:00   2018-01-01 00:00:00   None   2018-07-01 00:00:00   None   None   None   None   None   2018-07-01 00:00:00   None   None   None   None   2018-10-21 00:00:00   None   None   2018-10-21 00:00:00   2019-01-01 00:00:00   None   2019-07-01 00:00:00   None   2020-01-01 00:00:00   2019-07-01 00:00:00   None   2020-02-16 00:00:00   None   None   None   2020-10-18 00:00:00   None   2020-07-01 00:00:00   2020-09-20 00:00:00   None   None   None   None   2021-01-01 00:00:00   2021-07-01 00:00:00   2022-01-01 00:00:00   2022-04-24 00:00:00   None   2022-05-22 00:00:00   2022-07-01 00:00:00   None   2022-07-01 00:00:00   2022-09-25 00:00:00   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
thru_date   2017-12-31 00:00:00   2018-06-30 00:00:00   None   2018-10-20 00:00:00   None   None   None   None   None   2018-10-20 00:00:00   None   None   None   None   2018-12-31 00:00:00   None   None   2018-12-31 00:00:00   2019-06-30 00:00:00   None   2019-12-31 00:00:00   None   2020-02-15 00:00:00   2019-12-31 00:00:00   None   2020-06-30 00:00:00   None   None   None   2020-12-31 00:00:00   None   2020-09-19 00:00:00   2020-10-17 00:00:00   None   None   None   None   2021-06-30 00:00:00   2021-12-31 00:00:00   2022-04-23 00:00:00   2022-05-21 00:00:00   None   2022-06-30 00:00:00   2022-09-24 00:00:00   None   2022-09-24 00:00:00   2022-10-22 00:00:00   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
elect_date   None   None   None   2018-11-06 00:00:00   None   None   None   None   None   2018-11-06 00:00:00   None   None   None   None   None   None   None   None   None   None   None   None   2020-03-03 00:00:00   None   None   None   None   None   None   None   None   2020-11-03 00:00:00   2020-11-03 00:00:00   None   None   None   None   None   None   2022-06-07 00:00:00   2022-06-07 00:00:00   None   None   2022-11-08 00:00:00   None   2022-11-08 00:00:00   2022-11-08 00:00:00   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
filer_city   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento
filer_st   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA
filer_zip4   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814
filer_phon   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887   916-443-4887
filer_fax   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
file_email   [email protected] 368000   [email protected] 368000   [email protected] 368000   [email protected] 368000   [email protected] 368000   [email protected] 368000   [email protected] 368000   [email protected] 368000   [email protected] 368000   [email protected] 368000   [email protected]/3680ssb   [email protected] 368000   [email protected]/3680ssb   [email protected]/3680ssb   [email protected]/3680ssb   [email protected] 368000   [email protected] 368000   [email protected]/3680ssb   [email protected]/3680ssb   [email protected] 368000   [email protected]/3680ssb   [email protected]/3680ssb   [email protected]/3680ssb   [email protected]/3680ssb   [email protected]/3680ssb   [email protected]/3680ssb   [email protected]/3680ssb   [email protected]/3680ssb   [email protected]/3680ssb   [email protected]/3680ssb   [email protected]/3680ssb   [email protected]/3680ssb   [email protected]/3680ssb   [email protected]/3680ssb   [email protected]/3680ssb   [email protected]/3680ssb   [email protected]/3680ssb   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]
mail_city   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento
mail_st   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA
mail_zip4   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814
tres_naml   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Titus   Titus   Titus   Titus   Titus   Titus   Titus   Titus   Titus   Titus   Titus   Titus   Titus   Titus   Titus   Titus   Titus   Titus   Titus   Titus   Titus   Titus   Titus   Titus   Titus   Titus   Titus   Titus   Titus   Titus   Titus   Titus   Titus   Titus   Titus   Titus
tres_namf   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee   Ashlee
tres_namt   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
tres_nams   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
tres_city   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento
tres_st   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA
tres_zip4   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814
tres_phon   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757   916-442-7757
tres_fax   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
tres_email   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cmtte_type   G   G   None   G   None   None   None   None   None   G   None   None   None   None   G   None   None   G   G   None   G   None   G   G   None   G   None   None   None   G   None   G   G   None   None   None   None   G   G   G   G   None   G   G   None   G   G   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
control_yn   N   N   None   N   None   None   None   None   None   N   None   None   None   None   N   None   None   N   N   None   N   None   N   N   None   N   None   None   None   N   None   N   N   None   None   None   None   N   Y   Y   Y   None   Y   Y   None   Y   Y   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
sponsor_yn   N   N   None   N   None   None   None   None   None   N   None   None   None   None   N   None   None   N   N   None   N   None   N   N   None   N   None   None   None   N   None   N   N   None   None   None   None   N   N   N   N   None   N   N   None   N   N   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
primfrm_yn   N   N   None   N   None   None   None   None   None   N   None   None   None   None   N   None   None   N   N   None   N   None   N   N   None   N   None   None   None   N   None   N   N   None   None   None   None   N   N   N   N   None   N   N   None   N   N   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
brdbase_yn   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
amendexp_1   None   None   None   None   None   Amending to change candidate from Supporrting Susan to Opposing Mike Eng.   None   Amending date of independent expenditure.   None   Amending name of committee.   None   None   None   None   Amending to include additional contributions received   None   None   None   None   Amending to correct Section 1 to reflect Oppose   None   None   None   Amending to include accrued expense received after reporting period.   None   None   None   None   None   None   Amending to change the description of the Independent Expenditure   None   None   None   Amending to change the description of the Independent Expenditure   None   None   None   None   None   None   None   None   None   None   Amending to add an accrued expense   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   Amending to update expenditure amount   Update expenditure amount and contribution received   None   None   None   None   None   None   None
amendexp_2   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
amendexp_3   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
rpt_att_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cmtte_id   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
reportname   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
rptfromdt   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
rptthrudt   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
emplbus_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bus_name   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bus_city   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bus_st   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bus_zip4   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bus_inter   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
busact_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
busactvity   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
assoc_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
assoc_int   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
other_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
other_int   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_naml   None   None   None   None   None   Michael Eng   Dante Acosta   Dante Acosta   Susan Rubio   None   None   Dante Acosta   None   None   None   Christy Smith   Christy Smith   None   None   Christy Smith   None   None   None   None   Steve Glazer   None   Susan Eggman   Jordan Cunningham   Jordan Cunningham   None   Chad Mayes   None   None   Scott Wilk   Chad Mayes   Chad Mayes   Chad Mayes   None   None   None   None   Angelique Ashby   None   None   Jasmeet Bains   None   None   Jasmeet Bains   Juan Alanis   Leticia Perez   Leticia Perez   Jasmeet Bains   Lily Mei   Jasmeet Bains   Leticia Perez   Jasmeet Bains   Dave Jones   Juan Alanis   Leticia Perez   Marie Alvarado-Gil   Jessica Self   Jasmeet Bains   Leticia Perez   Leticia Perez   Jasmeet Bains   Jasmeet Bains   Jasmeet Bains   Leticia Perez   Angelique Ashby   Marie Alvarado-Gil   David Alvarez   Jasmeet Bains   Lily Mei
cand_namf   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_namt   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_nams   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_city   None   None   None   None   None   Los Angeles   San Diego   San Diego   Sacramento   None   None   San Diego   None   None   None   Valencia   Valencia   None   None   Valencia   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_st   None   None   None   None   None   CA   CA   CA   CA   None   None   CA   None   None   None   CA   CA   None   None   CA   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_zip4   None   None   None   None   None   90048   92119   92119   95814   None   None   92119   None   None   None   91355   91355   None   None   91355   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_phon   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_fax   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_email   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bal_name   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bal_num   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bal_juris   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
office_cd   None   None   None   None   None   SEN   ASM   ASM   SEN   None   None   ASM   None   None   None   ASM   ASM   None   None   ASM   None   None   None   None   SEN   None   SEN   ASM   ASM   None   ASM   None   None   SEN   ASM   ASM   ASM   None   None   None   OTH   SEN   OTH   OTH   ASM   OTH   OTH   ASM   ASM   ASM   ASM   ASM   SEN   ASM   ASM   ASM   SEN   ASM   ASM   SEN   ASM   ASM   ASM   ASM   ASM   ASM   ASM   ASM   SEN   SEN   ASM   ASM   SEN
offic_dscr   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
juris_cd   None   None   None   None   None   SEN   ASM   ASM   SEN   None   None   ASM   None   None   None   ASM   ASM   None   None   ASM   None   None   None   None   SEN   None   SEN   ASM   ASM   None   ASM   None   None   SEN   ASM   ASM   ASM   None   None   None   STW   SEN   STW   STW   ASM   STW   STW   ASM   ASM   ASM   ASM   ASM   SEN   ASM   ASM   ASM   SEN   ASM   ASM   SEN   ASM   ASM   ASM   ASM   ASM   ASM   ASM   ASM   SEN   SEN   ASM   ASM   SEN
juris_dscr   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
dist_no   None   None   None   None   None   22   38   38   22   None   None   38   None   None   None   38   38   None   None   38   None   None   None   None   07   None   05   35   35   None   42   None   None   21   42   42   42   None   None   None   None   08   None   None   35   None   None   35   22   35   35   35   10   35   35   35   08   22   35   04   22   35   35   35   35   35   35   35   08   04   80   35   10
off_s_h_cd   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
sup_opp_cd   None   None   None   None   None   O   S   S   S   None   None   S   None   None   None   O   S   None   None   O   None   None   None   None   S   None   S   S   S   None   O   None   None   S   S   S   S   None   None   None   None   S   None   None   S   None   None   S   S   O   O   S   S   S   O   S   O   S   O   S   O   S   O   O   S   S   S   O   S   S   S   S   S
employer   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
occupation   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
selfemp_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bal_id   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_id   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
Table: cvr_so
filing_id   2196527   2196527   2196527   2196527   2196527   2196527   2196527   2196527   2196527   2196527   2196527
amend_id   1   0   2   4   3   5   6   7   10   9   8
rec_type   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR
form_type   F410   F410   F410   F410   F410   F410   F410   F410   F410   F410   F410
filer_id   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192
entity_cd   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP
filer_naml   Building a Healthy Future for California Facilitated by Agricultural Council of California   Building a Healthy Future for California Facilitated by Agricultural Council of California   Building a Healthy Future for California Facilitated by Agricultural Council of California   Building a Healthy Future for CA Facilitated by Agricultural Council of CA, Sprd by Land O'Lakes, Inc.   Building a Healthy Future for California Facilitated by Agricultural Council of California, Sponsored by Land O'Lakes, Inc.   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Independent Expenditure Committee Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Independent Expenditure Committee Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA   Building a Healthy Future for CA Facilitated by Agricultural Council of CA
filer_namf   None   None   None   None   None   None   None   None   None   None   None
filer_namt   None   None   None   None   None   None   None   None   None   None   None
filer_nams   None   None   None   None   None   None   None   None   None   None   None
report_num   001   000   002   004   003   005   006   007   010   009   008
rpt_date   2017-11-20 00:00:00   2017-09-26 00:00:00   2018-01-24 00:00:00   2018-12-14 00:00:00   2018-10-26 00:00:00   2019-06-26 00:00:00   2020-02-17 00:00:00   2020-07-01 00:00:00   2021-11-01 00:00:00   2021-06-04 00:00:00   2020-09-24 00:00:00
qual_cb   None   None   None   X   None   X   X   X   X   X   X
qualfy_dt   None   None   None   2018-06-21 00:00:00   None   2018-06-21 00:00:00   2018-06-21 00:00:00   2018-06-21 00:00:00   2018-06-21 00:00:00   2018-06-21 00:00:00   2018-06-21 00:00:00
term_date   None   None   None   None   None   None   None   None   None   None   None
city   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento
st   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA
zip4   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814
phone   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   916-443-4887   916-443-4887   (916) 442-2280
county_res   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento
county_act   Statewide   Statewide   Statewide   Statewide   Statewide   Statewide   Statewide   Statewide   Statewide   Statewide   Statewide
mail_city   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento
mail_st   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA
mail_zip4   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814
cmte_fax   None   None   None   None   None   None   None   None   None   None   None
cmte_email   [email protected] 368000   [email protected] 368000   [email protected] 368000   [email protected]/3680ssb   [email protected] 368000   [email protected]/3680ssb   [email protected]/3680ssb   [email protected]/3680ssb   [email protected]   [email protected]   [email protected]/3680ssb
tres_naml   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Eichman   Titus   Titus   Eichman
tres_namf   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   J. Richard   Ashlee   Ashlee   J. Richard
tres_namt   None   None   None   None   None   None   None   None   None   None   None
tres_nams   None   None   None   None   None   None   None   None   None   None   None
tres_city   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento
tres_st   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA
tres_zip4   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814
tres_phon   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   (916) 442-2280   916-442-7757   916-442-7757   (916) 442-2280
actvty_lvl   ST   ST   ST   ST   ST   ST   ST   ST   ST   ST   ST
com82013yn   None   None   None   None   None   None   None   None   None   None   None
com82013nm   None   None   None   None   None   None   None   None   None   None   None
com82013id   None   None   None   None   None   None   None   None   None   None   None
control_cb   None   None   None   None   None   None   None   None   None   None   None
bank_nam   Wells Fargo Bank, N.A.   Wells Fargo Bank, N.A.   None   Wells Fargo Bank, N.A.   Wells Fargo Bank, N.A.   Wells Fargo Bank, N.A.   Wells Fargo Bank, N.A.   F & M BANK   California Bank & Trust   F & M BANK   F & M BANK
bank_adr1   400 Capitol Mall   400 Capitol Mall   None   400 Capitol Mall   400 Capitol Mall   400 Capitol Mall   400 Capitol Mall   CAPITOL OFFICE, 1303 J STREET   550 S. Hope Street   CAPITOL OFFICE, 1303 J STREET   CAPITOL OFFICE, 1303 J STREET
bank_adr2   None   None   None   None   None   None   None   None   None   None   None
bank_city   Sacramento   Sacramento   None   Sacramento   Sacramento   Sacramento   Sacramento   SACRAMENTO   Los Angeles   SACRAMENTO   SACRAMENTO
bank_st   CA   CA   None   CA   CA   CA   CA   CA   CA   CA   CA
bank_zip4   95814   95814   None   95814   95814   95814   95814   95814   90071   95814   95814
bank_phon   (916) 440-4331   (916) 440-4331   None   (916) 440-4331   (916) 440-4331   (916) 440-4331   (916) 440-4331   (800) 888-1498   213-228-1700   (800) 888-1498   (800) 888-1498
acct_opendt   None   None   None   None   None   None   None   None   None   None   None
surplusdsp   None   None   None   None   None   None   None   None   None   None   None
primfc_cb   None   None   None   None   None   None   None   None   None   None   None
genpurp_cb   X   X   X   X   X   X   X   X   X   X   X
gpc_descr   This committee expects to make independent expenditures to support or oppose numerous candidates, each of whom will be listed in the committee's campaign statements, filed pursuant to Government Code Section 84200, et seq.   This committee expects to make independent expenditures to support or oppose numerous candidates, each of whom will be listed in the committee's campaign statements, filed pursuant to Government Code Section 84200, et seq.   This committee expects to make independent expenditures to support or oppose numerous candidates, each of whom will be listed in the committee's campaign statements, filed pursuant to Government Code Section 84200, et seq.   This committee expects to make independent expenditures to support or oppose numerous candidates, each of whom will be listed in the committee's campaign statements, filed pursuant to Government Code Section 84200, et seq.   This committee expects to make independent expenditures to support or oppose numerous candidates, each of whom will be listed in the committee's campaign statements, filed pursuant to Government Code Section 84200, et seq.   This committee expects to make independent expenditures to support or oppose numerous candidates, each of whom will be listed in the committee's campaign statements, filed pursuant to Government Code Section 84200, et seq.   This committee expects to make independent expenditures to support or oppose numerous candidates and ballot measures, each of whom will be listed in the committee's campaign statements, filed pursuant to Government Code Section 84200, et seq.   This committee expects to make independent expenditures to support or oppose numerous candidates and ballot measures, each of whom will be listed in the committee's campaign statements, filed pursuant to Government Code Section 84200, et seq.   This committee expects to make independent expenditures to support or oppose numerous candidates and ballot measures, each of whom will be listed in the committee's campaign statements, filed pursuant to Government Code Section 84200, et seq.   This committee expects to make independent expenditures to support or oppose numerous candidates and ballot measures, each of whom will be listed in the committee's campaign statements, filed pursuant to Government Code Section 84200, et seq.   This committee expects to make independent expenditures to support or oppose numerous candidates and ballot measures, each of whom will be listed in the committee's campaign statements, filed pursuant to Government Code Section 84200, et seq.
sponsor_cb   None   None   None   None   None   None   None   None   None   None   None
brdbase_cb   None   None   None   None   None   None   None   None   None   None   None
smcont_qualdt   None   None   None   None   None   None   None   None   None   None   None
Table: filer_address
filer_id   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192
adrid   2473504   2473505   2473792   2494600   2494599   2440125   2440126   2519301   2519302
effect_dt   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2020-02-19 00:00:00   2020-07-06 00:00:00   2017-09-26 00:00:00   2017-09-26 00:00:00   2021-06-07 00:00:00   2021-06-07 00:00:00
add_type   7051   7082   7082   7082   7051   7051   7082   7051   7082
session_id   2017   2017   2017   2019   2019   2017   2017   2021   2021
Table: filer_filings
filer_id   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192
filing_id   2196527   2489859   2455260   2212657   2197061   2322471   2334373   2196527   2205475   2309320   2196527   2506885   2265920   2334373   2312950   2185460   2333550   2315013   2196527   2450390   2431552   2196527   2454093   2196527   2456132   2309319   2309319   2321877   2439860   2311858   2309320   2519585   2507302   2507323   2462751   2321873   2264673   2328788   2506885   2196527   2512357   2489102   2316370   2321877   2439860   2315013   2533738   2388164   2394760   2305512   2312950   2355471   2196527   2413160   2396357   2355471   2214989   2534146   2431552   2329895   2458630   2598555   2196527   2686602   2504582   2196527   2480126   2655579   2515474   2506885   2692065   2513990   2196527   2704142   2575187   2550513   2641329   2680201   2617127   2587164   2725266   2672336   2627390   2731734   2741729   2725526   2728921   2745136   2745137   2741739   2725526   2743145   2732814   2741740   2741746   2745134   2736298   2736299   2731211   2732754   2751105   2751305   2751808   2751809   2741748   2740703   2740704   2732755   2732849   2741728   2741730   2743291   2732278   2731734   2731734
period_id   236   None   241   None   None   None   236   233   229   236   241   244   None   236   235   None   237   None   232   241   239   231   241   236   None   236   236   236   None   236   236   243   243   243   None   236   233   None   243   238   244   None   236   236   None   None   None   237   None   236   235   None   246   240   None   None   None   None   239   236   241   245   248   250   243   243   241   None   244   243   None   None   243   250   None   244   247   None   None   None   None   249   None   252   252   251   252   252   252   252   251   251   252   252   252   252   252   252   252   252   252   252   252   252   252   252   252   252   252   252   252   None   252   252   252
form_id   F410   F460   F497   F410   F410   F410   F460   F410   F460   F496   F410   F496   F460   F460   F460   F410   F497   F460   F410   F496   F460   F410   F460   F410   F460   F496   F496   F496   F460   F497   F496   F460   F496   F496   F410   F496   F460   F410   F496   F410   F496   F410   F496   F496   F460   F460   F460   F460   F460   F497   F460   F460   F410   F497   F410   F460   F460   F460   F460   F497   F496   F460   F410   F460   F460   F410   F460   F460   F496   F496   F460   F410   F410   F460   F460   F460   F460   F460   F460   F410   F460   F460   F410   F496   F496   F460   F496   F496   F496   F496   F460   F460   F496   F496   F496   F496   F496   F496   F496   F496   F496   F496   F496   F496   F496   F496   F496   F496   F496   F496   F496   F460   F496   F496   F496
filing_sequence   4   0   0   0   0   0   1   2   0   0   6   2   0   0   0   0   0   1   1   0   0   0   0   3   0   0   1   1   0   0   1   0   0   0   0   0   0   0   1   5   0   0   0   0   1   0   0   0   0   0   1   0   9   0   0   1   0   0   1   0   0   0   10   0   0   7   0   0   0   0   0   0   8   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1   2
filing_date   2018-12-14 00:00:00   2020-07-27 00:00:00   2020-02-20 00:00:00   2018-01-26 00:00:00   2017-11-21 00:00:00   2018-10-26 00:00:00   2019-01-28 00:00:00   2018-01-25 00:00:00   2018-01-25 00:00:00   2018-10-19 00:00:00   2020-02-19 00:00:00   2020-10-28 00:00:00   2018-07-17 00:00:00   2019-01-15 00:00:00   2018-10-25 00:00:00   2017-09-26 00:00:00   2019-01-10 00:00:00   2018-10-26 00:00:00   2017-11-20 00:00:00   2020-02-11 00:00:00   2020-01-17 00:00:00   2017-11-20 00:00:00   2020-02-19 00:00:00   2018-10-26 00:00:00   2020-02-19 00:00:00   2018-10-19 00:00:00   2018-10-19 00:00:00   2018-11-02 00:00:00   2020-01-21 00:00:00   2018-10-24 00:00:00   2018-10-24 00:00:00   2020-10-21 00:00:00   2020-09-30 00:00:00   2020-09-30 00:00:00   2020-02-19 00:00:00   2018-11-01 00:00:00   2018-07-13 00:00:00   2018-12-17 00:00:00   2020-09-30 00:00:00   2019-07-01 00:00:00   2020-10-09 00:00:00   2020-07-28 00:00:00   2018-10-29 00:00:00   2018-11-01 00:00:00   2020-02-19 00:00:00   2018-10-25 00:00:00   2020-09-24 00:00:00   2019-07-01 00:00:00   2019-07-03 00:00:00   2018-10-11 00:00:00   2018-10-26 00:00:00   2019-01-16 00:00:00   2021-06-04 00:00:00   2019-10-15 00:00:00   2019-07-26 00:00:00   2019-01-29 00:00:00   2018-01-26 00:00:00   2020-10-22 00:00:00   2020-02-19 00:00:00   2018-12-27 00:00:00   2020-02-26 00:00:00   2021-07-28 00:00:00   2021-11-03 00:00:00   2022-05-26 00:00:00   2020-09-23 00:00:00   2020-07-23 00:00:00   2020-07-23 00:00:00   2022-01-28 00:00:00   2020-10-14 00:00:00   2020-09-29 00:00:00   2022-05-26 00:00:00   2020-09-24 00:00:00   2020-09-24 00:00:00   2022-07-29 00:00:00   2021-01-29 00:00:00   2021-01-29 00:00:00   2022-01-28 00:00:00   2022-04-28 00:00:00   2021-07-30 00:00:00   2021-06-07 00:00:00   2022-07-29 00:00:00   2022-04-28 00:00:00   2021-11-05 00:00:00   2022-10-12 00:00:00   2022-10-26 00:00:00   2022-09-29 00:00:00   2022-10-05 00:00:00   2022-10-28 00:00:00   2022-10-28 00:00:00   2022-10-26 00:00:00   2022-10-27 00:00:00   2022-10-27 00:00:00   2022-10-13 00:00:00   2022-10-26 00:00:00   2022-10-26 00:00:00   2022-10-28 00:00:00   2022-10-19 00:00:00   2022-10-19 00:00:00   2022-10-11 00:00:00   2022-10-13 00:00:00   2022-11-02 00:00:00   2022-11-02 00:00:00   2022-11-03 00:00:00   2022-11-03 00:00:00   2022-10-26 00:00:00   2022-10-25 00:00:00   2022-10-25 00:00:00   2022-10-13 00:00:00   2022-10-13 00:00:00   2022-10-26 00:00:00   2022-10-26 00:00:00   2022-09-29 00:00:00   2022-10-12 00:00:00   2022-10-12 00:00:00   2022-10-13 00:00:00
stmnt_type   10002   10005   10001   10006   10006   10006   10002   10002   10001   10001   10002   10002   10005   10001   10001   10005   10001   10002   10002   10001   10001   10001   10001   10002   10005   10001   10002   10002   10005   10001   10002   10001   10001   10001   10006   10001   10001   10006   10002   10002   10001   10006   10001   10001   10006   10005   10005   10001   10005   10001   10002   10005   10002   10001   10006   10006   10005   10005   10002   10001   10001   10001   10002   10001   10001   10002   10001   10005   10001   10001   10005   10006   10002   10001   10005   10001   10001   10005   10005   10006   10005   10001   10006   10001   10001   10001   10001   10001   10001   10001   10002   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10005   10001   10002   10002
stmnt_status   11001   11001   11003   11001   11001   11001   11003   11001   11001   11003   11003   11003   11001   11001   11001   11001   11001   11003   11001   11003   11001   11003   11001   11001   11001   11003   11003   11003   11001   11003   11003   11001   11001   11001   11001   11003   11001   11001   11003   11001   11003   11001   11003   11003   11003   11001   11001   11001   11001   11003   11003   11001   11003   11003   11001   11003   11001   11001   11003   11001   11003   11001   11003   11003   11001   11003   11001   11001   11003   11003   11003   11001   11003   11003   11001   11001   11001   11001   11001   11001   11003   11001   11001   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003
session_id   2017   2019   2019   2017   2017   2017   2017   2017   2017   2017   2019   2019   2017   2017   2017   2017   2019   2017   2017   2019   2019   2017   2019   2017   2019   2017   2017   2017   2019   2017   2017   2019   2019   2019   2019   2017   2017   2017   2019   2019   2019   2019   2017   2017   2019   2017   2019   2019   2019   2017   2017   2017   2021   2019   2019   2017   2017   2019   2019   2017   2019   2021   2021   2021   2019   2019   2019   2021   2019   2019   2021   2019   2019   2021   2019   2019   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021
user_id   JFRONEFIELD   IMEDINA   CAFILER   TRAMON   TRAMON   TRAMON   CAFILER   TRAMON   CSAGABAEN   CAFILER   CAFILER   CAFILER   YRODRIGU   LPHEAV   HSTOVALL   CPON   RGEREMIA   LBARTHOL   TRAMON   CAFILER   VUKSTINA   CAFILER   SUSHAKOV   TRAMON   SUSHAKOV   CAFILER   CAFILER   CAFILER   VUKSTINA   CAFILER   CAFILER   IMEDINA   RGEREMIA   RGEREMIA   LPALMER   CAFILER   YRODRIGU   JFRONEFIELD   CAFILER   TRAMON   CAFILER   KWHELAN   CAFILER   CAFILER   VUKSTINA   HSTOVALL   IMEDINA   HCOURSEY   HCOURSEY   CAFILER   CAFILER   LPHEAV   CAFILER   CAFILER   TRAMON   CSAGABAEN   CSAGABAEN   IMEDINA   CAFILER   RGEREMIA   CAFILER   DCODY   CAFILER   CAFILER   IMEDINA   CAFILER   IMEDINA   KRUSSELL   CAFILER   CAFILER   JMAVES   JINCE   CAFILER   CAFILER   BCOLON   BCOLON   KRUSSELL   KRUSSELL   DCODY   IMEDINA   JMAVES   KRUSSELL   IMEDINA   CAFILER   CAFILER   CAFILER   CAFILER   CAFILER   CAFILER   CAFILER   CAFILER   CAFILER   CAFILER   CAFILER   CAFILER   CAFILER   CAFILER   CAFILER   CAFILER   CAFILER   CAFILER   CAFILER   CAFILER   CAFILER   CAFILER   CAFILER   CAFILER   CAFILER   CAFILER   CAFILER   CAFILER   LPHEAV   CAFILER   CAFILER   CAFILER
special_audit   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003
fine_audit   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11001   11001   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11001   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003
rpt_start   2018-12-14 00:00:00   2020-02-16 00:00:00   2020-02-20 00:00:00   None   None   None   2018-10-21 00:00:00   2018-01-24 00:00:00   2017-01-01 00:00:00   2018-10-19 00:00:00   2020-02-17 00:00:00   2020-10-28 00:00:00   2018-01-01 00:00:00   2018-10-21 00:00:00   2018-07-01 00:00:00   None   2019-01-10 00:00:00   2018-07-01 00:00:00   2017-11-20 00:00:00   2020-02-11 00:00:00   2019-07-01 00:00:00   2017-09-26 00:00:00   2020-01-01 00:00:00   2018-10-26 00:00:00   2020-01-01 00:00:00   2018-10-19 00:00:00   2018-10-19 00:00:00   2018-11-02 00:00:00   2019-07-01 00:00:00   2018-10-24 00:00:00   2018-10-24 00:00:00   2020-09-20 00:00:00   2020-09-30 00:00:00   2020-09-30 00:00:00   None   2018-10-31 00:00:00   2018-01-01 00:00:00   None   2020-09-30 00:00:00   2019-06-26 00:00:00   2020-10-09 00:00:00   None   2018-10-29 00:00:00   2018-10-31 00:00:00   2019-07-01 00:00:00   2018-07-01 00:00:00   2020-07-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2018-10-11 00:00:00   2018-07-01 00:00:00   2018-10-21 00:00:00   2021-06-04 00:00:00   2019-10-15 00:00:00   None   2018-10-21 00:00:00   2017-01-01 00:00:00   2020-09-20 00:00:00   2019-07-01 00:00:00   2018-12-27 00:00:00   2020-02-26 00:00:00   2021-01-01 00:00:00   2021-11-01 00:00:00   2022-04-24 00:00:00   2020-07-01 00:00:00   2020-07-01 00:00:00   2020-02-16 00:00:00   2021-07-01 00:00:00   2020-10-14 00:00:00   2020-09-29 00:00:00   2022-04-24 00:00:00   None   2020-09-24 00:00:00   2022-05-22 00:00:00   2020-10-18 00:00:00   2020-10-18 00:00:00   2021-07-01 00:00:00   2022-01-01 00:00:00   2021-01-01 00:00:00   None   2022-05-22 00:00:00   2022-01-01 00:00:00   None   2022-10-12 00:00:00   2022-10-26 00:00:00   2022-07-01 00:00:00   2022-10-05 00:00:00   2022-10-28 00:00:00   2022-10-28 00:00:00   2022-10-26 00:00:00   2022-07-01 00:00:00   2022-09-25 00:00:00   2022-10-13 00:00:00   2022-10-26 00:00:00   2022-10-26 00:00:00   2022-10-28 00:00:00   2022-10-19 00:00:00   2022-10-19 00:00:00   2022-10-11 00:00:00   2022-10-13 00:00:00   2022-11-02 00:00:00   2022-11-02 00:00:00   2022-11-03 00:00:00   2022-11-03 00:00:00   2022-10-26 00:00:00   2022-10-25 00:00:00   2022-10-25 00:00:00   2022-10-13 00:00:00   2022-10-13 00:00:00   2022-10-26 00:00:00   2022-10-26 00:00:00   2022-07-01 00:00:00   2022-10-12 00:00:00   2022-10-12 00:00:00   2022-10-13 00:00:00
rpt_end   2018-12-14 00:00:00   2020-06-30 00:00:00   2020-02-20 00:00:00   None   None   None   2018-12-31 00:00:00   2018-01-24 00:00:00   2017-12-31 00:00:00   2018-10-19 00:00:00   2020-02-17 00:00:00   2020-10-28 00:00:00   2018-06-30 00:00:00   2018-12-31 00:00:00   2018-10-20 00:00:00   None   2019-01-10 00:00:00   2018-10-20 00:00:00   2017-11-20 00:00:00   2020-02-11 00:00:00   2019-12-31 00:00:00   2017-09-26 00:00:00   2020-02-15 00:00:00   2018-10-26 00:00:00   2020-02-15 00:00:00   2018-10-19 00:00:00   2018-10-19 00:00:00   2018-11-02 00:00:00   2019-12-31 00:00:00   2018-10-24 00:00:00   2018-10-24 00:00:00   2020-10-17 00:00:00   2020-09-30 00:00:00   2020-09-30 00:00:00   None   2018-10-31 00:00:00   2018-06-30 00:00:00   None   2020-09-30 00:00:00   2019-06-26 00:00:00   2020-10-09 00:00:00   None   2018-10-29 00:00:00   2018-10-31 00:00:00   2019-12-31 00:00:00   2018-10-20 00:00:00   2020-09-19 00:00:00   2019-06-30 00:00:00   2019-06-30 00:00:00   2018-10-11 00:00:00   2018-10-20 00:00:00   2018-12-31 00:00:00   2021-06-04 00:00:00   2019-10-15 00:00:00   None   2018-12-31 00:00:00   2017-12-31 00:00:00   2020-10-17 00:00:00   2019-12-31 00:00:00   2018-12-27 00:00:00   2020-02-26 00:00:00   2021-06-30 00:00:00   2021-11-01 00:00:00   2022-05-21 00:00:00   2020-09-19 00:00:00   2020-07-01 00:00:00   2020-06-30 00:00:00   2021-12-31 00:00:00   2020-10-14 00:00:00   2020-09-29 00:00:00   2022-05-21 00:00:00   None   2020-09-24 00:00:00   2022-06-30 00:00:00   2020-12-31 00:00:00   2020-12-31 00:00:00   2021-12-31 00:00:00   2022-04-23 00:00:00   2021-06-30 00:00:00   None   2022-06-30 00:00:00   2022-04-23 00:00:00   None   2022-10-12 00:00:00   2022-10-26 00:00:00   2022-09-24 00:00:00   2022-10-05 00:00:00   2022-10-28 00:00:00   2022-10-28 00:00:00   2022-10-26 00:00:00   2022-09-24 00:00:00   2022-10-22 00:00:00   2022-10-13 00:00:00   2022-10-26 00:00:00   2022-10-26 00:00:00   2022-10-28 00:00:00   2022-10-19 00:00:00   2022-10-19 00:00:00   2022-10-11 00:00:00   2022-10-13 00:00:00   2022-11-02 00:00:00   2022-11-02 00:00:00   2022-11-03 00:00:00   2022-11-03 00:00:00   2022-10-26 00:00:00   2022-10-25 00:00:00   2022-10-25 00:00:00   2022-10-13 00:00:00   2022-10-13 00:00:00   2022-10-26 00:00:00   2022-10-26 00:00:00   2022-09-24 00:00:00   2022-10-12 00:00:00   2022-10-12 00:00:00   2022-10-13 00:00:00
rpt_date   None   None   2020-02-20 00:00:00   None   None   None   2019-01-24 00:00:00   None   2018-01-24 00:00:00   2018-10-19 00:00:00   None   2020-10-28 00:00:00   None   2019-01-10 00:00:00   2018-10-25 00:00:00   None   2019-01-10 00:00:00   None   None   2020-02-11 00:00:00   2020-01-07 00:00:00   None   2020-02-17 00:00:00   None   None   2018-10-19 00:00:00   2018-10-19 00:00:00   2018-11-02 00:00:00   None   2018-10-24 00:00:00   2018-10-24 00:00:00   2020-10-21 00:00:00   2020-09-30 00:00:00   2020-09-30 00:00:00   None   2018-10-31 00:00:00   2018-07-11 00:00:00   None   2020-09-30 00:00:00   None   2020-10-09 00:00:00   None   2018-10-29 00:00:00   2018-10-31 00:00:00   None   None   None   2019-07-01 00:00:00   None   2018-10-11 00:00:00   2018-10-26 00:00:00   None   None   2019-10-15 00:00:00   None   None   None   None   2020-02-19 00:00:00   2018-12-27 00:00:00   2020-02-26 00:00:00   2021-07-06 00:00:00   None   2022-05-22 00:00:00   2020-09-23 00:00:00   None   2020-07-01 00:00:00   None   2020-10-14 00:00:00   2020-09-29 00:00:00   None   None   None   2022-07-13 00:00:00   None   2021-01-04 00:00:00   2022-01-11 00:00:00   None   None   None   None   2022-04-25 00:00:00   None   2022-10-12 00:00:00   2022-10-26 00:00:00   2022-09-26 00:00:00   2022-10-05 00:00:00   2022-10-28 00:00:00   2022-10-28 00:00:00   2022-10-26 00:00:00   2022-10-25 00:00:00   2022-10-26 00:00:00   2022-10-13 00:00:00   2022-10-26 00:00:00   2022-10-26 00:00:00   2022-10-28 00:00:00   2022-10-19 00:00:00   2022-10-19 00:00:00   2022-10-11 00:00:00   2022-10-13 00:00:00   2022-11-02 00:00:00   2022-11-02 00:00:00   2022-11-03 00:00:00   2022-11-03 00:00:00   2022-10-26 00:00:00   2022-10-25 00:00:00   2022-10-25 00:00:00   2022-10-13 00:00:00   2022-10-13 00:00:00   2022-10-26 00:00:00   2022-10-26 00:00:00   None   2022-10-12 00:00:00   2022-10-12 00:00:00   2022-10-13 00:00:00
filing_type   22001   None   22001   None   None   None   22001   22001   22001   22001   22001   22001   None   22001   22001   None   22001   None   22001   22001   22001   22001   22001   22001   None   22001   22001   22001   None   22001   22001   22001   22001   22001   None   22001   22001   None   22001   22001   22001   None   22001   22001   None   None   None   22001   None   22001   22001   None   22001   22001   None   None   None   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   None   22001   22001   None   None   22001   22001   None   22001   22001   None   None   None   None   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   None   22001   22001   22001
Table: filer_to_filer_type
filer_id   1399192   1399192   1399192
filer_type   16   16   16
active   Y   Y   Y
race   0   0   0
session_id   2017   2017   2017
category   0   0   0
category_type   40502   40502   40502
sub_category   40103   40103   40103
effect_dt   2017-11-21 00:00:00   2017-09-26 00:00:00   2018-12-17 00:00:00
sub_category_type   0   0   0
election_type   0   0   0
sub_category_a   S   None   S
nyq_dt   None   None   2018-06-21 00:00:00
party_cd   0   0   0
county_cd   18004   18004   18004
district_cd   0   0   0
Table: filer_xref
filer_id   1399192
xref_id   1399192
effect_dt   2017-09-26 00:00:00
migration_source   CLAIMS
Table: filername
xref_filer_id   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192
filer_id   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192
filer_type   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE
status   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE   ACTIVE
effect_dt   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00   2018-12-17 00:00:00
naml   AGRICULTURAL AND DAIRY COMMUNITY BUILDING A PROSPEROUS FUTURE FOR CALIFORNIA   AGRICULTURAL AND DAIRY COMMUNITY BUILDING A PROSPEROUS FUTURE FOR CALIFORNIA   AGRICULTURAL AND DAIRY COMMUNITY BUILDING A PROSPEROUS FUTURE FOR CALIFORNIA   AGRICULTURAL AND DAIRY COMMUNITY BUILDING A PROSPEROUS FUTURE FOR CALIFORNIA   AGRICULTURAL AND DAIRY COMMUNITY BUILDING A PROSPEROUS FUTURE FOR CALIFORNIA   AGRICULTURAL AND DAIRY COMMUNITY BUILDING A PROSPEROUS FUTURE FOR CALIFORNIA   AGRICULTURAL AND DAIRY COMMUNITY BUILDING A PROSPEROUS FUTURE FOR CALIFORNIA   AGRICULTURAL AND DAIRY COMMUNITY BUILDING A PROSPEROUS FUTURE FOR CALIFORNIA   AGRICULTURAL AND DAIRY COMMUNITY BUILDING A PROSPEROUS FUTURE FOR CALIFORNIA   BUILDING A PROSPEROUS FUTURE FOR CALIFORNIA FACILITATED BY AGRICULTURAL COUNCIL OF CALIFORNIA   BUILDING A PROSPEROUS FUTURE FOR CALIFORNIA FACILITATED BY AGRICULTURAL COUNCIL OF CALIFORNIA   BUILDING A PROSPEROUS FUTURE FOR CALIFORNIA FACILITATED BY AGRICULTURAL COUNCIL OF CALIFORNIA   BUILDING A PROSPEROUS FUTURE FOR CALIFORNIA FACILITATED BY AGRICULTURAL COUNCIL OF CALIFORNIA   BUILDING A PROSPEROUS FUTURE FOR CALIFORNIA FACILITATED BY AGRICULTURAL COUNCIL OF CALIFORNIA   BUILDING A PROSPEROUS FUTURE FOR CALIFORNIA FACILITATED BY AGRICULTURAL COUNCIL OF CALIFORNIA   BUILDING A PROSPEROUS FUTURE FOR CALIFORNIA FACILITATED BY AGRICULTURAL COUNCIL OF CALIFORNIA   BUILDING A PROSPEROUS FUTURE FOR CALIFORNIA FACILITATED BY AGRICULTURAL COUNCIL OF CALIFORNIA   BUILDING A PROSPEROUS FUTURE FOR CALIFORNIA FACILITATED BY AGRICULTURAL COUNCIL OF CALIFORNIA   BUILDING A PROSPEROUS FUTURE FOR CALIFORNIA FACILITATED BY AGRICULTURAL COUNCIL OF CALIFORNIA, SPONSORED BY LAND O' LAKES, INC.   BUILDING A PROSPEROUS FUTURE FOR CALIFORNIA FACILITATED BY AGRICULTURAL COUNCIL OF CALIFORNIA, SPONSORED BY LAND O' LAKES, INC.   BUILDING A PROSPEROUS FUTURE FOR CALIFORNIA FACILITATED BY AGRICULTURAL COUNCIL OF CALIFORNIA, SPONSORED BY LAND O' LAKES, INC.   BUILDING A PROSPEROUS FUTURE FOR CALIFORNIA FACILITATED BY AGRICULTURAL COUNCIL OF CALIFORNIA, SPONSORED BY LAND O' LAKES, INC.   BUILDING A PROSPEROUS FUTURE FOR CALIFORNIA FACILITATED BY AGRICULTURAL COUNCIL OF CALIFORNIA, SPONSORED BY LAND O' LAKES, INC.   BUILDING A PROSPEROUS FUTURE FOR CALIFORNIA FACILITATED BY AGRICULTURAL COUNCIL OF CALIFORNIA, SPONSORED BY LAND O' LAKES, INC.   BUILDING A PROSPEROUS FUTURE FOR CALIFORNIA FACILITATED BY AGRICULTURAL COUNCIL OF CALIFORNIA, SPONSORED BY LAND O' LAKES, INC.   BUILDING A PROSPEROUS FUTURE FOR CALIFORNIA FACILITATED BY AGRICULTURAL COUNCIL OF CALIFORNIA, SPONSORED BY LAND O' LAKES, INC.   BUILDING A PROSPEROUS FUTURE FOR CALIFORNIA FACILITATED BY AGRICULTURAL COUNCIL OF CALIFORNIA, SPONSORED BY LAND O' LAKES, INC.   BUILDING A HEALTHY FUTURE FOR CA FACILITATED BY AGRICULTURAL COUNCIL OF CA   BUILDING A HEALTHY FUTURE FOR CA FACILITATED BY AGRICULTURAL COUNCIL OF CA   BUILDING A HEALTHY FUTURE FOR CA FACILITATED BY AGRICULTURAL COUNCIL OF CA   BUILDING A HEALTHY FUTURE FOR CA FACILITATED BY AGRICULTURAL COUNCIL OF CA   BUILDING A HEALTHY FUTURE FOR CA FACILITATED BY AGRICULTURAL COUNCIL OF CA   BUILDING A HEALTHY FUTURE FOR CA FACILITATED BY AGRICULTURAL COUNCIL OF CA   BUILDING A HEALTHY FUTURE FOR CA FACILITATED BY AGRICULTURAL COUNCIL OF CA   BUILDING A HEALTHY FUTURE FOR CA FACILITATED BY AGRICULTURAL COUNCIL OF CA   BUILDING A HEALTHY FUTURE FOR CA FACILITATED BY AGRICULTURAL COUNCIL OF CA   BUILDING A HEALTHY FUTURE FOR CA INDEPENDENT EXPENDITURE COMMITTEE FACILITATED BY AGRICULTURAL COUNCIL OF CA   BUILDING A HEALTHY FUTURE FOR CA INDEPENDENT EXPENDITURE COMMITTEE FACILITATED BY AGRICULTURAL COUNCIL OF CA   BUILDING A HEALTHY FUTURE FOR CA INDEPENDENT EXPENDITURE COMMITTEE FACILITATED BY AGRICULTURAL COUNCIL OF CA   BUILDING A HEALTHY FUTURE FOR CA INDEPENDENT EXPENDITURE COMMITTEE FACILITATED BY AGRICULTURAL COUNCIL OF CA   BUILDING A HEALTHY FUTURE FOR CA INDEPENDENT EXPENDITURE COMMITTEE FACILITATED BY AGRICULTURAL COUNCIL OF CA   BUILDING A HEALTHY FUTURE FOR CA INDEPENDENT EXPENDITURE COMMITTEE FACILITATED BY AGRICULTURAL COUNCIL OF CA   BUILDING A HEALTHY FUTURE FOR CA INDEPENDENT EXPENDITURE COMMITTEE FACILITATED BY AGRICULTURAL COUNCIL OF CA   BUILDING A HEALTHY FUTURE FOR CA INDEPENDENT EXPENDITURE COMMITTEE FACILITATED BY AGRICULTURAL COUNCIL OF CA   BUILDING A HEALTHY FUTURE FOR CA INDEPENDENT EXPENDITURE COMMITTEE FACILITATED BY AGRICULTURAL COUNCIL OF CA   BUILDING A HEALTHY FUTURE FOR CA FACILITATED BY AGRICULTURAL COUNCIL OF CA   BUILDING A HEALTHY FUTURE FOR CA FACILITATED BY AGRICULTURAL COUNCIL OF CA   BUILDING A HEALTHY FUTURE FOR CA FACILITATED BY AGRICULTURAL COUNCIL OF CA   BUILDING A HEALTHY FUTURE FOR CA FACILITATED BY AGRICULTURAL COUNCIL OF CA   BUILDING A HEALTHY FUTURE FOR CA FACILITATED BY AGRICULTURAL COUNCIL OF CA   BUILDING A HEALTHY FUTURE FOR CA FACILITATED BY AGRICULTURAL COUNCIL OF CA   BUILDING A HEALTHY FUTURE FOR CA FACILITATED BY AGRICULTURAL COUNCIL OF CA   BUILDING A HEALTHY FUTURE FOR CA FACILITATED BY AGRICULTURAL COUNCIL OF CA   BUILDING A HEALTHY FUTURE FOR CA FACILITATED BY AGRICULTURAL COUNCIL OF CA
namf   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
namt   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
nams   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
adr1   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
adr2   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
city   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO
st   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA
zip4   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814
phon   9164432280   None   9164432280         9164422280      9164434887   9164434887   9164432280   None   9164432280         9164422280      9164434887   9164434887   9164432280   None   9164432280         9164422280      9164434887   9164434887   9164432280   None   9164432280         9164422280      9164434887   9164434887   9164432280   None   9164432280         9164422280      9164434887   9164434887   9164432280   None   9164432280         9164422280      9164434887   9164434887
fax   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
email   [email protected]   None   [email protected]   None   None   [email protected]   None   [email protected]   [email protected]   [email protected]   None   [email protected]   None   None   [email protected]   None   [email protected]   [email protected]   [email protected]   None   [email protected]   None   None   [email protected]   None   [email protected]   [email protected]   [email protected]   None   [email protected]   None   None   [email protected]   None   [email protected]   [email protected]   [email protected]   None   [email protected]   None   None   [email protected]   None   [email protected]   [email protected]   [email protected]   None   [email protected]   None   None   [email protected]   None   [email protected]   [email protected]
Table: filers
filer_id   1399192
Table: received_filings
filer_id   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192   1399192
filing_file_name   2413160_0.cal   425147.cal   425394.cal   425415.cal   2333550_0.cal   2311858_0.cal   243812.cal   243862.cal   424328.cal   15287.cal   2455260_0.cal   2305512_0.cal   424998.cal   126755.cal   2329895_0.cal   15236.cal
received_date   2019-10-15 00:00:00   2018-10-26 00:00:00   2018-10-26 00:00:00   2018-10-26 00:00:00   2019-01-10 00:00:00   2018-10-24 00:00:00   2017-11-20 00:00:00   2017-11-20 00:00:00   2018-10-26 00:00:00   2018-12-14 00:00:00   2020-02-20 00:00:00   2018-10-11 00:00:00   2018-10-26 00:00:00   2020-01-17 00:00:00   2018-12-27 00:00:00   2018-12-14 00:00:00
filing_directory   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/temp
filing_id   2413160   None   None   None   2333550   2311858   None   None   None   None   2455260   2305512   None   None   2329895   None
form_id   F497   None   None   None   F497   F497   None   None   None   None   F497   F497   None   None   F497   None
receive_comment   Filing accepted   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing accepted   Filing accepted   Filing did not pass validation   Filing did not pass validation   Filing passed validation, but failed DB constraints   Filing did not pass validation   Filing accepted   Filing accepted   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing accepted   Filing did not pass validation