| filing_id | 786412 | 806077 | 827360 | 909692 | 1051117 | 1055585 | 1667251 | 1680649 | 1736923 | 1883228 | 1858277 | 1858277 | 1871966 | 1856894 | 1931516 | 2086956 | 2075966 | 2075967 | 2131063 | 2099121 | 2103174 | 2398704 | 2390712 | 2443376 | 2642111 | |||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| form_type | F461 | F461 | F497 | F461 | F497 | F497 | F497 | F461 | F461 | F497 | F497 | F497 | F461 | F497 | F461 | F497 | F497 | F497 | F461 | F497 | F497 | F461 | F497 | F461 | F461 | |||||||||||||||||||||||||
| filer_id | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | |||||||||||||||||||||||||
| entity_cd | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | MDI | |||||||||||||||||||||||||
| filer_naml | Syngenta | Syngenta | Syngenta | Syngenta | Syngenta | Syngenta | Syngenta | Syngenta | Syngenta | Syngenta | Syngenta | Syngenta | Syngenta | Syngenta | Syngenta | Syngenta | Syngenta | Syngenta | Syngenta | Syngenta | Syngenta | Syngenta | Syngenta | Syngenta | Syngenta | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| report_num | 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 | |||||||||||||||||||||||||
| rpt_date | 2001-10-10 00:00:00 | 2002-01-11 00:00:00 | 2002-02-28 00:00:00 | 2003-01-30 00:00:00 | 2004-10-21 00:00:00 | 2004-10-27 00:00:00 | 2012-06-01 00:00:00 | 2012-07-20 00:00:00 | 2013-01-24 00:00:00 | 2014-09-08 00:00:00 | 2014-06-30 00:00:00 | 2014-06-03 00:00:00 | 2014-07-16 00:00:00 | 2014-05-30 00:00:00 | 2015-01-20 00:00:00 | 2016-10-10 00:00:00 | 2016-09-06 00:00:00 | 2016-09-07 00:00:00 | 2017-01-31 00:00:00 | 2016-10-28 00:00:00 | 2016-11-01 00:00:00 | 2019-07-17 00:00:00 | 2019-07-17 00:00:00 | 2020-01-17 00:00:00 | 2022-01-10 00:00:00 | |||||||||||||||||||||||||
| stmt_type | None | 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 | 000160 | 000580 | LCM-20228 | 010305 | LCM-41021 | LCM-41026 | LCR-20120601 | None | None | LCM-20140908 | LCM-20140603-1 | LCM-20140603 | None | LCM-20140530 | None | 101016 | 090616 | 090716 | None | 102816 | 110116 | None | 071719 | None | None | |||||||||||||||||||||||||
| from_date | 2001-07-01 00:00:00 | 2001-10-01 00:00:00 | 2002-02-28 00:00:00 | 2002-01-01 00:00:00 | 2004-10-21 00:00:00 | 2004-10-26 00:00:00 | 2012-06-01 00:00:00 | 2012-01-01 00:00:00 | 2012-07-01 00:00:00 | 2014-09-08 00:00:00 | 2014-06-03 00:00:00 | 2014-06-03 00:00:00 | 2014-01-01 00:00:00 | 2014-05-30 00:00:00 | 2014-07-01 00:00:00 | None | None | None | 2016-01-01 00:00:00 | None | None | 2019-01-01 00:00:00 | None | 2019-07-01 00:00:00 | 2021-01-01 00:00:00 | |||||||||||||||||||||||||
| thru_date | 2001-09-30 00:00:00 | 2001-12-31 00:00:00 | 2002-02-28 00:00:00 | 2002-12-31 00:00:00 | 2004-10-21 00:00:00 | 2004-10-26 00:00:00 | 2012-06-01 00:00:00 | 2012-06-30 00:00:00 | 2012-12-31 00:00:00 | 2014-09-08 00:00:00 | 2014-06-03 00:00:00 | 2014-06-03 00:00:00 | 2014-06-30 00:00:00 | 2014-05-30 00:00:00 | 2014-12-31 00:00:00 | None | None | None | 2016-12-31 00:00:00 | None | None | 2019-06-30 00:00:00 | None | 2019-12-31 00:00:00 | 2021-12-31 00:00:00 | |||||||||||||||||||||||||
| elect_date | 2002-03-05 00:00:00 | 2002-03-05 00:00:00 | 2002-03-05 00:00:00 | 2002-03-05 00:00:00 | 2004-11-02 00:00:00 | 2004-11-02 00:00:00 | 2012-06-05 00:00:00 | None | None | 2014-11-04 00:00:00 | 2014-06-03 00:00:00 | 2014-06-03 00:00:00 | None | 2014-06-03 00:00:00 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||
| filer_city | Roseville | Roseville | Roseville | Roseville | Roseville | Roseville | Greensboro | Greensboro | Greensboro | Greensboro | Greensboro | Greensboro | Greensboro | Greensboro | Greensboro | Greensboro | Greensboro | Greensboro | Greensboro | Greensboro | Greensboro | Roseville | Roseville | Roseville | Roseville | |||||||||||||||||||||||||
| filer_st | CA | CA | CA | CA | CA | CA | NC | NC | NC | NC | NC | NC | NC | NC | NC | NC | NC | NC | NC | NC | NC | CA | CA | CA | CA | |||||||||||||||||||||||||
| filer_zip4 | 95661 | 95661 | 95661 | 95661 | 95661 | 95661 | 27409 | 27409 | 27409 | 27409 | 27409 | 27409 | 27409 | 27409 | 27409 | 27409 | 27409 | 27409 | 27409 | 27409 | 27409 | 95678 | 95678 | 95678 | 95678 | |||||||||||||||||||||||||
| filer_phon | (916) 783-1834 | (916) 783-1834 | (916) 783-1834 | (916) 783-1834 | (916) 783-1834 | (916) 783-1834 | (336) 301-8746 | (336)301-8746 | (336)301-8746 | (336) 301-8746 | (336) 301-8746 | (336) 301-8746 | (336)301-8746 | (336) 301-8746 | (336)301-8746 | 336-301-8746 | 336-301-8746 | 336-301-8746 | 336-301-8746 | 336-301-8746 | 336-301-8746 | 336-567-2471 | 336-567-2471 | 336-567-2471 | 336-567-2471 | |||||||||||||||||||||||||
| filer_fax | ( ) | ( ) | ( ) | ( ) | ( ) | ( ) | () | () | () | () | () | () | () | () | () | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||
| file_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 | |||||||||||||||||||||||||
| mail_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 | |||||||||||||||||||||||||
| mail_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 | ||||||||||||||||||||||||||
| mail_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 | |||||||||||||||||||||||||
| tres_naml | Kelly | Kelly | Kelly | Kelly | Kelly | Kelly | None | None | None | None | None | None | None | None | None | Kelly | Kelly | Kelly | Kelly | Kelly | Kelly | Sacher | Sacher | Sacher | Sacher | |||||||||||||||||||||||||
| tres_namf | Dennis | Dennis | Dennis | Dennis | Dennis | Dennis | None | None | None | None | None | None | None | None | None | Dennis | Dennis | Dennis | Dennis | Dennis | Dennis | Ben | Ben | Ben | Ben | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| tres_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 | |||||||||||||||||||||||||
| tres_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 | ||||||||||||||||||||||||||
| tres_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 | |||||||||||||||||||||||||
| tres_phon | (916) 783-1834 | (916) 783-1834 | (916) 783-1834 | (916) 783-1834 | (916) 783-1834 | (916) 783-1834 | () | () | () | () | () | () | () | () | () | 336-301-8746 | 336-301-8746 | 336-301-8746 | 336-301-8746 | 336-301-8746 | 336-301-8746 | 336-567-2471 | 336-567-2471 | 336-567-2471 | 336-567-2471 | |||||||||||||||||||||||||
| tres_fax | 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 | |||||||||||||||||||||||||
| cmtte_type | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | N | None | None | N | None | N | N | |||||||||||||||||||||||||
| sponsor_yn | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | N | None | None | N | None | N | N | |||||||||||||||||||||||||
| primfrm_yn | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | N | None | None | N | None | N | N | |||||||||||||||||||||||||
| brdbase_yn | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | N | None | None | N | None | N | N | |||||||||||||||||||||||||
| amendexp_1 | None | None | None | None | None | None | None | None | None | None | Contribution originally reported as given on 6/3/2014. Actual date mailed was 6/30/14. | None | None | None | None | None | None | None | 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| busact_cb | X | X | None | X | None | None | None | X | X | None | None | None | X | None | X | None | None | None | X | None | None | X | None | X | X | |||||||||||||||||||||||||
| busactvity | Agribusiness | Agribusiness | None | Agribusiness | None | None | None | Agribusiness | Agribusiness | None | None | None | Agribusiness | None | Agribusiness | None | None | None | Agribusiness | None | None | Agribusiness | None | Agribusiness | Agribusiness | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| cand_naml | None | 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_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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| cand_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 | |||||||||||||||||||||||||
| cand_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 | |||||||||||||||||||||||||
| cand_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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| office_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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| juris_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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| dist_no | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| sup_opp_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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 |
| filing_date | 2003-01-30 00:00:00 | 2003-01-30 00:00:00 | ||
|---|---|---|---|---|
| filingstatus | 2 | 0 | ||
| vendor | STATECRAFT | STATECRAFT | ||
| filer_id | 1242845 | 1242845 | ||
| form_type | form | F461 | ||
| error_no | ERROR 261 | ACCEPTED |
| filer_id | 1242845 | 1242845 | 1242845 | |||
|---|---|---|---|---|---|---|
| adrid | 2028452 | 2132489 | 2483034 | |||
| effect_dt | 2002-01-10 00:00:00 | 2008-01-31 00:00:00 | 2019-08-15 00:00:00 | |||
| add_type | 7051 | 7082 | 7051 | |||
| session_id | 2001 | 2007 | 2019 |
| filer_id | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_id | 788520 | 786412 | 806077 | 832571 | 827360 | 829378 | 909692 | 917998 | 1051117 | 1060533 | 1067033 | 1055585 | 1057694 | 1092475 | 1121189 | 1185758 | 1121189 | 1250876 | 1273295 | 1871966 | 1856894 | 1858277 | 1858277 | 1950430 | 1300504 | 1315457 | 1340365 | 1352922 | 1399132 | 1468724 | 1580971 | 1623610 | 1641460 | 1667251 | 1822432 | 1680649 | 1682766 | 1931516 | 1879986 | 1883228 | 1745298 | 1736923 | 2406487 | 2024647 | 2086956 | 2075967 | 2075966 | 2099121 | 2103174 | 2131063 | 2137455 | 2390712 | 2398704 | 2476573 | 2443376 | 2648211 | 2642111 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| period_id | None | 167 | 168 | None | 169 | None | 169 | None | 180 | None | None | 180 | None | None | None | None | None | None | None | 217 | 218 | 218 | 218 | None | None | None | None | None | None | None | None | None | None | 210 | None | 209 | None | 219 | None | 219 | None | 211 | None | None | 228 | 227 | 227 | 228 | 228 | 225 | None | 239 | 237 | None | 239 | None | 245 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| form_id | F461 | F461 | F461 | F497 | F497 | F461 | F461 | F461 | F497 | F497 | F497 | F497 | F497 | F461 | F461 | F461 | F461 | F461 | F497 | F461 | F497 | F497 | F497 | F461 | F461 | F461 | F497 | F461 | F461 | F461 | F461 | F461 | F461 | F497 | F461 | F461 | F461 | F461 | F461 | F497 | F461 | F461 | F461 | F461 | F497 | F497 | F497 | F497 | F497 | F461 | F461 | F497 | F461 | F461 | F461 | F461 | F461 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_date | 2001-10-10 00:00:00 | 2001-10-11 00:00:00 | 2002-01-11 00:00:00 | 2002-02-28 00:00:00 | 2002-02-28 00:00:00 | 2002-01-10 00:00:00 | 2003-01-30 00:00:00 | 2003-01-31 00:00:00 | 2004-10-21 00:00:00 | 2004-10-27 00:00:00 | 2004-11-01 00:00:00 | 2004-10-27 00:00:00 | 2004-10-21 00:00:00 | 2005-01-31 00:00:00 | 2005-08-01 00:00:00 | 2006-01-31 00:00:00 | 2006-01-31 00:00:00 | 2007-01-31 00:00:00 | 2006-11-03 00:00:00 | 2014-07-31 00:00:00 | 2014-05-30 00:00:00 | 2014-06-03 00:00:00 | 2014-06-30 00:00:00 | 2015-02-02 00:00:00 | 2007-10-31 00:00:00 | 2008-01-31 00:00:00 | 2008-06-02 00:00:00 | 2008-07-31 00:00:00 | 2009-02-02 00:00:00 | 2010-02-01 00:00:00 | 2011-01-31 00:00:00 | 2011-10-31 00:00:00 | 2012-01-31 00:00:00 | 2012-06-01 00:00:00 | 2014-01-31 00:00:00 | 2012-07-31 00:00:00 | 2012-07-31 00:00:00 | 2015-01-28 00:00:00 | 2014-07-31 00:00:00 | 2014-09-08 00:00:00 | 2013-01-31 00:00:00 | 2013-01-30 00:00:00 | 2019-07-31 00:00:00 | 2016-02-01 00:00:00 | 2016-10-10 00:00:00 | 2016-09-12 00:00:00 | 2016-09-12 00:00:00 | 2016-10-28 00:00:00 | 2016-11-01 00:00:00 | 2017-01-31 00:00:00 | 2017-01-31 00:00:00 | 2019-07-17 00:00:00 | 2019-07-31 00:00:00 | 2020-01-31 00:00:00 | 2020-01-31 00:00:00 | 2022-01-31 00:00:00 | 2022-01-29 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| stmnt_type | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10005 | 10005 | 10006 | 10005 | 10005 | 10001 | 10001 | 10001 | 10002 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| stmnt_status | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| session_id | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2013 | 2013 | 2013 | 2013 | 2013 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2011 | 2011 | 2011 | 2011 | 2013 | 2011 | 2011 | 2013 | 2013 | 2013 | 2011 | 2011 | 2019 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2019 | 2019 | 2019 | 2019 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| user_id | DMCCASTL | DMCCASTL | DMCCASTL | RALLMOND | DMCCASTL | LTHIBAUL | COMPLETED | DHORRELL | PBANFORD | EMCENTEE | EMCENTEE | PBANFORD | GPEREZ | DHORRELL | KLARRY | JINGRAM | KVANG | JMARTIN | RGEREMIA | JINGRAM | CAFILER | CAFILER | CAFILER | JINGRAM | SMCCABE | SMCCABE | LHOANG | MGUERRA | JINGRAM | JINGRAM | JINGRAM | JINGRAM | JINGRAM | PBANFORD | JINGRAM | JINGRAM | JINGRAM | JINGRAM | JINGRAM | CAFILER | JINGRAM | JINGRAM | GTAYLOR | JINGRAM | GKURIMOT | RGEREMIA | RGEREMIA | GKURIMOT | GKURIMOT | JINGRAM | JINGRAM | RGEREMIA | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| fine_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_start | 2001-01-01 00:00:00 | 2001-07-01 00:00:00 | 2001-10-01 00:00:00 | None | 2002-02-28 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2002-01-01 00:00:00 | 2004-10-21 00:00:00 | None | None | 2004-10-27 00:00:00 | None | 2004-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-07-01 00:00:00 | 2005-01-01 00:00:00 | 2006-01-01 00:00:00 | None | 2014-01-01 00:00:00 | 2014-05-30 00:00:00 | 2014-06-03 00:00:00 | 2014-06-30 00:00:00 | 2014-07-01 00:00:00 | 2007-01-01 00:00:00 | 2007-10-01 00:00:00 | None | 2008-01-01 00:00:00 | 2008-07-01 00:00:00 | 2009-01-01 00:00:00 | 2010-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-10-01 00:00:00 | 2012-06-01 00:00:00 | 2013-01-01 00:00:00 | 2012-01-01 00:00:00 | 2012-01-01 00:00:00 | 2014-07-01 00:00:00 | 2014-01-01 00:00:00 | 2014-09-08 00:00:00 | 2012-07-01 00:00:00 | 2012-07-01 00:00:00 | 2019-01-01 00:00:00 | 2015-01-01 00:00:00 | 2016-10-10 00:00:00 | 2016-09-07 00:00:00 | 2016-09-06 00:00:00 | 2016-10-28 00:00:00 | 2016-11-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2019-07-17 00:00:00 | 2019-01-01 00:00:00 | 2019-07-01 00:00:00 | 2019-07-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_end | 2001-09-30 00:00:00 | 2001-09-30 00:00:00 | 2001-12-31 00:00:00 | None | 2002-02-28 00:00:00 | 2001-12-31 00:00:00 | 2002-12-31 00:00:00 | 2002-12-31 00:00:00 | 2004-10-21 00:00:00 | None | None | 2004-10-27 00:00:00 | None | 2004-12-31 00:00:00 | 2005-06-30 00:00:00 | 2005-12-31 00:00:00 | 2005-06-30 00:00:00 | 2006-12-31 00:00:00 | None | 2014-06-30 00:00:00 | 2014-05-30 00:00:00 | 2014-06-03 00:00:00 | 2014-06-30 00:00:00 | 2014-12-31 00:00:00 | 2007-09-30 00:00:00 | 2007-12-31 00:00:00 | None | 2008-06-30 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2012-06-01 00:00:00 | 2013-12-31 00:00:00 | 2012-06-30 00:00:00 | 2012-06-30 00:00:00 | 2014-12-31 00:00:00 | 2014-06-30 00:00:00 | 2014-09-08 00:00:00 | 2012-12-31 00:00:00 | 2012-12-31 00:00:00 | 2019-06-30 00:00:00 | 2015-12-31 00:00:00 | 2016-10-10 00:00:00 | 2016-09-07 00:00:00 | 2016-09-06 00:00:00 | 2016-10-28 00:00:00 | 2016-11-01 00:00:00 | 2016-12-31 00:00:00 | 2016-12-31 00:00:00 | 2019-07-17 00:00:00 | 2019-06-30 00:00:00 | 2019-12-31 00:00:00 | 2019-12-31 00:00:00 | 2021-12-31 00:00:00 | 2021-12-31 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_date | None | 2001-10-10 00:00:00 | 2002-01-11 00:00:00 | None | 2002-02-28 00:00:00 | None | 2003-01-30 00:00:00 | None | 2004-10-21 00:00:00 | None | None | 2004-10-27 00:00:00 | None | None | None | None | None | None | None | 2014-07-16 00:00:00 | 2014-05-30 00:00:00 | 2014-06-03 00:00:00 | 2014-06-30 00:00:00 | None | None | None | None | None | None | None | None | None | None | 2012-06-01 00:00:00 | None | 2012-07-20 00:00:00 | None | 2015-01-20 00:00:00 | None | 2014-09-08 00:00:00 | None | 2013-01-24 00:00:00 | None | None | 2016-10-10 00:00:00 | 2016-09-07 00:00:00 | 2016-09-06 00:00:00 | 2016-10-28 00:00:00 | 2016-11-01 00:00:00 | 2017-01-31 00:00:00 | None | 2019-07-17 00:00:00 | 2019-07-17 00:00:00 | None | 2020-01-17 00:00:00 | None | 2022-01-10 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_type | None | None | None | None | None | None | 22001 | None | 22001 | None | None | 22001 | None | None | None | None | None | None | None | 22001 | 22001 | 22001 | 22001 | None | None | None | None | None | None | None | None | None | None | 22001 | None | 22001 | None | 22001 | None | 22001 | None | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | None | 22001 |
| filer_id | 1242845 | |
|---|---|---|
| filer_type | 10 | |
| active | Y | |
| race | 0 | |
| session_id | 2007 | |
| category | 0 | |
| category_type | 40502 | |
| sub_category | 0 | |
| effect_dt | 2002-01-10 00:00:00 | |
| sub_category_type | 0 | |
| election_type | 0 | |
| sub_category_a | None | |
| nyq_dt | None | |
| party_cd | 0 | |
| county_cd | 18037 | |
| district_cd | 0 |
| filer_id | 1242845 | |
|---|---|---|
| xref_id | 1242845 | |
| effect_dt | 2002-02-09 00:00:00 | |
| migration_source | CLAIMS |
| xref_filer_id | 1242845 | 1242845 | 1242845 | |||
|---|---|---|---|---|---|---|
| filer_id | 1242845 | 1242845 | 1242845 | |||
| filer_type | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | |||
| status | ACTIVE | ACTIVE | ACTIVE | |||
| effect_dt | 2002-01-10 00:00:00 | 2002-01-10 00:00:00 | 2002-01-10 00:00:00 | |||
| naml | SYNGENTA | SYNGENTA | SYNGENTA | |||
| namf | None | None | None | |||
| namt | None | None | None | |||
| nams | None | None | None | |||
| adr1 | None | None | None | |||
| adr2 | None | None | None | |||
| city | ROSEVILLE | GREENSBORO | ROSEVILLE | |||
| st | CA | NC | CA | |||
| zip4 | 95661 | 27409 | 95678 | |||
| phon | 9167831834 | 3363018746 | 3365672471 | |||
| fax | None | |||||
| None | None | None |
| filer_id | 1242845 |
|---|
| filer_id | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | 1242845 | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_file_name | 436056.cal | 909692_0.cal | 182656.cal | 1051117_0.cal | 1055585_0.cal | 1736923_0.cal | 1680649_0.cal | 1667251_0.cal | 1856894_0.cal | 1858277_1.cal | 1858277_0.cal | 1871966_0.cal | 135226.cal | 138864.cal | 141932.cal | 2103174_0.cal | 2086956_0.cal | 1883228_0.cal | 2099121_0.cal | 2075966_0.cal | 2075967_0.cal | 2390712_0.cal | ||||||||||||||||||||||
| received_date | 2003-01-30 00:00:00 | 2003-01-30 00:00:00 | 2004-10-21 00:00:00 | 2004-10-21 00:00:00 | 2004-10-27 00:00:00 | 2013-01-30 00:00:00 | 2012-07-31 00:00:00 | 2012-06-01 00:00:00 | 2014-05-30 00:00:00 | 2014-06-30 00:00:00 | 2014-06-03 00:00:00 | 2014-07-31 00:00:00 | 2017-01-31 00:00:00 | 2017-01-31 00:00:00 | 2017-01-31 00:00:00 | 2016-11-01 00:00:00 | 2016-10-10 00:00:00 | 2014-09-08 00:00:00 | 2016-10-28 00:00:00 | 2016-09-12 00:00:00 | 2016-09-12 00:00:00 | 2019-07-17 00:00:00 | ||||||||||||||||||||||
| filing_directory | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /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/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | ||||||||||||||||||||||
| filing_id | None | 909692 | None | 1051117 | 1055585 | 1736923 | 1680649 | 1667251 | 1856894 | 1858277 | 1858277 | 1871966 | None | None | None | 2103174 | 2086956 | 1883228 | 2099121 | 2075966 | 2075967 | 2390712 | ||||||||||||||||||||||
| form_id | None | F461 | None | F497 | F497 | F461 | F461 | F497 | F497 | F497 | F497 | F461 | None | None | None | F497 | F497 | F497 | F497 | F497 | F497 | F497 | ||||||||||||||||||||||
| receive_comment | Filing passed validation, but failed DB constraints | Filing accepted | Filing did not pass validation | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted |