Home

Filing ID: 2743554

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

Table: cvr2_campaign_disclosure

filing_id		2743554
amend_id		0
line_item		1
rec_type		CVR2
form_type		F460
tran_id		OFC1
entity_cd		ATR
title		None
mail_city		None
mail_st		None
mail_zip4		None
f460_part		3
cmte_id		None
enty_naml		Rice
enty_namf		Brian
enty_namt		None
enty_nams		None
enty_city		Sacramento
enty_st		CA
enty_zip4		95833
enty_phon		(916) 921-9111
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		2743554		2743554
amend_id		0		0
line_item		1		2
rec_type		CVR3		CVR3
form_type		F460		F460
tran_id		VER_1.1		VER_2.2
entity_cd		ATR		OFF
sig_date		2022-10-25 00:00:00		2022-10-25 00:00:00
sig_loc		None		None
sig_naml		Brian Rice		Brian Rice
sig_namf		None		None
sig_namt		None		None
sig_nams		None		None

Table: cvr_campaign_disclosure

filing_id		2743554
amend_id		0
rec_type		CVR
form_type		F460
filer_id		744058
entity_cd		RCP
filer_naml		California Professional Firefighters Political Action Committee
filer_namf		None
filer_namt		None
filer_nams		None
report_num		000
rpt_date		2022-10-25 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		Sacramento
filer_st		CA
filer_zip4		95833
filer_phon		(916) 921-9111
filer_fax		None
file_email		info@olsonhagel.com
mail_city		Sacramento
mail_st		CA
mail_zip4		95814
tres_naml		Lopez
tres_namf		Mike
tres_namt		None
tres_nams		None
tres_city		Sacramento
tres_st		CA
tres_zip4		95833
tres_phon		(916) 921-9111
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: debt

filing_id		2743554		2743554
amend_id		0		0
line_item		1		2
rec_type		DEBT		DEBT
form_type		F		F
tran_id		PAY17149		PAY17150
entity_cd		OTH		OTH
payee_naml		LG Campaigns		Street Level Campaigns
payee_namf		None		None
payee_namt		None		None
payee_nams		None		None
payee_city		Sacramento		Sierra Madre
payee_st		CA		CA
payee_zip4		95822		91024
beg_bal		0		0
amt_incur		5000		45000
amt_paid		0		0
end_bal		5000		45000
expn_code		IND		IND
expn_dscr		Consulting/Support/Angelique Ashby		Text Messages/Support/Angelique Ashby
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		PAY17149		PAY17150
bakref_tid		None		None
xref_schnm		None		None
xref_match		None		None

Table: expn

filing_id		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554
amend_id		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
line_item		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		20		21		22		23		24		25		26		27		28		29		30		31		32		33		34		35		36		37		38		39		40		41		42		43		44		45		46		47		48		49		50		51		52		53		54		55		56		57		58		59		60		61		62		63		64		65		66		67		68		69		70		71		72		73		74		75		76		77		78		79		80		81		82		83		84		85		86		87		88		89		90		91		92		93		94		95		96		97		98		99		100		101		102		103		104		105		106		107		108
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		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		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		D		D		D		D		D		D		D		D		D		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		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		E		E		E		E		E		E
tran_id		EXP17100		EXP17126		EXP17099		EXP17134		EXP17098		EXP17140		EXP17116		EXP17095		EXP17144		EXP17097		EXP17141		EXP17139		EXP17138		EXP17127		EXP17101		EXP17108		EXP17118		EXP17111		EXP17129		EXP17130		EXP17107		EXP17128		EXP17110		EXP17089		EXP17109		EXP17131		EXP17125		EXP17094		EXP17117		PDT1614		EXP17090		EXP17092		EXP17112		EXP17103		EXP17102		EXP17132		EXP17115		EXP17137		PDT1615		EXP17105		EXP17145		EXP17104		EXP17113		EXP17135		EXP17123		EXP17114		EXP17136		EXP17148		EXP17093		EXP17124		PDT1616		EXP17142		EXP17133		EXP17100		EXP17126		EXP17099		EXP17134		EXP17098		EXP17140		EXP17116		EXP17095		EXP17144		EXP17096		EXP17097		EXP17141		EXP17139		EXP17138		EXP17127		EXP17101		EXP17106		EXP17146		EXP17108		EXP17118		EXP17111		EXP17129		EXP17130		EXP17107		EXP17128		EXP17110		EXP17089		EXP17109		EXP17131		EXP17125		EXP17094		EXP17117		EXP17119		EXP17090		EXP17092		EXP17112		EXP17103		EXP17143		EXP17102		EXP17132		EXP17115		EXP17137		EXP17105		EXP17145		EXP17104		EXP17113		EXP17135		EXP17123		EXP17114		EXP17136		EXP17148		EXP17093		EXP17124		EXP17142		EXP17133
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		IND		COM		COM		COM		COM		COM		COM		COM		COM		IND		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		IND		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		OTH		COM		COM		COM		COM		COM		COM		OTH		OTH		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		IND		COM		COM		COM		COM		OTH		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM
payee_naml		Addis for Assembly 2022		Allen for Senate 2022		Alvarez for Assembly 2022		Basgall for Clovis City Council 2022		Blakespear for Senate 2022		Boerner Horvath for Assembly 2022		Bonta for CA Attorney General 2022		California Democratic Party		California Democratic Party		California Republican Party		Carrillo for Assembly 2022		Cervantes for Assembly 2022		Chavez Zbur for Assembly 2022		Connolly for Assembly 2022		Dixon for Assembly 2022		Flora for Assembly 2022		Fong for Assembly 2022		Gallagher for Assembly 2022		Gipson for Assembly 2022		Glazer for Lt. Governor 2026		Hart for Assembly 2022		Haus for Clovis City Council 2022		Hertzberg for Senate 2018 Officeholder Account		Hertzberg for Supervisor 2022		Hertzberg for Supervisor 2022		International Association of Fire Fighters Local 1230 Political Activity Committee		Kalra for Assembly 2022		Maienschein for Assembly 2022		McKinnor for Assembly 2022		Miller (I)		Mullin for Assembly 2020 Officeholder Account		Muratsuchi for Assembly 2022		Nathan Sweet for School Board 2022		Nguyen for Assembly 2022		Papan for Assembly 2022		Phanco for Clovis City Council 2022		Rahn for Assembly 2022		Ramos for Assembly 2022		Reece (I)		Re-Elect Fiona Ma for State Treasurer 2022		Retirees for Walker for CalPERS Board 2022		Rizvi for Assembly 2022		Sakaris for CSD Director 2022		Santiago for Assembly 2022		Shannon Grove for Senate 2022		Ting for Assembly 2022		Ting for Assembly 2022		Tracy Firefighters Association PAC		Valencia for Assembly 2022		Vazquez for State Board of Equalization 2022		Vierra (I)		Wilk for Lt. Governor 2026		Wilson for Assembly 2022		Addis for Assembly 2022		Allen for Senate 2022		Alvarez for Assembly 2022		Basgall for Clovis City Council 2022		Blakespear for Senate 2022		Boerner Horvath for Assembly 2022		Bonta for CA Attorney General 2022		California Democratic Party		California Democratic Party		California Professional Firefighters		California Republican Party		Carrillo for Assembly 2022		Cervantes for Assembly 2022		Chavez Zbur for Assembly 2022		Connolly for Assembly 2022		Dixon for Assembly 2022		Firefighters First Credit Union		Firefighters Print & Design, Inc.		Flora for Assembly 2022		Fong for Assembly 2022		Gallagher for Assembly 2022		Gipson for Assembly 2022		Glazer for Lt. Governor 2026		Hart for Assembly 2022		Haus for Clovis City Council 2022		Hertzberg for Senate 2018 Officeholder Account		Hertzberg for Supervisor 2022		Hertzberg for Supervisor 2022		International Association of Fire Fighters Local 1230 Political Activity Committee		Kalra for Assembly 2022		Maienschein for Assembly 2022		McKinnor for Assembly 2022		Morrow		Mullin for Assembly 2020 Officeholder Account		Muratsuchi for Assembly 2022		Nathan Sweet for School Board 2022		Nguyen for Assembly 2022		Olson Remcho LLP		Papan for Assembly 2022		Phanco for Clovis City Council 2022		Rahn for Assembly 2022		Ramos for Assembly 2022		Re-Elect Fiona Ma for State Treasurer 2022		Retirees for Walker for CalPERS Board 2022		Rizvi for Assembly 2022		Sakaris for CSD Director 2022		Santiago for Assembly 2022		Shannon Grove for Senate 2022		Ting for Assembly 2022		Ting for Assembly 2022		Tracy Firefighters Association PAC		Valencia for Assembly 2022		Vazquez for State Board of Equalization 2022		Wilk for Lt. Governor 2026		Wilson for Assembly 2022
payee_namf		Dawn		Ben		David		Matt		Catherine		Tasha		None		None		None		None		Wendy		Sabrina		Rick		Damon		Diane		Heath		Vince		None		None		None		Gregg		Desi		None		Bob		Bob		None		Ash		Brian		Tina		Craig		Kevin		None		None		Diedre Thu-Ha		None		Josh		None		Re-Elect James		Pete		None		None		Fauzia		Peter		Miguel		None		Phil		Phil		None		Avelino		None		John		None		Lori		Dawn		Ben		David		Matt		Catherine		Tasha		None		None		None		None		None		Wendy		Sabrina		Rick		Damon		Diane		None		None		Heath		Vince		None		None		None		Gregg		Desi		None		Bob		Bob		None		Ash		Brian		Tina		Douglas		Kevin		None		None		Diedre Thu-Ha		None		None		Josh		None		Re-Elect James		None		None		Fauzia		Peter		Miguel		None		Phil		Phil		None		Avelino		None		None		Lori
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_city		Sacramento		Sacramento		Sacramento		Fresno		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		San Rafael		Sacramento		Hilmar		Bakersfield		Sacramento		Sacramento		Orinda		Sacramento		Clovis		Sacramento		Sacramento		Sacramento		Martinez		Sacramento		Sacramento		Sacramento		None		Sacramento		Sacramento		Moorpark		Sacramento		Sacramento		Fresno		Wilton		Sacramento		None		Sacramento		Sacramento		Corona		Elk Grove		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		None		Elk Grove		Sacramento		Sacramento		Sacramento		Sacramento		Fresno		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		San Rafael		Sacramento		Los Angeles		Sacramento		Hilmar		Bakersfield		Sacramento		Sacramento		Orinda		Sacramento		Clovis		Sacramento		Sacramento		Sacramento		Martinez		Sacramento		Sacramento		Sacramento		Merced		Sacramento		Sacramento		Moorpark		Sacramento		Sacramento		Sacramento		Fresno		Wilton		Sacramento		Sacramento		Sacramento		Corona		Elk Grove		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Elk Grove		Sacramento
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		None		CA		CA		CA		CA		CA		CA		CA		CA		None		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		None		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		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
payee_zip4		95814		95814		95814		93704		95814		95815		95814		95811		95811		95814		95814		95814		95814		94903		95814		95324		93314		95819		95814		94563		95814		93612		95814		95814		95814		94553		95814		95814		95835		None		95814		95814		93021		95814		95814		93710		95693		95814		None		95864		95814		92879		95758		95814		95814		95814		95814		95814		95814		95814		None		95624		95814		95814		95814		95814		93704		95814		95815		95814		95811		95811		95833		95814		95814		95814		95814		94903		95814		90041		95833		95324		93314		95819		95814		94563		95814		93612		95814		95814		95814		94553		95814		95814		95835		95340		95814		95814		93021		95814		95814		95814		93710		95693		95814		95864		95814		92879		95758		95814		95814		95814		95814		95814		95814		95814		95624		95814
expn_date		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-10-06 00:00:00		2022-09-28 00:00:00		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-10 00:00:00		2022-09-28 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-10-10 00:00:00		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-10-14 00:00:00		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-06 00:00:00		2022-10-14 00:00:00		2022-10-10 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-10-06 00:00:00		2022-09-28 00:00:00		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-09-28 00:00:00		2022-09-28 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-10-14 00:00:00		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-06 00:00:00		2022-10-14 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00
amount		1000		1000		9700		1000		9700		1500		16200		100000		50000		25000		7200		5000		2500		4700		1000		2500		1000		2000		5700		1000		2500		1000		3000		-3000		1500		2500		4900		7200		9700		382		-1000		1000		3000		3500		1000		1000		9700		1000		382		2500		9700		2500		1000		2500		-1000		3700		5000		855		2500		-1000		382		1000		1000		1000		1000		9700		1000		9700		1500		16200		100000		50000		30000		25000		7200		5000		2500		4700		1000		252		1145		2500		1000		2000		5700		1000		2500		1000		3000		-3000		1500		2500		4900		7200		9700		500		-1000		1000		3000		3500		4635		1000		1000		9700		1000		2500		9700		2500		1000		2500		-1000		3700		5000		855		2500		-1000		1000		1000
cum_ytd		10700		4000		9700		1000		9700		5500		16200		388290		388290		52552		11700		8000		9500		19400		3500		5500		3000		6000		17400		2000		6000		1000		4000		1500		1500		2500		4900		12900		9700		382		0		4000		3000		3500		10700		1000		12200		3000		382		5000		19400		2500		1000		6500		1000		14700		14700		855		7400		0		382		2000		3000		10700		4000		9700		1000		9700		5500		16200		388290		388290		300000		52552		11700		8000		9500		19400		3500		422		86013		5500		3000		6000		17400		2000		6000		1000		4000		1500		1500		2500		4900		12900		9700		500		0		4000		3000		3500		29900		10700		1000		12200		3000		5000		19400		2500		1000		6500		1000		14700		14700		855		7400		0		2000		3000
cum_oth		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		MON		MON		MON		MON		MON		MON		MON		IND		MON		MON		MON		MON		MON		MON		MON		MON		IND		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		IND		MON		MON		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		OFC		CTB		CTB		CTB		CTB		CTB		CTB		OFC		IND		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		OFC		CTB		CTB		CTB		CTB		PRO		CTB		CTB		CTB		CTB		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		Void Check		None		None		None		None		None		Sign		Void Check		None		None		None		None		None		None		None		Sign		None		None		None		None		None		Void Check		None		None		None		None		Void Check		Sign		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Sign/Support/Craig Miller, Pete Reece, John Vierra		None		None		None		None		None		None		None		None		Void Check		None		None		None		None		None		None		Void Check		None		None		None		None		None		None		None		None		None		None		None		None		None		Void Check		None		None		None		None		Void Check		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1442437		1414553		1443355		1449851		1436941		1434881		1437201		741666		741666		None		810163		1434630		1435160		1437343		1441976		1443172		None		None		1435262		1435504		1434393		1434878		1435128		1444010		1452428		1414093		1443772		1443772		744488		1434891		1435006		1444546		None		1447871		1435331		1453020		1444098		None		1442617		1451384		1443672		1435373		1414254		1447543		1445659		1452076		1435164		1414696		1437844		1437844		1230611		1446169		1417133		1435661		1442763
tres_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		Dawn Addis		Ben Allen		David Alvarez		Matt Basgall		Catherine Blakespear		Tasha Boerner Horvath		Rob Bonta		California Democratic Party		California Democratic Party		California Republican Party		Wendy Carrillo		Sabrina Cervantes		Rick Chavez Zbur		Damon Connolly		Diane Dixon		Heath Flora		Vince Fong		James Gallagher		Mike Gipson		Steve Glazer		Gregg Hart		Desi Haus		Robert Hertzberg (O)		Bob Hertzberg		Bob Hertzberg		International Association of Fire Fighters Local 1230 Political Activity Committee		Ash Kalra		Brian Maienschein		Tina McKinnor		Craig Miller		Kevin Mullin (O)		Al Muratsuchi		Nathan Sweet		Diedre Thu-Ha Nguyen		Diane Papan		Josh Phanco		Matthew Rahn		James Ramos		Pete Reece		Fiona Ma		Yvonne Walker		Fauzia Rizvi		Peter Sakaris		Miguel Santiago		Shannon Grove		Phil Ting		Phil Ting		None		Avelino Valencia		Tony Vazquez		John Vierra		Scott Wilk		Lori Wilson		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		SEN		ASM		CCM		SEN		ASM		ATT		None		None		None		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		LTG		ASM		CCM		SEN		CSU		CSU		None		ASM		ASM		ASM		OTH		ASM		ASM		OTH		ASM		ASM		CCM		ASM		ASM		OTH		TRE		OTH		ASM		OTH		ASM		SEN		ASM		ASM		None		ASM		OTH		OTH		LTG		ASM		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
offic_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Board Member		None		None		Board Member		None		None		None		None		None		Board Member		None		Board Member		None		Board Member		None		None		None		None		None		None		Board Member		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		None		None		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		SEN		ASM		CIT		SEN		ASM		STW		None		None		None		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		STW		ASM		CIT		SEN		OTH		OTH		None		ASM		ASM		ASM		OTH		ASM		ASM		OTH		ASM		ASM		CIT		ASM		ASM		OTH		STW		OTH		ASM		OTH		ASM		SEN		ASM		ASM		None		ASM		OTH		OTH		STW		ASM		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		City of Clovis		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		City of Clovis		None		Los Angeles County		Los Angeles County		None		None		None		None		Tracy Rural Fire District		None		None		Moorpark Unified School District		None		None		City of Clovis		None		None		Tracy Rural Fire District		None		CalPERS Board		None		Cosumnes Community Service District		None		None		None		None		None		None		Board of Equalization		Tracy Rural Fire 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		None		None		None		None		None		None		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		30		24		80		None		38		77		None		None		None		None		52		58		51		12		72		9		32		3		65		None		37		None		18		3		3		None		25		76		61		None		22		66		1		70		21		None		71		45		None		None		None		63		2		54		12		19		19		None		68		3		None		None		11		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
off_s_h_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_name		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_num		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_juris		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		S		S		S		S		S		S		S		S		S		S		S		S		S		S		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
memo_code		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
memo_refno		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bakref_tid		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
xref_schnm		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
xref_match		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		1018977
filing_id		2743554
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-25 00:00:00
filing_type		22001

Table: filings

filing_id		2743554
filing_type		22001

Table: hdr

filing_id		2743554
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		2743554
amend_id		0
line_item		1
rec_type		RCPT
form_type		I
tran_id		INC17120
entity_cd		OTH
ctrib_naml		First Internet Bank of Indiana
ctrib_namf		None
ctrib_namt		None
ctrib_nams		None
ctrib_city		Fishers
ctrib_st		IN
ctrib_zip4		46037
ctrib_emp		None
ctrib_occ		None
ctrib_self		None
tran_type		None
rcpt_date		2022-09-30 00:00:00
date_thru		None
amount		670
cum_ytd		0
cum_oth		None
ctrib_dscr		Interest Earned
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		None
memo_refno		None
bakref_tid		None
xref_schnm		None
xref_match		None
int_rate		None
intr_cmteid		None

Table: smry

filing_id		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554
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		176427		0		176427		0		176427		362987		0		362987		50000		0		412987		937641		176427		675		362987		751757		0		0		50000		0		176427		176427		0		0		0		0		0		0		327600		0		327600		362987		0		0		362987		50000		0		50000		0		0		0		670		5		0		675
amount_b		1333929		0		1333929		0		1333929		1915494		0		1915494		50000		0		1965494		None		None		None		None		None		None		None		None		None		None		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		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554		2743554
amend_id		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
line_item		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		20		21		22		23		24		25		26		27		28		29		30		31		32		33		34		35		36		37		38		39		40		41		42		43		44		45		46		47		48		49		50		51		52		53		54		55		56		57		58		59		60		61		62		63
pform_type		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D
ptran_id		EXP17100		EXP17100		EXP17126		EXP17126		EXP17099		EXP17098		EXP17140		EXP17140		EXP17116		EXP17116		EXP17141		EXP17141		EXP17139		EXP17139		EXP17138		EXP17138		EXP17127		EXP17127		EXP17101		EXP17101		EXP17108		EXP17108		EXP17118		EXP17118		EXP17111		EXP17111		EXP17129		EXP17129		EXP17130		EXP17107		EXP17107		EXP17125		EXP17125		EXP17094		EXP17094		EXP17117		EXP17092		EXP17092		EXP17103		EXP17102		EXP17102		EXP17115		EXP17115		EXP17137		EXP17137		EXP17105		EXP17105		EXP17145		EXP17145		EXP17104		EXP17135		EXP17135		EXP17123		EXP17123		EXP17114		EXP17114		EXP17136		EXP17136		EXP17093		EXP17093		EXP17124		EXP17142		EXP17133
elec_date		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2026-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2026-01-01 00:00:00		2022-01-01 00:00:00
elec_amount		9700		1000		9700		2300		9700		9700		6000		3500		16200		16200		5000		9700		6000		6000		6000		3500		9700		9700		2500		1000		5250		4500		1000		2000		2000		4000		9700		9700		4000		2500		3500		2000		4900		9700		9200		9700		6000		2000		3500		9700		1000		2500		9700		4000		2000		7000		4000		9700		9700		2500		5000		4500		4000		1000		5000		9700		5000		9700		4900		2500		1000		4000		3000
elec_code		P		G		P		G		G		G		P		G		P		G		P		G		P		G		P		G		P		G		P		G		P		G		P		G		P		G		P		G		P		P		G		P		G		P		G		G		P		G		G		P		G		P		G		P		G		P		G		R		O		G		P		G		P		G		P		G		P		G		P		G		P		P		G