Home

Filer ID: 1295326

Table: cvr_lobby_disclosure

filing_id		1282108		1260927		1260927		1260927		1369917		1346801		1296029		1307847		1260927		1327726		1307847		1432645		1450113		1390744		1418954		1503750		1482740		1461814		1539553		1619134		1588741		1604119		1571453		1588741		1632097		1707122		1674655		1654031		1732784		1795048		1778897		1760897		1778897		1795048		1811823		1900897		1864617		1839874		1931112		1992606		1978299		1963466		2059439		2088035		2008051		2027792		2168665		2152289		2123818		2187432		2232668		2204101
amend_id		0		1		0		2		0		0		0		1		3		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		1		1		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
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
sender_id		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326
filer_id		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326
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
filer_naml		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, 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
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
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
report_num		000		001		000		002		000		000		000		001		003		000		000		000		000		000		000		000		000		000		000		000		001		000		000		000		000		000		000		000		000		000		000		000		001		001		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000
rpt_date		2007-07-27 00:00:00		2007-06-12 00:00:00		2007-04-27 00:00:00		2007-10-05 00:00:00		2008-10-23 00:00:00		2008-07-28 00:00:00		2007-10-29 00:00:00		2008-04-30 00:00:00		2007-11-09 00:00:00		2008-04-28 00:00:00		2008-01-29 00:00:00		2009-07-22 00:00:00		2009-10-27 00:00:00		2009-01-21 00:00:00		2009-04-27 00:00:00		2010-07-27 00:00:00		2010-04-27 00:00:00		2010-01-28 00:00:00		2010-10-30 00:00:00		2011-10-24 00:00:00		2011-06-21 00:00:00		2011-07-27 00:00:00		2011-01-31 00:00:00		2011-04-27 00:00:00		2012-01-26 00:00:00		2012-10-30 00:00:00		2012-07-25 00:00:00		2012-04-24 00:00:00		2013-01-25 00:00:00		2013-10-10 00:00:00		2013-07-13 00:00:00		2013-04-23 00:00:00		2013-11-05 00:00:00		2013-11-05 00:00:00		2014-01-15 00:00:00		2014-10-20 00:00:00		2014-07-10 00:00:00		2014-04-16 00:00:00		2015-01-23 00:00:00		2015-10-19 00:00:00		2015-07-16 00:00:00		2015-04-21 00:00:00		2016-07-07 00:00:00		2016-10-07 00:00:00		2016-01-16 00:00:00		2016-04-07 00:00:00		2017-07-07 00:00:00		2017-04-13 00:00:00		2017-01-23 00:00:00		2017-10-06 00:00:00		2018-04-18 00:00:00		2018-01-19 00:00:00
from_date		2007-04-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2008-07-01 00:00:00		2008-04-01 00:00:00		2007-07-01 00:00:00		2007-10-01 00:00:00		2007-01-01 00:00:00		2008-01-01 00:00:00		2007-10-01 00:00:00		2009-04-01 00:00:00		2009-07-01 00:00:00		2008-10-01 00:00:00		2009-01-01 00:00:00		2010-04-01 00:00:00		2010-01-01 00:00:00		2009-10-01 00:00:00		2010-07-01 00:00:00		2011-07-01 00:00:00		2011-01-01 00:00:00		2011-04-01 00:00:00		2010-10-01 00:00:00		2011-01-01 00:00:00		2011-10-01 00:00:00		2012-07-01 00:00:00		2012-04-01 00:00:00		2012-01-01 00:00:00		2012-10-01 00:00:00		2013-07-01 00:00:00		2013-04-01 00:00:00		2013-01-01 00:00:00		2013-04-01 00:00:00		2013-07-01 00:00:00		2013-10-01 00:00:00		2014-07-01 00:00:00		2014-04-01 00:00:00		2014-01-01 00:00:00		2014-10-01 00:00:00		2015-07-01 00:00:00		2015-04-01 00:00:00		2015-01-01 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		2015-10-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		2018-01-01 00:00:00		2017-10-01 00:00:00
thru_date		2007-06-30 00:00:00		2007-03-31 00:00:00		2007-03-31 00:00:00		2007-03-31 00:00:00		2008-09-30 00:00:00		2008-06-30 00:00:00		2007-09-30 00:00:00		2007-12-31 00:00:00		2007-03-31 00:00:00		2008-03-31 00:00:00		2007-12-31 00:00:00		2009-06-30 00:00:00		2009-09-30 00:00:00		2008-12-31 00:00:00		2009-03-31 00:00:00		2010-06-30 00:00:00		2010-03-31 00:00:00		2009-12-31 00:00:00		2010-09-30 00:00:00		2011-09-30 00:00:00		2011-03-31 00:00:00		2011-06-30 00:00:00		2010-12-31 00:00:00		2011-03-31 00:00:00		2011-12-31 00:00:00		2012-09-30 00:00:00		2012-06-30 00:00:00		2012-03-31 00:00:00		2012-12-31 00:00:00		2013-09-30 00:00:00		2013-06-30 00:00:00		2013-03-31 00:00:00		2013-06-30 00:00:00		2013-09-30 00:00:00		2013-12-31 00:00:00		2014-09-30 00:00:00		2014-06-30 00:00:00		2014-03-31 00:00:00		2014-12-31 00:00:00		2015-09-30 00:00:00		2015-06-30 00:00:00		2015-03-31 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		2015-12-31 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		2018-03-31 00:00:00		2017-12-31 00:00:00
cum_beg_dt		2007-01-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		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		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2015-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00
firm_id		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326
firm_name		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, 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		Saratoga		Saratoga
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
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		95070		95070
firm_phon		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 409-5292		916 409-5292
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
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
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
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
sig_date		2007-07-26 00:00:00		2007-06-05 00:00:00		2007-04-20 00:00:00		2007-10-04 00:00:00		2008-10-21 00:00:00		2008-07-22 00:00:00		2007-10-25 00:00:00		2008-04-23 00:00:00		2007-11-06 00:00:00		2008-04-23 00:00:00		2008-01-28 00:00:00		2009-07-15 00:00:00		2009-10-23 00:00:00		2009-01-13 00:00:00		2009-04-08 00:00:00		2010-07-26 00:00:00		2010-04-19 00:00:00		2010-01-26 00:00:00		2010-10-26 00:00:00		2011-10-17 00:00:00		2011-06-20 00:00:00		2011-07-21 00:00:00		2011-01-30 00:00:00		2011-04-19 00:00:00		2011-01-18 00:00:00		2012-10-22 00:00:00		2012-07-15 00:00:00		2012-04-16 00:00:00		2013-01-24 00:00:00		2013-10-10 00:00:00		2013-07-13 00:00:00		2013-04-23 00:00:00		2013-11-05 00:00:00		2013-11-05 00:00:00		2014-01-15 00:00:00		2014-10-20 00:00:00		2014-07-10 00:00:00		2014-04-16 00:00:00		2015-01-23 00:00:00		2015-10-19 00:00:00		2015-07-16 00:00:00		2015-04-21 00:00:00		2016-07-07 00:00:00		2016-10-07 00:00:00		2016-01-16 00:00:00		2016-04-07 00:00:00		2017-07-07 00:00:00		2017-04-13 00:00:00		2017-01-23 00:00:00		2017-10-06 00:00:00		2018-04-18 00:00:00		2018-01-19 00:00:00
sig_loc		Sacramento, CA		Sacramento, CA		Sacramento, CA		None		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		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs
sig_namf		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan
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
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
prn_naml		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs
prn_namf		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan
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
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
sig_title		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Owner		None		None		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner
nopart1_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
part1_1_cb		X		X		None		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		X		None		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		X		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
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
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
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
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
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
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
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
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
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
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

Table: cvr_registration

filing_id		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1383556		1383556		1383556		1383556		1383556		1383556		1383556		1383556		1383556		1383556		1383556		1383556		1552173		1552173		1552173		1552173		1552173		1552173		1552173		1552173		1552173		1552173		1552173		1719328		1719328		1719328		1719328		1719328		1719328		1719328		1719328		1719328		1719328		1719328		1719328		1719328		1719328		1918421		1918421		1918421		1918421		1918421		1918421		1918421		1918421		1918421		1918421		1918421		1918421		1918421		1918421		1918421		1918421		1918421		1918421		1918421		1918421		2116837		2116837		2116837		2116837		2116837		2200649
amend_id		4		5		13		15		3		2		1		6		7		8		9		10		11		12		14		16		46		0		19		21		22		23		24		25		26		27		28		29		30		33		34		36		37		38		39		40		42		20		31		32		41		35		45		17		18		44		43		0		2		1		7		4		3		5		6		11		10		8		9		0		2		1		3		4		5		8		9		6		10		7		0		1		5		8		6		3		7		2		9		4		12		10		11		13		0		1		4		2		3		5		6		9		8		7		12		13		14		10		11		17		16		15		19		18		0		1		2		3		4		0
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		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		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F606
sender_id		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326
filer_id		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326
entity_cd		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM
filer_naml		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, 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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
report_num		004		005		013		015		003		002		001		006		007		008		009		010		011		012		014		016		046		000		019		021		022		023		024		025		026		027		028		029		030		033		034		036		037		038		039		040		042		020		031		032		041		035		045		017		018		044		043		000		002		001		007		004		003		005		006		011		010		008		009		000		002		001		003		004		005		008		009		006		010		007		000		001		005		008		006		003		007		002		009		004		012		010		011		013		000		001		004		002		003		005		006		009		008		007		012		013		014		010		011		017		016		015		019		018		000		001		002		003		004		000
rpt_date		2007-05-29 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-05-29 00:00:00		2007-05-01 00:00:00		2007-04-02 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2008-05-15 00:00:00		2007-02-21 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-11-02 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2008-03-11 00:00:00		2007-07-31 00:00:00		2007-08-17 00:00:00		2008-03-06 00:00:00		2008-01-18 00:00:00		2008-12-11 00:00:00		2009-12-31 00:00:00		2009-01-14 00:00:00		2010-01-08 00:00:00		2009-07-29 00:00:00		2009-06-18 00:00:00		2009-08-06 00:00:00		2009-10-30 00:00:00		2010-12-06 00:00:00		2010-11-03 00:00:00		2010-05-28 00:00:00		2010-05-28 00:00:00		2010-12-20 00:00:00		2011-06-24 00:00:00		2011-03-03 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2012-02-07 00:00:00		2012-11-15 00:00:00		2012-11-15 00:00:00		2012-07-02 00:00:00		2012-11-27 00:00:00		2012-04-01 00:00:00		2013-01-01 00:00:00		2013-04-01 00:00:00		2013-02-17 00:00:00		2013-12-07 00:00:00		2013-08-30 00:00:00		2013-05-17 00:00:00		2013-11-05 00:00:00		2013-05-17 00:00:00		2014-01-24 00:00:00		2013-07-02 00:00:00		2014-07-01 00:00:00		2014-02-16 00:00:00		2014-06-01 00:00:00		2014-11-30 00:00:00		2015-01-01 00:00:00		2015-01-12 00:00:00		2015-05-13 00:00:00		2015-03-18 00:00:00		2015-03-19 00:00:00		2015-06-26 00:00:00		2015-07-08 00:00:00		2015-09-30 00:00:00		2015-08-21 00:00:00		2015-07-01 00:00:00		2015-09-30 00:00:00		2016-01-01 00:00:00		2016-01-29 00:00:00		2015-10-01 00:00:00		2015-07-31 00:00:00		2016-06-30 00:00:00		2016-04-07 00:00:00		2016-03-30 00:00:00		2016-12-02 00:00:00		2016-12-01 00:00:00		2018-12-31 00:00:00		2017-02-15 00:00:00		2017-03-21 00:00:00		2017-06-29 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00
ls_beg_yr		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2017		2017		2017		2017
ls_end_yr		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2008		2010		2010		2010		2010		2010		2010		2010		2010		2010		2010		2010		2010		2012		2012		2012		2012		2012		2012		2012		2012		2012		2012		2012		2014		2014		2014		2014		2014		2014		2014		2014		2014		2014		2014		2014		2014		2014		2016		2016		2016		2016		2016		2016		2016		2016		2016		2016		2016		2016		2016		2016		2016		2016		2016		2016		2016		2016		2018		2018		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2017-12-31 00:00:00
bus_city		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Saratoga		Saratoga
bus_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
bus_zip4		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95070		95070
bus_phon		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 444-7114		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 444-7114		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		916 551-1881		(916) 551-1881		916 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		(916) 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 551-1881		916 409-5292		916 409-5292
bus_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
bus_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		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sig_date		2007-05-29 00:00:00		2007-06-05 00:00:00		2007-06-05 00:00:00		2007-06-05 00:00:00		2007-05-29 00:00:00		2007-04-20 00:00:00		2007-03-29 00:00:00		2007-06-05 00:00:00		2007-06-05 00:00:00		2007-06-05 00:00:00		2007-06-05 00:00:00		2007-06-05 00:00:00		2007-06-05 00:00:00		2007-06-05 00:00:00		2007-06-05 00:00:00		2007-06-05 00:00:00		2008-04-30 00:00:00		2007-02-20 00:00:00		2007-10-25 00:00:00		2007-10-25 00:00:00		2007-10-25 00:00:00		2007-10-25 00:00:00		2007-10-25 00:00:00		2007-10-25 00:00:00		2007-10-25 00:00:00		2007-10-25 00:00:00		2007-10-25 00:00:00		2007-10-25 00:00:00		2007-10-25 00:00:00		2007-11-06 00:00:00		2007-11-06 00:00:00		2007-11-06 00:00:00		2007-11-06 00:00:00		2007-11-06 00:00:00		2007-11-06 00:00:00		2007-11-06 00:00:00		2007-11-06 00:00:00		2007-10-25 00:00:00		2007-11-06 00:00:00		2007-11-06 00:00:00		2007-11-06 00:00:00		2007-11-06 00:00:00		2008-03-05 00:00:00		2007-07-27 00:00:00		2007-08-14 00:00:00		2008-03-03 00:00:00		2008-01-17 00:00:00		2008-11-18 00:00:00		2009-02-23 00:00:00		2009-01-07 00:00:00		2010-01-05 00:00:00		2009-07-20 00:00:00		2009-06-16 00:00:00		2009-08-05 00:00:00		2009-10-23 00:00:00		2010-11-17 00:00:00		2010-11-01 00:00:00		2010-05-19 00:00:00		2010-05-19 00:00:00		2010-12-16 00:00:00		2011-06-23 00:00:00		2011-02-18 00:00:00		2012-01-12 00:00:00		2012-01-19 00:00:00		2012-02-06 00:00:00		2012-11-15 00:00:00		2012-11-15 00:00:00		2012-06-11 00:00:00		2012-11-19 00:00:00		2012-07-25 00:00:00		2012-12-30 00:00:00		2013-04-19 00:00:00		2013-07-08 00:00:00		2013-11-14 00:00:00		2013-08-28 00:00:00		2013-06-24 00:00:00		2013-11-05 00:00:00		2013-05-17 00:00:00		2014-01-28 00:00:00		2013-07-02 00:00:00		2014-08-06 00:00:00		2014-02-04 00:00:00		2014-05-30 00:00:00		2014-11-13 00:00:00		2014-12-04 00:00:00		2015-01-27 00:00:00		2015-05-13 00:00:00		2015-03-24 00:00:00		2015-03-25 00:00:00		2015-06-09 00:00:00		2015-07-09 00:00:00		2015-08-28 00:00:00		2015-08-21 00:00:00		2015-07-09 00:00:00		2015-11-03 00:00:00		2016-01-28 00:00:00		2016-02-02 00:00:00		2015-10-13 00:00:00		2015-10-14 00:00:00		2016-06-30 00:00:00		2016-04-13 00:00:00		2016-04-01 00:00:00		2016-12-02 00:00:00		2016-12-01 00:00:00		2016-12-20 00:00:00		2017-02-15 00:00:00		2017-03-21 00:00:00		2017-06-29 00:00:00		2017-12-20 00:00:00		2017-12-20 00:00:00
sig_loc		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Sacramento CA		None		Sacramento CA		None		None		None		None		None		None		None		None		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		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs
sig_namf		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan
sig_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sig_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
prn_naml		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs		Klehs
prn_namf		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan		Johan
prn_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
prn_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sig_title		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner
stmt_firm		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		Johan Klehs & Company, Inc.		None
ind_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
auth_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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
auth_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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
auth_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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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_int		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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_name		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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_reg_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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: filer_address

filer_id		1295326		1295326		1295326		1295326		1295326		1295326
adrid		2118928		2159456		2204810		2412526		2278560		2341755
effect_dt		2007-02-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		2015-01-01 00:00:00
add_type		7051		7051		7051		7051		7051		7051
session_id		2007		2009		2011		2017		2013		2015

Table: filer_filings

filer_id		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326
filing_id		1246843		1258738		1246843		1260927		1246843		1269794		1269796		1258868		1272987		1260927		1262669		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1260927		1282108		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1246843		1281872		1272988		1272989		1272990		1272991		1272992		1272993		1272994		1272995		1272996		1272997		1272998		1289606		1246843		1260927		1246843		1246843		1246843		1246843		1298898		1298899		1298900		1298901		1298902		1298903		1298904		1298905		1298906		1298907		1298908		1298909		1246843		1246843		1773571		1719328		1771332		1784332		1719328		1790002		1771335		1719328		1778897		1719328		1719328		1784329		1971099		1918421		1962058		1962062		1962054		1963466		1918421		1918421		1918421		1859373		1864617		1839874		1719328		1805864		1805869		1778897		1795048		1795048		1950284		1918421		1918421		1900897		1307847		1246843		1304482		1246843		1246843		1298318		1298319		1298320		1298321		1298322		1298323		1298324		1298325		1298326		1298327		1298328		1298329		1246843		1246843		1296029		1327726		1346801		1246843		1246843		1307847		1317116		1317454		1332340		1369917		1390744		1383556		1383556		1383556		1418954		1410042		1410059		1410121		1410127		1426029		1429574		1383556		1383556		1383556		1450113		1383556		1432645		1450142		1456802		1383556		1432652		1482740		1441672		1461814		1496668		1496670		1383556		1383556		1503750		1539553		1541647		1383556		1552173		1383556		1548873		1552362		1584610		1588741		1588741		1571453		1552173		1604119		1552173		1598931		1552173		1632097		1552173		1619134		1639900		1643202		1654031		1639902		1552173		1679013		1552173		1673119		1719328		1719328		1811823		1817903		1719328		1821118		1674655		1552173		1931112		1918421		1916309		1918421		1719328		1552173		1719328		1707122		1716108		1716111		1719328		1719328		1879056		1552173		1552173		1732784		1716904		1726356		1719328		1760897		1992606		1990185		1992248		1972843		1918421		1984155		1918421		1987139		1992246		1918421		1918421		1978299		2001443		1984153		1918421		2232668		2187432		1918421		1918421		2016254		2016256		2008051		1918421		2027792		1918421		1918421		2059439		2088035		1918421		1918421		2116837		2148256		2123818		2152289		2148530		2116837		2142687		2116837		2164967		2164969		2168665		2162046		2116837		2164961		2164965		2164971		2166238		2200539		2200541		2204101		2200649		2116837
period_id		190		None		189		189		191		None		None		None		None		189		None		190		190		190		190		190		190		192		192		192		192		192		192		192		192		192		192		192		192		192		192		192		189		190		190		190		190		190		190		190		190		190		190		None		None		None		None		None		None		None		None		None		None		None		None		None		191		189		192		192		192		192		None		None		None		None		None		None		None		None		None		None		None		None		192		193		None		215		None		None		215		None		None		213		214		214		214		None		None		223		None		None		None		221		222		222		223		None		218		217		216		None		None		214		215		215		None		221		221		219		192		192		None		193		193		None		None		None		None		None		None		None		None		None		None		None		None		192		192		191		193		194		192		194		192		None		None		None		195		196		196		197		200		197		None		None		None		None		None		None		199		198		199		199		200		198		None		None		201		None		201		None		200		None		None		202		202		202		203		None		204		204		204		None		None		None		205		205		204		205		206		206		None		208		208		208		207		None		None		209		None		209		None		211		None		216		217		216		None		217		None		210		210		220		221		None		221		220		212		213		211		None		None		219		218		None		212		212		212		None		None		214		213		223		None		None		None		223		None		224		None		None		223		223		222		None		None		223		233		231		225		225		None		None		224		226		225		225		226		226		227		228		228		236		None		228		229		None		229		None		229		None		None		230		None		230		None		None		None		None		None		None		232		232		232
form_id		F601		F601		F601		F625		F601		F605		F605		F605		F605		F625		F605		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		F625		F625		F601		F601		F601		F601		F601		F601		F601		F601		F601		F605		F605		F605		F605		F605		F605		F605		F605		F605		F605		F605		F605		F605		F601		F625		F601		F601		F601		F601		F605		F605		F605		F605		F605		F605		F605		F605		F605		F605		F605		F605		F601		F601		F605		F601		F605		F605		F601		F605		F605		F601		F625		F601		F601		F605		F605		F601		F605		F605		F605		F625		F601		F601		F601		F605		F625		F625		F601		F605		F605		F625		F625		F625		F601		F601		F601		F625		F625		F601		F605		F601		F601		F605		F605		F605		F605		F605		F605		F605		F605		F605		F605		F605		F605		F601		F601		F625		F625		F625		F601		F601		F625		F605		F605		F605		F625		F625		F601		F601		F601		F625		F601		F602		F605		F602		F605		F605		F601		F601		F601		F625		F601		F625		F605		F605		F601		F605		F625		F605		F625		F605		F605		F601		F601		F625		F625		F605		F601		F601		F601		F605		F601		F605		F625		F625		F625		F601		F625		F601		F605		F601		F625		F601		F625		F605		F605		F625		F605		F601		F605		F601		F605		F601		F601		F625		F605		F601		F605		F625		F601		F625		F601		F605		F601		F601		F601		F601		F625		F605		F605		F601		F601		F605		F601		F601		F625		F605		F601		F601		F625		F625		F605		F605		F605		F601		F605		F601		F605		F605		F601		F601		F625		F605		F605		F601		F625		F625		F601		F601		F605		F605		F625		F601		F625		F601		F601		F625		F625		F601		F601		F601		F605		F625		F625		F605		F601		F601		F601		F605		F605		F625		F605		F601		F605		F605		F605		F605		F605		F606		F625		F606		F601
filing_sequence		1		0		0		1		17		0		0		0		0		0		0		3		4		5		13		15		2		19		21		22		23		26		27		30		33		34		36		37		38		39		40		42		3		0		6		7		8		9		10		11		12		14		16		0		0		0		0		0		0		0		0		0		0		0		0		0		18		2		28		29		31		32		0		0		0		0		0		0		0		0		0		0		0		0		35		43		0		4		0		0		6		0		0		5		0		3		2		0		0		6		0		0		0		0		4		5		7		0		0		0		8		0		0		1		1		0		0		2		3		0		0		20		0		45		44		0		0		0		0		0		0		0		0		0		0		0		0		24		25		0		0		0		41		46		1		0		0		0		0		0		0		1		2		0		0		0		0		0		0		0		4		3		5		0		6		0		0		0		7		0		0		0		0		0		0		8		9		0		0		0		11		0		10		0		0		0		0		1		0		1		0		2		0		4		0		3		0		0		0		0		0		5		0		6		0		7		9		0		0		10		0		0		7		0		1		0		0		13		10		0		0		0		0		12		11		0		8		9		0		0		0		1		0		0		0		0		0		11		0		10		0		0		9		12		0		0		0		8		0		0		13		15		0		0		0		16		0		14		17		0		0		19		18		0		0		0		0		0		2		0		1		0		0		0		0		3		0		0		0		0		0		0		0		0		4
filing_date		2007-04-02 00:00:00		2007-02-20 00:00:00		2007-02-21 00:00:00		2007-06-12 00:00:00		2007-07-31 00:00:00		2007-05-29 00:00:00		2007-05-29 00:00:00		2007-03-30 00:00:00		2007-06-08 00:00:00		2007-04-27 00:00:00		2007-04-27 00:00:00		2007-05-29 00:00:00		2007-05-29 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-05-01 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-07-27 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-07-27 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-08-16 00:00:00		2007-08-17 00:00:00		2007-10-05 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-11-07 00:00:00		2007-11-07 00:00:00		2007-11-07 00:00:00		2007-11-07 00:00:00		2007-11-07 00:00:00		2007-11-07 00:00:00		2007-11-07 00:00:00		2007-11-07 00:00:00		2007-11-07 00:00:00		2007-11-07 00:00:00		2007-11-07 00:00:00		2007-11-07 00:00:00		2007-11-09 00:00:00		2008-01-18 00:00:00		2012-09-26 00:00:00		2013-07-02 00:00:00		2013-04-25 00:00:00		2013-07-09 00:00:00		2013-08-28 00:00:00		2013-08-29 00:00:00		2013-05-17 00:00:00		2013-07-09 00:00:00		2013-07-26 00:00:00		2013-06-26 00:00:00		2013-05-17 00:00:00		2013-07-02 00:00:00		2015-05-14 00:00:00		2015-07-09 00:00:00		2015-01-27 00:00:00		2015-03-24 00:00:00		2015-03-25 00:00:00		2015-04-28 00:00:00		2015-05-14 00:00:00		2015-06-26 00:00:00		2015-07-10 00:00:00		2014-06-03 00:00:00		2014-07-21 00:00:00		2014-04-21 00:00:00		2013-11-15 00:00:00		2013-11-06 00:00:00		2013-11-15 00:00:00		2013-11-05 00:00:00		2013-11-05 00:00:00		2013-10-17 00:00:00		2014-12-15 00:00:00		2015-03-24 00:00:00		2015-03-25 00:00:00		2014-10-20 00:00:00		2008-01-29 00:00:00		2007-11-02 00:00:00		2008-01-18 00:00:00		2008-03-11 00:00:00		2008-03-06 00:00:00		2007-11-01 00:00:00		2007-11-01 00:00:00		2007-11-01 00:00:00		2007-11-01 00:00:00		2007-11-01 00:00:00		2007-11-01 00:00:00		2007-11-01 00:00:00		2007-11-01 00:00:00		2007-11-01 00:00:00		2007-11-01 00:00:00		2007-11-01 00:00:00		2007-11-01 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-10-29 00:00:00		2008-04-28 00:00:00		2008-07-28 00:00:00		2007-11-09 00:00:00		2008-05-15 00:00:00		2008-04-30 00:00:00		2008-03-05 00:00:00		2008-03-06 00:00:00		2008-05-02 00:00:00		2008-10-23 00:00:00		2009-01-21 00:00:00		2008-12-11 00:00:00		2009-01-14 00:00:00		2009-02-26 00:00:00		2009-04-27 00:00:00		2008-12-05 00:00:00		2008-12-05 00:00:00		2009-01-13 00:00:00		2009-01-13 00:00:00		2009-02-25 00:00:00		2009-06-17 00:00:00		2009-07-29 00:00:00		2009-06-18 00:00:00		2009-08-06 00:00:00		2009-10-27 00:00:00		2009-10-30 00:00:00		2009-07-22 00:00:00		2009-10-27 00:00:00		2010-01-06 00:00:00		2010-01-08 00:00:00		2009-07-21 00:00:00		2010-04-27 00:00:00		2009-08-05 00:00:00		2010-01-28 00:00:00		2010-05-28 00:00:00		2010-05-28 00:00:00		2010-05-28 00:00:00		2010-05-28 00:00:00		2010-07-27 00:00:00		2010-10-30 00:00:00		2010-11-02 00:00:00		2010-12-06 00:00:00		2010-12-20 00:00:00		2010-11-03 00:00:00		2010-12-03 00:00:00		2010-12-17 00:00:00		2011-03-02 00:00:00		2011-04-27 00:00:00		2011-06-21 00:00:00		2011-01-31 00:00:00		2011-03-03 00:00:00		2011-07-27 00:00:00		2011-06-24 00:00:00		2011-06-24 00:00:00		2012-01-20 00:00:00		2012-01-26 00:00:00		2012-01-20 00:00:00		2011-10-24 00:00:00		2012-01-19 00:00:00		2012-02-07 00:00:00		2012-04-24 00:00:00		2012-01-20 00:00:00		2012-02-07 00:00:00		2012-07-25 00:00:00		2012-07-02 00:00:00		2012-07-02 00:00:00		2013-11-06 00:00:00		2014-01-28 00:00:00		2014-01-22 00:00:00		2014-01-28 00:00:00		2014-02-07 00:00:00		2014-02-07 00:00:00		2012-07-25 00:00:00		2012-07-31 00:00:00		2015-01-27 00:00:00		2015-01-27 00:00:00		2014-11-14 00:00:00		2014-12-15 00:00:00		2014-11-14 00:00:00		2012-11-27 00:00:00		2012-12-20 00:00:00		2012-10-30 00:00:00		2012-11-15 00:00:00		2012-11-15 00:00:00		2014-08-12 00:00:00		2014-06-03 00:00:00		2014-08-12 00:00:00		2012-11-15 00:00:00		2012-11-15 00:00:00		2013-01-25 00:00:00		2012-11-26 00:00:00		2012-12-20 00:00:00		2013-04-25 00:00:00		2013-04-23 00:00:00		2015-10-20 00:00:00		2015-09-28 00:00:00		2015-10-14 00:00:00		2015-06-26 00:00:00		2015-10-14 00:00:00		2015-07-10 00:00:00		2015-10-14 00:00:00		2015-08-24 00:00:00		2015-10-14 00:00:00		2015-09-28 00:00:00		2015-11-04 00:00:00		2015-07-28 00:00:00		2015-11-04 00:00:00		2015-07-09 00:00:00		2015-08-24 00:00:00		2018-04-18 00:00:00		2017-10-11 00:00:00		2016-02-02 00:00:00		2016-04-04 00:00:00		2016-02-02 00:00:00		2016-02-02 00:00:00		2016-01-27 00:00:00		2016-04-14 00:00:00		2016-04-12 00:00:00		2016-02-02 00:00:00		2016-07-05 00:00:00		2016-07-27 00:00:00		2016-10-12 00:00:00		2016-12-13 00:00:00		2016-12-01 00:00:00		2017-01-03 00:00:00		2017-02-16 00:00:00		2017-01-25 00:00:00		2017-04-21 00:00:00		2017-03-24 00:00:00		2017-03-24 00:00:00		2016-12-30 00:00:00		2017-02-16 00:00:00		2017-06-14 00:00:00		2017-06-14 00:00:00		2017-07-19 00:00:00		2013-06-26 00:00:00		2017-06-29 00:00:00		2017-06-14 00:00:00		2017-06-14 00:00:00		2017-06-14 00:00:00		2017-06-29 00:00:00		2018-01-05 00:00:00		2018-01-05 00:00:00		2018-01-22 00:00:00		2018-01-08 00:00:00		2018-01-08 00:00:00
stmnt_type		10002		10005		10001		10002		10002		10005		10005		10005		10005		10001		10005		10002		10002		10002		10002		10002		10002		10002		10002		10002		10002		10002		10002		10002		10002		10002		10002		10002		10002		10002		10002		10002		10002		10001		10002		10002		10002		10002		10002		10002		10002		10002		10002		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10002		10002		10002		10002		10002		10002		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10002		10002		10005		10002		10005		10006		10002		10005		10005		10002		10001		10002		10002		10006		10006		10002		10006		10006		10006		10001		10002		10002		10002		10005		10001		10001		10002		10006		10006		10002		10002		10001		10005		10002		10002		10001		10001		10002		10005		10002		10002		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10002		10002		10001		10001		10001		10002		10002		10002		10005		10005		10005		10001		10001		10001		10002		10002		10001		10005		10005		10005		10005		10006		10005		10002		10002		10002		10001		10002		10001		10006		10006		10002		10006		10001		10006		10001		10006		10006		10002		10002		10001		10001		10006		10002		10001		10002		10006		10005		10005		10001		10002		10001		10002		10001		10002		10005		10002		10001		10002		10001		10006		10006		10001		10006		10002		10006		10002		10006		10002		10002		10001		10006		10002		10006		10001		10002		10001		10002		10006		10001		10002		10002		10001		10001		10006		10006		10002		10002		10006		10002		10002		10001		10006		10005		10002		10001		10001		10006		10006		10006		10002		10006		10002		10006		10006		10002		10002		10001		10006		10006		10002		10001		10001		10002		10002		10005		10005		10001		10002		10001		10002		10002		10001		10001		10002		10002		10001		10005		10001		10001		10005		10002		10005		10002		10006		10006		10001		10006		10002		10006		10006		10006		10005		10005		10005		10001		10001		10002
stmnt_status		11003		11001		11003		11001		11003		11001		11001		11003		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11003		11003		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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		11003		11001		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11003		11003		11001		11003		11001		11003		11003		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003
session_id		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2015		2015		2015		2015		2015		2015		2015		2015		2015		2013		2013		2013		2013		2013		2013		2013		2013		2013		2015		2015		2015		2013		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2009		2009		2011		2011		2011		2011		2009		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2013		2013		2013		2013		2013		2013		2011		2011		2013		2015		2013		2015		2013		2011		2013		2011		2011		2011		2013		2013		2013		2011		2011		2011		2011		2013		2013		2013		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2015		2017		2017		2017		2017		2017		2015		2015		2017		2013		2017		2015		2015		2015		2017		2017		2017		2017		2017		2017
user_id		*		CFLAGG		*		YRODRIGU		*		CFLAGG		CFLAGG		YRODRIGU		GPEREZ		YRODRIGU		GPEREZ		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		YRODRIGU		YRODRIGU		*		*		*		*		*		*		*		*		*		SARRIAGA		GPEREZ		GPEREZ		GPEREZ		GPEREZ		GPEREZ		GPEREZ		GPEREZ		GPEREZ		GPEREZ		GPEREZ		GPEREZ		SARRIAGA		*		YRODRIGU		*		*		*		*		GPEREZ		GPEREZ		GPEREZ		GPEREZ		GPEREZ		GPEREZ		GPEREZ		GPEREZ		GPEREZ		GPEREZ		GPEREZ		GPEREZ		*		*		SARRIAGA		YRODRIGU		SARRIAGA		YRODRIGU		SARRIAGA		SARRIAGA		GPEREZ		YRODRIGU		ASAETERN		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		AGLADNEY		YRODRIGU		YRODRIGU		YRODRIGU		GPEREZ		ASAETERN		ASAETERN		YRODRIGU		YRODRIGU		YRODRIGU		ASAETERN		ASAETERN		ASAETERN		PBANFORD		YRODRIGU		YRODRIGU		ASAETERN		YRODRIGU		*		GPEREZ		*		*		SARRIAGA		SARRIAGA		SARRIAGA		SARRIAGA		SARRIAGA		SARRIAGA		SARRIAGA		SARRIAGA		SARRIAGA		SARRIAGA		SARRIAGA		SARRIAGA		*		*		YRODRIGU		LTHIBAUL		LTHIBAUL		*		*		LTHIBAUL		YRODRIGU		YRODRIGU		YRODRIGU		MGUERRA		MGUERRA		YRODRIGU		YRODRIGU		YRODRIGU		CFLAGG		YRODRIGU		CPON		YRODRIGU		CPON		YRODRIGU		PBANFORD		YRODRIGU		PBANFORD		YRODRIGU		CFLAGG		YRODRIGU		CFLAGG		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		CFLAGG		YRODRIGU		CFLAGG		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		ASAETERN		ASAETERN		YRODRIGU		PBANFORD		YRODRIGU		YRODRIGU		PBANFORD		GKURIMOT		SARRIAGA		ASAETERN		ASAETERN		ASAETERN		PBANFORD		ASAETERN		YRODRIGU		GPEREZ		YRODRIGU		ASAETERN		YRODRIGU		ASAETERN		YRODRIGU		YRODRIGU		ASAETERN		YRODRIGU		YRODRIGU		ASAETERN		YRODRIGU		ASAETERN		YRODRIGU		YRODRIGU		ASAETERN		YRODRIGU		YRODRIGU		YRODRIGU		AGLADNEY		YRODRIGU		AGLADNEY		YRODRIGU		PBANFORD		PBANFORD		PBANFORD		YRODRIGU		SARRIAGA		ASAETERN		SMCCONNAN		SMCCONNAN		YRODRIGU		YRODRIGU		SMCCONNAN		YRODRIGU		YRODRIGU		ASAETERN		ASAETERN		SARRIAGA		YRODRIGU		ASAETERN		AGLADNEY		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		AGLADNEY		YRODRIGU		YRODRIGU		YRODRIGU		CAFILER		AGLADNEY		CAFILER		CAFILER		GPEREZ		GPEREZ		AGLADNEY		CAFILER		AGLADNEY		CAFILER		CAFILER		AGLADNEY		AGLADNEY		CAFILER		CAFILER		SARRIAGA		SARRIAGA		AGLADNEY		AGLADNEY		SARRIAGA		SARRIAGA		SARRIAGA		SARRIAGA		YRODRIGU		YRODRIGU		AGLADNEY		NLANDERS		GPEREZ		YRODRIGU		YRODRIGU		YRODRIGU		GPEREZ		GPEREZ		GPEREZ		AGLADNEY		CAFILER		CAFILER
special_audit		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11003		11003		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		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		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		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11003		11003		11001		11001		11003		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11003		11003		11001		11003		11001		11003		11003		11001		11001		11003		11003		11003		11003		11001		11001		11003		11003		11003		11003		11001		11001		11001		11003		11003		11001		11001		11001		11003		11003		11003		11001		11003		11003
rpt_start		2007-04-02 00:00:00		1900-01-01 00:00:00		2007-02-21 00:00:00		2007-01-01 00:00:00		2007-07-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		2007-01-01 00:00:00		1900-01-01 00:00:00		2007-05-29 00:00:00		2007-05-29 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-05-01 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-01-01 00:00:00		2007-04-01 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 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		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		2007-08-17 00:00:00		2007-01-01 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-11-09 00:00:00		2007-11-09 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		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		2007-11-09 00:00:00		2008-01-18 00:00:00		1900-01-01 00:00:00		2013-07-02 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2013-08-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2013-02-17 00:00:00		2013-04-01 00:00:00		2013-05-17 00:00:00		2013-05-17 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2015-07-08 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2015-01-01 00:00:00		2015-05-13 00:00:00		2015-06-26 00:00:00		2015-07-01 00:00:00		1900-01-01 00:00:00		2014-04-01 00:00:00		2014-01-01 00:00:00		2013-12-07 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2013-04-01 00:00:00		2013-07-01 00:00:00		2013-07-01 00:00:00		1900-01-01 00:00:00		2015-03-18 00:00:00		2015-03-19 00:00:00		2014-07-01 00:00:00		2007-10-01 00:00:00		2007-11-02 00:00:00		1900-01-01 00:00:00		2008-03-11 00:00:00		2008-03-06 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		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		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-07-01 00:00:00		2008-01-01 00:00:00		2008-04-01 00:00:00		2007-11-09 00:00:00		2008-05-15 00:00:00		2007-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2008-07-01 00:00:00		2008-10-01 00:00:00		2008-12-11 00:00:00		2009-01-14 00:00:00		2009-12-31 00:00:00		2009-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		2009-07-29 00:00:00		2009-06-18 00:00:00		2009-08-06 00:00:00		2009-07-01 00:00:00		2009-10-30 00:00:00		2009-04-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2010-01-08 00:00:00		1900-01-01 00:00:00		2010-01-01 00:00:00		1900-01-01 00:00:00		2009-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2010-05-28 00:00:00		2010-05-28 00:00:00		2010-04-01 00:00:00		2010-07-01 00:00:00		1900-01-01 00:00:00		2010-12-06 00:00:00		2010-12-20 00:00:00		2010-11-03 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2010-10-01 00:00:00		2011-03-03 00:00:00		2011-04-01 00:00:00		2011-06-24 00:00:00		1900-01-01 00:00:00		2011-12-31 00:00:00		2011-10-01 00:00:00		2011-12-31 00:00:00		2011-07-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2012-01-01 00:00:00		1900-01-01 00:00:00		2012-02-07 00:00:00		1900-01-01 00:00:00		2012-07-02 00:00:00		1900-01-01 00:00:00		2013-11-05 00:00:00		2014-01-24 00:00:00		2013-10-01 00:00:00		1900-01-01 00:00:00		2014-02-16 00:00:00		1900-01-01 00:00:00		2012-04-01 00:00:00		2012-04-01 00:00:00		2014-10-01 00:00:00		2015-01-12 00:00:00		1900-01-01 00:00:00		2015-01-01 00:00:00		2014-11-30 00:00:00		2012-11-27 00:00:00		2013-01-01 00:00:00		2012-07-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2014-07-01 00:00:00		2014-06-01 00:00:00		1900-01-01 00:00:00		2012-11-15 00:00:00		2012-11-15 00:00:00		2012-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2013-04-01 00:00:00		2013-01-01 00:00:00		2015-07-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2015-07-31 00:00:00		1900-01-01 00:00:00		2015-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2015-09-30 00:00:00		2015-09-30 00:00:00		2015-04-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2015-08-21 00:00:00		2018-01-01 00:00:00		2017-07-01 00:00:00		2016-01-01 00:00:00		2016-03-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2015-10-01 00:00:00		2016-04-07 00:00:00		2016-01-01 00:00:00		2016-01-29 00:00:00		2016-06-30 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		2016-12-02 00:00:00		2016-12-01 00:00:00		2018-12-31 00:00:00		1900-01-01 00:00:00		2016-10-01 00:00:00		2017-01-01 00:00:00		1900-01-01 00:00:00		2017-03-21 00:00:00		1900-01-01 00:00:00		2017-02-15 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2017-04-01 00:00:00		None		2017-06-29 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		2017-10-01 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00
rpt_end		2007-04-02 00:00:00		1900-01-01 00:00:00		2007-02-21 00:00:00		2007-03-31 00:00:00		2007-07-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		2007-03-31 00:00:00		1900-01-01 00:00:00		2007-05-29 00:00:00		2007-05-29 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-05-01 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-11-09 00:00:00		2007-03-31 00:00:00		2007-06-30 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 00:00:00		2007-06-08 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		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		2007-08-17 00:00:00		2007-03-31 00:00:00		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-11-09 00:00:00		2007-11-09 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		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		2007-11-09 00:00:00		2008-01-18 00:00:00		1900-01-01 00:00:00		2013-07-02 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2013-08-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2013-02-17 00:00:00		2013-06-30 00:00:00		2013-05-17 00:00:00		2013-05-17 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2015-07-08 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2015-03-31 00:00:00		2015-05-13 00:00:00		2015-06-26 00:00:00		2015-07-01 00:00:00		1900-01-01 00:00:00		2014-06-30 00:00:00		2014-03-31 00:00:00		2013-12-07 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2013-06-30 00:00:00		2013-09-30 00:00:00		2013-09-30 00:00:00		1900-01-01 00:00:00		2015-03-18 00:00:00		2015-03-19 00:00:00		2014-09-30 00:00:00		2007-12-31 00:00:00		2007-11-02 00:00:00		1900-01-01 00:00:00		2008-03-11 00:00:00		2008-03-06 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		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		2007-11-02 00:00:00		2007-11-02 00:00:00		2007-09-30 00:00:00		2008-03-31 00:00:00		2008-06-30 00:00:00		2007-11-09 00:00:00		2008-05-15 00:00:00		2007-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2008-09-30 00:00:00		2008-12-31 00:00:00		2008-12-11 00:00:00		2009-01-14 00:00:00		2009-12-31 00:00:00		2009-03-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		2009-07-29 00:00:00		2009-06-18 00:00:00		2009-08-06 00:00:00		2009-09-30 00:00:00		2009-10-30 00:00:00		2009-06-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2010-01-08 00:00:00		1900-01-01 00:00:00		2010-03-31 00:00:00		1900-01-01 00:00:00		2009-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2010-05-28 00:00:00		2010-05-28 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		1900-01-01 00:00:00		2010-12-06 00:00:00		2010-12-20 00:00:00		2010-11-03 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2011-03-31 00:00:00		2011-03-31 00:00:00		2010-12-31 00:00:00		2011-03-03 00:00:00		2011-06-30 00:00:00		2011-06-24 00:00:00		1900-01-01 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2011-09-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2012-03-31 00:00:00		1900-01-01 00:00:00		2012-02-07 00:00:00		1900-01-01 00:00:00		2012-07-02 00:00:00		1900-01-01 00:00:00		2013-11-05 00:00:00		2014-01-24 00:00:00		2013-12-31 00:00:00		1900-01-01 00:00:00		2014-02-16 00:00:00		1900-01-01 00:00:00		2012-06-30 00:00:00		2012-04-01 00:00:00		2014-12-31 00:00:00		2015-01-12 00:00:00		1900-01-01 00:00:00		2015-01-01 00:00:00		2014-11-30 00:00:00		2012-11-27 00:00:00		2013-01-01 00:00:00		2012-09-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2014-07-01 00:00:00		2014-06-01 00:00:00		1900-01-01 00:00:00		2012-11-15 00:00:00		2012-11-15 00:00:00		2012-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2013-04-01 00:00:00		2013-03-31 00:00:00		2015-09-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2015-07-31 00:00:00		1900-01-01 00:00:00		2015-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2015-09-30 00:00:00		2015-09-30 00:00:00		2015-06-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2015-08-21 00:00:00		2018-03-31 00:00:00		2017-09-30 00:00:00		2016-01-01 00:00:00		2016-03-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2015-12-31 00:00:00		2016-04-07 00:00:00		2016-03-31 00:00:00		2016-01-29 00:00:00		2016-06-30 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		2016-12-02 00:00:00		2016-12-01 00:00:00		2018-12-31 00:00:00		1900-01-01 00:00:00		2016-12-31 00:00:00		2017-03-31 00:00:00		1900-01-01 00:00:00		2017-03-21 00:00:00		1900-01-01 00:00:00		2017-02-15 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2017-06-30 00:00:00		None		2017-06-29 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		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		22001		None		22001		22001		22001		None		None		None		None		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		None		None		None		None		None		None		None		None		None		None		None		None		22001		22001		22001		22001		22001		22001		None		None		None		None		None		None		None		None		None		None		None		None		22001		22001		None		22001		None		None		22001		None		None		22001		22001		22001		22001		None		None		22001		None		None		None		22001		22001		22001		22001		None		22001		22001		22001		None		None		22001		22001		22001		None		22001		22001		22001		22001		22001		None		22001		22001		None		None		None		None		None		None		None		None		None		None		None		None		22001		22001		22001		22001		22001		22001		22001		22001		None		None		None		22001		22001		22001		22001		22001		22001		None		None		None		None		None		None		22001		22001		22001		22001		22001		22001		None		None		22001		None		22001		None		22001		None		None		22001		22001		22001		22001		None		22001		22001		22001		None		None		None		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		None		None		22001		None		22001		None		22001		None		22001		22001		22001		None		22001		None		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		None		None		22001		22001		None		22001		22001		22001		None		None		22001		22001		22001		None		None		None		22001		None		22001		None		None		22001		22001		22001		None		None		22001		22001		22001		22001		22001		None		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		None		22001		None		22001		None		None		22001		None		22001		None		None		None		None		None		None		22001		22001		22001

Table: filer_to_filer_type

filer_id		1295326		1295326		1295326		1295326		1295326		1295326		1295326
filer_type		3		3		3		3		3		3		3
active		Y		Y		Y		Y		T		Y		Y
race		0		None		None		None		None		None		None
session_id		2007		2011		2013		2009		2017		2015		2017
category		0		None		None		None		None		None		None
category_type		0		None		None		None		None		None		None
sub_category		0		None		None		None		None		None		None
effect_dt		2007-02-01 00:00:00		2011-01-01 00:00:00		2013-01-01 00:00:00		2009-01-01 00:00:00		2017-12-31 00:00:00		2015-01-01 00:00:00		2017-01-01 00:00:00
sub_category_type		0		None		None		None		None		None		None
election_type		0		None		None		None		None		None		None
sub_category_a		None		None		None		None		None		None		None
nyq_dt		None		None		None		None		None		None		None
party_cd		0		None		None		None		None		None		None
county_cd		0		None		None		None		None		None		None
district_cd		0		None		None		None		None		None		None

Table: filer_xref

filer_id		1295326
xref_id		1295326
effect_dt		2007-02-20 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326
filer_id		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326
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
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
effect_dt		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00
naml		KLEHS & COMPANY; JOHAN		KLEHS & COMPANY; JOHAN		KLEHS & COMPANY; JOHAN		KLEHS & COMPANY; JOHAN		KLEHS & COMPANY; JOHAN		KLEHS & COMPANY; JOHAN		KLEHS & COMPANY; JOHAN		KLEHS & COMPANY; JOHAN		KLEHS & COMPANY; JOHAN		KLEHS & COMPANY; JOHAN		KLEHS & COMPANY; JOHAN		KLEHS & COMPANY; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN
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
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
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
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
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
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
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
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
phon		9165511881		9165511881		9165511881		9165511881		9165511881		9165511881		9165511881		9165511881		9165511881		9165511881		9165511881		9165511881		9165511881		9165511881		9165511881		9165511881		9165511881		9165511881		9165511881		9165511881		9165511881		9165511881		9165511881		9165511881		9165511881		9165511881		9165511881		9165511881		9165511881		9165511881		9165511881		9165511881		9165511881		9165511881		9165511881		9165511881
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
email		None		None		None		None		None		[email protected]		None		None		None		None		None		[email protected]		None		None		None		None		None		[email protected]		None		None		None		None		None		[email protected]		None		None		None		None		None		[email protected]		None		None		None		None		None		[email protected]

Table: filers

filer_id		1295326

Table: lobbying_chg_log

filer_id		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326
change_no		20		15		16		11		18		19		6		21		25		24		22		23		28		27		26		0		29		30		31		32		33		34		35		40		38		41		39		36		37		43		45		44		42		53		46		51		49		50		48		52		47		55		54		56		57		58		59		60		61		62		63
session_id		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2009		2009		2009		2011		2009		2009		2009		2011		2011		2011		2011		2013		2013		2013		2013		2013		2013		2013		2015		2015		2013		2015		2015		2015		2015		2015		2015		2015		2015		2017		2015		2017		2017		2017		2017		2017		2017		2017		2017
log_dt		2007-08-16 00:00:00		2007-02-20 00:00:00		2007-02-20 00:00:00		2007-03-30 00:00:00		2007-05-29 00:00:00		2007-05-29 00:00:00		2007-02-20 00:00:00		2007-11-01 00:00:00		2008-05-02 00:00:00		2008-03-06 00:00:00		2007-11-07 00:00:00		2008-03-05 00:00:00		2009-10-27 00:00:00		2009-07-21 00:00:00		2009-06-17 00:00:00		2011-03-02 00:00:00		2010-05-28 00:00:00		2010-05-28 00:00:00		2010-12-03 00:00:00		2012-01-19 00:00:00		2012-01-20 00:00:00		2012-02-07 00:00:00		2012-07-02 00:00:00		2014-01-28 00:00:00		2013-08-29 00:00:00		2014-02-07 00:00:00		2013-11-15 00:00:00		2013-07-02 00:00:00		2013-07-09 00:00:00		2014-06-03 00:00:00		2015-03-24 00:00:00		2015-01-27 00:00:00		2013-05-17 00:00:00		2015-11-04 00:00:00		2015-07-10 00:00:00		2015-06-26 00:00:00		2015-03-25 00:00:00		2015-05-14 00:00:00		2015-10-14 00:00:00		2015-07-09 00:00:00		2015-09-28 00:00:00		2017-03-24 00:00:00		2016-02-02 00:00:00		2018-01-05 00:00:00		2018-01-05 00:00:00		2018-01-05 00:00:00		2018-01-05 00:00:00		2018-01-05 00:00:00		2018-01-05 00:00:00		2018-01-05 00:00:00		2018-01-05 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		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3
correction_flg		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		None		Y		None		None		None		None		None		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		None		None		None		None		None		None		None		None
action		ADDED		ADDED		ADDED		ADDED		DELETED		DELETED		ADDED		DELETED		ADDED		ADDED		ADDED		DELETED		DELETED		ADDED		DELETED		ADDED		DELETED		ADDED		ADDED		DELETED		ADDED		ADDED		DELETED		ADDED		ADDED		DELETED		DELETED		ADDED		DELETED		DELETED		ADDED		ADDED		ADDED		DELETED		ADDED		TERMINATED		ADDED		DELETED		DELETED		ADDED		DELETED		ADDED		ADDED		DELETED		DELETED		DELETED		DELETED		DELETED		DELETED		DELETED		TERMINATED
attribute_changed		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		LOBBYIST		CLIENT		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		FIRM		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		CLIENT		LOBBYIST		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		LOBBYIST		LOBBYIST		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		LOBBYIST		EMPLOYER		CLIENT		LOBBYIST		CLIENT		LOBBYIST		EMPLOYER		CLIENT		CLIENT
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		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_full_name		KLEHS & COMPANY; JOHAN		KLEHS & COMPANY, JOHAN		KLEHS & COMPANY, JOHAN		KLEHS & COMPANY; JOHAN		KLEHS & COMPANY; JOHAN		KLEHS & COMPANY; JOHAN		KLEHS & COMPANY; JOHAN		KLEHS & COMPANY; JOHAN		KLEHS & COMPANY; JOHAN		KLEHS & COMPANY; JOHAN		KLEHS & COMPANY; JOHAN		KLEHS & COMPANY; JOHAN		KLEHS & COMPANY; JOHAN		KLEHS & COMPANY; JOHAN		KLEHS & COMPANY; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY; JOHAN		KLEHS & COMPANY; JOHAN		KLEHS & COMPANY; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN		KLEHS & COMPANY, INC; JOHAN
filer_city		SACRAMENTO		None		None		None		None		None		None		SACRAMENTO		None		None		SACRAMENTO		None		None		None		None		None		None		None		None		None		None		None		None		None		SACRAMENTO		None		None		None		None		None		None		None		SACRAMENTO		SACRAMENTO		None		SACRAMENTO		SACRAMENTO		SACRAMENTO		None		SACRAMENTO		None		SACRAMENTO		SACRAMENTO		None		None		None		None		None		None		None		None
filer_st		CA		None		None		None		None		None		None		CA		None		None		CA		None		None		None		None		None		None		None		None		None		None		None		None		None		CA		None		None		None		None		None		None		None		CA		CA		None		CA		CA		CA		None		CA		None		CA		CA		None		None		None		None		None		None		None		None
filer_zip		95814		None		None		None		None		None		None		95814		None		None		95814		None		None		None		None		None		None		None		None		None		None		None		None		None		95814		None		None		None		None		None		None		None		95814		95814		None		95814		95814		95814		None		95814		None		95814		95814		None		None		None		None		None		None		None		None
filer_phone		9165511881		None		None		None		None		None		None		9165511881		None		None		9165511881		None		None		None		None		None		None		None		None		None		None		None		None		None		9165511881		None		None		None		None		None		None		None		9165511881		9165511881		None		9165511881		9165511881		9165511881		None		9165511881		None		9165511881		9165511881		None		None		None		None		None		None		None		None
entity_type		2		2		2		2		2		2		4		3		2		2		2		2		3		2		2		2		2		2		2		2		2		2		2		1		4		1		1		1		1		1		2		2		2		2		2		4		4		2		2		2		2		4		2		1		4		1		4		2		1		1		3
entity_name		PAM COMPANY; THE		LIVERMORE AREA RECREATION AND PARK DISTRICT		PLEASANT HILL RECREATION AND PARK DISTRICT		LINEBARGER GOGGAN BLAIR & SAMPSON, LLP		LIVERMORE AREA RECREATION AND PARK DISTRICT		PLEASANT HILL RECREATION AND PARK DISTRICT		KLEHS, JOHAN		APREA & MICHELI		LIVERMORE; CITY OF		PRINTING INDUSTRIES OF CALIFORNIA		ERTEC ENVIRONMENTAL SYSTEMS		ERTEC ENVIRONMENTAL SYSTEMS		CLINE & DUPLISSEA		PAM COMPANY; THE		PAM COMPANY; THE		CAL-STATE EAST BAY FOUNDATION, INC.		PAM COMPANIES; THE		PACIFIC DEVELOPMENT GROUP, INC.		MICHAEL'S DEVELOPMENT COPMANY		MICHAEL'S DEVELOPMENT COMPANY		SD3, LLC		BATARSE FAMILY TRUST		CAL-STATE EAST BAY FOUNDATION, INC.		SANI-STAR, LLC		SMITH, SARA ELIZABETH		PRINTING INDUSTRIES OF CALIFORNIA		DUBLIN UNIFIED SCHOOL DISTRICT		ONTARIO; CITY OF		DEIKEL; THEODORE		SANI-STAR, LLC		EDEN TOWNSHIP HEALTHCARE DISTRICT		MARTIN LUTHER KING, JR. FREEDOM CENTER		DUBLIN UNIFIED SCHOOL DISTRICT		LOMPOC; CITY OF		LOMPOC; CITY OF		THOMAS, CHAY M.		THOMAS, CHAY M.		EDEN TOWNSHIP HEALTHCARE DISTRICT		MARTIN LUTHER KING, JR. FREEDOM CENTER		JOHNSON; GARY AND SANDY		JOHNSON; GARY AND SANDY		FORE, BRANDON		ALECTO HEALTHCARE SERVICES		ALECTO HEALTHCARE SERVICES		BRANDON FORE		HINDERLITER, DE LLAMAS & ASSOCIATES		JOHAN KLEHS		LEADINGAGE CALIFORNIA		ONTARIO; CITY OF		PARAMEDICS PLUS		None
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		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		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		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
entity_id		None		1295736		1295735		1277278		1295736		1295735		1297556		None		1307101		1304688		None		1302374		1234678		1300404		1300404		1337668		1300404		1327903		1334188		1334188		1344486		1345280		1337668		1363149		None		1304688		1327838		1227734		1353664		1363149		1376274		1374775		None		None		1378361		None		None		None		1374775		None		1378380		None		None		1382415		1395479		1236470		1297049		1146781		1227734		1334379		0
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
effect_dt		2007-08-15 00:00:00		2007-02-01 00:00:00		2007-02-01 00:00:00		2007-03-27 00:00:00		2007-03-31 00:00:00		2007-03-31 00:00:00		2007-02-01 00:00:00		2007-09-30 00:00:00		2008-05-01 00:00:00		2008-03-01 00:00:00		2007-11-01 00:00:00		2008-01-31 00:00:00		2009-06-30 00:00:00		2009-07-20 00:00:00		2009-06-15 00:00:00		2011-02-18 00:00:00		2010-05-31 00:00:00		2010-06-01 00:00:00		2010-11-15 00:00:00		2011-12-31 00:00:00		2012-01-18 00:00:00		2012-02-01 00:00:00		2012-06-30 00:00:00		2014-01-23 00:00:00		2013-08-29 00:00:00		2014-02-15 00:00:00		2013-12-06 00:00:00		2013-07-01 00:00:00		2013-02-16 00:00:00		2014-05-31 00:00:00		2015-03-18 00:00:00		2015-01-12 00:00:00		2013-05-15 00:00:00		2015-09-30 00:00:00		2015-07-01 00:00:00		2015-06-26 00:00:00		2015-03-19 00:00:00		2015-05-13 00:00:00		2015-07-31 00:00:00		2015-07-08 00:00:00		2015-09-30 00:00:00		2017-03-16 00:00:00		2016-01-29 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00

Table: received_filings

filer_id		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326		1295326
filing_file_name		1246843_46.cal		1503750_0.cal		1383556_1.cal		1383556_8.cal		1383556_9.cal		178166.cal		1383556_3.cal		1383556_7.cal		1383556_6.cal		1246843_3.cal		1246843_4.cal		2965.cal		2117.cal		1246843_1.cal		346413.cal		102290.cal		1246843_2.cal		1383556_4.cal		1383556_5.cal		196352.cal		1246843_45.cal		147106.cal		1383556_2.cal		1383556_0.cal		475732.cal		1246843_44.cal		1732784_0.cal		1552173_7.cal		1719328_6.cal		1719328_7.cal		1719328_8.cal		1795048_0.cal		1778897_1.cal		1795048_1.cal		1539553_0.cal		1383556_11.cal		1552173_0.cal		1588741_0.cal		1383556_10.cal		1571453_0.cal		1552173_1.cal		1719328_10.cal		1719328_9.cal		1839874_0.cal		1811823_0.cal		1604119_0.cal		498398.cal		1552173_2.cal		1588741_1.cal		1719328_4.cal		1719328_2.cal		142016.cal		1719328_3.cal		1778897_0.cal		1719328_1.cal		1719328_5.cal		1619134_0.cal		1552173_4.cal		1552173_3.cal		1552173_5.cal		1632097_0.cal		289453.cal		1707122_0.cal		1552173_8.cal		1552173_9.cal		1552173_10.cal		1719328_0.cal		1654031_0.cal		1552173_6.cal		1674655_0.cal		1864617_0.cal		1719328_11.cal		1918421_4.cal		1918421_9.cal		1918421_6.cal		1918421_7.cal		1918421_8.cal		1918421_5.cal		1978299_0.cal		2123818_0.cal		2116837_1.cal		2116837_2.cal		2059439_0.cal		1918421_12.cal		2008051_0.cal		1992606_0.cal		1918421_18.cal		1918421_19.cal		2116837_0.cal		2088035_0.cal		1719328_12.cal		2027792_0.cal		1918421_14.cal		1918421_15.cal		1918421_13.cal		1918421_16.cal		1931112_0.cal		1900897_0.cal		1918421_1.cal		1918421_0.cal		1719328_13.cal		1918421_10.cal		1918421_11.cal		378546.cal		1918421_3.cal		1918421_2.cal		2168665_0.cal		2116837_3.cal		2232668_0.cal		2187432_0.cal		2204101_0.cal		2116837_4.cal
received_date		2008-05-15 00:00:00		2010-07-27 00:00:00		2009-01-14 00:00:00		2010-05-28 00:00:00		2010-05-28 00:00:00		2010-05-28 00:00:00		2009-06-18 00:00:00		2010-01-08 00:00:00		2009-10-30 00:00:00		2007-05-29 00:00:00		2007-05-29 00:00:00		2007-02-21 00:00:00		2007-02-21 00:00:00		2007-04-02 00:00:00		2010-06-01 00:00:00		2007-11-02 00:00:00		2007-05-01 00:00:00		2009-07-29 00:00:00		2009-08-06 00:00:00		2007-11-09 00:00:00		2008-03-11 00:00:00		2007-08-17 00:00:00		2009-02-26 00:00:00		2008-12-11 00:00:00		2008-03-06 00:00:00		2008-03-06 00:00:00		2013-01-25 00:00:00		2012-07-31 00:00:00		2013-08-28 00:00:00		2013-11-06 00:00:00		2013-11-15 00:00:00		2013-10-17 00:00:00		2013-11-05 00:00:00		2013-11-05 00:00:00		2010-10-30 00:00:00		2010-12-06 00:00:00		2010-12-20 00:00:00		2011-04-27 00:00:00		2010-11-03 00:00:00		2011-01-31 00:00:00		2011-03-03 00:00:00		2014-02-07 00:00:00		2014-01-28 00:00:00		2014-04-21 00:00:00		2014-01-22 00:00:00		2011-07-27 00:00:00		2011-06-24 00:00:00		2011-06-24 00:00:00		2011-06-21 00:00:00		2013-07-02 00:00:00		2013-05-17 00:00:00		2013-04-23 00:00:00		2013-06-26 00:00:00		2013-07-26 00:00:00		2013-04-25 00:00:00		2013-07-09 00:00:00		2011-10-24 00:00:00		2012-01-20 00:00:00		2012-01-20 00:00:00		2012-02-07 00:00:00		2012-01-26 00:00:00		2012-11-15 00:00:00		2012-10-30 00:00:00		2012-11-15 00:00:00		2012-11-15 00:00:00		2012-11-27 00:00:00		2012-12-20 00:00:00		2012-04-24 00:00:00		2012-07-02 00:00:00		2012-07-25 00:00:00		2014-07-21 00:00:00		2014-06-03 00:00:00		2015-05-14 00:00:00		2015-09-28 00:00:00		2015-07-09 00:00:00		2015-07-10 00:00:00		2015-08-24 00:00:00		2015-06-26 00:00:00		2015-07-28 00:00:00		2017-01-25 00:00:00		2017-02-16 00:00:00		2017-03-24 00:00:00		2016-07-27 00:00:00		2015-11-04 00:00:00		2016-01-27 00:00:00		2015-10-20 00:00:00		2016-12-01 00:00:00		2016-12-13 00:00:00		2017-01-03 00:00:00		2016-10-12 00:00:00		2014-08-12 00:00:00		2016-04-12 00:00:00		2016-02-02 00:00:00		2016-04-04 00:00:00		2016-02-02 00:00:00		2016-04-14 00:00:00		2015-01-27 00:00:00		2014-10-20 00:00:00		2015-01-27 00:00:00		2014-12-15 00:00:00		2014-11-14 00:00:00		2015-10-14 00:00:00		2015-10-14 00:00:00		2015-04-28 00:00:00		2015-03-25 00:00:00		2015-03-24 00:00:00		2017-07-19 00:00:00		2017-06-29 00:00:00		2018-04-18 00:00:00		2017-10-11 00:00:00		2018-01-22 00:00:00		2018-01-08 00:00:00
filing_directory		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/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		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/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/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		1246843		1503750		1383556		1383556		1383556		None		1383556		1383556		1383556		1246843		1246843		None		None		1246843		None		None		1246843		1383556		1383556		None		1246843		None		1383556		1383556		None		1246843		1732784		1552173		1719328		1719328		1719328		1795048		1778897		1795048		1539553		1383556		1552173		1588741		1383556		1571453		1552173		1719328		1719328		1839874		1811823		1604119		None		1552173		1588741		1719328		1719328		None		1719328		1778897		1719328		1719328		1619134		1552173		1552173		1552173		1632097		None		1707122		1552173		1552173		1552173		1719328		1654031		1552173		1674655		1864617		1719328		1918421		1918421		1918421		1918421		1918421		1918421		1978299		2123818		2116837		2116837		2059439		1918421		2008051		1992606		1918421		1918421		2116837		2088035		1719328		2027792		1918421		1918421		1918421		1918421		1931112		1900897		1918421		1918421		1719328		1918421		1918421		None		1918421		1918421		2168665		2116837		2232668		2187432		2204101		2116837
form_id		F601		F625		F601		F601		F601		None		F601		F601		F601		F601		F601		None		None		F601		None		None		F601		F601		F601		None		F601		None		F601		F601		None		F601		F625		F601		F601		F601		F601		F625		F625		F625		F625		F601		F601		F625		F601		F625		F601		F601		F601		F625		F625		F625		None		F601		F625		F601		F601		None		F601		F625		F601		F601		F625		F601		F601		F601		F625		None		F625		F601		F601		F601		F601		F625		F601		F625		F625		F601		F601		F601		F601		F601		F601		F601		F625		F625		F601		F601		F625		F601		F625		F625		F601		F601		F601		F625		F601		F625		F601		F601		F601		F601		F625		F625		F601		F601		F601		F601		F601		None		F601		F601		F625		F601		F625		F625		F625		F601
receive_comment		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing passed validation, but failed DB constraints		Filing accepted		Filing did not pass validation		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 accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted