Home

Filer ID: 1286979

Table: cvr_lobby_disclosure

filing_id		1231392		1279009		1279009		1259768		1216453		1216453		1328956		1350463		1297220		1308014		1308014		1452755		1438020		1376401		1421921		1398486		1505709		1485190		1464969		1540914		1622411		1592436		1606034		1592436		1571720		1636633		1709507		1680198		1680198		1680198		1657385		1800889		1782899		1743680		1766048		1817304		1845199		1871439		1912630		1931654		1991389		1966331		1981903		2010391		2060157		2035570		2092142		2169451		2157676		2128557		2193749		2241575		2212420		2193749		2270959		2320639		2380135		2345662		2396325		2470959		2470959		2415248		2438075		2470959		2483734		2524950		2550576		2596643		2578897		2620646		2640408		2703810		2674292		2744865
amend_id		0		0		1		0		0		1		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		2		1		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		1		0		0		2		0		0		0		0		0		0		0		0		0		0
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
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
sender_id		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979
filer_id		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979
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
filer_naml		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES
filer_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
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
report_num		000		000		001		000		000		001		000		000		000		000		001		000		000		000		000		000		000		000		000		000		000		000		000		001		000		000		000		002		001		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		001		000		000		000		000		000		000		000		000		000		001		000		000		002		000		000		000		000		000		000		000		000		000		000
rpt_date		2007-01-24 00:00:00		2007-07-23 00:00:00		2007-07-23 00:00:00		2007-04-26 00:00:00		2006-10-31 00:00:00		2007-08-14 00:00:00		2008-04-30 00:00:00		2008-07-31 00:00:00		2007-10-31 00:00:00		2008-01-29 00:00:00		2008-01-29 00:00:00		2009-11-02 00:00:00		2009-07-31 00:00:00		2008-10-30 00:00:00		2009-04-30 00:00:00		2009-02-02 00:00:00		2010-07-29 00:00:00		2010-04-30 00:00:00		2010-02-01 00:00:00		2010-11-01 00:00:00		2011-10-31 00:00:00		2011-05-03 00:00:00		2011-07-28 00:00:00		2011-05-10 00:00:00		2011-01-31 00:00:00		2012-01-31 00:00:00		2012-10-31 00:00:00		2012-08-20 00:00:00		2012-08-14 00:00:00		2012-07-31 00:00:00		2012-04-30 00:00:00		2013-10-31 00:00:00		2013-07-31 00:00:00		2013-02-06 00:00:00		2013-04-30 00:00:00		2014-01-31 00:00:00		2014-04-30 00:00:00		2014-07-31 00:00:00		2014-10-31 00:00:00		2015-01-28 00:00:00		2015-10-09 00:00:00		2015-04-30 00:00:00		2015-07-31 00:00:00		2016-01-29 00:00:00		2016-07-28 00:00:00		2016-04-29 00:00:00		2016-10-20 00:00:00		2017-07-21 00:00:00		2017-05-01 00:00:00		2017-01-31 00:00:00		2017-12-13 00:00:00		2018-04-30 00:00:00		2018-02-01 00:00:00		2017-10-31 00:00:00		2018-07-27 00:00:00		2018-10-31 00:00:00		2019-04-30 00:00:00		2019-01-30 00:00:00		2019-07-30 00:00:00		2020-04-30 00:00:00		2020-04-30 00:00:00		2019-10-24 00:00:00		2020-01-29 00:00:00		2020-12-07 00:00:00		2020-07-30 00:00:00		2020-10-28 00:00:00		2021-01-29 00:00:00		2021-07-26 00:00:00		2021-04-29 00:00:00		2021-10-27 00:00:00		2022-01-28 00:00:00		2022-07-29 00:00:00		2022-04-29 00:00:00		2022-10-28 00:00:00
from_date		2006-10-01 00:00:00		2007-04-01 00:00:00		2007-04-01 00:00:00		2007-01-01 00:00:00		2006-07-01 00:00:00		2006-07-01 00:00:00		2008-01-01 00:00:00		2008-04-01 00:00:00		2007-07-01 00:00:00		2007-10-01 00:00:00		2007-10-01 00:00:00		2009-07-01 00:00:00		2009-04-01 00:00:00		2008-07-01 00:00:00		2009-01-01 00:00:00		2008-09-01 00:00:00		2010-04-01 00:00:00		2010-01-01 00:00:00		2009-10-01 00:00:00		2010-07-01 00:00:00		2011-07-01 00:00:00		2011-01-01 00:00:00		2011-04-01 00:00:00		2011-01-01 00:00:00		2010-10-01 00:00:00		2011-10-01 00:00:00		2012-07-01 00:00:00		2012-04-01 00:00:00		2012-04-01 00:00:00		2012-04-01 00:00:00		2012-01-01 00:00:00		2013-07-01 00:00:00		2013-04-01 00:00:00		2012-10-01 00:00:00		2013-01-01 00:00:00		2013-10-01 00:00:00		2014-01-01 00:00:00		2014-04-01 00:00:00		2014-07-01 00:00:00		2014-10-01 00:00:00		2015-07-01 00:00:00		2015-01-01 00:00:00		2015-04-01 00:00:00		2015-10-01 00:00:00		2016-04-01 00:00:00		2016-01-01 00:00:00		2016-07-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-01-01 00:00:00		2017-10-01 00:00:00		2017-07-01 00:00:00		2018-04-01 00:00:00		2018-07-01 00:00:00		2019-01-01 00:00:00		2018-10-01 00:00:00		2019-04-01 00:00:00		2020-01-01 00:00:00		2020-01-01 00:00:00		2019-07-01 00:00:00		2019-10-01 00:00:00		2020-01-01 00:00:00		2020-04-01 00:00:00		2020-07-01 00:00:00		2020-10-01 00:00:00		2021-04-01 00:00:00		2021-01-01 00:00:00		2021-07-01 00:00:00		2021-10-01 00:00:00		2022-04-01 00:00:00		2022-01-01 00:00:00		2022-07-01 00:00:00
thru_date		2006-12-31 00:00:00		2007-06-30 00:00:00		2007-06-30 00:00:00		2007-03-31 00:00:00		2006-09-30 00:00:00		2006-09-30 00:00:00		2008-03-31 00:00:00		2008-06-30 00:00:00		2007-09-30 00:00:00		2007-12-31 00:00:00		2007-12-31 00:00:00		2009-09-30 00:00:00		2009-06-30 00:00:00		2008-09-30 00:00:00		2009-03-31 00:00:00		2008-12-31 00:00:00		2010-06-30 00:00:00		2010-03-31 00:00:00		2009-12-31 00:00:00		2010-09-30 00:00:00		2011-09-30 00:00:00		2011-03-31 00:00:00		2011-06-30 00:00:00		2011-03-31 00:00:00		2010-12-31 00:00:00		2011-12-31 00:00:00		2012-09-30 00:00:00		2012-06-30 00:00:00		2012-06-30 00:00:00		2012-06-30 00:00:00		2012-03-31 00:00:00		2013-09-30 00:00:00		2013-06-30 00:00:00		2012-12-31 00:00:00		2013-03-31 00:00:00		2013-12-31 00:00:00		2014-03-31 00:00:00		2014-06-30 00:00:00		2014-09-30 00:00:00		2014-12-31 00:00:00		2015-09-30 00:00:00		2015-03-31 00:00:00		2015-06-30 00:00:00		2015-12-31 00:00:00		2016-06-30 00:00:00		2016-03-31 00:00:00		2016-09-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-03-31 00:00:00		2017-12-31 00:00:00		2017-09-30 00:00:00		2018-06-30 00:00:00		2018-09-30 00:00:00		2019-03-31 00:00:00		2018-12-31 00:00:00		2019-06-30 00:00:00		2020-03-31 00:00:00		2020-03-31 00:00:00		2019-09-30 00:00:00		2019-12-31 00:00:00		2020-03-31 00:00:00		2020-06-30 00:00:00		2020-09-30 00:00:00		2020-12-31 00:00:00		2021-06-30 00:00:00		2021-03-31 00:00:00		2021-09-30 00:00:00		2021-12-31 00:00:00		2022-06-30 00:00:00		2022-03-31 00:00:00		2022-09-30 00:00:00
cum_beg_dt		2006-04-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		None		2005-01-01 00:00:00		2008-01-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2011-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		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		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		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		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		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979
firm_name		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO
firm_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
firm_zip4		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814
firm_phon		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129
mail_city		SACRAMENTO		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
mail_st		CA		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		95814		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		9166067129		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		2007-01-24 00:00:00		2007-07-23 00:00:00		2007-07-23 00:00:00		2007-04-26 00:00:00		2006-10-31 00:00:00		2007-08-14 00:00:00		2008-04-30 00:00:00		2008-07-31 00:00:00		2007-10-31 00:00:00		2008-01-29 00:00:00		2008-01-29 00:00:00		2009-11-02 00:00:00		2009-07-31 00:00:00		2008-10-30 00:00:00		2009-04-30 00:00:00		2009-02-02 00:00:00		2010-07-29 00:00:00		2010-04-30 00:00:00		2010-02-01 00:00:00		2010-11-01 00:00:00		2011-10-31 00:00:00		2011-05-03 00:00:00		2011-07-28 00:00:00		2011-05-11 00:00:00		2011-01-31 00:00:00		2012-01-31 00:00:00		2012-10-31 00:00:00		2012-08-20 00:00:00		2012-08-14 00:00:00		2012-07-31 00:00:00		2012-04-30 00:00:00		2013-10-31 00:00:00		2013-07-31 00:00:00		2013-02-06 00:00:00		2013-04-30 00:00:00		2014-01-31 00:00:00		2014-04-30 00:00:00		2014-07-31 00:00:00		2014-10-31 00:00:00		2015-01-28 00:00:00		2015-10-09 00:00:00		2015-04-30 00:00:00		2014-07-31 00:00:00		2016-01-29 00:00:00		2016-07-28 00:00:00		2016-04-29 00:00:00		2016-10-20 00:00:00		2017-07-21 00:00:00		2017-05-01 00:00:00		2017-01-31 00:00:00		2017-12-13 00:00:00		2018-04-30 00:00:00		2018-02-01 00:00:00		2017-10-31 00:00:00		2018-07-27 00:00:00		2018-10-31 00:00:00		2019-04-30 00:00:00		2019-01-30 00:00:00		2019-07-30 00:00:00		2020-04-30 00:00:00		2020-04-30 00:00:00		2019-10-24 00:00:00		2019-01-29 00:00:00		2020-12-07 00:00:00		2020-07-30 00:00:00		2020-10-28 00:00:00		2021-01-29 00:00:00		2021-07-26 00:00:00		2021-04-29 00:00:00		2021-10-27 00:00:00		2022-01-28 00:00:00		2022-07-29 00:00:00		2022-04-29 00:00:00		2022-10-28 00:00:00
sig_loc		Sacaremento, CA		Sacramento, CA		Sacramento, CA		Davis, CA		Davis, CA		DAVIS, CA		Sacramento, CA		Sacramento		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Davis, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento		Sacramento, CA		Sacramento, CA		Sacramento		Sacramento		Sacramento, CA		Sacramento		Sacramento, CA		Sacramento		Sacramento		Sacramento, CA		Davis		Sacramento, CA		Sacramento CA		Sacramento, CA		Davis, CA		Davis		Sacramento, CA		Sacramento, CA		Davis		Davis, CA		Davis, CA		Davis, CA		Davis		Davis, CA		Davis, CA		Davis, CA		Santa Cruz, CA		Davis, CA		Davis, CA
sig_naml		Blattner		Blattner		Blattner		Blattner		Blattner		BLATTNER		Blattner		Bob Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner
sig_namf		Bob		Bob		Bob		Bob		Bob		BOB		Bob		CA		Bob		Bob		Bob		Bob		Bob		Bob		Bob		Robert		Bob		Bob		Bob		Bob		Bob		Bob		Bob		Bob		Bob		Bob		Robert		Bob		Robert		Robert		Bob		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Bob		Robert		Bob		Robert		Bob		Bob		Robert		Robert		Robert		Robert		Robert		Bob		Bob		Bob		Bob		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert
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
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
prn_naml		Blattner		Blattner		Blattner		Blattner		Blattner		BLATTNER		Blattner		Bob Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner
prn_namf		Bob		Bob		Bob		Bob		Bob		BOB		Bob		CA		Bob		Bob		Bob		Bob		Bob		Bob		Bob		Robert		Bob		Bob		Bob		Bob		Bob		Bob		Bob		Bob		Bob		Bob		Robert		Bob		Robert		Robert		Bob		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Bob		Robert		Bob		Robert		Bob		Bob		Robert		Robert		Robert		Robert		Robert		Bob		Bob		Bob		Bob		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert
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
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
sig_title		President		President		President		President		President		PRESIDENT		President		Principal		President		President		President		President		Principal		President		President		President		President		Principal		Principal		President		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal
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
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
part1_1_cb		X		X		X		X		None		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X
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
ctrib_n_cb		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		None		X		X		None		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X
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
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
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
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
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
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
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
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
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
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

Table: cvr_registration

filing_id		1556410		1556410		1721833		1921226		1921226		2114109		2331435		2331435		2331435		2538867
amend_id		0		1		0		0		1		0		0		2		1		0
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601
sender_id		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979
filer_id		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979
entity_cd		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM
filer_naml		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES
filer_namf		None		None		None		None		None		None		None		None		None		None
filer_namt		None		None		None		None		None		None		None		None		None		None
filer_nams		None		None		None		None		None		None		None		None		None		None
report_num		000		001		000		000		001		000		000		002		001		000
rpt_date		2010-12-31 00:00:00		2011-05-26 00:00:00		2012-12-31 00:00:00		2014-12-29 00:00:00		2016-07-27 00:00:00		2016-12-27 00:00:00		2019-01-01 00:00:00		2020-01-08 00:00:00		2020-01-08 00:00:00		2020-12-29 00:00:00
ls_beg_yr		2011		2011		2013		2015		2015		2017		2019		2019		2019		2021
ls_end_yr		2012		2012		2014		2016		2016		2018		2020		2020		2020		2022
qual_date		2011-01-01 00:00:00		2011-01-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2019-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		None		None
bus_city		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO
bus_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
bus_zip4		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814
bus_phon		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129
bus_fax		9169300542		9169300542		None		None		None		None		None		None		None		None
bus_email		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]
mail_city		None		None		None		None		None		None		None		None		None		None
mail_st		None		None		None		None		None		None		None		None		None		None
mail_zip4		None		None		None		None		None		None		None		None		None		None
mail_phon		None		None		None		None		None		None		None		None		None		None
sig_date		2011-12-31 00:00:00		2011-05-26 00:00:00		2012-12-31 00:00:00		2014-12-29 00:00:00		2016-07-27 00:00:00		2016-12-27 00:00:00		2019-01-01 00:00:00		2020-01-08 00:00:00		2020-01-08 00:00:00		2020-12-29 00:00:00
sig_loc		None		Sacramento, CA		None		None		Sacramento		None		None		Sacramento, CA		Sacramento, CA		None
sig_naml		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner
sig_namf		Bob		Bob		Robert		Robert		Robert		Robert		Robert		Bob		Bob		Robert
sig_namt		None		None		None		None		None		None		None		None		None		None
sig_nams		None		None		None		None		None		None		None		None		None		None
prn_naml		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner		Blattner
prn_namf		Bob		Bob		Robert		Robert		Robert		Robert		Robert		Bob		Bob		Robert
prn_namt		None		None		None		None		None		None		None		None		None		None
prn_nams		None		None		None		None		None		None		None		None		None		None
sig_title		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal
stmt_firm		Blattner & Associates		Blattner & Associates		Blattner & Associates		Blattner & Associates		Blattner & Associates		Blattner & Associates		Blattner & Associates		Blattner & Associates		Blattner & Associates		Blattner & Associates
ind_cb		None		None		None		None		None		None		None		None		None		None
bus_cb		None		None		None		None		None		None		None		None		None		None
trade_cb		None		None		None		None		None		None		None		None		None		None
oth_cb		None		None		None		None		None		None		None		None		None		None
a_b_name		None		None		None		None		None		None		None		None		None		None
a_b_city		None		None		None		None		None		None		None		None		None		None
a_b_st		None		None		None		None		None		None		None		None		None		None
a_b_zip4		None		None		None		None		None		None		None		None		None		None
descrip_1		None		None		None		None		None		None		None		None		None		None
descrip_2		None		None		None		None		None		None		None		None		None		None
c_less50		None		None		None		None		None		None		None		None		None		None
c_more50		None		None		None		None		None		None		None		None		None		None
ind_class		None		None		None		None		None		None		None		None		None		None
ind_descr		None		None		None		None		None		None		None		None		None		None
bus_class		None		None		None		None		None		None		None		None		None		None
bus_descr		None		None		None		None		None		None		None		None		None		None
auth_name		None		None		None		None		None		None		None		None		None		None
auth_city		None		None		None		None		None		None		None		None		None		None
auth_st		None		None		None		None		None		None		None		None		None		None
auth_zip4		None		None		None		None		None		None		None		None		None		None
lobby_int		None		None		None		None		None		None		None		None		None		None
influen_yn		None		None		None		None		None		None		None		None		None		None
firm_name		None		None		None		None		None		None		None		None		None		None
newcert_cb		None		None		None		None		None		None		None		None		None		None
rencert_cb		None		None		None		None		None		None		None		None		None		None
complet_dt		None		None		None		None		None		None		None		None		None		None
lby_reg_cb		None		None		None		None		None		None		None		None		None		None
lby_604_cb		None		None		None		None		None		None		None		None		None		None
st_leg_yn		None		None		None		None		None		None		None		None		None		None
st_agency		None		None		None		None		None		None		None		None		None		None
lobby_cb		None		None		None		None		None		None		None		None		None		None
l_firm_cb		None		None		None		None		None		None		None		None		None		None

Table: filer_address

filer_id		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979
adrid		2103865		2114410		2159262		2204619		2412289		2549117		2278753		2339356		2467540		2506902
effect_dt		2006-06-01 00:00:00		2007-01-01 00:00:00		2009-01-15 00:00:00		2011-01-01 00:00:00		2017-01-01 00:00:00		2023-01-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00		2019-01-01 00:00:00		2021-01-01 00:00:00
add_type		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051
session_id		2005		2007		2009		2011		2017		2023		2013		2015		2019		2021

Table: filer_filings

filer_id		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979
filing_id		1180262		1180264		1193311		1231392		1216453		1225710		1279009		1279009		1258876		1259768		1308014		1308014		1297220		1216453		1773103		1782899		1766048		1981903		1966331		1868666		1800889		1946197		1912630		1328956		1350463		1376401		1421921		1408939		1438020		1398486		1445418		1452755		1485190		1464969		1505709		1552044		1540914		1571720		1598121		1556410		1592436		1556410		1614590		1615238		1622411		1592436		1636633		1606034		1657385		1672403		1817304		1680198		1680198		1680198		1921226		1931654		1709507		1871439		1721833		1726761		1845199		1743680		2339087		2483734		2331435		2331435		2431409		2415248		2470959		2331435		2241575		2212420		2010391		1991389		2035570		2058148		1921226		2060157		2092142		2099414		2128557		2114109		2136002		2169451		2157676		2396325		2345662		2270959		2196325		2197692		2193749		2578897		2538867		2380135		2320639		2524950		2193749		2438075		2550576		2596643		2470959		2470959		2620646		2674292		2713171		2640408		2720637		2703810		2683251		2572535		2716628		2744865
period_id		None		None		None		188		187		None		190		190		None		189		192		192		191		187		None		214		213		222		221		None		215		None		219		193		194		195		197		None		198		195		None		199		201		200		202		None		203		204		None		206		205		204		None		None		207		205		208		206		209		None		216		210		210		210		220		220		211		218		212		None		217		212		None		242		237		241		None		239		241		241		233		232		224		223		225		None		227		226		227		None		228		228		None		230		229		238		236		234		None		None		231		245		244		237		235		243		231		240		244		246		241		241		247		249		None		248		None		250		None		None		None		251
form_id		F601		F999		F625		F625		F625		F601		F625		F625		F605		F625		F625		F625		F625		F625		F605		F625		F625		F625		F625		F605		F625		F601		F625		F625		F625		F625		F625		F601		F625		F625		F605		F625		F625		F625		F625		F601		F625		F625		F605		F601		F625		F601		F605		F605		F625		F625		F625		F625		F625		F605		F625		F625		F625		F625		F601		F625		F625		F625		F601		F601		F625		F625		F601		F625		F601		F601		F605		F625		F625		F601		F625		F625		F625		F625		F625		F605		F601		F625		F625		F605		F625		F601		F601		F625		F625		F625		F625		F625		F605		F605		F625		F625		F601		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F605		F625		F605		F625		F605		F601		F605		F625
filing_sequence		0		0		0		0		0		0		0		1		0		0		0		1		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		1		0		0		0		0		0		0		0		0		0		0		1		0		2		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		2		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		1		2		0		0		0		0		0		0		0		0		0		0
filing_date		2006-06-09 00:00:00		2006-06-12 00:00:00		2006-07-31 00:00:00		2007-01-24 00:00:00		2006-10-31 00:00:00		2007-01-02 00:00:00		2007-07-23 00:00:00		2007-07-23 00:00:00		2007-04-16 00:00:00		2007-04-26 00:00:00		2008-01-29 00:00:00		2008-01-29 00:00:00		2007-10-31 00:00:00		2007-08-14 00:00:00		2013-06-26 00:00:00		2013-07-31 00:00:00		2013-04-30 00:00:00		2015-07-31 00:00:00		2015-04-30 00:00:00		2014-07-02 00:00:00		2013-10-31 00:00:00		2015-01-02 00:00:00		2014-10-31 00:00:00		2008-04-30 00:00:00		2008-07-31 00:00:00		2008-10-30 00:00:00		2009-04-30 00:00:00		2009-02-06 00:00:00		2009-07-31 00:00:00		2009-02-02 00:00:00		2009-09-17 00:00:00		2009-11-02 00:00:00		2010-04-30 00:00:00		2010-02-01 00:00:00		2010-07-29 00:00:00		2010-12-17 00:00:00		2010-11-01 00:00:00		2011-01-31 00:00:00		2011-05-25 00:00:00		2011-05-26 00:00:00		2011-05-10 00:00:00		2010-12-31 00:00:00		2011-08-19 00:00:00		2011-09-20 00:00:00		2011-10-31 00:00:00		2011-05-03 00:00:00		2012-01-31 00:00:00		2011-07-28 00:00:00		2012-04-30 00:00:00		2012-06-06 00:00:00		2014-01-31 00:00:00		2012-08-14 00:00:00		2012-07-31 00:00:00		2012-08-20 00:00:00		2014-12-29 00:00:00		2015-01-28 00:00:00		2012-10-31 00:00:00		2014-07-31 00:00:00		2012-12-31 00:00:00		2012-12-20 00:00:00		2014-04-30 00:00:00		2013-02-06 00:00:00		2018-12-31 00:00:00		2020-07-30 00:00:00		2019-01-01 00:00:00		2020-01-08 00:00:00		2020-01-15 00:00:00		2019-10-24 00:00:00		2020-04-30 00:00:00		2020-01-08 00:00:00		2018-04-30 00:00:00		2018-02-01 00:00:00		2016-01-29 00:00:00		2015-10-09 00:00:00		2016-04-29 00:00:00		2016-07-25 00:00:00		2016-07-27 00:00:00		2016-07-28 00:00:00		2016-10-20 00:00:00		2016-10-20 00:00:00		2017-01-31 00:00:00		2016-12-27 00:00:00		2016-12-28 00:00:00		2017-07-21 00:00:00		2017-05-01 00:00:00		2019-07-30 00:00:00		2019-01-30 00:00:00		2018-07-27 00:00:00		2017-11-15 00:00:00		2017-12-04 00:00:00		2017-10-31 00:00:00		2021-04-29 00:00:00		2020-12-29 00:00:00		2019-04-30 00:00:00		2018-10-31 00:00:00		2020-10-28 00:00:00		2017-12-13 00:00:00		2020-01-29 00:00:00		2021-01-29 00:00:00		2021-07-26 00:00:00		2020-04-30 00:00:00		2020-12-07 00:00:00		2021-10-27 00:00:00		2022-04-29 00:00:00		2022-08-05 00:00:00		2022-01-28 00:00:00		2022-09-07 00:00:00		2022-07-29 00:00:00		2022-04-26 00:00:00		2020-12-30 00:00:00		2022-08-12 00:00:00		2022-10-28 00:00:00
stmnt_type		10005		10005		10005		10001		10001		10005		10001		10002		10005		10001		10001		10002		10001		10002		10006		10001		10001		10001		10001		10006		10001		10005		10001		10001		10001		10001		10001		10005		10001		10001		10006		10001		10001		10001		10001		10005		10001		10001		10006		10002		10002		10001		10006		10006		10001		10001		10001		10001		10001		10006		10001		10002		10001		10002		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10002		10005		10001		10001		10002		10001		10001		10001		10001		10001		10005		10002		10001		10001		10006		10001		10001		10005		10001		10001		10001		10001		10001		10006		10006		10001		10001		10001		10001		10001		10001		10002		10001		10001		10001		10002		10002		10001		10001		10002		10001		10002		10001		10002		10005		10002		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003
session_id		2005		2005		2005		2005		2005		2007		2007		2007		2007		2007		2007		2007		2007		2005		2013		2013		2013		2015		2015		2013		2013		2015		2013		2007		2007		2007		2009		2009		2009		2007		2009		2009		2009		2009		2009		2011		2009		2009		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2013		2011		2011		2011		2015		2013		2011		2013		2013		2013		2013		2011		2019		2019		2019		2019		2019		2019		2019		2019		2017		2017		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2017		2017		2019		2017		2017		2017		2017		2017		2021		2021		2019		2017		2019		2017		2019		2019		2021		2019		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		CFLAGG		CFLAGG		YRODRIGU		YRODRIGU		YRODRIGU		CFLAGG		LTHIBAUL		LTHIBAUL		GPEREZ		YRODRIGU		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		YRODRIGU		ASAETERN		ASAETERN		AGLADNEY		AGLADNEY		YRODRIGU		ASAETERN		SARRIAGA		ASAETERN		LTHIBAUL		MGUERRA		MGUERRA		YRODRIGU		SARRIAGA		YRODRIGU		MGUERRA		YRODRIGU		YRODRIGU		CFLAGG		YRODRIGU		ASAETERN		YRODRIGU		ASAETERN		ASAETERN		YRODRIGU		YRODRIGU		ASAETERN		YRODRIGU		YRODRIGU		YRODRIGU		ASAETERN		TBOWMAN		ASAETERN		ASAETERN		ASAETERN		YRODRIGU		ASAETERN		AGLADNEY		AGLADNEY		AGLADNEY		SARRIAGA		AGLADNEY		ASAETERN		ASAETERN		SARRIAGA		SARRIAGA		ASAETERN		ASAETERN		DMCCASTL		MKIRKHAM		GPEREZ		GPEREZ		GPEREZ		AGLADNEY		MKIRKHAM		GPEREZ		AGLADNEY		KBANH		AGLADNEY		AGLADNEY		AGLADNEY		GPEREZ		YRODRIGU		AGLADNEY		AGLADNEY		YRODRIGU		AGLADNEY		YRODRIGU		YRODRIGU		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		YRODRIGU		YRODRIGU		AGLADNEY		MKIRKHAM		SARRIAGA		AGLADNEY		AGLADNEY		MKIRKHAM		AGLADNEY		AGLADNEY		MKIRKHAM		CHATRIDGE		CAFILER		CAFILER		CHATRIDGE		RATTIYEH		MMERCHANT		CHATRIDGE		MMERCHANT		CAFILER		CVANLIEW		SARRIAGA		NKRESTOFF		CAFILER
special_audit		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11003		11001		11003		11001		11001		11003		11003		11003		11001		11001		11003		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11003		11001		11003		11003		11003		11003		11003		11003
rpt_start		1900-01-01 00:00:00		1900-01-01 00:00:00		2006-04-01 00:00:00		2006-10-01 00:00:00		2006-07-01 00:00:00		1900-01-01 00:00:00		2007-04-01 00:00:00		2007-04-01 00:00:00		1900-01-01 00:00:00		2007-01-01 00:00:00		2007-10-01 00:00:00		2007-10-01 00:00:00		2007-07-01 00:00:00		2006-07-01 00:00:00		1900-01-01 00:00:00		2013-04-01 00:00:00		2013-01-01 00:00:00		2015-04-01 00:00:00		2015-01-01 00:00:00		1900-01-01 00:00:00		2013-07-01 00:00:00		1900-01-01 00:00:00		2014-07-01 00:00:00		2008-01-01 00:00:00		2008-04-01 00:00:00		2008-07-01 00:00:00		2009-01-01 00:00:00		1900-01-01 00:00:00		2009-04-01 00:00:00		2008-09-01 00:00:00		1900-01-01 00:00:00		2009-07-01 00:00:00		2010-01-01 00:00:00		2009-10-01 00:00:00		2010-04-01 00:00:00		1900-01-01 00:00:00		2010-07-01 00:00:00		2010-10-01 00:00:00		1900-01-01 00:00:00		2011-05-26 00:00:00		2011-01-01 00:00:00		2010-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2011-07-01 00:00:00		2011-01-01 00:00:00		2011-10-01 00:00:00		2011-04-01 00:00:00		2012-01-01 00:00:00		1900-01-01 00:00:00		2013-10-01 00:00:00		2012-04-01 00:00:00		2012-04-01 00:00:00		2012-04-01 00:00:00		2014-12-29 00:00:00		2014-10-01 00:00:00		2012-07-01 00:00:00		2014-04-01 00:00:00		2012-12-31 00:00:00		1900-01-01 00:00:00		2014-01-01 00:00:00		2012-10-01 00:00:00		1900-01-01 00:00:00		2020-04-01 00:00:00		2019-01-01 00:00:00		2020-01-08 00:00:00		1900-01-01 00:00:00		2019-07-01 00:00:00		2020-01-01 00:00:00		2020-01-08 00:00:00		2018-01-01 00:00:00		2017-10-01 00:00:00		2015-10-01 00:00:00		2015-07-01 00:00:00		2016-01-01 00:00:00		1900-01-01 00:00:00		2016-07-27 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		1900-01-01 00:00:00		2016-10-01 00:00:00		2016-12-27 00:00:00		1900-01-01 00:00:00		2017-04-01 00:00:00		2017-01-01 00:00:00		2019-04-01 00:00:00		2018-10-01 00:00:00		2018-04-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2017-07-01 00:00:00		2021-01-01 00:00:00		2020-12-29 00:00:00		2019-01-01 00:00:00		2018-07-01 00:00:00		2020-07-01 00:00:00		2017-07-01 00:00:00		2019-10-01 00:00:00		2020-10-01 00:00:00		2021-04-01 00:00:00		2020-01-01 00:00:00		2020-01-01 00:00:00		2021-07-01 00:00:00		2022-01-01 00:00:00		1900-01-01 00:00:00		2021-10-01 00:00:00		1900-01-01 00:00:00		2022-04-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2022-07-01 00:00:00
rpt_end		1900-01-01 00:00:00		1900-01-01 00:00:00		2006-06-30 00:00:00		2006-12-31 00:00:00		2006-09-30 00:00:00		1900-01-01 00:00:00		2007-06-30 00:00:00		2007-06-30 00:00:00		1900-01-01 00:00:00		2007-03-31 00:00:00		2007-12-31 00:00:00		2007-12-31 00:00:00		2007-09-30 00:00:00		2006-09-30 00:00:00		1900-01-01 00:00:00		2013-06-30 00:00:00		2013-03-31 00:00:00		2015-06-30 00:00:00		2015-03-31 00:00:00		1900-01-01 00:00:00		2013-09-30 00:00:00		1900-01-01 00:00:00		2014-09-30 00:00:00		2008-03-31 00:00:00		2008-06-30 00:00:00		2008-09-30 00:00:00		2009-03-31 00:00:00		1900-01-01 00:00:00		2009-06-30 00:00:00		2008-12-31 00:00:00		1900-01-01 00:00:00		2009-09-30 00:00:00		2010-03-31 00:00:00		2009-12-31 00:00:00		2010-06-30 00:00:00		1900-01-01 00:00:00		2010-09-30 00:00:00		2010-12-31 00:00:00		1900-01-01 00:00:00		2011-05-26 00:00:00		2011-03-31 00:00:00		2010-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2011-09-30 00:00:00		2011-03-31 00:00:00		2011-12-31 00:00:00		2011-06-30 00:00:00		2012-03-31 00:00:00		1900-01-01 00:00:00		2013-12-31 00:00:00		2012-06-30 00:00:00		2012-06-30 00:00:00		2012-06-30 00:00:00		2014-12-29 00:00:00		2014-12-31 00:00:00		2012-09-30 00:00:00		2014-06-30 00:00:00		2012-12-31 00:00:00		1900-01-01 00:00:00		2014-03-31 00:00:00		2012-12-31 00:00:00		1900-01-01 00:00:00		2020-06-30 00:00:00		2019-01-01 00:00:00		2020-01-08 00:00:00		1900-01-01 00:00:00		2019-09-30 00:00:00		2020-03-31 00:00:00		2020-01-08 00:00:00		2018-03-31 00:00:00		2017-12-31 00:00:00		2015-12-31 00:00:00		2015-09-30 00:00:00		2016-03-31 00:00:00		1900-01-01 00:00:00		2016-07-27 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		1900-01-01 00:00:00		2016-12-31 00:00:00		2016-12-27 00:00:00		1900-01-01 00:00:00		2017-06-30 00:00:00		2017-03-31 00:00:00		2019-06-30 00:00:00		2018-12-31 00:00:00		2018-06-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2017-09-30 00:00:00		2021-03-31 00:00:00		2020-12-29 00:00:00		2019-03-31 00:00:00		2018-09-30 00:00:00		2020-09-30 00:00:00		2017-09-30 00:00:00		2019-12-31 00:00:00		2020-12-31 00:00:00		2021-06-30 00:00:00		2020-03-31 00:00:00		2020-03-31 00:00:00		2021-09-30 00:00:00		2022-03-31 00:00:00		1900-01-01 00:00:00		2021-12-31 00:00:00		1900-01-01 00:00:00		2022-06-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 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
filing_type		None		None		None		22006		22006		None		22006		22006		None		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		None		22006		None		22006		22006		22006		22006		22006		None		22006		22006		None		22006		22006		22006		22006		None		22006		22006		None		22006		22006		22006		None		None		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		None		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		None		22006		22006		None		22006		22006		22006		22006		22006		None		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		None		22006		None		None		None		22006

Table: filer_to_filer_type

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

Table: filer_xref

filer_id		1286979
xref_id		1286979
effect_dt		2006-06-12 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979
filer_id		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979
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
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
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
naml		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES
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
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
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
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
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
city		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO
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
zip4		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814
phon		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129		9166067129
fax		None		None		9169300542																None		None		9169300542																None		None		9169300542																None		None		9169300542																None		None		9169300542																None		None		9169300542																None		None		9169300542																None		None		9169300542																None		None		9169300542																None		None		9169300542
email		blattnerandassociates.com		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		blattnerandassociates.com		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		blattnerandassociates.com		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		blattnerandassociates.com		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		blattnerandassociates.com		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		blattnerandassociates.com		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		blattnerandassociates.com		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		blattnerandassociates.com		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		blattnerandassociates.com		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		blattnerandassociates.com		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]

Table: filers

filer_id		1286979

Table: lobbying_chg_log

filer_id		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979
change_no		1		0		2		3		4		5		6		7		8
session_id		2005		2005		2007		2009		2011		2011		2013		2017		2021
log_dt		2006-06-09 00:00:00		2006-06-09 00:00:00		2007-04-16 00:00:00		2009-09-17 00:00:00		2011-08-19 00:00:00		2011-09-20 00:00:00		2014-07-02 00:00:00		2017-12-04 00:00:00		2022-09-07 00:00:00
filer_type		3		3		3		3		3		3		3		3		3
correction_flg		None		None		Y		Y		Y		Y		None		Y		None
action		ADDED		ADDED		ADDED		ADDED		ADDED		CHANGED		ADDED		ADDED		ADDED
attribute_changed		CLIENT		LOBBYIST		EMPLOYER		EMPLOYER		EMPLOYER		EFFECTIVE DATE		CLIENT		EMPLOYER		CLIENT
ethics_dt		None		None		None		None		None		None		None		None		None
interests		None		None		None		None		None		None		None		None		None
filer_full_name		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES		BLATTNER & ASSOCIATES
filer_city		None		None		SACRAMENTO		None		None		SACRAMENTO		None		SACRAMENTO		None
filer_st		None		None		CA		None		None		CA		None		CA		None
filer_zip		None		None		95814		None		None		95814		None		95814		None
filer_phone		None		None		9166067129		None		None		9166067129		None		9166067129		None
entity_type		1		4		2		2		2		2		1		2		1
entity_name		NEWPORT-MESA UNIFIED SCHOOL DISTRICT		ROBERT W. BLATTNER		ESCONDIDO CHARTER HIGH SCHOOL		ELK GROVE UNIFIED SCHOOL DISTRICT		CAJON VALLEY UNION SCHOOL DISTRICT		CAJON VALLEY UNION SCHOOL DISTRICT		COLTON-REDLANDS-YUCAIPA ROP		SHORELINE USD		IRVINE UNIFIED SCHOOL DISTRICT
entity_city		None		None		None		None		None		None		None		None		None
entity_st		None		None		None		None		None		None		None		None		None
entity_zip		None		None		None		None		None		None		None		None		None
entity_phone		None		None		None		None		None		None		None		None		None
entity_id		1286981		1148769		None		1142952		1341447		None		1368611		None		1143144
responsible_officer		None		None		None		None		None		None		None		None		None
effect_dt		2006-06-01 00:00:00		2006-06-01 00:00:00		2007-04-10 00:00:00		2009-09-01 00:00:00		2011-06-20 00:00:00		2011-07-10 00:00:00		2014-06-18 00:00:00		2017-11-10 00:00:00		2021-01-01 00:00:00

Table: received_filings

filer_id		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979		1286979
filing_file_name		1556410_0.cal		1556410_1.cal		1721833_0.cal		1921226_1.cal		2114109_0.cal		1921226_0.cal		2331435_0.cal		2331435_1.cal		2331435_2.cal		2538867_0.cal
received_date		2010-12-31 00:00:00		2011-05-26 00:00:00		2012-12-31 00:00:00		2016-07-27 00:00:00		2016-12-27 00:00:00		2014-12-29 00:00:00		2019-01-01 00:00:00		2020-01-08 00:00:00		2020-01-08 00:00:00		2020-12-29 00:00:00
filing_directory		/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		1556410		1556410		1721833		1921226		2114109		1921226		2331435		2331435		2331435		2538867
form_id		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601
receive_comment		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted