Home

Filing ID: 2725972

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

Table: cvr3_verification_info

filing_id		2725972		2725972		2725972		2725972
amend_id		1		1		0		0
line_item		1		2		1		2
rec_type		CVR3		CVR3		CVR3		CVR3
form_type		F460		F460		F460		F460
tran_id		VER_1.1		VER_2.2		VER_1.1		VER_2.2
entity_cd		TRE		CAO		TRE		CAO
sig_date		2022-10-24 00:00:00		2022-10-25 00:00:00		2022-09-26 00:00:00		2022-09-26 00:00:00
sig_loc		None		None		None		None
sig_naml		Jen Slater		Diane Dixon		Jen Slater		Diane Dixon
sig_namf		None		None		None		None
sig_namt		None		None		None		None
sig_nams		None		None		None		None

Table: cvr_campaign_disclosure

filing_id		2725972		2725972
amend_id		0		1
rec_type		CVR		CVR
form_type		F460		F460
filer_id		1443172		1443172
entity_cd		CTL		CTL
filer_naml		Diane Dixon for Assembly 2022		Diane Dixon for Assembly 2022
filer_namf		None		None
filer_namt		None		None
filer_nams		None		None
report_num		000		001
rpt_date		2022-09-28 00:00:00		2022-10-26 00:00:00
stmt_type		PE		PE
late_rptno		None		None
from_date		2022-07-01 00:00:00		2022-07-01 00:00:00
thru_date		2022-09-24 00:00:00		2022-09-24 00:00:00
elect_date		2022-11-08 00:00:00		2022-11-08 00:00:00
filer_city		Irvine		Irvine
filer_st		CA		CA
filer_zip4		92618		92618
filer_phon		949-858-7448		949-858-7448
filer_fax		None		None
file_email		info@campaign-compliance.com		info@campaign-compliance.com
mail_city		Newport Beach		Newport Beach
mail_st		CA		CA
mail_zip4		92663		92663
tres_naml		Slater		Slater
tres_namf		Jen		Jen
tres_namt		None		None
tres_nams		None		None
tres_city		Irvine		Irvine
tres_st		CA		CA
tres_zip4		92618		92618
tres_phon		949-858-7448		949-858-7448
tres_fax		None		None
tres_email		None		None
cmtte_type		C		C
control_yn		Y		Y
sponsor_yn		N		N
primfrm_yn		N		N
brdbase_yn		N		N
amendexp_1		None		Amend for Additions to Sch F & Sch G
amendexp_2		None		None
amendexp_3		None		None
rpt_att_cb		None		None
cmtte_id		None		None
reportname		None		None
rptfromdt		None		None
rptthrudt		None		None
emplbus_cb		None		None
bus_name		None		None
bus_city		None		None
bus_st		None		None
bus_zip4		None		None
bus_inter		None		None
busact_cb		None		None
busactvity		None		None
assoc_cb		None		None
assoc_int		None		None
other_cb		None		None
other_int		None		None
cand_naml		Dixon		Dixon
cand_namf		Diane		Diane
cand_namt		None		None
cand_nams		None		None
cand_city		Newport Beach		Newport Beach
cand_st		CA		CA
cand_zip4		92663		92663
cand_phon		949-287-9211		949-287-9211
cand_fax		None		None
cand_email		dianebdixon@gmail.com		dianebdixon@gmail.com
bal_name		None		None
bal_num		None		None
bal_juris		None		None
office_cd		ASM		ASM
offic_dscr		None		None
juris_cd		ASM		ASM
juris_dscr		None		None
dist_no		72		72
off_s_h_cd		S		S
sup_opp_cd		None		None
employer		None		None
occupation		None		None
selfemp_cb		None		None
bal_id		None		None
cand_id		None		None

Table: debt

filing_id		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972
amend_id		0		0		0		0		0		0		0		0		1		1		1		1		1		1		1		1		1		1
line_item		1		2		3		4		5		6		7		8		1		2		3		4		5		6		7		8		9		10
rec_type		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT
form_type		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F
tran_id		PAY797		PAY706		PAY682		PAY685		PAY695		PAY796		PAY871		PAY867		PAY797		PAY706		PAY682		PAY685		PAY695		PAY796		PAY1047		PAY871		PAY867		PAY1024
entity_cd		IND		OTH		OTH		OTH		OTH		IND		OTH		OTH		IND		OTH		OTH		OTH		OTH		IND		OTH		OTH		OTH		OTH
payee_naml		Christiansen		Bell, McAndrews & Hiltachk, LLP		Quimby Group Consulting		Quimby Group Consulting		Cardmember Service		Christiansen		The Monaco Group		Quimby Group Consulting		Christiansen		Bell, McAndrews & Hiltachk, LLP		Quimby Group Consulting		Quimby Group Consulting		Cardmember Service		Christiansen		JC Evans Inc.		Monaco Inc.		Quimby Group Consulting		Cardmember Service
payee_namf		William		None		None		None		None		William		None		None		William		None		None		None		None		William		None		None		None		None
payee_namt		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
payee_city		Tustin		Sacramento		Tustin		Tustin		Carol Stream		Tustin		Santa Ana		Tustin		Tustin		Sacramento		Tustin		Tustin		Carol Stream		Tustin		Riverview		Santa Ana		Tustin		Carol Stream
payee_st		CA		CA		CA		CA		IL		CA		CA		CA		CA		CA		CA		CA		IL		CA		FL		CA		CA		IL
payee_zip4		92782		95814		92780		92780		60197-6294		92782		92705		92780		92782		95814		92780		92780		60197-6294		92782		33578		92705		92780		60197-6294
beg_bal		1006		129		1500		869		509		316		0		0		1006		129		1500		869		509		316		0		0		0		0
amt_incur		0		0		0		0		0		0		5260		10712		0		0		0		0		0		0		230		5260		10712		6396
amt_paid		1006		129		1500		869		509		316		0		0		1006		129		1500		869		509		316		0		0		0		0
end_bal		0		0		0		0		0		0		5260		10712		0		0		0		0		0		0		230		5260		10712		6396
expn_code		OFC		PRO		CNS		FND		OFC		OFC		LIT		CNS		OFC		PRO		CNS		FND		OFC		OFC		LIT		LIT		CNS		FND
expn_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		See Schedule G for Details
cmte_id		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
tres_namf		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
tres_nams		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
tres_st		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
memo_code		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
bakref_tid		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
xref_match		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: expn

filing_id		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972
amend_id		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		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		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
rec_type		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN
form_type		D		D		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		D		D		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G
tran_id		EXP677		EXP758		EXP677		EXP686		EXP688		EXP698		EXP690		EXP703		EXP748		EXP709		EXP714		EXP711		EXP716		EXP722		EXP658		EXP731		EXP727		EXP729		EXP738		EXP758		EXP754		EXP756		EXP750		EXP752		EXP757		EXP760		EXP764		EXP765		EXP747		EXP798		EXP800		EXP805		EXP809		EXP813		EXP816		EXP814		EXP818		EXP819		EXP817		EXP836		EXP839		EXP847		EXP853		EXP854		EXP808		EDT54		EDT51		EDT50		EDT53		EDT52		EDT66		EDT65		EDT64		EDT68		EDT69		EDT71		EDT70		PDT56		PDT57		PDT55		EDT57		EDT56		EDT59		EDT61		EDT62		EDT63		EDT55		EDT74		EDT75		PDT37		PDT38		EXP677		EXP758		EXP677		EXP686		EXP688		EXP698		EXP690		EXP703		EXP748		EXP709		EXP714		EXP711		EXP716		EXP722		EXP658		EXP731		EXP727		EXP729		EXP738		EXP758		EXP754		EXP756		EXP750		EXP752		EXP757		EXP760		EXP764		EXP765		EXP747		EXP798		EXP800		EXP805		EXP809		EXP813		EXP816		EXP814		EXP818		EXP819		EXP817		EXP836		EXP839		EXP847		EXP853		EXP854		EXP808		EDT54		EDT51		EDT50		EDT53		EDT52		EDT66		EDT65		EDT64		EDT68		EDT69		EDT71		EDT70		EDT57		EDT56		EDT59		EDT61		EDT62		EDT63		EDT55		EDT74		PDT37		PDT38		EDT75
entity_cd		COM		COM		COM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		IND		OTH		OTH		OTH		OTH		OTH		OTH		OTH		COM		OTH		OTH		IND		OTH		OTH		OTH		IND		OTH		OTH		IND		IND		OTH		IND		OTH		IND		OTH		OTH		IND		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		COM		COM		COM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		IND		OTH		OTH		OTH		OTH		OTH		OTH		OTH		COM		OTH		OTH		IND		OTH		OTH		OTH		IND		OTH		OTH		IND		IND		OTH		IND		OTH		IND		OTH		OTH		IND		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH
payee_naml		Republican Party of Orange County		Burns for Huntington Beach City Council 2022		Republican Party of Orange County		Quimby Group Consulting		Quimby Group Consulting		Cardmember Service		Gilliard Blanning & Associates Inc.		Our Lady of Mount Carmel		Bell, McAndrews & Hiltachk, LLP		JC Evans Inc.		Campaign Compliance Group		Christiansen		Wendy Warfield & Associates		Orange County Registrar of Voters		Capitol Tech Solutions		Gilliard Blanning & Associates Inc.		Quimby Group Consulting		Quimby Group Consulting		Monaco Inc.		Burns for Huntington Beach City Council 2022		Campaign Compliance Group		Cardmember Service		Christiansen		Wendy Warfield & Associates		American Express		Gilliard Blanning & Associates Inc.		Christiansen		The Angent Group		Capitol Tech Solutions		Christiansen		Christiansen		Gilliard Blanning & Associates Inc.		Christiansen		Cardmember Service		Christiansen		Wendy Warfield & Associates		Monaco Inc.		Christiansen		Campaign Compliance Group		US Postmaster USPS		2S Publishing LLC		Cygnal		Gilliard Blanning & Associates Inc.		Monaco Inc.		Capitol Tech Solutions		Federal Express		MailChimp		Southwest Airlines		Shorebird		MailChimp		MailChimp		Southwest Airlines		The Park Downtown		Beach Pit BBQ		MailChimp		Newport Harbor Republican Women		Southwest Airlines		D&B Transportation		MailChimp		Newport Beach Country Club		Southwest Airlines		Southwest Airlines		Ralphs		Angelo's Italian Deli		Ralphs		Southwest Airlines		COGS South Signs		Facebook		US Postmaster USPS		Staples		US Postmaster USPS		Republican Party of Orange County		Burns for Huntington Beach City Council 2022		Republican Party of Orange County		Quimby Group Consulting		Quimby Group Consulting		Cardmember Service		Gilliard Blanning & Associates Inc.		Our Lady of Mount Carmel		Bell, McAndrews & Hiltachk, LLP		JC Evans Inc.		Campaign Compliance Group		Christiansen		Wendy Warfield & Associates		Orange County Registrar of Voters		Capitol Tech Solutions		Gilliard Blanning & Associates Inc.		Quimby Group Consulting		Quimby Group Consulting		The Monaco Group		Burns for Huntington Beach City Council 2022		Campaign Compliance Group		Cardmember Service		Christiansen		Wendy Warfield & Associates		American Express		Gilliard Blanning & Associates Inc.		Christiansen		The Angent Group		Capitol Tech Solutions		Christiansen		Christiansen		Gilliard Blanning & Associates Inc.		Christiansen		Cardmember Service		Christiansen		Wendy Warfield & Associates		The Monaco Group		Christiansen		Campaign Compliance Group		US Postmaster USPS		2S Publishing LLC		Cygnal		Gilliard Blanning & Associates Inc.		The Monaco Group		Capitol Tech Solutions		Federal Express		MailChimp		Southwest Airlines		Shorebird		MailChimp		MailChimp		Southwest Airlines		The Park Downtown		Beach Pit BBQ		MailChimp		Newport Harbor Republican Women		Southwest Airlines		Southwest Airlines		Southwest Airlines		Ralphs		Angelo's Italian Deli		Ralphs		Southwest Airlines		COGS South Signs		Facebook		Staples		US Postmaster USPS		US Postmaster USPS
payee_namf		None		None		None		None		None		None		None		None		None		None		None		William		None		None		None		None		None		None		None		None		None		None		William		None		None		None		William		None		None		William		William		None		William		None		William		None		None		William		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		William		None		None		None		None		None		None		None		None		None		None		William		None		None		None		William		None		None		William		William		None		William		None		William		None		None		William		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_city		Tustin		Huntington Beach		Tustin		Tustin		Tustin		Carol Stream		Rocklin		Newport Beach		Sacramento		Riverview		Irvine		Tustin		Sacramento		Santa Ana		Sacramento		Rocklin		Tustin		Tustin		Santa Ana		Huntington Beach		Irvine		Carol Stream		Tustin		Sacramento		Los Angeles		Rocklin		Tustin		Costa Mesa		Sacramento		Tustin		Tustin		Rocklin		Tustin		Carol Stream		Tustin		Sacramento		Santa Ana		Tustin		Irvine		Santa Ana		Laguna Beach		Washington		Rocklin		Santa Ana		Sacramento		Memphis		Atlanta		Dallas		Newport Beach		Atlanta		Atlanta		Dallas		Sacramento		Costa Mesa		Atlanta		Newport Beach		Dallas		Irvine		Atlanta		Newport Beach		Dallas		Dallas		Tustin		Seal Beach		Tustin		Dallas		Santa Ana		Menlo Park		Santa Ana		Santa Ana		Santa Ana		Tustin		Huntington Beach		Tustin		Tustin		Tustin		Carol Stream		Rocklin		Newport Beach		Sacramento		Pahrump		Irvine		Tustin		Sacramento		Santa Ana		Sacramento		Rocklin		Tustin		Tustin		Santa Ana		Huntington Beach		Irvine		Carol Stream		Tustin		Sacramento		Los Angeles		Rocklin		Tustin		Costa Mesa		Sacramento		Tustin		Tustin		Rocklin		Tustin		Carol Stream		Tustin		Sacramento		Santa Ana		Tustin		Irvine		Santa Ana		Laguna Beach		Washington		Rocklin		Santa Ana		Sacramento		Memphis		Atlanta		Dallas		Newport Beach		Atlanta		Atlanta		Dallas		Sacramento		Costa Mesa		Atlanta		Newport Beach		Dallas		Dallas		Dallas		Tustin		Seal Beach		Tustin		Dallas		Santa Ana		Menlo Park		Santa Ana		Santa Ana		Santa Ana
payee_st		CA		CA		CA		CA		CA		IL		CA		CA		CA		FL		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		IL		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		IL		CA		CA		CA		CA		CA		CA		CA		DC		CA		CA		CA		TN		GA		TX		CA		GA		GA		TX		CA		CA		GA		CA		TX		CA		GA		CA		TX		TX		CA		CA		CA		TX		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		IL		CA		CA		CA		NV		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		IL		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		IL		CA		CA		CA		CA		CA		CA		CA		DC		CA		CA		CA		TN		GA		TX		CA		GA		GA		TX		CA		CA		GA		CA		TX		TX		TX		CA		CA		CA		TX		CA		CA		CA		CA		CA
payee_zip4		92780		92647		92780		92780		92780		60197-6294		95765		92661		95814		33578		92618		92782		95814		92705		95816		95765		92780		92780		92705		92647		92618		60197-6294		92782		95814		90010		95765		92782		92626		95816		92782		92782		95765		92782		60197-6294		92782		95814		92705		92782		92618		92705		92651		20006		95765		92705		95816		38101		30308		75235		92660		30308		30308		75235		95814		92627		30308		92660		75235		92612		30308		92660		75235		75235		92782		90740		92782		75235		92707		94025		92705		92705		92705		92780		92647		92780		92780		92780		60197-6294		95765		92661		95814		89048		92618		92782		95814		92705		95816		95765		92780		92780		92705		92647		92618		60197-6294		92782		95814		90010		95765		92782		92626		95816		92782		92782		95765		92782		60197-6294		92782		95814		92705		92782		92618		92705		92651		20006		95765		92705		95816		38101		30308		75235		92660		30308		30308		75235		95814		92627		30308		92660		75235		75235		75235		92782		90740		92782		75235		92707		94025		92705		92705		92705
expn_date		2022-07-01 00:00:00		2022-08-09 00:00:00		2022-07-01 00:00:00		2022-07-05 00:00:00		2022-07-05 00:00:00		2022-07-06 00:00:00		2022-07-06 00:00:00		2022-07-06 00:00:00		2022-07-09 00:00:00		2022-07-15 00:00:00		2022-07-20 00:00:00		2022-07-20 00:00:00		2022-07-20 00:00:00		2022-07-27 00:00:00		2022-07-31 00:00:00		2022-08-01 00:00:00		2022-08-01 00:00:00		2022-08-01 00:00:00		2022-08-03 00:00:00		2022-08-09 00:00:00		2022-08-09 00:00:00		2022-08-09 00:00:00		2022-08-09 00:00:00		2022-08-09 00:00:00		2022-08-11 00:00:00		2022-08-15 00:00:00		2022-08-16 00:00:00		2022-08-16 00:00:00		2022-08-30 00:00:00		2022-08-31 00:00:00		2022-08-31 00:00:00		2022-09-06 00:00:00		2022-09-07 00:00:00		2022-09-08 00:00:00		2022-09-08 00:00:00		2022-09-08 00:00:00		2022-09-09 00:00:00		2022-09-12 00:00:00		2022-09-16 00:00:00		2022-09-16 00:00:00		2022-09-19 00:00:00		2022-09-20 00:00:00		2022-09-22 00:00:00		2022-09-23 00:00:00		2022-09-24 00:00:00		2022-08-11 00:00:00		2022-07-07 00:00:00		2022-07-10 00:00:00		2022-07-23 00:00:00		2022-07-28 00:00:00		2022-08-07 00:00:00		2022-08-15 00:00:00		2022-08-17 00:00:00		2022-08-20 00:00:00		2022-08-20 00:00:00		2022-08-30 00:00:00		2022-08-30 00:00:00		2022-09-15 00:00:00		2022-09-15 00:00:00		2022-09-24 00:00:00		2022-07-20 00:00:00		2022-08-15 00:00:00		2022-08-20 00:00:00		2022-08-27 00:00:00		2022-08-27 00:00:00		2022-09-10 00:00:00		2022-08-15 00:00:00		2022-09-22 00:00:00		2022-09-23 00:00:00		2022-07-12 00:00:00		2022-07-26 00:00:00		2022-07-01 00:00:00		2022-08-09 00:00:00		2022-07-01 00:00:00		2022-07-05 00:00:00		2022-07-05 00:00:00		2022-07-06 00:00:00		2022-07-06 00:00:00		2022-07-06 00:00:00		2022-07-09 00:00:00		2022-07-15 00:00:00		2022-07-20 00:00:00		2022-07-20 00:00:00		2022-07-20 00:00:00		2022-07-27 00:00:00		2022-07-31 00:00:00		2022-08-01 00:00:00		2022-08-01 00:00:00		2022-08-01 00:00:00		2022-08-03 00:00:00		2022-08-09 00:00:00		2022-08-09 00:00:00		2022-08-09 00:00:00		2022-08-09 00:00:00		2022-08-09 00:00:00		2022-08-11 00:00:00		2022-08-15 00:00:00		2022-08-16 00:00:00		2022-08-16 00:00:00		2022-08-30 00:00:00		2022-08-31 00:00:00		2022-08-31 00:00:00		2022-09-06 00:00:00		2022-09-07 00:00:00		2022-09-08 00:00:00		2022-09-08 00:00:00		2022-09-08 00:00:00		2022-09-09 00:00:00		2022-09-12 00:00:00		2022-09-16 00:00:00		2022-09-16 00:00:00		2022-09-19 00:00:00		2022-09-20 00:00:00		2022-09-22 00:00:00		2022-09-23 00:00:00		2022-09-24 00:00:00		2022-08-11 00:00:00		2022-07-07 00:00:00		2022-07-10 00:00:00		2022-07-23 00:00:00		2022-07-28 00:00:00		2022-08-07 00:00:00		2022-08-15 00:00:00		2022-08-17 00:00:00		2022-08-20 00:00:00		2022-08-20 00:00:00		2022-08-30 00:00:00		2022-08-30 00:00:00		2022-07-20 00:00:00		2022-08-15 00:00:00		2022-08-20 00:00:00		2022-08-27 00:00:00		2022-08-27 00:00:00		2022-09-10 00:00:00		2022-08-15 00:00:00		2022-09-22 00:00:00		2022-07-12 00:00:00		2022-07-26 00:00:00		2022-09-23 00:00:00
amount		3000		250		3000		1500		869		509		1000		500		129		230		1200		7000		1512		2400		627		1000		135		5913		1272		250		1200		679		7000		1537		44		3293		894		695		416		316		1006		1000		210		3624		7000		1555		1272		248		1200		62		1200		9400		7500		4469		532		44		98		338		166		70		98		106		1536		1177		70		60		458		550		98		5817		445		449		56		111		33		248		3293		7500		4469		49		86		3000		250		3000		1500		869		509		1000		500		129		230		1200		7000		1512		2400		627		1000		135		5913		1272		250		1200		679		7000		1537		44		3293		894		695		416		316		1006		1000		210		3624		7000		1555		1272		248		1200		62		1200		9400		7500		4469		532		44		98		338		166		70		98		106		1536		1177		70		60		458		445		449		56		111		33		248		3293		7500		49		86		4469
cum_ytd		6000		250		6000		47342		47342		22367		59016		500		225		690		12953		58674		13781		5999		7255		59016		47342		47342		111829		250		12953		22367		58674		13781		230		59016		58674		695		7255		58674		58674		59016		58674		22367		58674		13781		111829		58674		12953		54963		1200		9400		59016		111829		7255		230		1425		5103		166		1425		1425		5103		1536		1177		1425		933		5103		550		1425		5817		5103		5103		538		111		538		5103		12539		21500		54963		441		54963		6000		250		6000		47342		47342		15971		59016		500		225		460		12953		58674		13781		5999		7255		59016		47342		47342		111829		250		12953		15971		58674		13781		230		59016		58674		695		7255		58674		58674		59016		58674		15971		58674		13781		111829		58674		12953		54963		1200		9400		59016		111829		7255		230		1327		5103		166		1327		1327		5103		1536		1177		1327		933		5103		5103		5103		538		111		538		5103		12539		21500		441		54963		54963
cum_oth		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
expn_chkno		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
expn_code		MON		MON		CTB		CNS		FND		OFC		CNS		CVC		PRO		LIT		CNS		CNS		CNS		FIL		OFC		CNS		POS		CNS		LIT		CTB		CNS		OFC		CNS		CNS		POS		CMP		TRS		LIT		OFC		OFC		OFC		CNS		TRS		OFC		CNS		CNS		LIT		TRS		CNS		POS		PRT		POL		WEB		POS		OFC		POS		WEB		TRC		MTG		WEB		WEB		TRC		FND		OFC		WEB		CVC		TRC		CMP		WEB		FND		TRS		TRS		OFC		OFC		OFC		TRS		CMP		WEB		POS		OFC		POS		MON		MON		CTB		CNS		FND		OFC		CNS		CVC		PRO		LIT		CNS		CNS		CNS		FIL		OFC		CNS		POS		CNS		LIT		CTB		CNS		OFC		CNS		CNS		POS		CMP		TRS		LIT		OFC		OFC		OFC		CNS		TRS		OFC		CNS		CNS		LIT		TRS		CNS		POS		PRT		POL		WEB		POS		OFC		POS		WEB		TRC		MTG		WEB		WEB		TRC		FND		OFC		WEB		CVC		TRC		TRS		TRS		OFC		OFC		OFC		TRS		CMP		WEB		OFC		POS		POS
expn_dscr		None		None		None		None		None		See Schedule G for Details		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		See Schedule G for Details		None		None		None		Outdoor Signs		See Schedule G for Details		Door Hangers		None		See Schedule G for Details		See Schedule G for Details		None		See Schedule G for Details		See Schedule G for Details		None		None		Palm Cards		See Schedule G for Details		None		None		None		None		See Schedule G for Details		None		None		None		None		Candidate Airfare 8/17 SNA-SMF-SNA for Campaign Meetings		7/23 Campaign Strategy Meeting & Meal Costs - 4 Attendees including Candidate		None		None		Candidate Airfare 8/17 SNA-SMF-SNA for Campaign Meetings		8/17 Event Food and Beverage - 46 Attendees Including Candidate		8/20 Meals for Volunteers - 23 Attendees Including Candidate		None		None		Candidate Airfare 9/23 SNA-SMF-SNA for Campaign Meetings		None		None		9/22 Event Venue & Catering Costs - Reception Only		WChristiansen Airfare Costs 7/20 SMF-SNA for Campaign Meetings		WChristiansen Airfare Costs 8/17 SNA-SMF-SNA for Campaign Meetings		8/20 Volunteer Refreshments		8/27 Volunteer Refreshments		8/27 Volunteer Refreshments		WChristiansen Airfare 9/28 SNA-SMF-SNA for Campaign Meetings		Outdoor Signs		None		None		None		None		None		None		None		None		None		See Schedule G for Details		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		See Schedule G for Details		None		None		None		Outdoor Signs		See Schedule G for Details		Door Hangers		None		See Schedule G for Details		See Schedule G for Details		None		See Schedule G for Details		None		None		None		Palm Cards		See Schedule G for Details		None		None		None		None		See Schedule G for Details		None		None		None		None		Candidate Airfare 8/17 SNA-SMF-SNA for Campaign Meetings		7/23 Campaign Strategy Meeting & Meal Costs - 4 Attendees including Candidate		None		None		Candidate Airfare 8/17 SNA-SMF-SNA for Campaign Meetings		8/17 Event Food and Beverage - 46 Attendees Including Candidate		8/20 Meals for Volunteers - 23 Attendees Including Candidate		None		None		Candidate Airfare 9/23 SNA-SMF-SNA for Campaign Meetings		WChristiansen Airfare Costs 7/20 SMF-SNA for Campaign Meetings		WChristiansen Airfare Costs 8/17 SNA-SMF-SNA for Campaign Meetings		8/20 Volunteer Refreshments		8/27 Volunteer Refreshments		8/27 Volunteer Refreshments		WChristiansen Airfare 9/28 SNA-SMF-SNA for Campaign Meetings		Outdoor Signs		None		None		None		None
agent_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		American Express		Cardmember Service		Cardmember Service		Cardmember Service		Cardmember Service		Cardmember Service		Cardmember Service		Cardmember Service		Cardmember Service		Cardmember Service		Cardmember Service		Cardmember Service		Cardmember Service		Cardmember Service		Cardmember Service		Christiansen		Christiansen		Christiansen		Christiansen		Christiansen		Christiansen		Gilliard Blanning & Associates Inc.		Gilliard Blanning & Associates Inc.		Monaco Inc.		Quimby Group Consulting		Quimby Group Consulting		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		American Express		Cardmember Service		Cardmember Service		Cardmember Service		Cardmember Service		Cardmember Service		Cardmember Service		Cardmember Service		Cardmember Service		Cardmember Service		Cardmember Service		Cardmember Service		Christiansen		Christiansen		Christiansen		Christiansen		Christiansen		Christiansen		Gilliard Blanning & Associates Inc.		Gilliard Blanning & Associates Inc.		Quimby Group Consulting		Quimby Group Consulting		The Monaco Group
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		William		William		William		William		William		William		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		William		William		William		William		William		William		None		None		None		None		None
agent_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
agent_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cmte_id		742088		1444900		742088		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1444900		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		742088		1444900		742088		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1444900		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_naml		Republican Party of Orange County		Pat Burns		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Republican Party of Orange County		Pat Burns		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
office_cd		None		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		None		None		None		None		None		None		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		None		None
offic_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_cd		None		CIT		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		CIT		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		City of Huntington Beach		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		City of Huntington Beach		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
dist_no		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
off_s_h_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_name		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_num		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_juris		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sup_opp_cd		S		S		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		S		S		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
memo_code		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
memo_refno		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bakref_tid		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
g_from_e_f		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		E		E		E		E		E		E		E		E		E		E		E
xref_schnm		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
xref_match		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filer_filings

filer_id		1443172		1443172
filing_id		2725972		2725972
period_id		251		251
form_id		F460		F460
filing_sequence		1		0
filing_date		2022-10-27 00:00:00		2022-09-29 00:00:00
stmnt_type		10002		10001
stmnt_status		11003		11003
session_id		2021		2021
user_id		CAFILER		CAFILER
special_audit		11003		11003
fine_audit		11003		11003
rpt_start		2022-07-01 00:00:00		2022-07-01 00:00:00
rpt_end		2022-09-24 00:00:00		2022-09-24 00:00:00
rpt_date		2022-10-26 00:00:00		2022-09-28 00:00:00
filing_type		22001		22001

Table: filings

filing_id		2725972
filing_type		22001

Table: hdr

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

Table: rcpt

filing_id		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972
amend_id		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		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		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
rec_type		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT
form_type		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		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		INC708		INC707		INC718		INC721		INC723		INC724		INC733		INC732		INC739		INC740		INC742		INC741		INC743		INC744		INC763		INC759		INC766		INC767		INC768		INC769		INC770		INC771		INC772		INC773		INC776		INC777		INC774		INC775		INC784		INC785		INC782		INC794		INC795		INC802		INC803		INC804		INC810		INC812		INC811		INC820		INC823		INC825		INC828		INC824		INC829		INC833		INC831		INC835		INC834		INC838		INC837		INC846		INC850		INC849		INC848		INC852		INC859		INC858		INC857		INC855		INC856		INC708		INC707		INC718		INC721		INC723		INC724		INC733		INC732		INC739		INC740		INC742		INC741		INC743		INC744		INC763		INC759		INC766		INC767		INC768		INC769		INC770		INC771		INC772		INC773		INC776		INC777		INC774		INC775		INC784		INC785		INC782		INC794		INC795		INC802		INC803		INC804		INC810		INC812		INC811		INC820		INC823		INC825		INC828		INC824		INC829		INC833		INC831		INC835		INC834		INC838		INC837		INC846		INC850		INC849		INC848		INC852		INC859		INC858		INC857		INC855		INC856
entity_cd		IND		OTH		IND		IND		IND		IND		COM		COM		IND		IND		OTH		IND		IND		IND		SCC		IND		COM		COM		OTH		OTH		OTH		COM		COM		IND		COM		IND		IND		IND		COM		OTH		IND		IND		IND		COM		IND		IND		OTH		COM		OTH		COM		COM		COM		IND		COM		IND		OTH		OTH		OTH		IND		OTH		IND		IND		IND		IND		IND		COM		COM		IND		IND		IND		IND		IND		OTH		IND		IND		IND		IND		COM		COM		IND		IND		OTH		IND		IND		IND		SCC		IND		COM		COM		OTH		OTH		OTH		COM		COM		IND		COM		IND		IND		IND		COM		OTH		IND		IND		IND		COM		IND		IND		OTH		COM		OTH		COM		COM		COM		IND		COM		IND		OTH		OTH		OTH		IND		OTH		IND		IND		IND		IND		IND		COM		COM		IND		IND		IND		IND
ctrib_naml		Mokhbery		San Manuel Band of Mission Indians		Rommel		Moore		Metcalfe		Huyck		Avery for City Council		Californians Allied for Patient Protection PAC		Cox		Czisny		Philip Morris USA Inc. and its Affiliates		Stewart		Thompson		Caldwell		CA Real Estate PAC (CREPAC)		Yant		CA Credit Union League PAC		CALPAC - CA Medical Assn PAC		Southern California Edison Inc		Caroline Dutchie-Caroline Akhavain		Sempra Energy Inc		CA Assn of Winegrape Growers State PAC		CA Beer & Beverage Distributors Community Affairs PAC		Stinehart		GFC Courage Committee-Future Generations Chapter PAC		Nelson		Stevens		Unsworth		Associated General Contractors PAC		BNSF Railyway Company		Lovenduski		Turner		Herzog		GFC Courage Committee - Bay Area Chapter		Emery		Emery		AT&T Services Inc and its Affiliates		GFC Courage Committee - San Francisco Chapter		Johnson & Johnson Inc		CA Permanente Medical Groups PAC		Abbott Laboratories Employee PAC		CA New Car Dealers Assn PAC		Maseeh		Orange County Automobile Dealers Assn PAC		Beimfohr		Clean Energy, Inc.		Molina Healthcare, Inc		Camino Enterprises(Dan Young)		Petry		Port Calypso Marina(Jim Parker)		Yates		Conrad		Arcangelo		Arcangelo		Scinto		CA Nations Indian Gaming Assoc		Anesthesia Services Medical Group PAC		Ayres		Johns		Reynolds		He		Mokhbery		San Manuel Band of Mission Indians		Rommel		Moore		Metcalfe		Huyck		Avery for City Council		Californians Allied for Patient Protection PAC		Cox		Czzisny		Philip Morris USA Inc. and its Affiliates		Stewart		Thompson		Caldwell		CA Real Estate PAC (CREPAC)		Yant		CA Credit Union League PAC		CALPAC - CA Medical Assn PAC		Southern California Edison Inc		Caroline Dutchie-Caroline Akhavain		Sempra Energy Inc		CA Assn of Winegrape Growers State PAC		CA Beer & Beverage Distributors Community Affairs PAC		Stinehart		GFC Courage Committee-Future Generations Chapter PAC		Nelson		Stevens		Unsworth		Associated General Contractors PAC		BNSF Railyway Company		Lovenduski		Turner		Herzog		GFC Courage Committee - Bay Area Chapter		Emery		Emery		AT&T Services Inc and its Affiliates		GFC Courage Committee - San Francisco Chapter		Johnson & Johnson Inc		CA Permanente Medical Groups PAC		Abbott Laboratories Employee PAC		CA New Car Dealers Assn PAC		Maseeh		Orange County Automobile Dealers Assn PAC		Beimfohr		Clean Energy, Inc.		Molina Healthcare, Inc		Camino Enterprises(Dan Young)		Petry		Port Calypso Marina(Jim Parker)		Yates		Conrad		Arcangelo		Arcangelo		Scinto		CA Nations Indian Gaming Assoc		Anesthesia Services Medical Group PAC		Ayres		Johns		Reynolds		He
ctrib_namf		Javad		None		Ann M.		William		Norman		Libby		None		None		Roberta F.		Edward		None		Lynne Nicole		Michael		Kim		None		Bob		None		None		None		None		None		None		None		William		None		Richard		Debbie		Charles		None		None		Michele		Clarence J.		Howard		None		Pamela		Rodney		None		None		None		None		None		None		Fariborz		None		Linda		None		None		None		Lorian		None		Robert		Jerry		Anna		Louis		Francine		None		None		Sandra		William		Kerry		Lin		Javad		None		Ann M.		William		Norman		Libby		None		None		Roberta F.		Edward		None		Lynne Nicole		Michael		Kim		None		Bob		None		None		None		None		None		None		None		William		None		Richard		Debbie		Charles		None		None		Michele		Clarence J.		Howard		None		Pamela		Rodney		None		None		None		None		None		None		Fariborz		None		Linda		None		None		None		Lorian		None		Bob		Jerry		Anna		Louis		Francine		None		None		Sandra		William		Kerry		Lin
ctrib_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
ctrib_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
ctrib_city		Laguna Niguel		Los Angeles		Coto De Caza		Laguna Beach		Corona del Mar		Newport Beach		Irvine		Sacramento		Laguna Beach		Newport Beach		Sacramento		Seal Beach		San Juan Capistrano		La Canada		Los Angeles		Newport Beach		Ontario		Sacramento		Rosemead		Newport Beach		San Diego		Sacramento		Sacramento		Los Angeles		San Rafael		Tustin		Newport Beach		Newport Beach		West Sacramento		Fort Worth		Newport Beach		Newport Beach		Newport Beach		San Rafael		Newport Beach		Newport Beach		Sacramento		San Raaelf		Washington		Oakland		Abbott Park		Sacramento		Newport Beach		Los Angeles		Newport Beach		Newport Beach		Sacramento		Irvine		Newport Beach		Newport Beach		Newport Beach		Costa Mesa		Corona Del Mar		Corona Del Mar		Santa Ana		Los Angeles		San Diego		Newport Beach		Newport Beach		Newport Beach		Newport Beach		Laguna Niguel		Los Angeles		Coto De Caza		Laguna Beach		Corona del Mar		Newport Beach		Irvine		Sacramento		Laguna Beach		Newport Beach		Sacramento		Seal Beach		San Juan Capistrano		La Canada		Los Angeles		Newport Beach		Ontario		Sacramento		Rosemead		Newport Beach		San Diego		Sacramento		Sacramento		Los Angeles		San Rafael		Tustin		Newport Beach		Newport Beach		West Sacramento		Fort Worth		Newport Beach		Newport Beach		Newport Beach		San Rafael		Newport Beach		Newport Beach		Sacramento		San Raaelf		Washington		Oakland		Abbott Park		Sacramento		Newport Beach		Los Angeles		Newport Beach		Newport Beach		Sacramento		Irvine		Newport Beach		Newport Beach		Newport Beach		Costa Mesa		Corona Del Mar		Corona Del Mar		Santa Ana		Los Angeles		San Diego		Newport Beach		Newport Beach		Newport Beach		Newport Beach
ctrib_st		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		TX		CA		CA		CA		CA		CA		CA		CA		CA		DC		CA		IL		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		TX		CA		CA		CA		CA		CA		CA		CA		CA		DC		CA		IL		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
ctrib_zip4		92677		90071		92679		92651		92625		92663		92618		95814		92651		92660		95814		90740		92675		91011		90071		92661		91761		95814		91770		92660		92101		95814		95814		90004		94901		92780		92625		92663		95691		76131		92662		92660		92660		94901		92660		92660		95816		94901		20005		94612		60064		95814		92660		90071		92660		92660		95815		92603		92625		92663		92663		92626		92625		92625		92705		90071		92119		92663		92660		92663		92625		92677		90071		92679		92651		92625		92663		92618		95814		92651		92660		95814		90740		92675		91011		90071		92661		91761		95814		91770		92660		92101		95814		95814		90004		94901		92780		92625		92663		95691		76131		92662		92660		92660		94901		92660		92660		95816		94901		20005		94612		60064		95814		92660		90071		92660		92660		95815		92603		92625		92663		92663		92626		92625		92625		92705		90071		92119		92663		92660		92663		92625
ctrib_emp		Futek		None		The Bergeson Series		Retired		Balmoral Funds		Retired		None		None		Roberta F. Cox		RE/MAX		None		Retired		Newport Landing Sportfishing		Retired		None		Retired		None		None		None		None		None		None		None		Retired		None		Retired		Environmental Audit, Inc.		Retired		None		None		Retired		Trico Realty		Retired		None		Retired		Steadfast		None		None		None		None		None		None		Picoco, LLC		None		Retired		None		None		None		Centriplan, LLC		None		Retired		Retired		Retired		Retired		Orange County Associates		None		None		None		Inland Group Inc		Kerry Reynolds		Rellion Inc		Futek		None		The Bergeson Series		Retired		Balmoral Funds		Retired		None		None		Roberta F. Cox		RE/MAX		None		Retired		Newport Landing Sportfishing		Retired		None		Retired		None		None		None		None		None		None		None		Retired		None		Retired		Environmental Audit, Inc.		Retired		None		None		Retired		Trico Realty		Retired		None		Retired		Steadfast		None		None		None		None		None		None		Picoco, LLC		None		Retired		None		None		None		Centriplan, LLC		None		Retired		Retired		Retired		Retired		Orange County Associates		None		None		None		Inland Group Inc		Kerry Reynolds		Rellion Inc
ctrib_occ		CEO		None		Executive Director		Retired		Sr Advisor		Retired		None		None		Real Estate Broker		Real Estate		None		Retired		Owner		Retired		None		Retired		None		None		None		None		None		None		None		Retired		None		Retired		Consultant		Retired		None		None		Retired		Real Estate		Retired		None		Retired		CEO		None		None		None		None		None		None		President		None		Retired		None		None		None		Inv. Advisor		None		Retired		Retired		Retired		Retired		Manager		None		None		Homemaker		President		Investor/Therapist		Owner		CEO		None		Executive Director		Retired		Sr Advisor		Retired		None		None		Real Estate Broker		Real Estate		None		Retired		Owner		Retired		None		Retired		None		None		None		None		None		None		None		Retired		None		Retired		Consultant		Retired		None		None		Retired		Real Estate		Retired		None		Retired		CEO		None		None		None		None		None		None		President		None		Retired		None		None		None		Inv. Advisor		None		Retired		Retired		Retired		Retired		Manager		None		None		Homemaker		President		Investor/Therapist		Owner
ctrib_self		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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-07-15 00:00:00		2022-07-15 00:00:00		2022-07-22 00:00:00		2022-07-26 00:00:00		2022-07-30 00:00:00		2022-07-31 00:00:00		2022-08-01 00:00:00		2022-08-01 00:00:00		2022-08-03 00:00:00		2022-08-03 00:00:00		2022-08-03 00:00:00		2022-08-03 00:00:00		2022-08-05 00:00:00		2022-08-07 00:00:00		2022-08-15 00:00:00		2022-08-15 00:00:00		2022-08-16 00:00:00		2022-08-16 00:00:00		2022-08-16 00:00:00		2022-08-17 00:00:00		2022-08-18 00:00:00		2022-08-19 00:00:00		2022-08-19 00:00:00		2022-08-21 00:00:00		2022-08-22 00:00:00		2022-08-22 00:00:00		2022-08-22 00:00:00		2022-08-22 00:00:00		2022-08-26 00:00:00		2022-08-26 00:00:00		2022-08-26 00:00:00		2022-08-30 00:00:00		2022-09-01 00:00:00		2022-09-02 00:00:00		2022-09-06 00:00:00		2022-09-06 00:00:00		2022-09-07 00:00:00		2022-09-07 00:00:00		2022-09-07 00:00:00		2022-09-12 00:00:00		2022-09-14 00:00:00		2022-09-14 00:00:00		2022-09-14 00:00:00		2022-09-14 00:00:00		2022-09-15 00:00:00		2022-09-15 00:00:00		2022-09-15 00:00:00		2022-09-16 00:00:00		2022-09-16 00:00:00		2022-09-19 00:00:00		2022-09-19 00:00:00		2022-09-20 00:00:00		2022-09-21 00:00:00		2022-09-21 00:00:00		2022-09-21 00:00:00		2022-09-22 00:00:00		2022-09-23 00:00:00		2022-09-23 00:00:00		2022-09-23 00:00:00		2022-09-23 00:00:00		2022-09-24 00:00:00		2022-07-15 00:00:00		2022-07-15 00:00:00		2022-07-22 00:00:00		2022-07-26 00:00:00		2022-07-30 00:00:00		2022-07-31 00:00:00		2022-08-01 00:00:00		2022-08-01 00:00:00		2022-08-03 00:00:00		2022-08-03 00:00:00		2022-08-03 00:00:00		2022-08-03 00:00:00		2022-08-05 00:00:00		2022-08-07 00:00:00		2022-08-15 00:00:00		2022-08-15 00:00:00		2022-08-16 00:00:00		2022-08-16 00:00:00		2022-08-16 00:00:00		2022-08-17 00:00:00		2022-08-18 00:00:00		2022-08-19 00:00:00		2022-08-19 00:00:00		2022-08-21 00:00:00		2022-08-22 00:00:00		2022-08-22 00:00:00		2022-08-22 00:00:00		2022-08-22 00:00:00		2022-08-26 00:00:00		2022-08-26 00:00:00		2022-08-26 00:00:00		2022-08-30 00:00:00		2022-09-01 00:00:00		2022-09-02 00:00:00		2022-09-06 00:00:00		2022-09-06 00:00:00		2022-09-07 00:00:00		2022-09-07 00:00:00		2022-09-07 00:00:00		2022-09-12 00:00:00		2022-09-14 00:00:00		2022-09-14 00:00:00		2022-09-14 00:00:00		2022-09-14 00:00:00		2022-09-15 00:00:00		2022-09-15 00:00:00		2022-09-15 00:00:00		2022-09-16 00:00:00		2022-09-16 00:00:00		2022-09-19 00:00:00		2022-09-19 00:00:00		2022-09-20 00:00:00		2022-09-21 00:00:00		2022-09-21 00:00:00		2022-09-21 00:00:00		2022-09-22 00:00:00		2022-09-23 00:00:00		2022-09-23 00:00:00		2022-09-23 00:00:00		2022-09-23 00:00:00		2022-09-24 00:00:00
date_thru		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
amount		2500		2500		500		50		2500		100		3000		1000		500		200		4900		100		500		1000		9700		100		1500		4900		4900		100		3000		1500		1500		500		4900		250		500		250		2000		2500		100		1000		250		4900		1225		1225		1500		4900		1500		1500		4000		2500		4900		4900		500		3000		1000		250		100		500		250		2000		500		500		250		2500		1000		500		1000		1000		1000		2500		2500		500		50		2500		100		3000		1000		500		200		4900		100		500		1000		9700		100		1500		4900		4900		100		3000		1500		1500		500		4900		250		500		250		2000		2500		100		1000		250		4900		1225		1225		1500		4900		1500		1500		4000		2500		4900		4900		500		3000		1000		250		100		500		250		2000		500		500		250		2500		1000		500		1000		1000		1000
cum_ytd		2500		2500		500		100		2500		100		3000		1000		500		200		9800		100		1000		1000		19400		100		3000		9800		9800		100		5500		1500		1500		500		4900		500		750		700		4000		2500		200		1500		250		4900		1225		3725		1500		4900		1500		1500		4000		7400		4900		4900		1000		3000		1000		250		200		1500		850		2000		500		500		250		2500		1000		500		1500		2000		1000		2500		2500		500		100		2500		100		3000		1000		500		200		9800		100		1000		1000		19400		100		3000		9800		9800		100		5500		1500		1500		500		4900		500		750		700		4000		2500		200		1500		250		4900		1225		3725		1500		4900		1500		1500		4000		7400		4900		4900		1000		3000		1000		250		200		1500		350		2000		500		500		250		2500		1000		500		1500		2000		1000
cum_oth		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
ctrib_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		1387480		920780		None		None		None		None		None		None		890106		None		760225		742617		None		None		None		801893		761487		None		1416436		None		None		None		980194		None		None		None		None		1423911		None		None		None		1416440		None		992303		1332968		741623		None		870777		None		None		None		None		None		None		None		None		None		None		None		1266480		870598		None		None		None		None		None		None		None		None		None		None		1387480		920780		None		None		None		None		None		None		890106		None		760225		742617		None		None		None		801893		761487		None		1416436		None		None		None		980194		None		None		None		None		1423911		None		None		None		1416440		None		992303		1332968		741623		None		870777		None		None		None		None		None		None		None		None		None		None		None		1266480		870598		None		None		None		None
tres_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_occ		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_self		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
office_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
offic_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
dist_no		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
off_s_h_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_name		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_num		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_juris		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sup_opp_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
memo_code		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
memo_refno		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bakref_tid		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
xref_schnm		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
xref_match		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
int_rate		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_cmteid		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: smry

filing_id		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972
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		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1
line_item		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		1		2		3		1		2		3		1		2		3		4		1		2		3		1		2		3		1		2		3		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		1		2		3		1		2		3		1		2		3		4		1		2		3		1		2		3		1		2		3
rec_type		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY
form_type		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		A		A		A		D		D		D		E		E		E		E		F		F		F		B1		B1		B1		H		H		H		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		A		A		A		D		D		D		E		E		E		E		F		F		F		B1		B1		B1		H		H		H
amount_a		107800		0		107800		0		107800		85397		0		85397		11644		0		97041		72740		107800		0		85397		95144		0		0		15972		107700		100		107800		3250		0		3250		85397		0		0		85397		15972		4328		11644		0		0		0		0		0		0		107800		0		107800		0		107800		85397		0		85397		18271		0		103668		72740		107800		0		85397		95144		0		0		22598		107700		100		107800		3250		0		3250		85397		0		0		85397		22598		4328		18271		0		0		0		0		0		0
amount_b		407904		0		407904		9151		417055		417357		0		417357		15972		9151		442481		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		407904		0		407904		9151		417055		417357		0		417357		22598		9151		449107		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
amount_c		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
elec_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: splt

filing_id		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972		2725972
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		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1
line_item		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		20		21		22		23		24		25		26		27		28		29		30		31		32		33		34		35		36		37		38		39		40		41		42		43		44		45		46		47		48		49		50		51		52		53		54		55		56		57		58		59		60		61		62		63		64		65		66		67		68		69		70		71		72		73		74		75		76		77		78		79		80		81		82		83		84		85		86		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
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		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A
ptran_id		INC708		INC707		INC718		INC721		INC721		INC723		INC723		INC724		INC733		INC732		INC739		INC740		INC742		INC742		INC741		INC743		INC743		INC744		INC763		INC763		INC759		INC766		INC766		INC767		INC767		INC768		INC768		INC769		INC769		INC770		INC770		INC771		INC772		INC773		INC776		INC777		INC774		INC774		INC775		INC775		INC784		INC784		INC785		INC782		INC782		INC794		INC794		INC795		INC802		INC803		INC804		INC804		INC810		INC812		INC811		INC820		INC823		INC825		INC825		INC828		INC824		INC829		INC829		INC833		INC831		INC835		INC834		INC834		INC838		INC838		INC837		INC837		INC846		INC846		INC850		INC849		INC848		INC848		INC852		INC859		INC858		INC857		INC857		INC855		INC855		INC856		INC708		INC707		INC718		INC721		INC721		INC723		INC723		INC724		INC733		INC732		INC739		INC740		INC742		INC742		INC741		INC743		INC743		INC744		INC763		INC763		INC759		INC766		INC766		INC767		INC767		INC768		INC768		INC769		INC769		INC770		INC770		INC771		INC772		INC773		INC776		INC777		INC774		INC774		INC775		INC775		INC784		INC784		INC785		INC782		INC782		INC794		INC794		INC795		INC802		INC803		INC804		INC804		INC810		INC812		INC811		INC820		INC823		INC825		INC825		INC828		INC824		INC829		INC829		INC833		INC831		INC835		INC834		INC834		INC838		INC838		INC837		INC837		INC846		INC846		INC850		INC849		INC848		INC848		INC852		INC859		INC858		INC857		INC857		INC855		INC855		INC856
elec_date		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00
elec_amount		2500		2500		500		200		50		1000		2500		100		3000		1000		500		200		4900		4900		100		1000		500		1000		9700		9700		100		1500		1500		4900		4900		4900		4900		100		100		2500		3000		1500		1500		500		4900		500		250		500		1250		250		2000		2000		2500		100		100		1000		1000		250		4900		1225		2500		1225		1500		4900		1500		1500		4000		4900		2500		4900		4900		500		500		3000		1000		250		100		100		1000		500		300		250		2515		2000		500		500		350		250		2500		1000		500		4900		1250		3200		1000		1000		2500		2500		500		200		50		1000		2500		100		3000		1000		500		200		4900		4900		100		1000		500		1000		9700		9700		100		1500		1500		4900		4900		4900		4900		100		100		2500		3000		1500		1500		500		4900		500		250		500		1250		250		2000		2000		2500		100		100		1000		1000		250		4900		1225		2500		1225		1500		4900		1500		1500		4000		4900		2500		4900		4900		500		500		3000		1000		250		100		100		1000		500		800		250		2515		2000		500		500		350		250		2500		1000		500		4900		1250		3200		1000		1000
elec_code		G		G		G		P		G		P		G		G		G		G		G		G		P		G		G		P		G		G		P		G		G		P		G		P		G		P		G		P		G		P		G		G		G		G		G		G		P		G		P		G		P		G		G		P		G		P		G		G		G		G		P		G		G		G		G		G		G		P		G		G		G		P		G		G		G		G		P		G		P		G		P		G		P		G		G		G		P		G		G		G		G		P		G		P		G		G		G		G		G		P		G		P		G		G		G		G		G		G		P		G		G		P		G		G		P		G		G		P		G		P		G		P		G		P		G		P		G		G		G		G		G		G		P		G		P		G		P		G		G		P		G		P		G		G		G		G		P		G		G		G		G		G		G		P		G		G		G		P		G		G		G		G		P		G		P		G		P		G		P		G		G		G		P		G		G		G		G		P		G		P		G		G