Home

Filer ID: 1260704

Table: cvr_lobby_disclosure

filing_id		987509		1013055		1028363		1057330		1078078		1131836		1104456		1165550		1148437		1117696		1187278		1280078		1234421		1206573		1260024		1310597		1348318		1294584		1330166		1420627		1450856		1377804		1420627		1435469		1396309		1534773		1482913		1503902		1463140		1568397		1606016		1621216		1606016		1589012		1633058		1708748		1606016		1633058		1677210		1657477		1621216		1657477		1735206		1797354		1781983		1763634		1781983		1763634		1797354		1870232		1907682		1844903		1818886		1981118		1965118		1936631		1997425		2060342		2035492		2010678		2099148		2175639		2155512		2129008		2193206		2207594		2275339		2242156		2320260		2349124
amend_id		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		1		0		0		0		0		0		2		1		0		0		1		1		0		0		0		0		1		1		1		0		0		0		0		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		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704
filer_id		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704
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		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.
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		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		001		000		000		000		000		000		002		001		000		000		001		001		000		000		000		000		001		001		001		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000
rpt_date		2004-01-16 00:00:00		2004-04-21 00:00:00		2004-07-26 00:00:00		2004-10-12 00:00:00		2005-01-18 00:00:00		2005-10-24 00:00:00		2005-04-30 00:00:00		2006-04-14 00:00:00		2006-01-27 00:00:00		2005-07-29 00:00:00		2006-07-17 00:00:00		2007-07-23 00:00:00		2007-01-26 00:00:00		2006-10-12 00:00:00		2007-04-13 00:00:00		2008-01-28 00:00:00		2008-07-25 00:00:00		2007-10-18 00:00:00		2008-04-18 00:00:00		2009-04-22 00:00:00		2009-10-12 00:00:00		2008-10-28 00:00:00		2009-07-24 00:00:00		2009-07-24 00:00:00		2009-01-26 00:00:00		2010-10-15 00:00:00		2010-04-15 00:00:00		2010-07-26 00:00:00		2010-01-22 00:00:00		2011-01-21 00:00:00		2011-08-01 00:00:00		2011-10-19 00:00:00		2011-07-25 00:00:00		2011-04-26 00:00:00		2012-01-25 00:00:00		2012-10-26 00:00:00		2011-08-01 00:00:00		2012-07-02 00:00:00		2012-07-25 00:00:00		2012-04-13 00:00:00		2012-07-02 00:00:00		2012-07-02 00:00:00		2013-01-28 00:00:00		2013-10-15 00:00:00		2013-07-25 00:00:00		2013-04-25 00:00:00		2013-10-29 00:00:00		2013-10-29 00:00:00		2013-10-29 00:00:00		2014-07-28 00:00:00		2014-10-27 00:00:00		2014-04-25 00:00:00		2014-01-29 00:00:00		2015-07-29 00:00:00		2015-04-21 00:00:00		2015-01-28 00:00:00		2015-10-26 00:00:00		2016-07-29 00:00:00		2016-04-27 00:00:00		2016-01-28 00:00:00		2016-10-28 00:00:00		2017-07-26 00:00:00		2017-04-28 00:00:00		2017-01-30 00:00:00		2017-10-20 00:00:00		2018-01-29 00:00:00		2018-07-27 00:00:00		2018-04-18 00:00:00		2018-10-29 00:00:00		2019-01-31 00:00:00
from_date		2003-10-01 00:00:00		2004-01-01 00:00:00		2004-04-01 00:00:00		2004-07-01 00:00:00		2004-10-01 00:00:00		2005-07-01 00:00:00		2005-01-01 00:00:00		2006-01-01 00:00:00		2005-10-01 00:00:00		2005-04-01 00:00:00		2006-04-01 00:00:00		2007-04-01 00:00:00		2006-10-01 00:00:00		2006-07-01 00:00:00		2007-01-01 00:00:00		2007-10-01 00:00:00		2008-04-01 00:00:00		2007-07-01 00:00:00		2008-01-01 00:00:00		2009-01-01 00:00:00		2009-07-01 00:00:00		2008-07-01 00:00:00		2009-01-01 00:00:00		2009-04-01 00:00:00		2008-10-01 00:00:00		2010-07-01 00:00:00		2010-01-01 00:00:00		2010-04-01 00:00:00		2009-10-01 00:00:00		2010-10-01 00:00:00		2011-04-01 00:00:00		2011-07-01 00:00:00		2011-04-01 00:00:00		2011-01-01 00:00:00		2011-10-01 00:00:00		2012-07-01 00:00:00		2011-04-01 00:00:00		2011-10-01 00:00:00		2012-04-01 00:00:00		2012-01-01 00:00:00		2011-07-01 00:00:00		2012-01-01 00:00:00		2012-10-01 00:00:00		2013-07-01 00:00:00		2013-04-01 00:00:00		2013-01-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-07-01 00:00:00		2014-01-01 00:00:00		2013-10-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		2017-04-01 00:00:00		2017-01-01 00:00:00		2016-10-01 00:00:00		2017-07-01 00:00:00		2017-10-01 00:00:00		2018-04-01 00:00:00		2018-01-01 00:00:00		2018-07-01 00:00:00		2018-10-01 00:00:00
thru_date		2003-12-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		2005-09-30 00:00:00		2005-03-31 00:00:00		2006-03-31 00:00:00		2005-12-31 00:00:00		2005-06-30 00:00:00		2006-06-30 00:00:00		2007-06-30 00:00:00		2006-12-31 00:00:00		2006-09-30 00:00:00		2007-03-31 00:00:00		2007-12-31 00:00:00		2008-06-30 00:00:00		2007-09-30 00:00:00		2008-03-31 00:00:00		2009-03-31 00:00:00		2009-09-30 00:00:00		2008-09-30 00:00:00		2009-03-31 00:00:00		2009-06-30 00:00:00		2008-12-31 00:00:00		2010-09-30 00:00:00		2010-03-31 00:00:00		2010-06-30 00:00:00		2009-12-31 00:00:00		2010-12-31 00:00:00		2011-06-30 00:00:00		2011-09-30 00:00:00		2011-06-30 00:00:00		2011-03-31 00:00:00		2011-12-31 00:00:00		2012-09-30 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2012-06-30 00:00:00		2012-03-31 00:00:00		2011-09-30 00:00:00		2012-03-31 00:00:00		2012-12-31 00:00:00		2013-09-30 00:00:00		2013-06-30 00:00:00		2013-03-31 00:00:00		2013-06-30 00:00:00		2013-03-31 00:00:00		2013-09-30 00:00:00		2014-06-30 00:00:00		2014-09-30 00:00:00		2014-03-31 00:00:00		2013-12-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		2017-06-30 00:00:00		2017-03-31 00:00:00		2016-12-31 00:00:00		2017-09-30 00:00:00		2017-12-31 00:00:00		2018-06-30 00:00:00		2018-03-31 00:00:00		2018-09-30 00:00:00		2018-12-31 00:00:00
cum_beg_dt		2003-12-01 00:00:00		2003-12-01 00:00:00		2003-12-01 00:00:00		2003-12-01 00:00:00		2003-12-01 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		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		2009-01-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		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		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
firm_id		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704
firm_name		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.
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		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010		(916) 325-1010
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		2004-01-26 00:00:00		2004-04-21 00:00:00		2004-07-26 00:00:00		2004-10-15 00:00:00		2005-01-19 00:00:00		2005-10-24 00:00:00		2005-04-30 00:00:00		2006-04-14 00:00:00		2006-01-26 00:00:00		2005-07-29 00:00:00		2006-07-17 00:00:00		2007-07-23 00:00:00		2007-01-26 00:00:00		2006-10-12 00:00:00		2007-04-13 00:00:00		2008-01-28 00:00:00		2008-07-25 00:00:00		2007-10-18 00:00:00		2008-04-18 00:00:00		2009-04-22 00:00:00		2009-10-12 00:00:00		2008-10-28 00:00:00		2009-07-24 00:00:00		2009-07-24 00:00:00		2009-01-26 00:00:00		2010-10-15 00:00:00		2010-04-15 00:00:00		2010-07-26 00:00:00		2010-01-22 00:00:00		2011-01-21 00:00:00		2011-08-01 00:00:00		2011-10-19 00:00:00		2011-07-25 00:00:00		2011-04-26 00:00:00		2012-01-25 00:00:00		2012-10-26 00:00:00		2011-08-01 00:00:00		2012-07-02 00:00:00		2012-07-25 00:00:00		2012-04-13 00:00:00		2012-07-02 00:00:00		2012-07-02 00:00:00		2013-01-28 00:00:00		2013-10-15 00:00:00		2013-07-25 00:00:00		2013-04-25 00:00:00		2013-10-29 00:00:00		2013-10-29 00:00:00		2013-10-29 00:00:00		2014-07-28 00:00:00		2014-10-27 00:00:00		2014-04-25 00:00:00		2014-01-29 00:00:00		2015-07-29 00:00:00		2015-04-21 00:00:00		2015-01-28 00:00:00		2015-10-26 00:00:00		2016-07-29 00:00:00		2016-04-27 00:00:00		2016-01-28 00:00:00		2016-10-28 00:00:00		2017-07-26 00:00:00		2017-04-28 00:00:00		2017-01-30 00:00:00		2017-10-20 00:00:00		2018-01-29 00:00:00		2018-07-27 00:00:00		2018-04-18 00:00:00		2018-10-29 00:00:00		2019-01-31 00:00:00
sig_loc		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		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		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS
sig_namf		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.
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		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS
prn_namf		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.
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 (4400-nm)		PRESIDENT (4400-nm)		PRESIDENT (4400-NGZ)		PRESIDENT (4400-NGZ)		PRESIDENT (4400-NGZ)		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000sm
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		None		X		X		X		X		X		X		X		None		X		X		X		X		X		None		None		X		X		None		None		X		X		X		X		None		None		None		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		X		None		None		None		None		None		None		None		X		None		None		None		None		None		X		X		None		None		X		X		None		None		None		None		X		X		X		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
ctrib_n_cb		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X
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		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		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		1069399		1226513		1226513		1386605		1553613		1553613		1553613		1553613		1553613		1553613		1553613		1553613		1553613		1721512		1721512		1921257		1921257		2115342		2136837		2115342		2115342
amend_id		0		1		0		0		0		1		4		5		2		3		7		8		6		0		1		0		1		0		0		1		2
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F602		F601		F601
sender_id		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		F00980		1260704		1260704
filer_id		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704
entity_cd		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		LEM		FRM		FRM
filer_naml		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.
filer_namf		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
filer_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
report_num		000		001		000		000		000		001		004		005		002		003		007		008		006		000		001		000		001		000		000		001		002
rpt_date		2004-12-13 00:00:00		2007-01-16 00:00:00		2006-12-29 00:00:00		2008-12-31 00:00:00		2010-12-22 00:00:00		2011-08-10 00:00:00		2012-03-26 00:00:00		2012-03-07 00:00:00		2011-12-29 00:00:00		2012-01-24 00:00:00		2012-06-22 00:00:00		2012-06-29 00:00:00		2012-05-03 00:00:00		2012-12-29 00:00:00		2014-07-28 00:00:00		2014-12-19 00:00:00		2016-07-20 00:00:00		2016-12-20 00:00:00		2017-02-10 00:00:00		2017-02-27 00:00:00		2018-01-29 00:00:00
ls_beg_yr		2005		2007		2007		2009		2011		2011		2011		2011		2011		2011		2011		2011		2011		2013		2013		2015		2015		2017		2017		2017		2017
ls_end_yr		2006		2008		2008		2010		2012		2012		2012		2012		2012		2012		2012		2012		2012		2014		2014		2016		2016		2018		2018		2018		2018
qual_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
eff_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2017-02-01 00:00:00		None		None
bus_city		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO
bus_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
bus_zip4		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814
bus_phon		916 325-1010		916 325-1010		916 325-1010		916 325-1010		916 325-1010		916 325-1010		916 325-1010		916 325-1010		916 325-1010		916 325-1010		916 325-1010		916 325-1010		916 325-1010		916 325-1010		916 325-1010		916 325-1010		916 325-1010		916 325-1010		(916) 325-1010		916 325-1010		916 325-1010
bus_fax		(916) 325-1015		(916) 325-1015		(916) 325-1015		(916) 325-1015		(916) 325-1015		(916) 325-1015		(916) 325-1015		(916) 325-1015		(916) 325-1015		(916) 325-1015		(916) 325-1015		(916) 325-1015		(916) 325-1015		(916) 325-1015		(916) 325-1015		(916) 325-1015		(916) 325-1015		(916) 325-1015		(916) 325-1015		(916) 325-1015		(916) 325-1015
bus_email		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]
mail_city		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
mail_zip4		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
sig_date		2004-12-09 00:00:00		2007-01-15 00:00:00		2006-12-21 00:00:00		2008-12-18 00:00:00		2010-12-17 00:00:00		2011-08-10 00:00:00		2012-03-26 00:00:00		2012-03-07 00:00:00		2011-12-29 00:00:00		2012-01-24 00:00:00		2012-06-22 00:00:00		2012-06-29 00:00:00		2012-05-03 00:00:00		2012-12-03 00:00:00		2014-07-28 00:00:00		2014-12-16 00:00:00		2016-07-20 00:00:00		2016-12-19 00:00:00		2017-02-10 00:00:00		2017-02-27 00:00:00		2018-01-29 00:00:00
sig_loc		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA
sig_naml		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS
sig_namf		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.
sig_namt		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
prn_naml		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS		THOMAS
prn_namf		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.		TERRI V.
prn_namt		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
sig_title		PRESIDENT		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh		PRESIDENT 440000jh
stmt_firm		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		None		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.
ind_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
trade_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
oth_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		X		None		None
a_b_name		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
a_b_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
a_b_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
a_b_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
descrip_1		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
descrip_2		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
c_less50		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
c_more50		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
ind_class		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
ind_descr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_class		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_descr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
auth_name		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		EDELSTEIN, GILBERT, ROBSON & SMITH, LLC		None		None
auth_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		SACRAMENTO		None		None
auth_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		CA		None		None
auth_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		95814		None		None
lobby_int		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
influen_yn		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
firm_name		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
newcert_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rencert_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
complet_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
lby_reg_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
lby_604_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
st_leg_yn		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
st_agency		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
lobby_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
l_firm_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filer_address

filer_id		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704
adrid		2059970		2079758		2061230		2114642		2159621		2204983		2412716		2277029		2465852		2339196
effect_dt		2003-12-01 00:00:00		2005-01-01 00:00:00		2004-01-05 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2017-01-01 00:00:00		2013-01-01 00:00:00		2019-01-01 00:00:00		2015-01-01 00:00:00
add_type		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051
session_id		2003		2005		2003		2007		2009		2011		2017		2013		2019		2015

Table: filer_filings

filer_id		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704
filing_id		980616		987509		974006		973969		973971		974375		1009061		1006523		991800		991131		995175		1026862		1028363		1014453		1029177		1051535		1013055		1069399		1057330		1062962		1083548		1078078		1082905		1104456		1117696		1131836		1107141		1107142		1165550		1148437		1187278		1206573		1181328		1226513		1256690		1260024		1226513		1234234		1234421		1280078		1246228		1292277		1294285		1294286		1294584		1781983		1981118		1954847		1965118		1870232		1721512		1763634		1797354		1781983		1797354		1959076		1959078		1959079		1959080		1959081		1959082		1936631		1938861		1291357		1330166		1310597		1348318		1377804		1386605		1396309		1421360		1420627		1420627		1435469		1414334		1445976		1449955		1454125		1450856		1463140		1482913		1503902		1534773		1553613		1556893		1568397		1615078		1606016		1589012		1606016		1621216		1553613		1628148		1633058		1649954		1651051		1657477		1606016		1621216		1633058		1657477		1663443		1677210		1830339		1818886		1553613		1553613		1553613		1553613		1553613		1553613		1553613		1682461		1907682		1921257		1876319		1882703		1721512		1728849		1708748		1735206		1844903		1763634		1997425		2210281		2242156		2193206		2320260		2010678		2035492		1921257		2060342		2065034		2099148		2125835		2129008		2154049		2155512		2137382		2136837		2115342		2175639		2115342		2115342		2275339		2207594		2349124
period_id		None		176		None		None		None		None		None		None		None		None		None		None		178		None		None		None		177		180		179		None		None		180		None		181		182		183		None		None		185		184		186		187		None		188		None		189		189		None		188		190		None		None		None		None		191		214		222		None		221		218		219		213		215		214		215		None		None		None		None		None		None		220		None		None		193		192		194		195		196		196		None		197		197		198		None		None		None		None		199		200		201		202		203		204		None		204		None		206		205		206		207		207		None		208		None		None		209		206		207		208		209		None		210		None		216		208		209		209		209		210		210		210		None		219		220		None		None		212		None		211		212		217		213		223		None		233		231		235		224		225		227		226		None		227		None		228		None		229		None		229		228		230		229		233		234		232		236
form_id		F605		F625		F605		F601		F999		F605		F605		F605		F605		F625		F605		F605		F625		F625		F625		F605		F625		F601		F625		F625		F625		F625		F601		F625		F625		F625		F605		F605		F625		F625		F625		F625		F605		F601		F605		F625		F601		F601		F625		F625		F605		F605		F605		F605		F625		F625		F625		F602		F625		F625		F601		F625		F625		F625		F625		F605		F605		F605		F605		F605		F605		F625		F601		F605		F625		F625		F625		F625		F601		F625		F666		F625		F625		F625		F601		F605		F605		F605		F625		F625		F625		F625		F625		F601		F601		F625		F605		F625		F625		F625		F625		F601		F605		F625		F605		F605		F625		F625		F625		F625		F625		F605		F625		F605		F625		F601		F601		F601		F601		F601		F601		F601		F605		F625		F601		F605		F605		F601		F601		F625		F625		F625		F625		F625		F605		F625		F625		F625		F625		F625		F601		F625		F605		F625		F601		F625		F605		F625		F602		F602		F601		F625		F601		F601		F625		F625		F625
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		1		1		1		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		1		0		0		0		0		0		2		1		1		1		0		0		0		0		2		3		4		5		6		7		8		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		1		2		0		0		0
filing_date		2004-01-08 00:00:00		2004-01-28 00:00:00		2003-12-03 00:00:00		2003-11-26 00:00:00		2003-12-04 00:00:00		2003-12-05 00:00:00		2004-04-12 00:00:00		2004-03-12 00:00:00		2004-02-02 00:00:00		2003-01-29 00:00:00		2004-02-13 00:00:00		2004-07-23 00:00:00		2004-07-29 00:00:00		2004-04-29 00:00:00		2004-07-29 00:00:00		2004-10-21 00:00:00		2004-04-29 00:00:00		2005-01-03 00:00:00		2004-10-29 00:00:00		2004-10-29 00:00:00		2005-01-28 00:00:00		2005-01-28 00:00:00		2005-01-04 00:00:00		2005-04-29 00:00:00		2005-07-29 00:00:00		2005-10-27 00:00:00		2005-05-06 00:00:00		2005-05-06 00:00:00		2006-04-27 00:00:00		2006-01-31 00:00:00		2006-07-25 00:00:00		2006-10-11 00:00:00		2006-06-23 00:00:00		2007-01-04 00:00:00		2007-04-03 00:00:00		2007-04-26 00:00:00		2007-01-16 00:00:00		2007-01-04 00:00:00		2007-01-29 00:00:00		2007-07-25 00:00:00		2007-01-17 00:00:00		2007-10-05 00:00:00		2007-10-23 00:00:00		2007-10-23 00:00:00		2007-10-24 00:00:00		2013-07-31 00:00:00		2015-07-30 00:00:00		2011-04-25 00:00:00		2015-04-30 00:00:00		2014-07-30 00:00:00		2014-07-30 00:00:00		2013-11-12 00:00:00		2013-11-12 00:00:00		2013-11-12 00:00:00		2013-10-25 00:00:00		2012-07-20 00:00:00		2012-07-20 00:00:00		2012-07-20 00:00:00		2012-07-20 00:00:00		2012-07-20 00:00:00		2012-07-20 00:00:00		2015-02-02 00:00:00		2014-12-30 00:00:00		2007-09-19 00:00:00		2008-04-30 00:00:00		2008-01-31 00:00:00		2008-07-29 00:00:00		2008-10-31 00:00:00		2008-12-30 00:00:00		2009-01-30 00:00:00		2009-04-30 00:00:00		2009-04-29 00:00:00		2009-07-29 00:00:00		2009-07-29 00:00:00		2008-12-31 00:00:00		2009-09-21 00:00:00		2009-10-26 00:00:00		2009-11-09 00:00:00		2009-10-28 00:00:00		2010-01-29 00:00:00		2010-04-27 00:00:00		2010-07-27 00:00:00		2010-10-25 00:00:00		2010-12-23 00:00:00		2010-12-23 00:00:00		2011-01-28 00:00:00		2011-08-11 00:00:00		2011-08-01 00:00:00		2011-04-27 00:00:00		2011-07-28 00:00:00		2011-10-28 00:00:00		2011-08-10 00:00:00		2011-12-29 00:00:00		2012-01-27 00:00:00		2012-03-07 00:00:00		2012-04-04 00:00:00		2012-04-30 00:00:00		2012-07-19 00:00:00		2012-07-19 00:00:00		2012-07-19 00:00:00		2012-07-19 00:00:00		2012-05-03 00:00:00		2012-07-30 00:00:00		2014-03-14 00:00:00		2014-01-31 00:00:00		2012-07-19 00:00:00		2012-07-19 00:00:00		2012-07-19 00:00:00		2012-07-19 00:00:00		2012-07-19 00:00:00		2012-07-19 00:00:00		2012-07-19 00:00:00		2012-07-20 00:00:00		2014-10-28 00:00:00		2014-12-29 00:00:00		2014-07-31 00:00:00		2014-09-03 00:00:00		2012-12-28 00:00:00		2012-12-28 00:00:00		2012-10-31 00:00:00		2013-01-29 00:00:00		2014-04-30 00:00:00		2013-04-29 00:00:00		2015-10-30 00:00:00		2018-01-30 00:00:00		2018-04-30 00:00:00		2017-10-31 00:00:00		2018-10-31 00:00:00		2016-01-29 00:00:00		2016-04-29 00:00:00		2016-07-26 00:00:00		2016-07-28 00:00:00		2016-07-28 00:00:00		2016-10-28 00:00:00		2016-12-29 00:00:00		2017-01-31 00:00:00		2017-02-28 00:00:00		2017-04-28 00:00:00		2017-02-13 00:00:00		2017-02-13 00:00:00		2016-12-29 00:00:00		2017-07-31 00:00:00		2017-02-27 00:00:00		2018-01-29 00:00:00		2018-07-31 00:00:00		2018-01-29 00:00:00		2019-01-31 00:00:00
stmnt_type		10005		10001		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10001		10005		10005		10005		10001		10001		10001		10005		10005		10001		10005		10001		10001		10001		10005		10005		10001		10001		10001		10001		10005		10001		10005		10001		10002		10005		10001		10001		10005		10005		10005		10005		10001		10001		10001		10005		10001		10001		10002		10002		10002		10002		10001		10006		10006		10006		10006		10006		10006		10001		10005		10005		10001		10001		10001		10001		10001		10001		10005		10001		10002		10001		10005		10006		10006		10006		10001		10001		10001		10001		10001		10001		10005		10001		10006		10002		10001		10001		10001		10002		10005		10001		10006		10006		10001		10002		10002		10002		10002		10006		10001		10006		10001		10002		10002		10002		10002		10002		10002		10002		10006		10001		10001		10006		10006		10001		10005		10001		10001		10001		10001		10001		10006		10001		10001		10001		10001		10001		10002		10001		10005		10001		10005		10001		10005		10001		10005		10001		10001		10001		10002		10002		10001		10001		10001
stmnt_status		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11003		11003		11001		11001		11003		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001
session_id		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2003		2003		2003		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2007		2007		2007		2007		2005		2007		2007		2007		2007		2007		2007		2013		2015		2011		2015		2013		2013		2013		2013		2013		2013		2011		2011		2011		2011		2011		2011		2013		2015		2007		2007		2007		2007		2007		2009		2007		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2009		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2013		2013		2011		2011		2011		2011		2011		2011		2011		2011		2013		2015		2013		2013		2013		2013		2011		2011		2013		2013		2015		2017		2017		2017		2017		2015		2015		2015		2015		2015		2015		2017		2015		2017		2017		2017		2017		2017		2017		2017		2017		2017		2017		2017
user_id		SARRIAGA		COMPLETED		SARRIAGA		SARRIAGA		SARRIAGA		GPEREZ		SARRIAGA		CFLAGG		GPEREZ		LTHIBAUL		GPEREZ		GPEREZ		COMPLETED		LTHIBAUL		LTHIBAUL		SARRIAGA		COMPLETED		COMPLETED		COMPLETED		*		YRODRIGU		COMPLETED		PBANFORD		YRODRIGU		YRODRIGU		YRODRIGU		CFLAGG		CFLAGG		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		SARRIAGA		*		GPEREZ		YRODRIGU		*		PBANFORD		YRODRIGU		YRODRIGU		PBANFORD		SARRIAGA		GPEREZ		GPEREZ		YRODRIGU		ASAETERN		AGLADNEY		SDANG		AGLADNEY		ASAETERN		PBANFORD		ASAETERN		ASAETERN		ASAETERN		ASAETERN		CHENG		CHENG		CHENG		CHENG		CHENG		CHENG		AGLADNEY		GKURIMOT		GPEREZ		YRODRIGU		LTHIBAUL		LTHIBAUL		MGUERRA		*		MGUERRA		MGUERRA		MGUERRA		MGUERRA		MGUERRA		PBANFORD		YRODRIGU		YRODRIGU		YRODRIGU		MGUERRA		MGUERRA		MGUERRA		ASAETERN		ASAETERN		YRODRIGU		GKURIMOT		ASAETERN		YRODRIGU		ASAETERN		ASAETERN		ASAETERN		ASAETERN		YRODRIGU		SARRIAGA		ASAETERN		YRODRIGU		CFLAGG		ASAETERN		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		CFLAGG		AGLADNEY		PBANFORD		ASAETERN		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CHENG		ASAETERN		YRODRIGU		PBANFORD		PBANFORD		PBANFORD		PBANFORD		ASAETERN		ASAETERN		ASAETERN		ASAETERN		AGLADNEY		YRODRIGU		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		GPEREZ		AGLADNEY		GPEREZ		AGLADNEY		PBANFORD		AGLADNEY		GPEREZ		AGLADNEY		SARRIAGA		GPEREZ		PBANFORD		AGLADNEY		GPEREZ		YRODRIGU		AGLADNEY		AGLADNEY		AGLADNEY
special_audit		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
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		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11003		11001		11003		11003		11001		11001		11003		11003		11001		11001		11001
rpt_start		1900-01-01 00:00:00		2003-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2003-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2004-04-01 00:00:00		2004-01-01 00:00:00		2004-04-01 00:00:00		1900-01-01 00:00:00		2004-01-01 00:00:00		2004-12-13 00:00:00		2004-07-01 00:00:00		2004-07-01 00:00:00		2004-10-01 00:00:00		2004-10-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		1900-01-01 00:00:00		2006-01-01 00:00:00		2005-10-01 00:00:00		2006-04-01 00:00:00		2006-07-01 00:00:00		1900-01-01 00:00:00		2006-12-29 00:00:00		1900-01-01 00:00:00		2007-01-01 00:00:00		2007-01-16 00:00:00		1900-01-01 00:00:00		2006-10-01 00:00:00		2007-04-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		2007-07-01 00:00:00		2013-04-01 00:00:00		2015-04-01 00:00:00		1900-01-01 00:00:00		2015-01-01 00:00:00		2014-04-01 00:00:00		2014-07-28 00:00:00		2013-01-01 00:00:00		2013-07-01 00:00:00		2013-04-01 00:00:00		2013-07-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2014-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2008-01-01 00:00:00		2007-10-01 00:00:00		2008-04-01 00:00:00		2008-07-01 00:00:00		2008-12-31 00:00:00		2008-10-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-04-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		2009-07-01 00:00:00		2009-10-01 00:00:00		2010-01-01 00:00:00		2010-04-01 00:00:00		2010-07-01 00:00:00		2010-12-22 00:00:00		1900-01-01 00:00:00		2010-10-01 00:00:00		1900-01-01 00:00:00		2011-04-01 00:00:00		2011-01-01 00:00:00		2011-04-01 00:00:00		2011-07-01 00:00:00		2011-08-10 00:00:00		1900-01-01 00:00:00		2011-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2012-01-01 00:00:00		2011-04-01 00:00:00		2011-07-01 00:00:00		2011-10-01 00:00:00		2012-01-01 00:00:00		1900-01-01 00:00:00		2012-04-01 00:00:00		1900-01-01 00:00:00		2013-10-01 00:00:00		2011-12-29 00:00:00		2012-01-24 00:00:00		2012-03-26 00:00:00		2012-03-07 00:00:00		2012-05-03 00:00:00		2012-06-22 00:00:00		2012-06-29 00:00:00		1900-01-01 00:00:00		2014-07-01 00:00:00		2014-12-19 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2012-12-29 00:00:00		1900-01-01 00:00:00		2012-07-01 00:00:00		2012-10-01 00:00:00		2014-01-01 00:00:00		2013-01-01 00:00:00		2015-07-01 00:00:00		1900-01-01 00:00:00		2018-01-01 00:00:00		2017-07-01 00:00:00		2018-07-01 00:00:00		2015-10-01 00:00:00		2016-01-01 00:00:00		2016-07-20 00:00:00		2016-04-01 00:00:00		1900-01-01 00:00:00		2016-07-01 00:00:00		1900-01-01 00:00:00		2016-10-01 00:00:00		1900-01-01 00:00:00		2017-01-01 00:00:00		1900-01-01 00:00:00		2017-02-10 00:00:00		2016-12-20 00:00:00		2017-04-01 00:00:00		2017-02-27 00:00:00		2018-01-29 00:00:00		2018-04-01 00:00:00		2017-10-01 00:00:00		2018-10-01 00:00:00
rpt_end		1900-01-01 00:00:00		2003-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		1900-01-01 00:00:00		2003-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2004-06-30 00:00:00		2004-03-31 00:00:00		2004-06-30 00:00:00		1900-01-01 00:00:00		2004-03-31 00:00:00		2004-12-13 00:00:00		2004-09-30 00:00:00		2004-09-30 00:00:00		2004-12-31 00:00:00		2004-12-31 00:00:00		1900-01-01 00:00:00		2005-03-31 00:00:00		2005-06-30 00:00:00		2005-09-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2006-03-31 00:00:00		2005-12-31 00:00:00		2006-06-30 00:00:00		2006-09-30 00:00:00		1900-01-01 00:00:00		2006-12-29 00:00:00		1900-01-01 00:00:00		2007-03-31 00:00:00		2007-01-16 00:00:00		1900-01-01 00:00:00		2006-12-31 00:00:00		2007-06-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2007-09-30 00:00:00		2013-06-30 00:00:00		2015-06-30 00:00:00		1900-01-01 00:00:00		2015-03-31 00:00:00		2014-06-30 00:00:00		2014-07-28 00:00:00		2013-03-31 00:00:00		2013-09-30 00:00:00		2013-06-30 00:00:00		2013-09-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2014-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2008-03-31 00:00:00		2007-12-31 00:00:00		2008-06-30 00:00:00		2008-09-30 00:00:00		2008-12-31 00:00:00		2008-12-31 00:00:00		2008-12-31 00:00:00		2009-03-31 00:00:00		2009-03-31 00:00:00		2009-06-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2009-09-30 00:00:00		2009-12-31 00:00:00		2010-03-31 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		2010-12-22 00:00:00		1900-01-01 00:00:00		2010-12-31 00:00:00		1900-01-01 00:00:00		2011-06-30 00:00:00		2011-03-31 00:00:00		2011-06-30 00:00:00		2011-09-30 00:00:00		2011-08-10 00:00:00		1900-01-01 00:00:00		2011-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2012-03-31 00:00:00		2011-06-30 00:00:00		2011-09-30 00:00:00		2011-12-31 00:00:00		2012-03-31 00:00:00		1900-01-01 00:00:00		2012-06-30 00:00:00		1900-01-01 00:00:00		2013-12-31 00:00:00		2011-12-29 00:00:00		2012-01-24 00:00:00		2012-03-26 00:00:00		2012-03-07 00:00:00		2012-05-03 00:00:00		2012-06-22 00:00:00		2012-06-29 00:00:00		1900-01-01 00:00:00		2014-09-30 00:00:00		2014-12-19 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2012-12-29 00:00:00		1900-01-01 00:00:00		2012-09-30 00:00:00		2012-12-31 00:00:00		2014-03-31 00:00:00		2013-03-31 00:00:00		2015-09-30 00:00:00		1900-01-01 00:00:00		2018-03-31 00:00:00		2017-09-30 00:00:00		2018-09-30 00:00:00		2015-12-31 00:00:00		2016-03-31 00:00:00		2016-07-20 00:00:00		2016-06-30 00:00:00		1900-01-01 00:00:00		2016-09-30 00:00:00		1900-01-01 00:00:00		2016-12-31 00:00:00		1900-01-01 00:00:00		2017-03-31 00:00:00		1900-01-01 00:00:00		2017-02-10 00:00:00		2016-12-20 00:00:00		2017-06-30 00:00:00		2017-02-27 00:00:00		2018-01-29 00:00:00		2018-06-30 00:00:00		2017-12-31 00:00:00		2018-12-31 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filing_type		None		22001		None		None		None		None		None		None		None		None		None		None		22001		None		None		None		22001		22001		22001		None		None		22001		None		22001		22001		22001		None		None		22001		22001		22001		22001		None		22001		None		22001		22001		None		22001		22001		None		None		None		None		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		None		None		None		None		None		None		22001		None		None		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		None		None		None		None		22001		22001		22001		22001		22001		22001		None		22001		None		22001		22001		22001		22001		22001		None		22001		None		None		22001		22001		22001		22001		22001		None		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		None		None		22001		None		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		None		22001		None		22001		None		22001		None		22001		22001		22001		22001		22001		22001		22001		22001

Table: filer_to_filer_type

filer_id		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704
filer_type		3		3		3		3		3		3		3		3		3
active		Y		Y		Y		Y		Y		Y		Y		Y		N
race		0		0		0		None		None		None		None		None		None
session_id		2003		2005		2007		2013		2011		2009		2015		2017		2019
category		0		0		0		None		None		None		None		None		None
category_type		0		0		0		None		None		None		None		None		None
sub_category		0		0		0		None		None		None		None		None		None
effect_dt		2003-12-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2013-01-01 00:00:00		2011-01-01 00:00:00		2009-01-01 00:00:00		2015-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00
sub_category_type		0		0		0		None		None		None		None		None		None
election_type		0		0		0		None		None		None		None		None		None
sub_category_a		None		None		None		None		None		None		None		None		None
nyq_dt		None		2003-10-01 00:00:00		2003-10-01 00:00:00		None		None		None		None		None		None
party_cd		0		0		0		None		None		None		None		None		None
county_cd		0		0		0		None		None		None		None		None		None
district_cd		0		0		0		None		None		None		None		None		None

Table: filer_xref

filer_id		1260704
xref_id		1260704
effect_dt		2003-12-04 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704
filer_id		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704
filer_type		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM
status		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE
effect_dt		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		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		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		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		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		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		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		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		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		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
naml		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.
namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr1		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr2		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
city		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO
st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		95831		95814		95814		95814		95814		95814		95814		95814		95814		95814		95831		95814		95814		95814		95814		95814		95814		95814		95814		95814		95831		95814		95814		95814		95814		95814		95814		95814		95814		95814		95831		95814		95814		95814		95814		95814		95814		95814		95814		95814		95831		95814		95814		95814		95814		95814		95814		95814		95814		95814		95831		95814		95814		95814		95814		95814		95814		95814		95814		95814		95831		95814		95814		95814		95814		95814		95814		95814		95814		95814		95831		95814		95814		95814		95814		95814		95814		95814		95814		95814		95831		95814		95814		95814		95814		95814		95814		95814		95814		95814
phon		9162965450		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9162965450		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9162965450		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9162965450		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9162965450		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9162965450		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9162965450		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9162965450		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9162965450		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010		9163251010
fax		None		None		9163251015		9163251015		9163251015		9163251015		9163251015		9163251015		9163251015		9163251015		None		None		9163251015		9163251015		9163251015		9163251015		9163251015		9163251015		9163251015		9163251015		None		None		9163251015		9163251015		9163251015		9163251015		9163251015		9163251015		9163251015		9163251015		None		None		9163251015		9163251015		9163251015		9163251015		9163251015		9163251015		9163251015		9163251015		None		None		9163251015		9163251015		9163251015		9163251015		9163251015		9163251015		9163251015		9163251015		None		None		9163251015		9163251015		9163251015		9163251015		9163251015		9163251015		9163251015		9163251015		None		None		9163251015		9163251015		9163251015		9163251015		9163251015		9163251015		9163251015		9163251015		None		None		9163251015		9163251015		9163251015		9163251015		9163251015		9163251015		9163251015		9163251015		None		None		9163251015		9163251015		9163251015		9163251015		9163251015		9163251015		9163251015		9163251015
email		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]

Table: filers

filer_id		1260704

Table: lobbying_chg_log

filer_id		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704
change_no		14		15		0		10		9		12		4		5		6		7		8		11		1		2		3		13		16		20		19		18		17		21		23		22		24		28		27		26		25		30		29
session_id		2005		2005		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2007		2007		2007		2007		2007		2009		2009		2009		2011		2011		2011		2011		2011		2013		2013
log_dt		2005-05-06 00:00:00		2005-05-06 00:00:00		2003-11-26 00:00:00		2003-11-26 00:00:00		2003-11-26 00:00:00		2003-11-26 00:00:00		2003-11-26 00:00:00		2003-11-26 00:00:00		2003-11-26 00:00:00		2003-11-26 00:00:00		2003-11-26 00:00:00		2003-11-26 00:00:00		2003-11-26 00:00:00		2003-11-26 00:00:00		2003-11-26 00:00:00		2004-01-08 00:00:00		2007-10-05 00:00:00		2007-09-19 00:00:00		2007-04-03 00:00:00		2007-10-23 00:00:00		2007-10-23 00:00:00		2009-09-21 00:00:00		2009-11-09 00:00:00		2009-10-26 00:00:00		2011-08-11 00:00:00		2012-05-03 00:00:00		2012-05-01 00:00:00		2012-04-04 00:00:00		2011-12-29 00:00:00		2014-09-03 00:00:00		2014-03-14 00:00:00
filer_type		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3
correction_flg		None		None		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		None		None		Y		Y		None		Y
action		DELETED		DELETED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		NEW		ADDED		ADDED		ADDED		DELETED		ADDED		ADDED		DELETED		DELETED		ADDED		DELETED		DELETED		ADDED		DELETED		DELETED		DELETED		DELETED		DELETED		ADDED
attribute_changed		CLIENT		CLIENT		None		None		None		None		None		None		None		None		None		None		None		None		None		None		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		CLIENT		FIRM		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER
ethics_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
interests		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_full_name		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY, INC.		THOMAS ADVOCACY INC.		THOMAS ADVOCACY INC.
filer_city		None		None		None		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		None		SACRAMENTO		SACRAMENTO		None		None		None		None		None		None		None		None		None		SACRAMENTO		None		SACRAMENTO
filer_st		None		None		None		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		None		CA		CA		None		None		None		None		None		None		None		None		None		CA		None		CA
filer_zip		None		None		None		95831		95831		95831		95831		95831		95831		95831		95831		95831		95831		95831		95831		95831		None		95831		95831		None		None		None		None		None		None		None		None		None		95814		None		95814
filer_phone		None		None		None		9162965450		9162965450		9162965450		9162965450		9162965450		9162965450		9162965450		9162965450		9162965450		9162965450		9162965450		9162965450		9162965450		None		9162965450		9162965450		None		None		None		None		None		None		None		None		None		9163251010		None		9163251010
entity_type		1		1		4		2		2		2		2		2		2		2		2		2		3		2		2		2		2		2		2		2		2		2		2		2		2		1		3		2		2		2		2
entity_name		GOLDEN STATE DONOR SERVICES		CALIFORNIA TRANSPLANT DONOR NETWORK		THOMAS, TERRI V.		SONY PICTURES ENTERTAINMENT, INC.		SONY MUSIC ENTERTAINMENT, INC.		WALT DISNEY COMPANY AND ITS AFFILIATED ENTITIES, THE		CALIFORNIA COUNCIL/AMERICAN SOCIETY OF LANDSCAPE ARCHITECTS		EBAY, INC.		MOTION PICTURE ASSOCIATION OF AMERICA, INC.		PACIFICARE HEALTH SYSTEMS AND AFFILIATED ENTITIES		SEALY, INC.		MEDSTAT GROUP, INC.		THOMAS ADVOCACY INC.		CALIFORNIA ASSOCIATION OF PUBLIC HOSPITALS AND HEALTH SYSTEMS		CALIFORNIA HEALTHCARE ASSOCIATION, ET. AL.		NATIONAL ASSOCIATION OF THEATRE OWNERS OF CALIFORNIA/NEVADA		THOMSON MEDSTAT		GILCHRIST & RUTTER PROFESSIONAL CORPORATION		CAPSTONE TURBINE CORPORATION		GILCHRIST & RUTTER PROFESSIONAL CORPORATION		ENERGY SYSTEMS DIVISION OF INGERSOLL-RAND COMPANY; THE		HART, KING & COLDREN		AMERICAN LASER CENTERS		HART, KING & COLDREN		UNISYS CORPORATION		UNITED HEALTHCARE SERVICES, INC.		CARTER, WETCH & ASSOCIATES		UNISYS CORPORATION		EBAY, INC.		EXPRESS SCRIPTS HOLDING COMPANY		EXPRESS SCRIPTS HOLDING COMPANY
entity_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
entity_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
entity_zip		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
entity_phone		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
entity_id		1232043		1145867		1148075		None		None		None		None		None		None		None		None		None		None		None		None		None		1146593		None		None		1301259		1295284		1321576		1287328		1321576		1143290		1143238		1252406		1143290		None		1231977		None
responsible_officer		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
effect_dt		2005-05-01 00:00:00		2005-05-01 00:00:00		2003-12-01 00:00:00		2003-12-01 00:00:00		2003-12-01 00:00:00		2003-12-01 00:00:00		2003-12-01 00:00:00		2003-12-01 00:00:00		2003-12-01 00:00:00		2003-12-01 00:00:00		2003-12-01 00:00:00		2003-12-01 00:00:00		2003-12-01 00:00:00		2003-12-01 00:00:00		2003-12-01 00:00:00		2004-01-08 00:00:00		2007-09-28 00:00:00		2007-09-17 00:00:00		2007-04-02 00:00:00		2007-10-14 00:00:00		2007-10-23 00:00:00		2009-09-17 00:00:00		2009-10-31 00:00:00		2009-10-23 00:00:00		2011-07-26 00:00:00		2012-04-30 00:00:00		2012-04-15 00:00:00		2012-03-26 00:00:00		2011-12-30 00:00:00		2014-09-01 00:00:00		2014-03-03 00:00:00

Table: received_filings

filer_id		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704		1260704
filing_file_name		987509_0.cal		1069399_0.cal		287083.cal		121237.cal		1386605_0.cal		291445.cal		291476.cal		291647.cal		1226513_1.cal		1226513_0.cal		329907.cal		1553613_2.cal		1553613_3.cal		207500.cal		1553613_4.cal		1553613_5.cal		1553613_6.cal		1553613_7.cal		207693.cal		1553613_8.cal		284562.cal		284600.cal		284668.cal		1553613_0.cal		1553613_1.cal		1721512_0.cal		251370.cal		1721512_1.cal		156699.cal		156766.cal		156820.cal		157426.cal		497975.cal		192074.cal		1921257_1.cal		2115342_1.cal		2115342_0.cal		1921257_0.cal		2115342_2.cal		503769.cal
received_date		2004-01-28 00:00:00		2005-01-03 00:00:00		2005-01-03 00:00:00		2006-04-27 00:00:00		2008-12-30 00:00:00		2008-12-30 00:00:00		2008-12-30 00:00:00		2008-12-30 00:00:00		2007-01-16 00:00:00		2007-01-04 00:00:00		2009-07-29 00:00:00		2012-07-19 00:00:00		2012-07-19 00:00:00		2012-07-19 00:00:00		2012-07-19 00:00:00		2012-07-19 00:00:00		2012-07-19 00:00:00		2012-07-19 00:00:00		2012-07-19 00:00:00		2012-07-19 00:00:00		2013-11-12 00:00:00		2013-11-12 00:00:00		2013-11-12 00:00:00		2010-12-23 00:00:00		2011-08-10 00:00:00		2012-12-28 00:00:00		2014-07-30 00:00:00		2014-07-30 00:00:00		2015-07-30 00:00:00		2015-07-30 00:00:00		2015-07-30 00:00:00		2015-07-30 00:00:00		2017-02-13 00:00:00		2016-07-26 00:00:00		2016-07-26 00:00:00		2017-02-27 00:00:00		2016-12-29 00:00:00		2014-12-29 00:00:00		2018-01-29 00:00:00		2018-01-29 00:00:00
filing_directory		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/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/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp
filing_id		987509		1069399		None		None		1386605		None		None		None		1226513		1226513		None		1553613		1553613		None		1553613		1553613		1553613		1553613		None		1553613		None		None		None		1553613		1553613		1721512		None		1721512		None		None		None		None		None		None		1921257		2115342		2115342		1921257		2115342		None
form_id		F625		F601		None		None		F601		None		None		None		F601		F601		None		F601		F601		None		F601		F601		F601		F601		None		F601		None		None		None		F601		F601		F601		None		F601		None		None		None		None		None		None		F601		F601		F601		F601		F601		None
receive_comment		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints