OpenCalAccess

Filer ID: 1291968

Table: cvr_lobby_disclosure
filing_id	1228417	1228417	1276080	1255306	1292116	1365013	1325374	1342516	1302556	1302556	1458070	1389954	1448437	1431495	1417334	1525468	1500713	1480857	1561630	1588064	1621558	1601534	1588064	1588064	1634931	1708117	1677874	1656624	1737234	1781354	1800594	1765078	1813525	1907197	1867059	1839822	1976948	1991425	1935371	1962145	1976948	2008278	2116338	2107064	2107065	2107066	2151205	2165263	2151205	2116338	2187747	2151205	2266334	2187747	2266334	2204186	2309420	2187747	2229112	2389444	2370850	2334525	2465110	2429772	2389444	2478091	2412448	2513208	2546032	2574907	2513208	2546032	2513208	2574907	2616278	2546032	2546032	2513208	2594165	2513208	2639021	2738520	2697624	2664631
amend_id	0	1	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	2	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	1	0	2	0	2	1	0	0	1	0	0	0	0	0	0	1	0	0	1	0	0	0	2	4	1	0	3	1	2	0	3	0	0	0	0
rec_type	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR
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	F635	F635
sender_id	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968
filer_id	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968
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	LEM	LEM
filer_naml	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	California Retired County Employees Association	California Retired County Employees Association	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	California Retired County Employees Association	California Retired County Employees Association	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION
filer_namf	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
filer_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
filer_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
report_num	000	001	000	000	000	000	000	000	000	001	000	000	000	000	000	000	000	000	000	001	000	000	000	002	000	000	000	000	000	000	000	000	000	000	000	000	001	000	000	000	000	000	000	000	000	000	001	000	000	001	000	002	000	002	001	000	000	001	000	000	000	000	000	000	001	000	000	001	000	000	000	002	004	001	000	003	001	002	000	003	000	000	000	000
rpt_date	2007-01-17 00:00:00	2007-01-17 00:00:00	2007-07-03 00:00:00	2007-04-04 00:00:00	2007-10-04 00:00:00	2008-10-09 00:00:00	2008-04-18 00:00:00	2008-07-09 00:00:00	2008-01-08 00:00:00	2008-01-08 00:00:00	2010-01-15 00:00:00	2009-01-16 00:00:00	2009-10-20 00:00:00	2009-07-17 00:00:00	2009-04-14 00:00:00	2010-10-13 00:00:00	2010-07-15 00:00:00	2010-04-20 00:00:00	2011-01-19 00:00:00	2011-04-28 00:00:00	2011-10-29 00:00:00	2011-07-20 00:00:00	2011-04-25 00:00:00	2011-04-28 00:00:00	2012-01-30 00:00:00	2012-10-30 00:00:00	2012-07-30 00:00:00	2012-04-29 00:00:00	2013-01-30 00:00:00	2013-07-30 00:00:00	2013-10-31 00:00:00	2013-04-30 00:00:00	2014-01-27 00:00:00	2014-10-28 00:00:00	2014-07-27 00:00:00	2014-04-21 00:00:00	2015-10-12 00:00:00	2015-10-12 00:00:00	2015-01-31 00:00:00	2015-04-26 00:00:00	2015-07-24 00:00:00	2016-01-27 00:00:00	2017-01-03 00:00:00	2016-11-12 00:00:00	2016-11-12 00:00:00	2016-11-12 00:00:00	2017-05-08 00:00:00	2017-07-03 00:00:00	2017-04-14 00:00:00	2017-03-24 00:00:00	2017-10-13 00:00:00	2017-08-30 00:00:00	2018-07-18 00:00:00	2018-01-23 00:00:00	2018-07-30 00:00:00	2018-01-23 00:00:00	2018-10-19 00:00:00	2018-01-23 00:00:00	2018-04-07 00:00:00	2019-07-10 00:00:00	2019-04-06 00:00:00	2019-01-15 00:00:00	2020-04-07 00:00:00	2020-01-11 00:00:00	2019-10-09 00:00:00	2020-07-13 00:00:00	2019-10-09 00:00:00	2021-02-08 00:00:00	2021-01-22 00:00:00	2021-04-19 00:00:00	2020-10-12 00:00:00	2021-08-16 00:00:00	2021-09-29 00:00:00	2021-06-29 00:00:00	2021-10-15 00:00:00	2021-09-29 00:00:00	2021-06-29 00:00:00	2021-06-29 00:00:00	2021-07-19 00:00:00	2021-08-16 00:00:00	2022-01-27 00:00:00	2022-10-21 00:00:00	2022-07-12 00:00:00	2022-04-09 00:00:00
from_date	2006-10-01 00:00:00	2006-10-01 00:00:00	2007-04-01 00:00:00	2007-01-01 00:00:00	2007-07-01 00:00:00	2008-07-01 00:00:00	2008-01-01 00:00:00	2008-04-01 00:00:00	2007-10-01 00:00:00	2007-10-01 00:00:00	2009-10-01 00:00:00	2008-10-01 00:00:00	2009-07-01 00:00:00	2009-04-01 00:00:00	2009-01-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-01-01 00:00:00	2011-07-01 00:00:00	2011-04-01 00:00:00	2011-01-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-04-01 00:00:00	2013-07-01 00:00:00	2013-01-01 00:00:00	2013-10-01 00:00:00	2014-07-01 00:00:00	2014-04-01 00:00:00	2014-01-01 00:00:00	2015-04-01 00:00:00	2015-07-01 00:00:00	2014-10-01 00:00:00	2015-01-01 00:00:00	2015-04-01 00:00:00	2015-10-01 00:00:00	2016-01-01 00:00:00	2016-01-01 00:00:00	2016-04-01 00:00:00	2016-07-01 00:00:00	2017-01-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	2017-01-01 00:00:00	2018-01-01 00:00:00	2017-07-01 00:00:00	2018-04-01 00:00:00	2017-10-01 00:00:00	2018-07-01 00:00:00	2017-07-01 00:00:00	2018-01-01 00:00:00	2019-04-01 00:00:00	2019-01-01 00:00:00	2018-10-01 00:00:00	2020-01-01 00:00:00	2019-10-01 00:00:00	2019-04-01 00:00:00	2020-04-01 00:00:00	2019-07-01 00:00:00	2020-07-01 00:00:00	2020-10-01 00:00:00	2021-01-01 00:00:00	2020-07-01 00:00:00	2020-10-01 00:00:00	2020-07-01 00:00:00	2021-01-01 00:00:00	2021-07-01 00:00:00	2020-10-01 00:00:00	2020-10-01 00:00:00	2020-07-01 00:00:00	2021-04-01 00:00:00	2020-07-01 00:00:00	2021-10-01 00:00:00	2022-07-01 00:00:00	2022-04-01 00:00:00	2022-01-01 00:00:00
thru_date	2006-12-31 00:00:00	2006-12-31 00:00:00	2007-06-30 00:00:00	2007-03-31 00:00:00	2007-09-30 00:00:00	2008-09-30 00:00:00	2008-03-31 00:00:00	2008-06-30 00:00:00	2007-12-31 00:00:00	2007-12-31 00:00:00	2009-12-31 00:00:00	2008-12-31 00:00:00	2009-09-30 00:00:00	2009-06-30 00:00:00	2009-03-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-03-31 00:00:00	2011-09-30 00:00:00	2011-06-30 00:00:00	2011-03-31 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-06-30 00:00:00	2013-09-30 00:00:00	2013-03-31 00:00:00	2013-12-31 00:00:00	2014-09-30 00:00:00	2014-06-30 00:00:00	2014-03-31 00:00:00	2015-06-30 00:00:00	2015-09-30 00:00:00	2014-12-31 00:00:00	2015-03-31 00:00:00	2015-06-30 00:00:00	2015-12-31 00:00:00	2016-12-31 00:00:00	2016-03-31 00:00:00	2016-06-30 00:00:00	2016-09-30 00:00:00	2017-03-31 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	2017-03-31 00:00:00	2018-06-30 00:00:00	2017-09-30 00:00:00	2018-06-30 00:00:00	2017-12-31 00:00:00	2018-09-30 00:00:00	2017-09-30 00:00:00	2018-03-31 00:00:00	2019-06-30 00:00:00	2019-03-31 00:00:00	2018-12-31 00:00:00	2020-03-31 00:00:00	2019-12-31 00:00:00	2019-06-30 00:00:00	2020-06-30 00:00:00	2019-09-30 00:00:00	2020-09-30 00:00:00	2020-12-31 00:00:00	2021-03-31 00:00:00	2020-09-30 00:00:00	2020-12-31 00:00:00	2020-09-30 00:00:00	2021-03-31 00:00:00	2021-09-30 00:00:00	2020-12-31 00:00:00	2020-12-31 00:00:00	2020-09-30 00:00:00	2021-06-30 00:00:00	2020-09-30 00:00:00	2021-12-31 00:00:00	2022-09-30 00:00:00	2022-06-30 00:00:00	2022-03-31 00:00:00
cum_beg_dt	2005-01-01 00:00:00	2005-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	2007-01-01 00:00:00	2007-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	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	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	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	2016-01-01 00:00:00	2016-01-01 00:00:00	2016-01-01 00:00:00	2016-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2016-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2018-01-01 00:00:00	2017-01-01 00:00:00	2018-01-01 00:00:00	2017-01-01 00:00:00	2018-01-01 00:00:00	2017-01-01 00:00:00	2018-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2018-01-01 00:00:00	2020-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2020-01-01 00:00:00	2019-01-01 00:00:00	2020-01-01 00:00:00	2020-01-01 00:00:00	2021-01-01 00:00:00	2020-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	2019-01-01 00:00:00	2020-01-01 00:00:00	2020-01-01 00:00:00	2021-01-01 00:00:00	2019-01-01 00:00:00	2021-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00
firm_id	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	1291968	1291968	None	None	None	1291968	1291968	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	California Retired County Employees Association	California Retired County Employees Association	None	None	None	California Retired County Employees Association	California Retired County Employees Association	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
firm_city	HUNTINGTON BEACH	HUNTINGTON BEACH	HUNTINGTON BEACH	HUNTINGTON BEACH	HUNTINGTON BEACH	HUNTINGTON BEACH	HUNTINGTON BEACH	HUNTINGTON BEACH	HUNTINGTON BEACH	HUNTINGTON BEACH	FONTANA	HUNTINGTON BEACH	FONTANA	FONTANA	FONTANA	FONTANA	FONTANA	FONTANA	FONTANA	FONTANA	FONTANA	FONTANA	FONTANA	FONTANA	FONTANA	FONTANA	FONTANA	FONTANA	FONTANA	FONTANA	FONTANA	FONTANA	FONTANA	Fontana	Fontana	FONTANA	FONTANA	FONTANA	Fontana	Fontana	FONTANA	FONTANA	FONTANA	FONTANA	FONTANA	FONTANA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA
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	CA	CA
firm_zip4	926053266	926053266	926053266	926053266	926053266	926053266	926053266	926053266	926053266	926053266	92331	926053266	92331	92331	92331	92331	92331	92331	92331	92331	92331	92331	92331	92331	92331	92331	92331	92331	92331	92331	92331	92331	92331	92331	92331	92331	92331	92331	92331	92331	92331	92331	92331	92331	92331	92331	92399	92399	92399	92399	92399	92399	92399	92399	92399	92399	92399	92399	92399	92399	92399	92399	92399	92399	92399	92399	92399	92399	92399	92399	92399	92399	92399	92399	92399	92399	92399	92399	92399	92399	92399	92399	92399	92399
firm_phon	7148400553	7148400553	7148400553	7148400553	7148400553	7148400553	7148400553	7148400553	7148400553	7148400553	7607870945	7148400553	7607870945	7148403995	7148403995	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	760-787-0945	760-787-0945	7607870945	7607870945	7607870945	760-787-0945	760-787-0945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	9097907199	9097907199	7607870945	9097907199	9097907199	9097907199	9097907199	9097907199	9097907199	9097907199	7607870945	9097907199	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945	7607870945
mail_city	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	FONTANA	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	CA	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	92331	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	7607870945	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	2007-01-17 00:00:00	2007-01-17 00:00:00	2007-07-03 00:00:00	2007-04-04 00:00:00	2007-10-04 00:00:00	2008-10-09 00:00:00	2008-04-18 00:00:00	2008-07-09 00:00:00	2008-01-08 00:00:00	2008-01-08 00:00:00	2010-01-15 00:00:00	2009-01-16 00:00:00	2009-10-20 00:00:00	2009-07-17 00:00:00	2009-04-14 00:00:00	2010-10-13 00:00:00	2010-07-15 00:00:00	2010-04-20 00:00:00	2011-01-19 00:00:00	2011-04-25 00:00:00	2011-10-29 00:00:00	2011-07-20 00:00:00	2011-04-25 00:00:00	2011-04-28 00:00:00	2012-01-30 00:00:00	2012-10-30 00:00:00	2012-07-30 00:00:00	2012-04-29 00:00:00	2013-01-30 00:00:00	2013-07-30 00:00:00	2013-10-31 00:00:00	2013-04-30 00:00:00	2014-01-27 00:00:00	2014-10-28 00:00:00	2014-07-27 00:00:00	2014-04-21 00:00:00	2015-10-12 00:00:00	2015-10-12 00:00:00	2014-01-31 00:00:00	2014-04-26 00:00:00	2015-07-23 00:00:00	2016-01-27 00:00:00	2017-01-03 00:00:00	2016-11-13 00:00:00	2016-11-13 00:00:00	2016-11-13 00:00:00	2017-05-08 00:00:00	2017-07-03 00:00:00	2017-04-14 00:00:00	2017-03-24 00:00:00	2017-10-13 00:00:00	2017-08-30 00:00:00	2018-07-18 00:00:00	2018-01-23 00:00:00	2018-07-30 00:00:00	2018-01-23 00:00:00	2018-10-19 00:00:00	2018-01-23 00:00:00	2018-04-07 00:00:00	2019-07-10 00:00:00	2019-04-06 00:00:00	2019-01-15 00:00:00	2020-04-07 00:00:00	2020-01-11 00:00:00	2019-10-09 00:00:00	2020-07-13 00:00:00	2019-10-09 00:00:00	2021-02-08 00:00:00	2021-01-22 00:00:00	2021-04-19 00:00:00	2020-10-12 00:00:00	2021-08-16 00:00:00	2021-09-29 00:00:00	2021-06-29 00:00:00	2021-10-15 00:00:00	2021-09-29 00:00:00	2021-06-29 00:00:00	2021-06-29 00:00:00	2021-07-19 00:00:00	2021-08-16 00:00:00	2022-01-27 00:00:00	2022-10-21 00:00:00	2022-07-12 00:00:00	2022-04-09 00:00:00
sig_loc	Huntington Beach, CA	Huntington Beach, CA	Huntington Beach, CA	Huntington Beach, CA	Huntington Beach, CA	Fontana, CA	Huntington Beach, CA	Fontana, CA	Huntington Beach, CA	Huntington Beach, CA	Fontana, CA	Huntington Beach, CA	Fontana, CA	Fontana, CA	Fontana, CA	Fontana, CA	Fontana, CA	Fontana, CA	Fontana, CA	Fontana, CA	Fontana, CA	Fontana, CA	Fontana, CA	Fontana, CA	Fontana, CA	Fontana, CA	Fontana, CA	Fontana, CA	Fontana, CA	Fontana, CA	Fontana, CA	Fontana, ca	Fontana, CA	Fontana, CA	Fontana, CA	Fontana, CA	Vista, CA	Vista, CA	Fontana, CA	Fontana, CA	FONTANA, CA	VISTA, CA	VISTA, CA	Yorba Linda, California	Yorba Linda, California	Yorba Linda, California	VISTA, CA	VISTA, CA	VISTA, CA	VISTA, CA	VISTA, CA	VISTA, CA	VISTA, CA	VISTA, CA	Vista	VISTA, CA	Vista	VISTA, CA	VISTA, CA	VISTA	Vista	Vista	VISTA, CA	VISTA	Vista	Vista, California	Vista	VISTA, CALIFORNIA	VISTA	VISTA	Vista	VISTA	Vista, California	Vista, California	VISTA, CALIFORNIA	Vista, California	Vista, California	Vista, California	VISTA	VISTA	Vista, California	Vista, California	Vista, California	Vista, California
sig_naml	Kirkwood	Kirkwood	Kirkwood	Kirkwood	Kirkwood	De la Graza	Kirkwood	De la Graza	Kirkwood	Kirkwood	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	GONZALEZ	Gonzalez	Gonzalez	Gonzalez	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	Gonzalez	GONZALEZ	Gonzalez	Gonzalez
sig_namf	H. William	H. William	H. William	H. William	H. William	William	H. William	William	H. William	H. William	E.F. Skip	Skip	E.F. Skip	E.F. Skip	Skip	E.F. Skip	E.F. (Skip)	E.F. (Skip)	EF Skip	E.F. Skip	E.F. Skip	E.F. Skip	E.F. Skip	E.F. Skip	E.F. Skip	E.F. Skip	E.F. Skip	E.F. Skip	E.F. Skip	E.F. Skip	E.F. Skip	E.F. Skip	E.F Skip	F. Skip	F. Skip	E.F Skip	Earl	E. F. 'Skip'	F. Skip	F. Skip	E.F. 'Skip'	E.F. 'Skip'	CARLOS	Carlos	Carlos	Carlos	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	Carlos	CARLOS	Carlos	Carlos
sig_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	E.	E.	None	None	None	E.	E.	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None
prn_naml	Kirkwood	Kirkwood	Kirkwood	Kirkwood	Kirkwood	De la Graza	Kirkwood	De la Graza	Kirkwood	Kirkwood	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	Murphy	GONZALEZ	Gonzalez	Gonzalez	Gonzalez	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	GONZALEZ	Gonzalez	GONZALEZ	Gonzalez	Gonzalez
prn_namf	H. William	H. William	H. William	H. William	H. William	William	H. William	William	H. William	H. William	E.F. Skip	Skip	E.F. Skip	E.F. Skip	Skip	E.F. Skip	E.F. (Skip)	E.F. (Skip)	EF Skip	E.F. Skip	E.F. Skip	E.F. Skip	E.F. Skip	E.F. Skip	E.F. Skip	E.F. Skip	E.F. Skip	E.F. Skip	E.F. Skip	E.F. Skip	E.F. Skip	E.F. Skip	E.F Skip	F. Skip	F. Skip	E.F Skip	Earl	E. F. 'Skip'	F. Skip	F. Skip	E.F. 'Skip'	E.F. 'Skip'	CARLOS	Carlos	Carlos	Carlos	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	CARLOS	Carlos	CARLOS	Carlos	Carlos
prn_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	E.	E.	None	None	None	E.	E.	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None
sig_title	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	TREASURER	Treasurer	Treasurer	Treasurer	TREASURER	TREASURER	TREASURER	TREASURER	TREASURER	TREASURER	TREASURER	TREASURER	TREASURER	TREASURER	TREASURER	TREASURER	TREASURER	TREASURER	TREASURER	TREASURER	TREASURER	TREASURER	TREASURER	Treasurer	TREASURER	TREASURER	TREASURER	TREASURER	Treasurer	Treasurer	TREASURER	TREASURER	TREASURER	TREASURER	TREASURER	TREASURER	TREASURER	Treasurer	Treasurer	TREASURER	Treasurer	Treasurer
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	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	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	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	None	None
ctrib_n_cb	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	X	X	X	X	X	X	X	X	X	None	X	X	None	X	None	None	None	None	None	None	None	None	None	None	None	None	None	X	None	None	X	X	None	X	None	X	None	X	X	None	None	None	None	None	None	None
ctrib_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	X	None	None	None	None	None	None	None	None	None	None	X	None	None	X	None	X	X	X	X	X	X	X	X	X	X	X	X	X	None	X	X	None	None	X	None	X	None	X	None	None	X	X	X	X	X	X	X
lby_actvty	N/A	N/A	State Legislature; Governor's Office; AB 1276	CA Legislature/Governor's Office	CA State Legislature; AB 1276 and public employment bills	AB 1184; AB 1844; SB 1123; CA Legislature	AB 2526; Legislature	AB 2526; SB 1123; CA Legislature	None	None	AB 1136; SB 414; CA State Legislature; Governor's Office	CA State Budget/CA State Legislature	AB 1136; CA State Legislature; Governor's Office	AB 1136; SB 414; CA State Legislature	AB 104; SB 414; CA State Legislature	SB 414; CA State Legislature/Governor's Office	SB 414; SB 1425; CA State Legislature	SB 414; CA State Legislature	None.	SB 203; Legislature	SB 203; Legislature	SB 203; Legislature	SB 203; Legislature	SB 203; Legislature	No lobbying activity	SB 1382; AB 1747; SB 1234	SB 1382	SB 1382	No Lobbying Activity	No Lobbying Activity	No Lobbying Activity	No Lobbying Activity	No Lobbying Activity this period.	AB 1804 & AB 1824 -- Legislature, Governor	AB 1804 & AB 1824 -- Legislature	AB 1804 & AB 1824	None This Period.	None This Period.	None This Period.	None This Period.	None This Period.	None This Period.	AB 241 Legislature.	None This Period.	AB 241 Legislature.	AB 241 Legislature.	None	None	None	AB 241 Legislature.	NONE THIS PERIOD	NONE	NONE THIS PERIOD	NONE THIS PERIOD	NONE THIS PERIOD	NONE THIS PERIOD	NONE THIS PERIOD	NONE THIS PERIOD	NONE THIS PERIOD	NONE THIS PERIOD	NONE THIS PERIOD	NONE THIS PERIOD	NONE THIS PERIOD	NONE THIS PERIOD	NONE THIS PERIOD	NONE THIS PERIOD	NONE THIS PERIOD	NONE THIS PERIOD	NONE THIS PERIOD	NONE THIS PERIOD	NONE THIS PERIOD	NONE THIS PERIOD	NONE THIS PERIOD	NONE THIS PERIOD	NONE THIS PERIOD	NONE THIS PERIOD	NONE THIS PERIOD	NONE THIS PERIOD	NONE THIS PERIOD	NONE THIS PERIOD	NONE THIS PERIOD	NONE THIS PERIOD	NONE THIS PERIOD	NONE THIS PERIOD
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	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	None	None
major_naml	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
major_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
major_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
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	None	None
rcpcmte_nm	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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_id	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None

Table: cvr_registration
filing_id	1212165	1212165	1212165	1220797	1212165	1212165	1381545	1543355	1716606
amend_id	3	4	2	0	1	0	0	0	0
rec_type	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR
form_type	F602	F602	F602	F602	F602	F602	F602	F602	F602
sender_id	1276403	1276403	1276403	1276403	1276403	1276403	1276403	1276403	1276403
filer_id	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968
entity_cd	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM
filer_naml	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION
filer_namf	None	None	None	None	None	None	None	None	None
filer_namt	None	None	None	None	None	None	None	None	None
filer_nams	None	None	None	None	None	None	None	None	None
report_num	003	004	002	000	001	000	000	000	000
rpt_date	2006-10-26 00:00:00	2006-10-26 00:00:00	2006-10-26 00:00:00	2006-11-07 00:00:00	2006-10-26 00:00:00	2006-10-24 00:00:00	2008-11-14 00:00:00	2010-11-08 00:00:00	2012-12-09 00:00:00
ls_beg_yr	2005	2005	2005	2007	2005	2005	2009	2011	2013
ls_end_yr	2006	2006	2006	2008	2006	2006	2010	2012	2014
qual_date	None	None	None	None	None	None	None	None	None
eff_date	2006-11-01 00:00:00	2006-11-01 00:00:00	2006-11-01 00:00:00	2007-01-01 00:00:00	2006-11-01 00:00:00	2006-10-24 00:00:00	2009-01-01 00:00:00	2011-01-01 00:00:00	2013-01-01 00:00:00
bus_city	HUNTINGTON BEACH	HUNTINGTON BEACH	HUNTINGTON BEACH	HUNTINGTON BEACH	HUNTINGTON BEACH	HUNTINGTON BEACH	Fontana	Fontana	FONTANA
bus_st	CA	CA	CA	CA	CA	CA	CA	CA	CA
bus_zip4	92605-3266	92605-3266	92605-3266	92605-3266	92605-3266	92605-3266	92331	92331	92331
bus_phon	714-840-0553	714-840-0553	714-840-3995	714-840-0553	714-840-3995	714-840-3995	714-840-3995	760-787-0945	7607870945
bus_fax	None	None	None	None	None	None	None	None	None
bus_email	None	None	None	None	None	None	None	[email protected]	[email protected]
mail_city	None	None	None	None	None	None	None	None	None
mail_st	None	None	None	None	None	None	None	None	None
mail_zip4	None	None	None	None	None	None	None	None	None
mail_phon	None	None	None	None	None	None	None	None	None
sig_date	2006-11-01 00:00:00	2006-11-01 00:00:00	2006-11-01 00:00:00	2006-11-07 00:00:00	2006-11-01 00:00:00	2006-10-24 00:00:00	2008-11-20 00:00:00	2010-11-15 00:00:00	2012-12-09 00:00:00
sig_loc	Huntington Beach CA	Huntington Beach CA	Huntington Beach CA	Huntington Beach CA	Huntington Beach CA	Huntington Beach CA	Fontana CA	Fontana CA	None
sig_naml	Kirkwood	Kirkwood	Kirkwood	Kirkwood	Kirkwood	Kirkwood	Murphy	Murphy	Murphy
sig_namf	William	H. William	Bill	H. William	Bill	Bill	E.F. (Skip)	E.F. Skip	E.F. Skip
sig_namt	None	None	None	None	None	None	Mr.	Mr.	None
sig_nams	None	None	None	None	None	None	None	None	None
prn_naml	None	None	None	None	None	None	None	None	Murphy
prn_namf	None	None	None	None	None	None	None	None	E.F. Skip
prn_namt	None	None	None	None	None	None	None	None	None
prn_nams	None	None	None	None	None	None	None	None	None
sig_title	President	President	President	President	None	None	President	President	President
stmt_firm	None	None	None	None	None	None	None	None	None
ind_cb	None	None	None	None	None	None	None	None	None
bus_cb	None	None	None	None	None	None	None	None	None
trade_cb	X	X	X	X	X	None	X	X	X
oth_cb	None	None	None	None	None	None	None	None	None
a_b_name	None	None	None	None	None	None	None	None	None
a_b_city	None	None	None	None	None	None	None	None	None
a_b_st	None	None	None	None	None	None	None	None	None
a_b_zip4	None	None	None	None	None	None	None	None	None
descrip_1	Coalition of all the associations of retired county employees from the 20 counties with retirement systems formed under The County Employees Retirement Law of 1937 (37 Act).	Coalition of all the associations of retired county employees from the 20 counties with retirement systems formed under The County Employees Retirement Law of 1937 (37 Act).	Coalition of all the associations of retired county employees from the 20 counties with retirement systems formed under The County Employees Retirement Law of 1937 (37 Act).	Coalition of all the association of retired county employees from the 20 counties with retirement systems formed under The County Employees Retirement Law of 1937 (37 Act).	Coalition of all the associations of retired county employees from the 20 counties with retirement systems formed under The County Employees Retirement Law of 1937 (37 Act).	None	All the associations of retired county employees from the 20 counties with retirement systems formed under The County Employees Retirement Law of 1937 (37 Act).	All the associations of retired county employees from the 20 counties with retirement systems formed under The County Employees Retirement Law of 1937 (37 Act).	All the associations of retired county employees from the 20 counties with retirement systems formed under The County Employees Retirement Law of 1937 (37 Act)
descrip_2	Legislation and regulation impacting the California Retired County Employees Association.	Legislation and regulation impacting the California Retired County Employees Association.	Legislation and regulation impacting the California Retired County Employees Association.	Legislation and regulation impacting the California Retired County Employees Association.	Legislation and regulation impacting the California Retired County Employees Association.	None	Legislation and regulations impacting the Calfiornia Retired County Employees Association	Legislation and regulations impacting the county retirees of the 37 Act.	Legislation and regulations impacting the county retirees of the 37 Act.
c_less50	X	X	X	X	X	None	X	X	None
c_more50	None	None	None	None	None	None	None	None	X
ind_class	PUB	PUB	PUB	PUB	PUB	None	PUB	PUB	PUB
ind_descr	None	None	None	None	None	None	None	None	None
bus_class	None	None	None	None	None	None	OTH	None	None
bus_descr	None	None	None	None	None	None	37 Act County Employes	None	None
auth_name	Dunlap Van Vleck and Brown	Dunlap Van Vleck and Brown	Dunlap Van Vleck and Brown	Dunlap Van Vleck and Brown LLC	Dunlap Van Vleck and Brown	Dunlap Van Vleck and Brown LLC	DiMare Van Vleck and Brown LLC	DiMare Van Vleck and Brown LLC	DiMare, Van Vleck & Brown, LLC
auth_city	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento
auth_st	CA	CA	CA	CA	CA	CA	CA	CA	CA
auth_zip4	95814	95814	95814	95814	95814	95814	95814	95814	95814
lobby_int	None	None	None	None	None	None	None	None	None
influen_yn	None	None	None	None	None	None	None	None	None
firm_name	None	None	None	None	None	None	None	None	None
newcert_cb	None	None	None	None	None	None	None	None	None
rencert_cb	None	None	None	None	None	None	None	None	None
complet_dt	None	None	None	None	None	None	None	None	None
lby_reg_cb	None	None	None	None	None	None	None	None	None
lby_604_cb	None	None	None	None	None	None	None	None	None
st_leg_yn	None	None	None	None	None	None	None	None	None
st_agency	None	None	None	None	None	None	None	None	None
lobby_cb	None	None	None	None	None	None	None	None	None
l_firm_cb	None	None	None	None	None	None	None	None	None

Table: filer_address
filer_id	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968
adrid	2116071	2110279	2163050	2207633	2415813	2547712	2276199	2343869	2506626	2472465
effect_dt	2007-01-01 00:00:00	2006-11-01 00:00:00	2009-01-01 00:00:00	2011-01-01 00:00:00	2017-01-01 00:00:00	2023-01-01 00:00:00	2013-01-01 00:00:00	2015-01-01 00:00:00	2021-01-01 00:00:00	2019-01-01 00:00:00
add_type	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051
session_id	2007	2005	2009	2011	2017	2023	2013	2015	2021	2019

Table: filer_filings
filer_id	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968
filing_id	1212165	1220696	1212165	1222591	1212165	1212165	1220797	1255306	1228417	1228417	1241616	1241618	1212165	1302556	1302556	1276080	1292116	1781354	1962145	1976948	1867059	1800594	1935371	1947143	1907197	1325374	1342516	1365013	1389954	1381545	1417334	1412610	1448437	1458070	1431495	1480857	1442550	1500713	1525468	1543355	1558159	1601534	1561630	1588064	1588064	1588064	1634931	1621558	1656624	1677874	1813525	1716606	1708117	1737234	1839822	1752548	1765078	2266334	2429772	2204186	2338382	2151205	2187747	2465110	2008278	1976948	1991425	2107064	2107065	2107066	2116338	2116338	2151205	2139372	2151205	2165263	2389444	2187747	2513208	2266334	2389444	2513208	2187747	2412448	2574907	2309420	2370850	2229112	2334525	2478091	2697624	2594165	2546032	2513208	2574907	2566282	2513208	2639021	2546032	2546032	2664631	2616278	2546032	2513208	2738520
period_id	188	None	188	None	188	188	188	189	188	188	None	None	188	192	192	190	191	214	221	222	218	215	220	None	219	193	194	195	196	196	197	None	199	200	198	201	None	202	203	204	None	206	204	205	205	205	208	207	209	210	216	212	211	212	217	None	213	233	240	232	None	229	231	241	224	222	223	225	226	227	225	228	229	None	229	230	238	231	243	234	238	243	231	239	245	235	237	233	236	242	250	246	244	243	245	None	243	248	244	244	249	247	244	243	251
form_id	F602	F602	F602	F999	F602	F602	F602	F635	F635	F635	F602	F605	F602	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F602	F635	F635	F635	F635	F635	F602	F635	F602	F635	F635	F635	F635	F605	F635	F635	F602	F602	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F602	F635	F635	F635	F602	F635	F635	F635	F635	F602	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F602	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F602	F635	F635	F635	F635	F635	F635	F635	F635	F635
filing_sequence	1	0	2	0	3	4	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	2	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	0	0	1	0	0	0	0	0	1	0	0	1	0	0	2	0	1	1	1	1	0	1	0	0	0	0	0	0	0	2	3	0	0	4	0	3	0	0	0	1	2	0
filing_date	2006-11-01 00:00:00	2006-11-07 00:00:00	2006-11-01 00:00:00	2006-11-28 00:00:00	2006-11-03 00:00:00	2006-11-03 00:00:00	2006-11-07 00:00:00	2007-04-04 00:00:00	2007-01-17 00:00:00	2007-01-17 00:00:00	2006-12-26 00:00:00	2007-01-23 00:00:00	2006-10-26 00:00:00	2008-01-08 00:00:00	2008-01-08 00:00:00	2007-07-03 00:00:00	2007-10-04 00:00:00	2013-07-30 00:00:00	2015-04-26 00:00:00	2015-07-24 00:00:00	2014-07-27 00:00:00	2013-10-31 00:00:00	2015-01-31 00:00:00	2014-12-30 00:00:00	2014-10-28 00:00:00	2008-04-18 00:00:00	2008-07-09 00:00:00	2008-10-09 00:00:00	2009-01-16 00:00:00	2008-11-14 00:00:00	2009-04-14 00:00:00	2008-12-23 00:00:00	2009-10-20 00:00:00	2010-01-15 00:00:00	2009-07-17 00:00:00	2010-04-20 00:00:00	2009-08-13 00:00:00	2010-07-15 00:00:00	2010-10-13 00:00:00	2010-11-08 00:00:00	2010-12-29 00:00:00	2011-07-20 00:00:00	2011-01-19 00:00:00	2011-04-28 00:00:00	2011-04-25 00:00:00	2011-04-28 00:00:00	2012-01-30 00:00:00	2011-10-29 00:00:00	2012-04-29 00:00:00	2012-07-30 00:00:00	2014-01-27 00:00:00	2012-12-09 00:00:00	2012-10-30 00:00:00	2013-01-30 00:00:00	2014-04-21 00:00:00	2012-12-28 00:00:00	2013-04-30 00:00:00	2018-07-18 00:00:00	2020-01-11 00:00:00	2018-01-23 00:00:00	2018-12-31 00:00:00	2017-08-30 00:00:00	2017-10-13 00:00:00	2020-04-07 00:00:00	2016-01-27 00:00:00	2015-10-12 00:00:00	2015-10-12 00:00:00	2016-11-12 00:00:00	2016-11-12 00:00:00	2016-11-12 00:00:00	2017-01-03 00:00:00	2017-03-24 00:00:00	2017-04-14 00:00:00	2017-01-03 00:00:00	2017-05-08 00:00:00	2017-07-03 00:00:00	2019-07-10 00:00:00	2018-01-23 00:00:00	2020-10-12 00:00:00	2018-07-30 00:00:00	2019-10-09 00:00:00	2021-02-08 00:00:00	2018-01-23 00:00:00	2019-10-09 00:00:00	2021-06-29 00:00:00	2018-10-19 00:00:00	2019-04-06 00:00:00	2018-04-07 00:00:00	2019-01-15 00:00:00	2020-07-13 00:00:00	2022-07-12 00:00:00	2021-07-19 00:00:00	2021-08-16 00:00:00	2021-08-16 00:00:00	2021-04-19 00:00:00	2020-12-29 00:00:00	2021-09-29 00:00:00	2022-01-27 00:00:00	2021-09-29 00:00:00	2021-01-22 00:00:00	2022-04-09 00:00:00	2021-10-15 00:00:00	2021-06-29 00:00:00	2021-06-29 00:00:00	2022-10-21 00:00:00
stmnt_type	10002	10005	10002	10005	10002	10002	10001	10001	10001	10002	10005	10005	10001	10001	10002	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10006	10001	10001	10001	10005	10001	10001	10002	10001	10002	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10002	10001	10001	10001	10002	10001	10001	10001	10001	10001	10002	10001	10005	10002	10001	10001	10002	10001	10002	10002	10002	10002	10001	10002	10001	10001	10001	10001	10001	10001	10001	10002	10002	10001	10005	10002	10001	10002	10001	10001	10001	10002	10002	10001
stmnt_status	11003	11001	11003	11001	11003	11003	11003	11001	11001	11001	11001	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	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	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003
session_id	2005	2005	2005	2005	2005	2005	2007	2007	2005	2005	2007	2007	2005	2007	2007	2007	2007	2013	2015	2015	2013	2013	2013	2015	2013	2007	2007	2007	2007	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2011	2011	2011	2009	2011	2011	2011	2011	2011	2011	2011	2013	2013	2011	2011	2013	2013	2013	2017	2019	2017	2019	2017	2017	2019	2015	2015	2015	2015	2015	2015	2015	2015	2017	2017	2017	2017	2019	2017	2019	2017	2019	2019	2017	2019	2021	2017	2019	2017	2017	2019	2021	2021	2019	2019	2021	2021	2019	2021	2019	2019	2021	2021	2019	2019	2021
user_id	*	GPEREZ	*	GPEREZ	*	*	*	LTHIBAUL	LTHIBAUL	LTHIBAUL	SARRIAGA	SARRIAGA	*	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	MPACHECO	YRODRIGU	AGLADNEY	LTHIBAUL	YRODRIGU	JGRISSUM	JGRISSUM	*	JGRISSUM	PBANFORD	MGUERRA	JINGRAM	JGRISSUM	ASAETERN	YRODRIGU	ASAETERN	ASAETERN	*	SARRIAGA	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	YRODRIGU	AGLADNEY	ASAETERN	AGLADNEY	YRODRIGU	ASAETERN	AGLADNEY	AGLADNEY	AGLADNEY	DMCCASTL	AGLADNEY	AGLADNEY	SUSHAKOV	AGLADNEY	AGLADNEY	AGLADNEY	DWALKER	DWALKER	DWALKER	AGLADNEY	AGLADNEY	AGLADNEY	YRODRIGU	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	GTAYLOR	AGLADNEY	GTAYLOR	GTAYLOR	AGLADNEY	GTAYLOR	GTAYLOR	AGLADNEY	GTAYLOR	AGLADNEY	AGLADNEY	VUKSTINA	CAFILER	GTAYLOR	GTAYLOR	GTAYLOR	GTAYLOR	MMERCHANT	GTAYLOR	CHATRIDGE	GTAYLOR	GTAYLOR	CHATRIDGE	CHATRIDGE	GTAYLOR	GTAYLOR	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
fine_audit	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11003	11003	11003	11003	11001	11001	11001	11003	11001	11001	11001	11001	11003	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	11003	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11003
rpt_start	2006-10-26 00:00:00	1900-01-01 00:00:00	2006-10-26 00:00:00	1900-01-01 00:00:00	2006-10-26 00:00:00	2006-10-26 00:00:00	2006-11-07 00:00:00	2007-01-01 00:00:00	2006-10-01 00:00:00	2006-10-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2006-10-24 00:00:00	2007-10-01 00:00:00	2007-10-01 00:00:00	2007-04-01 00:00:00	2007-07-01 00:00:00	2013-04-01 00:00:00	2015-01-01 00:00:00	2015-04-01 00:00:00	2014-04-01 00:00:00	2013-07-01 00:00:00	2014-10-01 00:00:00	1900-01-01 00:00:00	2014-07-01 00:00:00	2008-01-01 00:00:00	2008-04-01 00:00:00	2008-07-01 00:00:00	2008-10-01 00:00:00	2008-11-14 00:00:00	2009-01-01 00:00:00	1900-01-01 00:00:00	2009-07-01 00:00:00	2009-10-01 00:00:00	2009-04-01 00:00:00	2010-01-01 00:00:00	1900-01-01 00:00:00	2010-04-01 00:00:00	2010-07-01 00:00:00	2010-11-08 00:00:00	1900-01-01 00:00:00	2011-04-01 00:00:00	2010-10-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-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	2012-12-09 00:00:00	2012-07-01 00:00:00	2012-10-01 00:00:00	2014-01-01 00:00:00	1900-01-01 00:00:00	2013-01-01 00:00:00	2018-01-01 00:00:00	2019-10-01 00:00:00	2017-10-01 00:00:00	1900-01-01 00:00:00	2017-01-01 00:00:00	2017-07-01 00:00:00	2020-01-01 00:00:00	2015-10-01 00:00:00	2015-04-01 00:00:00	2015-07-01 00:00:00	2016-01-01 00:00:00	2016-04-01 00:00:00	2016-07-01 00:00:00	2016-01-01 00:00:00	2016-10-01 00:00:00	2017-01-01 00:00:00	1900-01-01 00:00:00	2017-01-01 00:00:00	2017-04-01 00:00:00	2019-04-01 00:00:00	2017-07-01 00:00:00	2020-07-01 00:00:00	2018-04-01 00:00:00	2019-04-01 00:00:00	2020-07-01 00:00:00	2017-07-01 00:00:00	2019-07-01 00:00:00	2021-01-01 00:00:00	2018-07-01 00:00:00	2019-01-01 00:00:00	2018-01-01 00:00:00	2018-10-01 00:00:00	2020-04-01 00:00:00	2022-04-01 00:00:00	2021-04-01 00:00:00	2020-10-01 00:00:00	2020-07-01 00:00:00	2021-01-01 00:00:00	1900-01-01 00:00:00	2020-07-01 00:00:00	2021-10-01 00:00:00	2020-10-01 00:00:00	2020-10-01 00:00:00	2022-01-01 00:00:00	2021-07-01 00:00:00	2020-10-01 00:00:00	2020-07-01 00:00:00	2022-07-01 00:00:00
rpt_end	2006-10-26 00:00:00	1900-01-01 00:00:00	2006-10-26 00:00:00	1900-01-01 00:00:00	2006-10-26 00:00:00	2006-10-26 00:00:00	2006-11-07 00:00:00	2007-03-31 00:00:00	2006-12-31 00:00:00	2006-12-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2006-10-24 00:00:00	2007-12-31 00:00:00	2007-12-31 00:00:00	2007-06-30 00:00:00	2007-09-30 00:00:00	2013-06-30 00:00:00	2015-03-31 00:00:00	2015-06-30 00:00:00	2014-06-30 00:00:00	2013-09-30 00:00:00	2014-12-31 00:00:00	1900-01-01 00:00:00	2014-09-30 00:00:00	2008-03-31 00:00:00	2008-06-30 00:00:00	2008-09-30 00:00:00	2008-12-31 00:00:00	2008-11-14 00:00:00	2009-03-31 00:00:00	1900-01-01 00:00:00	2009-09-30 00:00:00	2009-12-31 00:00:00	2009-06-30 00:00:00	2010-03-31 00:00:00	1900-01-01 00:00:00	2010-06-30 00:00:00	2010-09-30 00:00:00	2010-11-08 00:00:00	1900-01-01 00:00:00	2011-06-30 00:00:00	2010-12-31 00:00:00	2011-03-31 00:00:00	2011-03-31 00:00:00	2011-03-31 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	2012-12-09 00:00:00	2012-09-30 00:00:00	2012-12-31 00:00:00	2014-03-31 00:00:00	1900-01-01 00:00:00	2013-03-31 00:00:00	2018-06-30 00:00:00	2019-12-31 00:00:00	2017-12-31 00:00:00	1900-01-01 00:00:00	2017-03-31 00:00:00	2017-09-30 00:00:00	2020-03-31 00:00:00	2015-12-31 00:00:00	2015-06-30 00:00:00	2015-09-30 00:00:00	2016-03-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	2017-03-31 00:00:00	1900-01-01 00:00:00	2017-03-31 00:00:00	2017-06-30 00:00:00	2019-06-30 00:00:00	2017-09-30 00:00:00	2020-09-30 00:00:00	2018-06-30 00:00:00	2019-06-30 00:00:00	2020-09-30 00:00:00	2017-09-30 00:00:00	2019-09-30 00:00:00	2021-03-31 00:00:00	2018-09-30 00:00:00	2019-03-31 00:00:00	2018-03-31 00:00:00	2018-12-31 00:00:00	2020-06-30 00:00:00	2022-06-30 00:00:00	2021-06-30 00:00:00	2020-12-31 00:00:00	2020-09-30 00:00:00	2021-03-31 00:00:00	1900-01-01 00:00:00	2020-09-30 00:00:00	2021-12-31 00:00:00	2020-12-31 00:00:00	2020-12-31 00:00:00	2022-03-31 00:00:00	2021-09-30 00:00:00	2020-12-31 00:00:00	2020-09-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
filing_type	22001	None	22001	None	22001	22001	22001	22006	22006	22006	None	None	22001	22006	22006	22006	22006	22006	22001	22006	22001	22006	22001	None	22001	22006	22006	22006	22006	22001	22006	None	22006	22006	22006	22006	None	22006	22006	22001	None	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	None	22006	22006	22006	22006	None	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	None	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	None	22006	22006	22006	22006	22006	22006	22006	22006	22006

Table: filer_interests
filer_id	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968
session_id	2007	2013	2009	2005	2011	2019	2017	2021	2015	2023
interest_cd	40316	40316	40316	40316	40316	40316	40316	40316	40316	40316
effect_date	2007-01-01 00:00:00	2013-01-01 00:00:00	2009-01-01 00:00:00	2006-11-01 00:00:00	2011-01-01 00:00:00	2019-01-01 00:00:00	2017-01-01 00:00:00	2021-01-01 00:00:00	2015-01-01 00:00:00	2023-01-01 00:00:00

Table: filer_to_filer_type
filer_id	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968
filer_type	1	1	1	1	1	1	1	1	1	1
active	Y	Y	Y	Y	Y	Y	Y	Y	Y	N
race	0	0	None	None	None	None	None	None	None	None
session_id	2005	2007	2013	2011	2009	2019	2015	2021	2017	2023
category	0	0	None	None	None	None	None	None	None	None
category_type	0	0	None	None	None	None	None	None	None	None
sub_category	0	0	None	None	None	None	None	None	None	None
effect_dt	2006-11-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	2019-01-01 00:00:00	2015-01-01 00:00:00	2021-01-01 00:00:00	2017-01-01 00:00:00	2023-01-01 00:00:00
sub_category_type	0	0	None	None	None	None	None	None	None	None
election_type	0	0	None	None	None	None	None	None	None	None
sub_category_a	None	None	None	None	None	None	None	None	None	None
nyq_dt	2006-10-24 00:00:00	2006-10-24 00:00:00	None	None	None	None	None	None	None	None
party_cd	0	0	None	None	None	None	None	None	None	None
county_cd	0	0	None	None	None	None	None	None	None	None
district_cd	0	0	None	None	None	None	None	None	None	None

Table: filer_xref
filer_id		1291968
xref_id		1291968
effect_dt		2006-10-23 00:00:00
migration_source		CLAIMS

Table: filername
xref_filer_id	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968
filer_id	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968	1291968
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
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
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
naml	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION
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
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
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
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
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
city	HUNTINGTON BEACH	HUNTINGTON BEACH	FONTANA	FONTANA	FONTANA	FONTANA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	HUNTINGTON BEACH	HUNTINGTON BEACH	FONTANA	FONTANA	FONTANA	FONTANA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	HUNTINGTON BEACH	HUNTINGTON BEACH	FONTANA	FONTANA	FONTANA	FONTANA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	HUNTINGTON BEACH	HUNTINGTON BEACH	FONTANA	FONTANA	FONTANA	FONTANA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	HUNTINGTON BEACH	HUNTINGTON BEACH	FONTANA	FONTANA	FONTANA	FONTANA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	HUNTINGTON BEACH	HUNTINGTON BEACH	FONTANA	FONTANA	FONTANA	FONTANA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	HUNTINGTON BEACH	HUNTINGTON BEACH	FONTANA	FONTANA	FONTANA	FONTANA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	HUNTINGTON BEACH	HUNTINGTON BEACH	FONTANA	FONTANA	FONTANA	FONTANA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	HUNTINGTON BEACH	HUNTINGTON BEACH	FONTANA	FONTANA	FONTANA	FONTANA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA	HUNTINGTON BEACH	HUNTINGTON BEACH	FONTANA	FONTANA	FONTANA	FONTANA	YUCAIPA	YUCAIPA	YUCAIPA	YUCAIPA
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
zip4	926053266	926053266	92331	92331	92331	92331	92399	92399	92399	92399	926053266	926053266	92331	92331	92331	92331	92399	92399	92399	92399	926053266	926053266	92331	92331	92331	92331	92399	92399	92399	92399	926053266	926053266	92331	92331	92331	92331	92399	92399	92399	92399	926053266	926053266	92331	92331	92331	92331	92399	92399	92399	92399	926053266	926053266	92331	92331	92331	92331	92399	92399	92399	92399	926053266	926053266	92331	92331	92331	92331	92399	92399	92399	92399	926053266	926053266	92331	92331	92331	92331	92399	92399	92399	92399	926053266	926053266	92331	92331	92331	92331	92399	92399	92399	92399	926053266	926053266	92331	92331	92331	92331	92399	92399	92399	92399
phon	7148400553	7148400553	7607870945	7607870945	7607870945	7607870945	7607870945	9097907199	7607870945	7607870945	7148400553	7148400553	7607870945	7607870945	7607870945	7607870945	7607870945	9097907199	7607870945	7607870945	7148400553	7148400553	7607870945	7607870945	7607870945	7607870945	7607870945	9097907199	7607870945	7607870945	7148400553	7148400553	7607870945	7607870945	7607870945	7607870945	7607870945	9097907199	7607870945	7607870945	7148400553	7148400553	7607870945	7607870945	7607870945	7607870945	7607870945	9097907199	7607870945	7607870945	7148400553	7148400553	7607870945	7607870945	7607870945	7607870945	7607870945	9097907199	7607870945	7607870945	7148400553	7148400553	7607870945	7607870945	7607870945	7607870945	7607870945	9097907199	7607870945	7607870945	7148400553	7148400553	7607870945	7607870945	7607870945	7607870945	7607870945	9097907199	7607870945	7607870945	7148400553	7148400553	7607870945	7607870945	7607870945	7607870945	7607870945	9097907199	7607870945	7607870945	7148400553	7148400553	7607870945	7607870945	7607870945	7607870945	7607870945	9097907199	7607870945	7607870945
fax	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
email	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]

Table: filers
filer_id		1291968

Table: lobbying_chg_log
filer_id	1291968	1291968
change_no	0	1
session_id	2005	2005
log_dt	2006-11-20 00:00:00	2006-11-20 00:00:00
filer_type	1	1
correction_flg	None	None
action	ADDED	IN SUSPENSE
attribute_changed	FIRM	FIRM
ethics_dt	None	None
interests	None	None
filer_full_name	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION	CALIFORNIA RETIRED COUNTY EMPLOYEES ASSOCIATION
filer_city	None	None
filer_st	None	None
filer_zip	None	None
filer_phone	None	None
entity_type	3	3
entity_name	DUNLAP, VAN VLECK & BROWN, LLC	DUNLAP, VAN VLECK & BROWN, LLC
entity_city	None	None
entity_st	None	None
entity_zip	None	None
entity_phone	None	None
entity_id	1276403	1276403
responsible_officer	None	None
effect_dt	2006-11-01 00:00:00	2006-11-01 00:00:00

Table: received_filings
filer_id	1291968	1291968	1291968	1291968	1291968	1291968
filing_file_name	62595.cal	1381545_0.cal	1867059_0.cal	1907197_0.cal	1962145_0.cal	1935371_0.cal
received_date	2006-10-26 00:00:00	2008-11-14 00:00:00	2014-07-27 00:00:00	2014-10-28 00:00:00	2015-04-26 00:00:00	2015-01-31 00:00:00
filing_directory	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal
filing_id	None	1381545	1867059	1907197	1962145	1935371
form_id	None	F602	F635	F635	F635	F635
receive_comment	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted