Home

Filer ID: 1251637

Table: cvr_lobby_disclosure

filing_id		930533		946661		968527		990318		930533		1012772		1026460		1059334		1080901		1059334		1167800		1105715		1150503		1134278		1105715		1117341		1262395		1192992		1238516		1216551		1238516		1285034		1312221		1351659		1330485		1298218		1445242		1330485		1351659		1378936		1401498		1421915		1378936		1262395		1285034		1298218		1312221		1401498		1485400		1470678		1485422		1470678		1557047		1557055		1557054		1782741		1764745		1801593		1872478		1846026		1818834		1912303		1966688		1981943		1966688		1934301		1996658		2063116		2038220		2012877		2102347		2161486		2161685		2165787		2188408		2201614		2300050		2267939		2250187		2348726
amend_id		0		0		0		0		1		0		0		0		0		1		0		1		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		1		1		1		1		0		0		1		1		1		1		0		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		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
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
sender_id		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637
filer_id		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637
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
filer_naml		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES; MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES; MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES; MARK		NOBILI & ASSOCIATES; MARK		NOBILI & ASSOCIATES; MARK		NOBILI & ASSOCIATES; MARK		NOBILI & ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		Mark Nobili & Associates		Mark Nobili & Associates		Mark Nobili & Associates		Mark Nobili & Associates		NOBILI & ASSOCIATES; MARK		NOBILI & ASSOCIATES; MARK		Mark Nobili & Associates		Mark Nobili & Associates		Mark Nobili & Associates		Mark Nobili & Associates		NOBILI & ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK
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
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
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
report_num		000		000		000		000		001		000		000		000		000		001		000		001		000		000		000		000		000		000		001		000		000		000		000		000		000		000		000		001		001		001		001		000		000		001		001		001		001		000		000		001		000		000		000		000		000		000		000		000		000		000		000		000		001		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000
rpt_date		2003-04-29 00:00:00		2003-07-30 00:00:00		2003-10-29 00:00:00		2004-02-02 00:00:00		2004-04-29 00:00:00		2004-04-29 00:00:00		2004-07-27 00:00:00		2004-11-01 00:00:00		2005-01-31 00:00:00		2006-05-01 00:00:00		2006-05-01 00:00:00		2006-05-01 00:00:00		2006-02-03 00:00:00		2005-10-31 00:00:00		2005-05-02 00:00:00		2005-07-29 00:00:00		2007-04-30 00:00:00		2006-08-01 00:00:00		2007-06-26 00:00:00		2006-10-31 00:00:00		2007-01-31 00:00:00		2007-07-31 00:00:00		2008-01-31 00:00:00		2008-07-31 00:00:00		2008-05-01 00:00:00		2007-11-01 00:00:00		2009-09-16 00:00:00		2009-09-15 00:00:00		2009-09-15 00:00:00		2009-09-15 00:00:00		2009-09-15 00:00:00		2009-04-30 00:00:00		2008-10-31 00:00:00		2009-09-15 00:00:00		2009-09-15 00:00:00		2009-09-15 00:00:00		2009-09-15 00:00:00		2009-02-09 00:00:00		2010-04-30 00:00:00		2010-04-30 00:00:00		2010-04-30 00:00:00		2010-02-25 00:00:00		2011-01-04 00:00:00		2011-01-04 00:00:00		2011-01-04 00:00:00		2013-07-31 00:00:00		2013-04-30 00:00:00		2013-10-31 00:00:00		2014-07-31 00:00:00		2014-04-30 00:00:00		2014-01-31 00:00:00		2014-10-31 00:00:00		2015-07-31 00:00:00		2015-07-31 00:00:00		2015-05-02 00:00:00		2015-01-30 00:00:00		2015-10-30 00:00:00		2016-08-01 00:00:00		2016-05-02 00:00:00		2016-02-01 00:00:00		2016-10-31 00:00:00		2017-05-24 00:00:00		2017-05-25 00:00:00		2017-07-06 00:00:00		2017-10-18 00:00:00		2018-01-12 00:00:00		2018-10-02 00:00:00		2018-07-23 00:00:00		2018-05-17 00:00:00		2019-01-31 00:00:00
from_date		2003-01-01 00:00:00		2003-04-01 00:00:00		2003-07-01 00:00:00		2003-10-01 00:00:00		2003-01-01 00:00:00		2004-01-01 00:00:00		2004-03-01 00:00:00		2004-06-01 00:00:00		2003-01-01 00:00:00		2004-07-01 00:00:00		2006-01-01 00:00:00		2005-01-01 00:00:00		2005-10-01 00:00:00		2005-07-01 00:00:00		2005-01-01 00:00:00		2005-04-01 00:00:00		2007-01-01 00:00:00		2006-04-01 00:00:00		2006-10-01 00:00:00		2006-07-01 00:00:00		2006-10-01 00:00:00		2007-04-01 00:00:00		2007-10-01 00:00:00		2008-04-01 00:00:00		2008-01-01 00:00:00		2007-07-01 00:00:00		2009-04-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		2009-01-01 00:00:00		2008-07-01 00:00:00		2007-01-01 00:00:00		2007-04-01 00:00:00		2007-07-01 00:00:00		2007-10-01 00:00:00		2008-10-01 00:00:00		2009-07-01 00:00:00		2009-10-01 00:00:00		2010-01-01 00:00:00		2009-10-01 00:00:00		2010-04-01 00:00:00		2010-10-01 00:00:00		2010-07-01 00:00:00		2013-04-01 00:00:00		2013-01-01 00:00:00		2013-07-01 00:00:00		2014-04-01 00:00:00		2014-01-01 00:00:00		2013-10-01 00:00:00		2014-07-01 00:00:00		2015-01-01 00:00:00		2015-04-01 00:00:00		2015-01-01 00:00:00		2014-10-01 00:00:00		2015-07-01 00:00:00		2016-04-01 00:00:00		2016-01-01 00:00:00		2015-10-01 00:00:00		2016-07-01 00:00:00		2016-10-01 00:00:00		2017-01-01 00:00:00		2017-04-01 00:00:00		2017-07-01 00:00:00		2017-10-02 00:00:00		2018-07-01 00:00:00		2018-04-01 00:00:00		2018-01-01 00:00:00		2018-10-02 00:00:00
thru_date		2003-03-31 00:00:00		2003-06-30 00:00:00		2001-09-30 00:00:00		2003-12-31 00:00:00		2003-03-31 00:00:00		2004-03-31 00:00:00		2004-06-30 00:00:00		2004-09-30 00:00:00		2004-12-31 00:00:00		2004-09-30 00:00:00		2006-03-31 00:00:00		2005-03-31 00:00:00		2005-12-31 00:00:00		2005-09-30 00:00:00		2005-03-30 00:00:00		2005-06-30 00:00:00		2007-03-30 00:00:00		2006-06-30 00:00:00		2006-12-31 00:00:00		2006-09-30 00:00:00		2006-12-31 00:00:00		2007-06-30 00:00:00		2007-12-31 00:00:00		2008-06-30 00:00:00		2008-03-31 00:00:00		2007-09-30 00:00:00		2009-06-30 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		2009-03-31 00:00:00		2008-09-30 00:00:00		2007-03-31 00:00:00		2007-06-30 00:00:00		2007-09-30 00:00:00		2007-12-31 00:00:00		2008-12-31 00:00:00		2009-09-30 00:00:00		2009-12-31 00:00:00		2010-03-31 00:00:00		2009-12-31 00:00:00		2010-06-30 00:00:00		2010-12-31 00:00:00		2010-09-30 00:00:00		2013-06-30 00:00:00		2013-03-31 00:00:00		2013-09-30 00:00:00		2014-06-30 00:00:00		2014-03-31 00:00:00		2013-12-31 00:00:00		2014-09-30 00:00:00		2015-03-31 00:00:00		2015-06-30 00:00:00		2015-03-31 00:00:00		2014-12-31 00:00:00		2015-09-30 00:00:00		2016-06-30 00:00:00		2016-03-31 00:00:00		2015-12-31 00:00:00		2016-09-30 00:00:00		2016-12-31 00:00:00		2017-03-31 00:00:00		2017-06-30 00:00:00		2017-09-30 00:00:00		2017-12-31 00:00:00		2018-09-30 00:00:00		2018-06-30 00:00:00		2018-03-31 00:00:00		2018-12-31 00:00:00
cum_beg_dt		2003-01-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2002-01-01 00:00:00		2004-10-01 00:00:00		2002-01-01 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2004-01-01 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		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		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2013-01-01 00:00:00		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		None		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		None		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00
firm_id		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637
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		Mark Nobili & Associates		Mark Nobili & Associates		Mark Nobili & Associates		Mark Nobili & Associates		None		None		Mark Nobili & Associates		Mark Nobili & Associates		Mark Nobili & Associates		Mark Nobili & Associates		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
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
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
firm_phon		9165955403		9165955403		9165955403		9165955403		9164572353		9164572353		9164572353		9164572353		9164572353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		916-447-2353		916-447-2353		916-447-2353		916-447-2353		9164472353		9164472353		916-447-2353		916-447-2353		916-447-2353		916-447-2353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353
mail_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
mail_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
mail_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
mail_phon		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sig_date		2003-04-29 00:00:00		2003-07-30 00:00:00		2003-10-28 00:00:00		2004-01-31 00:00:00		2004-04-28 00:00:00		2004-04-28 00:00:00		2004-07-27 00:00:00		2004-10-30 00:00:00		2005-01-31 00:00:00		2006-04-30 00:00:00		2006-04-30 00:00:00		2006-04-30 00:00:00		2006-02-02 00:00:00		2005-10-31 00:00:00		2005-04-02 00:00:00		2005-07-29 00:00:00		2007-04-30 00:00:00		2006-08-01 00:00:00		2006-06-26 00:00:00		2006-10-31 00:00:00		2007-01-31 00:00:00		2007-07-31 00:00:00		2008-01-31 00:00:00		2008-07-31 00:00:00		2008-05-01 00:00:00		2007-11-01 00:00:00		2009-09-16 00:00:00		2009-09-15 00:00:00		2009-09-15 00:00:00		2009-09-15 00:00:00		2009-09-15 00:00:00		2009-04-30 00:00:00		2008-08-31 00:00:00		2009-09-15 00:00:00		2009-09-15 00:00:00		2009-09-15 00:00:00		2009-09-15 00:00:00		2009-02-09 00:00:00		2010-04-30 00:00:00		2010-04-30 00:00:00		2010-04-30 00:00:00		2010-02-25 00:00:00		2011-01-04 00:00:00		2011-01-04 00:00:00		2011-01-04 00:00:00		2013-07-31 00:00:00		2013-04-30 00:00:00		2013-10-31 00:00:00		2014-07-31 00:00:00		2014-04-30 00:00:00		2014-01-31 00:00:00		2014-10-31 00:00:00		2015-07-31 00:00:00		2015-07-31 00:00:00		2015-05-01 00:00:00		2015-01-30 00:00:00		2015-10-30 00:00:00		2016-08-01 00:00:00		2016-05-01 00:00:00		2015-02-01 00:00:00		2016-10-31 00:00:00		2017-05-24 00:00:00		2017-05-25 00:00:00		2017-07-06 00:00:00		2017-10-18 00:00:00		2018-01-12 00:00:00		2018-10-02 00:00:00		2018-07-23 00:00:00		2018-05-17 00:00:00		2019-01-31 00:00:00
sig_loc		Sacramento, CA		Sacramento, CA		Sacramento, Ca		Sacramento, Ca		Sacramento, CA		Sacramento, Ca		Sacramento		Sacramento		Sacramento, Ca		Sacramento, Ca		Sacramento		Sacramento, Ca		Sacramento		Sacramento		Sacramento, Ca		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento		Sacramento, ca		Sacramento, California		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		Sacramento, CA		Sacramento, CA		Sacramento, CA		SACRAMENTO, CA		Sacramento, CA		Sacramento, CA		sacramento ca		SACRAMENTO, CA		SACRAMENTO CA		SACRAMENTO, CA		SACRAMENTO CA		SACRAMENTO CA		SACRAMENTO CA
sig_naml		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		nobili		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		nobili		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		nobili		Nobili		Nobili		Nobili		Nobili		nobili		Nobili		Nobili		Nobili		NOBILI		Nobili		Nobili		Nobili		Nobili		Nobili		NOBILI		Nobili		NOBILI		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		NOBILI		Nobili		Nobili		Nobilli		NOBILI		Nobili		Nobili		NOBILI		NOBILI		NOBILI		NOBILI		NOBILI		NOBILI		NOBILI
sig_namf		Mark		Mark		Mark		Mark		Mark		Mark		Mark		Mark		mark		Mark		Mark		Mark		Mark		Mark		Mark		Mark		Mark		Mark		Mark		Mark		Mark		Mark		Mark		mark		Mark		Mark		Mark		Mark		Mark		Mark		Mark		mark		mark		Mark		Mark		Mark		Mark		mark		Mark		Mark		Mark		MARK		Mark		Mark		Mark		Mark		Mark		MARK		Mark		MARK		Mark		Mark		Mark		Mark		Mark		Mark		MARK		Mark		Mark		Mark		MARK		Mark		Mark		MARK		MARK		MARK		MARK		MARK		MARK		MARK
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
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
prn_naml		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		nobili		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		nobili		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		nobili		Nobili		Nobili		Nobili		Nobili		nobili		Nobili		Nobili		Nobili		NOBILI		Nobili		Nobili		Nobili		Nobili		Nobili		NOBILI		Nobili		NOBILI		Nobili		Nobili		Nobili		Nobili		Nobili		Nobili		NOBILI		Nobili		Nobili		Nobilli		NOBILI		Nobili		Nobili		NOBILI		NOBILI		NOBILI		NOBILI		NOBILI		NOBILI		NOBILI
prn_namf		Mark		Mark		Mark		Mark		Mark		Mark		Mark		Mark		mark		Mark		Mark		Mark		Mark		Mark		Mark		Mark		Mark		Mark		Mark		Mark		Mark		Mark		Mark		mark		Mark		Mark		Mark		Mark		Mark		Mark		Mark		mark		mark		Mark		Mark		Mark		Mark		mark		Mark		Mark		Mark		MARK		Mark		Mark		Mark		Mark		Mark		MARK		Mark		MARK		Mark		Mark		Mark		Mark		Mark		Mark		MARK		Mark		Mark		Mark		MARK		Mark		Mark		MARK		MARK		MARK		MARK		MARK		MARK		MARK
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
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
sig_title		President		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		President		Owner/Lobbyist		Owner/Lobbyist		Owner/Lobbyist		Owner/Lobbyist		owner		owner		Owner/Lobbyist		Owner/Lobbyist		Owner/Lobbyist		Owner/Lobbyist		owner		President		President		President		PRESIDENT		President		President		President		President		President		PRESIDENT		President		PRESIDENT		President		President		President		President		President		President		PRESIDENT		President		Owner		President		PRESIDENT		President		President		PRESIDENT		PRESIDENT		PRESIDENT		PRESIDENT		PRESIDENT		PRESIDENT		PRESIDENT
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
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
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
part1_2_cb		None		None		X		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		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
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
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
lobby_n_cb		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
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
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
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
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
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
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
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

Table: cvr_registration

filing_id		1223957		1486508		1742488		1742488		1945499		1945499		1945499		2188399		2348800
amend_id		0		0		0		1		1		0		2		0		0
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F601		F601		F601		F601		F601		F601		F601		F601		F601
sender_id		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637
filer_id		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637
entity_cd		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM
filer_naml		NOBILI & ASSOCIATES, MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK
filer_namf		None		None		None		None		None		None		None		None		None
filer_namt		None		None		None		None		None		None		None		None		None
filer_nams		None		None		None		None		None		None		None		None		None
report_num		000		000		000		001		001		000		002		000		000
rpt_date		2006-12-20 00:00:00		2010-05-06 00:00:00		2013-02-04 00:00:00		2014-07-31 00:00:00		2015-03-05 00:00:00		2015-02-20 00:00:00		2015-07-31 00:00:00		2017-10-18 00:00:00		2019-01-31 00:00:00
ls_beg_yr		2007		2009		2013		2013		2015		2015		2015		2017		2019
ls_end_yr		2008		2010		2014		2014		2016		2016		2016		2018		2020
qual_date		2007-01-01 00:00:00		2009-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		2019-01-01 00:00:00
eff_date		None		None		None		None		None		None		None		None		None
bus_city		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO
bus_st		CA		CA		CA		CA		CA		CA		CA		CA		CA
bus_zip4		95814		95814		95814		95814		95814		95814		95814		95814		95814
bus_phon		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353
bus_fax		9164472356		9164472356		9164472356		9164472356		9164472356		9164472356		9164472356		9164472356		9164472356
bus_email		[email protected]		None		None		None		None		None		None		None		None
mail_city		None		None		None		None		None		None		None		None		None
mail_st		None		None		None		None		None		None		None		None		None
mail_zip4		None		None		None		None		None		None		None		None		None
mail_phon		None		None		None		None		None		None		None		None		None
sig_date		2006-12-20 00:00:00		2010-05-06 00:00:00		2013-02-04 00:00:00		2014-06-04 00:00:00		2015-02-19 00:00:00		2015-01-30 00:00:00		2015-07-31 00:00:00		2017-10-18 00:00:00		2019-01-31 00:00:00
sig_loc		None		None		None		Sacramento, CA		Houston, TC		None		SACRAMENTO, CA		None		None
sig_naml		NOBILI		Nobili		Nobili		Nobili		Uterback		Nobili		NOBILI		NOBILI		NOBILI
sig_namf		MARK		Mark		Mark		Mark		Greg		Mark		MARK		MARK		MARK
sig_namt		None		None		None		None		None		None		None		None		None
sig_nams		None		None		None		None		None		None		None		None		None
prn_naml		NOBILI		Nobili		Nobili		Nobili		Uterback		Nobili		NOBILI		NOBILI		NOBILI
prn_namf		MARK		Mark		Mark		Mark		Greg		Mark		MARK		MARK		MARK
prn_namt		None		None		None		None		None		None		None		None		None
prn_nams		None		None		None		None		None		None		None		None		None
sig_title		PRESIDENT		President		President		President		Chief Development Officer		President		PRESIDENT		PRESIDENT		PRESIDENT
stmt_firm		MARK NOBILI & ASSOCIATES		Mark Nobili & Associates		Mark Nobili & Associates		Mark Nobili & Associates		Mark Nobili & Associates		Mark Nobili & Associates		Mark Nobili & Associates		MARK NOBILI AND ASSOCIATES		MARK NOBILI AND ASSOCIATES
ind_cb		None		None		None		None		None		None		None		None		None
bus_cb		None		None		None		None		None		None		None		None		None
trade_cb		None		None		None		None		None		None		None		None		None
oth_cb		None		None		None		None		None		None		None		None		None
a_b_name		None		None		None		None		None		None		None		None		None
a_b_city		None		None		None		None		None		None		None		None		None
a_b_st		None		None		None		None		None		None		None		None		None
a_b_zip4		None		None		None		None		None		None		None		None		None
descrip_1		None		None		None		None		None		None		None		None		None
descrip_2		None		None		None		None		None		None		None		None		None
c_less50		None		None		None		None		None		None		None		None		None
c_more50		None		None		None		None		None		None		None		None		None
ind_class		None		None		None		None		None		None		None		None		None
ind_descr		None		None		None		None		None		None		None		None		None
bus_class		None		None		None		None		None		None		None		None		None
bus_descr		None		None		None		None		None		None		None		None		None
auth_name		None		None		None		None		None		None		None		None		None
auth_city		None		None		None		None		None		None		None		None		None
auth_st		None		None		None		None		None		None		None		None		None
auth_zip4		None		None		None		None		None		None		None		None		None
lobby_int		None		None		None		None		None		None		None		None		None
influen_yn		None		None		None		None		None		None		None		None		None
firm_name		None		None		None		None		None		None		None		None		None
newcert_cb		None		None		None		None		None		None		None		None		None
rencert_cb		None		None		None		None		None		None		None		None		None
complet_dt		None		None		None		None		None		None		None		None		None
lby_reg_cb		None		None		None		None		None		None		None		None		None
lby_604_cb		None		None		None		None		None		None		None		None		None
st_leg_yn		None		None		None		None		None		None		None		None		None
st_agency		None		None		None		None		None		None		None		None		None
lobby_cb		None		None		None		None		None		None		None		None		None
l_firm_cb		None		None		None		None		None		None		None		None		None

Table: efs_filing_log

filing_date		2003-04-29 00:00:00		2003-04-29 00:00:00		2003-07-30 00:00:00		2003-07-30 00:00:00		2003-10-29 00:00:00		2003-10-29 00:00:00
filingstatus		1		0		1		0		1		0
vendor		CAL-ACCESS OBJECT MODEL		CAL-ACCESS OBJECT MODEL		CAL-ACCESS OBJECT MODEL		CAL-ACCESS OBJECT MODEL		CAL-ACCESS OBJECT MODEL		CAL-ACCESS OBJECT MODEL
filer_id		1251637		1251637		1251637		1251637		1251637		1251637
form_type		F625		F625		F625		F625		F625		F625
error_no		ACCEPTED		ACCEPTED		ACCEPTED		ACCEPTED		ACCEPTED		ACCEPTED

Table: filer_address

filer_id		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637
adrid		2042912		2063312		2079602		2116847		2159519		2412612		2287247		2338594
effect_dt		2003-01-01 00:00:00		2004-02-02 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2017-01-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00
add_type		7051		7051		7051		7051		7051		7051		7051		7051
session_id		2003		2003		2005		2007		2009		2017		2013		2015

Table: filer_filings

filer_id		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637
filing_id		930533		900950		900960		932387		945170		946661		949621		953459		970756		990318		968527		930533		1012772		1032294		1019093		993151		993561		1035076		1026460		1020484		1076839		1059334		1066630		1063383		1092942		1085848		1080901		1092944		1092948		1092952		1124483		1108162		1109487		1105715		1117341		1134278		1109710		1167800		1059334		1105715		1150503		1183606		1179590		1180985		1223957		1216551		1192992		1256490		1238516		1246235		1285034		1238516		1262395		1782741		1966688		1981943		1945499		1963354		1966688		1963413		1968613		1742488		1872478		1846026		1861537		1801593		1945499		1945499		1912303		1298218		1312221		1330485		1351659		1356898		1378936		1401498		1421915		1423403		1262395		1298218		1330485		1351659		1378936		1401498		1445242		1285034		1312221		1455195		1470678		1485400		1486508		1496200		1470678		1485422		1487558		1557054		1557047		1557055		1818834		1934301		1704841		1742488		1764745		1762817		1996658		2188399		2188408		2012877		2038220		2063116		2102347		2161486		2161685		2165787		2250187		2201614		2348800		2348726		2229192		2267939		2300050
period_id		173		None		None		None		None		174		None		None		None		176		167		173		177		None		None		None		None		None		177		None		None		178		None		None		None		None		173		None		None		None		None		None		None		181		182		183		None		185		179		181		184		None		None		None		188		187		186		None		188		None		190		188		189		214		221		222		223		None		221		None		None		219		218		217		None		215		221		221		219		191		192		193		194		None		195		196		197		None		189		191		193		194		195		196		198		190		192		None		200		199		202		None		200		201		None		203		202		204		216		220		None		213		213		None		223		232		231		224		225		226		227		228		229		230		233		232		237		236		None		234		235
form_id		F625		F601		F605		F625		F605		F625		F605		F625		F625		F625		F625		F625		F625		F605		F625		F605		F625		F625		F625		F690		F601		F625		F605		F625		F605		F625		F625		F605		F605		F605		F605		F605		F605		F625		F625		F625		F605		F625		F625		F625		F625		F605		F605		F605		F601		F625		F625		F605		F625		F601		F625		F625		F625		F625		F625		F625		F601		F601		F625		F605		F605		F601		F625		F625		F605		F625		F601		F601		F625		F625		F625		F625		F625		F605		F625		F625		F625		F601		F625		F625		F625		F625		F625		F625		F625		F625		F625		F666		F625		F625		F601		F605		F625		F625		F605		F625		F625		F625		F625		F625		F888		F601		F625		F601		F625		F601		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F601		F625		F601		F625		F625
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		1		0		0		0		0		0		0		0		0		0		0		0		1		0		0		1		0		2		0		0		0		0		1		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		1		1		1		1		1		1		0		1		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
filing_date		2003-04-29 00:00:00		2002-12-30 00:00:00		2003-01-03 00:00:00		2003-04-30 00:00:00		2003-07-21 00:00:00		2003-07-30 00:00:00		2003-08-07 00:00:00		2003-07-31 00:00:00		2003-10-30 00:00:00		2004-02-02 00:00:00		2003-10-29 00:00:00		2004-04-29 00:00:00		2004-04-29 00:00:00		2004-07-30 00:00:00		2004-04-29 00:00:00		2004-02-09 00:00:00		2004-02-02 00:00:00		2004-07-30 00:00:00		2004-07-27 00:00:00		2004-04-29 00:00:00		2005-01-01 00:00:00		2004-11-01 00:00:00		2004-12-13 00:00:00		2004-11-01 00:00:00		2005-01-14 00:00:00		2005-01-31 00:00:00		2005-01-31 00:00:00		2005-01-14 00:00:00		2005-01-13 00:00:00		2004-12-13 00:00:00		2005-08-29 00:00:00		2005-05-24 00:00:00		2005-06-13 00:00:00		2005-05-02 00:00:00		2005-07-29 00:00:00		2005-10-31 00:00:00		2005-06-13 00:00:00		2006-05-01 00:00:00		2006-05-01 00:00:00		2006-05-01 00:00:00		2006-02-03 00:00:00		2006-07-10 00:00:00		2006-06-06 00:00:00		2006-06-20 00:00:00		2006-12-20 00:00:00		2006-10-31 00:00:00		2006-08-01 00:00:00		2007-03-09 00:00:00		2007-01-31 00:00:00		2007-01-02 00:00:00		2007-07-31 00:00:00		2007-06-26 00:00:00		2007-04-30 00:00:00		2013-07-31 00:00:00		2015-07-31 00:00:00		2015-07-31 00:00:00		2015-07-31 00:00:00		2015-03-05 00:00:00		2015-05-02 00:00:00		2015-03-05 00:00:00		2015-05-15 00:00:00		2014-07-31 00:00:00		2014-07-31 00:00:00		2014-04-30 00:00:00		2014-06-11 00:00:00		2013-10-31 00:00:00		2015-03-05 00:00:00		2015-02-20 00:00:00		2014-10-31 00:00:00		2007-11-01 00:00:00		2008-01-31 00:00:00		2008-05-01 00:00:00		2008-07-31 00:00:00		2008-08-14 00:00:00		2008-10-31 00:00:00		2009-02-09 00:00:00		2009-04-30 00:00:00		2009-01-30 00:00:00		2009-09-16 00:00:00		2009-09-16 00:00:00		2009-09-16 00:00:00		2009-09-16 00:00:00		2009-09-16 00:00:00		2009-09-16 00:00:00		2009-09-16 00:00:00		2009-09-16 00:00:00		2009-09-16 00:00:00		2009-11-30 00:00:00		2010-02-25 00:00:00		2010-04-30 00:00:00		2010-05-06 00:00:00		2010-05-19 00:00:00		2010-04-30 00:00:00		2010-04-30 00:00:00		2010-05-07 00:00:00		2011-01-04 00:00:00		2011-01-04 00:00:00		2011-01-04 00:00:00		2014-01-31 00:00:00		2015-01-30 00:00:00		2012-03-23 00:00:00		2013-02-04 00:00:00		2013-04-30 00:00:00		2013-02-22 00:00:00		2015-10-30 00:00:00		2017-10-18 00:00:00		2017-10-18 00:00:00		2016-02-01 00:00:00		2016-05-02 00:00:00		2016-08-01 00:00:00		2016-10-31 00:00:00		2017-05-24 00:00:00		2017-05-25 00:00:00		2017-07-06 00:00:00		2018-05-17 00:00:00		2018-01-12 00:00:00		2019-01-31 00:00:00		2019-01-31 00:00:00		2018-04-06 00:00:00		2018-07-23 00:00:00		2018-10-02 00:00:00
stmnt_type		10001		10005		10005		10005		10005		10001		10005		10005		10005		10001		10001		10002		10001		10005		10005		10005		10005		10005		10001		10006		10005		10001		10005		10005		10005		10005		10001		10005		10005		10005		10005		10005		10005		10001		10001		10001		10005		10001		10002		10002		10001		10005		10005		10005		10001		10001		10001		10005		10001		10005		10001		10002		10001		10001		10002		10001		10002		10005		10001		10006		10006		10002		10001		10001		10005		10001		10002		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10005		10002		10002		10002		10002		10002		10002		10001		10002		10002		10005		10001		10001		10001		10006		10002		10001		10006		10001		10001		10001		10001		10001		10005		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001
stmnt_status		11003		11001		11001		11001		11001		11003		11001		11001		11001		11003		11003		11003		11003		11001		11001		11001		11001		11001		11003		11003		11001		11003		11001		11001		11001		11001		11003		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11003		11003		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		11003		11001		11003		11003
session_id		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2003		2003		2003		2005		2003		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2003		2005		2003		2005		2005		2005		2005		2005		2007		2005		2005		2007		2005		2007		2007		2005		2007		2013		2015		2015		2015		2015		2015		2015		2015		2013		2013		2013		2013		2013		2015		2015		2013		2007		2007		2007		2007		2007		2007		2007		2009		2009		2007		2007		2007		2007		2007		2007		2009		2007		2007		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2013		2013		2009		2013		2013		2013		2015		2017		2017		2015		2015		2015		2015		2015		2017		2017		2017		2017		2019		2017		2017		2017		2017
user_id		COMPLETED		SARRIAGA		SARRIAGA		YBONILLA		SARRIAGA		COMPLETED		CFLAGG		YBONILLA		YBONILLA		COMPLETED		COMPLETED		COMPLETED		COMPLETED		SARRIAGA		LTHIBAUL		GPEREZ		LTHIBAUL		LTHIBAUL		COMPLETED		EMCENTEE		CFLAGG		COMPLETED		GPEREZ		YRODRIGUEZ		CFLAGG		YRODRIGU		COMPLETED		EMCENTEE		CFLAGG		EMCENTEE		SARRIAGA		CFLAGG		CFLAGG		YRODRIGU		YRODRIGU		YRODRIGU		SARRIAGA		LTHIBAUL		*		*		LTHIBAUL		SARRIAGA		CFLAGG		SARRIAGA		*		LTHIBAUL		LTHIBAUL		PBANFORD		YRODRIGU		GPEREZ		YRODRIGU		YRODRIGU		YRODRIGU		ASAETERN		AGLADNEY		AGLADNEY		CAFILER		YRODRIGU		AGLADNEY		YRODRIGU		YRODRIGU		YRODRIGU		ASAETERN		ASAETERN		SARRIAGA		ASAETERN		YRODRIGU		YRODRIGU		ASAETERN		YRODRIGU		LTHIBAUL		YRODRIGU		YRODRIGU		CFLAGG		MGUERRA		MGUERRA		MGUERRA		SARRIAGA		*		*		MGUERRA		MGUERRA		MGUERRA		MGUERRA		MGUERRA		*		*		MGUERRA		NWALKER		RGEREMIA		YRODRIGU		YRODRIGU		NWALKER		MGUERRA		YRODRIGU		ASAETERN		ASAETERN		ASAETERN		ASAETERN		AGLADNEY		NLANDERS		SARRIAGA		ASAETERN		SARRIAGA		AGLADNEY		GPEREZ		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		CAFILER		CAFILER		GPEREZ		CAFILER		CAFILER
special_audit		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		11001		11003		11003		11001		11001		11001		11003		11003		11003		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11003		11003		11003
rpt_start		2003-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2003-01-01 00:00:00		1900-01-01 00:00:00		2003-04-01 00:00:00		1900-01-01 00:00:00		2003-04-01 00:00:00		2003-07-01 00:00:00		2003-10-01 00:00:00		2003-07-01 00:00:00		2003-01-01 00:00:00		2004-01-01 00:00:00		1900-01-01 00:00:00		2004-01-01 00:00:00		1900-01-01 00:00:00		2003-10-01 00:00:00		2004-03-01 00:00:00		2004-03-01 00:00:00		2004-01-01 00:00:00		1900-01-01 00:00:00		2004-06-01 00:00:00		1900-01-01 00:00:00		2004-07-01 00:00:00		1900-01-01 00:00:00		2004-10-01 00:00:00		2003-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2005-01-01 00:00:00		2005-04-01 00:00:00		2005-07-01 00:00:00		1900-01-01 00:00:00		2006-01-01 00:00:00		2004-07-01 00:00:00		2005-01-01 00:00:00		2005-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2006-12-20 00:00:00		2006-07-01 00:00:00		2006-04-01 00:00:00		1900-01-01 00:00:00		2006-10-01 00:00:00		1900-01-01 00:00:00		2007-04-01 00:00:00		2006-10-01 00:00:00		2007-01-01 00:00:00		2013-04-01 00:00:00		2015-01-01 00:00:00		2015-04-01 00:00:00		2015-07-31 00:00:00		1900-01-01 00:00:00		2015-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2014-07-31 00:00:00		2014-04-01 00:00:00		2014-01-01 00:00:00		1900-01-01 00:00:00		2013-07-01 00:00:00		2015-03-05 00:00:00		2015-02-20 00:00:00		2014-07-01 00:00:00		2007-07-01 00:00:00		2007-10-01 00:00:00		2008-01-01 00:00:00		2008-04-01 00:00:00		1900-01-01 00:00:00		2008-07-01 00:00:00		2008-10-01 00:00:00		2009-01-01 00:00:00		1900-01-01 00:00:00		2007-01-01 00:00:00		2007-07-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		2009-04-01 00:00:00		2007-04-01 00:00:00		2007-10-01 00:00:00		2007-01-01 00:00:00		2009-10-01 00:00:00		2009-07-01 00:00:00		2010-05-06 00:00:00		1900-01-01 00:00:00		2009-10-01 00:00:00		2010-01-01 00:00:00		1900-01-01 00:00:00		2010-07-01 00:00:00		2010-04-01 00:00:00		2010-10-01 00:00:00		2013-10-01 00:00:00		2014-10-01 00:00:00		None		2013-02-04 00:00:00		2013-01-01 00:00:00		1900-01-01 00:00:00		2015-07-01 00:00:00		2017-10-18 00:00:00		2017-07-01 00:00:00		2015-10-01 00:00:00		2016-01-01 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		2016-10-01 00:00:00		2017-01-01 00:00:00		2017-04-01 00:00:00		2018-01-01 00:00:00		2017-10-02 00:00:00		2019-01-31 00:00:00		2018-10-02 00:00:00		1900-01-01 00:00:00		2018-04-01 00:00:00		2018-07-01 00:00:00
rpt_end		2003-03-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2003-03-31 00:00:00		1900-01-01 00:00:00		2003-06-30 00:00:00		1900-01-01 00:00:00		2003-06-30 00:00:00		2003-09-30 00:00:00		2003-12-31 00:00:00		2001-09-30 00:00:00		2003-03-31 00:00:00		2004-03-31 00:00:00		1900-01-01 00:00:00		2004-03-31 00:00:00		1900-01-01 00:00:00		2003-12-31 00:00:00		2004-06-30 00:00:00		2004-06-30 00:00:00		2004-03-31 00:00:00		1900-01-01 00:00:00		2004-09-30 00:00:00		1900-01-01 00:00:00		2004-09-30 00:00:00		1900-01-01 00:00:00		2004-12-31 00:00:00		2004-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2005-03-30 00:00:00		2005-06-30 00:00:00		2005-09-30 00:00:00		1900-01-01 00:00:00		2006-03-31 00:00:00		2004-09-30 00:00:00		2005-03-31 00:00:00		2005-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2006-12-20 00:00:00		2006-09-30 00:00:00		2006-06-30 00:00:00		1900-01-01 00:00:00		2006-12-31 00:00:00		1900-01-01 00:00:00		2007-06-30 00:00:00		2006-12-31 00:00:00		2007-03-30 00:00:00		2013-06-30 00:00:00		2015-03-31 00:00:00		2015-06-30 00:00:00		2015-07-31 00:00:00		1900-01-01 00:00:00		2015-03-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2014-07-31 00:00:00		2014-06-30 00:00:00		2014-03-31 00:00:00		1900-01-01 00:00:00		2013-09-30 00:00:00		2015-03-05 00:00:00		2015-02-20 00:00:00		2014-09-30 00:00:00		2007-09-30 00:00:00		2007-12-31 00:00:00		2008-03-31 00:00:00		2008-06-30 00:00:00		1900-01-01 00:00:00		2008-09-30 00:00:00		2008-12-31 00:00:00		2009-03-31 00:00:00		1900-01-01 00:00:00		2007-03-31 00:00:00		2007-09-30 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		2009-06-30 00:00:00		2007-06-30 00:00:00		2007-12-31 00:00:00		2008-12-31 00:00:00		2009-12-31 00:00:00		2009-09-30 00:00:00		2010-05-06 00:00:00		1900-01-01 00:00:00		2009-12-31 00:00:00		2010-03-31 00:00:00		1900-01-01 00:00:00		2010-09-30 00:00:00		2010-06-30 00:00:00		2010-12-31 00:00:00		2013-12-31 00:00:00		2014-12-31 00:00:00		None		2013-02-04 00:00:00		2013-03-31 00:00:00		1900-01-01 00:00:00		2015-09-30 00:00:00		2017-10-18 00:00:00		2017-09-30 00:00:00		2015-12-31 00:00:00		2016-03-31 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		2016-12-31 00:00:00		2017-03-31 00:00:00		2017-06-30 00:00:00		2018-03-31 00:00:00		2017-12-31 00:00:00		2019-01-31 00:00:00		2018-12-31 00:00:00		1900-01-01 00:00:00		2018-06-30 00:00:00		2018-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
filing_type		22006		None		None		None		None		22006		None		None		None		22006		22006		22006		22006		None		None		None		None		None		22006		None		None		22006		None		None		None		None		22006		None		None		None		None		None		None		22006		22006		22006		None		22006		22006		22006		22006		None		None		None		22006		22006		22006		None		22006		None		22006		22006		22006		22006		22006		22006		22006		None		22006		None		None		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		None		22001		22001		22001		22001		22001		22001		22006		22001		22001		None		22006		22006		22006		None		22006		22006		None		22006		22006		22006		22006		22006		None		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006

Table: filer_to_filer_type

filer_id		1251637		1251637		1251637		1251637		1251637		1251637		1251637
filer_type		3		3		3		3		3		3		3
active		Y		Y		Y		Y		Y		Y		S
race		0		0		0		None		None		None		None
session_id		2003		2005		2007		2013		2009		2015		2017
category		0		0		0		None		None		None		None
category_type		0		0		0		None		None		None		None
sub_category		0		0		0		None		None		None		None
effect_dt		2003-01-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2013-01-01 00:00:00		2009-01-01 00:00:00		2015-01-01 00:00:00		2017-01-01 00:00:00
sub_category_type		0		0		0		None		None		None		None
election_type		0		0		0		None		None		None		None
sub_category_a		None		None		None		None		None		None		None
nyq_dt		None		2003-01-01 00:00:00		2003-01-01 00:00:00		None		None		None		None
party_cd		0		0		0		None		None		None		None
county_cd		0		0		0		None		None		None		None
district_cd		0		0		0		None		None		None		None

Table: filer_xref

filer_id		1251637
xref_id		1251637
effect_dt		2003-01-07 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637
filer_id		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637
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
status		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S
effect_dt		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00
naml		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES; MARK		NOBILI & ASSOCIATES; MARK		NOBILI & ASSOCIATES; MARK		NOBILI & ASSOCIATES; MARK		NOBILI & ASSOCIATES; MARK		NOBILI & ASSOCIATES; MARK		NOBILI & ASSOCIATES; MARK		NOBILI & ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK
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
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
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
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
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
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
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
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
phon		9165955403		9164572353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9165955403		9164572353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9165955403		9164572353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9165955403		9164572353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9165955403		9164572353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9165955403		9164572353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353		9165955403		9164572353		9164472353		9164472353		9164472353		9164472353		9164472353		9164472353
fax		None		None		9164472356		9164472356		9164472356		9164472356		9164472356		9164472356		None		None		9164472356		9164472356		9164472356		9164472356		9164472356		9164472356		None		None		9164472356		9164472356		9164472356		9164472356		9164472356		9164472356		None		None		9164472356		9164472356		9164472356		9164472356		9164472356		9164472356		None		None		9164472356		9164472356		9164472356		9164472356		9164472356		9164472356		None		None		9164472356		9164472356		9164472356		9164472356		9164472356		9164472356		None		None		9164472356		9164472356		9164472356		9164472356		9164472356		9164472356
email		[email protected]		[email protected]		None		[email protected]		None		None		None		None		[email protected]		[email protected]		None		[email protected]		None		None		None		None		[email protected]		[email protected]		None		[email protected]		None		None		None		None		[email protected]		[email protected]		None		[email protected]		None		None		None		None		[email protected]		[email protected]		None		[email protected]		None		None		None		None		[email protected]		[email protected]		None		[email protected]		None		None		None		None		[email protected]		[email protected]		None		[email protected]		None		None		None		None

Table: filers

filer_id		1251637

Table: lobbying_chg_log

filer_id		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637
change_no		0		1		4		2		3		5		6		7		8		9		10		11		12		13		14
session_id		2003		2003		2005		2005		2005		2007		2007		2009		2009		2013		2013		2013		2015		2015		2015
log_dt		2003-07-21 00:00:00		2004-07-30 00:00:00		2006-06-06 00:00:00		2005-05-24 00:00:00		2005-05-24 00:00:00		2007-03-09 00:00:00		2008-08-14 00:00:00		2010-05-07 00:00:00		2010-05-19 00:00:00		2013-02-22 00:00:00		2013-02-22 00:00:00		2013-02-22 00:00:00		2015-03-05 00:00:00		2015-03-05 00:00:00		2015-03-15 00:00:00
filer_type		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3
correction_flg		Y		None		None		None		None		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y
action		ADDED		DELETED		DELETED		ADDED		SET ACTIVE		ADDED		DELETED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED
attribute_changed		None		CLIENT		CLIENT		CLIENT		CLIENT		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		LOBBYIST		EMPLOYER		LOBBYIST		EMPLOYER
ethics_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
interests		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_full_name		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES, MARK		NOBILI & ASSOCIATES; MARK		NOBILI & ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK		NOBILI AND ASSOCIATES; MARK
filer_city		None		None		None		None		None		SACRAMENTO		None		None		None		None		None		SACRAMENTO		None		SACRAMENTO		SACRAMENTO
filer_st		None		None		None		None		None		CA		None		None		None		None		None		CA		None		CA		CA
filer_zip		None		None		None		None		None		95814		None		None		None		None		None		95814		None		95814		95814
filer_phone		None		None		None		None		None		9165955403		None		None		None		None		None		9164472353		None		9164472353		9164472353
entity_type		2		1		1		1		1		2		2		2		2		2		2		4		2		4		2
entity_name		ALTERNATIVE PROGRAMS, INC.		HDNET, LLC		ELDRIDGE BID REPORTER		ELDRIDGE BID REPORTER		CORNELL COMPANIES, INC.		MEDICAL DEVELOPMENT INTERNATIONAL		MHM SERVICES, INC.		SATELLITE TRACKING OF PEOPLE LLC		MEDICAL DEVELOPMENT INTERNATIONAL		HARVEST FARMS, INC		SATELLITE TRACKING OF PEOPLE, LLC		NOBILI, MARK D.		SATELLITE TRACKING OF PEOPLE, LLC		NOBILI, MARK D.		HARVEST FARMS
entity_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
entity_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
entity_zip		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
entity_phone		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
entity_id		1145663		1243085		1277076		1277076		1144510		None		1239587		1279648		1274935		1287751		1279648		None		0		None		None
responsible_officer		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
effect_dt		2003-07-15 00:00:00		2004-06-30 00:00:00		2005-10-01 00:00:00		2005-05-23 00:00:00		2005-01-10 00:00:00		2007-01-01 00:00:00		2007-09-30 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2015-03-05 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00

Table: received_filings

filer_id		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637		1251637
filing_file_name		930533_0.cal		946661_0.cal		968527_0.cal		1486508_0.cal		294091.cal		302448.cal		1401498_1.cal		1330485_1.cal		1351659_1.cal		1378936_1.cal		304960.cal		1298218_1.cal		1223957_0.cal		1742488_0.cal		1742488_1.cal		1945499_2.cal		1945499_0.cal		1945499_1.cal		2188399_0.cal		2348800_0.cal
received_date		2003-04-29 00:00:00		2003-07-30 00:00:00		2003-10-29 00:00:00		2010-05-06 00:00:00		2009-09-15 00:00:00		2009-09-16 00:00:00		2009-09-16 00:00:00		2009-09-16 00:00:00		2009-09-16 00:00:00		2009-09-16 00:00:00		2009-09-16 00:00:00		2009-09-16 00:00:00		2006-12-20 00:00:00		2013-02-04 00:00:00		2014-07-31 00:00:00		2015-07-31 00:00:00		2015-02-20 00:00:00		2015-03-05 00:00:00		2017-10-18 00:00:00		2019-01-31 00:00:00
filing_directory		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/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
filing_id		930533		946661		968527		1486508		None		None		1401498		1330485		1351659		1378936		None		1298218		1223957		1742488		1742488		1945499		1945499		1945499		2188399		2348800
form_id		F625		F625		F625		F601		None		None		F625		F625		F625		F625		None		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 passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		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