OpenCalAccess

Filer ID: 1336512

Table: cvr_lobby_disclosure
filing_id	1632978	1620547	1605904	1589249	1701498	1676204	1656436	1737808	1800973	1783028	1764721	1870737	1906234	1845568	1819201	1981232	1935490	1961760	1997623	2057894	2034843	2008513	2100549	2175231	2155984	2129130	2192341	2192341	2210651	2471832	2441471	2529704	2552357	2486332	2664891	2696931	2730598
amend_id	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	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
form_type	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635
sender_id	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512
filer_id	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512
entity_cd	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM
filer_naml	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL
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
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
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
report_num	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	001	000	000	000	000	000	000	000	000	000
rpt_date	2012-01-14 00:00:00	2011-10-11 00:00:00	2011-07-12 00:00:00	2011-04-11 00:00:00	2012-10-15 00:00:00	2012-07-13 00:00:00	2012-04-13 00:00:00	2013-01-23 00:00:00	2013-10-24 00:00:00	2013-07-26 00:00:00	2013-04-19 00:00:00	2014-07-23 00:00:00	2014-10-22 00:00:00	2014-04-23 00:00:00	2014-01-29 00:00:00	2015-07-27 00:00:00	2015-01-23 00:00:00	2015-04-24 00:00:00	2015-10-26 00:00:00	2016-07-22 00:00:00	2016-04-23 00:00:00	2016-01-21 00:00:00	2016-10-23 00:00:00	2017-07-21 00:00:00	2017-04-26 00:00:00	2017-01-27 00:00:00	2017-10-25 00:00:00	2017-11-02 00:00:00	2018-01-31 00:00:00	2020-04-30 00:00:00	2020-01-31 00:00:00	2020-11-01 00:00:00	2021-01-31 00:00:00	2020-07-31 00:00:00	2022-04-11 00:00:00	2022-07-07 00:00:00	2022-10-10 00:00:00
from_date	2011-10-01 00:00:00	2011-07-01 00:00:00	2011-04-01 00:00:00	2011-01-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	2014-04-01 00:00:00	2014-07-01 00:00:00	2014-01-01 00:00:00	2013-10-01 00:00:00	2015-04-01 00:00:00	2014-10-01 00:00:00	2015-01-01 00:00:00	2015-07-01 00:00:00	2016-04-01 00:00:00	2016-01-01 00:00:00	2015-10-01 00:00:00	2016-07-01 00:00:00	2017-04-01 00:00:00	2017-01-01 00:00:00	2016-10-01 00:00:00	2017-07-01 00:00:00	2017-07-01 00:00:00	2017-10-01 00:00:00	2020-01-01 00:00:00	2019-10-01 00:00:00	2020-07-01 00:00:00	2020-10-01 00:00:00	2020-04-01 00:00:00	2022-01-01 00:00:00	2022-04-01 00:00:00	2022-07-01 00:00:00
thru_date	2011-12-31 00:00:00	2011-09-30 00:00:00	2011-06-30 00:00:00	2011-03-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	2014-06-30 00:00:00	2014-09-30 00:00:00	2014-03-31 00:00:00	2013-12-31 00:00:00	2015-06-30 00:00:00	2014-12-31 00:00:00	2015-03-31 00:00:00	2015-09-30 00:00:00	2016-06-30 00:00:00	2016-03-31 00:00:00	2015-12-31 00:00:00	2016-09-30 00:00:00	2017-06-30 00:00:00	2017-03-31 00:00:00	2016-12-31 00:00:00	2017-09-30 00:00:00	2017-09-30 00:00:00	2017-12-31 00:00:00	2020-03-31 00:00:00	2019-12-21 00:00:00	2020-09-30 00:00:00	2020-12-21 00:00:00	2020-06-30 00:00:00	2022-03-31 00:00:00	2022-06-30 00:00:00	2022-09-30 00:00:00
cum_beg_dt	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2015-01-01 00:00:00	2013-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	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	2020-01-01 00:00:00	2019-10-01 00:00:00	2020-01-01 00:00:00	2020-01-01 00:00:00	2020-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2022-01-10 00:00:00
firm_id	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1266243	1266243	1266243	1266243	1266243	1266243	None	None	None	None	None	None	None	None
firm_name	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CalDesal	CAPITOL CASINO	CAPITOL CASINO	CAPITOL CASINO	CAPITOL CASINO	CAPITOL CASINO	CAPITOL CASINO	None	None	None	None	None	None	None	None
firm_city	Sacramento	Sacramento	Costa Mesa	Costa Mesa	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO
firm_st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA
firm_zip4	95814	95814	92627	92627	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95833	95814	95814	95833	95814	95814	95814	95814	95814	95814	95833	95833	95833	95833	95833	95833	95833	95833
firm_phon	916-492-6082	916-492-6082	949-631-1200	949-631-1200	916-492-6082	916-492-6082	916-492-6082	916-492-6082	916-492-6082	916-492-6082	916-492-6082	916-492-6082	916-492-6082	916-492-6082	916-492-6082	916-492-6082	916-492-6082	916-492-6082	916-492-6082	916-492-6082	916-492-6082	916-492-6082	916-492-6082	(916) 492-6082	(916) 492-6082	(916) 492-6082	(916) 492-6082	(916) 492-6082	(916) 492-6082	9162394099	9162394099	9162394099	9162394099	9162394099	9162394099	9162394099	9162394099
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
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
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
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
sig_date	2012-01-17 00:00:00	2011-10-12 00:00:00	2011-07-12 00:00:00	2011-04-25 00:00:00	2012-10-16 00:00:00	2012-07-16 00:00:00	2012-04-17 00:00:00	2013-01-23 00:00:00	2013-10-25 00:00:00	2013-07-26 00:00:00	2013-04-19 00:00:00	2014-07-24 00:00:00	2014-10-22 00:00:00	2014-04-23 00:00:00	2014-01-29 00:00:00	2015-07-27 00:00:00	2015-01-26 00:00:00	2015-04-24 00:00:00	2015-10-26 00:00:00	2016-07-22 00:00:00	2016-04-25 00:00:00	2016-01-22 00:00:00	2016-10-24 00:00:00	2017-07-21 00:00:00	2017-04-26 00:00:00	2017-01-27 00:00:00	2017-10-25 00:00:00	2017-11-02 00:00:00	2018-01-26 00:00:00	2020-04-30 00:00:00	2020-01-31 00:00:00	2020-11-01 00:00:00	2021-01-31 00:00:00	2020-07-31 00:00:00	2022-04-11 00:00:00	2022-07-06 00:00:00	2022-10-10 00:00:00
sig_loc	Costa Mesa, CA	Costa Mesa, CA	Costa Mesa, CA	Costa Mesa, CA	Costa Mesa, CA	Costa Mesa, CA	Costa Mesa, CA	Costa Mesa, CA	Costa Mesa, CA	Costa Mesa, CA	Costa Mesa, CA	Costa Mesa, CA	Costa Mesa, CA	Costa Mesa, CA	Costa Mesa, CA	Costa Mesa, CA	Costa Mesa, CA	Costa Mesa, CA	Costa Mesa, CA	Costa Mesa, CA	Costa Mesa, CA	Costa Mesa, CA	Costa Mesa, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	Sacramento, CA	Sacramento, CA	Alameda	Alameda, CA	Alameda	Sacramento, CA	Sacramento, CA	Sacramento, CA
sig_naml	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	KELLEY	DEWANE	DEWANE	KELLEY	KELLEY	KELLEY	Shaver	Shaver	Shaver	Shaver	Shaver	Farrel	Farrel	Farrel
sig_namf	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	PAUL	SHAWN	SHAWN	PAUL	PAUL	PAUL	Bob	Robert	Robert	Robert	Robert	Glenn	Glenn	Glenn
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
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
prn_naml	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	Dewane	KELLEY	DEWANE	DEWANE	KELLEY	KELLEY	KELLEY	Shaver	Shaver	Shaver	Shaver	Shaver	Farrel	Farrel	Farrel
prn_namf	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	Shawn	PAUL	SHAWN	SHAWN	PAUL	PAUL	PAUL	Bob	Robert	Robert	Robert	Robert	Glenn	Glenn	Glenn
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
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
sig_title	Chair	Chair	Chair	Chair	Chair	Chair	Chair	Chair	Chair	Chair	Chair	Chair	Chair	Chair	Chair	Chair	Chair	Chair	Chair	Chair	Chair	Chair	Chair	EXECUTIVE DIRECTOR	CHAIR	CHAIR	EXECUTIVE DIRECTOR	EXECUTIVE DIRECTOR	EXECUTIVE DIRECTOR	Chair	Chair	Chair	Chair	Chair	Executive Director	Executive Director	Executive Director
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
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
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
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
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
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
lby_actvty	State Water Resources Control Board re Ocean Plan amendment for Brine Disposal.	State Water Resources Control Board re Ocean Plan amendment for Brine Disposal.	State Water Resources Control Board re Ocean Plan amendment for Brine Disposal.	Ocean Plan Triennial Review before the State Water Resources Control Board	AB 2595, AB 2398, State Water Resources Control Board Ocean Plan Amendment for Intakes and Brine Disposal.	AB 2595, AB 2398, State Water Resources Control Board Ocean Plan Amendment for Intakes and Brine Disposal.	AB 2595, State Water Resources Control Board Ocean Plan Amendment for Intakes and Brine Disposal.	State Water Resources Control Board Ocean Plan Amendment for Intakes and Brine Disposal.	State Water Resources Control Board Ocean Plan Amendment for Intakes and Brine Disposal.	State Water Resources Control Board Ocean Plan Amendment for Intakes and Brine Disposal.	State Water Resources Control Board Ocean Plan Amendment for Intakes and Brine Disposal.	State Water Resources Control Board Ocean Plan Amendment for Intakes and Brine Disposal, Department of Water Resources' California Water Plan	State Water Resources Control Board Ocean Plan Amendment for Intakes and Brine Disposal, Department of Water Resources' California Water Plan	State Water Resources Control Board Ocean Plan Amendment for Intakes and Brine Disposal, Department of Water Resources' California Water Plan	State Water Resources Control Board Ocean Plan Amendment for Intakes and Brine Disposal, Department of Water Resources' California Water Plan	State Water Resources Control Board re Ocean Plan Amendment for Intakes and Brine Disposal.	State Water Resources Control Board Ocean Plan Amendment for Intakes and Brine Disposal, Department of Water Resources' California Water Plan	State Water Resources Control Board Ocean Plan Amendment for Intakes and Brine Disposal, Department of Water Resources' California Water Plan	No actions actively lobbied during the period.	AB 1925, AB 2022	AB 1925	No actions actively lobbied during the period.	None	AB 457, 554, 1654; SB 701	AB 457, 554, 594	NONE	AB 1654, 1667; SB 606	AB 1654, 1667; SB 606	NONE	SB 45 (Allen) Wildfire Prevention, Safe Drinking Water, Drought Preparation, and Flood Protection Bond Act of 2020	State Water Resources Control Board: 2019 Review of the Water Quality Control Plan for Ocean Waters of California Public Hearing Santa Ana Regional Water Quality Control Board Meeting Huntington Beach Desalination Facility Permit Renewal Workshop	None	None	AB 3256 (E. Garcia) Economic Recovery, Wildlife Prevention, Safe Drinking Water, Drought Preparation, and Flood Protection Bond Act of 2020	AB 2016, State Budget	AB 2016, State Budget	AB 2016, SB 991, SB 1075, SB 1347, State Budget
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
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
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
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
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
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
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
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

Table: cvr_registration
filing_id		2115453
amend_id		0
rec_type		CVR
form_type		F602
sender_id		1336499
filer_id		1336512
entity_cd		LEM
filer_naml		CALDESAL
filer_namf		None
filer_namt		None
filer_nams		None
report_num		000
rpt_date		2016-12-07 00:00:00
ls_beg_yr		2017
ls_end_yr		2018
qual_date		None
eff_date		2017-01-01 00:00:00
bus_city		SACRAMENTO
bus_st		CA
bus_zip4		95814
bus_phon		(916) 492-6082
bus_fax		None
bus_email		None
mail_city		None
mail_st		None
mail_zip4		None
mail_phon		None
sig_date		2016-12-07 00:00:00
sig_loc		SACRAMENTO, CA
sig_naml		KELLEY
sig_namf		PAUL
sig_namt		None
sig_nams		None
prn_naml		KELLEY
prn_namf		PAUL
prn_namt		None
prn_nams		None
sig_title		EXECUTIVE DIRECTOR (466600-MM)
stmt_firm		None
ind_cb		None
bus_cb		None
trade_cb		X
oth_cb		None
a_b_name		None
a_b_city		None
a_b_st		None
a_b_zip4		None
descrip_1		WATER DESALINATION
descrip_2		USERS AND PURVEYORS
c_less50		None
c_more50		X
ind_class		UTL
ind_descr		None
bus_class		None
bus_descr		None
auth_name		RON DAVIS ADVOCACY
auth_city		SACRAMENTO
auth_st		CA
auth_zip4		95814
lobby_int		None
influen_yn		None
firm_name		None
newcert_cb		None
rencert_cb		None
complet_dt		None
lby_reg_cb		None
lby_604_cb		None
st_leg_yn		None
st_agency		None
lobby_cb		None
l_firm_cb		None

Table: filer_address
filer_id	1336512	1336512	1336512	1336512	1336512	1336512	1336512
adrid	2211743	2488093	2415463	2546941	2276109	2509389	2343645
effect_dt	2011-02-01 00:00:00	2019-12-01 00:00:00	2017-01-01 00:00:00	2023-01-01 00:00:00	2013-01-01 00:00:00	2022-01-10 00:00:00	2015-01-01 00:00:00
add_type	7051	7051	7051	7051	7051	7051	7051
session_id	2011	2019	2017	2023	2013	2021	2015

Table: filer_filings
filer_id	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512
filing_id	1783028	1961760	1981232	1870737	1935490	1944139	1906234	1579201	1605904	1589249	1632978	1656436	1620547	1676204	1800973	1819201	1701498	1727228	1737808	1845568	1764721	2424606	2486332	1997623	2008513	2034843	2057894	2100549	2129130	2155984	2134865	2115453	2175231	2192341	2471832	2441471	2192341	2210651	2529704	2552357	2664891	2696931	2653622	2730598
period_id	214	221	222	218	220	None	219	None	206	205	208	209	207	210	215	216	211	None	212	217	213	None	242	223	224	225	226	227	228	229	None	228	230	231	241	240	231	232	243	244	249	250	None	251
form_id	F635	F635	F635	F635	F635	F602	F635	F602	F635	F635	F635	F635	F635	F635	F635	F635	F635	F602	F635	F635	F635	F602	F635	F635	F635	F635	F635	F635	F635	F635	F602	F602	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F602	F635
filing_sequence	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0
filing_date	2013-07-31 00:00:00	2015-04-24 00:00:00	2015-07-30 00:00:00	2014-07-30 00:00:00	2015-01-31 00:00:00	2015-01-05 00:00:00	2014-10-27 00:00:00	2011-02-10 00:00:00	2011-07-28 00:00:00	2011-04-28 00:00:00	2012-01-27 00:00:00	2012-04-28 00:00:00	2011-10-27 00:00:00	2012-07-27 00:00:00	2013-10-31 00:00:00	2014-01-31 00:00:00	2012-10-23 00:00:00	2012-12-27 00:00:00	2013-01-30 00:00:00	2014-04-30 00:00:00	2013-04-30 00:00:00	2019-12-10 00:00:00	2020-07-31 00:00:00	2015-10-31 00:00:00	2016-01-28 00:00:00	2016-04-28 00:00:00	2016-07-25 00:00:00	2016-10-30 00:00:00	2017-01-31 00:00:00	2017-04-28 00:00:00	2016-12-30 00:00:00	2016-12-29 00:00:00	2017-07-31 00:00:00	2017-11-03 00:00:00	2020-04-30 00:00:00	2020-01-31 00:00:00	2017-10-30 00:00:00	2018-01-31 00:00:00	2020-11-01 00:00:00	2021-01-31 00:00:00	2022-04-11 00:00:00	2022-07-07 00:00:00	2022-02-08 00:00:00	2022-10-10 00:00:00
stmnt_type	10001	10001	10001	10001	10001	10005	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10002	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001
stmnt_status	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	11003	11003	11001	11001	11001	11003	11001	11003
session_id	2013	2015	2015	2013	2013	2015	2013	2011	2011	2011	2011	2011	2011	2011	2013	2013	2011	2013	2011	2013	2013	2019	2019	2015	2015	2015	2015	2015	2015	2017	2017	2017	2017	2017	2019	2019	2017	2017	2019	2019	2021	2021	2021	2021
user_id	AGLADNEY	MPACHECO	MPACHECO	AGLADNEY	AGLADNEY	YRODRIGU	AGLADNEY	CFLAGG	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	YRODRIGU	ASAETERN	AGLADNEY	AGLADNEY	SARRIAGA	MKIRKHAM	MPACHECO	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	YRODRIGU	YRODRIGU	AGLADNEY	CAFILER	GTAYLOR	GTAYLOR	CAFILER	CAFILER	MKIRKHAM	CHARTRIDGE	CHATRIDGE	CAFILER	CVANLIEW	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
fine_audit	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11003	11003	11001	11001	11001	11003	11003	11003
rpt_start	2013-04-01 00:00:00	2015-01-01 00:00:00	2015-04-01 00:00:00	2014-04-01 00:00:00	2014-10-01 00:00:00	1900-01-01 00:00:00	2014-07-01 00:00:00	1900-01-01 00:00:00	2011-04-01 00:00:00	2011-01-01 00:00:00	2011-10-01 00:00:00	2012-01-01 00:00:00	2011-07-01 00:00:00	2012-04-01 00:00:00	2013-07-01 00:00:00	2013-10-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	1900-01-01 00:00:00	2020-04-01 00:00:00	2015-07-01 00:00:00	2015-10-01 00:00:00	2016-01-01 00:00:00	2016-04-01 00:00:00	2016-07-01 00:00:00	2016-10-01 00:00:00	2017-01-01 00:00:00	1900-01-01 00:00:00	2016-12-07 00:00:00	2017-04-01 00:00:00	2017-07-01 00:00:00	2020-01-01 00:00:00	2019-10-01 00:00:00	2017-07-01 00:00:00	2017-10-01 00:00:00	2020-07-01 00:00:00	2020-10-01 00:00:00	2022-01-01 00:00:00	2022-04-01 00:00:00	1900-01-01 00:00:00	2022-07-01 00:00:00
rpt_end	2013-06-30 00:00:00	2015-03-31 00:00:00	2015-06-30 00:00:00	2014-06-30 00:00:00	2014-12-31 00:00:00	1900-01-01 00:00:00	2014-09-30 00:00:00	1900-01-01 00:00:00	2011-06-30 00:00:00	2011-03-31 00:00:00	2011-12-31 00:00:00	2012-03-31 00:00:00	2011-09-30 00:00:00	2012-06-30 00:00:00	2013-09-30 00:00:00	2013-12-31 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	1900-01-01 00:00:00	2020-06-30 00:00:00	2015-09-30 00:00:00	2015-12-31 00:00:00	2016-03-31 00:00:00	2016-06-30 00:00:00	2016-09-30 00:00:00	2016-12-31 00:00:00	2017-03-31 00:00:00	1900-01-01 00:00:00	2016-12-07 00:00:00	2017-06-30 00:00:00	2017-09-30 00:00:00	2020-03-31 00:00:00	2019-12-21 00:00:00	2017-09-30 00:00:00	2017-12-31 00:00:00	2020-09-30 00:00:00	2020-12-21 00:00:00	2022-03-31 00:00:00	2022-06-30 00:00:00	1900-01-01 00:00:00	2022-09-30 00:00:00
rpt_date	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
filing_type	22001	22001	22001	22001	22001	None	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	None	22006	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22006	22006	22001	22001	22006	22006	22006	22006	None	22006

Table: filer_interests
filer_id	1336512	1336512	1336512	1336512	1336512	1336512	1336512
session_id	2013	2011	2017	2019	2015	2023	2021
interest_cd	40319	40319	40319	40305	40319	40319	40319
effect_date	2013-01-01 00:00:00	2011-02-01 00:00:00	2017-01-01 00:00:00	2019-12-01 00:00:00	2015-01-01 00:00:00	2023-01-01 00:00:00	2022-01-10 00:00:00

Table: filer_to_filer_type
filer_id	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512
filer_type	1	1	1	1	1	1	1	1
active	Y	Y	Y	Y	Y	T	Y	N
race	None	0	None	None	None	None	None	None
session_id	2013	2011	2019	2015	2021	2017	2017	2023
category	None	0	None	None	None	None	None	None
category_type	None	0	None	None	None	None	None	None
sub_category	None	0	None	None	None	None	None	None
effect_dt	2013-01-01 00:00:00	2011-02-01 00:00:00	2019-12-01 00:00:00	2015-01-01 00:00:00	2022-01-10 00:00:00	2017-12-31 00:00:00	2017-01-01 00:00:00	2023-01-01 00:00:00
sub_category_type	None	0	None	None	None	None	None	None
election_type	None	0	None	None	None	None	None	None
sub_category_a	None	None	None	None	None	None	None	None
nyq_dt	None	None	None	None	None	None	None	None
party_cd	None	0	None	None	None	None	None	None
county_cd	None	0	None	None	None	None	None	None
district_cd	None	0	None	None	None	None	None	None

Table: filer_xref
filer_id		1336512
xref_id		1336512
effect_dt		2011-02-11 00:00:00
migration_source		CLAIMS

Table: filername
xref_filer_id	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512
filer_id	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512
filer_type	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT
status	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE
effect_dt	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00
naml	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL	CALDESAL
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
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
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
adr1	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
adr2	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
city	COSTA MESA	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	COSTA MESA	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	COSTA MESA	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	COSTA MESA	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	COSTA MESA	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	COSTA MESA	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	COSTA MESA	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO
st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA
zip4	92627	95814	95814	95814	95833	95833	95833	92627	95814	95814	95814	95833	95833	95833	92627	95814	95814	95814	95833	95833	95833	92627	95814	95814	95814	95833	95833	95833	92627	95814	95814	95814	95833	95833	95833	92627	95814	95814	95814	95833	95833	95833	92627	95814	95814	95814	95833	95833	95833
phon	9496311200	9164926082	9164926082	9164926082	9162394099	9162394099	9162394099	9496311200	9164926082	9164926082	9164926082	9162394099	9162394099	9162394099	9496311200	9164926082	9164926082	9164926082	9162394099	9162394099	9162394099	9496311200	9164926082	9164926082	9164926082	9162394099	9162394099	9162394099	9496311200	9164926082	9164926082	9164926082	9162394099	9162394099	9162394099	9496311200	9164926082	9164926082	9164926082	9162394099	9162394099	9162394099	9496311200	9164926082	9164926082	9164926082	9162394099	9162394099	9162394099
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
email	None	None	None	None	[email protected]	[email protected]	[email protected]	None	None	None	None	[email protected]	[email protected]	[email protected]	None	None	None	None	[email protected]	[email protected]	[email protected]	None	None	None	None	[email protected]	[email protected]	[email protected]	None	None	None	None	[email protected]	[email protected]	[email protected]	None	None	None	None	[email protected]	[email protected]	[email protected]	None	None	None	None	[email protected]	[email protected]	[email protected]

Table: filers
filer_id		1336512

Table: lobbying_chg_log
filer_id		1336512
change_no		1
session_id		2017
log_dt		2017-12-28 00:00:00
filer_type		2
correction_flg		Y
action		DELETED
attribute_changed		FIRM
ethics_dt		None
interests		None
filer_full_name		CALDESAL
filer_city		COSTA MESA
filer_st		CA
filer_zip		92627
filer_phone		9496311200
entity_type		3
entity_name		DAVIS ADVOCACY; RON
entity_city		None
entity_st		None
entity_zip		None
entity_phone		None
entity_id		None
responsible_officer		None
effect_dt		2017-12-31 00:00:00

Table: received_filings
filer_id	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512	1336512
filing_file_name	1845568_0.cal	1737808_0.cal	1676204_0.cal	1783028_0.cal	1800973_0.cal	1701498_0.cal	1589249_0.cal	1819201_0.cal	1605904_0.cal	1764721_0.cal	1632978_0.cal	1620547_0.cal	1656436_0.cal	1870737_0.cal	1981232_0.cal	2057894_0.cal	1997623_0.cal	2008513_0.cal	2100549_0.cal	1906234_0.cal	2034843_0.cal	1961760_0.cal	1935490_0.cal	100048.cal
received_date	2014-04-30 00:00:00	2013-01-30 00:00:00	2012-07-27 00:00:00	2013-07-31 00:00:00	2013-10-31 00:00:00	2012-10-23 00:00:00	2011-04-28 00:00:00	2014-01-31 00:00:00	2011-07-28 00:00:00	2013-04-30 00:00:00	2012-01-27 00:00:00	2011-10-27 00:00:00	2012-04-28 00:00:00	2014-07-30 00:00:00	2015-07-30 00:00:00	2016-07-25 00:00:00	2015-10-31 00:00:00	2016-01-28 00:00:00	2016-10-30 00:00:00	2014-10-27 00:00:00	2016-04-28 00:00:00	2015-04-24 00:00:00	2015-01-31 00:00:00	2018-01-31 00:00:00
filing_directory	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/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
filing_id	1845568	1737808	1676204	1783028	1800973	1701498	1589249	1819201	1605904	1764721	1632978	1620547	1656436	1870737	1981232	2057894	1997623	2008513	2100549	1906234	2034843	1961760	1935490	None
form_id	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	None
receive_comment	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