OpenCalAccess

Filer ID: 1224157

Table: cvr_lobby_disclosure
filing_id	678359	710832	742654	767981	767981	787667	809451	810863	809451	849762	873722	901163	928874	941368	963393	985940	1013298	1023467	1013298	1047829	1076211	1103846	1111664	1164145	1142470	1128202	1187602	1258568	1233218	1280725	1213473	1344564	1326783	1295097	1304376	1373056	1416883	1389619	1447886	1430569	1458394	1506316	1479091	1570373	1479091	1506316	1540160	1618302	1602256	1591483	1633721	1696658	1673747	1653748	1729558	1795818	1775827	1756521	1811410	1901680	1841241	1865774	1927041	1992064	1957344	1974717	1957344	2007060	2088062	2054741	2029601	2171099	2151815	2122913	2187547	2268674	2207178	2235147	2308536	2375485	2342231	2394873	2467945	2413450	2436136	2482935	2525616	2549511	2575341	2597959	2624357	2638274	2737701	2701800	2671302
amend_id	0	0	0	0	1	0	0	0	1	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	1	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
rec_type	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	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	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635
sender_id	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157
filer_id	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157
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	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM
filer_naml	ROSEVILLE CITY OF	ROSEVILLE CITY OF	ROSEVILLE CITY OF	ROSEVILLE CITY OF	ROSEVILLE CITY OF	ROSEVILLE CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF
filer_namf	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
filer_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
filer_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
report_num	000	000	000	000	001	000	000	000	001	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	1	1	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	1	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000
rpt_date	2000-10-27 00:00:00	2001-01-17 00:00:00	2001-04-20 00:00:00	2001-07-17 00:00:00	2001-08-02 00:00:00	2001-10-17 00:00:00	2002-01-23 00:00:00	2002-01-25 00:00:00	2002-04-24 00:00:00	2002-07-15 00:00:00	2002-10-11 00:00:00	2003-01-10 00:00:00	2003-04-24 00:00:00	2003-07-10 00:00:00	2003-10-10 00:00:00	2004-01-23 00:00:00	2004-04-29 00:00:00	2004-07-16 00:00:00	2004-06-04 00:00:00	2004-10-14 00:00:00	2005-01-25 00:00:00	2005-04-28 00:00:00	2005-07-12 00:00:00	2006-04-24 00:00:00	2006-01-18 00:00:00	2005-10-13 00:00:00	2006-07-20 00:00:00	2007-04-18 00:00:00	2007-01-24 00:00:00	2007-07-17 00:00:00	2006-10-18 00:00:00	2008-07-21 00:00:00	2008-04-17 00:00:00	2007-10-22 00:00:00	2008-01-17 00:00:00	2008-10-21 00:00:00	2009-04-09 00:00:00	2009-01-14 00:00:00	2009-10-15 00:00:00	2009-07-14 00:00:00	2010-01-19 00:00:00	2010-07-30 00:00:00	2010-04-12 00:00:00	2011-01-31 00:00:00	2010-11-01 00:00:00	2010-11-01 00:00:00	2010-11-01 00:00:00	2011-10-19 00:00:00	2011-07-22 00:00:00	2011-05-02 00:00:00	2012-01-30 00:00:00	2012-10-10 00:00:00	2012-07-23 00:00:00	2012-04-23 00:00:00	2013-01-22 00:00:00	2013-10-21 00:00:00	2013-07-16 00:00:00	2013-04-15 00:00:00	2014-01-21 00:00:00	2014-10-21 00:00:00	2014-04-24 00:00:00	2014-07-24 00:00:00	2015-01-20 00:00:00	2015-10-15 00:00:00	2015-07-01 00:00:00	2015-07-16 00:00:00	2015-04-10 00:00:00	2016-01-26 00:00:00	2016-10-12 00:00:00	2016-07-13 00:00:00	2016-04-19 00:00:00	2017-07-25 00:00:00	2017-04-19 00:00:00	2017-01-24 00:00:00	2017-10-12 00:00:00	2018-07-24 00:00:00	2018-01-29 00:00:00	2018-04-24 00:00:00	2018-10-18 00:00:00	2019-04-22 00:00:00	2019-01-28 00:00:00	2019-07-29 00:00:00	2020-04-27 00:00:00	2019-10-17 00:00:00	2020-01-27 00:00:00	2020-07-29 00:00:00	2020-10-28 00:00:00	2021-01-28 00:00:00	2021-04-20 00:00:00	2021-07-28 00:00:00	2021-11-01 00:00:00	2022-01-26 00:00:00	2022-10-20 00:00:00	2022-07-27 00:00:00	2022-04-27 00:00:00
from_date	2000-07-01 00:00:00	2000-10-01 00:00:00	2001-01-01 00:00:00	2001-04-01 00:00:00	2001-04-01 00:00:00	2001-07-01 00:00:00	2002-01-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-01-01 00:00:00	2004-07-01 00:00:00	2004-10-01 00:00:00	2005-01-01 00:00:00	2005-04-01 00:00:00	2006-01-01 00:00:00	2005-10-01 00:00:00	2005-07-01 00:00:00	2006-04-01 00:00:00	2007-01-01 00:00:00	2006-10-01 00:00:00	2007-04-01 00:00:00	2006-07-01 00:00:00	2008-04-01 00:00:00	2008-01-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	2008-10-01 00:00:00	2009-07-01 00:00:00	2009-04-01 00:00:00	2009-10-01 00:00:00	2010-04-01 00:00:00	2010-01-01 00:00:00	2010-10-01 00:00:00	2010-01-01 00:00:00	2010-04-01 00:00:00	2010-07-01 00:00:00	2011-07-01 00:00:00	2011-04-01 00:00:00	2011-01-01 00:00:00	2011-10-01 00:00:00	2012-07-01 00:00:00	2012-04-01 00:00:00	2012-01-01 00:00:00	2012-10-01 00:00:00	2013-07-01 00:00:00	2013-04-01 00:00:00	2013-01-01 00:00:00	2013-10-01 00:00:00	2014-07-01 00:00:00	2014-01-01 00:00:00	2014-04-01 00:00:00	2014-10-01 00:00:00	2015-07-01 00:00:00	2015-01-01 00:00:00	2015-04-01 00:00:00	2015-01-01 00:00:00	2015-10-01 00:00:00	2016-07-01 00:00:00	2016-04-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-04-01 00:00:00	2017-10-01 00:00:00	2018-01-01 00:00:00	2018-07-01 00:00:00	2019-01-01 00:00:00	2018-10-01 00:00:00	2019-04-01 00:00:00	2020-01-01 00:00:00	2019-07-01 00:00:00	2019-10-01 00:00:00	2020-04-01 00:00:00	2020-07-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	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	2000-09-30 00:00:00	2000-12-31 00:00:00	2001-03-31 00:00:00	2001-06-30 00:00:00	2001-06-30 00:00:00	2001-09-30 00:00:00	2002-03-31 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-03-31 00:00:00	2004-09-30 00:00:00	2004-12-31 00:00:00	2005-03-31 00:00:00	2005-06-30 00:00:00	2006-03-31 00:00:00	2005-12-31 00:00:00	2005-09-30 00:00:00	2006-06-30 00:00:00	2007-03-31 00:00:00	2006-12-31 00:00:00	2007-06-30 00:00:00	2006-09-30 00:00:00	2008-06-30 00:00:00	2008-03-31 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	2008-12-31 00:00:00	2009-09-30 00:00:00	2009-06-30 00:00:00	2009-12-31 00:00:00	2010-06-30 00:00:00	2010-03-31 00:00:00	2010-12-31 00:00:00	2010-03-31 00:00:00	2010-06-30 00:00:00	2010-09-30 00:00:00	2011-09-30 00:00:00	2011-06-30 00:00:00	2011-03-31 00:00:00	2011-12-31 00:00:00	2012-09-30 00:00:00	2012-06-30 00:00:00	2012-03-31 00:00:00	2012-12-31 00:00:00	2013-09-30 00:00:00	2013-06-30 00:00:00	2013-03-31 00:00:00	2013-12-31 00:00:00	2014-09-30 00:00:00	2014-03-31 00:00:00	2014-06-30 00:00:00	2014-12-31 00:00:00	2015-09-30 00:00:00	2015-03-31 00:00:00	2015-06-30 00:00:00	2015-03-31 00:00:00	2015-12-31 00:00:00	2016-09-30 00:00:00	2016-06-30 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-06-30 00:00:00	2017-12-31 00:00:00	2018-03-31 00:00:00	2018-09-30 00:00:00	2019-03-31 00:00:00	2018-12-31 00:00:00	2019-06-30 00:00:00	2020-03-31 00:00:00	2019-09-30 00:00:00	2019-12-31 00:00:00	2020-06-30 00:00:00	2020-09-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	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	1999-01-01 00:00:00	1999-01-01 00:00:00	2001-01-01 00:00:00	2001-01-01 00:00:00	2001-01-01 00:00:00	2001-01-01 00:00:00	2001-01-01 00:00:00	2001-01-01 00:00:00	2001-01-01 00:00:00	2001-01-01 00:00:00	2001-01-01 00:00:00	2001-01-01 00:00:00	2003-01-01 00:00:00	2003-01-01 00:00:00	2003-01-01 00:00:00	2003-01-01 00:00:00	2003-01-01 00:00:00	2003-01-01 00:00:00	2003-01-01 00:00:00	2003-01-01 00:00:00	2003-01-01 00:00:00	2005-01-01 00:00:00	2005-01-01 00:00:00	2005-01-01 00:00:00	2005-01-01 00:00:00	2005-01-01 00:00:00	2005-01-01 00:00:00	2007-01-01 00:00:00	2005-01-01 00:00:00	2007-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	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	2009-01-01 00:00:00	2009-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2015-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2019-01-01 00:00:00	2017-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00
firm_id	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	None	None	None
firm_name	ROSEVILLE CITY OF	ROSEVILLE CITY OF	ROSEVILLE CITY OF	ROSEVILLE CITY OF	ROSEVILLE CITY OF	ROSEVILLE CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	Roseville, City of	None	None	None
firm_city	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	Roseville	ROSEVILLE	ROSEVILLE	ROSEVILLE
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	CA	CA	CA	CA	CA	CA	CA	CA
firm_zip4	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678
firm_phon	(999) 999-9999	(999) 999-9999	(999) 999-9999	(916) 774-5204	(916) 774-5204	(916) 774-5204	(916) 774-5204	(916) 774-5204	(916) 774-5204	(916) 774-5204	(916) 774-5204	(916) 774-5204	(916) 774-5204	(916) 774-5204	(916) 774-5204	(916) 774-5204	(916) 774-5204	(916) 774-5204	(916) 774-5204	(916) 774-5204	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	(916) 774-5179	9167745179	9167745179	9167745179
mail_city	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
mail_st	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	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	None	None	None	None	None	None	None	None
sig_date	2000-10-27 00:00:00	2000-10-27 00:00:00	2001-04-20 00:00:00	2001-07-17 00:00:00	2001-07-31 00:00:00	2001-10-17 00:00:00	2001-10-17 00:00:00	2002-01-25 00:00:00	2002-04-24 00:00:00	2002-07-15 00:00:00	2002-10-12 00:00:00	2003-01-10 00:00:00	2003-04-24 00:00:00	2003-07-11 00:00:00	2003-10-10 00:00:00	2004-01-11 00:00:00	2004-04-28 00:00:00	2004-07-16 00:00:00	2004-06-03 00:00:00	2004-10-14 00:00:00	2005-01-24 00:00:00	2005-04-27 00:00:00	2005-07-12 00:00:00	2006-04-24 00:00:00	2006-01-18 00:00:00	2005-10-13 00:00:00	2006-07-21 00:00:00	2007-04-16 00:00:00	2007-01-23 00:00:00	2007-07-17 00:00:00	2006-10-18 00:00:00	2008-07-21 00:00:00	2008-04-17 00:00:00	2007-10-22 00:00:00	2008-01-18 00:00:00	2008-10-21 00:00:00	2009-04-09 00:00:00	2009-01-14 00:00:00	2009-10-14 00:00:00	2009-07-14 00:00:00	2010-01-19 00:00:00	2010-07-30 00:00:00	2010-04-09 00:00:00	2011-01-27 00:00:00	2010-11-01 00:00:00	2010-11-01 00:00:00	2010-11-01 00:00:00	2011-10-19 00:00:00	2011-07-22 00:00:00	2011-05-02 00:00:00	2012-01-27 00:00:00	2012-10-10 00:00:00	2012-07-23 00:00:00	2012-04-23 00:00:00	2013-01-22 00:00:00	2013-10-21 00:00:00	2013-07-16 00:00:00	2013-04-15 00:00:00	2014-01-21 00:00:00	2014-10-14 00:00:00	2014-04-24 00:00:00	2014-07-24 00:00:00	2015-01-16 00:00:00	2015-10-15 00:00:00	2015-07-01 00:00:00	2015-07-16 00:00:00	2015-04-10 00:00:00	2016-01-26 00:00:00	2016-10-12 00:00:00	2016-07-11 00:00:00	2016-04-19 00:00:00	2017-07-25 00:00:00	2017-04-19 00:00:00	2017-01-24 00:00:00	2017-10-12 00:00:00	2018-07-24 00:00:00	2018-01-29 00:00:00	2018-04-24 00:00:00	2018-10-18 00:00:00	2019-04-22 00:00:00	2019-01-28 00:00:00	2019-07-29 00:00:00	2020-04-27 00:00:00	2019-10-17 00:00:00	2020-01-27 00:00:00	2020-07-29 00:00:00	2020-10-28 00:00:00	2021-01-28 00:00:00	2021-04-20 00:00:00	2021-07-28 00:00:00	2021-11-01 00:00:00	2022-01-26 00:00:00	2022-10-20 00:00:00	2022-07-27 00:00:00	2022-04-27 00:00:00
sig_loc	Roseville California	Roseville California	Roseville California	Roseville California	Roseville California	Roseville California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, California	Roseville, CA	Roseville, CA	Roseville, CA
sig_naml	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Powell	Powell	Powell	Powell	Powell	Powell	Powell	None	None	None	Powell	Powell	Powell	Powell	Powell	Powell	Powell	Powell	Powell	Powell	Powell	Wolinski	Powell	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski
sig_namf	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	None	None	None	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	Mark	Ellen	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mr. Mark
sig_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	None	None	None	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Mr.	Ms.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	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	None	None	None	None	None	None	None	None	None	None	None
prn_naml	Philpott	Philpott	Philpott	Whitcomb	Whitcomb	Whitcomb	Whitcomb	Whitcomb	Whitcomb	Whitcomb	Whitcomb	Whitcomb	Powell	Powell	Powell	Powell	Powell	Powell	Powell	Powell	Powell	Powell	Powell	Powell	Powell	Powell	Powell	Powell	Powell	Powell	Powell	Powell	Powell	Powell	Powell	Powell	Powell	Powell	Powell	Powell	Powell	Wolinski	Powell	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski	Wolinski
prn_namf	Vicki K.	Vicki K.	Vicki K.	Stephanie	Stephanie	Stephanie	Stephanie	Stephanie	Stephanie	Stephanie	Stephanie	Stephanie	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	Ellen	Mark	Ellen	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mark	Mr. Mark
prn_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Mr.	Ms.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	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	None	None	None	None	None	None	None	None
sig_title	Administrative Assistant	Administrative Assistant	Administrative Assistant	Administrative Assistant	Administrative Assistant	Administrative Assistant	Administrative Assistant	Administrative Assistant	Administrative Assistant	Administrative Assistant	Administrative Assistant	Administrative Assistant	Legislative Analyst	Legislative Analyst	Legislative Analyst	Legislative Analyst	Government Relations Manager	Government Relations Manager	Government Relations Manager	Government Relations Manager	Government Relations Manager	Government Relations Manager	Government Relations Manager	Government Relations Manager	Government Relations Manager	Government Relations Manager	Government Relations Manager	Government Relations Manager	Government Relations Manager	Government Relations Manager	Government Relations Manager	Government Relations Manager	Government Relations Manager	Government Relations Manager	Government Relations Manager	Government Relations Manager	Government Relations Manager	Government Relations Manager	Government Relations Manager	Government Relations Manager	Government Relations Manager	Government Relations Manager	Government Relations Manager	Government Relations Manager	Government Relations Manager	Government Relations Manager	Government Relations Manager	Government Relations Analyst	Government Relations Analyst	Government Relations Manager	Government Relations Analyst	Government Relations Analyst	Government Relations Analyst	Government Relations Analyst	Government Relations Analyst	Government Relations Analyst	Government Relations Analyst	Government Relations Analyst	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator	Government Relations Administrator
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	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	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	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	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	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
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	None	None	None	None	None	None	None	None
lby_actvty	SB 739 SB 1874 SB 1491	No activity this quarter	AB 1015	AB 680 AB 1015 SB 27 SB 910	AB 680 AB 1015 SB 27 SB 910	AB 81 AB 680 SB 910	None	AB 680	AB 81, AB 680	AB 81, AB 425, AB 680, AB 1777, AB 2878, SB 910	AB 425, AB 498, AB 680, AB 713, AB 1243, AB 1314, AB 2436, AB 2843, AB 2936, SB 905, SB 910, SB 1828	Issues relating to the budget Issues relating to fiscal reform	AB 4x, issues relating to the State budget, and issues relating to redevelopment agencies	AB 136, AB 816, AB 980, AB 1160, AB 1192, AB 1221, AB 1426, SB 744 and issues relating to the state budget	AB 218, AB 274, AB 296, AB 421, AB 980, AB 1192, AB 1362, AB 1426, AB 1755, AB 1765, AB 1766, SB 178, SB 566, SB 1045, and budget item #9210-101-0001, and issues relating to the state budget	SB 1-5x, AB 3-5x, AB 7-5x	Issue relating to Section 97.68 of the Revenue and Taxation Code, SB 744, and SB 438	SB 1702, SB 744, AB 426, AB 3105, ACA 30, AB 2499, SB 1478, SB 1592, SB 1212, AB 2702, SB 1592, AB 2372, AB 2406, AB 2690, AB 3007, SB 438, SB 1212	Issue relating to Section 97.68 of the Revenue and Taxation Code, SB 744, and SB 438	SB 1609, AB 2702, SCA 9, SB 438, AB 1510, AB 1426, AB 466, AB 2406, AB 421, AB 426, AB 3036, SB 438, SB 1478, SB 1818	Issue relating to 2005 Budget regarding booking fees	SB 593, SB 773	AB 371, 1168, 1221 SB 593, 773, 926, 77	AB 148, AB 149,AB 150,AB 152,AB 1783,AB 1831,AB 1833,AB 1836,AB 1838,AB 1839, ACA 4, ACA 13, AB 2922, ACR 124 SB 81, SB 82, SB 83, SB 84, SB 85, SB 371, SB 1163, SB 1164, SB 1165,SB 926. SB 1554, SB 1206	No activity this quarter	AB 178, AB 371, AB 1168, AB 1221, AB 1162, ACA 22 SB 593, SB 773, SB 926, SB 77, SB 135, SCA 15	AB 2922 , AB 2987, ACR 124, AB 1800 SB 1206, SB 1322, SB 1330, SB 1432, SB 1554, SB 1627, SB 1812	AB 120, AB 412, AB 575, AB655, AB 669, AB 784, AB 901, AB 995, AB 1170, AB 1227, AB 1350, AB 1351, AB 1672 SB 9, SB 19, SB 45, SB 47,SB 54 SB 262, SB 286, SB 307, SB 395, SB 716, SB 745, SB 748, SB 286, SB 303	Dept. of Water Resources: Infrastructure Bond	AB 120, AB 414, AB 1193, AB 1260, AB 1496, AB 1535 SB 77, SB 286, SB 303, SB 395, SB 717, SB 966, SB 980, SB 964, SB 1016, SCA 12	AB 2511, AB 2987 SB 1, SB 53, SB 1206, SB 1210, SB 1322, SB 1432, SB 1627	AB 628, AB 642, AB 1496, AB 2280, AB 2295, AB 2364, AB 2986, AB 1252, AB 1496, AB 2280 SB 303, SB 375, SB 1016, SB 1499, SB 1627, SB 1672	AB 628, AB 1770 SB 286, SB 1067, SB 1627, SB 1672	AB 70, AB 156, AB 162, AB 193, AB 196, AB 414, AB 701, AB 1252, AB 1351, AB 1260, AB 1496 SB 5, SB 17, SB 77, SB 78, SB 286, SB 303, SB 375, SB 619, , SB 748, SB 964, SB 966, SB 980, SCA 12	AB 414, AB 901, AB 1260, SB 9, SB 717, SB 964, SB 966	AB 628, AB 642, AB 1496, AB 2270, AB 2280, AB 2295, AB 2716, AB 2986, AB 88, AB 1781 SB 286, SB 303, SB 375, SB 619, SB 980, SB 1016, SB 1499, SB 1627, SB 1672	AB 155 SB 1xxx	AB 2x,3x,4x,5x,6x,7x,8x,9x,10x,11x,12x,13x SB 2x,3x,4x,5x,6x,7x,8x,9x,10x,11x,12x	AB 64, AB 155, AB 286, AB 474, AB 576, AB 720, AB 1004 SB 14, SB 67, SB 88, SB 93, SB 402, SB 486, SB 802	SB 16xxx, SB 17xxx, SB 18xxx AB 128, AB 155, AB 474, AB 1004 SCA 18	AB 64, AB 286, AB 474, AB 576 SB 14, SB 93, SB 115, SB 402, SB 486, SB 802, SB 1x3	AB 155, AB 602, AB 1609 SB 346, SB 918, SB 625, SB 949	AB 128, AB 1004, AB 1609, AB 6 (8X) SB 874	AB 23, 1614, 1630, 1623 SB 31, 854, 870, 863, 848, 866	See attached TEXT	Joe A. Gonsalves & Son: AB 155, AB 602, AB 1609, SB 346, SB 918, SB 625, SB 949 Fernandez Government Solutions LLC: AB's: 300,815,1253,1774,1834,1975,2063,2092,2202,2277,2304,2336,2376, 2776 SB's: 476,565,918,991,1173,1478	Joe A. Gonsalves & Son: AB 155, AB 192, AB 194, AB 602, AB 827, AB 1955, AB 2531, AB 2064, SB 194, SB 346, SB 501, SB 870, SB 918 Fernandez Government Solutions LLC: AB's: 300,815,1253,1265,1677,1834,1975,2063,2092,2202,2304,2376,2409, 2669,2776 SB's: 565,918,991,1023,1173,1478	AB 92, AB 246, AB 438, AB 506, AB 710, AB 1220, AB 1344, AB 1391, AB X1 26, AB X1 27 SB 68, SB 450, SBX1 8 Fernandez Government Solutions - AB 23, AB 54, AB 134, AB 275, AB 359, AB 380, AB 403, AB 685, AB 741, AB 849, AB 938, AB 964, AB 983, AB 1152, AB 1194, AB 1221, SB 215, SB 224, SB 235, SB 250, SB 263, SB 267, SB 607, SB 744, SB 834, SB 846, SB 900, SB 918	See attached TEXT	AB 101 SB 77, SB 515, SB 670	AB 26x, AB 27x, SB 89 Fernandez Government Solutions AB 54, AB 134, AB 275, AB 359, AB 763, AB 849, AB 938, AB 964, AB 983, AB 1152, AB 1194, AB 1221, SB 200, SB 224, SB 250, SB 263, SB 267, SB 834	See attached TEXT	See attached TEXT	AB 1463, AB 1555, AB 1585, SB 654, SB 659, SB 964, SB 965, SB 973, SB 986, SB 1010, SB 1439	AB 119, AB 26x, SB 1, SB 89	AB 145, AB 300, AB 325, AB 562, AB 564, AB 1222, AB 1229, AB 1235, SB 7, SB 211, SB 443, SB 556, SB 594, SB 649, SB 684, SB 731 Fernandez Government Solutions, LLC - AB 7, AB 21, AB 30, AB 69, AB 115, AB 118, AB 119, AB 240, AB 426, AB 527, AB 763, AB 803, AB 850, AB 909, AB 1200, AB 1330, AB 1331, AB 1393, SB 4, SB 42, SB 135, SB 184, SB 436, SB 591, SB 620, SB 731, SB 749, SB 753	See attached TEXT	See attached TEXT	AB 325, AB 564, AB 1222, AB 1229, AB 1331, SB 211, SB 649, SB 7, SB 556, SB 594, SB 684 Fernandez Government Solutions, LLC - No bills lobbied in the 4th quarter.	See attached TEXT	See attached TEXT	See attached TEXT	Fernandez Government Solutions, L.L.C. - AB 194, AB 739, AB 1043, AB 1249, AB 1330, AB 1471, AB 1527, AB 1707, AB 1739, AB 2067, AB 2071, AB 2100, AB 2104, AB 2259, AB 2282, AB 2312, AB 2442, AB 2443, AB 2446, AB 2451, AB 2453, AB 2471, AB 2516, AB 2636, SB 757, SB 936, SB 985, SB 988, SB 1036, SB 1120, SB 1168, SB 1292, SB 1319, SB 1420	See attached TEXT	AB 26, AB 34, AB 45, AB 46, AB 88, AB 103, AB 266, AB 401, AB 504, AB 645, AB 945, AB 1063, AB 1377, SB 8, SB 69, SB 350, RN#15-09465 (Governor's Budget Proposal Affecting Redevelopment Dissolution) Fernandez Government Solutions, LLC, AB 149, AB 291, AB 349, AB 453, AB 606, AB 647, AB 1242, AB 1362, SB 144, SB173, SB 228, SB 385, SB 487, SB 553.	See attached TEXT	AB 26, AB 34, AB 45, AB 46, AB 88, AB 103, AB 266, AB 401, AB 504, AB 645, AB 945, AB 1063, AB 1377, SB 8, SB 69, SB 350, RN#15-09465 (Governor's Budget Proposal Affecting Redevelopment Dissolution) Fernandez Government Solutions, LLC, AB 149, AB 291, AB 349, AB 453, AB 606, AB 647, AB 1242, AB 1362, SB 144, SB173, SB 228, SB 385, SB 487, SB 553.	AB 35, AB 57, AB 315, AB 606, AB 802, SB 107, SB 272, SB 350, SB 533, SB 555 Fernandez Government Solutions, LLC AB 149, AB 291, AB 349, AB 401, AB 453, AB 585, AB 603, AB 606, AB 617, AB 647, AB 935, AB 937, AB 938, AB 1139, AB 1201, AB 1242, AB 1376, AB 1390, SB 7, SB 13, SB 20, SB 144, SB 208, SB 226, SB 385, SB 555, SB 664, SB 789	See attached TEXT	See attached TEXT	Fernandez Government Solutions, LLC: AB 453, AB 647, AB 935, AB 937, AB 1201, AB 1242, AB 1362, AB 1555, AB 1588, AB 1589, AB 1590, AB 1647, AB 1649, AB 1755, AB 1882, AB 1925, AB 1989, AB 2040, AB 2099, AB 2304, AB 2480, AB 2525, AB 2550, AB 2551, AB 2601, ACA 8, SB 7, SB 20, SB 163, SB 552, SB 554, SB 814, SB 919, SB 1233, SB 1262, SB 1264, SB 1294, SB 1317, SB 1318, SB 1340, SB 1440	Fernandez Government Solutions, LLC. AB 247, 746, 869, 885, 968, 975, 1323, 1427, 1654, 1667, 1668, 1669, SB 5, 427, 473, 580, 623, 778, 780	AB 1, 18, 28, 96, 199,278, SB 1, 3, 5, 72, 649 Fernandez Government Solutions, LLC; AB 18, AB 968, AB 975, AB 1654, AB 1667, AB 1668, AB 1669, SB 5, SB 427, SB 580, SWRCB Emergency Urban Water Conservation Regulations, DWR SB 555 Water Loss Regulations	See attached TEXT	Fernandez Government Solutions, LLC, AB 247, 313, 746, 869, 885, 968, 975, 1323, 1427, 1654, 1667, 1668, 1669, SB 5, 427, 580, 606, 623.	AB 813, 1654, 1668, 1836, 1912, 2596, SB 64, 827,840, 998,1110, 1302 Fernandez Government Solutions, LLC. AB 2050, 2283, 2371, 2649, 3170, 3206, SB 623, 831, 966, 998, Safe and Affordable Drinking Water Fund budget trailer bill	Fernandez Government Solutions, LLC, AB 313, AB 746, SB 5, SB 427 and SB 580.	AB 1806-Budget SB 839-Budget AB 813, 1912 SB 827, 1110 Fernandez Government Solutions, LLC, AB 1668, 1989, 2050, 2241, 2242, 2266, 2283, 2370, 2371, 2649, 3170, 3206, SB 606, 623, 831, 966, 998, bSafe and Affordable Drinking Water Fundb budget trailer bill.	AB 726, 813, 893, 1654, 1667, 1836, 1912, 2596, 2598, 2681, 2923, 3162 SB 664, 212, 623, 845, 998, 1110, 1333, 1302, 1440 State Bureau of Cannabis Control Re: Draft Regulation 5416; Fernandez Government Solutions, LLC. AB 1577, 2050, 2283, 2371, 2649, 3170, 3206, SB 623, 831, 844, 845, 966, 998.	Legislature & Administration Re: All matters related to Transportation and Housing AB 147, 190, 213, 510, 533, 1413 SB 50, 72, 414, 669	No reportable activity this quarter.	AB 74, 147, 213, 217, 533, 1413, 1509, 1672, SB 5, 134, 329, 332, 414, 669	AB 1484, 1672, 1917 SB 808, 848 SB 50, 902 SB 795, 1179	AB 139, 213, 1110, 1413, 1509 SB 5, 134, 266, 329, 414, 744	AB 849, 857, 1110, 1413, 1819, SB 5, 6, 50, 209, 235, 329, 330, 520, 676, 1484	AB 89, 90, 100, 899, 902, 1672 SB 74, 902, 995, 1085, 1120, 1385 Governorbs Office, Legislature, and Administration Re: 2020-21 Budget Funding, COVID-19 Response and Homeless Allocations.	AB 685, 1672 SB 902, 1120, 1383 Governors Office, Legislature, and Administration Re: COVID-19 Response, CARES Act Funding, Housing & Zoning Legislation, and Homeless Allocations.	Governors Office, Legislature, and Administration Re: COVID-19 Response, CARES Act Funding, Housing & Zoning Legislation, and Homeless Allocations.	See attached TEXT	See attached TEXT	See attached TEXT	Legislature & Administration Re: Housing & Community Development, Covid-19 Policies, and local funding.	Governor's Office, Legislature, and Administration Re: 2022-23 Budget Funding, Housing & Community Development, and Local Funding. AB 179, 1711, 1886, 2011, 2108, 2142, 2247, 2440 SB 6, 222, 379, 1127, 1157, 1158, 1215	Governor?s Office, Legislature, and Administration Re: 2022-23 Budget Funding, Vitality of Cities, Housing & Community Development, Local and Library Grant Funding. AB 178, 180, 1711, 2142,2247, 2440, 2878, SB 178, 180, 222, 379, 1157	Legislature & Administration Re: Housing & Community Development, Covid-19 Policies, and local funding. Governor Newsom?s Real Public Safety Plan Governor Newsom?s CARE Court. COVID-19 Supplemental Paid Sick Leave AB 2142 SB 379, 792
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	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	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	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	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	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	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	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	None	None	None	None	None	None	None	None

Table: cvr_registration
filing_id	1071629	1225987	1386544	1541489	1555366	1557696	1716658	1723251	1921876	1923880	2114568	2117095	2329908	2540975
amend_id	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
form_type	F602	F602	F602	F602	F602	F602	F602	F602	F602	F602	F602	F602	F602	F602
sender_id	F00462	F00462	F00462	1282555	F00462	1282555	F00462	1282555	F00462	1282555	F00462	1282555	F00462	F00462
filer_id	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157
entity_cd	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM
filer_naml	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	Roseville, City of	ROSEVILLE, CITY OF	Roseville, City of	ROSEVILLE, CITY OF	Roseville, City of	ROSEVILLE, CITY OF	Roseville, City of	Roseville, City of
filer_namf	None	None	None	None	None	None	None	None	None	None	None	None	None	None
filer_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None
filer_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None
report_num	000	000	000	000	000	000	000	000	000	000	000	000	000	000
rpt_date	2005-01-13 00:00:00	2007-01-02 00:00:00	2008-12-30 00:00:00	2010-08-20 00:00:00	2010-12-29 00:00:00	2010-12-31 00:00:00	2012-12-10 00:00:00	2012-12-31 00:00:00	2014-12-30 00:00:00	2014-12-31 00:00:00	2016-12-28 00:00:00	2016-12-31 00:00:00	2018-12-27 00:00:00	2020-12-30 00:00:00
ls_beg_yr	2005	2007	2009	2009	2011	2011	2013	2013	2015	2015	2017	2017	2019	2021
ls_end_yr	2006	2008	2010	2010	2012	2012	2014	2014	2016	2016	2018	2018	2020	2022
qual_date	None	None	None	None	None	None	None	None	None	None	None	None	None	None
eff_date	2005-01-01 00:00:00	2007-01-01 00:00:00	2009-01-01 00:00:00	2010-01-27 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	2015-01-01 00:00:00	2015-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2019-01-01 00:00:00	2021-01-01 00:00:00
bus_city	Roseville	Roseville	Roseville	LROSEVILLE	Roseville	ROSEVILLE	Roseville	ROSEVILLE	Roseville	ROSEVILLE	Roseville	ROSEVILLE	Roseville	Roseville
bus_st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA
bus_zip4	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678
bus_phon	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5353	(916) 774-5179	(916) 774-5353	(916) 774-5179	(916) 774-5353	(916) 774-5179	(916) 774-5353	(916) 774-5179	(916) 774-5179
bus_fax	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bus_email	None	None	None	None	None	None	None	None	None	None	None	None	None	None
mail_city	None	None	None	None	None	None	None	None	None	None	None	None	None	None
mail_st	None	None	None	None	None	None	None	None	None	None	None	None	None	None
mail_zip4	None	None	None	None	None	None	None	None	None	None	None	None	None	None
mail_phon	None	None	None	None	None	None	None	None	None	None	None	None	None	None
sig_date	2004-12-20 00:00:00	2006-11-28 00:00:00	2008-11-19 00:00:00	2010-08-18 00:00:00	2010-11-04 00:00:00	2010-11-23 00:00:00	2012-11-26 00:00:00	2012-11-19 00:00:00	2014-11-20 00:00:00	2014-12-02 00:00:00	2016-11-02 00:00:00	2016-12-12 00:00:00	2018-12-27 00:00:00	2020-12-30 00:00:00
sig_loc	Roseville, California	Roseville, California	Roseville, California	None	Roseville, California	None	Roseville, California	None	Roseville, California	ROSEVILLE, CA	Roseville, California	ROSEVILLE, CA	Roseville, California	Roseville, California
sig_naml	Powell	None	Powell	POWELL	Wolinski	WOLINSKI	Wolinski	WOLINSKI	Wolinski	WOLINSKI	Wolinski	WOLINSKI	Wolinski	Wolinski
sig_namf	Ellen	None	Ellen	ELLEN	Mark	MARK	Mark	MARK	Mark	MARK	Mark	MARK	Mark	Mark
sig_namt	Ms.	None	Ms.	None	Mr.	None	Mr.	None	Mr.	None	Mr.	None	Mr.	Mr.
sig_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None
prn_naml	Powell	Powell	Powell	POWELL	Wolinski	WOLINSKI	Wolinski	WOLINSKI	Wolinski	WOLINSKI	Wolinski	WOLINSKI	Wolinski	Wolinski
prn_namf	Ellen	Ellen	Ellen	ELLEN	Mark	MARK	Mark	MARK	Mark	MARK	Mark	MARK	Mark	Mark
prn_namt	Ms.	Ms.	Ms.	None	Mr.	None	Mr.	None	Mr.	None	Mr.	None	Mr.	Mr.
prn_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None
sig_title	Government Relations Manager	Government Relations Manager	Government Relations Manager	GOV'T RELATIONS MANAGER (444600-MM)	Government Relations Manager	GOV'T RELATIONS MANAGER (444600-MM)	Government Relations Analyst	GOV'T RELATIONS MANAGER (444600-MM)	Government Relations Administrator	GOV'T RELATIONS MANAGER (444600-MM)	Government Relations Administrator	GOV'T RELATIONS MANAGER (444600-MM)	Government Relations Administrator	Government Relations Administrator
stmt_firm	None	None	None	None	None	None	None	None	None	None	None	None	None	None
ind_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bus_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None
trade_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None
oth_cb	X	X	X	X	X	X	X	X	X	X	X	X	X	X
a_b_name	None	None	None	None	None	None	None	None	None	None	None	None	None	None
a_b_city	None	None	None	None	None	None	None	None	None	None	None	None	None	None
a_b_st	None	None	None	None	None	None	None	None	None	None	None	None	None	None
a_b_zip4	None	None	None	None	None	None	None	None	None	None	None	None	None	None
descrip_1	Local government - Serving the best interests of the citizens of the city of Roseville.	Local government - Serving the best interests of the citizens of the city of Roseville.	Local government - Serving the best interests of the citizens of the city of Roseville.	LOCAL GOVERNMENT	Local government - Serving the best interests of the citizens of the city of Roseville.	LOCAL GOVERNMENT	Local government - serving the best interests of the citizens of the City of Roseville.	LOCAL GOVERNMENT	Local government - serving the best interests of the citizens of the City of Roseville.	LOCAL GOVERNMENT	Local government - serving the best interests of the citizens of the City of Roseville.	LOCAL GOVERNMENT	Local government - serving the best interests of the citizens of the City of Roseville.	Local government - serving the best interests of the citizens of the City of Roseville.
descrip_2	None	None	None	None	None	None	None	None	None	None	None	None	None	None
c_less50	None	None	None	None	None	None	None	None	None	None	None	None	None	None
c_more50	None	None	None	None	None	None	None	None	None	None	None	None	None	None
ind_class	GOV	GOV	GOV	GOV	GOV	GOV	GOV	GOV	GOV	GOV	GOV	GOV	GOV	GOV
ind_descr	None	None	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	None	None
bus_descr	None	None	None	None	None	None	None	None	None	None	None	None	None	None
auth_name	GONSALVES & SON, JOE A.	GONSALVES & SON, JOE A.	GONSALVES & SON, JOE A.	FERNANDEZ GOVERNMENT SOLUTIONS, LLC	GONSALVES & SON, JOE A.	FERNANDEZ GOVERNMENT SOLUTIONS, LLC	GONSALVES & SON, JOE A.	FERNANDEZ GOVERNMENT SOLUTIONS, LLC	GONSALVES & SON, JOE A.	FERNANDEZ GOVERNMENT SOLUTIONS, LLC	GONSALVES & SON, JOE A.	FERNANDEZ GOVERNMENT SOLUTIONS, LLC	GONSALVES & SON, JOE A.	GONSALVES & SON, JOE A.
auth_city	Sacramento	Sacramento	Sacramento	SACRAMENTO	Sacramento	SACRAMENTO	Sacramento	SACRAMENTO	Sacramento	SACRAMENTO	Sacramento	SACRAMENTO	Sacramento	Sacramento,
auth_st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA
auth_zip4	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814
lobby_int	None	None	None	None	None	None	None	None	None	None	None	None	None	None
influen_yn	None	None	None	None	None	None	None	None	None	None	None	None	None	None
firm_name	None	None	None	None	None	None	None	None	None	None	None	None	None	None
newcert_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None
rencert_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None
complet_dt	None	None	None	None	None	None	None	None	None	None	None	None	None	None
lby_reg_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None
lby_604_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None
st_leg_yn	None	None	None	None	None	None	None	None	None	None	None	None	None	None
st_agency	None	None	None	None	None	None	None	None	None	None	None	None	None	None
lobby_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None
l_firm_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None

Table: efs_filing_log
filing_date	2001-07-17 00:00:00	2001-07-17 00:00:00	2001-08-02 00:00:00	2001-08-02 00:00:00	2001-04-20 00:00:00	2001-04-20 00:00:00	2001-10-17 00:00:00	2001-10-17 00:00:00	2002-01-23 00:00:00	2002-01-23 00:00:00	2002-01-26 00:00:00	2002-01-26 00:00:00	2002-07-15 00:00:00	2002-07-15 00:00:00	2002-04-24 00:00:00	2002-04-24 00:00:00	2002-04-24 00:00:00	2002-10-11 00:00:00	2002-10-11 00:00:00	2003-01-13 00:00:00	2003-01-13 00:00:00	2003-04-24 00:00:00	2003-04-24 00:00:00	2003-07-11 00:00:00	2003-07-11 00:00:00	2003-10-10 00:00:00	2003-10-10 00:00:00
filingstatus	1	0	1	0	1	0	1	0	1	0	1	0	1	0	2	1	0	1	0	1	0	1	0	1	0	1	0
vendor	RUNFOROFFICE	RUNFOROFFICE	RUNFOROFFICE	RUNFOROFFICE	RUNFOROFFICE	RUNFOROFFICE	RUNFOROFFICE	RUNFOROFFICE	RUNFOROFFICE	RUNFOROFFICE	RUNFOROFFICE	RUNFOROFFICE	RUNFOROFFICE	RUNFOROFFICE	RUNFOROFFICE	RUNFOROFFICE	RUNFOROFFICE	RUNFOROFFICE	RUNFOROFFICE	RUNFOROFFICE	RUNFOROFFICE	RUNFOROFFICE	RUNFOROFFICE	RUNFOROFFICE	RUNFOROFFICE	RUNFOROFFICE	RUNFOROFFICE
filer_id	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157
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
error_no	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ERROR 280	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED

Table: filer_address
filer_id	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157
adrid	2002058	2011728	2044834	2080936	2115278	2164362	2206769	2418290	2512761	2547074	2468973	2281995	2341288
effect_dt	2000-05-24 00:00:00	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	2021-01-01 00:00:00	2023-01-01 00:00:00	2019-01-01 00:00:00	2013-01-01 00:00:00	2015-01-01 00:00:00
add_type	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051
session_id	1999	2001	2003	2005	2007	2009	2011	2017	2021	2023	2019	2013	2015

Table: filer_filings
filer_id	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157
filing_id	636678	642145	642529	678359	710832	694438	713320	742654	734783	758652	760858	760946	787667	767981	779756	767981	810863	796105	809451	804256	809451	822269	859717	849762	846416	848387	847168	873722	893164	903503	901163	928874	941368	936301	920787	963393	956203	973384	1001059	985940	1013298	1034820	1017017	1023467	1013298	1047829	1020724	1019341	1071629	1076211	1065613	1093426	1103846	1084694	1111664	1128202	1164145	1142470	1187602	1213473	1258568	1225987	1233218	1242864	1304376	1280725	1941120	1957344	1974717	1865774	1795818	1811410	1775827	1957344	1948930	1901680	1295097	1326783	1344564	1389619	1373056	1386544	1409140	1416883	1430569	1447886	1458394	1479091	1513201	1506316	1506316	1540160	1541489	1557696	1560804	1570373	1565606	1479091	1591483	1555366	1602256	1618302	1633721	1673747	1653748	1696658	1927041	1921876	1923880	1716658	1729558	1723251	1730773	1727221	1841241	1756521	1992064	2482935	2342231	2235147	2394873	2268674	2363598	2007060	2029601	2054741	2088062	2127071	2122913	2114568	2117095	2151815	2132484	2171099	2329908	2375485	2207178	2597959	2549511	2540975	2556529	2413450	2308536	2187547	2436136	2467945	2525616	2624357	2701800	2575341	2671302	2638274	2737701
period_id	None	None	162	163	164	163	None	165	164	165	None	None	167	166	None	166	168	None	169	None	169	None	None	170	None	None	None	171	None	None	172	173	174	None	None	175	None	None	None	176	177	None	None	178	177	179	None	None	181	180	None	None	181	None	182	183	185	184	186	187	189	189	188	None	192	190	None	221	222	218	215	216	214	221	None	219	191	193	194	196	195	196	None	197	198	199	200	201	None	202	202	203	203	204	None	204	None	201	205	204	206	207	208	210	209	211	220	220	220	212	212	212	None	None	217	213	223	242	236	233	238	234	None	224	225	226	227	None	228	228	228	229	None	230	236	237	232	246	244	244	None	239	235	231	240	241	243	247	250	245	249	248	251
form_id	F602	F999	F635	F635	F635	F635	F602	F635	F635	F635	F602	F605	F635	F635	F635	F635	F635	F635	F635	F690	F635	F635	F635	F635	F690	F635	F635	F635	F635	F602	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F690	F635	F602	F635	F635	F635	F635	F602	F635	F635	F635	F635	F635	F635	F635	F602	F635	F602	F635	F635	F602	F635	F635	F635	F635	F635	F635	F635	F602	F635	F635	F635	F635	F635	F635	F602	F602	F635	F635	F635	F635	F635	F602	F635	F635	F635	F602	F602	F602	F635	F602	F635	F635	F602	F635	F635	F635	F635	F635	F635	F635	F602	F602	F602	F635	F602	F602	F602	F635	F635	F635	F635	F635	F635	F635	F635	F602	F635	F635	F635	F635	F602	F635	F602	F602	F635	F602	F635	F602	F635	F635	F635	F635	F602	F602	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635
filing_sequence	0	0	0	0	0	0	0	0	0	0	0	0	0	1	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	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	1	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	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
filing_date	2000-05-25 00:00:00	2000-05-25 00:00:00	2000-07-17 00:00:00	2000-10-27 00:00:00	2001-01-17 00:00:00	2000-10-31 00:00:00	2000-12-29 00:00:00	2001-04-20 00:00:00	2001-01-31 00:00:00	2001-04-30 00:00:00	2001-05-31 00:00:00	2001-05-31 00:00:00	2001-10-17 00:00:00	2001-08-02 00:00:00	2001-07-31 00:00:00	2001-07-17 00:00:00	2002-01-26 00:00:00	2001-10-31 00:00:00	2002-01-23 00:00:00	2001-07-31 00:00:00	2002-04-24 00:00:00	2002-01-31 00:00:00	2002-07-31 00:00:00	2002-07-15 00:00:00	2002-04-30 00:00:00	2002-04-30 00:00:00	2002-05-09 00:00:00	2002-10-11 00:00:00	2002-10-31 00:00:00	2002-12-31 00:00:00	2003-01-13 00:00:00	2003-04-24 00:00:00	2003-07-11 00:00:00	2003-04-30 00:00:00	2003-01-31 00:00:00	2003-10-10 00:00:00	2003-07-31 00:00:00	2003-10-31 00:00:00	2004-02-02 00:00:00	2004-01-23 00:00:00	2004-06-08 00:00:00	2004-07-30 00:00:00	2004-04-30 00:00:00	2004-07-16 00:00:00	2004-04-29 00:00:00	2004-10-14 00:00:00	2004-06-09 00:00:00	2004-05-03 00:00:00	2005-01-12 00:00:00	2005-01-27 00:00:00	2004-10-29 00:00:00	2005-01-31 00:00:00	2005-04-28 00:00:00	2004-12-31 00:00:00	2005-07-12 00:00:00	2005-10-16 00:00:00	2006-04-24 00:00:00	2006-01-19 00:00:00	2006-07-26 00:00:00	2006-10-27 00:00:00	2007-04-23 00:00:00	2007-01-02 00:00:00	2007-01-28 00:00:00	2007-01-02 00:00:00	2008-01-17 00:00:00	2007-07-25 00:00:00	2014-12-30 00:00:00	2015-07-01 00:00:00	2015-07-16 00:00:00	2014-07-24 00:00:00	2013-10-21 00:00:00	2014-01-21 00:00:00	2013-07-16 00:00:00	2015-04-10 00:00:00	2015-01-08 00:00:00	2014-10-21 00:00:00	2007-10-25 00:00:00	2008-04-24 00:00:00	2008-07-21 00:00:00	2009-01-14 00:00:00	2008-10-28 00:00:00	2008-12-30 00:00:00	2008-12-30 00:00:00	2009-04-09 00:00:00	2009-07-14 00:00:00	2009-10-15 00:00:00	2010-01-19 00:00:00	2010-04-12 00:00:00	2010-07-30 00:00:00	2010-07-30 00:00:00	2010-11-01 00:00:00	2010-11-01 00:00:00	2010-11-02 00:00:00	2011-01-06 00:00:00	2010-12-30 00:00:00	2011-01-31 00:00:00	2011-01-06 00:00:00	2010-11-01 00:00:00	2011-05-02 00:00:00	2010-12-29 00:00:00	2011-07-22 00:00:00	2011-10-19 00:00:00	2012-01-30 00:00:00	2012-07-23 00:00:00	2012-04-23 00:00:00	2012-10-10 00:00:00	2015-01-20 00:00:00	2014-12-30 00:00:00	2015-01-08 00:00:00	2012-12-10 00:00:00	2013-01-22 00:00:00	2013-01-08 00:00:00	2012-12-28 00:00:00	2013-01-08 00:00:00	2014-04-24 00:00:00	2013-04-15 00:00:00	2015-10-15 00:00:00	2020-07-29 00:00:00	2019-01-28 00:00:00	2018-04-24 00:00:00	2019-07-29 00:00:00	2018-07-24 00:00:00	2018-12-27 00:00:00	2016-01-26 00:00:00	2016-04-19 00:00:00	2016-07-13 00:00:00	2016-10-12 00:00:00	2017-01-04 00:00:00	2017-01-24 00:00:00	2016-12-28 00:00:00	2017-01-04 00:00:00	2017-04-19 00:00:00	2016-12-28 00:00:00	2017-07-25 00:00:00	2018-12-27 00:00:00	2019-04-22 00:00:00	2018-01-29 00:00:00	2021-07-28 00:00:00	2021-01-28 00:00:00	2020-12-30 00:00:00	2020-12-31 00:00:00	2019-10-17 00:00:00	2018-10-18 00:00:00	2017-10-12 00:00:00	2020-01-27 00:00:00	2020-04-27 00:00:00	2020-10-28 00:00:00	2021-11-01 00:00:00	2022-07-27 00:00:00	2021-04-20 00:00:00	2022-04-27 00:00:00	2022-01-26 00:00:00	2022-10-20 00:00:00
stmnt_type	10005	10005	10005	10001	10001	10005	10005	10001	10005	10005	10005	10005	10001	10002	10005	10001	10001	10005	10001	10006	10002	10005	10005	10001	10005	10005	10006	10001	10005	10005	10001	10001	10001	10005	10005	10001	10005	10005	10005	10001	10002	10005	10005	10001	10001	10001	10006	10006	10001	10001	10005	10005	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10005	10002	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10005	10001	10002	10001	10001	10001	10005	10001	10005	10002	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10005	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10005	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001
stmnt_status	11001	11001	11001	11003	11003	11001	11001	11003	11001	11001	11001	11001	11003	11003	11001	11003	11003	11001	11003	11001	11003	11001	11001	11003	11001	11001	11001	11003	11001	11001	11003	11003	11003	11001	11001	11003	11001	11001	11001	11003	11003	11001	11001	11003	11003	11003	11003	11003	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	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	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11003	11001	11003
session_id	1999	1999	1999	1999	1999	1999	2001	2001	1999	2001	2001	2001	2001	2001	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	2003	2003	2003	2005	2005	2005	2005	2005	2005	2005	2005	2007	2007	2005	2007	2007	2007	2015	2015	2015	2013	2013	2013	2013	2015	2015	2013	2007	2007	2007	2007	2007	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2011	2011	2009	2011	2009	2011	2011	2011	2011	2011	2011	2011	2011	2013	2015	2015	2013	2011	2013	2013	2013	2013	2013	2015	2019	2017	2017	2019	2017	2019	2015	2015	2015	2015	2017	2015	2017	2017	2017	2017	2017	2019	2019	2017	2021	2019	2021	2021	2019	2017	2017	2019	2019	2019	2021	2021	2021	2021	2021	2021
user_id	SARRIAGA	SARRIAGA	TTHAM	*	*	YBONILLA	TTHAM	*	YBONILLA	JBRANNAN	CFLAGG	CFLAGG	*	*	LTHIBAUL	*	*	LTHIBAUL	*	LTHIBAUL	*	LTHIBAUL	LTHIBAUL	*	LTHIBAUL	LTHIBAUL	LTHIBAUL	*	LTHIBAUL	BSMITH	COMPLETED	COMPLETED	COMPLETED	LTHIBAUL	LTHIBAUL	COMPLETED	LTHIBAUL	LTHIBAUL	LTHIBAUL	COMPLETED	COMPLETED	LTHIBAUL	LTHIBAUL	COMPLETED	COMPLETED	COMPLETED	EMCENTEE	EMCENTEE	COMPLETED	COMPLETED	LTHIBAUL	LTHIBAUL	LTHIBAUL	SARRIAGA	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	*	LTHIBAUL	SARRIAGA	LTHIBAUL	YRODRIGU	PBANFORD	AGLADNEY	AGLADNEY	ASAETERN	ASAETERN	ASAETERN	AGLADNEY	AGLADNEY	YRODRIGU	AGLADNEY	YRODRIGU	YRODRIGU	LTHIBAUL	MGUERRA	MGUERRA	YRODRIGU	PBANFORD	WBROWN	WBROWN	WBROWN	WBROWN	ASAETERN	YRODRIGU	ASAETERN	ASAETERN	ASAETERN	*	*	PBANFORD	AGLADNEY	SARRIAGA	ASAETERN	AGLADNEY	*	AGLADNEY	AGLADNEY	AGLADNEY	ASAETERN	ASAETERN	AGLADNEY	AGLADNEY	PBANFORD	YRODRIGU	PBANFORD	AGLADNEY	SARRIAGA	PBANFORD	SARRIAGA	AGLADNEY	AGLADNEY	AGLADNEY	CVANLIEW	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	GPEREZ	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	SARRIAGA	AGLADNEY	GPEREZ	GPEREZ	MPACHECO	SARRIAGA	AGLADNEY	GPEREZ	GTAYLOR	AGLADNEY	MKIRKHAM	GTAYLOR	MMERCHANT	MMERCHANT	GTAYLOR	AGLADNEY	AGLADNEY	AGLADNEY	VUKSTINA	GTAYLOR	GTAYLOR	CAFILER	CHATRIDGE	CAFILER	CHATRIDGE	CAFILER
special_audit	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11002	11002	11003	11003	11002	11003	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
fine_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	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11003	11001	11003	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11003	11001	11003	11003	11001	11003	11001	11003	11001	11001	11001	11001	11003	11003	11001	11001	11001	11001	11001	11001	11001	11003	11001	11003	11001	11003
rpt_start	None	None	2000-04-01 00:00:00	2000-07-01 00:00:00	2000-10-01 00:00:00	2000-07-01 00:00:00	1900-01-01 00:00:00	2001-01-01 00:00:00	2000-10-01 00:00:00	2001-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2001-07-01 00:00:00	2001-04-01 00:00:00	2001-04-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	2001-04-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-01-01 00:00:00	2002-01-01 00:00:00	2002-01-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	2003-04-01 00:00:00	2003-01-01 00:00:00	2002-10-01 00:00:00	2003-07-01 00:00:00	2003-04-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-04-01 00:00:00	2004-01-01 00:00:00	2004-04-01 00:00:00	2004-01-01 00:00:00	2004-07-01 00:00:00	2004-01-01 00:00:00	2004-01-01 00:00:00	2005-01-13 00:00:00	2004-10-01 00:00:00	2004-07-01 00:00:00	2004-10-01 00:00:00	2005-01-01 00:00:00	1900-01-01 00:00:00	2005-04-01 00:00:00	2005-07-01 00:00:00	2006-01-01 00:00:00	2005-10-01 00:00:00	2006-04-01 00:00:00	2006-07-01 00:00:00	2007-01-01 00:00:00	2007-01-02 00:00:00	2006-10-01 00:00:00	1900-01-01 00:00:00	2007-10-01 00:00:00	2007-04-01 00:00:00	1900-01-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	2013-10-01 00:00:00	2013-04-01 00:00:00	2015-01-01 00:00:00	1900-01-01 00:00:00	2014-07-01 00:00:00	2007-07-01 00:00:00	2008-01-01 00:00:00	2008-04-01 00:00:00	2008-10-01 00:00:00	2008-07-01 00:00:00	2008-12-30 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	2009-10-01 00:00:00	2010-01-01 00:00:00	1900-01-01 00:00:00	2010-04-01 00:00:00	2010-04-01 00:00:00	2010-07-01 00:00:00	2010-08-20 00:00:00	2010-12-31 00:00:00	1900-01-01 00:00:00	2010-10-01 00:00:00	1900-01-01 00:00:00	2010-01-01 00:00:00	2011-01-01 00:00:00	2010-12-29 00:00:00	2011-04-01 00:00:00	2011-07-01 00:00:00	2011-10-01 00:00:00	2012-04-01 00:00:00	2012-01-01 00:00:00	2012-07-01 00:00:00	2014-10-01 00:00:00	2014-12-30 00:00:00	2014-12-31 00:00:00	2012-12-10 00:00:00	2012-10-01 00:00:00	2012-12-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2014-01-01 00:00:00	2013-01-01 00:00:00	2015-07-01 00:00:00	2020-04-01 00:00:00	2018-10-01 00:00:00	2018-01-01 00:00:00	2019-04-01 00:00:00	2018-04-01 00:00:00	1900-01-01 00:00:00	2015-10-01 00:00:00	2016-01-01 00:00:00	2016-04-01 00:00:00	2016-07-01 00:00:00	1900-01-01 00:00:00	2016-10-01 00:00:00	2016-12-28 00:00:00	2016-12-31 00:00:00	2017-01-01 00:00:00	1900-01-01 00:00:00	2017-04-01 00:00:00	2018-12-27 00:00:00	2019-01-01 00:00:00	2017-10-01 00:00:00	2021-04-01 00:00:00	2020-10-01 00:00:00	2020-12-30 00:00:00	1900-01-01 00:00:00	2019-07-01 00:00:00	2018-07-01 00:00:00	2017-07-01 00:00:00	2019-10-01 00:00:00	2020-01-01 00:00:00	2020-07-01 00:00:00	2021-07-01 00:00:00	2022-04-01 00:00:00	2021-01-01 00:00:00	2022-01-01 00:00:00	2021-10-01 00:00:00	2022-07-01 00:00:00
rpt_end	None	None	2000-06-30 00:00:00	2000-09-30 00:00:00	2000-12-31 00:00:00	2000-09-30 00:00:00	1900-01-01 00:00:00	2001-03-31 00:00:00	2000-12-31 00:00:00	2001-03-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2001-09-30 00:00:00	2001-06-30 00:00:00	2001-06-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	2001-06-30 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-03-31 00:00:00	2002-03-31 00:00:00	2002-03-31 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	2003-06-30 00:00:00	2003-03-31 00:00:00	2002-12-31 00:00:00	2003-09-30 00:00:00	2003-06-30 00:00:00	2003-09-30 00:00:00	2003-12-31 00:00:00	2003-12-31 00:00:00	2004-03-31 00:00:00	2004-06-30 00:00:00	2004-03-31 00:00:00	2004-06-30 00:00:00	2004-03-31 00:00:00	2004-09-30 00:00:00	2004-03-31 00:00:00	2004-03-31 00:00:00	2005-01-13 00:00:00	2004-12-31 00:00:00	2004-09-30 00:00:00	2004-12-31 00:00:00	2005-03-31 00:00:00	1900-01-01 00:00:00	2005-06-30 00:00:00	2005-09-30 00:00:00	2006-03-31 00:00:00	2005-12-31 00:00:00	2006-06-30 00:00:00	2006-09-30 00:00:00	2007-03-31 00:00:00	2007-01-02 00:00:00	2006-12-31 00:00:00	1900-01-01 00:00:00	2007-12-31 00:00:00	2007-06-30 00:00:00	1900-01-01 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	2013-12-31 00:00:00	2013-06-30 00:00:00	2015-03-31 00:00:00	1900-01-01 00:00:00	2014-09-30 00:00:00	2007-09-30 00:00:00	2008-03-31 00:00:00	2008-06-30 00:00:00	2008-12-31 00:00:00	2008-09-30 00:00:00	2008-12-30 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	2009-12-31 00:00:00	2010-03-31 00:00:00	1900-01-01 00:00:00	2010-06-30 00:00:00	2010-06-30 00:00:00	2010-09-30 00:00:00	2010-08-20 00:00:00	2010-12-31 00:00:00	1900-01-01 00:00:00	2010-12-31 00:00:00	1900-01-01 00:00:00	2010-03-31 00:00:00	2011-03-31 00:00:00	2010-12-29 00:00:00	2011-06-30 00:00:00	2011-09-30 00:00:00	2011-12-31 00:00:00	2012-06-30 00:00:00	2012-03-31 00:00:00	2012-09-30 00:00:00	2014-12-31 00:00:00	2014-12-30 00:00:00	2014-12-31 00:00:00	2012-12-10 00:00:00	2012-12-31 00:00:00	2012-12-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2014-03-31 00:00:00	2013-03-31 00:00:00	2015-09-30 00:00:00	2020-06-30 00:00:00	2018-12-31 00:00:00	2018-03-31 00:00:00	2019-06-30 00:00:00	2018-06-30 00:00:00	1900-01-01 00:00:00	2015-12-31 00:00:00	2016-03-31 00:00:00	2016-06-30 00:00:00	2016-09-30 00:00:00	1900-01-01 00:00:00	2016-12-31 00:00:00	2016-12-28 00:00:00	2016-12-31 00:00:00	2017-03-31 00:00:00	1900-01-01 00:00:00	2017-06-30 00:00:00	2018-12-27 00:00:00	2019-03-31 00:00:00	2017-12-31 00:00:00	2021-06-30 00:00:00	2020-12-31 00:00:00	2020-12-30 00:00:00	1900-01-01 00:00:00	2019-09-30 00:00:00	2018-09-30 00:00:00	2017-09-30 00:00:00	2019-12-31 00:00:00	2020-03-31 00:00:00	2020-09-30 00:00:00	2021-09-30 00:00:00	2022-06-30 00:00:00	2021-03-31 00:00:00	2022-03-31 00:00:00	2021-12-31 00:00:00	2022-09-30 00:00:00
rpt_date	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	22001	22001	22001	None	None	22001	None	None	None	22001	22001	None	None	22001	22001	22001	None	None	22001	22001	None	None	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	None	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	None	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	None	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22006	22001	22006	22001	22006

Table: filer_interests
filer_id	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157
session_id	1999	2003	2001	2013	2007	2005	2009	2011	2017	2015	2019	2021	2023
interest_cd	40305	40305	40305	40305	40305	40305	40305	40305	40305	40305	40305	40305	40305
effect_date	2000-05-24 00:00:00	2003-01-01 00:00:00	2001-01-01 00:00:00	2013-01-01 00:00:00	2007-01-01 00:00:00	2005-01-01 00:00:00	2009-01-01 00:00:00	2011-01-01 00:00:00	2017-01-01 00:00:00	2015-01-01 00:00:00	2019-01-01 00:00:00	2021-01-01 00:00:00	2023-01-01 00:00:00

Table: filer_to_filer_type
filer_id	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157
filer_type	1	1	1	1	1	1	1	1	1	1	1	1	1
active	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	N
race	0	0	None	None	None	None	None	None	None	None	None	None	None
session_id	2001	1999	2003	2005	2007	2013	2011	2009	2017	2019	2021	2015	2023
category	0	0	None	None	None	None	None	None	None	None	None	None	None
category_type	0	0	None	None	None	None	None	None	None	None	None	None	None
sub_category	0	0	None	None	None	None	None	None	None	None	None	None	None
effect_dt	2001-01-01 00:00:00	2000-05-24 00:00:00	2003-01-01 00:00:00	2005-01-01 00:00:00	2007-01-01 00:00:00	2013-01-01 00:00:00	2011-01-01 00:00:00	2009-01-01 00:00:00	2017-01-01 00:00:00	2019-01-01 00:00:00	2021-01-01 00:00:00	2015-01-01 00:00:00	2023-01-01 00:00:00
sub_category_type	0	0	None	None	None	None	None	None	None	None	None	None	None
election_type	0	0	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
nyq_dt	None	None	None	2000-07-01 00:00:00	2000-07-01 00:00:00	None	None	None	None	None	None	None	None
party_cd	0	0	None	None	None	None	None	None	None	None	None	None	None
county_cd	0	0	None	None	None	None	None	None	None	None	None	None	None
district_cd	0	0	None	None	None	None	None	None	None	None	None	None	None

Table: filer_xref
filer_id		1224157
xref_id		1224157
effect_dt		2000-06-24 00:00:00
migration_source		CLAIMS

Table: filername
xref_filer_id	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157
filer_id	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157
filer_type	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT
status	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE
effect_dt	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	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	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF
namf	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
adr1	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
adr2	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
city	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE	ROSEVILLE
st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA
zip4	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678	95678
phon	9167745263	9167745204	9167745204	9167745353	9167745353	9167745353	9167745353	9167745353	9167745353	9167745353	9167745179	9167745179	9167745179	9167745263	9167745204	9167745204	9167745353	9167745353	9167745353	9167745353	9167745353	9167745353	9167745353	9167745179	9167745179	9167745179	9167745263	9167745204	9167745204	9167745353	9167745353	9167745353	9167745353	9167745353	9167745353	9167745353	9167745179	9167745179	9167745179	9167745263	9167745204	9167745204	9167745353	9167745353	9167745353	9167745353	9167745353	9167745353	9167745353	9167745179	9167745179	9167745179	9167745263	9167745204	9167745204	9167745353	9167745353	9167745353	9167745353	9167745353	9167745353	9167745353	9167745179	9167745179	9167745179	9167745263	9167745204	9167745204	9167745353	9167745353	9167745353	9167745353	9167745353	9167745353	9167745353	9167745179	9167745179	9167745179	9167745263	9167745204	9167745204	9167745353	9167745353	9167745353	9167745353	9167745353	9167745353	9167745353	9167745179	9167745179	9167745179	9167745263	9167745204	9167745204	9167745353	9167745353	9167745353	9167745353	9167745353	9167745353	9167745353	9167745179	9167745179	9167745179	9167745263	9167745204	9167745204	9167745353	9167745353	9167745353	9167745353	9167745353	9167745353	9167745353	9167745179	9167745179	9167745179	9167745263	9167745204	9167745204	9167745353	9167745353	9167745353	9167745353	9167745353	9167745353	9167745353	9167745179	9167745179	9167745179	9167745263	9167745204	9167745204	9167745353	9167745353	9167745353	9167745353	9167745353	9167745353	9167745353	9167745179	9167745179	9167745179	9167745263	9167745204	9167745204	9167745353	9167745353	9167745353	9167745353	9167745353	9167745353	9167745353	9167745179	9167745179	9167745179
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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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: filers
filer_id		1224157

Table: lobbying_chg_log
filer_id	1224157	1224157	1224157	1224157	1224157	1224157	1224157
change_no	1	2	3	4	5	0	6
session_id	1999	1999	1999	2001	2001	2009	2021
log_dt	2000-06-24 00:00:00	2000-06-24 00:00:00	2000-06-24 00:00:00	2001-05-31 00:00:00	2002-08-01 00:00:00	2010-08-20 00:00:00	2020-12-31 00:00:00
filer_type	1	1	1	1	1	1	1
correction_flg	None	None	None	Y	None	Y	None
action	None	CHANGED	None	ADDED	DELETED	ADDED	CHANGED
attribute_changed	None	ADDRESS AND PHONE	None	EMPLOYER	FIRM	FIRM	RESPONSIBLE OFFICER
ethics_dt	None	None	None	None	None	None	None
interests	None	None	None	None	None	None	None
filer_full_name	ROSEVILLE, CITY OF	None	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE, CITY OF	ROSEVILLE; CITY OF	ROSEVILLE; CITY OF
filer_city	None	ROSEVILLE	None	ROSEVILLE	None	None	None
filer_st	None	CA	None	CA	None	None	None
filer_zip	None	95678	None	95678	None	None	None
filer_phone	None	9167745263	None	9167745263	None	None	None
entity_type	3	1	20	2	3	3	20
entity_name	GONSALVES & SON, JOE A.	None	ACTING CITY MANAGER W. CRAIG ROBINSON	THE FERGUSON GROUP	FERGUSON GROUP, L.L.C., THE	FERNANDEZ GOVERNMENT SOLUTIONS, LLC	GOVERNMENT RELATIONS MANAGER MARK WOLINSKI
entity_city	None	ROSEVILLE	None	None	None	None	None
entity_st	None	CA	None	None	None	None	None
entity_zip	None	95678	None	None	None	None	None
entity_phone	None	9167745263	None	None	None	None	None
entity_id	1147239	1224157	1224158	None	1147613	1282555	1335641
responsible_officer	None	None	None	None	None	None	None
effect_dt	None	None	None	2001-05-22 00:00:00	2002-07-01 00:00:00	2010-01-27 00:00:00	2021-01-01 00:00:00

Table: received_filings
filer_id	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157	1224157
filing_file_name	710832_0.cal	678359_0.cal	742654_0.cal	767981_0.cal	787667_0.cal	767981_1.cal	809451_0.cal	810863_0.cal	198065.cal	809451_1.cal	849762_0.cal	873722_0.cal	901163_0.cal	928874_0.cal	941368_0.cal	963393_0.cal	313407.cal	1076211_0.cal	1103846_0.cal	1128202_0.cal	1111664_0.cal	1142470_0.cal	1164145_0.cal	1187602_0.cal	1326783_0.cal	1506316_0.cal	1416883_0.cal	1389619_0.cal	1344564_0.cal	318767.cal	1447886_0.cal	1458394_0.cal	1213473_0.cal	1479091_0.cal	1430569_0.cal	1295097_0.cal	1304376_0.cal	1373056_0.cal	1673747_0.cal	1756521_0.cal	1729558_0.cal	1841241_0.cal	1795818_0.cal	1479091_1.cal	1540160_0.cal	1506316_1.cal	1696658_0.cal	174353.cal	1570373_0.cal	1811410_0.cal	1618302_0.cal	1591483_0.cal	1602256_0.cal	1775827_0.cal	1633721_0.cal	1653748_0.cal	1865774_0.cal	1974717_0.cal	1957344_1.cal	2151815_0.cal	2122913_0.cal	2054741_0.cal	480140.cal	2007060_0.cal	2088062_0.cal	2029601_0.cal	1901680_0.cal	1927041_0.cal	1992064_0.cal	1957344_0.cal	2171099_0.cal	2342231_0.cal	2413450_0.cal	2235147_0.cal	2268674_0.cal	2436136_0.cal	2482935_0.cal	2467945_0.cal	2207178_0.cal	2308536_0.cal	2187547_0.cal	2375485_0.cal	2394873_0.cal	2624357_0.cal	2549511_0.cal	2638274_0.cal	2597959_0.cal	2575341_0.cal	2525616_0.cal
received_date	2001-01-17 00:00:00	2000-10-27 00:00:00	2001-04-20 00:00:00	2001-07-17 00:00:00	2001-10-17 00:00:00	2001-08-02 00:00:00	2002-01-23 00:00:00	2002-01-26 00:00:00	2002-04-24 00:00:00	2002-04-24 00:00:00	2002-07-15 00:00:00	2002-10-11 00:00:00	2003-01-13 00:00:00	2003-04-24 00:00:00	2003-07-11 00:00:00	2003-10-10 00:00:00	2004-06-08 00:00:00	2005-01-27 00:00:00	2005-04-28 00:00:00	2005-10-16 00:00:00	2005-07-12 00:00:00	2006-01-19 00:00:00	2006-04-24 00:00:00	2006-07-26 00:00:00	2008-04-24 00:00:00	2010-07-30 00:00:00	2009-04-09 00:00:00	2009-01-14 00:00:00	2008-07-21 00:00:00	2009-10-16 00:00:00	2009-10-15 00:00:00	2010-01-19 00:00:00	2006-10-27 00:00:00	2010-04-12 00:00:00	2009-07-14 00:00:00	2007-10-25 00:00:00	2008-01-17 00:00:00	2008-10-28 00:00:00	2012-07-23 00:00:00	2013-04-15 00:00:00	2013-01-22 00:00:00	2014-04-24 00:00:00	2013-10-21 00:00:00	2010-11-01 00:00:00	2010-11-01 00:00:00	2010-11-01 00:00:00	2012-10-10 00:00:00	2011-01-31 00:00:00	2011-01-31 00:00:00	2014-01-21 00:00:00	2011-10-19 00:00:00	2011-05-02 00:00:00	2011-07-22 00:00:00	2013-07-16 00:00:00	2012-01-30 00:00:00	2012-04-23 00:00:00	2014-07-24 00:00:00	2015-07-16 00:00:00	2015-07-01 00:00:00	2017-04-19 00:00:00	2017-01-24 00:00:00	2016-07-13 00:00:00	2016-07-13 00:00:00	2016-01-26 00:00:00	2016-10-12 00:00:00	2016-04-19 00:00:00	2014-10-21 00:00:00	2015-01-20 00:00:00	2015-10-15 00:00:00	2015-04-10 00:00:00	2017-07-25 00:00:00	2019-01-28 00:00:00	2019-10-17 00:00:00	2018-04-24 00:00:00	2018-07-24 00:00:00	2020-01-27 00:00:00	2020-07-29 00:00:00	2020-04-27 00:00:00	2018-01-29 00:00:00	2018-10-18 00:00:00	2017-10-12 00:00:00	2019-04-22 00:00:00	2019-07-29 00:00:00	2021-11-01 00:00:00	2021-01-28 00:00:00	2022-01-26 00:00:00	2021-07-28 00:00:00	2021-04-20 00:00:00	2020-10-28 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	/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/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/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/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/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/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal
filing_id	710832	678359	742654	767981	787667	767981	809451	810863	None	809451	849762	873722	901163	928874	941368	963393	None	1076211	1103846	1128202	1111664	1142470	1164145	1187602	1326783	1506316	1416883	1389619	1344564	None	1447886	1458394	1213473	1479091	1430569	1295097	1304376	1373056	1673747	1756521	1729558	1841241	1795818	1479091	1540160	1506316	1696658	None	1570373	1811410	1618302	1591483	1602256	1775827	1633721	1653748	1865774	1974717	1957344	2151815	2122913	2054741	None	2007060	2088062	2029601	1901680	1927041	1992064	1957344	2171099	2342231	2413450	2235147	2268674	2436136	2482935	2467945	2207178	2308536	2187547	2375485	2394873	2624357	2549511	2638274	2597959	2575341	2525616
form_id	F635	F635	F635	F635	F635	F635	F635	F635	None	F635	F635	F635	F635	F635	F635	F635	None	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	None	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	None	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	None	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
receive_comment	Filing accepted, but with warnings	Filing accepted, but but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing passed validation, but failed DB constraints	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing 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 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 did not pass validation	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	Filing accepted	Filing 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