Home

Filing ID: 2743403

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

Table: cvr2_campaign_disclosure

filing_id		2743403		2743403		2743403		2743403
amend_id		0		0		1		1
line_item		1		2		1		2
rec_type		CVR2		CVR2		CVR2		CVR2
form_type		F460		F460		F460		F460
tran_id		OFC1		NIC3		OFC1		NIC3
entity_cd		ATR		COM		ATR		COM
title		None		None		None		None
mail_city		None		None		None		None
mail_st		None		None		None		None
mail_zip4		None		None		None		None
f460_part		3		5b		3		5b
cmte_id		None		1447582		None		1447582
enty_naml		Deane		Fighting for Working Families, Tim Grayson Ballot Measure Committee		Deane		Fighting for Working Families, Tim Grayson Ballot Measure Committee
enty_namf		Shawnda		None		Shawnda		None
enty_namt		None		None		None		None
enty_nams		None		None		None		None
enty_city		Sacramento		Sacramento		Sacramento		Sacramento
enty_st		CA		CA		CA		CA
enty_zip4		95815		95815		95815		95815
enty_phon		(916) 285-5733		(916)285-5733		(916) 285-5733		(916)285-5733
enty_fax		None		None		None		None
enty_email		None		None		None		None
tres_naml		None		Grayson		None		Grayson
tres_namf		None		Tim		None		Tim
tres_namt		None		None		None		None
tres_nams		None		None		None		None
control_yn		None		Y		None		Y
office_cd		None		None		None		None
offic_dscr		None		None		None		None
juris_cd		None		None		None		None
juris_dscr		None		None		None		None
dist_no		None		None		None		None
off_s_h_cd		None		None		None		None
bal_name		None		None		None		None
bal_num		None		None		None		None
bal_juris		None		None		None		None
sup_opp_cd		None		None		None		None

Table: cvr3_verification_info

filing_id		2743403		2743403		2743403		2743403
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		ATR		CAO		ATR		CAO
sig_date		2022-10-26 00:00:00		2022-10-26 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00
sig_loc		None		None		None		None
sig_naml		Shawnda Deane		Tim Grayson		Shawnda Deane		Tim Grayson
sig_namf		None		None		None		None
sig_namt		None		None		None		None
sig_nams		None		None		None		None

Table: cvr_campaign_disclosure

filing_id		2743403		2743403
amend_id		1		0
rec_type		CVR		CVR
form_type		F460		F460
filer_id		1434632		1434632
entity_cd		CTL		CTL
filer_naml		Tim Grayson for Assembly 2022		Tim Grayson for Assembly 2022
filer_namf		None		None
filer_namt		None		None
filer_nams		None		None
report_num		001		000
rpt_date		2022-11-08 00:00:00		2022-10-26 00:00:00
stmt_type		PE		PE
late_rptno		None		None
from_date		2022-09-25 00:00:00		2022-09-25 00:00:00
thru_date		2022-10-22 00:00:00		2022-10-22 00:00:00
elect_date		2022-11-08 00:00:00		2022-11-08 00:00:00
filer_city		Concord		Concord
filer_st		CA		CA
filer_zip4		94521		94521
filer_phon		(925) 674-3634		(925) 674-3634
filer_fax		None		None
file_email		Grayson2022@deaneandcompany.com		Grayson2022@deaneandcompany.com
mail_city		Sacramento		Sacramento
mail_st		CA		CA
mail_zip4		95815		95815
tres_naml		Grayson		Grayson
tres_namf		Tim		Tim
tres_namt		None		None
tres_nams		None		None
tres_city		Concord		Concord
tres_st		CA		CA
tres_zip4		94521		94521
tres_phon		(925) 674-3634		(925) 674-3634
tres_fax		None		None
tres_email		None		None
cmtte_type		C		C
control_yn		Y		Y
sponsor_yn		N		N
primfrm_yn		None		None
brdbase_yn		None		None
amendexp_1		Update Sch. G		None
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		Grayson		Grayson
cand_namf		Tim		Tim
cand_namt		None		None
cand_nams		None		None
cand_city		Concord		Concord
cand_st		CA		CA
cand_zip4		94521		94521
cand_phon		(925) 674-3634		(925) 674-3634
cand_fax		None		None
cand_email		None		None
bal_name		None		None
bal_num		None		None
bal_juris		None		None
office_cd		ASM		ASM
offic_dscr		None		None
juris_cd		ASM		ASM
juris_dscr		None		None
dist_no		15		15
off_s_h_cd		H		H
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		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403
amend_id		1		1		1		1		1		1		0		0		0		0		0		0
line_item		1		2		3		4		5		6		1		2		3		4		5		6
rec_type		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT
form_type		F		F		F		F		F		F		F		F		F		F		F		F
tran_id		PAY954		PAY1014		PAY1066		PAY1094		PAY1123		PAY1040		PAY954		PAY1014		PAY1066		PAY1094		PAY1123		PAY1040
entity_cd		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH
payee_naml		Elan Financial Services		Elan Financial Services		Elan Financial Services		H & S Signs, LLC		Jacobson & Zilber Strategies, LLC		Powers Interactive Digital, LLC		Elan Financial Services		Elan Financial Services		Elan Financial Services		H & S Signs, LLC		Jacobson & Zilber Strategies, LLC		Powers Interactive Digital, LLC
payee_namf		None		None		None		None		None		None		None		None		None		None		None		None
payee_namt		None		None		None		None		None		None		None		None		None		None		None		None
payee_nams		None		None		None		None		None		None		None		None		None		None		None		None
payee_city		Irving		Irving		Irving		Grass Valley		Los Angeles		Lower Gwynedd		Irving		Irving		Irving		Grass Valley		Los Angeles		Lower Gwynedd
payee_st		TX		TX		TX		CA		CA		PA		TX		TX		TX		CA		CA		PA
payee_zip4		75038		75038		75038		95945		90027		19002		75038		75038		75038		95945		90027		19002
beg_bal		3564		683		0		4581		2903		57500		3564		683		0		4581		2903		57500
amt_incur		0		0		5620		0		0		0		0		0		5620		0		0		0
amt_paid		3564		683		0		4581		2903		57500		3564		683		0		4581		2903		57500
end_bal		0		0		5620		0		0		0		0		0		5620		0		0		0
expn_code		None		None		None		CMP		TRS		None		None		None		None		CMP		TRS		None
expn_dscr		Credit Card Payment		Credit Card Payment		Credit Card Payment		None		9/6/22-9/7/22, Media Production Travel Expenses, 6		Digital Media		Credit Card Payment		Credit Card Payment		Credit Card Payment		None		9/6/22-9/7/22, Media Production Travel Expenses, 6		Digital Media
cmte_id		None		None		None		None		None		None		None		None		None		None		None		None
tres_naml		None		None		None		None		None		None		None		None		None		None		None		None
tres_namf		None		None		None		None		None		None		None		None		None		None		None		None
tres_namt		None		None		None		None		None		None		None		None		None		None		None		None
tres_nams		None		None		None		None		None		None		None		None		None		None		None		None
tres_city		None		None		None		None		None		None		None		None		None		None		None		None
tres_st		None		None		None		None		None		None		None		None		None		None		None		None
tres_zip4		None		None		None		None		None		None		None		None		None		None		None		None
memo_code		None		None		None		None		None		None		None		None		None		None		None		None
memo_refno		None		None		None		None		None		None		None		None		None		None		None		None
bakref_tid		None		None		None		None		None		None		None		None		None		None		None		None
xref_schnm		None		None		None		None		None		None		None		None		None		None		None		None
xref_match		None		None		None		None		None		None		None		None		None		None		None		None

Table: expn

filing_id		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403
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		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		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		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
rec_type		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN
form_type		D		D		D		D		D		D		D		D		D		D		D		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		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		D		D		D		D		D		D		D		D		D		D		D		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		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G
tran_id		EXP1087		EXP1113		EXP1088		EXP1109		EXP1089		EXP1063		EXP1107		EXP1074		EXP1072		EXP1108		EXP1075		EXP1071		EXP1114		EXP1096		EXP1087		EXP1113		EXP1088		EXP1109		EXP1089		EXP1056		EXP1057		EXP1078		EXP1080		EXP1084		EXP1112		EXP1063		EXP1107		EXP1038		EXP1115		EXP1117		EXP1099		EXP1046		EXP1091		EXP1055		EXP1124		EXP1074		EXP1072		EXP1054		EXP1098		EXP1108		EXP1043		EXP1079		EXP1075		EXP1071		EXP1045		EXP1090		EXP1059		EXP1114		EDT115		EDT114		EDT113		PDT108		PDT92		PDT95		PDT96		PDT97		PDT98		PDT99		PDT100		PDT101		PDT102		PDT103		PDT104		PDT105		PDT106		PDT94		PDT109		PDT91		PDT93		PDT107		EDT103		EDT112		EDT107		EDT104		EDT108		EDT109		EDT110		EDT111		EXP1087		EXP1113		EXP1088		EXP1109		EXP1089		EXP1063		EXP1107		EXP1074		EXP1072		EXP1108		EXP1075		EXP1071		EXP1114		EXP1096		EXP1087		EXP1113		EXP1088		EXP1109		EXP1089		EXP1056		EXP1057		EXP1078		EXP1080		EXP1084		EXP1112		EXP1063		EXP1107		EXP1038		EXP1115		EXP1117		EXP1099		EXP1046		EXP1091		EXP1055		EXP1124		EXP1074		EXP1072		EXP1054		EXP1098		EXP1108		EXP1043		EXP1079		EXP1075		EXP1071		EXP1045		EXP1090		EXP1059		EXP1114		EDT115		EDT114		EDT113		PDT108		PDT92		PDT95		PDT96		PDT97		PDT98		PDT99		PDT100		PDT101		PDT102		PDT103		PDT104		PDT105		PDT106		PDT94		PDT109		PDT91		PDT93		PDT107		EDT103		EDT112		EDT107		EDT104		EDT108		EDT109		EDT110		EDT111		EDT118		EDT117
entity_cd		COM		COM		COM		COM		COM		None		None		COM		COM		COM		COM		COM		COM		OTH		COM		COM		COM		COM		COM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		COM		COM		OTH		OTH		COM		OTH		OTH		COM		COM		OTH		OTH		OTH		COM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		IND		IND		OTH		OTH		IND		IND		OTH		OTH		COM		COM		COM		COM		COM		None		None		COM		COM		COM		COM		COM		COM		OTH		COM		COM		COM		COM		COM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		COM		COM		OTH		OTH		COM		OTH		OTH		COM		COM		OTH		OTH		OTH		COM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		IND		IND		OTH		OTH		IND		IND		OTH		OTH		OTH		OTH
payee_naml		California Democratic Party		Christina Strawbridge for City Council 2022		Christy Holstege for Assembly 2022		Committee to Re-Elect Dr. Woolridge for Pittsburg Unified School District Trustee 2022		Concord Police Association PAC		Democratic Party of Contra Costa County		Democratic Party of Contra Costa County		Ken Carlson for County Supervisor 2022		Kim Trupiano for Clayton City Council 2022		Malia Cohen for Controller 2022		Robert Ring for City Council 2022		Scales-Preston for Pittsburg City Council 2022		Zac Shess for Pleasant Hill City Council 2022		ActBlue Technical Services		California Democratic Party		Christina Strawbridge for City Council 2022		Christy Holstege for Assembly 2022		Committee to Re-Elect Dr. Woolridge for Pittsburg Unified School District Trustee 2022		Concord Police Association PAC		Convergence Targeted Communications		Convergence Targeted Communications		Deane & Company		Deane & Company		Deane & Company		Deane & Company		Democratic Party of Contra Costa County		Democratic Party of Contra Costa County		Elan Financial Services		Elan Financial Services		Elan Financial Services		H & S Signs, LLC		Intuit, Inc.		Intuit, Inc.		Jacobson & Zilber Strategies, LLC		Jacobson & Zilber Strategies, LLC		Ken Carlson for County Supervisor 2022		Kim Trupiano for Clayton City Council 2022		LAC, Inc.		Levy Restaurants at Sonoma Raceway		Malia Cohen for Controller 2022		Powers Interactive Digital, LLC		Powers Interactive Digital, LLC		Robert Ring for City Council 2022		Scales-Preston for Pittsburg City Council 2022		United States Treasury		United States Treasury		Uplift		Zac Shess for Pleasant Hill City Council 2022		Political Data Intelligence (PDI)		River City Printers, LLC		U.S. Postmaster		Canva		Emerge California		Fairfield Inn & Suites		Fairfield Inn & Suites		Fairfield Inn & Suites		Fairfield Inn & Suites		Fairfield Inn & Suites		Fairfield Inn & Suites		Fairfield Inn & Suites		Fairfield Inn & Suites		Fairfield Inn & Suites		Fairfield Inn & Suites		Fairfield Inn & Suites		Fairfield Inn & Suites		Rok Steakhouse & Grill		The UPS Store		Topgolf		Topgolf		Wreaths Across America		Detmer		Detmer		DTC Lighting and Grip		Faced by Janea		Garcia		Kozsela		Namares, Inc.		Znapfly		California Democratic Party		Christina Strawbridge for City Council 2022		Christy Holstege for Assembly 2022		Committee to Re-Elect Dr. Woolridge for Pittsburg Unified School District Trustee 2022		Concord Police Association PAC		Democratic Party of Contra Costa County		Democratic Party of Contra Costa County		Ken Carlson for County Supervisor 2022		Kim Trupiano for Clayton City Council 2022		Malia Cohen for Controller 2022		Robert Ring for City Council 2022		Scales-Preston for Pittsburg City Council 2022		Zac Shess for Pleasant Hill City Council 2022		ActBlue Technical Services		California Democratic Party		Christina Strawbridge for City Council 2022		Christy Holstege for Assembly 2022		Committee to Re-Elect Dr. Woolridge for Pittsburg Unified School District Trustee 2022		Concord Police Association PAC		Convergence Targeted Communications		Convergence Targeted Communications		Deane & Company		Deane & Company		Deane & Company		Deane & Company		Democratic Party of Contra Costa County		Democratic Party of Contra Costa County		Elan Financial Services		Elan Financial Services		Elan Financial Services		H & S Signs, LLC		Intuit, Inc.		Intuit, Inc.		Jacobson & Zilber Strategies, LLC		Jacobson & Zilber Strategies, LLC		Ken Carlson for County Supervisor 2022		Kim Trupiano for Clayton City Council 2022		LAC, Inc.		Levy Restaurants at Sonoma Raceway		Malia Cohen for Controller 2022		Powers Interactive Digital, LLC		Powers Interactive Digital, LLC		Robert Ring for City Council 2022		Scales-Preston for Pittsburg City Council 2022		United States Treasury		United States Treasury		Uplift		Zac Shess for Pleasant Hill City Council 2022		Political Data Intelligence (PDI)		River City Printers, LLC		U.S. Postmaster		Canva		Emerge California		Fairfield Inn & Suites		Fairfield Inn & Suites		Fairfield Inn & Suites		Fairfield Inn & Suites		Fairfield Inn & Suites		Fairfield Inn & Suites		Fairfield Inn & Suites		Fairfield Inn & Suites		Fairfield Inn & Suites		Fairfield Inn & Suites		Fairfield Inn & Suites		Fairfield Inn & Suites		Rok Steakhouse & Grill		The UPS Store		Topgolf		Topgolf		Wreaths Across America		Detmer		Detmer		DTC Lighting and Grip		Faced by Janea		Garcia		Kozsela		Namares, Inc.		Znapfly		Datorama		Saguaro Strategies, LLC
payee_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Audrey N.		Audrey N.		None		None		Marcos E. Nieves		Randy		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Audrey N.		Audrey N.		None		None		Marcos E. Nieves		Randy		None		None		None		None
payee_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_city		Sacramento		Benicia		Sacramento		Pittsburg		Sacramento		Antelope		Antelope		Oakland		Clayton		Sacramento		Hilmar		Pittsburg		Pleasant Hill		Cambridge		Sacramento		Benicia		Sacramento		Pittsburg		Sacramento		Washington		Washington		Sacramento		Sacramento		Sacramento		Sacramento		Antelope		Antelope		Irving		Irving		Irving		Grass Valley		Mountain View		Mountain View		Los Angeles		Los Angeles		Oakland		Clayton		Sacramento		Sonoma		Sacramento		Lower Gwynedd		Lower Gwynedd		Hilmar		Pittsburg		Ogden		Ogden		Berkeley		Pleasant Hill		Long Beach		Sacramento		Sacramento		Surry Hills		Sacramento		Alviso		Alviso		Alviso		Alviso		Alviso		Alviso		Alviso		Alviso		Alviso		Alviso		Alviso		Alviso		San Jose		Sacramento		Alviso		Alviso		Columbia Falls		West Sacramento		West Sacramento		Emeryville		Oakland		Los Angeles		Simi Valley		Los Angeles		Vacaville		Sacramento		Benicia		Sacramento		Pittsburg		Sacramento		Antelope		Antelope		Oakland		Clayton		Sacramento		Hilmar		Pittsburg		Pleasant Hill		Cambridge		Sacramento		Benicia		Sacramento		Pittsburg		Sacramento		Washington		Washington		Sacramento		Sacramento		Sacramento		Sacramento		Antelope		Antelope		Irving		Irving		Irving		Grass Valley		Mountain View		Mountain View		Los Angeles		Los Angeles		Oakland		Clayton		Sacramento		Sonoma		Sacramento		Lower Gwynedd		Lower Gwynedd		Hilmar		Pittsburg		Ogden		Ogden		Berkeley		Pleasant Hill		Long Beach		Sacramento		Sacramento		Surry Hills		Sacramento		Alviso		Alviso		Alviso		Alviso		Alviso		Alviso		Alviso		Alviso		Alviso		Alviso		Alviso		Alviso		San Jose		Sacramento		Alviso		Alviso		Columbia Falls		West Sacramento		West Sacramento		Emeryville		Oakland		Los Angeles		Simi Valley		Los Angeles		Vacaville		San Francisco		Berkeley
payee_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		MA		CA		CA		CA		CA		CA		DC		DC		CA		CA		CA		CA		CA		CA		TX		TX		TX		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		PA		PA		CA		CA		UT		UT		CA		CA		CA		CA		CA		AU		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		ME		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		MA		CA		CA		CA		CA		CA		DC		DC		CA		CA		CA		CA		CA		CA		TX		TX		TX		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		PA		PA		CA		CA		UT		UT		CA		CA		CA		CA		CA		AU		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		ME		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
payee_zip4		95811		94510		95815		94565		95814		95843		95843		94607		94517		95815		95324		94565		94523		02138		95811		94510		95815		94565		95814		20036		20036		95815		95815		95815		95815		95843		95843		75038		75038		75038		95945		94043		94043		90027		90027		94607		94517		95814		95476		95815		19002		19002		95324		94565		84201		84201		94704		94523		90806		95834		95813		02010		95815		95002		95002		95002		95002		95002		95002		95002		95002		95002		95002		95002		95002		95134		95816		95002		95002		04623		95691		95691		94608		94605		90029		93063		90028		95688		95811		94510		95815		94565		95814		95843		95843		94607		94517		95815		95324		94565		94523		02138		95811		94510		95815		94565		95814		20036		20036		95815		95815		95815		95815		95843		95843		75038		75038		75038		95945		94043		94043		90027		90027		94607		94517		95814		95476		95815		19002		19002		95324		94565		84201		84201		94704		94523		90806		95834		95813		02010		95815		95002		95002		95002		95002		95002		95002		95002		95002		95002		95002		95002		95002		95134		95816		95002		95002		04623		95691		95691		94608		94605		90029		93063		90028		95688		94105		94704
expn_date		2022-10-12 00:00:00		2022-10-22 00:00:00		2022-10-12 00:00:00		2022-10-19 00:00:00		2022-10-12 00:00:00		2022-10-06 00:00:00		2022-10-19 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-19 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-22 00:00:00		2022-10-09 00:00:00		2022-10-12 00:00:00		2022-10-22 00:00:00		2022-10-12 00:00:00		2022-10-19 00:00:00		2022-10-12 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-21 00:00:00		2022-10-06 00:00:00		2022-10-19 00:00:00		2022-09-25 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00		2022-10-13 00:00:00		2022-09-30 00:00:00		2022-10-14 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-04 00:00:00		2022-10-13 00:00:00		2022-10-19 00:00:00		2022-09-28 00:00:00		2022-10-11 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-09-30 00:00:00		2022-10-14 00:00:00		2022-10-06 00:00:00		2022-10-22 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-17 00:00:00		2022-10-05 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-06 00:00:00		2022-10-19 00:00:00		2022-09-27 00:00:00		2022-10-06 00:00:00		2022-10-11 00:00:00		2022-09-30 00:00:00		2022-10-14 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-12 00:00:00		2022-10-22 00:00:00		2022-10-12 00:00:00		2022-10-19 00:00:00		2022-10-12 00:00:00		2022-10-06 00:00:00		2022-10-19 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-19 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-22 00:00:00		2022-10-09 00:00:00		2022-10-12 00:00:00		2022-10-22 00:00:00		2022-10-12 00:00:00		2022-10-19 00:00:00		2022-10-12 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-21 00:00:00		2022-10-06 00:00:00		2022-10-19 00:00:00		2022-09-25 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00		2022-10-13 00:00:00		2022-09-30 00:00:00		2022-10-14 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-04 00:00:00		2022-10-13 00:00:00		2022-10-19 00:00:00		2022-09-28 00:00:00		2022-10-11 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-09-30 00:00:00		2022-10-14 00:00:00		2022-10-06 00:00:00		2022-10-22 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-17 00:00:00		2022-10-05 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-06 00:00:00		2022-10-19 00:00:00		2022-09-27 00:00:00		2022-10-06 00:00:00		2022-10-11 00:00:00		2022-09-30 00:00:00		2022-10-14 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00
amount		20000		500		4900		1500		5000		3000		3000		2000		1500		4900		1500		1500		500		10		20000		500		4900		1500		5000		17101		42556		75		75		3125		75		3000		3000		3564		683		355		4581		450		450		16970		2903		2000		1500		10883		1150		4900		57500		20000		1500		1500		91		91		3000		500		1150		13624		17101		13		500		281		281		281		281		281		281		281		281		281		281		281		366		818		237		355		100		498		448		448		1976		500		4206		1620		1300		700		20000		500		4900		1500		5000		3000		3000		2000		1500		4900		1500		1500		500		10		20000		500		4900		1500		5000		17101		42556		75		75		3125		75		3000		3000		3564		683		355		4581		450		450		16970		2903		2000		1500		10883		1150		4900		57500		20000		1500		1500		91		91		3000		500		1150		13624		17101		13		500		281		281		281		281		281		281		281		281		281		281		281		366		818		237		355		100		498		448		448		1976		500		4206		1620		1300		700		1500		3000
cum_ytd		102150		500		4900		1500		5000		9000		9000		2000		1500		4900		1500		1500		500		706		102150		500		4900		1500		5000		76381		76381		27729		27729		27729		27729		9000		9000		22431		22431		22431		9163		11445		11445		37638		37638		2000		1500		99768		1150		4900		152500		152500		1500		1500		2794		2794		17129		500		1150		13624		21877		130		500		3454		3454		3454		3454		3454		3454		3454		3454		3454		3454		3454		3454		818		511		710		710		498		7206		7206		1976		500		4206		1620		1300		700		102150		500		4900		1500		5000		9000		9000		2000		1500		4900		1500		1500		500		706		102150		500		4900		1500		5000		76381		76381		27729		27729		27729		27729		9000		9000		22431		22431		22431		9163		11445		11445		37638		37638		2000		1500		99768		1150		4900		152500		152500		1500		1500		2794		2794		17129		500		1150		13624		21877		130		500		3454		3454		3454		3454		3454		3454		3454		3454		3454		3454		3454		3454		818		511		710		710		498		7206		7206		1976		500		4206		1620		1300		700		3000		3000
cum_oth		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
expn_chkno		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
expn_code		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		OFC		CTB		CTB		CTB		CTB		CTB		POS		LIT		PRO		PRO		PRO		PRO		CTB		CTB		None		None		None		CMP		SAL		SAL		TEL		TRS		CTB		CTB		FND		FND		CTB		None		None		CTB		CTB		SAL		SAL		WEB		CTB		LIT		LIT		POS		OFC		CVC		TRS		TRS		TRS		TRS		TRS		TRS		TRS		TRS		TRS		TRS		TRS		TRC		OFC		POS		OFC		OFC		CVC		SAL		SAL		TEL		TEL		TEL		TEL		TEL		TEL		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		OFC		CTB		CTB		CTB		CTB		CTB		POS		LIT		PRO		PRO		PRO		PRO		CTB		CTB		None		None		None		CMP		SAL		SAL		TEL		TRS		CTB		CTB		FND		FND		CTB		None		None		CTB		CTB		SAL		SAL		WEB		CTB		LIT		LIT		POS		OFC		CVC		TRS		TRS		TRS		TRS		TRS		TRS		TRS		TRS		TRS		TRS		TRS		TRC		OFC		POS		OFC		OFC		CVC		SAL		SAL		TEL		TEL		TEL		TEL		TEL		TEL		None		None
expn_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		Credit Card Payment		Credit Card Payment		Credit Card Payment		None		None		None		None		9/6/22-9/7/22, Media Production Travel Expenses, 6		None		None		None		10/06/22, Fundraising Event, 18, including Candidate		None		Digital Media		Digital Media		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Credit Card Payment		Credit Card Payment		Credit Card Payment		None		None		None		None		9/6/22-9/7/22, Media Production Travel Expenses, 6		None		None		None		10/06/22, Fundraising Event, 18, including Candidate		None		Digital Media		Digital Media		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Digital Media		Digital Media
agent_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Convergence Targeted Communications		Convergence Targeted Communications		Convergence Targeted Communications		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Intuit, Inc.		Intuit, Inc.		Jacobson & Zilber Strategies, LLC		Jacobson & Zilber Strategies, LLC		Jacobson & Zilber Strategies, LLC		Jacobson & Zilber Strategies, LLC		Jacobson & Zilber Strategies, LLC		Jacobson & Zilber Strategies, LLC		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Convergence Targeted Communications		Convergence Targeted Communications		Convergence Targeted Communications		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Elan Financial Services		Intuit, Inc.		Intuit, Inc.		Jacobson & Zilber Strategies, LLC		Jacobson & Zilber Strategies, LLC		Jacobson & Zilber Strategies, LLC		Jacobson & Zilber Strategies, LLC		Jacobson & Zilber Strategies, LLC		Jacobson & Zilber Strategies, LLC		Powers Interactive Digital, LLC		Powers Interactive Digital, LLC
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
agent_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cmte_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		741666		1449710		1439961		1454837		931817		None		None		None		None		None		None		990861		990861		None		None		None		None		None		None		None		None		1439757		1454147		None		None		1437983		None		None		1449993		1450648		None		None		None		1448635		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		741666		1449710		1439961		1454837		931817		None		None		None		None		None		None		990861		990861		None		None		None		None		None		None		None		None		1439757		1454147		None		None		1437983		None		None		1449993		1450648		None		None		None		1448635		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_naml		None		Christina Strawbridge		Christy Holstege		Delshawn Woolridge		None		None		None		Ken Carlson		Kim Trupiano		Malia Cohen		Robert Ring		Shanelle Scales-Preston		Zac Shess		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Christina Strawbridge		Christy Holstege		Delshawn Woolridge		None		None		None		Ken Carlson		Kim Trupiano		Malia Cohen		Robert Ring		Shanelle Scales-Preston		Zac Shess		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
office_cd		None		CCM		ASM		OTH		None		None		None		CSU		CCM		CON		CCM		CCM		CCM		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		CCM		ASM		OTH		None		None		None		CSU		CCM		CON		CCM		CCM		CCM		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
offic_dscr		None		None		None		Board Member, Pittsburg USD		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Board Member, Pittsburg USD		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_cd		None		CIT		SEN		OTH		None		None		None		OTH		OTH		STW		OTH		OTH		CIT		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		CIT		SEN		OTH		None		None		None		OTH		OTH		STW		OTH		OTH		CIT		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_dscr		None		Benicia		None		Contra Costa County		None		None		None		Contra Costa County		City of Clayton		None		City of Concord		City of Pittsburg		Pleasant Hill		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Benicia		None		Contra Costa County		None		None		None		Contra Costa County		City of Clayton		None		City of Concord		City of Pittsburg		Pleasant Hill		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		47		None		None		None		None		4		None		None		1		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		47		None		None		None		None		4		None		None		1		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
off_s_h_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_name		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_num		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_juris		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sup_opp_cd		S		S		S		S		S		S		S		S		S		S		S		S		S		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		S		S		S		S		S		S		S		S		S		S		S		S		S		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
memo_code		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
memo_refno		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bakref_tid		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
g_from_e_f		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		E		E		E		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		E		F		F		E		E		E		E		E		E		E		E		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		E		E		E		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		E		F		F		E		E		E		E		E		E		E		E		E		E
xref_schnm		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
xref_match		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filer_filings

filer_id		1434632		1434632
filing_id		2743403		2743403
period_id		251		251
form_id		F460		F460
filing_sequence		0		1
filing_date		2022-10-27 00:00:00		2022-11-08 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-09-25 00:00:00		2022-09-25 00:00:00
rpt_end		2022-10-22 00:00:00		2022-10-22 00:00:00
rpt_date		2022-10-26 00:00:00		2022-11-08 00:00:00
filing_type		22001		22001

Table: filings

filing_id		2743403
filing_type		22001

Table: hdr

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

Table: rcpt

filing_id		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403
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		1		1		1		1		1		1		1		1		1		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		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		20		21		22		23		24		25		26		27		28		29		30		31		32		33
rec_type		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		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		I		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		I
tran_id		INC1082		INC1041		INC1092		INC1110		INC1083		INC1047		INC1111		INC1058		INC1103		INC1104		INC1106		INC1062		INC1097		IDT26		INC1102		INC1050		INC1042		INC1068		INC1060		INC1101		INC1093		INC1081		INC1061		INC1052		INC1053		INC1076		INC1077		INC1069		INC1105		INC1065		INC1051		INC1070		INC1064		INC1082		INC1041		INC1092		INC1110		INC1083		INC1047		INC1111		INC1058		INC1103		INC1104		INC1106		INC1062		INC1097		IDT26		INC1102		INC1050		INC1042		INC1068		INC1060		INC1101		INC1093		INC1081		INC1061		INC1052		INC1053		INC1076		INC1077		INC1069		INC1105		INC1065		INC1051		INC1070		INC1064
entity_cd		COM		COM		COM		COM		COM		COM		COM		COM		COM		SCC		OTH		OTH		COM		IND		COM		OTH		OTH		OTH		OTH		OTH		OTH		COM		OTH		COM		COM		COM		COM		OTH		OTH		OTH		OTH		OTH		OTH		COM		COM		COM		COM		COM		COM		COM		COM		COM		SCC		OTH		OTH		COM		IND		COM		OTH		OTH		OTH		OTH		OTH		OTH		COM		OTH		COM		COM		COM		COM		OTH		OTH		OTH		OTH		OTH		OTH
ctrib_naml		Associated Builders and Contractors Northern California Chapter PAC		California Apartment Association PAC		California Dental Association PAC (CDA PAC)		California Hospital Association PAC, Sponsored by CA Association of Hospitals and Health Systems (CAHHS)		California Independent Petroleum Association (CIPAC PAC) PAC		California Medical Association PAC (CALPAC)		California Medical Association PAC (CALPAC)		California New Car Dealers Association PAC		California Optometric PAC		California State Association of Electrical Workers Small Contributor Committee		CEMEX Materials, LLC		CVS Pharmacy, Inc.		Daly for Assembly 2022		Elliot		Enterprise Holdings, Inc. PAC		Hall Equities Group - Operating		Lighthouse Public Affairs, LLC		Pechanga Band of Luiseno Indians		Populus Financial Group, Inc.		Reyes Coca-Cola Bottling, LLC and affiliated entities		Smile Direct Club, LLC		Specialty Equipment Market Association California PAC		Sunpower Corporation Systems		The California Society of Certified Public Accountants PAC		The California Society of Certified Public Accountants PAC		The Caterpillar, Inc. PAC (CATPAC) (FEC ID# C00148031)		United Parcel Service, Inc. PAC (FEC ID# C00064766)		UnitedHealth Group, Inc.		Universal Music Group, Inc.		Viejas Band of Kumeyaay Indians		Zenith Insurance Company		Zuffa, LLC		First Foundation Bank		Associated Builders and Contractors Northern California Chapter PAC		California Apartment Association PAC		California Dental Association PAC (CDA PAC)		California Hospital Association PAC, Sponsored by CA Association of Hospitals and Health Systems (CAHHS)		California Independent Petroleum Association (CIPAC PAC) PAC		California Medical Association PAC (CALPAC)		California Medical Association PAC (CALPAC)		California New Car Dealers Association PAC		California Optometric PAC		California State Association of Electrical Workers Small Contributor Committee		CEMEX Materials, LLC		CVS Pharmacy, Inc.		Daly for Assembly 2022		Elliot		Enterprise Holdings, Inc. PAC		Hall Equities Group - Operating		Lighthouse Public Affairs, LLC		Pechanga Band of Luiseno Indians		Populus Financial Group, Inc.		Reyes Coca-Cola Bottling, LLC and affiliated entities		Smile Direct Club, LLC		Specialty Equipment Market Association California PAC		Sunpower Corporation Systems		The California Society of Certified Public Accountants PAC		The California Society of Certified Public Accountants PAC		The Caterpillar, Inc. PAC (CATPAC) (FEC ID# C00148031)		United Parcel Service, Inc. PAC (FEC ID# C00064766)		UnitedHealth Group, Inc.		Universal Music Group, Inc.		Viejas Band of Kumeyaay Indians		Zenith Insurance Company		Zuffa, LLC		First Foundation Bank
ctrib_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		Marilu		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Marilu		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
ctrib_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
ctrib_city		Livermore		Sacramento		Sacramento		Sacramento		Irvine		Sacramento		Sacramento		Sacramento		Sacramento		Pasadena		West Palm Beach		Woonsocket		Sacramento		Bay Point		Saint Louis		Walnut Creek		San Francisco		Temecula		Irving		Irvine		Nashville		Diamond Bar		San Jose		San Rafael		San Rafael		Deerfield		Atlanta		Minnetonka		Woodland Hills		Alpine		Woodland Hills		Las Vegas		Irvine		Livermore		Sacramento		Sacramento		Sacramento		Irvine		Sacramento		Sacramento		Sacramento		Sacramento		Pasadena		West Palm Beach		Woonsocket		Sacramento		Bay Point		Saint Louis		Walnut Creek		San Francisco		Temecula		Irving		Irvine		Nashville		Diamond Bar		San Jose		San Rafael		San Rafael		Deerfield		Atlanta		Minnetonka		Woodland Hills		Alpine		Woodland Hills		Las Vegas		Irvine
ctrib_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		FL		RI		CA		CA		MO		CA		CA		CA		TX		CA		TN		CA		CA		CA		CA		IL		GA		MN		CA		CA		CA		NV		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		FL		RI		CA		CA		MO		CA		CA		CA		TX		CA		TN		CA		CA		CA		CA		IL		GA		MN		CA		CA		CA		NV		CA
ctrib_zip4		94551		95814		95814		95814		92618		95814		95814		95814		95816		91101		33401		02895		95815		94565		63105		94598		94133		92592		75062		92614		37219		91765		94520		94901		94901		60015		30328		55343		91367		91901		91367		89102		92612		94551		95814		95814		95814		92618		95814		95814		95814		95816		91101		33401		02895		95815		94565		63105		94598		94133		92592		75062		92614		37219		91765		94520		94901		94901		60015		30328		55343		91367		91901		91367		89102		92612
ctrib_emp		None		None		None		None		None		None		None		None		None		None		None		None		None		Marilu Elliot		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Marilu Elliot		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
ctrib_occ		None		None		None		None		None		None		None		None		None		None		None		None		None		Realtor		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Realtor		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
ctrib_self		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tran_type		None		None		None		None		None		None		None		None		None		None		None		None		None		I		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		I		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rcpt_date		2022-10-11 00:00:00		2022-09-26 00:00:00		2022-10-12 00:00:00		2022-10-19 00:00:00		2022-10-11 00:00:00		2022-09-28 00:00:00		2022-10-20 00:00:00		2022-10-04 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-17 00:00:00		2022-10-05 00:00:00		2022-10-13 00:00:00		2022-10-07 00:00:00		2022-10-14 00:00:00		2022-09-29 00:00:00		2022-09-28 00:00:00		2022-10-07 00:00:00		2022-10-05 00:00:00		2022-10-13 00:00:00		2022-10-12 00:00:00		2022-10-11 00:00:00		2022-10-05 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-07 00:00:00		2022-10-14 00:00:00		2022-10-06 00:00:00		2022-09-30 00:00:00		2022-10-07 00:00:00		2022-09-30 00:00:00		2022-10-11 00:00:00		2022-09-26 00:00:00		2022-10-12 00:00:00		2022-10-19 00:00:00		2022-10-11 00:00:00		2022-09-28 00:00:00		2022-10-20 00:00:00		2022-10-04 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-17 00:00:00		2022-10-05 00:00:00		2022-10-13 00:00:00		2022-10-07 00:00:00		2022-10-14 00:00:00		2022-09-29 00:00:00		2022-09-28 00:00:00		2022-10-07 00:00:00		2022-10-05 00:00:00		2022-10-13 00:00:00		2022-10-12 00:00:00		2022-10-11 00:00:00		2022-10-05 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-07 00:00:00		2022-10-14 00:00:00		2022-10-06 00:00:00		2022-09-30 00:00:00		2022-10-07 00:00:00		2022-09-30 00:00:00
date_thru		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		4000		4900		2900		3800		2000		2000		1400		3000		1900		7500		4900		1000		2500		250		1500		4900		1000		2400		1000		1000		1000		1300		1500		2000		2000		1500		2500		3500		1000		4900		3000		1500		60		4000		4900		2900		3800		2000		2000		1400		3000		1900		7500		4900		1000		2500		250		1500		4900		1000		2400		1000		1000		1000		1300		1500		2000		2000		1500		2500		3500		1000		4900		3000		1500		60
cum_ytd		4000		4900		4900		4800		2000		4900		4900		3000		3900		7500		4900		4000		2500		250		1500		4900		1000		4900		1000		1000		1000		1300		1500		6000		6000		1500		2500		3500		1000		4900		3000		1500		0		4000		4900		4900		4800		2000		4900		4900		3000		3900		7500		4900		4000		2500		250		1500		4900		1000		4900		1000		1000		1000		1300		1500		6000		6000		1500		2500		3500		1000		4900		3000		1500		0
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
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		Interest Earned		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Interest Earned
cmte_id		901313		745208		742855		790773		822237		742617		742617		741623		745825		743107		None		None		1435321		None		992324		None		None		None		None		None		None		861377		None		782601		782601		1307878		1377592		None		None		None		None		None		None		901313		745208		742855		790773		822237		742617		742617		741623		745825		743107		None		None		1435321		None		992324		None		None		None		None		None		None		861377		None		782601		782601		1307878		1377592		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
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
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
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
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
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
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
intr_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		ActBlue		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		ActBlue		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
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
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
intr_city		None		None		None		None		None		None		None		None		None		None		None		None		None		Cambridge		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Cambridge		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_st		None		None		None		None		None		None		None		None		None		None		None		None		None		MA		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		MA		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		02138		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		02138		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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
memo_refno		None		None		None		None		None		None		None		None		None		None		INC1106		None		None		None		None		None		INC1042		None		None		INC1101		INC1093		None		None		None		None		None		None		None		None		None		None		INC1070		None		None		None		None		None		None		None		None		None		None		None		INC1106		None		None		None		None		None		INC1042		None		None		INC1101		INC1093		None		None		None		None		None		None		None		None		None		None		INC1070		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
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
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
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
intr_cmteid		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: smry

filing_id		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403
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		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		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		22A		22B		1		2		3		1		2		3		1		2		3		1		2		3		1		2		3		4		1		2		3		1		2		3		1		2		3		4		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		22A		22B		1		2		3		1		2		3		1		2		3		1		2		3		1		2		3		4		1		2		3		1		2		3		1		2		3		4
rec_type		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY
form_type		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		A		A		A		B1		B1		B1		C		C		C		D		D		D		E		E		E		E		F		F		F		H		H		H		I		I		I		I		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		A		A		A		B1		B1		B1		C		C		C		D		D		D		E		E		E		E		F		F		F		H		H		H		I		I		I		I
amount_a		79550		0		79550		0		79550		235486		0		235486		-63611		0		171876		594977		79550		60		235486		439100		0		0		5620		222222		370058		79550		0		79550		0		0		0		0		0		0		49800		0		49800		235486		0		0		235486		5620		69231		-63611		0		0		0		60		0		0		60		79550		0		79550		0		79550		235486		0		235486		-63611		0		171876		594977		79550		60		235486		439100		0		0		5620		222222		370058		79550		0		79550		0		0		0		0		0		0		49800		0		49800		235486		0		0		235486		5620		69231		-63611		0		0		0		60		0		0		60
amount_b		594363		0		594363		357		594720		730545		0		730545		5620		357		736522		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		594363		0		594363		357		594720		730545		0		730545		5620		357		736522		None		None		None		None		None		None		None		None		None		None		None		None		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
elec_dt		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		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		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403		2743403
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		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		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		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
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		D		D		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		D		D
ptran_id		INC1082		INC1041		INC1041		INC1092		INC1092		INC1110		INC1110		INC1083		INC1047		INC1047		INC1111		INC1111		INC1058		INC1058		INC1103		INC1103		INC1104		INC1104		INC1106		INC1062		INC1062		INC1097		IDT26		INC1102		INC1050		INC1042		INC1068		INC1068		INC1060		INC1060		INC1101		INC1101		INC1093		INC1081		INC1081		INC1061		INC1052		INC1052		INC1053		INC1053		INC1076		INC1077		INC1069		INC1069		INC1105		INC1105		INC1065		INC1051		INC1070		INC1070		EXP1088		EXP1108		INC1082		INC1041		INC1041		INC1092		INC1092		INC1110		INC1110		INC1083		INC1047		INC1047		INC1111		INC1111		INC1058		INC1058		INC1103		INC1103		INC1104		INC1104		INC1106		INC1062		INC1062		INC1097		IDT26		INC1102		INC1050		INC1042		INC1068		INC1068		INC1060		INC1060		INC1101		INC1101		INC1093		INC1081		INC1081		INC1061		INC1052		INC1052		INC1053		INC1053		INC1076		INC1077		INC1069		INC1069		INC1105		INC1105		INC1065		INC1051		INC1070		INC1070		EXP1088		EXP1108
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
elec_amount		4000		4900		4900		4900		4900		4900		4900		2000		3000		4900		3000		4900		4900		3000		4900		2700		7500		7500		4900		4900		1600		2500		250		1500		4900		1000		4900		4900		1000		1000		1000		1000		1000		1500		1300		1500		2000		4000		2000		4000		1500		2500		4700		3500		1000		1000		4900		3000		3000		1500		4900		4900		4000		4900		4900		4900		4900		4900		4900		2000		3000		4900		3000		4900		4900		3000		4900		2700		7500		7500		4900		4900		1600		2500		250		1500		4900		1000		4900		4900		1000		1000		1000		1000		1000		1500		1300		1500		2000		4000		2000		4000		1500		2500		4700		3500		1000		1000		4900		3000		3000		1500		4900		4900
elec_code		G		P		G		P		G		P		G		G		P		G		P		G		P		G		P		G		P		G		G		P		G		G		G		G		G		G		P		G		P		G		P		G		G		P		G		G		P		G		P		G		G		G		P		G		P		G		G		G		P		G		G		G		G		P		G		P		G		P		G		G		P		G		P		G		P		G		P		G		P		G		G		P		G		G		G		G		G		G		P		G		P		G		P		G		G		P		G		G		P		G		P		G		G		G		P		G		P		G		G		G		P		G		G		G