Home

Filing ID: 2743073

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

Table: cvr3_verification_info

filing_id		2743073		2743073
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-24 00:00:00		2022-10-24 00:00:00
sig_loc		None		None
sig_naml		Lysa M Ray		Tri Ta
sig_namf		None		None
sig_namt		None		None
sig_nams		None		None

Table: cvr_campaign_disclosure

filing_id		2743073
amend_id		0
rec_type		CVR
form_type		F460
filer_id		1443284
entity_cd		CTL
filer_naml		Tri Ta For Assembly 2022
filer_namf		None
filer_namt		None
filer_nams		None
report_num		000
rpt_date		2022-10-24 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-06-07 00:00:00
filer_city		Westminster
filer_st		CA
filer_zip4		92683
filer_phon		714-540-2295
filer_fax		None
file_email		[email protected]
mail_city		Santa Ana
mail_st		CA
mail_zip4		92704
tres_naml		Ray
tres_namf		Lysa
tres_namt		None
tres_nams		None
tres_city		Santa Ana
tres_st		CA
tres_zip4		92704
tres_phon		714-540-2295
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		Ta
cand_namf		Tri
cand_namt		None
cand_nams		None
cand_city		Westminster
cand_st		CA
cand_zip4		92683
cand_phon		714-366-0376
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		2743073		2743073		2743073		2743073		2743073		2743073
amend_id		0		0		0		0		0		0
line_item		1		2		3		4		5		6
rec_type		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT
form_type		F		F		F		F		F		F
tran_id		PAY620		PAY621		PAY14		PAY87		PAY622		PAY618
entity_cd		OTH		OTH		IND		IND		OTH		OTH
payee_naml		Axiom Strategies		Axiom Strategies		Doan		Doan		Public Opinion Strategies		VNCR
payee_namf		None		None		Anh Q.		Anh Q.		None		None
payee_namt		None		None		None		None		None		None
payee_nams		None		None		None		None		None		None
payee_city		Kansas City		Kansas City		Westminster		Westminster		Alexandria		Fountain Valley
payee_st		MO		MO		CA		CA		VA		CA
payee_zip4		64112		64112		92683		92683		22314		92708
beg_bal		25325		20635		5825		2186		14000		2500
amt_incur		0		0		0		0		0		0
amt_paid		25325		20635		0		0		14000		2500
end_bal		0		0		5825		2186		0		0
expn_code		LIT		LIT		CMP		CMP		POL		TEL
expn_dscr		None		None		None		None		None		None
cmte_id		None		None		None		None		None		None
tres_naml		None		None		None		None		None		None
tres_namf		None		None		None		None		None		None
tres_namt		None		None		None		None		None		None
tres_nams		None		None		None		None		None		None
tres_city		None		None		None		None		None		None
tres_st		None		None		None		None		None		None
tres_zip4		None		None		None		None		None		None
memo_code		None		None		None		None		None		None
memo_refno		None		None		None		None		None		None
bakref_tid		None		None		None		None		None		None
xref_schnm		None		None		None		None		None		None
xref_match		None		None		None		None		None		None

Table: expn

filing_id		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073
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
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
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
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		G		G		G		G		G		G		G		G		G		G		G		G
tran_id		EXP736		EXP749		EXP753		EXP754		EXP764		EXP759		EXP777		EXP771		EXP798		EXP799		EXP778		EXP792		EXP793		EXP779		EXP790		EXP791		EXP724		EXP726		EXP770		EXP788		EXP784		EXP783		EXP781		EXP736		EXP787		EXP794		EXP786		EXP769		EXP767		EXP782		EXP748		EXP706		EXP768		EXP789		EXP780		EXP728		EDT47		EDT39		EDT38		EDT46		EDT40		EDT36		EDT45		EDT37		EDT42		EDT44		EDT41		EDT43
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		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
payee_naml		Charlie Nguyen for Mayor 2022		Anedot		Anedot		Anedot		Anedot		Anedot		Anedot		Anedot		Anedot		Anedot		ATC Financial Inc dba BMC and Assoc.		ATC Financial Inc dba BMC and Assoc.		ATC Financial Inc dba BMC and Assoc.		ATC Financial Inc dba BMC and Assoc.		Axiom Strategies		Axiom Strategies		Axiom Strategies		Axiom Strategies		Axiom Strategies		Budget Watchdogs		California Voter Guide		CDS Capital Development Strategies		CDS Capital Development Strategies		Charlie Nguyen for Mayor 2022		COGS		Fedex		IBC TV		International Vietnamese Television		Little Saigon TV Network Inc.		LT & T Print Corp.		Lysa Ray Campaign Services		Public Opinion Strategies		Saigon Entertainment Television		Senior Advocate		US Bank		VNCR		LT & T Print Corp.		LT & T Print Corp.		Mailing Pros Inc,		Mailing Pros Inc,		Mailing Pros Inc,		DTN Tech		Encompass Direct Marketing Group		USPS		COGS		Mailchimp		Southwest Airlines		Tequila Museo Mayahuel
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
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
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
payee_city		Westminster		Baton Rouge		Baton Rouge		Baton Rouge		Baton Rouge		Baton Rouge		Baton Rouge		Baton Rouge		Baton Rouge		Baton Rouge		Fountain Valley		Fountain Valley		Fountain Valley		Fountain Valley		Kansas City		Kansas City		Kansas City		Kansas City		Kansas City		Torrance		Torrance		Sacramento		Sacramento		Westminster		Santa Ana		None		Westminster		Westminster		Westminster		Westminster		Santa Ana		Alexandria		Garden Grove		Torrance		Fargo		Fountain Valley		Westminster		Westminster		Huntington Beach		Huntington Beach		Huntington Beach		Garden Grove		Cheyenne		Santa Ana		Santa Ana		Atlanta		Dallas		Sacramento
payee_st		CA		LA		LA		LA		LA		LA		LA		LA		LA		LA		CA		CA		CA		CA		MO		MO		MO		MO		MO		CA		CA		CA		CA		CA		CA		None		CA		CA		CA		CA		CA		VA		CA		CA		ND		CA		CA		CA		CA		CA		CA		CA		WY		CA		CA		GA		TX		CA
payee_zip4		92683		70808		70808		70808		70808		70808		70808		70808		70808		70808		92708		92708		92708		92708		64112		64112		64112		64112		64112		90505		90505		95814		95814		92683		92707		None		92683		92683		92684		92683		92704		22314		92843		90505		58125		92708		92683		92683		92649		92649		92649		92843		82001		92705		92707		30308		75235		95814
expn_date		2022-10-14 00:00:00		2022-09-26 00:00:00		2022-09-29 00:00:00		2022-10-04 00:00:00		2022-10-05 00:00:00		2022-10-08 00:00:00		2022-10-13 00:00:00		2022-10-18 00:00:00		2022-10-19 00:00:00		2022-10-22 00:00:00		2022-10-04 00:00:00		2022-10-12 00:00:00		2022-10-17 00:00:00		2022-10-21 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-10-19 00:00:00		2022-10-14 00:00:00		2022-09-30 00:00:00		2022-10-11 00:00:00		2022-09-30 00:00:00		2022-10-20 00:00:00		2022-10-19 00:00:00		2022-09-30 00:00:00		2022-10-06 00:00:00		2022-09-26 00:00:00		2022-10-19 00:00:00		2022-09-30 00:00:00		2022-10-19 00:00:00		2022-09-30 00:00:00		2022-10-12 00:00:00		2022-10-21 00:00:00		2022-10-04 00:00:00		2022-10-12 00:00:00		2022-10-21 00:00:00		2022-10-20 00:00:00		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-10-09 00:00:00		2022-10-09 00:00:00		2022-10-09 00:00:00		2022-10-09 00:00:00
amount		1000		4		2		10		17		1		10		602		246		12		8596		13306		14978		14519		5269		2402		25325		20635		25324		500		500		1703		4723		1000		2813		67		1000		900		1000		7993		750		14000		500		500		3383		2500		4141		5148		8850		8914		9246		8026		1400		11642		1974		339		268		741
cum_ytd		1000		1762		1762		1762		1762		1762		1762		1762		1762		1762		202825		202825		202825		202825		264557		264557		264557		264557		264557		500		500		7057		7057		1000		23901		157		2000		900		1000		17283		8500		14000		500		500		15403		3600		17283		17283		27010		27010		27010		55212		9788		92253		23901		339		1732		741
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
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
expn_code		MON		None		None		None		None		None		None		None		None		None		CMP		LIT		CMP		LIT		CNS		LIT		LIT		LIT		LIT		LIT		LIT		FND		FND		CTB		CMP		POS		TEL		TEL		TEL		LIT		PRO		POL		TEL		LIT		CMP		TEL		LIT		LIT		POS		POS		POS		LIT		LIT		POS		CMP		CMP		TRC		FND
expn_dscr		None		cc processing		cc processing		cc processing		cc processing		cc processing		cc processing		cc processing		cc processing		cc processing		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		ATC Financial Inc dba BMC and Assoc.		ATC Financial Inc dba BMC and Assoc.		ATC Financial Inc dba BMC and Assoc.		ATC Financial Inc dba BMC and Assoc.		ATC Financial Inc dba BMC and Assoc.		Axiom Strategies		Axiom Strategies		Axiom Strategies		US Bank		US Bank		US Bank		US Bank
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
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
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
cmte_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1345115		595004		None		None		1449188		None		None		None		None		None		None		None		None		None		1439476		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
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
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
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
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
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
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
cand_naml		Charlie Nguyen		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
office_cd		MAY		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
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
juris_dscr		Westminster		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
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
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
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
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
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
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
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		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
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

Table: filer_filings

filer_id		1443284
filing_id		2743073
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-24 00:00:00
filing_type		22001

Table: filings

filing_id		2743073
filing_type		22001

Table: hdr

filing_id		2743073
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		2743073		2743073
amend_id		0		0
line_item		1		2
rec_type		LOAN		LOAN
form_type		B1		B1
tran_id		PAY409		PAY411
loan_type		None		None
entity_cd		IND		IND
lndr_naml		Ta		Ta
lndr_namf		Tri		Tri
lndr_namt		None		None
lndr_nams		None		None
loan_city		Westminster		Westminster
loan_st		CA		CA
loan_zip4		92683		92683
loan_date1		2022-05-29 00:00:00		2022-06-07 00:00:00
loan_date2		None		None
loan_amt1		0		0
loan_amt2		15000		10000
loan_amt3		26234		26234
loan_amt4		15000		10000
loan_rate		0.00		0.00
loan_emp		City of Wesminster		City of Wesminster
loan_occ		Councilman		Councilman
loan_self		None		None
cmte_id		None		None
tres_naml		None		None
tres_namf		None		None
tres_namt		None		None
tres_nams		None		None
tres_city		None		None
tres_st		None		None
tres_zip4		None		None
intr_naml		None		None
intr_namf		None		None
intr_namt		None		None
intr_nams		None		None
intr_city		None		None
intr_st		None		None
intr_zip4		None		None
memo_code		None		None
memo_refno		None		None
bakref_tid		None		None
xref_schnm		None		None
xref_match		None		None
loan_amt5		0		0
loan_amt6		0		0
loan_amt7		0		0
loan_amt8		15000		10000

Table: rcpt

filing_id		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073
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		C
tran_id		INC776		INC722		INC711		INC745		INC721		INC717		INC714		INC735		INC734		INC744		INC716		INC718		INC720		INC730		INC713		INC712		INC762		INC761		INC731		INC732		INC747		INC743		INC738		INC746		INC750		INC755		INC733		INC803		INC758		INC742		INC739		INC723		INC757		INC763		INC741		INC740		INC737		INC800		INC804		NON715
entity_cd		IND		OTH		COM		COM		COM		COM		COM		COM		COM		COM		OTH		COM		COM		COM		COM		COM		IND		IND		OTH		COM		IND		IND		IND		COM		IND		IND		OTH		OTH		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		OTH		PTY
ctrib_naml		Ackman		Agua Caliente Band of Cahuilla Indians		American Prperty Casualty Insurance Assoc		Anesthesia Service Medical Group Advocacy Fund		Building Owners & Managers Assoc OC PAC		CA Mortgage Assoc PAC		CA Nations Indian Gaming Assoc		California Credit Union League PAC		California Financial Services Assn		Devon Mathis for Assembly 2022		Edison		GFC Courage Committee - Future Generations Chapter		GFC Courage Committee - San Francisco Chapter		GFC Courage Committee - Southern CA Chapter		GFC Courage Committee -Golden Gate Chapter		GFC Courage Committee-Santa Barbara Chapter		Hong		Hua		Huntington Beach Auto Dealers		Joe Patterson for Assembly 2022		Koch		Lindholm		McNulty		New Majority PAC		Ngo		Nguyen		Pechanga Band of Indians		PG&E Corp		Phan		Ramirez		Tinsley		Tran		Truong		Vo		Wabiszewski		Weissenbach		Whitaker		Willson		Yocha Dehe Wintun Nation		Ca Republican Party
ctrib_namf		Julie		None		None		None		BOMA OC PAC		None		None		None		None		None		None		None		None		None		None		None		Duy		Than		None		None		Judith		Wayne		MaryGail		None		Kimthoa		Mai		None		None		Thaibinh		Manuel		Richard		Thai Viet		Xuannga		Tina		Lacey		John		Fred		Gretvhen		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		Corona		Palm Springs		Chicago		San Diego		Tustin		Sacramento		Los Angeles		Ontario		None		Hilmar		Rosemead		San Rafael		San Rafael		San Rafael		San Rafael		San Rafael		Huntington Beach		Huntington Beach		Huntington Beach		Wilton		Palo Alto		Laguna Niguel		Moreno Valley		Sacramento		Concord		Northridge		Riverside		San Francisco		Fountain Valley		San Juan Capistrano		Los Gatos		Spring		Garden Grove		Westminster		Aliso Viejo		Los Angeles		Orange		Los Angeles		Brooks		Sacramento
ctrib_st		CA		CA		IL		CA		CA		CA		CA		CA		None		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		TX		CA		CA		None		CA		CA		CA		CA		CA
ctrib_zip4		92882		92264		60631		92119		92780		95814		90071		91761		85814		95324		91770		94901		94901		94901		94901		94901		92647		92648		92648		95693		94303		92677		92555		95814		94520		91324		92503		94105		92708		92675		95030		77379		92840		92683		92656		90049		92866		90024		95606		95814
ctrib_emp		Self		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Edwards Villa Inc		None		None		None		None		M Raahauge Shoot Ent		None		Suns Recycling Inc.		None		None		None		None		RHI CPA's		None		Nails of America		None		None		DOMA		None		Cummins &White, LLP		None		None		None
ctrib_occ		Consultant		None		None		870598		None		None		None		None		None		None		None		None		None		None		None		None		None		Owner		None		None		Retired		Retired		Office		None		Office Manager		Retired		None		None		Retired		CPA		Retired		Owner		Retired		Retired		Escrow		Retired		Owner/Executive/Attorney		Retired		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		None		None		None		None		None		None		None		None		None		None
rcpt_date		2022-10-13 00:00:00		2022-10-06 00:00:00		2022-09-30 00:00:00		2022-10-19 00:00:00		2022-10-06 00:00:00		2022-10-04 00:00:00		2022-09-30 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-19 00:00:00		2022-10-04 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-11 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-10-05 00:00:00		2022-10-06 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-20 00:00:00		2022-10-19 00:00:00		2022-10-18 00:00:00		2022-10-19 00:00:00		2022-09-26 00:00:00		2022-10-04 00:00:00		2022-10-12 00:00:00		2022-10-22 00:00:00		2022-10-06 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-05 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-22 00:00:00		2022-10-22 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		250		1500		1500		1000		1000		1000		2500		1500		1500		4900		2000		4900		4900		4900		4900		4900		50		250		2000		1000		4900		1000		1000		4900		100		200		4900		4900		100		1000		4900		1000		100		100		1000		3000		3900		250		3000		14000
cum_ytd		250		1500		1500		1000		1000		1000		2500		1500		1500		4900		2000		4900		4900		4900		4900		4900		200		1250		2000		1000		4900		1000		1000		4900		100		500		4900		4900		100		1000		4900		1000		100		100		1000		3000		4900		250		3000		14000
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		POL
cmte_id		None		None		830078		None		1347850		990462		1266480		760225		881022		1435405		None		1416436		1416440		1435445		1425929		1435804		None		None		None		1443381		None		None		None		992074		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
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		None		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		None		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		None		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		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073
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
line_item		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		1		2		3		1		2		3		1		2		3		1		2		3		1		2		3		4		1		2		3		1		2		3		1		2		3		4
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
form_type		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		A		A		A		B1		B1		B1		C		C		C		D		D		D		E		E		E		E		F		F		F		H		H		H		I		I		I		I
amount_a		87272		0		87272		14000		101272		175091		0		175091		-62460		14000		126631		120872		87272		0		175091		33054		0		0		33011		86700		572		87272		0		0		0		14000		0		14000		1000		0		1000		175091		0		0		175091		0		62460		-62460		0		0		0		0		0		0		0
amount_b		488539		25000		513539		27164		540703		581935		0		581935		8011		27164		617110		None		None		None		None		None		None		None		None		None		None		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
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

Table: splt

filing_id		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073		2743073
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		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
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		B1		B1		B1		B1		C		D
ptran_id		INC776		INC722		INC711		INC745		INC721		INC717		INC714		INC735		INC734		INC744		INC716		INC718		INC720		INC730		INC713		INC712		INC762		INC762		INC761		INC731		INC732		INC747		INC743		INC738		INC746		INC750		INC755		INC755		INC733		INC803		INC758		INC742		INC739		INC723		INC757		INC763		INC741		INC740		INC737		INC800		INC804		PAY409		PAY409		PAY411		PAY411		NON715		EXP736
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
elec_amount		250		1500		1500		1000		1000		1000		2500		1500		1500		4900		2000		4900		4900		4900		4900		4900		50		150		1250		2000		1000		4900		1000		1000		4900		100		300		200		4900		4900		100		1000		4900		1000		100		100		1000		3000		4900		250		3000		1234		25000		1234		25000		14000		1000
elec_code		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		P		G		G		G		G		G		G		G		G		G		P		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		P		G		P		G		G