Home

Filing ID: 2743579

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

Table: cvr3_verification_info

filing_id		2743579		2743579
amend_id		0		0
line_item		1		2
rec_type		CVR3		CVR3
form_type		F460		F460
tran_id		FMILLIGAN.1		FMILLIGAN.2
entity_cd		TRE		OFF
sig_date		2022-10-25 00:00:00		2022-10-25 00:00:00
sig_loc		None		None
sig_naml		Robert James		Robert James
sig_namf		None		None
sig_namt		None		None
sig_nams		None		None

Table: cvr_campaign_disclosure

filing_id		2743579
amend_id		0
rec_type		CVR
form_type		F460
filer_id		890440
entity_cd		RCP
filer_naml		Plumbers and Steamfitters Local Union No. 582 Political Action Committee
filer_namf		None
filer_namt		None
filer_nams		None
report_num		000
rpt_date		2022-10-26 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		Orange
filer_st		CA
filer_zip4		92868
filer_phon		(714) 978-0582
filer_fax		None
file_email		[email protected]
mail_city		Sacramento
mail_st		CA
mail_zip4		95814
tres_naml		James
tres_namf		Robert
tres_namt		None
tres_nams		None
tres_city		Orange
tres_st		CA
tres_zip4		92868
tres_phon		(714) 978-0582
tres_fax		None
tres_email		None
cmtte_type		G
control_yn		Y
sponsor_yn		Y
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: expn

filing_id		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579
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		D		D		D		D		D		D		D		D		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
tran_id		EXP670		EXP672		EXP671		EXP681		EXP678		EXP688		EXP683		EXP675		EXP677		EXP680		EXP686		EXP685		EXP673		EXP684		EXP679		EXP687		EXP694		EXP674		EXP689		EXP690		EXP682		EXP676		EXP670		EXP672		EXP671		EXP681		EXP678		EXP688		EXP683		EXP675		EXP677		EXP680		EXP686		EXP685		EXP673		EXP684		EXP679		EXP687		EXP694		EXP674		EXP689		EXP690		EXP682		EXP676
entity_cd		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM
payee_naml		Lowenthal for Assembly 2022		Foley for Supervisor 2022		Lowenthal for Assembly 2022		Barrios for Orange City Council 2022		Becerra for City Council 2022		Chen for Assembly 2022		Gallagher for Tustin Council 2024		Gladson for Council 2022		Gomez for Mayor 2022		Khan for Irvine Mayor 2022		Lumbard for Mayor 2022		Ma'ae for City Council 2022		McGill for Moulton Niguel Water District 2022		Mendoza for City Council 2022		Nguyen for Supervisor 2022		Stephens for Costa Mesa Mayor 2022		Treseder for City Council 2022		Umberg for Senate 2022		Vasquez for City Council 2022 - District 3		Working Families and Communities in Support of Rex Richardson for Mayor, Kerr and Ricks-Oddie for City Council 2022		Yes on Measure LA Committee for Quality Education and Student Success		Zahra for City Council 2022		Lowenthal for Assembly 2022		Foley for Supervisor 2022		Lowenthal for Assembly 2022		Barrios for Orange City Council 2022		Becerra for City Council 2022		Chen for Assembly 2022		Gallagher for Tustin Council 2024		Gladson for Council 2022		Gomez for Mayor 2022		Khan for Irvine Mayor 2022		Lumbard for Mayor 2022		Ma'ae for City Council 2022		McGill for Moulton Niguel Water District 2022		Mendoza for City Council 2022		Nguyen for Supervisor 2022		Stephens for Costa Mesa Mayor 2022		Treseder for City Council 2022		Umberg for Senate 2022		Vasquez for City Council 2022 - District 3		Working Families and Communities in Support of Rex Richardson for Mayor, Kerr and Ricks-Oddie for City Council 2022		Yes on Measure LA Committee for Quality Education and Student Success		Zahra for City Council 2022
payee_namf		Josh		Katrina		Josh		Arianna		Phil		Phillip		Ryan		None		Becky		Farrah		Austin		Gloria		Lily		Committee to Re-Elect Nelida		Kim		John		Kathleen		Colonel (ret.) Tom		Cynthia		None		None		Ahmad		Josh		Katrina		Josh		Arianna		Phil		Phillip		Ryan		None		Becky		Farrah		Austin		Gloria		Lily		Committee to Re-Elect Nelida		Kim		John		Kathleen		Colonel (ret.) Tom		Cynthia		None		None		Ahmad
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		Los Angeles		Costa Mesa		Los Angeles		Orange		Santa Ana		Yorba Linda		Irvine		Orange		Fullerton		Long Beach		Irvine		Anaheim		Aliso Viejo		Santa Ana		Santa Ana		Santa Ana		Inglewood		Long Beach		Inglewood		Los Angeles		Long Beach		Fullerton		Los Angeles		Costa Mesa		Los Angeles		Orange		Santa Ana		Yorba Linda		Irvine		Orange		Fullerton		Long Beach		Irvine		Anaheim		Aliso Viejo		Santa Ana		Santa Ana		Santa Ana		Inglewood		Long Beach		Inglewood		Los Angeles		Long Beach		Fullerton
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		CA		CA		CA		CA
payee_zip4		90017		92626		90017		92866		92704		92886		92618		92869		92838		90802		92618		92805		92656		92704		92704		92703		90301		90802		90301		90017		90814		92835		90017		92626		90017		92866		92704		92886		92618		92869		92838		90802		92618		92805		92656		92704		92704		92703		90301		90802		90301		90017		90814		92835
expn_date		2022-09-27 00:00:00		2022-10-12 00:00:00		2022-10-12 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-09-27 00:00:00		2022-10-12 00:00:00		2022-10-12 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00
amount		-1000		2200		1000		500		1000		2000		1000		500		1000		550		2000		2000		500		1000		1200		2500		-450		3000		1000		5000		2500		1000		-1000		2200		1000		500		1000		2000		1000		500		1000		550		2000		2000		500		1000		1200		2500		-450		3000		1000		5000		2500		1000
cum_ytd		1000		6600		1000		500		1000		4000		1000		500		1000		550		2000		2000		500		1000		2900		2500		550		3000		1000		5000		2500		1000		1000		6600		1000		500		1000		4000		1000		500		1000		550		2000		2000		500		1000		2900		2500		550		3000		1000		5000		2500		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
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		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB
expn_dscr		Void Check Issued 4/18/2022		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Refund of Contribution		None		None		None		None		None		Void Check Issued 4/18/2022		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Refund of Contribution		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		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		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		1443482		1435506		1443482		1416295		1418052		1434989		1427211		1397503		1447497		1437827		1442896		1442319		1451300		1408187		1442910		1439034		1436692		1415628		1448920		1446966		1452899		1396977		1443482		1435506		1443482		1416295		1418052		1434989		1427211		1397503		1447497		1437827		1442896		1442319		1451300		1408187		1442910		1439034		1436692		1415628		1448920		1446966		1452899		1396977
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		Josh Lowenthal		Katrina Foley		Josh Lowenthal		Arianna Barrios		Phil Becerra		Phillip Chen		Ryan Gallagher		Adrienne Gladson		Becky Gomez		Farrah Khan		Austin Lumbard		Gloria Ma'ae		Lily McGill		Nelida Mendoza		Kim Nguyen		John Stephens		Kathleen Treseder		Tom Umberg		Cynthia Vasquez		None		None		Ash Zahra		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		ASM		CSU		ASM		CCM		CCM		ASM		CCM		CCM		MAY		MAY		MAY		CCM		OTH		CCM		CSU		MAY		CCM		SEN		CCM		None		None		CCM		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		Board Member		None		None		None		None		None		None		None		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		ASM		OTH		ASM		OTH		OTH		ASM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		SEN		OTH		None		None		OTH		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		Orange County		None		City of Orange		City of Santa Ana		None		City of Tustin		City of Orange		City of Tustin		City of Irvine		City of Tustin		City of Anaheim		Moulton Niguel Water District		City of Santa Ana		Orange County		City of Costa Mesa		City of Irvine		None		City of Mission Viejo		None		None		City of Fullerton		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
dist_no		69		2		69		1		4		59		None		6		None		None		None		2		None		2		2		None		None		34		3		None		None		5		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		Working Families and Communities in Support of Rex Richardson for Mayor, Kerr and Ricks-Oddie for City Council 2022		Funding for Homelessness Prevention, Affordable Housing, and Schools Ballot Measure		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		LA		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		Los Angeles County		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		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
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		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
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		1047853
filing_id		2743579
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-26 00:00:00
filing_type		22001

Table: filings

filing_id		2743579
filing_type		22001

Table: hdr

filing_id		2743579
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		2743579
amend_id		0
line_item		1
rec_type		RCPT
form_type		C
tran_id		NON695
entity_cd		OTH
ctrib_naml		Plumbers and Steamfitters Local Union No. 582
ctrib_namf		None
ctrib_namt		None
ctrib_nams		None
ctrib_city		Orange
ctrib_st		CA
ctrib_zip4		92868
ctrib_emp		None
ctrib_occ		None
ctrib_self		None
tran_type		None
rcpt_date		2022-10-17 00:00:00
date_thru		None
amount		224
cum_ytd		4644
cum_oth		None
ctrib_dscr		Accounting & Legal Services
cmte_id		None
tres_naml		None
tres_namf		None
tres_namt		None
tres_nams		None
tres_city		None
tres_st		None
tres_zip4		None
intr_naml		None
intr_namf		None
intr_namt		None
intr_nams		None
intr_city		None
intr_st		None
intr_zip4		None
intr_emp		None
intr_occ		None
intr_self		None
cand_naml		None
cand_namf		None
cand_namt		None
cand_nams		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
memo_code		X
memo_refno		None
bakref_tid		None
xref_schnm		None
xref_match		None
int_rate		None
intr_cmteid		None

Table: smry

filing_id		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579
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		1		2		3		4		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		C		C		C		D		D		D		E		E		E		E		B1		B1		B1		H		H		H
amount_a		5668		0		5668		0		5668		30000		0		30000		0		0		30000		62087		5668		0		30000		37755		0		0		0		0		5668		5668		0		0		0		30000		0		30000		30000		0		0		30000		0		0		0		0		0		0
amount_b		52811		0		52811		0		52811		79000		0		79000		0		0		79000		None		None		None		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		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579		2743579
amend_id		0		0		0		0		0		0		0		0		0		0
line_item		1		2		3		4		5		6		7		8		9		10
pform_type		D		D		D		D		D		D		D		D		D		D
ptran_id		EXP670		EXP670		EXP671		EXP671		EXP688		EXP688		EXP687		EXP674		EXP674		EXP676
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
elec_amount		0		1000		0		1000		2000		2000		249		7400		3000		500
elec_code		P		G		P		G		P		G		G		P		G		P