Home

Filer ID: 1231781

Table: cvr_lobby_disclosure

filing_id		794436		794437		794438		806740		836140		850516		875463		902974		928030		942736		965115		985417		1009199		1009199		1009199		1028250		1052489		1073898		1100728		1132356		1182466		1160491		1073898		1117951		1141922		1228145		1160491		1228145		1216040		1256049		1277219		1216040		1182466		1366792		1293444		1342954		1303207		1328303		1447294		1388921		1430578		1417034		1456981		1521583		1499041		1477027		1557630		1616466		1616466		1598562		1557630		1587797		1627857		1692438		1670103		1651401		1722866		1792826		1808761		1774134		1754528		1890819		1860819		1837241		1924087		1990258		1972567		1956048		2026022		2002194		2084333		2053226		2165311		2150537		2119216		2186614		2302760		2263172		2227289		2200055		2389627		2332721		2369705		2410990		2464557		2476057		2428285		2464557		2543158		2573364		2590757		2629190		2633549		2662702		2696213		2732667
amend_id		0		0		0		0		0		0		0		0		0		0		0		0		0		1		2		0		0		0		0		0		0		0		1		0		0		0		1		1		1		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		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
sender_id		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781
filer_id		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781
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
filer_naml		LAW OFFICES OF FRED JONES		LAW OFFICES OF FRED JONES		LAW OFFICES OF FRED JONES		LAW OFFICES OF FRED JONES		LAW OFFICES OF FRED JONES		LAW OFFICES OF FRED JONES		LAW OFFICES OF FRED JONES		LAW OFFICES OF FRED JONES		LAW OFFICES OF FRED JONES		LAW OFFICES OF FRED JONES		LAW OFFICES OF FRED JONES		LAW OFFICES OF FRED JONES		LAW OFFICES OF FRED JONES		LAW OFFICES OF FRED JONES		LAW OFFICES OF FRED JONES		LAW OFFICES OF FRED JONES		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED
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
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
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
report_num		000		000		000		000		000		000		000		000		000		000		000		000		000		001		002		000		000		000		000		000		000		000		001		000		000		000		001		001		001		000		000		000		001		000		000		000		000		000		000		000		000		000		000		000		000		000		000		001		000		000		001		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		001		000		000		000		000		000		000		000		000
rpt_date		2001-11-06 00:00:00		2001-11-06 00:00:00		2001-11-06 00:00:00		2002-01-14 00:00:00		2002-01-19 00:00:00		2002-07-22 00:00:00		2002-10-19 00:00:00		2003-01-17 00:00:00		2003-01-17 00:00:00		2003-01-17 00:00:00		2003-10-17 00:00:00		2004-01-23 00:00:00		2004-04-15 00:00:00		2004-07-16 00:00:00		2004-07-29 00:00:00		2004-07-29 00:00:00		2004-10-23 00:00:00		2005-01-21 00:00:00		2005-04-18 00:00:00		2005-10-28 00:00:00		2006-07-05 00:00:00		2006-04-04 00:00:00		2005-06-06 00:00:00		2005-07-31 00:00:00		2006-01-13 00:00:00		2007-01-16 00:00:00		2007-09-13 00:00:00		2007-09-13 00:00:00		2007-09-13 00:00:00		2007-04-10 00:00:00		2007-07-12 00:00:00		2006-10-31 00:00:00		2007-09-13 00:00:00		2008-10-17 00:00:00		2007-10-18 00:00:00		2008-07-11 00:00:00		2008-01-11 00:00:00		2008-04-29 00:00:00		2009-10-09 00:00:00		2009-01-12 00:00:00		2009-07-14 00:00:00		2009-04-12 00:00:00		2010-01-07 00:00:00		2010-10-04 00:00:00		2010-07-02 00:00:00		2010-04-01 00:00:00		2011-01-06 00:00:00		2011-11-09 00:00:00		2011-10-05 00:00:00		2011-07-01 00:00:00		2011-02-28 00:00:00		2011-04-22 00:00:00		2012-01-11 00:00:00		2012-10-01 00:00:00		2012-07-06 00:00:00		2012-04-10 00:00:00		2013-01-07 00:00:00		2013-10-07 00:00:00		2014-01-06 00:00:00		2013-07-09 00:00:00		2013-04-02 00:00:00		2014-10-02 00:00:00		2014-07-02 00:00:00		2014-04-09 00:00:00		2015-01-09 00:00:00		2015-10-01 00:00:00		2015-07-01 00:00:00		2015-04-06 00:00:00		2016-04-05 00:00:00		2016-01-04 00:00:00		2016-10-03 00:00:00		2016-07-01 00:00:00		2017-07-03 00:00:00		2017-04-11 00:00:00		2017-01-12 00:00:00		2017-10-05 00:00:00		2018-10-05 00:00:00		2018-07-09 00:00:00		2018-04-03 00:00:00		2018-01-04 00:00:00		2019-07-11 00:00:00		2019-01-08 00:00:00		2019-04-01 00:00:00		2019-10-01 00:00:00		2020-04-01 00:00:00		2020-07-02 00:00:00		2020-01-06 00:00:00		2020-10-21 00:00:00		2021-01-10 00:00:00		2021-04-10 00:00:00		2021-07-05 00:00:00		2021-11-22 00:00:00		2022-01-10 00:00:00		2022-04-04 00:00:00		2022-07-01 00:00:00		2022-10-13 00:00:00
from_date		2001-07-01 00:00:00		2001-04-01 00:00:00		2001-01-01 00:00:00		2001-10-01 00:00:00		2002-01-01 00:00:00		2002-04-01 00:00:00		2002-07-01 00:00:00		2002-10-01 00:00:00		2003-01-01 00:00:00		2003-04-01 00:00:00		2003-07-01 00:00:00		2003-10-01 00:00:00		2004-01-01 00:00:00		2004-04-01 00:00:00		2004-01-01 00:00:00		2004-04-01 00:00:00		2004-07-01 00:00:00		2004-10-01 00:00:00		2005-01-01 00:00:00		2005-07-01 00:00:00		2006-04-01 00:00:00		2006-01-01 00:00:00		2004-10-01 00:00:00		2005-04-01 00:00:00		2005-10-01 00:00:00		2006-10-01 00:00:00		2006-01-01 00:00:00		2006-10-01 00:00:00		2006-07-01 00:00:00		2007-01-01 00:00:00		2007-04-01 00:00:00		2006-07-01 00:00:00		2006-04-01 00:00:00		2008-07-01 00:00:00		2007-07-01 00:00:00		2008-04-01 00:00:00		2007-10-01 00:00:00		2008-01-01 00:00:00		2009-07-01 00:00:00		2008-10-01 00:00:00		2009-04-01 00:00:00		2009-01-01 00:00:00		2009-10-01 00:00:00		2010-07-01 00:00:00		2010-04-01 00:00:00		2010-01-01 00:00:00		2010-10-01 00:00:00		2011-07-01 00:00:00		2011-07-01 00:00:00		2011-04-01 00:00:00		2010-10-01 00:00:00		2011-01-01 00:00:00		2011-10-01 00:00:00		2012-07-01 00:00:00		2012-04-01 00:00:00		2012-01-01 00:00:00		2012-10-01 00:00:00		2013-07-01 00:00:00		2013-10-01 00:00:00		2013-04-01 00:00:00		2013-01-01 00:00:00		2014-07-01 00:00:00		2014-04-01 00:00:00		2014-01-01 00:00:00		2014-10-01 00:00:00		2015-07-01 00:00:00		2015-04-01 00:00:00		2015-01-01 00:00:00		2016-01-01 00:00:00		2015-10-01 00:00:00		2016-07-01 00:00:00		2016-04-01 00:00:00		2017-04-01 00:00:00		2017-01-01 00:00:00		2016-10-01 00:00:00		2017-07-01 00:00:00		2018-07-01 00:00:00		2018-04-01 00:00:00		2018-01-01 00:00:00		2017-10-01 00:00:00		2019-04-01 00:00:00		2018-10-01 00:00:00		2019-01-01 00:00:00		2019-07-01 00:00:00		2020-01-01 00:00:00		2020-04-01 00:00:00		2019-10-01 00:00:00		2020-01-01 00:00:00		2020-10-01 00:00:00		2021-01-01 00:00:00		2021-04-01 00:00:00		2021-07-01 00:00:00		2021-10-01 00:00:00		2022-01-01 00:00:00		2022-04-01 00:00:00		2022-07-01 00:00:00
thru_date		2001-09-30 00:00:00		2001-06-30 00:00:00		2001-03-31 00:00:00		2001-12-31 00:00:00		2002-03-31 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		2002-12-31 00:00:00		2003-03-31 00:00:00		2003-06-30 00:00:00		2003-09-30 00:00:00		2003-12-31 00:00:00		2004-03-31 00:00:00		2004-06-30 00:00:00		2004-03-31 00:00:00		2004-06-30 00:00:00		2004-09-30 00:00:00		2004-12-31 00:00:00		2005-03-31 00:00:00		2005-09-30 00:00:00		2006-06-30 00:00:00		2006-03-31 00:00:00		2004-12-31 00:00:00		2005-06-30 00:00:00		2005-12-31 00:00:00		2006-12-31 00:00:00		2006-03-31 00:00:00		2006-12-31 00:00:00		2006-09-30 00:00:00		2007-03-31 00:00:00		2007-06-30 00:00:00		2006-09-30 00:00:00		2006-06-30 00:00:00		2008-09-30 00:00:00		2007-09-30 00:00:00		2008-06-30 00:00:00		2007-12-31 00:00:00		2008-03-31 00:00:00		2009-09-30 00:00:00		2008-12-31 00:00:00		2009-06-30 00:00:00		2009-03-31 00:00:00		2009-12-31 00:00:00		2010-09-30 00:00:00		2010-06-30 00:00:00		2010-03-31 00:00:00		2019-12-31 00:00:00		2011-09-30 00:00:00		2011-09-01 00:00:00		2011-06-30 00:00:00		2010-12-31 00:00:00		2011-03-31 00:00:00		2011-12-31 00:00:00		2012-09-30 00:00:00		2012-06-30 00:00:00		2012-03-31 00:00:00		2012-12-31 00:00:00		2013-09-30 00:00:00		2013-12-31 00:00:00		2013-06-30 00:00:00		2013-03-31 00:00:00		2014-09-30 00:00:00		2014-06-30 00:00:00		2014-03-31 00:00:00		2014-12-31 00:00:00		2015-09-30 00:00:00		2015-06-30 00:00:00		2015-03-31 00:00:00		2016-03-31 00:00:00		2015-12-31 00:00:00		2016-09-30 00:00:00		2016-06-30 00:00:00		2017-06-30 00:00:00		2017-03-31 00:00:00		2016-12-31 00:00:00		2017-09-30 00:00:00		2018-09-30 00:00:00		2018-06-30 00:00:00		2018-03-31 00:00:00		2017-12-31 00:00:00		2019-06-30 00:00:00		2018-12-31 00:00:00		2019-03-31 00:00:00		2019-09-30 00:00:00		2020-03-31 00:00:00		2020-06-30 00:00:00		2019-12-31 00:00:00		2020-03-31 00:00:00		2020-12-30 00:00:00		2021-03-31 00:00:00		2021-06-30 00:00:00		2021-09-30 00:00:00		2021-12-31 00:00:00		2022-03-31 00:00:00		2022-06-30 00:00:00		2022-09-30 00:00:00
cum_beg_dt		2001-01-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		2002-01-01 00:00:00		2002-01-01 00:00:00		2002-01-01 00:00:00		2002-01-01 00:00:00		2002-01-01 00:00:00		2002-01-01 00:00:00		2002-01-01 00:00:00		2003-01-01 00:00:00		2004-01-01 00:00:00		2004-01-01 00:00:00		2004-01-01 00:00:00		2004-01-01 00:00:00		2004-01-01 00:00:00		2004-01-01 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2006-01-01 00:00:00		2005-01-01 00:00:00		2004-01-01 00:00:00		None		2005-01-01 00:00:00		2006-01-01 00:00:00		2005-01-01 00:00:00		2006-01-01 00:00:00		2006-01-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2006-01-01 00:00:00		2006-01-01 00:00:00		2008-01-01 00:00:00		2007-01-01 00:00:00		2008-01-01 00:00:00		2007-01-01 00:00:00		2008-01-01 00:00:00		2009-01-01 00:00:00		2008-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		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		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2015-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00
firm_id		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781
firm_name		LAW OFFICES OF FRED JONES		LAW OFFICES OF FRED JONES		LAW OFFICES OF FRED JONES		LAW OFFICES OF FRED JONES		LAW OFFICES OF FRED JONES		LAW OFFICES OF FRED JONES		LAW OFFICES OF FRED JONES		LAW OFFICES OF FRED JONES		LAW OFFICES OF FRED JONES		LAW OFFICES OF FRED JONES		LAW OFFICES OF FRED JONES		LAW OFFICES OF FRED JONES		LAW OFFICES OF FRED JONES		LAW OFFICES OF FRED JONES		LAW OFFICES OF FRED JONES		LAW OFFICES OF FRED JONES		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
firm_city		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN
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
firm_zip4		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603
firm_phon		530-887-9944		530-887-9944		530-887-9944		530-887-9944		530-887-9944		530-887-9944		530-887-9944		530-887-9944		530-887-9944		530-887-9944		530-887-9944		530-887-9944		530-887-9944		530-887-9944		530-887-9944		530-887-9944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944
mail_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		AUBURN		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
mail_st		None						None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
mail_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		95603		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
mail_phon		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		5308879944		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sig_date		2001-11-06 00:00:00		2001-11-06 00:00:00		2001-11-06 00:00:00		2002-01-14 00:00:00		2002-04-19 00:00:00		2002-07-22 00:00:00		2002-10-19 00:00:00		2003-01-17 00:00:00		2003-04-19 00:00:00		2003-07-18 00:00:00		2003-10-17 00:00:00		2004-01-23 00:00:00		2004-04-15 00:00:00		2004-07-16 00:00:00		2004-07-29 00:00:00		2004-07-29 00:00:00		2004-10-23 00:00:00		2005-01-21 00:00:00		2005-04-18 00:00:00		2005-10-28 00:00:00		2006-07-05 00:00:00		2006-04-04 00:00:00		2005-06-06 00:00:00		2005-07-31 00:00:00		2006-01-13 00:00:00		2007-01-16 00:00:00		2007-09-13 00:00:00		2007-09-13 00:00:00		2007-09-13 00:00:00		2007-04-10 00:00:00		2007-07-12 00:00:00		2006-10-31 00:00:00		2007-09-13 00:00:00		2008-10-17 00:00:00		2007-10-18 00:00:00		2008-07-11 00:00:00		2008-01-11 00:00:00		2008-04-29 00:00:00		2009-10-09 00:00:00		2009-01-12 00:00:00		2009-07-14 00:00:00		2009-04-12 00:00:00		2010-01-07 00:00:00		2010-10-04 00:00:00		2010-07-02 00:00:00		2010-04-01 00:00:00		2011-01-06 00:00:00		2011-11-09 00:00:00		2011-10-05 00:00:00		2011-07-01 00:00:00		2011-02-28 00:00:00		2011-04-22 00:00:00		2012-01-11 00:00:00		2012-10-01 00:00:00		2012-07-06 00:00:00		2012-04-01 00:00:00		2013-01-07 00:00:00		2013-10-07 00:00:00		2014-01-06 00:00:00		2013-07-09 00:00:00		2013-04-02 00:00:00		2014-10-02 00:00:00		2014-07-02 00:00:00		2014-04-09 00:00:00		2015-01-09 00:00:00		2015-10-01 00:00:00		2015-07-01 00:00:00		2015-04-06 00:00:00		2016-04-05 00:00:00		2016-01-04 00:00:00		2016-10-03 00:00:00		2016-07-01 00:00:00		2017-07-03 00:00:00		2017-04-11 00:00:00		2017-01-12 00:00:00		2017-10-05 00:00:00		2018-10-05 00:00:00		2018-07-09 00:00:00		2018-01-03 00:00:00		2018-01-04 00:00:00		2019-07-11 00:00:00		2019-01-08 00:00:00		2019-04-01 00:00:00		2019-10-01 00:00:00		2020-04-01 00:00:00		2020-07-02 00:00:00		2020-01-06 00:00:00		2020-10-21 00:00:00		2021-01-10 00:00:00		2021-04-10 00:00:00		2021-07-05 00:00:00		2021-11-22 00:00:00		2022-01-10 00:00:00		2022-04-04 00:00:00		2022-07-01 00:00:00		2022-10-13 00:00:00
sig_loc		Auburn CA		Auburn CA		Auburn CA		Auburn California		Auburn		Auburn CA		Auburn CA		Auburn CA		Auburn CA		Auburn CA		Auburn CA		AUBURN CA		Auburn CA		Auburn CA		Auburn CA		Auburn CA		Auburn, California		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		AUBURN, CA		AUBURN, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, Ca		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA		Auburn, CA
sig_naml		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		JONES		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		JONES		JONES		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones
sig_namf		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		FRED		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		FRED		FRED		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred
sig_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
prn_naml		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		JONES		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		JONES		JONES		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones
prn_namf		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		FRED		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		FRED		FRED		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred
prn_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
sig_title		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		OWNER		Owner		Owner		Owner		Owner		None		Owner		Owner		owner		Owner		Owner		Owner/Lobbyist		BOARD SECRETARY		OWNER		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Legal Counsel		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner
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
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
part1_1_cb		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X
part1_2_cb								None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
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
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
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
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
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
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
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
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

Table: cvr_registration

filing_id		1222943		1384401		1546580		1718945		1917096		2110711		2328293		2536343
amend_id		0		0		0		0		0		0		0		0
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F601		F601		F601		F601		F601		F601		F601		F601
sender_id		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781
filer_id		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781
entity_cd		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM
filer_naml		JONES, LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED
filer_namf		None		None		None		None		None		None		None		None
filer_namt		None		None		None		None		None		None		None		None
filer_nams		None		None		None		None		None		None		None		None
report_num		000		000		000		000		000		000		000		000
rpt_date		2006-12-04 00:00:00		2008-12-18 00:00:00		2010-11-29 00:00:00		2012-12-20 00:00:00		2014-12-05 00:00:00		2016-12-13 00:00:00		2018-12-17 00:00:00		2020-12-08 00:00:00
ls_beg_yr		2007		2009		2011		2013		2015		2017		2019		2021
ls_end_yr		2008		2010		2012		2014		2016		2018		2020		2022
qual_date		2007-01-01 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2021-01-01 00:00:00
eff_date		None		None		None		None		None		None		None		None
bus_city		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN
bus_st		CA		CA		CA		CA		CA		CA		CA		CA
bus_zip4		95603		95603		95603		95603		95603		95603		95603		95603
bus_phon		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944
bus_fax		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000
bus_email		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]
mail_city		None		None		None		None		None		None		None		None
mail_st		None		None		None		None		None		None		None		None
mail_zip4		None		None		None		None		None		None		None		None
mail_phon		None		None		None		None		None		None		None		None
sig_date		2006-12-04 00:00:00		2008-12-18 00:00:00		2010-11-29 00:00:00		2012-12-20 00:00:00		2014-12-05 00:00:00		2016-12-13 00:00:00		2018-12-17 00:00:00		2020-12-08 00:00:00
sig_loc		None		None		None		None		None		None		None		None
sig_naml		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones
sig_namf		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred
sig_namt		None		None		None		None		None		None		None		None
sig_nams		None		None		None		None		None		None		None		None
prn_naml		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones
prn_namf		Fred		Fred		Fred		Fred		Fred		Fred		Fred		Fred
prn_namt		None		None		None		None		None		None		None		None
prn_nams		None		None		None		None		None		None		None		None
sig_title		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner
stmt_firm		Law Offices of Fred Jones		Law Offices of Fred Jones		Law Offices of Fred Jones		Law Offices of Fred Jones		Law Offices of Fred Jones		Law Offices of Fred Jones		Law Offices of Fred Jones		Law Offices of Fred Jones
ind_cb		None		None		None		None		None		None		None		None
bus_cb		None		None		None		None		None		None		None		None
trade_cb		None		None		None		None		None		None		None		None
oth_cb		None		None		None		None		None		None		None		None
a_b_name		None		None		None		None		None		None		None		None
a_b_city		None		None		None		None		None		None		None		None
a_b_st		None		None		None		None		None		None		None		None
a_b_zip4		None		None		None		None		None		None		None		None
descrip_1		None		None		None		None		None		None		None		None
descrip_2		None		None		None		None		None		None		None		None
c_less50		None		None		None		None		None		None		None		None
c_more50		None		None		None		None		None		None		None		None
ind_class		None		None		None		None		None		None		None		None
ind_descr		None		None		None		None		None		None		None		None
bus_class		None		None		None		None		None		None		None		None
bus_descr		None		None		None		None		None		None		None		None
auth_name		None		None		None		None		None		None		None		None
auth_city		None		None		None		None		None		None		None		None
auth_st		None		None		None		None		None		None		None		None
auth_zip4		None		None		None		None		None		None		None		None
lobby_int		None		None		None		None		None		None		None		None
influen_yn		None		None		None		None		None		None		None		None
firm_name		None		None		None		None		None		None		None		None
newcert_cb		None		None		None		None		None		None		None		None
rencert_cb		None		None		None		None		None		None		None		None
complet_dt		None		None		None		None		None		None		None		None
lby_reg_cb		None		None		None		None		None		None		None		None
lby_604_cb		None		None		None		None		None		None		None		None
st_leg_yn		None		None		None		None		None		None		None		None
st_agency		None		None		None		None		None		None		None		None
lobby_cb		None		None		None		None		None		None		None		None
l_firm_cb		None		None		None		None		None		None		None		None

Table: efs_filing_log

filing_date		2001-11-06 00:00:00		2001-11-06 00:00:00		2001-11-06 00:00:00		2001-11-06 00:00:00		2001-11-06 00:00:00		2001-11-06 00:00:00		2001-11-06 00:00:00		2001-11-06 00:00:00		2001-11-06 00:00:00		2001-11-06 00:00:00		2001-11-06 00:00:00		2001-11-06 00:00:00		2001-11-06 00:00:00		2001-11-06 00:00:00		2001-11-06 00:00:00		2001-11-06 00:00:00		2001-11-06 00:00:00		2001-11-07 00:00:00		2001-11-07 00:00:00		2001-11-07 00:00:00		2001-11-07 00:00:00		2002-01-14 00:00:00		2002-01-14 00:00:00		2002-01-15 00:00:00		2002-01-15 00:00:00		2002-01-15 00:00:00		2002-01-15 00:00:00		2002-07-22 00:00:00		2002-07-22 00:00:00		2002-07-22 00:00:00		2002-07-22 00:00:00		2002-07-22 00:00:00		2002-07-22 00:00:00		2002-07-22 00:00:00		2002-07-22 00:00:00		2002-07-22 00:00:00		2002-04-19 00:00:00		2002-04-19 00:00:00		2002-04-19 00:00:00		2002-04-19 00:00:00		2002-04-19 00:00:00		2002-04-19 00:00:00		2002-04-19 00:00:00		2002-04-19 00:00:00		2002-04-22 00:00:00		2002-04-22 00:00:00		2002-10-19 00:00:00		2002-10-17 00:00:00		2002-10-17 00:00:00		2002-10-17 00:00:00		2002-10-17 00:00:00		2002-10-17 00:00:00		2003-01-17 00:00:00		2003-01-17 00:00:00		2003-01-17 00:00:00		2003-01-17 00:00:00		2003-01-17 00:00:00		2003-01-17 00:00:00		2003-04-19 00:00:00		2003-04-19 00:00:00		2003-04-19 00:00:00		2003-04-19 00:00:00		2003-04-19 00:00:00		2003-04-19 00:00:00		2003-07-18 00:00:00		2003-07-18 00:00:00		2003-07-18 00:00:00		2003-07-18 00:00:00		2003-07-18 00:00:00		2003-07-18 00:00:00		2003-10-17 00:00:00		2003-10-17 00:00:00		2003-10-17 00:00:00		2003-10-17 00:00:00		2003-10-17 00:00:00		2003-10-17 00:00:00
filingstatus		0		0		0		1		0		1		0		1		0		1		0		1		0		1		0		1		0		1		0		1		0		0		0		1		0		1		0		0		0		2		2		2		1		0		1		0		0		0		2		2		2		2		1		0		1		0		0		0		1		0		1		0		1		0		1		0		0		0		0		0		1		0		1		0		0		1		0		1		0		0		0		1		0		0		1		0
vendor		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM
filer_id		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781
form_type		F615		F615		F615		F625		F625		F625		F625		F625		F625		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F625		F615		F635		F635		F635		F635		F625		F615		F635		F635		F635		F635		F635		F635		F635		F625		F615		F635		F635		F635		F635		F635		F635		F635		F635		F625		F615		F635		F635		F635		F635		F635		F635		F635		F635		F625		F615		F615		F625		F635		F635		F635		F635		F615		F635		F635		F635		F635		F625		F615		F635		F635		F625		F635		F635
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		ERROR 305		ERROR 305		ERROR 305		ACCEPTED		ACCEPTED		ACCEPTED		ACCEPTED		ACCEPTED		ACCEPTED		ERROR 305		ERROR 305		ERROR 305		ERROR 305		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		ACCEPTED		ACCEPTED		ACCEPTED		ACCEPTED

Table: filer_address

filer_id		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781
adrid		2012281		2079519		2067310		2113836		2159442		2204797		2418881		2470172		2278070		2548051		2510811		2345278
effect_dt		2001-01-01 00:00:00		2005-01-01 00:00:00		2003-03-25 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2013-01-01 00:00:00		2023-01-01 00:00:00		2021-01-01 00:00:00		2015-01-01 00:00:00
add_type		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051
session_id		2001		2005		2003		2007		2009		2011		2017		2019		2013		2023		2021		2015

Table: filer_filings

filer_id		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781
filing_id		715315		715731		715734		725552		750537		787709		794436		794437		794438		777405		806740		838269		836140		816483		850516		849430		847805		847807		853090		875463		877151		902974		904982		925749		942736		928030		939601		953076		965115		972691		1009199		989331		1009994		985417		1009199		1028250		1009199		1016843		1052489		1038532		1038533		1035267		1016832		1073898		1063361		1083834		1080831		1100728		1124522		1073898		1132356		1117951		1141493		1141922		1160491		1182466		1222943		1228145		1216040		1256049		1245236		1277219		1303207		1228145		1216040		1160491		1182466		1293444		1774134		1972567		1860819		1808761		1792826		1956048		1328303		1342954		1366792		1388921		1384401		1408137		1417034		1430578		1447294		1456981		1499041		1477027		1521583		1546580		1551180		1557630		1557630		1587797		1598562		1627857		1616466		1651401		1616466		1670103		1692438		1917096		1924087		1718945		1890819		1732102		1722866		1837241		1754528		1990258		2002194		2263172		2389627		2332721		2354785		2428285		2410990		2227289		2026022		2053226		2084333		2119216		2114208		2110711		2150537		2141717		2165311		2200055		2186614		2536343		2464557		2464557		2476057		2302760		2328293		2539497		2369705		2662702		2543158		2696213		2633549		2573364		2629190		2590757		2732667
period_id		None		None		None		164		165		None		167		166		165		None		168		None		169		None		170		None		None		None		None		171		None		172		None		None		174		173		None		None		175		None		177		None		None		176		177		178		178		None		179		None		None		None		None		180		None		None		None		181		None		180		183		182		None		184		185		186		188		188		187		189		None		190		192		188		187		185		186		191		214		222		218		216		215		221		193		194		195		196		196		None		197		198		199		200		202		201		203		204		None		204		204		205		206		208		207		209		207		210		211		220		220		212		219		None		212		217		213		223		224		234		238		236		None		240		239		233		225		226		227		228		None		228		229		None		230		232		231		244		241		241		242		235		236		None		237		249		244		250		248		245		247		246		251
form_id		F605		F601		F601		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F690		F690		F690		F625		F625		F625		F625		F625		F607		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F888		F625		F625		F625		F625		F601		F625		F625		F601		F625		F625		F605		F625		F625		F625		F605		F625		F625		F625		F601		F625		F625		F625		F601		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F601		F601		F625		F625		F625		F625		F625		F625		F625		F601		F601		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F601		F625		F601		F625		F601		F625		F625		F625		F625		F625		F625		F625		F625		F601		F625		F625		F625		F625		F625		F625		F625		F601		F601		F625		F601		F625		F625		F625		F601		F625		F625		F625		F625		F601		F601		F625		F625		F625		F625		F625		F625		F625		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		2		0		1		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		1		1		1		1		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		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		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		2001-01-22 00:00:00		2001-01-25 00:00:00		2000-12-22 00:00:00		2001-01-31 00:00:00		2001-04-24 00:00:00		2001-10-12 00:00:00		2001-11-06 00:00:00		2001-11-06 00:00:00		2001-11-06 00:00:00		2001-07-30 00:00:00		2002-01-14 00:00:00		2002-04-23 00:00:00		2002-04-19 00:00:00		2002-01-17 00:00:00		2002-07-22 00:00:00		2002-07-05 00:00:00		2002-05-01 00:00:00		2002-05-01 00:00:00		2002-07-25 00:00:00		2002-10-19 00:00:00		2002-10-23 00:00:00		2003-01-17 00:00:00		2003-01-21 00:00:00		2003-03-21 00:00:00		2003-07-18 00:00:00		2003-04-19 00:00:00		2003-04-23 00:00:00		2003-07-24 00:00:00		2003-10-17 00:00:00		2003-10-22 00:00:00		2004-04-15 00:00:00		2004-01-28 00:00:00		2004-04-19 00:00:00		2004-01-23 00:00:00		2004-07-29 00:00:00		2004-07-29 00:00:00		2004-07-16 00:00:00		2004-04-15 00:00:00		2004-10-23 00:00:00		2004-07-26 00:00:00		2004-08-02 00:00:00		2004-08-02 00:00:00		2003-03-27 00:00:00		2005-01-21 00:00:00		2004-11-01 00:00:00		2004-12-29 00:00:00		2005-01-25 00:00:00		2005-04-18 00:00:00		2005-09-06 00:00:00		2005-06-06 00:00:00		2005-10-28 00:00:00		2005-07-31 00:00:00		2006-01-10 00:00:00		2006-01-13 00:00:00		2006-04-04 00:00:00		2006-07-05 00:00:00		2006-12-04 00:00:00		2007-01-16 00:00:00		2006-10-31 00:00:00		2007-04-10 00:00:00		2006-12-11 00:00:00		2007-07-12 00:00:00		2008-01-11 00:00:00		2007-09-13 00:00:00		2007-09-13 00:00:00		2007-09-13 00:00:00		2007-09-13 00:00:00		2007-10-18 00:00:00		2013-07-09 00:00:00		2015-07-01 00:00:00		2014-07-02 00:00:00		2014-01-06 00:00:00		2013-10-07 00:00:00		2015-04-06 00:00:00		2008-04-29 00:00:00		2008-07-11 00:00:00		2008-10-17 00:00:00		2009-01-12 00:00:00		2008-12-18 00:00:00		2008-12-22 00:00:00		2009-04-12 00:00:00		2009-07-14 00:00:00		2009-10-09 00:00:00		2010-01-07 00:00:00		2010-07-02 00:00:00		2010-04-01 00:00:00		2010-10-04 00:00:00		2010-11-29 00:00:00		2010-11-30 00:00:00		2011-01-06 00:00:00		2011-02-28 00:00:00		2011-04-22 00:00:00		2011-07-01 00:00:00		2012-01-11 00:00:00		2011-10-05 00:00:00		2012-04-10 00:00:00		2011-11-09 00:00:00		2012-07-06 00:00:00		2012-10-01 00:00:00		2014-12-05 00:00:00		2015-01-09 00:00:00		2012-12-20 00:00:00		2014-10-02 00:00:00		2012-12-24 00:00:00		2013-01-07 00:00:00		2014-04-09 00:00:00		2013-04-02 00:00:00		2015-10-01 00:00:00		2016-01-04 00:00:00		2018-07-09 00:00:00		2019-07-11 00:00:00		2019-01-08 00:00:00		2018-12-20 00:00:00		2020-01-06 00:00:00		2019-10-01 00:00:00		2018-04-03 00:00:00		2016-04-05 00:00:00		2016-07-01 00:00:00		2016-10-03 00:00:00		2017-01-12 00:00:00		2014-12-08 00:00:00		2016-12-13 00:00:00		2017-04-11 00:00:00		2016-12-22 00:00:00		2017-07-03 00:00:00		2018-01-04 00:00:00		2017-10-05 00:00:00		2020-12-08 00:00:00		2020-10-21 00:00:00		2020-04-01 00:00:00		2020-07-02 00:00:00		2018-10-05 00:00:00		2018-12-17 00:00:00		2020-12-14 00:00:00		2019-04-01 00:00:00		2022-04-04 00:00:00		2021-01-10 00:00:00		2022-07-01 00:00:00		2022-01-10 00:00:00		2021-04-10 00:00:00		2021-11-22 00:00:00		2021-07-05 00:00:00		2022-10-13 00:00:00
stmnt_type		10005		10005		10005		10005		10005		10005		10001		10001		10001		10005		10001		10005		10001		10005		10001		10002		10002		10002		10005		10001		10005		10001		10005		10005		10001		10001		10005		10005		10001		10005		10001		10005		10005		10001		10002		10001		10002		10005		10001		10006		10006		10005		10005		10001		10005		10005		10005		10001		10005		10002		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10002		10002		10002		10002		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10002		10001		10001		10001		10001		10001		10002		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10005		10001		10001		10001		10001		10002		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001
stmnt_status		11001		11003		11001		11001		11001		11001		11003		11003		11003		11001		11003		11001		11003		11001		11003		11001		11001		11001		11001		11003		11001		11003		11001		11001		11003		11003		11001		11001		11003		11001		11003		11001		11001		11003		11003		11003		11003		11001		11003		11001		11003		11001		11001		11003		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		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11003
session_id		2001		2001		2001		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2003		2005		2005		2003		2005		2005		2005		2005		2005		2005		2007		2005		2005		2007		2007		2007		2007		2005		2005		2005		2005		2007		2013		2015		2013		2013		2013		2015		2007		2007		2007		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2009		2009		2011		2011		2011		2011		2011		2011		2011		2011		2015		2013		2013		2013		2013		2011		2013		2013		2015		2015		2017		2019		2017		2019		2019		2019		2017		2015		2015		2015		2015		2015		2017		2017		2017		2017		2017		2017		2021		2019		2019		2019		2017		2019		2019		2019		2021		2019		2021		2021		2021		2021		2021		2021
user_id		GGILMORE		DHORRELL		GGILMORE		MKIENG		YBONILLA		YBONILLA		DHORRELL		DHORRELL		*		YBONILLA		*		YBONILLA		*		YBONILLA		*		YBONILLA		YBONILLA		YBONILLA		YBONILLA		*		YBONILLA		COMPLETED		YBONILLA		SARRIAGA		COMPLETED		COMPLETED		YBONILLA		YBONILLA		COMPLETED		YBONILLA		COMPLETED		LTHIBAUL		LTHIBAUL		COMPLETED		COMPLETED		COMPLETED		COMPLETED		SARRIAGA		COMPLETED		LTHIBAUL		EMCENTEE		LTHIBAUL		SARRIAGA		COMPLETED		YRODRIGU		SARRIAGA		YRODRIGU		YRODRIGU		CFLAGG		YRODRIGU		YRODRIGU		YRODRIGU		CFLAGG		LTHIBAUL		YRODRIGU		YRODRIGU		*		YRODRIGU		YRODRIGU		YRODRIGU		SARRIAGA		LTHIBAUL		LTHIBAUL		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		LTHIBAUL		ASAETERN		AGLADNEY		ASAETERN		ASAETERN		ASAETERN		AGLADNEY		LTHIBAUL		MGUERRA		MGUERRA		MGUERRA		*		YRODRIGU		MGUERRA		MGUERRA		MGUERRA		MGUERRA		MGUERRA		MGUERRA		ASAETERN		*		GPEREZ		ASAETERN		ASAETERN		ASAETERN		ASAETERN		ASAETERN		ASAETERN		ASAETERN		ASAETERN		JINGRAM		ASAETERN		YRODRIGU		AGLADNEY		PBANFORD		ASAETERN		PBANFORD		ASAETERN		ASAETERN		ASAETERN		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		SARRIAGA		AGLADNEY		GTAYLOR		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		YRODRIGU		SARRIAGA		AGLADNEY		SARRIAGA		AGLADNEY		AGLADNEY		AGLADNEY		CVANLIEW		CAFILER		MKIRKHAM		CAFILER		AGLADNEY		SARRIAGA		CVANLIEW		AGLADNEY		RATTIYEH		CAFILER		CAFILER		CHATRIDGE		MKIRKHAM		AROJAS		CHATRIDGE		CAFILER
special_audit		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11002		11003		11002		11003		11003		11003		11003		11002		11003		11002		11003		11002		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11003		11003		11003		11003		11003		11003		11001		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11003		11003		11001		11003		11001		11003		11003		11001		11001		11003		11003		11001		11001		11001		11001		11003
rpt_start		1900-01-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		2001-07-01 00:00:00		2001-07-01 00:00:00		2001-04-01 00:00:00		2001-01-01 00:00:00		2001-04-01 00:00:00		2001-10-01 00:00:00		2002-01-01 00:00:00		2002-01-01 00:00:00		2001-10-01 00:00:00		2002-04-01 00:00:00		2001-07-01 00:00:00		2001-01-01 00:00:00		2001-04-01 00:00:00		2002-04-01 00:00:00		2002-07-01 00:00:00		2002-07-01 00:00:00		2002-10-01 00:00:00		2002-10-01 00:00:00		1900-01-01 00:00:00		2003-04-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-07-01 00:00:00		2004-01-01 00:00:00		2003-10-01 00:00:00		2004-01-01 00:00:00		2003-10-01 00:00:00		2004-01-01 00:00:00		2004-04-01 00:00:00		2004-04-01 00:00:00		None		2004-07-01 00:00:00		2004-04-01 00:00:00		2004-01-01 00:00:00		2004-04-01 00:00:00		1900-01-01 00:00:00		2004-10-01 00:00:00		2004-07-01 00:00:00		1900-01-01 00:00:00		2004-10-01 00:00:00		2005-01-01 00:00:00		1900-01-01 00:00:00		2004-10-01 00:00:00		2005-07-01 00:00:00		2005-04-01 00:00:00		1900-01-01 00:00:00		2005-10-01 00:00:00		2006-01-01 00:00:00		2006-04-01 00:00:00		2006-12-04 00:00:00		2006-10-01 00:00:00		2006-07-01 00:00:00		2007-01-01 00:00:00		1900-01-01 00:00:00		2007-04-01 00:00:00		2007-10-01 00:00:00		2006-10-01 00:00:00		2006-07-01 00:00:00		2006-01-01 00:00:00		2006-04-01 00:00:00		2007-07-01 00:00:00		2013-04-01 00:00:00		2015-04-01 00:00:00		2014-04-01 00:00:00		2013-10-01 00:00:00		2013-07-01 00:00:00		2015-01-01 00:00:00		2008-01-01 00:00:00		2008-04-01 00:00:00		2008-07-01 00:00:00		2008-10-01 00:00:00		2008-12-18 00:00:00		1900-01-01 00:00:00		2009-01-01 00:00:00		2009-04-01 00:00:00		2009-07-01 00:00:00		2009-10-01 00:00:00		2010-04-01 00:00:00		2010-01-01 00:00:00		2010-07-01 00:00:00		2010-11-29 00:00:00		1900-01-01 00:00:00		2010-10-01 00:00:00		2010-10-01 00:00:00		2011-01-01 00:00:00		2011-04-01 00:00:00		2011-10-01 00:00:00		2011-07-01 00:00:00		2012-01-01 00:00:00		2011-07-01 00:00:00		2012-04-01 00:00:00		2012-07-01 00:00:00		2014-12-05 00:00:00		2014-10-01 00:00:00		2012-12-20 00:00:00		2014-07-01 00:00:00		1900-01-01 00:00:00		2012-10-01 00:00:00		2014-01-01 00:00:00		2013-01-01 00:00:00		2015-07-01 00:00:00		2015-10-01 00:00:00		2018-04-01 00:00:00		2019-04-01 00:00:00		2018-10-01 00:00:00		1900-01-01 00:00:00		2019-10-01 00:00:00		2019-07-01 00:00:00		2018-01-01 00:00:00		2016-01-01 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		2016-10-01 00:00:00		1900-01-01 00:00:00		2016-12-13 00:00:00		2017-01-01 00:00:00		1900-01-01 00:00:00		2017-04-01 00:00:00		2017-10-01 00:00:00		2017-07-01 00:00:00		2020-12-08 00:00:00		2020-01-01 00:00:00		2020-01-01 00:00:00		2020-04-01 00:00:00		2018-07-01 00:00:00		2018-12-17 00:00:00		1900-01-01 00:00:00		2019-01-01 00:00:00		2022-01-01 00:00:00		2020-10-01 00:00:00		2022-04-01 00:00:00		2021-10-01 00:00:00		2021-01-01 00:00:00		2021-07-01 00:00:00		2021-04-01 00:00:00		2022-07-01 00:00:00
rpt_end		1900-01-01 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		2001-09-30 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		2001-03-31 00:00:00		2001-06-30 00:00:00		2001-12-31 00:00:00		2002-03-31 00:00:00		2002-03-31 00:00:00		2001-12-31 00:00:00		2002-06-30 00:00:00		2001-09-30 00:00:00		2001-03-31 00:00:00		2001-06-30 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		2002-09-30 00:00:00		2002-12-31 00:00:00		2002-12-31 00:00:00		1900-01-01 00:00:00		2003-06-30 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-09-30 00:00:00		2004-03-31 00:00:00		2003-12-31 00:00:00		2004-03-31 00:00:00		2003-12-31 00:00:00		2004-03-31 00:00:00		2004-06-30 00:00:00		2004-06-30 00:00:00		None		2004-09-30 00:00:00		2004-06-30 00:00:00		2004-03-31 00:00:00		2004-06-30 00:00:00		1900-01-01 00:00:00		2004-12-31 00:00:00		2004-09-30 00:00:00		1900-01-01 00:00:00		2004-12-31 00:00:00		2005-03-31 00:00:00		1900-01-01 00:00:00		2004-12-31 00:00:00		2005-09-30 00:00:00		2005-06-30 00:00:00		1900-01-01 00:00:00		2005-12-31 00:00:00		2006-03-31 00:00:00		2006-06-30 00:00:00		2006-12-04 00:00:00		2006-12-31 00:00:00		2006-09-30 00:00:00		2007-03-31 00:00:00		1900-01-01 00:00:00		2007-06-30 00:00:00		2007-12-31 00:00:00		2006-12-31 00:00:00		2006-09-30 00:00:00		2006-03-31 00:00:00		2006-06-30 00:00:00		2007-09-30 00:00:00		2013-06-30 00:00:00		2015-06-30 00:00:00		2014-06-30 00:00:00		2013-12-31 00:00:00		2013-09-30 00:00:00		2015-03-31 00:00:00		2008-03-31 00:00:00		2008-06-30 00:00:00		2008-09-30 00:00:00		2008-12-31 00:00:00		2008-12-18 00:00:00		1900-01-01 00:00:00		2009-03-31 00:00:00		2009-06-30 00:00:00		2009-09-30 00:00:00		2009-12-31 00:00:00		2010-06-30 00:00:00		2010-03-31 00:00:00		2010-09-30 00:00:00		2010-11-29 00:00:00		1900-01-01 00:00:00		2019-12-31 00:00:00		2010-12-31 00:00:00		2011-03-31 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2011-09-01 00:00:00		2012-03-31 00:00:00		2011-09-30 00:00:00		2012-06-30 00:00:00		2012-09-30 00:00:00		2014-12-05 00:00:00		2014-12-31 00:00:00		2012-12-20 00:00:00		2014-09-30 00:00:00		1900-01-01 00:00:00		2012-12-31 00:00:00		2014-03-31 00:00:00		2013-03-31 00:00:00		2015-09-30 00:00:00		2015-12-31 00:00:00		2018-06-30 00:00:00		2019-06-30 00:00:00		2018-12-31 00:00:00		1900-01-01 00:00:00		2019-12-31 00:00:00		2019-09-30 00:00:00		2018-03-31 00:00:00		2016-03-31 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		2016-12-31 00:00:00		1900-01-01 00:00:00		2016-12-13 00:00:00		2017-03-31 00:00:00		1900-01-01 00:00:00		2017-06-30 00:00:00		2017-12-31 00:00:00		2017-09-30 00:00:00		2020-12-08 00:00:00		2020-03-31 00:00:00		2020-03-31 00:00:00		2020-06-30 00:00:00		2018-09-30 00:00:00		2018-12-17 00:00:00		1900-01-01 00:00:00		2019-03-31 00:00:00		2022-03-31 00:00:00		2020-12-30 00:00:00		2022-06-30 00:00:00		2021-12-31 00:00:00		2021-03-31 00:00:00		2021-09-30 00:00:00		2021-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
filing_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22001		None		None		22001		22001		None		None		22001		None		22001		None		None		22001		22001		22001		22001		None		22006		None		None		None		None		22006		None		None		None		22006		None		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006

Table: filer_to_filer_type

filer_id		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781
filer_type		3		3		3		3		3		3		3		3		3		3		3		3
active		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		N
race		0		0		0		0		None		None		None		None		None		None		None		None
session_id		2001		2003		2005		2007		2011		2013		2009		2017		2015		2021		2019		2023
category		0		0		0		0		None		None		None		None		None		None		None		None
category_type		0		0		0		0		None		None		None		None		None		None		None		None
sub_category		0		0		0		0		None		None		None		None		None		None		None		None
effect_dt		2001-01-01 00:00:00		2005-03-25 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2011-01-01 00:00:00		2013-01-01 00:00:00		2009-01-01 00:00:00		2017-01-01 00:00:00		2015-01-01 00:00:00		2021-01-01 00:00:00		2019-01-01 00:00:00		2023-01-01 00:00:00
sub_category_type		0		0		0		0		None		None		None		None		None		None		None		None
election_type		0		0		0		0		None		None		None		None		None		None		None		None
sub_category_a		None		None		None		None		None		None		None		None		None		None		None		None
nyq_dt		None		None		2001-07-01 00:00:00		2001-07-01 00:00:00		None		None		None		None		None		None		None		None
party_cd		0		0		0		0		None		None		None		None		None		None		None		None
county_cd		0		0		0		0		None		None		None		None		None		None		None		None
district_cd		0		0		0		0		None		None		None		None		None		None		None		None

Table: filer_xref

filer_id		1231781
xref_id		1231781
effect_dt		2001-01-08 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781
filer_id		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781
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
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
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
naml		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED		JONES; LAW OFFICES OF FRED
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
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
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
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
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
city		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN
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
zip4		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603
phon		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944		5308879944
fax		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000		5308898000
email		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]

Table: filers

filer_id		1231781

Table: lobbying_chg_log

filer_id		1231781		1231781		1231781		1231781		1231781
change_no		1		0		2		3		4
session_id		2001		2003		2005		2005		2005
log_dt		2001-05-12 00:00:00		2003-03-27 00:00:00		2006-01-10 00:00:00		2006-01-10 00:00:00		2006-01-10 00:00:00
filer_type		3		3		3		3		3
correction_flg		None		None		None		None		None
action		ADDED		ADDED		ADDED		IN SUSPENSE		SET ACTIVE
attribute_changed		ETHICS		CLIENT		CLIENT		CLIENT		CLIENT
ethics_dt		2001-04-20 00:00:00		None		None		None		None
interests		None		None		None		None		None
filer_full_name		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED		JONES, LAW OFFICES OF FRED
filer_city		None		None		None		None		None
filer_st		None		None		None		None		None
filer_zip		None		None		None		None		None
filer_phone		None		None		None		None		None
entity_type		4		1		1		1		1
entity_name		FRED JONES		HOME ECONOMICS TEACHERS ASSOCIATION OF CALIFORNIA		CALIFORNIA COUNCIL FOR THE SOCIAL STUDIES		CALIFORNIA COUNCIL FOR THE SOCIAL STUDIES		CALIFORNIA COUNCIL FOR THE SOCIAL STUDIES
entity_city		None		None		None		None		None
entity_st		None		None		None		None		None
entity_zip		None		None		None		None		None
entity_phone		None		None		None		None		None
entity_id		1231783		1145082		1143151		1143151		1143151
responsible_officer		None		None		None		None		None
effect_dt		None		2003-03-25 00:00:00		2006-01-09 00:00:00		2006-01-09 00:00:00		2006-01-09 00:00:00

Table: received_filings

filer_id		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781		1231781
filing_file_name		794436_0.cal		794437_0.cal		794438_0.cal		806740_0.cal		836140_0.cal		850516_0.cal		875463_0.cal		902974_0.cal		928030_0.cal		942736_0.cal		965115_0.cal		985417_0.cal		1009199_0.cal		193969.cal		1009199_2.cal		1028250_0.cal		1009199_1.cal		1222943_0.cal		1384401_0.cal		1718945_0.cal		1546580_0.cal		2110711_0.cal		1917096_0.cal		2328293_0.cal		2536343_0.cal
received_date		2001-11-06 00:00:00		2001-11-06 00:00:00		2001-11-06 00:00:00		2002-01-14 00:00:00		2002-04-19 00:00:00		2002-07-22 00:00:00		2002-10-19 00:00:00		2003-01-17 00:00:00		2003-04-19 00:00:00		2003-07-18 00:00:00		2003-10-17 00:00:00		2004-01-23 00:00:00		2004-04-15 00:00:00		2004-07-29 00:00:00		2004-07-29 00:00:00		2004-07-29 00:00:00		2004-07-16 00:00:00		2006-12-04 00:00:00		2008-12-18 00:00:00		2012-12-20 00:00:00		2010-11-29 00:00:00		2016-12-13 00:00:00		2014-12-05 00:00:00		2018-12-17 00:00:00		2020-12-08 00:00:00
filing_directory		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		794436		794437		794438		806740		836140		850516		875463		902974		928030		942736		965115		985417		1009199		None		1009199		1028250		1009199		1222943		1384401		1718945		1546580		2110711		1917096		2328293		2536343
form_id		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		None		F625		F625		F625		F601		F601		F601		F601		F601		F601		F601		F601
receive_comment		Filing accepted, but with warnings		Filing accepted, but with warnings		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		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted