Home

Filing ID: 2743496

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

Table: cvr2_campaign_disclosure

filing_id		2743496		2743496
amend_id		0		0
line_item		1		2
rec_type		CVR2		CVR2
form_type		F460		F460
tran_id		NIC2		OFC1
entity_cd		COM		ATR
title		None		None
mail_city		None		None
mail_st		None		None
mail_zip4		None		None
f460_part		5b		3
cmte_id		1405939		None
enty_naml		Assemblyman Vince Fong's Ballot Measure Committee for Central Valley Prosperity		Burch
enty_namf		None		Bryan
enty_namt		None		None
enty_nams		None		None
enty_city		Roseville		Roseville
enty_st		CA		CA
enty_zip4		95747		95747
enty_phon		916-476-6926		626-260-6037
enty_fax		None		None
enty_email		None		bryan@politicalfinancesolutions.com
tres_naml		Klemin		None
tres_namf		Rebecca		None
tres_namt		None		None
tres_nams		None		None
control_yn		Y		None
office_cd		None		None
offic_dscr		None		None
juris_cd		None		None
juris_dscr		None		None
dist_no		None		None
off_s_h_cd		None		None
bal_name		None		None
bal_num		None		None
bal_juris		None		None
sup_opp_cd		None		None

Table: cvr3_verification_info

filing_id		2743496		2743496
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		TRE		CAO
sig_date		2022-10-27 00:00:00		2022-10-27 00:00:00
sig_loc		None		None
sig_naml		Rebecca Klemin		Vince Fong
sig_namf		None		None
sig_namt		None		None
sig_nams		None		None

Table: cvr_campaign_disclosure

filing_id		2743496
amend_id		0
rec_type		CVR
form_type		F460
filer_id		1435504
entity_cd		CTL
filer_naml		Vince Fong for Assembly 2022
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		Bakersfield
filer_st		CA
filer_zip4		93314
filer_phon		661-900-3299
filer_fax		None
file_email		vincentfong97@gmail.com
mail_city		None
mail_st		None
mail_zip4		None
tres_naml		Klemin
tres_namf		Rebecca
tres_namt		None
tres_nams		None
tres_city		Roseville
tres_st		CA
tres_zip4		95747
tres_phon		818-675-5522
tres_fax		None
tres_email		None
cmtte_type		C
control_yn		Y
sponsor_yn		N
primfrm_yn		N
brdbase_yn		N
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		Fong
cand_namf		Vince
cand_namt		None
cand_nams		None
cand_city		Bakersfield
cand_st		CA
cand_zip4		93314
cand_phon		661-900-3299
cand_fax		None
cand_email		vincentfong97@gmail.com
bal_name		None
bal_num		None
bal_juris		None
office_cd		ASM
offic_dscr		None
juris_cd		ASM
juris_dscr		None
dist_no		34
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		2743496
amend_id		0
line_item		1
rec_type		DEBT
form_type		F
tran_id		PAY1248
entity_cd		OTH
payee_naml		US Bank Visa - Fong
payee_namf		None
payee_namt		None
payee_nams		None
payee_city		Los Angeles
payee_st		CA
payee_zip4		90071
beg_bal		2339
amt_incur		0
amt_paid		2339
end_bal		0
expn_code		CMP
expn_dscr		None
cmte_id		None
tres_naml		None
tres_namf		None
tres_namt		None
tres_nams		None
tres_city		None
tres_st		None
tres_zip4		None
memo_code		None
memo_refno		None
bakref_tid		None
xref_schnm		None
xref_match		None

Table: expn

filing_id		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496
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
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
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
form_type		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		G		G		G		G		G		G		G		G		G
tran_id		EXP1371		EXP1296		EXP1294		EXP1346		EXP1295		EXP1385		EXP1346		EXP1388		EXP1378		EXP1392		EXP1399		EXP1371		EXP1396		EXP1402		EXP1379		EXP1403		EXP1384		EXP1391		EXP1382		EXP1400		EXP1294		EXP1295		EXP1380		EXP1407		EXP1296		EXP1401		EXP1394		EXP1389		EXP1386		EXP1406		EXP1393		EXP1405		EXP1395		EXP1397		EXP1381		EXP1387		EXP1383		EXP1404		EXP1398		EDT70		EDT65		EDT71		EDT63		EDT64		EDT68		EDT67		EDT69		EDT66
entity_cd		COM		PTY		PTY		PTY		COM		OTH		OTH		OTH		OTH		OTH		OTH		COM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		COM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		COM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		COM		COM		COM		COM
payee_naml		Chen for Controller 2022		Tulare County Republican Central Committee		Republican Central Committee of Orange County		Tulare County Republican Central Committee		Kathy Scrivner for Kern High School District		Onymous Media, Inc.		Tulare County Republican Central Committee		Strategy Insights		JJ's Legacy		Kern County Media, LLC		Political Finance Solutions, Inc.		Chen for Controller 2022		Western Pacific Research		KLR Development		Johnson Strategies, LLC		KLR Development		Mountain Communities Family Resource Center		It's Your Party Event Rentals		Lucky's Crew Animal Rescue		Golden State Strategy Group		Republican Central Committee of Orange County		Kathy Scrivner for Kern High School District		Johnson Strategies, LLC		Anedot		Tulare County Republican Central Committee		Golden State Strategy Group		Proforma		US Bank Visa - Fong		Wounded Heroes Fund		Anedot		Kern County Young Republicans Slate Mailer Committee		Anedot		The News Review		15th District Legionnaire		Kern County Farm Bureau		KLR Development		Midway Driller		Anedot		Downtown Visalians		Allegretto Vineyard		Southwest Airlines		Hot Rods & Handguns		Encompass Direct Marketing Group		US Post Office		Budget Watchdogs		California Voter Guide		California Seniors Voter Guide		Citizens for Good Government
payee_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
payee_city		Irvine		Visalia		Tustin		Visalia		Bakersfield		Fair Oaks		Visalia		Woodland		Bakersfield		West Hollywood		Laguna Niguel		Irvine		Bakersfield		Irvine		Austin		Irvine		Frazier Park		Bakersfield		Bakersfield		Sacramento		Tustin		Bakersfield		Austin		Bat		Visalia		Sacramento		Cleveland		Los Angeles		Bakersfield		Bat		Bakersfield		Bat		Ridgecrest		Bakersfield		Bakersfield		Irvine		Taft		Bat		Visalia		Paso Robles		Dallas		Huntington Beach		Cheyenne		Bakersfield		Torrance		Torrance		Torrance		Covina
payee_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		TX		CA		CA		CA		CA		CA		CA		CA		TX		LA		CA		CA		OH		CA		CA		LA		CA		LA		CA		CA		CA		CA		CA		LA		CA		CA		TX		CA		WY		CA		CA		CA		CA		CA
payee_zip4		92618		93291		92780		93291		93308		95628		93291		95776		93309		90069		92677		92618		93309		92614		78746		92614		93225		93308		93313		95814		92780		93308		78746		70808		93291		95814		44131		90071		93308		70808		93304		70808		93555		93301		93307		92614		93268		70808		93291		93446		75235		92649		82001		93301		90501		90501		90505		91722
expn_date		2022-10-21 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-17 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-17 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-14 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-14 00:00:00		2022-10-13 00:00:00		2022-10-06 00:00:00		2022-10-13 00:00:00		2022-10-06 00:00:00		2022-10-14 00:00:00		2022-10-06 00:00:00		2022-10-13 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-22 00:00:00		2022-10-06 00:00:00		2022-10-13 00:00:00		2022-10-14 00:00:00		2022-10-11 00:00:00		2022-10-06 00:00:00		2022-09-30 00:00:00		2022-10-14 00:00:00		2022-09-25 00:00:00		2022-10-14 00:00:00		2022-10-21 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-09-25 00:00:00		2022-10-21 00:00:00		2022-10-13 00:00:00		2022-10-06 00:00:00		2022-10-13 00:00:00		2022-10-06 00:00:00		2022-10-06 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
amount		2500		1500		40500		25000		1000		4053		25000		27162		1250		269		2901		2500		33301		3738		2500		5320		300		449		500		16146		40500		1000		833		1034		1500		488		670		2339		2500		251		14080		381		3138		350		1000		1500		2341		1367		150		488		503		5285		8821		12796		17024		6353		3919		6004
cum_ytd		2500		26500		45500		26500		1000		24318		26500		68264		1250		1343		17366		2500		100452		24058		3333		24058		300		449		500		106408		45500		1000		3333		6100		26500		106408		5951		16355		5000		6100		21767		6100		5816		350		2250		24058		3272		6100		150		5562		805		5285		18537		30909		38911		15613		11762		11665
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
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
expn_code		MON		MON		MON		MON		MON		CNS		CTB		LIT		CVC		PRT		PRO		CTB		LIT		CNS		CNS		FND		CVC		FND		CVC		CNS		CTB		CTB		TRS		None		CTB		TRS		CMP		CMP		CVC		None		LIT		None		PRT		PRT		CVC		CNS		PRT		None		CVC		TRS		TRS		FND		LIT		POS		LIT		LIT		LIT		LIT
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		Credit card processing		None		None		None		None		None		Credit card processing		None		Credit card processing		None		None		None		None		None		Credit card processing		None		Lodging; 9/8/22; Paso Robles, CA; 1 Attendee; Candidate not present		Airfare; 9/13/22; Austin, TX-Sacramento, CA roundtrip; 1 attendee; Candidate not present		Catering and room rental; 9/20/22; Huntington Beach, CA; 35 attendees; Candidate present		None		None		None		None		None		None
agent_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Golden State Strategy Group		Johnson Strategies, LLC		KLR Development		Strategy Insights		Strategy Insights		Western Pacific Research		Western Pacific Research		Western Pacific Research		Western Pacific Research
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
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
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
cmte_id		1439261		742005		742088		742005		1454489		None		742005		None		None		None		None		1439261		None		None		None		None		None		None		None		None		742088		1454489		None		None		742005		None		None		None		None		None		1448063		None		None		None		None		None		None		None		None		None		None		None		None		None		1345115		595004		1268286		599010
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
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
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
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
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
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
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
cand_naml		Lanhee Chen		None		None		None		Kathy Scrivner		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
office_cd		CON		None		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		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		School Board		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_cd		STW		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_dscr		None		None		None		None		Kern High School District		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
dist_no		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
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
sup_opp_cd		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
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
memo_refno		None		None		EXP1294		EXP1346		None		None		EXP1346		None		None		None		None		None		None		None		None		None		None		None		None		None		EXP1294		None		None		None		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
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		E		E		E		E		E		E		E		E		E
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
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

Table: filer_filings

filer_id		1435504
filing_id		2743496
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		2743496
filing_type		22001

Table: hdr

filing_id		2743496
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		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496
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		0		0		0		0		0		0		0		0		0
line_item		99		100		101		102		103		104		105		106		107		108		109		110		111		112		113		114		115		116		117		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
rec_type		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT
form_type		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A
tran_id		EXP1377		INC1281		INC1289		INC1277		INC1316		INC1374		INC1336		INC1333		INC1260		INC1239		INC1329		INC1334		INC1340		INC1267		INC1317		INC1279		INC1361		INC1278		INC1350		INC1297		INC1313		INC1273		INC1283		INC1332		INC1292		INC1308		INC1325		INC1362		INC1251		INC1318		INC1275		INC1304		INC1328		INC1268		INC1322		INC1301		INC1257		INC1246		INC1276		INC1264		INC1242		INC1359		INC1360		INC1352		INC1347		INC1351		INC1319		INC1254		INC1284		INC1321		INC1271		INC1302		INC1286		INC1348		INC1311		INC1315		INC1344		INC1356		INC1342		INC1258		INC1287		INC1245		INC1312		INC1256		INC1323		INC1309		INC1290		INC1299		INC1375		INC1363		INC1237		INC1285		INC1293		INC1326		INC1354		INC1341		INC1364		INC1349		INC1249		INC1282		INC1291		INC1320		INC1337		INC1307		INC1288		INC1331		INC1306		INC1280		INC1338		INC1303		INC1357		INC1274		INC1266		INC1244		INC1262		INC1355		INC1241		INC1353		INC1240		INC1253		INC1358		INC1310		INC1261		INC1255		INC1238		INC1259		INC1300		INC1250		INC1324		INC1270		INC1339		INC1327		INC1265		INC1330		INC1335		INC1272		INC1298
entity_cd		COM		OTH		IND		OTH		COM		OTH		IND		IND		COM		SCC		IND		IND		IND		IND		IND		OTH		OTH		OTH		COM		OTH		IND		IND		OTH		IND		OTH		IND		OTH		COM		COM		IND		IND		SCC		IND		IND		OTH		IND		IND		OTH		IND		IND		COM		OTH		OTH		OTH		IND		COM		IND		COM		OTH		COM		OTH		IND		OTH		COM		COM		OTH		COM		IND		IND		IND		IND		OTH		COM		IND		OTH		OTH		IND		OTH		IND		COM		IND		IND		OTH		OTH		IND		IND		IND		OTH		COM		OTH		OTH		OTH		IND		IND		IND		IND		IND		OTH		COM		OTH		OTH		IND		IND		COM		COM		IND		OTH		OTH		COM		COM		OTH		IND		COM		SCC		COM		IND		IND		OTH		OTH		IND		IND		IND		IND		IND		IND		OTH		OTH
ctrib_naml		Personal Insurance Federation of CA Agents & Employees PAC		Bakersfield Dodge Inc. and Affiliated Entities		Denny		Nelms Surveying, Inc.		California Mortgage Bankers Association PAC		E&B Natural Resources Management Corp.		Bynum		Snider		California Correctional Peace Officers Assocaiation (CCPOA) PAC		California Dental PAC SCC		Downs		Kroeker		Doshi		Lane		Pavletich		Bakersfield Dodge Inc. and Affiliated Entities		Agua Caliente Band of Cahuilla Indians		Mashburn Transportation Services, Inc.		California Academy of Eye Physicians & Surgeons PAC		Buttonwillow Warehouse Co.		Martin		Waters		Bakersfield Dodge Inc. and Affiliated Entities		Downs		Kern Ridge Growers LLC(Robert Giragosian)		McNally		Phoenix Management		JPMorgan Chase & Co. PAC		Govern for California Courage Committee - Future Generations Chapter		Johnson		Valov		California Professional Firefighters PAC		Haddad		Mazzei		The Law Offices of Young Wooldridge		Barbich		Reed		Berry Petroleum, LLC(Trem Smith)		Medders		Preston		California Building Industry Association PAC		Calpine Corporation		Santa Ynez Band of Mission Indians		Phillips 66 Company		Curley		Charter Schools PAC		Starrh		Caterpillar Employees PAC		CVS Health		Associated Builders and Contractors Central CA Chapter PAC		Deloitte Services, LLP		Wright		California Water Service Co.		Personal Insurance Federation of CA Agents & Employees PAC		UPSPAC		Tejon Indian Tribe		California Cable & Telecommunications Association PAC		Fritch		Meek		Corkins		Fanopoulos		Meta Platforms, Inc.		Milk Producers Council PAC		Medders		JSS Almonds		Vasinda's Around the Clock		Looney		Yankee Communications, Inc.		Criscione		Friant Water PAC		Ainley		Riddle		Klein DeNatale Goldner		Valley Institute of Prosethic		Bennett		Harman		Alsop		Amgen Inc.		California Medical Association PAC		Bakersfield Dodge Inc. and Affiliated Entities		Sullivan Petroleum		AstraZeneca		Corrigan		Beck		Layous		Love		Chang		Bakersfield Dodge Inc. and Affiliated Entities		Tulare County Medical Society PAC		Hall Ambulance Service, Inc.		Kern Oil & Refining Co.		Fuller		Davenport		California Apartment Association PAC (CAAPAC)		Govern for California Courage Committee - Southern CA Chapter		White		AmerisourceBergen		Harbor Distributing, LLC(David K. Reyes)		Pacific Association of Domestic Insurance Companies PAC		Govern for California Courage Committee - San Francisco Chapter		Val Mar Farms, LLC(Donald Valpredo)		Camp		California New Car Dealers Association PAC		California Real Estate PAC		California Statewide Law Enforcement Assoc PAC		Edmonds		Stovall		Ryan, LLC(Holly Reed)		Healthy Valley Management Services		Komoto		Barcellos		Nickel		DenHerder		Pankey		Dickens		Bynum, Inc.		M & S Holdings
ctrib_namf		None		None		Marvin		None		None		None		Don		Todd		None		None		Gordon		Carol		Anik		Joseph		Paul		None		None		None		None		None		Jeff		Peggy		None		Gordon		None		Sean		None		None		None		Tyler		Jimi		None		Angelo		Angelo		None		Sheryl		Gary		None		Wilna (Billie Jo)		David		None		None		None		None		Sarah		None		Larry		None		None		None		None		Cassandra		None		None		None		None		None		Charles		Kay		John		George		None		None		Wilna (Billie Jo)		None		None		Sheri		None		Michael		None		Robert		Vicki		None		None		Bill		Paul		Melissa		None		None		None		None		None		Katie		Patrick		John		Barbara		Daniel		None		None		None		None		Marvin		Jason		None		None		Bruce		None		None		None		None		None		Edwin		None		None		None		Irene		John		None		None		Kevin		Tom		James		Les		Mona		Bradley		None		None
ctrib_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		None		None		None		None		None		None		None		None		None
ctrib_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
ctrib_city		Sacramento		Bakersfield		Bakersfield		Bakersfield		Roseville		Bakersfield		Bakersfield		Bakersfield		Sacramento		Sacramento		Bakersfield		Shafter		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Palm Springs		Bakersfield		San Francisco		Bakersfield		Wasco		Shafter		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Washington		San Rafael		Bakersfield		Tulare		Sacramento		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Porterville		Bakersfield		Bakersfield		Visalia		Sacramento		Houston		Santa Ynez		Washington		Coarsegold		Sacramento		Shafter		Peoria		Woonsocket		Bakersfield		Hermitage		Santa Barbara		San Jose		Sacramento		Atlanta		Arvin		Sacramento		Bakersfield		Bakersfield		Porterville		Visalia		Menlo Park		Chino		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Diamond Bar		Fresno		Visalia		Exeter		Bakersfield		Bakersfield		Poway		Bakersfield		Bakersfield		Alexandria		Sacramento		Bakersfield		Bakersfield		Wilmington		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Visalia		Bakersfield		Bakersfield		Bakersfield		Arvin		Sacramento		San Rafael		Porterville		Conshohoken		Huntington Beach		Sacramento		San Rafael		Bakersfield		Bakersfield		Sacramento		Los Angeles		Sacramento		Bakersfield		Bakersfield		Dallas		Bakersfield		Bakersfield		Porterville		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfield
ctrib_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		DC		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		C		CA		TX		CA		DC		CA		CA		CA		IL		RI		CA		TN		CA		CA		CA		GA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		VA		CA		CA		CA		DE		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		PA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		TX		CA		CA		CA		CA		CA		CA		CA		CA		CA
ctrib_zip4		95814		93313		93306		93308		95661		93308		93309		93314		95814		95814		93309		93263		93308		93308		93309		93313		92264		93314		94105		93308		93280		93263		93313		93309		93308		93311		93309		20004		94901		93305		93274		95833		93309		93311		93301		93306		93257		93309		93309		93291		95814		77002		93460		20004		93614		95814		93263		61629		02895		93308		37076		93108		95112		95814		30328		93203		95814		93312		93311		93257		93292		94025		91710		93309		93308		93309		93314		93309		91765		93704		93277		93221		93309		93301		92064		93312		93305		22303		95814		93313		93301		19850		93312		93311		93311		93309		93312		93313		93277		93301		93307		93301		93203		95814		94901		93257		19428		92647		95814		94901		93307		93308		95814		90020		95814		93312		93311		75240		93309		93301		93257		93306		93307		93308		93311		93309		93313
ctrib_emp		None		None		N/A		None		None		None		Gregory D. Bynum & Associates, Inc.		Personal Ag Management Insurance Services LLC		None		None		Downs Equipment Rental		Starrh and Starrh		Sat Kaival Management LLC		The Garlic Company		Premier Lighting		None		None		None		None		None		American Refuse, Inc.		R & P Fishing Tools		None		Downs Equipment Rental		None		Grimmway Farms		None		None		None		Healthcare Finance Direct		Valov & Sons Farming		None		The Nautilus Group		Mazzei Injection Co.		None		Barbich Consulting		First Allied Advisory Services, Inc.		None		N/A		Safety Striping Service		None		None		None		None		N/A		None		Starrh Family Farms		None		None		None		None		N/A		None		None		None		None		None		Fritch Eye Care		Kern Community College District		Research for Hire		N/A		None		None		N/A		None		None		Self Employed		None		N/A		None		Ainley, Alipaz Webb PC		City of Exeter		None		None		N/A		Bigger & Harman		N/A		None		None		None		None		None		Rush Air Sports		Bakersfield Hyundai		The Garlic Company		Love in Bloom		Empire Eye and Laser		None		None		None		None		M&S Security Services		Allied Potato		None		None		3 Rivers Trucking		None		None		None		None		None		DM Camp and Sons		None		None		None		N/A		Law Offices of John F. Stovall		None		None		Komoto Medical Pharmacy		Barcellos Farms		Nickel Farms, LLC		HPS Mechanical, Inc.		Intrados		McCullough Dental		None		None
ctrib_occ		None		None		Retired		None		None		None		Real Estate		Crop Insurance Agent		None		None		Owner		Bookkeeper		Principal		Partner		Owner		None		None		None		None		None		President		Owner		None		Owner		None		VP of Government Affairs		None		None		None		CEO		Farmer		None		Financial Consultant		Owner		None		Executive and Leadership Consultant		Financial Advisor		None		Retired		President & CEO		None		None		None		None		Homemaker		None		Farmer		None		None		None		None		Retired		None		None		None		None		None		M.D.		Trustee		General Manager		Retired		None		None		Retired		None		None		Tax Preparer		None		Retired		None		Attorney		Planning Commissioner		None		None		Retired		Attorney		Homemaker		None		None		None		None		None		General Manager		Car Dealer		Owner		Owner		Surgeon		None		None		None		None		Owner		Owner		None		None		Owner		None		None		None		None		None		President		None		None		None		Retired		Attorney		None		None		VP		Farmer		Farmer		Manager		Controller		Dentist		None		None
ctrib_self		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tran_type		R		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rcpt_date		2022-09-25 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-11 00:00:00		2022-10-21 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-10-03 00:00:00		2022-09-26 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-10-03 00:00:00		2022-10-11 00:00:00		2022-10-06 00:00:00		2022-10-21 00:00:00		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-10-07 00:00:00		2022-10-10 00:00:00		2022-10-04 00:00:00		2022-10-06 00:00:00		2022-10-13 00:00:00		2022-10-06 00:00:00		2022-10-10 00:00:00		2022-10-13 00:00:00		2022-10-21 00:00:00		2022-09-29 00:00:00		2022-10-11 00:00:00		2022-10-05 00:00:00		2022-10-07 00:00:00		2022-10-13 00:00:00		2022-09-29 00:00:00		2022-10-13 00:00:00		2022-10-07 00:00:00		2022-09-30 00:00:00		2022-09-27 00:00:00		2022-10-06 00:00:00		2022-09-30 00:00:00		2022-09-27 00:00:00		2022-10-19 00:00:00		2022-10-20 00:00:00		2022-10-19 00:00:00		2022-10-17 00:00:00		2022-10-20 00:00:00		2022-10-12 00:00:00		2022-09-30 00:00:00		2022-10-06 00:00:00		2022-10-13 00:00:00		2022-10-03 00:00:00		2022-10-07 00:00:00		2022-10-06 00:00:00		2022-10-18 00:00:00		2022-10-10 00:00:00		2022-10-11 00:00:00		2022-10-14 00:00:00		2022-10-19 00:00:00		2022-10-13 00:00:00		2022-09-30 00:00:00		2022-10-06 00:00:00		2022-09-27 00:00:00		2022-10-10 00:00:00		2022-09-30 00:00:00		2022-10-13 00:00:00		2022-10-10 00:00:00		2022-10-06 00:00:00		2022-10-07 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-09-26 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-13 00:00:00		2022-10-19 00:00:00		2022-10-13 00:00:00		2022-10-21 00:00:00		2022-10-18 00:00:00		2022-09-28 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-12 00:00:00		2022-10-13 00:00:00		2022-10-10 00:00:00		2022-10-06 00:00:00		2022-10-13 00:00:00		2022-10-10 00:00:00		2022-10-06 00:00:00		2022-10-13 00:00:00		2022-10-07 00:00:00		2022-10-19 00:00:00		2022-10-05 00:00:00		2022-09-30 00:00:00		2022-09-27 00:00:00		2022-10-03 00:00:00		2022-10-19 00:00:00		2022-09-26 00:00:00		2022-10-19 00:00:00		2022-09-26 00:00:00		2022-09-30 00:00:00		2022-10-19 00:00:00		2022-10-10 00:00:00		2022-10-03 00:00:00		2022-09-30 00:00:00		2022-09-26 00:00:00		2022-09-30 00:00:00		2022-10-07 00:00:00		2022-09-28 00:00:00		2022-10-13 00:00:00		2022-09-29 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-09-30 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-09-30 00:00:00		2022-10-07 00:00:00
date_thru		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		-1500		1000		200		100		1500		2500		350		200		1400		2900		500		500		200		250		500		900		2500		4900		2000		1000		200		1000		1000		500		1000		500		4900		1500		4900		200		2500		1000		200		500		1000		250		250		1000		200		200		2800		2900		2400		4900		100		2500		1000		1500		2500		2000		1000		2500		4900		1000		4000		2500		2500		250		1000		250		125		2000		1000		100		1000		1000		300		1000		2000		1500		125		300		4900		1000		200		100		250		1500		3400		1000		200		1500		400		500		500		100		1000		1000		4900		4900		1200		400		2500		4900		4900		4900		1000		4900		1000		4900		1000		500		3400		1000		2000		100		100		1500		4900		500		1000		200		1000		4900		100		2400		1000
cum_ytd		3000		4900		400		100		1500		2500		350		200		3400		4900		3000		500		350		1750		500		4900		2500		4900		2000		1000		1200		1000		4900		3000		1000		500		4900		1500		4900		200		2500		3000		200		1500		1000		250		250		1000		400		200		6800		4900		4900		4900		100		2500		2000		1500		2500		2000		1500		5000		4900		3000		8500		2500		2500		250		1000		250		125		2000		1000		400		1000		1000		300		1000		2000		3000		125		300		4900		1000		200		100		250		3000		4900		4900		200		1500		400		1500		1000		100		1000		4900		4900		6400		1200		400		5000		9800		4900		4900		1000		4900		1000		4900		1000		500		4900		6000		2000		100		600		1500		4900		750		1000		200		3500		9800		100		2400		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
ctrib_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		1338487		None		None		None		890152		None		None		None		830349		742855		None		None		None		None		None		None		None		None		980331		None		None		None		None		None		None		None		None		C00128512		1416436		None		None		744058		None		None		None		None		None		None		None		None		890483		None		None		None		None		1302433		None		1307878		None		1222327		None		None		None		1338487		C00064766		None		745932		None		None		None		None		None		744692		None		None		None		None		None		None		1396710		None		None		None		None		None		None		None		None		742617		None		None		None		None		None		None		None		None		None		1307752		None		None		None		None		745208		1435445		None		None		None		1350983		1416440		None		None		741623		890106		970375		None		None		None		None		None		None		None		None		None		None		None		None
tres_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		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		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		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		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		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		None		None		None		None		None		None		None		None		None
intr_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_emp		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_occ		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_self		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		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		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		None		None		None		None		None		None		None		None		None
office_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		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		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		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		None		None		None		None		None		None		None		None		None
sup_opp_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		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		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		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		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		None		None		None		None		None		None		None		None		None
int_rate		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_cmteid		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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: smry

filing_id		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496
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
line_item		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		20		21		22A		22B		1		2		3		1		2		3		1		2		3		4		1		2		3		1		2		3		1		2		3
rec_type		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		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		F460		F460		F460		F460		A		A		A		D		D		D		E		E		E		E		F		F		F		B1		B1		B1		H		H		H
amount_a		181265		0		181265		0		181265		200868		0		200868		-2339		0		198529		378655		181265		0		200868		359052		0		0		0		395446		513162		247074		393327		181200		65		181265		70500		0		70500		200811		57		0		200868		0		2339		-2339		0		0		0		0		0		0
amount_b		796883		0		796883		4000		800883		927055		0		927055		0		4000		931055		None		None		None		None		None		None		None		None		405437		440589		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
elec_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2022-11-08 00:00:00		2022-06-07 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: splt

filing_id		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496		2743496
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		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		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		116		117		118		119		120		121		122		123		124		125		126		127		128		129		130		131		132		133		134		135		136		137		138		139		140		141		142		143		144		145		146		147		148		149		150		151		152		153		154		155		156		157		158		159		160		161		162		163		164		165		166		167		168		169		170		171		172		173		174		175		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		109		110		111		112		113		114		115
pform_type		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		D		D		D		D		D		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A
ptran_id		INC1353		INC1240		INC1253		INC1358		INC1310		INC1261		INC1261		INC1255		INC1255		INC1238		INC1259		INC1259		INC1300		INC1300		INC1250		INC1324		INC1270		INC1270		INC1339		INC1327		INC1327		INC1265		INC1265		INC1330		INC1330		INC1335		INC1272		INC1272		INC1298		EXP1377		EXP1377		INC1281		INC1289		INC1289		INC1277		INC1316		INC1374		INC1336		INC1333		INC1260		INC1260		INC1239		INC1239		INC1329		INC1329		INC1334		INC1340		INC1267		INC1267		INC1317		INC1279		INC1361		INC1361		INC1278		INC1350		EXP1371		EXP1296		EXP1294		EXP1346		EXP1295		INC1297		INC1313		INC1313		INC1273		INC1283		INC1332		INC1332		INC1292		INC1292		INC1308		INC1325		INC1362		INC1251		INC1318		INC1275		INC1304		INC1304		INC1328		INC1268		INC1268		INC1322		INC1322		INC1301		INC1257		INC1246		INC1246		INC1276		INC1276		INC1264		INC1242		INC1242		INC1359		INC1359		INC1360		INC1352		INC1352		INC1347		INC1351		INC1319		INC1319		INC1254		INC1254		INC1284		INC1321		INC1321		INC1271		INC1271		INC1302		INC1302		INC1286		INC1348		INC1348		INC1311		INC1311		INC1315		INC1315		INC1344		INC1344		INC1356		INC1342		INC1342		INC1258		INC1287		INC1245		INC1312		INC1256		INC1256		INC1323		INC1309		INC1290		INC1290		INC1299		INC1299		INC1375		INC1363		INC1363		INC1237		INC1285		INC1293		INC1293		INC1326		INC1354		INC1354		INC1341		INC1364		INC1349		INC1349		INC1249		INC1249		INC1282		INC1291		INC1320		INC1320		INC1337		INC1307		INC1307		INC1288		INC1288		INC1331		INC1306		INC1280		INC1338		INC1303		INC1303		INC1357		INC1274		INC1274		INC1266		INC1266		INC1244		INC1244		INC1262		INC1355		INC1241		INC1353
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		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		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		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		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		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
elec_amount		4900		1000		4900		1000		500		4900		4900		4000		3000		2000		125		100		500		350		1500		4900		750		500		1000		1000		200		4900		1100		4900		4900		100		2500		2400		1000		4900		2100		4900		200		200		100		1500		2500		350		200		3000		6800		4900		4900		4000		1000		500		350		1000		750		500		4900		1500		2500		4900		2000		2500		26500		45500		26500		1000		1000		1000		200		1000		4900		4000		1000		1000		1000		500		4900		1500		4900		200		2500		2000		2000		200		3610		500		1000		1000		250		250		1000		1000		225		300		200		4900		4900		3500		4900		4900		4900		4900		100		2500		2000		1000		1500		1500		2500		4900		2000		3000		1500		2500		2500		4900		4900		2100		4500		4000		750		2500		1500		2500		250		1000		1000		250		125		2000		1000		225		300		1000		1000		250		300		1000		1000		2000		1500		1500		125		300		4900		4900		1000		10		200		100		250		1500		1500		4900		4900		4900		200		2000		1500		400		2000		500		500		500		100		1000		4900		4900		6400		4900		1200		500		400		4900		2600		4900		4900		4900		4900		1000		2500
elec_code		G		G		G		G		G		P		G		P		G		G		P		G		P		G		G		G		P		G		G		P		G		P		G		P		G		G		P		G		G		P		G		G		P		G		G		G		G		G		G		P		G		P		G		P		G		G		G		P		G		G		G		P		G		G		G		G		G		G		G		G		G		P		G		G		G		P		G		P		G		G		G		G		G		G		G		P		G		G		P		G		P		G		G		G		P		G		P		G		G		P		G		P		G		G		P		G		G		G		P		G		P		G		G		P		G		P		G		P		G		G		P		G		P		G		P		G		P		G		G		P		G		G		G		G		G		P		G		G		G		P		G		P		G		G		P		G		G		G		P		G		G		P		G		G		G		P		G		P		G		G		G		P		G		G		P		G		P		G		G		G		G		G		P		G		G		P		G		P		G		P		G		G		G		G		P