OpenCalAccess

Filer ID: 1220370

Table: cvr_campaign_disclosure
filing_id	668459	674907	706147	769907	785418	803600	820932	850016	871413	876563	911114	946894	962531	978701	1029393	1049253	1044271	1080668	1156695	1146706	1116586	1210577	1234157	1186813	1310883	1284150	1319902	1342452	1367935	1395730	1491086	1474122	1463099	1435966	1504434	1568297	1522296	1531436	1662674	1632590	1605764	1675165	1694030	1734422	1703265	1831952	1826535	1818143	1783378	1856914	1870757	1888395	1890204	1892571	1935566	2041748	1981283	2005892	2046461	2082852	2076293	2058745	2097269	2168761	2128056	2207036	2256439	2235381	2304261	2310075	2266117	2337490	2425106	2322893	2390480	2491110	2438667	2476727	2502016	2503766	2546511	2591407	2634831	2729998	2715350	2723704	2699101	2739219	2738057
amend_id	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	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	0	0	0	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	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	F497	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F497	F460	F460	F460	F460	F460	F460	F460	F460	F497	F460	F460	F497	F460	F497	F497	F460	F460	F497	F460	F460	F460	F460	F497	F460	F460	F460	F460	F460	F497	F460	F497	F460	F460	F460	F497	F497	F460	F497	F460	F460	F497	F460	F460	F450	F460	F497	F497	F460	F450	F460	F497
filer_id	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370
entity_cd	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP
filer_naml	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	Consumers for Clean Water PAC	Consumers for Clean Water PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	Consumers for Clean Water PAC	Consumers for Clean Water PAC	Consumers for Clean Water PAC	Consumers for Clean Water PAC	Consumers for Clean Water PAC	Consumers for Clean Water PAC	Consumers for Clean Water PAC	Consumers for Clean Water PAC	Consumers for Clean Water PAC	Consumers for Clean Water PAC	Consumers for Clean Water PAC	Consumers for Clean Water PAC	Consumers for Clean Water PAC	Consumers for Clean Water PAC	CONSUMERS FOR CLEAN WATER PAC	Consumers for Clean Water PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER 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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
filer_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
filer_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	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	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	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	000	000	000	000
rpt_date	2000-10-03 00:00:00	2000-10-21 00:00:00	2001-01-04 00:00:00	2001-07-25 00:00:00	2001-10-09 00:00:00	2002-01-07 00:00:00	2002-02-19 00:00:00	2002-07-12 00:00:00	2002-10-02 00:00:00	2002-10-22 00:00:00	2003-01-30 00:00:00	2003-07-30 00:00:00	2003-10-03 00:00:00	2004-01-07 00:00:00	2004-07-30 00:00:00	2004-10-19 00:00:00	2004-10-04 00:00:00	2005-01-28 00:00:00	2006-03-17 00:00:00	2006-01-30 00:00:00	2005-07-28 00:00:00	2006-10-23 00:00:00	2007-01-24 00:00:00	2006-07-24 00:00:00	2008-01-25 00:00:00	2007-07-30 00:00:00	2008-03-21 00:00:00	2008-07-08 00:00:00	2008-10-20 00:00:00	2009-01-26 00:00:00	2010-05-26 00:00:00	2010-03-17 00:00:00	2010-01-25 00:00:00	2009-07-22 00:00:00	2010-07-26 00:00:00	2011-01-06 00:00:00	2010-10-04 00:00:00	2010-10-21 00:00:00	2012-05-20 00:00:00	2012-01-26 00:00:00	2011-07-27 00:00:00	2012-07-10 00:00:00	2012-09-30 00:00:00	2013-01-17 00:00:00	2012-10-21 00:00:00	2014-03-18 00:00:00	2014-03-07 00:00:00	2014-01-29 00:00:00	2013-07-31 00:00:00	2014-05-30 00:00:00	2014-07-26 00:00:00	2014-09-25 00:00:00	2014-10-01 00:00:00	2014-10-03 00:00:00	2015-01-26 00:00:00	2016-05-11 00:00:00	2015-07-24 00:00:00	2016-01-19 00:00:00	2016-05-23 00:00:00	2016-09-26 00:00:00	2016-09-13 00:00:00	2016-07-14 00:00:00	2016-10-23 00:00:00	2017-07-19 00:00:00	2017-01-23 00:00:00	2018-01-28 00:00:00	2018-05-29 00:00:00	2018-04-24 00:00:00	2018-10-10 00:00:00	2018-10-22 00:00:00	2018-07-18 00:00:00	2019-01-22 00:00:00	2019-12-16 00:00:00	2018-11-02 00:00:00	2019-07-16 00:00:00	2020-08-14 00:00:00	2020-01-29 00:00:00	2020-07-03 00:00:00	2020-09-16 00:00:00	2020-09-22 00:00:00	2021-01-23 00:00:00	2021-07-07 00:00:00	2022-01-17 00:00:00	2022-10-07 00:00:00	2022-08-29 00:00:00	2022-09-26 00:00:00	2022-07-19 00:00:00	2022-10-22 00:00:00	2022-10-20 00:00:00
stmt_type	PE	PE	SA	SA	PE	SA	None	SA	PE	PE	SA	SA	PE	QT	SA	PE	PE	SA	PE	SA	SA	PE	SA	SA	SA	SA	PE	SA	PE	SA	PE	PE	SA	SA	SA	SA	PE	None	PE	SA	SA	SA	PE	SA	PE	PE	None	SA	SA	None	SA	None	None	PE	QT	None	SA	SA	PE	PE	None	SA	PE	SA	SA	SA	None	PE	None	PE	SA	SA	None	None	SA	None	SA	SA	None	PE	SA	SA	SA	None	None	PE	SA	PE	None
late_rptno	000006	000009	000026	000049	000060	000081	LCM-20218	000131	000141	000149	000197	000236	000270	000283	000353	000363	000356	000396	000527	000521	000455	000612	000641	000576	000714	000684	000726	000756	000786	000845	000735	000932	000711	000886	000743	000769	000762	LCM-01021	000894	000857	000807	000921	000976	001016	000992	001164	LCM-40306	001137	001082	LCM-40530	001265	LCM-40925	LCM-40929	001317	001393	LCM-60511	001464	001513	000002	000093	LCM-60913	000043	000138	None	000184	None	LCM-052918	None	2018-02	None	None	None	LCM-121319	LCM-110218	None	LCM-081420	None	None	LCM-091620	None	None	None	None	LCM-100722	LCM-082922	None	None	None	LCM-10202022
from_date	2000-07-01 00:00:00	2000-10-01 00:00:00	2000-10-22 00:00:00	2001-01-01 00:00:00	2001-07-01 00:00:00	2001-10-01 00:00:00	2002-02-18 00:00:00	2002-01-01 00:00:00	2002-07-01 00:00:00	2002-10-01 00:00:00	2002-10-20 00:00:00	2003-01-01 00:00:00	2003-07-01 00:00:00	2003-10-01 00:00:00	2004-01-01 00:00:00	2004-10-01 00:00:00	2004-07-01 00:00:00	2004-10-17 00:00:00	2006-01-01 00:00:00	2005-07-01 00:00:00	2005-01-01 00:00:00	2006-07-01 00:00:00	2006-10-22 00:00:00	2006-03-18 00:00:00	2007-07-01 00:00:00	2007-01-01 00:00:00	2008-01-01 00:00:00	2008-03-18 00:00:00	2008-07-01 00:00:00	2008-10-19 00:00:00	2010-03-18 00:00:00	2010-01-01 00:00:00	2009-07-01 00:00:00	2009-01-01 00:00:00	2010-05-23 00:00:00	2010-10-01 00:00:00	2010-07-01 00:00:00	2010-10-21 00:00:00	2012-01-01 00:00:00	2011-07-01 00:00:00	2011-01-01 00:00:00	2012-05-20 00:00:00	2012-07-01 00:00:00	2012-10-21 00:00:00	2012-10-01 00:00:00	2014-01-01 00:00:00	2014-03-06 00:00:00	2013-07-01 00:00:00	2013-01-01 00:00:00	2014-05-30 00:00:00	2014-03-18 00:00:00	2014-09-25 00:00:00	2014-09-29 00:00:00	2014-07-01 00:00:00	2014-10-01 00:00:00	2016-05-11 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	2016-09-13 00:00:00	2016-05-22 00:00:00	2016-09-25 00:00:00	2017-01-01 00:00:00	2016-10-23 00:00:00	2017-07-01 00:00:00	None	2018-01-01 00:00:00	None	2018-07-01 00:00:00	2018-04-22 00:00:00	2018-10-21 00:00:00	None	None	2019-01-01 00:00:00	None	2019-07-01 00:00:00	2020-01-01 00:00:00	None	2020-07-01 00:00:00	2020-09-20 00:00:00	2021-01-01 00:00:00	2021-07-01 00:00:00	None	None	2022-07-01 00:00:00	2022-01-01 00:00:00	2022-09-25 00:00:00	None
thru_date	2000-09-30 00:00:00	2000-10-21 00:00:00	2000-12-31 00:00:00	2001-06-30 00:00:00	2001-09-30 00:00:00	2001-12-31 00:00:00	2002-02-18 00:00:00	2002-06-30 00:00:00	2002-09-30 00:00:00	2002-10-19 00:00:00	2002-12-31 00:00:00	2003-06-30 00:00:00	2003-09-30 00:00:00	2003-12-31 00:00:00	2004-06-30 00:00:00	2004-10-16 00:00:00	2004-09-30 00:00:00	2004-12-31 00:00:00	2006-03-17 00:00:00	2005-12-31 00:00:00	2005-06-30 00:00:00	2006-10-21 00:00:00	2006-12-31 00:00:00	2006-06-30 00:00:00	2007-12-31 00:00:00	2007-06-30 00:00:00	2008-03-17 00:00:00	2008-06-30 00:00:00	2008-10-18 00:00:00	2008-12-31 00:00:00	2010-05-22 00:00:00	2010-03-17 00:00:00	2009-12-31 00:00:00	2009-06-30 00:00:00	2010-06-30 00:00:00	2010-12-31 00:00:00	2010-09-30 00:00:00	2010-10-21 00:00:00	2012-05-19 00:00:00	2011-12-31 00:00:00	2011-06-30 00:00:00	2012-06-30 00:00:00	2012-09-30 00:00:00	2012-12-31 00:00:00	2012-10-20 00:00:00	2014-03-17 00:00:00	2014-03-06 00:00:00	2013-12-31 00:00:00	2013-06-30 00:00:00	2014-05-30 00:00:00	2014-06-30 00:00:00	2014-09-25 00:00:00	2014-09-29 00:00:00	2014-09-30 00:00:00	2014-12-31 00:00:00	2016-05-11 00:00:00	2015-06-30 00:00:00	2015-12-31 00:00:00	2016-05-21 00:00:00	2016-09-24 00:00:00	2016-09-13 00:00:00	2016-06-30 00:00:00	2016-10-22 00:00:00	2017-06-30 00:00:00	2016-12-31 00:00:00	2017-12-31 00:00:00	None	2018-04-21 00:00:00	None	2018-10-20 00:00:00	2018-06-30 00:00:00	2018-12-31 00:00:00	None	None	2019-06-30 00:00:00	None	2019-12-31 00:00:00	2020-06-30 00:00:00	None	2020-09-19 00:00:00	2020-12-31 00:00:00	2021-06-30 00:00:00	2021-12-31 00:00:00	None	None	2022-09-24 00:00:00	2022-06-30 00:00:00	2022-10-22 00:00:00	None
elect_date	2000-11-07 00:00:00	2000-11-07 00:00:00	2000-11-07 00:00:00	2002-03-05 00:00:00	2002-03-05 00:00:00	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	2018-11-06 00:00:00	None	None	None	None	None	None	None	None	None	2020-11-03 00:00:00	None	None	None	None	None	2022-11-08 00:00:00	None	2022-11-08 00:00:00	None
filer_city	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	Sacramento	Sacramento	SACRAMENTO	SACRAMENTO	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	SACRAMENTO	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO
filer_st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA
filer_zip4	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814
filer_phon	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	9164428888	(916) 442-8888	9164428888	9164428888	9164428888	9164428888	9164428888	9164428888	9164428888	9164428888	9164428888	9164428888	9164428888	9164428888	9164428888	9164428888	9164428888	9164428888	9164428888	9164428888	9164428888	9164428888	9164428888	9164428888	9164428888	9164428888
filer_fax	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	(916) 442-0382	9164420382	(916) 442-0382	9164420382	9164420382	9164420382	9164420382	9164420382	9164420382	9164420382	9164420382	9164420382	9164420382	9164420382	9164420382	9164420382	9164420382	9164420382	9164420382	9164420382	9164420382	9164420382	9164420382	9164420382	9164420382	9164420382	9164420382
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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]
mail_city	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	ROBERTS	ROBERTS	ROBERTS	ROBERTS	ROBERTS	ROBERTS	ROBERTS	ROBERTS	ROBERTS	ROBERTS	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	Roberts	None	Roberts	None	Roberts	Karen	Roberts	None	None	Roberts	None	Roberts	Roberts	None	Roberts	Roberts	Roberts	Roberts	None	None	Roberts	Roberts	Roberts	None
tres_namf	KAREN	KAREN	KAREN	KAREN	KAREN	KAREN	KAREN	KAREN	KAREN	KAREN	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	Karen	None	Karen	None	Karen	Roberts	Karen	None	None	Karen	None	Karen	Karen	None	Karen	Karen	Karen	Karen	None	None	Karen	Karen	Karen	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
tres_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
tres_city	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	None	Sacramento	None	Sacramento	Sacramento	Sacramento	None	None	Sacramento	None	Sacramento	Sacramento	None	Sacramento	Sacramento	Sacramento	Sacramento	None	None	Sacramento	Sacramento	Sacramento	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	CA	CA	CA	CA	CA	CA	None	CA	None	CA	CA	CA	None	None	CA	None	CA	CA	None	CA	CA	CA	CA	None	None	CA	CA	CA	None
tres_zip4	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	None	95814	None	95814	95814	95814	None	None	95814	None	95814	95814	None	95814	95814	95814	95814	None	None	95814	95814	95814	None
tres_phon	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	(916) 442-8888	9164428888	(916) 442-8888	9164428888	None	9164428888	None	9164428888	9164428888	9164428888	None	None	9164428888	None	9164428888	9164428888	None	9169307716	9169307716	9164428888	9169307716	None	None	9169307716	9169307716	9169307716	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	9164420382	None	9164420382	None	9164420382	None	9164420382	9164420382	9164420382	None	None	9164420382	None	9164420382	9164420382	None	9164420382	9164420382	9164420382	9164420382	None	None	9164420382	9164420382	9164420382	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	[email protected]	None	[email protected]	None	[email protected]	None	[email protected]	[email protected]	[email protected]	None	None	[email protected]	None	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]	[email protected]	[email protected]	None
cmtte_type	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	None	G	None	G	G	G	None	None	G	None	G	G	None	G	G	G	G	None	None	G	G	G	None
control_yn	None	None	None	None	None	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	None	N	None	N	N	N	None	None	N	None	N	N	None	N	N	N	N	None	None	N	N	N	None
sponsor_yn	N	N	N	N	N	Y	Y	Y	Y	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	None	N	None	N	N	N	None	None	N	None	N	N	None	N	N	N	N	None	None	N	N	N	None
primfrm_yn	None	None	None	None	None	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	None	N	None	N	N	N	None	None	N	None	N	N	None	N	N	None	N	None	None	N	None	N	None
brdbase_yn	N	N	N	N	N	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
amendexp_1	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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_2	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
amendexp_3	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
rpt_att_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cmtte_id	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
reportname	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
rptfromdt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
rptthrudt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
emplbus_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bus_name	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bus_city	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bus_st	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bus_zip4	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bus_inter	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
busact_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
busactvity	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
assoc_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
assoc_int	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
other_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
other_int	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cand_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cand_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	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	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cand_phon	( )	( )	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cand_fax	( )	( )	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cand_email	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bal_name	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bal_num	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bal_juris	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	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	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	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	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	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
sup_opp_cd	S	S	S	S	S	S	None	S	S	S	S	S	S	S	S	S	S	S	None	S	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	S	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	S	None	S	S	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
occupation	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
selfemp_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bal_id	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cand_id	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None

Table: cvr_so
filing_id	1402948	1402948	1402948	1402948	1402948
amend_id	0	1	2	3	4
rec_type	CVR	CVR	CVR	CVR	CVR
form_type	F410	F410	F410	F410	F410
filer_id	1220370	1220370	1220370	1220370	1220370
entity_cd	RCP	RCP	RCP	RCP	RCP
filer_naml	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC	Consumers for Clean Water PAC	CONSUMERS FOR CLEAN WATER PAC
filer_namf	None	None	None	None	None
filer_namt	None	None	None	None	None
filer_nams	None	None	None	None	None
report_num	000	001	002	003	004
rpt_date	2009-02-18 00:00:00	2009-02-18 00:00:00	2012-06-07 00:00:00	2017-03-24 00:00:00	2021-07-07 00:00:00
qual_cb	None	None	None	X	None
qualfy_dt	2000-01-25 00:00:00	2000-01-25 00:00:00	2000-01-25 00:00:00	2000-01-25 00:00:00	2000-01-25 00:00:00
term_date	None	None	None	None	None
city	SACRAMENTO	SACRAMENTO	Sacramento	Sacramento	SACRAMENTO
st	CA	CA	CA	CA	CA
zip4	95814	95814	95814	95814	95814
phone	9164428888	9164428888	9164428888	916 442-8888	9164428888
county_res	None	Sacramento	Sacramento	Sacramento	Sacramento
county_act	None	None	Los Angeles	Los Angeles	Los Angeles
mail_city	None	None	None	None	None
mail_st	None	None	None	None	None
mail_zip4	None	None	None	None	None
cmte_fax	None	9164420382	9164420382	916 442-0382	9164420382
cmte_email	None	[email protected]	[email protected]	[email protected]	[email protected]
tres_naml	Roberts	Roberts	Roberts	Roberts	Roberts
tres_namf	Karen	Karen	Karen	Karen L.	Karen L.
tres_namt	None	None	None	None	None
tres_nams	None	None	None	None	None
tres_city	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento
tres_st	CA	CA	CA	CA	CA
tres_zip4	95814	95814	95814	95814	95814
tres_phon	9164428888	9164428888	9164428888	916 442-8888	9164428888
actvty_lvl	ST	ST	ST	ST	CO
com82013yn	None	None	None	None	None
com82013nm	None	None	None	None	None
com82013id	None	None	None	None	None
control_cb	None	None	None	None	None
bank_nam	None	None	None	US Bank	US Bank
bank_adr1	None	None	None	P.O. Box 1800	P.O. Box 1800
bank_adr2	None	None	None	None	None
bank_city	None	None	None	Saint Paul	Saint Paul
bank_st	None	None	None	MN	MN
bank_zip4	None	None	None	55101	55101
bank_phon	None	None	None	None	8006733555
acct_opendt	None	None	None	None	None
surplusdsp	None	None	None	None	None
primfc_cb	None	None	None	None	None
genpurp_cb	X	X	X	X	X
gpc_descr	Provide contributions to candidates for state legislature and constitutional offices.	Provide contributions to candidates for state and local office.	Provide contributions to candidates for state and local office.	Provide contributions to candidates for state and local office.	Provide contributions to candidates for state and local office.
sponsor_cb	None	None	None	None	None
brdbase_cb	None	None	None	None	None
smcont_qualdt	None	None	None	None	None

Table: efs_filing_log
filing_date	2001-10-09 00:00:00	2001-10-09 00:00:00	2001-07-25 00:00:00	2001-07-25 00:00:00	2002-01-07 00:00:00	2002-01-07 00:00:00	2002-02-19 00:00:00	2002-07-17 00:00:00	2002-07-17 00:00:00	2002-10-07 00:00:00	2002-10-07 00:00:00	2002-10-22 00:00:00	2002-10-22 00:00:00	2003-01-30 00:00:00	2003-01-30 00:00:00	2003-07-30 00:00:00	2003-07-30 00:00:00	2003-10-08 00:00:00	2003-10-08 00:00:00	2004-01-08 00:00:00	2004-01-08 00:00:00
filingstatus	1	0	1	0	1	0	0	1	0	1	0	1	0	1	0	1	0	1	0	1	0
vendor	STATECRAFT	STATECRAFT	STATECRAFT	STATECRAFT	STATECRAFT	STATECRAFT	STATECRAFT	STATECRAFT	STATECRAFT	STATECRAFT	STATECRAFT	STATECRAFT	STATECRAFT	STATECRAFT	STATECRAFT	STATECRAFT	STATECRAFT	STATECRAFT	STATECRAFT	STATECRAFT	STATECRAFT
filer_id	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370
form_type	F460	F460	F460	F460	F460	F460	F497	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460
error_no	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED

Table: filer_address
filer_id	1220370	1220370
adrid	1129821	2234230
effect_dt	2000-01-25 00:00:00	2012-06-08 00:00:00
add_type	7051	7051
session_id	1999	2011

Table: filer_filings
filer_id	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370
filing_id	592799	580083	672314	674907	676669	643721	668459	706147	710661	782595	769907	786033	785418	803600	804590	824524	820932	871713	850016	866001	866004	871413	855517	879088	876563	915732	911114	962741	946894	951684	962531	978701	983440	1029393	1033139	1047468	1049253	1044271	1050790	1080668	1116586	1120156	1088067	1146706	1149844	1156695	1158488	1186813	1192797	1210577	1214829	1234157	1239371	1284150	1286155	1981283	1870757	1856914	1783378	1786724	1935566	1944271	1893890	1320061	1319902	1310883	1312589	1343621	1342452	1367935	1371287	1397683	1403510	1402948	1395730	1402948	1435966	1440454	1474973	1463099	1491086	1466095	1474122	1504434	1522296	1492545	1508717	1527270	1531436	1544260	1570144	1568297	1607077	1605764	1632590	1638026	1675165	1402948	1662674	1679611	1665706	1668789	1821717	1826535	1831952	1818143	1694030	1694798	1703265	1702963	1888395	1890204	1892571	1874885	1734422	1738117	1833776	1985004	2337490	2235381	2492394	2546511	2266117	2476727	2403866	2390480	2310075	2304261	2014208	2005892	2046461	2041748	2048325	2058745	2076293	2082852	2097269	2094238	2128056	2107958	2148744	1402948	2168761	2172511	2147786	2164523	2216985	2322893	2491110	2425106	2451965	2207036	2509534	2438667	2268428	2314852	2256439	2237716	2502016	2503766	2356042	2561717	2591407	2595473	2699101	1402948	2723704	2634831	2715350	2595723	2651139	2729687	2738057	2729998	2739219
period_id	None	None	None	164	None	None	163	164	None	None	165	None	167	168	None	None	169	None	169	157	157	171	None	None	172	None	172	None	173	None	175	176	None	177	None	None	180	179	None	180	181	None	None	183	None	185	None	185	None	187	None	188	None	189	None	221	217	218	213	None	220	None	None	None	193	191	None	None	193	195	None	None	None	197	196	197	197	None	None	199	201	None	201	202	203	None	None	None	204	None	None	204	None	205	207	None	210	210	209	None	None	None	None	217	217	215	211	None	212	None	219	220	219	None	212	None	None	None	236	233	None	243	234	241	None	237	235	236	None	223	225	226	None	226	227	227	227	None	228	None	None	229	229	None	None	None	None	236	243	240	None	231	None	239	None	None	234	None	243	243	None	None	245	None	249	247	251	247	251	None	None	None	252	252	251
form_id	F460	F410	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F497	F497	F460	F460	F666	F666	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F497	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F410	F410	F460	F410	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F497	F497	F460	F460	F460	F460	F460	F460	F460	F410	F460	F460	F460	F410	F460	F497	F460	F460	F460	F460	F460	F460	F497	F497	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F497	F460	F460	F460	F497	F460	F460	F497	F460	F460	F460	F460	F460	F410	F410	F460	F460	F460	F460	F460	F497	F497	F497	F460	F460	F460	F460	F460	F460	F497	F460	F497	F460	F460	F460	F450	F410	F450	F410	F460	F460	F497	F450	F460	F450	F497	F497	F460
filing_sequence	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	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	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	2	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	0	0	0	0	0	0	0	0	0	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	4	0	0	0	0	0	0	0	0	0
filing_date	2000-02-22 00:00:00	2000-01-25 00:00:00	2000-10-05 00:00:00	2000-10-24 00:00:00	2000-10-24 00:00:00	2000-07-27 00:00:00	2000-10-03 00:00:00	2001-01-05 00:00:00	2001-01-10 00:00:00	2001-07-31 00:00:00	2001-07-25 00:00:00	2001-10-10 00:00:00	2001-10-09 00:00:00	2002-01-07 00:00:00	2002-01-09 00:00:00	2002-02-19 00:00:00	2002-02-19 00:00:00	2002-10-07 00:00:00	2002-07-17 00:00:00	2002-09-03 00:00:00	2002-09-03 00:00:00	2002-10-07 00:00:00	2002-07-30 00:00:00	2002-10-23 00:00:00	2002-10-22 00:00:00	2003-01-31 00:00:00	2003-01-30 00:00:00	2003-10-06 00:00:00	2003-07-30 00:00:00	2003-07-31 00:00:00	2003-10-08 00:00:00	2004-01-08 00:00:00	2004-01-08 00:00:00	2004-07-30 00:00:00	2004-07-30 00:00:00	2004-10-05 00:00:00	2004-10-19 00:00:00	2004-10-04 00:00:00	2004-10-20 00:00:00	2005-01-31 00:00:00	2005-07-28 00:00:00	2005-07-29 00:00:00	2005-01-31 00:00:00	2006-01-30 00:00:00	2006-01-31 00:00:00	2006-03-21 00:00:00	2006-03-22 00:00:00	2006-07-24 00:00:00	2006-07-26 00:00:00	2006-10-24 00:00:00	2006-10-25 00:00:00	2007-01-29 00:00:00	2007-01-30 00:00:00	2007-07-31 00:00:00	2007-07-31 00:00:00	2015-07-30 00:00:00	2014-07-30 00:00:00	2014-05-30 00:00:00	2013-07-31 00:00:00	2013-07-31 00:00:00	2015-01-31 00:00:00	2015-01-27 00:00:00	2014-10-06 00:00:00	2008-03-24 00:00:00	2008-03-24 00:00:00	2008-01-31 00:00:00	2008-01-31 00:00:00	2008-07-14 00:00:00	2008-07-08 00:00:00	2008-10-21 00:00:00	2008-10-22 00:00:00	2009-01-30 00:00:00	2009-01-12 00:00:00	2009-02-18 00:00:00	2009-01-30 00:00:00	2009-02-18 00:00:00	2009-07-29 00:00:00	2009-07-30 00:00:00	2010-03-22 00:00:00	2010-01-29 00:00:00	2010-05-27 00:00:00	2010-01-29 00:00:00	2010-03-22 00:00:00	2010-07-28 00:00:00	2010-10-05 00:00:00	2010-05-27 00:00:00	2010-07-29 00:00:00	2010-10-05 00:00:00	2010-10-21 00:00:00	2010-10-21 00:00:00	2011-01-27 00:00:00	2011-01-27 00:00:00	2011-07-28 00:00:00	2011-07-28 00:00:00	2012-01-26 00:00:00	2012-01-30 00:00:00	2012-07-26 00:00:00	2012-06-07 00:00:00	2012-05-23 00:00:00	2012-07-26 00:00:00	2012-05-24 00:00:00	2012-06-08 00:00:00	2014-01-31 00:00:00	2014-03-07 00:00:00	2014-03-24 00:00:00	2014-01-31 00:00:00	2012-10-04 00:00:00	2012-10-04 00:00:00	2012-10-25 00:00:00	2012-10-24 00:00:00	2014-09-25 00:00:00	2014-10-01 00:00:00	2014-10-06 00:00:00	2014-07-31 00:00:00	2013-01-29 00:00:00	2013-01-24 00:00:00	2014-03-24 00:00:00	2015-07-31 00:00:00	2019-01-22 00:00:00	2018-04-24 00:00:00	2020-07-30 00:00:00	2021-01-23 00:00:00	2018-07-18 00:00:00	2020-07-03 00:00:00	2019-07-26 00:00:00	2019-07-16 00:00:00	2018-10-22 00:00:00	2018-10-10 00:00:00	2016-01-27 00:00:00	2016-01-24 00:00:00	2016-05-26 00:00:00	2016-05-11 00:00:00	2016-05-25 00:00:00	2016-07-26 00:00:00	2016-09-13 00:00:00	2016-09-29 00:00:00	2016-10-27 00:00:00	2016-09-29 00:00:00	2017-01-30 00:00:00	2016-10-27 00:00:00	2017-03-24 00:00:00	2017-03-27 00:00:00	2017-07-19 00:00:00	2017-07-24 00:00:00	2017-01-31 00:00:00	2016-07-28 00:00:00	2018-01-31 00:00:00	2018-11-02 00:00:00	2020-08-14 00:00:00	2019-12-16 00:00:00	2020-01-31 00:00:00	2018-01-28 00:00:00	2020-09-24 00:00:00	2020-01-29 00:00:00	2018-07-23 00:00:00	2018-10-24 00:00:00	2018-05-29 00:00:00	2018-04-26 00:00:00	2020-09-16 00:00:00	2020-09-22 00:00:00	2019-01-29 00:00:00	2021-01-29 00:00:00	2021-07-07 00:00:00	2021-07-21 00:00:00	2022-07-19 00:00:00	2021-07-07 00:00:00	2022-09-26 00:00:00	2022-01-17 00:00:00	2022-08-29 00:00:00	2021-07-21 00:00:00	2022-01-26 00:00:00	2022-07-22 00:00:00	2022-10-20 00:00:00	2022-10-07 00:00:00	2022-10-22 00:00:00
stmnt_type	10005	10001	10005	10001	10005	10005	10001	10001	10005	10005	10001	10005	10001	10001	10005	10005	10001	10005	10001	10005	10005	10001	10005	10005	10001	10005	10001	10005	10001	10005	10001	10001	10005	10001	10005	10005	10001	10001	10005	10001	10001	10005	10005	10001	10005	10001	10005	10001	10005	10001	10005	10001	10005	10001	10005	10001	10001	10001	10001	10005	10001	10005	10005	10005	10001	10001	10005	10005	10001	10001	10005	10005	10006	10002	10001	10001	10001	10005	10005	10001	10001	10005	10001	10001	10001	10005	10005	10005	10001	10005	10005	10001	10005	10001	10001	10005	10001	10002	10001	10005	10005	10006	10005	10001	10001	10001	10001	10005	10001	10005	10001	10001	10001	10005	10001	10005	10005	10005	10001	10001	10005	10001	10001	10001	10005	10001	10001	10001	10005	10001	10001	10001	10005	10001	10001	10001	10001	10005	10001	10005	10006	10002	10001	10005	10005	10005	10005	10001	10001	10001	10005	10001	10005	10001	10005	10005	10001	10005	10001	10001	10005	10005	10001	10006	10001	10002	10001	10001	10001	10005	10005	10005	10001	10001	10001
stmnt_status	11001	11003	11003	11003	11003	11001	11003	11003	11003	11001	11003	11001	11003	11003	11001	11001	11003	11003	11003	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11003	11003	11003	11003	11003	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11003	11003	11003	11003	11003	11003	11003	11003	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	11003	11003	11003	11003	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11003	11003	11001	11001	11001	11003	11001	11003	11003	11003	11001	11001	11001	11001	11001	11001	11003	11001	11003	11001	11001	11001	11001	11001	11003	11003	11003	11001	11003	11001	11001	11003	11003	11003	11003
session_id	1999	1999	1999	1999	1999	1999	1999	1999	1999	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	1999	1999	2001	2001	2001	2001	2001	2001	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2005	2005	2003	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2007	2007	2015	2013	2013	2013	2013	2013	2013	2013	2007	2007	2007	2007	2007	2007	2007	2007	2009	2009	2009	2007	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2011	2011	2011	2011	2011	2011	2011	2011	2011	2011	2013	2013	2013	2013	2011	2011	2011	2011	2013	2013	2013	2013	2011	2011	2013	2015	2017	2017	2019	2019	2017	2019	2019	2019	2017	2017	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2017	2017	2017	2017	2015	2015	2017	2017	2019	2019	2019	2017	2019	2019	2017	2017	2017	2017	2019	2019	2017	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021
user_id	TTHAM	*	KCHAN	*	KCHAN	JLEHMAN	*	*	TWALLS	SARRIAGA	*	GPEREZ	*	*	GPEREZ	BINTHAVO	*	DBARRICK	*	PROBERTS	PROBERTS	*	DBARRICK	DBARRICK	*	DBARRICK	COMPLETED	KVANG	COMPLETED	KVOONG1	COMPLETED	COMPLETED	KLARRY	COMPLETED	EMCENTEE	GPEREZ	COMPLETED	COMPLETED	EMCENTEE	COMPLETED	*	CFLAGG	SARRIAGA	SARRIAGA	SARRIAGA	*	CFLAGG	SARRIAGA	SARRIAGA	SARRIAGA	SARRIAGA	*	CFLAGG	SARRIAGA	GPEREZ	MDIGRAZIA	SARRIAGA	WBROWN	CPON	CPON	SMCCONNAN	SMCCONNAN	JINGRAM	SARRIAGA	SARRIAGA	SARRIAGA	SARRIAGA	NWALKER	NWALKER	*	RGEREMIA	JVAZQUEZ	RGEREMIA	*	*	*	MMORENO	MMORENO	SARRIAGA	MMORENO	CPON	MMORENO	SARRIAGA	MMORENO	CPON	CPON	MMORENO	CPON	CREYNOLDS	MPACHECO	CPON	CPON	CPON	CPON	MDIGRAZIA	MDIGRAZIA	CPON	TRAMON	MDIGRAZIA	CPON	MDIGRAZIA	TRAMON	SARRIAGA	WBROWN	MDIGRAZIA	MDIGRAZIA	CAFILER	MPACHECO	CAFILER	MPACHECO	WBROWN	WBROWN	CAFILER	SARRIAGA	CPON	CPON	MDIGRAZIA	MDIGRAZIA	JFONSECA	HSTOVALL	IMEDINA	AXIONG	LBARTHOL	IMEDINA	HCOURSEY	HCOURSEY	HSTOVALL	CAFILER	MDIGRAZIA	MDIGRAZIA	SARRIAGA	KBANH	SARRIAGA	CAFILER	PDEO	SARRIAGA	GPEREZ	SARRIAGA	SARRIAGA	GPEREZ	TRAMON	CAFILER	BSINGH	BSINGH	SARRIAGA	SMCCONNAN	KKRASNAYA	CAFILER	CAFILER	CAFILER	HCOURSEY	KKRASNAYA	IMEDINA	HCOURSEY	LBARTHOL	HSTOVALL	CAFILER	HSTOVALL	CAFILER	IMEDINA	JFONSECA	AXIONG	SARRIAGA	IMEDINA	CAFILER	CAFILER	CAFILER	SARRIAGA	CAFILER	SARRIAGA	SARRIAGA	JMAVES	CAFILER	CAFILER	CAFILER
special_audit	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003
fine_audit	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	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	11001	11003	11001	11001	11001	11001	11001	11003	11001	11003	11003	11001	11001	11001	11003	11003	11003	11003	11003	11003	11003	11001	11001	11003	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11003	11003	11001	11001	11001	11003	11003	11003	11003	11001	11001	11003	11003	11001	11001	11001	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11001	11003	11001	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
rpt_start	2000-01-01 00:00:00	None	2000-07-01 00:00:00	2000-10-01 00:00:00	2000-10-01 00:00:00	2000-02-20 00:00:00	2000-07-01 00:00:00	2000-10-22 00:00:00	2000-10-22 00:00:00	2001-01-01 00:00:00	2001-01-01 00:00:00	2001-07-01 00:00:00	2001-07-01 00:00:00	2001-10-01 00:00:00	2001-10-01 00:00:00	None	2002-02-19 00:00:00	2002-07-01 00:00:00	2002-01-01 00:00:00	2000-01-01 00:00:00	1999-01-01 00:00:00	2002-07-01 00:00:00	2002-01-01 00:00:00	2002-10-01 00:00:00	2002-10-01 00:00:00	2002-10-20 00:00:00	2002-10-20 00:00:00	2003-07-01 00:00:00	2003-01-01 00:00:00	2003-01-01 00:00:00	2003-07-01 00:00:00	2003-10-01 00:00:00	2003-10-01 00:00:00	2004-01-01 00:00:00	2004-01-01 00:00:00	2004-07-01 00:00:00	2004-10-01 00:00:00	2004-07-01 00:00:00	2004-10-01 00:00:00	2004-10-17 00:00:00	2005-01-01 00:00:00	2005-01-01 00:00:00	2004-10-17 00:00:00	2005-07-01 00:00:00	2005-07-01 00:00:00	2006-01-01 00:00:00	2006-01-01 00:00:00	2006-03-18 00:00:00	2006-03-18 00:00:00	2006-07-01 00:00:00	2006-07-01 00:00:00	2006-10-22 00:00:00	2006-10-22 00:00:00	2007-01-01 00:00:00	2007-01-01 00:00:00	2015-01-01 00:00:00	2014-03-18 00:00:00	2014-05-30 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2014-10-01 00:00:00	2014-10-01 00:00:00	2014-07-01 00:00:00	2008-01-01 00:00:00	2008-01-01 00:00:00	2007-07-01 00:00:00	2007-07-01 00:00:00	2008-03-18 00:00:00	2008-03-18 00:00:00	2008-07-01 00:00:00	2008-07-01 00:00:00	2008-10-19 00:00:00	None	2009-02-18 00:00:00	2008-10-19 00:00:00	2009-02-18 00:00:00	2009-01-01 00:00:00	2009-01-01 00:00:00	2010-01-01 00:00:00	2009-07-01 00:00:00	2010-03-18 00:00:00	2009-07-01 00:00:00	2010-01-01 00:00:00	2010-05-23 00:00:00	2010-07-01 00:00:00	2010-03-18 00:00:00	2010-05-23 00:00:00	2010-07-01 00:00:00	2010-10-21 00:00:00	None	2010-10-01 00:00:00	2010-10-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-07-01 00:00:00	2011-07-01 00:00:00	2012-05-20 00:00:00	2012-06-07 00:00:00	2012-01-01 00:00:00	2012-05-20 00:00:00	2012-01-01 00:00:00	None	2013-07-01 00:00:00	2014-03-07 00:00:00	2014-01-01 00:00:00	2013-07-01 00:00:00	2012-07-01 00:00:00	2012-07-01 00:00:00	2012-10-01 00:00:00	2012-10-01 00:00:00	2014-09-25 00:00:00	2014-10-01 00:00:00	2014-07-01 00:00:00	2014-03-18 00:00:00	2012-10-21 00:00:00	2012-10-21 00:00:00	2014-01-01 00:00:00	2015-01-01 00:00:00	2018-10-21 00:00:00	2018-01-01 00:00:00	2020-01-01 00:00:00	2020-09-20 00:00:00	2018-04-22 00:00:00	2020-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2018-07-01 00:00:00	2018-10-10 00:00:00	2015-07-01 00:00:00	2015-07-01 00:00:00	2016-01-01 00:00:00	2016-05-11 00:00:00	2016-01-01 00:00:00	2016-05-22 00:00:00	2016-09-13 00:00:00	2016-07-01 00:00:00	2016-09-25 00:00:00	2016-07-01 00:00:00	2016-10-23 00:00:00	2016-09-25 00:00:00	None	2017-03-24 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2016-10-23 00:00:00	2016-05-22 00:00:00	2017-07-01 00:00:00	2018-11-02 00:00:00	2020-08-14 00:00:00	2019-12-16 00:00:00	2019-07-01 00:00:00	2017-07-01 00:00:00	2020-07-01 00:00:00	2019-07-01 00:00:00	2018-04-22 00:00:00	2018-07-01 00:00:00	2018-05-29 00:00:00	2018-01-01 00:00:00	2020-09-16 00:00:00	2020-07-01 00:00:00	2018-10-21 00:00:00	2020-09-20 00:00:00	2021-01-01 00:00:00	None	2022-01-01 00:00:00	2021-07-07 00:00:00	2022-07-01 00:00:00	2021-07-01 00:00:00	2022-08-29 00:00:00	2021-01-01 00:00:00	2021-07-01 00:00:00	2022-01-01 00:00:00	2022-10-20 00:00:00	2022-10-07 00:00:00	2022-09-25 00:00:00
rpt_end	2000-02-19 00:00:00	None	2000-09-30 00:00:00	2000-10-21 00:00:00	2000-10-21 00:00:00	2000-06-30 00:00:00	2000-09-30 00:00:00	2000-12-31 00:00:00	2000-12-31 00:00:00	2001-06-30 00:00:00	2001-06-30 00:00:00	2001-09-30 00:00:00	2001-09-30 00:00:00	2001-12-31 00:00:00	2001-12-31 00:00:00	None	2002-02-19 00:00:00	2002-09-30 00:00:00	2002-06-30 00:00:00	2000-12-31 00:00:00	1999-03-31 00:00:00	2002-09-30 00:00:00	2002-06-30 00:00:00	2002-10-19 00:00:00	2002-10-19 00:00:00	2002-12-31 00:00:00	2002-12-31 00:00:00	2003-09-30 00:00:00	2003-06-30 00:00:00	2003-06-30 00:00:00	2003-09-30 00:00:00	2003-12-31 00:00:00	2003-12-31 00:00:00	2004-06-30 00:00:00	2004-06-30 00:00:00	2004-09-30 00:00:00	2004-10-16 00:00:00	2004-09-30 00:00:00	2004-10-16 00:00:00	2004-12-31 00:00:00	2005-06-30 00:00:00	2005-06-30 00:00:00	2004-12-31 00:00:00	2005-12-31 00:00:00	2005-12-31 00:00:00	2006-03-17 00:00:00	2006-03-17 00:00:00	2006-06-30 00:00:00	2006-06-30 00:00:00	2006-10-21 00:00:00	2006-10-21 00:00:00	2006-12-31 00:00:00	2006-12-31 00:00:00	2007-06-30 00:00:00	2007-06-30 00:00:00	2015-06-30 00:00:00	2014-06-30 00:00:00	2014-05-30 00:00:00	2013-06-30 00:00:00	2013-06-30 00:00:00	2014-12-31 00:00:00	2014-12-31 00:00:00	2014-09-30 00:00:00	2008-03-17 00:00:00	2008-03-17 00:00:00	2007-12-31 00:00:00	2007-12-31 00:00:00	2008-06-30 00:00:00	2008-06-30 00:00:00	2008-10-18 00:00:00	2008-10-18 00:00:00	2008-12-31 00:00:00	None	2009-02-18 00:00:00	2008-12-31 00:00:00	2009-02-18 00:00:00	2009-06-30 00:00:00	2009-06-30 00:00:00	2010-03-17 00:00:00	2009-12-31 00:00:00	2010-05-22 00:00:00	2009-12-31 00:00:00	2010-03-17 00:00:00	2010-06-30 00:00:00	2010-09-30 00:00:00	2010-05-22 00:00:00	2010-06-30 00:00:00	2010-09-30 00:00:00	2010-10-21 00:00:00	None	2010-12-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	2011-12-31 00:00:00	2012-06-30 00:00:00	2012-06-07 00:00:00	2012-05-19 00:00:00	2012-06-30 00:00:00	2012-05-19 00:00:00	None	2013-12-31 00:00:00	2014-03-07 00:00:00	2014-03-17 00:00:00	2013-12-31 00:00:00	2012-09-30 00:00:00	2012-09-30 00:00:00	2012-10-20 00:00:00	2012-10-20 00:00:00	2014-09-25 00:00:00	2014-10-01 00:00:00	2014-09-30 00:00:00	2014-06-30 00:00:00	2012-12-31 00:00:00	2012-12-31 00:00:00	2014-03-17 00:00:00	2015-06-30 00:00:00	2018-12-31 00:00:00	2018-04-21 00:00:00	2020-06-30 00:00:00	2020-12-31 00:00:00	2018-06-30 00:00:00	2020-06-30 00:00:00	2019-06-30 00:00:00	2019-06-30 00:00:00	2018-10-20 00:00:00	2018-10-10 00:00:00	2015-12-31 00:00:00	2015-12-31 00:00:00	2016-05-21 00:00:00	2016-05-11 00:00:00	2016-05-21 00:00:00	2016-06-30 00:00:00	2016-09-13 00:00:00	2016-09-24 00:00:00	2016-10-22 00:00:00	2016-09-24 00:00:00	2016-12-31 00:00:00	2016-10-22 00:00:00	None	2017-03-24 00:00:00	2017-06-30 00:00:00	2017-06-30 00:00:00	2016-12-31 00:00:00	2016-06-30 00:00:00	2017-12-31 00:00:00	2018-11-02 00:00:00	2020-08-14 00:00:00	2019-12-16 00:00:00	2019-12-31 00:00:00	2017-12-31 00:00:00	2020-09-19 00:00:00	2019-12-31 00:00:00	2018-06-30 00:00:00	2018-10-20 00:00:00	2018-05-29 00:00:00	2018-04-21 00:00:00	2020-09-16 00:00:00	2020-09-19 00:00:00	2018-12-31 00:00:00	2020-12-31 00:00:00	2021-06-30 00:00:00	None	2022-06-30 00:00:00	2021-07-07 00:00:00	2022-09-24 00:00:00	2021-12-31 00:00:00	2022-08-29 00:00:00	2021-06-30 00:00:00	2021-12-31 00:00:00	2022-06-30 00:00:00	2022-10-20 00:00:00	2022-10-07 00:00:00	2022-10-22 00:00:00
rpt_date	None	None	None	2000-10-21 00:00:00	None	None	2000-10-03 00:00:00	2001-01-04 00:00:00	None	None	2001-07-25 00:00:00	None	2001-10-09 00:00:00	2002-01-07 00:00:00	None	None	2002-02-19 00:00:00	None	2002-07-12 00:00:00	None	None	2002-10-02 00:00:00	None	None	2002-10-22 00:00:00	None	2003-01-30 00:00:00	None	2003-07-30 00:00:00	None	2003-10-03 00:00:00	2004-01-07 00:00:00	None	2004-07-30 00:00:00	None	None	2004-10-19 00:00:00	2004-10-04 00:00:00	None	2005-01-28 00:00:00	2005-07-28 00:00:00	None	None	2006-01-30 00:00:00	None	2006-03-17 00:00:00	None	2006-07-24 00:00:00	None	2006-10-23 00:00:00	None	2007-01-24 00:00:00	None	2007-07-30 00:00:00	None	2015-07-24 00:00:00	2014-07-26 00:00:00	2014-05-30 00:00:00	2013-07-31 00:00:00	None	2015-01-26 00:00:00	None	None	None	2008-03-21 00:00:00	2008-01-25 00:00:00	None	None	2008-07-08 00:00:00	2008-10-20 00:00:00	None	None	None	None	2009-01-26 00:00:00	None	2009-07-22 00:00:00	None	None	2010-01-25 00:00:00	2010-05-26 00:00:00	None	2010-03-17 00:00:00	2010-07-26 00:00:00	2010-10-04 00:00:00	None	None	None	2010-10-21 00:00:00	None	None	2011-01-06 00:00:00	None	2011-07-27 00:00:00	2012-01-26 00:00:00	None	2012-07-10 00:00:00	None	2012-05-20 00:00:00	None	None	None	None	2014-03-07 00:00:00	2014-03-18 00:00:00	2014-01-29 00:00:00	2012-09-30 00:00:00	None	2012-10-21 00:00:00	None	2014-09-25 00:00:00	2014-10-01 00:00:00	2014-10-03 00:00:00	None	2013-01-17 00:00:00	None	None	None	2019-01-22 00:00:00	2018-04-24 00:00:00	None	2021-01-23 00:00:00	2018-07-18 00:00:00	2020-07-03 00:00:00	None	2019-07-16 00:00:00	2018-10-22 00:00:00	2018-10-10 00:00:00	None	2016-01-19 00:00:00	2016-05-23 00:00:00	2016-05-11 00:00:00	None	2016-07-14 00:00:00	2016-09-13 00:00:00	2016-09-26 00:00:00	2016-10-23 00:00:00	None	2017-01-23 00:00:00	None	None	None	2017-07-19 00:00:00	None	None	None	None	2018-11-02 00:00:00	2020-08-14 00:00:00	2019-12-16 00:00:00	None	2018-01-28 00:00:00	None	2020-01-29 00:00:00	None	None	2018-05-29 00:00:00	None	2020-09-16 00:00:00	2020-09-22 00:00:00	None	None	2021-07-07 00:00:00	None	2022-07-19 00:00:00	None	2022-09-26 00:00:00	2022-01-17 00:00:00	2022-08-29 00:00:00	None	None	None	2022-10-20 00:00:00	2022-10-07 00:00:00	2022-10-22 00:00:00
filing_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	None	22001	None	22001	None	22001	22001	None	22001	None	None	22001	22001	None	22001	22001	None	None	22001	None	22001	None	22001	None	22001	None	22001	None	22001	None	22001	22001	22001	22001	None	22001	None	None	None	22001	22001	None	None	22001	22001	None	None	None	22006	22001	22006	22001	None	None	22001	22001	None	22001	22001	22001	None	None	None	22001	None	None	22001	None	22001	22001	None	22001	22006	22001	None	None	None	None	22001	22001	22001	22001	None	22001	None	22001	22001	22001	None	22001	None	None	None	22006	22006	None	22006	22006	22006	None	22006	22006	22006	None	22001	22001	22001	None	22001	22001	22001	22001	None	22001	None	None	22001	22006	None	None	None	None	22006	22006	22006	None	22006	None	22006	None	None	22006	None	22006	22006	None	None	22006	None	22006	22006	22006	22006	22006	None	None	None	22006	22006	22006

Table: filer_to_filer_type
filer_id	1220370	1220370
filer_type	16	16
active	Y	Y
race	0	0
session_id	1999	2021
category	0	0
category_type	40502	40503
sub_category	40103	40103
effect_dt	2000-01-25 00:00:00	2021-07-21 00:00:00
sub_category_type	0	0
election_type	0	0
sub_category_a	None	None
nyq_dt	2000-01-25 00:00:00	2000-01-25 00:00:00
party_cd	0	0
county_cd	18004	18004
district_cd	0	0

Table: filer_xref
filer_id		1220370
xref_id		1220370
effect_dt		2000-01-31 00:00:00
migration_source		CLAIMS

Table: filername
xref_filer_id	1220370	1220370
filer_id	1220370	1220370
filer_type	RECIPIENT COMMITTEE	RECIPIENT COMMITTEE
status	ACTIVE	ACTIVE
effect_dt	2021-07-21 00:00:00	2021-07-21 00:00:00
naml	CONSUMERS FOR CLEAN WATER PAC	CONSUMERS FOR CLEAN WATER PAC
namf	None	None
namt	None	None
nams	None	None
adr1	None	None
adr2	None	None
city	SACRAMENTO	SACRAMENTO
st	CA	CA
zip4	95814	95814
phon	9164428888	9164428888
fax	None	9164420382
email	None	[email protected]

Table: filers
filer_id		1220370

Table: received_filings
filer_id	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370	1220370
filing_file_name	674907_0.cal	668459_0.cal	6106.cal	6156.cal	6188.cal	7409.cal	706147_0.cal	769907_0.cal	785418_0.cal	803600_0.cal	820932_0.cal	850016_0.cal	871413_0.cal	876563_0.cal	911114_0.cal	946894_0.cal	962531_0.cal	978701_0.cal	1402948_1.cal	1531436_0.cal	1826535_0.cal	1856914_0.cal	1890204_0.cal	1888395_0.cal	2076293_0.cal	2041748_0.cal	1402948_4.cal
received_date	2000-10-24 00:00:00	2000-10-03 00:00:00	2000-10-02 00:00:00	2000-10-02 00:00:00	2000-10-02 00:00:00	2000-10-03 00:00:00	2001-01-05 00:00:00	2001-07-25 00:00:00	2001-10-09 00:00:00	2002-01-07 00:00:00	2002-02-19 00:00:00	2002-07-17 00:00:00	2002-10-07 00:00:00	2002-10-22 00:00:00	2003-01-30 00:00:00	2003-07-30 00:00:00	2003-10-08 00:00:00	2004-01-08 00:00:00	2009-02-18 00:00:00	2010-10-21 00:00:00	2014-03-07 00:00:00	2014-05-30 00:00:00	2014-10-01 00:00:00	2014-09-25 00:00:00	2016-09-13 00:00:00	2016-05-11 00:00:00	2021-07-07 00:00:00
filing_directory	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/usr/users/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/cal	/cafiler/disclose/ca99/cal
filing_id	674907	668459	None	None	None	None	706147	769907	785418	803600	820932	850016	871413	876563	911114	946894	962531	978701	1402948	1531436	1826535	1856914	1890204	1888395	2076293	2041748	1402948
form_id	F460	F460	None	None	None	None	F460	F460	F460	F460	F497	F460	F460	F460	F460	F460	F460	F460	F410	F497	F497	F497	F497	F497	F497	F497	F410
receive_comment	Filing accepted, but but with warnings	Filing accepted, but but with warnings	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted