Home

Filing ID: 2744543

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

Table: cvr2_campaign_disclosure

filing_id		2744543		2744543
amend_id		1		0
line_item		1		1
rec_type		CVR2		CVR2
form_type		F460		F460
tran_id		OFC4		OFC4
entity_cd		ATR		ATR
title		None		None
mail_city		None		None
mail_st		None		None
mail_zip4		None		None
f460_part		3		3
cmte_id		None		None
enty_naml		Whitelam		Whitelam
enty_namf		Evann		Evann
enty_namt		None		None
enty_nams		None		None
enty_city		San Rafael		San Rafael
enty_st		CA		CA
enty_zip4		94901		94901
enty_phon		(415) 389-6800		(415) 389-6800
enty_fax		None		None
enty_email		None		None
tres_naml		None		None
tres_namf		None		None
tres_namt		None		None
tres_nams		None		None
control_yn		None		None
office_cd		None		None
offic_dscr		None		None
juris_cd		None		None
juris_dscr		None		None
dist_no		None		None
off_s_h_cd		None		None
bal_name		None		None
bal_num		None		None
bal_juris		None		None
sup_opp_cd		None		None

Table: cvr3_verification_info

filing_id		2744543		2744543
amend_id		1		0
line_item		1		1
rec_type		CVR3		CVR3
form_type		F460		F460
tran_id		VER_1.1		VER_1.1
entity_cd		TRE		TRE
sig_date		2022-11-04 00:00:00		2022-10-27 00:00:00
sig_loc		None		None
sig_naml		Steven S. Lucas		Steven S. Lucas
sig_namf		None		None
sig_namt		None		None
sig_nams		None		None

Table: cvr_campaign_disclosure

filing_id		2744543		2744543
amend_id		0		1
rec_type		CVR		CVR
form_type		F460		F460
filer_id		1365275		1365275
entity_cd		RCP		RCP
filer_naml		Coalition to Restore California's Middle Class, Including Energy Companies who Produce Gas, Oil, Jobs and Pay Taxes		Coalition to Restore California's Middle Class, Including Energy Companies who Produce Gas, Oil, Jobs and Pay Taxes
filer_namf		None		None
filer_namt		None		None
filer_nams		None		None
report_num		000		001
rpt_date		2022-10-27 00:00:00		2022-11-04 00:00:00
stmt_type		PE		PE
late_rptno		None		None
from_date		2022-09-25 00:00:00		2022-09-25 00:00:00
thru_date		2022-10-22 00:00:00		2022-10-22 00:00:00
elect_date		2022-11-08 00:00:00		2022-11-08 00:00:00
filer_city		San Rafael		San Rafael
filer_st		CA		CA
filer_zip4		94901		94901
filer_phon		(415) 389-6800		(415) 389-6800
filer_fax		None		None
file_email		Form410@nmgovlaw.com		Form410@nmgovlaw.com
mail_city		Los Angeles		Los Angeles
mail_st		CA		CA
mail_zip4		90039		90039
tres_naml		Lucas		Lucas
tres_namf		Steven S.		Steven S.
tres_namt		None		None
tres_nams		None		None
tres_city		San Rafael		San Rafael
tres_st		CA		CA
tres_zip4		94901		94901
tres_phon		(415) 389-6800		(415) 389-6800
tres_fax		None		None
tres_email		None		None
cmtte_type		G		G
control_yn		Y		Y
sponsor_yn		N		N
primfrm_yn		N		N
brdbase_yn		None		None
amendexp_1		None		Amendment to update independent expenditure allocations
amendexp_2		None		None
amendexp_3		None		None
rpt_att_cb		None		None
cmtte_id		None		None
reportname		None		None
rptfromdt		None		None
rptthrudt		None		None
emplbus_cb		None		None
bus_name		None		None
bus_city		None		None
bus_st		None		None
bus_zip4		None		None
bus_inter		None		None
busact_cb		None		None
busactvity		None		None
assoc_cb		None		None
assoc_int		None		None
other_cb		None		None
other_int		None		None
cand_naml		None		None
cand_namf		None		None
cand_namt		None		None
cand_nams		None		None
cand_city		None		None
cand_st		None		None
cand_zip4		None		None
cand_phon		None		None
cand_fax		None		None
cand_email		None		None
bal_name		None		None
bal_num		None		None
bal_juris		None		None
office_cd		None		None
offic_dscr		None		None
juris_cd		None		None
juris_dscr		None		None
dist_no		None		None
off_s_h_cd		None		None
sup_opp_cd		None		None
employer		None		None
occupation		None		None
selfemp_cb		None		None
bal_id		None		None
cand_id		None		None

Table: debt

filing_id		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543
amend_id		0		0		0		0		0		0		0		1		1		1		1		1		1		1
line_item		1		2		3		4		5		6		7		1		2		3		4		5		6		7
rec_type		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT
form_type		F		F		F		F		F		F		F		F		F		F		F		F		F		F
tran_id		PAY1792		PAY1811		PAY1812		PAY1810		PAY1821		PAY1822		PAY1823		PAY1792		PAY1811		PAY1812		PAY1810		PAY1821		PAY1822		PAY1823
entity_cd		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH
payee_naml		Nielsen Merksamer Parrinello Gross & Leoni LLP		Wilson Public Affairs		Wilson Public Affairs		Ross Communications and Management, Inc.		Bonneville Sacramento		Bonneville Sacramento		Bonneville Sacramento		Nielsen Merksamer Parrinello Gross & Leoni LLP		Wilson Public Affairs		Wilson Public Affairs		Ross Communications and Management, Inc.		Bonneville Sacramento		Bonneville Sacramento		Bonneville Sacramento
payee_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_city		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento
payee_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
payee_zip4		95814		95811		95811		95811		95815		95815		95815		95814		95811		95811		95811		95815		95815		95815
beg_bal		0		0		0		0		0		0		0		0		0		0		0		0		0		0
amt_incur		6693		44800		104		25000		60000		50000		10000		6693		44800		104		25000		60000		50000		10000
amt_paid		0		0		0		0		0		0		0		0		0		0		0		0		0		0
end_bal		6693		44800		104		25000		60000		50000		10000		6693		44800		104		25000		60000		50000		10000
expn_code		PRO		CNS		None		CNS		None		None		None		PRO		CNS		None		CNS		None		None		None
expn_dscr		None		See Schedule G		Reimbursed Expenses		None		Digital Ads		Digital Ads		Digital Ads		None		See Schedule G		Reimbursed Expenses		None		Digital Ads		Digital Ads		Digital Ads
cmte_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None
memo_code		None		None		None		None		None		None		None		None		None		None		None		None		None		None
memo_refno		None		None		None		None		PAY1821		PAY1822		PAY1823		None		None		None		None		PAY1821		PAY1822		PAY1823
bakref_tid		None		None		None		None		None		None		None		None		None		None		None		None		None		None
xref_schnm		None		None		None		None		None		None		None		None		None		None		None		None		None		None
xref_match		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: expn

filing_id		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543
amend_id		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1
line_item		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		20		21		22		23		24		25		26		27		28		29		30		31		32		33		34		35		36		37		38		39		40		41		42		43		44		45		46		47		48		49		50		51		52		53		54		55		56		57		58		59		60		61		62		63		64		65		66		67		68		69		70		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		20		21		22		23		24		25		26		27		28		29		30		31		32		33		34		35		36		37		38		39		40		41		42		43		44		45		46		47		48		49		50		51		52		53		54		55		56		57		58		59		60		61		62		63		64		65		66		67		68		69		70
rec_type		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN
form_type		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		G		G		G		G		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		G		G		G		G
tran_id		EXP1788		EXP1789		EXP1790		EDT1305		EDT1306		EDT1307		EDT1312		EDT1314		EDT1319		PDT446		EDT1315		EDT1316		EDT1317		EDT1318		EDT1295		EDT1296		EDT1297		EDT1298		EDT1299		EDT1300		EDT1301		EDT1308		EDT1309		EDT1310		EDT1320		PDT445		EDT1291		EDT1292		EDT1293		EDT1294		EDT1302		EDT1303		EDT1304		EXP1793		EXP1794		EDT1327		EDT1328		EDT1329		EDT1335		EDT1341		EDT1342		EDT1343		EDT1345		EDT1324		EDT1325		EDT1326		EDT1337		EDT1338		EDT1344		EDT1340		EXP1788		EXP1789		EXP1790		EXP1793		EXP1795		EXP1796		EXP1797		EXP1794		EXP1805		EXP1802		EXP1803		EXP1804		EXP1800		EXP1801		EXP1808		EXP1809		EDT1321		EDT1322		EDT1323		PDT447		EXP1788		EXP1789		EXP1790		EDT1305		EDT1306		EDT1307		EDT1312		EDT1314		EDT1319		PDT446		EDT1315		EDT1316		EDT1317		EDT1318		EDT1295		EDT1296		EDT1297		EDT1298		EDT1299		EDT1300		EDT1301		EDT1308		EDT1309		EDT1310		EDT1320		PDT445		EDT1291		EDT1292		EDT1293		EDT1294		EDT1302		EDT1303		EDT1304		EXP1793		EXP1794		EDT1327		EDT1328		EDT1329		EDT1335		EDT1341		EDT1342		EDT1343		EDT1345		EDT1324		EDT1325		EDT1326		EDT1337		EDT1338		EDT1344		EDT1340		EXP1788		EXP1789		EXP1790		EXP1793		EXP1795		EXP1796		EXP1797		EXP1794		EXP1805		EXP1802		EXP1803		EXP1804		EXP1800		EXP1801		EXP1808		EXP1809		EDT1321		EDT1322		EDT1323		PDT447
entity_cd		COM		COM		COM		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		COM		COM		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		COM		COM		COM		COM		OTH		OTH		OTH		COM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		COM		COM		COM		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		COM		COM		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		COM		COM		COM		COM		OTH		OTH		OTH		COM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH
payee_naml		Coalition to Restore CA's Middle Class - Supporting Leticia Perez for Assembly 2022		Coalition to Restore CA's Middle Class - Supporting Leticia Perez for Assembly 2022		Coalition to Restore CA's Middle Class - Supporting Leticia Perez for Assembly 2022		Angelique Ashby (I/E)		Angelique Ashby (I/E)		Catherine Blakespear (I/E)		Catherine Blakespear (I/E)		Catherine Blakespear (I/E)		Catherine Blakespear (I/E)		Catherine Blakespear (I/E)		Janet Nguyen (I/E - SD 36)		Janet Nguyen (I/E - SD 36)		Janet Nguyen (I/E - SD 36)		Janet Nguyen (I/E - SD 36)		Juan Alanis (I/E)		Juan Alanis (I/E)		Juan Alanis (I/E)		Juan Alanis (I/E)		Juan Carrillo (I/E)		Juan Carrillo (I/E)		Juan Carrillo (I/E)		Matt Gunderson (I/E)		Matt Gunderson (I/E)		Matt Gunderson (I/E)		Matt Gunderson (I/E)		Matt Gunderson (I/E)		STEPHANIE NGUYEN (I/E)		STEPHANIE NGUYEN (I/E)		STEPHANIE NGUYEN (I/E)		STEPHANIE NGUYEN (I/E)		Suzette Martinez Valladares (I/E)		Suzette Martinez Valladares (I/E)		Suzette Martinez Valladares (I/E)		Coalition to Restore CA's Middle Class - Supporting Leticia Perez for Assembly 2022		Coalition to Restore CA's Middle Class - Supporting Leticia Perez for Assembly 2022		Angelique Ashby (I/E)		Angelique Ashby (I/E)		Angelique Ashby (I/E)		Angelique Ashby (I/E)		Catherine Blakespear (I/E)		Catherine Blakespear (I/E)		Catherine Blakespear (I/E)		Catherine Blakespear (I/E)		STEPHANIE NGUYEN (I/E)		STEPHANIE NGUYEN (I/E)		STEPHANIE NGUYEN (I/E)		Angelique Ashby (I/E)		Angelique Ashby (I/E)		Catherine Blakespear (I/E)		STEPHANIE NGUYEN (I/E)		Coalition to Restore CA's Middle Class - Supporting Leticia Perez for Assembly 2022		Coalition to Restore CA's Middle Class - Supporting Leticia Perez for Assembly 2022		Coalition to Restore CA's Middle Class - Supporting Leticia Perez for Assembly 2022		Coalition to Restore CA's Middle Class - Supporting Leticia Perez for Assembly 2022		Bonneville Sacramento		Bonneville Sacramento		Bonneville Sacramento		Coalition to Restore CA's Middle Class - Supporting Leticia Perez for Assembly 2022		Hulu, LLC		Magnite, Inc.		Magnite, Inc.		Magnite, Inc.		Pandora Media LLC		Pandora Media LLC		Hulu, LLC		Hulu, LLC		YouTube		YouTube		YouTube		Joint Medias, Inc.		Coalition to Restore CA's Middle Class - Supporting Leticia Perez for Assembly 2022		Coalition to Restore CA's Middle Class - Supporting Leticia Perez for Assembly 2022		Coalition to Restore CA's Middle Class - Supporting Leticia Perez for Assembly 2022		Angelique Ashby (I/E)		Angelique Ashby (I/E)		Catherine Blakespear (I/E)		Catherine Blakespear (I/E)		Catherine Blakespear (I/E)		Catherine Blakespear (I/E)		Catherine Blakespear (I/E)		Janet Nguyen (I/E - SD 36)		Janet Nguyen (I/E - SD 36)		Janet Nguyen (I/E - SD 36)		Janet Nguyen (I/E - SD 36)		Juan Alanis (I/E)		Juan Alanis (I/E)		Juan Alanis (I/E)		Juan Alanis (I/E)		Juan Carrillo (I/E)		Juan Carrillo (I/E)		Juan Carrillo (I/E)		Matt Gunderson (I/E)		Matt Gunderson (I/E)		Matt Gunderson (I/E)		Matt Gunderson (I/E)		Matt Gunderson (I/E)		STEPHANIE NGUYEN (I/E)		STEPHANIE NGUYEN (I/E)		STEPHANIE NGUYEN (I/E)		STEPHANIE NGUYEN (I/E)		Suzette Martinez Valladares (I/E)		Suzette Martinez Valladares (I/E)		Suzette Martinez Valladares (I/E)		Coalition to Restore CA's Middle Class - Supporting Leticia Perez for Assembly 2022		Coalition to Restore CA's Middle Class - Supporting Leticia Perez for Assembly 2022		Angelique Ashby (I/E)		Angelique Ashby (I/E)		Angelique Ashby (I/E)		Angelique Ashby (I/E)		Catherine Blakespear (I/E)		Catherine Blakespear (I/E)		Catherine Blakespear (I/E)		Catherine Blakespear (I/E)		STEPHANIE NGUYEN (I/E)		STEPHANIE NGUYEN (I/E)		STEPHANIE NGUYEN (I/E)		Angelique Ashby (I/E)		Angelique Ashby (I/E)		Catherine Blakespear (I/E)		STEPHANIE NGUYEN (I/E)		Coalition to Restore CA's Middle Class - Supporting Leticia Perez for Assembly 2022		Coalition to Restore CA's Middle Class - Supporting Leticia Perez for Assembly 2022		Coalition to Restore CA's Middle Class - Supporting Leticia Perez for Assembly 2022		Coalition to Restore CA's Middle Class - Supporting Leticia Perez for Assembly 2022		Bonneville Sacramento		Bonneville Sacramento		Bonneville Sacramento		Coalition to Restore CA's Middle Class - Supporting Leticia Perez for Assembly 2022		Hulu, LLC		Magnite, Inc.		Magnite, Inc.		Magnite, Inc.		Pandora Media LLC		Pandora Media LLC		Hulu, LLC		Hulu, LLC		YouTube		YouTube		YouTube		Joint Medias, Inc.
payee_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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_city		San Rafael		San Rafael		San Rafael		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		San Rafael		San Rafael		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		San Rafael		San Rafael		San Rafael		San Rafael		Sacramento		Sacramento		Sacramento		San Rafael		Chicago		Los Angeles		Los Angeles		Los Angeles		Chicago		Chicago		Chicago		Chicago		San Bruno		San Bruno		San Bruno		Sacramento		San Rafael		San Rafael		San Rafael		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		San Rafael		San Rafael		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		San Rafael		San Rafael		San Rafael		San Rafael		Sacramento		Sacramento		Sacramento		San Rafael		Chicago		Los Angeles		Los Angeles		Los Angeles		Chicago		Chicago		Chicago		Chicago		San Bruno		San Bruno		San Bruno		Sacramento
payee_st		CA		CA		CA		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		CA		CA		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		CA		CA		CA		CA		CA		CA		CA		CA		IL		CA		CA		CA		IL		IL		IL		IL		CA		CA		CA		CA		CA		CA		CA		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		CA		CA		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		CA		CA		CA		CA		CA		CA		CA		CA		IL		CA		CA		CA		IL		IL		IL		IL		CA		CA		CA		CA
payee_zip4		94901		94901		94901		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		94901		94901		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		94901		94901		94901		94901		95815		95815		95815		94901		60693		90045		90045		90045		60673		60673		60693		60693		94066		94066		94066		95814		94901		94901		94901		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		94901		94901		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		94901		94901		94901		94901		95815		95815		95815		94901		60693		90045		90045		90045		60673		60673		60693		60693		94066		94066		94066		95814
expn_date		2022-09-28 00:00:00		2022-10-05 00:00:00		2022-10-07 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-12 00:00:00		2022-10-14 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-09-28 00:00:00		2022-10-05 00:00:00		2022-10-07 00:00:00		2022-10-12 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-09-30 00:00:00		2022-09-28 00:00:00		2022-10-05 00:00:00		2022-10-07 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-12 00:00:00		2022-10-14 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-09-28 00:00:00		2022-10-05 00:00:00		2022-10-07 00:00:00		2022-10-12 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-09-30 00:00:00
amount		110000		42000		20000		1206022		12000		14820		1500		914970		1500		3975		24700		185100		1500		1500		480011		1500		1500		5657		140010		1500		1500		9880		609980		1500		1500		2650		799548		1500		1500		24700		1500		1500		479990		20000		20000		1500		1500		172666		73150		1500		1500		121737		12350		69629		1500		1500		64539		107479		114785		54506		110000		42000		20000		20000		69629		172666		121737		20000		64539		107479		84374		44167		12350		73150		30411		10339		69629		172666		121737		14800		110000		42000		20000		1206022		12000		14820		1500		914970		1500		3975		24700		185100		1500		1500		480011		1500		1500		5657		140010		1500		1500		9880		609980		1500		1500		2650		799548		1500		1500		24700		1500		1500		479990		20000		20000		42779		1500		172666		73150		31961		1500		121737		12350		69629		13335		1500		64539		107479		114785		54506		110000		42000		20000		20000		69629		172666		121737		20000		64539		107479		84374		44167		12350		73150		30411		10339		69629		172666		121737		14800
cum_ytd		212000		212000		212000		1638856		1638856		1188637		1188637		1188637		1188637		1188637		212800		212800		212800		212800		488668		488668		488668		488668		143010		143010		143010		625510		625510		625510		625510		625510		954383		954383		954383		954383		482990		482990		482990		212000		212000		1638856		1638856		1638856		1638856		1188637		1188637		1188637		1188637		954383		954383		954383		1638856		1638856		1188637		954383		212000		212000		212000		212000		484032		484032		484032		212000		105290		236020		236020		236020		85500		85500		105290		105290		364032		364032		364032		37600		212000		212000		212000		1680135		1680135		1219098		1219098		1219098		1219098		1219098		212800		212800		212800		212800		488668		488668		488668		488668		143010		143010		143010		625510		625510		625510		625510		625510		966218		966218		966218		966218		482990		482990		482990		212000		212000		1680135		1680135		1680135		1680135		1219098		1219098		1219098		1219098		966218		966218		966218		1680135		1680135		1219098		966218		212000		212000		212000		212000		484032		484032		484032		212000		105290		236020		236020		236020		85500		85500		105290		105290		364032		364032		364032		37600
cum_oth		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
expn_chkno		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
expn_code		MON		MON		MON		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		MON		MON		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		CTB		CTB		CTB		CTB		IND		IND		IND		CTB		IND		IND		IND		IND		IND		IND		IND		IND		None		None		None		None		MON		MON		MON		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		MON		MON		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		CTB		CTB		CTB		CTB		IND		IND		IND		CTB		IND		IND		IND		IND		IND		IND		IND		IND		None		None		None		None
expn_dscr		None		None		None		TV Ads		Consulting		Polling		Consulting		TV Ads		Consulting		Research		Polling		TV Ads		Consulting		Consulting		TV Ads		Consulting		Consulting		Polling		TV Ads		Consulting		Consulting		Polling		TV Ads		Consulting		Consulting		Research		TV Ads		Consulting		Consulting		Polling		Consulting		Consulting		TV Ads		None		None		Consulting		Consulting		Digital Ads		Digital Ads		Consulting		Consulting		Consulting		Digital Ads		Digital Ads		Consulting		Consulting		Digital Ads		Digital Ads		Digital Ads		Digital Ads		None		None		None		None		Digital Ads/Support/S. Nguyen, AD 10. See Schedule G		Digital Ads/Support/A. Ashby, SD 8. See Schedule G		Digital Ads/Oppose/C. Blakespear, SD 38; See Schedule G		None		Digital Ads/Support/A. Ashby, SD 8		Digital Ads/Support/A. Ashby, SD 8		Digital Ads/Oppose/C. Blakespear, SD 38		Digital Ads/Support/S. Nguyen, AD 10		Digital Ads/Oppose/C. Blakespear, SD 38		Digital Ads/Support/A. Ashby, SD 8		Digital Ads/Oppose/C. Blakespear, SD 38		Digital Ads/Support/S. Nguyen, AD 10		Digital Ads		Digital Ads		Digital Ads		Graphic Design		None		None		None		TV Ads		Consulting		Polling		Consulting		TV Ads		Consulting		Research		Polling		TV Ads		Consulting		Consulting		TV Ads		Consulting		Consulting		Polling		TV Ads		Consulting		Consulting		Polling		TV Ads		Consulting		Consulting		Research		TV Ads		Consulting		Consulting		Polling		Consulting		Consulting		TV Ads		None		None		Consulting		Consulting		Digital Ads		Digital Ads		Consulting		Consulting		Digital Ads		Digital Ads		Digital Ads		Consulting		Consulting		Digital Ads		Digital Ads		Digital Ads		Digital Ads		None		None		None		None		Digital Ads/Support/S. Nguyen, AD 10. See Schedule G		Digital Ads/Support/A. Ashby, SD 8. See Schedule G		Digital Ads/Oppose/C. Blakespear, SD 38; See Schedule G		None		Digital Ads/Support/A. Ashby, SD 8		Digital Ads/Support/A. Ashby, SD 8		Digital Ads/Oppose/C. Blakespear, SD 38		Digital Ads/Support/S. Nguyen, AD 10		Digital Ads/Oppose/C. Blakespear, SD 38		Digital Ads/Support/A. Ashby, SD 8		Digital Ads/Oppose/C. Blakespear, SD 38		Digital Ads/Support/S. Nguyen, AD 10		Digital Ads		Digital Ads		Digital Ads		Graphic Design
agent_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Bonneville Sacramento		Bonneville Sacramento		Bonneville Sacramento		Wilson Public Affairs		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Bonneville Sacramento		Bonneville Sacramento		Bonneville Sacramento		Wilson Public Affairs
agent_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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
agent_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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
agent_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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cmte_id		1454778		1454778		1454778		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1454778		1454778		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1454778		1454778		1454778		1454778		None		None		None		1454778		None		None		None		None		None		None		None		None		None		None		None		None		1454778		1454778		1454778		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1454778		1454778		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1454778		1454778		1454778		1454778		None		None		None		1454778		None		None		None		None		None		None		None		None		None		None		None		None
tres_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_naml		Leticia Perez		Leticia Perez		Leticia Perez		Angelique Ashby		Angelique Ashby		Catherine Blakespear		Catherine Blakespear		Catherine Blakespear		Catherine Blakespear		Catherine Blakespear		Janet Nguyen		Janet Nguyen		Janet Nguyen		Janet Nguyen		Juan Alanis		Juan Alanis		Juan Alanis		Juan Alanis		Juan Carrillo		Juan Carrillo		Juan Carrillo		Matt Gunderson		Matt Gunderson		Matt Gunderson		Matt Gunderson		Matt Gunderson		Stephanie Nguyen		Stephanie Nguyen		Stephanie Nguyen		Stephanie Nguyen		Suzette Martinez Valladares		Suzette Martinez Valladares		Suzette Martinez Valladares		Leticia Perez		Leticia Perez		Angelique Ashby		Angelique Ashby		Angelique Ashby		Angelique Ashby		Catherine Blakespear		Catherine Blakespear		Catherine Blakespear		Catherine Blakespear		Stephanie Nguyen		Stephanie Nguyen		Stephanie Nguyen		Angelique Ashby		Angelique Ashby		Catherine Blakespear		Stephanie Nguyen		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Leticia Perez		Leticia Perez		Leticia Perez		Angelique Ashby		Angelique Ashby		Catherine Blakespear		Catherine Blakespear		Catherine Blakespear		Catherine Blakespear		Catherine Blakespear		Janet Nguyen		Janet Nguyen		Janet Nguyen		Janet Nguyen		Juan Alanis		Juan Alanis		Juan Alanis		Juan Alanis		Juan Carrillo		Juan Carrillo		Juan Carrillo		Matt Gunderson		Matt Gunderson		Matt Gunderson		Matt Gunderson		Matt Gunderson		Stephanie Nguyen		Stephanie Nguyen		Stephanie Nguyen		Stephanie Nguyen		Suzette Martinez Valladares		Suzette Martinez Valladares		Suzette Martinez Valladares		Leticia Perez		Leticia Perez		Angelique Ashby		Angelique Ashby		Angelique Ashby		Angelique Ashby		Catherine Blakespear		Catherine Blakespear		Catherine Blakespear		Catherine Blakespear		Stephanie Nguyen		Stephanie Nguyen		Stephanie Nguyen		Angelique Ashby		Angelique Ashby		Catherine Blakespear		Stephanie Nguyen		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
office_cd		ASM		ASM		ASM		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		ASM		ASM		ASM		ASM		ASM		ASM		ASM		SEN		SEN		SEN		SEN		SEN		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		ASM		ASM		ASM		SEN		SEN		SEN		ASM		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		ASM		ASM		ASM		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		ASM		ASM		ASM		ASM		ASM		ASM		ASM		SEN		SEN		SEN		SEN		SEN		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		ASM		ASM		ASM		SEN		SEN		SEN		ASM		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
offic_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_cd		ASM		ASM		ASM		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		ASM		ASM		ASM		ASM		ASM		ASM		ASM		SEN		SEN		SEN		SEN		SEN		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		ASM		ASM		ASM		SEN		SEN		SEN		ASM		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		ASM		ASM		ASM		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		ASM		ASM		ASM		ASM		ASM		ASM		ASM		SEN		SEN		SEN		SEN		SEN		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		ASM		ASM		ASM		SEN		SEN		SEN		ASM		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
dist_no		35		35		35		8		8		38		38		38		38		38		36		36		36		36		22		22		22		22		39		39		39		38		38		38		38		38		10		10		10		10		40		40		40		35		35		8		8		8		8		38		38		38		38		10		10		10		8		8		38		10		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		35		35		35		8		8		38		38		38		38		38		36		36		36		36		22		22		22		22		39		39		39		38		38		38		38		38		10		10		10		10		40		40		40		35		35		8		8		8		8		38		38		38		38		10		10		10		8		8		38		10		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
off_s_h_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_num		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_juris		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sup_opp_cd		S		S		S		S		S		O		O		O		O		O		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		O		O		O		O		S		S		S		S		S		O		S		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		S		S		S		S		S		O		O		O		O		O		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		O		O		O		O		S		S		S		S		S		O		S		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
memo_code		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
memo_refno		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bakref_tid		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
g_from_e_f		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		E		E		E		E		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		E		E		E		E
xref_schnm		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
xref_match		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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: filer_filings

filer_id		1365275		1365275
filing_id		2744543		2744543
period_id		251		251
form_id		F460		F460
filing_sequence		1		0
filing_date		2022-11-04 00:00:00		2022-10-27 00:00:00
stmnt_type		10002		10001
stmnt_status		11003		11003
session_id		2021		2021
user_id		CAFILER		CAFILER
special_audit		11003		11003
fine_audit		11003		11003
rpt_start		2022-09-25 00:00:00		2022-09-25 00:00:00
rpt_end		2022-10-22 00:00:00		2022-10-22 00:00:00
rpt_date		2022-11-04 00:00:00		2022-10-27 00:00:00
filing_type		22001		22001

Table: filings

filing_id		2744543
filing_type		22001

Table: hdr

filing_id		2744543		2744543
amend_id		0		1
rec_type		HDR		HDR
ef_type		CAL		CAL
state_cd		CA		CA
cal_ver		2.01		2.01
soft_name		NETFILE		NETFILE
soft_ver		2022451		2022451
hdrcomment		None		None

Table: rcpt

filing_id		2744543		2744543
amend_id		0		1
line_item		1		1
rec_type		RCPT		RCPT
form_type		I		I
tran_id		INC1791		INC1791
entity_cd		OTH		OTH
ctrib_naml		Bank of Marin		Bank of Marin
ctrib_namf		None		None
ctrib_namt		None		None
ctrib_nams		None		None
ctrib_city		Corta Madera		Corta Madera
ctrib_st		CA		CA
ctrib_zip4		94925		94925
ctrib_emp		None		None
ctrib_occ		None		None
ctrib_self		None		None
tran_type		None		None
rcpt_date		2022-09-30 00:00:00		2022-09-30 00:00:00
date_thru		None		None
amount		1345		1345
cum_ytd		0		0
cum_oth		None		None
ctrib_dscr		Interest Eearned		Interest Eearned
cmte_id		None		None
tres_naml		None		None
tres_namf		None		None
tres_namt		None		None
tres_nams		None		None
tres_city		None		None
tres_st		None		None
tres_zip4		None		None
intr_naml		None		None
intr_namf		None		None
intr_namt		None		None
intr_nams		None		None
intr_city		None		None
intr_st		None		None
intr_zip4		None		None
intr_emp		None		None
intr_occ		None		None
intr_self		None		None
cand_naml		None		None
cand_namf		None		None
cand_namt		None		None
cand_nams		None		None
office_cd		None		None
offic_dscr		None		None
juris_cd		None		None
juris_dscr		None		None
dist_no		None		None
off_s_h_cd		None		None
bal_name		None		None
bal_num		None		None
bal_juris		None		None
sup_opp_cd		None		None
memo_code		None		None
memo_refno		None		None
bakref_tid		None		None
xref_schnm		None		None
xref_match		None		None
int_rate		None		None
intr_cmteid		None		None

Table: smry

filing_id		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543		2744543
amend_id		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
line_item		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		1		2		3		4		1		2		3		1		2		3		4		1		2		3		1		2		3		1		2		3		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		1		2		3		4		1		2		3		1		2		3		4		1		2		3		1		2		3		1		2		3
rec_type		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY
form_type		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		I		I		I		I		D		D		D		E		E		E		E		F		F		F		B1		B1		B1		H		H		H		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		I		I		I		I		D		D		D		E		E		E		E		F		F		F		B1		B1		B1		H		H		H
amount_a		0		0		0		0		0		1002842		0		1002842		196598		0		1199439		1751431		0		1345		1002842		749935		0		0		196598		1345		0		0		1345		6030430		0		6030430		1002842		0		0		1002842		196598		0		196598		0		0		0		0		0		0		0		0		0		0		0		1002842		0		1002842		196598		0		1199439		1751431		0		1345		1002842		749935		0		0		196598		1345		0		0		1345		5946855		0		5946855		1002842		0		0		1002842		196598		0		196598		0		0		0		0		0		0
amount_b		7000000		0		7000000		0		7000000		8793933		0		8793933		196598		0		8990531		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		7000000		0		7000000		0		7000000		8793933		0		8793933		196598		0		8990531		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
amount_c		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
elec_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None