Home

Filer ID: 1226625

Table: cvr_lobby_disclosure

filing_id		941881		965499		983624		1010107		1010107		1023414		1052833		1075348		1980611		2007039		1995278		2058494		2035967		2099334		2122300		2638561		2625542		2739964		2678284		2701839
amend_id		0		0		0		0		1		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
form_type		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635
sender_id		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625
filer_id		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625
entity_cd		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM
filer_naml		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF		La Habra, City of		La Habra, City of		La Habra, City of		La Habra, City of		La Habra, City of		La Habra, City of		La Habra, City of		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF
filer_namf		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
filer_nams		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		001		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000
rpt_date		2003-07-15 00:00:00		2003-10-20 00:00:00		2004-01-20 00:00:00		2004-04-21 00:00:00		2004-04-21 00:00:00		2004-07-16 00:00:00		2004-10-25 00:00:00		2005-01-25 00:00:00		2015-07-13 00:00:00		2016-01-11 00:00:00		2015-10-14 00:00:00		2016-07-18 00:00:00		2016-04-14 00:00:00		2016-10-12 00:00:00		2017-01-11 00:00:00		2022-01-31 00:00:00		2021-10-31 00:00:00		2022-10-31 00:00:00		2022-04-30 00:00:00		2022-07-31 00:00:00
from_date		2003-04-01 00:00:00		2003-07-01 00:00:00		2003-10-01 00:00:00		2004-01-01 00:00:00		2004-01-01 00:00:00		2004-04-01 00:00:00		2004-07-01 00:00:00		2004-10-01 00:00:00		2015-04-01 00:00:00		2015-10-01 00:00:00		2015-07-01 00:00:00		2016-04-01 00:00:00		2016-01-01 00:00:00		2016-07-01 00:00:00		2016-10-01 00:00:00		2021-10-01 00:00:00		2021-07-01 00:00:00		2022-07-01 00:00:00		2022-01-01 00:00:00		2022-04-01 00:00:00
thru_date		2003-06-30 00:00:00		2003-09-30 00:00:00		2003-12-31 00:00:00		2004-03-31 00:00:00		2004-03-31 00:00:00		2004-06-30 00:00:00		2004-09-30 00:00:00		2004-12-31 00:00:00		2015-06-30 00:00:00		2015-12-31 00:00:00		2015-09-30 00:00:00		2016-06-30 00:00:00		2016-03-31 00:00:00		2016-09-30 00:00:00		2016-12-31 00:00:00		2021-12-31 00:00:00		2021-09-30 00:00:00		2022-09-30 00:00:00		2022-03-31 00:00:00		2022-06-30 00:00:00
cum_beg_dt		2003-01-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2015-04-01 00:00:00		2015-04-01 00:00:00		2015-04-01 00:00:00		2015-04-01 00:00:00		2015-04-01 00:00:00		2015-04-01 00:00:00		2015-04-01 00:00:00		2021-07-01 00:00:00		2021-07-01 00:00:00		2021-07-01 00:00:00		2021-07-01 00:00:00		2021-07-01 00:00:00
firm_id		None		None		None		None		None		None		None		None		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625
firm_name		None		None		None		None		None		None		None		None		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF
firm_city		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		La Habra		La Habra		La Habra		La Habra		La Habra		La Habra		La Habra		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA
firm_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
firm_zip4		90631		90631		90631		90631		90631		90631		90631		90631		90631		90631		90631		90631		90631		90631		90631		90633		90633		90633		90633		90633
firm_phon		5629059701		5629059701		5629059701		5629059701		5629059701		5629059701		5629059701		5629059701		(562) 383-4010		(562) 383-4010		(562) 383-4010		(562) 383-4010		(562) 383-4010		(562) 383-4010		(562) 383-4010		562-383-4200		562-383-4200		562-383-4200		562-383-4200		562-383-4200
mail_city		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		None		None		None		None		None		None		None		None		None		None		None		None
mail_st		CA		CA		CA		CA		CA		CA		CA		CA		None		None		None		None		None		None		None		None		None		None		None		None
mail_zip4		906330337		906330337		906330337		906330337		906330337		906330337		906330337		906330337		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
sig_date		2003-07-15 00:00:00		2003-10-20 00:00:00		2004-01-20 00:00:00		2004-04-21 00:00:00		2004-04-21 00:00:00		2004-07-16 00:00:00		2004-10-25 00:00:00		2005-01-25 00:00:00		2015-07-13 00:00:00		2016-01-11 00:00:00		2015-10-14 00:00:00		2016-07-18 00:00:00		2016-04-14 00:00:00		2016-10-12 00:00:00		2017-01-11 00:00:00		2022-01-25 00:00:00		2021-10-25 00:00:00		2022-10-16 00:00:00		2022-04-13 00:00:00		2022-07-18 00:00:00
sig_loc		La Habra, California		La Habra, CA		La Habra, CA		La Habra, CA		La Habra, CA		La Habra, CA		La Habra, CA		La Habra, CA		La Habra, CA		La Habra, CA		La Habra, CA		La Habra, CA		La Habra, CA		La Habra, CA		La Habra, CA		LA HABRA, CA		LA HABRA, CA		LA HABRA, CA		LA HABRA, CA		LA HABRA, CA
sig_naml		Cervantez		Cervantez		Cervantez		Cervantez		Cervantez		Cervantez		Cervantez		Cervantez		Ferrier		Ferrier		Ferrier		Ferrier		Ferrier		Ferrier		Ferrier		SADRO		SADRO		SADRO		SADRO		SADRO
sig_namf		Jennifer		Jennifer		Jennifer		Jennifer		Jennifer		Jennifer		Jennifer		Jennifer		Robert		Robert		Robert		Robert		Robert		Robert		Robert		JIM		JIM		JIM		JIM		JIM
sig_namt		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
prn_naml		Cervantez		Cervantez		Cervantez		Cervantez		Cervantez		Cervantez		Cervantez		Cervantez		Ferrier		Ferrier		Ferrier		Ferrier		Ferrier		Ferrier		Ferrier		SADRO		SADRO		SADRO		SADRO		SADRO
prn_namf		Jennifer		Jennifer		Jennifer		Jennifer		Jennifer		Jennifer		Jennifer		Jennifer		Robert		Robert		Robert		Robert		Robert		Robert		Robert		JIM		JIM		JIM		JIM		JIM
prn_namt		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
sig_title		Assistant to the City Manager		Assistant to the City Manager		Assistant to the City Manager		Asst. to the City Mgr.		Asst. to the City Mgr.		Assistant to the City Manager		Assistant to the City Manager		Assistant to the City Manager		Assistant to the City Manager 425900SSB		Assistant to the City Manager 425900SSB		Assistant to the City Manager 425900SSB		Assistant to the City Manager 425900SSB		Assistant to the City Manager 425900SSB		Assistant to the City Manager 425900SSB		Assistant to the City Manager 425900SSB		CITY MANAGER		CITY MANAGER		CITY MANAGER		CITY MANAGER		CITY MANAGER
nopart1_cb		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
part1_1_cb		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
ctrib_n_cb		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
lby_actvty		AB 136, 710 SB 100		AB 1362, 1160		None		AB 136, 1221 SB 100		AB 136, 1221 SB 100		AB 2372; SB 1404; State Budget		SB 1404, SB 1056, AB 2406, Library Bond Act Grants, Murray-Hayden Park Bond Act grants		None		Legislature and Department of Finance Re: Redevelopment, AB 113.		Department of Finance and Legislature RE: redevelopment dissolution.		Department of Finance and Legislature RE: redevelopment dissolution. AB 113, SB 107		Nothing to report.		Nothing to report.		Nothing to report.		Nothing to report.		Legislature, Governor's Office re: Budget		Legislature, Governors Office re: Budget		Legislature re: FY 22 Budget; AB 1976; SB 1418; California Transportation Commission and Legislature: Active Transportation Grant Program		Legislature re: FY 22 Budget; AB 1976; SB 1418		Legislature re: FY 22 Budget; AB 1976; SB 1418; California Transportation Commission, Legislature Re: Active Transportation Grant Program
lobby_n_cb		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
major_naml		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
major_namt		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
rcpcmte_nm		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

Table: cvr_registration

filing_id		1970005		2627586
amend_id		0		0
rec_type		CVR		CVR
form_type		F602		F602
sender_id		F24882		F24882
filer_id		1226625		1226625
entity_cd		LEM		LEM
filer_naml		LA HABRA, CITY OF		LA HABRA, CITY OF
filer_namf		None		None
filer_namt		None		None
filer_nams		None		None
report_num		000		000
rpt_date		2015-06-02 00:00:00		2021-10-25 00:00:00
ls_beg_yr		2015		2021
ls_end_yr		2016		2022
qual_date		None		None
eff_date		None		2021-07-01 00:00:00
bus_city		LA HABRA		LA HABRA
bus_st		CA		CA
bus_zip4		90631		90633
bus_phon		(562) 383-4010		562-383-4200
bus_fax		None		None
bus_email		None		None
mail_city		None		None
mail_st		None		None
mail_zip4		None		None
mail_phon		None		None
sig_date		2015-05-01 00:00:00		2021-10-25 00:00:00
sig_loc		LA HABRA, CA		LA HABRA, CA
sig_naml		FERRIER		SADRO
sig_namf		ROBERT		JIM
sig_namt		None		None
sig_nams		None		None
prn_naml		FERRIER		SADRO
prn_namf		ROBERT		JIM
prn_namt		None		None
prn_nams		None		None
sig_title		ASST. TO CITY MANAGER 425900SSB		CITY MANAGER
stmt_firm		None		None
ind_cb		None		None
bus_cb		None		None
trade_cb		None		None
oth_cb		X		X
a_b_name		None		None
a_b_city		None		None
a_b_st		None		None
a_b_zip4		None		None
descrip_1		MUNICIPAL GOVERNMENT		MUNICIPAL GOVERNMENT
descrip_2		None		MUNICIPAL GOVERNMENT
c_less50		None		None
c_more50		None		None
ind_class		GOV		GOV
ind_descr		None		None
bus_class		None		None
bus_descr		None		None
auth_name		TOWNSEND PUBLIC AFFAIRS, INC.		TOWNSEND PUBLIC AFFAIRS, INC.
auth_city		NEWPORT BEACH		NEWPORT BEACH
auth_st		CA		CA
auth_zip4		92660		92660
lobby_int		None		None
influen_yn		None		None
firm_name		None		None
newcert_cb		None		None
rencert_cb		None		None
complet_dt		None		None
lby_reg_cb		None		None
lby_604_cb		None		None
st_leg_yn		None		None
st_agency		None		None
lobby_cb		None		None
l_firm_cb		None		None

Table: efs_filing_log

filing_date		2003-07-15 00:00:00		2003-07-15 00:00:00		2003-10-20 00:00:00		2003-10-20 00:00:00
filingstatus		1		0		1		0
vendor		CAL-ACCESS OBJECT MODEL		CAL-ACCESS OBJECT MODEL		CAL-ACCESS OBJECT MODEL		CAL-ACCESS OBJECT MODEL
filer_id		1226625		1226625		1226625		1226625
form_type		F635		F635		F635		F635
error_no		ACCEPTED		ACCEPTED		ACCEPTED		ACCEPTED

Table: filer_address

filer_id		1226625		1226625		1226625		1226625		1226625		1226625		1226625
adrid		2004370		2013580		2048691		2526383		2551390		2551391		2363292
effect_dt		2000-08-21 00:00:00		2001-03-02 00:00:00		2003-02-03 00:00:00		2021-07-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2015-05-01 00:00:00
add_type		7051		7082		7051		7051		7051		7082		7051
session_id		1999		2001		2003		2021		2023		2023		2015

Table: filer_filings

filer_id		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625
filing_id		655886		655889		692939		710169		729743		923135		941881		943398		932554		965499		983624		976422		1010107		1010107		997305		1023414		1027884		1052833		1016698		1019252		1075348		1065393		1092719		1970005		1980611		1972229		1995278		2007039		2035967		2058494		2099334		2122300		2627586		2628907		2638561		2678284		2701839		2625542		2739964
period_id		None		None		163		None		164		None		174		174		None		175		176		None		177		177		None		178		None		179		None		None		180		None		None		222		222		None		223		224		225		226		227		228		248		None		248		249		250		247		251
form_id		F602		F999		F635		F602		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F690		F635		F635		F635		F602		F635		F602		F635		F635		F635		F635		F635		F635		F602		F602		F635		F635		F635		F635		F635
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		2000-08-28 00:00:00		2000-08-28 00:00:00		2000-10-31 00:00:00		2001-01-09 00:00:00		2001-01-31 00:00:00		2003-02-21 00:00:00		2003-07-15 00:00:00		2003-07-21 00:00:00		2003-04-28 00:00:00		2003-10-20 00:00:00		2004-01-20 00:00:00		2003-10-23 00:00:00		2004-04-21 00:00:00		2004-04-21 00:00:00		2004-01-23 00:00:00		2004-07-16 00:00:00		2004-07-23 00:00:00		2004-10-25 00:00:00		2004-04-27 00:00:00		2004-04-27 00:00:00		2005-01-25 00:00:00		2004-11-01 00:00:00		2005-01-31 00:00:00		2015-06-03 00:00:00		2015-07-30 00:00:00		2015-06-02 00:00:00		2015-10-28 00:00:00		2016-01-26 00:00:00		2016-04-29 00:00:00		2016-07-26 00:00:00		2016-10-28 00:00:00		2017-01-23 00:00:00		2021-11-08 00:00:00		2021-11-08 00:00:00		2022-01-26 00:00:00		2022-05-02 00:00:00		2022-07-27 00:00:00		2021-11-01 00:00:00		2022-10-24 00:00:00
stmnt_type		10005		10005		10005		10005		10005		10005		10001		10005		10005		10001		10001		10005		10001		10002		10005		10001		10005		10001		10005		10006		10001		10005		10005		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003		11001		11003		11003		11001		11003		11001		11003		11001		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11003
session_id		1999		1999		1999		2001		1999		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2015		2015		2015		2015		2015		2015		2015		2015		2015		2021		2021		2021		2021		2021		2021		2021
user_id		CFLAGG		CFLAGG		YBONILLA		GGILMORE		YBONILLA		GPEREZ		COMPLETED		LTHIBAUL		LTHIBAUL		COMPLETED		COMPLETED		LTHIBAUL		COMPLETED		COMPLETED		LTHIBAUL		COMPLETED		LTHIBAUL		COMPLETED		LTHIBAUL		EMCENTEE		COMPLETED		GGILMORE		KLARRY		YRODRIGU		AGLADNEY		YRODRIGU		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		MKIRKHAM		MKIRKHAM		CHATRIDGE		CAFILER		CAFILER		CHATRIDGE		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
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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11003		11003		11001		11003
rpt_start		None		None		2000-07-01 00:00:00		1900-01-01 00:00:00		2000-10-01 00:00:00		1900-01-01 00:00:00		2003-04-01 00:00:00		2003-04-01 00:00:00		2003-01-01 00:00:00		2003-07-01 00:00:00		2003-10-01 00:00:00		2003-07-01 00:00:00		2004-01-01 00:00:00		2004-01-01 00:00:00		2003-10-01 00:00:00		2004-04-01 00:00:00		2004-04-01 00:00:00		2004-07-01 00:00:00		2004-01-01 00:00:00		2004-01-01 00:00:00		2004-10-01 00:00:00		2004-07-01 00:00:00		2004-10-01 00:00:00		2015-06-02 00:00:00		2015-04-01 00:00:00		1900-01-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		2021-10-25 00:00:00		1900-01-01 00:00:00		2021-10-01 00:00:00		2022-01-01 00:00:00		2022-04-01 00:00:00		2021-07-01 00:00:00		2022-07-01 00:00:00
rpt_end		None		None		2000-09-30 00:00:00		1900-01-01 00:00:00		2000-12-31 00:00:00		1900-01-01 00:00:00		2003-06-30 00:00:00		2003-06-30 00:00:00		2003-03-31 00:00:00		2003-09-30 00:00:00		2003-12-31 00:00:00		2003-09-30 00:00:00		2004-03-31 00:00:00		2004-03-31 00:00:00		2003-12-31 00:00:00		2004-06-30 00:00:00		2004-06-30 00:00:00		2004-09-30 00:00:00		2004-03-31 00:00:00		2004-03-31 00:00:00		2004-12-31 00:00:00		2004-09-30 00:00:00		2004-12-31 00:00:00		2015-06-02 00:00:00		2015-06-30 00:00:00		1900-01-01 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		2021-10-25 00:00:00		1900-01-01 00:00:00		2021-12-31 00:00:00		2022-03-31 00:00:00		2022-06-30 00:00:00		2021-09-30 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
filing_type		None		None		None		None		None		None		22006		None		None		22006		22006		None		22006		22006		None		22006		None		22006		None		None		22006		None		None		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001

Table: filer_interests

filer_id		1226625		1226625		1226625		1226625		1226625		1226625
session_id		2003		1999		2001		2015		2023		2021
interest_cd		40305		40305		40305		40305		40305		40305
effect_date		2003-02-03 00:00:00		2000-08-21 00:00:00		2001-01-01 00:00:00		2015-05-01 00:00:00		2023-01-01 00:00:00		2021-07-01 00:00:00

Table: filer_to_filer_type

filer_id		1226625		1226625		1226625		1226625		1226625		1226625
filer_type		1		1		1		1		1		1
active		T		Y		T		Y		Y		N
race		0		None		None		None		None		None
session_id		1999		2003		2003		2015		2021		2023
category		0		None		None		None		None		None
category_type		0		None		None		None		None		None
sub_category		0		None		None		None		None		None
effect_dt		2000-08-21 00:00:00		2003-02-03 00:00:00		2004-12-01 00:00:00		2015-05-01 00:00:00		2021-07-01 00:00:00		2023-01-01 00:00:00
sub_category_type		0		None		None		None		None		None
election_type		0		None		None		None		None		None
sub_category_a		None		None		None		None		None		None
nyq_dt		None		None		2003-04-01 00:00:00		2003-04-01 00:00:00		2003-04-01 00:00:00		None
party_cd		0		None		None		None		None		None
county_cd		0		None		None		None		None		None
district_cd		0		None		None		None		None		None

Table: filer_xref

filer_id		1226625
xref_id		1226625
effect_dt		2000-08-29 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625
filer_id		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625
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
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
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
naml		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA: CITY OF		LA HABRA: CITY OF		LA HABRA: CITY OF		LA HABRA: CITY OF		LA HABRA: CITY OF		LA HABRA: CITY OF		LA HABRA: CITY OF		LA HABRA: CITY OF		LA HABRA: CITY OF		LA HABRA: CITY OF		LA HABRA: CITY OF		LA HABRA: CITY OF		LA HABRA: CITY OF		LA HABRA: CITY OF		LA HABRA: CITY OF		LA HABRA: CITY OF		LA HABRA: CITY OF		LA HABRA: CITY OF		LA HABRA: CITY OF		LA HABRA: CITY OF		LA HABRA: CITY OF
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
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
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
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
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
city		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA		LA HABRA
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
zip4		90633		906330337		90631		90631		90633		90633		906330337		90633		906330337		90631		90631		90633		90633		906330337		90633		906330337		90631		90631		90633		90633		906330337		90633		906330337		90631		90631		90633		90633		906330337		90633		906330337		90631		90631		90633		90633		906330337
phon		5629059700		None		5629059701		5623834010		5623834200		5623834200		None		5629059700		None		5629059701		5623834010		5623834200		5623834200		None		5629059700		None		5629059701		5623834010		5623834200		5623834200		None		5629059700		None		5629059701		5623834010		5623834200		5623834200		None		5629059700		None		5629059701		5623834010		5623834200		5623834200		None
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
email		None		None		None		None		[email protected]		[email protected]		None		None		None		None		None		[email protected]		[email protected]		None		None		None		None		None		[email protected]		[email protected]		None		None		None		None		None		[email protected]		[email protected]		None		None		None		None		None		[email protected]		[email protected]		None

Table: filers

filer_id		1226625

Table: lobbying_chg_log

filer_id		1226625		1226625		1226625		1226625		1226625		1226625
change_no		1		2		3		4		5		0
session_id		1999		2001		2003		2015		2021		2021
log_dt		2001-01-05 00:00:00		2001-03-20 00:00:00		2003-02-21 00:00:00		2015-06-02 00:00:00		2021-11-08 00:00:00		2021-11-08 00:00:00
filer_type		1		1		1		1		1		1
correction_flg		Y		None		Y		Y		None		None
action		DELETED		IN SUSPENSE		ADDED		ADDED		CHANGED		ADDED
attribute_changed		EMPLOYER		EMPLOYER		None		FIRM		RESPONSIBLE OFFICER		FIRM
ethics_dt		None		None		None		None		None		None
interests		None		None		None		None		None		None
filer_full_name		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA, CITY OF		LA HABRA: CITY OF		LA HABRA: CITY OF		LA HABRA: CITY OF
filer_city		None		SAN FRANCISCO		LA HABRA		LA HABRA		None		None
filer_st		None		CA		CA		CA		None		None
filer_zip		None		94105		90633		906330337		None		None
filer_phone		None		4158947700		5629059700		None		None		None
entity_type		2		3		3		3		20		3
entity_name		ENVIRO COMMUNICATIONS, INCORPORATED		MORSHED AND ASSOCIATES		EMANUELS JONES AND ASSOCIATES		TOWNSEND PUBLIC AFFAIRS, INC.		CITY MANAGER JIM SADRO		TOWNSEND PUBLIC AFFAIRS, INC.
entity_city		None		None		None		None		None		None
entity_st		None		None		None		None		None		None
entity_zip		None		None		None		None		None		None
entity_phone		None		None		None		None		None		None
entity_id		1147611		1147220		None		None		1442498		1147750
responsible_officer		None		None		None		None		None		None
effect_dt		2000-12-28 00:00:00		None		2003-02-03 00:00:00		2015-05-01 00:00:00		2021-07-01 00:00:00		2021-07-01 00:00:00

Table: received_filings

filer_id		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625		1226625
filing_file_name		941881_0.cal		965499_0.cal		2122300_0.cal		2058494_0.cal		2007039_0.cal		1995278_0.cal		2099334_0.cal		2035967_0.cal		1980611_0.cal		2739964_0.cal		60450.cal		60348.cal		2701839_0.cal		2678284_0.cal		2638561_0.cal		2625542_0.cal
received_date		2003-07-15 00:00:00		2003-10-20 00:00:00		2017-01-23 00:00:00		2016-07-26 00:00:00		2016-01-26 00:00:00		2015-10-28 00:00:00		2016-10-28 00:00:00		2016-04-29 00:00:00		2015-07-30 00:00:00		2022-10-24 00:00:00		2022-07-27 00:00:00		2022-07-27 00:00:00		2022-07-27 00:00:00		2022-05-02 00:00:00		2022-01-26 00:00:00		2021-11-01 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/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		941881		965499		2122300		2058494		2007039		1995278		2099334		2035967		1980611		2739964		None		None		2701839		2678284		2638561		2625542
form_id		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		None		None		F635		F635		F635		F635
receive_comment		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted