Home

Filing ID: 2742906

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

Table: cvr2_campaign_disclosure

filing_id		2742906
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		YIN
enty_namf		FLORA
enty_namt		None
enty_nams		None
enty_city		LOS ANGELES
enty_st		CA
enty_zip4		90071
enty_phon		(213) 624-6200
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		2742906
amend_id		0
line_item		1
rec_type		CVR3
form_type		F460
tran_id		VER_1.1
entity_cd		ATR
sig_date		2022-10-26 00:00:00
sig_loc		None
sig_naml		FLORA YIN
sig_namf		None
sig_namt		None
sig_nams		None

Table: cvr_campaign_disclosure

filing_id		2742906
amend_id		0
rec_type		CVR
form_type		F460
filer_id		802010
entity_cd		RCP
filer_naml		ORANGE COUNTY BUSINESS COUNCIL'S BIZ PAC
filer_namf		None
filer_namt		None
filer_nams		None
report_num		000
rpt_date		2022-10-27 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		IRVINE
filer_st		CA
filer_zip4		92614
filer_phon		(949) 476-2242
filer_fax		(213) 623-1692
file_email		[email protected]
mail_city		LOS ANGELES
mail_st		CA
mail_zip4		90071
tres_naml		BALL
tres_namf		JEFFREY
tres_namt		None
tres_nams		None
tres_city		IRVINE
tres_st		CA
tres_zip4		92614
tres_phon		(949) 476-2242
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		2742906		2742906
amend_id		0		0
line_item		1		2
rec_type		DEBT		DEBT
form_type		F		F
tran_id		PAY1319		PAY1343
entity_cd		OTH		OTH
payee_naml		REED & DAVIDSON, LLP		REED & DAVIDSON, LLP
payee_namf		None		None
payee_namt		None		None
payee_nams		None		None
payee_city		LOS ANGELES		LOS ANGELES
payee_st		CA		CA
payee_zip4		90071		90071
beg_bal		141		0
amt_incur		0		60
amt_paid		0		0
end_bal		141		60
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		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906
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
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
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
form_type		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
tran_id		EXP1326		EXP1327		EXP1338		EXP1337		EXP1330		EXP1336		EXP1328		EXP1322		EXP1333		EXP1332		EXP1335		EXP1321		EXP1334		EXP1331		EXP1323		EXP1320		EXP1329		EXP1326		EXP1327		EXP1338		EXP1337		EXP1330		EXP1336		EXP1328		EXP1322		EXP1333		EXP1332		EXP1335		EXP1321		EXP1334		EXP1324		EXP1331		EXP1323		EXP1320		EXP1329
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		OTH		COM		COM		COM		COM
payee_naml		BARRIOS FOR ORANGE CITY COUNCIL 2022		BILODEAU FOR ORANGE CITY COUNCIL 2022		COTTIE PETRIE-NORRIS FOR ASSEMBLY 2022		DIANE DIXON FOR ASSEMBLY 2022		FRIENDS OF STEVE JONES FOR MAYOR 2022		JANET NGUYEN FOR SENATE 2022		JOHN GYLLENHAMMER FOR ORANGE CITY COUNCIL 2022		KATHY TAVOULARIS FOR ORANGE CITY COUNCIL 2022		KATRINA FOLEY FOR SUPERVISOR 2022		KIM NGUYEN FOR SUPERVISOR 2022		LUMBARD FOR MAYOR 2022		MARK A. MURPHY FOR MAYOR 2022		PAT BATES FOR SUPERVISOR 2022		REINHART FOR IRWD BOARD OF DIRECTORS - 2022		RODRIGUEZ FOR YORBA LINDA CITY COUNCIL 2022		SHARON QUIRK-SILVA FOR ASSEMBLY 2022		WEIGAND FOR CITY COUNCIL 2022		BARRIOS FOR ORANGE CITY COUNCIL 2022		BILODEAU FOR ORANGE CITY COUNCIL 2022		COTTIE PETRIE-NORRIS FOR ASSEMBLY 2022		DIANE DIXON FOR ASSEMBLY 2022		FRIENDS OF STEVE JONES FOR MAYOR 2022		JANET NGUYEN FOR SENATE 2022		JOHN GYLLENHAMMER FOR ORANGE CITY COUNCIL 2022		KATHY TAVOULARIS FOR ORANGE CITY COUNCIL 2022		KATRINA FOLEY FOR SUPERVISOR 2022		KIM NGUYEN FOR SUPERVISOR 2022		LUMBARD FOR MAYOR 2022		MARK A. MURPHY FOR MAYOR 2022		PAT BATES FOR SUPERVISOR 2022		REED & DAVIDSON, LLP		REINHART FOR IRWD BOARD OF DIRECTORS - 2022		RODRIGUEZ FOR YORBA LINDA CITY COUNCIL 2022		SHARON QUIRK-SILVA FOR ASSEMBLY 2022		WEIGAND FOR CITY COUNCIL 2022
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
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
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
payee_city		ORANGE		ORANGE		SACRAMENTO		TUSTIN		GARDEN GROVE		GARDEN GROVE		ORANGE		IRVINE		COSTA MESA		SANTA ANA		IRVINE		ORANGE		TUSTIN		IRVINE		YORBA LINDA		SACRAMENTO		NEWPORT BEACH		ORANGE		ORANGE		SACRAMENTO		TUSTIN		GARDEN GROVE		GARDEN GROVE		ORANGE		IRVINE		COSTA MESA		SANTA ANA		IRVINE		ORANGE		TUSTIN		LOS ANGELES		IRVINE		YORBA LINDA		SACRAMENTO		NEWPORT BEACH
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
payee_zip4		92866		92867		95815		92780		92841		92840		92869		92618		92626		92704		92618		92869		92780		92618		92887		95841		92660		92866		92867		95815		92780		92841		92840		92869		92618		92626		92704		92618		92869		92780		90071		92618		92887		95841		92660
expn_date		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-09-30 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-09-30 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-09-30 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-09-30 00:00:00		2022-10-14 00:00:00		2022-10-06 00:00:00		2022-10-14 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-10-14 00:00:00
amount		500		500		1000		1500		500		2500		500		500		1500		1000		1000		1000		1500		2000		1000		1000		250		500		500		1000		1500		500		2500		500		500		1500		1000		1000		1000		1500		1000		2000		1000		1000		250
cum_ytd		500		500		3500		1500		500		2500		500		750		1500		1000		1000		1000		1500		2000		2000		2096		250		500		500		3500		1500		500		2500		500		750		1500		1000		1000		1000		1500		10508		2000		2000		2096		250
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
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
expn_code		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		PRO		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
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
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
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
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
cmte_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1416295		1452376		1435043		1443172		1443321		1443408		1445061		1438389		1435506		1442910		1442896		1394864		1265511		None		1287873		1402990		1434995		1442645
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
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
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
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
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
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
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
cand_naml		ARIANNA BARRIOS		DENIS BILODEAU		COTTIE PETRIE-NORRIS		DIANE DIXON		STEVE JONES		JANET NGUYEN		JOHN GYLLENHAMMER		KATHY TAVOULARIS		KATRINA FOLEY		KIM NGUYEN		AUSTIN LUMBARD		MARK A. MURPHY		PAT BATES		DOUG REINHART		CARLOS RODRIGUEZ		SHARON QUIRK-SILVA		ERIK WEIGAND		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
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
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
office_cd		CCM		CCM		ASM		ASM		MAY		SEN		CCM		CCM		CSU		CSU		MAY		MAY		CSU		OTH		CCM		ASM		CCM		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		DIRECTOR		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_cd		OTH		OTH		ASM		ASM		OTH		SEN		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		ASM		OTH		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_dscr		CITY OF ORANGE, #1		CITY OF ORANGE, #4		None		None		CITY OF GARDEN GROVE		None		CITY OF ORANGE, #6		CITY OF ORANGE, #3		ORANGE COUNTY, #5		ORANGE COUNTY, #2		CITY OF TUSTIN		CITY OF ORANGE		ORANGE COUNTY, #5		IRVINE RANCH WATER DISTRICT, #3		CITY OF YORBA LINDA		None		CITY OF NEWPORT BEACH, #3		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
dist_no		None		None		73		72		None		36		None		None		None		None		None		None		None		None		None		67		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
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
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
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
sup_opp_cd		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
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
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
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
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
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
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

Table: filer_filings

filer_id		1029815
filing_id		2742906
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-27 00:00:00
filing_type		22001

Table: filings

filing_id		2742906
filing_type		22001

Table: hdr

filing_id		2742906
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		2742906		2742906		2742906
amend_id		0		0		0
line_item		1		2		3
rec_type		RCPT		RCPT		RCPT
form_type		A		A		A
tran_id		INC1339		INC1325		INC1342
entity_cd		OTH		OTH		COM
ctrib_naml		CHEVRON		COX COMMUNICATIONS AND AFFILIATED ENTITIES		WESTERN STATES PETROLEUM ASSOCIATION CALIFORNIA PAC (AKA WSPA CA PAC)
ctrib_namf		None		None		None
ctrib_namt		None		None		None
ctrib_nams		None		None		None
ctrib_city		SAN RAMON		SAN DIEGO		SAN RAFAEL
ctrib_st		CA		CA		CA
ctrib_zip4		94583		92111		94901
ctrib_emp		None		None		None
ctrib_occ		None		None		None
ctrib_self		None		None		None
tran_type		None		None		None
rcpt_date		2022-10-10 00:00:00		2022-09-26 00:00:00		2022-10-17 00:00:00
date_thru		None		None		None
amount		5000		5000		2500
cum_ytd		10000		5000		2500
cum_oth		None		None		None
ctrib_dscr		None		None		None
cmte_id		None		None		1414539
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
intr_naml		None		None		None
intr_namf		None		None		None
intr_namt		None		None		None
intr_nams		None		None		None
intr_city		None		None		None
intr_st		None		None		None
intr_zip4		None		None		None
intr_emp		None		None		None
intr_occ		None		None		None
intr_self		None		None		None
cand_naml		None		None		None
cand_namf		None		None		None
cand_namt		None		None		None
cand_nams		None		None		None
office_cd		None		None		None
offic_dscr		None		None		None
juris_cd		None		None		None
juris_dscr		None		None		None
dist_no		None		None		None
off_s_h_cd		None		None		None
bal_name		None		None		None
bal_num		None		None		None
bal_juris		None		None		None
sup_opp_cd		None		None		None
memo_code		None		None		None
memo_refno		None		INC1325		None
bakref_tid		None		None		None
xref_schnm		None		None		None
xref_match		None		None		None
int_rate		None		None		None
intr_cmteid		None		None		None

Table: smry

filing_id		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906
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
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
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
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
amount_a		12500		0		12500		0		12500		18750		0		18750		60		0		18810		200892		12500		0		18750		194642		0		0		201		12500		0		12500		0		0		0		0		0		0		17750		0		17750		18750		0		0		18750		60		0		60		0		0		0		0		0		0		0
amount_b		42150		0		42150		0		42150		46850		0		46850		201		0		47050		None		None		None		None		None		None		None		None		None		None		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
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

Table: splt

filing_id		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906		2742906
amend_id		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
pform_type		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D
ptran_id		EXP1326		EXP1327		EXP1338		EXP1338		EXP1337		EXP1330		EXP1336		EXP1328		EXP1322		EXP1333		EXP1332		EXP1335		EXP1321		EXP1334		EXP1323		EXP1320		EXP1320		EXP1329
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
elec_amount		500		500		1000		3500		1500		500		2500		500		750		1500		1000		1000		1000		1500		2250		2096		1000		250
elec_code		G		G		P		G		G		G		G		G		G		G		G		G		G		G		G		P		G		G