Home

Filing ID: 2744319

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

Table: cvr2_campaign_disclosure

filing_id		2744319		2744319
amend_id		0		0
line_item		1		2
rec_type		CVR2		CVR2
form_type		F460		F460
tran_id		OFC1		NIC3
entity_cd		ATR		COM
title		None		None
mail_city		None		None
mail_st		None		None
mail_zip4		None		None
f460_part		3		5b
cmte_id		None		1419761
enty_naml		Rubio		Senator Susan Rubio Ballot Measure Committee
enty_namf		Susan		None
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		None		None
enty_email		None		None
tres_naml		None		Deane
tres_namf		None		Shawnda
tres_namt		None		None
tres_nams		None		None
control_yn		None		Y
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		2744319		2744319
amend_id		0		0
line_item		1		2
rec_type		CVR3		CVR3
form_type		F460		F460
tran_id		shawnda.1		VER_2.2
entity_cd		TRE		CAO
sig_date		2022-10-26 00:00:00		2022-10-26 00:00:00
sig_loc		None		None
sig_naml		Shawnda Deane		Susan Rubio
sig_namf		None		None
sig_namt		None		None
sig_nams		None		None

Table: cvr_campaign_disclosure

filing_id		2744319
amend_id		0
rec_type		CVR
form_type		F460
filer_id		1415107
entity_cd		CTL
filer_naml		Susan Rubio for Senate 2022
filer_namf		None
filer_namt		None
filer_nams		None
report_num		000
rpt_date		2022-10-27 00:00:00
stmt_type		PE
late_rptno		None
from_date		2022-09-25 00:00:00
thru_date		2022-10-22 00:00:00
elect_date		2022-11-08 00:00:00
filer_city		Sacramento
filer_st		CA
filer_zip4		95815
filer_phon		(916) 285-5733
filer_fax		(916) 333-1344
file_email		[email protected]
mail_city		None
mail_st		None
mail_zip4		None
tres_naml		Deane
tres_namf		Shawnda
tres_namt		None
tres_nams		None
tres_city		Sacramento
tres_st		CA
tres_zip4		95815
tres_phon		(916) 285-5733
tres_fax		None
tres_email		None
cmtte_type		C
control_yn		Y
sponsor_yn		N
primfrm_yn		None
brdbase_yn		None
amendexp_1		None
amendexp_2		None
amendexp_3		None
rpt_att_cb		None
cmtte_id		None
reportname		None
rptfromdt		None
rptthrudt		None
emplbus_cb		None
bus_name		None
bus_city		None
bus_st		None
bus_zip4		None
bus_inter		None
busact_cb		None
busactvity		None
assoc_cb		None
assoc_int		None
other_cb		None
other_int		None
cand_naml		Rubio
cand_namf		Susan
cand_namt		None
cand_nams		None
cand_city		Sacramento
cand_st		CA
cand_zip4		95815
cand_phon		(916) 285-5733
cand_fax		None
cand_email		None
bal_name		None
bal_num		None
bal_juris		None
office_cd		SEN
offic_dscr		None
juris_cd		SEN
juris_dscr		None
dist_no		22
off_s_h_cd		H
sup_opp_cd		None
employer		None
occupation		None
selfemp_cb		None
bal_id		None
cand_id		None

Table: debt

filing_id		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319
amend_id		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
rec_type		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
tran_id		PAY2571		PAY2647		PAY2708		PAY2709		PAY2660		PAY2661		PAY2616		PAY2751		PAY2637		PAY2654		PAY2655		PAY2656		PAY2657
entity_cd		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		IND		IND		IND		IND
payee_naml		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Image Cube, Inc.		Image Cube, Inc.		LAC, Inc.		LAC, Inc.		Nossaman, LLP		Robert Lopez dba Campaign Management Group		Robert Lopez dba Campaign Management Group		Robert Lopez dba Campaign Management Group		Rubio
payee_namf		None		None		None		None		None		None		None		None		None		None		None		None		Sylvia
payee_namt		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
payee_city		Irving		Irving		Irving		Irving		Sylmar		Sylmar		Sacramento		Sacramento		Los Angeles		Ontario		Ontario		Ontario		Downey
payee_st		TX		TX		TX		TX		CA		CA		CA		CA		CA		CA		CA		CA		CA
payee_zip4		75038		75038		75038		75038		91342		91342		95814		95814		90017		91764		91764		91764		90240
beg_bal		8626		2563		0		0		27543		26426		1905		0		130		5000		5000		5000		3500
amt_incur		0		0		9120		1880		0		0		0		11325		0		0		0		0		0
amt_paid		8626		0		0		0		27543		26426		0		0		0		5000		5000		5000		3500
end_bal		0		2563		9120		1880		0		0		1905		11325		130		0		0		0		0
expn_code		None		None		None		None		LIT		POS		FND		FND		PRO		CNS		CNS		CNS		None
expn_dscr		Credit Card Payment		Credit Card Payment		Credit Card Payment		Credit Card Payment		None		None		None		None		None		None		None		None		Campaign Management
cmte_id		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
tres_namf		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
tres_nams		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
tres_st		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
memo_code		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
bakref_tid		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
xref_match		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: expn

filing_id		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319
amend_id		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		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
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
form_type		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		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		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G
tran_id		EXP2674		EXP2700		EXP2703		EXP2743		EXP2691		EXP2748		EXP2749		EXP2741		EXP2692		EXP2702		EXP2742		EXP2696		EXP2740		EXP2697		EXP2690		EXP2694		EXP2739		EXP2701		PDT1272		EXP2695		EXP2659		EXP2734		EXP2674		EXP2700		EXP2737		EXP2703		EXP2743		EXP2691		EXP2748		EXP2749		EXP2741		EXP2710		EXP2738		EXP2721		EXP2706		EXP2692		EXP2702		EXP2742		EXP2670		EXP2672		EXP2686		EXP2687		EXP2711		EXP2696		EXP2740		EXP2697		EXP2698		EXP2752		EXP2690		EXP2694		EXP2662		EXP2664		EXP2666		EXP2739		EXP2668		EXP2712		EXP2701		EXP2731		EXP2732		EXP2736		EXP2695		PDT1237		PDT1234		PDT1235		PDT1232		PDT1264		PDT1265		PDT1248		PDT1251		PDT1238		PDT1254		PDT1262		PDT1227		PDT1241		PDT1225		PDT1249		PDT1259		PDT1260		PDT1255		PDT1216		PDT1221		PDT1229		PDT1268		PDT1269		PDT1270		PDT1271		PDT1244		PDT1243		PDT1219		PDT1226		PDT1228		PDT1240		PDT1242		PDT1257		PDT1252		PDT1273		PDT1246		PDT1223		PDT1261		PDT1218		PDT1220		PDT1247		PDT1245		PDT1250		PDT1256		PDT1239		PDT1258		PDT1236		PDT1224		PDT1272		EDT543		EDT544
entity_cd		COM		COM		COM		COM		COM		None		None		COM		COM		COM		COM		COM		COM		None		COM		COM		COM		COM		COM		COM		OTH		OTH		COM		COM		OTH		COM		COM		COM		OTH		OTH		COM		OTH		OTH		OTH		OTH		COM		COM		COM		OTH		OTH		OTH		OTH		OTH		COM		COM		OTH		OTH		OTH		COM		COM		IND		IND		IND		COM		IND		IND		COM		OTH		OTH		OTH		COM		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		OTH		OTH		OTH		OTH		COM		OTH		OTH
payee_naml		Alex Hirsch for West Sacramento City Council 2022		Alvarado-Gil for Senate 2022		Angelique Ashby for Senate 2022		Angelique Ashby for Senate 2022		Apolinario for School Board 2022		California Democratic Party		California Democratic Party		Catherine Blakespear for Senate 2022		Emmanuel J. Estrada for Baldwin Park Mayor 2022		Esmeralda Soria for Assembly 2022		Esmeralda Soria for Assembly 2022		Julia Ruedas for El Monte City Council 2022		Julia Ruedas for El Monte City Council 2022		Los Angeles County Democratic Party		Padilla 4 School Board 2022		Ricardo Vazques for City Council 2022		Rocha for Senate 2022		Sara Hernandez for Community College Trustee 2022		Tri Counties Democratic Club		Valenzuela for Treasurer 2022		ActBlue Technical Services		ActBlue Technical Services		Alex Hirsch for West Sacramento City Council 2022		Alvarado-Gil for Senate 2022		American Union Printing, Inc.		Angelique Ashby for Senate 2022		Angelique Ashby for Senate 2022		Apolinario for School Board 2022		California Democratic Party		California Democratic Party		Catherine Blakespear for Senate 2022		COGS South Signs		COGS South Signs		Deane & Company		Elan Financial Services		Emmanuel J. Estrada for Baldwin Park Mayor 2022		Esmeralda Soria for Assembly 2022		Esmeralda Soria for Assembly 2022		Image Cube, Inc.		Image Cube, Inc.		Image Cube, Inc.		Image Cube, Inc.		Impact Posting		Julia Ruedas for El Monte City Council 2022		Julia Ruedas for El Monte City Council 2022		Los Angeles County Democratic Party		New Nation Strategies, LLC		Next Gen Campaigns		Padilla 4 School Board 2022		Ricardo Vazques for City Council 2022		Robert Lopez dba Campaign Management Group		Robert Lopez dba Campaign Management Group		Robert Lopez dba Campaign Management Group		Rocha for Senate 2022		Rubio		Rubio		Sara Hernandez for Community College Trustee 2022		The Charters Mailing Group, Inc.		The Charters Mailing Group, Inc.		Valencia Marketing		Valenzuela for Treasurer 2022		4imprint		76		76		Aioli Bodega Espanola		Amazon, LLC		Amazon, LLC		Amazon, LLC		Amazon, LLC		Apple, Inc.		Apple, Inc.		Apple, Inc.		Arco		Arco		Chevron		Enterprise Rent-A-Car		Enthusiast, Inc.		Enthusiast, Inc.		Fog Harbor Fish House		GoDaddy		GoDaddy		GoDaddy		Hawaiian Airlines		Hawaiian Airlines		Hawaiian Airlines		Hawaiian Airlines		International Coercive Control Conference		Los Angeles Times		Lyft, Inc.		Lyft, Inc.		Lyft, Inc.		Lyft, Inc.		Lyft, Inc.		Lyft, Inc.		Lyft, Inc.		M&C Hotel Interests, Inc.		Political Data, Inc.		Sam's Chowder House		San Gabriel Valley News		Southwest Airlines		Southwest Airlines		Southwest Airlines		Southwest Airlines		Southwest Airlines		Southwest Airlines		Starbucks		Starbucks		The New Stand		The Ritz-Carlton, Half Moon Bay		Tri Counties Democratic Club		U.S. Postmaster		U.S. Postmaster
payee_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Sylvia		Sylvia		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
payee_city		West Sacramento		Jackson		Sacramento		Sacramento		Baldwin Park		Sacramento		Sacramento		Sacramento		Baldwin Park		Sacramento		Sacramento		Covina		Covina		Los Angeles		El Monte		Baldwin Park		Los Angeles		Sacramento		Diamond Bar		Baldwin Park		Cambridge		Cambridge		West Sacramento		Jackson		Santa Ana		Sacramento		Sacramento		Baldwin Park		Sacramento		Sacramento		Sacramento		Santa Ana		Santa Ana		Sacramento		Irving		Baldwin Park		Sacramento		Sacramento		Sylmar		Sylmar		Sylmar		Sylmar		Santa Ana		Covina		Covina		Los Angeles		Alhambra		Sacramento		El Monte		Baldwin Park		Ontario		Ontario		Ontario		Los Angeles		Downey		Downey		Sacramento		Signal Hill		Signal Hill		Whittier		Baldwin Park		Oshkosh		Long Beach		Long Beach		Sacramento		Seattle		Seattle		Seattle		Seattle		Cupertino		Cupertino		Cupertino		Glendora		Glendora		Sacramento		Sacramento		Johnston		Johnston		San Francisco		Scottsdale		Scottsdale		Scottsdale		Sacramento		Sacramento		Sacramento		Sacramento		Milford		El Segundo		San Francisco		San Francisco		San Francisco		San Francisco		San Francisco		San Francisco		San Francisco		Boulder		Norwalk		Half Moon Bay		Monrovia		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		West Covina		West Covina		Los Angeles		Half Moon Bay		Diamond Bar		Baldwin Park		Baldwin Park
payee_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		MA		MA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		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		WI		CA		CA		CA		WA		WA		WA		WA		CA		CA		CA		CA		CA		CA		CA		RI		RI		CA		AZ		AZ		AZ		CA		CA		CA		CA		MI		CA		CA		CA		CA		CA		CA		CA		CA		CO		CA		CA		CA		TX		TX		TX		TX		TX		TX		CA		CA		CA		CA		CA		CA		CA
payee_zip4		95691		95642		95815		95815		91706		95811		95811		95815		91706		95815		95815		91722		91722		90017		91731		91706		90017		95815		91765		91706		02138		02138		95691		95642		92705		95815		95815		91706		95811		95811		95815		92707		92707		95815		75038		91706		95815		95815		91342		91342		91342		91342		92707		91722		91722		90017		91803		95826		91731		91706		91764		91764		91764		90017		90240		90240		95815		90755		90755		90601		91706		54901		90808		90808		95811		98109		98109		98109		98109		95014		95014		95014		91741		91741		95814		95837		02919		02919		94133		85260		85260		85260		95837		95837		95837		95837		48381		90245		94107		94107		94107		94107		94107		94107		94107		80302		90650		94019		91016		75235		75235		75235		75235		75235		75235		91791		91791		90045		94019		91765		91706		91706
expn_date		2022-09-29 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-20 00:00:00		2022-10-05 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-20 00:00:00		2022-10-05 00:00:00		2022-10-07 00:00:00		2022-10-20 00:00:00		2022-10-05 00:00:00		2022-10-20 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-20 00:00:00		2022-10-07 00:00:00		2022-10-22 00:00:00		2022-10-05 00:00:00		2022-09-25 00:00:00		2022-10-16 00:00:00		2022-09-29 00:00:00		2022-10-07 00:00:00		2022-10-19 00:00:00		2022-10-07 00:00:00		2022-10-20 00:00:00		2022-10-05 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-20 00:00:00		2022-10-10 00:00:00		2022-10-19 00:00:00		2022-10-13 00:00:00		2022-10-09 00:00:00		2022-10-05 00:00:00		2022-10-07 00:00:00		2022-10-20 00:00:00		2022-09-28 00:00:00		2022-09-28 00:00:00		2022-10-04 00:00:00		2022-10-04 00:00:00		2022-10-10 00:00:00		2022-10-05 00:00:00		2022-10-20 00:00:00		2022-10-05 00:00:00		2022-10-06 00:00:00		2022-10-22 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-09-28 00:00:00		2022-09-28 00:00:00		2022-09-28 00:00:00		2022-10-20 00:00:00		2022-09-28 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-10-19 00:00:00		2022-10-05 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-07 00:00:00		2022-09-28 00:00:00		2022-09-28 00:00:00		2022-10-13 00:00:00		2022-10-15 00:00:00		2022-10-11 00:00:00		2022-10-14 00:00:00		2022-10-20 00:00:00		2022-10-02 00:00:00		2022-10-07 00:00:00		2022-10-02 00:00:00		2022-10-16 00:00:00		2022-10-17 00:00:00		2022-10-18 00:00:00		2022-10-14 00:00:00		2022-09-26 00:00:00		2022-09-28 00:00:00		2022-10-04 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00		2022-10-12 00:00:00		2022-10-12 00:00:00		2022-09-27 00:00:00		2022-10-02 00:00:00		2022-10-02 00:00:00		2022-10-07 00:00:00		2022-10-11 00:00:00		2022-10-14 00:00:00		2022-10-16 00:00:00		2022-10-22 00:00:00		2022-10-13 00:00:00		2022-10-01 00:00:00		2022-10-18 00:00:00		2022-09-27 00:00:00		2022-09-28 00:00:00		2022-10-05 00:00:00		2022-10-12 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-06 00:00:00		2022-10-16 00:00:00		2022-10-11 00:00:00		2022-10-01 00:00:00		2022-10-22 00:00:00		2022-10-04 00:00:00		2022-10-18 00:00:00
amount		121		1000		500		500		500		25000		10000		4900		750		500		500		3000		1900		500		2000		750		500		500		245		500		40		0		121		1000		6890		500		500		500		25000		10000		4900		5749		1262		3035		8626		750		500		500		27543		26426		13117		15573		4300		3000		1900		500		33000		5850		2000		750		5000		5000		5000		500		3500		5000		500		1609		16398		1250		500		549		108		12		716		10		22		98		16		10		10		12		71		30		32		165		2450		616		264		282		24		71		269		447		315		134		196		16		25		40		15		14		79		16		29		172		989		184		10		333		333		47		176		328		329		16		26		107		108		245		15573		16398
cum_ytd		121		1000		3000		3000		500		127350		127350		4900		750		1000		1000		4900		4900		2450		2000		750		500		500		245		500		1298		1298		121		1000		6890		3000		3000		500		127350		127350		4900		7011		7011		28544		70886		750		1000		1000		199216		199216		199216		199216		4300		4900		4900		2450		75000		11350		2000		750		15000		15000		15000		500		14500		14500		500		18007		18007		1250		500		549		121		121		1545		845		845		845		845		628		628		628		193		193		235		819		5516		5516		264		527		527		527		1165		1165		1165		1165		196		128		1510		1510		1510		1510		1510		1510		1510		172		3457		184		100		8791		8791		8791		8791		8791		8791		104		104		107		108		245		112132		112132
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
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
expn_code		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		OFC		OFC		CTB		CTB		LIT		CTB		CTB		CTB		CTB		CTB		CTB		CMP		CMP		PRO		None		CTB		CTB		CTB		LIT		POS		LIT		POS		CMP		CTB		CTB		CTB		PHO		PHO		CTB		CTB		CNS		CNS		CNS		CTB		None		None		CTB		LIT		POS		LIT		CTB		OFC		TRC		TRC		OFC		OFC		OFC		OFC		OFC		OFC		OFC		OFC		TRC		OFC		TRC		TRC		OFC		OFC		OFC		WEB		WEB		WEB		TRC		TRS		TRS		TRS		OFC		OFC		TRC		TRC		TRC		OFC		TRC		TRC		OFC		TRC		OFC		OFC		OFC		TRC		TRC		TRC		TRC		TRC		TRC		OFC		OFC		OFC		TRC		CTB		POS		POS
expn_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		Credit Card Payment		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Campaign Management		Campaign Management		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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_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		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Image Cube, Inc.		The Charters Mailing Group, 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
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
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
cmte_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1450640		1444765		None		1425662		1425662		1450948		741666		741666		1436941		None		None		None		None		1444425		1443835		1443835		None		None		None		None		None		1450674		1450674		1237135		None		None		1358876		1442650		None		None		None		1443327		None		None		1438882		None		None		None		1451676		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1393624		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
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
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
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
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
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
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
cand_naml		Alex Hirsch		Marie Alvarado-Gil		Angelique Ashby		Angelique Ashby		Annalyn Apolinario		None		None		Catherine Blakespear		Emmanuel J. Estrada		Esmeralda Soria		Esmeralda Soria		Julia Ruedas		Julia Ruedas		None		Ricardo Padilla		Ricardo Vazques		Joseph Rocha		Sara Hernandez		None		Joanna Valenzuela		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
office_cd		CCM		SEN		SEN		SEN		OTH		None		None		SEN		MAY		ASM		ASM		CCM		CCM		None		OTH		CCM		SEN		OTH		None		TRS		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		Board Member, Baldwin Park USD		None		None		None		None		None		None		None		None		None		El Monte Union School Board		None		None		Community College Trustee		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		SEN		SEN		SEN		OTH		None		None		SEN		OTH		ASM		ASM		OTH		OTH		None		OTH		OTH		SEN		CTY		None		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
juris_dscr		City of West Sacramento		None		None		None		Los Angeles County		None		None		None		City of Baldwin Park		None		None		City of El Monte		City of El Monte		None		Los Angeles County		City of Baldwin Park		None		Los Angeles County		None		City of Baldwin Park		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		4		4		8		8		None		None		None		38		None		27		27		3		3		None		None		None		40		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
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
sup_opp_cd		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
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
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
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
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		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		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
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

Table: filer_filings

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

Table: filings

filing_id		2744319
filing_type		22001

Table: hdr

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

Table: rcpt

filing_id		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319
amend_id		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
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
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
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		I
tran_id		INC2747		INC2719		INC2717		INC2651		INC2652		INC2715		INC2723		INC2689		INC2658		INC2725		INC2688		INC2649		INC2744		INC2699		INC2718		INC2730		INC2754		INC2714		INC2750		INC2735		INC2685		INC2683		INC2727		INC2713		INC2755		INC2745		INC2753		INC2678		INC2650		INC2729		IDT136		INC2676		INC2722		INC2724		INC2746		INC2716		INC2679		INC2728		INC2677		INC2726
entity_cd		OTH		OTH		OTH		SCC		OTH		OTH		OTH		OTH		OTH		OTH		COM		COM		COM		OTH		OTH		OTH		COM		OTH		OTH		OTH		COM		SCC		COM		COM		OTH		OTH		COM		OTH		COM		COM		SCC		OTH		COM		OTH		COM		OTH		SCC		OTH		COM		OTH
ctrib_naml		Agua Caliente Band of Cahuilla Indians		Amazon.com Services, LLC		Amgen, Inc.		Association of California School Administrators PAC Small Contributor Committee		AstraZeneca Pharmaceuticals, LP / Zeneca, Inc.		Aya Healthcare, Inc.		Barona Band of Mission Indians		Berry Petroleum Company, LLC		Blue Shield of California		Blue Shield of California		California New Car Dealers Association PAC		California Pawnbrokers Association PAC		CARGO PAC California Trucking Association		Comcast Financial Agency Corporation		Cox Communications and Affiliated Entities		Deloitte Services, LP		Dentaquest PAC-TN-C (CA)		DoorDash, Inc.		Elevance Health, Inc. and It's Affiliate Anthem Blue Cross		Eli Lilly and Company Federal PAC		Farmers Group, Inc. Employees & Agents PAC		Farmers Group, Inc. Employees and Agents PAC Small Contributor Committee		GFC Courage Committee - Hollywood Chapter		GFC Courage Committee - Sierra Chapter		Gilead Sciences, Inc.		Intersect Power, LLC		JPMorgan Chase & Company PAC (FEC ID: C00128512)		Molson Coors Beverage Company		National Association of Industrial & Office Properties SOCAL PAC (NAIOP)		National Union of Healthcare Workers Candidate Committee for Quality Patient Care and Union Democracy		National Women's Political Caucus of California PAC		Pfizer, Inc.		Philips North America, LLC PAC (FEDPAC ID# C00239780		Reyes Coca-Cola Bottling, LLC		San Bernardino County Sheriff's Employees' Benefit Association PAC		The Dentists Insurance Company		United Food and Commercial Workers (UFCW) Western States Council Candidates PAC Small Contributor Committee		Universal Music Group, Inc.		Western Manufactured Housing Communities Association PAC		First Foundation Bank
ctrib_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
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
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
ctrib_city		Palm Springs		Seattle		Alexandria		Burlingame		Wilmington		San Diego		Lakeside		Bakersfield		Oakland		Oakland		Sacramento		Sacramento		Sacramento		Philadelphia		San Diego		Hermitage		Nashville		San Francisco		Cincinnati		Indianapolis		San Rafael		San Rafael		San Rafael		San Rafael		Raleigh		Oakland		Washington		Chicago		Irvine		Sacramento		Beverly Hills		Memphis		Washington		Niles		Sacramento		Sacramento		Buena Park		Woodland Hills		Sacramento		Irvine
ctrib_st		CA		WA		VA		CA		DE		CA		CA		CA		CA		CA		CA		CA		CA		PA		CA		TN		TN		CA		OH		IN		CA		CA		CA		CA		NC		CA		DC		IL		CA		CA		CA		TN		DC		IL		CA		CA		CA		CA		CA		CA
ctrib_zip4		92264		98109		22303		94010		19850		92121		92040		93311		94607		94607		95814		95814		95834		19103		92111		37076		37203		94107		45209		46225		94901		94901		94901		94901		27609		94612		20004		60606		92618		95815		90211		38120		20005		60714		95814		95814		90620		91367		95814		92612
ctrib_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
ctrib_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
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
tran_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		I		None		None		None		None		None		None		None		None		None
rcpt_date		2022-10-20 00:00:00		2022-10-12 00:00:00		2022-10-11 00:00:00		2022-09-27 00:00:00		2022-09-27 00:00:00		2022-10-11 00:00:00		2022-10-13 00:00:00		2022-10-04 00:00:00		2022-09-28 00:00:00		2022-10-05 00:00:00		2022-10-04 00:00:00		2022-09-26 00:00:00		2022-10-19 00:00:00		2022-10-06 00:00:00		2022-10-11 00:00:00		2022-10-17 00:00:00		2022-10-21 00:00:00		2022-10-11 00:00:00		2022-10-20 00:00:00		2022-10-18 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-10-14 00:00:00		2022-10-10 00:00:00		2022-10-21 00:00:00		2022-10-20 00:00:00		2022-10-21 00:00:00		2022-09-30 00:00:00		2022-09-27 00:00:00		2022-10-18 00:00:00		2022-10-17 00:00:00		2022-09-30 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-10-20 00:00:00		2022-10-11 00:00:00		2022-09-30 00:00:00		2022-10-14 00:00:00		2022-09-30 00:00:00		2022-09-30 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
amount		3000		1200		2500		7100		2000		1000		2400		2000		4900		-4900		1000		1000		3000		1900		1000		1000		3000		1000		2800		2000		2500		7200		4900		4900		2500		2000		2000		1500		1000		1000		250		2000		1500		1000		4900		2800		1000		2000		2000		1
cum_ytd		3000		3700		2500		9600		2000		1000		2400		2000		0		0		5000		1000		3000		4900		1000		1000		3000		2000		4800		2000		2500		7200		4900		4900		2500		2000		2000		3000		1000		3500		250		2000		1500		1000		9800		4300		1000		2000		2000		0
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
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		Interest Earned
cmte_id		None		None		None		842151		None		None		None		None		None		None		741623		743255		760458		None		None		None		1408990		None		None		None		901422		1343619		1416424		1416442		None		None		1257506		None		950520		1318200		746373		None		1367728		None		822554		None		910874		None		742422		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
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
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
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
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
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
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
intr_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		ActBlue		None		None		None		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
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
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
intr_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		Cambridge		None		None		None		None		None		None		None		None		None
intr_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		MA		None		None		None		None		None		None		None		None		None
intr_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		02138		None		None		None		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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
memo_refno		None		INC2719		None		None		None		None		None		INC2689		None		INC2725		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		INC2745		None		None		None		None		None		None		None		INC2724		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
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
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
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
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

Table: smry

filing_id		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319
amend_id		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
line_item		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		22A		22B		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
form_type		F460		F460		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		85855		0		85855		0		85855		248089		0		248089		-58770		0		189319		556506		85855		1		248089		394272		0		0		26923		300673		970869		85850		5		85855		0		0		0		0		0		0		54166		0		54166		248089		0		0		248089		22325		81095		-58770		0		0		0		1		0		0		1
amount_b		567630		0		567630		379		568009		798958		0		798958		26923		379		826260		None		None		None		None		None		None		None		None		None		None		None		None		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
elec_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2022-11-08 00:00:00		2022-06-07 00:00:00		None		None		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		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319		2744319
amend_id		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		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
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		D		D		D		D		D		D		D		D		D
ptran_id		INC2747		INC2747		INC2719		INC2719		INC2717		INC2717		INC2651		INC2651		INC2652		INC2652		INC2715		INC2723		INC2723		INC2689		INC2658		INC2658		INC2725		INC2725		INC2688		INC2688		INC2649		INC2649		INC2744		INC2744		INC2699		INC2699		INC2718		INC2718		INC2730		INC2730		INC2754		INC2714		INC2714		INC2750		INC2750		INC2735		INC2735		INC2685		INC2683		INC2683		INC2727		INC2727		INC2713		INC2755		INC2755		INC2745		INC2753		INC2753		INC2678		INC2678		INC2650		INC2729		INC2729		IDT136		INC2676		INC2676		INC2722		INC2724		INC2746		INC2746		INC2716		INC2716		INC2679		INC2728		INC2728		INC2677		INC2677		EXP2700		EXP2703		EXP2703		EXP2743		EXP2743		EXP2741		EXP2702		EXP2742		EXP2739
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
elec_amount		3800		3000		4900		4900		4500		2500		9700		9700		4900		4100		1000		4900		4900		2000		4900		3000		4900		3000		4900		4900		2000		1000		4700		3000		2000		4900		2000		1000		4700		1800		3000		1000		2000		4900		4900		4900		3100		2500		4900		7200		2500		4900		4900		4900		2900		2000		2500		2000		3000		1500		1000		2500		1000		250		4900		3100		1500		1000		4900		4900		4900		4900		1000		1000		2000		4900		2000		1000		2000		1000		2000		1000		4900		1000		1000		500
elec_code		P		G		P		G		P		G		P		G		P		G		G		P		G		G		P		G		P		G		P		G		P		G		P		G		P		G		P		G		P		G		G		P		G		P		G		P		G		G		P		G		P		G		G		P		G		G		P		G		P		G		G		P		G		G		P		G		G		G		P		G		P		G		G		P		G		P		G		G		P		G		P		G		G		G		G		G