Home

Filing ID: 1921086

PDF: https://cal-access.sos.ca.gov/PDFGen/pdfgen.prg?filingid=1921086&amendid=8

Table: cvr2_registration

filing_id		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086
amend_id		2		0		3		4		5		6		1		7		8
line_item		1		1		1		1		1		1		1		1		1
rec_type		CVR2		CVR2		CVR2		CVR2		CVR2		CVR2		CVR2		CVR2		CVR2
form_type		F601		F601		F601		F601		F601		F601		F601		F601		F601
tran_id		9916		9916		9916		9916		9916		9916		9916		9916		9916
entity_cd		None		None		None		None		None		None		None		None		None
entity_id		L23988		L23988		L23988		L23988		L23988		L23988		L23988		L23988		L23988
enty_naml		TREAT		TREAT		TREAT		TREAT		TREAT		TREAT		TREAT		TREAT		TREAT
enty_namf		PAULA		PAULA		PAULA		PAULA		PAULA		PAULA		PAULA		PAULA		PAULA
enty_namt		None		None		None		None		None		None		None		None		None
enty_nams		None		None		None		None		None		None		None		None		None

Table: cvr_registration

filing_id		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086
amend_id		0		4		2		3		5		6		1		7		8
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F601		F601		F601		F601		F601		F601		F601		F601		F601
sender_id		F23987		F23987		F23987		F23987		F23987		F23987		F23987		F23987		F23987
filer_id		F23987		F23987		F23987		F23987		F23987		F23987		F23987		F23987		F23987
entity_cd		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM
filer_naml		PAULA TREAT		PAULA TREAT		PAULA TREAT		PAULA TREAT		PAULA TREAT		PAULA TREAT		PAULA TREAT		PAULA TREAT		PAULA TREAT
filer_namf		None		None		None		None		None		None		None		None		None
filer_namt		None		None		None		None		None		None		None		None		None
filer_nams		None		None		None		None		None		None		None		None		None
report_num		000		004		002		003		005		006		001		007		008
rpt_date		2014-12-29 00:00:00		2015-06-22 00:00:00		2015-05-14 00:00:00		2015-05-14 00:00:00		2015-06-24 00:00:00		2015-06-24 00:00:00		2015-03-31 00:00:00		2016-03-23 00:00:00		2016-05-20 00:00:00
ls_beg_yr		2015		2015		2015		2015		2015		2015		2015		2015		2015
ls_end_yr		2016		2016		2016		2016		2016		2016		2016		2016		2016
qual_date		None		None		None		None		None		None		None		None		None
eff_date		None		None		None		None		None		None		None		None		None
bus_city		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento
bus_st		CA		CA		CA		CA		CA		CA		CA		CA		CA
bus_zip4		95835		95835		95835		95835		95835		95835		95835		95835		95835
bus_phon		916-570-3613		916-570-3613		916-570-3613		916-570-3613		916-570-3613		916-570-3613		916-570-3613		916-570-3613		916-570-3613
bus_fax		916-570-3614		916-570-3614		916-570-3614		916-570-3614		916-570-3614		916-570-3614		916-570-3614		916-570-3614		916-570-3614
bus_email		None		None		None		None		None		None		None		None		None
mail_city		None		None		None		None		None		None		None		None		None
mail_st		None		None		None		None		None		None		None		None		None
mail_zip4		None		None		None		None		None		None		None		None		None
mail_phon		None		None		None		None		None		None		None		None		None
sig_date		2014-12-10 00:00:00		2015-06-22 00:00:00		2015-04-13 00:00:00		2015-04-21 00:00:00		2015-06-15 00:00:00		2015-06-15 00:00:00		2015-03-20 00:00:00		2016-03-15 00:00:00		2016-05-20 00:00:00
sig_loc		Sacramento CA		Sacramento CA		Sacramento CA		Sacramento CA		Sacramento CA		Sacramento CA		Sacramento CA		Sacramento CA		Sacramento CA
sig_naml		Treat		Treat		Treat		Treat		Treat		Treat		Treat		Treat		Treat
sig_namf		Paula		Paula		Paula		Paula		Paula		Paula		Paula		Paula		Paula
sig_namt		None		None		None		None		None		None		None		None		None
sig_nams		None		None		None		None		None		None		None		None		None
prn_naml		None		None		None		None		None		None		None		None		None
prn_namf		None		None		None		None		None		None		None		None		None
prn_namt		None		None		None		None		None		None		None		None		None
prn_nams		None		None		None		None		None		None		None		None		None
sig_title		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner
stmt_firm		Paula Treat		Paula Treat		Paula Treat		Paula Treat		Paula Treat		Paula Treat		Paula Treat		Paula Treat		Paula Treat
ind_cb		None		None		None		None		None		None		None		None		None
bus_cb		None		None		None		None		None		None		None		None		None
trade_cb		None		None		None		None		None		None		None		None		None
oth_cb		None		None		None		None		None		None		None		None		None
a_b_name		None		None		None		None		None		None		None		None		None
a_b_city		None		None		None		None		None		None		None		None		None
a_b_st		None		None		None		None		None		None		None		None		None
a_b_zip4		None		None		None		None		None		None		None		None		None
descrip_1		None		None		None		None		None		None		None		None		None
descrip_2		None		None		None		None		None		None		None		None		None
c_less50		None		None		None		None		None		None		None		None		None
c_more50		None		None		None		None		None		None		None		None		None
ind_class		None		None		None		None		None		None		None		None		None
ind_descr		None		None		None		None		None		None		None		None		None
bus_class		None		None		None		None		None		None		None		None		None
bus_descr		None		None		None		None		None		None		None		None		None
auth_name		None		None		None		None		None		None		None		None		None
auth_city		None		None		None		None		None		None		None		None		None
auth_st		None		None		None		None		None		None		None		None		None
auth_zip4		None		None		None		None		None		None		None		None		None
lobby_int		None		None		None		None		None		None		None		None		None
influen_yn		None		None		None		None		None		None		None		None		None
firm_name		None		None		None		None		None		None		None		None		None
newcert_cb		None		None		None		None		None		None		None		None		None
rencert_cb		None		None		None		None		None		None		None		None		None
complet_dt		None		None		None		None		None		None		None		None		None
lby_reg_cb		None		None		None		None		None		None		None		None		None
lby_604_cb		None		None		None		None		None		None		None		None		None
st_leg_yn		None		None		None		None		None		None		None		None		None
st_agency		None		None		None		None		None		None		None		None		None
lobby_cb		None		None		None		None		None		None		None		None		None
l_firm_cb		None		None		None		None		None		None		None		None		None

Table: filer_filings

filer_id		1147433		1147433		1147433		1147433		1147433		1147433		1147433		1147433		1147433
filing_id		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086
period_id		222		222		222		222		221		220		222		225		226
form_id		F601		F601		F601		F601		F601		F601		F601		F601		F601
filing_sequence		3		4		5		6		1		0		2		7		8
filing_date		2015-05-14 00:00:00		2015-06-22 00:00:00		2015-06-24 00:00:00		2015-06-24 00:00:00		2015-03-31 00:00:00		2014-12-29 00:00:00		2015-05-14 00:00:00		2016-03-23 00:00:00		2016-05-31 00:00:00
stmnt_type		10002		10002		10002		10002		10002		10001		10002		10002		10002
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001
session_id		2015		2015		2015		2015		2015		2015		2015		2015		2015
user_id		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		PBANFORD		YRODRIGU		YRODRIGU		GPEREZ		GPEREZ
special_audit		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11001		11001		11001		11001		11001		11001		11001		11003		11003
rpt_start		2015-05-14 00:00:00		2015-06-22 00:00:00		2015-06-24 00:00:00		2015-06-24 00:00:00		2015-03-31 00:00:00		2014-12-29 00:00:00		2015-05-14 00:00:00		2016-03-23 00:00:00		2016-05-20 00:00:00
rpt_end		2015-05-14 00:00:00		2015-06-22 00:00:00		2015-06-24 00:00:00		2015-06-24 00:00:00		2015-03-31 00:00:00		2014-12-29 00:00:00		2015-05-14 00:00:00		2016-03-23 00:00:00		2016-05-20 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None
filing_type		22001		22001		22001		22001		22001		22001		22001		22001		22001

Table: filings

filing_id		1921086
filing_type		22001

Table: hdr

filing_id		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086
amend_id		0		1		5		6		2		3		4		7		8
rec_type		HDR		HDR		HDR		HDR		HDR		HDR		HDR		HDR		HDR
ef_type		CAL		CAL		CAL		CAL		CAL		CAL		CAL		CAL		CAL
state_cd		CA		CA		CA		CA		CA		CA		CA		CA		CA
cal_ver		2.01		2.01		2.01		2.01		2.01		2.01		2.01		2.01		2.01
soft_name		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM		EASYDISCLOSURE.COM
soft_ver		1.10		1.10		1.10		1.10		1.10		1.10		1.10		1.10		1.10
hdrcomment		None		None		None		None		None		None		None		None		None

Table: lemp

filing_id		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086
amend_id		2		2		2		2		2		3		3		3		3		3		3		3		2		1		1		1		1		1		0		0		0		0		5		5		4		4		4		4		4		4		5		5		5		5		5		6		6		6		6		6		6		6		6		8		8		8		8		8		8		7		7		7		7		7		7		7
line_item		2		3		4		5		6		1		2		3		4		5		6		7		1		1		2		3		4		5		1		2		3		4		1		2		1		2		3		4		5		6		3		4		5		6		7		1		2		3		4		5		6		7		8		1		2		3		4		5		6		1		2		3		4		5		6		7
rec_type		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP		LEMP
form_type		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A
client_id		E00768		None		None		None		None		C27423		E00768		None		None		None		None		None		C27423		C27423		E00768		None		None		None		C27423		E00768		None		None		C27423		E00768		C27423		E00768		None		None		None		None		None		None		None		None		None		C27423		E00768		None		None		None		None		None		None		C27423		E00768		None		None		None		None		C27423		E00768		None		None		None		None		None
cli_naml		Southern California Edison		International Premium Cigar & Pipe Retailers Association		Cachil Dehe Band of Wintun Indians of Colusa		Johnson & Johnson Services Inc. and Affiliated Entities		California Plastics Recyclers		Pechanga Band of Luiseno Mission Indians		Southern California Edison		International Premium Cigar & Pipe Retailers Association		Cachil Dehe Band of Wintun Indians of Colusa		Johnson & Johnson Services Inc. and Affiliated Entities		California Plastics Recyclers		CIGNA Companies		Pechanga Band of Luiseno Mission Indians		Pechanga Band of Luiseno Mission Indians		Southern California Edison		International Premium Cigar & Pipe Retailers Association		Cachil Dehe Band of Wintun Indians of Colusa		Johnson & Johnson Services Inc. and Affiliated Entities		Pechanga Band of Luiseno Mission Indians		Southern California Edison		International Premium Cigar & Pipe Retailers Association		Cachil Dehe Band of Wintun Indians of Colusa		Pechanga Band of Luiseno Mission Indians		Southern California Edison		Pechanga Band of Luiseno Mission Indians		Southern California Edison		International Premium Cigar & Pipe Retailers Association		Cachil Dehe Band of Wintun Indians of Colusa		California Plastics Recyclers		CIGNA Companies		International Premium Cigar & Pipe Retailers Association		Cachil Dehe Band of Wintun Indians of Colusa		California Plastics Recyclers		CIGNA Companies		California Academy of Eye Physicians & Surgeons		Pechanga Band of Luiseno Mission Indians		Southern California Edison		International Premium Cigar & Pipe Retailers Association		Cachil Dehe Band of Wintun Indians of Colusa		California Plastics Recyclers		CIGNA Companies		California Academy of Eye Physicians & Surgeons		California Medical Association		Pechanga Band of Luiseno Mission Indians		Southern California Edison		Cachil Dehe Band of Wintun Indians of Colusa		California Plastics Recyclers		California Academy of Eye Physicians & Surgeons		California Medical Association		Pechanga Band of Luiseno Mission Indians		Southern California Edison		Cachil Dehe Band of Wintun Indians of Colusa		California Plastics Recyclers		CIGNA Companies		California Academy of Eye Physicians & Surgeons		California Medical Association
cli_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		None		None		None		None		None		None		None
cli_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		None		None		None		None		None		None		None
cli_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		None		None		None		None		None		None		None
cli_city		Rosemead		Columbus		Colusa		Sacramento		Sacramento		Temecula		Rosemead		Columbus		Colusa		Sacramento		Sacramento		Hartford		Temecula		Temecula		Rosemead		Columbus		Colusa		Sacramento		Temecula		Rosemead		Columbus		Colusa		Temecula		Rosemead		Temecula		Rosemead		Columbus		Colusa		Sacramento		Hartford		Columbus		Colusa		Sacramento		Hartford		San Francisco		Temecula		Rosemead		Columbus		Colusa		Sacramento		Hartford		San Francisco		Sacramento		Temecula		Rosemead		Colusa		Sacramento		San Francisco		Sacramento		Temecula		Rosemead		Colusa		Sacramento		Hartford		San Francisco		Sacramento
cli_st		CA		OH		CA		CA		CA		CA		CA		OH		CA		CA		CA		CT		CA		CA		CA		OH		CA		CA		CA		CA		OH		CA		CA		CA		CA		CA		OH		CA		CA		CT		OH		CA		CA		CT		CA		CA		CA		OH		CA		CA		CT		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CT		CA		CA
cli_zip4		91770		31904-3637		95932		95814		95814		92593		91770		31904-3637		95932		95814		95814		06152		92593		92593		91770		31904-3637		95932		95814		92593		91770		31904-3637		95932		92593		91770		92593		91770		31904-3637		95932		95814		06152		31904-3637		95932		95814		06152		94105		92593		91770		31904-3637		95932		95814		06152		94105		95814		92593		91770		95932		95814		94105		95814		92593		91770		95932		95814		06152		94105		95814
cli_phon		626-302-1952		706-494-1143		530-458-8231		916-443-0104		916-556-1776		951-676-2768		626-302-1952		706-494-1143		530-458-8231		916-443-0104		916-556-1776		860-226-2907		951-676-2768		951-676-2768		626-302-1952		706-494-1143		530-458-8231		916-443-0104		951-676-2768		626-302-1952		706-494-1143		530-458-8231		951-676-2768		626-302-1952		951-676-2768		626-302-1952		706-494-1143		530-458-8231		916-556-1776		860-226-2907		706-494-1143		530-458-8231		916-556-1776		860-226-2907		415-777-3937		951-676-2768		626-302-1952		706-494-1143		530-458-8231		916-556-1776		860-226-2907		415-777-3937		916-444-5532		951-676-2768		626-302-1952		530-458-8231		916-556-1776		415-777-3937		916-444-5532		951-676-2768		626-302-1952		530-458-8231		916-556-1776		860-226-2907		415-777-3937		916-444-5532
eff_date		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-03-20 00:00:00		2015-04-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-03-20 00:00:00		2015-04-01 00:00:00		2015-04-16 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-03-20 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		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-04-01 00:00:00		2015-04-16 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-04-01 00:00:00		2015-04-16 00:00:00		2015-06-15 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-04-01 00:00:00		2015-04-16 00:00:00		2015-06-15 00:00:00		2015-06-15 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-04-01 00:00:00		2015-06-15 00:00:00		2015-06-15 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-04-01 00:00:00		2015-04-16 00:00:00		2015-06-15 00:00:00		2015-06-15 00:00:00
con_period		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing		Ongoing
agencylist		Legislature Governors Office Lt. Governor's Office Dept of Finance Office of Emergency Services Office of Planning & Research EPA Resources Agency State & Consumer Services BOE		Legislature Governor's Office Board of Equalization Franchise Tax Board Dept of Finance		Legislature Governors Office Attorney General Department of Finance Environmental Protection Agency Health & Human Services Native American Heritage Commission Gambling Control Commission State Lotte		Legislature Governor's Office Dept of Consumer Affairs		Legislature Governor's Office Environmental Protection Agency Dept of Natural Resources Dept of Resources Recycling & Recovery		Legislature Governors Office Lt. Governors Office Attorney General State Treasurer State Controller Secretary of State Department of Justice Department of Finance Office of Homeland Security Office		Legislature Governors Office Lt. Governor's Office Dept of Finance Office of Emergency Services Office of Planning & Research EPA Resources Agency State & Consumer Services BOE		Legislature Governor's Office Board of Equalization Franchise Tax Board Dept of Finance		Legislature Governors Office Attorney General Department of Finance Environmental Protection Agency Health & Human Services Native American Heritage Commission Gambling Control Commission State Lotte		Legislature Governor's Office Dept of Consumer Affairs		Legislature Governor's Office Environmental Protection Agency Dept of Natural Resources Dept of Resources Recycling & Recovery		Legislature Governor's Office Dept of Insurance Dept of Health		Legislature Governors Office Lt. Governors Office Attorney General State Treasurer State Controller Secretary of State Department of Justice Department of Finance Office of Homeland Security Office		Legislature Governors Office Lt. Governors Office Attorney General State Treasurer State Controller Secretary of State Department of Justice Department of Finance Office of Homeland Security Office		Legislature Governors Office Lt. Governor's Office Dept of Finance Office of Emergency Services Office of Planning & Research EPA Resources Agency State & Consumer Services BOE		Legislature Governor's Office Board of Equalization Franchise Tax Board Dept of Finance		Legislature Governors Office Attorney General Department of Finance Environmental Protection Agency Health & Human Services Native American Heritage Commission Gambling Control Commission State Lotte		Legislature Governor's Office Dept of Consumer Affairs		Legislature Governors Office Lt. Governors Office Attorney General State Treasurer State Controller Secretary of State Department of Justice Department of Finance Office of Homeland Security Office		Legislature Governors Office Lt. Governor's Office Dept of Finance Office of Emergency Services Office of Planning & Research EPA Resources Agency State & Consumer Services BOE		Legislature Governor's Office Board of Equalization Franchise Tax Board Dept of Finance		Legislature Governors Office Attorney General Department of Finance Environmental Protection Agency Health & Human Services Native American Heritage Commission Gambling Control Commission State Lotte		Legislature Governors Office Lt. Governors Office Attorney General State Treasurer State Controller Secretary of State Department of Justice Department of Finance Office of Homeland Security Office		Legislature Governors Office Lt. Governor's Office Dept of Finance Office of Emergency Services Office of Planning & Research EPA Resources Agency State & Consumer Services BOE		Legislature Governors Office Lt. Governors Office Attorney General State Treasurer State Controller Secretary of State Department of Justice Department of Finance Office of Homeland Security Office		Legislature Governors Office Lt. Governor's Office Dept of Finance Office of Emergency Services Office of Planning & Research EPA Resources Agency State & Consumer Services BOE		Legislature Governor's Office Board of Equalization Franchise Tax Board Dept of Finance		Legislature Governors Office Attorney General Department of Finance Environmental Protection Agency Health & Human Services Native American Heritage Commission Gambling Control Commission State Lotte		Legislature Governor's Office Environmental Protection Agency Dept of Natural Resources Dept of Resources Recycling & Recovery		Legislature Governor's Office Dept of Insurance Dept of Health		Legislature Governor's Office Board of Equalization Franchise Tax Board Dept of Finance		Legislature Governors Office Attorney General Department of Finance Environmental Protection Agency Health & Human Services Native American Heritage Commission Gambling Control Commission State Lotte		Legislature Governor's Office Environmental Protection Agency Dept of Natural Resources Dept of Resources Recycling & Recovery		Legislature Governor's Office Dept of Insurance Dept of Health		Legislature Governor's Office		Legislature Governors Office Lt. Governors Office Attorney General State Treasurer State Controller Secretary of State Department of Justice Department of Finance Office of Homeland Security Office		Legislature Governors Office Lt. Governor's Office Dept of Finance Office of Emergency Services Office of Planning & Research EPA Resources Agency State & Consumer Services BOE		Legislature Governor's Office Board of Equalization Franchise Tax Board Dept of Finance		Legislature Governors Office Attorney General Department of Finance Environmental Protection Agency Health & Human Services Native American Heritage Commission Gambling Control Commission State Lotte		Legislature Governor's Office Environmental Protection Agency Dept of Natural Resources Dept of Resources Recycling & Recovery		Legislature Governor's Office Dept of Insurance Dept of Health		Legislature Governor's Office		Legislature Governor's Office		Legislature Governors Office Lt. Governors Office Attorney General State Treasurer State Controller Secretary of State Department of Justice Department of Finance Office of Homeland Security Office		Legislature Governors Office Lt. Governor's Office Dept of Finance Office of Emergency Services Office of Planning & Research EPA Resources Agency State & Consumer Services BOE		Legislature Governors Office Attorney General Department of Finance Environmental Protection Agency Health & Human Services Native American Heritage Commission Gambling Control Commission State Lotte		Legislature Governor's Office Environmental Protection Agency Dept of Natural Resources Dept of Resources Recycling & Recovery		Legislature Governor's Office		Legislature Governor's Office		Legislature Governors Office Lt. Governors Office Attorney General State Treasurer State Controller Secretary of State Department of Justice Department of Finance Office of Homeland Security Office		Legislature Governors Office Lt. Governor's Office Dept of Finance Office of Emergency Services Office of Planning & Research EPA Resources Agency State & Consumer Services BOE		Legislature Governors Office Attorney General Department of Finance Environmental Protection Agency Health & Human Services Native American Heritage Commission Gambling Control Commission State Lotte		Legislature Governor's Office Environmental Protection Agency Dept of Natural Resources Dept of Resources Recycling & Recovery		Legislature Governor's Office Dept of Insurance Dept of Health		Legislature Governor's Office		Legislature Governor's Office
descrip		Legislation regulations and policies relaitve to a provider of electric finance and consumer service		Regulations policy and issues relative to cigar & pipe industry		Legislation regulations and policies relative to indian tribes		Legislation policy and regulations relative to the manufacturer & sale of pharmaceuticals medical de		Legislation relative to PET recycling		Legislation regulations and policies relative to American Indian tribes		Legislation regulations and policies relaitve to a provider of electric finance and consumer service		Regulations policy and issues relative to cigar & pipe industry		Legislation regulations and policies relative to indian tribes		Legislation policy and regulations relative to the manufacturer & sale of pharmaceuticals medical de		Legislation relative to PET recycling		Legislation polices and regulations relative to health and life insurance		Legislation regulations and policies relative to American Indian tribes		Legislation regulations and policies relative to American Indian tribes		Legislation regulations and policies relaitve to a provider of electric finance and consumer service		Regulations policy and issues relative to cigar & pipe industry		Legislation regulations and policies relative to indian tribes		Legislation policy and regulations relative to the manufacturer & sale of pharmaceuticals medical de		Legislation regulations and policies relative to American Indian tribes		Legislation regulations and policies relaitve to a provider of electric finance and consumer service		Regulations policy and issues relative to cigar & pipe industry		Legislation regulations and policies relative to indian tribes		Legislation regulations and policies relative to American Indian tribes		Legislation regulations and policies relaitve to a provider of electric finance and consumer service		Legislation regulations and policies relative to American Indian tribes		Legislation regulations and policies relaitve to a provider of electric finance and consumer service		Regulations policy and issues relative to cigar & pipe industry		Legislation regulations and policies relative to indian tribes		Legislation relative to PET recycling		Legislation polices and regulations relative to health and life insurance		Regulations policy and issues relative to cigar & pipe industry		Legislation regulations and policies relative to indian tribes		Legislation relative to PET recycling		Legislation polices and regulations relative to health and life insurance		Legislation policies and regulations relative to eye physicians and surgeons		Legislation regulations and policies relative to American Indian tribes		Legislation regulations and policies relaitve to a provider of electric finance and consumer service		Regulations policy and issues relative to cigar & pipe industry		Legislation regulations and policies relative to indian tribes		Legislation relative to PET recycling		Legislation polices and regulations relative to health and life insurance		Legislation policies and regulations relative to eye physicians and surgeons		Legislation polices and regulations relative to the medical profession		Legislation regulations and policies relative to American Indian tribes		Legislation regulations and policies relaitve to a provider of electric finance and consumer service		Legislation regulations and policies relative to indian tribes		Legislation relative to PET recycling		Legislation policies and regulations relative to eye physicians and surgeons		Legislation polices and regulations relative to the medical profession		Legislation regulations and policies relative to American Indian tribes		Legislation regulations and policies relaitve to a provider of electric finance and consumer service		Legislation regulations and policies relative to indian tribes		Legislation relative to PET recycling		Legislation polices and regulations relative to health and life insurance		Legislation policies and regulations relative to eye physicians and surgeons		Legislation polices and regulations relative to the medical profession
subfirm_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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sub_name		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sub_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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sub_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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sub_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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sub_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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: lobby_amendments

filing_id		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086
amend_id		8		7		6		5		4		3		2		1
rec_type		F605		F605		F605		F605		F605		F605		F605		F605
form_type		F601		F601		F601		F601		F601		F601		F601		F601
exec_date		2016-05-20 00:00:00		2016-03-15 00:00:00		2015-06-15 00:00:00		2015-06-15 00:00:00		2015-06-22 00:00:00		2015-04-21 00:00:00		2015-04-13 00:00:00		2015-03-20 00:00:00
from_date		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		2015-01-01 00:00:00		2015-01-01 00:00:00
thru_date		2016-12-31 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00
add_l_cb		None		None		None		None		None		None		None		None
add_l_eff		None		None		None		None		None		None		None		None
a_l_naml		None		None		None		None		None		None		None		None
a_l_namf		None		None		None		None		None		None		None		None
a_l_namt		None		None		None		None		None		None		None		None
a_l_nams		None		None		None		None		None		None		None		None
del_l_cb		None		None		None		None		None		None		None		None
del_l_eff		None		None		None		None		None		None		None		None
d_l_naml		None		None		None		None		None		None		None		None
d_l_namf		None		None		None		None		None		None		None		None
d_l_namt		None		None		None		None		None		None		None		None
d_l_nams		None		None		None		None		None		None		None		None
add_le_cb		None		None		X		X		None		X		X		X
add_le_eff		None		None		2015-06-15 00:00:00		2015-06-15 00:00:00		None		2015-04-16 00:00:00		2015-04-01 00:00:00		2015-03-20 00:00:00
a_le_naml		None		None		California Medical Association		California Academy of Eye Physicians & Surgeons		None		CIGNA Companies		California Plastics Recyclers Coalition		Johnson & Johnson Services Inc. and Affiliated Entities
a_le_namf		None		None		None		None		None		None		None		None
a_le_namt		None		None		None		None		None		None		None		None
a_le_nams		None		None		None		None		None		None		None		None
del_le_cb		X		X		None		None		X		None		None		None
del_le_eff		2016-05-20 00:00:00		2016-03-13 00:00:00		None		None		2015-06-15 00:00:00		None		None		None
d_le_naml		Cigna Companies		International Premium Cigar & Pipe Retailers Association		None		None		Johnson & Johnson Services Inc. and Affiliated Entities		None		None		None
d_le_namf		None		None		None		None		None		None		None		None
d_le_namt		None		None		None		None		None		None		None		None
d_le_nams		None		None		None		None		None		None		None		None
add_lf_cb		None		None		None		None		None		None		None		None
add_lf_eff		None		None		None		None		None		None		None		None
a_lf_name		None		None		None		None		None		None		None		None
del_lf_cb		None		None		None		None		None		None		None		None
del_lf_eff		None		None		None		None		None		None		None		None
d_lf_name		None		None		None		None		None		None		None		None
other_cb		None		None		None		None		None		None		None		None
other_eff		None		None		None		None		None		None		None		None
other_desc		None		None		None		None		None		None		None		None
f606_yes		None		None		None		None		None		None		None		None
f606_no		None		None		None		None		None		None		None		None

Table: received_filings

filer_id		1147433		1147433		1147433		1147433		1147433		1147433		1147433		1147433		1147433
filing_file_name		1921086_3.cal		1921086_2.cal		1921086_5.cal		1921086_6.cal		1921086_4.cal		1921086_8.cal		1921086_7.cal		1921086_1.cal		1921086_0.cal
received_date		2015-05-14 00:00:00		2015-05-14 00:00:00		2015-06-24 00:00:00		2015-06-24 00:00:00		2015-06-22 00:00:00		2016-05-31 00:00:00		2016-03-23 00:00:00		2015-03-31 00:00:00		2014-12-29 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
filing_id		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086		1921086
form_id		F601		F601		F601		F601		F601		F601		F601		F601		F601
receive_comment		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted