Home

Filing ID: 2744682

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

Table: cvr3_verification_info

filing_id		2744682		2744682
amend_id		0		0
line_item		1		2
rec_type		CVR3		CVR3
form_type		F460		F460
tran_id		Treas-CVR3.208		Cand-CVR3.207
entity_cd		TRE		CAO
sig_date		2022-10-27 00:00:00		2022-10-27 00:00:00
sig_loc		Hilmar,CA		Porterville,CA
sig_naml		Lawler		Shepard
sig_namf		Kelly		David
sig_namt		None		None
sig_nams		None		None

Table: cvr_campaign_disclosure

filing_id		2744682
amend_id		0
rec_type		CVR
form_type		F460
filer_id		1444818
entity_cd		CAO
filer_naml		Shepard for Senate 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		Porterville
filer_st		CA
filer_zip4		93257
filer_phon		805-748-4382
filer_fax		None
file_email		[email protected]
mail_city		Porterville
mail_st		CA
mail_zip4		93257
tres_naml		Lawler
tres_namf		Kelly
tres_namt		None
tres_nams		None
tres_city		Hilmar
tres_st		CA
tres_zip4		95324
tres_phon		209-656-1542
tres_fax		None
tres_email		[email protected]
cmtte_type		C
control_yn		Y
sponsor_yn		N
primfrm_yn		None
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		Shepard
cand_namf		David
cand_namt		None
cand_nams		None
cand_city		Porterville
cand_st		CA
cand_zip4		93257
cand_phon		805-748-4382
cand_fax		None
cand_email		None
bal_name		None
bal_num		None
bal_juris		None
office_cd		SEN
offic_dscr		None
juris_cd		SEN
juris_dscr		None
dist_no		16
off_s_h_cd		S
sup_opp_cd		None
employer		None
occupation		None
selfemp_cb		None
bal_id		None
cand_id		None

Table: debt

filing_id		2744682		2744682
amend_id		0		0
line_item		1		2
rec_type		DEBT		DEBT
form_type		F		F
tran_id		F-696		F-720
entity_cd		OTH		OTH
payee_naml		Johnson Strategies LLC		Golden State Strategy Group
payee_namf		None		None
payee_namt		None		None
payee_nams		None		None
payee_city		Austin		Sacramento
payee_st		TX		CA
payee_zip4		78746		95819
beg_bal		0		0
amt_incur		7500		3432
amt_paid		0		0
end_bal		7500		3432
expn_code		TEL		CNS
expn_dscr		None		None
cmte_id		None		None
tres_naml		None		None
tres_namf		None		None
tres_namt		None		None
tres_nams		None		None
tres_city		None		None
tres_st		None		None
tres_zip4		None		None
memo_code		None		None
memo_refno		None		None
bakref_tid		None		None
xref_schnm		None		None
xref_match		None		None

Table: expn

filing_id		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682
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
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
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
form_type		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		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G
tran_id		E-554		E-558		E-585		E-590		E-599		E-604		E-607		E-691		E-605		E-617		E-635		E-647		E-649		E-644		E-642		E-660		E-666		E-677		E-681		E-675		E-684		E-692		E-716		E-685		E-686		E-695		G-657		G-658		G-656		G-651		G-655		G-652		G-654		G-653		G-704		G-701		G-699		G-698		G-697		G-700		G-702		G-703		G-736		G-737		G-735		G-730		G-734		G-731		G-733		G-732
entity_cd		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH
payee_naml		eFundraising Connections		eFundraising Connections		eFundraising Connections		eFundraising Connections		eFundraising Connections		Johnson Strategies LLC		eFundraising Connections		Integrated Solutions: Political		Strategy Insights LLC		eFundraising Connections		eFundraising Connections		eFundraising Connections		eFundraising Connections		Bynum Inc.		The Battin Group		eFundraising Connections		eFundraising Connections		eFundraising Connections		eFundraising Connections		The KAL Group, Inc.		eFundraising Connections		Chase Card Services		eFundraising Connections		Families First Education Voter Guide		Latino Family Voter Guide		The Battin Group		KBAK-TV CBS		KBFX-TV FOX		KERO-TV ABC		KFSN-TV ABC		KGET-TV NBC		KGPE-TV CBS		KMPH-TV Fox		KSEE-TV NBC		Eagle Feather Trading Post		Hanford FFA Parents		Poplar Mart & Gas		Shell Oil		The Anvil BBQ		Town & Country Gas		Town & Country Gas		Town & Country Gas		KBAK-TV CBS		KBFX-TV FOX		KERO-TV ABC		KFSN-TV ABC		KGET-TV NBC		KGPE-TV CBS		KMPH-TV Fox		KSEE-TV NBC
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		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		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
payee_city		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Austin		Sacramento		San Diego		Woodland		Sacramento		Sacramento		Sacramento		Sacramento		Bakersfield		Reno		Sacramento		Sacramento		Sacramento		Sacramento		Hilmar		Sacramento		Elgin		Sacramento		Norwalk		Norwalk		Reno		Bakersfield		Bakersfield		Bakersfield		Fresno		Bakersfield		Fresno		Fresno		Fresno		Porterville		Hanford		Porterville		Terra Bella		Porterville		Porterville		Porterville		Porterville		Bakersfield		Bakersfield		Bakersfield		Fresno		Bakersfield		Fresno		Fresno		Fresno
payee_st		CA		CA		CA		CA		CA		TX		CA		CA		CA		CA		CA		CA		CA		CA		NV		CA		CA		CA		CA		CA		CA		IL		CA		CA		CA		NV		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		95816		95816		95816		95816		95816		78746		95816		92116		95776		95816		95816		95816		95816		93309		89511		95816		95816		95816		95816		95324		95816		60124		95816		90650		90650		89511		93301		93301		93301		93706		93301		93727		93727		93727		93257		93230		93257		93270		93257		93257		93257		93257		93301		93301		93301		93706		93301		93727		93727		93727
expn_date		2022-09-26 00:00:00		2022-09-27 00:00:00		2022-09-29 00:00:00		2022-09-30 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-04 00:00:00		2022-10-04 00:00:00		2022-10-04 00:00:00		2022-10-05 00:00:00		2022-10-06 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-10 00:00:00		2022-10-11 00:00:00		2022-10-12 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-18 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-21 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00
amount		108		35		26		373		14		11284		216		475		7500		30		18		6		3		100		85405		31		10		23		113		1047		55		2254		5		250		250		50000		8483		1216		5364		28858		10838		4760		8317		4356		130		500		100		136		104		120		113		106		2545		365		1609		8657		3251		1441		2426		1307
cum_ytd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
expn_chkno		90		91		92		93		94		None		95		None		1038		97		99		103		104		None		None		105		106		108		109		1039		110		None		117		1040		1041		None		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		OFC		OFC		OFC		OFC		OFC		TEL		OFC		OFC		CNS		OFC		OFC		OFC		OFC		RFD		TEL		OFC		OFC		OFC		OFC		PRO		OFC		None		OFC		LIT		LIT		TEL		TEL		TEL		TEL		TEL		TEL		TEL		TEL		TEL		TRC		CVC		TRC		TRC		MTG		TRC		TRC		TRC		TEL		TEL		TEL		TEL		TEL		TEL		TEL		TEL
expn_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		CMP, TRC and MTG		None		None		None		None		None		None		None		None		None		None		None		None		10/14/22 Fuel for Campaign Travel		None		10/8/22 Fuel for Campaign Travel		10/11/22 Fuel for Campaign Travel		10/14/22 Lunch Meeting for Campaign		10/03/22 Fuel for Campaign Travel		09/29/22 Fuel for Campaign Travel		9/30/22 Fuel for Campaign Travel		None		None		None		None		None		None		None		None
agent_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		The Battin Group		The Battin Group		The Battin Group		The Battin Group		The Battin Group		The Battin Group		The Battin Group		The Battin Group		Chase Card Services		Chase Card Services		Chase Card Services		Chase Card Services		Chase Card Services		Chase Card Services		Chase Card Services		Chase Card Services		The Battin Group		The Battin Group		The Battin Group		The Battin Group		The Battin Group		The Battin Group		The Battin Group		The Battin Group
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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		E-642		E-642		E-642		E-642		E-642		E-642		E-642		E-642		E-692		E-692		E-692		E-692		E-692		E-692		E-692		E-692		E-695		E-695		E-695		E-695		E-695		E-695		E-695		E-695
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		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		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		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

Table: filer_filings

filer_id		1444818
filing_id		2744682
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		2744682
filing_type		22001

Table: hdr

filing_id		2744682
amend_id		0
rec_type		HDR
ef_type		CAL
state_cd		CA
cal_ver		2.01
soft_name		ISP
soft_ver		1.0
hdrcomment		None

Table: rcpt

filing_id		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682
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
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
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
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		C		C		C		C		C		C		C
tran_id		A-552		A-579		A-576		A-559		A-555		A-583		A-577		A-556		A-578		A-581		A-582		A-563		A-562		A-560		A-561		A-580		A-592		A-586		A-594		A-595		A-591		A-588		A-587		A-597		A-600		A-615		A-601		A-614		A-602		A-609		A-608		A-627		A-621		A-626		A-622		A-623		A-625		A-624		A-610		A-620		A-628		A-619		A-631		A-632		A-674		A-637		A-633		A-639		A-640		A-643		A-650		A-662		A-663		A-668		A-669		A-664		A-667		A-671		A-670		A-672		A-679		A-690		A-689		A-705		C-593		C-603		C-612		C-618		C-636		C-661		C-678
entity_cd		IND		OTH		COM		IND		IND		IND		OTH		IND		OTH		OTH		OTH		IND		IND		IND		IND		OTH		OTH		OTH		IND		COM		IND		IND		IND		IND		IND		IND		IND		IND		OTH		IND		IND		IND		OTH		OTH		IND		IND		OTH		IND		IND		IND		SCC		OTH		IND		IND		IND		COM		IND		COM		PTY		IND		IND		COM		IND		OTH		IND		IND		OTH		COM		IND		COM		COM		OTH		SCC		OTH		PTY		PTY		PTY		PTY		PTY		PTY		PTY
ctrib_naml		Merritt		Airoso Dairy		American Pistachio Growers California PAC		Denny		Dickens		Hoffman		Krme Partnership		Madland		O P C Farms Inc. South		Prime-Dirt		Ron Clark Farms		Anderson		Costamagna		Townsend		Wilbur		Brian Watte Farms		Bynum Inc.		Darlene Denison Ins Agency, Inc		Edmonds		International Brotherhood of Electrical Workers Political Action Committee		Marchbanks		Snedden		Snedden		Weir		Harman		Lane		Nickel		Scrivner		Serpa & Co.		Costa		Dev		Cornforth		Independent Oil Producers Alliance		M & S Holdings		Pandol		Reid		St Clair Property Management		St. Clair		Verboon		Grabow		Peace Officers Research Association of California PAC (PORAC PAC)		Valov Brothers Farms LP		Vignolo		Beck		Bynum		Devon Mathis for Assembly 2022		Papenhausen		United Parcel Service Inc. Political Action Committee (fec ID #c00064766)		California Republican Party		Damian		Wade		California Cattlemen's Association PAC (CATTLE-PAC)		Panero		Healthy Valley Management Services LLC		Merritt		Parra		Setton Pistachio of Terra Bella, Inc.		Seyarto For Senate 2022		Alvarado		Rosilicie Ochoa Bogh for Senate 2024		California Financial Services Association Political Action Committee		Pitigliano Farm Services Inc.		Southwest Regional Council of Carpenters Political Action Fund		Agri - Vista		California Republican Party		California Republican Party		California Republican Party		California Republican Party		California Republican Party		California Republican Party		California Republican Party
ctrib_namf		Daniel		None		None		Marvin		Bradley		Mark		None		Mary		None		None		None		Doug		Ernie		Dennis		Stephen		None		None		None		Thomas		None		William Patrick		Richard		Susan		Ken		Paul		Joseph		James		Patricia Kathy		None		Vernon		Vipul		Donald		None		None		Lucy		Sarah		None		Arlana Joy		Doug		Gladys		None		None		Gail		Patrick		Gregory		None		Jim		None		None		Jim		Patrick		None		Jacob		None		Eric		Joseph		None		None		Steven		None		None		None		None		None		None		None		None		None		None		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
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
ctrib_city		Visalia		Pixley		Sacramento		Bakersfield		Bakersfield CA 93311		Tulare		Visalia		Bakersfield		San Joaquin		Woodlake		Tulare		Tulare		Hanford		Springville		Tulare		Tulare		Bakersfield		Bakersfield		Bakersfield		Washington		Bakersfield		Maricopa		Maricopa		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Tulare		Hanford		Bakersfield		Bakersfield		Taft		Bakersfield		Delano		Springville		Bakersfield		Bakersfield		Hanford		Hanford		Sacramento		Tulare		Bakersfield		Bakersfield		Bakersfield		Hilmar		El Cajon		Atlanta		Sacramento		Bakersfield		Bakersfield		Sacramento		Bakersfield		Bakersfield		Porterville		Sacramento		Terra Bella		Wilton		Canon City		Hilmar		Sacramento		Tipton		Los Angeles		Porterville		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento
ctrib_st		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		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		GA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CO		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
ctrib_zip4		93277		93256		95814		93312		93311		93274		93291		93308		93660		93286		93274		93274		93230		93265		93274		93274		93309		93312		93312		20001		93311		93252		93252		93309		93312		93308		93306		93301		93274		93230		93308		93311		93268		93306		93215		93265		93309		93309		93230		93230		95834		93274		93311		93311		93309		95324		92021		30328		95814		93311		93311		95814		93314		93309		93257		95816		93270		95693		81212		95324		95814		93272		90071		93257		95814		95814		95814		95814		95814		95814		95814
ctrib_emp		MVP Insurance Agency		None		None		Retired		Retired		Hoffman $ Son Farming		None		Madland Toyota-Lift, Inc.		None		None		None		Doug Anderson Farms		West Valley Farm Enterprises		Townsend Architectural Group		Self Employed - Stephen Wilbur		None		None		None		Retired		None		Marchbanks Truck Service Inc.		Snedden Ranch		Snedden Ranch		Weir & Associates		Bigger & Harman, ACP		The Garlic Company		Nickel Family LLC		PBVUSD		None		Vernon Costa Dairy Cattle		California Institute of Cosmetic & Reconstructive Surgery		Donald E Cornforth MD Inc		None		None		Retired		EW Merritt Farms		None		St. Clair Properties		County of Kings		Retired		None		None		Retired		Bakersfield Hyundai		Bynum Inc.		None		Self Employed-Jim Papenhausen		None		None		Stria		Precision Pharmacy		None		Burrtec Kern, LLC.		None		E.W. Merritt Farms		CA State Senate		None		None		CDOC		None		None		None		None		None		None		None		None		None		None		None		None
ctrib_occ		Agent		None		None		Retired		Retired		Owner		None		President / Owner		None		None		None		Farmer		Farming		Architect		Farmer		None		None		None		Retired		None		Developer		Cattle Rancher		Cattle Rancher		CPA		Attorney		Owner		Farmer		Substitute Teacher, ELPAC evaluator		None		Farmer		Reconstructive Surgeon		Physician		None		None		Retired		Farmer/ Office manager		None		Property Management		Farmer		Retired		None		None		Retired		Auto Dealer		Developer		None		Contractor		None		None		Founder		Pharmacsit		None		Manager		None		Farmer		Policy Consultant		None		None		Teacher		None		None		None		None		None		None		None		None		None		None		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
tran_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		R		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		R		None		None		None		None		None		None		None		None
rcpt_date		2022-09-26 00:00:00		2022-09-27 00:00:00		2022-09-27 00:00:00		2022-09-27 00:00:00		2022-09-27 00:00:00		2022-09-27 00:00:00		2022-09-27 00:00:00		2022-09-27 00:00:00		2022-09-27 00:00:00		2022-09-27 00:00:00		2022-09-27 00:00:00		2022-09-28 00:00:00		2022-09-28 00:00:00		2022-09-28 00:00:00		2022-09-28 00:00:00		2022-09-29 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-10-01 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-04 00:00:00		2022-10-04 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-09 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-12 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-15 00:00:00		2022-10-16 00:00:00		2022-10-16 00:00:00		2022-10-17 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-22 00:00:00		2022-09-30 00:00:00		2022-10-03 00:00:00		2022-10-04 00:00:00		2022-10-05 00:00:00		2022-10-10 00:00:00		2022-10-12 00:00:00		2022-10-15 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
amount		300		300		1000		300		125		500		300		125		600		500		500		2400		2350		1500		2000		600		2500		1000		125		4000		1000		125		125		125		125		100		125		125		300		250		125		250		125		1000		1000		250		250		250		125		4000		9700		4900		200		500		-100		4900		100		2500		75000		500		2500		4900		1000		1000		1000		200		2500		2500		100		4900		1500		2500		-2500		500		31910		2600		31910		31910		9000		31910		2600
cum_ytd		500		300		1000		300		125		500		300		125		600		500		500		2650		2350		1600		3000		1100		4800		1000		125		4000		3500		375		125		125		125		2600		125		225		300		750		125		250		625		1000		1000		350		250		250		225		4000		9700		5900		200		1000		4800		4900		100		2500		615436		500		2500		4900		1000		1000		1200		200		7400		2500		200		4900		1500		2500		0		500		615436		615436		615436		615436		615436		615436		615436
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
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		Printing, Mailing and Postage		Payroll		Printing, Mailing and Postage		Printing, Mailing and Postage		Polling		Printing, Mailing and Postage		Payroll
cmte_id		None		None		1343200		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		900161		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		810830		None		None		None		None		1435405		None		1377592		810163		None		None		760980		None		None		None		None		None		1443473		None		1435065		881022		None		870169		None		810163		810163		810163		810163		810163		810163		810163
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

Table: smry

filing_id		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682
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
line_item		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		20		21		1		2		3		1		2		3		1		2		3		1		2		3		1		2		3		4		1		2		3		1		2		3		1		2		3		4
rec_type		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY
form_type		F460		F460		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		151765		0		151765		141840		293605		159704		0		159704		10932		141840		312476		30811		151765		0		159704		22872		0		0		10932		187464		166617		151600		165		151765		0		0		0		141840		0		141840		0		0		0		159629		75		0		159704		10932		0		10932		0		0		0		0		0		0		0
amount_b		585622		0		585622		321191		906813		563110		0		563110		10932		321191		895233		None		None		None		None		None		None		None		None		719350		728616		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
amount_c		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
elec_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: splt

filing_id		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682		2744682
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
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
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		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		C		C		C		C		C		C		C		C		C		C		C		C		C		C
ptran_id		A-552		A-560		A-588		A-615		A-609		A-623		A-610		A-619		A-640		A-669		A-667		A-670		A-552		A-579		A-576		A-559		A-555		A-583		A-577		A-556		A-578		A-581		A-582		A-563		A-562		A-560		A-561		A-580		A-592		A-586		A-594		A-595		A-591		A-588		A-587		A-597		A-600		A-615		A-601		A-614		A-602		A-609		A-608		A-627		A-621		A-626		A-622		A-623		A-625		A-624		A-610		A-620		A-628		A-619		A-631		A-632		A-674		A-637		A-633		A-639		A-640		A-643		A-650		A-662		A-663		A-668		A-669		A-664		A-667		A-671		A-670		A-672		A-679		A-690		A-705		C-593		C-603		C-612		C-618		C-636		C-661		C-678		C-593		C-603		C-612		C-618		C-636		C-661		C-678
elec_date		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00
elec_amount		200		100		250		1000		200		100		100		1000		50490		200		4900		100		300		300		1000		300		125		500		300		125		600		500		500		2650		2350		1500		3000		1100		4800		1000		125		4000		3500		125		125		125		125		1600		125		225		300		550		125		250		625		1000		1000		250		250		250		125		4000		9700		4900		200		1000		4800		4900		100		2500		564946		500		2500		4900		1000		1000		1000		200		2500		2500		100		4900		1500		2500		500		50490		50490		50490		50490		50490		50490		50490		564946		564946		564946		564946		564946		564946		564946
elec_code		P		P		P		P		P		P		P		P		P		P		P		P		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		P		P		P		P		P		P		P		G		G		G		G		G		G		G