OpenCalAccess

Filer ID: 1222890

Table: cvr_lobby_disclosure
filing_id	679583	719789	746328	770136	792112	813277	839467	852848	883579	911018	930240	945941	968194	990174	1014086	1014086	1030526	1055856	1080209	1168094	1132555	1104513	1148117	1118290	1280058	1192102	1238471	1259906	1238471	1216519	1192102	1216519	1293462	1348264	1330280	1306032	1306032	1420428	1375878	1448217	1391284	1433938	1485339	1503606	1464913	1538558	1567817	1618179	1602230	1590157	1706845	1672495	1672495	1637754	1658127	1658127	1733791	1797714	1776967	1762017	1762017	1797714	1817022	1871980	1871980	1929174	1912355	1845891	1845891	1929174	1912355	1979077	1964881	1964881	1912355	1929174	1912355	1929174	1929174	1995150	2061392	2036577	2009115	2009115	2092989	2092989	2169663	2154491	2154491	2127534	2127534	2127534	2127534	2192283	2241088	2208441	2272733	2315530	2397167	2381447	2349173	2443952	2417356	2471816	2554425	2471816	2471816	2487929	2519073	2624104	2581485	2487929	2604068	2519073	2677570	2645734	2707627	2749394
amend_id	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	1	1	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	1	0	0	0	0	1	0	1	0	0	1	0	1	1	0	1	0	0	0	1	2	3	3	4	2	0	0	0	0	1	1	0	0	1	0	1	2	0	3	0	0	0	0	0	0	0	0	0	0	0	0	1	2	0	0	0	0	1	0	1	0	0	0	0
rec_type	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	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	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	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890
filer_id	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890
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	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	KNUDSEN MICHAEL B.	KNUDSEN MICHAEL B.	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES
filer_namf	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
filer_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
filer_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
report_num	000	000	000	000	000	000	000	000	000	000	000	000	000	000	001	000	000	000	000	000	000	000	000	000	000	000	001	000	000	000	001	001	000	000	000	001	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	001	000	001	000	000	000	000	001	000	001	000	000	001	000	001	001	000	001	000	000	000	001	002	003	003	004	002	000	000	000	000	001	001	000	000	001	000	001	002	000	003	000	000	000	000	000	000	000	000	000	000	000	000	001	002	000	000	000	000	001	000	001	000	000	000	000
rpt_date	2000-10-27 00:00:00	2001-01-31 00:00:00	2001-04-30 00:00:00	2001-07-31 00:00:00	2001-10-31 00:00:00	2002-01-31 00:00:00	2002-04-30 00:00:00	2002-07-23 00:00:00	2002-10-23 00:00:00	2003-01-29 00:00:00	2003-04-29 00:00:00	2003-07-29 00:00:00	2003-10-28 00:00:00	2004-02-02 00:00:00	2004-04-30 00:00:00	2004-04-30 00:00:00	2004-07-30 00:00:00	2004-10-28 00:00:00	2005-01-31 00:00:00	2006-05-01 00:00:00	2005-10-28 00:00:00	2005-04-29 00:00:00	2006-01-31 00:00:00	2005-08-01 00:00:00	2007-07-25 00:00:00	2006-07-31 00:00:00	2007-06-26 00:00:00	2007-04-26 00:00:00	2007-01-31 00:00:00	2006-10-31 00:00:00	2007-08-29 00:00:00	2007-09-06 00:00:00	2007-10-18 00:00:00	2008-07-29 00:00:00	2008-04-30 00:00:00	2008-01-24 00:00:00	2008-01-24 00:00:00	2009-04-29 00:00:00	2008-10-30 00:00:00	2009-10-19 00:00:00	2009-01-23 00:00:00	2009-07-27 00:00:00	2010-04-30 00:00:00	2010-07-27 00:00:00	2010-02-01 00:00:00	2010-10-29 00:00:00	2011-01-27 00:00:00	2011-10-19 00:00:00	2011-07-22 00:00:00	2011-04-29 00:00:00	2012-10-29 00:00:00	2012-07-18 00:00:00	2012-07-18 00:00:00	2012-01-31 00:00:00	2012-04-30 00:00:00	2012-04-30 00:00:00	2013-01-28 00:00:00	2013-10-28 00:00:00	2013-07-22 00:00:00	2013-04-26 00:00:00	2013-04-25 00:00:00	2013-12-16 00:00:00	2014-01-30 00:00:00	2014-07-31 00:00:00	2014-10-18 00:00:00	2015-01-23 00:00:00	2015-01-23 00:00:00	2014-06-13 00:00:00	2014-04-30 00:00:00	2015-01-27 00:00:00	2014-10-31 00:00:00	2015-07-29 00:00:00	2015-04-30 00:00:00	2015-07-28 00:00:00	2015-03-13 00:00:00	2015-03-13 00:00:00	2015-03-19 00:00:00	2015-03-19 00:00:00	2015-03-05 00:00:00	2015-10-28 00:00:00	2016-07-29 00:00:00	2016-04-29 00:00:00	2016-01-28 00:00:00	2016-02-12 00:00:00	2016-10-24 00:00:00	2016-10-21 00:00:00	2017-07-21 00:00:00	2017-07-21 00:00:00	2017-04-27 00:00:00	2017-01-30 00:00:00	2017-01-31 00:00:00	2017-01-30 00:00:00	2017-01-31 00:00:00	2017-10-30 00:00:00	2018-04-30 00:00:00	2018-01-30 00:00:00	2018-07-30 00:00:00	2018-10-29 00:00:00	2019-07-30 00:00:00	2019-04-30 00:00:00	2019-01-31 00:00:00	2020-01-31 00:00:00	2019-10-29 00:00:00	2020-04-30 00:00:00	2021-01-31 00:00:00	2020-08-25 00:00:00	2020-09-09 00:00:00	2020-07-31 00:00:00	2020-10-20 00:00:00	2021-10-29 00:00:00	2021-04-27 00:00:00	2021-08-19 00:00:00	2021-07-31 00:00:00	2021-10-22 00:00:00	2022-04-30 00:00:00	2022-01-29 00:00:00	2022-07-31 00:00:00	2022-10-31 00:00:00
from_date	2000-07-01 00:00:00	2000-10-01 00:00:00	2001-01-01 00:00:00	2001-04-01 00:00:00	2001-07-01 00:00:00	2001-10-01 00:00:00	2002-01-01 00:00:00	2002-04-01 00:00:00	2002-07-01 00:00:00	2002-10-01 00:00:00	2003-01-01 00:00:00	2003-04-01 00:00:00	2003-07-01 00:00:00	2003-10-01 00:00:00	2004-01-01 00:00:00	2004-01-01 00:00:00	2004-04-01 00:00:00	2004-07-01 00:00:00	2004-10-01 00:00:00	2006-01-01 00:00:00	2005-07-01 00:00:00	2005-01-01 00:00:00	2005-10-01 00:00:00	2005-04-01 00:00:00	2007-04-01 00:00:00	2006-04-01 00:00:00	2006-10-01 00:00:00	2007-01-01 00:00:00	2006-10-01 00:00:00	2006-07-01 00:00:00	2006-04-01 00:00:00	2006-07-01 00:00:00	2007-07-01 00:00:00	2008-04-01 00:00:00	2008-01-01 00:00:00	2007-10-01 00:00:00	2008-10-01 00:00:00	2009-01-01 00:00:00	2008-07-01 00:00:00	2009-07-01 00:00:00	2008-10-01 00:00:00	2009-04-01 00:00:00	2010-01-01 00:00:00	2010-04-01 00:00:00	2009-10-01 00:00:00	2010-07-01 00:00:00	2010-10-01 00:00:00	2011-07-01 00:00:00	2011-04-01 00:00:00	2011-01-01 00:00:00	2012-07-01 00:00:00	2012-04-01 00:00:00	2012-04-01 00:00:00	2011-10-01 00:00:00	2012-01-01 00:00:00	2012-01-01 00:00:00	2012-10-01 00:00:00	2013-01-07 00:00:00	2013-04-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-07-01 00:00:00	2013-10-01 00:00:00	2014-04-01 00:00:00	2014-04-01 00:00:00	2014-10-01 00:00:00	2014-07-01 00:00:00	2014-01-01 00:00:00	2014-01-01 00:00:00	2014-10-01 00:00:00	2014-07-01 00:00:00	2015-04-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2014-07-01 00:00:00	2014-10-01 00:00:00	2014-07-01 00:00:00	2014-10-01 00:00:00	2014-10-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	2016-07-01 00:00:00	2017-04-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2016-10-01 00:00:00	2016-10-01 00:00:00	2016-10-01 00:00:00	2016-10-01 00:00:00	2017-07-01 00:00:00	2018-01-01 00:00:00	2017-10-01 00:00:00	2018-04-01 00:00:00	2018-07-01 00:00:00	2019-04-01 00:00:00	2019-01-01 00:00:00	2018-10-01 00:00:00	2019-10-01 00:00:00	2019-07-01 00:00:00	2020-01-01 00:00:00	2020-10-01 00:00:00	2020-01-01 00:00:00	2020-01-01 00:00:00	2020-04-01 00:00:00	2020-07-01 00:00:00	2021-07-01 00:00:00	2021-01-01 00:00:00	2020-04-01 00:00:00	2021-04-01 00:00:00	2020-07-01 00:00:00	2022-01-01 00:00:00	2021-10-01 00:00:00	2022-04-01 00:00:00	2022-07-01 00:00:00
thru_date	2000-09-30 00:00:00	2000-12-31 00:00:00	2001-03-31 00:00:00	2001-06-30 00:00:00	2001-09-30 00:00:00	2001-12-31 00:00:00	2002-03-31 00:00:00	2002-06-30 00:00:00	2002-09-30 00:00:00	2002-12-31 00:00:00	2003-03-31 00:00:00	2003-06-30 00:00:00	2003-09-30 00:00:00	2003-12-31 00:00:00	2004-03-31 00:00:00	2004-03-31 00:00:00	2004-06-30 00:00:00	2004-09-30 00:00:00	2004-12-31 00:00:00	2006-03-31 00:00:00	2005-09-30 00:00:00	2005-03-31 00:00:00	2005-12-31 00:00:00	2005-06-30 00:00:00	2007-06-30 00:00:00	2006-06-30 00:00:00	2006-12-31 00:00:00	2007-03-31 00:00:00	2006-12-31 00:00:00	2006-09-30 00:00:00	2006-06-30 00:00:00	2006-09-30 00:00:00	2007-09-30 00:00:00	2008-06-30 00:00:00	2008-03-31 00:00:00	2007-12-31 00:00:00	2008-12-31 00:00:00	2009-03-31 00:00:00	2008-09-30 00:00:00	2009-09-30 00:00:00	2008-12-31 00:00:00	2009-06-30 00:00:00	2010-03-31 00:00:00	2010-06-30 00:00:00	2009-12-31 00:00:00	2010-09-30 00:00:00	2010-12-31 00:00:00	2011-09-30 00:00:00	2011-06-30 00:00:00	2011-03-31 00:00:00	2012-09-30 00:00:00	2012-06-30 00:00:00	2012-06-30 00:00:00	2011-12-31 00:00:00	2012-03-31 00:00:00	2012-03-31 00:00:00	2012-12-31 00:00:00	2013-09-30 00:00:00	2013-06-30 00:00:00	2013-03-31 00:00:00	2013-03-31 00:00:00	2013-09-30 00:00:00	2014-12-31 00:00:00	2014-06-30 00:00:00	2014-06-30 00:00:00	2014-12-31 00:00:00	2014-09-30 00:00:00	2014-03-31 00:00:00	2014-03-31 00:00:00	2014-12-31 00:00:00	2014-09-30 00:00:00	2015-06-30 00:00:00	2015-03-31 00:00:00	2015-03-31 00:00:00	2014-09-30 00:00:00	2014-12-31 00:00:00	2014-09-30 00:00:00	2014-12-31 00:00:00	2014-12-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	2016-09-30 00:00:00	2017-06-30 00:00:00	2017-03-31 00:00:00	2017-03-31 00:00:00	2016-12-31 00:00:00	2016-12-31 00:00:00	2016-12-31 00:00:00	2016-12-31 00:00:00	2017-09-30 00:00:00	2018-03-31 00:00:00	2017-12-31 00:00:00	2018-06-30 00:00:00	2018-09-30 00:00:00	2019-06-30 00:00:00	2019-03-31 00:00:00	2018-12-31 00:00:00	2019-12-31 00:00:00	2019-09-30 00:00:00	2020-03-31 00:00:00	2020-12-31 00:00:00	2020-03-31 00:00:00	2020-03-31 00:00:00	2020-07-31 00:00:00	2020-09-30 00:00:00	2021-09-30 00:00:00	2021-03-31 00:00:00	2020-06-30 00:00:00	2021-06-30 00:00:00	2020-09-30 00:00:00	2022-03-31 00:00:00	2021-12-31 00:00:00	2022-06-30 00:00:00	2022-09-30 00:00:00
cum_beg_dt	1999-01-01 00:00:00	1999-01-01 00:00:00	2001-01-01 00:00:00	2001-01-01 00:00:00	2001-01-01 00:00:00	2001-01-01 00:00:00	2001-01-01 00:00:00	2001-01-01 00:00:00	2001-01-01 00:00:00	2001-01-01 00:00:00	2003-01-01 00:00:00	2003-01-01 00:00:00	2003-01-01 00:00:00	2003-01-01 00:00:00	2003-01-01 00:00:00	2003-01-01 00:00:00	2003-01-01 00:00:00	2003-01-01 00:00:00	2003-01-01 00:00:00	2005-01-01 00:00:00	2005-01-01 00:00:00	2005-01-01 00:00:00	2005-01-01 00:00:00	2005-01-01 00:00:00	2007-01-01 00:00:00	2005-01-01 00:00:00	2005-01-01 00:00:00	2007-01-01 00:00:00	2005-01-01 00:00:00	2005-01-01 00:00:00	2005-01-01 00:00:00	2005-01-01 00:00:00	2007-01-01 00:00:00	2007-01-01 00:00:00	2007-01-01 00:00:00	2007-01-01 00:00:00	2007-01-01 00:00:00	2009-01-01 00:00:00	2007-01-01 00:00:00	2009-01-01 00:00:00	2007-01-01 00:00:00	2009-01-01 00:00:00	2009-01-01 00:00:00	2009-01-01 00:00:00	2009-01-01 00:00:00	2009-01-01 00:00:00	2009-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2017-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	2015-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2017-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2019-01-01 00:00:00	2021-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
firm_id	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	None	1222890	1222890	1222890	1222890	None	None	1222890	None	1222890	None	None	None	None
firm_name	KNUDSEN MICHAEL B.	KNUDSEN MICHAEL B.	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	None	KNUDSEN & ASSOCIATES	None	None	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	KNUDSEN & ASSOCIATES	None	None	None	None	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	None	KNUDSEN & ASSOCIATES	None	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES
firm_city	Sacramento	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO
firm_st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA
firm_zip4	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814
firm_phon	916-446-7100	916-446-7100	(916) 448-7500	(916) 448-7500	(916) 448-7500	(916) 448-7500	(916) 448-7500	(916) 448-7500	(916) 448-7500	(916) 448-7500	916-442-7500	916-442-7500	916-442-7500	916-442-7500	916-442-7500	916-442-7500	916-442-7500	916-442-7500	916-442-7500	916-448-7500	916-448-7500	916-442-7500	916-448-7500	916-448-7500	9164487500	916-448-7500	9164487500	9164487500	916-448-7500	916-448-7500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	916-448-7500	9164487500	9164487500	9164487500	9164487500	916-448-7500	916-448-7500	9164487500	916-448-7500	9164487500	916-448-7500	916-448-7500	916-448-7500	916-448-7500
mail_city	Newcastle	Newcastle	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	CA	CA	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	95658	95658	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	916-663-2535	916-663-2535	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
sig_date	2000-10-27 00:00:00	2001-01-31 00:00:00	2001-04-27 00:00:00	2001-07-27 00:00:00	2001-10-26 00:00:00	2002-01-28 00:00:00	2002-04-24 00:00:00	2002-07-23 00:00:00	2002-10-23 00:00:00	2003-01-29 00:00:00	None	None	None	None	None	None	None	None	None	2006-04-28 00:00:00	2005-10-28 00:00:00	2005-04-28 00:00:00	2006-01-31 00:00:00	2005-07-29 00:00:00	2007-07-25 00:00:00	2006-07-31 00:00:00	2007-06-26 00:00:00	2007-04-26 00:00:00	2007-01-30 00:00:00	2006-10-30 00:00:00	2007-08-29 00:00:00	2007-09-06 00:00:00	2007-10-18 00:00:00	2008-07-29 00:00:00	2008-04-30 00:00:00	2008-01-24 00:00:00	2008-01-24 00:00:00	2009-04-29 00:00:00	2008-10-30 00:00:00	2009-10-19 00:00:00	2009-01-22 00:00:00	2009-07-27 00:00:00	2010-04-30 00:00:00	2010-07-27 00:00:00	2010-02-01 00:00:00	2010-10-29 00:00:00	2011-01-27 00:00:00	2011-10-19 00:00:00	2011-07-22 00:00:00	2011-04-29 00:00:00	2012-10-29 00:00:00	2012-07-18 00:00:00	2012-07-18 00:00:00	2012-01-31 00:00:00	2012-04-30 00:00:00	2012-04-30 00:00:00	2013-01-28 00:00:00	2013-10-28 00:00:00	2013-07-22 00:00:00	2013-04-25 00:00:00	2013-04-25 00:00:00	2013-12-16 00:00:00	2014-01-30 00:00:00	2014-07-31 00:00:00	2014-10-18 00:00:00	2015-01-23 00:00:00	2015-01-23 00:00:00	2014-06-13 00:00:00	2014-04-25 00:00:00	2015-01-23 00:00:00	2014-10-31 00:00:00	2015-07-29 00:00:00	2015-04-30 00:00:00	2015-07-28 00:00:00	2015-03-13 00:00:00	2015-03-13 00:00:00	2015-03-19 00:00:00	2015-03-19 00:00:00	2015-03-05 00:00:00	2015-10-28 00:00:00	2016-07-29 00:00:00	2016-04-29 00:00:00	2016-01-28 00:00:00	2016-02-12 00:00:00	2016-10-24 00:00:00	2016-10-21 00:00:00	2017-07-21 00:00:00	2017-07-21 00:00:00	2017-04-27 00:00:00	2017-01-30 00:00:00	2017-01-31 00:00:00	2017-01-30 00:00:00	2017-01-31 00:00:00	2017-10-30 00:00:00	2018-04-30 00:00:00	2018-01-30 00:00:00	2017-07-30 00:00:00	2018-10-29 00:00:00	2019-07-30 00:00:00	2019-04-30 00:00:00	2019-01-31 00:00:00	2019-01-31 00:00:00	2019-10-29 00:00:00	2020-04-30 00:00:00	2021-01-31 00:00:00	2020-08-25 00:00:00	2020-09-09 00:00:00	2020-07-31 00:00:00	2020-10-20 00:00:00	2021-10-29 00:00:00	2021-04-27 00:00:00	2021-08-19 00:00:00	2021-07-13 00:00:00	2021-10-22 00:00:00	2022-04-30 00:00:00	2022-01-29 00:00:00	2022-07-31 00:00:00	2022-10-31 00:00:00
sig_loc	Sacramento CA	Sacramento CA	SACRAMENTO CA	SACRAMENTO CA	SACRAMENTO CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	Sacramento,CA	Sacramento,CA	Sacramento,CA	Sacramento,CA	Sacramento,CA	Sacramento,CA	Sacramento,CA	Sacramento,CA	Sacramento,CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	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	Sacramento	Sacramento, CA	Sacramento, CA	Sacramento	Sacramento, CA	Sacramento, CA	Sacramento	Sacramento	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, ca	SACRAMENTO, CA	Sacramento	SACRAMENTO, CA	Sacramento, ca	SACRAMENTO, CA	SACRAMENTO, CA	Sacramento	Sacramento, CA	Sacramento, CA	SACRAMENTO, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento	Sacramento, CA	Sacramento	Sacramento	Sacramento	Sacramento, CA	Sacramento	Sacramento, CA	Sacramento	Sacramento, CA	Sacramento	Sacramento, CA	Sacramento, CA	Sacramento	Sacramento	Sacramento	Sacramento, CA	Sacramento	SACRAMENTO, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	SACRAMENTO, CA	SACRAMENTO, CA	Sacramento	SACRAMENTO, CA	Sacramento, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA
sig_naml	None	Knudsen	KNUDSEN	KNUDSEN	KNUDSEN	KNUDSEN	KNUDSEN	KNUDSEN	KNUDSEN	KNUDSEN	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	KNUDSEN	Knudsen	Knudsen	Knudsen	Knudsen	KNUDSEN	KNUDSEN	Knudsen	KNUDSEN	Knudsen	KNUDSEN	KNUDSEN	KNUDSEN	KNUDSEN
sig_namf	None	Michael	MICHAEL B.	MICHAEL B.	MICHAEL B.	MICHAEL B.	MICHAEL B.	MICHAEL B.	MICHAEL B.	MICHAEL B.	Michael B.	Michael B.	Michael B.	Michael B.	Michael B.	Michael B.	Michael B.	Michael B.	Michael B.	Michael B.	Michael B.	Michael B.	Michael B.	Michael B.	Michael B.	Michael B.	Michael	Michael B.	Michael B.	Michael B.	Michael B.	Michael	Michael B.	Michael B.	Michael B.	Michael B.	Michael B.	Michael	Michael B.	Michael	Michael B.	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael B.	Michael B.	Michael B.	Michael B.	Michael	Michael B.	Michael B.	Michael B.	Michael	Michael B.	Michael B.	Michael B.	Michael	Michael	Michael B.	Michael	Michael	Michael	Michael B.	Michael	Michael	Michael B.	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Mike	Michael	Michael	Michael B.	Michael B.	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Joshua	MICHAEL	Michael	Michael	Joshua	Michael	MICHAEL	MICHAEL	Michael	MICHAEL	Michael	MICHAEL	MICHAEL	MICHAEL	MICHAEL
sig_namt	None	Mr.	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
sig_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	Knudsen	Knudsen	KNUDSEN	KNUDSEN	KNUDSEN	KNUDSEN	KNUDSEN	KNUDSEN	KNUDSEN	KNUDSEN	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	KNUDSEN	Knudsen	Knudsen	Knudsen	Knudsen	KNUDSEN	KNUDSEN	Knudsen	KNUDSEN	Knudsen	KNUDSEN	KNUDSEN	KNUDSEN	KNUDSEN
prn_namf	Michael	Michael	MICHAEL B.	MICHAEL B.	MICHAEL B.	MICHAEL B.	MICHAEL B.	MICHAEL B.	MICHAEL B.	MICHAEL B.	Michael B.	Michael B.	Michael B.	Michael B.	Michael B.	Michael B.	Michael B.	Michael B.	Michael B.	Michael B.	Michael B.	Michael B.	Michael B.	Michael B.	Michael B.	Michael B.	Michael	Michael B.	Michael B.	Michael B.	Michael B.	Michael	Michael B.	Michael B.	Michael B.	Michael B.	Michael B.	Michael	Michael B.	Michael	Michael B.	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael B.	Michael B.	Michael B.	Michael B.	Michael	Michael B.	Michael B.	Michael B.	Michael	Michael B.	Michael B.	Michael B.	Michael	Michael	Michael B.	Michael	Michael	Michael	Michael B.	Michael	Michael	Michael B.	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Mike	Michael	Michael	Michael B.	Michael B.	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Joshua	MICHAEL	Michael	Michael	Joshua	Michael	MICHAEL	MICHAEL	Michael	MICHAEL	Michael	MICHAEL	MICHAEL	MICHAEL	MICHAEL
prn_namt	Mr.	Mr.	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
prn_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	Owner	Owner	OWNER/PRESIDENT (4298-nm)	OWNER/PRESIDENT (4298-RS)	OWNER/PRESIDENT (4298-RS)	OWNER/PRESIDENT (4298-RS)	OWNER/PRESIDENT (4298-RS)	OWNER/PRESIDENT (4298-sb)	OWNER/PRESIDENT (4298-sb)	OWNER/PRESIDENT (429800-TMA)	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	None	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President	President and Owner	President/CEO	President/CEO	President and Owner	President and Owner	President/CEO	President/CEO	President/CEO	President and CEO	President and CEO	President and CEO	President/CEO	CEO/President	President and CEO	President and CEO	President and CEO	President and CEO	President and CEO	President and CEO	President and CEO	President and CEO	President and CEO	President and CEO	President & CEO	President	President & CEO	President & CEO	President & CEO	President	President	President & CEO	President & CEO	President & CEO	President & CEO	President & CEO	President	President & CEO	President & CEO	President & CEO	President & CEO	President	President	President	President	President & CEO	President & CEO	President	Legislative Advocate	PRESIDENT	President	President	Legislative Advocate	President	PRESIDENT	PRESIDENT	President	PRESIDENT	President	PRESIDENT/CHIEF EXECUTIVE OFFICER	PRESIDENT	PRESIDENT/CHIEF EXECUTIVE OFFICER	PRESIDENT/CHIEF EXECUTIVE OFFICER
nopart1_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
nopart2_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	X	None	None	X	None	None	None	None	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	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	X	X	X	X	X	X	X	X	X	X	X	X	X	X	None	X	X	None	X	X	X	X	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
ctrib_n_cb	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X
ctrib_y_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
lby_actvty	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
major_naml	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
major_namf	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
major_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
major_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
rcpcmte_nm	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
rcpcmte_id	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None

Table: cvr_registration
filing_id	1162580	1226412	1226412	1226412	1384783	1426956	1716758	1716758	1810483	1716758	1716758	1716758	1922030	1932549	1922030	1922030	2111650	2111650	2111650	2328224	2328224	2422321	2422321	2540613	2611693
amend_id	0	0	1	2	0	0	0	1	0	2	4	3	0	0	1	2	0	1	2	0	1	0	1	0	0
rec_type	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR
form_type	F602	F601	F601	F601	F601	F602	F601	F601	F602	F601	F601	F601	F601	F602	F601	F601	F601	F601	F601	F601	F601	F602	F602	F601	F602
sender_id	F00895	1222890	1222890	1222890	1222890	F00845	1222890	1222890	F00895	1222890	1222890	1222890	1222890	F00895	1222890	1222890	1222890	1222890	1222890	1222890	1222890	F24880	F24880	1222890	F24880
filer_id	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890
entity_cd	LEM	FRM	FRM	FRM	FRM	LEM	FRM	FRM	LEM	FRM	FRM	FRM	FRM	LEM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	LEM	LEM	FRM	LEM
filer_naml	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES
filer_namf	None	None	None	None	None	None	None	None	None	None	None	None	Michael Knudsen	None	Michael Knudsen	Michael Knudsen	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
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
report_num	000	000	001	002	000	000	000	001	000	002	004	003	000	000	001	002	000	001	002	000	001	000	001	000	000
rpt_date	2006-04-14 00:00:00	2007-01-03 00:00:00	2007-06-29 00:00:00	2007-07-30 00:00:00	2008-12-22 00:00:00	2009-06-18 00:00:00	2012-12-10 00:00:00	2013-03-06 00:00:00	2014-01-16 00:00:00	2013-10-31 00:00:00	2014-06-30 00:00:00	2014-06-02 00:00:00	2014-12-30 00:00:00	2014-12-23 00:00:00	2015-02-09 00:00:00	2015-02-09 00:00:00	2016-12-16 00:00:00	2017-06-01 00:00:00	2017-06-30 00:00:00	2018-12-14 00:00:00	2018-12-14 00:00:00	2019-09-05 00:00:00	2020-07-02 00:00:00	2020-12-31 00:00:00	2020-11-30 00:00:00
ls_beg_yr	2005	2007	2007	2007	2009	2009	2013	2013	2013	2013	2013	2013	2015	2015	2015	2015	2017	2017	2017	2019	2019	2019	2019	2021	2021
ls_end_yr	2006	2008	2008	2008	2010	2010	2014	2014	2014	2014	2014	2014	2016	2016	2016	2016	2018	2018	2018	2020	2020	2020	2020	2022	2022
qual_date	None	None	None	None	2009-01-01 00:00:00	None	None	None	None	None	None	None	2014-12-30 00:00:00	None	2014-12-30 00:00:00	2014-12-30 00:00:00	None	None	None	2019-01-01 00:00:00	2019-01-01 00:00:00	None	None	None	None
eff_date	2006-04-17 00:00:00	None	None	None	None	2009-05-26 00:00:00	None	None	2014-01-14 00:00:00	None	None	None	None	2015-01-28 00:00:00	None	None	None	None	None	None	None	2019-09-05 00:00:00	2020-06-01 00:00:00	None	2021-01-01 00:00:00
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
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
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
bus_phon	916-448-7500	9164487500	9164487500	9164487500	9164487500	(916) 448-7500	9164487500	9164487500	916-448-7500	9164487500	9164487500	9164487500	9164487500	916-448-7500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	(916) 448-7500	(916) 448-7500	(916) 448-7500	(916) 448-7500
bus_fax	None	9169142191	9169142191	9169142191	9169142191	None	None	None	None	None	None	None	9169142191	None	9169142191	9169142191	9169142191	9169142191	9169142191	None	None	None	None	None	None
bus_email	None	[email protected]	[email protected]	[email protected]	[email protected]	None	None	None	None	None	None	None	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]	None
mail_city	None	None	None	None	None	None	None	None	None	None	None	None	Sacramento	None	Sacramento	Sacramento	None	None	None	None	None	None	None	None	None
mail_st	None	None	None	None	None	None	None	None	None	None	None	None	Ca	None	Ca	Ca	None	None	None	None	None	None	None	None	None
mail_zip4	None	None	None	None	None	None	None	None	None	None	None	None	95814	None	95814	95814	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
sig_date	2006-04-17 00:00:00	2007-01-03 00:00:00	2007-06-29 00:00:00	2007-07-30 00:00:00	2008-12-22 00:00:00	2009-05-26 00:00:00	2012-12-10 00:00:00	2013-03-06 00:00:00	2014-01-14 00:00:00	2013-10-31 00:00:00	2014-06-30 00:00:00	2014-06-02 00:00:00	2014-12-30 00:00:00	2014-12-23 00:00:00	2015-02-09 00:00:00	2015-02-09 00:00:00	2016-12-16 00:00:00	2017-06-01 00:00:00	2017-06-30 00:00:00	2016-12-14 00:00:00	2018-12-17 00:00:00	2019-09-05 00:00:00	2020-06-17 00:00:00	2020-12-16 00:00:00	2020-11-30 00:00:00
sig_loc	SACRAMENTO CA	None	Sacramento, CA	Sacramento, CA	None	SACRAMENTO, CA	None	Sacramento, CA	SACRAMENTO CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	None	SACRAMENTO CA	Sacramento	Sacramento, CA	None	Sacramento	Sacramento	None	Sacramento	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA
sig_naml	KNUDSEN	Knudsen	Knudsen	Knudsen	Knudsen	KNUDSEN	Knudsen	Knudsen	KNUDSEN	Knudsen	Knudsen	Knudsen	Knudsen	KNUDSEN	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	KNUDSEN	KNUDSEN	KNUDSEN	KNUDSEN
sig_namf	MICHAEL	Michael	Michael	Michael B.	Michael B.	MICHAEL	Michael B.	Michael B.	MICHAEL	Michael	Michael B.	Michael B.	Michael	MICHAEL	Michael	Michael	Michael	Michael	Michael	Michael	Mike	MICHAEL B.	MICHAEL B.	MICHAEL B.	MICHAEL B.
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
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
prn_naml	None	Knudsen	Knudsen	Knudsen	Knudsen	KNUDSEN	Knudsen	Knudsen	None	Knudsen	Knudsen	Knudsen	Knudsen	None	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	Knudsen	KNUDSEN	KNUDSEN	KNUDSEN	KNUDSEN
prn_namf	None	Michael	Michael	Michael B.	Michael B.	MICHAEL	Michael B.	Michael B.	None	Michael	Michael B.	Michael B.	Michael	None	Michael	Michael	Michael	Michael	Michael	Michael	Mike	MICHAEL B.	MICHAEL B.	MICHAEL B.	MICHAEL B.
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
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
sig_title	None	President	President	President	President	PRESIDENT	President and Owner	President and Owner	None	President/CEO	President/CEO	President/CEO	CEO/President	OWNER	President & CEO	President & CEO	CEO & President	President & CEO	President & CEO	President & CEO	President & CEO	PRESIDENT/CHIEF EXECUTIVE OFFICER	PRESIDENT	PRESIDENT/CHIEF EXECUTIVE OFFICER	PRESIDENT
stmt_firm	None	Knudsen & Associates	Knudsen & Associates	Knudsen & Associates	Knudsen & Associates	None	Knudsen & Associates	Knudsen & Associates	None	Knudsen & Associates	Knudsen & Associates	Knudsen & Associates	Knudsen & Associates	None	Knudsen & Associates	Knudsen & Associates	Knudsen & Associates	Knudsen & Associates	Knudsen & Associates	Knudsen & Associates	Knudsen & Associates	None	None	KNUDSEN & ASSOCIATES	None
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
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
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
oth_cb	None	None	None	None	None	X	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	X	X	None	X
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
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
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
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
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
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
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
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
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
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
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
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
auth_name	LANG HANSEN O'MALLEY AND MILLER	None	None	None	None	GOVERNMENTAL ADVOCATES, INC.	None	None	LANG HANSEN O'MALLEY & MILLER	None	None	None	None	LANG HANSEN O'MALLEY & MILLLER	None	None	None	None	None	None	None	PLATINUM ADVISORS, LLC	PLATINUM ADVISORS, LLC	None	PLATINUM ADVISORS, LLC
auth_city	SACRAMENTO	None	None	None	None	SACRAMENTO	None	None	SACRAMENTO	None	None	None	None	SACRAMENTO	None	None	None	None	None	None	None	SACRAMENTO	SACRAMENTO	None	SACRAMENTO
auth_st	CA	None	None	None	None	CA	None	None	CA	None	None	None	None	CA	None	None	None	None	None	None	None	CA	CA	None	CA
auth_zip4	95814	None	None	None	None	95814	None	None	95814	None	None	None	None	95814	None	None	None	None	None	None	None	95814	95814	None	95814
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
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
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
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
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
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
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
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
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
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
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
l_firm_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

Table: efs_filing_log
filing_date	2001-04-30 00:00:00	2001-04-30 00:00:00	2001-07-26 00:00:00	2001-07-26 00:00:00	2001-01-31 00:00:00	2001-01-31 00:00:00	2001-10-31 00:00:00	2001-10-31 00:00:00	2002-01-30 00:00:00	2002-01-30 00:00:00	2002-04-30 00:00:00	2002-04-30 00:00:00	2002-07-29 00:00:00	2002-07-29 00:00:00	2002-10-30 00:00:00	2002-10-30 00:00:00	2003-01-30 00:00:00	2003-01-30 00:00:00	2003-04-29 00:00:00	2003-04-29 00:00:00	2003-04-29 00:00:00	2003-04-29 00:00:00	2003-07-29 00:00:00	2003-07-29 00:00:00	2003-07-29 00:00:00	2003-07-29 00:00:00	2003-10-28 00:00:00	2003-10-28 00:00:00	2003-10-28 00:00:00	2003-10-28 00:00:00
filingstatus	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	1	0	1	0	1	0	1	0	1	0
vendor	NETFILE	NETFILE	NETFILE	NETFILE	RUNFOROFFICE	RUNFOROFFICE	NETFILE	NETFILE	NETFILE	NETFILE	NETFILE	NETFILE	NETFILE	NETFILE	NETFILE	NETFILE	NETFILE	NETFILE	RACE-TRAX FOR LOBBYISTS	RACE-TRAX FOR LOBBYISTS	RACE-TRAX FOR LOBBYISTS	RACE-TRAX FOR LOBBYISTS	RACE-TRAX FOR LOBBYISTS	RACE-TRAX FOR LOBBYISTS	RACE-TRAX FOR LOBBYISTS	RACE-TRAX FOR LOBBYISTS	RACE-TRAX FOR LOBBYISTS	RACE-TRAX FOR LOBBYISTS	RACE-TRAX FOR LOBBYISTS	RACE-TRAX FOR LOBBYISTS
filer_id	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890
form_type	F625	F615	F625	F615	F625	F615	F625	F615	F625	F615	F625	F615	F625	F615	F625	F615	F625	F615	F625	F625	F615	F615	F625	F625	F615	F615	F625	F625	F615	F615
error_no	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED

Table: filer_address
filer_id	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890
adrid	1131780	2012243	1132600	2045767	2045843	2079532	2076742	2085677	2115011	2159457	2204811	2504839	2412528	2544817	2465475	2278586	2337607
effect_dt	2000-01-01 00:00:00	2001-01-01 00:00:00	2000-01-01 00:00:00	2003-01-01 00:00:00	2003-01-06 00:00:00	2005-01-01 00:00:00	2004-11-01 00:00:00	2005-03-03 00:00:00	2007-01-01 00:00:00	2009-01-01 00:00:00	2011-01-01 00:00:00	2021-01-01 00:00:00	2017-01-01 00:00:00	2023-01-01 00:00:00	2019-01-01 00:00:00	2013-01-01 00:00:00	2015-01-01 00:00:00
add_type	7051	7051	7050	7050	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051
session_id	1999	2001	1999	2003	2003	2005	2003	2005	2007	2009	2011	2021	2017	2023	2019	2013	2015

Table: filer_filings
filer_id	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890
filing_id	687289	625031	622122	658306	679583	719789	704898	767020	733296	746328	767046	748375	792112	770136	785372	776985	795383	793244	813277	815484	839467	857363	842007	858034	859779	852848	886696	906843	906847	915890	894318	894319	883579	916355	911018	930240	932335	952468	968194	945941	937415	980510	972974	990174	1005989	1005990	1005991	1005992	1014086	1014086	993547	1030526	1015646	1062019	1073028	1035342	1063202	1083126	1055856	1085997	1095603	1080209	1097919	1118290	1132555	1104513	1126734	1134022	1126192	1162580	1168094	1162961	1148117	1226412	1216519	1192102	1259906	1240094	1240127	1285752	1280058	1226412	1238471	1226412	1277583	1238471	1306032	1292995	1306032	1192102	1216519	1293462	1752841	1784489	1762017	1964881	1962044	1970474	1979077	1964881	1969909	1845891	1871980	1716758	1845891	1716758	1862699	1776967	1716758	1805958	1810483	1797714	1797714	1944467	1912355	1929174	1922030	1922030	1946421	1929174	1912355	1929174	1957304	1912355	1332699	1330280	1348264	1360041	1360043	1375878	1391284	1384783	1397495	1410135	1410146	1420428	1429578	1429579	1433938	1426956	1431288	1448217	1470426	1464913	1486776	1485339	1503606	1538558	1567817	1554578	1554604	1585005	1602230	1618179	1590157	1637754	1615596	1652334	1658127	1672495	1672495	1658127	1821434	1825290	1819629	1929174	1912355	1932549	1929174	1871980	1915190	1922030	1716758	1706845	1733791	1817022	1716758	1752858	1762017	1995150	2001047	2000060	1986837	2000055	2000057	2208441	2369251	2291867	2411550	2502403	2349173	2422321	2554425	2237103	2377550	2421615	2354431	2385365	2408642	2009115	2009115	2022755	2022765	2024243	2036577	2052357	2061392	2092989	2127534	2127534	2127534	2111650	2092989	2127534	2154491	2133890	2169663	2154491	2111650	2164939	2164977	2111650	2417356	2269276	2272733	2192283	2471816	2471816	2499473	2315530	2471816	2328224	2487929	2463041	2536252	2536269	2397167	2241088	2477185	2381447	2328224	2540613	2443952	2631162	2422321	2519073	2605985	2677570	2604068	2611693	2624104	2581485	2519073	2487929	2624965	2645734	2569387	2707627	2749394
period_id	163	161	None	162	163	164	None	None	164	165	None	165	167	166	None	None	None	None	168	None	169	157	None	None	None	170	None	None	None	None	None	None	171	None	172	173	None	None	175	174	None	None	None	176	None	None	None	None	177	177	None	178	None	None	None	None	None	None	179	None	None	180	None	182	183	181	None	173	None	186	185	None	184	189	187	186	189	None	None	None	190	191	188	190	None	188	196	None	192	186	187	191	None	None	213	221	None	None	222	221	None	217	218	218	217	218	None	214	216	None	217	213	215	None	219	220	221	221	None	220	219	220	None	219	None	193	194	None	None	195	196	196	None	None	None	197	None	None	198	198	None	199	None	200	None	201	202	203	204	None	None	None	206	207	205	208	None	None	209	210	210	209	None	None	None	220	219	220	220	218	None	220	212	211	212	216	213	None	213	223	None	None	None	None	None	232	None	None	None	None	236	239	244	None	None	None	None	None	None	224	224	None	None	None	225	None	226	227	228	228	228	228	227	228	229	None	230	229	230	None	None	230	239	None	234	231	241	241	None	235	241	236	242	None	None	None	238	233	None	237	236	244	240	None	243	243	None	249	246	244	247	245	243	242	None	248	None	250	251
form_id	F625	F625	F601	F625	F625	F625	F601	F605	F625	F625	F602	F625	F625	F625	F605	F625	F605	F625	F625	F625	F625	F666	F625	F625	F605	F625	F625	F601	F605	F602	F605	F605	F625	F625	F625	F625	F625	F625	F625	F625	F605	F605	F625	F625	F690	F690	F690	F690	F625	F625	F625	F625	F625	F605	F601	F625	F625	F602	F625	F625	F605	F625	F605	F625	F625	F625	F605	F666	F605	F602	F625	F602	F625	F601	F625	F625	F625	F601	F605	F601	F625	F601	F625	F601	F605	F625	F625	F666	F625	F625	F625	F625	F601	F605	F625	F625	F605	F605	F625	F625	F605	F625	F625	F601	F625	F601	F605	F625	F601	F605	F602	F625	F625	F601	F625	F625	F601	F601	F602	F625	F625	F625	F602	F625	F605	F625	F625	F605	F605	F625	F625	F601	F601	F601	F605	F625	F605	F605	F625	F602	F602	F625	F605	F625	F605	F625	F625	F625	F625	F601	F605	F605	F625	F625	F625	F625	F605	F605	F625	F625	F625	F625	F602	F602	F602	F625	F625	F602	F625	F625	F605	F601	F601	F625	F625	F625	F601	F605	F625	F625	F605	F605	F605	F605	F605	F625	F605	F602	F602	F605	F625	F602	F625	F605	F605	F605	F601	F605	F605	F625	F625	F605	F605	F605	F625	F605	F625	F625	F625	F625	F625	F601	F625	F625	F625	F601	F625	F625	F601	F602	F605	F601	F625	F605	F625	F625	F625	F625	F605	F625	F625	F601	F625	F605	F605	F605	F625	F625	F602	F625	F601	F601	F625	F602	F602	F625	F605	F625	F625	F602	F625	F625	F625	F625	F605	F625	F601	F625	F625
filing_sequence	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	1	0	1	0	0	1	1	1	0	0	0	1	1	0	0	0	0	0	0	0	3	1	4	0	0	2	0	0	0	1	0	2	3	1	2	0	2	3	4	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0	0	1	0	1	1	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	1	0	2	1	0	0	3	0	0	0	1	1	0	0	2	0	0	0	0	1	2	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	1	1	0	0	0	0	0
filing_date	2000-10-30 00:00:00	2000-05-01 00:00:00	2000-02-15 00:00:00	2000-07-31 00:00:00	2000-10-28 00:00:00	2001-01-31 00:00:00	2000-12-28 00:00:00	2001-07-09 00:00:00	2001-03-01 00:00:00	2001-04-30 00:00:00	2001-07-09 00:00:00	2001-04-30 00:00:00	2001-10-31 00:00:00	2001-07-26 00:00:00	2001-10-05 00:00:00	2001-07-30 00:00:00	2001-11-01 00:00:00	2001-10-31 00:00:00	2002-01-30 00:00:00	2002-01-31 00:00:00	2002-04-30 00:00:00	2002-07-31 00:00:00	2002-04-30 00:00:00	2002-07-31 00:00:00	2002-08-05 00:00:00	2002-07-29 00:00:00	2002-10-31 00:00:00	2002-12-31 00:00:00	2003-01-08 00:00:00	2002-12-31 00:00:00	2002-11-22 00:00:00	2002-11-22 00:00:00	2002-10-30 00:00:00	2003-01-31 00:00:00	2003-01-30 00:00:00	2003-04-29 00:00:00	2003-04-30 00:00:00	2003-07-31 00:00:00	2003-10-28 00:00:00	2003-07-29 00:00:00	2003-05-21 00:00:00	2004-01-08 00:00:00	2003-10-31 00:00:00	2004-02-02 00:00:00	2004-03-02 00:00:00	2004-03-02 00:00:00	2004-03-02 00:00:00	2004-03-02 00:00:00	2004-04-30 00:00:00	2004-04-30 00:00:00	2004-02-02 00:00:00	2004-07-30 00:00:00	2004-04-30 00:00:00	2004-11-15 00:00:00	2004-12-30 00:00:00	2004-08-02 00:00:00	2004-11-01 00:00:00	2004-12-29 00:00:00	2004-10-28 00:00:00	2005-01-31 00:00:00	2005-03-03 00:00:00	2005-01-31 00:00:00	2005-01-21 00:00:00	2005-08-01 00:00:00	2005-10-28 00:00:00	2005-04-29 00:00:00	2005-10-03 00:00:00	2005-10-31 00:00:00	2005-09-27 00:00:00	2006-04-17 00:00:00	2006-05-01 00:00:00	2006-04-17 00:00:00	2006-01-31 00:00:00	2007-01-03 00:00:00	2006-10-31 00:00:00	2006-07-31 00:00:00	2007-04-26 00:00:00	2006-12-28 00:00:00	2007-01-05 00:00:00	2007-07-31 00:00:00	2007-07-25 00:00:00	2007-07-30 00:00:00	2007-01-31 00:00:00	2007-06-29 00:00:00	2007-07-11 00:00:00	2007-06-26 00:00:00	2008-01-24 00:00:00	2007-08-31 00:00:00	2008-01-24 00:00:00	2007-08-29 00:00:00	2007-09-06 00:00:00	2007-10-18 00:00:00	2013-03-05 00:00:00	2013-07-30 00:00:00	2013-04-26 00:00:00	2015-07-28 00:00:00	2015-02-10 00:00:00	2015-06-08 00:00:00	2015-07-29 00:00:00	2015-04-30 00:00:00	2015-05-05 00:00:00	2014-04-30 00:00:00	2014-07-31 00:00:00	2014-06-02 00:00:00	2014-06-13 00:00:00	2014-06-30 00:00:00	2014-06-30 00:00:00	2013-07-22 00:00:00	2013-10-31 00:00:00	2013-11-07 00:00:00	2014-01-16 00:00:00	2013-10-28 00:00:00	2013-12-16 00:00:00	2014-12-30 00:00:00	2015-03-13 00:00:00	2015-03-13 00:00:00	2015-02-09 00:00:00	2015-02-09 00:00:00	2014-12-30 00:00:00	2015-03-05 00:00:00	2015-03-19 00:00:00	2015-03-19 00:00:00	2015-01-28 00:00:00	2014-10-31 00:00:00	2008-05-15 00:00:00	2008-04-30 00:00:00	2008-07-29 00:00:00	2008-08-28 00:00:00	2008-09-09 00:00:00	2008-10-30 00:00:00	2009-01-23 00:00:00	2008-12-22 00:00:00	2008-12-29 00:00:00	2008-12-29 00:00:00	2008-12-29 00:00:00	2009-04-29 00:00:00	2009-05-27 00:00:00	2009-06-05 00:00:00	2009-07-27 00:00:00	2009-06-18 00:00:00	2009-05-27 00:00:00	2009-10-19 00:00:00	2010-02-17 00:00:00	2010-02-01 00:00:00	2010-05-07 00:00:00	2010-04-30 00:00:00	2010-07-27 00:00:00	2010-10-29 00:00:00	2011-01-27 00:00:00	2010-12-23 00:00:00	2010-12-23 00:00:00	2011-03-10 00:00:00	2011-07-22 00:00:00	2011-10-19 00:00:00	2011-04-29 00:00:00	2012-01-31 00:00:00	2011-08-22 00:00:00	2012-04-09 00:00:00	2012-04-30 00:00:00	2012-07-18 00:00:00	2012-07-18 00:00:00	2012-04-30 00:00:00	2014-01-16 00:00:00	2014-01-24 00:00:00	2014-01-17 00:00:00	2015-01-23 00:00:00	2015-01-23 00:00:00	2015-01-29 00:00:00	2015-01-27 00:00:00	2014-10-18 00:00:00	2014-11-05 00:00:00	2014-12-30 00:00:00	2012-12-10 00:00:00	2012-10-29 00:00:00	2013-01-28 00:00:00	2014-01-30 00:00:00	2013-03-06 00:00:00	2013-03-06 00:00:00	2013-04-25 00:00:00	2015-10-28 00:00:00	2015-11-13 00:00:00	2015-11-06 00:00:00	2014-12-22 00:00:00	2015-10-23 00:00:00	2015-11-06 00:00:00	2018-01-30 00:00:00	2019-01-31 00:00:00	2018-09-13 00:00:00	2019-09-05 00:00:00	2020-09-16 00:00:00	2019-01-31 00:00:00	2019-11-19 00:00:00	2021-02-01 00:00:00	2018-04-25 00:00:00	2019-03-06 00:00:00	2019-11-12 00:00:00	2018-12-27 00:00:00	2019-05-06 00:00:00	2019-07-25 00:00:00	2016-02-12 00:00:00	2016-01-28 00:00:00	2015-12-16 00:00:00	2016-01-25 00:00:00	2016-02-12 00:00:00	2016-04-29 00:00:00	2016-06-21 00:00:00	2016-07-29 00:00:00	2016-10-24 00:00:00	2017-01-30 00:00:00	2017-01-31 00:00:00	2017-01-30 00:00:00	2016-12-16 00:00:00	2016-10-21 00:00:00	2017-01-31 00:00:00	2017-04-27 00:00:00	2016-12-16 00:00:00	2017-07-21 00:00:00	2017-07-21 00:00:00	2017-06-01 00:00:00	2017-06-21 00:00:00	2017-06-01 00:00:00	2017-06-30 00:00:00	2019-10-29 00:00:00	2018-07-24 00:00:00	2018-07-30 00:00:00	2017-10-30 00:00:00	2020-08-25 00:00:00	2020-09-09 00:00:00	2020-08-31 00:00:00	2018-10-29 00:00:00	2020-04-30 00:00:00	2018-12-14 00:00:00	2020-07-31 00:00:00	2020-03-12 00:00:00	2020-11-23 00:00:00	2020-11-23 00:00:00	2019-07-30 00:00:00	2018-04-30 00:00:00	2020-07-02 00:00:00	2019-04-30 00:00:00	2018-12-14 00:00:00	2020-12-30 00:00:00	2020-01-31 00:00:00	2021-04-29 00:00:00	2020-08-10 00:00:00	2020-10-20 00:00:00	2021-03-17 00:00:00	2022-05-02 00:00:00	2021-08-02 00:00:00	2021-09-15 00:00:00	2021-11-01 00:00:00	2021-04-30 00:00:00	2021-10-22 00:00:00	2021-08-19 00:00:00	2021-02-18 00:00:00	2022-01-31 00:00:00	2020-12-30 00:00:00	2022-08-01 00:00:00	2022-10-31 00:00:00
stmnt_type	10005	10005	10005	10005	10001	10001	10005	10005	10005	10001	10005	10005	10001	10001	10005	10005	10005	10005	10001	10005	10001	10005	10005	10005	10005	10001	10005	10005	10005	10005	10005	10005	10001	10005	10001	10001	10005	10005	10001	10001	10005	10005	10005	10001	10006	10006	10006	10006	10001	10002	10005	10001	10005	10005	10005	10005	10005	10005	10001	10005	10005	10001	10005	10001	10001	10001	10005	10005	10005	10001	10001	10005	10001	10001	10001	10001	10001	10005	10005	10005	10001	10002	10001	10002	10005	10002	10001	10005	10002	10002	10002	10001	10005	10006	10002	10002	10006	10006	10001	10001	10006	10001	10001	10002	10002	10002	10006	10001	10002	10006	10001	10001	10002	10005	10002	10002	10002	10002	10005	10002	10002	10002	10005	10001	10005	10001	10001	10005	10005	10001	10001	10001	10005	10005	10005	10001	10005	10005	10001	10001	10005	10001	10006	10001	10006	10001	10001	10001	10001	10005	10006	10005	10001	10001	10001	10001	10006	10006	10001	10001	10002	10002	10005	10005	10005	10001	10002	10001	10002	10002	10006	10001	10001	10001	10001	10001	10002	10005	10001	10001	10006	10006	10006	10006	10006	10001	10005	10005	10005	10002	10001	10001	10001	10005	10005	10005	10001	10005	10005	10002	10001	10005	10005	10005	10001	10005	10001	10002	10001	10002	10002	10001	10001	10002	10001	10001	10001	10002	10002	10005	10006	10002	10001	10005	10001	10001	10002	10002	10005	10001	10001	10002	10001	10005	10002	10002	10001	10001	10005	10001	10001	10001	10001	10005	10002	10001	10002	10001	10001	10001	10001	10001	10002	10002	10002	10001	10005	10001	10001
stmnt_status	11001	11001	11001	11001	11003	11003	11001	11001	11001	11003	11001	11001	11003	11003	11001	11001	11001	11001	11003	11001	11003	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11003	11001	11003	11003	11001	11001	11003	11003	11001	11001	11001	11003	11001	11001	11001	11001	11003	11003	11003	11003	11003	11001	11001	11003	11001	11001	11003	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11003	11001	11001	11001	11001	11003	11001	11001	11003	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	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	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	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11003	11001	11001	11001	11001	11003	11003	11001	11001	11001	11003	11003
session_id	1999	1999	1999	1999	1999	1999	2001	2001	1999	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	1999	2001	2001	2001	2001	2001	2003	2003	2003	2001	2001	2001	2001	2001	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2005	2003	2003	2005	2003	2003	2005	2003	2005	2005	2005	2005	2005	2003	2005	2005	2005	2005	2005	2007	2005	2005	2007	2007	2007	2007	2007	2007	2005	2007	2007	2005	2007	2005	2007	2005	2005	2007	2013	2013	2013	2015	2015	2015	2015	2015	2015	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2015	2013	2013	2015	2015	2015	2013	2013	2013	2015	2013	2007	2007	2007	2007	2007	2007	2007	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2011	2009	2011	2011	2011	2011	2011	2011	2011	2011	2011	2011	2011	2013	2013	2013	2013	2013	2015	2013	2013	2013	2015	2013	2011	2011	2013	2013	2013	2013	2015	2015	2015	2013	2015	2015	2017	2019	2017	2019	2019	2017	2019	2019	2017	2019	2019	2019	2019	2019	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2017	2015	2015	2017	2017	2017	2017	2017	2017	2017	2017	2019	2017	2017	2017	2019	2019	2019	2017	2019	2019	2019	2019	2019	2019	2019	2017	2019	2019	2019	2021	2019	2021	2019	2019	2019	2021	2021	2021	2021	2021	2019	2019	2019	2021	2021	2021	2021
user_id	MKIENG	GGILMORE	GGILMORE	TTHAM	*	*	GGILMORE	CFLAGG	DHORRELL	*	CFLAGG	CFLAGG	*	*	CFLAGG	YBONILLA	SARRIAGA	YBONILLA	*	YBONILLA	*	PROBERTS	YBONILLA	YBONILLA	GPEREZ	*	YBONILLA	BSMITH	BSMITH	SARRIAGA	GPEREZ	GPEREZ	*	YBONILLA	COMPLETED	COMPLETED	YBONILLA	YBONILLA	COMPLETED	COMPLETED	SARRIAGA	SARRIAGA	YBONILLA	COMPLETED	YBONILLA	YBONILLA	YBONILLA	YBONILLA	COMPLETED	COMPLETED	EMCENTEE	COMPLETED	EMCENTEE	CFLAGG	SARRIAGA	EMCENTEE	YRODRIGU	PBANFORD	COMPLETED	YRODRIGU	PBANFORD	COMPLETED	SARRIAGA	YRODRIGU	YRODRIGU	YRODRIGU	GPEREZ	PROBERTS	CFLAGG	*	YRODRIGU	SARRIAGA	LTHIBAUL	*	YRODRIGU	YRODRIGU	YRODRIGU	CFLAGG	EMCENTEE	CFLAGG	YRODRIGU	*	YRODRIGU	*	GPEREZ	YRODRIGU	YRODRIGU	NLANDERS	YRODRIGU	LTHIBAUL	LTHIBAUL	YRODRIGU	SARRIAGA	YRODRIGU	ASAETERN	AGLADNEY	YRODRIGU	YRODRIGU	AGLADNEY	AGLADNEY	YRODRIGU	ASAETERN	ASAETERN	YRODRIGU	ASAETERN	YRODRIGU	YRODRIGU	ASAETERN	YRODRIGU	YRODRIGU	SARRIAGA	ASAETERN	ASAETERN	PBANFORD	AGLADNEY	AGLADNEY	YRODRIGU	YRODRIGU	SARRIAGA	AGLADNEY	AGLADNEY	AGLADNEY	SARRIAGA	ASAETERN	CFLAGG	LTHIBAUL	LTHIBAUL	LTHIBAUL	YRODRIGU	MGUERRA	MGUERRA	*	SARRIAGA	YRODRIGU	YRODRIGU	MGUERRA	PBANFORD	PBANFORD	MGUERRA	YRODRIGU	YRODRIGU	MGUERRA	YRODRIGU	MGUERRA	YRODRIGU	MGUERRA	ASAETERN	ASAETERN	ASAETERN	GKURIMOT	YRODRIGU	PBANFORD	ASAETERN	ASAETERN	ASAETERN	ASAETERN	YRODRIGU	YRODRIGU	ASAETERN	AGLADNEY	AGLADNEY	ASAETERN	YRODRIGU	YRODRIGU	SARRIAGA	AGLADNEY	AGLADNEY	YRODRIGU	AGLADNEY	ASAETERN	YRODRIGU	PBANFORD	PBANFORD	ASAETERN	ASAETERN	ASAETERN	SARRIAGA	SARRIAGA	ASAETERN	AGLADNEY	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	AGLADNEY	SARRIAGA	GPEREZ	SARRIAGA	MMERCHANT	AGLADNEY	GPEREZ	MKIRKHAM	GPEREZ	SARRIAGA	SARRIAGA	SARRIAGA	GPEREZ	SARRIAGA	AGLADNEY	AGLADNEY	GPEREZ	GPEREZ	GPEREZ	AGLADNEY	GPEREZ	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	PBANFORD	AGLADNEY	AGLADNEY	AGLADNEY	PBANFORD	AGLADNEY	AGLADNEY	YRODRIGU	YRODRIGU	YRODRIGU	GPEREZ	AGLADNEY	GPEREZ	AGLADNEY	AGLADNEY	MKIRKHAM	CAFILER	GPEREZ	AGLADNEY	MKIRKHAM	CAFILER	MKIRKHAM	GPEREZ	AROJAS	AROJAS	AGLADNEY	AGLADNEY	GPEREZ	AGLADNEY	SARRIAGA	CVANLIEW	AGLADNEY	MKIRKHAM	CAFILER	MKIRKHAM	MMERCHANT	CAFILER	MKIRKHAM	MKIRKHAM	CHATRIDGE	MKIRKHAM	CAFILER	CAFILER	MMERCHANT	CHATRIDGE	CVANLIEW	CAFILER	CAFILER
special_audit	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11002	11003	11003	11002	11002	11003	11003	11002	11003	11003	11003	11003	11003	11003	11002	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003
fine_audit	11003	11003	11003	11003	11003	11003	11003	11003	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	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	11003	11001	11003	11003	11003	11003	11003	11001	11001	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11003	11001	11001	11001	11003	11003	11003	11003	11001	11003	11001	11003	11003	11003	11003	11003	11003	11001	11001	11003	11003	11003	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11003	11001	11001	11001	11003	11003	11001	11001	11003	11001	11003	11003	11003	11001	11001	11003	11001	11003	11003	11001	11003	11003	11001	11003	11003	11001	11003	11001	11001	11003	11003	11003	11001	11003	11003	11003
rpt_start	2000-07-01 00:00:00	2000-01-01 00:00:00	None	2000-04-01 00:00:00	2000-07-01 00:00:00	2000-10-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2000-10-01 00:00:00	2001-01-01 00:00:00	1900-01-01 00:00:00	2001-01-01 00:00:00	2001-07-01 00:00:00	2001-04-01 00:00:00	1900-01-01 00:00:00	2001-04-01 00:00:00	1900-01-01 00:00:00	2001-07-01 00:00:00	2001-10-01 00:00:00	2001-10-01 00:00:00	2002-01-01 00:00:00	2000-01-01 00:00:00	2002-01-01 00:00:00	2002-04-01 00:00:00	1900-01-01 00:00:00	2002-04-01 00:00:00	2002-07-01 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	1900-01-01 00:00:00	2002-07-01 00:00:00	2002-10-01 00:00:00	2002-10-01 00:00:00	2003-01-01 00:00:00	2003-01-01 00:00:00	2003-04-01 00:00:00	2003-07-01 00:00:00	2003-04-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2003-07-01 00:00:00	2003-10-01 00:00:00	2003-10-01 00:00:00	2003-07-01 00:00:00	2003-04-01 00:00:00	2003-01-01 00:00:00	2004-01-01 00:00:00	2004-01-01 00:00:00	2003-10-01 00:00:00	2004-04-01 00:00:00	2004-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2004-04-01 00:00:00	2004-07-01 00:00:00	1900-01-01 00:00:00	2004-07-01 00:00:00	2004-10-01 00:00:00	1900-01-01 00:00:00	2004-10-01 00:00:00	1900-01-01 00:00:00	2005-04-01 00:00:00	2005-07-01 00:00:00	2005-01-01 00:00:00	1900-01-01 00:00:00	2003-01-01 00:00:00	1900-01-01 00:00:00	2006-04-14 00:00:00	2006-01-01 00:00:00	1900-01-01 00:00:00	2005-10-01 00:00:00	2007-01-03 00:00:00	2006-07-01 00:00:00	2006-04-01 00:00:00	2007-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2007-04-01 00:00:00	2007-07-30 00:00:00	2006-10-01 00:00:00	2007-06-29 00:00:00	1900-01-01 00:00:00	2006-10-01 00:00:00	2008-10-01 00:00:00	2005-01-01 00:00:00	2007-10-01 00:00:00	2006-04-01 00:00:00	2006-07-01 00:00:00	2007-07-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2013-01-01 00:00:00	2015-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2015-04-01 00:00:00	2015-01-01 00:00:00	1900-01-01 00:00:00	2014-01-01 00:00:00	2014-04-01 00:00:00	2014-06-02 00:00:00	2014-01-01 00:00:00	2014-06-30 00:00:00	1900-01-01 00:00:00	2013-04-01 00:00:00	2013-10-31 00:00:00	1900-01-01 00:00:00	2014-01-16 00:00:00	2013-01-07 00:00:00	2013-07-01 00:00:00	1900-01-01 00:00:00	2014-07-01 00:00:00	2014-10-01 00:00:00	2015-02-09 00:00:00	2015-02-09 00:00:00	1900-01-01 00:00:00	2014-10-01 00:00:00	2014-07-01 00:00:00	2014-10-01 00:00:00	1900-01-01 00:00:00	2014-07-01 00:00:00	1900-01-01 00:00:00	2008-01-01 00:00:00	2008-04-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2008-07-01 00:00:00	2008-10-01 00:00:00	2008-12-22 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2009-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2009-04-01 00:00:00	2009-06-18 00:00:00	1900-01-01 00:00:00	2009-07-01 00:00:00	1900-01-01 00:00:00	2009-10-01 00:00:00	1900-01-01 00:00:00	2010-01-01 00:00:00	2010-04-01 00:00:00	2010-07-01 00:00:00	2010-10-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2011-04-01 00:00:00	2011-07-01 00:00:00	2011-01-01 00:00:00	2011-10-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2012-01-01 00:00:00	2012-04-01 00:00:00	2012-04-01 00:00:00	2012-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2014-10-01 00:00:00	2014-07-01 00:00:00	2014-12-23 00:00:00	2014-10-01 00:00:00	2014-04-01 00:00:00	1900-01-01 00:00:00	2014-12-30 00:00:00	2012-12-10 00:00:00	2012-07-01 00:00:00	2012-10-01 00:00:00	2013-10-01 00:00:00	2013-03-06 00:00:00	1900-01-01 00:00:00	2013-01-01 00:00:00	2015-07-01 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	1900-01-01 00:00:00	2017-10-01 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	2018-10-01 00:00:00	2019-09-05 00:00:00	2020-10-01 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	1900-01-01 00:00:00	1900-01-01 00:00:00	2015-10-01 00:00:00	2015-10-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2016-01-01 00:00:00	1900-01-01 00:00:00	2016-04-01 00:00:00	2016-07-01 00:00:00	2016-10-01 00:00:00	2016-10-01 00:00:00	2016-10-01 00:00:00	2016-12-16 00:00:00	2016-07-01 00:00:00	2016-10-01 00:00:00	2017-01-01 00:00:00	1900-01-01 00:00:00	2017-04-01 00:00:00	2017-01-01 00:00:00	2017-06-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2017-06-30 00:00:00	2019-07-01 00:00:00	1900-01-01 00:00:00	2018-04-01 00:00:00	2017-07-01 00:00:00	2020-01-01 00:00:00	2020-01-01 00:00:00	1900-01-01 00:00:00	2018-07-01 00:00:00	2020-01-01 00:00:00	2018-12-14 00:00:00	2020-04-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2019-04-01 00:00:00	2018-01-01 00:00:00	1900-01-01 00:00:00	2019-01-01 00:00:00	2018-12-14 00:00:00	2020-12-31 00:00:00	2019-10-01 00:00:00	1900-01-01 00:00:00	2020-07-02 00:00:00	2020-07-01 00:00:00	1900-01-01 00:00:00	2022-01-01 00:00:00	2021-04-01 00:00:00	2020-11-30 00:00:00	2021-07-01 00:00:00	2021-01-01 00:00:00	2020-07-01 00:00:00	2020-04-01 00:00:00	1900-01-01 00:00:00	2021-10-01 00:00:00	1900-01-01 00:00:00	2022-04-01 00:00:00	2022-07-01 00:00:00
rpt_end	2000-09-30 00:00:00	2000-03-31 00:00:00	None	2000-06-30 00:00:00	2000-09-30 00:00:00	2000-12-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2000-12-31 00:00:00	2001-03-31 00:00:00	1900-01-01 00:00:00	2001-03-31 00:00:00	2001-09-30 00:00:00	2001-06-30 00:00:00	1900-01-01 00:00:00	2001-06-01 00:00:00	1900-01-01 00:00:00	2001-09-30 00:00:00	2001-12-31 00:00:00	2001-12-31 00:00:00	2002-03-31 00:00:00	2000-12-31 00:00:00	2002-03-31 00:00:00	2002-06-30 00:00:00	1900-01-01 00:00:00	2002-06-30 00:00:00	2002-09-30 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	1900-01-01 00:00:00	2002-09-30 00:00:00	2002-12-31 00:00:00	2002-12-31 00:00:00	2003-03-31 00:00:00	2003-03-31 00:00:00	2003-06-30 00:00:00	2003-09-30 00:00:00	2003-06-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2003-09-30 00:00:00	2003-12-31 00:00:00	2003-12-31 00:00:00	2003-09-30 00:00:00	2003-06-30 00:00:00	2003-03-31 00:00:00	2004-03-31 00:00:00	2004-03-31 00:00:00	2003-12-31 00:00:00	2004-06-30 00:00:00	2004-03-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2004-06-30 00:00:00	2004-09-30 00:00:00	1900-01-01 00:00:00	2004-09-30 00:00:00	2004-12-31 00:00:00	1900-01-01 00:00:00	2004-12-31 00:00:00	1900-01-01 00:00:00	2005-06-30 00:00:00	2005-09-30 00:00:00	2005-03-31 00:00:00	1900-01-01 00:00:00	2004-12-31 00:00:00	1900-01-01 00:00:00	2006-04-14 00:00:00	2006-03-31 00:00:00	1900-01-01 00:00:00	2005-12-31 00:00:00	2007-01-03 00:00:00	2006-09-30 00:00:00	2006-06-30 00:00:00	2007-03-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2007-06-30 00:00:00	2007-07-30 00:00:00	2006-12-31 00:00:00	2007-06-29 00:00:00	1900-01-01 00:00:00	2006-12-31 00:00:00	2008-12-31 00:00:00	2006-12-31 00:00:00	2007-12-31 00:00:00	2006-06-30 00:00:00	2006-09-30 00:00:00	2007-09-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2013-03-31 00:00:00	2015-03-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2015-06-30 00:00:00	2015-03-31 00:00:00	1900-01-01 00:00:00	2014-03-31 00:00:00	2014-06-30 00:00:00	2014-06-02 00:00:00	2014-03-31 00:00:00	2014-06-30 00:00:00	1900-01-01 00:00:00	2013-06-30 00:00:00	2013-10-31 00:00:00	1900-01-01 00:00:00	2014-01-16 00:00:00	2013-09-30 00:00:00	2013-09-30 00:00:00	1900-01-01 00:00:00	2014-09-30 00:00:00	2014-12-31 00:00:00	2015-02-09 00:00:00	2015-02-09 00:00:00	1900-01-01 00:00:00	2014-12-31 00:00:00	2014-09-30 00:00:00	2014-12-31 00:00:00	1900-01-01 00:00:00	2014-09-30 00:00:00	1900-01-01 00:00:00	2008-03-31 00:00:00	2008-06-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2008-09-30 00:00:00	2008-12-31 00:00:00	2008-12-22 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2009-03-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2009-06-30 00:00:00	2009-06-18 00:00:00	1900-01-01 00:00:00	2009-09-30 00:00:00	1900-01-01 00:00:00	2009-12-31 00:00:00	1900-01-01 00:00:00	2010-03-31 00:00:00	2010-06-30 00:00:00	2010-09-30 00:00:00	2010-12-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2011-06-30 00:00:00	2011-09-30 00:00:00	2011-03-31 00:00:00	2011-12-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2012-03-31 00:00:00	2012-06-30 00:00:00	2012-06-30 00:00:00	2012-03-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2014-12-31 00:00:00	2014-09-30 00:00:00	2014-12-23 00:00:00	2014-12-31 00:00:00	2014-06-30 00:00:00	1900-01-01 00:00:00	2014-12-30 00:00:00	2012-12-10 00:00:00	2012-09-30 00:00:00	2012-12-31 00:00:00	2014-12-31 00:00:00	2013-03-06 00:00:00	1900-01-01 00:00:00	2013-03-31 00:00:00	2015-09-30 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	1900-01-01 00:00:00	2017-12-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	2018-12-31 00:00:00	2019-09-05 00:00:00	2020-12-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	1900-01-01 00:00:00	1900-01-01 00:00:00	2015-12-31 00:00:00	2015-12-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2016-03-31 00:00:00	1900-01-01 00:00:00	2016-06-30 00:00:00	2016-09-30 00:00:00	2016-12-31 00:00:00	2016-12-31 00:00:00	2016-12-31 00:00:00	2016-12-16 00:00:00	2016-09-30 00:00:00	2016-12-31 00:00:00	2017-03-31 00:00:00	1900-01-01 00:00:00	2017-06-30 00:00:00	2017-03-31 00:00:00	2017-06-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2017-06-30 00:00:00	2019-09-30 00:00:00	1900-01-01 00:00:00	2018-06-30 00:00:00	2017-09-30 00:00:00	2020-03-31 00:00:00	2020-03-31 00:00:00	1900-01-01 00:00:00	2018-09-30 00:00:00	2020-03-31 00:00:00	2018-12-14 00:00:00	2020-07-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2019-06-30 00:00:00	2018-03-31 00:00:00	1900-01-01 00:00:00	2019-03-31 00:00:00	2018-12-14 00:00:00	2020-12-31 00:00:00	2019-12-31 00:00:00	1900-01-01 00:00:00	2020-07-02 00:00:00	2020-09-30 00:00:00	1900-01-01 00:00:00	2022-03-31 00:00:00	2021-06-30 00:00:00	2020-11-30 00:00:00	2021-09-30 00:00:00	2021-03-31 00:00:00	2020-09-30 00:00:00	2020-06-30 00:00:00	1900-01-01 00:00:00	2021-12-31 00:00:00	1900-01-01 00:00:00	2022-06-30 00:00:00	2022-09-30 00:00:00
rpt_date	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
filing_type	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	22001	22001	None	None	22001	22001	None	None	None	22001	None	None	None	None	22001	22001	None	22001	None	None	None	None	None	None	22001	None	None	22001	None	22001	22001	22001	None	None	None	22001	22001	None	22001	22006	22001	22001	22006	None	None	None	22006	22006	22001	22006	None	22006	22006	None	22006	22006	22006	22006	None	None	22006	22006	None	None	22006	22006	None	22006	22006	22006	22006	22006	None	22006	22006	None	22001	22006	22006	None	22006	22006	22006	22006	None	22006	22006	22006	None	22006	None	22006	22006	None	None	22006	22006	22006	None	None	None	22006	None	None	22006	22001	None	22006	None	22006	None	22006	22006	22006	22006	None	None	None	22006	22006	22006	22006	None	None	22006	22006	22006	22006	None	None	None	22006	22006	22001	22006	22006	None	22006	22006	22006	22006	22006	22006	None	22006	22006	None	None	None	None	None	22006	None	None	None	None	22006	22001	22001	None	None	None	None	None	None	22006	22006	None	None	None	22006	None	22006	22006	22006	22006	22006	22006	22006	22006	22006	None	22006	22006	22006	None	None	22006	22006	None	22006	22006	22006	22006	None	22006	22006	22006	22006	None	None	None	22006	22006	None	22006	22006	22001	22006	None	22001	22006	None	22001	22001	22001	22001	22001	22006	22006	None	22001	None	22001	22001

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

Table: filer_xref
filer_id		1222890
xref_id		1222890
effect_dt		2000-04-14 00:00:00
migration_source		CLAIMS

Table: filername
xref_filer_id	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890
filer_id	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890
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	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	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	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE
effect_dt	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	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	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN, MICHAEL B.	KNUDSEN, MICHAEL B.	KNUDSEN, MICHAEL B.	KNUDSEN, MICHAEL B.	KNUDSEN, MICHAEL B.	KNUDSEN, MICHAEL B.	KNUDSEN, MICHAEL B.	KNUDSEN, MICHAEL B.	KNUDSEN, MICHAEL B.	KNUDSEN, MICHAEL B.	KNUDSEN, MICHAEL B.	KNUDSEN, MICHAEL B.	KNUDSEN, MICHAEL B.	KNUDSEN, MICHAEL B.	KNUDSEN, MICHAEL B.	KNUDSEN, MICHAEL B.	KNUDSEN, MICHAEL B.
namf	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
adr1	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
adr2	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	NEWCASTLE	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	NEWCASTLE	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	NEWCASTLE	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	NEWCASTLE	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	NEWCASTLE	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	NEWCASTLE	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	NEWCASTLE	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	NEWCASTLE	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	NEWCASTLE	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	NEWCASTLE	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	NEWCASTLE	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	NEWCASTLE	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	NEWCASTLE	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO
st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	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	95658	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95658	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95658	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95658	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95658	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95658	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95658	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95658	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95658	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95658	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95658	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95658	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95658	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814
phon	9164467100	None	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164467100	None	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164467100	None	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164467100	None	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164467100	None	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164467100	None	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164467100	None	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164467100	None	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164467100	None	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164467100	None	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164467100	None	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164467100	None	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164467100	None	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500	9164487500
fax	9164467105	None	9164413549	9164455624	9164455624	9164455624	9169142191	9169142191	9169142191	9169142191	9169142191		9169142191					9164467105	None	9164413549	9164455624	9164455624	9164455624	9169142191	9169142191	9169142191	9169142191	9169142191		9169142191					9164467105	None	9164413549	9164455624	9164455624	9164455624	9169142191	9169142191	9169142191	9169142191	9169142191		9169142191					9164467105	None	9164413549	9164455624	9164455624	9164455624	9169142191	9169142191	9169142191	9169142191	9169142191		9169142191					9164467105	None	9164413549	9164455624	9164455624	9164455624	9169142191	9169142191	9169142191	9169142191	9169142191		9169142191					9164467105	None	9164413549	9164455624	9164455624	9164455624	9169142191	9169142191	9169142191	9169142191	9169142191		9169142191					9164467105	None	9164413549	9164455624	9164455624	9164455624	9169142191	9169142191	9169142191	9169142191	9169142191		9169142191					9164467105	None	9164413549	9164455624	9164455624	9164455624	9169142191	9169142191	9169142191	9169142191	9169142191		9169142191					9164467105	None	9164413549	9164455624	9164455624	9164455624	9169142191	9169142191	9169142191	9169142191	9169142191		9169142191					9164467105	None	9164413549	9164455624	9164455624	9164455624	9169142191	9169142191	9169142191	9169142191	9169142191		9169142191					9164467105	None	9164413549	9164455624	9164455624	9164455624	9169142191	9169142191	9169142191	9169142191	9169142191		9169142191					9164467105	None	9164413549	9164455624	9164455624	9164455624	9169142191	9169142191	9169142191	9169142191	9169142191		9169142191					9164467105	None	9164413549	9164455624	9164455624	9164455624	9169142191	9169142191	9169142191	9169142191	9169142191		9169142191
email	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]

Table: filers
filer_id		1222890

Table: lobbying_chg_log
filer_id	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890
change_no	1	3	2	6	4	7	8	9	10	11	0	13	15	12	19	14	16	17	18	21	22	20	23	24	25	26	27	28	32	33	34	35	29	36	30	31	37	38	39	40	42	43	45	46	44	41	47	48
session_id	1999	2001	2001	2001	2001	2001	2001	2003	2003	2003	2005	2007	2007	2007	2009	2007	2009	2009	2009	2011	2011	2009	2011	2013	2013	2013	2013	2015	2015	2015	2015	2015	2015	2015	2015	2015	2017	2017	2017	2017	2019	2019	2019	2019	2019	2017	2021	2021
log_dt	2000-10-25 00:00:00	2001-03-19 00:00:00	2001-03-19 00:00:00	2001-10-05 00:00:00	2001-07-09 00:00:00	2001-11-01 00:00:00	2002-08-05 00:00:00	2003-05-21 00:00:00	2004-01-08 00:00:00	2005-09-27 00:00:00	2005-01-21 00:00:00	2007-07-31 00:00:00	2008-09-09 00:00:00	2007-07-11 00:00:00	2010-02-17 00:00:00	2008-05-15 00:00:00	2009-06-05 00:00:00	2009-05-27 00:00:00	2010-01-27 00:00:00	2011-03-10 00:00:00	2011-08-22 00:00:00	2010-12-23 00:00:00	2012-04-09 00:00:00	2013-03-06 00:00:00	2013-11-07 00:00:00	2014-06-30 00:00:00	2014-11-05 00:00:00	2015-05-05 00:00:00	2015-11-13 00:00:00	2015-12-16 00:00:00	2016-01-25 00:00:00	2016-01-15 00:00:00	2015-06-08 00:00:00	2016-06-21 00:00:00	2015-10-23 00:00:00	2015-11-06 00:00:00	2017-06-01 00:00:00	2017-06-30 00:00:00	2018-04-25 00:00:00	2018-07-24 00:00:00	2019-10-30 00:00:00	2020-03-12 00:00:00	2020-11-23 00:00:00	2020-11-23 00:00:00	2020-08-31 00:00:00	2018-04-25 00:00:00	2020-12-30 00:00:00	2020-12-30 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	3	3	3	3	3	3	3	3	3	3	3	3	3	3
correction_flg	None	None	None	Y	Y	Y	Y	Y	Y	None	None	Y	Y	Y	Y	Y	Y	Y	None	Y	Y	Y	None	Y	None	None	None	Y	Y	Y	Y	None	Y	Y	Y	Y	Y	Y	Y	Y	None	None	None	None	None	Y	None	None
action	SET ACTIVE	IN SUSPENSE	IN SUSPENSE	NEW	NEW	DELETED	ADDED	DELETED	DELETED	DELETED	ADDED	ADDED	ADDED	DELETED	DELETED	DELETED	ADDED	ADDED	DELETED	ADDED	ADDED	TERMINATED	DELETED	ADDED	ADDED	ADDED	DELETED	ADDED	ADDED	DELETED	DELETED	DELETED	ADDED	TERMINATED	ADDED	ADDED	DELETED	ADDED	DELETED	DELETED	DELETED	DELETED	ADDED	ADDED	SET ACTIVE	ADDED	ADDED	ADDED
attribute_changed	BASE RECORD	CLIENT	CLIENT	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	None	None	CLIENT	CLIENT/FIRM	CLIENT	/FIRM	LOBBYIST	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	FIRM	EMPLOYER	EMPLOYER	LOBBYIST	CLIENT	EMPLOYER	CLIENT	CLIENT	LOBBYIST	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	FIRM	LOBBYIST	LOBBYIST	EMPLOYER	/ FIRM	EMPLOYER	EMPLOYER	LOBBYIST	EMPLOYER	FIRM	CLIENT	CLIENT	CLIENT	CLIENT	LOBBYIST	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	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None
filer_full_name	KNUDSEN, MICHAEL B.	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES	KNUDSEN & ASSOCIATES
filer_city	None	None	None	None	None	None	None	SACRAMENTO	None	None	None	SACRAMENTO	SACRAMENTO	None	None	None	None	None	None	SACRAMENTO	None	None	None	None	None	None	None	None	SACRAMENTO	None	None	None	SACRAMENTO	None	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	None	None	None	None	None	None	None	SACRAMENTO	None	None
filer_st	None	None	None	None	None	None	None	CA	None	None	None	CA	CA	None	None	None	None	None	None	CA	None	None	None	None	None	None	None	None	CA	None	None	None	CA	None	CA	CA	CA	CA	None	None	None	None	None	None	None	CA	None	None
filer_zip	None	None	None	None	None	None	None	95814	None	None	None	95814	95814	None	None	None	None	None	None	95814	None	None	None	None	None	None	None	None	95814	None	None	None	95814	None	95814	95814	95814	95814	None	None	None	None	None	None	None	95814	None	None
filer_phone	None	None	None	None	None	None	None	9164467100	None	None	None	9164487500	9164487500	None	None	None	None	None	None	9164487500	None	None	None	None	None	None	None	None	9164467100	None	None	None	9164467100	None	9164467100	9164467100	9164467100	9164467100	None	None	None	None	None	None	None	9164467100	None	None
entity_type	3	3	3	2	2	2	2	2	3	1	3	3	1	4	2	2	2	2	3	2	2	4	1	2	1	1	4	2	2	2	2	3	4	4	2	1	2	2	4	2	3	1	1	1	1	4	1	1
entity_name	None	PUBLIC POLICY ADVOCATES, LLC	PUBLIC POLICY ADVOCATES, LLC	BALLY TOTAL FITNESS	INNOVENTRY	INNOVENTRY	H.D. VEST	H.D. VEST, INC.	PUBLIC POLICY ADVOCATES, LLC	ENVIROSYSTEMS, INC.	CALIFORNIA STRATEGIES & ADVOCACY, LLC	LANG HANSEN O'MALLEY AND MILLER GOVERNMENTAL RELATIONS	PACIFIC STRATEGY GROUP	COLEMAN, BRENDA M.	JOHN HANCOCK	BALLY TOTAL FITNESS	JOHN HANCOCK	STUDEX CORPORATION	GOVERNMENTAL ADVOCATES, INC.	STUDEX CORPORATION	CALIFORNIA STATE PARKS PEACE OFFICER MANAGEMENT ASSOCIATION	LA CROSSE, JANINE M.	STUDEX CORPORATION	PROGRESO FINANCIERO	MYELIN PROJECT; THE	BRINKER INTERNATIONAL, INC	HALEY LAUREN STAUSS	CLEAR BALLOT	BE A HERO, BECOME A DONOR FOUNDATION	BE A HERO, BECOME A DONOR FOUNDATION	CLEAR BALLOT	BROAD & GUSMAN, LLP	CANTABERRY, EMILY M.	CANTABERRY, EMILY M.	ACCENTURE LLP	CARPENTER SIEVERS LLC	ACCENTURE LLP	BRIDGESTONE AMERICAS, INC.	KNUDSEN, BETHANY	BRIDGESTONE AMERICAS, INC.	PLATINUM ADVISORS, LLC	INTERNATIONAL BOTTLED WATER ASSOCIATION	HIKARU INC.	CALIFORNIA PROFESSIONAL MESSAGE THERAPY COALITION	BURKE WILLIAMS	KNUDSEN, JOSHUA	CALIFORNIA PROFESSIONAL MASSAGE THERAPY COALITION	HIKARU INC.
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	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	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	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None
entity_id	0	1147315	1147315	1238818	1236263	1236263	1145117	None	1147315	1250858	1273600	None	None	1293493	1146599	1238818	1146599	1319263	1147293	None	1341871	1314258	1319263	1356149	1361658	1367751	1358541	1374975	None	1367873	1374975	1147504	None	1377841	None	None	None	None	1392997	1397646	1147749	1253580	1435073	1435075	1430658	None	1435075	1435073
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	None	None	None	None	None	None	None	None	None	None	None	None	None	None
effect_dt	None	None	None	2001-10-05 00:00:00	2001-07-05 00:00:00	2001-11-01 00:00:00	2002-08-05 00:00:00	2003-04-01 00:00:00	2004-01-01 00:00:00	2004-03-31 00:00:00	2005-01-21 00:00:00	2007-07-27 00:00:00	2008-09-04 00:00:00	2007-06-29 00:00:00	2010-02-17 00:00:00	2008-03-31 00:00:00	2009-06-01 00:00:00	2009-05-26 00:00:00	2009-09-30 00:00:00	2011-03-06 00:00:00	2011-08-15 00:00:00	2010-12-20 00:00:00	2011-12-31 00:00:00	2013-03-05 00:00:00	2013-10-31 00:00:00	2014-07-01 00:00:00	2014-08-29 00:00:00	2015-02-09 00:00:00	2015-10-26 00:00:00	2015-12-14 00:00:00	2016-01-20 00:00:00	2015-12-31 00:00:00	2015-06-08 00:00:00	2016-06-09 00:00:00	2015-10-21 00:00:00	2015-11-05 00:00:00	2017-06-01 00:00:00	2017-06-01 00:00:00	2018-03-30 00:00:00	2018-07-23 00:00:00	2019-10-14 00:00:00	2020-03-12 00:00:00	2020-11-10 00:00:00	2020-11-01 00:00:00	2020-08-27 00:00:00	2018-04-25 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00

Table: received_filings
filer_id	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890	1222890
filing_file_name	679583_0.cal	719789_0.cal	770136_0.cal	746328_0.cal	792112_0.cal	813277_0.cal	839467_0.cal	852848_0.cal	883579_0.cal	911018_0.cal	930240_0.cal	945941_0.cal	968194_0.cal	248066.cal	1226412_1.cal	1226412_0.cal	329886.cal	1226412_2.cal	1384783_0.cal	1716758_1.cal	1716758_2.cal	365103.cal	365179.cal	365268.cal	365346.cal	365237.cal	365308.cal	1716758_0.cal	1716758_3.cal	1716758_4.cal	2111650_0.cal	1922030_0.cal	2111650_1.cal	2111650_2.cal	124011.cal	124515.cal	2328224_1.cal	2328224_0.cal	406439.cal	2540613_0.cal
received_date	2000-10-28 00:00:00	2001-01-31 00:00:00	2001-07-26 00:00:00	2001-04-30 00:00:00	2001-10-31 00:00:00	2002-01-30 00:00:00	2002-04-30 00:00:00	2002-07-29 00:00:00	2002-10-30 00:00:00	2003-01-30 00:00:00	2003-04-29 00:00:00	2003-07-29 00:00:00	2003-10-28 00:00:00	2004-07-30 00:00:00	2007-06-29 00:00:00	2007-01-03 00:00:00	2007-02-06 00:00:00	2007-07-30 00:00:00	2008-12-22 00:00:00	2013-03-06 00:00:00	2013-10-31 00:00:00	2014-01-16 00:00:00	2014-01-16 00:00:00	2014-01-16 00:00:00	2014-01-16 00:00:00	2014-01-16 00:00:00	2014-01-16 00:00:00	2012-12-10 00:00:00	2014-06-02 00:00:00	2014-06-30 00:00:00	2016-12-16 00:00:00	2014-12-30 00:00:00	2017-06-01 00:00:00	2017-06-30 00:00:00	2020-08-10 00:00:00	2020-08-10 00:00:00	2018-12-14 00:00:00	2018-12-14 00:00:00	2021-09-15 00:00:00	2020-12-30 00:00:00
filing_directory	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal
filing_id	679583	719789	770136	746328	792112	813277	839467	852848	883579	911018	930240	945941	968194	None	1226412	1226412	None	1226412	1384783	1716758	1716758	None	None	None	None	None	None	1716758	1716758	1716758	2111650	1922030	2111650	2111650	None	None	2328224	2328224	None	2540613
form_id	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	None	F601	F601	None	F601	F601	F601	F601	None	None	None	None	None	None	F601	F601	F601	F601	F601	F601	F601	None	None	F601	F601	None	F601
receive_comment	Filing accepted, but with warnings	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	Filing accepted