Home

Filing ID: 2743800

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

Table: cvr2_campaign_disclosure

filing_id		2743800
amend_id		0
line_item		1
rec_type		CVR2
form_type		F460
tran_id		OFC5
entity_cd		ATR
title		None
mail_city		None
mail_st		None
mail_zip4		None
f460_part		3
cmte_id		None
enty_naml		Leoni
enty_namf		Peter
enty_namt		None
enty_nams		None
enty_city		Sacramento
enty_st		CA
enty_zip4		95814
enty_phon		(916) 442-7757
enty_fax		None
enty_email		None
tres_naml		None
tres_namf		None
tres_namt		None
tres_nams		None
control_yn		None
office_cd		None
offic_dscr		None
juris_cd		None
juris_dscr		None
dist_no		None
off_s_h_cd		None
bal_name		None
bal_num		None
bal_juris		None
sup_opp_cd		None

Table: cvr3_verification_info

filing_id		2743800
amend_id		0
line_item		1
rec_type		CVR3
form_type		F460
tran_id		VER_1.1
entity_cd		TRE
sig_date		2022-10-24 00:00:00
sig_loc		None
sig_naml		Brian T. Hildreth
sig_namf		None
sig_namt		None
sig_nams		None

Table: cvr_campaign_disclosure

filing_id		2743800
amend_id		0
rec_type		CVR
form_type		F460
filer_id		1287461
entity_cd		RCP
filer_naml		CA Hispanic Chambers of Commerce Candidate PAC
filer_namf		None
filer_namt		None
filer_nams		None
report_num		000
rpt_date		2022-10-22 00:00:00
stmt_type		PE
late_rptno		None
from_date		2022-07-01 00:00:00
thru_date		2022-10-22 00:00:00
elect_date		2022-11-08 00:00:00
filer_city		Sacramento
filer_st		CA
filer_zip4		95814
filer_phon		916-444-2221
filer_fax		None
file_email		fppc@bmhlaw.com
mail_city		Sacramento
mail_st		CA
mail_zip4		95814
tres_naml		Hildreth
tres_namf		Brian T.
tres_namt		None
tres_nams		None
tres_city		Sacramento
tres_st		CA
tres_zip4		95814
tres_phon		916-442-7757
tres_fax		None
tres_email		None
cmtte_type		G
control_yn		Y
sponsor_yn		N
primfrm_yn		N
brdbase_yn		None
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		None
cand_namf		None
cand_namt		None
cand_nams		None
cand_city		None
cand_st		None
cand_zip4		None
cand_phon		None
cand_fax		None
cand_email		None
bal_name		None
bal_num		None
bal_juris		None
office_cd		None
offic_dscr		None
juris_cd		None
juris_dscr		None
dist_no		None
off_s_h_cd		None
sup_opp_cd		None
employer		None
occupation		None
selfemp_cb		None
bal_id		None
cand_id		None

Table: debt

filing_id		2743800
amend_id		0
line_item		1
rec_type		DEBT
form_type		F
tran_id		PAY195
entity_cd		OTH
payee_naml		Bell, McAndrews & Hiltachk, LLP
payee_namf		None
payee_namt		None
payee_nams		None
payee_city		Sacramento
payee_st		CA
payee_zip4		95814
beg_bal		146
amt_incur		0
amt_paid		146
end_bal		0
expn_code		PRO
expn_dscr		None
cmte_id		None
tres_naml		None
tres_namf		None
tres_namt		None
tres_nams		None
tres_city		None
tres_st		None
tres_zip4		None
memo_code		None
memo_refno		None
bakref_tid		None
xref_schnm		None
xref_match		None

Table: expn

filing_id		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800
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
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
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
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
tran_id		EXP234		EXP230		EXP231		EXP232		EXP233		EXP235		EXP236		EXP237		EXP238		EXP239		EXP242		EXP240		EXP241		EXP196		EXP198		EXP200		EXP219		EXP220		EXP221		EXP222		EXP201		EXP224		EXP225		EXP223		EXP227		EXP244		EXP229		EXP234		EXP230		EXP231		EXP232		EXP233		EXP235		EXP236		EXP237		EXP238		EXP239		EXP242		EXP240		EXP241
entity_cd		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM
payee_naml		Ashby for Senate 2022		Davies for Assembly 2022		Guerra for Assembly 2022		Perez for Assembly 2022		Valladares for Assembly 2022		Flores for Supervisor 2022		Montoya for City Council		Talamantes for City Council 2022		Turner for Mayor 2022		Ding for Supervisor 2022		Essayli for Assembly 2022		Rubalcava for City Council 2022		Stevens for School Board 2022		Bell, McAndrews & Hiltachk, LLP		Bell, McAndrews & Hiltachk, LLP		eFundraising Connections		eFundraising Connections		eFundraising Connections		eFundraising Connections		eFundraising Connections		Bell, McAndrews & Hiltachk, LLP		eFundraising Connections		eFundraising Connections		eFundraising Connections		eFundraising Connections		Bell, McAndrews & Hiltachk, LLP		eFundraising Connections		Ashby for Senate 2022		Davies for Assembly 2022		Guerra for Assembly 2022		Perez for Assembly 2022		Valladares for Assembly 2022		Flores for Supervisor 2022		Montoya for City Council		Talamantes for City Council 2022		Turner for Mayor 2022		Ding for Supervisor 2022		Essayli for Assembly 2022		Rubalcava for City Council 2022		Stevens for School Board 2022
payee_namf		Angelique		Laurie		Eric		Leticia		Suzette Martinez		Jeff		Art		Karina		Mark		Steve		None		Natalie		Kennetha		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Angelique		Laurie		Eric		Leticia		Suzette Martinez		Jeff		Art		Karina		Mark		Steve		None		Natalie		Kennetha
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
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
payee_city		Sacramento		Laguna Niguel		Sacramento		Sacramento		Santa Clarita		Bakersfield		Downey		Sacramento		Morgan Hill		Wilton		Sacramento		Anaheim		Stockton		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Laguna Niguel		Sacramento		Sacramento		Santa Clarita		Bakersfield		Downey		Sacramento		Morgan Hill		Wilton		Sacramento		Anaheim		Stockton
payee_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
payee_zip4		95814		92677		95815		95814		91355		93306		90242		95811		95037		95693		95819		92805		95207		95814		95814		95816		95816		95816		95816		95816		95814		95816		95816		95816		95816		95814		95816		95814		92677		95815		95814		91355		93306		90242		95811		95037		95693		95819		92805		95207
expn_date		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-17 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-07-18 00:00:00		2022-08-11 00:00:00		2022-09-06 00:00:00		2022-09-07 00:00:00		2022-09-08 00:00:00		2022-09-09 00:00:00		2022-09-13 00:00:00		2022-09-14 00:00:00		2022-09-15 00:00:00		2022-09-16 00:00:00		2022-09-28 00:00:00		2022-10-04 00:00:00		2022-10-11 00:00:00		2022-10-11 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-17 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
amount		1000		1000		1000		1000		1000		1000		1000		1000		500		1000		500		1000		500		146		477		23		207		23		23		46		146		23		23		23		23		358		23		1000		1000		1000		1000		1000		1000		1000		1000		500		1000		500		1000		500
cum_ytd		1000		1000		1000		1000		1000		1000		1000		1000		500		1000		500		1000		500		2821		2821		437		437		437		437		437		2821		437		437		437		437		2821		437		1000		1000		1000		1000		1000		1000		1000		1000		500		1000		500		1000		500
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
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
expn_code		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		PRO		PRO		OFC		OFC		OFC		OFC		OFC		PRO		OFC		OFC		OFC		OFC		PRO		OFC		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB
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		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
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
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
cmte_id		1425662		1435669		1443246		1443584		1420845		1441740		1451496		1443537		1440125		1439983		1443363		1439463		1450920		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1425662		1435669		1443246		1443584		1420845		1441740		1451496		1443537		1440125		1439983		1443363		1439463		1450920
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
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
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
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
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
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
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
cand_naml		Angelique Ashby		Laurie Davies		Eric Guerra		Leticia Perez		Suzette Martinez Valladares		Jeff Flores		Art Montoya		Karina Talamantes		Mark Turner		Steve Ding		Bill Essayli		Natalie Rubalcava		Kennetha Stevens		None		None		None		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
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
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
office_cd		SEN		ASM		ASM		ASM		ASM		CSU		CCM		CCM		MAY		CSU		ASM		CCM		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
offic_dscr		None		None		None		None		None		None		None		None		None		None		None		None		School Board		None		None		None		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		SEN		ASM		ASM		ASM		ASM		CTY		CIT		CIT		CIT		CTY		ASM		CIT		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
juris_dscr		None		None		None		None		None		Kern		Downey		Sacramento		Morgan Hill		San Joaquin		None		Anaheim		Stockton Unified School District		None		None		None		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		08		74		10		35		40		None		02		03		None		None		63		None		None		None		None		None		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
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
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
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
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
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
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
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
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
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
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

Table: filer_filings

filer_id		1287461
filing_id		2743800
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-07-01 00:00:00
rpt_end		2022-10-22 00:00:00
rpt_date		2022-10-22 00:00:00
filing_type		22001

Table: filings

filing_id		2743800
filing_type		22001

Table: hdr

filing_id		2743800
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		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800
amend_id		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
line_item		20		21		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19
rec_type		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
tran_id		INC228		INC243		INC205		INC203		INC202		INC210		INC208		INC204		INC199		INC207		INC206		INC209		INC211		INC212		INC213		INC214		INC215		INC216		INC217		INC218		INC226
entity_cd		IND		OTH		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		OTH
ctrib_naml		Urena		San Joaquin County Hispanic Chamber of Commerce		Aguilar		Betancourt		Butler Garcia		Castro		Corona		Cubas		Gomez		Gutierrez		Gutierrez		Hernandez		Baisa		Solorzano		Garcia		Plascencia		Duarte		Aguilera Marrero		Chamberlain		Vasquez		PG & E Corporation
ctrib_namf		Maria		None		Sylvester		David		Brenna L		Judy		Veronica		Anna		Marcus		Bob		Bob		Raul		Julio		Carlos		Sophia		Jose		Sylvia		Suzanna		Jenny		Ramiro		None
ctrib_namt		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
ctrib_city		Riverside		Stockton		Stockton		Baldwin Park		Sacramento		San Ramon		Pasadena		Los Angeles		Sacramento		Stockton		Stockton		Benicia		San Jose		San Francisco		Lincoln		Reedley		Palmdale		Visalia		Santa Rosa		Altadena		San Francisco
ctrib_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
ctrib_zip4		92508		95207		95207		91706		95819		94583		91105		90012		95819		95219		95219		94510		95127		94110		95648		93654		93550		93277		95401		91001		94105
ctrib_emp		King Automotive Services		None		Port of Stockton		CVS		AG Spanos Companies		Pacific Oaks College		CM Cleaning Solutions, Inc.		LACCD-Los Angeles Community College District		CA Clothing Recyclers		BGS Public Affairs		BGS Public Affairs		Hood & Strong LLP		J&J Import		Hispanic Chambers of Commerce San Francisco		Verizon		Allstate Kings Canyon Insurance Group LLC		Moonlight Sounds		CA Hispanic Chambers Commerce		Sonoma County Board of Supervisors		Bank of America		None
ctrib_occ		Owner		None		Real Estate Marketing Manager		Community Relations		Vice President		Professor		Owner/Managing Partner		Professor		President/CEO		Owner/Principal		Owner/Principal		Assurance & Advisory Partner		Owner & Manager		CEO		Executive Director/Gov't Affairs & Community Relations		Director		Business Owner		Board Member		Member		Senior Vice President		None
ctrib_self		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
rcpt_date		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-09-01 00:00:00		2022-09-01 00:00:00		2022-09-01 00:00:00		2022-09-01 00:00:00		2022-09-01 00:00:00		2022-09-01 00:00:00		2022-09-01 00:00:00		2022-09-01 00:00:00		2022-09-01 00:00:00		2022-09-01 00:00:00		2022-09-06 00:00:00		2022-09-06 00:00:00		2022-09-07 00:00:00		2022-09-08 00:00:00		2022-09-12 00:00:00		2022-09-13 00:00:00		2022-09-23 00:00:00		2022-09-30 00:00:00		2022-10-03 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
amount		500		1000		500		500		500		500		500		500		500		500		500		500		500		500		500		500		500		500		500		500		5000
cum_ytd		500		1000		500		500		500		500		500		500		500		1000		1000		500		500		500		500		500		500		500		500		500		5000
cum_oth		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
cmte_id		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
tres_namf		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
tres_nams		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
tres_st		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
intr_naml		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
intr_namt		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
intr_city		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
intr_zip4		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
intr_occ		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
cand_naml		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
cand_namt		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
office_cd		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
juris_cd		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
dist_no		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
bal_name		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
bal_juris		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
memo_code		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
bakref_tid		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
xref_match		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
intr_cmteid		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		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800
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
line_item		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		1		2		3		1		2		3		1		2		3		4		1		2		3		1		2		3		1		2		3
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
form_type		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		A		A		A		D		D		D		E		E		E		E		F		F		F		B1		B1		B1		H		H		H
amount_a		15500		0		15500		0		15500		13064		0		13064		-146		0		12918		1912		15500		0		13064		4348		0		0		0		15500		0		15500		11500		0		11500		13064		0		0		13064		0		146		-146		0		0		0		0		0		0
amount_b		15500		0		15500		0		15500		14808		0		14808		0		0		14808		None		None		None		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
elec_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: splt

filing_id		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800		2743800
amend_id		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
pform_type		D		D		D		D		D		D		D		D		D		D		D		D		D
ptran_id		EXP234		EXP230		EXP231		EXP232		EXP233		EXP235		EXP236		EXP237		EXP238		EXP239		EXP242		EXP240		EXP241
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
elec_amount		1000		1000		1000		1000		1000		1000		1000		1000		500		1000		500		1000		500
elec_code		G		G		G		G		G		G		G		G		G		G		G		G		G