Home

Filing ID: 2726101

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

Table: cvr3_verification_info

filing_id		2726101		2726101		2726101		2726101
amend_id		0		0		1		1
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-09-26 00:00:00		2022-09-24 00:00:00		2022-10-25 00:00:00		2022-10-22 00:00:00
sig_loc		None		None		None		None
sig_naml		Vona L. Copp		Kelly Seyarto		Vona L. Copp		Kelly Seyarto
sig_namf		None		None		None		None
sig_namt		None		None		None		None
sig_nams		None		None		None		None

Table: cvr_campaign_disclosure

filing_id		2726101		2726101
amend_id		0		1
rec_type		CVR		CVR
form_type		F460		F460
filer_id		1443473		1443473
entity_cd		CTL		CTL
filer_naml		Seyarto for Senate 2022		Seyarto for Senate 2022
filer_namf		None		None
filer_namt		None		None
filer_nams		None		None
report_num		000		001
rpt_date		2022-09-26 00:00:00		2022-10-27 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		Murrieta		Murrieta
filer_st		CA		CA
filer_zip4		92562		92562
filer_phon		951-743-5615		951-743-5615
filer_fax		951-677-5449		951-677-5449
file_email		[email protected]		[email protected]
mail_city		None		None
mail_st		None		None
mail_zip4		None		None
tres_naml		Copp		Copp
tres_namf		Vona L.		Vona L.
tres_namt		None		None
tres_nams		None		None
tres_city		Wilton		Wilton
tres_st		CA		CA
tres_zip4		95693		95693
tres_phon		916-686-1815		916-686-1815
tres_fax		None		None
tres_email		None		None
cmtte_type		C		C
control_yn		N		N
sponsor_yn		N		N
primfrm_yn		N		N
brdbase_yn		N		N
amendexp_1		None		Amendment to add additional information received after initial filing.
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		Seyarto		Seyarto
cand_namf		Kelly		Kelly
cand_namt		None		None
cand_nams		None		None
cand_city		Murrieta		Murrieta
cand_st		None		None
cand_zip4		92562		92562
cand_phon		951-743-5615		951-743-5615
cand_fax		951-677-5449		951-677-5449
cand_email		[email protected]		[email protected]
bal_name		None		None
bal_num		None		None
bal_juris		None		None
office_cd		None		None
offic_dscr		State of California		State of California
juris_cd		None		None
juris_dscr		None		None
dist_no		32		32
off_s_h_cd		None		None
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		2726101		2726101		2726101		2726101		2726101		2726101		2726101
amend_id		1		1		1		1		0		0		0
line_item		1		2		3		4		1		2		3
rec_type		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT
form_type		F		F		F		F		F		F		F
tran_id		PAY141		PAY142		PAY143		PAY257		PAY141		PAY142		PAY143
entity_cd		OTH		OTH		IND		OTH		OTH		OTH		IND
payee_naml		Wendy Warfield & Associates		Wendy Warfield & Associates		Copp		JC Evans, Inc.		Wendy Warfield & Associates		Wendy Warfield & Associates		Copp
payee_namf		None		None		Vona		None		None		None		Vona
payee_namt		None		None		None		None		None		None		None
payee_nams		None		None		None		None		None		None		None
payee_city		Sacramento		Sacramento		Wilton		Pahrump		Sacramento		Sacramento		Wilton
payee_st		CA		CA		CA		NV		CA		CA		CA
payee_zip4		95814		95814		95693		89048		95814		95814		95693
beg_bal		1500		1552		484		0		1500		1552		484
amt_incur		0		0		0		230		0		0		0
amt_paid		1500		1552		484		0		1500		1552		484
end_bal		0		0		0		230		0		0		0
expn_code		CNS		FND		PRO		PRO		CNS		FND		PRO
expn_dscr		None		None		None		None		None		None		None
cmte_id		None		None		None		None		None		None		None
tres_naml		None		None		None		None		None		None		None
tres_namf		None		None		None		None		None		None		None
tres_namt		None		None		None		None		None		None		None
tres_nams		None		None		None		None		None		None		None
tres_city		None		None		None		None		None		None		None
tres_st		None		None		None		None		None		None		None
tres_zip4		None		None		None		None		None		None		None
memo_code		None		None		None		None		None		None		None
memo_refno		None		None		None		None		None		None		None
bakref_tid		None		None		None		None		None		None		None
xref_schnm		None		None		None		None		None		None		None
xref_match		None		None		None		None		None		None		None

Table: expn

filing_id		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101
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		1		1		1		1		1		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		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
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
form_type		D		D		D		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		D		D		D		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
tran_id		EXP157		EXP156		EXP193		EXP150		EXP152		EXP146		EXP148		EXP157		EXP158		EXP156		EXP167		EXP168		EXP169		EXP171		EXP170		EXP175		EXP176		EXP177		EXP181		EXP186		EXP185		EXP193		EDT8		EDT9		EDT6		EDT5		EDT4		EDT7		EXP157		EXP156		EXP193		EXP150		EXP152		EXP146		EXP148		EXP157		EXP158		EXP156		EXP167		EXP168		EXP169		EXP171		EXP170		EXP175		EXP176		EXP177		EXP181		EXP186		EXP185		EXP193		EXP203		EDT8		EDT9		EDT6		EDT5		EDT4		EDT7
entity_cd		COM		COM		COM		IND		IND		OTH		OTH		COM		OTH		COM		IND		OTH		OTH		IND		OTH		OTH		OTH		OTH		OTH		IND		OTH		COM		OTH		OTH		OTH		OTH		OTH		OTH		COM		COM		COM		IND		IND		OTH		OTH		COM		OTH		COM		IND		OTH		OTH		IND		OTH		OTH		OTH		OTH		OTH		IND		OTH		COM		OTH		OTH		OTH		OTH		OTH		OTH		OTH
payee_naml		California Republican Party		Suzette Valladares for Assembly 2022		Janey Nguyen for Senate 2022		Copp		Copp		Wendy Warfield & Associates		Wendy Warfield & Associates		California Republican Party		Riverside County		Suzette Valladares for Assembly 2022		Copp		Gilliard Blanning & Associates, Inc.		Gilliard Blanning & Associates, Inc.		Seyarto		Wendy Warfield & Associates		Wendy Warfield & Associates		Wendy Warfield & Associates		Continuing the Republican Revolution		Genesis Consulting		Copp		Gilliard Blanning & Associates, Inc.		Janey Nguyen for Senate 2022		COGS South Signs		Impact Posting		Orange County Registrar of Voters		San Bernardino County Registrar of Voters		San Diego County Registrar		Brasserie du Monde		California Republican Party		Suzette Valladares for Assembly 2022		Janey Nguyen for Senate 2022		Copp		Copp		Wendy Warfield & Associates		Wendy Warfield & Associates		California Republican Party		Riverside County		Suzette Valladares for Assembly 2022		Copp		Gilliard Blanning & Associates, Inc.		Gilliard Blanning & Associates, Inc.		Seyarto		Wendy Warfield & Associates		Wendy Warfield & Associates		Wendy Warfield & Associates		Continuing the Republican Revolution		Genesis Consulting		Copp		Gilliard Blanning & Associates, Inc.		Janey Nguyen for Senate 2022		eFundraising Connections		COGS South Signs		Impact Posting		Orange County Registrar of Voters		San Bernardino County Registrar of Voters		San Diego County Registrar		Brasserie du Monde
payee_namf		None		None		None		Vona		Vona		None		None		None		None		None		Vona		None		None		Kelly		None		None		None		None		None		Vona		None		None		None		None		None		None		None		None		None		None		None		Vona		Vona		None		None		None		None		None		Vona		None		None		Kelly		None		None		None		None		None		Vona		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
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
payee_city		Sacramento		Hilmar		Granite Bay		Wilton		Wilton		Sacramento		Sacramento		Sacramento		Riverside		Hilmar		Wilton		Rocklin		Rocklin		Murrieta		Sacramento		Sacramento		Sacramento		Newport Beach		Canyon Lake		Wilton		Rocklin		Granite Bay		Santa Ana		Santa Ana		Santa Ana		San Bernardino		San Diego		Sacramento		Sacramento		Hilmar		Granite Bay		Wilton		Wilton		Sacramento		Sacramento		Sacramento		Riverside		Hilmar		Wilton		Rocklin		Rocklin		Murrieta		Sacramento		Sacramento		Sacramento		Newport Beach		Canyon Lake		Wilton		Rocklin		Granite Bay		Temecula		Santa Ana		Santa Ana		Santa Ana		San Bernardino		San Diego		Sacramento
payee_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		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
payee_zip4		95814		95324		95746		95693		95693		95814		95814		95814		92507		95324		95693		95765		95765		92562		95814		95814		95814		92660		92587		95693		95765		95746		92707		92707		92705		92415		92123		95814		95814		95324		95746		95693		95693		95814		95814		95814		92507		95324		95693		95765		95765		92562		95814		95814		95814		92660		92587		95693		95765		95746		92592		92707		92707		92705		92415		92123		95814
expn_date		2022-08-02 00:00:00		2022-08-02 00:00:00		2022-09-19 00:00:00		2022-07-19 00:00:00		2022-07-19 00:00:00		2022-07-19 00:00:00		2022-07-19 00:00:00		2022-08-02 00:00:00		2022-08-02 00:00:00		2022-08-02 00:00:00		2022-08-18 00:00:00		2022-08-18 00:00:00		2022-08-18 00:00:00		2022-08-18 00:00:00		2022-08-18 00:00:00		2022-08-23 00:00:00		2022-08-23 00:00:00		2022-08-25 00:00:00		2022-08-31 00:00:00		2022-09-09 00:00:00		2022-09-09 00:00:00		2022-09-19 00:00:00		2022-08-31 00:00:00		2022-08-31 00:00:00		2022-08-18 00:00:00		2022-08-18 00:00:00		2022-08-18 00:00:00		2022-08-23 00:00:00		2022-08-02 00:00:00		2022-08-02 00:00:00		2022-09-19 00:00:00		2022-07-19 00:00:00		2022-07-19 00:00:00		2022-07-19 00:00:00		2022-07-19 00:00:00		2022-08-02 00:00:00		2022-08-02 00:00:00		2022-08-02 00:00:00		2022-08-18 00:00:00		2022-08-18 00:00:00		2022-08-18 00:00:00		2022-08-18 00:00:00		2022-08-18 00:00:00		2022-08-23 00:00:00		2022-08-23 00:00:00		2022-08-25 00:00:00		2022-08-31 00:00:00		2022-09-09 00:00:00		2022-09-09 00:00:00		2022-09-19 00:00:00		2022-09-23 00:00:00		2022-08-31 00:00:00		2022-08-31 00:00:00		2022-08-18 00:00:00		2022-08-18 00:00:00		2022-08-18 00:00:00		2022-08-23 00:00:00
amount		10450		4900		4900		484		350		1500		1552		10450		7000		4900		384		500		500		4861		1570		1549		1741		1500		14000		848		500		4900		10800		2600		727		3523		611		1741		10450		4900		4900		484		350		1500		1552		10450		7000		4900		384		500		500		4861		1570		1549		1741		1500		14000		848		500		4900		12		10800		2600		727		3523		611		1741
cum_ytd		10450		9800		4900		5874		5874		18944		18944		10450		14000		9800		5874		14000		14000		8085		18944		18944		18944		1500		14000		5874		14000		4900		10800		2600		1437		5426		1222		1741		10450		9800		4900		5874		5874		18944		18944		10450		14000		9800		5874		14000		14000		8085		18944		18944		18944		1500		14000		5874		14000		4900		345		10800		2600		1437		5426		1222		1741
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
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
expn_code		MON		MON		MON		PRO		PRO		CNS		FND		CTB		FIL		CTB		PRO		CNS		CNS		FIL		CNS		CNS		FND		LIT		CMP		PRO		CNS		CTB		CMP		PRO		FIL		FIL		FIL		FND		MON		MON		MON		PRO		PRO		CNS		FND		CTB		FIL		CTB		PRO		CNS		CNS		FIL		CNS		CNS		FND		LIT		CMP		PRO		CNS		CTB		OFC		CMP		PRO		FIL		FIL		FIL		FND
expn_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Slate Placement		Signs		None		None		None		None		Sign installation & removal		None		None		None		Event expense: Appetizer only fundraising reception (8/10/22)		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Slate Placement		Signs		None		None		None		None		None		Sign installation & removal		None		None		None		Event expense: Appetizer only fundraising reception (8/10/22)
agent_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Genesis Consulting		Genesis Consulting		Seyarto		Seyarto		Seyarto		Wendy Warfield & Associates		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Genesis Consulting		Genesis Consulting		Seyarto		Seyarto		Seyarto		Wendy Warfield & Associates
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		Kelly		Kelly		Kelly		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Kelly		Kelly		Kelly		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
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
cmte_id		810163		1435635		1434976		None		None		None		None		810163		None		1435635		None		None		None		None		None		None		None		598041		None		None		None		1434976		None		None		None		None		None		None		810163		1435635		1434976		None		None		None		None		810163		None		1435635		None		None		None		None		None		None		None		598041		None		None		None		1434976		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
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
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
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
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
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
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
cand_naml		None		Suzette Valladares		Janet Nguyen		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Suzette Valladares		Janet Nguyen		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
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
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
office_cd		None		ASM		SEN		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		ASM		SEN		None		None		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
juris_cd		None		ASM		SEN		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		ASM		SEN		None		None		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
dist_no		None		40		36		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		40		36		None		None		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
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
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
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
sup_opp_cd		S		S		S		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		S		S		S		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
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
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
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		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		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
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

Table: filer_filings

filer_id		1443473		1443473
filing_id		2726101		2726101
period_id		251		251
form_id		F460		F460
filing_sequence		0		1
filing_date		2022-09-29 00:00:00		2022-10-27 00:00:00
stmnt_type		10001		10002
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-09-26 00:00:00		2022-10-27 00:00:00
filing_type		22001		22001

Table: filings

filing_id		2726101
filing_type		22001

Table: hdr

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

Table: rcpt

filing_id		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101
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		0		0		0		0		0		0		0		0		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		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
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
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
tran_id		INC145		INC155		INC159		INC160		INC163		INC165		INC164		INC162		INC161		INC166		INC172		INC173		INC174		INC179		INC178		INC180		INC187		INC182		INC183		INC184		INC188		INC202		INC190		INC191		INC194		INC192		INC195		INC196		INC199		INC200		INC197		INC198		INC145		INC155		INC159		INC160		INC163		INC165		INC164		INC162		INC161		INC166		INC172		INC173		INC174		INC179		INC178		INC180		INC187		INC182		INC183		INC184		INC188		INC202		INC190		INC191		INC194		INC192		INC195		INC196		INC199		INC200		INC197		INC198
entity_cd		COM		COM		OTH		OTH		COM		OTH		OTH		COM		SCC		OTH		COM		COM		COM		OTH		OTH		OTH		IND		COM		OTH		OTH		SCC		COM		COM		OTH		OTH		IND		OTH		OTH		OTH		IND		OTH		IND		COM		COM		OTH		OTH		COM		OTH		OTH		COM		SCC		OTH		COM		COM		COM		OTH		OTH		OTH		IND		COM		OTH		OTH		SCC		COM		COM		OTH		OTH		IND		OTH		OTH		OTH		IND		OTH		IND
ctrib_naml		California Credit Union League PAC		Assoc Builders and Contractors PAC of So. California		Charter Communications		Sempra Energy		CA Assn of Wingrape Growers State PAC		PBF Energy Western Region, LLC and affiliated entities		Yocha Dehe Wintun Nation		California Farm Bureau Fund to Protect the Family Farm (FARMPAC)		California Real Estate Political Action Committee (CREPAC)		Edison International and Affiliated Entities		Charter Public Schools PAC		Associated General Contractors PAC		Doctors Company Political Action Committee (DOCPAC)		American Chemistry Council		Blue Shield of California		California Resources Corporation - CRC Services, LLC(Mark McFarland)		Semple		The Boeing Company PAC		AT&T Services Inc. and its Affiliates		Disney Worldwide Services, Inc. and its Affiliated Entities		Howard Jarvis Taxpayers Association SCC		Lori Stone for Murrieta Council 2024		California Professional Firefighters PAC SCC		Fresenius Medical Care Corporate		Beyond Food Mart, Inc.		Johnson		BNSF Railway Company		California Veterinary Medical Association PAC		CR&R Incorporated		Lim		CalPortland Company		Lynch		California Credit Union League PAC		Assoc Builders and Contractors PAC of So. California		Charter Communications		Sempra Energy		CA Assn of Wingrape Growers State PAC		PBF Energy Western Region, LLC and affiliated entities		Yocha Dehe Wintun Nation		California Farm Bureau Fund to Protect the Family Farm (FARMPAC)		California Real Estate Political Action Committee (CREPAC)		Edison International and Affiliated Entities		Charter Public Schools PAC		Associated General Contractors PAC		Doctors Company Political Action Committee (DOCPAC)		American Chemistry Council		Blue Shield of California		California Resources Corporation - CRC Services, LLC(Mark McFarland)		Semple		The Boeing Company PAC		AT&T Services Inc. and its Affiliates		Disney Worldwide Services, Inc. and its Affiliated Entities		Howard Jarvis Taxpayers Association SCC		Lori Stone for Murrieta Council 2024		California Professional Firefighters PAC SCC		Fresenius Medical Care Corporate		Beyond Food Mart, Inc.		Johnson		BNSF Railway Company		California Veterinary Medical Association PAC		CR&R Incorporated		Lim		CalPortland Company		Lynch
ctrib_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Joel M.		None		None		None		None		None		None		None		None		William R.		None		None		None		Young		None		Tim		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Joel M.		None		None		None		None		None		None		None		None		William R.		None		None		None		Young		None		Tim
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
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
ctrib_city		Ontario		San Diego		Saint Louis		San Diego		Sacramento		Parsippany		Brooks		Sacramento		Los Angeles		Rosemead		Sacramento		West Sacramento		Napa		Washington		Oakland		Long Beach		Hemet		Arlington		Sacramento		Burbank		Sacramento		Wilton		Sacramento		Metairie		Chino		Riverside		Fort Worth		Sacramento		Stanton		Murrieta		Glendora		Upland		Ontario		San Diego		Saint Louis		San Diego		Sacramento		Parsippany		Brooks		Sacramento		Los Angeles		Rosemead		Sacramento		West Sacramento		Napa		Washington		Oakland		Long Beach		Hemet		Arlington		Sacramento		Burbank		Sacramento		Wilton		Sacramento		Metairie		Chino		Riverside		Fort Worth		Sacramento		Stanton		Murrieta		Glendora		Upland
ctrib_st		CA		CA		MO		CA		CA		NJ		CA		CA		CA		CA		CA		CA		CA		DC		CA		CA		CA		VA		CA		CA		CA		CA		CA		LA		CA		CA		TX		CA		CA		CA		CA		CA		CA		CA		MO		CA		CA		NJ		CA		CA		CA		CA		CA		CA		CA		DC		CA		CA		CA		VA		CA		CA		CA		CA		CA		LA		CA		CA		TX		CA		CA		CA		CA		CA
ctrib_zip4		91761		92119		63131		92101		95814		07054		95606		95833		90071		91770		95814		95691		94558		20002		94607		90831		92544		22202		95814		91521		95814		95693		95833		70002		91710		92506		76131		95815		90680		92562		91741		91786		91761		92119		63131		92101		95814		07054		95606		95833		90071		91770		95814		95691		94558		20002		94607		90831		92544		22202		95814		91521		95814		95693		95833		70002		91710		92506		76131		95815		90680		92562		91741		91786
ctrib_emp		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		n/a		C00142711		None		None		None		None		None		None		None		n/a		None		None		None		n/a		None		General Outdoor Advertising		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		n/a		C00142711		None		None		None		None		None		None		None		n/a		None		None		None		n/a		None		General Outdoor Advertising
ctrib_occ		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Retired		Federal PAC		None		None		None		None		None		None		None		Retired		None		None		None		Retired		None		Vice President		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Retired		Federal PAC		None		None		None		None		None		None		None		Retired		None		None		None		Retired		None		Vice President
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
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
rcpt_date		2022-07-08 00:00:00		2022-07-19 00:00:00		2022-08-02 00:00:00		2022-08-05 00:00:00		2022-08-08 00:00:00		2022-08-08 00:00:00		2022-08-08 00:00:00		2022-08-12 00:00:00		2022-08-12 00:00:00		2022-08-16 00:00:00		2022-08-18 00:00:00		2022-08-19 00:00:00		2022-08-23 00:00:00		2022-08-26 00:00:00		2022-08-26 00:00:00		2022-08-29 00:00:00		2022-09-02 00:00:00		2022-09-06 00:00:00		2022-09-07 00:00:00		2022-09-07 00:00:00		2022-09-09 00:00:00		2022-09-09 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-19 00:00:00		2022-09-19 00:00:00		2022-09-19 00:00:00		2022-09-19 00:00:00		2022-09-21 00:00:00		2022-09-23 00:00:00		2022-07-08 00:00:00		2022-07-19 00:00:00		2022-08-02 00:00:00		2022-08-05 00:00:00		2022-08-08 00:00:00		2022-08-08 00:00:00		2022-08-08 00:00:00		2022-08-12 00:00:00		2022-08-12 00:00:00		2022-08-16 00:00:00		2022-08-18 00:00:00		2022-08-19 00:00:00		2022-08-23 00:00:00		2022-08-26 00:00:00		2022-08-26 00:00:00		2022-08-29 00:00:00		2022-09-02 00:00:00		2022-09-06 00:00:00		2022-09-07 00:00:00		2022-09-07 00:00:00		2022-09-09 00:00:00		2022-09-09 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-19 00:00:00		2022-09-19 00:00:00		2022-09-19 00:00:00		2022-09-19 00:00:00		2022-09-21 00:00:00		2022-09-23 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
amount		1500		1000		1500		3000		1500		1500		2000		1500		9700		4900		1500		2000		1500		1000		2500		3000		100		1500		1500		1000		1000		250		1000		4900		500		1000		4000		1500		750		100		1000		250		1500		1000		1500		3000		1500		1500		2000		1500		9700		4900		1500		2000		1500		1000		2500		3000		100		1500		1500		1000		1000		250		1000		4900		500		1000		4000		1500		750		100		1000		250
cum_ytd		1500		1000		1500		7900		1500		1500		2000		1500		19400		7300		1500		5500		4500		1000		5000		3000		100		1500		4500		2000		1000		400		5000		6900		500		3000		4000		1500		3250		100		1000		750		1500		1000		1500		7900		1500		1500		2000		1500		19400		7300		1500		5500		4500		1000		5000		3000		100		1500		4500		2000		1000		400		5000		6900		500		3000		4000		1500		3250		100		1000		250
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
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
cmte_id		760225		1282257		None		None		801893		None		None		760960		890106		None		1302433		890194		923140		None		None		None		None		1329180		478036		None		1238271		1427024		744058		None		None		None		None		771044		None		None		None		None		760225		1282257		None		None		801893		None		None		760960		890106		None		1302433		890194		923140		None		None		None		None		1329180		478036		None		1238271		1427024		744058		None		None		None		None		771044		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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

Table: smry

filing_id		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101
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		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		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		22A		22B		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		20		21		22A		22B		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		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY
form_type		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		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		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		59950		0		59950		0		59950		59087		0		59087		-3529		0		55559		178652		59950		0		59087		179514		0		0		7		235464		60981		23379		28455		59950		0		59950		20250		0		20250		59087		0		0		59087		7		3535		-3529		0		0		0		0		0		0		59950		0		59950		0		59950		59099		0		59099		-3299		0		55800		178652		59950		0		59099		179503		0		0		237		235464		60981		23621		28455		59950		0		59950		20250		0		20250		59099		0		0		59099		237		3535		-3299		0		0		0		0		0		0
amount_b		295223		0		295223		191		295414		116342		0		116342		7		191		116540		None		None		None		None		None		None		None		None		59950		59094		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		295223		0		295223		191		295414		116354		0		116354		237		191		116782		None		None		None		None		None		None		None		None		59950		59336		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
amount_c		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
elec_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2022-11-08 00:00:00		2022-06-07 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2022-11-08 00:00:00		2022-06-07 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: splt

filing_id		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101		2726101
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		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		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		29		30		31		32		33		34		35		36		37		38		39		40		41		42		43		44		45		46		47		48		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		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
pform_type		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		D		D		D		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		D		D		D
ptran_id		INC188		INC202		INC202		INC190		INC190		INC191		INC191		INC194		INC192		INC192		INC195		INC196		INC199		INC199		INC200		INC197		INC198		EXP157		EXP156		EXP193		INC145		INC155		INC159		INC160		INC160		INC163		INC165		INC164		INC162		INC161		INC161		INC166		INC166		INC172		INC173		INC173		INC174		INC174		INC179		INC178		INC178		INC180		INC187		INC182		INC183		INC183		INC184		INC184		INC145		INC155		INC159		INC160		INC160		INC163		INC165		INC164		INC162		INC161		INC161		INC166		INC166		INC172		INC173		INC173		INC174		INC174		INC179		INC178		INC178		INC180		INC187		INC182		INC183		INC183		INC184		INC184		INC188		INC202		INC202		INC190		INC190		INC191		INC191		INC194		INC192		INC192		INC195		INC196		INC199		INC199		INC200		INC197		INC198		INC198		EXP157		EXP156		EXP193
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
elec_amount		1000		150		250		4000		1000		2000		4900		500		2000		1000		4000		1500		2500		750		100		1000		250		10450		4900		4900		1500		1000		1500		4900		3000		1500		1500		2000		1500		9700		9700		2400		4900		1500		3500		2000		3000		1500		1000		2500		2500		3000		100		1500		3000		1500		1000		1000		1500		1000		1500		4900		3000		1500		1500		2000		1500		9700		9700		2400		4900		1500		3500		2000		3000		1500		1000		2500		2500		3000		100		1500		3000		1500		1000		1000		1000		150		250		4000		1000		2000		4900		500		2000		1000		4000		1500		2500		750		100		1000		500		250		10450		4900		4900
elec_code		G		P		G		P		G		P		G		G		P		G		G		G		P		G		G		G		G		G		G		G		G		G		G		P		G		G		G		G		G		P		G		P		G		G		P		G		P		G		G		P		G		G		G		G		P		G		P		G		G		G		G		P		G		G		G		G		G		P		G		P		G		G		P		G		P		G		G		P		G		G		G		G		P		G		P		G		G		P		G		P		G		P		G		G		P		G		G		G		P		G		G		G		P		G		G		G		G