Home

Filing ID: 2744362

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

Table: cvr2_campaign_disclosure

filing_id		2744362		2744362
amend_id		0		0
line_item		1		2
rec_type		CVR2		CVR2
form_type		F460		F460
tran_id		OFC1		NIC1
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		1389135
enty_naml		Russell		Diedre Thu-Ha for Garden Grove City Council 2022
enty_namf		Marissa		None
enty_namt		None		None
enty_nams		None		None
enty_city		Sacramento		Fullerton
enty_st		CA		CA
enty_zip4		95841		92835
enty_phon		916-348-9100		714-745-5281
enty_fax		None		None
enty_email		None		None
tres_naml		None		Barcelona
tres_namf		None		Joana
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		2744362		2744362
amend_id		0		0
line_item		1		2
rec_type		CVR3		CVR3
form_type		F460		F460
tran_id		VER_1.1		VER_2.2
entity_cd		TRE		CAO
sig_date		2022-10-27 00:00:00		2022-10-27 00:00:00
sig_loc		None		None
sig_naml		Denise Lewis		Diedre Thu-Ha Nguyen
sig_namf		None		None
sig_namt		None		None
sig_nams		None		None

Table: cvr_campaign_disclosure

filing_id		2744362
amend_id		0
rec_type		CVR
form_type		F460
filer_id		1444098
entity_cd		CTL
filer_naml		Diedre Thu-Ha Nguyen for Assembly 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		95841
filer_phon		916-348-9100
filer_fax		916-348-9111
file_email		[email protected]
mail_city		None
mail_st		None
mail_zip4		None
tres_naml		Lewis
tres_namf		Denise
tres_namt		None
tres_nams		None
tres_city		Sacramento
tres_st		CA
tres_zip4		95841
tres_phon		916-348-9100
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		Thu-Ha Nguyen
cand_namf		Diedre
cand_namt		None
cand_nams		None
cand_city		Garden Grove
cand_st		CA
cand_zip4		92481
cand_phon		714-864-4574
cand_fax		None
cand_email		[email protected]
bal_name		None
bal_num		None
bal_juris		None
office_cd		ASM
offic_dscr		None
juris_cd		ASM
juris_dscr		None
dist_no		70
off_s_h_cd		S
sup_opp_cd		None
employer		None
occupation		None
selfemp_cb		None
bal_id		None
cand_id		None

Table: debt

filing_id		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362
amend_id		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
rec_type		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
tran_id		PAY414		PAY505		PAY533		PAY534		PAY494		PAY501		PAY527		PAY528		PAY498		PAY515		PAY519		PAY523
entity_cd		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH
payee_naml		Card Service Center		Card Service Center		Corazon Media & Print, Inc		Corazon Media & Print, Inc		Me Viet Nam Productions		MLC Strategies Inc.		Rice Nation Media LLC		Rice Nation Media LLC		Ted Angel, Inc		Vien Dong Daily News		Vien Dong Daily News		Viet Bao Daily News, Inc.
payee_namf		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
payee_nams		None		None		None		None		None		None		None		None		None		None		None		None
payee_city		Lawrenceville		Lawrenceville		Sacramento		Sacramento		Garden Grove		Westminster		Irvine		Irvine		Sacramento		Westminster		Westminster		Irvine
payee_st		GA		GA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
payee_zip4		30043		30043		95864		95864		92843		92683		92614		92614		95818		92683		92683		92606
beg_bal		12607		0		0		0		0		0		1200		0		0		110		0		0
amt_incur		0		4216		23778		16926		2000		12500		0		600		1900		0		2650		600
amt_paid		12607		0		0		0		0		0		0		0		0		0		0		0
end_bal		0		4216		23778		16926		2000		12500		1200		600		1900		110		2650		600
expn_code		None		None		POS		LIT		RAD		TEL		TEL		TEL		LIT		PRT		PRT		PRT
expn_dscr		See Schedule 'G' For Individual Credit Card Payees		See Schedule 'G' For Individual Credit Card Payees		None		None		None		None		None		None		None		None		None		None
cmte_id		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
tres_namf		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
tres_nams		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
tres_st		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
memo_code		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
bakref_tid		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
xref_match		None		None		None		None		None		None		None		None		None		None		None		None

Table: expn

filing_id		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362
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
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
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
form_type		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		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		EDT35		EXP396		EXP423		EXP425		EXP449		EXP476		EXP415		EXP454		EXP452		EXP417		EXP430		EXP431		EXP450		EXP461		EXP462		EXP463		EXP464		EXP486		EXP487		EXP433		EXP432		EXP465		EXP434		EXP416		EXP422		EXP418		EXP419		EXP471		EXP472		EXP429		EXP421		EXP447		EXP448		EXP473		EXP446		EXP474		EXP491		EDT45		PDT38		EDT46		EDT47		EDT44		PDT36		PDT35		PDT37		EDT35		PDT39		EDT32		EDT49		EDT36		EDT39		EDT42		PDT42		EDT50		EDT37		EDT38		EDT43		PDT41		EDT34		PDT34		EDT31		PDT40		EDT33		EDT40		EDT41
entity_cd		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		COM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		IND		IND		OTH
payee_naml		Trung Ta for Garden Grove City Council 2022		ActBlue Technical Services		ActBlue Technical Services		ActBlue Technical Services		ActBlue Technical Services		ActBlue Technical Services		Buchanan Enterprises		Card Service Center		Card Service Center		Corazon Media & Print, Inc		Corazon Media & Print, Inc		Corazon Media & Print, Inc		Corazon Media & Print, Inc		Corazon Media & Print, Inc		Corazon Media & Print, Inc		Corazon Media & Print, Inc		Corazon Media & Print, Inc		Corazon Media & Print, Inc		Corazon Media & Print, Inc		IBC TV		KBC Hai Ngoai News		Little Saigon Radio		Little Saigon TV Network, Inc.		MLC Strategies Inc.		Political Data Inc. (PDI)		RCBS Payroll		RCBS Payroll		RCBS Payroll		RCBS Payroll		River City Business Services		Ted Angel, Inc		Ted Angel, Inc		Ted Angel, Inc		Ted Angel, Inc		Zippost, Inc.		Zippost, Inc.		Zippost, Inc.		AVA TV		Lee's Sandwiches		Ngoc Suong Restaurant		Nguoi Viet News		Nguoi Viet News		Nguoi Viet News		Press Print Inc.		Shell Oil		Trung Ta for Garden Grove City Council 2022		Value Pizza		Political Data Inc. (PDI)		River City Print and Mail		River City Print and Mail		River City Print and Mail		River City Print and Mail		River City Print and Mail		United States Postal Service		United States Postal Service		United States Postal Service		United States Postal Service		United States Postal Service		KDOC-TV		LCT 106.3		Vietmedia TV		Vietmedia TV		Van		Van		LCT 106.3
payee_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Hong Alyce		Hong Alyce		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
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
payee_city		Garden Grove		Somerville		Somerville		Somerville		Somerville		Somerville		Sacramento		Lawrenceville		Lawrenceville		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Westminster		Westminster		Westminster		Costa Mesa		Westminster		Long Beach		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Westminster		Westminster		Westminster		Westminster		Garden Grove		Westminster		Westminster		Westminster		Westminster		Banning		Stanton		Garden Grove		Garden Grove		Long Beach		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Rancho Cordova		Rancho Cordova		Rancho Cordova		Rancho Cordova		Rancho Cordova		Santa Ana		Westminster		Garden Grove		Garden Grove		Stanton		Stanton		Westminster
payee_st		CA		MA		MA		MA		MA		MA		CA		GA		GA		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		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
payee_zip4		92843		02144		02144		02144		02144		02144		95814		30043		30043		95864		95864		95864		95864		95864		95864		95864		95864		95864		95864		92683		92683		92683		92626		92683		90806		95841		95841		95841		95841		95841		95818		95818		95818		95818		92683		92683		92683		92683		92843		92683		92683		92683		92683		92220		90680		92843		92840		90806		95834		95834		95834		95834		95834		95670		95670		95670		95670		95670		92705		92683		92844		92844		90680		90680		92683
expn_date		2022-10-04 00:00:00		2022-09-25 00:00:00		2022-09-30 00:00:00		2022-10-02 00:00:00		2022-10-09 00:00:00		2022-10-16 00:00:00		2022-09-30 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-09-30 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-11 00:00:00		2022-10-12 00:00:00		2022-10-12 00:00:00		2022-10-12 00:00:00		2022-10-12 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-12 00:00:00		2022-10-05 00:00:00		2022-09-30 00:00:00		2022-10-03 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-05 00:00:00		2022-10-03 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-14 00:00:00		2022-10-10 00:00:00		2022-10-17 00:00:00		2022-10-21 00:00:00		2022-10-07 00:00:00		2022-10-09 00:00:00		2022-10-07 00:00:00		2022-10-03 00:00:00		2022-10-07 00:00:00		2022-10-17 00:00:00		2022-10-14 00:00:00		2022-10-22 00:00:00		2022-10-04 00:00:00		2022-10-22 00:00:00		2022-09-30 00:00:00		2022-10-05 00:00:00		2022-10-12 00:00:00		2022-10-12 00:00:00		2022-10-19 00:00:00		2022-10-22 00:00:00		2022-10-05 00:00:00		2022-10-12 00:00:00		2022-10-12 00:00:00		2022-10-19 00:00:00		2022-10-22 00:00:00		2022-10-05 00:00:00		2022-10-22 00:00:00		2022-09-30 00:00:00		2022-10-22 00:00:00		2022-09-30 00:00:00		2022-10-14 00:00:00		2022-10-17 00:00:00
amount		1000		384		56		26		53		69		9240		2701		12607		2154		24424		19709		25000		10537		11799		11799		10592		4918		5625		3000		250		5200		6900		4000		14		76		2213		76		2153		2006		3890		1900		1990		3950		16500		4000		16500		300		111		127		640		320		2880		776		147		1000		124		2154		16709		8537		8592		4625		12926		24424		11799		11799		4918		23778		6900		2000		4000		12500		1691		1691		4000
cum_ytd		1000		2069		2069		2069		2069		2069		16853		52356		52356		174562		174562		174562		174562		174562		174562		174562		174562		174562		174562		3000		250		8000		6900		19000		8766		11925		11925		11925		11925		9982		17550		17550		17550		17550		37000		37000		37000		300		111		127		4010		4010		4010		776		282		1000		124		8766		57520		57520		57520		57520		57520		76718		76718		76718		76718		76718		6900		6000		16500		16500		8552		8552		6000
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
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
expn_code		MON		OFC		OFC		OFC		OFC		OFC		CNS		None		None		LIT		POS		LIT		CNS		LIT		POS		POS		LIT		POS		LIT		TEL		PRT		RAD		TEL		TEL		WEB		PRO		SAL		PRO		SAL		PRO		LIT		LIT		LIT		LIT		PRT		RAD		PRT		TEL		MTG		MTG		PRT		PRT		PRT		LIT		TRC		CTB		MTG		LIT		LIT		LIT		LIT		LIT		LIT		POS		POS		POS		POS		POS		TEL		RAD		TEL		TEL		SAL		SAL		RAD
expn_dscr		None		None		None		None		None		None		None		See Schedule 'G' For Individual Credit Card Payees		See Schedule 'G' For Individual Credit Card Payees		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Appetizers Only		10/7/22, Campaign Meeting, 2, Candidate		None		None		None		None		Fuel for Campaign Event Travel, Various Dates		None		10/22/22, Volunteer Lunch, 30		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		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		Corazon Media & Print, Inc		Corazon Media & Print, Inc		Corazon Media & Print, Inc		Corazon Media & Print, Inc		Corazon Media & Print, Inc		Corazon Media & Print, Inc		Corazon Media & Print, Inc		Corazon Media & Print, Inc		Corazon Media & Print, Inc		Corazon Media & Print, Inc		Corazon Media & Print, Inc		Little Saigon TV Network, Inc.		Me Viet Nam Productions		MLC Strategies Inc.		MLC Strategies Inc.		RCBS Payroll		RCBS Payroll		Zippost, 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
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
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
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1454199		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
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
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
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
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
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
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
cand_naml		Trung Ta		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
office_cd		CCM		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
juris_cd		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
juris_dscr		City of Garden Grove		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
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
sup_opp_cd		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
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
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
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
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		E		F		E		E		E		F		F		F		E		F		E		E		E		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
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

Table: filer_filings

filer_id		1444098
filing_id		2744362
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		2744362
filing_type		22001

Table: hdr

filing_id		2744362
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: loan

filing_id		2744362
amend_id		0
line_item		1
rec_type		LOAN
form_type		B1
tran_id		PAY113
loan_type		None
entity_cd		IND
lndr_naml		Nguyen
lndr_namf		Diedre Thu-Ha
lndr_namt		None
lndr_nams		None
loan_city		Garden Grove
loan_st		CA
loan_zip4		92841
loan_date1		2022-04-20 00:00:00
loan_date2		2024-12-31 00:00:00
loan_amt1		0
loan_amt2		20000
loan_amt3		20000
loan_amt4		20000
loan_rate		0.00
loan_emp		Candidate
loan_occ		Candidate
loan_self		None
cmte_id		None
tres_naml		None
tres_namf		None
tres_namt		None
tres_nams		None
tres_city		None
tres_st		None
tres_zip4		None
intr_naml		None
intr_namf		None
intr_namt		None
intr_nams		None
intr_city		None
intr_st		None
intr_zip4		None
memo_code		None
memo_refno		PAY113
bakref_tid		None
xref_schnm		None
xref_match		None
loan_amt5		0
loan_amt6		0
loan_amt7		0
loan_amt8		20000

Table: rcpt

filing_id		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362
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
line_item		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		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
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
form_type		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		C		C		C		C		C		C		C		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
tran_id		INC440		INC478		IDT273		INC445		INC490		INC470		INC441		INC428		INC492		IDT281		INC493		INC510		INC489		INC481		INC504		INC439		INC420		INC508		IDT265		IDT303		NON468		NON435		NON436		NON442		NON443		NON444		NON455		NON467		NON457		INC477		INC479		INC460		INC412		INC488		INC459		IDT266		INC458		IDT267		IDT250		IDT262		INC509		IDT276		INC497		INC469		INC475		INC507		INC426		IDT279		INC482		INC483		INC484		IDT296		IDT302		INC506		INC438		IDT300		IDT274		IDT263		IDT287		IDT282		IDT291		IDT251
entity_cd		COM		COM		IND		COM		COM		COM		SCC		COM		COM		IND		SCC		OTH		COM		SCC		COM		SCC		SCC		COM		OTH		IND		PTY		PTY		PTY		PTY		PTY		PTY		PTY		PTY		OTH		OTH		COM		COM		SCC		COM		COM		IND		COM		IND		IND		IND		OTH		IND		COM		COM		OTH		IND		COM		IND		COM		COM		COM		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND
ctrib_naml		Orange County Employees Association PAC		Orange County Professional Firefighters Association Local 3631 PAC		Pacheco		Phil Ting for Assembly 2022		Planned Parenthood of Orange and San Bernardino Counties' Community Action Fund PAC		PrivacyPAC: NARAL Pro-Choice California		SEIU Local 2015 State PAC		Sharon Quirk-Silva for Assembly 2022		Sharon Quirk-Silva for Assembly 2022		Simpson		Southern California District Council of Laborers PAC		Sunrise Village Properties, LLC(Thang Tran Nguyen)		The California Women's List		UA Journeyman & Apprentices Local 250 PAC		UFCW 324, PAC Fund		United Domestic Workers of America Action Fund		United Food and Commercial Workers (UFCW) Western States Council Candidates PAC		United Union Roofers, Waterproofers and Allied Workers		Vihn Doan Law Office		Weil		California Democratic Party		California Democratic Party		California Democratic Party		California Democratic Party		California Democratic Party		California Democratic Party		California Democratic Party		California Democratic Party		Saigon Broadcasting Television Network, Inc. (SBTN, Inc.)		Barona Band of Mission Indians		California Grocers Association PAC		California Sierra Club PAC		California Teachers Association/ Association for Better Citizenship		California Teamsters Public Affairs Council Public Affairs Fund		Chris Ward for Assembly 2022		Colodny		Dave Min for State Senate 2024		Do		Duong		Eng		First Golden Village Orange Hill, LLC(Thang Tran Nguyen)		Frolichman		Gail Pellerin for Assembly 2022		Garden Grove Police Association PAC		H4L Holding LLC(Linh Nqoc Nguyen)		Ha		Josh Newman for Senate 2024		Ko		Mike Fong for Assembly 2022 Special		National Women's Political Caucus of California PAC		National Women's Political Caucus of California PAC		Neuenschwander		Neuenschwander		Ngo		Ngo		Nguyen		Nguyen		Nguyen		Nguyen		Nguyen		Nguyen		Nguyen
ctrib_namf		None		None		Stephanie		None		None		None		None		None		None		David		None		None		None		None		None		None		None		None		None		James		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Richard		None		Khoa		Hien		Michael		None		Libby		None		None		None		Mindy C.		None		Alissa		None		None		None		Jan		Jan		Duc		Kevin		Bele		Dan		Duke		Frederick		Long		Nhan		Phuong
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
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
ctrib_city		Sacramento		Tustin		Fountain Valley		Sacramento		Sacramento		Sacramento		Los Angeles		Sacramento		Sacramento		Buena Park		Long Beach		Westminster		Oakland		Gardena		Buena Park		Sacramento		Buena Park		Washington		Garden Grove		Fountain Valley		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Garden Grove		Lakeside		Sacramento		Los Angeles		Burlingame		Sacramento		Encinitas		Huntington Beach		Sacramento		Orange		Tustin		Los Angeles		Westminster		Fountain Valley		Sacramento		Garden Grove		Garden Grove		Santa Ana		Fullerton		Sacramento		Encino		Beverly Hills		Beverly Hills		Seal Beach		Seal Beach		Garden Grove		Newport Beach		Fountain Valley		Fountain Valley		Santa Ana		Westminster		Fremont		San Jose		Fremont
ctrib_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		DC		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		CA		CA
ctrib_zip4		95814		92780		92708		95841		95814		95814		90057		95841		95841		90621		90802		92683		94607		90248		90622		95814		90620		20036		92843		92708		95814		95814		95814		95814		95814		95814		95814		95814		92843		92040		95814		90010		94010		95814		92024		92647		95841		92867		92782		90017		92683		92708		95841		92840		92840		92706		92835		95834		91436		90212		90212		90740		90740		92841		92660		92708		92708		92705		92683		94539		95131		94539
ctrib_emp		None		None		n/a		None		None		None		None		None		None		Simpson Auto Group		None		None		None		None		None		None		None		None		None		Weil Aquatronics, Inc.		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Advanced Property Services		None		Magic Group, Inc.		Duong Hien		State of California		None		n/a		None		None		None		n/a		None		Health Net		None		None		None		n/a		n/a		n/a		Kevcomp Company		State Farm		Essential Design Innovator		County of Los Angeles		Saigon Central Post		n/a		My Best Homecare		n/a
ctrib_occ		None		None		Not Employed		None		None		None		None		None		None		President		None		None		None		None		None		None		None		None		None		Sales Executive		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Property Accountant		None		Owner		Dentist		Board Member		None		Not Employed		None		None		None		Retired		None		Director of Giving		None		None		None		Not Employed		Not Employed		Retired		CEO		Agent		Contractor		Professional		Remittance		Not Employed		CEO		Not Employed
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
tran_type		None		None		I		None		None		None		None		None		None		I		None		None		None		None		None		None		None		None		I		I		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		I		None		I		I		I		None		I		None		None		None		None		None		I		None		None		None		I		I		None		None		I		I		I		I		I		I		I
rcpt_date		2022-10-06 00:00:00		2022-10-17 00:00:00		2022-10-02 00:00:00		2022-10-07 00:00:00		2022-10-20 00:00:00		2022-10-11 00:00:00		2022-10-06 00:00:00		2022-10-04 00:00:00		2022-10-21 00:00:00		2022-10-05 00:00:00		2022-10-20 00:00:00		2022-10-22 00:00:00		2022-10-20 00:00:00		2022-10-18 00:00:00		2022-10-21 00:00:00		2022-10-05 00:00:00		2022-09-30 00:00:00		2022-10-22 00:00:00		2022-09-26 00:00:00		2022-10-21 00:00:00		2022-09-25 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-07 00:00:00		2022-10-10 00:00:00		2022-10-09 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-11 00:00:00		2022-09-26 00:00:00		2022-10-20 00:00:00		2022-10-11 00:00:00		2022-09-26 00:00:00		2022-10-11 00:00:00		2022-09-28 00:00:00		2022-09-25 00:00:00		2022-09-26 00:00:00		2022-10-22 00:00:00		2022-10-02 00:00:00		2022-10-21 00:00:00		2022-10-11 00:00:00		2022-10-16 00:00:00		2022-10-16 00:00:00		2022-10-03 00:00:00		2022-10-05 00:00:00		2022-10-18 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-16 00:00:00		2022-10-22 00:00:00		2022-10-16 00:00:00		2022-10-04 00:00:00		2022-10-14 00:00:00		2022-10-01 00:00:00		2022-09-26 00:00:00		2022-10-10 00:00:00		2022-10-09 00:00:00		2022-10-11 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
amount		1000		2000		100		4900		2450		1000		4900		2000		2900		1000		4900		500		1000		2000		2500		2000		2500		500		500		100		3		688		29000		2407		6605		557		27327		6424		4500		2000		1200		1000		9700		2000		2400		25		3900		500		500		150		500		25		1000		4900		1000		100		1000		167		3900		250		250		25		100		500		1000		100		500		100		500		100		1000		100
cum_ytd		1500		4500		135		4900		4900		3000		14600		9800		9800		3500		4900		5000		3000		7000		5000		4000		2500		900		1000		200		94155		94155		94155		94155		94155		94155		94155		94155		4500		5000		1200		1000		14550		2000		4900		125		5900		500		1000		150		5000		630		1000		9800		3000		100		1000		167		5900		500		500		225		225		500		1000		100		900		100		500		100		1000		100
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
ctrib_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		In-Kind, Phone Banking		In-Kind, Data		In-Kind, Polling		In-Kind, Graphics		In-Kind, Printing		In-Kind, Data		In-Kind, Mail Production and Postage Differential		In-Kind, Printing		In-Kind, Airtime Advertising		None		None		None		None		None		None		None		None		None		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		801447		950925		None		1437844		1282464		1286599		1374983		1434995		1434995		None		1358150		None		1379150		743959		1306048		1302384		910874		1399166		None		None		741666		741666		741666		741666		741666		741666		741666		741666		None		None		760914		1399739		741941		742500		1434927		None		1435246		None		None		None		None		None		1445957		960881		None		None		1435010		None		1443029		746373		746373		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
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
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
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
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
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
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
intr_naml		None		None		Actblue		None		None		None		None		None		None		Actblue		None		None		None		None		None		None		None		None		Actblue		Actblue		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Actblue		None		Actblue		Actblue		Actblue		None		Actblue		None		None		None		None		None		Actblue		None		None		None		Actblue		Actblue		None		None		Actblue		Actblue		Actblue		Actblue		Actblue		Actblue		Actblue
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
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
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
intr_city		None		None		Somerville		None		None		None		None		None		None		Somerville		None		None		None		None		None		None		None		None		Somerville		Somerville		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Somerville		None		Somerville		Somerville		Somerville		None		Somerville		None		None		None		None		None		Somerville		None		None		None		Somerville		Somerville		None		None		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville
intr_st		None		None		MA		None		None		None		None		None		None		MA		None		None		None		None		None		None		None		None		MA		MA		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		MA		None		MA		MA		MA		None		MA		None		None		None		None		None		MA		None		None		None		MA		MA		None		None		MA		MA		MA		MA		MA		MA		MA
intr_zip4		None		None		02144		None		None		None		None		None		None		02144		None		None		None		None		None		None		None		None		02144		02144		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		02144		None		02144		02144		02144		None		02144		None		None		None		None		None		02144		None		None		None		02144		02144		None		None		02144		02144		02144		02144		02144		02144		02144
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
memo_refno		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		NON468		NON435		NON436		NON442		NON443		NON444		NON455		NON467		NON457		None		None		None		None		None		None		None		None		None		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
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
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
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
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

Table: smry

filing_id		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362
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		20		21		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		79588		0		79588		77512		157100		226333		0		226333		52562		77512		356408		249898		79588		0		226333		103152		0		0		86480		276747		70220		79242		346		79588		0		0		0		77512		0		77512		1000		0		1000		226310		23		0		226333		65170		12607		52562		0		0		0		0		0		0		0
amount_b		482613		20000		502613		98655		601268		399460		0		399460		66480		98655		564595		None		None		None		None		None		None		None		None		324522		504988		None		None		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		None		None		None		None		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		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362		2744362
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
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
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		A		A		A		A		B1		C		C		C		C		C		C		C		C		C		D
ptran_id		INC477		INC477		INC479		INC460		INC412		INC412		INC488		INC459		IDT266		IDT266		INC458		INC458		IDT267		IDT250		IDT250		IDT262		INC509		INC509		IDT276		IDT276		INC497		INC469		INC469		INC475		INC475		INC507		INC426		IDT279		INC482		INC482		INC483		INC484		IDT296		IDT296		IDT302		IDT302		INC506		INC438		IDT300		IDT274		IDT274		IDT263		IDT287		IDT282		IDT291		IDT251		INC440		INC440		INC478		IDT273		IDT273		INC445		INC490		INC470		INC470		INC441		INC441		INC428		INC428		INC492		INC492		IDT281		IDT281		INC493		INC510		INC510		INC489		INC489		INC481		INC481		INC504		INC504		INC439		INC439		INC420		INC508		INC508		IDT265		IDT265		IDT303		PAY113		NON468		NON435		NON436		NON442		NON443		NON444		NON455		NON467		NON457		EDT35
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
elec_amount		3000		2000		1200		1000		4850		9700		2000		4900		25		100		1000		4900		500		500		500		150		4000		1000		125		505		1000		4900		4900		2000		1000		100		1000		167		1000		4900		500		500		100		125		100		125		500		1000		100		300		600		100		500		100		1000		100		500		1000		4500		35		100		4900		4900		2000		1000		9700		4900		4900		4900		4900		4900		2500		1000		4900		4000		1000		1500		1500		5000		2000		2500		2500		2000		2000		2500		400		500		500		500		200		20000		94155		94155		94155		94155		94155		94155		94155		94155		4500		1000
elec_code		P		G		G		G		P		G		G		G		P		G		P		G		G		P		G		G		P		G		P		G		G		P		G		P		G		G		G		G		P		G		G		G		P		G		P		G		G		G		G		P		G		G		G		G		G		G		P		G		G		P		G		G		G		P		G		P		G		P		G		P		G		P		G		G		P		G		P		G		P		G		P		G		P		G		G		P		G		P		G		G		P		G		G		G		G		G		G		G		G		G		G