OpenCalAccess

Filer ID: 1262222

Table: cvr_lobby_disclosure
filing_id	1014284	1027989	1058719	1081478	1104607	1167827	1134231	1148725	1121342	1230179	1262816	1191263	1278368	1215128	1311598	1332226	1295816	1295816	1295816	1332226	1343175	1373960	1418415	1451128	1388988	1436924	1458183	1535503	1501545	1488113	1567385	1620319	1602919	1588658	1630645	1706826	1677600	1651435	1733777	1763610	1789433	1775822	1798778	1763610	1812073	1868777	1843503	1843503	1909221	1992521	1965241	1978997	1935759	2060019	2037328	2012626	2100595	2173173	2153890	2130262	2191445	2269518	2211667	2242231	2318179	2349934	2381633	2443078	2418691	2469804	2399393	2554279	2529855	2486985	2623892	2603428	2581082	2706149	2644906	2644906	2675860	2748343
amend_id	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	1	1	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	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	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
form_type	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635
sender_id	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222
filer_id	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222
entity_cd	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM
filer_naml	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION
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
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
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
report_num	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	002	000	001	001	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	001	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	000	000	000	000	000	001	000	000	000
rpt_date	2004-04-30 00:00:00	2004-07-29 00:00:00	2004-10-31 00:00:00	2005-01-31 00:00:00	2005-04-29 00:00:00	2006-05-01 00:00:00	2005-10-31 00:00:00	2006-01-31 00:00:00	2005-08-05 00:00:00	2007-01-23 00:00:00	2007-04-30 00:00:00	2006-07-30 00:00:00	2007-07-19 00:00:00	2006-10-30 00:00:00	2008-01-31 00:00:00	2008-05-13 00:00:00	2007-10-29 00:00:00	2007-10-29 00:00:00	2007-10-29 00:00:00	2008-05-13 00:00:00	2008-07-14 00:00:00	2008-10-28 00:00:00	2009-04-23 00:00:00	2009-10-29 00:00:00	2009-01-12 00:00:00	2009-07-30 00:00:00	2010-01-18 00:00:00	2010-10-26 00:00:00	2010-07-20 00:00:00	2010-05-17 00:00:00	2011-01-27 00:00:00	2011-10-27 00:00:00	2011-07-25 00:00:00	2011-04-27 00:00:00	2012-01-23 00:00:00	2012-10-29 00:00:00	2012-07-30 00:00:00	2012-04-10 00:00:00	2013-01-28 00:00:00	2013-04-29 00:00:00	2013-04-29 00:00:00	2013-07-16 00:00:00	2013-10-29 00:00:00	2013-04-29 00:00:00	2014-01-23 00:00:00	2014-07-24 00:00:00	2014-04-29 00:00:00	2014-04-29 00:00:00	2014-10-31 00:00:00	2015-01-31 00:00:00	2015-04-30 00:00:00	2015-07-31 00:00:00	2015-01-31 00:00:00	2016-08-02 00:00:00	2016-04-30 00:00:00	2016-01-31 00:00:00	2016-10-31 00:00:00	2017-07-31 00:00:00	2017-04-30 00:00:00	2017-01-31 00:00:00	2017-10-31 00:00:00	2018-07-31 00:00:00	2018-01-31 00:00:00	2018-04-30 00:00:00	2018-10-31 00:00:00	2019-01-30 00:00:00	2019-04-30 00:00:00	2020-01-30 00:00:00	2019-10-31 00:00:00	2020-04-30 00:00:00	2019-07-31 00:00:00	2021-01-31 00:00:00	2020-10-31 00:00:00	2020-07-31 00:00:00	2021-10-31 00:00:00	2021-07-31 00:00:00	2021-04-30 00:00:00	2022-07-31 00:00:00	2022-04-14 00:00:00	2022-01-31 00:00:00	2022-04-30 00:00:00	2022-10-31 00:00:00
from_date	2004-01-01 00:00:00	2004-04-01 00:00:00	2004-07-01 00:00:00	2004-10-01 00:00:00	2005-01-01 00:00:00	2006-01-01 00:00:00	2005-07-01 00:00:00	2005-10-01 00:00:00	2005-04-01 00:00:00	2006-10-01 00:00:00	2007-01-01 00:00:00	2006-04-01 00:00:00	2007-04-01 00:00:00	2006-07-01 00:00:00	2007-10-01 00:00:00	2008-01-01 00:00:00	2007-07-01 00:00:00	2007-07-01 00:00:00	2007-07-01 00:00:00	2008-01-01 00:00:00	2008-04-01 00:00:00	2008-07-01 00:00:00	2009-01-01 00:00:00	2009-07-01 00:00:00	2008-10-01 00:00:00	2009-04-01 00:00:00	2009-10-01 00:00:00	2010-07-01 00:00:00	2010-04-01 00:00:00	2010-01-01 00:00:00	2010-10-01 00:00:00	2011-07-01 00:00:00	2011-04-01 00:00:00	2011-01-01 00:00:00	2011-10-01 00:00:00	2012-07-01 00:00:00	2012-04-01 00:00:00	2012-01-01 00:00:00	2012-10-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-04-01 00:00:00	2013-07-01 00:00:00	2013-01-01 00:00:00	2013-10-01 00:00:00	2014-04-01 00:00:00	2014-01-01 00:00:00	2014-01-01 00:00:00	2014-07-01 00:00:00	2015-07-01 00:00:00	2015-01-01 00:00:00	2015-04-01 00:00:00	2014-10-01 00:00:00	2016-04-01 00:00:00	2016-01-01 00:00:00	2015-10-01 00:00:00	2016-07-01 00:00:00	2017-04-01 00:00:00	2017-01-01 00:00:00	2016-10-01 00:00:00	2017-07-01 00:00:00	2018-04-01 00:00:00	2017-10-01 00:00:00	2018-01-01 00:00:00	2018-07-01 00:00:00	2018-10-01 00:00:00	2019-01-01 00:00:00	2019-10-01 00:00:00	2019-07-01 00:00:00	2020-01-01 00:00:00	2019-04-01 00:00:00	2020-10-01 00:00:00	2020-07-01 00:00:00	2020-04-01 00:00:00	2021-07-01 00:00:00	2021-04-01 00:00:00	2021-01-01 00:00:00	2022-04-01 00:00:00	2021-10-01 00:00:00	2021-10-01 00:00:00	2022-01-01 00:00:00	2022-07-01 00:00:00
thru_date	2004-03-31 00:00:00	2004-06-30 00:00:00	2004-09-30 00:00:00	2004-12-31 00:00:00	2005-03-31 00:00:00	2006-03-31 00:00:00	2005-09-30 00:00:00	2005-12-31 00:00:00	2005-06-30 00:00:00	2006-12-31 00:00:00	2007-03-31 00:00:00	2006-06-30 00:00:00	2007-06-30 00:00:00	2006-09-30 00:00:00	2007-12-31 00:00:00	2008-03-31 00:00:00	2007-09-30 00:00:00	2007-09-30 00:00:00	2007-09-30 00:00:00	2008-03-31 00:00:00	2008-06-30 00:00:00	2008-09-30 00:00:00	2009-03-31 00:00:00	2009-09-30 00:00:00	2008-12-31 00:00:00	2009-06-30 00:00:00	2009-12-31 00:00:00	2010-09-30 00:00:00	2010-06-30 00:00:00	2010-03-31 00:00:00	2010-12-31 00:00:00	2011-09-30 00:00:00	2011-06-30 00:00:00	2011-03-31 00:00:00	2011-12-31 00:00:00	2012-09-30 00:00:00	2012-06-30 00:00:00	2012-03-31 00:00:00	2012-12-31 00:00:00	2013-03-31 00:00:00	2013-03-31 00:00:00	2013-06-30 00:00:00	2013-09-30 00:00:00	2013-04-01 00:00:00	2013-12-31 00:00:00	2014-06-30 00:00:00	2014-03-31 00:00:00	2014-03-31 00:00:00	2014-09-30 00:00:00	2015-09-30 00:00:00	2015-03-31 00:00:00	2015-06-30 00:00:00	2014-12-31 00:00:00	2016-06-30 00:00:00	2016-03-31 00:00:00	2015-12-31 00:00:00	2016-09-30 00:00:00	2017-06-30 00:00:00	2017-03-31 00:00:00	2016-12-31 00:00:00	2017-09-30 00:00:00	2018-06-30 00:00:00	2017-12-31 00:00:00	2018-03-31 00:00:00	2018-09-30 00:00:00	2018-12-31 00:00:00	2019-03-31 00:00:00	2019-12-31 00:00:00	2019-09-30 00:00:00	2020-03-31 00:00:00	2019-06-30 00:00:00	2020-12-31 00:00:00	2020-09-30 00:00:00	2020-06-30 00:00:00	2021-09-30 00:00:00	2021-06-30 00:00:00	2021-03-31 00:00:00	2022-06-30 00:00:00	2021-12-31 00:00:00	2021-12-31 00:00:00	2022-03-31 00:00:00	2022-09-30 00:00:00
cum_beg_dt	2003-01-01 00:00:00	2003-01-01 00:00:00	2003-01-01 00:00:00	2003-01-01 00:00:00	2005-01-01 00:00:00	2006-01-01 00:00:00	2005-01-01 00:00:00	2005-01-01 00:00:00	2005-01-01 00:00:00	2006-01-01 00:00:00	2007-01-01 00:00:00	2006-01-01 00:00:00	2007-01-01 00:00:00	2006-01-01 00:00:00	2007-01-01 00:00:00	2008-01-01 00:00:00	2007-01-01 00:00:00	2007-01-01 00:00:00	2007-01-01 00:00:00	2007-01-01 00:00:00	2007-01-01 00:00:00	2007-01-01 00:00:00	2009-01-01 00:00:00	2009-01-01 00:00:00	2007-01-01 00:00:00	2009-01-01 00:00:00	2009-01-01 00:00:00	2009-01-01 00:00:00	2009-01-01 00:00:00	2009-01-01 00:00:00	2009-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2013-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2015-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00
firm_id	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222
firm_name	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ
firm_city	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS
firm_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
firm_zip4	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762
firm_phon	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	95762	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	9169333062	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075	(916) 933-3075
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
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
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
mail_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
sig_date	2004-04-30 00:00:00	2004-07-29 00:00:00	2004-10-31 00:00:00	2005-01-31 00:00:00	2005-04-29 00:00:00	2006-05-01 00:00:00	2005-10-31 00:00:00	2006-01-31 00:00:00	2005-08-05 00:00:00	2007-01-23 00:00:00	2007-04-30 00:00:00	2006-07-31 00:00:00	2007-07-19 00:00:00	2006-10-30 00:00:00	2008-01-31 00:00:00	2008-05-13 00:00:00	2007-10-29 00:00:00	2007-10-29 00:00:00	2007-10-29 00:00:00	2008-07-09 00:00:00	2008-07-14 00:00:00	2008-10-28 00:00:00	2009-04-23 00:00:00	2009-10-29 00:00:00	2009-01-12 00:00:00	2009-07-30 00:00:00	2010-01-18 00:00:00	2010-10-26 00:00:00	2010-07-20 00:00:00	2010-05-17 00:00:00	2011-01-27 00:00:00	2011-10-27 00:00:00	2011-07-25 00:00:00	2011-04-27 00:00:00	2012-01-23 00:00:00	2012-10-29 00:00:00	2012-07-30 00:00:00	2012-04-10 00:00:00	2013-01-28 00:00:00	2013-10-07 00:00:00	2013-08-29 00:00:00	2013-07-16 00:00:00	2013-10-29 00:00:00	2013-04-29 00:00:00	2014-01-23 00:00:00	2014-07-29 00:00:00	2014-04-29 00:00:00	2014-04-29 00:00:00	2014-10-21 00:00:00	2015-10-14 00:00:00	2015-04-22 00:00:00	2015-07-14 00:00:00	2015-01-27 00:00:00	2016-07-19 00:00:00	2016-04-29 00:00:00	2016-01-18 00:00:00	2016-10-19 00:00:00	2017-07-19 00:00:00	2017-04-13 00:00:00	2017-01-26 00:00:00	2017-10-18 00:00:00	2018-07-17 00:00:00	2018-01-31 00:00:00	2018-04-19 00:00:00	2018-10-22 00:00:00	2019-01-30 00:00:00	2019-04-29 00:00:00	2020-01-30 00:00:00	2019-10-29 00:00:00	2020-04-22 00:00:00	2019-07-29 00:00:00	2021-01-31 00:00:00	2020-10-26 00:00:00	2020-07-30 00:00:00	2021-10-25 00:00:00	2021-07-30 00:00:00	2021-04-29 00:00:00	2022-07-26 00:00:00	2022-04-14 00:00:00	2022-01-28 00:00:00	2022-04-13 00:00:00	2022-10-31 00:00:00
sig_loc	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills California	El Dorado Hills California	El Dorado Hills CA	El Dorado Hills	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills California	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills	El Dorado Hills CA	EL DORADO HILLS, CA	SACRAMENTO, CA	EL DORADO HILLS, CA	SACRAMENTO, CA	EL DORADO HILLS, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	EL DORADO HILLS, CA	EL DORADO HILLS, CA	SACRAMENTO, CA	EL DORADO HILLS, CA	EL DORADO HILLS, CA	EL DORADO HILLS, CA	EL DORADO HILLS, CA	EL DORADO HILLS, CA
sig_naml	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	James	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	SIMONELLI	EICHMAN	SIMONELLI	EICHMAN	SIMONELLI	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	SIMONELLI	SIMONELLI	EICHMAN	SIMONELLI	SIMONELLI	SIMONELLI	SIMONELLI	SIMONELLI
sig_namf	James F.	James F.	James F.	James F.	James F.	James	James F.	Simonelli	James F.	James F.	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	JAMS	J. RICHARD	JAMES	J. RICHARD	JAMES	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	JAMES	JAMES	J. RICHARD	JAMES	JAMES	JAMES	JAMES	JAMES
sig_namt	Mr.	Mr.	Mr.	Mr.	Mr.	None	None	None	None	Mr.	None	None	Mr.	None	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
sig_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
prn_naml	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	James	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	SIMONELLI	EICHMAN	SIMONELLI	EICHMAN	SIMONELLI	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	EICHMAN	SIMONELLI	SIMONELLI	EICHMAN	SIMONELLI	SIMONELLI	SIMONELLI	SIMONELLI	SIMONELLI
prn_namf	James F.	James F.	James F.	James F.	James F.	James	James F.	Simonelli	James F.	James F.	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	James	JAMS	J. RICHARD	JAMES	J. RICHARD	JAMES	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	J. RICHARD	JAMES	JAMES	J. RICHARD	JAMES	JAMES	JAMES	JAMES	JAMES
prn_namt	Mr.	Mr.	Mr.	Mr.	Mr.	None	None	None	None	Mr.	None	None	Mr.	None	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
prn_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
sig_title	Managing Director	Managing Director	Managing Director	Managing Director	Managing Director	Legislative Advocate	Legislative Advocate	Legilative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	LEGISLATIVE ADVOCATES (439000-MM)	CERTIFIED PUBLIC ACCOUNTANT (439000-MM)	LEGISLATIVE ADVOCATES (439000-MM)	CERTIFIED PUBLIC ACCOUNTANT (439000-MM)	LEGISLATIVE ADVOCATES (439000-MM)	CERTIFIED PUBLIC ACCOUNTANT (439000-MM)	CERTIFIED PUBLIC ACCOUNTANT (439000-MM)	CERTIFIED PUBLIC ACCOUNTANT (439000-MM)	CERTIFIED PUBLIC ACCOUNTANT (439000-MM)	CERTIFIED PUBLIC ACCOUNTANT (439000-MM)	CERTIFIED PUBLIC ACCOUNTANT (439000-MM)	CERTIFIED PUBLIC ACCOUNTANT (439000-MM)	CERTIFIED PUBLIC ACCOUNTANT (439000-MM)	CERTIFIED PUBLIC ACCOUNTANT (439000-MM)	CERTIFIED PUBLIC ACCOUNTANT (439000-MM)	CERTIFIED PUBLIC ACCOUNTANT (439000-MM)	CERTIFIED PUBLIC ACCOUNTANT (439000-MM)	CERTIFIED PUBLIC ACCOUNTANT (439000-MM)	CERTIFIED PUBLIC ACCOUNTANT (439000-MM)	CERTIFIED PUBLIC ACCOUNTANT (439000-MM)	CERTIFIED PUBLIC ACCOUNTANT (439000-MM)	CERTIFIED PUBLIC ACCOUNTANT (439000-MM)	CERTIFIED PUBLIC ACCOUNTANT (439000-MM)	CERTIFIED PUBLIC ACCOUNTANT (439000-MM)	CERTIFIED PUBLIC ACCOUNTANT (439000-MM)	CERTIFIED PUBLIC ACCOUNTANT (439000-MM)	EXECUTIVE DIRECTOR	EXECUTIVE DIRECTOR	CERTIFIED PUBLIC ACCOUNTANT (439000-MM)	EXECUTIVE DIRECTOR	EXECUTIVE DIRECTOR	EXECUTIVE DIRECTOR	EXECUTIVE DIRECTOR	EXECUTIVE DIRECTOR
nopart1_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
nopart2_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
part1_1_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
part1_2_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
ctrib_n_cb	X	X	None	None	None	None	X	X	None	X	None	None	None	X	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	X	None	X	None	X	X	X	None
ctrib_y_cb	None	None	X	X	X	X	None	None	X	None	X	X	X	None	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	None	X	None	X	None	None	None	X
lby_actvty	more	more	more	more	more	Frederick Simonelli reported no lobbying activity for the 1st Quarter. On February 24 2006 James Simonelli spoke with Assemblymember Chan's office regarding AB 1953. On March 24 2006 James Simonelli met with Assemblymember Tran to discuss workers' compensation the Governor's bond proposal and potential manufacturing czar.	None	None	None	more	more	more	None	more	attached	None	None	None	None	None	more	None	None	None	JAMES: On December 4 2008 James Simonelli met with Senator Ellen Corbett to discuss the implementation of SB 1395. On December 19 2008 James Simonelli met with the Small Business Advocate to discuss a manufacturing advocate. FRED: None	None	None	None	None	None	None	None	None	attached	On October 4 2011 James Simonelli met with State Water Board staff to discuss the draft industrial storm water permit. On November 2 2011 James Simonelli met with State Water Board staff to discuss the draft industrial storm water permit. On November 7 2011 James Simonelli met with State Water Board staff to discuss the draft industrial storm water permit.	None	None	On January 4 2012 James Simonelli met with Senator Wright's office to discuss State Water Board legislation. On January 13 2012 James Simonelli met with Senator Blakeslee's office to discuss State Water Board legislation. On January 31 2012 James Simonelli met with CARB Board Member Sandra Berg to discuss AB 32 early action item for magnesium foundries.	None	None	None	None	None	None	None	None	None	None	AB 2096 ; Governor&146;s Office, CA Department of Industrial Relations, CA Department of Insurance, CA Commission on Health and Safety and Workers&146; Compensation, Senate Committee on Governmental Organization, Senate Labor and Industrial Relations Committee Re: All Issues Affecting the Metals Industry and Small Businesses	AB 722, AB 1124, SB 563; Governors Office, CA Department of Industrial Relations, CA Department of Insurance, CA Commission on Health and Safety and Workers Compensation, Assembly Insurance Committee, Senate Labor and Industrial Relations Committee Re: All Issues Affecting the Metals Industry and Small Businesses	Governor's Office, CA Department of Industrial Relations, CA Department of Insurance, CA Commission on Health and Safety and Workers' Compensation Re: All Issues Affecting the Metals Industry and Small Businesses	AB 722, AB 1124, SB 563; Governor's Office, CA Department of Industrial Relations, CA Department of Insurance, CA Commission on Health and Safety and Workers' Compensation, Assembly Insurance Committee, Senate Labor and Industrial Relations Committee Re: All Issues Affecting the Metals Industry and Small Businesses	Governor's Office, CA Department of Industrial Relations, CA Department of Insurance, CA Commission on Health and Safety and Workers' Compensation Re: All Issues Affecting the Metals Industry and Small Businesses	SEE ATTACHMENT A	AB 2178, AB 2230, SB 914, SB 1175; Governors Office, CA Department of Industrial Relations, CA Department of Insurance, CA Commission on Health and Safety and Workers Compensation, Assembly Insurance Committee, Senate Labor and Industrial Relations Committee re: All Issues Affecting the Metals Industry, Small Businesses and Workers Compensation	AB 722, AB 1124, SB 563; Governors Office, CA Department of Industrial Relations, CA Department of Insurance, CA Commission on Health and Safety and Workers Compensation, Assembly Insurance Committee, Senate Labor and Industrial Relations Committee Re: All Issues Affecting the Metals Industry and Small Businesses	SEE ATTACHMENT A	SEE ATTACHMENT A	SEE ATTACHMENT A	SEE ATTACHMENT A	SEE ATTACHMENT A	SEE ATTACHMENT A	SEE ATTACHMENT A	SEE ATTACHMENT A	SEE ATTACHMENT A	SEE ATTACHMENT A	SEE ATTACHMENT A	SEE ATTACHMENT A	SEE ATTACHMENT A	SEE ATTACHMENT A	SEE ATTACHMENT A	SEE ATTACHMENT A	SEE ATTACHMENT A	SEE ATTACHMENT A	SEE ATTACHMENT A	SEE ATTACHMENT A	SEE ATTACHMENT A	SEE ATTACHMENT A	SEE ATTACHMENT A	SEE ATTACHMENT A	SEE ATTACHMENT A	SEE ATTACHMENT A
lobby_n_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
lobby_y_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
major_naml	None	None	None	None	None	Haynes	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
major_namf	None	None	None	None	None	Ray	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
major_namt	None	None	None	None	None	Mr.	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
major_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
rcpcmte_nm	None	None	California Metals Coalition PAC	California Metals Coalition PAC	California Metals Coalition PAC	Taxpayers for Haynes	None	None	Garamedni for Lt. Governor	None	None	JERICHO Education for Justice	None	None	None	California Metals Coalition PAC	None	None	None	California Metals Coalition PAC	California Metals Coalition PAC	California Metals Coalition PAC	California Metals Coalition PAC	California Metals Coalition PAC	California Metals Coalition PAC	California Metals Coalition PAC	California Metals Coalition PAC	California Metals Coalition PAC	California Metals Coalition PAC	California Metals Coalition PAC	California Metals Coalition PAC	California Metals Coalition PAC	California Metals Coalition PAC	California Metals Coalition PAC	California Metals Coalition PAC	California Metals Coalition PAC	California Metals Coalition PAC	California Metals Coalition PAC	California Metals Coalition PAC	California Metals Coalition PAC	California Metals Coalition PAC	California Metals Coalition PAC	California Metals Coalition PAC	California Metals Coalition PAC	California Metals Coalition PAC	California Metals Coalition PAC	California Metals Coalition PAC	California Metals Coalition PAC	CA METALS COALITION PAC	CA METALS COALITION PAC	CA METALS COALITION PAC	CA METALS COALITION PAC	CA METALS COALITION PAC	CA METALS COALITION PAC	CA METALS COALITION PAC	CA METALS COALITION PAC	CA METALS COALITION PAC	CA METALS COALITION PAC	None	CA METALS COALITION PAC	None	CA METALS COALITION PAC	CA METALS COALITION PAC	None	CA METALS COALITION PAC	CA METALS COALITION PAC	CA METALS COALITION PAC	CA METALS COALITION PAC	CA METALS COALITION PAC	CA METALS COALITION PAC	CA METALS COALITION PAC	CA METALS COALITION PAC	CA METALS COALITION PAC	CA METALS COALITION PAC	CALIFORNIA METALS COALTION PAC	CALIFORNIA METALS COALTION PAC	None	CALIFORNIA METALS COALTION PAC	CALIFORNIA METALS COALTION PAC	CALIFORNIA METALS COALTION PAC	CALIFORNIA METALS COALTION PAC	CALIFORNIA METALS COALTION PAC
rcpcmte_id	None	None	1264568	1264568	1264568	1275448	None	None	1266998	None	None	95-414970	None	None	None	1264568	None	None	None	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	None	1264568	None	1264568	1264568	None	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	1264568	None	1264568	1264568	1264568	1264568	1264568

Table: cvr_registration
filing_id	1068941	1189124	1224999	1308078	1308078	1385860	1544973	1544972	1719012	1868683	1921718	2117513	2333589	2588028
amend_id	0	0	0	0	1	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
form_type	F602	F602	F602	F602	F602	F602	F602	F602	F602	F602	F602	F602	F602	F602
sender_id	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	F00009	1255172	1255172	1255172	1255172	1255172
filer_id	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222
entity_cd	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM
filer_naml	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ	CA METALS COALITION/CCSOJ
filer_namf	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
filer_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None
report_num	000	000	000	000	001	000	000	000	000	000	000	000	000	000
rpt_date	2004-12-30 00:00:00	2006-07-28 00:00:00	2006-12-28 00:00:00	2008-01-29 00:00:00	2008-01-29 00:00:00	2008-12-29 00:00:00	2010-11-16 00:00:00	2010-11-16 00:00:00	2012-12-20 00:00:00	2014-07-28 00:00:00	2014-12-31 00:00:00	2016-12-31 00:00:00	2018-11-26 00:00:00	2020-12-16 00:00:00
ls_beg_yr	2005	2006	2007	2008	2008	2009	2011	2011	2013	2013	2015	2017	2019	2021
ls_end_yr	2006	2007	2008	2009	2009	2010	2012	2012	2014	2014	2016	2018	2020	2022
qual_date	None	None	None	None	None	None	None	None	None	None	None	None	None	None
eff_date	2005-01-01 00:00:00	2005-01-01 00:00:00	2006-12-28 00:00:00	2008-01-01 00:00:00	2008-01-01 00:00:00	2008-12-29 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2013-01-01 00:00:00	2014-07-01 00:00:00	2015-01-01 00:00:00	2017-01-01 00:00:00	2019-01-01 00:00:00	2021-01-01 00:00:00
bus_city	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS
bus_st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA
bus_zip4	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762
bus_phon	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	916-933-3075	(916)933-3075	(916)933-3075	(916)933-3075	(916)933-3075	(916)933-3075
bus_fax	916-933-3072	916-933-3072	None	None	None	None	None	None	916-933-3072	None	None	None	None	None
bus_email	[email protected]	None	None	None	None	None	None	None	None	None	None	None	None	None
mail_city	None	None	None	None	None	None	None	None	None	None	None	None	None	None
mail_st	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
mail_phon	None	None	None	None	None	None	None	None	None	None	None	None	None	None
sig_date	2004-12-30 00:00:00	2006-07-28 00:00:00	2006-12-28 00:00:00	2008-01-29 00:00:00	2008-01-29 00:00:00	2008-12-29 00:00:00	2010-11-16 00:00:00	2008-12-29 00:00:00	2012-12-20 00:00:00	2014-07-28 00:00:00	2014-12-16 00:00:00	2016-11-30 00:00:00	2018-11-26 00:00:00	2020-12-16 00:00:00
sig_loc	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	El Dorado Hills CA	EL DORADO HILLS, CA	EL DORADO HILLS, CA	EL DORADO HILLS, CA	EL DORADO HILLS, CA	EL DORADO HILLS, CA
sig_naml	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	Simonelli	SIMONELLI	SIMONELLI	SIMONELLI	SIMONELLI	SIMONELLI
sig_namf	James F.	James F.	James F.	James F.	James F.	James F.	James F.	James F.	James	JAMES	JAMES	JAMES	JAMES	JAMES
sig_namt	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	None	None	None	None	None
sig_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None
prn_naml	None	None	None	None	None	None	None	None	None	SIMONELLI	SIMONELLI	SIMONELLI	SIMONELLI	SIMONELLI
prn_namf	None	None	None	None	None	None	None	None	None	JAMES	JAMES	JAMES	JAMES	JAMES
prn_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None
prn_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None
sig_title	Managing Director	Managing Director	Managing Director	Managing Director	Managing Director	Executive Director	Executive Director	Executive Director	Executive Director	EXECUTIVE DIRECTOR (439000-MM)	EXECUTIVE DIRECTOR (439000-MM)	EXECUTIVE DIRECTOR (439000-MM)	EXECUTIVE DIRECTOR (439000-MM)	EXECUTIVE DIRECTOR (439000-MM)
stmt_firm	None	None	None	None	None	None	None	None	None	None	None	None	None	None
ind_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bus_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None
trade_cb	X	X	X	X	X	X	X	X	X	X	X	X	X	X
oth_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None
a_b_name	None	None	None	None	None	None	None	None	None	None	None	None	None	None
a_b_city	None	None	None	None	None	None	None	None	None	None	None	None	None	None
a_b_st	None	None	None	None	None	None	None	None	None	None	None	None	None	None
a_b_zip4	None	None	None	None	None	None	None	None	None	None	None	None	None	None
descrip_1	metal workers	metal workers	metal workers	metal workers	metal workers	metal workers	metal workers	metal workers	Metal Workers	METAL WORKERS	METAL WORKERS	METAL WORKERS	METAL WORKERS	METAL WORKERS
descrip_2	none	none	none	none	none	none	none	none	none	None	None	None	None	None
c_less50	None	None	None	None	None	None	None	None	None	None	None	None	None	None
c_more50	X	X	X	X	X	X	X	X	X	X	X	X	X	X
ind_class	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH
ind_descr	Manufacturing	Manufacturing	manufacturing	manufacturing	manufacturing	manufacturing	manufacturing	manufacturing	Manufacturing	MANUFACTURING	MANUFACTURING	MANUFACTURING	MANUFACTURING	MANUFACTURING
bus_class	MAN	MAN	MAN	MAN	MAN	MAN	MAN	MAN	MAN	MAN	MAN	MAN	MAN	MAN
bus_descr	None	None	None	None	None	None	None	None	None	None	None	None	None	None
auth_name	Simonelli & Associates Inc.	Simonelli & Associates Inc.	Simonelli & Associates Inc.	Simonelli & Associates Inc.	Simonelli & Associates Inc.	Simonelli & Associates Inc.	Simonelli & Associates Inc.	Simonelli & Associates Inc.	Simonelli & Associates Inc	KAMMERER & COMPANY	KAMMERER & COMPANY	KAMMERER & COMPANY	KAMMERER & COMPANY	KAMMERER & COMPANY, INC.
auth_city	El Dorado Hills	El Dorado Hills	El Dorado Hills	El Dorado Hills	El Dorado Hills	El Dorado Hills	El Dorado Hills	El Dorado Hills	El Dorado Hills	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO
auth_st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA
auth_zip4	95762	95762	95762	95762	95762	95762	95762	95762	95762	95814	95814	95814	95814	95814
lobby_int	None	None	None	None	None	None	None	None	None	None	None	None	None	None
influen_yn	None	None	None	None	None	None	None	None	None	None	None	None	None	None
firm_name	None	None	None	None	None	None	None	None	None	None	None	None	None	None
newcert_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None
rencert_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None
complet_dt	None	None	None	None	None	None	None	None	None	None	None	None	None	None
lby_reg_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None
lby_604_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None
st_leg_yn	None	None	None	None	None	None	None	None	None	None	None	None	None	None
st_agency	None	None	None	None	None	None	None	None	None	None	None	None	None	None
lobby_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None
l_firm_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None

Table: filer_address
filer_id	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222
adrid	2083499	2114930	2149157	2162985	2207564	2504366	2504367	2415753	2470272	2269476	2341612	2548177	2548178
effect_dt	2005-01-01 00:00:00	2007-01-01 00:00:00	2008-07-09 00:00:00	2009-01-01 00:00:00	2011-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2017-01-01 00:00:00	2019-01-01 00:00:00	2013-01-01 00:00:00	2015-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00
add_type	7082	7051	7051	7051	7051	7051	7082	7051	7051	7051	7051	7051	7082
session_id	2005	2007	2007	2009	2011	2021	2021	2017	2019	2013	2015	2023	2023

Table: filer_filings
filer_id	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222
filing_id	1014284	1027989	1018627	1036434	1063799	1081478	1068941	1058719	1093306	1082407	1104607	1121342	1134231	1167827	1148725	1189124	1230179	1191263	1224999	1215128	1242572	1262816	1295816	1295816	1295816	1278368	1978997	1965241	1868683	1868777	1860225	1798778	1763610	1789433	1775822	1935759	1944802	1909221	1308078	1308078	1311598	1332226	1343175	1332226	1353720	1388988	1373960	1411006	1418415	1385860	1436924	1451128	1458183	1501545	1488113	1544972	1544973	1535503	1547844	1567385	1588658	1602919	1630645	1620319	1651435	1677600	1812073	1921718	1719012	1706826	1878926	1731782	1733777	1843503	1843503	1763610	1992521	2269518	2211667	2554279	2354224	2452188	2037328	2012626	2060019	2100595	2117513	2130262	2141917	2173173	2153890	2191445	2418691	2381633	2529855	2579643	2242231	2333589	2318179	2486985	2349934	2469804	2399393	2443078	2644906	2675860	2588028	2593724	2603428	2644906	2623892	2581082	2706149	2748343
period_id	177	178	None	None	None	180	180	179	None	None	181	182	183	185	184	187	188	186	188	187	None	189	191	191	191	190	222	221	219	218	None	215	213	213	214	220	None	219	193	193	192	193	194	193	None	196	195	None	197	196	198	199	200	202	201	204	204	203	None	204	205	206	208	207	209	210	216	220	212	211	None	None	212	217	217	213	223	234	232	244	None	None	225	224	226	227	228	228	None	230	229	231	239	237	243	None	233	236	235	242	236	241	238	240	248	249	244	None	246	248	247	245	250	251
form_id	F635	F635	F635	F635	F635	F635	F602	F635	F635	F602	F635	F635	F635	F635	F635	F602	F635	F635	F602	F635	F602	F635	F635	F635	F635	F635	F635	F635	F602	F635	F605	F635	F635	F635	F635	F635	F602	F635	F602	F602	F635	F635	F635	F635	F605	F635	F635	F602	F635	F602	F635	F635	F635	F635	F635	F602	F602	F635	F602	F635	F635	F635	F635	F635	F635	F635	F635	F602	F602	F635	F602	F602	F635	F635	F635	F635	F635	F635	F635	F635	F602	F602	F635	F635	F635	F635	F602	F635	F602	F635	F635	F635	F635	F635	F635	F602	F635	F602	F635	F635	F635	F635	F635	F635	F635	F635	F602	F602	F635	F635	F635	F635	F635	F635
filing_sequence	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	1	0	0	0	0	0	0	0	1	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	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	0	0	0	0	0	0	0	0	0	1	0	0	0	0
filing_date	2004-04-30 00:00:00	2004-07-29 00:00:00	2004-04-30 00:00:00	2004-08-02 00:00:00	2004-11-01 00:00:00	2005-01-31 00:00:00	2004-12-30 00:00:00	2004-10-31 00:00:00	2005-01-31 00:00:00	2005-01-11 00:00:00	2005-04-29 00:00:00	2005-08-05 00:00:00	2005-10-31 00:00:00	2006-05-01 00:00:00	2006-01-31 00:00:00	2006-07-28 00:00:00	2007-01-23 00:00:00	2006-07-31 00:00:00	2006-12-28 00:00:00	2006-10-30 00:00:00	2007-01-03 00:00:00	2007-05-01 00:00:00	2007-10-29 00:00:00	2007-10-29 00:00:00	2007-10-29 00:00:00	2007-07-19 00:00:00	2015-07-29 00:00:00	2015-04-30 00:00:00	2014-07-29 00:00:00	2014-07-29 00:00:00	2014-06-16 00:00:00	2013-10-29 00:00:00	2013-10-07 00:00:00	2013-08-29 00:00:00	2013-07-16 00:00:00	2015-02-01 00:00:00	2014-12-30 00:00:00	2014-10-30 00:00:00	2008-01-29 00:00:00	2008-01-29 00:00:00	2008-01-31 00:00:00	2008-05-13 00:00:00	2008-07-14 00:00:00	2008-07-09 00:00:00	2008-06-11 00:00:00	2009-01-12 00:00:00	2008-10-28 00:00:00	2008-12-30 00:00:00	2009-04-23 00:00:00	2008-12-29 00:00:00	2009-07-30 00:00:00	2009-10-29 00:00:00	2010-01-18 00:00:00	2010-07-20 00:00:00	2010-05-17 00:00:00	2010-11-16 00:00:00	2010-11-16 00:00:00	2010-10-26 00:00:00	2010-11-22 00:00:00	2011-01-27 00:00:00	2011-04-27 00:00:00	2011-07-25 00:00:00	2012-01-23 00:00:00	2011-10-27 00:00:00	2012-04-10 00:00:00	2012-07-30 00:00:00	2014-01-23 00:00:00	2014-12-30 00:00:00	2012-12-20 00:00:00	2012-10-29 00:00:00	2014-07-29 00:00:00	2012-12-24 00:00:00	2013-01-28 00:00:00	2014-04-29 00:00:00	2014-04-29 00:00:00	2013-04-29 00:00:00	2015-10-19 00:00:00	2018-07-25 00:00:00	2018-01-31 00:00:00	2021-02-01 00:00:00	2019-01-10 00:00:00	2020-02-12 00:00:00	2016-05-02 00:00:00	2016-02-01 00:00:00	2016-07-28 00:00:00	2016-10-30 00:00:00	2017-01-05 00:00:00	2017-01-31 00:00:00	2017-01-05 00:00:00	2017-07-27 00:00:00	2017-04-26 00:00:00	2017-10-27 00:00:00	2019-10-30 00:00:00	2019-04-30 00:00:00	2020-11-01 00:00:00	2021-01-11 00:00:00	2018-04-30 00:00:00	2019-01-10 00:00:00	2018-10-30 00:00:00	2020-07-31 00:00:00	2019-01-31 00:00:00	2020-04-29 00:00:00	2019-07-31 00:00:00	2020-01-31 00:00:00	2022-01-31 00:00:00	2022-05-01 00:00:00	2021-06-12 00:00:00	2021-05-03 00:00:00	2021-08-02 00:00:00	2022-05-01 00:00:00	2021-11-01 00:00:00	2021-04-30 00:00:00	2022-08-01 00:00:00	2022-10-31 00:00:00
stmnt_type	10001	10001	10005	10005	10005	10001	10001	10001	10005	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10002	10001	10002	10001	10001	10001	10001	10001	10006	10001	10002	10001	10001	10001	10005	10001	10002	10001	10001	10001	10001	10002	10005	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10005	10001	10001	10002	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10002	10001	10001	10001	10001
stmnt_status	11003	11003	11001	11001	11001	11003	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11003	11003
session_id	2003	2003	2003	2003	2003	2003	2005	2003	2003	2005	2005	2005	2005	2005	2005	2006	2005	2005	2007	2005	2007	2007	2007	2007	2007	2007	2015	2015	2013	2013	2013	2013	2013	2013	2013	2013	2015	2013	2008	2008	2007	2007	2007	2007	2007	2007	2007	2009	2009	2009	2009	2009	2009	2009	2009	2011	2011	2009	2011	2009	2011	2011	2011	2011	2011	2011	2013	2015	2013	2011	2013	2013	2011	2013	2013	2013	2015	2017	2017	2019	2019	2019	2015	2015	2015	2015	2017	2015	2017	2017	2017	2017	2019	2019	2019	2021	2017	2019	2017	2019	2017	2019	2019	2019	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021
user_id	COMPLETED	COMPLETED	LTHIBAUL	LTHIBAUL	LTHIBAUL	COMPLETED	YRODRIGU	COMPLETED	LTHIBAUL	PBANFORD	LTHIBAUL	DHORRELL	LTHIBAUL	LTHIBAUL	LTHIBAUL	YRODRIGU	LTHIBAUL	LTHIBAUL	YRODRIGU	LTHIBAUL	CFLAGG	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	AGLADNEY	AGLADNEY	PBANFORD	ASAETERN	YRODRIGU	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	PBANFORD	AGLADNEY	YRODRIGU	YRODRIGU	LTHIBAUL	LTHIBAUL	YRODRIGU	LTHIBAUL	LTHIBAUL	JGRISSUM	JGRISSUM	PBANFORD	JGRISSUM	YRODRIGU	JGRISSUM	MGUERRA	JINGRAM	ASAETERN	ASAETERN	YRODRIGU	PBANFORD	ASAETERN	SARRIAGA	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	ASAETERN	AGLADNEY	AGLADNEY	AGLADNEY	PBANFORD	PBANFORD	AGLADNEY	PBANFORD	PBANFORD	ASAETERN	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	GTAYLOR	SARRIAGA	GPEREZ	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	SARRIAGA	AGLADNEY	SARRIAGA	AGLADNEY	AGLADNEY	AGLADNEY	SUSHAKOV	GTAYLOR	GTAYLOR	CVANLIEW	AGLADNEY	SARRIAGA	AGLADNEY	GTAYLOR	AGLADNEY	SUSHAKOV	SUSHAKOV	AGLADNEY	GTAYLOR	CAFILER	MKIRKHAM	MKIRKHAM	CHATRIDGE	GTAYLOR	CHATRIDGE	GTAYLOR	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
fine_audit	11003	11003	11003	11003	11003	11003	11001	11003	11003	11003	11003	11001	11003	11003	11003	11001	11003	11003	11001	11003	11003	11003	11003	11003	11003	11003	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11003	11001	11003	11003	11003	11003	11003	11001	11003	11001	11003	11001	11001	11001	11003	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11001	11001	11001	11001	11003	11001	11003	11001	11001	11001	11001	11001	11001	11003	11001	11003	11001	11001	11001	11001	11001	11001	11001	11003	11003	11003	11001	11001	11001	11001	11003	11003
rpt_start	2004-01-01 00:00:00	2004-04-01 00:00:00	2004-01-01 00:00:00	2004-04-01 00:00:00	2004-07-01 00:00:00	2004-10-01 00:00:00	2004-12-30 00:00:00	2004-07-01 00:00:00	2004-10-01 00:00:00	1900-01-01 00:00:00	2005-01-01 00:00:00	2005-04-01 00:00:00	2005-07-01 00:00:00	2006-01-01 00:00:00	2005-10-01 00:00:00	2006-07-28 00:00:00	2006-10-01 00:00:00	2006-04-01 00:00:00	2006-12-28 00:00:00	2006-07-01 00:00:00	1900-01-01 00:00:00	2007-01-01 00:00:00	2007-07-01 00:00:00	2007-07-01 00:00:00	2007-07-01 00:00:00	2007-04-01 00:00:00	2015-04-01 00:00:00	2015-01-01 00:00:00	2014-07-28 00:00:00	2014-04-01 00:00:00	1900-01-01 00:00:00	2013-07-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-04-01 00:00:00	2014-10-01 00:00:00	1900-01-01 00:00:00	2014-07-01 00:00:00	2008-01-29 00:00:00	2008-01-29 00:00:00	2007-10-01 00:00:00	2008-01-01 00:00:00	2008-04-01 00:00:00	2008-01-01 00:00:00	1900-01-01 00:00:00	2008-10-01 00:00:00	2008-07-01 00:00:00	1900-01-01 00:00:00	2009-01-01 00:00:00	2008-12-29 00:00:00	2009-04-01 00:00:00	2009-07-01 00:00:00	2009-10-01 00:00:00	2010-04-01 00:00:00	2010-01-01 00:00:00	2010-11-16 00:00:00	2010-11-16 00:00:00	2010-07-01 00:00:00	1900-01-01 00:00:00	2010-10-01 00:00:00	2011-01-01 00:00:00	2011-04-01 00:00:00	2011-10-01 00:00:00	2011-07-01 00:00:00	2012-01-01 00:00:00	2012-04-01 00:00:00	2013-10-01 00:00:00	2014-12-31 00:00:00	2012-12-20 00:00:00	2012-07-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2012-10-01 00:00:00	2014-01-01 00:00:00	2014-01-01 00:00:00	2013-01-01 00:00:00	2015-07-01 00:00:00	2018-04-01 00:00:00	2017-10-01 00:00:00	2020-10-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2016-01-01 00:00:00	2015-10-01 00:00:00	2016-04-01 00:00:00	2016-07-01 00:00:00	2016-12-31 00:00:00	2016-10-01 00:00:00	1900-01-01 00:00:00	2017-04-01 00:00:00	2017-01-01 00:00:00	2017-07-01 00:00:00	2019-07-01 00:00:00	2019-01-01 00:00:00	2020-07-01 00:00:00	1900-01-01 00:00:00	2018-01-01 00:00:00	2018-11-26 00:00:00	2018-07-01 00:00:00	2020-04-01 00:00:00	2018-10-01 00:00:00	2020-01-01 00:00:00	2019-04-01 00:00:00	2019-10-01 00:00:00	2021-10-01 00:00:00	2022-01-01 00:00:00	2020-12-16 00:00:00	1900-01-01 00:00:00	2021-04-01 00:00:00	2021-10-01 00:00:00	2021-07-01 00:00:00	2021-01-01 00:00:00	2022-04-01 00:00:00	2022-07-01 00:00:00
rpt_end	2004-03-31 00:00:00	2004-06-30 00:00:00	2004-04-30 00:00:00	2004-06-30 00:00:00	2004-09-30 00:00:00	2004-12-31 00:00:00	2004-12-30 00:00:00	2004-09-30 00:00:00	2004-12-31 00:00:00	1900-01-01 00:00:00	2005-03-31 00:00:00	2005-06-30 00:00:00	2005-09-30 00:00:00	2006-03-31 00:00:00	2005-12-31 00:00:00	2006-07-28 00:00:00	2006-12-31 00:00:00	2006-06-30 00:00:00	2006-12-28 00:00:00	2006-09-30 00:00:00	1900-01-01 00:00:00	2007-03-31 00:00:00	2007-09-30 00:00:00	2007-09-30 00:00:00	2007-09-30 00:00:00	2007-06-30 00:00:00	2015-06-30 00:00:00	2015-03-31 00:00:00	2014-07-28 00:00:00	2014-06-30 00:00:00	1900-01-01 00:00:00	2013-09-30 00:00:00	2013-03-31 00:00:00	2013-03-31 00:00:00	2013-06-30 00:00:00	2014-12-31 00:00:00	1900-01-01 00:00:00	2014-09-30 00:00:00	2008-01-29 00:00:00	2008-01-29 00:00:00	2007-12-31 00:00:00	2008-03-31 00:00:00	2008-06-30 00:00:00	2008-03-31 00:00:00	1900-01-01 00:00:00	2008-12-31 00:00:00	2008-09-30 00:00:00	1900-01-01 00:00:00	2009-03-31 00:00:00	2008-12-29 00:00:00	2009-06-30 00:00:00	2009-09-30 00:00:00	2009-12-31 00:00:00	2010-06-30 00:00:00	2010-03-31 00:00:00	2010-11-16 00:00:00	2010-11-16 00:00:00	2010-09-30 00:00:00	1900-01-01 00:00:00	2010-12-31 00:00:00	2011-03-31 00:00:00	2011-06-30 00:00:00	2011-12-31 00:00:00	2011-09-30 00:00:00	2012-03-31 00:00:00	2012-06-30 00:00:00	2013-12-31 00:00:00	2014-12-31 00:00:00	2012-12-20 00:00:00	2012-09-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2012-12-31 00:00:00	2014-03-31 00:00:00	2014-03-31 00:00:00	2013-04-01 00:00:00	2015-09-30 00:00:00	2018-06-30 00:00:00	2017-12-31 00:00:00	2020-12-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2016-03-31 00:00:00	2015-12-31 00:00:00	2016-06-30 00:00:00	2016-09-30 00:00:00	2016-12-31 00:00:00	2016-12-31 00:00:00	1900-01-01 00:00:00	2017-06-30 00:00:00	2017-03-31 00:00:00	2017-09-30 00:00:00	2019-09-30 00:00:00	2019-03-31 00:00:00	2020-09-30 00:00:00	1900-01-01 00:00:00	2018-03-31 00:00:00	2018-11-26 00:00:00	2018-09-30 00:00:00	2020-06-30 00:00:00	2018-12-31 00:00:00	2020-03-31 00:00:00	2019-06-30 00:00:00	2019-12-31 00:00:00	2021-12-31 00:00:00	2022-03-31 00:00:00	2020-12-16 00:00:00	1900-01-01 00:00:00	2021-06-30 00:00:00	2021-12-31 00:00:00	2021-09-30 00:00:00	2021-03-31 00:00:00	2022-06-30 00:00:00	2022-09-30 00:00:00
rpt_date	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
filing_type	22001	22001	None	None	None	22001	22001	22001	None	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	None	22001	22001	22001	22001	22001	22001	22001	22001	None	None	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001

Table: filer_interests
filer_id	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222
session_id	2005	2009	2011	2007	2013	2021	2017	2019	2015	2023
interest_cd	40310	40310	40310	40310	40310	40310	40310	40310	40310	40310
effect_date	2005-01-01 00:00:00	2009-01-01 00:00:00	2011-01-01 00:00:00	2007-01-01 00:00:00	2013-01-01 00:00:00	2021-01-01 00:00:00	2017-01-01 00:00:00	2019-01-01 00:00:00	2015-01-01 00:00:00	2023-01-01 00:00:00

Table: filer_to_filer_type
filer_id	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222
filer_type	1	1	1	1	1	1	1	1	1	1	1
active	S	Y	Y	Y	Y	Y	Y	Y	Y	Y	N
race	0	0	0	None	None	None	None	None	None	None	None
session_id	2003	2005	2007	2013	2011	2009	2021	2015	2019	2017	2023
category	0	0	0	None	None	None	None	None	None	None	None
category_type	0	0	0	None	None	None	None	None	None	None	None
sub_category	0	0	0	None	None	None	None	None	None	None	None
effect_dt	2004-01-23 00:00:00	2005-01-01 00:00:00	2007-01-01 00:00:00	2013-01-01 00:00:00	2011-01-01 00:00:00	2009-01-01 00:00:00	2021-01-01 00:00:00	2015-01-01 00:00:00	2019-01-01 00:00:00	2017-01-01 00:00:00	2023-01-01 00:00:00
sub_category_type	0	0	0	None	None	None	None	None	None	None	None
election_type	0	0	0	None	None	None	None	None	None	None	None
sub_category_a	None	None	None	None	None	None	None	None	None	None	None
nyq_dt	None	2004-01-01 00:00:00	2004-01-01 00:00:00	None	None	None	None	None	None	None	None
party_cd	0	0	0	None	None	None	None	None	None	None	None
county_cd	0	0	0	None	None	None	None	None	None	None	None
district_cd	0	0	0	None	None	None	None	None	None	None	None

Table: filer_xref
filer_id		1262222
xref_id		1262222
effect_dt		2004-01-23 00:00:00
migration_source		CLAIMS

Table: filername
xref_filer_id	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222
filer_id	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222
filer_type	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT
status	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE
effect_dt	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00
naml	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ
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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
adr1	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
adr2	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
city	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS
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	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA
zip4	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762	95762
phon	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075	9169333075
fax	9169333072					9169333072					9169333072		9169333072	9169333072					9169333072					9169333072		9169333072	9169333072					9169333072					9169333072		9169333072	9169333072					9169333072					9169333072		9169333072	9169333072					9169333072					9169333072		9169333072	9169333072					9169333072					9169333072		9169333072	9169333072					9169333072					9169333072		9169333072	9169333072					9169333072					9169333072		9169333072	9169333072					9169333072					9169333072		9169333072	9169333072					9169333072					9169333072		9169333072	9169333072					9169333072					9169333072		9169333072
email	[email protected]	None	None	None	None	None	None	None	None	None	[email protected]	None	[email protected]	[email protected]	None	None	None	None	None	None	None	None	None	[email protected]	None	[email protected]	[email protected]	None	None	None	None	None	None	None	None	None	[email protected]	None	[email protected]	[email protected]	None	None	None	None	None	None	None	None	None	[email protected]	None	[email protected]	[email protected]	None	None	None	None	None	None	None	None	None	[email protected]	None	[email protected]	[email protected]	None	None	None	None	None	None	None	None	None	[email protected]	None	[email protected]	[email protected]	None	None	None	None	None	None	None	None	None	[email protected]	None	[email protected]	[email protected]	None	None	None	None	None	None	None	None	None	[email protected]	None	[email protected]	[email protected]	None	None	None	None	None	None	None	None	None	[email protected]	None	[email protected]	[email protected]	None	None	None	None	None	None	None	None	None	[email protected]	None	[email protected]	[email protected]	None	None	None	None	None	None	None	None	None	[email protected]	None	[email protected]

Table: filers
filer_id		1262222

Table: lobbying_chg_log
filer_id	1262222	1262222
change_no	1	0
session_id	2013	2013
log_dt	2014-06-16 00:00:00	2014-07-29 00:00:00
filer_type	1	1
correction_flg	None	None
action	DELETED	ADDED
attribute_changed	FIRM	FIRM
ethics_dt	None	None
interests	None	None
filer_full_name	CALIFORNIA METALS COALITION/CCSOJ	CALIFORNIA METALS COALITION/CCSOJ
filer_city	None	None
filer_st	None	None
filer_zip	None	None
filer_phone	None	None
entity_type	3	3
entity_name	SIMONELLI & ASSOCIATES	KAMMERER & COMPANY
entity_city	None	None
entity_st	None	None
entity_zip	None	None
entity_phone	None	None
entity_id	1147205	1255172
responsible_officer	None	None
effect_dt	2014-06-11 00:00:00	2014-07-01 00:00:00

Table: received_filings
filer_id	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222	1262222
filing_file_name	1068941_0.cal	232934.cal	206602.cal	1189124_0.cal	1332226_0.cal	1332226_1.cal	1224999_0.cal	307938.cal	307973.cal	307979.cal	307911.cal	308122.cal	308204.cal	1295816_0.cal	386905.cal	1295816_1.cal	1295816_2.cal	1373960_0.cal	1385860_0.cal	1308078_0.cal	109968.cal	1308078_1.cal	1311598_0.cal	1843503_0.cal	1544972_0.cal	1544973_0.cal	1719012_0.cal	1868683_0.cal	1965241_0.cal	1978997_0.cal	2153890_0.cal	2130262_0.cal	2060019_0.cal	1992521_0.cal	2012626_0.cal	2117513_0.cal	2100595_0.cal	1909221_0.cal	1921718_0.cal	2037328_0.cal	1935759_0.cal	2173173_0.cal	2269518_0.cal	2211667_0.cal	2191445_0.cal	2418691_0.cal	2443078_0.cal	2399393_0.cal	2242231_0.cal	2318179_0.cal	2333589_0.cal	2381633_0.cal	2349934_0.cal	2588028_0.cal
received_date	2004-12-30 00:00:00	2006-01-31 00:00:00	2006-07-28 00:00:00	2006-07-28 00:00:00	2008-05-13 00:00:00	2008-07-09 00:00:00	2006-12-28 00:00:00	2007-05-01 00:00:00	2007-05-01 00:00:00	2007-05-01 00:00:00	2007-05-01 00:00:00	2007-05-01 00:00:00	2007-05-01 00:00:00	2007-10-29 00:00:00	2007-10-29 00:00:00	2007-10-29 00:00:00	2007-10-29 00:00:00	2008-10-28 00:00:00	2008-12-29 00:00:00	2008-01-29 00:00:00	2008-01-29 00:00:00	2008-01-29 00:00:00	2008-01-31 00:00:00	2014-04-29 00:00:00	2010-11-16 00:00:00	2010-11-16 00:00:00	2012-12-20 00:00:00	2014-07-29 00:00:00	2015-04-30 00:00:00	2015-07-29 00:00:00	2017-04-26 00:00:00	2017-01-31 00:00:00	2016-07-28 00:00:00	2015-10-19 00:00:00	2016-02-01 00:00:00	2017-01-05 00:00:00	2016-10-30 00:00:00	2014-10-30 00:00:00	2014-12-30 00:00:00	2016-05-02 00:00:00	2015-02-01 00:00:00	2017-07-27 00:00:00	2018-07-25 00:00:00	2018-01-31 00:00:00	2017-10-27 00:00:00	2019-10-30 00:00:00	2020-01-31 00:00:00	2019-07-31 00:00:00	2018-04-30 00:00:00	2018-10-30 00:00:00	2019-01-10 00:00:00	2019-04-30 00:00:00	2019-01-31 00:00:00	2021-06-12 00:00:00
filing_directory	/cafiler/disclose/ca99/cal	/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/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/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/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	/cafiler/disclose/ca99/cal
filing_id	1068941	None	None	1189124	1332226	1332226	1224999	None	None	None	None	None	None	1295816	None	1295816	1295816	1373960	1385860	1308078	None	1308078	1311598	1843503	1544972	1544973	1719012	1868683	1965241	1978997	2153890	2130262	2060019	1992521	2012626	2117513	2100595	1909221	1921718	2037328	1935759	2173173	2269518	2211667	2191445	2418691	2443078	2399393	2242231	2318179	2333589	2381633	2349934	2588028
form_id	F602	None	None	F602	F635	F635	F602	None	None	None	None	None	None	F635	None	F635	F635	F635	F602	F602	None	F602	F635	F635	F602	F602	F602	F602	F635	F635	F635	F635	F635	F635	F635	F602	F635	F635	F602	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F602	F635	F635	F602
receive_comment	Filing accepted	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing accepted	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	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 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 accepted	Filing accepted	Filing accepted