Home

Filer ID: 1402009

Table: cvr_lobby_disclosure

filing_id		2213270		2213273		2213271		2213271		2213272		2213273		2213274		2213275		2213269		2213272		2213269		2213270		2213270		2213269		2213274		2213275		2213272		2213273		2213274		2213275		2213271
amend_id		0		0		2		1		1		1		1		1		2		0		1		1		2		0		0		0		2		2		2		2		0
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625
sender_id		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009
filer_id		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009
entity_cd		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM
filer_naml		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.
filer_namf		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
filer_nams		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		002		001		001		001		001		001		002		000		001		001		002		000		000		000		002		002		002		002		000
rpt_date		2018-02-05 00:00:00		2018-02-05 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-05 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-05 00:00:00		2018-02-05 00:00:00		2018-02-05 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-05 00:00:00
from_date		2013-01-01 00:00:00		2013-10-01 00:00:00		2013-04-01 00:00:00		2013-04-01 00:00:00		2013-07-01 00:00:00		2013-10-01 00:00:00		2014-01-01 00:00:00		2014-04-01 00:00:00		2012-10-01 00:00:00		2013-07-01 00:00:00		2012-10-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2012-10-01 00:00:00		2014-01-01 00:00:00		2014-04-01 00:00:00		2013-07-01 00:00:00		2013-10-01 00:00:00		2014-01-01 00:00:00		2014-04-01 00:00:00		2013-04-01 00:00:00
thru_date		2013-03-31 00:00:00		2013-12-31 00:00:00		2013-06-30 00:00:00		2013-06-30 00:00:00		2013-09-30 00:00:00		2013-12-31 00:00:00		2014-03-31 00:00:00		2014-06-30 00:00:00		2012-12-31 00:00:00		2013-09-30 00:00:00		2012-12-31 00:00:00		2013-03-31 00:00:00		2013-03-31 00:00:00		2012-12-31 00:00:00		2014-03-31 00:00:00		2014-06-30 00:00:00		2013-09-30 00:00:00		2013-12-31 00:00:00		2014-03-31 00:00:00		2014-06-30 00:00:00		2013-06-30 00:00:00
cum_beg_dt		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2012-10-01 00:00:00		2013-01-01 00:00:00		2012-10-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2012-10-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
firm_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
firm_name		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.
firm_city		San Francisco		San Francisco		San Francisco		San Francisco		San Francisco		San Francisco		San Francisco		San Francisco		San Francisco		San Francisco		San Francisco		San Francisco		San Francisco		San Francisco		San Francisco		San Francisco		San Francisco		San Francisco		San Francisco		San Francisco		San Francisco
firm_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
firm_zip4		94107		94107		94107		94107		94107		94107		94107		94107		94107		94107		94107		94107		94107		94107		94107		94107		94107		94107		94107		94107		94107
firm_phon		415-717-3228		415-717-3228		415-717-3228		415-717-3228		415-717-3228		415-717-3228		415-717-3228		415-717-3228		415-717-3228		415-717-3228		415-717-3228		415-717-3228		415-717-3228		415-717-3228		415-717-3228		415-717-3228		415-717-3228		415-717-3228		415-717-3228		415-717-3228		415-717-3228
mail_city		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
mail_zip4		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
sig_date		2018-02-05 00:00:00		2018-02-05 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-05 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-05 00:00:00		2018-02-05 00:00:00		2018-02-05 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-05 00:00:00
sig_loc		San Francisco, CA		San Francisco, CA		San Francisco, CA		San Francisco, CA		San Francisco, CA		San Francisco, CA		San Francisco, CA		San Francisco, CA		San Francisco, CA		San Francisco, CA		San Francisco, CA		San Francisco, CA		San Francisco, CA		San Francisco, CA		San Francisco, CA		San Francisco, CA		San Francisco, CA		San Francisco, CA		San Francisco, CA		San Francisco, CA		San Francisco, CA
sig_naml		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy
sig_namf		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.
sig_namt		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
prn_naml		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy		Kennedy
prn_namf		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.		Susan P.
prn_namt		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
sig_title		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner
nopart1_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
nopart2_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
part1_1_cb		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X
part1_2_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
ctrib_n_cb		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
lby_actvty		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
lobby_n_cb		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X
lobby_y_cb		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
major_namf		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
major_nams		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
rcpcmte_id		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		2214678		2214675		2214683
amend_id		0		0		0
rec_type		CVR		CVR		CVR
form_type		F601		F601		F606
sender_id		1402009		1402009		1402009
filer_id		1402009		1402009		1402009
entity_cd		FRM		FRM		FRM
filer_naml		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.
filer_namf		None		None		None
filer_namt		None		None		None
filer_nams		None		None		None
report_num		000		000		000
rpt_date		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00
ls_beg_yr		2013		2011		2013
ls_end_yr		2014		2012		2014
qual_date		None		None		None
eff_date		None		None		2014-06-30 00:00:00
bus_city		San Francisco		San Francisco		San Francisco
bus_st		CA		CA		CA
bus_zip4		94107		94107		94107
bus_phon		415-717-3228		415-717-3228		415-717-3228
bus_fax		None		None		None
bus_email		[email protected]		[email protected]		[email protected]
mail_city		None		None		None
mail_st		None		None		None
mail_zip4		None		None		None
mail_phon		None		None		None
sig_date		2018-02-09 00:00:00		2018-02-09 00:00:00		2018-02-09 00:00:00
sig_loc		San Francisco, CA		San Francisco, CA		San Francisco, CA
sig_naml		Kennedy		Kennedy		Kennedy
sig_namf		Susan P.		Susan P.		Susan P.
sig_namt		None		None		None
sig_nams		None		None		None
prn_naml		Kennedy		Kennedy		Kennedy
prn_namf		Susan P.		Susan P.		Susan P.
prn_namt		None		None		None
prn_nams		None		None		None
sig_title		Owner		Owner		Owner
stmt_firm		Susan P. Kennedy, Inc.		Susan P. Kennedy, Inc.		None
ind_cb		None		None		None
bus_cb		None		None		None
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		None		None		None
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		None		None		None
bus_descr		None		None		None
auth_name		None		None		None
auth_city		None		None		None
auth_st		None		None		None
auth_zip4		None		None		None
lobby_int		None		None		None
influen_yn		None		None		None
firm_name		None		None		Susan P. Kennedy, Inc.
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		1402009		1402009
adrid		2445143		2446228
effect_dt		2012-11-01 00:00:00		2013-01-01 00:00:00
add_type		7051		7051
session_id		2011		2013

Table: filer_filings

filer_id		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009		1402009
filing_id		2213273		2213269		2213270		2213270		2213271		2213269		2213274		2213275		2213271		2213270		2213272		2214678		2214683		2213271		2213272		2213273		2213274		2213275		2213269		2214675		2213272		2213273		2213274		2213275		2217237		2217254		2217344
period_id		216		212		213		213		214		212		217		218		214		213		215		233		233		214		215		216		217		218		212		233		215		216		217		218		None		None		None
form_id		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F601		F606		F625		F625		F625		F625		F625		F625		F601		F625		F625		F625		F625		F601		F601		F606
filing_sequence		0		1		1		2		2		0		0		0		0		0		0		0		0		1		1		1		1		1		2		0		2		2		2		2		0		0		0
filing_date		2018-02-05 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-05 00:00:00		2018-02-05 00:00:00		2018-02-05 00:00:00		2018-02-05 00:00:00		2018-02-05 00:00:00		2018-02-05 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-13 00:00:00		2018-02-13 00:00:00		2018-02-13 00:00:00
stmnt_type		10001		10002		10002		10002		10002		10001		10001		10001		10001		10001		10001		10001		10001		10002		10002		10002		10002		10002		10002		10001		10002		10002		10002		10002		10005		10005		10003
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
session_id		2013		2011		2013		2013		2013		2011		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2011		2011		2013		2013		2013		2013		2011		2013		2013
user_id		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		YRODRIGU		YRODRIGU		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		YRODRIGU		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		YRODRIGU		YRODRIGU		YRODRIGU
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
fine_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11003		11003
rpt_start		2013-10-01 00:00:00		2012-10-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-04-01 00:00:00		2012-10-01 00:00:00		2014-01-01 00:00:00		2014-04-01 00:00:00		2013-04-01 00:00:00		2013-01-01 00:00:00		2013-07-01 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2013-04-01 00:00:00		2013-07-01 00:00:00		2013-10-01 00:00:00		2014-01-01 00:00:00		2014-04-01 00:00:00		2012-10-01 00:00:00		2018-02-14 00:00:00		2013-07-01 00:00:00		2013-10-01 00:00:00		2014-01-01 00:00:00		2014-04-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00
rpt_end		2013-12-31 00:00:00		2012-12-31 00:00:00		2013-03-31 00:00:00		2013-03-31 00:00:00		2013-06-30 00:00:00		2012-12-31 00:00:00		2014-03-31 00:00:00		2014-06-30 00:00:00		2013-06-30 00:00:00		2013-03-31 00:00:00		2013-09-30 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2013-06-30 00:00:00		2013-09-30 00:00:00		2013-12-31 00:00:00		2014-03-31 00:00:00		2014-06-30 00:00:00		2012-12-31 00:00:00		2018-02-14 00:00:00		2013-09-30 00:00:00		2013-12-31 00:00:00		2014-03-31 00:00:00		2014-06-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 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
filing_type		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		None		None

Table: filer_to_filer_type

filer_id		1402009		1402009		1402009
filer_type		3		3		3
active		Y		Y		T
race		0		0		0
session_id		2011		2013		2013
category		0		0		0
category_type		0		0		0
sub_category		0		0		0
effect_dt		2012-11-01 00:00:00		2013-01-01 00:00:00		2014-06-30 00:00:00
sub_category_type		0		0		0
election_type		0		0		0
sub_category_a		None		None		None
nyq_dt		None		None		None
party_cd		0		0		0
county_cd		0		0		0
district_cd		0		0		0

Table: filer_xref

filer_id		1402009
xref_id		1402009
effect_dt		2018-02-05 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1402009		1402009		1402009		1402009
filer_id		1402009		1402009		1402009		1402009
filer_type		FIRM		FIRM		FIRM		FIRM
status		TERMINATED		TERMINATED		TERMINATED		TERMINATED
effect_dt		2014-06-30 00:00:00		2014-06-30 00:00:00		2014-06-30 00:00:00		2014-06-30 00:00:00
naml		KENNEDY, INC.; SUSAN P.		KENNEDY, INC.; SUSAN P.		KENNEDY, INC.; SUSAN P.		KENNEDY, INC.; SUSAN P.
namf		None		None		None		None
namt		None		None		None		None
nams		None		None		None		None
adr1		None		None		None		None
adr2		None		None		None		None
city		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO
st		CA		CA		CA		CA
zip4		94107		94107		94107		94107
phon		4157173228		4157173228		4157173228		4157173228
fax		None		None		None		None
email		[email protected]		[email protected]		[email protected]		[email protected]

Table: filers

filer_id		1402009

Table: received_filings

filer_id		1402009		1402009		1402009		1402009		1402009
filing_file_name		489242.cal		2214678_0.cal		2214683_0.cal		2214675_0.cal		488763.cal
received_date		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00		2018-02-14 00:00:00
filing_directory		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp
filing_id		None		2214678		2214683		2214675		None
form_id		None		F601		F606		F601		None
receive_comment		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation