Home

Filing ID: 2744402

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

Table: cvr3_verification_info

filing_id		2744402		2744402
amend_id		0		0
line_item		1		2
rec_type		CVR3		CVR3
form_type		F460		F460
tran_id		VER_1.1		VER_2.2
entity_cd		TRE		CAO
sig_date		2022-10-23 00:00:00		2022-10-23 00:00:00
sig_loc		None		None
sig_naml		Bryan Burch		Roger Niello
sig_namf		None		None
sig_namt		None		None
sig_nams		None		None

Table: cvr_campaign_disclosure

filing_id		2744402
amend_id		0
rec_type		CVR
form_type		F460
filer_id		1443871
entity_cd		CTL
filer_naml		Roger Niello for Senate 2022
filer_namf		None
filer_namt		None
filer_nams		None
report_num		000
rpt_date		2022-10-23 00:00:00
stmt_type		PE
late_rptno		None
from_date		2022-09-25 00:00:00
thru_date		2022-10-22 00:00:00
elect_date		2022-11-08 00:00:00
filer_city		West Sacramento
filer_st		CA
filer_zip4		95691
filer_phon		916-838-5799
filer_fax		None
file_email		[email protected]
mail_city		West Sacramento
mail_st		CA
mail_zip4		95799
tres_naml		Burch
tres_namf		Bryan
tres_namt		None
tres_nams		None
tres_city		West Sacramento
tres_st		CA
tres_zip4		95691
tres_phon		916-838-5799
tres_fax		None
tres_email		None
cmtte_type		C
control_yn		Y
sponsor_yn		N
primfrm_yn		N
brdbase_yn		N
amendexp_1		None
amendexp_2		None
amendexp_3		None
rpt_att_cb		None
cmtte_id		None
reportname		None
rptfromdt		None
rptthrudt		None
emplbus_cb		None
bus_name		None
bus_city		None
bus_st		None
bus_zip4		None
bus_inter		None
busact_cb		None
busactvity		None
assoc_cb		None
assoc_int		None
other_cb		None
other_int		None
cand_naml		Niello
cand_namf		Roger
cand_namt		None
cand_nams		None
cand_city		Fair Oaks
cand_st		CA
cand_zip4		95628
cand_phon		916-838-5799
cand_fax		None
cand_email		[email protected]
bal_name		None
bal_num		None
bal_juris		None
office_cd		SEN
offic_dscr		None
juris_cd		SEN
juris_dscr		None
dist_no		6
off_s_h_cd		S
sup_opp_cd		None
employer		None
occupation		None
selfemp_cb		None
bal_id		None
cand_id		None

Table: debt

filing_id		2744402		2744402		2744402
amend_id		0		0		0
line_item		1		2		3
rec_type		DEBT		DEBT		DEBT
form_type		F		F		F
tran_id		PAY765		PAY766		PAY858
entity_cd		OTH		OTH		OTH
payee_naml		Think Right Compliance, Inc.		Strategy Insights		Onymous Media Inc.
payee_namf		None		None		None
payee_namt		None		None		None
payee_nams		None		None		None
payee_city		West Sacramento		Woodland		Fair Oaks
payee_st		CA		CA		CA
payee_zip4		95691		95776		95628
beg_bal		1500		2580		0
amt_incur		0		0		21250
amt_paid		1500		2580		0
end_bal		0		0		21250
expn_code		PRO		LIT		WEB
expn_dscr		None		None		None
cmte_id		None		None		None
tres_naml		None		None		None
tres_namf		None		None		None
tres_namt		None		None		None
tres_nams		None		None		None
tres_city		None		None		None
tres_st		None		None		None
tres_zip4		None		None		None
memo_code		None		None		None
memo_refno		None		None		None
bakref_tid		None		None		None
xref_schnm		None		None		None
xref_match		None		None		None

Table: expn

filing_id		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402
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
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
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
form_type		D		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G
tran_id		EXP816		EXP787		EXP847		EXP841		EXP848		EXP842		EXP849		EXP850		EXP851		EXP834		EXP843		EXP832		EXP852		EXP857		EXP844		EXP845		EXP853		EXP856		EXP846		EXP854		EXP855		EXP837		EXP835		EXP816		EXP840		EXP838		EDT30		EDT34		EDT31		EDT33		EDT32		EDT38		EDT35		EDT37		EDT36		EDT22		EDT24		EDT23		EDT25		EDT26		EDT28		EDT27		EDT29		EDT21
entity_cd		PTY		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		IND		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH
payee_naml		Sacramento County Republican Central Committee		eFundraising Connections		eFundraising Connections		The Battin Group		eFundraising Connections		Onymous Media Inc.		eFundraising Connections		eFundraising Connections		eFundraising Connections		Johnson Strategies, LLC		Strategy Insights		Strategy Insights		eFundraising Connections		Onymous Media Inc.		Strategy Insights		Strategy Insights		eFundraising Connections		eFundraising Connections		Strategy Insights		eFundraising Connections		eFundraising Connections		Foster		Golden State Strategy Group		Sacramento County Republican Central Committee		Think Right Compliance, Inc.		Think Right Compliance, Inc.		Mama Kim Cooks		Agility Ad Exchange		Facebook, Inc.		Google, Inc.		Instagram		Agility Ad Exchange		Facebook, Inc.		Google, Inc.		Instagram		Encompass Direct Marketing Group		Encompass Direct Marketing Group		USPS		USPS		Encompass Direct Marketing Group		Encompass Direct Marketing Group		USPS		USPS		Cable Time
payee_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Sadie		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
payee_city		Sacramento		Sacramento		Sacramento		Reno		Sacramento		Fair Oaks		Sacramento		Sacramento		Sacramento		Austin		Woodland		Woodland		Sacramento		Fair Oaks		Woodland		Woodland		Sacramento		Sacramento		Woodland		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		West Sacramento		West Sacramento		Carmichael		Draper		Menlo Park		Mountain View		Menlo Park		Draper		Menlo Park		Mountain View		Menlo Park		Cheyenne		Cheyenne		Washington		Washington		Cheyenne		Cheyenne		Washington		Washington		Orinda
payee_st		CA		CA		CA		NV		CA		CA		CA		CA		CA		TX		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		UT		CA		CA		CA		UT		CA		CA		CA		WY		WY		DC		DC		WY		WY		DC		DC		CA
payee_zip4		95827		95816		95816		89511		95816		95628		95816		95816		95816		78746		95776		95776		95816		95628		95776		95776		95816		95816		95776		95816		95816		95816		95864		95827		95691		95691		95608		84020		94025		94043		94025		84020		94025		94043		94025		82001		82001		20260		20260		82001		82001		20260		20260		94563
expn_date		2022-10-20 00:00:00		2022-09-25 00:00:00		2022-09-26 00:00:00		2022-09-26 00:00:00		2022-09-27 00:00:00		2022-09-27 00:00:00		2022-09-28 00:00:00		2022-09-29 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-10-04 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-07 00:00:00		2022-10-12 00:00:00		2022-10-14 00:00:00		2022-10-17 00:00:00		2022-10-18 00:00:00		2022-10-19 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-07 00:00:00		2022-09-27 00:00:00		2022-09-27 00:00:00		2022-09-27 00:00:00		2022-09-27 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-09-30 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-09-30 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-09-26 00:00:00
amount		5000		19		28		124712		91		42500		12		46		3		7500		28608		2580		140		21250		28608		57216		16		23		28608		23		34		6000		22430		5000		1800		1500		5284		4250		19125		17000		2125		4250		19125		17000		2125		9194		9194		13642		13642		18388		9194		27284		13642		124712
cum_ytd		8000		8104		8104		124712		8104		185500		8104		8104		8104		7500		300977		300977		8104		185500		300977		300977		8104		8104		300977		8104		8104		23262		134904		8000		14255		14255		5784		8500		100250		60000		16250		8500		100250		60000		16250		76146		76146		124454		124454		76146		76146		124454		124454		124712
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
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
expn_code		MON		OFC		OFC		TEL		OFC		WEB		OFC		OFC		OFC		CNS		LIT		LIT		OFC		WEB		LIT		LIT		OFC		OFC		LIT		OFC		OFC		CNS		None		CTB		PRO		PRO		FND		WEB		WEB		WEB		WEB		WEB		WEB		WEB		WEB		LIT		LIT		POS		POS		LIT		LIT		POS		POS		TEL
expn_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		CNS, FND		None		None		None		09/22-Event Costs, 80, Sacramento, CA Candidate-Yes		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
agent_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Golden State Strategy Group		Onymous Media Inc.		Onymous Media Inc.		Onymous Media Inc.		Onymous Media Inc.		Onymous Media Inc.		Onymous Media Inc.		Onymous Media Inc.		Onymous Media Inc.		Strategy Insights		Strategy Insights		Strategy Insights		Strategy Insights		Strategy Insights		Strategy Insights		Strategy Insights		Strategy Insights		The Battin Group
agent_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
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
cmte_id		910414		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		910414		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
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
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
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
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
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
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
cand_naml		Sacramento County Republican Central Committee		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
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
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
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
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
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
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
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
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
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
sup_opp_cd		S		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
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
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
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		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E
xref_schnm		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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

Table: filer_filings

filer_id		1443871
filing_id		2744402
period_id		251
form_id		F460
filing_sequence		0
filing_date		2022-10-27 00:00:00
stmnt_type		10001
stmnt_status		11003
session_id		2021
user_id		CAFILER
special_audit		11003
fine_audit		11003
rpt_start		2022-09-25 00:00:00
rpt_end		2022-10-22 00:00:00
rpt_date		2022-10-23 00:00:00
filing_type		22001

Table: filings

filing_id		2744402
filing_type		22001

Table: hdr

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

Table: rcpt

filing_id		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402
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
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
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
form_type		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A
tran_id		INC759		INC761		INC760		INC758		INC771		INC762		INC772		INC773		INC768		INC782		INC769		INC776		INC775		INC770		INC777		INC779		INC778		INC780		INC784		INC781		INC785		INC786		INC791		INC788		INC789		INC796		INC793		INC792		INC794		INC797		INC790		INC795		INC798		INC799		INC800		INC802		INC812		INC801		INC813		INC814		INC806		INC805		INC803		INC804		INC810		INC811		INC808		INC809		INC815		INC818		INC807		INC825		INC817		INC824		INC819		INC821		INC820		INC831		INC826		INC828		INC822		INC827		INC823		INC829		INC830
entity_cd		COM		OTH		COM		COM		IND		IND		IND		IND		COM		IND		IND		COM		IND		COM		COM		OTH		COM		OTH		IND		COM		SCC		OTH		COM		COM		OTH		IND		OTH		COM		OTH		IND		COM		COM		IND		COM		COM		COM		IND		OTH		IND		IND		OTH		COM		OTH		COM		OTH		COM		OTH		COM		IND		OTH		OTH		IND		COM		IND		IND		OTH		COM		IND		IND		IND		COM		IND		COM		IND		IND
ctrib_naml		American Pistachio Growers California PAC		Anheuser Busch		California Association of Health Facilities PAC		California Statewide Law Enforcement Association PAC		Lent		McIntosh		Riegels		Olmstead		American Property Casualty Insurance Association California PAC		Dettwiller		Cummings		Farmers Employees & Agents PAC		Taghavian		The California Society of Certified Public Accountants PAC		Rancho Cordova Chamber of Commerce PAC		Agua Caliente Band of Cahuilla Indians		California New Car Dealers Association PAC		Deloitte Services LP		Dichellis		Family Business PAC		Cal Fire Local 2881 SCC		Charter Communications		California Landscape Contractors Association Inc. PAC		Caterpillar Inc. PAC		Pechanga Band of Luiseno Mission Indians		Ueltzen		1-800 Contacts, Inc.		California Independent Petroleum Association PAC		NextEra Energy Resources Development LLC(Peter Colussy)		Papenhausen		United Parcel Service Political Action Committee FEC - C00064766		Taylor Morrison Inc. Building Strong Business PAC		Davis		California State Council of Laborers PAC		Seyarto for Senate 2022		California Metal Works Coalition		Cooper		Sempra Energy Utilities		Blake		Teichert		Anderson Bros Florin Square Pharmacy		California Assisted Living Association PAC		California Resource Corporation		Roseville Area Business PAC		Clean Energy		Sacramento Police Officers Association PAC		Ensign Facility Services, Inc.		Joe Patterson for Assembly 2022		Lewis		Phillips 66		Providence Group Inc.		Bassett		California Charter Schools Association PAC		Kirby		Schade		Anthem Blue Cross		California Life Science Association PAC		Cummings		Drury		Knox		National Federation of Independent Business PAC		Ramos		Sacramento Builders' Exchange PAC		Taylor		Wiegner
ctrib_namf		None		None		None		None		Robert		Pat		David		Chris		None		Annetta		Claudia		None		Alex		None		None		None		None		None		Peter		None		None		None		None		None		None		Mike		None		None		None		Jim		None		None		William		None		None		None		Phil		None		Annie		Fred		None		None		None		None		None		None		None		None		Lin		None		None		Susan		None		Pat		John		None		None		Clifford		John		Thomas		None		Daniel		None		Renee		Edward
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
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
ctrib_city		Sacramento		Sacramento		Sacramento		Sacramento		Elk Grove		Roseville		Sacramento		Sacramento		Chicago		Carmichael		Folsom		San Rafael		Sacramento		San Rafael		Sacramento		Palm Springs		Sacramento		Hermitage		Santa Monica		Sacramento		Sacramento		St. Louis		Sacramento		Deerfield		Temecula		Sacramento		Draper		Irvine		Juno Beach		El Cajon		Atlanta		Scottsdale		Sacramento		Sacramento		Wilton		El Dorado Hills		Gold River		San Diego		Rocklin		Sacramento		Sacramento		Sacramento		Long Beach		Roseville		Newport Beach		Sacramento		San Juan Capistrano		Wilton		Sacramento		Sacramento		Farmington		Gold River		Sacramento		Wilton		Sacramento		Cincinnati		Sacramento		San Bernardino		Sacramento		Carmichael		Washignton		Sacramento		Sacramento		Sacramento		Sacramento
ctrib_st		CA		CA		CA		CA		CA		CA		CA		CA		IL		CA		CA		CA		CA		CA		CA		CA		CA		TN		CA		CA		CA		MO		CA		IL		CA		CA		UT		CA		FL		CA		GA		AZ		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		UT		CA		CA		CA		CA		OH		CA		CA		CA		CA		DC		CA		CA		CA		CA
ctrib_zip4		95814		95814		95816		95814		95757		95747		95819		95864		60631		95608		95630		94901		95864		94901		95841		92264		95814		37076		90403		95814		95814		63131		95815		60015		92592		95825		84020		92618		33408		92021		30328		85251		95816		95814		95693		95762		95670		92101		95677		95819		95822		95814		90831		95678		92660		95814		92675		95693		95825		95814		84025		95670		95814		95693		95818		45209		95814		92404		95815		95608		20004		95819		95841		95864		95864
ctrib_emp		None		None		None		None		Elk Grove Milling		N/A		N/A		N/A		None		N/A		N/A		None		Capitol Impact		None		None		None		None		None		Jalen Condominiums		None		None		None		None		None		None		N/A		None		None		None		Self		None		None		Brandenburger & Davis		None		None		None		Cooper Oates AC		None		Emme Consulting		Teichert Foundation		None		None		None		None		None		None		None		None		N/A		None		None		Self: Susan Bassett		None		A.L. Gilbert		N/A		None		None		Toyota of San Bernardino		Pacific Neon Company		Knox, Lemmon & Anapolsky		None		Ramco Enterprises		None		N/A		N/A
ctrib_occ		None		None		None		None		Owner		Retired		Retired		Retired		None		Retired		Retired		None		Managing Partner		None		None		None		None		None		Principal		None		None		None		None		None		None		Retired		None		None		None		Contractor		None		None		Manager		None		None		None		Owner		None		Consultant		Executive Director		None		None		None		None		None		None		None		None		Retired		None		None		Consultant		None		Purchaser		Retired		None		None		Auto Dealer		Owner		Attorney		None		VP		None		Retired		Retired
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
tran_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rcpt_date		2022-09-26 00:00:00		2022-09-26 00:00:00		2022-09-26 00:00:00		2022-09-26 00:00:00		2022-09-26 00:00:00		2022-09-26 00:00:00		2022-09-26 00:00:00		2022-09-27 00:00:00		2022-09-28 00:00:00		2022-09-28 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-09-30 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-04 00:00:00		2022-10-04 00:00:00		2022-10-06 00:00:00		2022-10-06 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-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-11 00:00:00		2022-10-12 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-15 00:00:00		2022-10-16 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 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
amount		2000		4900		1500		2000		500		100		250		250		2000		100		3000		2500		100		4900		2000		1500		4900		4000		150		1000		4900		3000		1000		2000		4900		250		1000		1500		1500		100		4000		1000		500		4900		2500		500		500		4900		250		500		250		4900		4900		500		1500		4900		2000		1000		500		4900		4900		250		1500		250		250		2900		2000		2500		150		250		4900		250		2000		500		1000
cum_ytd		2000		6400		1500		2000		1500		300		350		250		2000		200		7900		2500		350		9800		2000		1500		9800		4000		150		2000		9800		4500		1000		3500		7900		250		2500		1500		3500		100		6500		1000		500		4900		2500		2000		500		7400		250		500		500		7400		4900		1500		1500		9800		2000		1000		1000		9800		4900		250		1500		349		750		4900		2000		2500		150		750		4900		750		2000		1500		1000
cum_oth		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
ctrib_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cmte_id		1343200		None		741816		970375		None		None		None		None		830078		None		None		901422		None		782601		1248483		None		741623		None		None		1365285		790318		None		770272		1307878		None		None		None		822237		None		None		1377592		1425184		None		902770		1443473		1264568		None		None		None		None		None		1247506		None		961866		None		746239		None		1443381		None		None		None		None		1302433		None		None		None		1272633		None		None		None		822768		None		1355140		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
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
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
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
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
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
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
intr_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
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
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
intr_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

Table: smry

filing_id		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402
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
line_item		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		20		21		22A		22B		1		2		3		1		2		3		1		2		3		4		1		2		3		1		2		3		1		2		3
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
form_type		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		A		A		A		D		D		D		E		E		E		E		F		F		F		B1		B1		B1		H		H		H
amount_a		126365		0		126365		0		126365		378810		0		378810		17170		0		395980		324904		126365		0		378810		72459		0		0		21250		540037		404484		474716		382767		126300		65		126365		5000		0		5000		378745		65		0		378810		21250		4080		17170		0		0		0		0		0		0
amount_b		965139		0		965139		30130		995269		892880		0		892880		21250		30130		944260		None		None		None		None		None		None		None		None		455231		541576		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
elec_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2022-11-08 00:00:00		2022-06-07 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: splt

filing_id		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402		2744402
amend_id		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
line_item		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		20		21		22		23		24		25		26		27		28		29		30		31		32		33		34		35		36		37		38		39		40		41		42		43		44		45		46		47		48		49		50		51		52		53		54		55		56		57		58		59		60		61		62		63		64		65		66		67		68		69		70		71		72		73		74		75		76		77		78		79		80		81		82		83		84		85		86		87		88		89		90		91		92		93		94		95		96
pform_type		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		D
ptran_id		INC759		INC761		INC761		INC760		INC758		INC771		INC771		INC762		INC762		INC772		INC772		INC773		INC768		INC782		INC782		INC769		INC769		INC776		INC775		INC775		INC770		INC770		INC777		INC779		INC778		INC778		INC780		INC784		INC781		INC781		INC785		INC785		INC786		INC786		INC791		INC788		INC788		INC789		INC789		INC796		INC793		INC793		INC792		INC794		INC794		INC797		INC790		INC790		INC795		INC798		INC799		INC800		INC802		INC812		INC801		INC801		INC813		INC814		INC806		INC806		INC805		INC805		INC803		INC804		INC804		INC810		INC811		INC811		INC808		INC809		INC815		INC815		INC818		INC818		INC807		INC825		INC817		INC824		INC824		INC819		INC819		INC821		INC821		INC820		INC831		INC826		INC828		INC828		INC822		INC827		INC827		INC823		INC829		INC829		INC830		EXP816
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
elec_amount		2000		1500		4900		1500		2000		1000		500		100		200		100		250		250		2000		100		100		4900		3000		2500		250		100		4900		4900		2000		1500		4900		4900		4000		150		1000		1000		4900		4900		1500		3000		1000		1500		2000		3000		4900		250		1500		1000		1500		2000		1500		100		2500		4000		1000		500		4900		2500		2000		500		2500		4900		250		500		250		250		2500		4900		4900		1000		500		1500		4900		4900		2000		1000		500		500		4900		4900		4900		250		1500		99		250		250		500		2000		2900		2000		2500		150		500		250		4900		250		500		2000		1000		500		1000		8000
elec_code		G		P		G		G		G		P		G		P		G		P		G		G		G		P		G		P		G		G		P		G		P		G		G		G		P		G		G		G		P		G		P		G		P		G		G		P		G		P		G		G		P		G		G		P		G		G		P		G		G		G		G		G		G		G		P		G		G		G		P		G		P		G		G		P		G		G		P		G		G		G		P		G		P		G		G		G		G		P		G		P		G		P		G		G		G		G		P		G		G		P		G		G		P		G		G		G