Home

Filing ID: 2726193

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

Table: cvr2_campaign_disclosure

filing_id		2726193		2726193
amend_id		1		0
line_item		1		1
rec_type		CVR2		CVR2
form_type		F460		F460
tran_id		OFC1		OFC1
entity_cd		ATR		ATR
title		None		None
mail_city		None		None
mail_st		None		None
mail_zip4		None		None
f460_part		3		3
cmte_id		None		None
enty_naml		Lewis		Lewis
enty_namf		Denise		Denise
enty_namt		None		None
enty_nams		None		None
enty_city		Sacramento		Sacramento
enty_st		CA		CA
enty_zip4		95841		95841
enty_phon		916-348-9100		916-348-9100
enty_fax		None		None
enty_email		None		None
tres_naml		None		None
tres_namf		None		None
tres_namt		None		None
tres_nams		None		None
control_yn		None		None
office_cd		None		None
offic_dscr		None		None
juris_cd		None		None
juris_dscr		None		None
dist_no		None		None
off_s_h_cd		None		None
bal_name		None		None
bal_num		None		None
bal_juris		None		None
sup_opp_cd		None		None

Table: cvr3_verification_info

filing_id		2726193		2726193		2726193		2726193
amend_id		1		1		0		0
line_item		1		2		1		2
rec_type		CVR3		CVR3		CVR3		CVR3
form_type		F460		F460		F460		F460
tran_id		tcopeland.1		VER_2.2		tcopeland.1		VER_2.2
entity_cd		ATR		SPO		ATR		SPO
sig_date		2022-10-27 00:00:00		2022-10-27 00:00:00		2022-09-28 00:00:00		2022-09-28 00:00:00
sig_loc		None		None		None		None
sig_naml		Denise Lewis		David Osborne		Denise Lewis		David Osborne
sig_namf		None		None		None		None
sig_namt		None		None		None		None
sig_nams		None		None		None		None

Table: cvr_campaign_disclosure

filing_id		2726193		2726193
amend_id		0		1
rec_type		CVR		CVR
form_type		F460		F460
filer_id		831693		831693
entity_cd		RCP		RCP
filer_naml		District Council of Iron Workers PAC		District Council of Iron Workers PAC
filer_namf		None		None
filer_namt		None		None
filer_nams		None		None
report_num		000		001
rpt_date		2022-09-28 00:00:00		2022-10-27 00:00:00
stmt_type		PE		PE
late_rptno		None		None
from_date		2022-07-01 00:00:00		2022-07-01 00:00:00
thru_date		2022-09-24 00:00:00		2022-09-24 00:00:00
elect_date		2022-11-08 00:00:00		2022-11-08 00:00:00
filer_city		Pinole		Pinole
filer_st		CA		CA
filer_zip4		94564		94564
filer_phon		510-724-9277		510-724-9277
filer_fax		510-724-1345		510-724-1345
file_email		[email protected]		[email protected]
mail_city		None		None
mail_st		None		None
mail_zip4		None		None
tres_naml		Osborne		Osborne
tres_namf		David		David
tres_namt		None		None
tres_nams		None		None
tres_city		Pinole		Pinole
tres_st		CA		CA
tres_zip4		94564		94564
tres_phon		510-724-9277		510-724-9277
tres_fax		None		None
tres_email		None		None
cmtte_type		G		G
control_yn		Y		Y
sponsor_yn		Y		Y
primfrm_yn		N		N
brdbase_yn		None		None
amendexp_1		None		Amend to Update Schedule A, I & Summary Page
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		None		None
cand_namf		None		None
cand_namt		None		None
cand_nams		None		None
cand_city		None		None
cand_st		None		None
cand_zip4		None		None
cand_phon		None		None
cand_fax		None		None
cand_email		None		None
bal_name		None		None
bal_num		None		None
bal_juris		None		None
office_cd		None		None
offic_dscr		None		None
juris_cd		None		None
juris_dscr		None		None
dist_no		None		None
off_s_h_cd		None		None
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		2726193		2726193
amend_id		0		1
line_item		1		1
rec_type		DEBT		DEBT
form_type		F		F
tran_id		PAY3530		PAY3530
entity_cd		OTH		OTH
payee_naml		River City Business Services		River City Business Services
payee_namf		None		None
payee_namt		None		None
payee_nams		None		None
payee_city		Sacramento		Sacramento
payee_st		CA		CA
payee_zip4		95841		95841
beg_bal		227		227
amt_incur		0		0
amt_paid		227		227
end_bal		0		0
expn_code		PRO		PRO
expn_dscr		None		None
cmte_id		None		None
tres_naml		None		None
tres_namf		None		None
tres_namt		None		None
tres_nams		None		None
tres_city		None		None
tres_st		None		None
tres_zip4		None		None
memo_code		None		None
memo_refno		None		None
bakref_tid		None		None
xref_schnm		None		None
xref_match		None		None

Table: expn

filing_id		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193
amend_id		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
line_item		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19
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
form_type		D		D		D		D		D		D		D		E		E		E		E		E		E		E		E		E		E		E		E		D		D		D		D		D		D		D		E		E		E		E		E		E		E		E		E		E		E		E
tran_id		EXP3541		EXP3534		EXP3544		EXP3545		EXP3540		EXP3551		EXP3543		EXP3541		EXP3534		EXP3542		EXP3553		EXP3544		EXP3545		EXP3540		EXP3535		EXP3538		EXP3551		EXP3550		EXP3543		EXP3541		EXP3534		EXP3544		EXP3545		EXP3540		EXP3551		EXP3543		EXP3541		EXP3534		EXP3542		EXP3553		EXP3544		EXP3545		EXP3540		EXP3535		EXP3538		EXP3551		EXP3550		EXP3543
entity_cd		COM		COM		COM		COM		COM		COM		COM		COM		COM		OTH		OTH		COM		COM		COM		OTH		OTH		COM		OTH		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		OTH		OTH		COM		COM		COM		OTH		OTH		COM		OTH		COM
payee_naml		Carol Kwan for West Basin Water Board 2022		Cindy Chavez for Mayor 2022		Elizalde for City Council 2022		Rebecca Kaplan for Alameda County Supervisor 2022		Rex Richardson for Mayor 2022		Santa Clara & San Benito Counties Building and Construction Trades Council PAC		Tim McOsker for City Council 2022 - General		Carol Kwan for West Basin Water Board 2022		Cindy Chavez for Mayor 2022		Committee to Elect Aaron Ford		Committee to Elect Steve Sisolak		Elizalde for City Council 2022		Rebecca Kaplan for Alameda County Supervisor 2022		Rex Richardson for Mayor 2022		River City Business Services		River City Business Services		Santa Clara & San Benito Counties Building and Construction Trades Council PAC		Secretary of State		Tim McOsker for City Council 2022 - General		Carol Kwan for West Basin Water Board 2022		Cindy Chavez for Mayor 2022		Elizalde for City Council 2022		Rebecca Kaplan for Alameda County Supervisor 2022		Rex Richardson for Mayor 2022		Santa Clara & San Benito Counties Building and Construction Trades Council PAC		Tim McOsker for City Council 2022 - General		Carol Kwan for West Basin Water Board 2022		Cindy Chavez for Mayor 2022		Committee to Elect Aaron Ford		Committee to Elect Steve Sisolak		Elizalde for City Council 2022		Rebecca Kaplan for Alameda County Supervisor 2022		Rex Richardson for Mayor 2022		River City Business Services		River City Business Services		Santa Clara & San Benito Counties Building and Construction Trades Council PAC		Secretary of State		Tim McOsker for City Council 2022 - General
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
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
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
payee_city		Los Angeles		San Jose		Covina		Oakland		Long Beach		San Jose		Los Angeles		Los Angeles		San Jose		Las Vegas		Las Vegas		Covina		Oakland		Long Beach		Sacramento		Sacramento		San Jose		Sacramento		Los Angeles		Los Angeles		San Jose		Covina		Oakland		Long Beach		San Jose		Los Angeles		Los Angeles		San Jose		Las Vegas		Las Vegas		Covina		Oakland		Long Beach		Sacramento		Sacramento		San Jose		Sacramento		Los Angeles
payee_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		NV		NV		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		NV		NV		CA		CA		CA		CA		CA		CA		CA		CA
payee_zip4		90071		95126		91722		94612		90802		95125		90017		90071		95126		89193		89113		91722		94612		90802		95841		95841		95125		95814		90017		90071		95126		91722		94612		90802		95125		90017		90071		95126		89193		89113		91722		94612		90802		95841		95841		95125		95814		90017
expn_date		2022-09-05 00:00:00		2022-07-08 00:00:00		2022-09-16 00:00:00		2022-09-16 00:00:00		2022-09-02 00:00:00		2022-07-05 00:00:00		2022-09-16 00:00:00		2022-09-05 00:00:00		2022-07-08 00:00:00		2022-09-16 00:00:00		2022-09-16 00:00:00		2022-09-16 00:00:00		2022-09-16 00:00:00		2022-09-02 00:00:00		2022-08-05 00:00:00		2022-09-02 00:00:00		2022-07-05 00:00:00		2022-07-01 00:00:00		2022-09-16 00:00:00		2022-09-05 00:00:00		2022-07-08 00:00:00		2022-09-16 00:00:00		2022-09-16 00:00:00		2022-09-02 00:00:00		2022-07-05 00:00:00		2022-09-16 00:00:00		2022-09-05 00:00:00		2022-07-08 00:00:00		2022-09-16 00:00:00		2022-09-16 00:00:00		2022-09-16 00:00:00		2022-09-16 00:00:00		2022-09-02 00:00:00		2022-08-05 00:00:00		2022-09-02 00:00:00		2022-07-05 00:00:00		2022-07-01 00:00:00		2022-09-16 00:00:00
amount		2500		1400		500		5000		900		2000		800		2500		1400		1500		10000		500		5000		900		227		432		2000		430		800		2500		1400		500		5000		900		2000		800		2500		1400		1500		10000		500		5000		900		227		432		2000		430		800
cum_ytd		2500		1400		500		5000		1800		2000		800		2500		1400		1500		10000		500		5000		1800		3190		3190		2000		430		800		2500		1400		500		5000		1800		2000		800		2500		1400		1500		10000		500		5000		1800		3190		3190		2000		430		800
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
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
expn_code		MON		MON		MON		MON		MON		MON		MON		CTB		CTB		None		None		CTB		CTB		CTB		PRO		PRO		CTB		OFC		CTB		MON		MON		MON		MON		MON		MON		MON		CTB		CTB		None		None		CTB		CTB		CTB		PRO		PRO		CTB		OFC		CTB
expn_dscr		None		None		None		None		None		None		None		None		None		Out of State Contribution		Out of State Contribution		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Out of State Contribution		Out of State Contribution		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
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
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
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
cmte_id		None		None		None		None		None		None		None		1452345		1440871		None		None		1408899		1444142		1443096		None		None		743618		None		1449036		None		None		None		None		None		None		None		1452345		1440871		None		None		1408899		1444142		1443096		None		None		743618		None		1449036
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
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
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
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
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
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
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
cand_naml		Carol Kwan		Cindy Chavez		Jacqueline Elizalde		Rebecca Kaplan		Rex Richardson		Santa Clara & San Benito Counties Building and Construction Trades Council PAC		Tim McOsker		None		None		None		None		None		None		None		None		None		None		None		None		Carol Kwan		Cindy Chavez		Jacqueline Elizalde		Rebecca Kaplan		Rex Richardson		Santa Clara & San Benito Counties Building and Construction Trades Council PAC		Tim McOsker		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
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
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
office_cd		OTH		MAY		CCM		CSU		MAY		None		CCM		None		None		None		None		None		None		None		None		None		None		None		None		OTH		MAY		CCM		CSU		MAY		None		CCM		None		None		None		None		None		None		None		None		None		None		None		None
offic_dscr		Board Member		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Board Member		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_cd		OTH		CIT		CIT		CTY		CIT		None		CIT		None		None		None		None		None		None		None		None		None		None		None		None		OTH		CIT		CIT		CTY		CIT		None		CIT		None		None		None		None		None		None		None		None		None		None		None		None
juris_dscr		West Basin Water		San Jose		Pomona		Alameda		Long Beach		None		Los Angeles		None		None		None		None		None		None		None		None		None		None		None		None		West Basin Water		San Jose		Pomona		Alameda		Long Beach		None		Los Angeles		None		None		None		None		None		None		None		None		None		None		None		None
dist_no		1		None		2		3		None		None		15		None		None		None		None		None		None		None		None		None		None		None		None		1		None		2		3		None		None		15		None		None		None		None		None		None		None		None		None		None		None		None
off_s_h_cd		None		None		None		None		S		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		S		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
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
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
sup_opp_cd		S		S		S		S		S		S		S		None		None		None		None		None		None		None		None		None		None		None		None		S		S		S		S		S		S		S		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
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
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
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
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
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

Table: filer_filings

filer_id		1036761		1036761
filing_id		2726193		2726193
period_id		251		251
form_id		F460		F460
filing_sequence		1		0
filing_date		2022-10-27 00:00:00		2022-09-29 00:00:00
stmnt_type		10002		10001
stmnt_status		11003		11003
session_id		2021		2021
user_id		CAFILER		CAFILER
special_audit		11003		11003
fine_audit		11003		11003
rpt_start		2022-07-01 00:00:00		2022-07-01 00:00:00
rpt_end		2022-09-24 00:00:00		2022-09-24 00:00:00
rpt_date		2022-10-27 00:00:00		2022-09-28 00:00:00
filing_type		22001		22001

Table: filings

filing_id		2726193
filing_type		22001

Table: hdr

filing_id		2726193		2726193
amend_id		1		0
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		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193
amend_id		1		1		1		1		1		1		1		0		0
line_item		1		2		3		4		5		6		7		1		2
rec_type		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT
form_type		I		I		I		I		I		I		I		I		I
tran_id		INC3634		INC3633		INC3635		INC3637		INC3632		INC3546		INC3552		INC3546		INC3552
entity_cd		COM		COM		COM		COM		COM		OTH		OTH		OTH		OTH
ctrib_naml		Carlyn Obringer for City Council 2024		Cindy Allen for City Council 2020		Connie Leyva for Supervisor 2022		Councilmember Roberto Uranga Officeholder Account 2014		Katrina Foley for Supervisor 2022		United Business Bank		United Business Bank		United Business Bank		United Business Bank
ctrib_namf		None		None		None		None		None		None		None		None		None
ctrib_namt		None		None		None		None		None		None		None		None		None
ctrib_nams		None		None		None		None		None		None		None		None		None
ctrib_city		Concord		Long Beach		Santa Ana		Wilmington		Long Beach		Walnut Creek		Walnut Creek		Walnut Creek		Walnut Creek
ctrib_st		CA		CA		CA		CA		CA		CA		CA		CA		CA
ctrib_zip4		94519		90802		92703		90744		90802		94596		94596		94596		94596
ctrib_emp		None		None		None		None		None		None		None		None		None
ctrib_occ		None		None		None		None		None		None		None		None		None
ctrib_self		None		None		None		None		None		None		None		None		None
tran_type		None		None		None		None		None		None		None		None		None
rcpt_date		2022-09-12 00:00:00		2022-09-12 00:00:00		2022-09-12 00:00:00		2022-09-12 00:00:00		2022-09-12 00:00:00		2022-07-29 00:00:00		2022-08-31 00:00:00		2022-07-29 00:00:00		2022-08-31 00:00:00
date_thru		None		None		None		None		None		None		None		None		None
amount		200		750		2000		750		1000		13		13		13		13
cum_ytd		0		0		0		0		0		0		0		0		0
cum_oth		None		None		None		None		None		None		None		None		None
ctrib_dscr		Void Uncashed Check		Void Uncashed Check		Void Uncashed Check		Void Uncashed Check		Void Uncashed Check		Interest Earned		Interest Earned		Interest Earned		Interest Earned
cmte_id		1324644		1421740		1444138		1360366		1435506		None		None		None		None
tres_naml		None		None		None		None		None		None		None		None		None
tres_namf		None		None		None		None		None		None		None		None		None
tres_namt		None		None		None		None		None		None		None		None		None
tres_nams		None		None		None		None		None		None		None		None		None
tres_city		None		None		None		None		None		None		None		None		None
tres_st		None		None		None		None		None		None		None		None		None
tres_zip4		None		None		None		None		None		None		None		None		None
intr_naml		None		None		None		None		None		None		None		None		None
intr_namf		None		None		None		None		None		None		None		None		None
intr_namt		None		None		None		None		None		None		None		None		None
intr_nams		None		None		None		None		None		None		None		None		None
intr_city		None		None		None		None		None		None		None		None		None
intr_st		None		None		None		None		None		None		None		None		None
intr_zip4		None		None		None		None		None		None		None		None		None
intr_emp		None		None		None		None		None		None		None		None		None
intr_occ		None		None		None		None		None		None		None		None		None
intr_self		None		None		None		None		None		None		None		None		None
cand_naml		None		None		None		None		None		None		None		None		None
cand_namf		None		None		None		None		None		None		None		None		None
cand_namt		None		None		None		None		None		None		None		None		None
cand_nams		None		None		None		None		None		None		None		None		None
office_cd		None		None		None		None		None		None		None		None		None
offic_dscr		None		None		None		None		None		None		None		None		None
juris_cd		None		None		None		None		None		None		None		None		None
juris_dscr		None		None		None		None		None		None		None		None		None
dist_no		None		None		None		None		None		None		None		None		None
off_s_h_cd		None		None		None		None		None		None		None		None		None
bal_name		None		None		None		None		None		None		None		None		None
bal_num		None		None		None		None		None		None		None		None		None
bal_juris		None		None		None		None		None		None		None		None		None
sup_opp_cd		None		None		None		None		None		None		None		None		None
memo_code		None		None		None		None		None		None		None		None		None
memo_refno		None		None		None		None		None		None		None		None		None
bakref_tid		None		None		None		None		None		None		None		None		None
xref_schnm		None		None		None		None		None		None		None		None		None
xref_match		None		None		None		None		None		None		None		None		None
int_rate		None		None		None		None		None		None		None		None		None
intr_cmteid		None		None		None		None		None		None		None		None		None

Table: smry

filing_id		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193
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		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		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		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		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
form_type		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		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		0		0		0		0		0		25689		0		25689		-227		0		25462		440448		0		31		25689		414790		0		0		0		0		0		0		0		0		0		0		0		0		13100		0		13100		25689		0		0		25689		0		227		-227		0		0		0		26		5		0		31		78636		0		78636		0		78636		25724		0		25724		-227		0		25497		440448		78636		4731		25724		498091		0		0		0		0		78636		78636		0		0		0		0		0		0		13100		0		13100		25689		35		0		25724		0		227		-227		0		0		0		4726		5		0		4731
amount_b		68465		0		68465		0		68465		146920		0		146920		0		0		146920		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		147101		0		147101		0		147101		146955		0		146955		0		0		146955		None		None		None		None		None		None		None		None		None		None		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
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193		2726193
amend_id		0		0		0		0		0		0		1		1		1		1		1		1
line_item		1		2		3		4		5		6		1		2		3		4		5		6
pform_type		D		D		D		D		D		D		D		D		D		D		D		D
ptran_id		EXP3534		EXP3544		EXP3545		EXP3540		EXP3540		EXP3543		EXP3534		EXP3544		EXP3545		EXP3540		EXP3540		EXP3543
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
elec_amount		1400		500		5000		900		900		800		1400		500		5000		900		900		800
elec_code		G		G		G		P		G		G		G		G		G		P		G		G