Home

Filing ID: 1918755

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

Table: cvr2_registration

filing_id		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755
amend_id		0		1		2		3		4		5		6		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		9842		9842		9842		9842		9842		9842		9842		9842		9842
entity_cd		None		None		None		None		None		None		None		None		None
entity_id		L01998		L01998		L01998		L01998		L01998		L01998		L01998		L01998		L01998
enty_naml		Lovell		Lovell		Lovell		Lovell		Lovell		Lovell		Lovell		Lovell		Lovell
enty_namf		John		John		John		John		John		John		John		John		John
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		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755
amend_id		0		1		2		3		4		5		6		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		F24508		F24508		F24508		F24508		F24508		F24508		F24508		F24508		F24508
filer_id		F24508		F24508		F24508		F24508		F24508		F24508		F24508		F24508		F24508
entity_cd		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM
filer_naml		LOVELL LAW OFFICES OF JOHN		LOVELL LAW OFFICES OF JOHN		LOVELL LAW OFFICES OF JOHN		LOVELL LAW OFFICES OF JOHN		LOVELL LAW OFFICES OF JOHN		LOVELL LAW OFFICES OF JOHN		LOVELL LAW OFFICES OF JOHN		LOVELL LAW OFFICES OF JOHN		LOVELL; LAW OFFICES OF JOHN
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		001		002		003		004		005		006		007		008
rpt_date		2014-11-29 00:00:00		2014-11-29 00:00:00		2015-01-20 00:00:00		2016-01-05 00:00:00		2016-07-15 00:00:00		2016-07-15 00:00:00		2017-05-26 00:00:00		2017-05-26 00:00:00		2017-10-23 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		2014-12-01 00:00:00		2014-12-01 00:00:00		2014-12-01 00:00:00		2014-12-01 00:00:00		2014-12-01 00:00:00		2014-12-01 00:00:00		2014-12-01 00:00:00		2014-12-01 00:00:00		2014-12-01 00:00:00
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		95814		95814		95814		95814		95814		95814		95814		95814		95814
bus_phon		916-261-7188		916-261-7188		916-261-7188		9162617188		9162617188		9162617188		9162617188		9162617188		9162617188
bus_fax		None		None		None		None		None		None		None		None		None
bus_email		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]
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-01 00:00:00		2015-01-08 00:00:00		2015-01-20 00:00:00		2016-01-05 00:00:00		2016-07-14 00:00:00		2016-07-15 00:00:00		2017-05-26 00:00:00		2017-05-26 00:00:00		2017-10-23 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		Lovell		Lovell		Lovell		Lovell		Huddleston		Lovell		Lovell		Lovell		Lovell
sig_namf		John		John		John		John		Mindy		John		John		John		John
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		Lovell		Huddleston		Lovell		Lovell		Lovell		Lovell
prn_namf		None		None		None		John		Mindy		John		John		John		John
prn_namt		None		None		None		None		None		None		None		None		None
prn_nams		None		None		None		None		None		None		None		None		None
sig_title		None		None		None		Owner		Director		Managing Partner		Managing Partner		Managing Partner		Managing Partner
stmt_firm		LAW OFFICES OF JOHN LOVELL		LAW OFFICES OF JOHN LOVELL		LAW OFFICES OF JOHN LOVELL		LAW OFFICES OF JOHN LOVELL		LAW OFFICES OF JOHN LOVELL		LAW OFFICES OF JOHN LOVELL		LAW OFFICES OF JOHN LOVELL		LAW OFFICES OF JOHN LOVELL		LAW OFFICES OF JOHN LOVELL
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		1147451		1147451		1147451		1147451		1147451		1147451		1147451		1147451		1147451
filing_id		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755
period_id		221		220		220		225		232		227		227		230		230
form_id		F601		F601		F601		F601		F601		F601		F601		F601		F601
filing_sequence		2		0		1		3		8		4		5		7		6
filing_date		2015-01-28 00:00:00		2014-12-17 00:00:00		2015-01-09 00:00:00		2016-01-05 00:00:00		2017-10-23 00:00:00		2016-07-15 00:00:00		2016-07-15 00:00:00		2017-05-26 00:00:00		2017-05-26 00:00:00
stmnt_type		10002		10001		10002		10002		10002		10002		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		SARRIAGA		YRODRIGU		GPEREZ		GPEREZ		GPEREZ		GPEREZ		GPEREZ		GPEREZ
special_audit		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11001		11003		11001		11003		11003		11003		11003		11003		11003
rpt_start		2015-01-20 00:00:00		2014-11-29 00:00:00		2014-11-29 00:00:00		2016-01-05 00:00:00		2017-10-23 00:00:00		2016-07-15 00:00:00		2016-07-15 00:00:00		2017-05-26 00:00:00		2017-05-26 00:00:00
rpt_end		2015-01-20 00:00:00		2014-11-29 00:00:00		2014-11-29 00:00:00		2016-01-05 00:00:00		2017-10-23 00:00:00		2016-07-15 00:00:00		2016-07-15 00:00:00		2017-05-26 00:00:00		2017-05-26 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None
filing_type		22001		22001		22001		22006		22006		22006		22006		22006		22006

Table: filings

filing_id		1918755
filing_type		22001

Table: hdr

filing_id		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755
amend_id		1		0		2		3		4		5		6		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		CAL-ACCESS OBJECT MODEL		CAL-ACCESS OBJECT MODEL		CAL-ACCESS OBJECT MODEL		CAL-ACCESS OBJECT MODEL		CAL-ACCESS OBJECT MODEL		CAL-ACCESS OBJECT MODEL
soft_ver		1.10		1.10		1.10		1.00		1.00		1.00		1.00		1.00		1.00
hdrcomment		None		None		None		None		None		None		None		None		None

Table: lemp

filing_id		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755
amend_id		2		2		2		2		2		2		1		1		1		1		1		0		0		0		0		0		5		5		5		5		5		5		5		5		5		4		4		4		4		4		4		4		4		3		3		3		3		3		3		3		6		6		6		6		6		6		6		6		7		7		7		7		7		7		7		8		8		8		8		8		8		8
line_item		1		2		3		4		5		6		1		2		3		4		5		1		2		3		4		5		1		2		3		4		5		6		7		8		9		1		2		3		4		5		6		7		8		1		2		3		4		5		6		7		1		2		3		4		5		6		7		8		1		2		3		4		5		6		7		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		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		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A
client_id		C00829		C28038		C28289		C27641		1297682		1374268		C00829		C28038		C28289		C27641		1297682		C00829		C28038		C28289		C27641		1297682		C00829		C28038		C28289		C27641		1297682		1374268		None		None		None		C00829		C28038		C28289		C27641		1297682		1374268		None		None		C00829		C28038		C28289		C27641		1297682		1374268		None		C00829		C28038		C28289		C27641		1297682		None		None		None		C00829		C28038		C28289		C27641		1297682		None		None		C00829		C28038		C28289		C27641		1297682		None		None
cli_naml		California Police Chiefs' Association		California Narcotic Officers' Association		California Correctional Supervisors Organization Inc.		California Association of Code Enforcement Officers		CALIFORNIA COLLEGE AND UNIVERSITY POLICE CHIEFS ASSOCIATION		CAR DEALERS SAVING LIVES		California Police Chiefs' Association		California Narcotic Officers' Association		California Correctional Supervisors Organization Inc.		California Association of Code Enforcement Officers		CALIFORNIA COLLEGE AND UNIVERSITY POLICE CHIEFS ASSOCIATION		California Police Chiefs' Association		California Narcotic Officers' Association		California Correctional Supervisors Organization Inc.		California Association of Code Enforcement Officers		CALIFORNIA COLLEGE AND UNIVERSITY POLICE CHIEFS ASSOCIATION		California Police Chiefs' Association		California Narcotic Officers' Association		California Correctional Supervisors Organization Inc.		California Association of Code Enforcement Officers		CALIFORNIA COLLEGE AND UNIVERSITY POLICE CHIEFS ASSOCIATION		CAR DEALERS SAVING LIVES		Los Angeles County Professional Peace Officers Association		Alcohol Monitoring Systems		Alcohol Monitoring Systems		California Police Chiefs' Association		California Narcotic Officers' Association		California Correctional Supervisors Organization Inc.		California Association of Code Enforcement Officers		CALIFORNIA COLLEGE AND UNIVERSITY POLICE CHIEFS ASSOCIATION		CAR DEALERS SAVING LIVES		Los Angeles County Professional Peace Officers Association		Alcohol Monitoring Systems		California Police Chiefs' Association		California Narcotic Officers' Association		California Correctional Supervisors Organization Inc.		California Association of Code Enforcement Officers		CALIFORNIA COLLEGE AND UNIVERSITY POLICE CHIEFS ASSOCIATION		CAR DEALERS SAVING LIVES		Los Angeles County Professional Peace Officers Association		California Police Chiefs' Association		California Narcotic Officers' Association		California Correctional Supervisors Organization Inc.		California Association of Code Enforcement Officers		CALIFORNIA COLLEGE AND UNIVERSITY POLICE CHIEFS ASSOCIATION		Los Angeles County Professional Peace Officers Association		Alcohol Monitoring Systems		Alcohol Monitoring Systems		California Police Chiefs' Association		California Narcotic Officers' Association		California Correctional Supervisors Organization Inc.		California Association of Code Enforcement Officers		CALIFORNIA COLLEGE AND UNIVERSITY POLICE CHIEFS ASSOCIATION		Los Angeles County Professional Peace Officers Association		Alcohol Monitoring Systems		California Police Chiefs' Association		California Narcotic Officers' Association		California Correctional Supervisors Organization Inc.		California Association of Code Enforcement Officers		CALIFORNIA COLLEGE AND UNIVERSITY POLICE CHIEFS ASSOCIATION		Los Angeles County Professional Peace Officers Association		Alcohol Monitoring Systems
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		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		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		None		None		None		None		None		None
cli_city		Sacramento		Valencia		Escalon		Sacramento		Sacramento		New Port Beach		Sacramento		Valencia		Escalon		Sacramento		Sacramento		Sacramento		Valencia		Escalon		Sacramento		Sacramento		Sacramento		Valencia		Escalon		Sacramento		Sacramento		New Port Beach		SAN DIMAS		Littleton		Littleton		Sacramento		Valencia		Escalon		Sacramento		Sacramento		New Port Beach		SAN DIMAS		Littleton		Sacramento		Valencia		Escalon		Sacramento		Sacramento		New Port Beach		SAN DIMAS		Sacramento		Valencia		Escalon		Sacramento		Sacramento		SAN DIMAS		Littleton		Littleton		Sacramento		Valencia		Escalon		Sacramento		Sacramento		SAN DIMAS		Littleton		Sacramento		Valencia		Escalon		Sacramento		Sacramento		SAN DIMAS		Littleton
cli_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CO		CO		CA		CA		CA		CA		CA		CA		CA		CO		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CO		CO		CA		CA		CA		CA		CA		CA		CO		CA		CA		CA		CA		CA		CA		CO
cli_zip4		95814		91355-1201		95320		95814		95814		92660		95814		91355-1201		95320		95814		95814		95814		91355-1201		95320		95814		95814		95814		91355-1201		95320		95814		95814		92660		91773		80120		80120		95814		91355-1201		95320		95814		95814		92660		91773		80120		95814		91355-1201		95320		95814		95814		92660		91773		95814		91355-1201		95320		95814		95814		91773		80120		80120		95814		91355-1201		95320		95814		95814		91773		80120		95814		91355-1201		95320		95814		95814		91773		80120
cli_phon		916-481-8000		661-775-6961		209-838-2940		916.492.2223		916-955-6944		949-706-4255		916-481-8000		661-775-6961		209-838-2940		916.492.2223		916-955-6944		916-481-8000		661-775-6961		209-838-2940		916.492.2223		916-955-6944		(916) 481-8000		(661) 775-6961		(209) 838-2940		(916) 492-2223		(916) 955-6944		(949) 706-4255		(323) 261-3010		(703) 786-6390		(703) 786-6390		(916) 481-8000		(661) 775-6961		(209) 838-2940		(916) 492-2223		(916) 955-6944		(949) 706-4255		(323) 261-3010		(703) 786-6390		(916) 481-8000		(661) 775-6961		(209) 838-2940		(916) 492-2223		(916) 955-6944		(949) 706-4255		(323) 261-3010		(916) 481-8000		(661) 775-6961		(209) 838-2940		(916) 492-2223		(916) 955-6944		(323) 261-3010		(703) 786-6390		(703) 786-6390		(916) 481-8000		(661) 775-6961		(209) 838-2940		(916) 492-2223		(916) 955-6944		(323) 261-3010		(703) 786-6390		(916) 481-8000		(661) 775-6961		(209) 838-2940		(916) 492-2223		(916) 955-6944		(323) 261-3010		(703) 786-6390
eff_date		2006-12-01 00:00:00		2006-12-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2014-01-14 00:00:00		2015-01-20 00:00:00		2006-12-01 00:00:00		2006-12-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2014-01-14 00:00:00		2006-12-01 00:00:00		2006-12-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2014-01-14 00:00:00		2006-12-01 00:00:00		2006-12-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2014-01-14 00:00:00		2015-01-20 00:00:00		2016-01-04 00:00:00		2016-07-14 00:00:00		2016-07-14 00:00:00		2006-12-01 00:00:00		2006-12-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2014-01-14 00:00:00		2015-01-20 00:00:00		2016-01-04 00:00:00		2016-07-14 00:00:00		2006-12-01 00:00:00		2006-12-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2014-01-14 00:00:00		2015-01-20 00:00:00		2016-01-04 00:00:00		2006-12-01 00:00:00		2006-12-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2014-01-14 00:00:00		2016-01-04 00:00:00		2016-07-14 00:00:00		2016-07-14 00:00:00		2006-12-01 00:00:00		2006-12-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2014-01-14 00:00:00		2016-01-04 00:00:00		2016-07-14 00:00:00		2006-12-01 00:00:00		2006-12-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2014-01-14 00:00:00		2016-01-04 00:00:00		2016-07-14 00:00:00
con_period		12/01/2006 through 06/30/2015		12/01/2006 through 12/31/2019		01/01/09 through 12/31/2018		01/01/09 to 12/31/2018		1/14/14 through 12/31/15		01/20/15 to 12/31/16		12/01/2006 through 06/30/2015		12/01/2006 through 12/31/2019		01/01/09 through 12/31/2018		01/01/09 to 12/31/2018		1/14/14 through 12/31/15		12/01/2006 through 06/30/2015		12/01/2006 through 12/31/2019		01/01/09 through 12/31/2018		01/01/09 to 12/31/2018		1/14/14 through 12/31/15		12/01/2006 through 06/30/2015		12/01/2006 through 12/31/2019		01/01/09 through 12/31/2018		01/01/09 to 12/31/2018		1/14/14 through 12/31/15		01/20/15 to 12/31/16		Indefinite		Through 12/31/2016		Through 12/31/2016		12/01/2006 through 06/30/2015		12/01/2006 through 12/31/2019		01/01/09 through 12/31/2018		01/01/09 to 12/31/2018		1/14/14 through 12/31/15		01/20/15 to 12/31/16		Indefinite		Through 12/31/2016		12/01/2006 through 06/30/2015		12/01/2006 through 12/31/2019		01/01/09 through 12/31/2018		01/01/09 to 12/31/2018		1/14/14 through 12/31/15		01/20/15 to 12/31/16		Indefinite		12/01/2006 through 06/30/2015		12/01/2006 through 12/31/2019		01/01/09 through 12/31/2018		01/01/09 to 12/31/2018		1/14/14 through 12/31/15		Indefinite		Through 12/31/2016		Through 12/31/2016		12/01/2006 through 06/30/2015		12/01/2006 through 12/31/2019		01/01/09 through 12/31/2018		01/01/09 to 12/31/2018		1/14/14 through 12/31/15		Indefinite		Through 12/31/2016		12/01/2006 through 06/30/2015		12/01/2006 through 12/31/2019		01/01/09 through 12/31/2018		01/01/09 to 12/31/2018		1/14/14 through 12/31/15		Indefinite		Through 12/31/2016
agencylist		Legislature Governor Attorney General		Governor Legislature Attorney General		Governor Legislature Attorney General		Governor Legislature Attorney General		Governor Legislature Attorney General		Legislature Governor and DMV		Legislature Governor Attorney General		Governor Legislature Attorney General		Governor Legislature Attorney General		Governor Legislature Attorney General		Governor Legislature Attorney General		Legislature Governor Attorney General		Governor Legislature Attorney General		Governor Legislature Attorney General		Governor Legislature Attorney General		Governor Legislature Attorney General		Legislature Governor Attorney General		Governor Legislature Attorney General		Governor Legislature Attorney General		Governor Legislature Attorney General		Governor Legislature Attorney General		Legislature Governor and DMV		State Legislature, Governor's Office, Department of Finance		Legislature, Governor		Legislature, Governor		Legislature Governor Attorney General		Governor Legislature Attorney General		Governor Legislature Attorney General		Governor Legislature Attorney General		Governor Legislature Attorney General		Legislature Governor and DMV		State Legislature, Governor's Office, Department of Finance		Legislature, Governor		Legislature Governor Attorney General		Governor Legislature Attorney General		Governor Legislature Attorney General		Governor Legislature Attorney General		Governor Legislature Attorney General		Legislature Governor and DMV		State Legislature, Governor's Office, Department of Finance		Legislature Governor Attorney General		Governor Legislature Attorney General		Governor Legislature Attorney General		Governor Legislature Attorney General		Governor Legislature Attorney General		State Legislature, Governor's Office, Department of Finance		Legislature, Governor		Legislature, Governor		Legislature Governor Attorney General		Governor Legislature Attorney General		Governor Legislature Attorney General		Governor Legislature Attorney General		Governor Legislature Attorney General		State Legislature, Governor's Office, Department of Finance		Legislature, Governor		Legislature Governor Attorney General		Governor Legislature Attorney General		Governor Legislature Attorney General		Governor Legislature Attorney General		Governor Legislature Attorney General		State Legislature, Governor's Office, Department of Finance		Legislature, Governor
descrip		Law Enforcement		Narcotic Enforcement		Law Enforcement		Public Safety		Law Enforcement		Enhancement of Traffic Issues		Law Enforcement		Narcotic Enforcement		Law Enforcement		Public Safety		Law Enforcement		Law Enforcement		Narcotic Enforcement		Law Enforcement		Public Safety		Law Enforcement		Law Enforcement		Narcotic Enforcement		Law Enforcement		Public Safety		Law Enforcement		Enhancement of Traffic Issues		All issues relative to benefits, wages, hours and working conditions SEE ATTACHMENT: I2C411DB		Alcohol Monitoring		Alcohol Monitoring		Law Enforcement		Narcotic Enforcement		Law Enforcement		Public Safety		Law Enforcement		Enhancement of Traffic Issues		All issues relative to benefits, wages, hours and working conditions SEE ATTACHMENT: I2C411DB		Alcohol Monitoring		Law Enforcement		Narcotic Enforcement		Law Enforcement		Public Safety		Law Enforcement		Enhancement of Traffic Issues		All issues relative to benefits, wages, hours and working conditions SEE ATTACHMENT: I2C411DB		Law Enforcement		Narcotic Enforcement		Law Enforcement		Public Safety		Law Enforcement		All issues relative to benefits, wages, hours and working conditions SEE ATTACHMENT: I2C411DB		Alcohol Monitoring		Alcohol Monitoring		Law Enforcement		Narcotic Enforcement		Law Enforcement		Public Safety		Law Enforcement		All issues relative to benefits, wages, hours and working conditions SEE ATTACHMENT: I2C411DB		Alcohol Monitoring		Law Enforcement		Narcotic Enforcement		Law Enforcement		Public Safety		Law Enforcement		All issues relative to benefits, wages, hours and working conditions SEE ATTACHMENT: I2C411DB		Alcohol Monitoring
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		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		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		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		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		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		None		None		None		None		None		None

Table: lobby_amendments

filing_id		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755
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		2017-10-23 00:00:00		2017-05-26 00:00:00		2017-05-26 00:00:00		2016-07-15 00:00:00		2016-07-14 00:00:00		2016-01-05 00:00:00		2015-01-20 00:00:00		2015-01-08 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-20 00:00:00		2014-10-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		2015-12-31 00:00:00		2014-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		None		X		X		X		X		None
add_le_eff		None		None		None		2016-07-14 00:00:00		2016-07-14 00:00:00		2016-01-04 00:00:00		2015-01-20 00:00:00		None
a_le_naml		None		None		None		Alcohol Monitoring Systems		Alcohol Monitoring Systems		Los Angeles County Professional Peace Officers Association		Car Dealers Savings Lives		None
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		None		X		X		None		None		None		None		X
del_le_eff		None		2016-09-30 00:00:00		2015-12-31 00:00:00		None		None		None		None		2014-10-01 00:00:00
d_le_naml		None		Alcohol Monitoring Systems		CAR DEALERS SAVING LIVES		None		None		None		None		Bingo Innovations of California
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		X		None		None		None		None		None		None		None
other_eff		2017-10-16 00:00:00		None		None		None		None		None		None		None
other_desc		Change of Address.		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		1147451		1147451		1147451		1147451		1147451		1147451		1147451		1147451		1147451
filing_file_name		1918755_4.cal		1918755_5.cal		1918755_3.cal		1918755_1.cal		1918755_0.cal		1918755_2.cal		1918755_6.cal		1918755_7.cal		1918755_8.cal
received_date		2016-07-15 00:00:00		2016-07-15 00:00:00		2016-01-05 00:00:00		2015-01-09 00:00:00		2014-12-17 00:00:00		2015-01-28 00:00:00		2017-05-26 00:00:00		2017-05-26 00:00:00		2017-10-23 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		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755		1918755
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