Home

Filing ID: 2743178

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

Table: cvr3_verification_info

filing_id		2743178		2743178
amend_id		0		0
line_item		1		2
rec_type		CVR3		CVR3
form_type		F460		F460
tran_id		Treas-CVR3.3809		Cand-CVR3.3606
entity_cd		TRE		CAO
sig_date		2022-10-27 00:00:00		2022-10-27 00:00:00
sig_loc		San Rafael,CA		Bakersfield,CA
sig_naml		Montgomery		Grove
sig_namf		Thomas		Shannon
sig_namt		None		None
sig_nams		III		None

Table: cvr_campaign_disclosure

filing_id		2743178
amend_id		0
rec_type		CVR
form_type		F460
filer_id		1414696
entity_cd		CAO
filer_naml		Grove 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		Bakersfield
filer_st		CA
filer_zip4		93309
filer_phon		(661) 377-0410
filer_fax		None
file_email		tom@politicalvisions.com
mail_city		San Rafael
mail_st		CA
mail_zip4		94913-5703
tres_naml		Montgomery
tres_namf		Thomas
tres_namt		None
tres_nams		III
tres_city		San Rafael
tres_st		CA
tres_zip4		94903
tres_phon		(415) 250-4036
tres_fax		None
tres_email		tom@politicalcommunicationsinc.com
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		Grove
cand_namf		Shannon
cand_namt		None
cand_nams		None
cand_city		Bakersfield
cand_st		CA
cand_zip4		93308-9709
cand_phon		None
cand_fax		None
cand_email		None
bal_name		None
bal_num		None
bal_juris		None
office_cd		SEN
offic_dscr		California State Senate
juris_cd		SEN
juris_dscr		Senate District
dist_no		12
off_s_h_cd		S
sup_opp_cd		None
employer		None
occupation		None
selfemp_cb		None
bal_id		None
cand_id		None

Table: expn

filing_id		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178
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
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
rec_type		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN
form_type		D		D		D		D		D		D		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		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		D-21307		D-21284		D-21283		D-21536		D-21302		D-21281		E-21306		E-21190		E-21409		E-21375		E-21334		E-21178		E-21180		E-21191		E-21257		E-21378		E-21380		E-21382		E-21384		E-21390		E-21387		E-21392		E-21394		E-21396		E-21398		E-21400		E-21402		E-21412		E-21432		E-21471		E-21472		E-21410		E-21296		E-21297		E-21298		E-21299		E-21282		E-21493		E-21376		E-21331		E-21451		E-21188		E-21295		E-21427		E-21408		E-21385		E-21333		E-21300		E-21301		E-21280		E-21189		E-21304		E-21324		E-21433		G-21513		G-21515		G-21518		G-21449		G-21448		G-21447		G-21533		G-21511		G-21525		G-21527		G-21530		G-21535		G-21521		G-21509		G-21522		G-21534		G-21506		G-21532		G-21450		G-21526		G-21528		G-21529		G-21510		G-21519
entity_cd		IND		IND		IND		IND		IND		IND		COM		IND		OTH		OTH		IND		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		IND		IND		IND		IND		RCP		OTH		OTH		COM		COM		OTH		OTH		OTH		OTH		OTH		OTH		IND		COM		COM		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		Antonaros		Bill-De La Pena		Gorell		Jones		Scrivner		Valladares		Antonaros For Kern Community College District - 3 - 2022; John		Bates		Capital Development Strategies		Cardmember Services-Bank of the Sierra		Dietz		eFundraising Connections		eFundraising Connections		eFundraising Connections		eFundraising Connections		eFundraising Connections		eFundraising Connections		eFundraising Connections		eFundraising Connections		eFundraising Connections		eFundraising Connections		eFundraising Connections		eFundraising Connections		eFundraising Connections		eFundraising Connections		eFundraising Connections		eFundraising Connections		eFundraising Connections		eFundraising Connections		eFundraising Connections		eFundraising Connections		Fanny's House		Grove		Grove		Grove		Grove		Honesty Counts Supporting Jeff Gorell & Opposing Claudia Bill-De la Pena for Supervisor 2022		Insurica		Integrated Solutions: Political		Jones - Republican Central Committee 2024; Brian		Kern County Young Republicans Voter Guide		Kern Energy Foundation		Laurence A. Elder & Associates, Inc		Luigi's		MadoroM Vineyards, LLC.		Political Communications, Inc		Proforma Solutions for Printing & Promo		Richardson		SCRIVNER FOR KCCD TRUSTEE 2022		Valladares For Assembly 2022; Suzette Martinez		Western Pacific Research, Inc.		Western Pacific Research, Inc.		Western Pacific Research, Inc.		Western Pacific Research, Inc.		AT&T		Bakersfield Blue		Bakersfield Blue		Budget Watchdogs Newsletter		California Voter Guide		Citizens for Good Government		Dropbox		Dropbox		Facebook		Facebook		Facebook		Facebook		iDonate Pro		Iron Horse Tavern		Kernville Chamber of Commerce		McDonalds		Mendonsa Media		NationBuilder		Senior Advocate - A Project Of The Coalition For California		Target		The American Council for Evangelicals, Inc		The American Council for Evangelicals, Inc		The Park Downtown		Uber Eats
payee_namf		John		Claudia		Jeff		Brian		Christina		Suzette		None		Sherin		None		None		Lindsey		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Shannon		Shannon		Shannon		Shannon		None		None		None		None		None		None		None		None		None		None		None		Tracey		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_city		Bakersfield		None		None		La Mesa		Tehachapi		Hilmar		Bakersfield		Bakersfield		Sacramento		Bakersfield		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfield		San Rafael		Bakersfield		San Diego		La Mesa		Bakersfield		Bakersfield		Los Angeles		Bakersfield		Napa		San Rafael		Bakersfield		Shafter		Tehachapi		Hilmar		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Torrance		Torrance		Covina		San Francisco		San Francisco		Menlo Park		Menlo Park		Menlo Park		Menlo Park		Encinitas		Sacramento		Kernville		Bakersfield		Folsom		Los Angeles		Torrance		Bakersfield		Rocklin		Rocklin		Sacramento		San Francisco
payee_st		CA		None		None		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
payee_zip4		93305		None		None		91942		93561		95324		93305		93312		95814		93309-1102		95831		95816		95816		95816		95816		95816		95816		95816		95816		95816		95816		95816		95816		95816		95816		95816		95816		95816		95816		95816		95816		93312		93308-9709		93308-9709		93308-9709		93308-9709		94913-5703		93311		92116		91942		93309		93309		90046		93305		94559		94903-2121		93301-3033		93263-9666		93561		95324		93309-7425		93309-7425		93309-7425		93309-7425		93309		93309		93309		90505		90505		91722		94158-2381		94158-2381		94025-1452		94025-1452		94025-1452		94025-1452		92007		95811		93238		93301		95630		90013		90505		93312		95765		95765		95814		94103
expn_date		2022-10-05 00:00:00		2022-10-01 00:00:00		2022-10-01 00:00:00		2022-10-11 00:00:00		2022-10-04 00:00:00		2022-10-01 00:00:00		2022-10-05 00:00:00		2022-10-01 00:00:00		2022-10-18 00:00:00		2022-10-03 00:00:00		2022-10-11 00:00:00		2022-09-27 00:00:00		2022-09-27 00:00:00		2022-09-28 00:00:00		2022-09-29 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-11 00:00:00		2022-10-12 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-17 00:00:00		2022-10-17 00:00:00		2022-10-18 00:00:00		2022-10-19 00:00:00		2022-10-20 00:00:00		2022-10-21 00:00:00		2022-10-18 00:00:00		2022-10-04 00:00:00		2022-10-04 00:00:00		2022-10-04 00:00:00		2022-10-04 00:00:00		2022-10-01 00:00:00		2022-10-20 00:00:00		2022-10-04 00:00:00		2022-10-11 00:00:00		2022-10-19 00:00:00		2022-09-27 00:00:00		2022-10-01 00:00:00		2022-10-19 00:00:00		2022-10-18 00:00:00		2022-10-07 00:00:00		2022-10-11 00:00:00		2022-10-04 00:00:00		2022-10-04 00:00:00		2022-10-01 00:00:00		2022-10-01 00:00:00		2022-10-04 00:00:00		2022-10-10 00:00:00		2022-10-19 00:00:00		2022-08-09 00:00:00		2022-08-11 00:00:00		2022-08-12 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-08-24 00:00:00		2022-08-28 00:00:00		2022-08-08 00:00:00		2022-08-21 00:00:00		2022-08-22 00:00:00		2022-09-01 00:00:00		2022-08-19 00:00:00		2022-08-22 00:00:00		2022-08-23 00:00:00		2022-08-31 00:00:00		2022-08-04 00:00:00		2022-08-23 00:00:00		2022-10-19 00:00:00		2022-08-15 00:00:00		2022-08-22 00:00:00		2022-08-22 00:00:00		2022-08-23 00:00:00		2022-08-19 00:00:00
amount		1000		3000		3000		-5100		1000		4900		1000		300		2252		8089		1000		210		244		79		743		471		470		70		7		164		33		108		33		17		14		19		135		232		7		271		273		1000		301		948		408		541		3000		875		175		-5100		18008		1000		5000		861		2408		300		2464		1681		1000		4900		2000		40000		119871		20273		150		27		136		7857		4271		5736		120		20		400		400		27		173		150		269		1000		249		500		103		2409		107		2060		133		1692		139
cum_ytd		1000		3000		3000		9800		1000		4900		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		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		664		651		671		None		667		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		672		657		658		659		660		655		None		None		1003		675		649		656		673		670		None		666		661		662		654		650		663		665		674		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		IKD		IKD		MON		MON		MON		CTB		OFC		CNS		OFC		CNS		OFC		OFC		OFC		PRO		OFC		OFC		OFC		OFC		OFC		OFC		OFC		OFC		OFC		OFC		OFC		OFC		PRO		PRO		PRO		PRO		CVC		TRC		TRC		TRC		TRC		CTB		OFC		OFC		CTB		LIT		CVC		MTG		MTG		MTG		PRO		CMP		CNS		CTB		CTB		CNS		PHO		LIT		LIT		OFC		OFC		OFC		LIT		LIT		LIT		WEB		WEB		WEB		WEB		WEB		WEB		OFC		MTG		OFC		MTG		RAD		WEB		LIT		OFC		CVC		CVC		MTG		MTG
expn_dscr		None		None		None		Refund		None		None		None		Office staffing		Consulting retainer		Credit Card Bill		Consulting retainer		Credit Card Fees		Credit Card Fees		None		None		Credit Card Fees		Credit Card Fees		Credit Card Fees		Credit Card Fees		Credit Card Fees		Credit Card Fees		Credit Card Fees		Credit Card Fees		Credit Card Fees		Credit Card Fees		Credit Card Fees		Credit Card Fees		None		None		None		None		None		Mileage 481 x 62.5 cents a mile		Mileage 1517.2 x 62.5 cents a mile		Mileage 652.2 x 62.5 cents a mile		Mileage 865 x 62.5 cents a mile		None		Insurance		Compliance Software		Refund of Over Limit Contribution		Slate Mailer		None		Speaker Fee		Meeting refreshments		Event refreshments		Compliance and accounting		Paraphernalia		Consulting retainer and mileage		None		None		Consulting retainer		Phone banking and precinct walking		Slate card mailer		Slate card mailer		None		None		None		Slate Mailer		Slate Mailer		Slate Mailer		None		None		Social media ads		Social media ads		None		Social media ads		None		Meeting refreshments		None		Meeting refreshments		None		None		Slate Mailer		None		None		None		Meeting refreshments		Meeting refreshments
agent_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Cardmember Services-Bank of the Sierra		Cardmember Services-Bank of the Sierra		Cardmember Services-Bank of the Sierra		Western Pacific Research, Inc.		Western Pacific Research, Inc.		Western Pacific Research, Inc.		Cardmember Services-Bank of the Sierra		Cardmember Services-Bank of the Sierra		Cardmember Services-Bank of the Sierra		Cardmember Services-Bank of the Sierra		Cardmember Services-Bank of the Sierra		Cardmember Services-Bank of the Sierra		Cardmember Services-Bank of the Sierra		Cardmember Services-Bank of the Sierra		Cardmember Services-Bank of the Sierra		Cardmember Services-Bank of the Sierra		Cardmember Services-Bank of the Sierra		Cardmember Services-Bank of the Sierra		Western Pacific Research, Inc.		Cardmember Services-Bank of the Sierra		Cardmember Services-Bank of the Sierra		Cardmember Services-Bank of the Sierra		Cardmember Services-Bank of the Sierra		Cardmember Services-Bank of the Sierra
agent_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
agent_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
agent_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cmte_id		None		None		None		None		None		None		1453996		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1451295		None		None		1447779		590013		None		None		None		None		None		None		None		1454933		1435635		None		None		None		None		None		None		None		1345115		595004		599010		None		None		None		None		None		None		None		None		None		None		None		None		1439476		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
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
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
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
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
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
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
cand_naml		Antonaros		Bill-De La Pena		Gorell		Jones		Scrivner		Valladares		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Grove		Grove		Grove		Grove		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		John		Claudia		Jeff		Brian		Christina		Suzette		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Shannon		Shannon		Shannon		Shannon		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
office_cd		CCB		BSU		BSU		OTH		CCB		ASM		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		SEN		SEN		SEN		SEN		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		Kern Community College District Board		Ventura County Board of Supervisors		Ventura County Board of Supervisors		Orange County Central Committee		Kern Community College District Board		California State Assembly		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		California State Senate		California State Senate		California State Senate		California State Senate		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		CTY		CTY		CTY		CIT		CTY		ASM		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		SEN		SEN		SEN		SEN		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		Kern Community College District		Ventura County		Ventura County		Orange		Kern County		Assembly 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		Senate District		Senate District		Senate District		Senate 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
dist_no		3		None		None		None		None		40		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		12		12		12		12		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		S		S		S		S		S		S		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
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
sup_opp_cd		S		O		S		S		S		S		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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		E-21375		E-21375		E-21375		E-21433		E-21433		E-21433		E-21375		E-21375		E-21375		E-21375		E-21375		E-21375		E-21375		E-21375		E-21375		E-21375		E-21375		E-21375		E-21433		E-21375		E-21375		E-21375		E-21375		E-21375
g_from_e_f		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		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

Table: filer_filings

filer_id		1414696
filing_id		2743178
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		2743178
filing_type		22001

Table: hdr

filing_id		2743178
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		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178
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		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		116		117
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		A-21321		A-21272		A-21430		A-21337		A-21315		A-21119		A-21441		A-21260		A-21424		A-21419		A-21312		A-21264		A-21318		A-21319		A-21411		A-21268		A-21418		A-21270		A-21469		A-21127		A-21132		A-21323		A-21338		A-21273		A-21366		A-21445		A-21125		A-21124		A-21422		A-21461		A-21429		A-21438		A-21265		A-21362		A-21278		A-21354		A-21415		A-21121		A-21457		A-21267		A-21365		A-21356		A-21129		A-21289		A-21346		A-21285		A-21349		A-21413		A-21269		A-21139		A-21310		A-21348		A-21423		A-21347		A-21352		A-21428		A-21444		A-21388		A-21322		A-21325		A-21368		A-21358		A-21463		A-21443		A-21288		A-21357		A-21277		A-21275		A-21126		A-21459		A-21276		A-21467		A-21122		A-21452		A-21279		A-21293		A-21367		A-21353		A-21462		A-21416		A-21456		A-21308		A-21355		A-21286		A-21359		A-21123		A-21406		A-21414		A-21440		A-21455		A-21317		A-21364		A-21361		A-21360		A-21120		A-21262		A-21263		A-21420		A-21292		A-21417		A-21313		A-21133		A-21274		A-21465		A-21342		A-21261		A-21425		A-21259		A-21458		A-21363		A-21460		A-21339		A-21404		A-21328		A-21405		A-21453		A-21442
entity_cd		IND		IND		OTH		OTH		OTH		OTH		IND		IND		IND		IND		IND		IND		IND		IND		OTH		OTH		COM		COM		OTH		OTH		IND		IND		IND		IND		OTH		OTH		OTH		IND		IND		COM		OTH		OTH		OTH		IND		IND		IND		OTH		IND		IND		IND		OTH		IND		IND		IND		IND		IND		IND		IND		IND		OTH		IND		IND		IND		IND		IND		IND		OTH		OTH		IND		IND		IND		IND		OTH		OTH		IND		IND		IND		IND		IND		IND		IND		OTH		IND		IND		IND		OTH		IND		IND		COM		IND		OTH		OTH		IND		IND		OTH		IND		IND		IND		OTH		OTH		IND		OTH		IND		IND		IND		IND		IND		IND		IND		OTH		OTH		OTH		IND		IND		IND		IND		IND		IND		IND		IND		COM		IND		IND		IND		IND		IND		IND
ctrib_naml		Abel		Acharya		Alia Corp		Allied Potato Inc		AMR Digital Forensics		Anthony Vineyards		Bender		Bengard		Birmingham		Brandt		Brassfield-Cooper		Brown		Brown		Brown		Brown's Construction Service, Inc.		Burrtec Kern, LLC		California Nevada Cement Association PAC		California Statewide Law Enforcement Association PAC		California Water Service Company		CalPortland Company		Camp		Camp		Carney		Caves		Center For Neuro Skills		Central Valley Cafes		Continental Labor & Staffing Resources Inc.		Cornforth		Crosswhite		Doctors Company PAC		E & B Natural Resources Management Group		E & B Natural Resources Management Group		Ember Education		Eucce		Farr		Farris		Fleet Services Towing, Inc		Fritch		Froehlich		Gay		Gaytri, Inc.		Giannelli		Good		Griffith		Gutierrez		Hardt		Harlan		Harmer		Hay		Healthcare Finance Direct LLC		Janszen		Jones		Jones		Jones		Jordan		Joughin		Kern County Cafes, Inc.		Kern Ridge Growers LLC		Kilby		Kim		Kissack		Krauter		L4 Enterprises		Lakeview Farms		Lane		Lederhos		Loyd		Lynn		Malakian		Manzo		Marchbanks		Mashburn Transportation Services, Inc.		Medders		Mitts		Nicholas		Nickel Family LLC		Pandol		Paulden		Personal Insurance Federation of CA Agents & Employees PAC		Peters		Pro Tool Services, Inc.		Pyrenees Cafe		Rasmussen		Rivera		Roca Del Rio, LLC		Rosenlieb		Rowe		Rowe		Schwebel Petroleum Company		Setton Pistachio Of Terra Bella, Inc.		Shick		Sierra Construction & Excavation Inc.		Singh Kooner		Singh		Slayton		Snedden		Snedden		Stone		Stovall		Tejon Indian Tribe		The Redd Group, LLC		TRC Operating Company		Vasinda		Vowles		Wade		Wade		Walker		Warner		Watnick		Watson		WECA Good Government PAC		Wegis		Woodward		Wright		Wright		Yurosek		Zerbe
ctrib_namf		Rich		Ganesh		None		None		None		None		Gregg		Kim		Thomas		Robert		Robin		Karen		Kelly		Pat		None		None		None		None		None		None		Clayton		Edwin		David		Michael		None		None		None		Donald		Jeff		None		None		None		None		Steven		William		Patricia		None		Charles		Ronald		Catherine		None		Teresa		Albert		Kyle		Greg		Michelle		Floyd		George		Dan		None		Jack		Cindy		Kenneth		Rick		Josephate		Cathie		None		None		Lorraine		Tony		Lynda		Chris		None		None		Joseph		Judy		Steven		Bruce		Nader		Thomas		William		None		Wilna		Thomas		Theodore		None		Lucy		Cameron		None		Charles		None		None		Jeffrey		Alphonso		None		Katherine		Fred		Susan		None		None		Deborah		None		Nazar		Satnam		Skipper		Richard		Susie		Jeffrey		John		None		None		None		Mary		Rebecca		Patrick		Paul		Allan		John		Don		Tamara		None		Fredrick		Robin		Cassandra		David		Devon		Marion
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		Bakersfield		Bakersfield		Merced		Bakersfield		Bakersfield		Bakersfield		Bakersfield		San Clemente		Sacramento		Bakersfield		Bakersfield		Bakersfield		Newport Beach		Newport Beach		Bakersfield		Fontana		Sacramento		Sacramento		San Jose		Glendora		Bakersfield		Bakersfield		Hancock		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Napa		Bakersfield		Bakersfield		Visalia		Bakersfield		Bakersfield		Ridgecrest		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Delano		Bakersfield		Bakersfield		Balersfield		Clovis		Taft		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Arvin		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Fresno		Los Angeles		Bakersfield		Taft		Bakersfield		Visalia		Bakersfield		Bakersfield		Delano		Bakersfield		Sacramento		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Bakersfiled		Terra Bella		McFarland		Bakersfield		Bakersfield		Bakersfield		Bakersfield		Maricopa		Maricopa		Bakersfield		Bakersfield		Arvin		Bakersfield		Taft		Bakersfield		Pioneertown		Bakersfield		Bakersfield		Bakersfield		Newport Beach		Clovis		Bakersfield		Sacramento		Bakersfield		Bakersfield		Bakersfield		Modesto		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		NH		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
ctrib_zip4		93312		93312		95341-8005		93309		93313		93307		93308		92672		95818		93311-2964		93312		93314		92657		92657		93308		92335		95814		95814-3926		95112		91741		93314		93308		03449		93312		93313		93313		93309		93311		93314		94558-6270		93308		93308		93277-9238		93308		93312		93555		93308		93312		93314		93309-2740		93301		93311		93215		93314		93306		93306		93611		93268		93309		93301		93312		93308		93301		93308		93309		93308		93314		93203		93308		93311		93309		93312		93312		93311		93308		93308		93308		93306		93711		91040		93311		93268		93309		93292		93312		93306		93215		93311		95814		93314		93308		93305		93308		93313		93308		93309		93314		93314		93302		93270		93250		93312		93307		93311		93314-8324		93252-0129		93252		93308		93311		93203		93309		93268		93309		92268		93311		93311		93308		92660		93612		93311		95814		93301		93308		93313		95350		93308		93308
ctrib_emp		Jaco Oil		Genesis Healthcare Management, LLC		None		None		None		None		Caliber Home Loans		None		Westlands Water District		Retired		Robin's Envirovac		None		DBA: Kelly Brown		Lifetime Fitness-PB System		None		None		None		None		None		None		Kern Machinery		DM Camp & Sons		NHA, Inc.		Kern County		None		None		None		Donald Cornforth MD		Retired		None		None		None		None		Broken Hinge Handyman Services		Farr Medical		News Review		None		Fritch Eye Care Medical Center		Signature Development		N/A		None		Three-Way Chevy		Castlerock Farming & Transport		Randy's Trucking Inc & Core Industrial Services		Truitt Corporation		Hardt Construction Services		Harlan Ranch Company		Gps		Jim Burke Ford		None		Sturgeon Services Intl		Retired		Retired		Brown's Construction Services		Christ First Ministres		None		None		None		Kern County Superintendent of Schools		Renaissance International		DBA; Lynda Kissack		Arvin Edison Water Storage District		None		None		The garlic Company		DBA: J L Lederhos		Loyd's Aviation		The Lynn Company		MDC		Cabia		Retired		None		Retired		Thomas F. Mitts, M.D., Inc.		Three-Way Chevrolet Co		None		Lucy Pandol Family Farms, LLC		DBA; Cameron Paulden		None		San Joaquin Bit Service, Inc.		None		None		Crop Production Services		AMR Digital Forensics		None		Retired		DBA: Fred Rowe		Retired		None		None		Clinton Shick Farms		None		Kooner Investment Farms		Satgur Transport		N/A		dba: Richard Snedden		DBA: Susie Snedden		DBA: Jeffrey Stone		N/A		None		None		None		Around the Clock		Retired		Precision Pharmacy		Process Instruments		Retired		Retired		Retired		None		None		DBA: Fredrick Wegis		Chevron		Bill Wright Foundation		Farmers Insurance		DBA: Blodgie Rodriguez		DBA; Marion Zerbe
ctrib_occ		Retail Management		CEO		None		None		None		None		Loan Consultant		Investor		Manager		Retired		Owner		Homemaker		CEO- owner		Wellness / fitness manufacture		None		None		None		None		None		None		CEO		Farmer		CEO		Prosecuter		None		None		None		Md		Retired		None		None		None		None		Business Owner		Physician		Editor/Publisher		None		Opthamologist		Builder		Homemaker		None		Administrator		Agriculture Business		Vice President & Owner		Management		Designer		Farmer		Safety Director		President		None		Senior Vice President		Retired		Retired		Partner		Pastor Jordan		Homemaker		None		None		Administrative Secretary		Pastor		Hometown Directory		General Superintendent		None		None		Owner		Engineer		CEO		Insurance Agent		Owner		Founder		Retired		None		Retired		Physician		President		None		Farmer		Attorney		None		Sales		None		None		Manager		CEO		None		Retired		Physician		Retired		None		None		Farmer		None		Owner		Business Manager		Retired		Cattle rancher		Cattle rancher		Rancher		Retired		None		None		None		President/Owner		Retired		Entreprenuer		Manager		Retired		Retired		Retired		Homemaker		None		Real estate & Farmer		Corporate Affairs Advisor		Philanthropist		Insurance Broker/ Modesto City Council member		Farmer		Safety Consultant
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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-10-10 00:00:00		2022-09-30 00:00:00		2022-10-19 00:00:00		2022-10-12 00:00:00		2022-10-06 00:00:00		2022-09-26 00:00:00		2022-10-19 00:00:00		2022-09-29 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-06 00:00:00		2022-09-30 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-18 00:00:00		2022-09-30 00:00:00		2022-10-18 00:00:00		2022-09-30 00:00:00		2022-10-21 00:00:00		2022-09-26 00:00:00		2022-09-27 00:00:00		2022-10-10 00:00:00		2022-10-12 00:00:00		2022-09-30 00:00:00		2022-10-17 00:00:00		2022-10-19 00:00:00		2022-09-26 00:00:00		2022-09-26 00:00:00		2022-10-18 00:00:00		2022-10-20 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-09-30 00:00:00		2022-10-17 00:00:00		2022-09-30 00:00:00		2022-10-17 00:00:00		2022-10-18 00:00:00		2022-09-26 00:00:00		2022-10-20 00:00:00		2022-09-30 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-09-26 00:00:00		2022-10-03 00:00:00		2022-10-14 00:00:00		2022-10-02 00:00:00		2022-10-15 00:00:00		2022-10-18 00:00:00		2022-09-30 00:00:00		2022-09-27 00:00:00		2022-10-05 00:00:00		2022-10-14 00:00:00		2022-10-18 00:00:00		2022-10-14 00:00:00		2022-10-17 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-06 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-20 00:00:00		2022-10-19 00:00:00		2022-10-03 00:00:00		2022-10-17 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-09-26 00:00:00		2022-10-20 00:00:00		2022-09-30 00:00:00		2022-10-21 00:00:00		2022-09-26 00:00:00		2022-10-19 00:00:00		2022-10-01 00:00:00		2022-10-04 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-20 00:00:00		2022-10-18 00:00:00		2022-10-20 00:00:00		2022-10-05 00:00:00		2022-10-17 00:00:00		2022-10-02 00:00:00		2022-10-17 00:00:00		2022-09-26 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-19 00:00:00		2022-10-20 00:00:00		2022-10-06 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-09-26 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-10-18 00:00:00		2022-10-04 00:00:00		2022-10-18 00:00:00		2022-10-06 00:00:00		2022-09-27 00:00:00		2022-09-30 00:00:00		2022-10-21 00:00:00		2022-10-12 00:00:00		2022-09-29 00:00:00		2022-10-18 00:00:00		2022-09-29 00:00:00		2022-10-20 00:00:00		2022-10-17 00:00:00		2022-10-20 00:00:00		2022-10-12 00:00:00		2022-10-18 00:00:00		2022-10-11 00:00:00		2022-10-18 00:00:00		2022-10-19 00:00:00		2022-10-19 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		1000		2500		500		3060		500		2500		250		999		1070		250		500		1000		250		250		500		1000		1000		2000		4900		1000		1070		1000		200		125		1000		500		2500		1000		500		2000		1500		2500		1000		500		2500		250		1000		1000		1000		250		250		1000		4900		1070		500		1070		100		535		500		4900		100		1250		2674		1250		500		500		500		1000		125		250		250		125		250		1000		100		125		1000		1000		4900		535		1000		3000		125		250		500		1000		1000		250		2500		1000		2140		4900		125		1000		4900		100		1250		1250		500		1070		500		250		500		500		2500		150		150		125		100		2500		1000		535		1000		100		1000		1000		100		268		214		2000		2000		287		100		1000		500		1605		375
cum_ytd		1000		2500		1500		3060		500		2500		250		3499		1070		250		500		1000		250		250		500		1000		1000		2000		4900		1000		1070		1000		200		125		1000		500		2500		1000		500		2000		4000		4000		1000		500		2500		250		1000		1000		1000		250		250		1000		4900		1070		500		1070		100		535		500		4900		100		1250		2674		1250		500		500		500		1000		125		250		250		125		250		1000		350		1125		1000		1000		4900		535		1000		3000		125		250		500		1000		1000		250		2500		1000		2140		4900		125		1000		4900		100		1250		1250		500		1070		500		250		500		500		2500		150		150		125		100		2500		2500		535		2070		100		1000		1000		207		268		214		2000		2000		287		100		3500		500		1605		375
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1402766		970375		None		None		None		None		None		None		None		None		None		None		None		923140		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1338487		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		991225		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		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178
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		127036		0		127036		0		127036		238283		0		238283		0		0		238283		258828		127036		1		238283		147581		0		0		0		157484		291493		126903		132		127036		0		0		0		0		0		0		7800		0		7800		238153		130		0		238283		0		0		0		0		0		0		0		1		0		1
amount_b		465386		0		465386		2651		468038		658508		0		658508		0		2651		661159		None		None		None		None		None		None		None		None		310553		369666		None		None		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		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178		2743178
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
line_item		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		20		21		22		23		24		25		26		27		28		29		30		31		32		33		34		35		36		37		38		39		40		41		42		43		44		45		46		47		48		49		50		51		52		53		54		55		56		57		58		59		60		61		62		63		64		65		66		67		68		69		70		71		72		73		74		75		76		77		78		79		80		81		82		83		84		85		86		87		88		89		90		91		92		93		94		95		96		97		98		99		100		101		102		103		104		105		106		107		108		109		110		111		112		113		114		115		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
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		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		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
ptran_id		A-21272		A-21430		A-21119		A-21260		A-21419		A-21264		A-21418		A-21270		A-21127		A-21366		A-21125		A-21124		A-21461		A-21265		A-21267		A-21413		A-21269		A-21352		A-21428		A-21388		A-21325		A-21467		A-21293		A-21462		A-21416		A-21456		A-21440		A-21361		A-21262		A-21292		A-21417		A-21313		A-21274		A-21342		A-21261		A-21425		A-21259		A-21453		A-21321		A-21272		A-21430		A-21337		A-21315		A-21119		A-21441		A-21260		A-21424		A-21419		A-21312		A-21264		A-21318		A-21319		A-21411		A-21268		A-21418		A-21270		A-21469		A-21127		A-21132		A-21323		A-21338		A-21273		A-21366		A-21445		A-21125		A-21124		A-21422		A-21461		A-21429		A-21438		A-21265		A-21362		A-21278		A-21354		A-21415		A-21121		A-21457		A-21267		A-21365		A-21356		A-21129		A-21289		A-21346		A-21285		A-21349		A-21413		A-21269		A-21139		A-21310		A-21348		A-21423		A-21347		A-21352		A-21428		A-21444		A-21388		A-21322		A-21325		A-21368		A-21358		A-21463		A-21443		A-21288		A-21357		A-21277		A-21275		A-21126		A-21459		A-21276		A-21467		A-21122		A-21452		A-21279		A-21293		A-21367		A-21353		A-21462		A-21416		A-21456		A-21308		A-21355		A-21286		A-21359		A-21123		A-21406		A-21414		A-21440		A-21455		A-21317		A-21364		A-21361		A-21360		A-21120		A-21262		A-21263		A-21420		A-21292		A-21417		A-21313		A-21133		A-21274		A-21465		A-21342		A-21261		A-21425		A-21259		A-21458		A-21363		A-21460		A-21339		A-21404		A-21328		A-21405		A-21453		A-21442		D-21307		D-21284		D-21283		D-21302		D-21281
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-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-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-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-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
elec_amount		2674		2500		4900		2500		500		1250		1250		1500		4900		1000		2500		2674		4700		4900		500		100		1500		280		200		2250		200		4700		4250		4900		4900		1500		2500		625		250		850		750		1500		2070		3500		2500		242		293		2000		1000		2500		500		3060		500		2600		250		999		1070		250		500		1000		250		250		500		1000		1000		2000		4900		1100		1070		1000		200		125		1000		500		2500		1000		500		2000		4000		4000		3350		500		2500		250		1000		1000		1000		250		250		1000		4900		1070		500		1070		100		535		500		4900		100		1250		2674		1250		500		500		500		1000		125		250		250		125		250		1000		350		1125		1000		1000		4900		535		1000		3300		125		250		500		1000		1000		250		4800		1000		2140		4900		125		1000		4900		100		1250		1250		500		1070		500		250		500		500		2500		150		150		125		100		2500		1000		535		1000		100		1000		1000		100		268		214		2000		2000		287		100		3500		500		1605		375		1000		3000		3000		1000		4900
elec_code		P		P		P		P		P		P		P		P		P		P		P		P		P		P		P		P		P		P		P		P		P		P		P		P		P		P		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		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