Home

Filing ID: 2726047

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

Table: cvr2_campaign_disclosure

filing_id		2726047		2726047
amend_id		0		1
line_item		1		1
rec_type		CVR2		CVR2
form_type		F460		F460
tran_id		OFC1		OFC1
entity_cd		ATR		ATR
title		None		None
mail_city		None		None
mail_st		None		None
mail_zip4		None		None
f460_part		3		3
cmte_id		None		None
enty_naml		Copp		Copp
enty_namf		Logan D.		Logan D.
enty_namt		None		None
enty_nams		None		None
enty_city		Wilton		Wilton
enty_st		CA		CA
enty_zip4		95693		95693
enty_phon		916-686-1815		916-686-1815
enty_fax		None		None
enty_email		copp.logan@gmail.com		copp.logan@gmail.com
tres_naml		None		None
tres_namf		None		None
tres_namt		None		None
tres_nams		None		None
control_yn		None		None
office_cd		None		None
offic_dscr		None		None
juris_cd		None		None
juris_dscr		None		None
dist_no		None		None
off_s_h_cd		None		None
bal_name		None		None
bal_num		None		None
bal_juris		None		None
sup_opp_cd		None		None

Table: cvr3_verification_info

filing_id		2726047		2726047		2726047		2726047
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		Joe Patterson		Vona L. Copp		Joe Patterson
sig_namf		None		None		None		None
sig_namt		None		None		None		None
sig_nams		None		None		None		None

Table: cvr_campaign_disclosure

filing_id		2726047		2726047
amend_id		0		1
rec_type		CVR		CVR
form_type		F460		F460
filer_id		1443381		1443381
entity_cd		CTL		CTL
filer_naml		Joe Patterson for Assembly 2022		Joe Patterson for Assembly 2022
filer_namf		None		None
filer_namt		None		None
filer_nams		None		None
report_num		000		001
rpt_date		2022-09-29 00:00:00		2022-10-23 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		Rocklin		Rocklin
filer_st		CA		CA
filer_zip4		95765		95765
filer_phon		916-297-4822		916-297-4822
filer_fax		None		None
file_email		vonac@comcast.net		vonac@comcast.net
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		Patterson		Patterson
cand_namf		Joe		Joe
cand_namt		None		None
cand_nams		None		None
cand_city		Rocklin		Rocklin
cand_st		CA		CA
cand_zip4		95765		95765
cand_phon		916-297-4822		916-297-4822
cand_fax		None		None
cand_email		joepatterson@gmail.com		joepatterson@gmail.com
bal_name		None		None
bal_num		None		None
bal_juris		None		None
office_cd		ASM		ASM
offic_dscr		None		None
juris_cd		None		None
juris_dscr		None		None
dist_no		5		5
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		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047
amend_id		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
line_item		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16
rec_type		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		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		F		F		F		F		F		F		F		F		F		F		F		F		F		F
tran_id		PAY608		PAY609		PAY585		PAY591		PAY612		PAY652		PAY613		PAY594		PAY628		PAY647		PAY610		PAY572		PAY573		PAY752		PAY742		PAY753		PAY608		PAY609		PAY585		PAY591		PAY612		PAY652		PAY613		PAY594		PAY628		PAY647		PAY610		PAY572		PAY573		PAY752		PAY742		PAY753
entity_cd		OTH		IND		IND		OTH		OTH		OTH		IND		OTH		OTH		OTH		IND		IND		IND		OTH		OTH		OTH		OTH		IND		IND		OTH		OTH		OTH		IND		OTH		OTH		OTH		IND		IND		IND		OTH		OTH		OTH
payee_naml		Placer Mailing Services		Copp		Patterson		Chase Card Services		Sacramento Valley Solutions		Chase Card Services		Knight		Chase Card Services		Golden State Strategy Group		Chase Card Services		Copp		Zea		Zea		The Chef's Table		Placer Mailing Services		Chase Card Services		Placer Mailing Services		Copp		Patterson		Chase Card Services		Sacramento Valley Solutions		Chase Card Services		Knight		Chase Card Services		Golden State Strategy Group		Chase Card Services		Copp		Zea		Zea		The Chef's Table		Placer Mailing Services		Chase Card Services
payee_namf		None		Vona L.		Joseph L.		None		None		None		Joy		None		None		None		Vona L.		Harrison E.		Harrison E.		None		None		None		None		Vona L.		Joseph L.		None		None		None		Joy		None		None		None		Vona L.		Harrison E.		Harrison E.		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
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
payee_city		Auburn		Wilton		Rocklin		Wilton		Sutter		Wilton		El Dorado Hills		Wilton		Sacramento		Wilton		Wilton		Grass Valley		Grass Valley		Rocklin		Auburn		Wilton		Auburn		Wilton		Rocklin		Wilton		Sutter		Wilton		El Dorado Hills		Wilton		Sacramento		Wilton		Wilton		Grass Valley		Grass Valley		Rocklin		Auburn		Wilton
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
payee_zip4		95603-9067		95693		95765		95693		95982		95693		95762		95693		95814		95693		95693		95949		95949		95765		95603-9067		95693		95603-9067		95693		95765		95693		95982		95693		95762		95693		95814		95693		95693		95949		95949		95765		95603-9067		95693
beg_bal		1126		1713		526		2958		10000		3164		500		1010		2658		63		1121		105		141		0		0		0		1126		1713		526		2958		10000		3164		500		1010		2658		63		1121		105		141		0		0		0
amt_incur		0		0		0		0		0		0		0		0		0		0		0		0		0		2000		1142		548		0		0		0		0		0		0		0		0		0		0		0		0		0		2000		1142		548
amt_paid		1126		1713		526		2958		10000		3164		500		1010		2658		63		1121		105		141		0		0		0		1126		1713		526		2958		10000		3164		500		1010		2658		63		1121		105		141		0		0		0
end_bal		0		0		0		0		0		0		0		0		0		0		0		0		0		2000		1142		548		0		0		0		0		0		0		0		0		0		0		0		0		0		2000		1142		548
expn_code		LIT		PRO		TRC		None		CNS		None		PRO		None		CNS		None		PRO		TRS		MBR		FND		LIT		None		LIT		PRO		TRC		None		CNS		None		PRO		None		CNS		None		PRO		TRS		MBR		FND		LIT		None
expn_dscr		None		None		Mileage reimbursement		Meeting, office and event expenses		None		Text Program		None		Meetings, travel and campaign paraphernalia		None		Meeting & parking expenses		None		Mileage reimbursement		Volunteer expenses - food		Fundraising dinner: Candidate, spouse, 1 staff & 16 guests (8/22/22)		None		Travel, meeting & office expenses		None		None		Mileage reimbursement		Meeting, office and event expenses		None		Text Program		None		Meetings, travel and campaign paraphernalia		None		Meeting & parking expenses		None		Mileage reimbursement		Volunteer expenses - food		Fundraising dinner: Candidate, spouse, 1 staff & 16 guests (8/22/22)		None		Travel, meeting & office expenses
cmte_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
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
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
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
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
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
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
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
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
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
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
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

Table: expn

filing_id		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047
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		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		51		52		53		54		55		56		57		58		59		60		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		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
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
form_type		E		E		E		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		E		E		E		E		E		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		E		E		E		E		E		E		E		E		G		G		G		G		G		G		G
tran_id		EXP720		EXP750		EXP751		EDT34		EDT32		EDT33		PDT25		EDT31		EDT35		EDT36		EXP688		EXP662		EXP592		EXP595		EXP584		EXP587		EXP589		EXP601		EXP603		EXP629		EXP617		EXP619		EXP621		EXP634		EXP625		EXP615		EXP623		EXP635		EXP654		EXP650		EXP648		EXP640		EXP644		EXP645		EXP642		EXP641		EXP665		EXP660		EXP675		EXP692		EXP688		EXP691		EXP662		EXP693		EXP690		EXP689		EXP685		EXP686		EXP687		EXP709		EXP706		EXP704		EXP707		EXP708		EXP737		EXP736		EXP723		EXP749		EXP721		EXP722		EXP688		EXP662		EXP592		EXP595		EXP584		EXP587		EXP589		EXP601		EXP603		EXP629		EXP617		EXP619		EXP621		EXP634		EXP625		EXP615		EXP623		EXP635		EXP654		EXP650		EXP648		EXP640		EXP644		EXP645		EXP642		EXP641		EXP665		EXP660		EXP675		EXP692		EXP688		EXP691		EXP662		EXP693		EXP690		EXP689		EXP685		EXP686		EXP687		EXP709		EXP706		EXP704		EXP707		EXP708		EXP737		EXP736		EXP723		EXP749		EXP721		EXP722		EXP720		EXP750		EXP751		EDT34		EDT32		EDT33		PDT25		EDT31		EDT35		EDT36
entity_cd		OTH		OTH		OTH		IND		OTH		OTH		OTH		OTH		OTH		OTH		COM		COM		OTH		OTH		OTH		IND		IND		IND		IND		OTH		IND		IND		IND		OTH		IND		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		IND		COM		OTH		COM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		IND		OTH		OTH		OTH		COM		COM		OTH		OTH		OTH		IND		IND		IND		IND		OTH		IND		IND		IND		OTH		IND		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		IND		COM		OTH		COM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		IND		OTH		OTH		OTH		OTH		OTH		OTH		IND		OTH		OTH		OTH		OTH		OTH		OTH
payee_naml		Whitney Ranch Charitable Foundation		eFundraising Connections		eFundraising Connections		Bouchard		Jamie-Joye Photography		Roseville Area Chamber of Commerce		The American Council		Placer Mailing Services		H & S Signs		The Park Downtown		El Dorado County Republican Party		Hoover for Assembly 2022		Chase Card Services		Chase Card Services		Gilliard Blanning & Associates, Inc.		Patterson		Patterson		Zea		Zea		eFundraising Connections		Copp		Copp		Copp		eFundraising Connections		Knight		Placer Mailing Services		Sacramento Valley Solutions		eFundraising Connections		eFundraising Connections		Chase Card Services		Chase Card Services		El Dorado County Elections		Gilliard Blanning & Associates, Inc.		Gilliard Blanning & Associates, Inc.		Golden State Strategy Group		Placer County Elections		eFundraising Connections		PayChex of New York, LLC		eFundraising Connections		Copp		El Dorado County Republican Party		Golden State Strategy Group		Hoover for Assembly 2022		Signworx		The Chef's Table		Whitney Ranch Charitable Foundation		eFundraising Connections		eFundraising Connections		eFundraising Connections		eFundraising Connections		Chase Card Services		Chase Card Services		Gilliard Blanning & Associates, Inc.		Gilliard Blanning & Associates, Inc.		eFundraising Connections		eFundraising Connections		Copp		eFundraising Connections		Golden State Strategy Group		Golden State Strategy Group		El Dorado County Republican Party		Hoover for Assembly 2022		Chase Card Services		Chase Card Services		Gilliard Blanning & Associates, Inc.		Patterson		Patterson		Zea		Zea		eFundraising Connections		Copp		Copp		Copp		eFundraising Connections		Knight		Placer Mailing Services		Sacramento Valley Solutions		eFundraising Connections		eFundraising Connections		Chase Card Services		Chase Card Services		El Dorado County Elections		Gilliard Blanning & Associates, Inc.		Gilliard Blanning & Associates, Inc.		Golden State Strategy Group		Placer County Elections		eFundraising Connections		PayChex of New York, LLC		eFundraising Connections		Copp		El Dorado County Republican Party		Golden State Strategy Group		Hoover for Assembly 2022		Signworx		The Chef's Table		Whitney Ranch Charitable Foundation		eFundraising Connections		eFundraising Connections		eFundraising Connections		eFundraising Connections		Chase Card Services		Chase Card Services		Gilliard Blanning & Associates, Inc.		Gilliard Blanning & Associates, Inc.		eFundraising Connections		eFundraising Connections		Copp		eFundraising Connections		Golden State Strategy Group		Golden State Strategy Group		Whitney Ranch Charitable Foundation		eFundraising Connections		eFundraising Connections		Bouchard		Jamie-Joye Photography		Roseville Area Chamber of Commerce		The American Council		Placer Mailing Services		H & S Signs		The Park Downtown
payee_namf		None		None		None		Michelle		None		None		None		None		None		None		None		None		None		None		None		Joseph L.		Joseph L.		Harrison E.		Harrison E.		None		Vona L.		Vona L.		Vona L.		None		Joy		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Vona L.		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Vona L.		None		None		None		None		None		None		None		None		Joseph L.		Joseph L.		Harrison E.		Harrison E.		None		Vona L.		Vona L.		Vona L.		None		Joy		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Vona L.		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Vona L.		None		None		None		None		None		None		Michelle		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
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
payee_city		Rocklin		Sacramento		Sacramento		Rocklin		Woodland		Roseville		Rocklin		Auburn		Grass Valley		Sacramento		Shingle Springs		Wilton		Wilton		Wilton		Rocklin		Rocklin		Rocklin		Grass Valley		Grass Valley		Sacramento		Wilton		Wilton		Wilton		Sacramento		El Dorado Hills		Auburn		Sutter		Sacramento		Sacramento		Wilton		Wilton		Placerville		Rocklin		Rocklin		Sacramento		Auburn		Sacramento		Costa Mesa		Sacramento		Wilton		Shingle Springs		Sacramento		Wilton		Olivehurst		Rocklin		Rocklin		Sacramento		Sacramento		Sacramento		Sacramento		Wilton		Wilton		Rocklin		Rocklin		Sacramento		Sacramento		Wilton		Sacramento		Sacramento		Sacramento		Shingle Springs		Wilton		Wilton		Wilton		Rocklin		Rocklin		Rocklin		Grass Valley		Grass Valley		Sacramento		Wilton		Wilton		Wilton		Sacramento		El Dorado Hills		Auburn		Sutter		Sacramento		Sacramento		Wilton		Wilton		Placerville		Rocklin		Rocklin		Sacramento		Auburn		Sacramento		Costa Mesa		Sacramento		Wilton		Shingle Springs		Sacramento		Wilton		Olivehurst		Rocklin		Rocklin		Sacramento		Sacramento		Sacramento		Sacramento		Wilton		Wilton		Rocklin		Rocklin		Sacramento		Sacramento		Wilton		Sacramento		Sacramento		Sacramento		Rocklin		Sacramento		Sacramento		Rocklin		Woodland		Roseville		Rocklin		Auburn		Grass Valley		Sacramento
payee_st		CA		CA		CA		CA		CA		None		CA		CA		None		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		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		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		None		CA		CA		None		CA
payee_zip4		95765		95816		95816		95677		95776		95678		95677		95603-9067		95945		95814		95682		95693		95693		95693		95765		95765		95765		95949		95949		95816		95693		95693		95693		95816		95762		95603-9067		95982		95816		95816		95693		95693		95667		95765		95765		95814		95603		95816		92626		95816		95693		95682		95814		95693		95961		95765		95765		95816		95816		95816		95816		95693		95693		95765		95765		95816		95816		95693		95816		95814		95814		95682		95693		95693		95693		95765		95765		95765		95949		95949		95816		95693		95693		95693		95816		95762		95603-9067		95982		95816		95816		95693		95693		95667		95765		95765		95814		95603		95816		92626		95816		95693		95682		95814		95693		95961		95765		95765		95816		95816		95816		95816		95693		95693		95765		95765		95816		95816		95693		95816		95814		95814		95765		95816		95816		95677		95776		95678		95677		95603-9067		95945		95814
expn_date		2022-09-19 00:00:00		2022-09-20 00:00:00		2022-09-22 00:00:00		2022-09-07 00:00:00		2022-09-07 00:00:00		2022-09-07 00:00:00		2022-09-24 00:00:00		2022-08-04 00:00:00		2022-09-07 00:00:00		2022-09-19 00:00:00		2022-08-18 00:00:00		2022-08-18 00:00:00		2022-07-08 00:00:00		2022-07-08 00:00:00		2022-07-08 00:00:00		2022-07-08 00:00:00		2022-07-08 00:00:00		2022-07-08 00:00:00		2022-07-08 00:00:00		2022-07-11 00:00:00		2022-07-18 00:00:00		2022-07-18 00:00:00		2022-07-18 00:00:00		2022-07-18 00:00:00		2022-07-18 00:00:00		2022-07-18 00:00:00		2022-07-18 00:00:00		2022-07-22 00:00:00		2022-07-30 00:00:00		2022-08-04 00:00:00		2022-08-04 00:00:00		2022-08-04 00:00:00		2022-08-04 00:00:00		2022-08-04 00:00:00		2022-08-04 00:00:00		2022-08-04 00:00:00		2022-08-09 00:00:00		2022-08-10 00:00:00		2022-08-15 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-18 00:00:00		2022-08-18 00:00:00		2022-08-21 00:00:00		2022-08-22 00:00:00		2022-08-24 00:00:00		2022-08-30 00:00:00		2022-09-07 00:00:00		2022-09-07 00:00:00		2022-09-07 00:00:00		2022-09-07 00:00:00		2022-09-13 00:00:00		2022-09-14 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-08-18 00:00:00		2022-08-18 00:00:00		2022-07-08 00:00:00		2022-07-08 00:00:00		2022-07-08 00:00:00		2022-07-08 00:00:00		2022-07-08 00:00:00		2022-07-08 00:00:00		2022-07-08 00:00:00		2022-07-11 00:00:00		2022-07-18 00:00:00		2022-07-18 00:00:00		2022-07-18 00:00:00		2022-07-18 00:00:00		2022-07-18 00:00:00		2022-07-18 00:00:00		2022-07-18 00:00:00		2022-07-22 00:00:00		2022-07-30 00:00:00		2022-08-04 00:00:00		2022-08-04 00:00:00		2022-08-04 00:00:00		2022-08-04 00:00:00		2022-08-04 00:00:00		2022-08-04 00:00:00		2022-08-04 00:00:00		2022-08-09 00:00:00		2022-08-10 00:00:00		2022-08-15 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-18 00:00:00		2022-08-18 00:00:00		2022-08-21 00:00:00		2022-08-22 00:00:00		2022-08-24 00:00:00		2022-08-30 00:00:00		2022-09-07 00:00:00		2022-09-07 00:00:00		2022-09-07 00:00:00		2022-09-07 00:00:00		2022-09-13 00:00:00		2022-09-14 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-19 00:00:00		2022-09-20 00:00:00		2022-09-22 00:00:00		2022-09-07 00:00:00		2022-09-07 00:00:00		2022-09-07 00:00:00		2022-09-24 00:00:00		2022-08-04 00:00:00		2022-09-07 00:00:00		2022-09-19 00:00:00
amount		1000		3		12		113		300		300		258		555		12022		2004		500		4900		2958		1010		1000		526		32		141		105		5		1713		1121		350		5		500		1126		10000		1		1		69		63		2180		1000		813		2658		5110		12		284		45		1047		500		1500		4900		4492		3000		1500		45		3		18		1		964		3164		1000		13825		1		97		1020		17		2798		2004		500		4900		2958		1010		1000		526		32		141		105		5		1713		1121		350		5		500		1126		10000		1		1		69		63		2180		1000		813		2658		5110		12		284		45		1047		500		1500		4900		4492		3000		1500		45		3		18		1		964		3164		1000		13825		1		97		1020		17		2798		2004		1000		3		12		113		300		300		258		555		12022		2004
cum_ytd		2500		2770		2770		113		300		300		258		4671		12022		2004		500		9800		12082		12082		110107		1066		1066		16204		16204		2770		10555		10555		10555		2770		500		4671		10000		2770		2770		12082		12082		4320		110107		110107		43906		10200		2770		652		2770		10555		500		43906		9800		10372		5000		2500		2770		2770		2770		2770		12082		12082		110107		110107		2770		2770		10555		2770		43906		43906		500		9800		12082		12082		110107		1066		1066		16204		16204		2770		10555		10555		10555		2770		500		4671		10000		2770		2770		12082		12082		4320		110107		110107		43906		10200		2770		652		2770		10555		500		43906		9800		10372		5000		2500		2770		2770		2770		2770		12082		12082		110107		110107		2770		2770		10555		2770		43906		43906		2500		2770		2770		113		300		300		258		4671		12022		2004
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
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
expn_code		CVC		OFC		OFC		PRO		PRO		CVC		MTG		LIT		CMP		FND		MON		MON		None		None		CNS		TRC		TRC		MBR		TRS		OFC		PRO		PRO		PRO		OFC		PRO		LIT		CNS		OFC		OFC		MTG		None		FIL		CNS		LIT		CNS		FIL		OFC		SAL		OFC		PRO		CTB		CNS		CTB		CMP		FND		CVC		OFC		OFC		OFC		OFC		None		None		CNS		CMP		OFC		OFC		PRO		OFC		CNS		FND		MON		MON		None		None		CNS		TRC		TRC		MBR		TRS		OFC		PRO		PRO		PRO		OFC		PRO		LIT		CNS		OFC		OFC		MTG		None		FIL		CNS		LIT		CNS		FIL		OFC		SAL		OFC		PRO		CTB		CNS		CTB		CMP		FND		CVC		OFC		OFC		OFC		OFC		None		None		CNS		CMP		OFC		OFC		PRO		OFC		CNS		FND		CVC		OFC		OFC		PRO		PRO		CVC		MTG		LIT		CMP		FND
expn_dscr		None		None		None		Childcare (8/22/22)		None		None		American Council's Gala: Candidate & spouse attending (9/25/22)		None		Signs		Appetizer only fundraising reception (8/16/22)		BBQ Sponsorship (8/20/22)		None		Meeting, office and event expenses		Meetings, travel and campaign paraphernalia		None		Mileage reimbursement		Mileage reimbursement		Volunteer expenses - food		Mileage reimbursement		None		None		None		None		None		None		None		None		None		None		None		Meeting & parking expenses		None		None		None		None		None		None		None		None		None		BBQ Sponsorship (8/20/22)		None		None		Yard Signs		Fundraising dinner: Candidate, spouse, 1 staff & 16 guests (8/22/22)		None		None		None		None		None		See schedule G		Text Program		None		Signs		None		None		None		None		None		None		BBQ Sponsorship (8/20/22)		None		Meeting, office and event expenses		Meetings, travel and campaign paraphernalia		None		Mileage reimbursement		Mileage reimbursement		Volunteer expenses - food		Mileage reimbursement		None		None		None		None		None		None		None		None		None		None		None		Meeting & parking expenses		None		None		None		None		None		None		None		None		None		BBQ Sponsorship (8/20/22)		None		None		Yard Signs		Fundraising dinner: Candidate, spouse, 1 staff & 16 guests (8/22/22)		None		None		None		None		None		See schedule G		Text Program		None		Signs		None		None		None		None		None		None		None		None		None		Childcare (8/22/22)		None		None		American Council's Gala: Candidate & spouse attending (9/25/22)		None		Signs		Appetizer only fundraising reception (8/16/22)
agent_naml		None		None		None		Chase Card Services		Chase Card Services		Chase Card Services		Chase Card Services		Gilliard Blanning & Associates, Inc.		Gilliard Blanning & Associates, Inc.		Golden State Strategy Group		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Chase Card Services		Chase Card Services		Chase Card Services		Chase Card Services		Gilliard Blanning & Associates, Inc.		Gilliard Blanning & Associates, Inc.		Golden State Strategy 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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
agent_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
cmte_id		None		None		None		None		None		None		None		None		None		None		791662		1442521		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		791662		None		1442521		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		791662		1442521		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		791662		None		1442521		None		None		None		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
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
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
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
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
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
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
cand_naml		None		None		None		None		None		None		None		None		None		None		El Dorado County Republican Party		Josh Hoover		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		El Dorado County Republican Party		Josh Hoover		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
office_cd		None		None		None		None		None		None		None		None		None		None		None		ASM		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
juris_cd		None		None		None		None		None		None		None		None		None		None		STW		ASM		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		STW		ASM		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
dist_no		None		None		None		None		None		None		None		None		None		None		None		07		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		07		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
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
sup_opp_cd		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		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
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
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
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
g_from_e_f		None		None		None		E		E		E		F		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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

Table: filer_filings

filer_id		1443381		1443381
filing_id		2726047		2726047
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-29 00:00:00		2022-10-23 00:00:00
filing_type		22001		22001

Table: filings

filing_id		2726047
filing_type		22001

Table: hdr

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

filing_id		2726047		2726047
amend_id		1		0
line_item		1		1
rec_type		LOAN		LOAN
form_type		B1		B1
tran_id		PAY54		PAY54
loan_type		None		None
entity_cd		IND		IND
lndr_naml		Patterson		Patterson
lndr_namf		Joseph L.		Joseph L.
lndr_namt		None		None
lndr_nams		None		None
loan_city		Rocklin		Rocklin
loan_st		CA		CA
loan_zip4		95765		95765
loan_date1		2022-01-10 00:00:00		2022-01-10 00:00:00
loan_date2		2022-12-31 00:00:00		2022-12-31 00:00:00
loan_amt1		0		0
loan_amt2		10000		10000
loan_amt3		10003		10003
loan_amt4		10000		10000
loan_rate		0.00		0.00
loan_emp		Provident Strategies		Provident Strategies
loan_occ		Owner		Owner
loan_self		None		None
cmte_id		None		None
tres_naml		None		None
tres_namf		None		None
tres_namt		None		None
tres_nams		None		None
tres_city		None		None
tres_st		None		None
tres_zip4		None		None
intr_naml		None		None
intr_namf		None		None
intr_namt		None		None
intr_nams		None		None
intr_city		None		None
intr_st		None		None
intr_zip4		None		None
memo_code		None		None
memo_refno		PAY54		PAY54
bakref_tid		None		None
xref_schnm		None		None
xref_match		None		None
loan_amt5		0		0
loan_amt6		0		0
loan_amt7		0		0
loan_amt8		10000		10000

Table: rcpt

filing_id		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047
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		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		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		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		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		C		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		C
tran_id		IDT38		IDT39		INC575		INC574		INC630		INC637		INC636		INC638		INC639		INC651		INC661		INC653		INC655		INC656		INC658		INC659		INC657		INC663		INC664		INC666		INC669		INC670		INC673		INC672		INC671		INC674		INC678		INC676		INC677		INC698		INC683		INC679		INC680		INC681		INC682		INC684		INC696		INC694		INC695		INC697		INC701		INC700		INC710		INC714		INC715		INC716		INC718		INC728		INC727		INC725		INC719		INC729		INC731		INC730		INC740		INC739		INC738		INC788		INC732		INC733		INC735		NON741		IDT38		IDT39		INC575		INC574		INC630		INC637		INC636		INC638		INC639		INC651		INC661		INC653		INC655		INC656		INC658		INC659		INC657		INC663		INC664		INC666		INC669		INC670		INC673		INC672		INC671		INC674		INC678		INC676		INC677		INC698		INC683		INC679		INC680		INC681		INC682		INC684		INC696		INC694		INC695		INC697		INC701		INC700		INC710		INC714		INC715		INC716		INC718		INC728		INC727		INC725		INC719		INC729		INC731		INC730		INC740		INC739		INC738		INC732		INC733		INC735		NON741
entity_cd		IND		IND		COM		IND		COM		COM		OTH		COM		IND		COM		COM		IND		SCC		SCC		SCC		COM		IND		COM		OTH		IND		OTH		COM		IND		OTH		COM		IND		COM		COM		IND		IND		COM		COM		OTH		OTH		OTH		IND		SCC		COM		COM		OTH		COM		COM		SCC		SCC		OTH		OTH		IND		OTH		OTH		IND		IND		COM		OTH		IND		OTH		COM		OTH		OTH		IND		IND		IND		PTY		IND		IND		COM		IND		COM		COM		OTH		COM		IND		COM		COM		IND		SCC		SCC		SCC		COM		IND		COM		OTH		IND		OTH		COM		IND		OTH		COM		IND		COM		COM		IND		IND		COM		COM		OTH		OTH		OTH		IND		SCC		COM		COM		OTH		COM		COM		SCC		SCC		OTH		OTH		IND		OTH		OTH		IND		IND		COM		OTH		IND		OTH		COM		OTH		IND		IND		IND		PTY
ctrib_naml		Barker		Guerra		CA Chamber of Commerce PAC AKA ChamberPAC		Patterson		Californians Allied for Patient Protection PAC		Megan Dahle for Assembly 2022		Philip Morris USA Inc. and its Affiliates		Sacramento Area Fire Fighters Local 522 PAC		Myers		California Radiological PAC (CAL RAD PAC)		California Beer & Beverage Distributors Community Affairs		Hunsinger		California Professional Firefighters PAC Small Contributor Committee		Peace Officers Research Association of California PAC (PORAC PAC) Small Contributor Committee		California Real Estate PAC (CREPAC) SCC		California Rice PAC		Gayaldo		CALPAC - California Medical Association PAC		Martin A. Harmon & Auburn Manor Holding Corporation		Kaufhold		Blue Shield of California		Doctors Company PAC aka DOC PAC		Hughes		Knife, Fork & Spoon, LLC		Sheet Metal Workers Local Union 104 PAC		Linden		Anesthesia Service Medical Group Advocacy Fund		Charter Public Schools PAC		Cologna		Kanthal		Associated General Contractors PAC		California Life Sciences Association PAC		King's Casino Management Corp.		Niagra Bottling, LLC(Derrick Thomas)		Players Edge		Myers		California State Council of Laborers PAC - SCC		The Home Depot Inc.. PAC		Western Manufactured Housing Communities Association PAC		California Commerce Club, Inc.		AT&T Services Inc. and its Affiliates		The American Council for Evangelicals PAC PAC		Howard Jarvis Taxpayers Association SCC		California Professional Firefighters PAC Small Contributor Committee		Edison International and Affiliated Entities		Fresenius Medical Care		Astafan		BNSF Railway Company		Johnson & Johnson		Skadsen		Waterman		Rocklin Area Chamber of Commerce PAC		Le Gaming, Inc.		Yee		Capitol Casino		Sacramento Metropolitan Chamber PAC		Sycuan Band of the Kumeyaay Nation		The Frank Ford Company, Inc.		Wilson		Neumann		Piziali		Placer County Republican Central Committee		Barker		Guerra		CA Chamber of Commerce PAC AKA ChamberPAC		Patterson		Californians Allied for Patient Protection PAC		Megan Dahle for Assembly 2022		Philip Morris USA Inc. and its Affiliates		Sacramento Area Fire Fighters Local 522 PAC		Myers		California Radiological PAC (CAL RAD PAC)		California Beer & Beverage Distributors Community Affairs		Hunsinger		California Professional Firefighters PAC Small Contributor Committee		Peace Officers Research Association of California PAC (PORAC PAC) Small Contributor Committee		California Real Estate PAC (CREPAC) SCC		California Rice PAC		Gayaldo		CALPAC - California Medical Association PAC		Martin A. Harmon & Auburn Manor Holding Corporation		Kaufhold		Blue Shield of California		Doctors Company PAC aka DOC PAC		Hughes		Knife, Fork & Spoon, LLC		Sheet Metal Workers Local Union 104 PAC		Linden		Anesthesia Service Medical Group Advocacy Fund		Charter Public Schools PAC		Cologna		Kanthal		Associated General Contractors PAC		California Life Sciences Association PAC		King's Casino Management Corp.		Niagra Bottling, LLC(Derrick Thomas)		Players Edge		Myers		California State Council of Laborers PAC - SCC		The Home Depot Inc.. PAC		Western Manufactured Housing Communities Association PAC		California Commerce Club, Inc.		AT&T Services Inc. and its Affiliates		The American Council for Evangelicals PAC PAC		Howard Jarvis Taxpayers Association SCC		California Professional Firefighters PAC Small Contributor Committee		Edison International and Affiliated Entities		Fresenius Medical Care		Astafan		BNSF Railway Company		Johnson & Johnson		Skadsen		Waterman		Rocklin Area Chamber of Commerce PAC		Le Gaming, Inc.		Yee		Capitol Casino		Sacramento Metropolitan Chamber PAC		Sycuan Band of the Kumeyaay Nation		Wilson		Neumann		Piziali		Placer County Republican Central Committee
ctrib_namf		Jeffrey		Eric		None		David		None		None		None		None		Gwen G		None		None		Patricia		None		None		None		None		Jill		None		None		Steve		None		None		John P.		None		None		Dorothy		None		None		Thomas A.		Cheryl		None		None		None		None		None		Gwen G		None		None		None		None		None		None		None		None		None		None		Nora A.		None		None		Nathan		James		None		None		David		None		None		None		None		Carol		William		Rita		None		Jeffrey		Eric		None		David		None		None		None		None		Gwen G		None		None		Patricia		None		None		None		None		Jill		None		None		Steve		None		None		John P.		None		None		Dorothy		None		None		Thomas A.		Cheryl		None		None		None		None		None		Gwen G		None		None		None		None		None		None		None		None		None		None		Nora A.		None		None		Nathan		James		None		None		David		None		None		None		Carol		William		Rita		None
ctrib_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None
ctrib_city		Seattle		Sacramento		Sacramento		Rocklin		Sacramento		Hilmar		Sacramento		Sacramento		Roseville		Sacramento		Sacramento		Georgetown		Sacramento		Sacramento		Los Angeles		Sacramento		Rocklin		Sacramento		Rocklin		Orinda		Oakland		Napa		Rocklin		Rocklin		Livermore		Rocklin		San Diego		Sacramento		Granite Bay		Rocklin		West Sacramento		Sacramento		Citrus Heights		Diamond Bar		El Segundo		Roseville		Sacramento		Washington		Sacramento		Los Angeles		Sacramento		San Rafael		Sacramento		Sacramento		Rosemead		Waltham		Carmichael		Fort Worth		Washington		Sacramento		Shingle Springs		Rocklin		Anaheim		Granite Bay		Sacramento		Sacramento		El Cajon		Auburn		Lincoln		Rocklin		Lincoln		Colfax		Seattle		Sacramento		Sacramento		Rocklin		Sacramento		Hilmar		Sacramento		Sacramento		Roseville		Sacramento		Sacramento		Georgetown		Sacramento		Sacramento		Los Angeles		Sacramento		Rocklin		Sacramento		Rocklin		Orinda		Oakland		Napa		Rocklin		Rocklin		Livermore		Rocklin		San Diego		Sacramento		Granite Bay		Rocklin		West Sacramento		Sacramento		Citrus Heights		Diamond Bar		El Segundo		Roseville		Sacramento		Washington		Sacramento		Los Angeles		Sacramento		San Rafael		Sacramento		Sacramento		Rosemead		Waltham		Carmichael		Fort Worth		Washington		Sacramento		Shingle Springs		Rocklin		Anaheim		Granite Bay		Sacramento		Sacramento		El Cajon		Lincoln		Rocklin		Lincoln		Colfax
ctrib_st		WA		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		DC		CA		CA		CA		CA		CA		CA		CA		MA		CA		TX		DC		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		WA		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		DC		CA		CA		CA		CA		CA		CA		CA		MA		CA		TX		DC		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
ctrib_zip4		98105		95820		95814		95765		95814		95324		95814		95814		95747		95814		95814		95634		95833		95834		90071		95814		95677		95814		95677		94563		94607		94558		95765		95765		94551		95765		92119		95814		95746		95765		95691		95814		95621		91765		90245		95747		95814		20004		95814		90040		95814		94913		95814		95833		91770		02451		95608		76131		20005		95816		95682		95677		92808		95746		95811		95814		92019		95603		95648		95677		95648		95713		98105		95820		95814		95765		95814		95324		95814		95814		95747		95814		95814		95634		95833		95834		90071		95814		95677		95814		95677		94563		94607		94558		95765		95765		94551		95765		92119		95814		95746		95765		95691		95814		95621		91765		90245		95747		95814		20004		95814		90040		95814		94913		95814		95833		91770		02451		95608		76131		20005		95816		95682		95677		92808		95746		95811		95814		92019		95648		95677		95648		95713
ctrib_emp		Amazon		State of California		None		Retired		None		None		None		None		Retired		None		None		Retired		None		None		None		None		n/a		None		None		Kaufhold Gaskin Gallagher LLP		None		None		Guidant Realty		None		None		n/a		None		None		Pacific Capital Management		City of Rocklin		None		None		None		None		None		Retired		None		# C00284885		None		None		None		None		None		None		None		None		n/a		None		None		California Medical Association		SAS Institute		None		None		Sutter Health		None		None		None		None		n/a		n/a		Rita Piziali (Self-Employed)		None		Amazon		State of California		None		Retired		None		None		None		None		Retired		None		None		Retired		None		None		None		None		n/a		None		None		Kaufhold Gaskin Gallagher LLP		None		None		Guidant Realty		None		None		n/a		None		None		Pacific Capital Management		City of Rocklin		None		None		None		None		None		Retired		None		# C00284885		None		None		None		None		None		None		None		None		n/a		None		None		California Medical Association		SAS Institute		None		None		Sutter Health		None		None		None		n/a		n/a		Rita Piziali (Self-Employed)		None
ctrib_occ		Writer		Legislative Staff		None		Retired		None		None		None		None		Retired		None		None		Retired		None		None		None		None		Retired		None		None		Lawyer		None		None		Realtor		None		None		Retired		None		None		Real Estate Investor		Project Director		None		None		None		None		None		Retired		None		Federal PAC		None		None		None		None		None		None		None		None		Retired		None		None		Fundraiser		Public Sector Technology and Innovation		None		None		Physician		None		None		None		None		Retired		Retired		Consultant		None		Writer		Legislative Staff		None		Retired		None		None		None		None		Retired		None		None		Retired		None		None		None		None		Retired		None		None		Lawyer		None		None		Realtor		None		None		Retired		None		None		Real Estate Investor		Project Director		None		None		None		None		None		Retired		None		Federal PAC		None		None		None		None		None		None		None		None		Retired		None		None		Fundraiser		Public Sector Technology and Innovation		None		None		Physician		None		None		None		Retired		Retired		Consultant		None
ctrib_self		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		X		X		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		X		X		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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-01 00:00:00		2022-07-01 00:00:00		2022-07-08 00:00:00		2022-07-11 00:00:00		2022-07-18 00:00:00		2022-07-22 00:00:00		2022-07-25 00:00:00		2022-07-26 00:00:00		2022-07-30 00:00:00		2022-08-02 00:00:00		2022-08-08 00:00:00		2022-08-09 00:00:00		2022-08-11 00:00:00		2022-08-11 00:00:00		2022-08-12 00:00:00		2022-08-12 00:00:00		2022-08-15 00:00:00		2022-08-17 00:00:00		2022-08-17 00:00:00		2022-08-21 00:00:00		2022-08-22 00:00:00		2022-08-23 00:00:00		2022-08-23 00:00:00		2022-08-23 00:00:00		2022-08-23 00:00:00		2022-08-24 00:00:00		2022-08-25 00:00:00		2022-08-25 00:00:00		2022-08-25 00:00:00		2022-08-25 00:00:00		2022-08-26 00:00:00		2022-08-26 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-01 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-08 00:00:00		2022-09-12 00:00:00		2022-09-12 00:00:00		2022-09-14 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-22 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-23 00:00:00		2022-09-24 00:00:00		2022-09-24 00:00:00		2022-09-16 00:00:00		2022-07-01 00:00:00		2022-07-01 00:00:00		2022-07-08 00:00:00		2022-07-11 00:00:00		2022-07-18 00:00:00		2022-07-22 00:00:00		2022-07-25 00:00:00		2022-07-26 00:00:00		2022-07-30 00:00:00		2022-08-02 00:00:00		2022-08-08 00:00:00		2022-08-09 00:00:00		2022-08-11 00:00:00		2022-08-11 00:00:00		2022-08-12 00:00:00		2022-08-12 00:00:00		2022-08-15 00:00:00		2022-08-17 00:00:00		2022-08-17 00:00:00		2022-08-21 00:00:00		2022-08-22 00:00:00		2022-08-23 00:00:00		2022-08-23 00:00:00		2022-08-23 00:00:00		2022-08-23 00:00:00		2022-08-24 00:00:00		2022-08-25 00:00:00		2022-08-25 00:00:00		2022-08-25 00:00:00		2022-08-25 00:00:00		2022-08-26 00:00:00		2022-08-26 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-01 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-08 00:00:00		2022-09-12 00:00:00		2022-09-12 00:00:00		2022-09-14 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-22 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-09-24 00:00:00		2022-09-16 00:00:00
date_thru		2016-09-12 00:00:00		2016-09-12 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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2016-09-12 00:00:00		2016-09-12 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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
amount		84		205		1000		100		1000		2000		4900		4900		25		1500		1000		250		3500		2000		9700		2500		1000		4900		1500		1000		4900		1500		100		1000		4900		400		1000		1500		500		100		2000		1500		2500		1000		4900		25		4850		2000		4900		2000		2000		2000		1000		2500		2000		2000		500		4000		1500		100		150		150		3000		250		4900		4900		1500		100		150		100		100		37		84		205		1000		100		1000		2000		4900		4900		25		1500		1000		250		3500		2000		9700		2500		1000		4900		1500		1000		4900		1500		100		1000		4900		400		1000		1500		500		100		2000		1500		2500		1000		4900		25		4850		2000		4900		2000		2000		2000		1000		2500		2000		2000		500		4000		1500		100		150		150		3000		250		4900		4900		1500		150		100		100		37
cum_ytd		500		205		2250		200		1000		2000		4900		9800		150		1500		1000		250		7000		11900		19400		5000		1150		4900		4000		1000		9800		1500		100		1000		9800		400		1000		2250		500		100		4000		1500		2500		1000		9800		150		9700		2000		9800		6900		2000		2000		1000		7000		2000		2000		500		4000		1500		100		150		150		7900		250		9800		4900		1500		225		150		100		100		5461		500		205		2250		200		1000		2000		4900		9800		150		1500		1000		250		7000		11900		19400		5000		1150		4900		4000		1000		9800		1500		100		1000		9800		400		1000		2250		500		100		4000		1500		2500		1000		9800		150		9700		2000		9800		6900		2000		2000		1000		7000		2000		2000		500		4000		1500		100		150		150		7900		250		9800		4900		1500		150		100		100		5461
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
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		In-kind: Printing of Voter Guide delivered door to door.		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		In-kind: Printing of Voter Guide delivered door to door.
cmte_id		None		None		950352		None		920780		1435439		None		746138		None		811596		761487		None		744058		810830		890106		891390		None		742617		None		None		None		923140		None		None		850381		None		870598		1302433		None		None		980194		1272633		None		None		None		None		902770		1409634		742422		None		478036		1434406		1238271		744058		None		None		None		None		None		None		None		1360300		None		None		None		840819		None		None		None		None		None		743461		None		None		950352		None		920780		1435439		None		746138		None		811596		761487		None		744058		810830		890106		891390		None		742617		None		None		None		923140		None		None		850381		None		870598		1302433		None		None		980194		1272633		None		None		None		None		902770		1409634		742422		None		478036		1434406		1238271		744058		None		None		None		None		None		None		None		1360300		None		None		None		840819		None		None		None		None		743461
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
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
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
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
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
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
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
intr_naml		Joe Patterson for Rocklin City Council 2020		Joe Patterson for Rocklin City Council 2020		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Joe Patterson for Rocklin City Council 2020		Joe Patterson for Rocklin City Council 2020		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		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		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		None
intr_city		Rocklin		Rocklin		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Rocklin		Rocklin		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		CA		CA		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		CA		CA		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		95765		95765		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		95765		95765		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		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		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		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		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
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
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
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		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
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		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		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
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
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
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
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
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		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
memo_refno		None		None		None		None		None		None		INC636		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		INC636		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
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		None
intr_cmteid		1388707		1388707		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1388707		1388707		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047
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		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		22A		22B		1		2		3		1		2		3		1		2		3		4		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		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		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		C		C		C		I		I		I		I		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		C		C		C		I		I		I		I		D		D		D		E		E		E		E		F		F		F		B1		B1		B1		H		H		H
amount_a		117963		0		117963		37		118000		75741		0		75741		-21427		37		54351		38272		117963		42		75741		80536		0		0		13690		384054		376023		39930		333745		117439		524		117963		37		0		37		0		42		0		42		5400		0		5400		75741		0		0		75741		3690		25117		-21427		0		0		0		0		0		0		118063		0		118063		37		118100		75741		0		75741		-21427		37		54351		38272		118063		42		75741		80636		0		0		13690		384054		376023		39930		333745		117539		524		118063		37		0		37		0		42		0		42		5400		0		5400		75741		0		0		75741		3690		25117		-21427		0		0		0		0		0		0
amount_b		485956		10000		495956		6099		502054		420585		0		420585		3690		6099		430373		None		None		None		None		None		None		None		None		118000		79468		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		486056		10000		496056		6099		502154		420585		0		420585		3690		6099		430373		None		None		None		None		None		None		None		None		118100		79468		None		None		None		None		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		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		None		None		None		None		None		None		None		2022-11-08 00:00:00		2022-06-07 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: splt

filing_id		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047		2726047
amend_id		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		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		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		87		88		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		20		21		22		23		24		25		26		27		28		29		30		31		32		33		34		35		36		37		38		39		40		41		42		43		44		45		46		47		48		49		50		51		52		53		54		55		56		57		58		59		60		61		62		63		64		65		66		67		68		69		70		71		72		73		74		75		76		77		78		79		80		81		82		83		84		85		86		87		88		89		90
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		C		C		D		D		B1		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		C		C		D		D		B1
ptran_id		IDT38		IDT38		IDT39		INC575		INC575		INC574		INC574		INC630		INC637		INC636		INC638		INC638		INC639		INC639		INC651		INC661		INC653		INC655		INC655		INC656		INC656		INC658		INC658		INC659		INC659		INC657		INC657		INC663		INC664		INC664		INC666		INC669		INC669		INC670		INC673		INC672		INC671		INC671		INC674		INC678		INC676		INC676		INC677		INC698		INC683		INC683		INC679		INC680		INC681		INC682		INC682		INC684		INC684		INC696		INC696		INC694		INC695		INC695		INC697		INC697		INC701		INC700		INC710		INC714		INC714		INC715		INC716		INC718		INC728		INC727		INC725		INC719		INC729		INC731		INC731		INC730		INC740		INC740		INC739		INC738		INC732		INC733		INC735		NON741		NON741		EXP688		EXP662		PAY54		IDT38		IDT38		IDT39		INC575		INC575		INC574		INC574		INC630		INC637		INC636		INC638		INC638		INC639		INC639		INC651		INC661		INC653		INC655		INC655		INC656		INC656		INC658		INC658		INC659		INC659		INC657		INC657		INC663		INC664		INC664		INC666		INC669		INC669		INC670		INC673		INC672		INC671		INC671		INC674		INC678		INC676		INC676		INC677		INC698		INC683		INC683		INC679		INC680		INC681		INC682		INC682		INC684		INC684		INC696		INC696		INC694		INC695		INC695		INC697		INC697		INC701		INC700		INC710		INC714		INC714		INC715		INC716		INC718		INC728		INC727		INC725		INC719		INC729		INC731		INC731		INC730		INC740		INC740		INC739		INC738		INC788		INC788		INC732		INC733		INC735		NON741		NON741		EXP688		EXP662		PAY54
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		2022-01-01 00:00:00		2022-01-01 00:00:00		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		416		84		205		1250		1000		100		100		1000		2000		4900		4900		4900		75		75		1500		1000		250		1000		6000		9700		2200		9700		9700		2500		2500		150		1000		4900		2500		1500		1000		4900		4900		1500		100		1000		4900		4900		400		1000		750		1500		500		100		2000		2000		1500		2500		1000		4900		4900		75		75		4850		4850		2000		4900		4900		4900		2000		2000		2000		1000		1000		6000		2000		2000		500		4000		1500		100		150		150		4900		3000		250		4900		4900		4900		1500		150		100		100		5423		37		500		4900		10003		416		84		205		1250		1000		100		100		1000		2000		4900		4900		4900		75		75		1500		1000		250		1000		6000		9700		2200		9700		9700		2500		2500		150		1000		4900		2500		1500		1000		4900		4900		1500		100		1000		4900		4900		400		1000		750		1500		500		100		2000		2000		1500		2500		1000		4900		4900		75		75		4850		4850		2000		4900		4900		4900		2000		2000		2000		1000		1000		6000		2000		2000		500		4000		1500		100		150		150		4900		3000		250		4900		4900		4900		1500		125		100		150		100		100		5423		37		500		4900		10003
elec_code		P		G		G		P		G		P		G		G		G		P		P		G		P		G		G		G		G		P		G		P		G		P		G		P		G		P		G		G		P		G		G		P		G		G		G		G		P		G		G		G		P		G		G		G		P		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		G		G		G		P		G		G		P		G		G		G		G		G		G		P		G		G		G		P		P		G		G		P		G		P		G		G		G		P		P		G		P		G		G		G		G		P		G		P		G		P		G		P		G		P		G		G		P		G		G		P		G		G		G		G		P		G		G		G		P		G		G		G		P		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		G		G		G		P		G		G		P		G		G		G		P		G		G		G		G		P		G		G		G		P