Home

Filing ID: 1928470

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

Table: cvr2_registration

filing_id		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470
amend_id		1		0		4		5		6		2		3		7
line_item		1		1		1		1		1		1		1		1
rec_type		CVR2		CVR2		CVR2		CVR2		CVR2		CVR2		CVR2		CVR2
form_type		F601		F601		F601		F601		F601		F601		F601		F601
tran_id		1077		1077		1077		1077		1077		1077		1077		1077
entity_cd		None		None		None		None		None		None		None		None
entity_id		1263054		1263054		1263054		1263054		1263054		1263054		1263054		1263054
enty_naml		Onate-Quintana		Onate-Quintana		Onate-Quintana		Onate-Quintana		Onate-Quintana		Onate-Quintana		Onate-Quintana		Onate-Quintana
enty_namf		Pilar		Pilar		Pilar		Pilar		Pilar		Pilar		Pilar		Pilar
enty_namt		None		None		None		None		None		None		None		None
enty_nams		None		None		None		None		None		None		None		None

Table: cvr_registration

filing_id		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470
amend_id		0		1		2		3		4		5		6		7
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F601		F601		F601		F601		F601		F601		F601		F601
sender_id		1343241		1343241		1343241		1343241		1343241		1343241		1343241		1343241
filer_id		1343241		1343241		1343241		1343241		1343241		1343241		1343241		1343241
entity_cd		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM
filer_naml		The Onate Group		The Onate Group		The Onate Group		The Onate Group		The Onate Group		The Onate Group		The Onate Group		The Onate Group
filer_namf		None		None		None		None		None		None		None		None
filer_namt		None		None		None		None		None		None		None		None
filer_nams		None		None		None		None		None		None		None		None
report_num		000		001		002		003		004		005		006		007
rpt_date		2015-01-21 00:00:00		2015-04-14 00:00:00		2015-11-13 00:00:00		2015-11-13 00:00:00		2016-02-05 00:00:00		2016-07-13 00:00:00		2016-07-18 00:00:00		2016-12-27 00:00:00
ls_beg_yr		2015		2015		2015		2015		2015		2015		2015		2015
ls_end_yr		2016		2016		2016		2016		2016		2016		2016		2016
qual_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
eff_date		None		None		None		None		None		None		None		None
bus_city		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento
bus_st		CA		CA		CA		CA		CA		CA		CA		CA
bus_zip4		95814		95814		95814		95814		95814		95814		95814		95814
bus_phon		916-230-4470		916-230-4470		916-230-4470		916-230-4470		916-230-4470		916-230-4470		916-230-4470		916-230-4470
bus_fax		916-448-4923		916-448-4923		916-448-4923		916-448-4923		916-448-4923		916-448-4923		916-448-4923		916-448-4923
bus_email		None		None		None		None		None		None		None		None
mail_city		None		None		None		None		None		None		None		None
mail_st		None		None		None		None		None		None		None		None
mail_zip4		None		None		None		None		None		None		None		None
mail_phon		None		None		None		None		None		None		None		None
sig_date		2015-01-21 00:00:00		2015-04-08 00:00:00		2015-11-13 00:00:00		2015-11-13 00:00:00		2016-02-05 00:00:00		2016-07-13 00:00:00		2016-07-18 00:00:00		2016-12-27 00:00:00
sig_loc		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA
sig_naml		Onate-Quintana		Onate-Quintana		Onate-Quintana		Onate-Quintana		Onate-Quintana		Onate-Quintana		Onate-Quintana		Onate-Quintana
sig_namf		Pilar		Pilar		Pilar		Pilar		Pilar		Pilar		Pilar		Pilar
sig_namt		None		None		None		None		None		None		None		None
sig_nams		None		None		None		None		None		None		None		None
prn_naml		Onate-Quintana		Onate-Quintana		Onate-Quintana		Onate-Quintana		Onate-Quintana		Onate-Quintana		Onate-Quintana		Onate-Quintana
prn_namf		Pilar		Pilar		Pilar		Pilar		Pilar		Pilar		Pilar		Pilar
prn_namt		None		None		None		None		None		None		None		None
prn_nams		None		None		None		None		None		None		None		None
sig_title		Owner		Owner		Owner		Owner		Owner		Owner		Owner		Owner
stmt_firm		The Onate Group		The Onate Group		The Onate Group		The Onate Group		The Onate Group		The Onate Group		The Onate Group		The Onate Group
ind_cb		None		None		None		None		None		None		None		None
bus_cb		None		None		None		None		None		None		None		None
trade_cb		None		None		None		None		None		None		None		None
oth_cb		None		None		None		None		None		None		None		None
a_b_name		None		None		None		None		None		None		None		None
a_b_city		None		None		None		None		None		None		None		None
a_b_st		None		None		None		None		None		None		None		None
a_b_zip4		None		None		None		None		None		None		None		None
descrip_1		None		None		None		None		None		None		None		None
descrip_2		None		None		None		None		None		None		None		None
c_less50		None		None		None		None		None		None		None		None
c_more50		None		None		None		None		None		None		None		None
ind_class		None		None		None		None		None		None		None		None
ind_descr		None		None		None		None		None		None		None		None
bus_class		None		None		None		None		None		None		None		None
bus_descr		None		None		None		None		None		None		None		None
auth_name		None		None		None		None		None		None		None		None
auth_city		None		None		None		None		None		None		None		None
auth_st		None		None		None		None		None		None		None		None
auth_zip4		None		None		None		None		None		None		None		None
lobby_int		None		None		None		None		None		None		None		None
influen_yn		None		None		None		None		None		None		None		None
firm_name		None		None		None		None		None		None		None		None
newcert_cb		None		None		None		None		None		None		None		None
rencert_cb		None		None		None		None		None		None		None		None
complet_dt		None		None		None		None		None		None		None		None
lby_reg_cb		None		None		None		None		None		None		None		None
lby_604_cb		None		None		None		None		None		None		None		None
st_leg_yn		None		None		None		None		None		None		None		None
st_agency		None		None		None		None		None		None		None		None
lobby_cb		None		None		None		None		None		None		None		None
l_firm_cb		None		None		None		None		None		None		None		None

Table: filer_filings

filer_id		1343241		1343241		1343241		1343241		1343241		1343241		1343241		1343241
filing_id		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470
period_id		222		221		224		224		225		227		227		228
form_id		F601		F601		F601		F601		F601		F601		F601		F601
filing_sequence		1		0		3		2		4		5		6		7
filing_date		2015-04-14 00:00:00		2015-01-22 00:00:00		2015-11-19 00:00:00		2015-11-16 00:00:00		2016-02-09 00:00:00		2016-07-15 00:00:00		2016-07-18 00:00:00		2016-12-31 00:00:00
stmnt_type		10002		10001		10002		10002		10002		10002		10002		10002
stmnt_status		11001		11001		11001		11001		11003		11003		11003		11003
session_id		2015		2015		2015		2015		2015		2015		2015		2015
user_id		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		CAFILER		CAFILER		CAFILER		CAFILER
special_audit		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11001		11001		11001		11001		11003		11003		11003		11003
rpt_start		2015-04-14 00:00:00		2015-01-21 00:00:00		2015-11-13 00:00:00		2015-11-13 00:00:00		2016-02-05 00:00:00		2016-07-13 00:00:00		2016-07-18 00:00:00		2016-12-27 00:00:00
rpt_end		2015-04-14 00:00:00		2015-01-21 00:00:00		2015-11-13 00:00:00		2015-11-13 00:00:00		2016-02-05 00:00:00		2016-07-13 00:00:00		2016-07-18 00:00:00		2016-12-27 00:00:00
rpt_date		None		None		None		None		None		None		None		None
filing_type		22001		22001		22001		22001		22001		22001		22001		22001

Table: filings

filing_id		1928470
filing_type		22001

Table: hdr

filing_id		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470
amend_id		0		1		2		3		4		5		6		7
rec_type		HDR		HDR		HDR		HDR		HDR		HDR		HDR		HDR
ef_type		CAL		CAL		CAL		CAL		CAL		CAL		CAL		CAL
state_cd		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
soft_name		NETFILE		NETFILE		NETFILE		NETFILE		NETFILE		NETFILE		NETFILE		NETFILE
soft_ver		1802		1802		1802		1802		1802		1802		1802		1806
hdrcomment		None		None		None		None		None		None		None		None

Table: lemp

filing_id		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470		1928470
amend_id		1		1		1		1		1		1		1		1		1		1		0		0		0		0		0		0		0		0		0		5		5		5		5		5		5		5		5		5		5		5		5		6		6		6		6		6		6		6		6		6		6		6		6		4		4		4		4		4		4		4		4		4		4		4		3		3		3		3		3		3		3		3		3		3		3		2		2		2		2		2		2		2		2		2		2		7		7		7		7		7		7		7		7		7		7		7		7
line_item		2		3		4		5		6		7		8		9		10		1		1		2		3		4		5		6		7		8		9		1		2		3		4		5		6		7		8		9		10		11		12		1		2		3		4		5		6		7		8		9		10		11		12		4		7		8		9		1		2		5		6		10		3		11		3		4		5		6		7		1		2		8		9		10		11		1		2		3		4		5		6		7		8		9		10		1		2		3		4		5		6		7		8		9		10		11		12
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		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		F601P2B		F601P2B		F601P2B		F601P2B		F601P2A		F601P2A		F601P2A		F601P2A		F601P2B		F601P2B		F601P2B		F601P2B		F601P2B		F601P2B		F601P2B		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2B		F601P2B		F601P2B		F601P2B		F601P2B		F601P2B		F601P2B		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A		F601P2B		F601P2B		F601P2B		F601P2B		F601P2B		F601P2B		F601P2B		F601P2B		F601P2A		F601P2A		F601P2A		F601P2B		F601P2B		F601P2B		F601P2A		F601P2B		F601P2B		F601P2B		F601P2B		F601P2B		F601P2B		F601P2A		F601P2A		F601P2B		F601P2B		F601P2A		F601P2A		F601P2B		F601P2B		F601P2B		F601P2B		F601P2B		F601P2B		F601P2B		F601P2A		F601P2A		F601P2A		F601P2A		F601P2B		F601P2B		F601P2B		F601P2B		F601P2B		F601P2B		F601P2B		F601P2B		F601P2A		F601P2A		F601P2A		F601P2A		F601P2A
client_id		None		None		None		None		C25253		None		1319684		None		None		None		None		None		None		None		None		C25253		None		1319684		None		C25253		None		1319684		None		None		None		None		None		None		None		None		None		C25253		None		1319684		None		1387153		None		None		None		None		None		None		None		None		None		1319684		None		None		None		None		C25253		None		None		None		None		None		None		C25253		None		None		None		1319684		None		None		None		None		None		None		None		None		C25253		None		1319684		None		None		None		None		None		None		None		None		None		1387153		C25253		None		1319684		None
cli_naml		Ernst & Young LLP		Grant Thornton LLP		KPMG LLP		PricewaterhouseCoopers, LLP		Barona Band of Mission Indians		East Valley Water District		North Bay Water Reuse Authority c/o Novato Sanitary District		Yuba County Water Agency		Smoke-Free Alternatives Trade Association		Deloitte LLP		Deloitte LLP		Ernst & Young LLP		Grant Thornton LLP		KPMG LLP		PricewaterhouseCoopers, LLP		Barona Band of Mission Indians		East Valley Water District		North Bay Water Reuse Authority c/o Novato Sanitary District		Yuba County Water Agency		Barona Band of Mission Indians		East Valley Water District		North Bay Water Reuse Authority c/o Novato Sanitary District		Yuba County Water Agency		Administrative Services Cooperative, Inc.		Deloitte LLP		Ernst & Young LLP		Grant Thornton LLP		KPMG LLP		McGregor & Associates		PricewaterhouseCoopers, LLP		Smoke-Free Alternatives Trade Association		Barona Band of Mission Indians		East Valley Water District		North Bay Water Reuse Authority c/o Novato Sanitary District		Yuba County Water Agency		Administrative Services Cooperative, Inc.		Deloitte LLP		Ernst & Young LLP		Grant Thornton LLP		KPMG LLP		McGregor & Associates		PricewaterhouseCoopers, LLP		Smoke-Free Alternatives Trade Association		KPMG LLP		East Valley Water District		North Bay Water Reuse Authority c/o Novato Sanitary District		Yuba County Water Agency		Deloitte LLP		Ernst & Young LLP		PricewaterhouseCoopers, LLP		Barona Band of Mission Indians		Smoke-Free Alternatives Trade Association		Grant Thornton LLP		McGregor & Associates		Grant Thornton LLP		KPMG LLP		PricewaterhouseCoopers, LLP		Barona Band of Mission Indians		East Valley Water District		Deloitte LLP		Ernst & Young LLP		North Bay Water Reuse Authority c/o Novato Sanitary District		Yuba County Water Agency		Smoke-Free Alternatives Trade Association		McGregor & Associates		Deloitte LLP		Ernst & Young LLP		Grant Thornton LLP		KPMG LLP		PricewaterhouseCoopers, LLP		Barona Band of Mission Indians		East Valley Water District		North Bay Water Reuse Authority c/o Novato Sanitary District		Yuba County Water Agency		Smoke-Free Alternatives Trade Association		Deloitte LLP		Ernst & Young LLP		Grant Thornton LLP		KPMG LLP		McGregor & Associates		PricewaterhouseCoopers, LLP		Smoke-Free Alternatives Trade Association		Administrative Services Cooperative, Inc.		Barona Band of Mission Indians		East Valley Water District		North Bay Water Reuse Authority c/o Novato Sanitary District		Yuba County Water Agency
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		None		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		None		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		None		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		San Francisco		San Francisco		San Francisco		Washington		Lakeside		Highland		Novato		Marysville		Washington		New York		New York		San Francisco		San Francisco		San Francisco		Washington		Lakeside		Highland		Novato		Marysville		Lakeside		Highland		Novato		Marysville		Gardena		New York		San Francisco		San Francisco		San Francisco		San Diego		Washington		Washington		Lakeside		Highland		Novato		Marysville		Gardena		New York		San Francisco		San Francisco		San Francisco		San Diego		Washington		Washington		San Francisco		Highland		Novato		Marysville		New York		San Francisco		Washington		Lakeside		Washington		San Francisco		San Diego		San Francisco		San Francisco		Washington		Lakeside		Highland		New York		San Francisco		Novato		Marysville		Washington		San Diego		New York		San Francisco		San Francisco		San Francisco		Washington		Lakeside		Highland		Novato		Marysville		Washington		New York		San Francisco		San Francisco		San Francisco		San Diego		Washington		Washington		Gardena		Lakeside		Highland		Novato		Marysville
cli_st		CA		CA		CA		DC		CA		CA		CA		CA		DC		NY		NY		CA		CA		CA		DC		CA		CA		CA		CA		CA		CA		CA		CA		CA		NY		CA		CA		CA		CA		DC		DC		CA		CA		CA		CA		CA		NY		CA		CA		CA		CA		DC		DC		CA		CA		CA		CA		NY		CA		DC		CA		DC		CA		CA		CA		CA		DC		CA		CA		NY		CA		CA		CA		DC		CA		NY		CA		CA		CA		DC		CA		CA		CA		CA		DC		NY		CA		CA		CA		CA		DC		DC		CA		CA		CA		CA		CA
cli_zip4		94105		94111		94105		20005		92040		92346		94945		95901-4226		20004		10019		10019		94105		94111		94105		20005		92040		92346		94945		95901-4226		92040		92346		94945		95901-4226		90249		10019		94105		94111		94105		92108		20005		20004		92040		92346		94945		95901-4226		90249		10019		94105		94111		94105		92108		20005		20004		94105		92346		94945		95901-4226		10019		94105		20005		92040		20004		94111		92108		94111		94105		20005		92040		92346		10019		94105		94945		95901-4226		20004		92108		10019		94105		94111		94105		20005		92040		92346		94945		95901-4226		20004		10019		94105		94111		94105		92108		20005		20004		90249		92040		92346		94945		95901-4226
cli_phon		415-894-8501		415-365-5452		415-963-7810		202-312-7739		619-390-2179		909-885-4900		707-524-8378		530.741.6278		(218) 227-3282		212-436-2000		212-436-2000		415-894-8501		415-365-5452		415-963-7810		202-312-7739		619-390-2179		909-885-4900		707-524-8378		530.741.6278		619-390-2179		909-885-4900		707-524-8378		530.741.6278		(310) 715.1968		212-436-2000		415-894-8501		415-365-5452		415-963-7810		(619) 278-0021		202-312-7739		(218) 227-3282		619-390-2179		909-885-4900		707-524-8378		530.741.6278		(310) 715.1968		212-436-2000		415-894-8501		415-365-5452		415-963-7810		(619) 278-0021		202-312-7739		(218) 227-3282		415-963-7810		909-885-4900		707-524-8378		530.741.6278		212-436-2000		415-894-8501		202-312-7739		619-390-2179		(218) 227-3282		415-365-5452		(619) 278-0021		415-365-5452		415-963-7810		202-312-7739		619-390-2179		909-885-4900		212-436-2000		415-894-8501		707-524-8378		530.741.6278		(218) 227-3282		(619) 278-0021		212-436-2000		415-894-8501		415-365-5452		415-963-7810		202-312-7739		619-390-2179		909-885-4900		707-524-8378		530.741.6278		(218) 227-3282		212-436-2000		415-894-8501		415-365-5452		415-963-7810		(619) 278-0021		202-312-7739		(218) 227-3282		(310) 715.1968		619-390-2179		909-885-4900		707-524-8378		530.741.6278
eff_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		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-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		2016-07-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-10-01 00:00:00		2015-01-01 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		2016-07-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-10-01 00:00:00		2015-01-01 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-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-01-01 00:00:00		2015-10-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-10-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-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-10-01 00:00:00		2015-01-01 00:00:00		2015-04-01 00:00:00		2016-07-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
con_period		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		04/01/2015 - 10/11/2015		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		07/01/2016-9/30/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		10/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		04/01/2015 - 9/30/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		07/01/2016-9/30/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		10/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		04/01/2015 - 9/30/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		04/01/2015 - 9/30/2016		01/01/2015 - 12/31/2016		10/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		04/01/2015 - 12/31/2015		10/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		04/01/2015 - 12/31/2015		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		10/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		04/01/2015 - 9/30/2016		07/01/2016-9/30/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016		01/01/2015 - 12/31/2016
agencylist		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office.		State Legislature, Governor's Office, Dept of Water Resources, State Water Resources Control Board.		State Legislature, Governor's Office, Dept of Water Resources, State Water Resources Control Board.		State Legislature, Governor's Office, Dept of Water Resources, State Water Resources Control Board.		State Legislature, Governor's Office.		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office.		State Legislature, Governor's Office, Dept of Water Resources, State Water Resources Control Board.		State Legislature, Governor's Office, Dept of Water Resources, State Water Resources Control Board.		State Legislature, Governor's Office, Dept of Water Resources, State Water Resources Control Board.		State Legislature, Governor's Office.		State Legislature, Governor's Office, Dept of Water Resources, State Water Resources Control Board.		State Legislature, Governor's Office, Dept of Water Resources, State Water Resources Control Board.		State Legislature, Governor's Office, Dept of Water Resources, State Water Resources Control Board.		State Legislature, Governor's Office		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office, Board of Accountancy.		Governor's Office, State Legislature, Board of Equalization, CalPERS		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office.		State Legislature, Governor's Office.		State Legislature, Governor's Office, Dept of Water Resources, State Water Resources Control Board.		State Legislature, Governor's Office, Dept of Water Resources, State Water Resources Control Board.		State Legislature, Governor's Office, Dept of Water Resources, State Water Resources Control Board.		State Legislature, Governor's Office		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office, Board of Accountancy.		Governor's Office, State Legislature, Board of Equalization, CalPERS		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office.		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office, Dept of Water Resources, State Water Resources Control Board.		State Legislature, Governor's Office, Dept of Water Resources, State Water Resources Control Board.		State Legislature, Governor's Office, Dept of Water Resources, State Water Resources Control Board.		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office.		State Legislature, Governor's Office.		State Legislature, Governor's Office, Board of Accountancy.		Governor's Office, State Legislature, Board of Equalization, CalPERS		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office.		State Legislature, Governor's Office, Dept of Water Resources, State Water Resources Control Board.		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office, Dept of Water Resources, State Water Resources Control Board.		State Legislature, Governor's Office, Dept of Water Resources, State Water Resources Control Board.		State Legislature, Governor's Office.		Governor's Office, State Legislature, Board of Equalization, CalPERS		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office.		State Legislature, Governor's Office, Dept of Water Resources, State Water Resources Control Board.		State Legislature, Governor's Office, Dept of Water Resources, State Water Resources Control Board.		State Legislature, Governor's Office, Dept of Water Resources, State Water Resources Control Board.		State Legislature, Governor's Office.		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office, Board of Accountancy.		Governor's Office, State Legislature, Board of Equalization, CalPERS		State Legislature, Governor's Office, Board of Accountancy.		State Legislature, Governor's Office.		State Legislature, Governor's Office		State Legislature, Governor's Office.		State Legislature, Governor's Office, Dept of Water Resources, State Water Resources Control Board.		State Legislature, Governor's Office, Dept of Water Resources, State Water Resources Control Board.		State Legislature, Governor's Office, Dept of Water Resources, State Water Resources Control Board.
descrip		Board of Accountancy issues, tax issues, accountant profession-related issues.		Board of Accountancy issues, tax issues, accountant profession-related issues.		Board of Accountancy issues, tax issues, accountant profession-related issues.		Board of Accountancy issues, tax issues, accountant profession-related issues.		Tribal and gaming related issues.		Water issues.		Recycled water issues.		Water issues.		Electronic cigarette regulation		Board of Accountancy issues, tax issues, accountant profession-related issues.		Board of Accountancy issues, tax issues, accountant profession-related issues.		Board of Accountancy issues, tax issues, accountant profession-related issues.		Board of Accountancy issues, tax issues, accountant profession-related issues.		Board of Accountancy issues, tax issues, accountant profession-related issues.		Board of Accountancy issues, tax issues, accountant profession-related issues.		Tribal and gaming related issues.		Water issues.		Recycled water issues.		Water issues.		Tribal and gaming related issues.		Water issues.		Recycled water issues.		Water issues.		Transportation Services Issues		Board of Accountancy issues, tax issues, accountant profession-related issues.		Board of Accountancy issues, tax issues, accountant profession-related issues.		Board of Accountancy issues, tax issues, accountant profession-related issues.		Board of Accountancy issues, tax issues, accountant profession-related issues.		Healthcare costs/contracts		Board of Accountancy issues, tax issues, accountant profession-related issues.		Electronic cigarette regulation		Tribal and gaming related issues.		Water issues.		Recycled water issues.		Water issues.		Transportation Services Issues		Board of Accountancy issues, tax issues, accountant profession-related issues.		Board of Accountancy issues, tax issues, accountant profession-related issues.		Board of Accountancy issues, tax issues, accountant profession-related issues.		Board of Accountancy issues, tax issues, accountant profession-related issues.		Healthcare costs/contracts		Board of Accountancy issues, tax issues, accountant profession-related issues.		Electronic cigarette regulation		Board of Accountancy issues, tax issues, accountant profession-related issues.		Water issues.		Recycled water issues.		Water issues.		Board of Accountancy issues, tax issues, accountant profession-related issues.		Board of Accountancy issues, tax issues, accountant profession-related issues.		Board of Accountancy issues, tax issues, accountant profession-related issues.		Tribal and gaming related issues.		Electronic cigarette regulation		Board of Accountancy issues, tax issues, accountant profession-related issues.		Healthcare costs/contracts		Board of Accountancy issues, tax issues, accountant profession-related issues.		Board of Accountancy issues, tax issues, accountant profession-related issues.		Board of Accountancy issues, tax issues, accountant profession-related issues.		Tribal and gaming related issues.		Water issues.		Board of Accountancy issues, tax issues, accountant profession-related issues.		Board of Accountancy issues, tax issues, accountant profession-related issues.		Recycled water issues.		Water issues.		Electronic cigarette regulation		Healthcare costs/contracts		Board of Accountancy issues, tax issues, accountant profession-related issues.		Board of Accountancy issues, tax issues, accountant profession-related issues.		Board of Accountancy issues, tax issues, accountant profession-related issues.		Board of Accountancy issues, tax issues, accountant profession-related issues.		Board of Accountancy issues, tax issues, accountant profession-related issues.		Tribal and gaming related issues.		Water issues.		Recycled water issues.		Water issues.		Electronic cigarette regulation		Board of Accountancy issues, tax issues, accountant profession-related issues.		Board of Accountancy issues, tax issues, accountant profession-related issues.		Board of Accountancy issues, tax issues, accountant profession-related issues.		Board of Accountancy issues, tax issues, accountant profession-related issues.		Healthcare costs/contracts		Board of Accountancy issues, tax issues, accountant profession-related issues.		Electronic cigarette regulation		Transportation Services Issues		Tribal and gaming related issues.		Water issues.		Recycled water issues.		Water issues.
subfirm_id		F00409		F00409		F00409		F00409		None		None		None		None		None		F00409		F00409		F00409		F00409		F00409		F00409		None		None		None		None		None		None		None		None		1334301		F00409		F00409		F00409		F00409		1334301		F00409		1334301		None		None		None		None		None		F00409		F00409		F00409		F00409		1334301		F00409		1334301		F00409		None		None		None		F00409		F00409		F00409		None		1334301		F00409		1334301		F00409		F00409		F00409		None		None		F00409		F00409		None		None		1334301		1334301		F00409		F00409		F00409		F00409		F00409		None		None		None		None		None		F00409		F00409		F00409		F00409		1334301		F00409		1334301		None		None		None		None		None
sub_name		KP Public Affairs		KP Public Affairs		KP Public Affairs		KP Public Affairs		None		None		None		None		Gonzalez, Quintana & Hunter, LLC		KP Public Affairs		KP Public Affairs		KP Public Affairs		KP Public Affairs		KP Public Affairs		KP Public Affairs		None		None		None		None		None		None		None		None		Gonzalez, Quintana, Hunter and Cruz, LLC		KP Public Affairs		KP Public Affairs		KP Public Affairs		KP Public Affairs		Gonzalez, Quintana, Hunter & Cruz, LLC		KP Public Affairs		Gonzalez, Quintana, Hunter & Cruz, LLC		None		None		None		None		None		KP Public Affairs		KP Public Affairs		KP Public Affairs		KP Public Affairs		Gonzalez, Quintana, Hunter & Cruz, LLC		KP Public Affairs		Gonzalez, Quintana, Hunter & Cruz, LLC		KP Public Affairs		None		None		None		KP Public Affairs		KP Public Affairs		KP Public Affairs		None		Gonzalez, Quintana, Hunter & Cruz, LLC		KP Public Affairs		Gonzalez, Quintana, Hunter & Cruz, LLC		KP Public Affairs		KP Public Affairs		KP Public Affairs		None		None		KP Public Affairs		KP Public Affairs		None		None		Gonzalez, Quintana, Hunter & Cruz, LLC		Gonzalez, Quintana, Hunter & Cruz, LLC		KP Public Affairs		KP Public Affairs		KP Public Affairs		KP Public Affairs		KP Public Affairs		None		None		None		None		Gonzalez, Quintana, Hunter & Cruz, LLC		KP Public Affairs		KP Public Affairs		KP Public Affairs		KP Public Affairs		Gonzalez, Quintana, Hunter & Cruz, LLC		KP Public Affairs		Gonzalez, Quintana, Hunter & Cruz, LLC		None		None		None		None		None
sub_city		Sacramento		Sacramento		Sacramento		Sacramento		None		None		None		None		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		None		None		None		None		None		None		None		None		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		None		None		None		None		None		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		None		None		None		Sacramento		Sacramento		Sacramento		None		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		None		None		Sacramento		Sacramento		None		None		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		None		None		None		None		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		None		None		None		None		None
sub_st		CA		CA		CA		CA		None		None		None		None		CA		CA		CA		CA		CA		CA		CA		None		None		None		None		None		None		None		None		CA		CA		CA		CA		CA		CA		CA		CA		None		None		None		None		None		CA		CA		CA		CA		CA		CA		CA		CA		None		None		None		CA		CA		CA		None		CA		CA		CA		CA		CA		CA		None		None		CA		CA		None		None		CA		CA		CA		CA		CA		CA		CA		None		None		None		None		CA		CA		CA		CA		CA		CA		CA		CA		None		None		None		None		None
sub_zip4		95814		95814		95814		95814		None		None		None		None		95814		95814		95814		95814		95814		95814		95814		None		None		None		None		None		None		None		None		958145		95814		95814		95814		95814		95814		95814		95814		None		None		None		None		None		95814		95814		95814		95814		95814		95814		95814		95814		None		None		None		95814		95814		95814		None		95814		95814		95814		95814		95814		95814		None		None		95814		95814		None		None		95814		95814		95814		95814		95814		95814		95814		None		None		None		None		95814		95814		95814		95814		95814		95814		95814		95814		None		None		None		None		None
sub_phon		916-448-2162		916-448-2162		916-448-2162		916-448-2162		None		None		None		None		(916) 930.0796		916-448-2162		916-448-2162		916-448-2162		916-448-2162		916-448-2162		916-448-2162		None		None		None		None		None		None		None		None		(916) 930.0796		916-448-2162		916-448-2162		916-448-2162		916-448-2162		(916) 930.0796		916-448-2162		(916) 930.0796		None		None		None		None		None		916-448-2162		916-448-2162		916-448-2162		916-448-2162		(916) 930.0796		916-448-2162		(916) 930.0796		916-448-2162		None		None		None		916-448-2162		916-448-2162		916-448-2162		None		(916) 930.0796		916-448-2162		(916) 930.0796		916-448-2162		916-448-2162		916-448-2162		None		None		916-448-2162		916-448-2162		None		None		(916) 930.0796		(916) 930.0796		916-448-2162		916-448-2162		916-448-2162		916-448-2162		916-448-2162		None		None		None		None		(916) 930.0796		916-448-2162		916-448-2162		916-448-2162		916-448-2162		(916) 930.0796		916-448-2162		(916) 930.0796		None		None		None		None		None

Table: lobby_amendments

filing_id		1928470		1928470		1928470		1928470		1928470		1928470		1928470
amend_id		7		6		5		4		3		2		1
rec_type		F605		F605		F605		F605		F605		F605		F605
form_type		F601		F601		F601		F601		F601		F601		F601
exec_date		2016-12-27 00:00:00		2016-07-18 00:00:00		2016-07-13 00:00:00		2016-02-05 00:00:00		2015-11-13 00:00:00		2015-11-13 00:00:00		2015-04-01 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
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
add_l_cb		None		None		None		None		None		None		None
add_l_eff		None		None		None		None		None		None		None
a_l_naml		None		None		None		None		None		None		None
a_l_namf		None		None		None		None		None		None		None
a_l_namt		None		None		None		None		None		None		None
a_l_nams		None		None		None		None		None		None		None
del_l_cb		None		None		None		None		None		None		None
del_l_eff		None		None		None		None		None		None		None
d_l_naml		None		None		None		None		None		None		None
d_l_namf		None		None		None		None		None		None		None
d_l_namt		None		None		None		None		None		None		None
d_l_nams		None		None		None		None		None		None		None
add_le_cb		None		None		X		None		X		None		X
add_le_eff		None		None		2016-07-01 00:00:00		None		2015-10-01 00:00:00		None		2015-04-01 00:00:00
a_le_naml		None		None		Administrative Services Cooperative, Inc.		None		Gonzalez, Quintana, Hunter & Cruz, LLC for McGregor & Associates		None		Gonzalez, Quintana & Hunter, LLC for Smoke-Free Alternatives Trade Association
a_le_namf		None		None		None		None		None		None		None
a_le_namt		None		None		None		None		None		None		None
a_le_nams		None		None		None		None		None		None		None
del_le_cb		X		X		None		None		None		None		None
del_le_eff		2016-09-30 00:00:00		2016-07-14 00:00:00		None		None		None		None		None
d_le_naml		Administrative Services Cooperative		Gonzalez, Quintana, Hunter & Cruz for Admin Services Cooperative		None		None		None		None		None
d_le_namf		None		None		None		None		None		None		None
d_le_namt		None		None		None		None		None		None		None
d_le_nams		None		None		None		None		None		None		None
add_lf_cb		None		None		None		None		None		None		None
add_lf_eff		None		None		None		None		None		None		None
a_lf_name		None		None		None		None		None		None		None
del_lf_cb		None		None		None		None		None		None		None
del_lf_eff		None		None		None		None		None		None		None
d_lf_name		None		None		None		None		None		None		None
other_cb		None		X		None		X		None		X		None
other_eff		None		2016-07-14 00:00:00		None		2016-01-01 00:00:00		None		2015-10-11 00:00:00		None
other_desc		None		602 filed in error for Gonzalez, Quintana to subcontract for Administrative Services Cooperative.		None		Change ending contract date of Gonzalez, Quintana, Hunter & Cruz for Smoke-Free to 9/30/2016.		None		Smoke-Free Alternatives Trade Association - extend contract to 12/31/2015.		None
f606_yes		None		None		None		None		None		None		None
f606_no		X		X		X		X		X		X		X

Table: received_filings

filer_id		1343241		1343241		1343241		1343241		1343241		1343241		1343241
filing_file_name		1928470_6.cal		1928470_2.cal		1928470_3.cal		1928470_7.cal		1928470_4.cal		1928470_0.cal		1928470_1.cal
received_date		2016-07-18 00:00:00		2015-11-16 00:00:00		2015-11-19 00:00:00		2016-12-31 00:00:00		2016-02-09 00:00:00		2015-01-22 00:00:00		2015-04-14 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
filing_id		1928470		1928470		1928470		1928470		1928470		1928470		1928470
form_id		F601		F601		F601		F601		F601		F601		F601
receive_comment		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted