Home

Filing ID: 2743941

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

Table: cvr2_campaign_disclosure

filing_id		2743941		2743941
amend_id		1		0
line_item		1		1
rec_type		CVR2		CVR2
form_type		F460		F460
tran_id		OFC1		OFC1
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		Deane		Deane
enty_namf		Shawnda		Shawnda
enty_namt		None		None
enty_nams		None		None
enty_city		Sacramento		Sacramento
enty_st		CA		CA
enty_zip4		95815		95815
enty_phon		(916) 285-5733		(916) 285-5733
enty_fax		(916) 333-1344		(916) 333-1344
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		2743941		2743941		2743941		2743941
amend_id		1		1		0		0
line_item		1		2		1		2
rec_type		CVR3		CVR3		CVR3		CVR3
form_type		F460		F460		F460		F460
tran_id		VER_1.1		VER_2.2		VER_1.1		VER_2.2
entity_cd		ATR		CAO		ATR		CAO
sig_date		2022-11-05 00:00:00		2022-11-05 00:00:00		2022-10-26 00:00:00		2022-10-26 00:00:00
sig_loc		None		None		None		None
sig_naml		Shawnda Deane		Eduardo Garcia		Shawnda Deane		Eduardo Garcia
sig_namf		None		None		None		None
sig_namt		None		None		None		None
sig_nams		None		None		None		None

Table: cvr_campaign_disclosure

filing_id		2743941		2743941
amend_id		1		0
rec_type		CVR		CVR
form_type		F460		F460
filer_id		1435183		1435183
entity_cd		CTL		CTL
filer_naml		Eduardo Garcia for Assembly 2022		Eduardo Garcia for Assembly 2022
filer_namf		None		None
filer_namt		None		None
filer_nams		None		None
report_num		001		000
rpt_date		2022-11-05 00:00:00		2022-10-27 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		Sacramento		Sacramento
filer_st		CA		CA
filer_zip4		95815		95815
filer_phon		(916) 285-5733		(916) 285-5733
filer_fax		(916) 333-1344		(916) 333-1344
file_email		Garcia2022@deaneandcompany.com		Garcia2022@deaneandcompany.com
mail_city		None		None
mail_st		None		None
mail_zip4		None		None
tres_naml		Garcia		Garcia
tres_namf		Eduardo		Eduardo
tres_namt		None		None
tres_nams		None		None
tres_city		Sacramento		Sacramento
tres_st		CA		CA
tres_zip4		95815		95815
tres_phon		(916) 285-5733		(916) 285-5733
tres_fax		None		None
tres_email		None		None
cmtte_type		C		C
control_yn		Y		Y
sponsor_yn		N		N
primfrm_yn		None		None
brdbase_yn		None		None
amendexp_1		Update Summary Page, Sch. C, Sch. F & Sch. G		None
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		Garcia		Garcia
cand_namf		Eduardo		Eduardo
cand_namt		None		None
cand_nams		None		None
cand_city		Sacramento		Sacramento
cand_st		CA		CA
cand_zip4		95815		95815
cand_phon		(916) 285-5733		(916) 285-5733
cand_fax		(916) 333-1344		(916) 333-1344
cand_email		None		None
bal_name		None		None
bal_num		None		None
bal_juris		None		None
office_cd		ASM		ASM
offic_dscr		None		None
juris_cd		ASM		ASM
juris_dscr		None		None
dist_no		36		36
off_s_h_cd		H		H
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		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941
amend_id		1		1		1		1		1		1		1		1		1		1		1		1		0		0		0		0		0		0		0		0		0		0		0
line_item		12		1		2		3		4		5		6		7		8		9		10		11		1		2		3		4		5		6		7		8		9		10		11
rec_type		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		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		F		F		F		F		F		F		F		F		F
tran_id		PAY774		PAY709		PAY767		PAY896		PAY906		PAY827		PAY773		PAY782		PAY918		PAY804		PAY956		PAY781		PAY709		PAY767		PAY896		PAY906		PAY827		PAY773		PAY782		PAY918		PAY804		PAY781		PAY774
entity_cd		OTH		OTH		OTH		OTH		OTH		IND		OTH		OTH		OTH		IND		OTH		OTH		OTH		OTH		OTH		OTH		IND		OTH		OTH		OTH		IND		OTH		OTH
payee_naml		Vencer Public Affairs & Strategy, Inc.		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Gonzalez		LAC, Inc.		LAC, Inc.		Overland Strategies, LLC		Perez		Sandoval-Hernandez		Uribe Printing, Inc.		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Gonzalez		LAC, Inc.		LAC, Inc.		Overland Strategies, LLC		Perez		Uribe Printing, Inc.		Vencer Public Affairs & Strategy, Inc.
payee_namf		None		None		None		None		None		Carlos		None		None		None		Ruben		Luis Daniel		None		None		None		None		None		Carlos		None		None		None		Ruben		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
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
payee_city		Imperial		Dallas		Dallas		Dallas		Dallas		Indio		Sacramento		Sacramento		Riverside		Coachella		Calexico		Riverside		Dallas		Dallas		Dallas		Dallas		Indio		Sacramento		Sacramento		Riverside		Coachella		Riverside		Imperial
payee_st		CA		TX		TX		TX		TX		CA		CA		CA		CA		CA		CA		CA		TX		TX		TX		TX		CA		CA		CA		CA		CA		CA		CA
payee_zip4		92251		75247		75247		75247		75247		92201		95814		95814		92505		92236		92231		92504		75247		75247		75247		75247		92201		95814		95814		92505		92236		92504		92251
beg_bal		15000		472		2804		0		0		4000		506		14899		0		200		0		1371		472		2804		0		0		4000		506		14899		0		200		1371		15000
amt_incur		0		0		0		724		1233		0		0		0		30000		0		551		0		0		0		647		1154		0		0		0		30000		0		0		0
amt_paid		15000		472		2804		0		0		4000		0		14899		0		200		0		1371		472		2804		0		0		4000		0		14899		0		200		1371		15000
end_bal		0		0		0		724		1233		0		506		0		30000		0		551		0		0		0		647		1154		0		506		0		30000		0		0		0
expn_code		RAD		None		None		None		None		CNS		FND		FND		None		OFC		OFC		None		None		None		None		POS		CNS		FND		FND		None		OFC		None		RAD
expn_dscr		None		Credit Card Payment		Credit Card Payment		Credit Card Payment		Credit Card Payment		None		Appetizers Only		None		Digital Ads		None		None		Walk Piece		Credit Card Payment		Credit Card Payment		Credit Card Payment		None		None		Appetizers Only		None		Digital Ads		None		Walk Piece		None
cmte_id		None		None		None		None		None		None		None		None		None		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		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
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
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
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
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
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
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
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
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
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
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

Table: expn

filing_id		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941
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		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		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		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		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		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		71		72		73		74		75		76		77		78		79		80		81		82		83		84		85		86		87		88		89		90		91		92		93		94		95		96		97		98		99		100		101		102		103		104		105		106		107		108		109		110		111		112		113		114		115		116		117		118		119		120		121		122		123		124		125		126		127		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		71		72		73		74		75		76		77		78		79		80		81		82		83		84		85		86		87		88		89		90		91		92		93		94		95		96		97		98		99		100		101		102		103		104		105		106		107		108		109		110		111		112		113		114		115		116		117		118		119		120		121		122		123		124		125
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		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		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		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		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G
tran_id		EXP801		EXP857		EDT64		EXP859		EDT63		EDT72		EDT73		EXP854		EXP886		EDT71		EDT62		EXP855		EDT69		PDT174		EXP856		EDT67		EDT70		EXP858		EDT55		EXP848		PDT173		EDT66		EDT68		EXP800		EDT61		EXP874		EXP891		EXP801		EXP857		EXP859		EXP840		EXP784		EXP815		EXP817		EXP903		EXP907		EXP798		EXP854		EXP796		EXP862		EXP809		EXP839		EXP826		EXP886		EXP808		EXP828		EXP911		EXP882		EXP847		EXP885		EXP855		EXP803		EXP824		EXP864		EXP799		EXP822		EXP856		EXP858		EXP852		EXP853		EXP883		EXP884		EXP919		EXP920		EXP921		EXP922		EXP923		EXP924		EXP925		EXP893		EXP894		EXP806		EXP843		EXP848		EXP797		EXP821		EXP800		EXP805		EXP887		EXP888		EXP889		EXP786		EXP909		EXP792		EXP867		EXP875		EXP876		EXP877		EXP878		EXP901		EXP795		PDT160		PDT168		PDT179		PDT159		PDT172		PDT177		PDT170		PDT171		PDT181		PDT163		PDT167		PDT173		PDT166		PDT162		PDT165		PDT161		PDT180		PDT176		PDT178		PDT189		PDT190		EDT50		EDT57		EDT60		PDT183		PDT182		EDT49		EDT59		EDT48		EDT56		EDT58		EDT74		EDT75		EDT76		EDT77		EDT78		EXP801		EXP857		EDT64		EXP859		EDT63		EDT72		EDT73		EXP854		EXP886		EDT71		EDT62		EXP855		EDT69		PDT174		EXP856		EDT67		EDT70		EXP858		EDT55		EXP848		PDT173		EDT66		EDT68		EXP800		EDT61		EXP874		EXP891		EXP801		EXP857		EXP859		EXP840		EXP784		EXP815		EXP817		EXP903		EXP907		EXP798		EXP854		EXP796		EXP862		EXP809		EXP839		EXP826		EXP886		EXP808		EXP828		EXP911		EXP882		EXP847		EXP885		EXP855		EXP803		EXP824		EXP864		EXP799		EXP822		EXP856		EXP858		EXP852		EXP853		EXP883		EXP884		EXP919		EXP920		EXP921		EXP922		EXP923		EXP924		EXP925		EXP893		EXP894		EXP806		EXP843		EXP848		EXP797		EXP821		EXP800		EXP805		EXP887		EXP888		EXP889		EXP786		EXP909		EXP792		EXP867		EXP875		EXP876		EXP877		EXP878		EXP901		EXP795		PDT160		PDT168		PDT179		PDT159		PDT172		PDT177		PDT170		PDT171		PDT181		PDT163		PDT167		PDT173		PDT166		PDT162		PDT165		PDT161		PDT180		PDT176		PDT178		EDT50		EDT57		EDT60		PDT183		PDT182		EDT49		EDT59		EDT48		EDT56		EDT58		EDT74		EDT75		EDT76		EDT77		EDT78
entity_cd		COM		COM		COM		COM		COM		IND		IND		COM		COM		IND		COM		COM		COM		IND		COM		COM		IND		COM		IND		COM		None		COM		COM		COM		COM		OTH		OTH		COM		COM		COM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		COM		OTH		OTH		OTH		OTH		OTH		COM		IND		IND		IND		OTH		OTH		OTH		COM		OTH		OTH		OTH		OTH		IND		COM		COM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		IND		OTH		COM		OTH		OTH		COM		OTH		OTH		OTH		OTH		OTH		IND		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		COM		COM		COM		COM		COM		IND		IND		COM		COM		IND		COM		COM		COM		IND		COM		COM		IND		COM		IND		COM		None		COM		COM		COM		COM		OTH		OTH		COM		COM		COM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		COM		OTH		OTH		OTH		OTH		OTH		COM		IND		IND		IND		OTH		OTH		OTH		COM		OTH		OTH		OTH		OTH		IND		COM		COM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		IND		OTH		COM		OTH		OTH		COM		OTH		OTH		OTH		OTH		OTH		IND		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH
payee_naml		Acuna 4 CVUSD Trustee 2022		Acuna 4 CVUSD Trustee 2022		Acuna 4 CVUSD Trustee 2022		Blanca Torres Hall for CVUSD Board of Trustee 2022		Blanca Torres Hall for CVUSD Board of Trustee 2022		Campbell (IE)		Castillo (IE)		Committee to Elect Jacob Alvarez for Desert Sands Unified School District 2022 Trustee Area 2		Fauzia Rizvi for Assembly 2022		Garcia (IE)		Josie Gonzalez for Coachella City Council 2022		Kimberly Barraza for Desert Health Care District Zone 6 2022		Kimberly Barraza for Desert Health Care District Zone 6 2022		Luellen (IE)		Natalia Gonzalez for Desert Recreation District Board of Directors 2022		Natalia Gonzalez for Desert Recreation District Board of Directors 2022		Oliva (IE)		Oscar Ortiz for Indio City Council 2022		Rebollar (IE)		Rick Saldivar for Cathedral City Council 2022		Riverside County Democratic Central Committee		Ruben Perez for Desert Community College District 2022		Stephanie Virgen for Coachella City Council 2022		Steven Hernandez for Mayor 2022		Steven Hernandez for Mayor 2022		ActBlue Technical Services		ActBlue Technical Services		Acuna 4 CVUSD Trustee 2022		Acuna 4 CVUSD Trustee 2022		Blanca Torres Hall for CVUSD Board of Trustee 2022		Capitol Promotions, Inc.		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Cody's Closet		Committee to Elect Jacob Alvarez for Desert Sands Unified School District 2022 Trustee Area 2		Culturas Music & Arts		Deane & Company		Del Valle Informador, Inc.		Enrique Camarena Junior High School		Fantasy Springs Resort and Casino		Fauzia Rizvi for Assembly 2022		Gonzalez		Gonzalez		Gonzalez		Hispanas Organized for Political Equality (HOPE)		INKA Screenprinting		INKA Screenprinting		Kimberly Barraza for Desert Health Care District Zone 6 2022		KUNA-FM		LAC, Inc.		LAC, Inc.		MANA de Imperial Valley		Miranda		Natalia Gonzalez for Desert Recreation District Board of Directors 2022		Oscar Ortiz for Indio City Council 2022		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Perez		Political Data, Inc.		Rick Saldivar for Cathedral City Council 2022		Run With Los Muertos		Secretary of State		Steven Hernandez for Mayor 2022		Studio Five Design		The Lamar Companies		The Lamar Companies		The Lamar Companies		Uribe Printing, Inc.		Valle		Vencer Public Affairs & Strategy, Inc.		Vencer Public Affairs & Strategy, Inc.		Vencer Public Affairs & Strategy, Inc.		Vencer Public Affairs & Strategy, Inc.		Vencer Public Affairs & Strategy, Inc.		Vencer Public Affairs & Strategy, Inc.		Vencer Public Affairs & Strategy, Inc.		WomanHaven, A Center for Family Solutions		Bevmo		China Bistro		Desi Strong Foundation		Enterprise Rent-A-Car		Fedex		Greater Coachella Valley Chamber of Commerce		Hampton Inn & Suites		Hampton Inn & Suites		Holiday Inn Express Indio		Palm Springs Airport - Parking		PostalAnnex+		Riverside County Democratic Central Committee		Rosas Plane Food, Inc.		Staples.com		Sunridge Self Storage		The Home Depot		The Home Depot		U.S. Postmaster		U-Haul Moving & Storage		U-Haul Moving & Storage		U-Haul Moving & Storage		Mailing Pros, Inc.		Mailing Pros, Inc.		Mailing Pros, Inc.		Meta Platforms, Inc.		Political Data, Inc.		Press Print, Inc.		Press Print, Inc.		U.S. Postmaster		U.S. Postmaster		U.S. Postmaster		U.S. Postmaster		U.S. Postmaster		U.S. Postmaster		U.S. Postmaster		U.S. Postmaster		Acuna 4 CVUSD Trustee 2022		Acuna 4 CVUSD Trustee 2022		Acuna 4 CVUSD Trustee 2022		Blanca Torres Hall for CVUSD Board of Trustee 2022		Blanca Torres Hall for CVUSD Board of Trustee 2022		Campbell (IE)		Castillo (IE)		Committee to Elect Jacob Alvarez for Desert Sands Unified School District 2022 Trustee Area 2		Fauzia Rizvi for Assembly 2022		Garcia (IE)		Josie Gonzalez for Coachella City Council 2022		Kimberly Barraza for Desert Health Care District Zone 6 2022		Kimberly Barraza for Desert Health Care District Zone 6 2022		Luellen (IE)		Natalia Gonzalez for Desert Recreation District Board of Directors 2022		Natalia Gonzalez for Desert Recreation District Board of Directors 2022		Oliva (IE)		Oscar Ortiz for Indio City Council 2022		Rebollar (IE)		Rick Saldivar for Cathedral City Council 2022		Riverside County Democratic Central Committee		Ruben Perez for Desert Community College District 2022		Stephanie Virgen for Coachella City Council 2022		Steven Hernandez for Mayor 2022		Steven Hernandez for Mayor 2022		ActBlue Technical Services		ActBlue Technical Services		Acuna 4 CVUSD Trustee 2022		Acuna 4 CVUSD Trustee 2022		Blanca Torres Hall for CVUSD Board of Trustee 2022		Capitol Promotions, Inc.		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Cody's Closet		Committee to Elect Jacob Alvarez for Desert Sands Unified School District 2022 Trustee Area 2		Culturas Music & Arts		Deane & Company		Del Valle Informador, Inc.		Enrique Camarena Junior High School		Fantasy Springs Resort and Casino		Fauzia Rizvi for Assembly 2022		Gonzalez		Gonzalez		Gonzalez		Hispanas Organized for Political Equality (HOPE)		INKA Screenprinting		INKA Screenprinting		Kimberly Barraza for Desert Health Care District Zone 6 2022		KUNA-FM		LAC, Inc.		LAC, Inc.		MANA de Imperial Valley		Miranda		Natalia Gonzalez for Desert Recreation District Board of Directors 2022		Oscar Ortiz for Indio City Council 2022		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Perez		Political Data, Inc.		Rick Saldivar for Cathedral City Council 2022		Run With Los Muertos		Secretary of State		Steven Hernandez for Mayor 2022		Studio Five Design		The Lamar Companies		The Lamar Companies		The Lamar Companies		Uribe Printing, Inc.		Valle		Vencer Public Affairs & Strategy, Inc.		Vencer Public Affairs & Strategy, Inc.		Vencer Public Affairs & Strategy, Inc.		Vencer Public Affairs & Strategy, Inc.		Vencer Public Affairs & Strategy, Inc.		Vencer Public Affairs & Strategy, Inc.		Vencer Public Affairs & Strategy, Inc.		WomanHaven, A Center for Family Solutions		Bevmo		China Bistro		Desi Strong Foundation		Enterprise Rent-A-Car		Fedex		Greater Coachella Valley Chamber of Commerce		Hampton Inn & Suites		Hampton Inn & Suites		Holiday Inn Express Indio		Palm Springs Airport - Parking		PostalAnnex+		Riverside County Democratic Central Committee		Rosas Plane Food, Inc.		Staples.com		Sunridge Self Storage		The Home Depot		The Home Depot		U.S. Postmaster		U-Haul Moving & Storage		Mailing Pros, Inc.		Mailing Pros, Inc.		Mailing Pros, Inc.		Meta Platforms, Inc.		Political Data, Inc.		Press Print, Inc.		Press Print, Inc.		U.S. Postmaster		U.S. Postmaster		U.S. Postmaster		U.S. Postmaster		U.S. Postmaster		U.S. Postmaster		U.S. Postmaster		U.S. Postmaster
payee_namf		None		None		None		None		None		Don		Raymond		None		None		Luis		None		None		None		Michael		None		None		Tomas		None		Gil		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Carlos		Carlos		Carlos		None		None		None		None		None		None		None		None		Kimberly		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Ruben		None		None		None		None		None		None		None		None		None		None		Erika		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Don		Raymond		None		None		Luis		None		None		None		Michael		None		None		Tomas		None		Gil		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Carlos		Carlos		Carlos		None		None		None		None		None		None		None		None		Kimberly		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Ruben		None		None		None		None		None		None		None		None		None		None		Erika		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		Coachella		Coachella		Coachella		Indio		Indio		None		Holtville		Bermuda Dunes		Sacramento		None		Coachella		Coachella		Coachella		None		Thermal		Thermal		None		Indio		None		Cathedral City		Sacramento		Riverside		Coachella		Coachella		Coachella		Cambridge		Cambridge		Coachella		Coachella		Indio		Glenside		Dallas		Dallas		Dallas		Dallas		Dallas		El Centro		Bermuda Dunes		Coachella		Sacramento		Indio		Calexico		Indio		Sacramento		Indio		Indio		Indio		Los Angeles		Indio		Indio		Coachella		Thousand Palms		Sacramento		Sacramento		El Centro		Coachella		Thermal		Indio		Riverside		Riverside		Riverside		Riverside		Riverside		Riverside		Riverside		Riverside		Riverside		Riverside		Riverside		Riverside		Riverside		Coachella		Long Beach		Cathedral City		La Quinta		Sacramento		Coachella		Thermal		Yuma		Yuma		Yuma		Riverside		Sacramento		Imperial		Imperial		Imperial		Imperial		Imperial		Imperial		Imperial		El Centro		La Quinta		Indio		Palm Desert		Indio		Palm Desert		Indio		Indio		Indio		Indio		Palm Springs		Coachella		Sacramento		Calexico		Framingham		Coachella		Indio		Indio		Sacramento		Indio		Indio		Indio		Huntington Beach		Huntington Beach		Huntington Beach		Menlo Park		Long Beach		Banning		Banning		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Coachella		Coachella		Coachella		Indio		Indio		None		Holtville		Bermuda Dunes		Sacramento		None		Coachella		Coachella		Coachella		None		Thermal		Thermal		None		Indio		None		Cathedral City		Sacramento		Riverside		Coachella		Coachella		Coachella		Cambridge		Cambridge		Coachella		Coachella		Indio		Glenside		Dallas		Dallas		Dallas		Dallas		Dallas		El Centro		Bermuda Dunes		Coachella		Sacramento		Indio		Calexico		Indio		Sacramento		Indio		Indio		Indio		Los Angeles		Indio		Indio		Coachella		Thousand Palms		Sacramento		Sacramento		El Centro		Coachella		Thermal		Indio		Riverside		Riverside		Riverside		Riverside		Riverside		Riverside		Riverside		Riverside		Riverside		Riverside		Riverside		Riverside		Riverside		Coachella		Long Beach		Cathedral City		La Quinta		Sacramento		Coachella		Thermal		Yuma		Yuma		Yuma		Riverside		Sacramento		Imperial		Imperial		Imperial		Imperial		Imperial		Imperial		Imperial		El Centro		La Quinta		Indio		Palm Desert		Indio		Palm Desert		Indio		Indio		Indio		Indio		Palm Springs		Coachella		Sacramento		Calexico		Framingham		Coachella		Indio		Indio		Sacramento		Indio		Huntington Beach		Huntington Beach		Huntington Beach		Menlo Park		Long Beach		Banning		Banning		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento
payee_st		CA		CA		CA		CA		CA		None		CA		CA		CA		None		CA		CA		CA		None		CA		CA		None		CA		None		CA		CA		CA		CA		CA		CA		MA		MA		CA		CA		CA		PA		TX		TX		TX		TX		TX		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		AZ		AZ		AZ		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		MA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		None		CA		CA		CA		None		CA		CA		CA		None		CA		CA		None		CA		None		CA		CA		CA		CA		CA		CA		MA		MA		CA		CA		CA		PA		TX		TX		TX		TX		TX		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		AZ		AZ		AZ		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		MA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
payee_zip4		92236		92236		92236		92201		92201		None		92250		92203		95815		None		92236		92236		92236		None		92274		92274		None		92201		None		92234		95841		92501		92236		92236		92236		02138		02138		92236		92236		92201		19038		75247		75247		75247		75247		75247		92243		92203		92236		95815		92201		92231		92203		95815		92201		92201		92201		90014		92201		92201		92236		92276		95814		95814		92243		92236		92274		92201		92505		92505		92505		92505		92505		92505		92505		92505		92505		92505		92505		92505		92505		92236		90806		92234		92253		95814		92236		92274		85365		85365		85365		92504		95832		92251		92251		92251		92251		92251		92251		92251		92243		92253		92201		92211		92201		92260		92201		92203		92203		92203		92262		92236		95841		92231		01702		92236		92203		92203		95814		92201		92201		92201		92649		92649		92649		94025		90806		92220		92220		95814		95814		95814		95814		95814		95814		95814		95814		92236		92236		92236		92201		92201		None		92250		92203		95815		None		92236		92236		92236		None		92274		92274		None		92201		None		92234		95841		92501		92236		92236		92236		02138		02138		92236		92236		92201		19038		75247		75247		75247		75247		75247		92243		92203		92236		95815		92201		92231		92203		95815		92201		92201		92201		90014		92201		92201		92236		92276		95814		95814		92243		92236		92274		92201		92505		92505		92505		92505		92505		92505		92505		92505		92505		92505		92505		92505		92505		92236		90806		92234		92253		95814		92236		92274		85365		85365		85365		92504		95832		92251		92251		92251		92251		92251		92251		92251		92243		92253		92201		92211		92201		92260		92201		92203		92203		92203		92262		92236		95841		92231		01702		92236		92203		92203		95814		92201		92649		92649		92649		94025		90806		92220		92220		95814		95814		95814		95814		95814		95814		95814		95814
expn_date		2022-09-28 00:00:00		2022-10-11 00:00:00		2022-10-18 00:00:00		2022-10-11 00:00:00		2022-10-18 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-10-11 00:00:00		2022-10-18 00:00:00		2022-10-13 00:00:00		2022-10-18 00:00:00		2022-10-11 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-11 00:00:00		2022-10-18 00:00:00		2022-10-13 00:00:00		2022-10-11 00:00:00		2022-10-13 00:00:00		2022-10-10 00:00:00		2022-10-07 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-09-28 00:00:00		2022-10-18 00:00:00		2022-10-09 00:00:00		2022-10-16 00:00:00		2022-09-28 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-06 00:00:00		2022-09-26 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00		2022-09-28 00:00:00		2022-10-11 00:00:00		2022-09-28 00:00:00		2022-10-11 00:00:00		2022-09-30 00:00:00		2022-10-06 00:00:00		2022-10-04 00:00:00		2022-10-18 00:00:00		2022-09-30 00:00:00		2022-10-04 00:00:00		2022-10-22 00:00:00		2022-10-18 00:00:00		2022-10-10 00:00:00		2022-10-18 00:00:00		2022-10-11 00:00:00		2022-09-29 00:00:00		2022-10-04 00:00:00		2022-10-12 00:00:00		2022-09-28 00:00:00		2022-10-03 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-11 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-10-18 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-10-20 00:00:00		2022-10-20 00:00:00		2022-09-30 00:00:00		2022-10-09 00:00:00		2022-10-10 00:00:00		2022-09-28 00:00:00		2022-10-03 00:00:00		2022-09-28 00:00:00		2022-09-30 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-09-26 00:00:00		2022-10-22 00:00:00		2022-09-27 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-10-21 00:00:00		2022-09-28 00:00:00		2022-09-26 00:00:00		2022-10-06 00:00:00		2022-10-10 00:00:00		2022-09-26 00:00:00		2022-10-16 00:00:00		2022-10-18 00:00:00		2022-10-15 00:00:00		2022-10-15 00:00:00		2022-10-04 00:00:00		2022-09-30 00:00:00		2022-10-06 00:00:00		2022-10-07 00:00:00		2022-10-05 00:00:00		2022-09-28 00:00:00		2022-10-04 00:00:00		2022-09-26 00:00:00		2022-10-07 00:00:00		2022-10-05 00:00:00		2022-10-18 00:00:00		2022-10-20 00:00:00		2022-10-21 00:00:00		2022-10-11 00:00:00		2022-10-18 00:00:00		2022-10-20 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00		2022-10-11 00:00:00		2022-10-20 00:00:00		2022-10-11 00:00:00		2022-10-18 00:00:00		2022-10-20 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-09-28 00:00:00		2022-10-11 00:00:00		2022-10-18 00:00:00		2022-10-11 00:00:00		2022-10-18 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-10-11 00:00:00		2022-10-18 00:00:00		2022-10-13 00:00:00		2022-10-18 00:00:00		2022-10-11 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-11 00:00:00		2022-10-18 00:00:00		2022-10-13 00:00:00		2022-10-11 00:00:00		2022-10-13 00:00:00		2022-10-10 00:00:00		2022-10-07 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-09-28 00:00:00		2022-10-18 00:00:00		2022-10-09 00:00:00		2022-10-16 00:00:00		2022-09-28 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-06 00:00:00		2022-09-26 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00		2022-09-28 00:00:00		2022-10-11 00:00:00		2022-09-28 00:00:00		2022-10-11 00:00:00		2022-09-30 00:00:00		2022-10-06 00:00:00		2022-10-04 00:00:00		2022-10-18 00:00:00		2022-09-30 00:00:00		2022-10-04 00:00:00		2022-10-22 00:00:00		2022-10-18 00:00:00		2022-10-10 00:00:00		2022-10-18 00:00:00		2022-10-11 00:00:00		2022-09-29 00:00:00		2022-10-04 00:00:00		2022-10-12 00:00:00		2022-09-28 00:00:00		2022-10-03 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-11 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-10-18 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-10-20 00:00:00		2022-10-20 00:00:00		2022-09-30 00:00:00		2022-10-09 00:00:00		2022-10-10 00:00:00		2022-09-28 00:00:00		2022-10-03 00:00:00		2022-09-28 00:00:00		2022-09-30 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-09-26 00:00:00		2022-10-22 00:00:00		2022-09-27 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-10-21 00:00:00		2022-09-28 00:00:00		2022-09-26 00:00:00		2022-10-06 00:00:00		2022-10-10 00:00:00		2022-09-26 00:00:00		2022-10-16 00:00:00		2022-10-18 00:00:00		2022-10-15 00:00:00		2022-10-15 00:00:00		2022-10-04 00:00:00		2022-09-30 00:00:00		2022-10-06 00:00:00		2022-10-07 00:00:00		2022-10-05 00:00:00		2022-09-28 00:00:00		2022-10-04 00:00:00		2022-09-26 00:00:00		2022-10-07 00:00:00		2022-10-05 00:00:00		2022-10-18 00:00:00		2022-10-11 00:00:00		2022-10-18 00:00:00		2022-10-20 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00		2022-10-11 00:00:00		2022-10-20 00:00:00		2022-10-11 00:00:00		2022-10-18 00:00:00		2022-10-20 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00
amount		2000		2000		383		2000		383		3475		3480		2000		1000		3150		383		3000		383		1450		3000		383		4420		4000		3360		2000		120		383		383		2000		383		506		415		2000		2000		2000		1072		472		2804		2433		1050		89		500		2000		2000		3516		1840		5000		5657		1000		381		4000		213		450		924		1468		3000		5280		9195		14899		500		97		3000		4000		19559		20379		379		383		383		383		383		383		383		383		383		13086		13678		200		5000		2000		1000		20		2000		5678		800		2500		2550		1371		315		15000		3475		3480		3150		4420		3360		1450		500		731		228		500		986		75		267		187		180		292		62		84		120		153		568		294		86		171		29		216		33		47		3399		1739		2197		20416		2784		9526		6622		19559		754		13086		600		600		500		900		500		2000		2000		383		2000		383		3475		3480		2000		1000		3150		383		3000		383		1450		3000		383		4420		4000		3360		2000		120		383		383		2000		383		506		415		2000		2000		2000		1072		472		2804		2433		1050		89		500		2000		2000		3516		1840		5000		5657		1000		381		4000		213		450		924		1468		3000		5280		9195		14899		500		97		3000		4000		19559		20379		379		383		383		383		383		383		383		383		383		13086		13678		200		5000		2000		1000		20		2000		5678		800		2500		2550		1371		315		15000		3475		3480		3150		4420		3360		1450		500		731		228		500		986		75		267		187		180		292		62		84		120		153		568		294		86		171		29		216		3399		1739		2197		20416		2784		9526		6622		19559		754		13086		600		600		500		900		500
cum_ytd		6883		6883		6883		4383		4383		3475		3480		4000		1000		3150		4383		7383		7383		1450		7383		7383		4420		4000		3360		2000		120		2383		4383		4383		4383		2144		2144		6883		6883		4383		11764		32997		32997		32997		32997		32997		500		4000		3000		26920		4680		5000		13505		1000		15594		15594		15594		450		2392		2392		7383		5280		81818		81818		500		203		7383		4000		177342		177342		177342		177342		177342		177342		177342		177342		177342		177342		177342		177342		177342		564		12206		2000		1000		1267		4383		15558		35600		35600		35600		2121		315		47210		47210		47210		47210		47210		47210		47210		500		731		228		500		986		256		267		366		366		292		2040		344		120		153		568		2876		1294		1294		54157		1019		1019		1019		18037		18037		18037		20416		12206		16148		16148		54157		54157		54157		54157		54157		54157		54157		54157		6883		6883		6883		4383		4383		3475		3480		4000		1000		3150		4383		7383		7383		1450		7383		7383		4420		4000		3360		2000		120		2383		4383		4383		4383		2144		2144		6883		6883		4383		11764		32839		32839		32839		32839		32839		500		4000		3000		26920		4680		5000		13505		1000		15594		15594		15594		450		2392		2392		7383		5280		81818		81818		500		203		7383		4000		177342		177342		177342		177342		177342		177342		177342		177342		177342		177342		177342		177342		177342		564		12206		2000		1000		1267		4383		15558		35600		35600		35600		2121		315		47210		47210		47210		47210		47210		47210		47210		500		731		228		500		986		256		267		366		366		292		2040		344		120		153		568		2876		1294		1294		54157		939		18037		18037		18037		20416		12206		16148		16148		54157		54157		54157		54157		54157		54157		54157		54157
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		IKD		MON		IKD		IND		IND		MON		MON		IND		IKD		MON		IKD		IND		MON		IKD		IND		MON		IND		MON		MON		IKD		IKD		MON		IKD		OFC		OFC		CTB		CTB		CTB		CMP		None		None		None		None		None		CVC		CTB		CVC		PRO		PRT		CVC		FND		CTB		OFC		CNS		None		CVC		CMP		CMP		CTB		RAD		FND		FND		CVC		OFC		CTB		CTB		POS		LIT		LIT		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		POS		LIT		OFC		OFC		CTB		CVC		OFC		CTB		CMP		CMP		CMP		CMP		None		None		RAD		IND		IND		IND		IND		IND		IND		CVC		FND		OFC		CVC		TRC		POS		OFC		TRS		TRS		TRS		TRC		POS		CTB		OFC		OFC		OFC		OFC		OFC		POS		OFC		OFC		OFC		LIT		LIT		LIT		None		None		LIT		LIT		POS		POS		POS		IND		IND		IND		IND		IND		MON		MON		IKD		MON		IKD		IND		IND		MON		MON		IND		IKD		MON		IKD		IND		MON		IKD		IND		MON		IND		MON		MON		IKD		IKD		MON		IKD		OFC		OFC		CTB		CTB		CTB		CMP		None		None		None		None		None		CVC		CTB		CVC		PRO		PRT		CVC		FND		CTB		OFC		CNS		None		CVC		CMP		CMP		CTB		RAD		FND		FND		CVC		OFC		CTB		CTB		POS		LIT		LIT		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		POS		LIT		OFC		OFC		CTB		CVC		OFC		CTB		CMP		CMP		CMP		CMP		None		None		RAD		IND		IND		IND		IND		IND		IND		CVC		FND		OFC		CVC		TRC		POS		OFC		TRS		TRS		TRS		TRC		POS		CTB		OFC		OFC		OFC		OFC		OFC		POS		OFC		LIT		LIT		LIT		None		None		LIT		LIT		POS		POS		POS		IND		IND		IND		IND		IND
expn_dscr		None		None		Mailer		None		Mailer		Mailer		Mailer		None		None		Mailer		Mailer		None		Mailer		Mailer		None		Mailer		Mailer		None		Mailer		None		None		Mailer		Mailer		None		Mailer		None		None		None		None		None		None		Credit Card Payment		Credit Card Payment		Credit Card Payment		Credit Card Payment		Credit Card Payment		None		None		None		None		None		None		09/25/22, Fundraising Event, 40, including Candidate		None		None		None		Mileage		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Mailer - In-Kind to Steven Hernandez for Mayor 2022 (ID#1454871)		Mailer - In-Kind to Josie Gonzalez for Coachella City Council 2022 (ID# 1453232)		Mailer - In-Kind to Blanca Torres Hall for CVUSD Board of Trustee2022 (ID# 1413696)		Mailer - In-Kind to Ruben Perez for Desert Community College District 2022 (ID# 1448047)		Mailer - In-Kind to Kimberly Barraza for Desert Health Care District Zone 6 2022 (ID# 1452967)		Mailer - In-Kind to Natalia Gonzalez for Desert Recreation District Board of Directors 2022 (ID# 1452827)		Mailer - In-Kind to Stephanie Virgen for Coachella City Council 2022 (ID# 1452043)		Mailer - In-Kind to Kimberly Barraza for Desert Health Care DistrictZone 6 2022 (ID# 1452967)		None		None		None		None		None		None		None		None		None		None		None		None		Walk Piece		Mileage		None		Mailer/Support/Don Campbell/Irrigation District Director/Imperial County/Division 3		Mailer/Support/Raymond Castillo/County Supervisor/Imperial County		Mailer/Support/Luis Garcia/City Council/City of Imperial		Mailer/Support/Tomas Oliva/Mayor/City of El Centro		Mailer/Support/Gil Rebollar/City Council/City of Brawley		Mailer/Support/Michael Luellen/City Council/City of Calipatria		None		9/26/22, Golf Fundraiser Prizes		Food for Volunteers		None		9/15/22-9/26/22, Rental Truck for Campaign Sign Installation		None		None		10/14/22-10/15/22, Lodging, Campaign Travel, 1		10/14/22-10/15/22, Lodging, Campaign Travel, 1		10/4/22-10/6/22, Lodging, Campaign Event, 1		None		None		None		10/5/22, Campaign Meeting, 4, including Candidate		None		None		None		None		None		None		None		None		None		None		None		Digital Ads		Digital Ads		None		None		Paid through Mailing Pros, Inc.		Paid through Mailing Pros, Inc.		Paid through Mailing Pros, Inc.		Mailer		Mailer		Mailer		Mailer		Mailer		None		None		Mailer		None		Mailer		Mailer		Mailer		None		None		Mailer		Mailer		None		Mailer		Mailer		None		Mailer		Mailer		None		Mailer		None		None		Mailer		Mailer		None		Mailer		None		None		None		None		None		None		Credit Card Payment		Credit Card Payment		Credit Card Payment		Credit Card Payment		Credit Card Payment		None		None		None		None		None		None		09/25/22, Fundraising Event, 40, including Candidate		None		None		None		Mileage		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Mailer - In-Kind to Steven Hernandez for Mayor 2022 (ID#1454871)		Mailer - In-Kind to Josie Gonzalez for Coachella City Council 2022 (ID# 1453232)		Mailer - In-Kind to Blanca Torres Hall for CVUSD Board of Trustee2022 (ID# 1413696)		Mailer - In-Kind to Ruben Perez for Desert Community College District 2022 (ID# 1448047)		Mailer - In-Kind to Kimberly Barraza for Desert Health Care District Zone 6 2022 (ID# 1452967)		Mailer - In-Kind to Natalia Gonzalez for Desert Recreation District Board of Directors 2022 (ID# 1452827)		Mailer - In-Kind to Stephanie Virgen for Coachella City Council 2022 (ID# 1452043)		Mailer - In-Kind to Kimberly Barraza for Desert Health Care DistrictZone 6 2022 (ID# 1452967)		None		None		None		None		None		None		None		None		None		None		None		None		Walk Piece		Mileage		None		Mailer/Support/Don Campbell/Irrigation District Director/Imperial County/Division 3		Mailer/Support/Raymond Castillo/County Supervisor/Imperial County		Mailer/Support/Luis Garcia/City Council/City of Imperial		Mailer/Support/Tomas Oliva/Mayor/City of El Centro		Mailer/Support/Gil Rebollar/City Council/City of Brawley		Mailer/Support/Michael Luellen/City Council/City of Calipatria		None		9/26/22, Golf Fundraiser Prizes		Food for Volunteers		None		9/15/22-9/26/22, Rental Truck for Campaign Sign Installation		None		None		10/14/22-10/15/22, Lodging, Campaign Travel, 1		10/14/22-10/15/22, Lodging, Campaign Travel, 1		10/4/22-10/6/22, Lodging, Campaign Event, 1		None		None		None		10/5/22, Campaign Meeting, 4, including Candidate		None		None		None		None		None		None		None		None		None		Digital Ads		Digital Ads		None		None		Paid through Mailing Pros, Inc.		Paid through Mailing Pros, Inc.		Paid through Mailing Pros, Inc.		Mailer		Mailer		Mailer		Mailer		Mailer
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Vencer Public Affairs & Strategy, Inc.		Vencer Public Affairs & Strategy, Inc.		Vencer Public Affairs & Strategy, Inc.		Vencer Public Affairs & Strategy, Inc.		Vencer Public Affairs & Strategy, Inc.		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Card Service Center		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Overland Strategies, LLC		Vencer Public Affairs & Strategy, Inc.		Vencer Public Affairs & Strategy, Inc.		Vencer Public Affairs & Strategy, Inc.		Vencer Public Affairs & Strategy, Inc.		Vencer Public Affairs & Strategy, Inc.
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1371750		1371750		1413696		None		None		None		None		None		None		None		1454833		None		None		None		None		None		1445659		None		None		None		None		None		None		1452967		None		None		None		None		None		1452827		1450424		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1440501		None		None		1454871		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1342861		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1371750		1371750		1413696		None		None		None		None		None		None		None		1454833		None		None		None		None		None		1445659		None		None		None		None		None		None		1452967		None		None		None		None		None		1452827		1450424		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1440501		None		None		1454871		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1342861		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		Joey Acuna		Joey Acuna		Joey Acuna		Blanca Torres Hall		Blanca Torres Hall		Don Campbell		Raymond Castillo		Jacob Alvarez		Fauzia Rizvi		Luis Garcia		Josie Gonzalez		Kimberly Barraza		Kimberly Barraza		Michael Luellen		Natalia Gonzalez		Natalia Gonzalez		Tomas Oliva		Oscar Ortiz		Gil Rebollar		Rick Saldivar		None		Ruben Perez		Stephanie Virgen		Steven Hernandez		Steven Hernandez		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Joey Acuna		Joey Acuna		Joey Acuna		Blanca Torres Hall		Blanca Torres Hall		Don Campbell		Raymond Castillo		Jacob Alvarez		Fauzia Rizvi		Luis Garcia		Josie Gonzalez		Kimberly Barraza		Kimberly Barraza		Michael Luellen		Natalia Gonzalez		Natalia Gonzalez		Tomas Oliva		Oscar Ortiz		Gil Rebollar		Rick Saldivar		None		Ruben Perez		Stephanie Virgen		Steven Hernandez		Steven Hernandez		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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_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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		ASM		CCM		CCM		OTH		OTH		CCM		OTH		OTH		MAY		CCM		CCM		CCM		None		OTH		OTH		MAY		MAY		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		ASM		CCM		CCM		OTH		OTH		CCM		OTH		OTH		MAY		CCM		CCM		CCM		None		OTH		OTH		MAY		MAY		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
offic_dscr		Coachella Valley USD Trustee		Coachella Valley USD Trustee		Coachella Valley USD Trustee		Coachella Valley USD Trustee		Coachella Valley USD Trustee		Irrigation District Director		Supervisor		Desert Sands USD School Board Member		None		None		None		Healthcare District Board, Zone 6		Healthcare District Board, Zone 6		None		Desert Recreation District Board		Desert Recreation District Board		None		None		None		None		None		Desert Community College Board		City Councilmember		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Coachella Valley USD Trustee		Coachella Valley USD Trustee		Coachella Valley USD Trustee		Coachella Valley USD Trustee		Coachella Valley USD Trustee		Irrigation District Director		Supervisor		Desert Sands USD School Board Member		None		None		None		Healthcare District Board, Zone 6		Healthcare District Board, Zone 6		None		Desert Recreation District Board		Desert Recreation District Board		None		None		None		None		None		Desert Community College Board		City Councilmember		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		ASM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		None		OTH		OTH		OTH		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		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		ASM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		None		OTH		OTH		OTH		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
juris_dscr		Riverside County, Area 1		Riverside County, Area 1		Riverside County, Area 1		Riverside County, Area 1		Riverside County, Area 1		Imperial County, Div. 3		Imperial County		Riverside County		None		City of Imperial		City of Coachella		Riverside County		Riverside County		City of Calipatria		City of Coachella, Division 1		City of Coachella, Division 1		City of El Centro		City of Indio		City of Brawley		Cathedral City		None		Riverside County, Area 1		City of Coachella		City of Coachella		City of Coachella		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Riverside County, Area 1		Riverside County, Area 1		Riverside County, Area 1		Riverside County, Area 1		Riverside County, Area 1		Imperial County, Div. 3		Imperial County		Riverside County		None		City of Imperial		City of Coachella		Riverside County		Riverside County		City of Calipatria		City of Coachella, Division 1		City of Coachella, Division 1		City of El Centro		City of Indio		City of Brawley		Cathedral City		None		Riverside County, Area 1		City of Coachella		City of Coachella		City of Coachella		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		5		None		63		6		None		None		None		None		None		None		None		4		None		4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		5		None		63		6		None		None		None		None		None		None		None		4		None		4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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_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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		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		F		E		F		F		F		F		E		E		E		F		E		E		E		E		F		E		F		F		F		E		E		E		E		E		E		E		E		E		E		E		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		None		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		F		E		F		F		F		F		E		E		E		F		E		E		E		E		F		E		F		E		E		E		E		E		E		E		E		E		E		E		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		1435183		1435183
filing_id		2743941		2743941
period_id		251		251
form_id		F460		F460
filing_sequence		1		0
filing_date		2022-11-07 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-05 00:00:00		2022-10-27 00:00:00
filing_type		22001		22001

Table: filings

filing_id		2743941
filing_type		22001

Table: hdr

filing_id		2743941		2743941
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		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941
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		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		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		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		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
rec_type		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT
form_type		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		C		C		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		C		C
tran_id		INC842		IDT51		INC810		INC860		IDT49		IDT56		INC872		INC833		INC832		INC873		INC890		INC871		INC788		INC879		INC870		INC838		INC802		INC820		IDT42		INC892		IDT52		INC811		IDT43		INC790		INC913		INC837		IDT40		INC898		INC851		IDT61		INC789		IDT41		IDT60		INC844		IDT44		IDT57		IDT59		IDT53		INC835		IDT45		INC914		IDT47		IDT58		IDT55		INC813		INC861		INC836		IDT50		INC819		IDT46		INC831		IDT54		INC830		INC850		INC846		INC791		NON863		NON825		INC842		IDT51		INC810		INC860		IDT49		IDT56		INC872		INC833		INC832		INC873		INC890		INC871		INC788		INC879		INC870		INC838		INC802		INC820		IDT42		INC892		IDT52		INC811		IDT43		INC790		INC913		INC837		IDT40		INC898		INC851		IDT61		INC789		IDT41		IDT60		INC844		IDT44		IDT57		IDT59		IDT53		INC835		IDT45		INC914		IDT47		IDT58		IDT55		INC813		INC861		INC836		IDT50		INC819		IDT46		INC831		IDT54		INC830		INC850		INC846		INC791		NON863		NON825
entity_cd		OTH		IND		OTH		OTH		IND		IND		OTH		OTH		OTH		OTH		COM		COM		COM		COM		COM		COM		COM		SCC		OTH		OTH		IND		OTH		IND		SCC		COM		OTH		IND		OTH		OTH		IND		OTH		OTH		IND		OTH		IND		IND		IND		IND		OTH		IND		OTH		IND		IND		IND		SCC		COM		OTH		IND		OTH		IND		COM		IND		SCC		COM		OTH		OTH		PTY		OTH		OTH		IND		OTH		OTH		IND		IND		OTH		OTH		OTH		OTH		COM		COM		COM		COM		COM		COM		COM		SCC		OTH		OTH		IND		OTH		IND		SCC		COM		OTH		IND		OTH		OTH		IND		OTH		OTH		IND		OTH		IND		IND		IND		IND		OTH		IND		OTH		IND		IND		IND		SCC		COM		OTH		IND		OTH		IND		COM		IND		SCC		COM		OTH		OTH		PTY		OTH
ctrib_naml		Amazon.com Services, LLC		Anderson		Anthony Vineyards, Inc.		Aya Healthcare, Inc.		Backstrom		Baldonado		Barona Band of Mission Indians		Berkshire Hathaway Energy		Burrtec Waste and Recycling Services, LLC		CADIZ, Inc.		California Academy of Eye Physicians and Surgeons PAC		California American Water Employee PAC		California Cable & Telecommunications Association PAC		California Cable & Telecommunications Association PAC		California Dental Association PAC (CDA PAC)		California Hospital Association PAC Sponsored by California Association of Hospitals and Health System		California Medical Association PAC (CALPAC)		California Teachers Association/Association for Better Citizenship Small Contributor Committee		California Water Service (Cal Water)		Calpine Corporation		Choi		Diageo North America, Inc.		Escobar		Faculty for our University's Future, a committee sponsored by the California Faculty Association Small Contributor Committee		Ford Motor Company Civic Action Fund (FEC ID# C00046474)		Greenleaf Power, LLC		Hernandez		Intersect Power, LLC		Jacobs Engineering Group, Inc.		Murphy		Nationwide Environmental Services		Paramount Pictures		Parris		Pechanga Band of Luiseno Indians		Perez		Perez		Perez		Pizarro		Populus Financial Group, Inc.		Powell		Reyes Coca-Cola Bottling, LLC and Affiliated Entities		Rigatti		Rodriguez		Schilling		Sheet Metal, Air, Rail, Transportation Workers' International Union (S.M.A.R.T.) Local 105 PAC Small Contributor Committee		Specialty Equipment Market Association California PAC		Sunpower Corporation Systems		Takayesu		Three Rivers Energy Development, LLC		Tubbs		UAW Region 8 Western States PAC		Umanoff		United Domestic Workers of America Action Fund Small Contributor Committee		United Parcel Service, Inc. PAC (FEC ID# C00064766)		UnitedHealth Group, Inc.		Valley Vista Services, Inc.		California Democratic Party		Fantasy Springs Resort and Casino		Amazon.com Services, LLC		Anderson		Anthony Vineyards, Inc.		Aya Healthcare, Inc.		Backstrom		Baldonado		Barona Band of Mission Indians		Berkshire Hathaway Energy		Burrtec Waste and Recycling Services, LLC		CADIZ, Inc.		California Academy of Eye Physicians and Surgeons PAC		California American Water Employee PAC		California Cable & Telecommunications Association PAC		California Cable & Telecommunications Association PAC		California Dental Association PAC (CDA PAC)		California Hospital Association PAC Sponsored by California Association of Hospitals and Health System		California Medical Association PAC (CALPAC)		California Teachers Association/Association for Better Citizenship Small Contributor Committee		California Water Service (Cal Water)		Calpine Corporation		Choi		Diageo North America, Inc.		Escobar		Faculty for our University's Future, a committee sponsored by the California Faculty Association Small Contributor Committee		Ford Motor Company Civic Action Fund (FEC ID# C00046474)		Greenleaf Power, LLC		Hernandez		Intersect Power, LLC		Jacobs Engineering Group, Inc.		Murphy		Nationwide Environmental Services		Paramount Pictures		Parris		Pechanga Band of Luiseno Indians		Perez		Perez		Perez		Pizarro		Populus Financial Group, Inc.		Powell		Reyes Coca-Cola Bottling, LLC and Affiliated Entities		Rigatti		Rodriguez		Schilling		Sheet Metal, Air, Rail, Transportation Workers' International Union (S.M.A.R.T.) Local 105 PAC Small Contributor Committee		Specialty Equipment Market Association California PAC		Sunpower Corporation Systems		Takayesu		Three Rivers Energy Development, LLC		Tubbs		UAW Region 8 Western States PAC		Umanoff		United Domestic Workers of America Action Fund Small Contributor Committee		United Parcel Service, Inc. PAC (FEC ID# C00064766)		UnitedHealth Group, Inc.		Valley Vista Services, Inc.		California Democratic Party		Fantasy Springs Resort and Casino
ctrib_namf		None		Jill		None		None		Michael		Andrew		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Caroline		None		Oscar		None		None		None		Brandon		None		None		Drew		None		None		R. Rex		None		Gabriel		Gabriel		Jose		Pedro		None		Steven		None		Maria		Juan		Natalie		None		None		None		Erik		None		Cody		None		Adam		None		None		None		None		None		None		None		Jill		None		None		Michael		Andrew		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Caroline		None		Oscar		None		None		None		Brandon		None		None		Drew		None		None		R. Rex		None		Gabriel		Gabriel		Jose		Pedro		None		Steven		None		Maria		Juan		Natalie		None		None		None		Erik		None		Cody		None		Adam		None		None		None		None		None		None
ctrib_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
ctrib_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
ctrib_city		Seattle		South Pasadena		Bakersfield		San Diego		Sierra Madre		Carmichael		Lakeside		Des Moines		San Marcos		Los Angeles		San Francisco		San Diego		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Burlingame		San Jose		Houston		Manhattan Beach		Norwalk		San Francisco		Sacramento		Dearborn		Sacramento		San Francisco		Oakland		Los Angeles		Los Angeles		Norwalk		Los Angeles		Lancaster		Temecula		Rancho Mirage		Rancho Mirage		Winchester		Pasadena		Irving		Rosemead		Irvine		Laguna Hills		Los Angeles		Rancho Palos Verdes		Glendora		Diamond Bar		San Jose		Pomoma		Pleasanton		Newport Beach		Pico Rivera		Manhattan Beach		Sacramento		Atlanta		Minnetonka		City of Industry		Sacramento		Indio		Seattle		South Pasadena		Bakersfield		San Diego		Sierra Madre		Carmichael		Lakeside		Des Moines		San Marcos		Los Angeles		San Francisco		San Diego		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Burlingame		San Jose		Houston		Manhattan Beach		Norwalk		San Francisco		Sacramento		Dearborn		Sacramento		San Francisco		Oakland		Los Angeles		Los Angeles		Norwalk		Los Angeles		Lancaster		Temecula		Rancho Mirage		Rancho Mirage		Winchester		Pasadena		Irving		Rosemead		Irvine		Laguna Hills		Los Angeles		Rancho Palos Verdes		Glendora		Diamond Bar		San Jose		Pomoma		Pleasanton		Newport Beach		Pico Rivera		Manhattan Beach		Sacramento		Atlanta		Minnetonka		City of Industry		Sacramento		Indio
ctrib_st		WA		CA		CA		CA		CA		CA		CA		IA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		TX		CA		CT		CA		CA		MI		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		MA		CA		TX		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		GA		MN		CA		CA		CA		WA		CA		CA		CA		CA		CA		CA		IA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		TX		CA		CT		CA		CA		MI		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		MA		CA		TX		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		GA		MN		CA		CA		CA
ctrib_zip4		98109		91030		93307		92121		91024		95608		92040		50306		92078		90071		94131		92101		95814		95814		95814		95814		95814		94010		95112		77002		90266		06851		94105		95814		48126		95864		94105		94612		90017		90027		90650		90038		93534		92592		92270		92270		01890		91106		75062		91770		92614		92653		90015		90275		91740		91765		94520		91768		94566		92660		90660		90266		95814		30328		55343		91748		95811		92203		98109		91030		93307		92121		91024		95608		92040		50306		92078		90071		94131		92101		95814		95814		95814		95814		95814		94010		95112		77002		90266		06851		94105		95814		48126		95864		94105		94612		90017		90027		90650		90038		93534		92592		92270		92270		01890		91106		75062		91770		92614		92653		90015		90275		91740		91765		94520		91768		94566		92660		90660		90266		95814		30328		55343		91748		95811		92203
ctrib_emp		None		Southern California Edison		None		None		Southern California Edison		Southern California Edison		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Edison International & Southern California Edison		None		Niesar & Vestal, LLP		None		None		None		Reforma Strategies, LLC		None		None		Edison International		None		None		R. Rex Parris		None		Coachella		Coachella		n/a		Edison International		None		Southern California Edison		None		Edison International		Bearstar Strategies		Edison International		None		None		None		Southern California Edison		None		Edison International		None		Edison International		None		None		None		None		None		None		None		Southern California Edison		None		None		Southern California Edison		Southern California Edison		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Edison International & Southern California Edison		None		Niesar & Vestal, LLP		None		None		None		Reforma Strategies, LLC		None		None		Edison International		None		None		R. Rex Parris		None		Coachella		Coachella		n/a		Edison International		None		Southern California Edison		None		Edison International		Bearstar Strategies		Edison International		None		None		None		Southern California Edison		None		Edison International		None		Edison International		None		None		None		None		None		None
ctrib_occ		None		Executive Vice President		None		None		Vice President, Regulatory Affairs		Vice President, State Public Affairs		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Executive		None		Attorney		None		None		None		Principal		None		None		Energy Executive		None		None		Attorney		None		Planner		Planner		Not Employed		President/Chief Executive Officer		None		Chief Executive Officer		None		Chief Financial Officer		Consultant		Senior Vice President/HR Officer		None		None		None		Executive		None		Director		None		Executive		None		None		None		None		None		None		None		Executive Vice President		None		None		Vice President, Regulatory Affairs		Vice President, State Public Affairs		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Executive		None		Attorney		None		None		None		Principal		None		None		Energy Executive		None		None		Attorney		None		Planner		Planner		Not Employed		President/Chief Executive Officer		None		Chief Executive Officer		None		Chief Financial Officer		Consultant		Senior Vice President/HR Officer		None		None		None		Executive		None		Director		None		Executive		None		None		None		None		None		None
ctrib_self		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tran_type		None		I		None		None		I		I		None		None		None		None		None		None		None		None		None		None		None		None		I		None		I		None		I		None		None		None		I		None		None		I		None		I		I		None		I		I		I		I		None		I		None		I		I		I		None		None		None		I		None		I		None		I		None		None		None		None		None		None		None		I		None		None		I		I		None		None		None		None		None		None		None		None		None		None		None		None		I		None		I		None		I		None		None		None		I		None		None		I		None		I		I		None		I		I		I		I		None		I		None		I		I		I		None		None		None		I		None		I		None		I		None		None		None		None		None		None
rcpt_date		2022-10-06 00:00:00		2022-10-14 00:00:00		2022-09-30 00:00:00		2022-10-11 00:00:00		2022-10-13 00:00:00		2022-10-18 00:00:00		2022-10-13 00:00:00		2022-10-04 00:00:00		2022-10-04 00:00:00		2022-10-13 00:00:00		2022-10-18 00:00:00		2022-10-13 00:00:00		2022-09-26 00:00:00		2022-10-14 00:00:00		2022-10-12 00:00:00		2022-10-05 00:00:00		2022-09-28 00:00:00		2022-10-01 00:00:00		2022-10-04 00:00:00		2022-10-19 00:00:00		2022-10-17 00:00:00		2022-09-30 00:00:00		2022-10-05 00:00:00		2022-09-26 00:00:00		2022-10-21 00:00:00		2022-10-05 00:00:00		2022-10-03 00:00:00		2022-10-20 00:00:00		2022-10-10 00:00:00		2022-10-18 00:00:00		2022-09-26 00:00:00		2022-10-04 00:00:00		2022-10-21 00:00:00		2022-10-07 00:00:00		2022-10-05 00:00:00		2022-10-16 00:00:00		2022-10-21 00:00:00		2022-10-17 00:00:00		2022-10-05 00:00:00		2022-10-12 00:00:00		2022-10-21 00:00:00		2022-10-13 00:00:00		2022-10-20 00:00:00		2022-10-18 00:00:00		2022-09-30 00:00:00		2022-10-11 00:00:00		2022-10-05 00:00:00		2022-10-13 00:00:00		2022-09-30 00:00:00		2022-10-12 00:00:00		2022-10-04 00:00:00		2022-10-17 00:00:00		2022-10-04 00:00:00		2022-10-10 00:00:00		2022-10-07 00:00:00		2022-09-26 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-10-06 00:00:00		2022-10-14 00:00:00		2022-09-30 00:00:00		2022-10-11 00:00:00		2022-10-13 00:00:00		2022-10-18 00:00:00		2022-10-13 00:00:00		2022-10-04 00:00:00		2022-10-04 00:00:00		2022-10-13 00:00:00		2022-10-18 00:00:00		2022-10-13 00:00:00		2022-09-26 00:00:00		2022-10-14 00:00:00		2022-10-12 00:00:00		2022-10-05 00:00:00		2022-09-28 00:00:00		2022-10-01 00:00:00		2022-10-04 00:00:00		2022-10-19 00:00:00		2022-10-17 00:00:00		2022-09-30 00:00:00		2022-10-05 00:00:00		2022-09-26 00:00:00		2022-10-21 00:00:00		2022-10-05 00:00:00		2022-10-03 00:00:00		2022-10-20 00:00:00		2022-10-10 00:00:00		2022-10-18 00:00:00		2022-09-26 00:00:00		2022-10-04 00:00:00		2022-10-21 00:00:00		2022-10-07 00:00:00		2022-10-05 00:00:00		2022-10-16 00:00:00		2022-10-21 00:00:00		2022-10-17 00:00:00		2022-10-05 00:00:00		2022-10-12 00:00:00		2022-10-21 00:00:00		2022-10-13 00:00:00		2022-10-20 00:00:00		2022-10-18 00:00:00		2022-09-30 00:00:00		2022-10-11 00:00:00		2022-10-05 00:00:00		2022-10-13 00:00:00		2022-09-30 00:00:00		2022-10-12 00:00:00		2022-10-04 00:00:00		2022-10-17 00:00:00		2022-10-04 00:00:00		2022-10-10 00:00:00		2022-10-07 00:00:00		2022-09-26 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00
date_thru		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		2500		1500		4900		1000		1500		1500		4900		4900		2000		4900		2000		1000		2000		2000		2000		1500		1500		9700		4900		4900		2500		1500		1000		2000		2500		1900		4900		4000		4000		500		2000		1000		2500		2400		1000		500		1000		4900		1000		2500		2000		1500		4000		1500		4900		1300		3500		1500		2000		1500		2000		1500		4000		2500		4000		2000		6		4900		2500		1500		4900		1000		1500		1500		4900		4900		2000		4900		2000		1000		2000		2000		2000		1500		1500		9700		4900		4900		2500		1500		1000		2000		2500		1900		4900		4000		4000		500		2000		1000		2500		2400		1000		500		1000		4900		1000		2500		2000		1500		4000		1500		4900		1300		3500		1500		2000		1500		2000		1500		4000		2500		4000		2000		20		4900
cum_ytd		2500		1500		4900		1000		1500		1500		5800		4900		2000		4900		2000		1000		4000		4000		2000		1500		1500		19400		9800		6800		2500		1500		1000		2000		6900		4900		4900		4000		4000		500		2000		1000		2500		4900		1500		1500		1000		4900		1000		2500		2000		1500		4000		1500		9800		2600		3500		1500		2000		1500		2000		1500		4000		2500		6000		2000		33261		4900		2500		1500		4900		1000		1500		1500		5800		4900		2000		4900		2000		1000		4000		4000		2000		1500		1500		19400		9800		6800		2500		1500		1000		2000		6900		4900		4900		4000		4000		500		2000		1000		2500		4900		1500		1500		1000		4900		1000		2500		2000		1500		4000		1500		9800		2600		3500		1500		2000		1500		2000		1500		4000		2500		6000		2000		33275		4900
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
ctrib_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		Dialer (Phone-bank)		Fundraising Event Expenses		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Dialer (Phone-bank)		Fundraising Event Expenses
cmte_id		None		None		None		None		None		None		None		None		None		None		980331		1342002		745932		745932		742855		790773		742617		741941		None		None		None		None		None		850007		761070		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		962809		861377		None		None		None		None		743787		None		1302384		1377592		None		None		741666		None		None		None		None		None		None		None		None		None		None		None		980331		1342002		745932		745932		742855		790773		742617		741941		None		None		None		None		None		850007		761070		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		962809		861377		None		None		None		None		743787		None		1302384		1377592		None		None		741666		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
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
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
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
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
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
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
intr_naml		None		ActBlue		None		None		ActBlue		ActBlue		None		None		None		None		None		None		None		None		None		None		None		None		ActBlue		None		ActBlue		None		ActBlue		None		None		None		ActBlue		None		None		ActBlue		None		ActBlue		ActBlue		None		ActBlue		ActBlue		ActBlue		ActBlue		None		ActBlue		None		ActBlue		ActBlue		ActBlue		None		None		None		ActBlue		None		ActBlue		None		ActBlue		None		None		None		None		None		None		None		ActBlue		None		None		ActBlue		ActBlue		None		None		None		None		None		None		None		None		None		None		None		None		ActBlue		None		ActBlue		None		ActBlue		None		None		None		ActBlue		None		None		ActBlue		None		ActBlue		ActBlue		None		ActBlue		ActBlue		ActBlue		ActBlue		None		ActBlue		None		ActBlue		ActBlue		ActBlue		None		None		None		ActBlue		None		ActBlue		None		ActBlue		None		None		None		None		None		None
intr_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
intr_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
intr_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
intr_city		None		Cambridge		None		None		Cambridge		Cambridge		None		None		None		None		None		None		None		None		None		None		None		None		Cambridge		None		Cambridge		None		Cambridge		None		None		None		Cambridge		None		None		Cambridge		None		Cambridge		Cambridge		None		Cambridge		Cambridge		Cambridge		Cambridge		None		Cambridge		None		Cambridge		Cambridge		Cambridge		None		None		None		Cambridge		None		Cambridge		None		Cambridge		None		None		None		None		None		None		None		Cambridge		None		None		Cambridge		Cambridge		None		None		None		None		None		None		None		None		None		None		None		None		Cambridge		None		Cambridge		None		Cambridge		None		None		None		Cambridge		None		None		Cambridge		None		Cambridge		Cambridge		None		Cambridge		Cambridge		Cambridge		Cambridge		None		Cambridge		None		Cambridge		Cambridge		Cambridge		None		None		None		Cambridge		None		Cambridge		None		Cambridge		None		None		None		None		None		None
intr_st		None		MA		None		None		MA		MA		None		None		None		None		None		None		None		None		None		None		None		None		MA		None		MA		None		MA		None		None		None		MA		None		None		MA		None		MA		MA		None		MA		MA		MA		MA		None		MA		None		MA		MA		MA		None		None		None		MA		None		MA		None		MA		None		None		None		None		None		None		None		MA		None		None		MA		MA		None		None		None		None		None		None		None		None		None		None		None		None		MA		None		MA		None		MA		None		None		None		MA		None		None		MA		None		MA		MA		None		MA		MA		MA		MA		None		MA		None		MA		MA		MA		None		None		None		MA		None		MA		None		MA		None		None		None		None		None		None
intr_zip4		None		02138		None		None		02138		02138		None		None		None		None		None		None		None		None		None		None		None		None		02138		None		02138		None		02138		None		None		None		02138		None		None		02138		None		02138		02138		None		02138		02138		02138		02138		None		02138		None		02138		02138		02138		None		None		None		02138		None		02138		None		02138		None		None		None		None		None		None		None		02138		None		None		02138		02138		None		None		None		None		None		None		None		None		None		None		None		None		02138		None		02138		None		02138		None		None		None		02138		None		None		02138		None		02138		02138		None		02138		02138		02138		02138		None		02138		None		02138		02138		02138		None		None		None		02138		None		02138		None		02138		None		None		None		None		None		None
intr_emp		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_occ		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_self		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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_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
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
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
office_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
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
juris_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
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
dist_no		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
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
sup_opp_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
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
memo_refno		INC842		None		None		None		None		None		None		None		INC832		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		INC837		None		INC898		None		None		None		None		None		None		None		None		None		None		None		None		INC914		None		None		None		None		None		None		None		INC819		None		None		None		None		None		None		None		None		None		INC842		None		None		None		None		None		None		None		INC832		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		INC837		None		INC898		None		None		None		None		None		None		None		None		None		None		None		None		INC914		None		None		None		None		None		None		None		INC819		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
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
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
int_rate		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_cmteid		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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: smry

filing_id		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941
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		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		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		1		2		3		1		2		3		1		2		3		1		2		3		4		1		2		3		1		2		3		1		2		3		4		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		1		2		3		1		2		3		1		2		3		1		2		3		1		2		3		4		1		2		3		1		2		3		1		2		3		4
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		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		A		A		A		B1		B1		B1		C		C		C		D		D		D		E		E		E		E		F		F		F		H		H		H		I		I		I		I		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		A		A		A		B1		B1		B1		C		C		C		D		D		D		E		E		E		E		F		F		F		H		H		H		I		I		I		I
amount_a		144466		0		144466		4906		149372		212175		0		212175		-6237		4906		210844		525458		144466		80		212175		457829		0		0		33014		144400		66		144466		0		0		0		4906		0		4906		45519		0		45519		212175		0		0		212175		32508		38745		-6237		0		0		0		0		80		0		80		144466		0		144466		4920		149386		212175		0		212175		-6945		4920		210150		525458		144466		80		212175		457829		0		0		32306		144400		66		144466		0		0		0		4920		0		4920		45519		0		45519		212175		0		0		212175		31800		38745		-6945		0		0		0		0		80		0		80
amount_b		611194		0		611194		46395		657590		684106		0		684106		33014		46395		763516		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		611194		0		611194		46409		657604		684106		0		684106		32306		46409		762822		None		None		None		None		None		None		None		None		None		None		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		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		None		None		None		None		None		None		None		None		None		None		None		None

Table: splt

filing_id		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941		2743941
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		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		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		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		71		72		73		74		75		76		77		78		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		71		72		73		74		75		76		77		78
pform_type		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		C		D		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		C		D
ptran_id		INC842		INC842		IDT51		INC810		INC810		INC860		IDT49		IDT56		INC872		INC872		INC833		INC833		INC832		INC873		INC890		INC871		INC788		INC788		INC879		INC879		INC870		INC870		INC838		INC802		INC802		INC820		INC820		IDT42		IDT42		INC892		INC892		IDT52		INC811		IDT43		INC790		INC790		INC913		INC913		INC837		IDT40		INC898		INC851		IDT61		INC789		IDT41		IDT41		IDT60		INC844		INC844		IDT44		IDT57		IDT59		IDT53		INC835		INC835		IDT45		INC914		IDT47		IDT58		IDT55		INC813		INC813		INC861		INC861		INC836		IDT50		INC819		IDT46		INC831		IDT54		INC830		INC830		INC850		INC846		INC846		INC791		NON825		EXP886		INC842		INC842		IDT51		INC810		INC810		INC860		IDT49		IDT56		INC872		INC872		INC833		INC833		INC832		INC873		INC890		INC871		INC788		INC788		INC879		INC879		INC870		INC870		INC838		INC802		INC802		INC820		INC820		IDT42		IDT42		INC892		INC892		IDT52		INC811		IDT43		INC790		INC790		INC913		INC913		INC837		IDT40		INC898		INC851		IDT61		INC789		IDT41		IDT41		IDT60		INC844		INC844		IDT44		IDT57		IDT59		IDT53		INC835		INC835		IDT45		INC914		IDT47		IDT58		IDT55		INC813		INC813		INC861		INC861		INC836		IDT50		INC819		IDT46		INC831		IDT54		INC830		INC830		INC850		INC846		INC846		INC791		NON825		EXP886
elec_date		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00
elec_amount		2500		2500		1500		2000		4900		1000		1500		1500		4900		4900		3000		4900		2000		4900		2000		1000		2600		4000		2600		4000		2000		2000		1500		3500		1500		9700		9700		4900		4900		4900		4900		2500		1500		1000		1500		2000		4900		4000		4900		4900		4000		4000		500		2000		1000		1000		2500		4900		4900		1500		1500		1000		4900		1000		1000		2500		2000		1500		4000		1500		4900		4900		1300		1300		3500		1500		2000		1500		2000		1500		4000		4000		2500		4000		4000		2000		4900		1000		2500		2500		1500		2000		4900		1000		1500		1500		4900		4900		3000		4900		2000		4900		2000		1000		2600		4000		2600		4000		2000		2000		1500		3500		1500		9700		9700		4900		4900		4900		4900		2500		1500		1000		1500		2000		4900		4000		4900		4900		4000		4000		500		2000		1000		1000		2500		4900		4900		1500		1500		1000		4900		1000		1000		2500		2000		1500		4000		1500		4900		4900		1300		1300		3500		1500		2000		1500		2000		1500		4000		4000		2500		4000		4000		2000		4900		1000
elec_code		P		G		G		P		G		G		G		G		P		G		P		G		G		G		G		G		P		G		P		G		P		G		G		P		G		P		G		P		G		P		G		G		G		G		P		G		P		G		G		G		G		G		G		G		P		G		G		P		G		G		G		G		G		P		G		G		G		G		G		G		P		G		P		G		G		G		G		G		G		G		P		G		G		P		G		G		G		G		P		G		G		P		G		G		G		G		P		G		P		G		G		G		G		G		P		G		P		G		P		G		G		P		G		P		G		P		G		P		G		G		G		G		P		G		P		G		G		G		G		G		G		G		P		G		G		P		G		G		G		G		G		P		G		G		G		G		G		G		P		G		P		G		G		G		G		G		G		G		P		G		G		P		G		G		G		G