Home

Filer ID: 1400562

Table: cvr_lobby_disclosure

filing_id		2241155		2273130		2375938		2346402		2392766		2317820		2468023		2412942		2435754		2553821		2525810		2481434		2618573		2596323		2578542		2638491		2741228		2675170		2705254
amend_id		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
form_type		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635
sender_id		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562
filer_id		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562
entity_cd		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM
filer_naml		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES
filer_namf		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
filer_nams		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
rpt_date		2018-04-13 00:00:00		2018-07-13 00:00:00		2019-04-17 00:00:00		2019-01-22 00:00:00		2019-07-16 00:00:00		2018-10-17 00:00:00		2020-04-20 00:00:00		2019-10-11 00:00:00		2020-01-12 00:00:00		2021-01-27 00:00:00		2020-10-13 00:00:00		2020-07-21 00:00:00		2021-10-18 00:00:00		2021-07-14 00:00:00		2021-04-20 00:00:00		2022-01-22 00:00:00		2022-10-16 00:00:00		2022-04-19 00:00:00		2022-07-21 00:00:00
from_date		2018-01-01 00:00:00		2018-04-01 00:00:00		2019-01-01 00:00:00		2018-10-01 00:00:00		2019-04-01 00:00:00		2018-07-01 00:00:00		2020-01-01 00:00:00		2019-07-01 00:00:00		2019-10-01 00:00:00		2020-10-01 00:00:00		2020-07-01 00:00:00		2020-04-01 00:00:00		2021-07-01 00:00:00		2021-04-01 00:00:00		2021-01-01 00:00:00		2021-10-01 00:00:00		2022-07-01 00:00:00		2022-01-01 00:00:00		2022-04-01 00:00:00
thru_date		2018-03-31 00:00:00		2018-06-30 00:00:00		2019-03-31 00:00:00		2018-12-31 00:00:00		2019-06-30 00:00:00		2018-09-30 00:00:00		2020-03-31 00:00:00		2019-09-30 00:00:00		2019-12-31 00:00:00		2020-12-31 00:00:00		2020-09-30 00:00:00		2020-06-30 00:00:00		2021-09-30 00:00:00		2021-06-30 00:00:00		2021-03-31 00:00:00		2021-12-31 00:00:00		2022-09-30 00:00:00		2022-03-31 00:00:00		2022-06-30 00:00:00
cum_beg_dt		2018-01-01 00:00:00		2018-01-01 00:00:00		2019-01-01 00:00:00		2018-01-01 00:00:00		2019-01-01 00:00:00		2018-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00
firm_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
firm_name		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES
firm_city		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO
firm_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
firm_zip4		94080		94080		94080		94080		94080		94080		94080		94080		94080		94080		94080		94080		94080		94080		94080		94080		94080		94080		94080
firm_phon		800 347-7337		800 347-7337		800 347-7337		800 347-7337		800 347-7337		800 347-7337		800 347-7337		800 347-7337		800 347-7337		800 347-7337		800 347-7337		800 347-7337		800 347-7337		800 347-7337		800 347-7337		800 347-7337		800 347-7337		800 347-7337		800 347-7337
mail_city		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
mail_zip4		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
sig_date		2018-04-13 00:00:00		2018-07-13 00:00:00		2019-04-17 00:00:00		2019-01-22 00:00:00		2019-07-16 00:00:00		2018-10-17 00:00:00		2020-04-20 00:00:00		2019-10-11 00:00:00		2020-01-12 00:00:00		2021-01-27 00:00:00		2020-10-13 00:00:00		2020-07-21 00:00:00		2021-10-18 00:00:00		2021-07-14 00:00:00		2021-04-20 00:00:00		2022-01-22 00:00:00		2022-10-16 00:00:00		2022-04-19 00:00:00		2022-07-21 00:00:00
sig_loc		SACRAMENTO, CA		SACRAMENTO, CA		SOUTH SAN FRANCISCO, CA		SOUTH SAN FRANCISCO, CA		SOUTH SAN FRANCISCO, CA		SACRAMENTO, CA		SOUTH SAN FRANCISCO, CA		SOUTH SAN FRANCISCO, CA		SOUTH SAN FRANCISCO, CA		SOUTH SAN FRANCISCO, CA		SOUTH SAN FRANCISCO, CA		SOUTH SAN FRANCISCO, CA		SOUTH SAN FRANCISCO, CA		SOUTH SAN FRANCISCO, CA		SOUTH SAN FRANCISCO, CA		SOUTH SAN FRANCISCO, CA		SOUTH SAN FRANCISCO, CA		SOUTH SAN FRANCISCO, CA		SOUTH SAN FRANCISCO, CA
sig_naml		EICHMAN, AGENT		EICHMAN, AGENT		KINSTLER		KINSTLER		EGAN		EICHMAN, AGENT		EGAN		EGAN		EGAN		EGAN		EGAN		EGAN		EGAN		EGAN		EGAN		EGAN		EGAN		EGAN		EGAN
sig_namf		J. RICHARD		J. RICHARD		BRAD		BRAD		PAT		J. RICHARD		PAT		PAT		PAT		PAT		PAT		PAT		PAT		PAT		PAT		PAT		PAT		PAT		PAT
sig_namt		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
prn_naml		EICHMAN, AGENT		EICHMAN, AGENT		KINSTLER		KINSTLER		EGAN		EICHMAN, AGENT		EGAN		EGAN		EGAN		EGAN		EGAN		EGAN		EGAN		EGAN		EGAN		EGAN		EGAN		EGAN		EGAN
prn_namf		J. RICHARD		J. RICHARD		BRAD		BRAD		PAT		J. RICHARD		PAT		PAT		PAT		PAT		PAT		PAT		PAT		PAT		PAT		PAT		PAT		PAT		PAT
prn_namt		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
sig_title		CERTIFIED PUBLIC ACCOUNTANT, 431100SSB		CERTIFIED PUBLIC ACCOUNTANT, 431100SSB		PRESIDENT/CHIEF EXECUTIVE OFFICER		PRESIDENT/CHIEF EXECUTIVE OFFICER		PRESIDENT/CHIEF EXECUTIVE OFFICER		CERTIFIED PUBLIC ACCOUNTANT, 431100SSB		PRESIDENT/CHIEF EXECUTIVE OFFICER		PRESIDENT/CHIEF EXECUTIVE OFFICER		PRESIDENT/CHIEF EXECUTIVE OFFICER		PRESIDENT/CHIEF EXECUTIVE OFFICER		PRESIDENT/CHIEF EXECUTIVE OFFICER		PRESIDENT/CHIEF EXECUTIVE OFFICER		PRESIDENT/CHIEF EXECUTIVE OFFICER		PRESIDENT/CHIEF EXECUTIVE OFFICER		PRESIDENT/CHIEF EXECUTIVE OFFICER		PRESIDENT/CHIEF EXECUTIVE OFFICER		PRESIDENT/CHIEF EXECUTIVE OFFICER		PRESIDENT/CHIEF EXECUTIVE OFFICER		PRESIDENT/CHIEF EXECUTIVE OFFICER
nopart1_cb		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
part1_1_cb		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
ctrib_n_cb		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
lby_actvty		ABs 274, 2632; ACA 2; SB 562		ABs 274, 2632; ACA 2		ABs 161, 1080; SB 54		ABs 274, 958, 2632; SB 1335; ACA 2; Legislature and Governor's Office re: Budget and Food Dyes		ABs 161, 1080; SB 54		ABs 274, 958, 2632; SB 1335; ACA 2; Legislature and Governor's Office re: Budget and Food Dyes		ABs 161, 1080; SB 54		ABs 161, 1080; SB 54		ABs 161, 1080; SB 54		ABs 161, 1080; SB 54; Office of Environmental Health Hazard Assessment re: Proposition 65		ABs 161, 1080; SB 54; Office of Environmental Health Hazard Assessment re: Proposition 65		ABs 161, 1080; SB 54		AB 693, 1201 1371; SB 54, 343; Occupational Safety & Health Standards Board re: COVID-19 Prevention Emergency Regulations		AB 693, 1201 1371; SB 54, 343; Occupational Safety & Health Standards Board re: COVID-19 Prevention Emergency Regulations		NONE		ABs 693, 1201, 1371; SBs 54, 343; Occupational Safety & Health Standards Board re: COVID-19 Prevention Emergency Regulations; California State Transportation Agency and California Department of Transportation re: Supply Chain, Goods Movement, and Ports Executive Order		ABs 2026, 2784; SB 54; Occupational Safety & Health Standards Board re: COVID-19 Prevention Emergency Temporary Standards; California State Transportation Agency and California Department of Transportation re: Supply Chain, Goods Movement, and Ports Executive Order		ABs 693, 1371; SB 54; Occupational Safety & Health Standards Board re: COVID-19 Prevention Emergency Temporary Standards; California State Transportation Agency and California Department of Transportation: Supply Chain, Goods Movement, and Ports Executive Order		ABs 2026, 2784; SB 54; Occupational Safety & Health Standards Board re: COVID-19 Prevention Emergency Temporary Standards; California State Transportation Agency and California Department of Transportation re: Supply Chain, Goods Movement, and Ports Executive Order
lobby_n_cb		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
major_naml		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
major_namt		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
rcpcmte_nm		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

Table: cvr_registration

filing_id		2198193		2330631		2539150
amend_id		0		0		0
rec_type		CVR		CVR		CVR
form_type		F602		F602		F602
sender_id		F00729		F00729		F00729
filer_id		1400562		1400562		1400562
entity_cd		LEM		LEM		LEM
filer_naml		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES
filer_namf		None		None		None
filer_namt		None		None		None
filer_nams		None		None		None
report_num		000		000		000
rpt_date		2018-01-01 00:00:00		2018-11-27 00:00:00		2020-11-12 00:00:00
ls_beg_yr		2017		2019		2021
ls_end_yr		2018		2020		2022
qual_date		None		None		None
eff_date		2018-01-01 00:00:00		2019-01-01 00:00:00		2021-01-01 00:00:00
bus_city		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO
bus_st		CA		CA		CA
bus_zip4		94080		94080		94080
bus_phon		800-347-7337		(800) 347-7337		(800) 347-7337
bus_fax		None		None		None
bus_email		None		None		None
mail_city		None		None		None
mail_st		None		None		None
mail_zip4		None		None		None
mail_phon		None		None		None
sig_date		2017-11-08 00:00:00		2018-11-27 00:00:00		2020-11-12 00:00:00
sig_loc		SOUTH SAN FRANCISCO, CA		SOUTH SAN FRANCISCO, CA		SOUTH SAN FRANCISCO, CA
sig_naml		KINSTLER		KINSTLER		EGAN
sig_namf		BRAD		BRAD		PAT
sig_namt		None		None		None
sig_nams		None		None		None
prn_naml		KINSTLER		KINSTLER		EGAN
prn_namf		BRAD		BRAD		PAT
prn_namt		None		None		None
prn_nams		None		None		None
sig_title		PRESIDENT & CEO 4311KAU		PRESIDENT/CHIEF EXECUTIVE OFFICER		PRESIDENT/CHIEF EXECUTIVE OFFICER
stmt_firm		None		None		None
ind_cb		None		None		None
bus_cb		X		X		X
trade_cb		None		None		None
oth_cb		None		None		None
a_b_name		None		None		None
a_b_city		None		None		None
a_b_st		None		None		None
a_b_zip4		None		None		None
descrip_1		CONFECTIONER		CONFECTIONER		CONFECTIONER
descrip_2		None		None		None
c_less50		None		None		None
c_more50		None		None		None
ind_class		None		None		None
ind_descr		None		None		None
bus_class		MAN		MAN		MAN
bus_descr		None		None		None
auth_name		CALIFORNIA ADVOCATES , INC.		CALIFORNIA ADVOCATES , INC.		CALIFORNIA ADVOCATES , INC.
auth_city		SACRAMENTO		SACRAMENTO		SACRAMENTO
auth_st		CA		CA		CA
auth_zip4		95814		95814		95814
lobby_int		None		None		None
influen_yn		None		None		None
firm_name		None		None		None
newcert_cb		None		None		None
rencert_cb		None		None		None
complet_dt		None		None		None
lby_reg_cb		None		None		None
lby_604_cb		None		None		None
st_leg_yn		None		None		None
st_agency		None		None		None
lobby_cb		None		None		None
l_firm_cb		None		None		None

Table: filer_address

filer_id		1400562		1400562		1400562		1400562
adrid		2552067		2442449		2469233		2508502
effect_dt		2023-01-01 00:00:00		2018-01-01 00:00:00		2019-01-01 00:00:00		2021-01-01 00:00:00
add_type		7051		7051		7051		7051
session_id		2023		2017		2019		2021

Table: filer_filings

filer_id		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562
filing_id		2197773		2197775		2468023		2412942		2330631		2481434		2198193		2241155		2392766		2346402		2553821		2375938		2317820		2273130		2435754		2539150		2363392		2638491		2525810		2675170		2573314		2578542		2705254		2618573		2596323		2741228
period_id		None		None		241		239		236		242		233		233		238		236		244		237		235		234		240		244		None		248		243		249		None		245		250		247		246		251
form_id		F602		F999		F635		F635		F602		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F602		F602		F635		F635		F635		F602		F635		F635		F635		F635		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
filing_date		2017-12-05 00:00:00		2017-12-05 00:00:00		2020-04-28 00:00:00		2019-10-14 00:00:00		2018-12-28 00:00:00		2020-07-27 00:00:00		2017-12-12 00:00:00		2018-04-30 00:00:00		2019-07-24 00:00:00		2019-01-30 00:00:00		2021-02-01 00:00:00		2019-04-23 00:00:00		2018-10-30 00:00:00		2018-07-30 00:00:00		2020-01-25 00:00:00		2020-12-29 00:00:00		2018-12-28 00:00:00		2022-01-26 00:00:00		2020-10-28 00:00:00		2022-04-29 00:00:00		2020-12-30 00:00:00		2021-04-28 00:00:00		2022-07-30 00:00:00		2021-10-24 00:00:00		2021-07-25 00:00:00		2022-10-25 00:00:00
stmnt_type		10005		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10005		10001		10001		10001		10001		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11001		11003
session_id		2017		2017		2019		2019		2019		2019		2017		2017		2019		2017		2019		2019		2017		2017		2019		2021		2019		2021		2019		2021		2021		2021		2021		2021		2021		2021
user_id		GPEREZ		GPEREZ		GTAYLOR		SUSHAKOV		YRODRIGU		MKIRKHAM		CAFILER		AGLADNEY		SUSHAKOV		AGLADNEY		JMAVES		VUKSTINA		AGLADNEY		AGLADNEY		GTAYLOR		AROJAS		YRODRIGU		CHATRIDGE		MKIRKHAM		CAFILER		AROJAS		CHATRIDGE		CAFILER		GTAYLOR		MKIRKHAM		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
fine_audit		11003		11003		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11003		11003		11001		11003		11001		11001		11003
rpt_start		1900-01-01 00:00:00		1900-01-01 00:00:00		2020-01-01 00:00:00		2019-07-01 00:00:00		2018-11-27 00:00:00		2020-04-01 00:00:00		2018-01-01 00:00:00		2018-01-01 00:00:00		2019-04-01 00:00:00		2018-10-01 00:00:00		2020-10-01 00:00:00		2019-01-01 00:00:00		2018-07-01 00:00:00		2018-04-01 00:00:00		2019-10-01 00:00:00		2020-11-12 00:00:00		1900-01-01 00:00:00		2021-10-01 00:00:00		2020-07-01 00:00:00		2022-01-01 00:00:00		1900-01-01 00:00:00		2021-01-01 00:00:00		2022-04-01 00:00:00		2021-07-01 00:00:00		2021-04-01 00:00:00		2022-07-01 00:00:00
rpt_end		1900-01-01 00:00:00		1900-01-01 00:00:00		2020-03-31 00:00:00		2019-09-30 00:00:00		2018-11-27 00:00:00		2020-06-30 00:00:00		2018-01-01 00:00:00		2018-03-31 00:00:00		2019-06-30 00:00:00		2018-12-31 00:00:00		2020-12-31 00:00:00		2019-03-31 00:00:00		2018-09-30 00:00:00		2018-06-30 00:00:00		2019-12-31 00:00:00		2020-11-12 00:00:00		1900-01-01 00:00:00		2021-12-31 00:00:00		2020-09-30 00:00:00		2022-03-31 00:00:00		1900-01-01 00:00:00		2021-03-31 00:00:00		2022-06-30 00:00:00		2021-09-30 00:00:00		2021-06-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
filing_type		None		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		None		22001		22001		22001		22001		22001

Table: filer_interests

filer_id		1400562		1400562		1400562		1400562
session_id		2017		2019		2021		2023
interest_cd		40310		40310		40310		40310
effect_date		2018-01-01 00:00:00		2019-01-01 00:00:00		2021-01-01 00:00:00		2023-01-01 00:00:00

Table: filer_to_filer_type

filer_id		1400562		1400562		1400562		1400562
filer_type		1		1		1		1
active		Y		Y		Y		N
race		None		0		None		None
session_id		2019		2017		2021		2023
category		None		0		None		None
category_type		None		0		None		None
sub_category		None		0		None		None
effect_dt		2019-01-01 00:00:00		2018-01-01 00:00:00		2021-01-01 00:00:00		2023-01-01 00:00:00
sub_category_type		None		0		None		None
election_type		None		0		None		None
sub_category_a		None		None		None		None
nyq_dt		None		None		None		None
party_cd		None		0		None		None
county_cd		None		0		None		None
district_cd		None		0		None		None

Table: filer_xref

filer_id		1400562
xref_id		1400562
effect_dt		2017-12-06 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562
filer_id		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562		1400562
filer_type		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
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
naml		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES		SEE'S CANDIES
namf		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
nams		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
adr2		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
city		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO		SOUTH SAN FRANCISCO
st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		94080		94080		94080		94080		94080		94080		94080		94080		94080		94080		94080		94080		94080		94080		94080		94080
phon		8003477337		8003477337		8003477337		8003477337		8003477337		8003477337		8003477337		8003477337		8003477337		8003477337		8003477337		8003477337		8003477337		8003477337		8003477337		8003477337
fax		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
email		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filers

filer_id		1400562

Table: lobbying_chg_log

filer_id		1400562
change_no		1
session_id		2017
log_dt		2017-12-05 00:00:00
filer_type		2
correction_flg		Y
action		ADDED
attribute_changed		FIRM
ethics_dt		None
interests		None
filer_full_name		SEE'S CANDIES
filer_city		SOUTH SAN FRANCISCO
filer_st		CA
filer_zip		94080
filer_phone		8003477337
entity_type		3
entity_name		CALIFORNIA ADVOCATES, INC.
entity_city		None
entity_st		None
entity_zip		None
entity_phone		None
entity_id		None
responsible_officer		None
effect_dt		2017-01-01 00:00:00