Home

Filer ID: 1418169

Table: cvr_lobby_disclosure

filing_id		2394566		2417529		2440433		2469407		2483335		2550819		2528203
amend_id		0		0		0		0		0		0		0
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F635		F635		F635		F635		F635		F635		F635
sender_id		1418169		1418169		1418169		1418169		1418169		1418169		1418169
filer_id		1418169		1418169		1418169		1418169		1418169		1418169		1418169
entity_cd		LEM		LEM		LEM		LEM		LEM		LEM		LEM
filer_naml		KEPRO		KEPRO		KEPRO		KEPRO		KEPRO		KEPRO		KEPRO
filer_namf		None		None		None		None		None		None		None
filer_namt		None		None		None		None		None		None		None
filer_nams		None		None		None		None		None		None		None
report_num		000		000		000		000		000		000		000
rpt_date		2019-07-31 00:00:00		2019-10-31 00:00:00		2020-01-31 00:00:00		2020-04-30 00:00:00		2020-07-31 00:00:00		2021-01-31 00:00:00		2020-10-31 00:00:00
from_date		2019-04-01 00:00:00		2019-07-01 00:00:00		2019-10-01 00:00:00		2020-01-01 00:00:00		2020-04-01 00:00:00		2020-10-01 00:00:00		2020-07-01 00:00:00
thru_date		2019-06-30 00:00:00		2019-09-30 00:00:00		2019-12-31 00:00:00		2020-03-31 00:00:00		2020-06-30 00:00:00		2020-12-31 00:00:00		2020-09-30 00:00:00
cum_beg_dt		2019-04-01 00:00:00		2019-04-01 00:00:00		2019-04-01 00:00:00		2019-04-01 00:00:00		2019-04-01 00:00:00		2019-04-01 00:00:00		2019-04-01 00:00:00
firm_id		1418169		1418169		1418169		1418169		1418169		1418169		1418169
firm_name		KEPRO		KEPRO		KEPRO		KEPRO		KEPRO		KEPRO		KEPRO
firm_city		Harrisburg		Harrisburg		Harrisburg		Harrisburg		Harrisburg		Harrisburg		Harrisburg
firm_st		PA		PA		PA		PA		PA		PA		PA
firm_zip4		17111		17111		17111		17111		17111		17111		17111
firm_phon		415 903-2800		415 903-2800		415 903-2800		415 903-2800		415 903-2800		415 903-2800		415 903-2800
mail_city		Sausalito		Sausalito		Sausalito		Sausalito		Sausalito		Sausalito		Sausalito
mail_st		CA		CA		CA		CA		CA		CA		CA
mail_zip4		94965		94965		94965		94965		94965		94965		94965
mail_phon		None		None		None		None		None		None		None
sig_date		2019-07-29 00:00:00		2019-10-31 00:00:00		2020-01-31 00:00:00		2020-04-30 00:00:00		2020-07-31 00:00:00		2021-01-31 00:00:00		2020-10-31 00:00:00
sig_loc		Sausalito, CA		Sausalito, CA		Sausalito, CA		Sausalito, CA		Sausalito, CA		Sausalito, CA		Sausalito, CA
sig_naml		Skelton		Skelton		Skelton		Skelton		Skelton		Skelton		Skelton
sig_namf		Jennie Unger		Jennie Unger		Jennie Unger		Jennie Unger		Jennie Unger		Jennie Unger		Jennie Unger
sig_namt		None		None		None		None		None		None		None
sig_nams		None		None		None		None		None		None		None
prn_naml		Skelton		Skelton		Skelton		Skelton		Skelton		Skelton		Skelton
prn_namf		Jennie Unger		Jennie Unger		Jennie Unger		Jennie Unger		Jennie Unger		Jennie Unger		Jennie Unger
prn_namt		None		None		None		None		None		None		None
prn_nams		None		None		None		None		None		None		None
sig_title		Attorney & Agent for Filer		Attorney & Agent for Filer		Attorney & Agent for Filer		Attorney & Agent for Filer		Attorney & Agent for Filer		Attorney & Agent for Filer		Attorney & Agent for Filer
nopart1_cb		None		None		None		None		None		None		None
nopart2_cb		None		None		None		None		None		None		None
part1_1_cb		None		None		None		None		None		None		None
part1_2_cb		None		None		None		None		None		None		None
ctrib_n_cb		X		X		X		X		X		X		X
ctrib_y_cb		None		None		None		None		None		None		None
lby_actvty		PERS, Dept. of Managed Health Care re:: health		Dept. of Health Care Services, Department of Managed Health, PERS re: healthcare management		Dept. of Health Care Services, Department of Managed Health, PERS re: healthcare management		Dept. of Health Care Services, CalPERS RE: Health Management		None this period		None this period		None this period
lobby_n_cb		None		None		None		None		None		None		None
lobby_y_cb		None		None		None		None		None		None		None
major_naml		None		None		None		None		None		None		None
major_namf		None		None		None		None		None		None		None
major_namt		None		None		None		None		None		None		None
major_nams		None		None		None		None		None		None		None
rcpcmte_nm		None		None		None		None		None		None		None
rcpcmte_id		None		None		None		None		None		None		None

Table: filer_address

filer_id		1418169		1418169
adrid		2478792		2478790
effect_dt		2019-04-01 00:00:00		2019-04-01 00:00:00
add_type		7082		7051
session_id		2019		2019

Table: filer_filings

filer_id		1418169		1418169		1418169		1418169		1418169		1418169		1418169		1418169		1418169
filing_id		2376296		2376299		2483335		2417529		2440433		2469407		2394566		2528203		2550819
period_id		None		None		242		239		240		241		238		243		244
form_id		F602		F999		F635		F635		F635		F635		F635		F635		F635
filing_sequence		0		0		0		0		0		0		0		0		0
filing_date		2019-04-03 00:00:00		2019-04-03 00:00:00		2020-07-29 00:00:00		2019-10-30 00:00:00		2020-01-30 00:00:00		2020-04-29 00:00:00		2019-07-29 00:00:00		2020-10-30 00:00:00		2021-01-29 00:00:00
stmnt_type		10005		10005		10001		10001		10001		10001		10001		10001		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001
session_id		2019		2019		2019		2019		2019		2019		2019		2019		2019
user_id		GPEREZ		GPEREZ		GTAYLOR		VUKSTINA		GTAYLOR		GTAYLOR		VUKSTINA		GTAYLOR		GTAYLOR
special_audit		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11003		11003		11001		11001		11001		11001		11001		11001		11001
rpt_start		1900-01-01 00:00:00		1900-01-01 00:00:00		2020-04-01 00:00:00		2019-07-01 00:00:00		2019-10-01 00:00:00		2020-01-01 00:00:00		2019-04-01 00:00:00		2020-07-01 00:00:00		2020-10-01 00:00:00
rpt_end		1900-01-01 00:00:00		1900-01-01 00:00:00		2020-06-30 00:00:00		2019-09-30 00:00:00		2019-12-31 00:00:00		2020-03-31 00:00:00		2019-06-30 00:00:00		2020-09-30 00:00:00		2020-12-31 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None
filing_type		None		None		22001		22001		22001		22001		22001		22001		22001

Table: filer_interests

filer_id		1418169
session_id		2019
interest_cd		40306
effect_date		2019-04-01 00:00:00

Table: filer_to_filer_type

filer_id		1418169
filer_type		1
active		Y
race		0
session_id		2019
category		0
category_type		0
sub_category		0
effect_dt		2019-04-01 00:00:00
sub_category_type		0
election_type		0
sub_category_a		None
nyq_dt		None
party_cd		0
county_cd		0
district_cd		0

Table: filer_xref

filer_id		1418169
xref_id		1418169
effect_dt		2019-04-23 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1418169		1418169
filer_id		1418169		1418169
filer_type		CLIENT		CLIENT
status		ACTIVE		ACTIVE
effect_dt		2019-04-01 00:00:00		2019-04-01 00:00:00
naml		KEPRO		KEPRO
namf		None		None
namt		None		None
nams		None		None
adr1		None		None
adr2		None		None
city		HARRISBURG		SAUSALITO
st		PA		CA
zip4		17111		94965
phon		4159032800
fax		4156107604
email		[email protected]		None

Table: filers

filer_id		1418169