OpenCalAccess

Filer ID: 1297049

Table: cvr_lobby_disclosure
filing_id	1282113	1262158	1369918	1346804	1296035	1327731	1307851	1432649	1450115	1390746	1418955	1503751	1482743	1461816	1539555	1619135	1604121	1571459	1588745	1632100	1707123	1674656	1654034	1732786	1778900	1761915	1795065	1778900	1761915	1811825	1900898	1864621	1839878	1931118	1992607	1978309	1963464	2059440	2088036	2008053	2027793	2168671	2152291	2123821	2187434	2204102
amend_id	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
rec_type	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR
form_type	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615
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
filer_id	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049
entity_cd	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY
filer_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
filer_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
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
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
report_num	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	001	001	000	000	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-04-30 00:00:00	2008-10-23 00:00:00	2008-07-28 00:00:00	2007-10-29 00:00:00	2008-04-28 00:00:00	2008-01-28 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-11-28 00:00:00	2010-10-30 00:00:00	2011-10-24 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	2012-01-25 00:00:00	2013-08-22 00:00:00	2013-08-20 00:00:00	2013-10-10 00:00:00	2013-07-13 00:00:00	2013-04-25 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-01-19 00:00:00
from_date	2007-04-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	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-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-04-01 00:00:00	2013-01-01 00:00:00	2013-07-01 00:00:00	2013-04-01 00:00:00	2013-01-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	2017-10-01 00:00:00
thru_date	2007-06-30 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	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-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-06-30 00:00:00	2013-03-31 00:00:00	2013-09-30 00:00:00	2013-06-30 00:00:00	2013-03-31 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	2017-12-31 00:00:00
cum_beg_dt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
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
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, 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	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
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	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
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
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
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
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
sig_date	2007-07-26 00:00:00	2007-04-25 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	2008-01-17 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-07-21 00:00:00	2011-01-20 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-07-13 00:00:00	2013-04-25 00:00:00	2013-10-10 00:00:00	2013-07-13 00:00:00	2013-04-25 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-01-19 00:00:00
sig_loc	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento, CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA
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
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
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
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
prn_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	Klehs	Klehs	Klehs	Klehs	Klehs	Klehs	Klehs	Klehs	Klehs	Klehs	Klehs	Klehs	Klehs	Klehs	Klehs	Klehs	Klehs	Klehs	Klehs	Klehs	Klehs	Klehs
prn_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	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
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
sig_title	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Lobbyist	Lobbyist	Lobbyist	Owner	Owner	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist	Lobbyist
nopart1_cb	None	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X
nopart2_cb	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X
part1_1_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
part1_2_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
ctrib_n_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
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
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
lobby_n_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
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
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
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
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
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
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
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

Table: cvr_registration
filing_id	1255055	1255055	1383553	1383553	1552140	1552140	1719329	1918422	2116836	2200648
amend_id	1	0	0	1	0	1	0	0	0	0
rec_type	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR
form_type	F604	F604	F604	F604	F604	F604	F604	F604	F604	F606
sender_id	1295326	1295326	1295326	1295326	1295326	1295326	1295326	1295326	1295326	1295326
filer_id	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049
entity_cd	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY
filer_naml	Klehs	Klehs	Klehs	Klehs	Klehs	Klehs	Klehs	Klehs	Klehs	Klehs
filer_namf	Johan	Johan	Johan	Johan	Johan	Johan	Johan	Johan	Johan	Johan
filer_namt	None	None	None	None	None	None	None	None	None	None
filer_nams	None	None	None	None	None	None	None	None	None	None
report_num	001	000	000	001	000	001	000	000	000	000
rpt_date	2007-05-29 00:00:00	2007-03-30 00:00:00	2008-12-11 00:00:00	2009-03-11 00:00:00	2010-12-20 00:00:00	2011-06-17 00:00:00	2013-01-01 00:00:00	2015-01-01 00:00:00	2018-12-31 00:00:00	2017-12-31 00:00:00
ls_beg_yr	2007	2007	2009	2009	2011	2009	2013	2015	2017	2017
ls_end_yr	2008	2008	2010	2010	2012	2010	2014	2016	2018	2018
qual_date	None	None	None	None	None	None	None	None	None	None
eff_date	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
bus_st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA
bus_zip4	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814
bus_phon	(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
bus_fax	None	None	None	None	None	None	None	None	None	None
bus_email	None	None	None	None	None	None	None	None	[email protected]	[email protected]
mail_city	Sacramento	Sacramento	Sacramento	Sacramento	None	Sacramento	None	None	None	None
mail_st	CA	CA	CA	CA	None	CA	None	None	None	None
mail_zip4	95814	95814	95814	95814	None	95814	None	None	None	None
mail_phon	None	None	None	None	None	None	None	None	None	None
sig_date	2007-05-29 00:00:00	2007-02-20 00:00:00	2008-12-02 00:00:00	2009-01-16 00:00:00	2010-12-16 00:00:00	2011-06-15 00:00:00	2012-12-30 00:00:00	2014-12-04 00:00:00	2016-12-20 00:00:00	2017-12-20 00:00:00
sig_loc	None	None	None	None	Sacramento CA	None	Sacramento CA	Sacramento CA	Sacramento CA	Sacramento CA
sig_naml	Klehs	Klehs	Klehs	Klehs	Klehs	Klehs	Klehs	Klehs	Klehs	Klehs
sig_namf	Johan	Johan	Johan	Johan	Johan	Johan	Johan	Johan	Johan	Johan
sig_namt	None	None	None	None	None	None	None	None	None	None
sig_nams	None	None	None	None	None	None	None	None	None	None
prn_naml	None	None	None	None	Klehs	None	Klehs	Klehs	Klehs	Klehs
prn_namf	None	None	None	None	Johan	None	Johan	Johan	Johan	Johan
prn_namt	None	None	None	None	None	None	None	None	None	None
prn_nams	None	None	None	None	None	None	None	None	None	None
sig_title	None	None	None	None	Owner	None	None	None	None	Lobbyist
stmt_firm	None	None	None	None	None	None	None	None	None	None
ind_cb	None	None	None	None	None	None	None	None	None	None
bus_cb	None	None	None	None	None	None	None	None	None	None
trade_cb	None	None	None	None	None	None	None	None	None	None
oth_cb	None	None	None	None	None	None	None	None	None	None
a_b_name	None	None	None	None	None	None	None	None	None	None
a_b_city	None	None	None	None	None	None	None	None	None	None
a_b_st	None	None	None	None	None	None	None	None	None	None
a_b_zip4	None	None	None	None	None	None	None	None	None	None
descrip_1	None	None	None	None	None	None	None	None	None	None
descrip_2	None	None	None	None	None	None	None	None	None	None
c_less50	None	None	None	None	None	None	None	None	None	None
c_more50	None	None	None	None	None	None	None	None	None	None
ind_class	None	None	None	None	None	None	None	None	None	None
ind_descr	None	None	None	None	None	None	None	None	None	None
bus_class	None	None	None	None	None	None	None	None	None	None
bus_descr	None	None	None	None	None	None	None	None	None	None
auth_name	None	None	None	None	None	None	None	None	None	None
auth_city	None	None	None	None	None	None	None	None	None	None
auth_st	None	None	None	None	None	None	None	None	None	None
auth_zip4	None	None	None	None	None	None	None	None	None	None
lobby_int	None	None	None	None	None	None	None	None	None	None
influen_yn	None	None	None	None	None	None	None	None	None	None
firm_name	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.
newcert_cb	None	X	None	None	None	None	None	None	None	None
rencert_cb	None	None	X	None	X	None	None	None	None	None
complet_dt	2007-04-19 00:00:00	None	None	2009-01-16 00:00:00	None	2011-01-13 00:00:00	2012-11-08 00:00:00	2014-11-13 00:00:00	2016-11-17 00:00:00	None
lby_reg_cb	X	X	X	X	X	X	X	X	X	None
lby_604_cb	None	None	None	None	None	None	None	None	None	None
st_leg_yn	None	None	None	None	None	None	None	None	None	None
st_agency	None	None	None	None	None	None	None	None	None	None
lobby_cb	None	None	None	None	None	None	None	None	None	None
l_firm_cb	None	None	None	None	None	None	None	None	None	None

Table: filer_address
filer_id	1297049	1297049	1297049	1297049	1297049	1297049
adrid	2121706	2160482	2203965	2278569	2341759	2410989
effect_dt	2007-02-01 00:00:00	2009-01-01 00:00:00	2011-01-01 00:00:00	2013-01-01 00:00:00	2015-01-01 00:00:00	2017-01-01 00:00:00
add_type	7051	7051	7051	7051	7051	7051
session_id	2007	2009	2011	2013	2015	2017

Table: filer_ethics_class
filer_id	1297049	1297049	1297049	1297049	1297049	1297049
session_id	2009	2007	2011	2013	2015	2017
ethics_date	2009-01-16 00:00:00	2007-04-19 00:00:00	2011-01-13 00:00:00	2012-11-08 00:00:00	2014-11-13 00:00:00	2016-11-17 00:00:00

Table: filer_filings
filer_id	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049
filing_id	1255055	1265630	1265628	1265630	1255055	1282113	1262158	1296035	1778900	1761915	1778900	1978309	1963464	1864621	1795065	1950288	1900898	1307851	1327731	1346804	1369918	1390746	1383553	1418955	1410051	1410133	1383553	1450115	1432649	1482743	1461816	1503751	1539555	1552140	1552140	1552374	1598200	1571459	1588745	1632100	1604121	1619135	1654034	1811825	1674656	1931118	1918422	1719329	1707123	1726360	1732786	1839878	1761915	1992607	2187434	2008053	2027793	2059440	2088036	2116836	2123821	2152291	2142695	2168671	2200548	2204102	2200648
period_id	189	None	None	None	190	190	189	191	214	213	214	222	221	218	215	None	219	192	193	194	195	196	196	197	None	None	197	199	198	201	200	202	203	204	206	None	None	204	205	208	206	207	209	216	210	220	221	213	211	None	212	217	213	223	231	224	225	226	227	236	228	229	None	230	None	232	232
form_id	F604	F602	F604	F602	F604	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F604	F615	F615	F615	F615	F615	F615	F604	F615	F604	F604	F604	F615	F615	F615	F615	F615	F615	F604	F604	F604	F604	F615	F615	F615	F615	F615	F615	F615	F615	F615	F604	F604	F615	F604	F615	F615	F615	F615	F615	F615	F615	F615	F615	F604	F615	F615	F604	F615	F606	F615	F606
filing_sequence	0	1	0	0	1	0	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
filing_date	2007-03-30 00:00:00	2007-05-29 00:00:00	2007-04-19 00:00:00	2007-02-20 00:00:00	2007-05-29 00:00:00	2007-07-27 00:00:00	2007-04-30 00:00:00	2007-10-29 00:00:00	2013-08-28 00:00:00	2013-08-29 00:00:00	2013-07-26 00:00:00	2015-07-28 00:00:00	2015-04-28 00:00:00	2014-07-21 00:00:00	2013-10-17 00:00:00	2014-12-15 00:00:00	2014-10-20 00:00:00	2008-01-29 00:00:00	2008-04-28 00:00:00	2008-07-28 00:00:00	2008-10-23 00:00:00	2009-01-21 00:00:00	2008-12-11 00:00:00	2009-04-27 00:00:00	2008-12-05 00:00:00	2009-01-16 00:00:00	2009-03-11 00:00:00	2009-10-27 00:00:00	2009-07-22 00:00:00	2010-04-27 00:00:00	2010-01-28 00:00:00	2010-07-27 00:00:00	2010-10-30 00:00:00	2010-12-20 00:00:00	2011-06-17 00:00:00	2010-12-17 00:00:00	2011-06-16 00:00:00	2011-01-31 00:00:00	2011-04-27 00:00:00	2012-01-26 00:00:00	2011-07-27 00:00:00	2011-10-24 00:00:00	2012-04-24 00:00:00	2014-01-22 00:00:00	2012-07-25 00:00:00	2015-01-27 00:00:00	2014-12-15 00:00:00	2012-12-20 00:00:00	2012-10-30 00:00:00	2012-12-20 00:00:00	2013-01-25 00:00:00	2014-04-21 00:00:00	2013-04-25 00:00:00	2015-10-20 00:00:00	2017-10-11 00:00:00	2016-01-27 00:00:00	2016-04-12 00:00:00	2016-07-27 00:00:00	2016-10-12 00:00:00	2017-01-03 00:00:00	2017-01-25 00:00:00	2017-04-21 00:00:00	2016-12-30 00:00:00	2017-07-19 00:00:00	2018-01-05 00:00:00	2018-01-22 00:00:00	2018-01-08 00:00:00
stmnt_type	10001	10006	10006	10005	10002	10001	10001	10001	10002	10002	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10005	10006	10002	10001	10001	10001	10001	10001	10001	10001	10002	10005	10006	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10005	10001	10001
stmnt_status	11003	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003
session_id	2007	2007	2007	2007	2007	2007	2007	2007	2013	2013	2013	2015	2015	2013	2013	2015	2013	2007	2007	2007	2007	2007	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2011	2009	2011	2011	2009	2011	2011	2011	2011	2011	2013	2011	2013	2015	2013	2011	2013	2011	2013	2013	2015	2017	2015	2015	2015	2015	2017	2015	2017	2017	2017	2017	2017	2017
user_id	*	CFLAGG	SARRIAGA	SARRIAGA	*	YRODRIGU	YRODRIGU	YRODRIGU	ASAETERN	ASAETERN	ASAETERN	JINGRAM	JINGRAM	ASAETERN	ASAETERN	PBANFORD	ASAETERN	YRODRIGU	YRODRIGU	LTHIBAUL	CFLAGG	CFLAGG	YRODRIGU	CFLAGG	YRODRIGU	YRODRIGU	YRODRIGU	CFLAGG	CFLAGG	CFLAGG	CFLAGG	ASAETERN	ASAETERN	YRODRIGU	YRODRIGU	GKURIMOT	YRODRIGU	ASAETERN	JINGRAM	ASAETERN	ASAETERN	ASAETERN	ASAETERN	ASAETERN	AGLADNEY	AGLADNEY	PBANFORD	SARRIAGA	ASAETERN	SARRIAGA	ASAETERN	ASAETERN	ASAETERN	JINGRAM	SMCCONNAN	AGLADNEY	AGLADNEY	AGLADNEY	JINGRAM	SARRIAGA	AGLADNEY	SMCCONNAN	SARRIAGA	SMCCONNAN	GPEREZ	CAFILER	CAFILER
special_audit	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003
fine_audit	11003	11003	11003	11003	11003	11003	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11001	11001	11003	11001	11003	11003	11003
rpt_start	2007-03-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2007-05-29 00:00:00	2007-04-01 00:00:00	2007-01-01 00:00:00	2007-07-01 00:00:00	2013-04-01 00:00:00	2013-01-01 00:00:00	2013-04-01 00:00:00	2015-04-01 00:00:00	2015-01-01 00:00:00	2014-04-01 00:00:00	2013-07-01 00:00:00	1900-01-01 00:00:00	2014-07-01 00:00:00	2007-10-01 00:00:00	2008-01-01 00:00:00	2008-04-01 00:00:00	2008-07-01 00:00:00	2008-10-01 00:00:00	2008-12-11 00:00:00	2009-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2009-03-11 00:00:00	2009-07-01 00:00:00	2009-04-01 00:00:00	2010-01-01 00:00:00	2009-10-01 00:00:00	2010-04-01 00:00:00	2010-07-01 00:00:00	2010-12-20 00:00:00	2011-06-17 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2010-10-01 00:00:00	2011-01-01 00:00:00	2011-10-01 00:00:00	2011-04-01 00:00:00	2011-07-01 00:00:00	2012-01-01 00:00:00	2013-10-01 00:00:00	2012-04-01 00:00:00	2014-10-01 00:00:00	2015-01-01 00:00:00	2013-01-01 00:00:00	2012-07-01 00:00:00	1900-01-01 00:00:00	2012-10-01 00:00:00	2014-01-01 00:00:00	2013-01-01 00:00:00	2015-07-01 00:00:00	2017-07-01 00:00:00	2015-10-01 00:00:00	2016-01-01 00:00:00	2016-04-01 00:00:00	2016-07-01 00:00:00	2018-12-31 00:00:00	2016-10-01 00:00:00	2017-01-01 00:00:00	1900-01-01 00:00:00	2017-04-01 00:00:00	1900-01-01 00:00:00	2017-10-01 00:00:00	2017-12-31 00:00:00
rpt_end	2007-03-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2007-05-29 00:00:00	2007-06-30 00:00:00	2007-03-31 00:00:00	2007-09-30 00:00:00	2013-06-30 00:00:00	2013-03-31 00:00:00	2013-06-30 00:00:00	2015-06-30 00:00:00	2015-03-31 00:00:00	2014-06-30 00:00:00	2013-09-30 00:00:00	1900-01-01 00:00:00	2014-09-30 00:00:00	2007-12-31 00:00:00	2008-03-31 00:00:00	2008-06-30 00:00:00	2008-09-30 00:00:00	2008-12-31 00:00:00	2008-12-11 00:00:00	2009-03-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2009-03-11 00:00:00	2009-09-30 00:00:00	2009-06-30 00:00:00	2010-03-31 00:00:00	2009-12-31 00:00:00	2010-06-30 00:00:00	2010-09-30 00:00:00	2010-12-20 00:00:00	2011-06-17 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2010-12-31 00:00:00	2011-03-31 00:00:00	2011-12-31 00:00:00	2011-06-30 00:00:00	2011-09-30 00:00:00	2012-03-31 00:00:00	2013-12-31 00:00:00	2012-06-30 00:00:00	2014-12-31 00:00:00	2015-01-01 00:00:00	2013-01-01 00:00:00	2012-09-30 00:00:00	1900-01-01 00:00:00	2012-12-31 00:00:00	2014-03-31 00:00:00	2013-03-31 00:00:00	2015-09-30 00:00:00	2017-09-30 00:00:00	2015-12-31 00:00:00	2016-03-31 00:00:00	2016-06-30 00:00:00	2016-09-30 00:00:00	2018-12-31 00:00:00	2016-12-31 00:00:00	2017-03-31 00:00:00	1900-01-01 00:00:00	2017-06-30 00:00:00	1900-01-01 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
filing_type	22001	None	None	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	None	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	None	22001	22001

Table: filer_to_filer_type
filer_id	1297049	1297049	1297049	1297049	1297049	1297049	1297049
filer_type	4	4	4	4	4	4	4
active	Y	Y	Y	Y	T	Y	Y
race	None	None	0	None	None	None	None
session_id	2011	2013	2007	2009	2017	2015	2017
category	None	None	0	None	None	None	None
category_type	None	None	0	None	None	None	None
sub_category	None	None	0	None	None	None	None
effect_dt	2011-01-01 00:00:00	2013-01-01 00:00:00	2007-02-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	None	None	0	None	None	None	None
election_type	None	None	0	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	None	None	0	None	None	None	None
county_cd	None	None	0	None	None	None	None
district_cd	None	None	0	None	None	None	None

Table: filer_xref
filer_id		1297049
xref_id		1297049
effect_dt		2007-03-30 00:00:00
migration_source		CLAIMS

Table: filername
xref_filer_id	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049
filer_id	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049
filer_type	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST
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	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
namf	JOHAN	JOHAN	JOHAN	JOHAN	JOHAN	JOHAN	JOHAN M.	JOHAN M.	JOHAN M.	JOHAN M.	JOHAN M.	JOHAN M.	JOHAN	JOHAN	JOHAN	JOHAN	JOHAN	JOHAN	JOHAN	JOHAN	JOHAN	JOHAN	JOHAN	JOHAN	JOHAN	JOHAN	JOHAN	JOHAN	JOHAN	JOHAN	JOHAN	JOHAN	JOHAN	JOHAN	JOHAN	JOHAN
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	9164447114						9164447114						9164447114						9164447114						9164447114						9164447114
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		1297049

Table: lobbying_chg_log
filer_id	1297049	1297049	1297049
change_no	0	1	2
session_id	2007	2017	2017
log_dt	2007-02-20 00:00:00	2018-01-05 00:00:00	2018-01-05 00:00:00
filer_type	4	4	4
correction_flg	Y	None	None
action	ADDED	DELETED	TERMINATED
attribute_changed	FIRM	FIRM
ethics_dt	None	None	None
interests	None	None	None
filer_full_name	KLEHS, JOHAN M.	JOHAN KLEHS	KLEHS, JOHAN
filer_city	None	None	None
filer_st	None	None	None
filer_zip	None	None	None
filer_phone	None	None	None
entity_type	3	3	4
entity_name	KLEHS & COMPANY, JOHAN	KLEHS & COMPANY, INC; JOHAN	None
entity_city	None	None	None
entity_st	None	None	None
entity_zip	None	None	None
entity_phone	None	None	None
entity_id	1295326	1295326	0
responsible_officer	None	None	None
effect_dt	2007-02-01 00:00:00	2017-12-31 00:00:00	2017-12-31 00:00:00

Table: received_filings
filer_id	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049	1297049
filing_file_name	1503751_0.cal	1383553_1.cal	1418955_0.cal	1390746_0.cal	1327731_0.cal	1461816_0.cal	1482743_0.cal	1369918_0.cal	161109.cal	160334.cal	1255055_1.cal	1255055_0.cal	1282113_0.cal	1262158_0.cal	1432649_0.cal	1450115_0.cal	1296035_0.cal	1383553_0.cal	1346804_0.cal	1307851_0.cal	1732786_0.cal	1778900_1.cal	1795065_0.cal	1761915_1.cal	1539555_0.cal	136802.cal	137196.cal	1552140_0.cal	1588745_0.cal	1571459_0.cal	1552140_1.cal	1811825_0.cal	1839878_0.cal	1604121_0.cal	398450.cal	1778900_0.cal	1761915_0.cal	1619135_0.cal	1632100_0.cal	1707123_0.cal	1719329_0.cal	1654034_0.cal	1674656_0.cal	1864621_0.cal	1978309_0.cal	2123821_0.cal	2152291_0.cal	2059440_0.cal	2008053_0.cal	1992607_0.cal	2116836_0.cal	2088036_0.cal	2027793_0.cal	1931118_0.cal	1900898_0.cal	1918422_0.cal	1963464_0.cal	2168671_0.cal	2187434_0.cal	2204102_0.cal	2200648_0.cal
received_date	2010-07-27 00:00:00	2009-03-11 00:00:00	2009-04-27 00:00:00	2009-01-21 00:00:00	2008-04-28 00:00:00	2010-01-28 00:00:00	2010-04-27 00:00:00	2008-10-23 00:00:00	2007-05-29 00:00:00	2007-05-29 00:00:00	2007-05-29 00:00:00	2007-03-30 00:00:00	2007-07-27 00:00:00	2007-04-30 00:00:00	2009-07-22 00:00:00	2009-10-27 00:00:00	2007-10-29 00:00:00	2008-12-11 00:00:00	2008-07-28 00:00:00	2008-01-29 00:00:00	2013-01-25 00:00:00	2013-08-28 00:00:00	2013-10-17 00:00:00	2013-08-29 00:00:00	2010-10-30 00:00:00	2010-12-20 00:00:00	2010-12-20 00:00:00	2010-12-20 00:00:00	2011-04-27 00:00:00	2011-01-31 00:00:00	2011-06-17 00:00:00	2014-01-22 00:00:00	2014-04-21 00:00:00	2011-07-27 00:00:00	2011-06-17 00:00:00	2013-07-26 00:00:00	2013-04-25 00:00:00	2011-10-24 00:00:00	2012-01-26 00:00:00	2012-10-30 00:00:00	2012-12-20 00:00:00	2012-04-24 00:00:00	2012-07-25 00:00:00	2014-07-21 00:00:00	2015-07-28 00:00:00	2017-01-25 00:00:00	2017-04-21 00:00:00	2016-07-27 00:00:00	2016-01-27 00:00:00	2015-10-20 00:00:00	2017-01-03 00:00:00	2016-10-12 00:00:00	2016-04-12 00:00:00	2015-01-27 00:00:00	2014-10-20 00:00:00	2014-12-15 00:00:00	2015-04-28 00:00:00	2017-07-19 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/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/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/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/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
filing_id	1503751	1383553	1418955	1390746	1327731	1461816	1482743	1369918	None	None	1255055	1255055	1282113	1262158	1432649	1450115	1296035	1383553	1346804	1307851	1732786	1778900	1795065	1761915	1539555	None	None	1552140	1588745	1571459	1552140	1811825	1839878	1604121	None	1778900	1761915	1619135	1632100	1707123	1719329	1654034	1674656	1864621	1978309	2123821	2152291	2059440	2008053	1992607	2116836	2088036	2027793	1931118	1900898	1918422	1963464	2168671	2187434	2204102	2200648
form_id	F615	F604	F615	F615	F615	F615	F615	F615	None	None	F604	F604	F615	F615	F615	F615	F615	F604	F615	F615	F615	F615	F615	F615	F615	None	None	F604	F615	F615	F604	F615	F615	F615	None	F615	F615	F615	F615	F615	F604	F615	F615	F615	F615	F615	F615	F615	F615	F615	F604	F615	F615	F615	F615	F604	F615	F615	F615	F615	F606
receive_comment	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing 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 passed validation, but failed DB constraints	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