OpenCalAccess

Filer ID: 1231906

Table: cvr_lobby_disclosure
filing_id	746515	769792	788899	811819	835727	852803	881189	926874	926877	941476	961268	985718	1011819	1037145	1056720	1071870	1166177	1132658	1104798	1149149	1123822	1189569	1217121	1262959	1250145	1285043	1311513	1332362	1352209	1297721	1311513	1372753	1418451	1447941	1437794	1395409	1506203	1485867	1462125	1538495	1622187	1602143	1572286	1587472	1636515	1709727	1678779	1658396	1740356	1782729	1765074	1801652	1846376	1846376	1869902	1818918	1911171	1993370	1977801	1968993	2062878	2085392	2032604	2032600	2171288	2153169	2119016	2186961	2301336	2232061	2199626	2269333	2390189	2337672	2379069	2467850	2415163	2438232	2467693	2526494	2482424	2548301	2580495	2597639	2618910	2671474	2638930
amend_id	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
rec_type	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR
form_type	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615
sender_id	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906
filer_id	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906
entity_cd	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM
filer_naml	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER
filer_namf	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M	JULIE M	JULIE M	JULIE M	JULIE M	JULIE M
filer_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
filer_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
report_num	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	001	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	001	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000
rpt_date	2001-04-30 00:00:00	2001-07-24 00:00:00	2001-10-24 00:00:00	2002-01-29 00:00:00	2002-04-16 00:00:00	2002-07-28 00:00:00	2002-10-28 00:00:00	2003-04-10 00:00:00	2003-04-10 00:00:00	2003-07-14 00:00:00	2003-10-02 00:00:00	2004-01-30 00:00:00	2004-04-30 00:00:00	2004-08-12 00:00:00	2004-10-28 00:00:00	2005-01-13 00:00:00	2006-04-28 00:00:00	2005-10-28 00:00:00	2005-04-29 00:00:00	2005-01-31 00:00:00	2005-08-24 00:00:00	2006-07-28 00:00:00	2006-10-31 00:00:00	2007-05-01 00:00:00	2007-03-02 00:00:00	2007-07-31 00:00:00	2008-03-19 00:00:00	2008-05-14 00:00:00	2008-07-31 00:00:00	2007-10-31 00:00:00	2008-01-31 00:00:00	2008-10-27 00:00:00	2009-04-23 00:00:00	2009-10-16 00:00:00	2009-07-31 00:00:00	2009-01-30 00:00:00	2010-07-30 00:00:00	2010-04-30 00:00:00	2010-01-28 00:00:00	2010-10-29 00:00:00	2011-10-31 00:00:00	2011-07-21 00:00:00	2011-01-31 00:00:00	2011-04-21 00:00:00	2012-01-31 00:00:00	2012-10-31 00:00:00	2012-07-31 00:00:00	2012-04-30 00:00:00	2013-01-31 00:00:00	2013-07-31 00:00:00	2013-04-30 00:00:00	2013-10-31 00:00:00	2014-08-01 00:00:00	2014-04-30 00:00:00	2014-07-30 00:00:00	2014-01-31 00:00:00	2014-10-31 00:00:00	2015-10-22 00:00:00	2015-07-27 00:00:00	2015-05-19 00:00:00	2016-07-31 00:00:00	2016-10-04 00:00:00	2016-04-26 00:00:00	2016-04-26 00:00:00	2017-07-25 00:00:00	2017-04-25 00:00:00	2017-01-11 00:00:00	2017-10-09 00:00:00	2018-10-03 00:00:00	2018-04-17 00:00:00	2018-01-02 00:00:00	2018-07-25 00:00:00	2019-07-15 00:00:00	2019-01-22 00:00:00	2019-04-29 00:00:00	2020-04-27 00:00:00	2019-10-24 00:00:00	2020-01-29 00:00:00	2020-04-26 00:00:00	2020-10-29 00:00:00	2020-07-28 00:00:00	2021-01-27 00:00:00	2021-04-30 00:00:00	2021-07-27 00:00:00	2021-10-25 00:00:00	2022-04-27 00:00:00	2022-01-27 00:00:00
from_date	2001-01-01 00:00:00	2001-04-01 00:00:00	2001-07-01 00:00:00	2001-10-01 00:00:00	2002-01-01 00:00:00	2002-04-01 00:00:00	2002-07-01 00:00:00	2002-10-01 00:00:00	2003-01-01 00:00:00	2003-04-01 00:00:00	2003-07-01 00:00:00	2003-10-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	2006-01-01 00:00:00	2005-07-01 00:00:00	2005-01-01 00:00:00	2005-10-01 00:00:00	2005-04-01 00:00:00	2006-04-01 00:00:00	2006-07-01 00:00:00	2007-01-01 00:00:00	2006-10-01 00:00:00	2007-04-01 00:00:00	2007-10-01 00:00:00	2008-01-01 00:00:00	2008-04-01 00:00:00	2007-07-01 00:00:00	2007-10-01 00:00:00	2008-07-01 00:00:00	2009-01-01 00:00:00	2009-07-01 00:00:00	2009-04-01 00:00:00	2008-10-01 00:00:00	2010-04-01 00:00:00	2010-01-01 00:00:00	2009-10-01 00:00:00	2010-07-01 00:00:00	2011-07-01 00:00:00	2011-04-01 00:00:00	2010-10-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-01-01 00:00:00	2013-07-01 00:00:00	2014-01-01 00:00:00	2014-01-01 00:00:00	2014-04-01 00:00:00	2013-10-01 00:00:00	2014-07-01 00:00:00	2015-07-01 00:00:00	2015-04-01 00:00:00	2014-10-01 00:00:00	2016-04-01 00:00:00	2016-07-01 00:00:00	2015-10-01 00:00:00	2016-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	2018-07-01 00:00:00	2018-01-01 00:00:00	2017-10-01 00:00:00	2018-04-01 00:00:00	2019-04-01 00:00:00	2018-10-01 00:00:00	2019-01-01 00:00:00	2020-02-10 00:00:00	2019-07-01 00:00:00	2019-10-01 00:00:00	2020-01-01 00:00:00	2020-07-01 00:00:00	2020-04-01 00:00:00	2020-10-01 00:00:00	2021-01-01 00:00:00	2021-04-01 00:00:00	2021-07-01 00:00:00	2022-01-01 00:00:00	2021-10-01 00:00:00
thru_date	2001-03-31 00:00:00	2001-06-30 00:00:00	2001-09-30 00:00:00	2001-12-31 00:00:00	2002-03-31 00:00:00	2002-06-30 00:00:00	2002-09-30 00:00:00	2002-12-31 00:00:00	2003-03-31 00:00:00	2003-06-30 00:00:00	2003-09-30 00:00:00	2003-12-31 00:00:00	2004-03-31 00:00:00	2004-06-30 00:00:00	2004-09-30 00:00:00	2004-12-31 00:00:00	2006-03-31 00:00:00	2005-09-30 00:00:00	2005-03-31 00:00:00	2005-12-31 00:00:00	2005-06-30 00:00:00	2006-06-30 00:00:00	2006-09-30 00:00:00	2007-03-31 00:00:00	2006-12-31 00:00:00	2007-06-30 00:00:00	2007-12-31 00:00:00	2008-03-31 00:00:00	2008-06-30 00:00:00	2007-09-30 00:00:00	2007-12-31 00:00:00	2008-09-30 00:00:00	2009-03-31 00:00:00	2009-09-30 00:00:00	2009-06-30 00:00:00	2008-12-30 00:00:00	2010-07-31 00:00:00	2010-03-31 00:00:00	2009-12-31 00:00:00	2010-09-30 00:00:00	2011-09-30 00:00:00	2011-06-30 00:00:00	2010-12-31 00:00:00	2011-03-31 00:00:00	2011-12-31 00:00:00	2012-10-31 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-03-13 00:00:00	2013-09-30 00:00:00	2014-03-31 00:00:00	2014-04-30 00:00:00	2014-06-30 00:00:00	2013-12-31 00:00:00	2014-09-30 00:00:00	2015-09-30 00:00:00	2015-06-30 00:00:00	2014-12-31 00:00:00	2016-06-30 00:00:00	2016-09-30 00:00:00	2015-12-31 00:00:00	2016-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	2018-09-30 00:00:00	2018-03-31 00:00:00	2017-12-31 00:00:00	2018-06-30 00:00:00	2019-06-30 00:00:00	2018-12-31 00:00:00	2019-03-31 00:00:00	2020-03-31 00:00:00	2019-09-30 00:00:00	2019-12-31 00:00:00	2020-02-10 00:00:00	2020-09-30 00:00:00	2020-06-30 00:00:00	2020-12-31 00:00:00	2021-03-31 00:00:00	2021-06-30 00:00:00	2021-09-30 00:00:00	2022-03-31 00:00:00	2021-12-31 00:00:00
cum_beg_dt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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_id	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	E24595	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906
firm_name	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Housing California	Equity Advocates	Equity Advocates	Housing California	Equity Advocates	Equity Advocates	Equity Advocates	Equity Advocates	Equity Advocates	Equity Advocates	Equity Advocates	Equity Advocates	Equity Advocates	Equity Advocates	Equity Advocates	Equity Advocates	Equity Advocates	Equity Advocates	Equity Advocates	STEINBERG INSTITUTE	Equity Advocates	Equity Advocates	Equity Advocates	STEINBERG INSTITUTE	01/01/2019	Steinberg Institute	Steinberg Institute	Steinberg Institute	Steinberg Institute	Steinberg Institute	Steinberg Institute
firm_city	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO
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	CA	CA	CA
firm_zip4	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814
firm_phon	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	916-447-0503	9164470503	9164470503	9164470503	9164470503	9164470503	9164470503	9164470503	9164470503	9164470503	9164470503	9164470503	9164470503	9164470503	9164470503	9164470503	9164470503	9164470503	9165015922	9165015922	9164470503	9165015922	9165015922	9165015922	9165015922	9165015922	9165015922	9165015922	9165015922	9165015922	9165015922	9165015922	9165015922	9165015922	9165015922	9165015922	9165534167	9165015922	9165015922	9165534167	9165534167	9165534167	9165534167	9165534167	9165534167	9165534167	9165534167	9165534167
mail_city	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
mail_st				None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
mail_zip4	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
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	None	None	None	None	None
sig_date	2001-04-30 00:00:00	2001-07-25 00:00:00	2001-10-24 00:00:00	2002-01-29 00:00:00	2002-04-16 00:00:00	2002-07-28 00:00:00	2002-10-28 00:00:00	2003-04-10 00:00:00	2003-04-10 00:00:00	2003-07-14 00:00:00	2003-10-15 00:00:00	2004-01-23 00:00:00	2004-04-30 00:00:00	2004-08-12 00:00:00	2004-10-28 00:00:00	2005-01-13 00:00:00	2006-04-28 00:00:00	2005-10-28 00:00:00	2005-04-29 00:00:00	2006-01-31 00:00:00	2005-08-24 00:00:00	2006-07-28 00:00:00	2006-10-31 00:00:00	2007-05-01 00:00:00	2007-03-02 00:00:00	2007-07-31 00:00:00	2008-03-19 00:00:00	2008-05-14 00:00:00	0200-07-31 00:00:00	2007-10-31 00:00:00	2007-01-31 00:00:00	2008-10-27 00:00:00	2009-04-23 00:00:00	2009-10-15 00:00:00	2009-07-31 00:00:00	2009-01-30 00:00:00	2010-07-30 00:00:00	2010-04-30 00:00:00	2010-01-28 00:00:00	2010-10-29 00:00:00	2011-10-31 00:00:00	2011-07-21 00:00:00	2011-01-31 00:00:00	2011-04-21 00:00:00	2012-01-31 00:00:00	2012-10-31 00:00:00	2012-07-31 00:00:00	2012-04-30 00:00:00	2013-01-31 00:00:00	2013-07-31 00:00:00	2013-04-30 00:00:00	2013-10-31 00:00:00	2014-08-01 00:00:00	2014-04-30 00:00:00	2014-07-30 00:00:00	2014-01-31 00:00:00	2014-10-31 00:00:00	2015-10-22 00:00:00	2015-07-27 00:00:00	2015-05-19 00:00:00	2016-07-31 00:00:00	2016-10-04 00:00:00	2016-04-26 00:00:00	2016-04-26 00:00:00	2017-07-25 00:00:00	2017-04-25 00:00:00	2017-01-11 00:00:00	2017-10-09 00:00:00	2018-10-03 00:00:00	2018-04-17 00:00:00	2018-01-02 00:00:00	2018-07-25 00:00:00	2019-07-15 00:00:00	2019-01-22 00:00:00	2019-04-29 00:00:00	2020-04-27 00:00:00	2019-10-24 00:00:00	2020-01-29 00:00:00	2020-04-26 00:00:00	2020-10-23 00:00:00	2020-07-28 00:00:00	2020-01-27 00:00:00	2021-04-30 00:00:00	2021-07-27 00:00:00	2021-10-25 00:00:00	2021-03-28 00:00:00	2022-01-27 00:00:00
sig_loc	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	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	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	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	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, California	Sacramento, CA	Sacramento, CA
sig_naml	Snyder	Snyder	Snyder	Snyder	Snyder	SNYDER	Snyder	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	Snyder	Snyder	SNYDER	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder
sig_namf	Julie	Julie	Julie	Julie	Julie	JULIE	Julie	JULIE M.	JULIE M.	JULIE M.	JULIE	JULIE	JULIE	Julie	Julie	JULIE M.	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie
sig_namt	Ms.	Ms.	Ms.	None	Ms.	None	Ms.	None	None	None	None	None	None	Ms.	Ms.	MS.	None	Ms.	Ms.	None	Ms.	None	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	None	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	Ms.	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder	Snyder
prn_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	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie	Julie
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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None
sig_title	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Policy Director	Policy Director	Policy Director	Policy Director	Policy Director	Policy Director	Policy Director	Policy Director	Policy Director	Policy Director	Policy Director	Policy Director	Policy Director	Policy Director	Policy Director	Policy Director	Policy Director	Principal	Principal	Policy Director	Principal	Principal	Principal	Principal	Principal	Principal	Principal	Principal	Principal/Owner	Principal/Owner	Principal/Owner	Principal/Owner	Principal	Principal/Owner	Owner/principal	Government Relations Director	Principal/Owner	Principal	Principal/Owner	Government Affairs Director	Government Relations Director	Government Affairs Director	Government Affairs Director	Government Affairs Director	Government Affairs Director	Government Affairs Director	Government Affairs Director
nopart1_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	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
nopart2_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	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
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	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	None	None	None
ctrib_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	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
lby_actvty	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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_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	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	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	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	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	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	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	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	None	None	None

Table: cvr_registration
filing_id	1223934	1384716	1553001	1722340	1969654	2115916	2115916	2329504	2329504	2453455	2668734	2635900
amend_id	0	0	0	0	0	0	1	0	1	0	0	0
rec_type	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR
form_type	F604	F604	F604	F604	F604	F604	F604	F604	F604	F606	F606	F604
sender_id	E24595	E24595	E24595	E24595	1377671	1377671	1377671	1377671	1377671	1377671	1376993	1376993
filer_id	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906
entity_cd	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY
filer_naml	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER
filer_namf	JULIE	JULIE	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M	JULIE M
filer_namt	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
report_num	000	000	000	000	000	000	001	000	001	000	000	000
rpt_date	2006-12-19 00:00:00	2008-12-19 00:00:00	2010-12-21 00:00:00	2013-01-02 00:00:00	2015-05-29 00:00:00	2016-12-30 00:00:00	2017-06-22 00:00:00	2018-12-23 00:00:00	2019-04-30 00:00:00	2020-02-17 00:00:00	2022-04-21 00:00:00	2022-01-20 00:00:00
ls_beg_yr	2007	2009	2011	2013	2015	2017	2017	2019	2019	2019	2021	2021
ls_end_yr	2008	2010	2012	2014	2016	2018	2018	2020	2020	2020	2022	2022
qual_date	None	None	None	None	2015-05-28 00:00:00	None	None	None	None	None	None	2021-01-01 00:00:00
eff_date	None	None	None	None	None	None	None	None	None	2020-02-10 00:00:00	2022-03-28 00:00:00	None
bus_city	Sacramento	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO
bus_st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA
bus_zip4	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814
bus_phon	916-447-0503	916-447-0503 x102	9164470503	9164470503	9165015922	9165015922	9165015922	9165015922	9165015922	None	None	9165534167
bus_fax	916-447-1900	916-447-1900	9164471900	9164471900	None	None	None	None	None	None	None	None
bus_email	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]
mail_city	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
mail_zip4	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
sig_date	2006-12-19 00:00:00	2008-12-19 00:00:00	2010-12-21 00:00:00	2013-01-02 00:00:00	2015-05-29 00:00:00	2016-12-30 00:00:00	2017-06-22 00:00:00	2018-12-23 00:00:00	2019-04-30 00:00:00	2020-02-17 00:00:00	2022-04-21 00:00:00	2022-01-20 00:00:00
sig_loc	None	None	None	None	None	None	None	None	None	None	None	None
sig_naml	Snyder	Snyder	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	Snyder	Larsen	SNYDER
sig_namf	Julie	Julie	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	Julie	Karen	JULIE M
sig_namt	Ms.	Ms.	None	None	None	None	None	None	None	None	None	None
sig_nams	None	None	None	None	None	None	None	None	None	None	None	None
prn_naml	None	None	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	Snyder	Larsen	SNYDER
prn_namf	None	None	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	Julie	Karen	JULIE M
prn_namt	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
sig_title	None	None	None	None	None	None	None	None	None	Principal	Chief Executive Officer	None
stmt_firm	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
bus_cb	None	None	None	None	None	None	None	None	None	None	None	None
trade_cb	None	None	None	None	None	None	None	None	None	None	None	None
oth_cb	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
a_b_city	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
a_b_zip4	None	None	None	None	None	None	None	None	None	None	None	None
descrip_1	None	None	None	None	None	None	None	None	None	None	None	None
descrip_2	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
c_more50	None	None	None	None	None	None	None	None	None	None	None	None
ind_class	None	None	None	None	None	None	None	None	None	None	None	None
ind_descr	None	None	None	None	None	None	None	None	None	None	None	None
bus_class	None	None	None	None	None	None	None	None	None	None	None	None
bus_descr	None	None	None	None	None	None	None	None	None	None	None	None
auth_name	None	None	None	None	None	None	None	None	None	None	None	None
auth_city	None	None	None	None	None	None	None	None	None	None	None	None
auth_st	None	None	None	None	None	None	None	None	None	None	None	None
auth_zip4	None	None	None	None	None	None	None	None	None	None	None	None
lobby_int	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
firm_name	HOUSING CALIFORNIA	HOUSING CALIFORNIA	Housing California	Housing California	Equity Advocates	Equity Advocates	Equity Advocates	Equity Advocates	Equity Advocates	Equity Advocates	Steinberg Institute	Steinberg Institute
newcert_cb	None	None	None	None	X	None	None	None	None	None	None	None
rencert_cb	X	X	X	X	None	X	None	X	None	None	None	None
complet_dt	None	None	None	None	None	None	2017-06-22 00:00:00	None	2019-04-11 00:00:00	None	None	2021-05-13 00:00:00
lby_reg_cb	X	X	X	X	X	X	X	X	X	None	None	X
lby_604_cb	None	None	None	None	None	None	None	None	None	None	None	None
st_leg_yn	Y	Y	Y	Y	Y	Y	Y	Y	Y	None	None	Y
st_agency	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
l_firm_cb	None	None	None	None	None	None	None	None	None	None	None	None

Table: filer_address
filer_id	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906
adrid	2011225	2045758	2081475	2115553	2161003	2204435	2411868	2469822	2507883	2282402	2338369	2491360
effect_dt	2001-01-01 00:00:00	2003-01-01 00:00:00	2005-01-01 00:00:00	2007-01-01 00:00:00	2009-01-01 00:00:00	2011-01-01 00:00:00	2017-01-01 00:00:00	2019-01-01 00:00:00	2021-01-01 00:00:00	2013-01-01 00:00:00	2015-05-11 00:00:00	2020-02-10 00:00:00
add_type	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051
session_id	2001	2003	2005	2007	2009	2011	2017	2019	2021	2013	2015	2019

Table: filer_ethics_class
filer_id	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906
session_id	2001	2003	2007	2005	2009	2011	2013	2015	2017	2019	2021
ethics_date	2001-04-20 00:00:00	2003-01-16 00:00:00	2007-04-19 00:00:00	2005-06-17 00:00:00	2009-01-16 00:00:00	2011-02-24 00:00:00	2013-02-28 00:00:00	2015-08-13 00:00:00	2017-06-22 00:00:00	2019-04-11 00:00:00	2021-05-13 00:00:00

Table: filer_filings
filer_id	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906
filing_id	708383	756425	746515	769792	788899	778072	811819	798051	844788	835727	829531	852803	866679	881189	893644	906836	926157	929983	943008	941476	926874	926877	945082	961268	1011819	974478	1001377	985718	1020003	1056720	1037145	1066082	1037800	1071870	1096553	1123822	1104798	1132658	1109905	1149149	1166177	1189569	1217121	1223934	1229377	1250145	1262959	1285043	1265531	1297721	1969801	1969654	1968993	1801652	1782729	1311513	1311513	1332362	1352209	1372753	1384716	1395409	1405898	1405898	1418451	1437794	1447941	1485867	1462125	1506203	1538495	1554899	1579425	1553001	1587472	1572286	1602143	1622187	1636515	1658396	1818918	1678779	1911171	1869902	1846376	1740356	1722340	1709727	1735276	1846376	1765074	1751873	1993370	1977801	1985957	2329504	2383343	2415163	2580495	2379069	2438232	2453226	2453455	2301336	2337672	2032600	2032604	2085392	2062878	2115916	2119016	2125851	2153169	2171288	2164514	2115916	2232061	2361405	2482424	2390189	2329504	2186961	2199626	2269333	2467850	2526494	2597639	2668734	2671474	2467693	2644019	2618910	2646525	2542491	2638930	2548301	2679584	2635900
period_id	None	165	165	166	167	None	168	None	None	169	None	170	None	171	None	None	None	None	None	174	172	173	174	175	177	None	None	176	None	179	178	None	None	180	None	182	181	183	None	184	185	186	187	188	None	188	189	190	None	191	None	222	220	215	214	192	192	193	194	195	196	196	None	None	197	198	199	201	200	202	203	None	None	204	205	204	206	207	208	209	216	210	219	218	217	212	213	211	None	217	213	None	223	222	None	238	None	239	245	237	240	None	241	235	236	225	224	227	226	228	228	None	229	230	None	230	233	None	242	238	236	231	232	234	241	243	246	250	249	241	None	247	None	None	248	244	None	249
form_id	F604	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F604	F615	F615	F604	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F604	F615	F615	F615	F615	F615	F615	F615	F615	F604	F604	F615	F615	F615	F604	F615	F604	F604	F615	F615	F615	F615	F615	F615	F615	F615	F604	F615	F604	F604	F615	F615	F615	F615	F615	F615	F615	F604	F604	F604	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F604	F615	F604	F615	F615	F604	F615	F615	F604	F604	F604	F615	F615	F615	F615	F604	F606	F615	F615	F615	F615	F615	F615	F604	F615	F604	F615	F615	F604	F604	F615	F604	F615	F615	F604	F615	F615	F615	F615	F615	F615	F606	F615	F615	F604	F615	F604	F604	F615	F615	F606	F604
filing_sequence	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	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	1	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	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
filing_date	2001-01-08 00:00:00	2001-04-30 00:00:00	2001-04-30 00:00:00	2001-07-25 00:00:00	2001-10-24 00:00:00	2001-07-30 00:00:00	2002-01-29 00:00:00	2001-11-16 00:00:00	2002-04-30 00:00:00	2002-04-17 00:00:00	2002-01-29 00:00:00	2002-07-28 00:00:00	2002-07-31 00:00:00	2002-10-28 00:00:00	2002-10-29 00:00:00	2003-01-10 00:00:00	2003-03-17 00:00:00	2003-04-15 00:00:00	2003-07-17 00:00:00	2003-07-14 00:00:00	2003-04-10 00:00:00	2003-04-10 00:00:00	2003-07-21 00:00:00	2003-10-02 00:00:00	2004-04-27 00:00:00	2003-10-27 00:00:00	2004-01-29 00:00:00	2004-01-23 00:00:00	2004-04-30 00:00:00	2004-10-28 00:00:00	2004-08-12 00:00:00	2004-10-26 00:00:00	2004-08-16 00:00:00	2005-01-13 00:00:00	2005-02-28 00:00:00	2005-08-24 00:00:00	2005-04-29 00:00:00	2005-10-28 00:00:00	2005-06-09 00:00:00	2006-01-31 00:00:00	2006-04-28 00:00:00	2006-07-28 00:00:00	2006-10-31 00:00:00	2006-12-19 00:00:00	2006-12-28 00:00:00	2007-03-02 00:00:00	2007-05-01 00:00:00	2007-07-31 00:00:00	2007-04-19 00:00:00	2007-10-31 00:00:00	2015-05-28 00:00:00	2015-05-29 00:00:00	2015-05-19 00:00:00	2013-10-31 00:00:00	2013-07-31 00:00:00	2008-03-19 00:00:00	2008-01-31 00:00:00	2008-05-14 00:00:00	2008-07-31 00:00:00	2008-10-27 00:00:00	2008-12-19 00:00:00	2009-01-30 00:00:00	2008-12-29 00:00:00	2009-01-16 00:00:00	2009-04-23 00:00:00	2009-07-31 00:00:00	2009-10-15 00:00:00	2010-04-30 00:00:00	2010-01-28 00:00:00	2010-07-30 00:00:00	2010-10-29 00:00:00	2010-12-27 00:00:00	2011-02-24 00:00:00	2010-12-21 00:00:00	2011-04-21 00:00:00	2011-01-31 00:00:00	2011-07-21 00:00:00	2011-10-31 00:00:00	2012-01-31 00:00:00	2012-04-30 00:00:00	2014-01-31 00:00:00	2012-07-31 00:00:00	2014-10-31 00:00:00	2014-07-30 00:00:00	2014-08-01 00:00:00	2013-01-31 00:00:00	2013-01-02 00:00:00	2012-10-31 00:00:00	2013-01-15 00:00:00	2014-04-30 00:00:00	2013-04-30 00:00:00	2013-02-28 00:00:00	2015-10-22 00:00:00	2015-07-27 00:00:00	2015-08-13 00:00:00	2019-04-30 00:00:00	2019-05-03 00:00:00	2019-10-24 00:00:00	2021-04-30 00:00:00	2019-04-29 00:00:00	2020-01-29 00:00:00	2020-02-07 00:00:00	2020-02-17 00:00:00	2018-10-03 00:00:00	2019-01-22 00:00:00	2016-04-26 00:00:00	2016-04-26 00:00:00	2016-10-04 00:00:00	2016-07-31 00:00:00	2016-12-30 00:00:00	2017-01-11 00:00:00	2016-12-30 00:00:00	2017-04-25 00:00:00	2017-07-25 00:00:00	2017-06-22 00:00:00	2017-06-22 00:00:00	2018-04-17 00:00:00	2018-12-31 00:00:00	2020-07-28 00:00:00	2019-07-15 00:00:00	2018-12-23 00:00:00	2017-10-09 00:00:00	2018-01-02 00:00:00	2018-07-25 00:00:00	2020-04-27 00:00:00	2020-10-29 00:00:00	2021-07-27 00:00:00	2022-04-21 00:00:00	2022-04-27 00:00:00	2020-04-26 00:00:00	2022-01-20 00:00:00	2021-10-25 00:00:00	2022-01-24 00:00:00	2020-12-28 00:00:00	2022-01-27 00:00:00	2021-01-27 00:00:00	2022-04-27 00:00:00	2022-01-20 00:00:00
stmnt_type	10005	10005	10001	10001	10001	10005	10001	10005	10005	10001	10005	10001	10005	10001	10005	10005	10005	10005	10006	10001	10001	10001	10005	10001	10001	10005	10005	10001	10005	10001	10001	10005	10005	10001	10005	10001	10001	10001	10005	10001	10001	10001	10001	10001	10005	10001	10001	10001	10006	10001	10005	10001	10001	10001	10001	10002	10001	10001	10001	10001	10001	10001	10005	10006	10001	10001	10001	10001	10001	10001	10001	10005	10006	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10002	10001	10001	10001	10005	10001	10001	10006	10001	10001	10006	10002	10006	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10006	10002	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10002	10001	10002	10005	10001	10001	10005	10001
stmnt_status	11001	11003	11003	11003	11003	11001	11003	11001	11001	11003	11001	11003	11001	11003	11003	11001	11001	11001	11001	11003	11003	11003	11001	11003	11003	11001	11001	11003	11001	11003	11003	11003	11001	11003	11001	11001	11001	11001	11003	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	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	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
session_id	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2003	2001	2003	2003	2003	2001	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2005	2005	2005	2005	2003	2005	2005	2005	2005	2007	2007	2005	2007	2007	2007	2007	2015	2015	2013	2013	2013	2007	2007	2007	2007	2007	2009	2007	2009	2009	2009	2009	2009	2009	2009	2009	2009	2011	2011	2011	2011	2009	2011	2011	2011	2011	2013	2011	2013	2013	2013	2011	2013	2011	2013	2013	2013	2013	2015	2015	2015	2019	2019	2019	2021	2019	2019	2019	2019	2017	2017	2015	2015	2015	2015	2017	2015	2017	2017	2017	2017	2017	2017	2019	2019	2019	2019	2017	2017	2017	2019	2019	2021	2021	2021	2019	2021	2021	2021	2021	2021	2019	2021	2021
user_id	GPEREZ	TWALLS	*	*	*	LTHIBAUL	*	LTHIBAUL	LTHIBAUL	*	LTHIBAUL	*	LTHIBAUL	*	KVANG	BSMITH	LTHIBAUL	LTHIBAUL	SARRIAGA	COMPLETED	COMPLETED	COMPLETED	LTHIBAUL	COMPLETED	COMPLETED	LTHIBAUL	LTHIBAUL	COMPLETED	LTHIBAUL	COMPLETED	COMPLETED	KLARRY	LTHIBAUL	COMPLETED	SARRIAGA	LTHIBAUL	LTHIBAUL	LTHIBAUL	DHORRELL	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	*	PBANFORD	LTHIBAUL	LTHIBAUL	LTHIBAUL	SARRIAGA	LTHIBAUL	YRODRIGU	YRODRIGU	RGEREMIA	AGLADNEY	ASAETERN	LTHIBAUL	LTHIBAUL	YRODRIGU	LTHIBAUL	JINGRAM	YRODRIGU	JINGRAM	DMCCASTL	DMCCASTL	MGUERRA	MGUERRA	MGUERRA	JINGRAM	MGUERRA	ASAETERN	ASAETERN	CFLAGG	SMCCONNAN	*	JINGRAM	AGLADNEY	ASAETERN	JINGRAM	AGLADNEY	ASAETERN	ASAETERN	AGLADNEY	ASAETERN	AGLADNEY	AGLADNEY	ASAETERN	GKURIMOT	CAFILER	GKURIMOT	AGLADNEY	AGLADNEY	SMCCONNAN	JINGRAM	JINGRAM	PBANFORD	VUKSTINA	VUKSTINA	VUKSTINA	CHARTRIDGE	VUKSTINA	VUKSTINA	AROJAS	CAFILER	JFRONEFIELD	AGLADNEY	AGLADNEY	DWALKER	AGLADNEY	AGLADNEY	CAFILER	AGLADNEY	SARRIAGA	JINGRAM	SMCCONNAN	PBANFORD	PBANFORD	AGLADNEY	GPEREZ	CVANLIEW	VUKSTINA	GPEREZ	SMCCONNAN	AGLADNEY	AGLADNEY	GTAYLOR	MMERCHANT	CHATRIDGE	CVANLIEW	CHATRIDGE	SUSHAKOV	CVANLIEW	CHATRIDGE	CVANLIEW	AROJAS	CHATRIDGE	JRAMOS	CVANLIEW	CVANLIEW
special_audit	11003	11003	11003	11003	11003	11003	11003	11003	11002	11003	11002	11003	11002	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	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	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11001	11001	11001	11001	11003	11003	11001	11003	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	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11001	11001	11001	11001	11001	11001	11003	11001	11003	11001	11001	11001	11001	11001	11003	11001	11001	11003	11001	11001	11001	11001	11001	11001	11003	11001	11001	11003	11001	11003	11003	11001	11001	11003	11003
rpt_start	1900-01-01 00:00:00	2001-01-01 00:00:00	2001-01-01 00:00:00	2001-04-01 00:00:00	2001-07-01 00:00:00	2001-04-01 00:00:00	2001-10-01 00:00:00	2001-07-01 00:00:00	2002-01-01 00:00:00	2002-01-01 00:00:00	2001-10-01 00:00:00	2002-04-01 00:00:00	2002-04-01 00:00:00	2002-07-01 00:00:00	2002-07-01 00:00:00	1900-01-01 00:00:00	2002-10-01 00:00:00	2003-01-01 00:00:00	1900-01-01 00:00:00	2003-04-01 00:00:00	2002-10-01 00:00:00	2003-01-01 00:00:00	2003-04-01 00:00:00	2003-07-01 00:00:00	2004-01-01 00:00:00	2003-07-01 00:00:00	2003-10-01 00:00:00	2003-10-01 00:00:00	2004-01-01 00:00:00	2004-07-01 00:00:00	2004-04-01 00:00:00	2004-07-01 00:00:00	2004-04-01 00:00:00	2004-10-01 00:00:00	1900-01-01 00:00:00	2005-04-01 00:00:00	2005-01-01 00:00:00	2005-07-01 00:00:00	2004-10-01 00:00:00	2005-10-01 00:00:00	2006-01-01 00:00:00	2006-04-01 00:00:00	2006-07-01 00:00:00	2006-12-19 00:00:00	1900-01-01 00:00:00	2006-10-01 00:00:00	2007-01-01 00:00:00	2007-04-01 00:00:00	1900-01-01 00:00:00	2007-07-01 00:00:00	1900-01-01 00:00:00	2015-05-29 00:00:00	2014-10-01 00:00:00	2013-07-01 00:00:00	2013-04-01 00:00:00	2007-10-01 00:00:00	2007-10-01 00:00:00	2008-01-01 00:00:00	2008-04-01 00:00:00	2008-07-01 00:00:00	2008-12-19 00:00:00	2008-10-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2009-01-01 00:00:00	2009-04-01 00:00:00	2009-07-01 00:00:00	2010-01-01 00:00:00	2009-10-01 00:00:00	2010-04-01 00:00:00	2010-07-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2010-12-21 00:00:00	2011-01-01 00:00:00	2010-10-01 00:00:00	2011-04-01 00:00:00	2011-07-01 00:00:00	2011-10-01 00:00:00	2012-01-01 00:00:00	2013-10-01 00:00:00	2012-04-01 00:00:00	2014-07-01 00:00:00	2014-04-01 00:00:00	2014-01-01 00:00:00	2012-10-01 00:00:00	2013-01-02 00:00:00	2012-07-01 00:00:00	1900-01-01 00:00:00	2014-01-01 00:00:00	2013-01-01 00:00:00	1900-01-01 00:00:00	2015-07-01 00:00:00	2015-04-01 00:00:00	1900-01-01 00:00:00	2019-04-30 00:00:00	1900-01-01 00:00:00	2019-07-01 00:00:00	2021-01-01 00:00:00	2019-01-01 00:00:00	2019-10-01 00:00:00	1900-01-01 00:00:00	2020-02-17 00:00:00	2018-07-01 00:00:00	2018-10-01 00:00:00	2016-01-01 00:00:00	2015-10-01 00:00:00	2016-07-01 00:00:00	2016-04-01 00:00:00	2016-12-30 00:00:00	2016-10-01 00:00:00	1900-01-01 00:00:00	2017-01-01 00:00:00	2017-04-01 00:00:00	1900-01-01 00:00:00	2017-06-22 00:00:00	2018-01-01 00:00:00	1900-01-01 00:00:00	2020-04-01 00:00:00	2019-04-01 00:00:00	2018-12-23 00:00:00	2017-07-01 00:00:00	2017-10-01 00:00:00	2018-04-01 00:00:00	2020-02-10 00:00:00	2020-07-01 00:00:00	2021-04-01 00:00:00	2022-04-21 00:00:00	2022-01-01 00:00:00	2020-01-01 00:00:00	1900-01-01 00:00:00	2021-07-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2021-10-01 00:00:00	2020-10-01 00:00:00	1900-01-01 00:00:00	2022-01-20 00:00:00
rpt_end	1900-01-01 00:00:00	2001-03-31 00:00:00	2001-03-31 00:00:00	2001-06-30 00:00:00	2001-09-30 00:00:00	2001-06-30 00:00:00	2001-12-31 00:00:00	2001-09-30 00:00:00	2002-03-31 00:00:00	2002-03-31 00:00:00	2001-12-31 00:00:00	2002-06-30 00:00:00	2002-06-30 00:00:00	2002-09-30 00:00:00	2002-09-30 00:00:00	1900-01-01 00:00:00	2002-12-31 00:00:00	2003-03-31 00:00:00	1900-01-01 00:00:00	2003-06-30 00:00:00	2002-12-31 00:00:00	2003-03-31 00:00:00	2003-06-30 00:00:00	2003-09-30 00:00:00	2004-03-31 00:00:00	2003-09-30 00:00:00	2003-12-31 00:00:00	2003-12-31 00:00:00	2004-03-31 00:00:00	2004-09-30 00:00:00	2004-06-30 00:00:00	2004-09-30 00:00:00	2004-06-30 00:00:00	2004-12-31 00:00:00	1900-01-01 00:00:00	2005-06-30 00:00:00	2005-03-31 00:00:00	2005-09-30 00:00:00	2004-12-31 00:00:00	2005-12-31 00:00:00	2006-03-31 00:00:00	2006-06-30 00:00:00	2006-09-30 00:00:00	2006-12-19 00:00:00	1900-01-01 00:00:00	2006-12-31 00:00:00	2007-03-31 00:00:00	2007-06-30 00:00:00	1900-01-01 00:00:00	2007-09-30 00:00:00	1900-01-01 00:00:00	2015-05-29 00:00:00	2014-12-31 00:00:00	2013-09-30 00:00:00	2013-06-30 00:00:00	2007-12-31 00:00:00	2007-12-31 00:00:00	2008-03-31 00:00:00	2008-06-30 00:00:00	2008-09-30 00:00:00	2008-12-19 00:00:00	2008-12-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2009-03-31 00:00:00	2009-06-30 00:00:00	2009-09-30 00:00:00	2010-03-31 00:00:00	2009-12-31 00:00:00	2010-07-31 00:00:00	2010-09-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2010-12-21 00:00:00	2011-03-31 00:00:00	2010-12-31 00:00:00	2011-06-30 00:00:00	2011-09-30 00:00:00	2011-12-31 00:00:00	2012-03-31 00:00:00	2013-12-31 00:00:00	2012-06-30 00:00:00	2014-09-30 00:00:00	2014-06-30 00:00:00	2014-03-31 00:00:00	2012-12-31 00:00:00	2013-01-02 00:00:00	2012-10-31 00:00:00	1900-01-01 00:00:00	2014-04-30 00:00:00	2013-03-13 00:00:00	1900-01-01 00:00:00	2015-09-30 00:00:00	2015-06-30 00:00:00	1900-01-01 00:00:00	2019-04-30 00:00:00	1900-01-01 00:00:00	2019-09-30 00:00:00	2021-03-31 00:00:00	2019-03-31 00:00:00	2019-12-31 00:00:00	1900-01-01 00:00:00	2020-02-17 00:00:00	2018-09-30 00:00:00	2018-12-31 00:00:00	2016-03-31 00:00:00	2015-12-31 00:00:00	2016-09-30 00:00:00	2016-06-30 00:00:00	2016-12-30 00:00:00	2016-12-31 00:00:00	1900-01-01 00:00:00	2017-03-31 00:00:00	2017-06-30 00:00:00	1900-01-01 00:00:00	2017-06-22 00:00:00	2018-03-31 00:00:00	1900-01-01 00:00:00	2020-06-30 00:00:00	2019-06-30 00:00:00	2018-12-23 00:00:00	2017-09-30 00:00:00	2017-12-31 00:00:00	2018-06-30 00:00:00	2020-03-31 00:00:00	2020-09-30 00:00:00	2021-06-30 00:00:00	2022-04-21 00:00:00	2022-03-31 00:00:00	2020-02-10 00:00:00	1900-01-01 00:00:00	2021-09-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2021-12-31 00:00:00	2020-12-31 00:00:00	1900-01-01 00:00:00	2022-01-20 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	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	22001	22001	22001	None	22001	22001	None	None	22001	None	22001	22001	None	None	22001	None	22001	22001	22001	None	22001	22001	22001	22001	22001	None	22001	22001	22001	None	22001	None	22006	22006	22006	22006	22001	22001	22001	22001	22001	22001	22001	None	None	22001	22001	22001	22001	22001	22001	22001	None	None	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	None	22006	22006	None	22006	22006	None	22006	None	22006	22006	22006	22006	None	22006	22006	22006	22006	22006	22006	22006	22006	22006	None	22006	22006	None	22006	22006	None	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	None	22006	None	None	22006	22006	None	22006

Table: filer_to_filer_type
filer_id	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906
filer_type	4	4	4	4	4	4	4	4	4	4	4	4	4	4
active	Y	Y	Y	Y	Y	Y	Y	Y	Y	R	Y	Y	Y	T
race	0	None	None	None	None	None	None	None	None	None	None	None	None	None
session_id	2001	2003	2005	2007	2011	2013	2009	2015	2021	2015	2015	2019	2017	2021
category	0	None	None	None	None	None	None	None	None	None	None	None	None	None
category_type	0	None	None	None	None	None	None	None	None	None	None	None	None	None
sub_category	0	None	None	None	None	None	None	None	None	None	None	None	None	None
effect_dt	2001-01-01 00:00:00	2003-01-01 00:00:00	2005-01-01 00:00:00	2007-01-01 00:00:00	2011-01-01 00:00:00	2013-01-01 00:00:00	2009-01-01 00:00:00	2015-05-11 00:00:00	2021-01-01 00:00:00	2015-07-01 00:00:00	2015-08-13 00:00:00	2019-01-01 00:00:00	2017-01-01 00:00:00	2022-03-28 00:00:00
sub_category_type	0	None	None	None	None	None	None	None	None	None	None	None	None	None
election_type	0	None	None	None	None	None	None	None	None	None	None	None	None	None
sub_category_a	None	None	None	None	None	None	None	None	None	None	None	None	None	None
nyq_dt	None	None	2001-01-01 00:00:00	2001-01-01 00:00:00	None	None	None	None	None	None	None	None	None	None
party_cd	0	None	None	None	None	None	None	None	None	None	None	None	None	None
county_cd	0	None	None	None	None	None	None	None	None	None	None	None	None	None
district_cd	0	None	None	None	None	None	None	None	None	None	None	None	None	None

Table: filer_xref
filer_id		1231906
xref_id		1231906
effect_dt		2001-01-11 00:00:00
migration_source		CLAIMS

Table: filername
xref_filer_id	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906
filer_id	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906
filer_type	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST
status	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED	TERMINATED
effect_dt	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00	2022-03-28 00:00:00
naml	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER	SNYDER
namf	JULIE M	JULIE M	JULIE M	JULIE M	JULIE M	JULIE M	JULIE M	JULIE M	JULIE M	JULIE M	JULIE M	JULIE M	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.	JULIE M.
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
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
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
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
city	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO
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
zip4	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814
phon	9164470531	9164470531	9164470503	9164470503	9164470503	9164470503	9164470503	9165015922	9165015922	9165015922	9165534167	9165534167	9164470531	9164470531	9164470503	9164470503	9164470503	9164470503	9164470503	9165015922	9165015922	9165015922	9165534167	9165534167	9164470531	9164470531	9164470503	9164470503	9164470503	9164470503	9164470503	9165015922	9165015922	9165015922	9165534167	9165534167	9164470531	9164470531	9164470503	9164470503	9164470503	9164470503	9164470503	9165015922	9165015922	9165015922	9165534167	9165534167	9164470531	9164470531	9164470503	9164470503	9164470503	9164470503	9164470503	9165015922	9165015922	9165015922	9165534167	9165534167	9164470531	9164470531	9164470503	9164470503	9164470503	9164470503	9164470503	9165015922	9165015922	9165015922	9165534167	9165534167	9164470531	9164470531	9164470503	9164470503	9164470503	9164470503	9164470503	9165015922	9165015922	9165015922	9165534167	9165534167	9164470531	9164470531	9164470503	9164470503	9164470503	9164470503	9164470503	9165015922	9165015922	9165015922	9165534167	9165534167	9164470531	9164470531	9164470503	9164470503	9164470503	9164470503	9164470503	9165015922	9165015922	9165015922	9165534167	9165534167	9164470531	9164470531	9164470503	9164470503	9164470503	9164470503	9164470503	9165015922	9165015922	9165015922	9165534167	9165534167	9164470531	9164470531	9164470503	9164470503	9164470503	9164470503	9164470503	9165015922	9165015922	9165015922	9165534167	9165534167
fax	9164470458	9164470458	9164471900	9164471900	9164471900	9164471900	9164471900						9164470458	9164470458	9164471900	9164471900	9164471900	9164471900	9164471900						9164470458	9164470458	9164471900	9164471900	9164471900	9164471900	9164471900						9164470458	9164470458	9164471900	9164471900	9164471900	9164471900	9164471900						9164470458	9164470458	9164471900	9164471900	9164471900	9164471900	9164471900						9164470458	9164470458	9164471900	9164471900	9164471900	9164471900	9164471900						9164470458	9164470458	9164471900	9164471900	9164471900	9164471900	9164471900						9164470458	9164470458	9164471900	9164471900	9164471900	9164471900	9164471900						9164470458	9164470458	9164471900	9164471900	9164471900	9164471900	9164471900						9164470458	9164470458	9164471900	9164471900	9164471900	9164471900	9164471900						9164470458	9164470458	9164471900	9164471900	9164471900	9164471900	9164471900
email	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]

Table: filers
filer_id		1231906

Table: lobbying_chg_log
filer_id	1231906	1231906	1231906	1231906	1231906	1231906
change_no	1	3	4	2	0	5
session_id	2001	2005	2005	2005	2015	2019
log_dt	2001-04-30 00:00:00	2005-02-28 00:00:00	2005-02-28 00:00:00	2005-02-28 00:00:00	2015-05-28 00:00:00	2020-02-26 00:00:00
filer_type	4	4	4	4	4	4
correction_flg	None	None	None	None	Y	None
action	SET ACTIVE	SET ACTIVE	SET ACTIVE	ADDED	ADDED	DELETED
attribute_changed	FIRM	EMPLOYER		None	FIRM	FIRM
ethics_dt	None	None	None	None	None	None
interests	None	None	None	None	None	None
filer_full_name	JULIE M. SNYDER	JULIE M. SNYDER	SNYDER, JULIE M.	SNYDER, JULIE M.	SNYDER, JULIE M.	JULIE M. SNYDER
filer_city	SACRAMENTO	None	None	SACRAMENTO	None	None
filer_st	CA	None	None	CA	None	None
filer_zip	95814	None	None	95814	None	None
filer_phone	9164438891	None	None	9164470531	None	None
entity_type	2	2	4	2	3	3
entity_name	HOUSING CALIFORNIA	HOUSING CALIFORNIA	None	HOUSING CALIFORNIA	EQUITY ADVOCATES	EQUITY ADVOCATES
entity_city	None	None	None	None	None	None
entity_st	None	None	None	None	None	None
entity_zip	None	None	None	None	None	None
entity_phone	None	None	None	None	None	None
entity_id	1147052	1147052	0	None	1377671	1377671
responsible_officer	None	None	None	None	None	None
effect_dt	None	2005-01-01 00:00:00	2005-01-01 00:00:00	2005-02-28 00:00:00	2015-05-11 00:00:00	2020-02-10 00:00:00

Table: received_filings
filer_id	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906	1231906
filing_file_name	746515_0.cal	769792_0.cal	788899_0.cal	811819_0.cal	835727_0.cal	852803_0.cal	881189_0.cal	926874_0.cal	926877_0.cal	941476_0.cal	961268_0.cal	985718_0.cal	1011819_0.cal	1037145_0.cal	1056720_0.cal	1071870_0.cal	1104798_0.cal	1123822_0.cal	1132658_0.cal	1149149_0.cal	1166177_0.cal	1189569_0.cal	1332362_0.cal	1395409_0.cal	1352209_0.cal	1506203_0.cal	1485867_0.cal	1462125_0.cal	1447941_0.cal	1223934_0.cal	189262.cal	189077.cal	189290.cal	188496.cal	189403.cal	1250145_0.cal	1217121_0.cal	313859.cal	313916.cal	1262959_0.cal	1437794_0.cal	1285043_0.cal	1297721_0.cal	1384716_0.cal	1418451_0.cal	1372753_0.cal	1311513_1.cal	1311513_0.cal	1553001_0.cal	1538495_0.cal	1722340_0.cal	1969654_0.cal	2115916_0.cal	2115916_1.cal	2329504_1.cal	2329504_0.cal	2635900_0.cal
received_date	2001-04-30 00:00:00	2001-07-25 00:00:00	2001-10-24 00:00:00	2002-01-29 00:00:00	2002-04-17 00:00:00	2002-07-28 00:00:00	2002-10-28 00:00:00	2003-04-10 00:00:00	2003-04-10 00:00:00	2003-07-14 00:00:00	2003-10-02 00:00:00	2004-01-23 00:00:00	2004-04-27 00:00:00	2004-08-12 00:00:00	2004-10-28 00:00:00	2005-01-13 00:00:00	2005-04-29 00:00:00	2005-08-24 00:00:00	2005-10-28 00:00:00	2006-01-31 00:00:00	2006-04-28 00:00:00	2006-07-28 00:00:00	2008-05-14 00:00:00	2009-01-30 00:00:00	2008-07-31 00:00:00	2010-07-30 00:00:00	2010-04-30 00:00:00	2010-01-28 00:00:00	2009-10-15 00:00:00	2006-12-19 00:00:00	2006-12-19 00:00:00	2006-12-19 00:00:00	2006-12-19 00:00:00	2006-12-19 00:00:00	2006-12-19 00:00:00	2007-03-02 00:00:00	2006-10-31 00:00:00	2007-05-01 00:00:00	2007-05-01 00:00:00	2007-05-01 00:00:00	2009-07-31 00:00:00	2007-07-31 00:00:00	2007-10-31 00:00:00	2008-12-19 00:00:00	2009-04-23 00:00:00	2008-10-27 00:00:00	2008-03-19 00:00:00	2008-01-31 00:00:00	2010-12-21 00:00:00	2010-10-29 00:00:00	2013-01-02 00:00:00	2015-05-29 00:00:00	2016-12-30 00:00:00	2017-06-22 00:00:00	2019-04-30 00:00:00	2018-12-23 00:00:00	2022-01-20 00:00:00
filing_directory	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/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/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	746515	769792	788899	811819	835727	852803	881189	926874	926877	941476	961268	985718	1011819	1037145	1056720	1071870	1104798	1123822	1132658	1149149	1166177	1189569	1332362	1395409	1352209	1506203	1485867	1462125	1447941	1223934	None	None	None	None	None	1250145	1217121	None	None	1262959	1437794	1285043	1297721	1384716	1418451	1372753	1311513	1311513	1553001	1538495	1722340	1969654	2115916	2115916	2329504	2329504	2635900
form_id	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F604	None	None	None	None	None	F615	F615	None	None	F615	F615	F615	F615	F604	F615	F615	F615	F615	F604	F615	F604	F604	F604	F604	F604	F604	F604
receive_comment	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 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 accepted	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted