OpenCalAccess

Filer ID: 1285845

Table: cvr_lobby_disclosure
filing_id	1217070	1238636	1191446	1420326	1451879	1434472	1451879	1462071	1537362	1504907	1483591	1622466	1602051	1571316	1589944	1632844	1709815	1679467	1655967	1736974	1632844	1655967	1679467	1709815	1766021	1780606	1766021	1622466	1817937	1801285	1844420	1996352	2064547	2038045	2010500	2010500	2102328	2175256	2157877	2102328	2127577	2127577	2191602	2208969	2240145	2191602	2276493	2208969	2240145	2208969	2397410	2380984	2348236	2320523	2418081	2439269	2469609	2547933	2482925	2527928	2482925	2469609	2621960	2599725	2578712	2641576	2641576	2578712	2674508	2621960	2703927	2599725	2621960	2599725	2746134
amend_id	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	1	1	1	0	0	1	0	0	0	0	0	0	0	1	0	0	0	1	1	0	0	1	0	1	0	2	1	0	0	0	0	0	0	0	0	0	1	0	0	1	0	0	0	1	0	1	0	2	0	1	1	2	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
form_type	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625
sender_id	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845
filer_id	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845
entity_cd	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM
filer_naml	BEST BEST & KRIEGER	BEST BEST & KRIEGER	BEST BEST & KRIEGER	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP
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
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
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
report_num	000	000	000	000	000	000	001	000	000	000	000	000	000	000	000	000	000	000	000	000	001	001	001	001	001	000	000	001	000	000	000	000	000	000	000	001	000	000	000	001	001	000	000	001	000	001	000	002	001	000	000	000	000	000	000	000	000	000	001	000	000	001	000	000	000	001	000	001	000	002	000	001	001	002	000
rpt_date	2006-10-31 00:00:00	2007-01-31 00:00:00	2006-07-31 00:00:00	2009-04-29 00:00:00	2009-10-30 00:00:00	2009-07-28 00:00:00	2010-01-28 00:00:00	2010-01-28 00:00:00	2010-10-28 00:00:00	2010-07-29 00:00:00	2010-04-28 00:00:00	2011-10-31 00:00:00	2011-07-21 00:00:00	2011-01-31 00:00:00	2011-04-29 00:00:00	2012-01-27 00:00:00	2012-10-31 00:00:00	2012-07-31 00:00:00	2012-04-27 00:00:00	2013-01-30 00:00:00	2012-01-27 00:00:00	2012-04-27 00:00:00	2012-07-31 00:00:00	2012-10-31 00:00:00	2013-07-31 00:00:00	2013-07-31 00:00:00	2013-04-30 00:00:00	2011-10-31 00:00:00	2014-01-31 00:00:00	2013-10-31 00:00:00	2014-04-30 00:00:00	2015-10-31 00:00:00	2016-07-31 00:00:00	2016-04-30 00:00:00	2016-01-31 00:00:00	2016-01-31 00:00:00	2016-10-31 00:00:00	2017-07-31 00:00:00	2017-04-30 00:00:00	2016-10-31 00:00:00	2017-01-31 00:00:00	2017-01-31 00:00:00	2017-10-31 00:00:00	2017-12-31 00:00:00	2018-04-30 00:00:00	2017-10-31 00:00:00	2018-07-31 00:00:00	2017-12-31 00:00:00	2018-04-30 00:00:00	2018-01-31 00:00:00	2019-07-31 00:00:00	2019-04-30 00:00:00	2019-01-31 00:00:00	2018-10-31 00:00:00	2019-10-31 00:00:00	2020-01-31 00:00:00	2020-04-30 00:00:00	2021-01-31 00:00:00	2020-10-05 00:00:00	2020-10-31 00:00:00	2020-07-31 00:00:00	2020-10-05 00:00:00	2021-11-01 00:00:00	2021-07-31 00:00:00	2021-04-30 00:00:00	2022-03-31 00:00:00	2022-01-31 00:00:00	2022-02-10 00:00:00	2022-04-30 00:00:00	2022-03-31 00:00:00	2022-08-01 00:00:00	2022-01-31 00:00:00	2022-01-31 00:00:00	2022-03-31 00:00:00	2022-10-31 00:00:00
from_date	2006-07-01 00:00:00	2006-10-01 00:00:00	2006-04-01 00:00:00	2009-01-01 00:00:00	2009-07-31 00:00:00	2009-04-01 00:00:00	2009-07-01 00:00:00	2009-10-01 00:00:00	2010-07-01 00:00:00	2010-04-01 00:00:00	2010-01-01 00:00:00	2011-07-01 00:00:00	2011-04-01 00:00:00	2010-10-01 00:00:00	2011-01-01 00:00:00	2011-10-01 00:00:00	2012-07-01 00:00:00	2012-04-01 00:00:00	2012-01-01 00:00:00	2012-10-01 00:00:00	2011-10-01 00:00:00	2012-01-01 00:00:00	2012-04-01 00:00:00	2012-07-01 00:00:00	2013-01-01 00:00:00	2013-04-01 00:00:00	2013-01-01 00:00:00	2011-07-01 00:00:00	2013-10-01 00:00:00	2013-07-01 00:00:00	2014-01-01 00:00:00	2015-07-01 00:00:00	2016-04-01 00:00:00	2016-01-01 00:00:00	2015-10-01 00:00:00	2015-10-01 00:00:00	2016-07-01 00:00:00	2017-04-01 00:00:00	2017-01-01 00:00:00	2016-07-01 00:00:00	2016-10-01 00:00:00	2016-10-01 00:00:00	2017-07-01 00:00:00	2017-10-01 00:00:00	2018-01-01 00:00:00	2017-07-01 00:00:00	2018-04-01 00:00:00	2017-10-01 00:00:00	2018-01-01 00:00:00	2017-10-01 00:00:00	2019-04-01 00:00:00	2019-01-01 00:00:00	2018-10-01 00:00:00	2018-07-01 00:00:00	2019-07-01 00:00:00	2019-10-01 00:00:00	2020-01-01 00:00:00	2020-10-01 00:00:00	2020-04-01 00:00:00	2020-07-01 00:00:00	2020-04-01 00:00:00	2020-01-01 00:00:00	2021-07-01 00:00:00	2021-04-01 00:00:00	2021-01-01 00:00:00	2021-10-01 00:00:00	2021-10-01 00:00:00	2021-01-01 00:00:00	2022-01-01 00:00:00	2021-07-01 00:00:00	2022-04-01 00:00:00	2021-04-01 00:00:00	2021-07-01 00:00:00	2021-04-01 00:00:00	2022-07-01 00:00:00
thru_date	2006-09-30 00:00:00	2006-12-31 00:00:00	2006-06-30 00:00:00	2009-03-31 00:00:00	2009-09-30 00:00:00	2009-06-30 00:00:00	2009-09-30 00:00:00	2009-12-31 00:00:00	2010-09-30 00:00:00	2010-06-30 00:00:00	2010-03-31 00:00:00	2011-09-30 00:00:00	2011-06-30 00:00:00	2010-12-31 00:00:00	2011-03-31 00:00:00	2011-12-31 00:00:00	2012-09-30 00:00:00	2012-06-30 00:00:00	2012-03-31 00:00:00	2012-12-31 00:00:00	2011-12-31 00:00:00	2012-03-31 00:00:00	2012-06-30 00:00:00	2012-09-30 00:00:00	2013-03-31 00:00:00	2013-06-30 00:00:00	2013-03-31 00:00:00	2011-09-30 00:00:00	2013-12-31 00:00:00	2013-09-30 00:00:00	2014-03-31 00:00:00	2015-09-30 00:00:00	2016-06-30 00:00:00	2016-03-31 00:00:00	2015-12-31 00:00:00	2015-12-31 00:00:00	2016-09-30 00:00:00	2017-06-30 00:00:00	2017-03-31 00:00:00	2016-09-30 00:00:00	2016-12-31 00:00:00	2016-12-31 00:00:00	2017-09-30 00:00:00	2017-12-31 00:00:00	2018-03-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	2017-12-31 00:00:00	2019-06-30 00:00:00	2019-03-31 00:00:00	2018-12-31 00:00:00	2018-09-30 00:00:00	2019-09-30 00:00:00	2019-12-31 00:00:00	2020-03-31 00:00:00	2020-12-31 00:00:00	2020-06-30 00:00:00	2020-09-30 00:00:00	2020-06-30 00:00:00	2020-03-31 00:00:00	2021-09-30 00:00:00	2021-06-30 00:00:00	2021-03-31 00:00:00	2021-12-31 00:00:00	2021-12-31 00:00:00	2021-03-31 00:00:00	2022-03-31 00:00:00	2021-09-30 00:00:00	2022-06-30 00:00:00	2021-06-30 00:00:00	2021-09-30 00:00:00	2021-06-30 00:00:00	2022-09-30 00:00:00
cum_beg_dt	2006-04-01 00:00:00	2006-04-01 00:00:00	2006-04-01 00:00:00	None	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	2009-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2011-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	2017-01-01 00:00:00	2017-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	2017-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	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	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	None	1285845	1285845	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
firm_name	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	None	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP
firm_city	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO
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
firm_zip4	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814
firm_phon	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	9163254000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000
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
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
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
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
sig_date	2006-10-31 00:00:00	2007-01-31 00:00:00	2006-07-31 00:00:00	2009-04-29 00:00:00	2009-10-30 00:00:00	2009-07-28 00:00:00	2010-01-28 00:00:00	2010-01-28 00:00:00	2010-10-28 00:00:00	2010-07-29 00:00:00	2010-04-28 00:00:00	2011-10-31 00:00:00	2011-07-21 00:00:00	2011-01-31 00:00:00	2011-04-29 00:00:00	2012-01-27 00:00:00	2012-10-31 00:00:00	2012-07-31 00:00:00	2012-04-27 00:00:00	2013-01-30 00:00:00	2013-05-17 00:00:00	2013-05-17 00:00:00	2013-05-17 00:00:00	2013-05-17 00:00:00	2013-07-29 00:00:00	2013-07-29 00:00:00	2013-04-30 00:00:00	2013-05-17 00:00:00	2014-01-31 00:00:00	2013-10-31 00:00:00	2014-04-30 00:00:00	2015-10-31 00:00:00	2016-07-31 00:00:00	2016-04-30 00:00:00	2016-01-31 00:00:00	2016-04-05 00:00:00	2016-10-31 00:00:00	2017-07-31 00:00:00	2017-04-30 00:00:00	2017-03-06 00:00:00	2017-04-30 00:00:00	2017-01-31 00:00:00	2017-10-31 00:00:00	2018-04-30 00:00:00	2018-04-30 00:00:00	2018-04-30 00:00:00	2018-07-31 00:00:00	2018-04-30 00:00:00	2018-04-30 00:00:00	2018-01-31 00:00:00	2019-07-31 00:00:00	2019-04-30 00:00:00	2019-01-31 00:00:00	2018-10-31 00:00:00	2019-10-31 00:00:00	2020-01-31 00:00:00	2020-04-30 00:00:00	2021-01-31 00:00:00	2020-10-05 00:00:00	2020-10-31 00:00:00	2020-07-31 00:00:00	2020-10-05 00:00:00	2021-11-01 00:00:00	2021-07-31 00:00:00	2021-04-30 00:00:00	2022-03-31 00:00:00	2022-01-31 00:00:00	2022-02-10 00:00:00	2022-04-30 00:00:00	2022-03-31 00:00:00	2022-08-01 00:00:00	2022-01-31 00:00:00	2022-01-31 00:00:00	2022-03-31 00:00:00	2022-10-31 00:00:00
sig_loc	Riverside, California	Riverside, CA	Riverside, California	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	SACRAMENTO	Sacramento	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	SAN RAFAEL, CA	SAN RAFAEL, CA	SAN RAFAEL, CA	SAN RAFAEL, CA	SACRAMENTO, CA	SACRAMENTO, CA	Sacramento, CA	SAN RAFAEL, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA
sig_naml	GARNER	Garner	Garner	Thomas	Thomas	Thomas	Thomas	Thomas	THOMAS	Thomas	Thomas	Thomas	Thomas	Thomas	Thomas	Thomas	Thomas	Thomas	Thomas	Thomas	SKINNELL	SKINNELL	SKINNELL	SKINNELL	THOMAS	THOMAS	Thomas	SKINNELL	THOMAS	THOMAS	THOMAS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS
sig_namf	ERIC	Eric	Eric	William	William	William	William	William	WILLIAM	William	William	William	William	William	William	William	William	William	William	William	CHRISTOPHER	CHRISTOPHER	CHRISTOPHER	CHRISTOPHER	WILLIAM J.	WILLIAM J.	William	CHRISTOPHER	WILLIAM J.	WILLIAM J.	WILLIAM J.	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS
sig_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
sig_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
prn_naml	GARNER	Garner	Garner	Thomas	Thomas	Thomas	Thomas	Thomas	THOMAS	Thomas	Thomas	Thomas	Thomas	Thomas	Thomas	Thomas	Thomas	Thomas	Thomas	Thomas	SKINNELL	SKINNELL	SKINNELL	SKINNELL	THOMAS	THOMAS	Thomas	SKINNELL	THOMAS	THOMAS	THOMAS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS
prn_namf	ERIC	Eric	Eric	William	William	William	William	William	WILLIAM	William	William	William	William	William	William	William	William	William	William	William	CHRISTOPHER	CHRISTOPHER	CHRISTOPHER	CHRISTOPHER	WILLIAM J.	WILLIAM J.	William	CHRISTOPHER	WILLIAM J.	WILLIAM J.	WILLIAM J.	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS
prn_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
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
sig_title	MANAGING PARTNER	Managing Partner	Managing Partner	Of Counsel	Of Counsel	Of Counsel	Of Counsel	Of Counsel	OF COUNSEL	Of Counsel	Of Counsel	Of Counsel	Of Counsel	Of Counsel	Of Counsel	Of Counsel	Of Counsel	Of Counsel	Of Counsel	Of Counsel	ATTORNEY & AGENT FOR FILER	ATTORNEY & AGENT FOR FILER	ATTORNEY & AGENT FOR FILER	ATTORNEY & AGENT FOR FILER	ATTORNEY & AGENT FOR FILER	ATTORNEY & AGENT FOR FILER	Of Counsel	ATTORNEY & AGENT FOR FILER	ATTORNEY & AGENT FOR FILER	ATTORNEY & AGENT FOR FILER	ATTORNEY & AGENT FOR FILER	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS
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
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
part1_1_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
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
ctrib_n_cb	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	None	None	X	None	None	None	None	None	X	None	None	None	X	None	None	X	None	None	None	None	X	None	X	X	X	X	None	None	None	X	None	X	X	X	None	None	None	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	X	X	None	X	X	X	X	X	None	X	X	X	None	X	X	None	X	X	X	X	None	X	None	None	None	None	X	X	X	None	X	None	None	None	X	X	X	None	None
lby_actvty	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
lobby_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
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
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
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
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
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
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	BEST, BEST & KRIEGER, LLP	None	None	BEST, BEST & KRIEGER, LLP	BEST, BEST & KRIEGER, LLP	BEST, BEST & KRIEGER, LLP	BEST, BEST & KRIEGER, LLP	None	BEST, BEST & KRIEGER, LLP	BEST, BEST & KRIEGER, LLP	BEST, BEST & KRIEGER, LLP	None	BEST, BEST & KRIEGER, LLP	BEST, BEST & KRIEGER, LLP	None	BEST, BEST & KRIEGER, LLP	None	BEST, BEST & KRIEGER, LLP	BEST, BEST & KRIEGER, LLP	None	BEST, BEST & KRIEGER, LLP	None	None	None	None	None	None	None	None	None	None	None	None	BEST, BEST & KRIEGER, LLP	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	1272623	1272623	None	None	None	None	None	None	None	None	1272623	None	1272623	None	None	None	None	1272623	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None

Table: cvr_registration
filing_id	1225189	1387162	1809129	1809129	1872199	1809129	1986859	1986859	1986859	1986859	1986859	1986859	1986859	2115521	2115521	1986859	2115521	2115521	2115521	2115521	2115521	2115521	2334523	2334523	2334523	2334523	2334523	2334523	2334523	2539033	2539033	2539033	2539033	2539033	2539033	2539033
amend_id	0	0	0	1	0	2	1	2	0	3	5	4	6	0	1	7	4	2	5	3	7	6	0	1	2	4	5	6	3	0	1	4	5	3	2	6
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
form_type	F606	F601	F601	F601	F607	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601
sender_id	1285845	F24550	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845
filer_id	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845
entity_cd	LBY	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM
filer_naml	BEST BEST & KRIEGER	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP
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
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
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
report_num	000	000	000	001	000	002	001	002	000	003	005	004	006	000	001	007	004	002	005	003	007	006	000	001	002	004	005	006	003	000	001	004	005	003	002	006
rpt_date	2006-12-29 00:00:00	2008-12-31 00:00:00	2012-12-31 00:00:00	2014-01-02 00:00:00	2014-07-31 00:00:00	2014-01-31 00:00:00	2016-02-03 00:00:00	2016-02-18 00:00:00	2015-08-11 00:00:00	2016-02-18 00:00:00	2016-10-05 00:00:00	2016-04-05 00:00:00	2016-11-10 00:00:00	2016-11-10 00:00:00	2017-01-18 00:00:00	2017-06-05 00:00:00	2017-09-13 00:00:00	2017-04-24 00:00:00	2017-11-15 00:00:00	2017-07-14 00:00:00	2018-07-18 00:00:00	2018-03-05 00:00:00	2018-12-31 00:00:00	2019-06-03 00:00:00	2019-08-01 00:00:00	2020-05-07 00:00:00	2020-07-30 00:00:00	2020-09-08 00:00:00	2020-03-31 00:00:00	2021-01-01 00:00:00	2021-06-17 00:00:00	2022-02-14 00:00:00	2022-05-17 00:00:00	2022-01-26 00:00:00	2021-10-19 00:00:00	2022-10-12 00:00:00
ls_beg_yr	2007	2009	2013	2013	2013	2013	2015	2015	2015	2015	2015	2015	2015	2017	2017	2015	2017	2017	2017	2017	2017	2017	2019	2019	2019	2019	2019	2019	2019	2021	2021	2021	2021	2021	2021	2021
ls_end_yr	2008	2010	2014	2014	2014	2014	2016	2016	2016	2016	2016	2016	2016	2018	2018	2016	2018	2018	2018	2018	2018	2018	2020	2020	2020	2020	2020	2020	2020	2022	2022	2022	2022	2022	2022	2022
qual_date	None	None	None	None	None	None	None	None	2015-08-10 00:00:00	None	None	None	None	2017-01-01 00:00:00	None	None	None	None	None	None	None	None	2019-01-01 00:00:00	None	None	None	None	None	None	2021-01-01 00:00:00	None	None	None	None	None	None
eff_date	2006-12-31 00:00:00	None	None	None	2013-01-01 00:00:00	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bus_city	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO
bus_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
bus_zip4	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814
bus_phon	9163254000	9163254000	916 325-4000	916 325-4000	415-389-6800	916 325-4000	916 325-4000	916 325-4000	916 325-4000	916 325-4000	916 325-4000	916 325-4000	916 325-4000	916 325-4000	916 325-4000	916 325-4000	916 325-4000	916 325-4000	916 325-4000	916 325-4000	916 325-4000	916 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000	(916) 325-4000
bus_fax	None	9163254010	916 325-4010	916 325-4010	None	916 325-4010	916 325-4010	916 325-4010	916 325-4010	916 325-4010	916 325-4010	916 325-4010	916 325-4010	916 325-4010	916 325-4010	916 325-4010	916 325-4010	916 325-4010	916 325-4010	916 325-4010	916 325-4010	916 325-4010	(916) 325-4010	(916) 325-4010	(916) 325-4010	(916) 325-4010	(916) 325-4010	(916) 325-4010	(916) 325-4010	(916) 325-4010	(916) 325-4010	(916) 325-4010	(916) 325-4010	(916) 325-4010	(916) 325-4010	(916) 325-4010
bus_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
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
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
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
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
sig_date	2006-12-29 00:00:00	2008-12-31 00:00:00	2012-12-27 00:00:00	2013-12-19 00:00:00	2014-07-31 00:00:00	2014-01-31 00:00:00	2016-02-03 00:00:00	2016-02-18 00:00:00	2015-08-11 00:00:00	2016-02-18 00:00:00	2016-10-05 00:00:00	2016-04-05 00:00:00	2016-11-10 00:00:00	2016-12-15 00:00:00	2017-01-18 00:00:00	2017-06-05 00:00:00	2017-09-13 00:00:00	2017-04-24 00:00:00	2017-11-15 00:00:00	2017-07-14 00:00:00	None	2018-03-05 00:00:00	2018-12-31 00:00:00	2019-06-03 00:00:00	2019-08-01 00:00:00	2020-05-07 00:00:00	2020-07-30 00:00:00	2020-09-08 00:00:00	2020-03-31 00:00:00	2021-01-01 00:00:00	2021-06-17 00:00:00	2022-02-14 00:00:00	2022-05-17 00:00:00	2022-01-26 00:00:00	2021-10-19 00:00:00	2022-10-12 00:00:00
sig_loc	None	None	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA
sig_naml	GARNER	THOMAS	THOMAS	THOMAS	THOMAS	THOMAS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS
sig_namf	ERIC L.	WILLIAM	WILLIAM J.	WILLIAM J.	WILLIAM J.	WILLIAM J.	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS
sig_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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
prn_naml	GARNER	THOMAS	THOMAS	THOMAS	THOMAS	THOMAS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS	DEVERS
prn_namf	ERIC L.	WILLIAM	WILLIAM J.	WILLIAM J.	WILLIAM J.	WILLIAM J.	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS	SYRUS
prn_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
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
sig_title	MANAGING PARTNER	OF COUNSEL	OF COUNSEL	ATTORNEY	ATTORNEY & AGENT FOR FILER	ATTORNEY	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS	DIRECTOR, GOVERNMENTAL AFFAIRS
stmt_firm	None	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	None	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP
ind_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
bus_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
trade_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
oth_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
a_b_name	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
a_b_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
a_b_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
a_b_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
descrip_1	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
descrip_2	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
c_less50	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
ind_class	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
ind_descr	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bus_class	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bus_descr	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
auth_name	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
auth_city	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
auth_st	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
auth_zip4	None	None	None	None	None	None	None	None	None	None	None	None	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_int	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
influen_yn	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
firm_name	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
newcert_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
rencert_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
complet_dt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
lby_reg_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
lby_604_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
st_leg_yn	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
l_firm_cb	None	None	None	None	X	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None

Table: filer_address
filer_id	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845
adrid	2102281	2166099	2204609	2412282	2549086	2227877	2465414	2278602	2373218	2506876
effect_dt	2006-04-01 00:00:00	2009-01-01 00:00:00	2011-01-01 00:00:00	2017-01-01 00:00:00	2023-01-01 00:00:00	2011-12-05 00:00:00	2019-01-01 00:00:00	2013-01-01 00:00:00	2015-08-10 00:00:00	2021-01-01 00:00:00
add_type	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051
session_id	2005	2009	2011	2017	2023	2011	2019	2013	2015	2021

Table: filer_filings
filer_id	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845
filing_id	1165772	1169273	1191446	1217070	1225189	1227537	1227539	1238636	1632844	1655967	1679467	1709815	1766021	1784583	1780606	1771932	1771935	1622466	1872199	1844420	1801285	1809129	1809129	1790444	1387162	1434472	1420326	1408798	1433674	1462071	1451879	1451879	1483591	1504907	1537362	1555156	1571316	1589944	1602051	1625243	1622466	1624012	1632844	1655967	1645778	1679552	1679467	1814246	1809129	1824606	1817937	1709815	1876478	1736974	1732170	1766021	1996352	1986859	1988712	2334523	2339026	2334523	2191602	2566866	2186417	2547933	2439269	2334523	2115521	2380984	2334523	2407907	2348236	2259632	2498358	2418081	2115521	2197225	1986859	2018438	2018447	1986859	2010500	2018421	1986859	2038045	2010500	1986859	2064547	2042196	1986859	1986859	2102328	2127577	2108381	2115521	2115521	2140635	2135240	2175256	2115521	2127577	2164931	2115521	2157877	2102328	2158318	1986859	2164044	2191602	2208969	2276493	2397410	2180973	2364916	2320523	2334523	2334523	2115521	2465545	2208969	2240145	2482925	2387735	2539033	2115521	2474552	2469609	2469609	2208969	2240145	2334523	2259226	2259241	2222668	2507755	2641576	2641576	2631847	2539033	2650022	2628674	2693864	2578712	2674508	2482925	2527928	2621960	2539033	2599725	2621960	2599725	2621960	2599725	2703927	2539033	2539033	2655486	2578712	2539033	2539033	2746134
period_id	None	None	186	187	188	None	None	188	208	209	210	211	213	None	214	None	None	207	219	217	215	212	217	None	196	198	197	None	None	200	199	199	201	202	203	None	204	205	206	None	207	None	208	209	None	None	210	None	217	None	216	211	None	212	None	213	223	223	None	238	None	242	231	None	None	244	240	243	232	237	236	None	236	None	None	239	231	None	225	None	None	225	224	None	225	225	224	226	226	None	228	228	227	228	None	228	229	None	None	230	231	228	None	230	229	227	None	230	None	231	232	234	238	None	None	235	243	239	235	None	232	233	242	None	245	233	None	241	241	232	233	241	None	None	None	None	248	248	None	250	None	None	None	245	249	242	243	247	249	246	247	246	247	246	250	246	248	None	245	249	252	251
form_id	F601	F999	F625	F625	F606	F605	F606	F625	F625	F625	F625	F625	F625	F607	F625	F605	F605	F625	F607	F625	F625	F601	F601	F666	F601	F625	F625	F601	F605	F625	F625	F625	F625	F625	F625	F601	F625	F625	F625	F605	F625	F605	F625	F625	F605	F605	F625	F605	F601	F605	F625	F625	F607	F625	F601	F625	F625	F601	F601	F601	F601	F601	F625	F601	F605	F625	F625	F601	F601	F625	F601	F605	F625	F602	F605	F625	F601	F605	F601	F605	F605	F601	F625	F605	F601	F625	F625	F601	F625	F605	F601	F601	F625	F625	F605	F601	F601	F605	F601	F625	F601	F625	F605	F601	F625	F625	F605	F601	F605	F625	F625	F625	F625	F605	F605	F625	F601	F601	F601	F605	F625	F625	F625	F605	F601	F601	F605	F625	F625	F625	F625	F601	F605	F605	F605	F605	F625	F625	F605	F601	F605	F605	F605	F625	F625	F625	F625	F625	F601	F625	F625	F625	F625	F625	F625	F601	F601	F605	F625	F601	F601	F625
filing_sequence	0	0	0	0	0	0	0	0	1	1	1	1	1	0	0	0	0	1	0	0	0	0	1	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	0	0	0	0	0	0	0	0	0	1	0	4	1	0	0	0	0	6	5	0	0	0	0	0	0	0	4	0	2	0	0	3	0	0	1	0	1	4	0	0	5	6	0	0	0	0	1	0	0	0	3	1	0	2	0	1	0	7	0	0	0	0	0	0	0	0	5	2	7	0	1	0	0	0	0	6	0	0	1	2	1	3	0	0	0	0	1	0	0	5	0	0	0	1	0	1	0	2	4	1	1	2	0	0	0	1	2	0	0	3	6	0
filing_date	2006-04-26 00:00:00	2006-05-08 00:00:00	2006-07-31 00:00:00	2006-10-31 00:00:00	2006-12-29 00:00:00	2007-01-05 00:00:00	2007-01-05 00:00:00	2007-01-31 00:00:00	2013-05-20 00:00:00	2013-05-20 00:00:00	2013-05-20 00:00:00	2013-05-20 00:00:00	2013-07-30 00:00:00	2013-07-23 00:00:00	2013-07-30 00:00:00	2013-04-23 00:00:00	2013-04-30 00:00:00	2013-05-20 00:00:00	2014-07-31 00:00:00	2014-04-30 00:00:00	2013-10-31 00:00:00	2014-01-08 00:00:00	2014-01-08 00:00:00	2013-08-30 00:00:00	2008-12-31 00:00:00	2009-07-28 00:00:00	2009-04-29 00:00:00	2008-12-30 00:00:00	2009-03-12 00:00:00	2010-01-28 00:00:00	2010-01-28 00:00:00	2009-10-30 00:00:00	2010-04-28 00:00:00	2010-07-29 00:00:00	2010-10-28 00:00:00	2010-12-28 00:00:00	2011-01-31 00:00:00	2011-04-29 00:00:00	2011-07-21 00:00:00	2011-11-15 00:00:00	2011-10-31 00:00:00	2011-10-28 00:00:00	2012-01-27 00:00:00	2012-04-27 00:00:00	2012-02-01 00:00:00	2012-07-31 00:00:00	2012-07-31 00:00:00	2014-01-02 00:00:00	2014-01-31 00:00:00	2014-02-03 00:00:00	2014-01-31 00:00:00	2012-10-31 00:00:00	2014-08-08 00:00:00	2013-01-30 00:00:00	2012-12-31 00:00:00	2013-04-30 00:00:00	2015-10-29 00:00:00	2015-08-24 00:00:00	2015-08-21 00:00:00	2019-06-11 00:00:00	2019-01-10 00:00:00	2020-06-03 00:00:00	2018-05-01 00:00:00	2020-12-30 00:00:00	2017-10-03 00:00:00	2021-01-27 00:00:00	2020-01-30 00:00:00	2020-09-25 00:00:00	2017-11-30 00:00:00	2019-04-30 00:00:00	2019-01-15 00:00:00	2019-08-08 00:00:00	2019-01-31 00:00:00	2018-05-30 00:00:00	2020-08-18 00:00:00	2019-10-30 00:00:00	2017-10-10 00:00:00	2017-11-29 00:00:00	2016-02-19 00:00:00	2016-02-22 00:00:00	2016-02-26 00:00:00	2016-02-25 00:00:00	2016-01-29 00:00:00	2016-02-19 00:00:00	2016-02-08 00:00:00	2016-05-02 00:00:00	2016-04-05 00:00:00	2016-04-05 00:00:00	2016-08-01 00:00:00	2016-05-06 00:00:00	2016-10-30 00:00:00	2016-11-18 00:00:00	2016-10-31 00:00:00	2017-01-30 00:00:00	2016-11-21 00:00:00	2016-12-29 00:00:00	2017-02-22 00:00:00	2017-02-22 00:00:00	2016-12-29 00:00:00	2017-07-31 00:00:00	2017-08-02 00:00:00	2017-05-01 00:00:00	2017-06-22 00:00:00	2017-06-06 00:00:00	2017-05-01 00:00:00	2017-05-01 00:00:00	2017-02-23 00:00:00	2017-06-26 00:00:00	2017-05-11 00:00:00	2017-10-30 00:00:00	2018-01-30 00:00:00	2018-07-31 00:00:00	2019-07-31 00:00:00	2017-08-02 00:00:00	2019-01-04 00:00:00	2018-10-31 00:00:00	2020-08-14 00:00:00	2019-08-09 00:00:00	2018-07-18 00:00:00	2020-04-09 00:00:00	2018-04-28 00:00:00	2018-04-28 00:00:00	2020-07-29 00:00:00	2019-06-10 00:00:00	2020-12-29 00:00:00	2018-03-15 00:00:00	2020-05-29 00:00:00	2020-04-29 00:00:00	2020-10-08 00:00:00	2018-05-01 00:00:00	2018-05-01 00:00:00	2020-04-15 00:00:00	2018-06-01 00:00:00	2018-05-31 00:00:00	2018-03-14 00:00:00	2020-09-22 00:00:00	2022-03-31 00:00:00	2022-01-28 00:00:00	2021-06-30 00:00:00	2022-06-03 00:00:00	2022-02-01 00:00:00	2021-10-26 00:00:00	2022-06-06 00:00:00	2022-02-10 00:00:00	2022-04-29 00:00:00	2020-10-08 00:00:00	2020-10-30 00:00:00	2022-03-31 00:00:00	2022-02-28 00:00:00	2022-01-28 00:00:00	2022-01-28 00:00:00	2022-03-31 00:00:00	2021-10-29 00:00:00	2021-07-29 00:00:00	2022-07-29 00:00:00	2021-06-29 00:00:00	2021-10-25 00:00:00	2022-03-01 00:00:00	2021-04-29 00:00:00	2022-01-31 00:00:00	2022-10-17 00:00:00	2022-10-29 00:00:00
stmnt_type	10005	10005	10001	10001	10001	10005	10005	10001	10002	10002	10002	10002	10002	10005	10001	10006	10006	10002	10001	10001	10001	10001	10002	10005	10001	10001	10001	10005	10006	10001	10002	10001	10001	10001	10001	10005	10001	10001	10001	10006	10001	10006	10001	10001	10006	10005	10001	10006	10002	10006	10001	10001	10005	10001	10005	10001	10001	10001	10005	10002	10001	10002	10002	10001	10005	10001	10001	10002	10002	10001	10001	10005	10001	10005	10005	10001	10002	10006	10002	10005	10005	10002	10001	10005	10002	10001	10002	10002	10001	10005	10002	10002	10001	10001	10005	10001	10002	10006	10005	10001	10002	10002	10005	10002	10001	10002	10005	10002	10006	10001	10001	10001	10001	10006	10005	10001	10002	10002	10002	10005	10002	10001	10001	10005	10001	10002	10005	10001	10002	10002	10002	10002	10006	10006	10006	10002	10002	10001	10002	10002	10002	10005	10005	10002	10001	10002	10001	10002	10002	10002	10002	10002	10001	10001	10001	10002	10002	10002	10001	10002	10002	10001
stmnt_status	11001	11001	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11003	11001	11001	11001	11001	11001	11003	11001	11001	11003	11001	11001	11001	11001	11001	11003	11003
session_id	2005	2005	2005	2005	2007	2007	2007	2005	2011	2011	2011	2011	2013	2011	2013	2013	2013	2011	2013	2013	2013	2013	2013	2011	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2011	2009	2011	2011	2011	2011	2011	2011	2011	2011	2011	2011	2013	2013	2013	2013	2011	2013	2011	2013	2013	2015	2015	2015	2019	2019	2019	2017	2021	2017	2019	2019	2019	2017	2019	2019	2019	2017	2017	2019	2019	2017	2017	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2017	2017	2015	2017	2017	2017	2015	2015	2017	2017	2015	2017	2015	2017	2017	2017	2017	2019	2017	2017	2017	2019	2019	2017	2019	2017	2017	2019	2019	2021	2017	2019	2019	2019	2017	2017	2019	2017	2017	2017	2019	2021	2021	2021	2021	2021	2021	2021	2021	2021	2019	2019	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021
user_id	CFLAGG	CFLAGG	*	*	YRODRIGU	CFLAGG	CFLAGG	YRODRIGU	ASAETERN	ASAETERN	ASAETERN	ASAETERN	ASAETERN	YRODRIGU	ASAETERN	YRODRIGU	YRODRIGU	ASAETERN	YRODRIGU	ASAETERN	ASAETERN	YRODRIGU	YRODRIGU	NLANDERS	YRODRIGU	YRODRIGU	YRODRIGU	JVAZQUEZ	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	CFLAGG	ASAETERN	ASAETERN	YRODRIGU	ASAETERN	ASAETERN	ASAETERN	YRODRIGU	ASAETERN	YRODRIGU	ASAETERN	ASAETERN	YRODRIGU	YRODRIGU	AGLADNEY	YRODRIGU	YRODRIGU	PBANFORD	ASAETERN	ASAETERN	YRODRIGU	ASAETERN	SARRIAGA	ASAETERN	AGLADNEY	YRODRIGU	YRODRIGU	GPEREZ	DMCCASTL	SARRIAGA	AGLADNEY	CVANLIEW	GPEREZ	MKIRKHAM	AGLADNEY	MMERCHANT	YRODRIGU	AGLADNEY	GPEREZ	SARRIAGA	AGLADNEY	YRODRIGU	GPEREZ	AGLADNEY	GPEREZ	YRODRIGU	GPEREZ	GPEREZ	GPEREZ	GPEREZ	AGLADNEY	GPEREZ	GPEREZ	AGLADNEY	AGLADNEY	GPEREZ	AGLADNEY	GPEREZ	YRODRIGU	YRODRIGU	AGLADNEY	AGLADNEY	GPEREZ	YRODRIGU	GPEREZ	YRODRIGU	YRODRIGU	AGLADNEY	YRODRIGU	AGLADNEY	GPEREZ	YRODRIGU	AGLADNEY	AGLADNEY	GPEREZ	GPEREZ	YRODRIGU	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	YRODRIGU	GPEREZ	AGLADNEY	GPEREZ	SARRIAGA	GPEREZ	GPEREZ	AGLADNEY	AGLADNEY	MKIRKHAM	GPEREZ	CVANLIEW	YRODRIGU	SARRIAGA	MKIRKHAM	CAFILER	AGLADNEY	AGLADNEY	GPEREZ	YRODRIGU	YRODRIGU	YRODRIGU	MMERCHANT	CHATRIDGE	CHATRIDGE	CVANLIEW	SARRIAGA	CVANLIEW	SARRIAGA	SARRIAGA	CAFILER	CAFILER	CAFILER	MKIRKHAM	CHATRIDGE	CVANLIEW	MKIRKHAM	CHATRIDGE	CAFILER	CHATRIDGE	MKIRKHAM	CAFILER	CVANLIEW	SARRIAGA	CVANLIEW	MKIRKHAM	CVANLIEW	CAFILER	CAFILER
special_audit	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003
fine_audit	11003	11003	11003	11003	11001	11003	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11003	11001	11003	11001	11003	11003	11001	11001	11003	11003	11001	11003	11003	11001	11003	11003	11001	11003	11001	11003	11003	11003	11003	11001	11003	11003	11001	11001	11003	11001	11003	11001	11001	11001	11001	11003	11001	11003	11001	11001	11001	11001	11001	11003	11001	11001	11001	11003	11003	11001	11001	11001	11001	11001	11001	11003	11001	11003	11003	11003	11003	11001	11001	11001	11003	11003	11003	11003	11001	11003	11001	11001	11003	11003	11003	11003	11003	11001	11001	11003	11003	11003	11003	11003	11003	11003	11003	11001	11001	11003	11001	11001	11003	11001	11001	11003	11003	11003	11003	11001	11003	11003	11003
rpt_start	1900-01-01 00:00:00	1900-01-01 00:00:00	2006-04-01 00:00:00	2006-07-01 00:00:00	2006-12-29 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2006-10-01 00:00:00	2011-10-01 00:00:00	2012-01-01 00:00:00	2012-04-01 00:00:00	2012-07-01 00:00:00	2013-01-01 00:00:00	1900-01-01 00:00:00	2013-04-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2011-07-01 00:00:00	2014-07-31 00:00:00	2014-01-01 00:00:00	2013-07-01 00:00:00	2012-12-31 00:00:00	2014-01-02 00:00:00	2011-01-01 00:00:00	2008-12-31 00:00:00	2009-04-01 00:00:00	2009-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2009-10-01 00:00:00	2009-07-01 00:00:00	2009-07-31 00:00:00	2010-01-01 00:00:00	2010-04-01 00:00:00	2010-07-01 00:00:00	1900-01-01 00:00:00	2010-10-01 00:00:00	2011-01-01 00:00:00	2011-04-01 00:00:00	1900-01-01 00:00:00	2011-07-01 00:00:00	1900-01-01 00:00:00	2011-10-01 00:00:00	2012-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2012-04-01 00:00:00	1900-01-01 00:00:00	2014-01-31 00:00:00	1900-01-01 00:00:00	2013-10-01 00:00:00	2012-07-01 00:00:00	1900-01-01 00:00:00	2012-10-01 00:00:00	1900-01-01 00:00:00	2013-01-01 00:00:00	2015-07-01 00:00:00	2015-08-11 00:00:00	1900-01-01 00:00:00	2019-06-03 00:00:00	1900-01-01 00:00:00	2020-05-07 00:00:00	2017-07-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2020-10-01 00:00:00	2019-10-01 00:00:00	2020-09-08 00:00:00	2017-11-15 00:00:00	2019-01-01 00:00:00	2018-12-31 00:00:00	1900-01-01 00:00:00	2018-10-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2019-07-01 00:00:00	2017-09-13 00:00:00	1900-01-01 00:00:00	2016-02-18 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2016-02-18 00:00:00	2015-10-01 00:00:00	1900-01-01 00:00:00	2016-02-03 00:00:00	2016-01-01 00:00:00	2015-10-01 00:00:00	2016-04-05 00:00:00	2016-04-01 00:00:00	1900-01-01 00:00:00	2016-10-05 00:00:00	2016-11-10 00:00:00	2016-07-01 00:00:00	2016-10-01 00:00:00	1900-01-01 00:00:00	2016-11-10 00:00:00	2017-01-18 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2017-04-01 00:00:00	2017-07-14 00:00:00	2016-10-01 00:00:00	1900-01-01 00:00:00	2017-04-24 00:00:00	2017-01-01 00:00:00	2016-07-01 00:00:00	1900-01-01 00:00:00	2017-06-05 00:00:00	1900-01-01 00:00:00	2017-07-01 00:00:00	2017-10-01 00:00:00	2018-04-01 00:00:00	2019-04-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2018-07-01 00:00:00	2020-07-30 00:00:00	2019-08-01 00:00:00	2018-07-18 00:00:00	1900-01-01 00:00:00	2017-10-01 00:00:00	2018-01-01 00:00:00	2020-04-01 00:00:00	1900-01-01 00:00:00	2021-01-01 00:00:00	2018-03-05 00:00:00	1900-01-01 00:00:00	2020-01-01 00:00:00	2020-01-01 00:00:00	2017-10-01 00:00:00	2018-01-01 00:00:00	2020-03-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2021-10-01 00:00:00	2021-10-01 00:00:00	1900-01-01 00:00:00	2022-05-17 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2021-01-01 00:00:00	2022-01-01 00:00:00	2020-04-01 00:00:00	2020-07-01 00:00:00	2021-07-01 00:00:00	2022-02-14 00:00:00	2021-04-01 00:00:00	2021-07-01 00:00:00	2021-04-01 00:00:00	2021-07-01 00:00:00	2021-04-01 00:00:00	2022-04-01 00:00:00	2021-06-17 00:00:00	2021-10-19 00:00:00	1900-01-01 00:00:00	2021-01-01 00:00:00	2022-01-26 00:00:00	2022-10-12 00:00:00	2022-07-01 00:00:00
rpt_end	1900-01-01 00:00:00	1900-01-01 00:00:00	2006-06-30 00:00:00	2006-09-30 00:00:00	2006-12-29 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2006-12-31 00:00:00	2011-12-31 00:00:00	2012-03-31 00:00:00	2012-06-30 00:00:00	2012-09-30 00:00:00	2013-03-31 00:00:00	1900-01-01 00:00:00	2013-06-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2011-09-30 00:00:00	2014-07-31 00:00:00	2014-03-31 00:00:00	2013-09-30 00:00:00	2012-12-31 00:00:00	2014-01-02 00:00:00	2012-12-31 00:00:00	2008-12-31 00:00:00	2009-06-30 00:00:00	2009-03-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2009-12-31 00:00:00	2009-09-30 00:00:00	2009-09-30 00:00:00	2010-03-31 00:00:00	2010-06-30 00:00:00	2010-09-30 00:00:00	1900-01-01 00:00:00	2010-12-31 00:00:00	2011-03-31 00:00:00	2011-06-30 00:00:00	1900-01-01 00:00:00	2011-09-30 00:00:00	1900-01-01 00:00:00	2011-12-31 00:00:00	2012-03-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2012-06-30 00:00:00	1900-01-01 00:00:00	2014-01-31 00:00:00	1900-01-01 00:00:00	2013-12-31 00:00:00	2012-09-30 00:00:00	1900-01-01 00:00:00	2012-12-31 00:00:00	1900-01-01 00:00:00	2013-03-31 00:00:00	2015-09-30 00:00:00	2015-08-11 00:00:00	1900-01-01 00:00:00	2019-06-03 00:00:00	1900-01-01 00:00:00	2020-05-07 00:00:00	2017-09-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2020-12-31 00:00:00	2019-12-31 00:00:00	2020-09-08 00:00:00	2017-11-15 00:00:00	2019-03-31 00:00:00	2018-12-31 00:00:00	1900-01-01 00:00:00	2018-12-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2019-09-30 00:00:00	2017-09-13 00:00:00	1900-01-01 00:00:00	2016-02-18 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2016-02-18 00:00:00	2015-12-31 00:00:00	1900-01-01 00:00:00	2016-02-03 00:00:00	2016-03-31 00:00:00	2015-12-31 00:00:00	2016-04-05 00:00:00	2016-06-30 00:00:00	1900-01-01 00:00:00	2016-10-05 00:00:00	2016-11-10 00:00:00	2016-09-30 00:00:00	2016-12-31 00:00:00	1900-01-01 00:00:00	2016-11-10 00:00:00	2017-01-18 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2017-06-30 00:00:00	2017-07-14 00:00:00	2016-12-31 00:00:00	1900-01-01 00:00:00	2017-04-24 00:00:00	2017-03-31 00:00:00	2016-09-30 00:00:00	1900-01-01 00:00:00	2017-06-05 00:00:00	1900-01-01 00:00:00	2017-09-30 00:00:00	2017-12-31 00:00:00	2018-06-30 00:00:00	2019-06-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2018-09-30 00:00:00	2020-07-30 00:00:00	2019-08-01 00:00:00	2018-07-18 00:00:00	1900-01-01 00:00:00	2017-12-31 00:00:00	2018-03-31 00:00:00	2020-06-30 00:00:00	1900-01-01 00:00:00	2021-01-01 00:00:00	2018-03-05 00:00:00	1900-01-01 00:00:00	2020-03-31 00:00:00	2020-03-31 00:00:00	2017-12-31 00:00:00	2018-03-31 00:00:00	2020-03-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2021-12-31 00:00:00	2021-12-31 00:00:00	1900-01-01 00:00:00	2022-05-17 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2021-03-31 00:00:00	2022-03-31 00:00:00	2020-06-30 00:00:00	2020-09-30 00:00:00	2021-09-30 00:00:00	2022-02-14 00:00:00	2021-06-30 00:00:00	2021-09-30 00:00:00	2021-06-30 00:00:00	2021-09-30 00:00:00	2021-06-30 00:00:00	2022-06-30 00:00:00	2021-06-17 00:00:00	2021-10-19 00:00:00	1900-01-01 00:00:00	2021-03-31 00:00:00	2022-01-26 00:00:00	2022-10-12 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	None	None	None	None	None	None	None	None	None
filing_type	None	None	22006	22006	22006	None	None	22006	22001	22001	22001	22001	22001	None	22001	None	None	22001	22001	22001	22001	22001	22001	None	22006	22006	22006	None	None	22006	22006	22006	22006	22006	22006	None	22006	22006	22006	None	22006	None	22006	22006	None	None	22006	None	22001	None	22001	22006	None	22006	None	22006	22001	22001	None	22001	None	22001	22001	None	None	22001	22001	22001	22001	22001	22001	None	22001	None	None	22001	22001	None	22001	None	None	22001	22001	None	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	None	22001	22001	None	None	22001	22001	22001	None	22001	22001	22001	None	22001	None	22001	22001	22001	22001	None	None	22001	22001	22001	22001	None	22001	22001	22001	None	22001	22001	None	22001	22001	22001	22001	22001	None	None	None	None	22001	22001	None	22001	None	None	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001

Table: filer_to_filer_type
filer_id	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845
filer_type	3	3	3	3	3	3	3	3	3	3	3
active	Y	T	Y	Y	Y	W	Y	Y	Y	Y	N
race	0	0	None	None	0	None	None	None	None	None	None
session_id	2005	2005	2011	2013	2009	2013	2015	2021	2017	2019	2023
category	0	0	None	None	0	None	None	None	None	None	None
category_type	0	0	None	None	0	None	None	None	None	None	None
sub_category	0	0	None	None	0	None	None	None	None	None	None
effect_dt	2006-04-01 00:00:00	2006-12-31 00:00:00	2011-01-01 00:00:00	2013-01-01 00:00:00	2009-01-01 00:00:00	2013-01-02 00:00:00	2015-08-10 00:00:00	2021-01-01 00:00:00	2017-01-01 00:00:00	2019-01-01 00:00:00	2023-01-01 00:00:00
sub_category_type	0	0	None	None	0	None	None	None	None	None	None
election_type	0	0	None	None	0	None	None	None	None	None	None
sub_category_a	None	None	None	None	None	None	None	None	None	None	None
nyq_dt	2006-04-01 00:00:00	2006-04-01 00:00:00	None	None	2006-04-01 00:00:00	None	None	None	None	None	None
party_cd	0	0	None	None	0	None	None	None	None	None	None
county_cd	0	0	None	None	0	None	None	None	None	None	None
district_cd	0	0	None	None	0	None	None	None	None	None	None

Table: filer_xref
filer_id		1285845
xref_id		1285845
effect_dt		2006-04-27 00:00:00
migration_source		CLAIMS

Table: filername
xref_filer_id	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845
filer_id	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845
filer_type	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM
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
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
naml	BEST BEST & KRIEGER	BEST BEST & KRIEGER	BEST BEST & KRIEGER	BEST BEST & KRIEGER	BEST BEST & KRIEGER	BEST BEST & KRIEGER	BEST BEST & KRIEGER	BEST BEST & KRIEGER	BEST BEST & KRIEGER	BEST BEST & KRIEGER	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER	BEST BEST & KRIEGER	BEST BEST & KRIEGER	BEST BEST & KRIEGER	BEST BEST & KRIEGER	BEST BEST & KRIEGER	BEST BEST & KRIEGER	BEST BEST & KRIEGER	BEST BEST & KRIEGER	BEST BEST & KRIEGER	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP
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
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
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
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
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
city	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO
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
zip4	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814
phon	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000
fax	None	None	9163254010	9163254010	9163254010	9163254010	9163254010	9163254010	9163254010	9163254010	None	None	9163254010	9163254010	9163254010	9163254010	9163254010	9163254010	9163254010	9163254010	None	None	9163254010	9163254010	9163254010	9163254010	9163254010	9163254010	9163254010	9163254010	None	None	9163254010	9163254010	9163254010	9163254010	9163254010	9163254010	9163254010	9163254010	None	None	9163254010	9163254010	9163254010	9163254010	9163254010	9163254010	9163254010	9163254010	None	None	9163254010	9163254010	9163254010	9163254010	9163254010	9163254010	9163254010	9163254010	None	None	9163254010	9163254010	9163254010	9163254010	9163254010	9163254010	9163254010	9163254010	None	None	9163254010	9163254010	9163254010	9163254010	9163254010	9163254010	9163254010	9163254010	None	None	9163254010	9163254010	9163254010	9163254010	9163254010	9163254010	9163254010	9163254010
email	None	None	[email protected]	[email protected]	None	None	None	None	None	None	None	None	[email protected]	[email protected]	None	None	None	None	None	None	None	None	[email protected]	[email protected]	None	None	None	None	None	None	None	None	[email protected]	[email protected]	None	None	None	None	None	None	None	None	[email protected]	[email protected]	None	None	None	None	None	None	None	None	[email protected]	[email protected]	None	None	None	None	None	None	None	None	[email protected]	[email protected]	None	None	None	None	None	None	None	None	[email protected]	[email protected]	None	None	None	None	None	None	None	None	[email protected]	[email protected]	None	None	None	None	None	None

Table: filers
filer_id		1285845

Table: lobbying_chg_log
filer_id	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845
change_no	4	5	2	3	0	1	6	7	9	8	12	10	11	13	15	16	14	24	17	19	18	21	22	23	20	30	26	27	28	25	29	32	33	31
session_id	2005	2005	2005	2005	2005	2005	2009	2009	2011	2011	2013	2011	2013	2013	2013	2013	2013	2015	2015	2015	2015	2015	2015	2015	2015	2017	2015	2017	2017	2017	2017	2019	2019	2017
log_dt	2007-01-05 00:00:00	2007-01-05 00:00:00	2006-04-26 00:00:00	2006-04-26 00:00:00	2006-04-26 00:00:00	2006-04-27 00:00:00	2009-03-12 00:00:00	2010-04-06 00:00:00	2011-11-15 00:00:00	2011-10-28 00:00:00	2014-02-03 00:00:00	2012-07-31 00:00:00	2014-01-02 00:00:00	2014-08-08 00:00:00	2014-08-08 00:00:00	2014-08-08 00:00:00	2014-08-08 00:00:00	2016-11-21 00:00:00	2015-08-21 00:00:00	2015-08-21 00:00:00	2015-08-21 00:00:00	2016-02-26 00:00:00	2016-02-22 00:00:00	2016-02-19 00:00:00	2016-05-06 00:00:00	2017-10-03 00:00:00	2017-06-22 00:00:00	2017-05-11 00:00:00	2017-05-11 00:00:00	2017-02-23 00:00:00	2017-08-02 00:00:00	2020-04-09 00:00:00	2020-08-18 00:00:00	2019-01-04 00:00:00
filer_type	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3
correction_flg	None	None	None	None	None	None	Y	Y	None	None	Y	None	None	None	None	None	None	None	Y	Y	Y	Y	Y	Y	Y	Y	None	Y	Y	Y	Y	None	None	None
action	DELETED	TERMINATED	SET ACTIVE	SET ACTIVE	ADDED	IN SUSPENSE	ADDED	TERMINATED	SET ACTIVE	ADDED	DELETED	ADDED	DELETED	DELETED	DELETED	WITHDRAWAL	DELETED	SET ACTIVE	ADDED	ADDED	ADDED	ADDED	ADDED	ADDED	DELETED	ADDED	DELETED	ADDED	ADDED	ADDED	ADDED	DELETED	DELETED	SET ACTIVE
attribute_changed	LOBBYIST		CLIENT	CLIENT	LOBBYIST		LOBBYIST	LOBBYIST	CLIENT	CLIENT	EMPLOYER	CLIENT	CLIENT	CLIENT	LOBBYIST		CLIENT	CLIENT	LOBBYIST	EMPLOYER	LOBBYIST	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	CLIENT	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	CLIENT	CLIENT	CLIENT
ethics_dt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
interests	None	None	None	None	None	None	None	None	None	None	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_full_name	BEST BEST & KRIEGER	BEST BEST & KRIEGER	BEST BEST & KRIEGER	BEST BEST & KRIEGER	BEST BEST & KRIEGER	BEST BEST & KRIEGER	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER	BEST BEST & KRIEGER	BEST BEST & KRIEGER	BEST BEST & KRIEGER	BEST BEST & KRIEGER	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP	BEST BEST & KRIEGER LLP
filer_city	None	None	None	None	None	None	SACRAMENTO	SACRAMENTO	None	None	None	None	None	None	None	None	None	None	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	None	None	None	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	None	None	None
filer_st	None	None	None	None	None	None	CA	CA	None	None	None	None	None	None	None	None	None	None	CA	CA	CA	CA	CA	CA	None	None	None	CA	CA	CA	CA	None	None	None
filer_zip	None	None	None	None	None	None	95814	95814	None	None	None	None	None	None	None	None	None	None	95814	95814	95814	95814	95814	95814	None	None	None	95814	95814	95814	95814	None	None	None
filer_phone	None	None	None	None	None	None	9163254000	9163254000	None	None	None	None	None	None	None	None	None	None	9163254000	9163254000	9163254000	9163254000	9163254000	9163254000	None	None	None	9163254000	9163254000	9163254000	9163254000	None	None	None
entity_type	4	3	1	1	4	3	4	4	1	1	2	1	1	1	4	3	1	1	4	2	4	2	2	2	2	2	1	2	2	2	2	1	1	1
entity_name	WILLIAM J. THOMAS	None	ALLIANCE OF THE METHYL BROMIDE INDUSTRY	SOUTHERN SAN JOAQUIN VALLEY WATER QUALITY COALITION	WILLIAM J. THOMAS	None	VAN RUITEN, ANTHONY J.	VAN RUITEN, ANTHONY J.	CALIFORNIA ASSOCIATION OF RESOURCE CONSERVATION DISTRICTS	CALIFORNIA ASSOCIATION OF RESOURCE CONSERVATION DISTRICTS	CALIFORNIA ASSOCIATION OF RESOURCE CONSERVATION DISTRICTS	SALTON SEA AUTHORITY	ALLIANCE OF THE METHYL BROMIDE INDUSTRY	SALTON SEA AUTHORITY	WILLIAM J. THOMAS	None	SOUTHERN SAN JOAQUIN VALLEY WATER QUALITY COALITION	LAS VIRGENES - TRIUNFO JOINT POWERS AUTHORITY	THOMAS, WILLIAM J.	SAN GORGONIO PASS WATER AGENCY	DEVERS, SYRUS	LOS ANGELES; COUNTY OF	MUNICIPAL WATER DISTRICT OF ORANGE COUNTY	FALCON WATERFREE TECHNOLOGIES	LOS ANGELES; COUNTY OF	WESTERN RIVERSIDE COUNCIL OF GOVERNMENTS	FALCON WATERFREE TECHNOLOGIES	PASO ROBLES; CITY OF	SACRAMENTO METROPOLITAN CABLE TV COMMISSION	ONTARIO; CITY OF	SANTA CLARA DBA SILICON VALLEY POWER; CITY OF	RANCHO GUEJITO CORPORATION	ELSINORE VALLEY MUNICIPAL WATER DISTRICT	OMNITRANS - SAN BERNARDINO COUNTY PUBLIC TRANSIT
entity_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
entity_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
entity_zip	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
entity_phone	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
entity_id	1147925	0	1145843	1256009	1147925	0	None	None	1143667	1143667	1143667	1277180	1145843	1277180	1147925	0	1256009	1392296	None	None	None	None	None	None	1146830	1333933	1298878	None	None	None	None	1411217	1146367	1415119
responsible_officer	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
effect_dt	2006-12-31 00:00:00	2006-12-31 00:00:00	2006-04-01 00:00:00	2006-04-01 00:00:00	2006-04-01 00:00:00	2006-04-01 00:00:00	2009-03-13 00:00:00	2010-03-31 00:00:00	2011-08-01 00:00:00	2011-08-01 00:00:00	2013-12-31 00:00:00	2012-04-01 00:00:00	2013-12-17 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-02 00:00:00	2013-01-01 00:00:00	2016-10-01 00:00:00	2015-08-10 00:00:00	2015-08-10 00:00:00	2015-08-10 00:00:00	2016-01-15 00:00:00	2016-01-15 00:00:00	2016-01-18 00:00:00	2016-03-31 00:00:00	2017-09-12 00:00:00	2016-06-27 00:00:00	2017-04-14 00:00:00	2017-04-03 00:00:00	2017-01-10 00:00:00	2017-07-14 00:00:00	2020-01-31 00:00:00	2020-07-22 00:00:00	2018-11-28 00:00:00

Table: received_filings
filer_id	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845	1285845
filing_file_name	218388.cal	218477.cal	239716.cal	1809129_2.cal	1809129_0.cal	1809129_1.cal	158075.cal	1986859_0.cal	2115521_1.cal	34289.cal	122517.cal	1986859_6.cal	243361.cal	1986859_1.cal	242472.cal	1986859_2.cal	242192.cal	391942.cal	1986859_4.cal	2115521_0.cal	1986859_5.cal	5393.cal	6073.cal	6290.cal	1986859_7.cal	2115521_3.cal	309115.cal	2115521_2.cal	67003.cal	490273.cal	191030.cal	490100.cal	490058.cal	2115521_5.cal	2334523_0.cal	241683.cal	374928.cal	2115521_4.cal	105911.cal	2334523_1.cal	2334523_5.cal	2334523_4.cal	2334523_3.cal	2115521_6.cal	157169.cal	2334523_2.cal	2334523_6.cal	2539033_4.cal	2539033_1.cal	2539033_2.cal	2539033_0.cal	2539033_5.cal	518561.cal	2539033_6.cal	518395.cal	2539033_3.cal
received_date	2014-04-29 00:00:00	2014-04-29 00:00:00	2014-04-30 00:00:00	2014-01-31 00:00:00	2014-01-08 00:00:00	2014-01-08 00:00:00	2015-08-24 00:00:00	2015-08-24 00:00:00	2017-02-22 00:00:00	2017-01-30 00:00:00	2016-11-18 00:00:00	2016-11-18 00:00:00	2016-02-08 00:00:00	2016-02-08 00:00:00	2016-02-08 00:00:00	2016-02-19 00:00:00	2016-02-08 00:00:00	2016-02-19 00:00:00	2016-04-05 00:00:00	2016-12-29 00:00:00	2016-10-30 00:00:00	2016-05-02 00:00:00	2016-05-02 00:00:00	2016-05-02 00:00:00	2017-06-26 00:00:00	2017-08-02 00:00:00	2017-08-02 00:00:00	2017-06-06 00:00:00	2017-06-06 00:00:00	2017-05-01 00:00:00	2017-05-16 00:00:00	2017-05-01 00:00:00	2017-05-01 00:00:00	2017-11-30 00:00:00	2019-01-15 00:00:00	2018-07-31 00:00:00	2018-07-18 00:00:00	2017-10-10 00:00:00	2019-01-12 00:00:00	2019-06-11 00:00:00	2020-08-14 00:00:00	2020-06-03 00:00:00	2020-04-15 00:00:00	2018-03-15 00:00:00	2019-08-09 00:00:00	2019-08-09 00:00:00	2020-09-25 00:00:00	2022-02-28 00:00:00	2021-06-29 00:00:00	2021-10-25 00:00:00	2020-12-29 00:00:00	2022-06-03 00:00:00	2020-10-08 00:00:00	2022-10-17 00:00:00	2020-10-08 00:00:00	2022-01-31 00:00:00
filing_directory	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/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/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal
filing_id	None	None	None	1809129	1809129	1809129	None	1986859	2115521	None	None	1986859	None	1986859	None	1986859	None	None	1986859	2115521	1986859	None	None	None	1986859	2115521	None	2115521	None	None	None	None	None	2115521	2334523	None	None	2115521	None	2334523	2334523	2334523	2334523	2115521	None	2334523	2334523	2539033	2539033	2539033	2539033	2539033	None	2539033	None	2539033
form_id	None	None	None	F601	F601	F601	None	F601	F601	None	None	F601	None	F601	None	F601	None	None	F601	F601	F601	None	None	None	F601	F601	None	F601	None	None	None	None	None	F601	F601	None	None	F601	None	F601	F601	F601	F601	F601	None	F601	F601	F601	F601	F601	F601	F601	None	F601	None	F601
receive_comment	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing accepted	Filing passed validation, but failed DB constraints	Filing accepted	Filing passed validation, but failed DB constraints	Filing accepted	Filing did not pass validation	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	Filing did not pass validation	Filing did not pass validation	Filing accepted	Filing accepted	Filing did not pass validation	Filing accepted	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing did not pass validation	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	Filing did not pass validation	Filing accepted	Filing did not pass validation	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 passed validation, but failed DB constraints	Filing accepted	Filing passed validation, but failed DB constraints	Filing accepted