OpenCalAccess

Filer ID: 1298011

Table: cvr_campaign_disclosure
filing_id	1363457	1363457	1434797	1350757	1397728	1474253	1461244	1504597	1539055	1531099	1521886	1572127	1663598	1643272	1647340	1636806	1605484	1663598	1675863	1737454	1778983	1838011	1813165	1875292	1870575	1852661	1850973	1891740	1931154	1900103	1904024	1977101	2008841	2062268	2097571	2091113	2169285	2129653	2105849	2204589	2232210	2236534	2228765	2204589	2293226	2268433	2297020	2315417	2315417	2346100	2323028	2394023	2437452	2484422	2552005	2658550	2598621	2588432	2672433	2643567	2721073	2682957	2704998	2724497	2686054	2742065	2739068
amend_id	0	1	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	0	0	0	1	0	0	0	0	1	0	0	0	0	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	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	F460	F460	F460	F460	F460	F460	F497	F460	F460	F460	F460	F497	F460	F460	F460	F460	F460	F460	F460	F497	F460	F497	F460	F460	F497	F460	F460	F497	F460	F460	F460	F460	F460	F497	F460	F460	F497	F460	F497	F460	F497	F460	F497	F460	F460	F497	F497	F460	F497	F460	F460	F460	F460	F497	F460	F497	F460	F460	F497	F497	F460	F460	F460	F460	F497
filer_id	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011
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
filer_naml	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC
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
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
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
report_num	000	001	000	000	000	000	000	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	000	000	000	000	000	000	000	001	000	000	000	000	001	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000
rpt_date	2008-10-06 00:00:00	2008-10-07 00:00:00	2009-07-28 00:00:00	2008-07-31 00:00:00	2009-02-02 00:00:00	2010-03-22 00:00:00	2010-01-27 00:00:00	2010-07-28 00:00:00	2010-10-29 00:00:00	2010-10-21 00:00:00	2010-10-04 00:00:00	2011-01-31 00:00:00	2012-05-24 00:00:00	2012-02-28 00:00:00	2012-03-22 00:00:00	2012-01-31 00:00:00	2011-07-28 00:00:00	2012-07-31 00:00:00	2012-07-27 00:00:00	2013-01-30 00:00:00	2013-07-26 00:00:00	2014-04-11 00:00:00	2014-01-23 00:00:00	2014-08-07 00:00:00	2014-07-30 00:00:00	2014-05-21 00:00:00	2014-05-16 00:00:00	2014-10-03 00:00:00	2015-01-27 00:00:00	2014-10-17 00:00:00	2014-10-23 00:00:00	2015-07-24 00:00:00	2016-01-28 00:00:00	2016-07-29 00:00:00	2016-10-27 00:00:00	2016-10-18 00:00:00	2017-07-20 00:00:00	2017-01-30 00:00:00	2016-11-07 00:00:00	2018-01-23 00:00:00	2018-04-18 00:00:00	2018-04-25 00:00:00	2018-04-06 00:00:00	2018-04-16 00:00:00	2018-09-18 00:00:00	2018-07-24 00:00:00	2018-09-27 00:00:00	2018-10-29 00:00:00	2018-11-02 00:00:00	2019-01-29 00:00:00	2018-11-02 00:00:00	2019-07-26 00:00:00	2020-01-28 00:00:00	2020-07-30 00:00:00	2021-01-23 00:00:00	2022-03-18 00:00:00	2021-07-27 00:00:00	2021-06-16 00:00:00	2022-04-26 00:00:00	2022-01-29 00:00:00	2022-09-16 00:00:00	2022-05-16 00:00:00	2022-07-26 00:00:00	2022-09-27 00:00:00	2022-05-25 00:00:00	2022-10-26 00:00:00	2022-10-21 00:00:00
stmt_type	PE	PE	SA	SA	SA	PE	SA	SA	None	PE	PE	SA	PE	None	PE	SA	SA	PE	SA	SA	SA	None	SA	None	SA	PE	None	PE	SA	None	PE	SA	SA	SA	PE	None	SA	SA	None	SA	None	PE	None	SA	None	SA	PE	None	None	SA	None	SA	SA	SA	SA	None	SA	None	PE	SA	None	None	SA	PE	PE	PE	None
late_rptno	None	None	None	None	None	None	None	None	4742	None	None	None	None	5520	None	None	None	None	None	None	None	10181	None	11636	None	None	10938	None	None	13372	None	None	None	None	None	19876	None	None	21436	None	24067	None	23872	None	26713	None	None	28721	28721	None	29130	None	None	None	None	36640	None	35738	None	None	38839	37479	None	None	None	None	39817
from_date	2008-07-01 00:00:00	2008-07-01 00:00:00	2009-01-01 00:00:00	2008-01-01 00:00:00	2008-10-01 00:00:00	2010-01-01 00:00:00	2009-07-01 00:00:00	2010-03-18 00:00:00	None	2010-10-01 00:00:00	2010-07-01 00:00:00	2010-10-17 00:00:00	2012-03-18 00:00:00	None	2012-01-01 00:00:00	2011-07-01 00:00:00	2011-01-01 00:00:00	2012-03-18 00:00:00	2012-05-20 00:00:00	2012-07-01 00:00:00	2013-01-01 00:00:00	None	2013-07-01 00:00:00	None	2014-05-18 00:00:00	2014-01-01 00:00:00	None	2014-07-01 00:00:00	2014-10-19 00:00:00	None	2014-10-01 00:00:00	2015-01-01 00:00:00	2015-07-01 00:00:00	2016-01-01 00:00:00	2016-07-01 00:00:00	None	2017-01-01 00:00:00	2016-10-23 00:00:00	None	2017-07-01 00:00:00	None	2018-01-01 00:00:00	None	2017-07-01 00:00:00	None	2018-04-22 00:00:00	2018-07-01 00:00:00	None	None	2018-09-23 00:00:00	None	2019-01-01 00:00:00	2019-07-01 00:00:00	2020-01-01 00:00:00	2020-07-01 00:00:00	None	2021-01-01 00:00:00	None	2022-01-01 00:00:00	2021-07-01 00:00:00	None	None	2022-05-22 00:00:00	2022-07-01 00:00:00	2022-04-24 00:00:00	2022-09-25 00:00:00	None
thru_date	2008-09-30 00:00:00	2008-09-30 00:00:00	2009-06-30 00:00:00	2008-06-30 00:00:00	2008-12-31 00:00:00	2010-03-17 00:00:00	2009-12-31 00:00:00	2010-06-30 00:00:00	None	2010-10-16 00:00:00	2010-09-30 00:00:00	2010-12-31 00:00:00	2012-05-19 00:00:00	None	2012-03-17 00:00:00	2011-12-31 00:00:00	2011-06-30 00:00:00	2012-05-19 00:00:00	2012-06-30 00:00:00	2012-12-31 00:00:00	2013-06-30 00:00:00	None	2013-12-31 00:00:00	None	2014-06-30 00:00:00	2014-05-17 00:00:00	None	2014-09-30 00:00:00	2014-12-31 00:00:00	None	2014-10-18 00:00:00	2015-06-30 00:00:00	2015-12-31 00:00:00	2016-06-30 00:00:00	2016-10-22 00:00:00	None	2017-06-30 00:00:00	2016-12-31 00:00:00	None	2017-12-31 00:00:00	None	2018-04-21 00:00:00	None	2017-12-31 00:00:00	None	2018-06-30 00:00:00	2018-09-22 00:00:00	None	None	2018-12-31 00:00:00	None	2019-06-30 00:00:00	2019-12-31 00:00:00	2020-06-30 00:00:00	2020-12-31 00:00:00	None	2021-06-30 00:00:00	None	2022-04-23 00:00:00	2021-12-31 00:00:00	None	None	2022-06-30 00:00:00	2022-09-24 00:00:00	2022-05-21 00:00:00	2022-10-22 00:00:00	None
elect_date	2008-11-04 00:00:00	2008-11-04 00:00:00	None	None	None	2010-06-08 00:00:00	None	None	None	2010-11-02 00:00:00	2010-11-02 00:00:00	None	2012-06-05 00:00:00	None	2012-06-05 00:00:00	None	None	2012-06-05 00:00:00	None	None	None	None	None	None	None	2014-06-03 00:00:00	None	2014-11-04 00:00:00	None	None	2014-11-04 00:00:00	None	None	None	2016-11-08 00:00:00	None	None	None	None	None	None	2018-06-05 00:00:00	None	None	None	None	2018-11-06 00:00:00	None	None	None	None	None	None	None	None	None	None	None	2022-06-07 00:00:00	None	2022-11-08 00:00:00	2022-06-07 00:00:00	None	2022-11-08 00:00:00	2022-06-07 00:00:00	2022-11-08 00:00:00	2022-11-08 00:00:00
filer_city	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward
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
filer_zip4	94545	94545	94545	94545-	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545
filer_phon	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483
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
file_email	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	compliance@olsonremcho.com	info@olsonhagel.com	info@olsonhagel.com	compliance@olsonremcho.com	compliance@olsonremcho.com	compliance@olsonremcho.com	compliance@olsonremcho.com	compliance@olsonremcho.com	compliance@olsonremcho.com	compliance@olsonremcho.com	compliance@olsonremcho.com	compliance@olsonremcho.com
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
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
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
tres_naml	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Smith	Dixon	Smith	Smith	Dixon	Dixon	None	None	Dixon	Dixon	Dixon	Dixon	None
tres_namf	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Stanley	Jeffrey M.	Stanley	Stanley	Jeffrey M.	Jeffrey M.	None	None	Jeffrey M.	Jeffrey M.	Jeffrey M.	Jeffrey M.	None
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
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
tres_city	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward	None	None	Hayward	Hayward	Hayward	Hayward	None
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	None	None	CA	CA	CA	CA	None
tres_zip4	94545	94545	94545	94545-	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	94545	None	None	94545	94545	94545	94545	None
tres_phon	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	None	None	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	None
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
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
cmtte_type	G	G	G	G	G	G	G	G	None	G	G	G	G	None	G	G	G	G	G	G	G	None	G	None	G	G	None	G	G	None	G	G	G	G	G	None	G	G	None	G	None	G	None	G	None	G	G	None	None	G	None	G	G	G	G	None	G	None	G	G	None	None	G	G	G	G	None
control_yn	Y	Y	Y	Y	Y	Y	Y	Y	None	Y	Y	Y	Y	None	Y	Y	Y	Y	Y	Y	Y	None	Y	None	Y	Y	None	Y	Y	None	Y	Y	Y	Y	Y	None	Y	Y	None	Y	None	Y	None	Y	None	Y	Y	None	None	Y	None	Y	Y	Y	Y	None	Y	None	Y	Y	None	None	Y	Y	Y	Y	None
sponsor_yn	N	N	Y	N	N	Y	Y	Y	None	Y	Y	Y	Y	None	Y	Y	Y	Y	Y	Y	Y	None	Y	None	Y	Y	None	Y	Y	None	Y	Y	Y	Y	Y	None	Y	Y	None	Y	None	Y	None	Y	None	Y	Y	None	None	Y	None	Y	Y	Y	Y	None	Y	None	Y	Y	None	None	Y	Y	Y	Y	None
primfrm_yn	N	N	N	N	N	N	N	N	None	N	N	N	N	None	N	N	N	N	N	N	N	None	N	None	N	N	None	N	N	None	N	N	N	N	N	None	N	N	None	N	None	N	None	N	None	N	N	None	None	N	None	N	N	N	N	None	N	None	N	N	None	None	N	N	N	N	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
amendexp_1	None	To Amend for Original Signature	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	To update summary page and schedules E & I	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Amend to update Schedule D and Schedule E.	None	None	None	None	Update Contributions Made.	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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
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
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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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
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
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
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
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
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
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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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
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
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
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

Table: cvr_so
filing_id	1416479	1416479	1416479	1416479	1416479	1416479
amend_id	1	0	2	3	4	5
rec_type	CVR	CVR	CVR	CVR	CVR	CVR
form_type	F410	F410	F410	F410	F410	F410
filer_id	1298011	1298011	1298011	1298011	1298011	1298011
entity_cd	RCP	RCP	RCP	RCP	RCP	RCP
filer_naml	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC	Sprinkler Fitters & Apprentices Local 483 Statewide PAC
filer_namf	None	None	None	None	None	None
filer_namt	None	None	None	None	None	None
filer_nams	None	None	None	None	None	None
report_num	001	000	002	003	004	005
rpt_date	2009-04-07 00:00:00	2009-04-07 00:00:00	2011-05-31 00:00:00	2013-01-30 00:00:00	2018-03-15 00:00:00	2022-01-05 00:00:00
qual_cb	None	None	None	X	X	X
qualfy_dt	2007-09-28 00:00:00	2007-09-28 00:00:00	2007-09-28 00:00:00	2007-09-28 00:00:00	2007-09-28 00:00:00	2007-09-28 00:00:00
term_date	None	None	None	None	None	None
city	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward
st	CA	CA	CA	CA	CA	CA
zip4	94545	94545	94545	94545	94545	94545
phone	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483
county_res	Alameda	Alameda	Alameda	Alameda	Alameda	Alameda
county_act	None	None	None	Statewide	Statewide	Statewide
mail_city	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento
mail_st	CA	CA	CA	CA	CA	CA
mail_zip4	95814	95814	95814	95814	95814	95814
cmte_fax	None	None	None	None	None	None
cmte_email	None	None	None	info@olsonhagel.com	info@olsonhagel.com	compliance@olsonremcho.com
tres_naml	Smith	Smith	Smith	Smith	Smith	Dixon
tres_namf	Stanley	Stanley	Stanley	Stanley	Stanley	Jeffrey M.
tres_namt	None	None	None	None	None	None
tres_nams	None	None	None	None	None	None
tres_city	Hayward	Hayward	Hayward	Hayward	Hayward	Hayward
tres_st	CA	CA	CA	CA	CA	CA
tres_zip4	94545	94545	94545	94545	94545	94545
tres_phon	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483	(510) 785-8483
actvty_lvl	ST	ST	ST	ST	ST	ST
com82013yn	None	None	None	None	None	None
com82013nm	None	None	None	None	None	None
com82013id	None	None	None	None	None	None
control_cb	None	None	None	None	None	None
bank_nam	None	None	None	Wells Fargo Bank	Wells Fargo Bank	Wells Fargo Bank
bank_adr1	None	None	None	400 Capitol Mall	400 Capitol Mall	400 Capitol Mall
bank_adr2	None	None	None	None	None	None
bank_city	None	None	None	Sacramento	Sacramento	Sacramento
bank_st	None	None	None	CA	CA	CA
bank_zip4	None	None	None	95814	95814	95814
bank_phon	None	None	None	(916) 440-4205	(916) 440-4205	(916) 440-4205
acct_opendt	None	None	None	None	None	None
surplusdsp	None	None	None	None	None	None
primfc_cb	None	None	None	None	None	None
genpurp_cb	None	None	None	None	None	None
gpc_descr	To Support or Oppose State Candidates	To Support or Oppose State Candidates	To Support or Oppose State Candidates	To Support or Oppose State Candidates	To Support or Oppose State Candidates	To Support or Oppose State Candidates
sponsor_cb	None	None	None	None	X	X
brdbase_cb	None	None	None	None	X	X
smcont_qualdt	2009-03-31 00:00:00	2009-03-31 00:00:00	2009-03-31 00:00:00	2009-03-31 00:00:00	2009-03-31 00:00:00	2009-03-31 00:00:00

Table: filer_address
filer_id	1298011	1298011	1298011	1298011	1298011	1298011	1298011
adrid	2123482	2123483	2451355	2451354	2286394	2528246	2528247
effect_dt	2007-05-11 00:00:00	2007-05-11 00:00:00	2018-03-15 00:00:00	2018-03-15 00:00:00	2013-01-30 00:00:00	2022-01-07 00:00:00	2022-01-07 00:00:00
add_type	7051	7082	7082	7051	7051	7051	7082
session_id	2007	2007	2017	2017	2013	2021	2021

Table: filer_filings
filer_id	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011
filing_id	1281791	1265610	1779610	1778983	1979465	1977101	1870575	1850973	1853873	1782798	1943187	1891740	1900103	1904024	1309513	1351052	1363457	1350757	1364582	1363457	1364582	1397728	1416479	1434797	1423199	1416479	1398974	1464413	1435285	1461244	1474253	1504597	1474354	1509110	1532375	1531099	1539055	1543080	1523389	1521886	1572127	1416479	1573102	1607058	1605484	1638355	1595961	1643272	1647865	1647340	1636806	1666690	1663598	1679674	1663598	1813165	1819893	1666690	1675863	1931154	1915629	1893011	1876759	1875292	1737454	1416479	1852661	1838011	1746941	1756834	2239046	1416479	2437452	2204589	2297020	2323028	2204589	2268433	2395555	2008841	2014410	2062268	2077847	2091113	2110198	2129653	2097571	2105849	2146990	2169285	2170485	2216872	2301019	2451317	2315417	2228765	2484422	2494266	2315417	2293226	2346100	2268418	2232210	2569719	2356198	2236534	2224192	2394023	2633580	2682957	2598621	1416479	2676422	2704998	2658550	2648629	2616762	2724497	2721073	2688067	2552005	2588432	2643567	2686054	2672433	2742638	2737987	2742065	2739068
period_id	None	None	None	213	None	221	218	218	None	None	None	219	220	220	None	None	195	193	None	195	None	196	198	197	None	198	None	None	None	199	201	201	None	None	None	204	204	None	None	203	204	206	None	None	205	None	None	209	None	209	207	None	209	None	209	215	None	None	210	220	None	None	None	219	211	213	217	218	None	None	None	233	239	231	235	236	231	234	None	223	None	225	None	228	None	228	227	228	None	229	None	None	None	None	236	234	241	None	236	235	235	None	234	None	None	233	None	237	None	250	245	249	None	250	249	None	None	251	251	None	243	246	247	250	249	None	None	251	252
form_id	F460	F410	F460	F460	F460	F460	F460	F497	F460	F666	F460	F460	F497	F460	F460	F460	F460	F460	F460	F460	F460	F460	F410	F460	F410	F410	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F497	F497	F460	F460	F460	F410	F460	F460	F460	F460	F410	F497	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F497	F460	F410	F460	F497	F460	F410	F460	F410	F460	F460	F460	F497	F460	F460	F460	F460	F460	F460	F460	F497	F460	F460	F460	F497	F460	F460	F460	F460	F460	F460	F497	F497	F460	F460	F497	F497	F460	F460	F497	F460	F460	F460	F410	F460	F410	F497	F460	F410	F460	F460	F497	F460	F460	F460	F497	F460	F460	F497	F460	F460	F460	F460	F460	F460	F497
filing_sequence	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	1	0	0	0	0	0	0	0	3	0	0	0	0	0	4	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	1	0	0	0	0	0	0	0	0	0	0	0	0	5	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
filing_date	2007-07-26 00:00:00	2007-05-11 00:00:00	2013-07-26 00:00:00	2013-07-26 00:00:00	2015-07-24 00:00:00	2015-07-24 00:00:00	2014-07-30 00:00:00	2014-05-16 00:00:00	2014-05-21 00:00:00	2013-07-31 00:00:00	2015-01-27 00:00:00	2014-10-03 00:00:00	2014-10-17 00:00:00	2014-10-23 00:00:00	2008-01-29 00:00:00	2008-07-31 00:00:00	2008-10-06 00:00:00	2008-07-31 00:00:00	2008-10-06 00:00:00	2008-10-07 00:00:00	2008-10-07 00:00:00	2009-02-02 00:00:00	2009-04-07 00:00:00	2009-07-28 00:00:00	2009-04-07 00:00:00	2009-04-07 00:00:00	2009-02-02 00:00:00	2010-01-27 00:00:00	2009-07-28 00:00:00	2010-01-27 00:00:00	2010-03-22 00:00:00	2010-07-28 00:00:00	2010-03-22 00:00:00	2010-07-28 00:00:00	2010-10-21 00:00:00	2010-10-21 00:00:00	2010-10-29 00:00:00	2010-10-29 00:00:00	2010-10-04 00:00:00	2010-10-04 00:00:00	2011-01-31 00:00:00	2011-05-31 00:00:00	2011-01-28 00:00:00	2011-07-28 00:00:00	2011-07-28 00:00:00	2012-01-31 00:00:00	2011-05-31 00:00:00	2012-02-28 00:00:00	2012-03-22 00:00:00	2012-03-22 00:00:00	2012-01-31 00:00:00	2012-05-24 00:00:00	2012-05-24 00:00:00	2012-07-27 00:00:00	2012-07-31 00:00:00	2014-01-24 00:00:00	2014-01-24 00:00:00	2012-07-31 00:00:00	2012-07-27 00:00:00	2015-01-27 00:00:00	2014-10-23 00:00:00	2014-10-03 00:00:00	2014-07-30 00:00:00	2014-08-07 00:00:00	2013-01-30 00:00:00	2013-01-30 00:00:00	2014-05-21 00:00:00	2014-04-11 00:00:00	2013-01-30 00:00:00	2013-01-30 00:00:00	2018-04-25 00:00:00	2018-03-15 00:00:00	2020-01-28 00:00:00	2018-01-23 00:00:00	2018-09-27 00:00:00	2018-11-02 00:00:00	2018-04-16 00:00:00	2018-07-24 00:00:00	2019-07-26 00:00:00	2016-01-28 00:00:00	2016-01-28 00:00:00	2016-07-29 00:00:00	2016-07-29 00:00:00	2016-10-18 00:00:00	2016-10-27 00:00:00	2017-01-31 00:00:00	2016-10-27 00:00:00	2016-11-07 00:00:00	2017-01-31 00:00:00	2017-07-20 00:00:00	2017-07-20 00:00:00	2018-01-23 00:00:00	2018-09-27 00:00:00	2020-01-28 00:00:00	2018-10-29 00:00:00	2018-04-06 00:00:00	2020-07-30 00:00:00	2020-07-31 00:00:00	2018-11-02 00:00:00	2018-09-18 00:00:00	2019-01-30 00:00:00	2018-07-23 00:00:00	2018-04-18 00:00:00	2021-02-01 00:00:00	2019-01-30 00:00:00	2018-04-25 00:00:00	2018-03-15 00:00:00	2019-07-26 00:00:00	2022-01-07 00:00:00	2022-05-16 00:00:00	2021-07-28 00:00:00	2022-01-07 00:00:00	2022-04-27 00:00:00	2022-07-29 00:00:00	2022-03-18 00:00:00	2022-01-31 00:00:00	2021-07-29 00:00:00	2022-09-27 00:00:00	2022-09-16 00:00:00	2022-05-26 00:00:00	2021-01-30 00:00:00	2021-06-16 00:00:00	2022-01-31 00:00:00	2022-05-25 00:00:00	2022-04-28 00:00:00	2022-09-28 00:00:00	2022-07-29 00:00:00	2022-10-26 00:00:00	2022-10-21 00:00:00
stmnt_type	10005	10005	10005	10001	10005	10001	10001	10001	10005	10005	10005	10001	10001	10001	10005	10005	10001	10001	10005	10002	10006	10001	10001	10001	10006	10002	10005	10005	10005	10001	10001	10001	10005	10005	10005	10001	10001	10005	10005	10001	10001	10002	10005	10005	10001	10005	10006	10001	10005	10001	10001	10005	10001	10005	10002	10001	10005	10006	10001	10001	10005	10005	10005	10001	10001	10002	10001	10001	10005	10002	10005	10002	10001	10001	10001	10001	10002	10001	10005	10001	10005	10001	10005	10001	10005	10001	10001	10001	10005	10001	10005	10005	10005	10005	10001	10001	10001	10005	10002	10001	10001	10005	10001	10005	10005	10001	10006	10001	10006	10001	10001	10002	10005	10001	10001	10005	10005	10001	10001	10005	10001	10001	10001	10001	10001	10005	10005	10001	10001
stmnt_status	11001	11003	11001	11001	11001	11001	11003	11001	11001	11003	11001	11003	11001	11001	11001	11001	11003	11001	11003	11003	11003	11003	11003	11001	11001	11003	11003	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	11003	11001	11003	11003	11001	11001	11001	11003	11003	11001	11003	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11001	11001	11003	11003	11001	11001	11003	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11003	11003	11001	11001	11003	11003	11003	11001	11003	11001	11003	11001	11003	11003	11003	11003
session_id	2007	2007	2013	2013	2015	2015	2013	2013	2013	2009	2013	2013	2013	2013	2007	2007	2007	2007	2007	2007	2007	2007	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2011	2009	2011	2011	2011	2011	2011	2011	2011	2011	2011	2011	2011	2011	2013	2013	2011	2011	2013	2013	2013	2013	2013	2011	2013	2013	2013	2011	2013	2017	2017	2019	2017	2017	2017	2017	2017	2019	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2017	2017	2017	2017	2019	2017	2017	2019	2019	2017	2017	2017	2017	2017	2021	2017	2017	2017	2019	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2019	2021	2021	2021	2021	2021	2021	2021	2021
user_id	SARRIAGA	BATKINSO	MDIGRAZIA	MDIGRAZIA	SARRIAGA	SARRIAGA	CAFILER	WBROWN	MDIGRAZIA	NLANDERS	SARRIAGA	CAFILER	WBROWN	SARRIAGA	GKURIMOT	CPON	*	CPON	RGEREMIA	*	RGEREMIA	*	*	MMORENO	RGEREMIA	*	JVAZQUEZ	CPON	MMORENO	CPON	MMORENO	SARRIAGA	MMORENO	SARRIAGA	MMORENO	MMORENO	CREYNOLDS	MPACHECO	CPON	CPON	SMCCONNAN	TRAMON	SMCCONNAN	SARRIAGA	SARRIAGA	MDIGRAZIA	TRAMON	CREYNOLDS	MDIGRAZIA	MDIGRAZIA	MDIGRAZIA	MDIGRAZIA	MDIGRAZIA	CPON	CAFILER	MDIGRAZIA	MPACHECO	MPACHECO	CPON	SARRIAGA	SARRIAGA	JINGRAM	MPACHECO	WBROWN	CAFILER	JINGRAM	MDIGRAZIA	WBROWN	MPACHECO	JINGRAM	CSAGABAEN	TRAMON	SUSHAKOV	CSAGABAEN	MXIONG	CAFILER	CAFILER	LBARTHOL	HCOURSEY	SMCCONNAN	SMCCONNAN	CPON	CPON	GKURIMOT	CSAGABAEN	LLEONG	CSAGABAEN	GKURIMOT	LLEONG	LBARTHOL	LBARTHOL	CSAGABAEN	MXIONG	SUSHAKOV	CAFILER	CAFILER	KRUSSELL	KRUSSELL	CAFILER	CAFILER	VUKSTINA	LBARTHOL	CAFILER	AXIONG	VUKSTINA	CSAGABAEN	TRAMON	HCOURSEY	IMEDINA	CAFILER	KRUSSELL	IMEDINA	KRUSSELL	CAFILER	CAFILER	KRUSSELL	KRUSSELL	CAFILER	CAFILER	JMAVES	AXIONG	CAFILER	KRUSSELL	CAFILER	KRUSSELL	LPHEAV	JMAVES	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	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003
fine_audit	11003	11003	11001	11001	11003	11003	11003	11001	11001	11003	11003	11003	11001	11003	11001	11001	11003	11001	11003	11003	11003	11003	11003	11001	11003	11003	11003	11001	11001	11001	11001	11003	11001	11003	11001	11001	11001	11003	11001	11001	11001	11003	11001	11003	11003	11001	11003	11001	11001	11001	11001	11001	11001	11001	11003	11001	11003	11003	11001	11003	11003	11003	11003	11001	11003	11003	11001	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11001	11001	11001	11001	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
rpt_start	2007-01-01 00:00:00	None	2013-01-01 00:00:00	2013-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2014-05-18 00:00:00	2014-05-16 00:00:00	2014-01-01 00:00:00	2009-01-01 00:00:00	2014-10-19 00:00:00	2014-07-01 00:00:00	2014-10-17 00:00:00	2014-10-01 00:00:00	2007-07-01 00:00:00	2008-01-01 00:00:00	2008-07-01 00:00:00	2008-01-01 00:00:00	2008-07-01 00:00:00	2008-07-01 00:00:00	2008-07-01 00:00:00	2008-10-01 00:00:00	2009-04-07 00:00:00	2009-01-01 00:00:00	None	2009-04-07 00:00:00	2008-10-01 00:00:00	2009-07-01 00:00:00	2009-01-01 00:00:00	2009-07-01 00:00:00	2010-01-01 00:00:00	2010-03-18 00:00:00	2010-01-01 00:00:00	2010-03-18 00:00:00	2010-10-01 00:00:00	2010-10-01 00:00:00	2010-10-29 00:00:00	None	2010-07-01 00:00:00	2010-07-01 00:00:00	2010-10-17 00:00:00	2011-05-31 00:00:00	2010-10-17 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-07-01 00:00:00	None	2012-02-28 00:00:00	2012-01-01 00:00:00	2012-01-01 00:00:00	2011-07-01 00:00:00	2012-03-18 00:00:00	2012-03-18 00:00:00	2012-05-20 00:00:00	2012-03-18 00:00:00	2013-07-01 00:00:00	2013-07-01 00:00:00	2012-03-18 00:00:00	2012-05-20 00:00:00	2014-10-19 00:00:00	2014-10-01 00:00:00	2014-07-01 00:00:00	2014-05-18 00:00:00	2014-08-07 00:00:00	2012-07-01 00:00:00	2013-01-30 00:00:00	2014-01-01 00:00:00	2014-04-11 00:00:00	2012-07-01 00:00:00	None	2018-01-01 00:00:00	2018-03-15 00:00:00	2019-07-01 00:00:00	2017-07-01 00:00:00	2018-07-01 00:00:00	2018-11-02 00:00:00	2017-07-01 00:00:00	2018-04-22 00:00:00	2019-01-01 00:00:00	2015-07-01 00:00:00	2015-07-01 00:00:00	2016-01-01 00:00:00	2016-01-01 00:00:00	2016-10-18 00:00:00	2016-07-01 00:00:00	2016-10-23 00:00:00	2016-07-01 00:00:00	2016-11-07 00:00:00	2016-10-23 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2017-07-01 00:00:00	2018-07-01 00:00:00	2019-07-01 00:00:00	2018-10-29 00:00:00	2018-04-06 00:00:00	2020-01-01 00:00:00	2020-01-01 00:00:00	2018-11-02 00:00:00	2018-09-18 00:00:00	2018-09-23 00:00:00	2018-04-22 00:00:00	2018-04-18 00:00:00	2020-07-01 00:00:00	2018-09-23 00:00:00	2018-01-01 00:00:00	None	2019-01-01 00:00:00	None	2022-05-16 00:00:00	2021-01-01 00:00:00	2022-01-05 00:00:00	2022-01-01 00:00:00	2022-05-22 00:00:00	2022-03-18 00:00:00	2021-07-01 00:00:00	2021-01-01 00:00:00	2022-07-01 00:00:00	2022-09-16 00:00:00	2022-04-24 00:00:00	2020-07-01 00:00:00	2021-06-16 00:00:00	2021-07-01 00:00:00	2022-04-24 00:00:00	2022-01-01 00:00:00	2022-07-01 00:00:00	2022-05-22 00:00:00	2022-09-25 00:00:00	2022-10-21 00:00:00
rpt_end	2007-06-30 00:00:00	None	2013-06-30 00:00:00	2013-06-30 00:00:00	2015-06-30 00:00:00	2015-06-30 00:00:00	2014-06-30 00:00:00	2014-05-16 00:00:00	2014-05-17 00:00:00	2010-12-31 00:00:00	2014-12-31 00:00:00	2014-09-30 00:00:00	2014-10-17 00:00:00	2014-10-18 00:00:00	2007-12-31 00:00:00	2008-06-30 00:00:00	2008-09-30 00:00:00	2008-06-30 00:00:00	2008-09-30 00:00:00	2008-09-30 00:00:00	2008-09-30 00:00:00	2008-12-31 00:00:00	2009-04-07 00:00:00	2009-06-30 00:00:00	None	2009-04-07 00:00:00	2008-12-31 00:00:00	2009-12-31 00:00:00	2009-06-30 00:00:00	2009-12-31 00:00:00	2010-03-17 00:00:00	2010-06-30 00:00:00	2010-03-17 00:00:00	2010-06-30 00:00:00	2010-10-16 00:00:00	2010-10-16 00:00:00	2010-10-29 00:00:00	None	2010-09-30 00:00:00	2010-09-30 00:00:00	2010-12-31 00:00:00	2011-05-31 00:00:00	2010-12-31 00:00:00	2011-06-30 00:00:00	2011-06-30 00:00:00	2011-12-31 00:00:00	None	2012-02-28 00:00:00	2012-03-17 00:00:00	2012-03-17 00:00:00	2011-12-31 00:00:00	2012-05-19 00:00:00	2012-05-19 00:00:00	2012-06-30 00:00:00	2012-05-19 00:00:00	2013-12-31 00:00:00	2013-12-31 00:00:00	2012-05-19 00:00:00	2012-06-30 00:00:00	2014-12-31 00:00:00	2014-10-18 00:00:00	2014-09-30 00:00:00	2014-06-30 00:00:00	2014-08-07 00:00:00	2012-12-31 00:00:00	2013-01-30 00:00:00	2014-05-17 00:00:00	2014-04-11 00:00:00	2012-12-31 00:00:00	None	2018-04-21 00:00:00	2018-03-15 00:00:00	2019-12-31 00:00:00	2017-12-31 00:00:00	2018-09-22 00:00:00	2018-11-02 00:00:00	2017-12-31 00:00:00	2018-06-30 00:00:00	2019-06-30 00:00:00	2015-12-31 00:00:00	2015-12-31 00:00:00	2016-06-30 00:00:00	2016-06-30 00:00:00	2016-10-18 00:00:00	2016-10-22 00:00:00	2016-12-31 00:00:00	2016-10-22 00:00:00	2016-11-07 00:00:00	2016-12-31 00:00:00	2017-06-30 00:00:00	2017-06-30 00:00:00	2017-12-31 00:00:00	2018-09-22 00:00:00	2019-12-31 00:00:00	2018-10-29 00:00:00	2018-04-06 00:00:00	2020-06-30 00:00:00	2020-06-30 00:00:00	2018-11-02 00:00:00	2018-09-18 00:00:00	2018-12-31 00:00:00	2018-06-30 00:00:00	2018-04-18 00:00:00	2020-12-31 00:00:00	2018-12-31 00:00:00	2018-04-21 00:00:00	None	2019-06-30 00:00:00	None	2022-05-16 00:00:00	2021-06-30 00:00:00	2022-01-05 00:00:00	2022-04-23 00:00:00	2022-06-30 00:00:00	2022-03-18 00:00:00	2021-12-31 00:00:00	2021-06-30 00:00:00	2022-09-24 00:00:00	2022-09-16 00:00:00	2022-05-21 00:00:00	2020-12-31 00:00:00	2021-06-16 00:00:00	2021-12-31 00:00:00	2022-05-21 00:00:00	2022-04-23 00:00:00	2022-09-24 00:00:00	2022-06-30 00:00:00	2022-10-22 00:00:00	2022-10-21 00:00:00
rpt_date	None	None	None	2013-07-26 00:00:00	None	2015-07-24 00:00:00	2014-07-30 00:00:00	2014-05-16 00:00:00	None	None	None	2014-10-03 00:00:00	2014-10-17 00:00:00	2014-10-23 00:00:00	None	None	2008-10-06 00:00:00	2008-07-31 00:00:00	None	2008-10-07 00:00:00	None	2009-02-02 00:00:00	None	2009-07-28 00:00:00	None	None	None	None	None	2010-01-27 00:00:00	2010-03-22 00:00:00	2010-07-28 00:00:00	None	None	None	2010-10-21 00:00:00	2010-10-29 00:00:00	None	None	2010-10-04 00:00:00	2011-01-31 00:00:00	None	None	None	2011-07-28 00:00:00	None	None	2012-02-28 00:00:00	None	2012-03-22 00:00:00	2012-01-31 00:00:00	None	2012-05-24 00:00:00	None	2012-07-31 00:00:00	2014-01-23 00:00:00	None	None	2012-07-27 00:00:00	2015-01-27 00:00:00	None	None	None	2014-08-07 00:00:00	2013-01-30 00:00:00	None	2014-05-21 00:00:00	2014-04-11 00:00:00	None	None	None	None	2020-01-28 00:00:00	2018-01-23 00:00:00	2018-09-27 00:00:00	2018-11-02 00:00:00	2018-04-16 00:00:00	2018-07-24 00:00:00	None	2016-01-28 00:00:00	None	2016-07-29 00:00:00	None	2016-10-18 00:00:00	None	2017-01-30 00:00:00	2016-10-27 00:00:00	2016-11-07 00:00:00	None	2017-07-20 00:00:00	None	None	None	None	2018-10-29 00:00:00	2018-04-06 00:00:00	2020-07-30 00:00:00	None	2018-11-02 00:00:00	2018-09-18 00:00:00	2019-01-29 00:00:00	None	2018-04-18 00:00:00	None	None	2018-04-25 00:00:00	None	2019-07-26 00:00:00	None	2022-05-16 00:00:00	2021-07-27 00:00:00	None	None	2022-07-26 00:00:00	2022-03-18 00:00:00	None	None	2022-09-27 00:00:00	2022-09-16 00:00:00	None	2021-01-23 00:00:00	2021-06-16 00:00:00	2022-01-29 00:00:00	2022-05-25 00:00:00	2022-04-26 00:00:00	None	None	2022-10-26 00:00:00	2022-10-21 00:00:00
filing_type	None	None	None	22001	None	22001	22001	22001	None	None	None	22001	22001	22001	None	None	22001	22001	None	22001	None	22001	22001	22001	None	22001	None	None	None	22001	22001	22001	None	None	None	22001	22001	None	None	22001	22001	22001	None	None	22001	None	None	22001	None	22001	22001	None	22001	None	22001	22001	None	None	22001	22001	None	None	None	22001	22001	22001	22001	22001	None	None	None	22001	22001	22001	22001	22001	22001	22001	None	22001	None	22001	None	22001	None	22001	22001	22001	None	22001	None	None	None	None	22001	22001	22001	None	22001	22001	22001	None	22001	None	None	22001	None	22001	None	22001	22001	22001	None	22001	22001	None	None	22001	22001	None	22001	22001	22001	22001	22001	None	None	22001	22001

Table: filer_to_filer_type
filer_id	1298011	1298011
filer_type	16	16
active	Y	Y
race	0	0
session_id	2007	2009
category	0	0
category_type	40502	40502
sub_category	40103	40103
effect_dt	2007-05-11 00:00:00	2009-04-07 00:00:00
sub_category_type	0	40203
election_type	0	0
sub_category_a	S	S
nyq_dt	None	2007-09-28 00:00:00
party_cd	0	0
county_cd	18001	18001
district_cd	0	0

Table: filer_xref
filer_id		1298011
xref_id		1298011
effect_dt		2007-05-11 00:00:00
migration_source		CLAIMS

Table: filername
xref_filer_id	1298011	1298011	1298011	1298011	1298011	1298011	1298011
filer_id	1298011	1298011	1298011	1298011	1298011	1298011	1298011
filer_type	RECIPIENT COMMITTEE	RECIPIENT COMMITTEE	RECIPIENT COMMITTEE	RECIPIENT COMMITTEE	RECIPIENT COMMITTEE	RECIPIENT COMMITTEE	RECIPIENT COMMITTEE
status	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE
effect_dt	2009-04-07 00:00:00	2009-04-07 00:00:00	2009-04-07 00:00:00	2009-04-07 00:00:00	2009-04-07 00:00:00	2009-04-07 00:00:00	2009-04-07 00:00:00
naml	SPRINKLER FITTERS & APPRENTICES LOCAL 483 STATEWIDE PAC	SPRINKLER FITTERS & APPRENTICES LOCAL 483 STATEWIDE PAC	SPRINKLER FITTERS & APPRENTICES LOCAL 483 STATEWIDE PAC	SPRINKLER FITTERS & APPRENTICES LOCAL 483 STATEWIDE PAC	SPRINKLER FITTERS & APPRENTICES LOCAL 483 STATEWIDE PAC	SPRINKLER FITTERS & APPRENTICES LOCAL 483 STATEWIDE PAC	SPRINKLER FITTERS & APPRENTICES LOCAL 483 STATEWIDE PAC
namf	None	None	None	None	None	None	None
namt	None	None	None	None	None	None	None
nams	None	None	None	None	None	None	None
adr1	None	None	None	None	None	None	None
adr2	None	None	None	None	None	None	None
city	HAYWARD	SACRAMENTO	HAYWARD	HAYWARD	SACRAMENTO	HAYWARD	SACRAMENTO
st	CA	CA	CA	CA	CA	CA	CA
zip4	94545	95814	94545	94545	95814	94545	95814
phon	5107858483	None	5107858483	5107858483	5107858483	5107858483	5107858483
fax	None	None	None	None	None	None	None
email	None	None	info@olsonhagel.com	info@olsonhagel.com	info@olsonhagel.com	compliance@olsonremcho.com	compliance@olsonremcho.com

Table: filers
filer_id		1298011

Table: received_filings
filer_id	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011	1298011
filing_file_name	450535.cal	45694.cal	1850973_0.cal	54782.cal	410076.cal	410198.cal	1539055_0.cal	1838011_0.cal	2105849_0.cal	1875292_0.cal	2091113_0.cal	1900103_0.cal	2323028_0.cal	2228765_0.cal	2315417_0.cal	2293226_0.cal	2315417_1.cal	2232210_0.cal	2721073_0.cal	2682957_0.cal	2739068_0.cal	509985.cal	2658550_0.cal	513784.cal	514061.cal
received_date	2009-04-07 00:00:00	2008-10-29 00:00:00	2014-05-16 00:00:00	2013-01-30 00:00:00	2012-07-27 00:00:00	2012-07-27 00:00:00	2010-10-29 00:00:00	2014-04-11 00:00:00	2016-11-07 00:00:00	2014-08-07 00:00:00	2016-10-18 00:00:00	2014-10-17 00:00:00	2018-11-02 00:00:00	2018-04-06 00:00:00	2018-10-29 00:00:00	2018-09-18 00:00:00	2018-11-02 00:00:00	2018-04-18 00:00:00	2022-09-16 00:00:00	2022-05-16 00:00:00	2022-10-21 00:00:00	2022-04-28 00:00:00	2022-03-18 00:00:00	2022-04-28 00:00:00	2022-04-28 00:00:00
filing_directory	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/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	/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/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp
filing_id	None	None	1850973	None	None	None	1539055	1838011	2105849	1875292	2091113	1900103	2323028	2228765	2315417	2293226	2315417	2232210	2721073	2682957	2739068	None	2658550	None	None
form_id	None	None	F497	None	None	None	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	None	F497	None	None
receive_comment	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	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 accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	Filing accepted	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints