Home

Filer ID: 1264491

Table: cvr_lobby_disclosure

filing_id		1025074		1047247		1077770		1101892		1128356		1182865		1167068		1114412		1143182		1229475		1279856		1261152		1211908		1366028		1295673		1325319		1346480		1304716		1419771		1387807		1449445		1431774		1527841		1500605		1483188		1461358		1570022		1621727		1588654		1606673		1629363		1708559		1673573		1652098		1723722		1760802		1797535		1776560		1838357		1810392		1900252		1864881		1922772		1990942		1975157		1956748		2003794		2087239		2053285		2027225		2169899		2155793		2119193		2185974
amend_id		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		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
form_type		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615
sender_id		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491
filer_id		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491
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
filer_naml		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH
filer_namf		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.
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
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
report_num		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000
rpt_date		2004-07-22 00:00:00		2004-10-13 00:00:00		2005-01-28 00:00:00		2005-04-21 00:00:00		2005-10-18 00:00:00		2006-07-06 00:00:00		2006-04-29 00:00:00		2005-07-26 00:00:00		2006-01-23 00:00:00		2007-01-20 00:00:00		2007-07-24 00:00:00		2007-04-29 00:00:00		2006-10-26 00:00:00		2008-10-14 00:00:00		2007-10-29 00:00:00		2008-04-17 00:00:00		2008-07-27 00:00:00		2008-01-20 00:00:00		2009-04-29 00:00:00		2009-01-07 00:00:00		2009-10-23 00:00:00		2009-07-20 00:00:00		2010-10-17 00:00:00		2010-07-14 00:00:00		2010-04-27 00:00:00		2010-01-27 00:00:00		2011-01-30 00:00:00		2011-10-30 00:00:00		2011-04-27 00:00:00		2011-07-29 00:00:00		2012-01-18 00:00:00		2012-10-31 00:00:00		2012-07-23 00:00:00		2012-04-14 00:00:00		2013-01-09 00:00:00		2013-04-23 00:00:00		2013-10-26 00:00:00		2013-07-18 00:00:00		2014-04-14 00:00:00		2014-01-16 00:00:00		2014-10-18 00:00:00		2014-07-22 00:00:00		2015-01-04 00:00:00		2015-10-07 00:00:00		2015-07-19 00:00:00		2015-04-08 00:00:00		2016-01-13 00:00:00		2016-10-10 00:00:00		2016-07-04 00:00:00		2016-04-11 00:00:00		2017-07-23 00:00:00		2017-04-28 00:00:00		2017-01-12 00:00:00		2017-10-02 00:00:00
from_date		2004-04-01 00:00:00		2004-07-01 00:00:00		2004-10-01 00:00:00		2005-01-01 00:00:00		2005-07-01 00:00:00		2006-04-01 00:00:00		2006-01-01 00:00:00		2005-04-01 00:00:00		2005-10-01 00:00:00		2006-10-01 00:00:00		2007-04-01 00:00:00		2007-01-01 00:00:00		2006-07-01 00:00:00		2008-07-01 00:00:00		2007-07-01 00:00:00		2008-01-01 00:00:00		2008-04-01 00:00:00		2007-10-01 00:00:00		2009-01-01 00:00:00		2008-10-01 00:00:00		2009-07-01 00:00:00		2009-04-01 00:00:00		2010-07-01 00:00:00		2010-04-01 00:00:00		2010-01-01 00:00:00		2009-10-01 00:00:00		2010-10-01 00:00:00		2011-07-01 00:00:00		2011-01-01 00:00:00		2011-04-01 00:00:00		2011-10-01 00:00:00		2012-07-01 00:00:00		2012-04-01 00:00:00		2012-01-01 00:00:00		2012-10-01 00:00:00		2013-01-01 00:00:00		2013-07-01 00:00:00		2013-04-01 00:00:00		2014-01-01 00:00:00		2013-10-01 00:00:00		2014-07-01 00:00:00		2014-04-01 00:00:00		2014-10-01 00:00:00		2015-07-01 00:00:00		2015-04-01 00:00:00		2015-01-01 00:00:00		2015-10-01 00:00:00		2016-07-01 00:00:00		2016-04-01 00:00:00		2016-01-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
thru_date		2004-06-30 00:00:00		2004-09-30 00:00:00		2004-12-31 00:00:00		2005-03-31 00:00:00		2005-09-30 00:00:00		2006-06-30 00:00:00		2006-03-31 00:00:00		2005-06-30 00:00:00		2005-12-31 00:00:00		2006-12-31 00:00:00		2007-06-30 00:00:00		2007-03-31 00:00:00		2006-09-30 00:00:00		2008-09-30 00:00:00		2007-09-30 00:00:00		2008-03-31 00:00:00		2008-06-30 00:00:00		2007-12-31 00:00:00		2009-03-31 00:00:00		2008-12-31 00:00:00		2009-09-30 00:00:00		2009-06-30 00:00:00		2010-09-30 00:00:00		2010-06-30 00:00:00		2010-03-31 00:00:00		2009-12-31 00:00:00		2010-12-31 00:00:00		2011-09-30 00:00:00		2011-03-31 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2012-09-30 00:00:00		2012-06-30 00:00:00		2012-03-31 00:00:00		2012-12-31 00:00:00		2013-03-31 00:00:00		2013-09-30 00:00:00		2013-06-30 00:00:00		2014-03-31 00:00:00		2013-12-31 00:00:00		2014-09-30 00:00:00		2014-06-30 00:00:00		2014-12-31 00:00:00		2015-09-30 00:00:00		2015-06-30 00:00:00		2015-03-31 00:00:00		2015-12-31 00:00:00		2016-09-30 00:00:00		2016-06-30 00:00:00		2016-03-31 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
cum_beg_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
firm_id		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491
firm_name		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		J.R. Ulrich & Associates		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		01/01/2005		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R..		ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J. R.		Ulrich & Associates, J.R..		Ulrich & Associates, J. R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.
firm_city		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM
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
firm_zip4		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417		956307417
firm_phon		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692
mail_city		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM
mail_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
mail_zip4		957632260		957632260		956307417		956302260		956302260		956302260		956302260		956302260		956302260		956307417		957632260		957632260		956302260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260		957632260
mail_phon		None		None		None		None		None		None		None		None		None		9169899692		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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-07-22 00:00:00		2004-10-13 00:00:00		2005-01-28 00:00:00		2005-04-21 00:00:00		2005-10-18 00:00:00		2006-07-06 00:00:00		2006-04-29 00:00:00		2005-06-26 00:00:00		2006-01-23 00:00:00		2007-01-20 00:00:00		2007-07-24 00:00:00		2007-04-29 00:00:00		2006-10-26 00:00:00		2008-10-14 00:00:00		2007-10-29 00:00:00		2008-04-17 00:00:00		2008-07-27 00:00:00		2008-01-20 00:00:00		2009-04-29 00:00:00		2009-01-07 00:00:00		2009-10-23 00:00:00		2009-07-20 00:00:00		2010-10-17 00:00:00		2010-07-14 00:00:00		2010-04-27 00:00:00		2010-01-27 00:00:00		2011-01-30 00:00:00		2011-10-30 00:00:00		2011-04-27 00:00:00		2011-07-28 00:00:00		2012-01-18 00:00:00		2012-10-31 00:00:00		2012-07-23 00:00:00		2012-04-14 00:00:00		2013-01-10 00:00:00		2013-04-23 00:00:00		2013-10-26 00:00:00		2013-07-18 00:00:00		2014-04-14 00:00:00		2014-01-16 00:00:00		2014-10-18 00:00:00		2014-07-22 00:00:00		2015-01-04 00:00:00		2015-10-07 00:00:00		2015-07-19 00:00:00		2015-04-08 00:00:00		2016-01-13 00:00:00		2016-10-10 00:00:00		2016-07-04 00:00:00		2016-04-11 00:00:00		2017-07-23 00:00:00		2017-04-28 00:00:00		2017-01-12 00:00:00		2017-10-01 00:00:00
sig_loc		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom		Folsom, CA		Folsom, CA		Folsom, CA		Folsom		Folsom, CA		Folsom		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA 95630		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, California		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA		Folsom, CA
sig_naml		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich
sig_namf		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R		John R.		John R		John R.		John R.		John R.		John R.		John R		John R.		John R.		John R.		John R.		John R.		John R		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.
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
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
prn_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		Ulrich		None		None		None		None		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich		Ulrich
prn_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		John R.		None		None		None		None		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R		John R.		John R		John R.		John R.		John R.		John R.		John R		John R.		John R.		John R.		John R.		John R.		John R		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.		John R.
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
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
sig_title		None		None		None		None		None		None		None		None		None		None		None		None		None		Sr. Consultant/ Owner		None		None		None		None		Sr. Consultant/ Owner		Owner/ Sr. Consultant		Sr. Consultant, Owner		Owner/ Sr. Consultant		Sr. Consultant/ Owner		Owner/ Sr. Consultant		Owner/ Sr. Consultant		Sr. Consultant/ Owner		Owner, Sr. Consultant		Owner/ Sr. Consultant		Owner/ Sr. Consultant		Owner/ Sr. Consultant		Owner/ Sr. Consultant		Sr. Consultant / Owner		Sr Consultant/ Owner		Sr. Consultant/ Owner		Owner/ Sr. Consultant		Owner / Sr. Consultant		Owner/ Sr. Consultant		Owner / Sr. Consultant		Owner / Sr. Consultant		Owner/ Sr. Consultant		Owner/ Sr. Consultant		Owner / Sr. Consultant		Owner/ Sr. Consultant		Owner / Sr. Consultant		Owner / Sr. Consultant		Owner/ Sr. Consultant		Owner/ Sr. Consultant		Owner/ Sr. Consultant		Owner/ Sr. Consultant		Owner/ Sr. Consultant		Owner/ Sr. Consultant		Owner/ Sr. Consultant		Owner/ Sr. Consultant		Owner/ Sr. Consultant
nopart1_cb		X		None		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		None		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X
nopart2_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
part1_1_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
part1_2_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
ctrib_n_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
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
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
lobby_n_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
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
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
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
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
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
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
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

Table: cvr_registration

filing_id		1222090		1384181		1546482		1717574		1916857		2110349		2185979
amend_id		0		0		0		0		0		0		0
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F604		F604		F604		F604		F604		F604		F606
sender_id		1264487		1264487		1264487		1264487		1264487		1264487		1264487
filer_id		1264491		1264491		1264491		1264491		1264491		1264491		1264491
entity_cd		LBY		LBY		LBY		LBY		LBY		LBY		LBY
filer_naml		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH
filer_namf		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.
filer_namt		None		None		None		None		None		None		None
filer_nams		None		None		None		None		None		None		None
report_num		000		000		000		000		000		000		000
rpt_date		2006-11-17 00:00:00		2008-12-17 00:00:00		2010-11-27 00:00:00		2012-12-17 00:00:00		2014-12-03 00:00:00		2016-12-12 00:00:00		2017-10-02 00:00:00
ls_beg_yr		2007		2009		2011		2013		2015		2017		2017
ls_end_yr		2008		2010		2012		2014		2016		2018		2018
qual_date		None		None		None		None		None		None		None
eff_date		None		None		None		None		None		None		2017-10-01 00:00:00
bus_city		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM
bus_st		CA		CA		CA		CA		CA		CA		CA
bus_zip4		956307417		956307417		956307417		956307417		956307417		956307417		956307417
bus_phon		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692		9169899692
bus_fax		None		None		None		None		None		None		None
bus_email		None		None		None		None		None		None		None
mail_city		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		None
mail_st		CA		CA		CA		CA		CA		CA		None
mail_zip4		957632260		957632260		957632260		957632260		957632260		957632260		None
mail_phon		None		None		None		None		None		None		None
sig_date		2006-11-17 00:00:00		2008-12-17 00:00:00		2010-11-27 00:00:00		2012-12-17 00:00:00		2014-12-03 00:00:00		2016-12-12 00:00:00		2017-10-01 00:00:00
sig_loc		None		None		None		None		None		None		None
sig_naml		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		Ulrich
sig_namf		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		John R.
sig_namt		None		None		None		None		None		None		None
sig_nams		None		None		None		None		None		None		None
prn_naml		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		Ulrich
prn_namf		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		John R.
prn_namt		None		None		None		None		None		None		None
prn_nams		None		None		None		None		None		None		None
sig_title		None		None		None		None		None		None		Owner / Sr. Consultant
stmt_firm		None		None		None		None		None		None		None
ind_cb		None		None		None		None		None		None		None
bus_cb		None		None		None		None		None		None		None
trade_cb		None		None		None		None		None		None		None
oth_cb		None		None		None		None		None		None		None
a_b_name		None		None		None		None		None		None		None
a_b_city		None		None		None		None		None		None		None
a_b_st		None		None		None		None		None		None		None
a_b_zip4		None		None		None		None		None		None		None
descrip_1		None		None		None		None		None		None		None
descrip_2		None		None		None		None		None		None		None
c_less50		None		None		None		None		None		None		None
c_more50		None		None		None		None		None		None		None
ind_class		None		None		None		None		None		None		None
ind_descr		None		None		None		None		None		None		None
bus_class		None		None		None		None		None		None		None
bus_descr		None		None		None		None		None		None		None
auth_name		None		None		None		None		None		None		None
auth_city		None		None		None		None		None		None		None
auth_st		None		None		None		None		None		None		None
auth_zip4		None		None		None		None		None		None		None
lobby_int		None		None		None		None		None		None		None
influen_yn		None		None		None		None		None		None		None
firm_name		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.		Ulrich & Associates, J.R.
newcert_cb		None		None		None		None		None		None		None
rencert_cb		None		None		None		X		None		X		None
complet_dt		2006-11-16 00:00:00		2008-11-12 00:00:00		2010-11-17 00:00:00		None		2014-11-13 00:00:00		None		None
lby_reg_cb		X		X		X		X		X		X		None
lby_604_cb		None		None		None		None		None		None		None
st_leg_yn		Y		Y		Y		Y		Y		Y		None
st_agency		None		None		None		None		None		None		None
lobby_cb		None		None		None		None		None		None		None
l_firm_cb		None		None		None		None		None		None		None

Table: filer_address

filer_id		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491
adrid		2065703		2065704		2083163		2083164		2114657		2118160		2161065		2161066		2204496		2204497		2412005		2412006		2277977		2277978		2344544		2344545
effect_dt		2004-04-01 00:00:00		2004-03-12 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		2009-01-01 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2017-01-01 00:00:00		2017-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
add_type		7051		7082		7051		7082		7051		7082		7051		7082		7051		7082		7051		7082		7051		7082		7051		7082
session_id		2003		2003		2005		2005		2007		2007		2009		2009		2011		2011		2017		2017		2013		2013		2015		2015

Table: filer_ethics_class

filer_id		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491
session_id		2005		2003		2009		2007		2011		2013		2015		2017
ethics_date		2004-11-17 00:00:00		2003-06-13 00:00:00		2008-11-12 00:00:00		2006-11-16 00:00:00		2010-11-17 00:00:00		2013-02-28 00:00:00		2014-11-13 00:00:00		2017-02-02 00:00:00

Table: filer_filings

filer_id		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491
filing_id		1008244		1008246		1025074		1028066		1047247		1062471		1076122		1077770		1101892		1085071		1114412		1128356		1167068		1143182		1182865		1222090		1211908		1229475		1242726		1261152		1279856		1304716		1776560		1975157		1864881		1810392		1797535		1940489		1956748		1325319		1295673		1346480		1366028		1384181		1387807		1417007		1419771		1431774		1461358		1449445		1483188		1500605		1527841		1546482		1551167		1570022		1588654		1621727		1629363		1606673		1652098		1673573		1922772		1916857		1900252		1717574		1708559		1723722		1732557		1838357		1752066		1760802		2003794		1990942		2186276		2185974		2185979		2027225		2053285		2087239		2119193		2125958		2110349		2138511		2169899		2155793
period_id		None		None		178		None		179		None		None		180		181		None		182		183		185		184		186		188		187		188		None		189		190		192		214		222		218		216		215		None		221		193		191		194		195		196		196		None		197		198		200		199		201		202		203		204		None		204		205		207		208		206		209		210		220		220		219		212		211		212		None		217		None		213		224		223		None		231		232		225		226		227		228		None		228		None		230		229
form_id		F604		F999		F615		F615		F615		F615		F604		F615		F615		F615		F615		F615		F615		F615		F615		F604		F615		F615		F604		F615		F615		F615		F615		F615		F615		F615		F615		F604		F615		F615		F615		F615		F615		F604		F615		F604		F615		F615		F615		F615		F615		F615		F615		F604		F604		F615		F615		F615		F615		F615		F615		F615		F615		F604		F615		F604		F615		F615		F604		F615		F604		F615		F615		F615		F606		F615		F606		F615		F615		F615		F615		F604		F604		F604		F615		F615
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		2004-04-01 00:00:00		2004-04-01 00:00:00		2004-07-22 00:00:00		2004-07-23 00:00:00		2004-10-13 00:00:00		2004-10-14 00:00:00		2004-12-06 00:00:00		2005-01-28 00:00:00		2005-04-21 00:00:00		2005-01-28 00:00:00		2005-07-26 00:00:00		2005-10-18 00:00:00		2006-04-29 00:00:00		2006-01-23 00:00:00		2006-07-06 00:00:00		2006-11-17 00:00:00		2006-10-26 00:00:00		2007-01-20 00:00:00		2006-12-07 00:00:00		2007-04-29 00:00:00		2007-07-24 00:00:00		2008-01-20 00:00:00		2013-07-18 00:00:00		2015-07-19 00:00:00		2014-07-22 00:00:00		2014-01-16 00:00:00		2013-10-26 00:00:00		2014-12-04 00:00:00		2015-04-08 00:00:00		2008-04-17 00:00:00		2007-10-29 00:00:00		2008-07-27 00:00:00		2008-10-14 00:00:00		2008-12-17 00:00:00		2009-01-07 00:00:00		2008-12-18 00:00:00		2009-04-29 00:00:00		2009-07-20 00:00:00		2010-01-27 00:00:00		2009-10-23 00:00:00		2010-04-27 00:00:00		2010-07-14 00:00:00		2010-10-17 00:00:00		2010-11-27 00:00:00		2010-12-14 00:00:00		2011-01-30 00:00:00		2011-04-27 00:00:00		2011-10-30 00:00:00		2012-01-18 00:00:00		2011-07-29 00:00:00		2012-04-14 00:00:00		2012-07-23 00:00:00		2015-01-04 00:00:00		2014-12-03 00:00:00		2014-10-18 00:00:00		2012-12-17 00:00:00		2012-10-31 00:00:00		2013-01-09 00:00:00		2012-12-18 00:00:00		2014-04-14 00:00:00		2013-02-28 00:00:00		2013-04-23 00:00:00		2016-01-13 00:00:00		2015-10-07 00:00:00		2017-10-02 00:00:00		2017-10-02 00:00:00		2017-10-02 00:00:00		2016-04-11 00:00:00		2016-07-04 00:00:00		2016-10-10 00:00:00		2017-01-12 00:00:00		2016-12-14 00:00:00		2016-12-12 00:00:00		2017-02-02 00:00:00		2017-07-23 00:00:00		2017-04-28 00:00:00
stmnt_type		10005		10005		10001		10005		10001		10005		10005		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10006		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10005		10001		10006		10001		10001
stmnt_status		11001		11001		11003		11003		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001
session_id		2003		2003		2003		2003		2003		2003		2005		2003		2005		2003		2005		2005		2005		2005		2005		2007		2005		2005		2007		2007		2007		2007		2013		2015		2013		2013		2013		2015		2015		2007		2007		2007		2007		2009		2007		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2009		2011		2011		2011		2011		2011		2011		2013		2015		2013		2013		2011		2011		2013		2013		2013		2013		2015		2015		2017		2017		2017		2015		2015		2015		2015		2017		2017		2017		2017		2017
user_id		CFLAGG		CFLAGG		COMPLETED		EMCENTEE		COMPLETED		YRODRIGU		PBANFORD		COMPLETED		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		LTHIBAUL		LTHIBAUL		LTHIBAUL		*		LTHIBAUL		YRODRIGU		CFLAGG		YRODRIGU		YRODRIGU		LTHIBAUL		ASAETERN		JINGRAM		ASAETERN		ASAETERN		ASAETERN		GKURIMOT		JINGRAM		YRODRIGU		LTHIBAUL		LTHIBAUL		JINGRAM		YRODRIGU		JINGRAM		PBANFORD		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		MGUERRA		ASAETERN		*		GKURIMOT		ASAETERN		JINGRAM		ASAETERN		ASAETERN		ASAETERN		ASAETERN		AGLADNEY		AGLADNEY		CAFILER		ASAETERN		PBANFORD		ASAETERN		ASAETERN		PBANFORD		ASAETERN		SMCCONNAN		ASAETERN		AGLADNEY		JINGRAM		GPEREZ		CAFILER		GPEREZ		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		PBANFORD		PBANFORD		KBANH		SMCCONNAN		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
fine_audit		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		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001
rpt_start		1900-01-01 00:00:00		1900-01-01 00:00:00		2004-04-01 00:00:00		2004-04-01 00:00:00		2004-07-01 00:00:00		2004-07-01 00:00:00		1900-01-01 00:00:00		2004-10-01 00:00:00		2005-01-01 00:00:00		2004-10-01 00:00:00		2005-04-01 00:00:00		2005-07-01 00:00:00		2006-01-01 00:00:00		2005-10-01 00:00:00		2006-04-01 00:00:00		2006-11-17 00:00:00		2006-07-01 00:00:00		2006-10-01 00:00:00		1900-01-01 00:00:00		2007-01-01 00:00:00		2007-04-01 00:00:00		2007-10-01 00:00:00		2013-04-01 00:00:00		2015-04-01 00:00:00		2014-04-01 00:00:00		2013-10-01 00:00:00		2013-07-01 00:00:00		1900-01-01 00:00:00		2015-01-01 00:00:00		2008-01-01 00:00:00		2007-07-01 00:00:00		2008-04-01 00:00:00		2008-07-01 00:00:00		2008-12-17 00:00:00		2008-10-01 00:00:00		1900-01-01 00:00:00		2009-01-01 00:00:00		2009-04-01 00:00:00		2009-10-01 00:00:00		2009-07-01 00:00:00		2010-01-01 00:00:00		2010-04-01 00:00:00		2010-07-01 00:00:00		2010-11-27 00:00:00		1900-01-01 00:00:00		2010-10-01 00:00:00		2011-01-01 00:00:00		2011-07-01 00:00:00		2011-10-01 00:00:00		2011-04-01 00:00:00		2012-01-01 00:00:00		2012-04-01 00:00:00		2014-10-01 00:00:00		2014-12-03 00:00:00		2014-07-01 00:00:00		2012-12-17 00:00:00		2012-07-01 00:00:00		2012-10-01 00:00:00		1900-01-01 00:00:00		2014-01-01 00:00:00		1900-01-01 00:00:00		2013-01-01 00:00:00		2015-10-01 00:00:00		2015-07-01 00:00:00		1900-01-01 00:00:00		2017-07-01 00:00:00		2017-10-02 00:00:00		2016-01-01 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		2016-10-01 00:00:00		1900-01-01 00:00:00		2016-12-12 00:00:00		None		2017-04-01 00:00:00		2017-01-01 00:00:00
rpt_end		1900-01-01 00:00:00		1900-01-01 00:00:00		2004-06-30 00:00:00		2004-06-30 00:00:00		2004-09-30 00:00:00		2004-09-30 00:00:00		1900-01-01 00:00:00		2004-12-31 00:00:00		2005-03-31 00:00:00		2004-12-31 00:00:00		2005-06-30 00:00:00		2005-09-30 00:00:00		2006-03-31 00:00:00		2005-12-31 00:00:00		2006-06-30 00:00:00		2006-11-17 00:00:00		2006-09-30 00:00:00		2006-12-31 00:00:00		1900-01-01 00:00:00		2007-03-31 00:00:00		2007-06-30 00:00:00		2007-12-31 00:00:00		2013-06-30 00:00:00		2015-06-30 00:00:00		2014-06-30 00:00:00		2013-12-31 00:00:00		2013-09-30 00:00:00		1900-01-01 00:00:00		2015-03-31 00:00:00		2008-03-31 00:00:00		2007-09-30 00:00:00		2008-06-30 00:00:00		2008-09-30 00:00:00		2008-12-17 00:00:00		2008-12-31 00:00:00		1900-01-01 00:00:00		2009-03-31 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2009-09-30 00:00:00		2010-03-31 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		2010-11-27 00:00:00		1900-01-01 00:00:00		2010-12-31 00:00:00		2011-03-31 00:00:00		2011-09-30 00:00:00		2011-12-31 00:00:00		2011-06-30 00:00:00		2012-03-31 00:00:00		2012-06-30 00:00:00		2014-12-31 00:00:00		2014-12-03 00:00:00		2014-09-30 00:00:00		2012-12-17 00:00:00		2012-09-30 00:00:00		2012-12-31 00:00:00		1900-01-01 00:00:00		2014-03-31 00:00:00		1900-01-01 00:00:00		2013-03-31 00:00:00		2015-12-31 00:00:00		2015-09-30 00:00:00		1900-01-01 00:00:00		2017-09-30 00:00:00		2017-10-02 00:00:00		2016-03-31 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		2016-12-31 00:00:00		1900-01-01 00:00:00		2016-12-12 00:00:00		None		2017-06-30 00:00:00		2017-03-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
filing_type		None		None		22006		None		22006		None		None		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		None		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		None		22006		None		22006		22006

Table: filer_to_filer_type

filer_id		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491
filer_type		4		4		4		4		4		4		4		4		4
active		Y		Y		Y		Y		Y		Y		T		Y		Y
race		0		0		0		None		None		None		None		None		None
session_id		2003		2005		2007		2011		2013		2009		2017		2015		2017
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		2004-04-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2011-01-01 00:00:00		2013-01-01 00:00:00		2009-01-01 00:00:00		2017-10-01 00:00:00		2015-01-01 00:00:00		2017-01-01 00:00:00
sub_category_type		0		0		0		None		None		None		None		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		2004-04-01 00:00:00		2004-04-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		1264491
xref_id		1264491
effect_dt		2004-04-01 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491
filer_id		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491		1264491
filer_type		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST
status		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED
effect_dt		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00
naml		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH		ULRICH
namf		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.		JOHN R.
namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr1		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr2		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
city		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM		FOLSOM
st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		956307417		957632260		956307417		956302260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		956302260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		956302260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		956302260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		956302260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		956302260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		956302260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		956302260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		957632260		956307417		957632260
phon		9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692				9169899692
fax		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
email		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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: filers

filer_id		1264491

Table: lobbying_chg_log

filer_id		1264491		1264491		1264491
change_no		1		2		3
session_id		2003		2017		2017
log_dt		2004-04-01 00:00:00		2017-10-02 00:00:00		2017-10-02 00:00:00
filer_type		4		4		4
correction_flg		None		None		None
action		SET ACTIVE		DELETED		TERMINATED
attribute_changed		FIRM		FIRM
ethics_dt		None		None		None
interests		None		None		None
filer_full_name		JOHN R. ULRICH		JOHN R. ULRICH		ULRICH, JOHN R.
filer_city		None		None		None
filer_st		None		None		None
filer_zip		None		None		None
filer_phone		None		None		None
entity_type		3		3		4
entity_name		ULRICH & ASSOCIATES, J.R.		ULRICH & ASSOCIATES; J.R.		None
entity_city		None		None		None
entity_st		None		None		None
entity_zip		None		None		None
entity_phone		None		None		None
entity_id		1264487		1264487		0
responsible_officer		None		None		None
effect_dt		2004-03-12 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00