Home

Filer ID: 1239171

Table: cvr_campaign_disclosure

filing_id		805588		821826		852927		877092		876540		882223		886804		876540		907612		941427		962701		979434		1027959		1049955		1079941		1145469		1117279		1232261		1397211		1539025		1540513		1566153		1528715		1829139		1842758		1879522		1885660		1866427		1887706		1889916		1879522		1931492		1905213		2204970		2292005		2347260		2486683		2492744		2442209		2522305		2509996		2512025		2513774		2518836		2528402		2523358		2550256		2516900		2509994		2512025		2518836		2519566		2516900		2522263		2523350		2509999		2527436		2527441		2527443		2527447		2527449		2509999		2516900		2519566		2533020		2598709		2674722		2637696		2715515		2717339		2723854		2703294		2637696		2720800		2721267		2738010		2753069
amend_id		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		1		1		1		2		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F461		F497		F461		F497		F497		F497		F497		F497		F461		F461		F461		F461		F461		F497		F461		F461		F461		F461		F461		F497		F497		F461		F497		F497		F497		F497		F497		F461		F497		F497		F497		F461		F497		F461		F497		F461		F461		F497		F461		F497		F497		F496		F497		F496		F497		F497		F461		F496		F497		F496		F496		F496		F496		F497		F497		F496		F497		F497		F497		F497		F497		F496		F496		F496		F497		F461		F497		F461		F497		F497		F497		F461		F461		F497		F497		F497		F497
filer_id		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171
entity_cd		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI
filer_naml		Robert N. Klein II & Connie R. Klein		Robert N. Klein II & Connie R. Klein		Robert N. Klein II & Connie R. Klein		Robert N. Klein II & Connie R. Klein		Robert N. Klein II & Connie R. Klein		Robert N. Klein II & Connie R. Klein		Robert N. Klein II & Connie R. Klein		Robert N. Klein II & Connie R. Klein		Robert N. Klein II & Connie R. Klein		Robert N. Klein II & Connie R. Klein		Robert N. Klein II & Connie R. Klein		Robert N. Klein II & Connie R. Klein		Robert N. Klein II & Connie R. Klein		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II and affiliated entity Klein Financial Corporation		Robert N. Klein II and affiliated entity Klein Financial Corporation		Robert N. Klein II and affiliated entity Klein Financial Corporation		Robert N. Klein II and affiliated entity Klein Financial Corporation		Robert N. Klein II and affiliated entity Klein Financial Corporation		Robert N. Klein II and affiliated entity Klein Financial Corporation		Robert N. Klein II and affiliated entity Klein Financial Corporation		Robert N. Klein II and affiliated entity Klein Financial Corporation		Robert N. Klein II and affiliated entity Klein Financial Corporation		Robert N. Klein II and affiliated entity Klein Financial Corporation		Robert N. Klein II and affiliated entity Klein Financial Corporation		Robert N. Klein II and affiliated entity Klein Financial Corporation		Robert N. Klein II and affiliated entity Klein Financial Corporation		Robert N. Klein II and affiliated entity Klein Financial Corporation		Robert N. Klein II and affiliated entity Klein Financial Corporation		Robert N. Klein II and affiliated entity Klein Financial Corporation		Robert N. Klein II and affiliated entity Klein Financial Corporation		Robert N. Klein II and affiliated entity Klein Financial Corporation		Robert N. Klein II and affiliated entity Klein Financial Corporation		Robert N. Klein II and affiliated entity Klein Financial Corporation		Robert N. Klein II and affiliated entity Klein Financial Corporation		Robert N. Klein II and affiliated entity Klein Financial Corporation		Robert N. Klein II and affiliated entity Klein Financial Corporation		Robert N. Klein II and affiliated entity Klein Financial Corporation		Robert N. Klein II and affiliated entity Klein Financial Corporation		Robert N. Klein II and affiliated entity Klein Financial Corporation		Robert N. Klein II and Affiliated Entity Klein Financial Corporation		Robert N. Klein II and Affiliated Entity Klein Financial Corporation		Robert N. Klein II and Affiliated Entity Klein Financial Corporation		Robert N. Klein II and Affiliated Entity Klein Financial Corporation		Robert N. Klein II and Affiliated Entity Klein Financial Corporation		Robert N. Klein II and Affiliated Entity Klein Financial Corporation		Robert N. Klein II and Affiliated Entity Klein Financial Corporation		Robert N. Klein II and Affiliated Entity Klein Financial Corporation		Robert N. Klein II and Affiliated Entity Klein Financial Corporation		Robert N. Klein II and Affiliated Entity Klein Financial Corporation		Robert N. Klein II and Affiliated Entity Klein Financial Corporation		Robert N. Klein II and Affiliated Entity Klein Financial Corporation
filer_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
filer_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
filer_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
report_num		000		000		000		000		000		000		000		001		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		001		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		001		000		001		001		001		002		000		000		000		000		000		000		000		000		001		000		000		000		000		000		000		000		000		000		000		001		000		000		000		000
rpt_date		2002-01-10 00:00:00		2002-02-20 00:00:00		2002-07-23 00:00:00		2002-10-23 00:00:00		2002-10-22 00:00:00		2002-10-29 00:00:00		2002-11-01 00:00:00		2002-11-01 00:00:00		2003-01-22 00:00:00		2003-07-08 00:00:00		2003-10-07 00:00:00		2004-01-08 00:00:00		2004-07-27 00:00:00		2004-10-20 00:00:00		2005-01-25 00:00:00		2006-01-13 00:00:00		2005-07-28 00:00:00		2007-01-24 00:00:00		2009-01-28 00:00:00		2010-10-29 00:00:00		2010-11-01 00:00:00		2011-01-20 00:00:00		2010-10-18 00:00:00		2014-03-14 00:00:00		2014-04-28 00:00:00		2014-08-21 00:00:00		2014-09-16 00:00:00		2014-07-09 00:00:00		2014-09-23 00:00:00		2014-09-30 00:00:00		2015-01-21 00:00:00		2015-01-21 00:00:00		2014-10-24 00:00:00		2018-01-17 00:00:00		2018-09-14 00:00:00		2019-01-23 00:00:00		2020-07-31 00:00:00		2020-08-18 00:00:00		2020-01-30 00:00:00		2020-10-23 00:00:00		2020-10-05 00:00:00		2020-10-08 00:00:00		2020-10-12 00:00:00		2020-10-20 00:00:00		2020-10-30 00:00:00		2020-10-26 00:00:00		2021-01-29 00:00:00		2020-10-19 00:00:00		2020-10-05 00:00:00		2020-10-30 00:00:00		2020-10-30 00:00:00		2020-10-30 00:00:00		2020-10-30 00:00:00		2020-10-23 00:00:00		2020-10-26 00:00:00		2020-10-05 00:00:00		2020-10-26 00:00:00		2020-10-26 00:00:00		2020-10-26 00:00:00		2020-10-26 00:00:00		2020-10-26 00:00:00		2020-10-30 00:00:00		2020-10-16 00:00:00		2020-10-21 00:00:00		2020-11-04 00:00:00		2021-07-23 00:00:00		2022-04-29 00:00:00		2022-01-13 00:00:00		2022-08-30 00:00:00		2022-09-06 00:00:00		2022-09-26 00:00:00		2022-07-27 00:00:00		2022-07-25 00:00:00		2022-09-16 00:00:00		2022-09-19 00:00:00		2022-10-20 00:00:00		2022-11-07 00:00:00
stmt_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
late_rptno		None		1		None		2		1		3		4		1		None		None		None		None		None		1		None		None		None		None		None		2		3		None		1		P14-1		P14-2		G14-1		G14-2		None		G14-3		G14-4		G14-1		None		G14-5		None		g2018-1		None		None		g2020-1		None		loan0904		g2020-2		g2020-3		g2020-4		ind2020-6		g2020-26		g2020-25		None		g2020-5		g2020-1		g2020-3		ind2020-6		ind2020-7		G2020-5		g2020-23		g2020-24		ind2020-1		g2020-1a		g2020-3a		g2020-5a		g2020-6a		g2020-7a		ind2020-1		G2020-5		ind2020-7		g2020-27		None		347691-JM		None		286464-JM		286649-JM		287446-KL		None		None		286897-JM		286912-JM		775979-JM		776277-JM
from_date		2001-07-01 00:00:00		None		2002-01-01 00:00:00		None		None		None		None		None		2002-07-01 00:00:00		2003-01-01 00:00:00		2003-07-01 00:00:00		2003-10-01 00:00:00		2004-01-01 00:00:00		None		2004-07-01 00:00:00		2005-07-01 00:00:00		2005-01-01 00:00:00		2006-01-01 00:00:00		2008-01-01 00:00:00		None		None		2010-01-01 00:00:00		None		None		None		None		None		2014-01-01 00:00:00		None		None		None		2014-07-01 00:00:00		None		2017-01-01 00:00:00		None		2018-01-01 00:00:00		2020-01-01 00:00:00		None		2019-01-01 00:00:00		None		None		None		None		None		None		None		2020-07-01 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2021-01-01 00:00:00		None		2021-07-01 00:00:00		None		None		None		2022-01-01 00:00:00		2021-07-01 00:00:00		None		None		None		None
thru_date		2001-12-31 00:00:00		None		2002-06-30 00:00:00		None		None		None		None		None		2002-12-31 00:00:00		2003-06-30 00:00:00		2003-09-30 00:00:00		2003-12-31 00:00:00		2004-06-30 00:00:00		None		2004-12-31 00:00:00		2005-12-31 00:00:00		2005-06-30 00:00:00		2006-12-31 00:00:00		2008-12-31 00:00:00		None		None		2010-12-31 00:00:00		None		None		None		None		None		2014-06-30 00:00:00		None		None		None		2014-12-31 00:00:00		None		2017-12-31 00:00:00		None		2018-12-31 00:00:00		2020-06-30 00:00:00		None		2019-12-31 00:00:00		None		None		None		None		None		None		None		2020-12-31 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2021-06-30 00:00:00		None		2021-12-31 00:00:00		None		None		None		2022-06-30 00:00:00		2021-12-31 00:00:00		None		None		None		None
elect_date		None		None		None		None		None		None		None		None		None		None		2004-03-02 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_city		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno		Fresno
filer_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		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
filer_zip4		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721		93721
filer_phon		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901
filer_fax		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
file_email		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
mail_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
mail_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
mail_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
tres_naml		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		Robert N. Klein II		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
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
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
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
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
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
tres_phon		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		(559) 441-7901		None		(559) 441-7901		None		None		None		(559) 441-7901		(559) 441-7901		None		None		None		None
tres_fax		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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_email		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cmtte_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
control_yn		N		None		N		None		None		None		None		None		N		N		N		N		N		None		N		N		N		N		N		None		None		N		None		None		None		None		None		N		None		None		None		N		None		N		None		N		N		None		N		None		None		None		None		None		None		None		N		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		N		None		N		None		None		None		N		N		None		None		None		None
sponsor_yn		N		None		N		None		None		None		None		None		N		N		N		N		N		None		N		N		N		N		N		None		None		N		None		None		None		None		None		N		None		None		None		N		None		N		None		N		N		None		N		None		None		None		None		None		None		None		N		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		N		None		N		None		None		None		N		N		None		None		None		None
primfrm_yn		N		None		N		None		None		None		None		None		N		N		N		N		N		None		N		N		N		N		N		None		None		N		None		None		None		None		None		N		None		None		None		N		None		N		None		N		N		None		N		None		None		None		None		None		None		None		N		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		N		None		N		None		None		None		N		N		None		None		None		None
brdbase_yn		N		None		N		None		None		None		None		None		N		N		N		N		N		None		N		N		N		N		N		None		None		N		None		None		None		None		None		N		None		None		None		N		None		N		None		N		N		None		N		None		None		None		None		None		None		None		N		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		N		None		N		None		None		None		N		N		None		None		None		None
amendexp_1		None		None		None		None		None		None		None		Amending to correct contributor		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Amending to correct date and amount of contribution		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Amending for actual description of expenditure		None		Filed form 496 when form 497 should have been filed. Please reference form 497; Report #g2020-3a;		Filed form 496 when form 497 should have been filed. Please reference form 497; Report #g2020-6a;		Filed form 496 when form 497 should have been filed. Please reference form 497; Report #g2020-7a;		Filed form 496 when form 497 should have been filed. Please reference form 497; Report #g2020-5a;		None		None		None		None		None		None		None		None		Filed form 496 when form 497 should have been filed. Please reference form 497; Report #g2020-1a;		None		None		None		None		None		None		None		None		None		None		Update Contribution Information		None		None		None		None
amendexp_2		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Filing ID #CA-2527441		Filing ID #CA-2527447		Filing ID #CA-2527449		Filing ID #CA-2527443		None		None		None		None		None		None		None		None		Filing ID #CA-2527436		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
amendexp_3		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rpt_att_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cmtte_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
reportname		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rptfromdt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rptthrudt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
emplbus_cb		X		None		X		None		None		None		None		None		X		X		X		X		X		None		X		X		X		X		X		None		None		X		None		None		None		None		None		X		None		None		None		X		None		X		None		X		X		None		X		None		None		None		None		None		None		None		X		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		X		None		X		None		None		None		X		X		None		None		None		None
bus_name		Klein Financial Corporation		None		Klein Financial Corporation		None		None		None		None		None		Klein Financial Corporation		Klein Financial Corporation		Klein Financial Corporation		Klein Financial Corporation		Klein Financial Corporation		None		Klein Financial Corporation		Klein Financial Corporation		Klein Financial Corporation		Klein Financial Corporation		Klein Financial Corporation		None		None		Klein Financial Corporation		None		None		None		None		None		Klein Financial Corporation		None		None		None		Klein Financial Corporation		None		Klein Financial Corporation		None		Klein Financial Corporation		Klein Financial Corporation		None		Klein Financial Corporation		None		None		None		None		None		None		None		Klein Financial Corporation		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Klein Financial Corporation		None		Klein Financial Corporation		None		None		None		Klein Financial Corporation		Klein Financial Corporation		None		None		None		None
bus_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		Fresno		None		Fresno		None		None		None		Fresno		Fresno		None		None		None		None
bus_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		CA		None		CA		None		None		None		CA		CA		None		None		None		None
bus_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		93721		None		93721		None		None		None		93721		93721		None		None		None		None
bus_inter		Investments		None		Investments		None		None		None		None		None		Investments		Investments		Investments		Investments		Investments		None		Investments		Investments		Investments		Investments		Investments		None		None		Investments		None		None		None		None		None		Investments		None		None		None		Investments		None		Investments		None		Investments		Investments		None		Investments		None		None		None		None		None		None		None		Investments		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Investments		None		Investments		None		None		None		Investments		Investments		None		None		None		None
busact_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
busactvity		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
assoc_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
assoc_int		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
other_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
other_int		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
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
cand_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		Los Angeles		None		Los Angeles		None		None		None		Los Angeles		None		Los Angeles		Los Angeles		Los Angeles		Los Angeles		None		None		Los Angeles		None		None		None		None		None		Los Angeles		Los Angeles		Los Angeles		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_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		CA		None		CA		None		None		None		CA		None		CA		CA		CA		CA		None		None		CA		None		None		None		None		None		CA		CA		CA		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_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		90028		None		90028		None		None		None		90028		None		90028		90028		90028		90028		None		None		90028		None		None		None		None		None		90028		90028		90028		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_phon		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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_fax		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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_email		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		Authorizes Bonds to Continue Funding Stem Cell and Other Medical Research		None		Authorizes Bonds to Continue Funding Stem Cell and Other Medical Research		None		None		None		Authorizes Bonds to Continue Funding Stem Cell and Other Medical Research		None		Authorizes Bonds to Continue Funding Stem Cell and Other Medical Research		Authorizes Bonds to Continue Funding Stem Cell and Other Medical Research		Authorizes Bonds to Continue Funding Stem Cell and Other Medical Research		Authorizes Bonds to Continue Funding Stem Cell and Other Medical Research		None		None		Authorizes Bonds to Continue Funding Stem Cell and Other Medical Research		None		None		None		None		None		Authorizes Bonds to Continue Funding Stem Cell and Other Medical Research		Authorizes Bonds to Continue Funding Stem Cell and Other Medical Research		Authorizes Bonds to Continue Funding Stem Cell and Other Medical Research		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		14		None		14		None		None		None		14		None		14		14		14		14		None		None		14		None		None		None		None		None		14		14		14		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		Statewide		None		Statewide		None		None		None		Statewide		None		Statewide		Statewide		Statewide		Statewide		None		None		Statewide		None		None		None		None		None		Statewide		Statewide		Statewide		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
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
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
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
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
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
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		S		None		S		None		None		None		S		None		S		S		S		S		None		None		S		None		None		None		None		None		S		S		S		None		None		None		None		None		None		None		None		None		None		None		None		None
employer		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
occupation		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
selfemp_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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: efs_filing_log

filing_date		2002-02-21 00:00:00		2002-01-10 00:00:00		2002-07-29 00:00:00		2002-11-01 00:00:00		2002-10-23 00:00:00		2002-10-22 00:00:00		2002-11-01 00:00:00		2002-10-29 00:00:00		2003-01-28 00:00:00		2003-07-14 00:00:00		2003-10-09 00:00:00		2004-01-10 00:00:00
filingstatus		0		0		0		0		0		0		0		0		0		0		0		0
vendor		NETFILE		NETFILE		NETFILE		NETFILE		NETFILE		NETFILE		NETFILE		NETFILE		NETFILE		NETFILE		NETFILE		NETFILE
filer_id		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171
form_type		F497		F461		F461		F497		F497		F497		F497		F497		F461		F461		F461		F461
error_no		ACCEPTED		ACCEPTED		ACCEPTED		ACCEPTED		ACCEPTED		ACCEPTED		ACCEPTED		ACCEPTED		ACCEPTED		ACCEPTED		ACCEPTED		ACCEPTED

Table: filer_address

filer_id		1239171
adrid		2022574
effect_dt		2001-07-12 00:00:00
add_type		7051
session_id		2001

Table: filer_filings

filer_id		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171
filing_id		792208		805588		809158		824710		821826		859880		877092		880002		889183		889188		852927		876540		877872		886804		876540		888324		907612		882223		916678		962701		941427		964571		955856		955936		979434		992133		1027959		1029303		1049955		1079941		1058217		1092374		1118210		1117279		1145469		1180696		1232261		1251907		1866427		1956393		1889916		1879522		1905213		1402116		1397211		1528715		1543691		1539025		1546367		1540513		1566153		1576838		1829139		1879522		1931492		1887706		1875942		1885660		1842758		2486683		2368593		2509996		2512025		2523358		2509999		2227939		2347260		2513774		2204970		2522263		2509994		2442209		2516900		2527436		2527441		2527443		2527447		2527449		2509999		2533020		2516900		2519566		2564324		2598709		2292005		2518836		2528402		2476594		2512025		2518836		2519566		2516900		2523350		2522305		2550256		2503714		2492744		2637696		2674722		2607451		2715515		2717339		2720800		2723854		2703294		2637696		2663866		2712663		2663866		2721267		2738010		2753069
period_id		None		167		None		None		169		None		172		None		None		None		169		172		None		172		172		None		171		172		None		175		173		None		None		None		176		None		177		None		180		179		None		None		None		181		183		None		185		None		217		None		219		219		220		None		193		204		None		204		None		204		201		None		217		221		219		219		None		219		218		241		None		244		244		244		244		None		233		244		229		244		244		237		244		244		244		244		244		244		244		244		244		244		None		245		235		244		244		None		244		244		244		244		244		244		243		None		243		247		250		None		251		251		251		251		249		247		None		None		None		251		252		252
form_id		F461		F461		F461		F497		F497		F461		F497		F497		F497		F497		F461		F497		F497		F497		F497		F497		F461		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F461		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F497		F497		F461		F461		F497		F497		F497		F497		F497		F461		F461		F497		F497		F461		F497		F461		F497		F497		F461		F461		F497		F496		F497		F496		F461		F461		F497		F461		F497		F497		F461		F496		F497		F497		F497		F497		F497		F496		F497		F496		F496		F461		F461		F497		F496		F497		F461		F496		F496		F496		F496		F497		F497		F461		F461		F497		F461		F497		F461		F497		F497		F497		F497		F461		F461		F461		F461		F461		F497		F497		F497
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		1		1		2		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		1		0		0		0
filing_date		2001-07-31 00:00:00		2002-01-10 00:00:00		2002-01-10 00:00:00		2002-02-20 00:00:00		2002-02-21 00:00:00		2002-07-31 00:00:00		2002-10-23 00:00:00		2002-10-23 00:00:00		2002-11-01 00:00:00		2002-11-01 00:00:00		2002-07-29 00:00:00		2002-10-22 00:00:00		2002-10-22 00:00:00		2002-11-01 00:00:00		2002-11-01 00:00:00		2002-10-29 00:00:00		2003-01-28 00:00:00		2002-10-29 00:00:00		2003-01-29 00:00:00		2003-10-09 00:00:00		2003-07-14 00:00:00		2003-10-09 00:00:00		2003-07-14 00:00:00		2003-07-18 00:00:00		2004-01-10 00:00:00		2004-01-12 00:00:00		2004-07-29 00:00:00		2004-07-29 00:00:00		2004-10-20 00:00:00		2005-01-31 00:00:00		2004-10-20 00:00:00		2005-01-31 00:00:00		2005-07-29 00:00:00		2005-07-29 00:00:00		2006-01-27 00:00:00		2006-01-30 00:00:00		2007-01-26 00:00:00		2007-01-26 00:00:00		2014-07-25 00:00:00		2015-01-28 00:00:00		2014-09-30 00:00:00		2014-08-21 00:00:00		2014-10-24 00:00:00		2009-02-02 00:00:00		2009-02-02 00:00:00		2010-10-18 00:00:00		2010-10-18 00:00:00		2010-10-29 00:00:00		2010-10-29 00:00:00		2010-11-01 00:00:00		2011-01-26 00:00:00		2011-01-27 00:00:00		2014-03-14 00:00:00		2015-01-21 00:00:00		2015-01-28 00:00:00		2014-09-23 00:00:00		2014-07-29 00:00:00		2014-09-16 00:00:00		2014-04-28 00:00:00		2020-07-31 00:00:00		2019-01-31 00:00:00		2020-10-05 00:00:00		2020-10-08 00:00:00		2020-10-26 00:00:00		2020-10-30 00:00:00		2018-01-26 00:00:00		2019-01-31 00:00:00		2020-10-12 00:00:00		2018-01-24 00:00:00		2020-10-23 00:00:00		2020-10-05 00:00:00		2020-01-31 00:00:00		2020-10-19 00:00:00		2020-10-30 00:00:00		2020-10-30 00:00:00		2020-10-30 00:00:00		2020-10-30 00:00:00		2020-10-30 00:00:00		2020-10-05 00:00:00		2020-11-04 00:00:00		2020-10-16 00:00:00		2020-10-21 00:00:00		2021-01-29 00:00:00		2021-07-28 00:00:00		2018-09-14 00:00:00		2020-10-20 00:00:00		2020-10-30 00:00:00		2020-01-31 00:00:00		2020-10-30 00:00:00		2020-10-30 00:00:00		2020-10-30 00:00:00		2020-10-30 00:00:00		2020-10-26 00:00:00		2020-10-23 00:00:00		2021-01-29 00:00:00		2020-07-31 00:00:00		2020-08-18 00:00:00		2022-01-25 00:00:00		2022-04-29 00:00:00		2021-07-29 00:00:00		2022-08-31 00:00:00		2022-09-06 00:00:00		2022-09-16 00:00:00		2022-09-26 00:00:00		2022-07-28 00:00:00		2022-07-28 00:00:00		0222-01-26 00:00:00		2922-07-29 00:00:00		2022-07-29 00:00:00		2022-09-19 00:00:00		2022-10-20 00:00:00		2022-11-07 00:00:00
stmnt_type		10005		10001		10005		10005		10001		10005		10001		10005		10005		10002		10001		10001		10005		10001		10002		10005		10001		10001		10005		10001		10001		10005		10005		10005		10001		10005		10001		10005		10001		10001		10005		10005		10005		10001		10001		10005		10001		10005		10001		10005		10001		10001		10001		10005		10001		10001		10005		10001		10005		10001		10001		10005		10001		10002		10001		10001		10005		10001		10001		10001		10005		10001		10001		10001		10002		10005		10001		10001		10001		10001		10001		10001		10002		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10005		10002		10002		10002		10002		10001		10001		10001		10005		10001		10001		10001		10005		10001		10001		10001		10001		10001		10002		10005		10005		10006		10001		10001		10001
stmnt_status		11001		11003		11001		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11003		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11003		11001		11003		11003		11001		11001		11003		11003		11003		11001		11003		11003		11003		11003		11003		11001		11001		11001		11003		11001		11003		11001		11003		11003		11003		11003		11001		11001		11001		11001		11001		11003		11003		11003
session_id		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2005		2005		2005		2005		2005		2013		2013		2013		2013		2013		2007		2007		2009		2009		2009		2009		2009		2009		2009		2013		2015		2013		2013		2013		2013		2013		2019		2019		2019		2019		2019		2019		2017		2017		2019		2017		2019		2019		2019		2019		2019		2019		2019		2019		2019		2019		2019		2019		2019		2021		2021		2017		2019		2019		2019		2019		2019		2019		2019		2019		2019		2019		2019		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		ERUTH		*		YBONILLA		BINTHAVO		*		LTHIBAUL		*		KLARRY		PROBERTS		PROBERTS		*		*		KLARRY		*		*		BSMITH		COMPLETED		*		DHORRELL		COMPLETED		COMPLETED		DHORRELL		GGILMORE		GGILMORE		COMPLETED		CFLAGG		COMPLETED		DHORRELL		GKURIMOT		COMPLETED		LLEONG		DHORRELL		DHORRELL		*		*		GGILMORE		*		JMARTIN		JINGRAM		JINGRAM		WBROWN		WBROWN		WBROWN		JINGRAM		JINGRAM		PBANFORD		MPACHECO		WBROWN		MPACHECO		CREYNOLDS		JINGRAM		JINGRAM		WBROWN		WBROWN		JINGRAM		WBROWN		JINGRAM		WBROWN		WBROWN		GTAYLOR		GTAYLOR		RGEREMIA		CAFILER		RGEREMIA		CAFILER		DMCCASTL		GTAYLOR		CAFILER		DMCCASTL		CAFILER		RGEREMIA		GTAYLOR		CAFILER		RGEREMIA		RGEREMIA		RGEREMIA		RGEREMIA		RGEREMIA		CAFILER		RGEREMIA		CAFILER		CAFILER		GTAYLOR		GTAYLOR		CAFILER		CAFILER		CAFILER		GTAYLOR		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		RGEREMIA		GTAYLOR		GTAYLOR		CAFILER		GTAYLOR		CAFILER		GTAYLOR		CAFILER		CAFILER		CAFILER		CAFILER		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		CAFILER		CAFILER		CAFILER
special_audit		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11003		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11003		11001		11003		11003		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11003		11001		11003		11003		11001		11001		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11001		11001		11003		11001		11003		11001		11003		11003		11003		11003		11001		11001		11001		11001		11001		11003		11003		11003
rpt_start		2001-01-01 00:00:00		2001-07-01 00:00:00		2001-07-01 00:00:00		None		2002-02-20 00:00:00		2002-01-01 00:00:00		2002-10-23 00:00:00		None		None		None		2002-01-01 00:00:00		2002-10-22 00:00:00		None		2002-11-01 00:00:00		2002-11-01 00:00:00		None		2002-07-01 00:00:00		2002-10-29 00:00:00		2002-07-01 00:00:00		2003-07-01 00:00:00		2003-01-01 00:00:00		2003-07-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2003-10-01 00:00:00		2003-10-01 00:00:00		2004-01-01 00:00:00		2004-01-01 00:00:00		2004-10-20 00:00:00		2004-07-01 00:00:00		None		2004-07-01 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2005-07-01 00:00:00		2005-07-01 00:00:00		2006-01-01 00:00:00		2006-01-01 00:00:00		2014-01-01 00:00:00		2014-07-01 00:00:00		2014-09-30 00:00:00		2014-08-21 00:00:00		2014-10-24 00:00:00		2008-01-01 00:00:00		2008-01-01 00:00:00		2010-10-18 00:00:00		None		2010-10-29 00:00:00		2010-10-29 00:00:00		2010-11-01 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2014-03-14 00:00:00		2015-01-21 00:00:00		2014-07-01 00:00:00		2014-09-23 00:00:00		2014-01-01 00:00:00		2014-09-16 00:00:00		2014-04-28 00:00:00		2020-01-01 00:00:00		2018-01-01 00:00:00		2020-10-05 00:00:00		2020-10-08 00:00:00		2020-10-26 00:00:00		2020-10-30 00:00:00		2017-01-01 00:00:00		2018-01-01 00:00:00		2020-10-12 00:00:00		2017-01-01 00:00:00		2020-10-23 00:00:00		2020-10-05 00:00:00		2019-01-01 00:00:00		2020-10-19 00:00:00		2020-10-26 00:00:00		2020-10-26 00:00:00		2020-10-26 00:00:00		2020-10-26 00:00:00		2020-10-26 00:00:00		2020-10-05 00:00:00		2020-11-04 00:00:00		2020-10-16 00:00:00		2020-10-21 00:00:00		2020-07-01 00:00:00		2021-01-01 00:00:00		2018-09-14 00:00:00		2020-10-20 00:00:00		2020-10-30 00:00:00		2019-01-01 00:00:00		2020-10-30 00:00:00		2020-10-30 00:00:00		2020-10-30 00:00:00		2020-10-30 00:00:00		2020-10-26 00:00:00		2020-10-23 00:00:00		2020-07-01 00:00:00		2020-01-01 00:00:00		2020-08-18 00:00:00		2021-07-01 00:00:00		2022-04-29 00:00:00		2021-01-01 00:00:00		2022-08-30 00:00:00		2022-09-06 00:00:00		2022-09-16 00:00:00		2022-09-26 00:00:00		2022-01-01 00:00:00		2021-07-01 00:00:00		2021-07-01 00:00:00		2022-01-01 00:00:00		2021-07-01 00:00:00		2022-09-19 00:00:00		2022-10-20 00:00:00		2022-11-07 00:00:00
rpt_end		2001-06-30 00:00:00		2001-12-31 00:00:00		2001-12-31 00:00:00		None		2002-02-20 00:00:00		2002-06-30 00:00:00		2002-10-23 00:00:00		None		None		None		2002-06-30 00:00:00		2002-10-22 00:00:00		None		2002-11-01 00:00:00		2002-11-01 00:00:00		None		2002-12-31 00:00:00		2002-10-29 00:00:00		2002-12-31 00:00:00		2003-09-30 00:00:00		2003-06-30 00:00:00		2003-09-30 00:00:00		2003-06-30 00:00:00		2003-06-30 00:00:00		2003-12-31 00:00:00		2003-12-31 00:00:00		2004-06-30 00:00:00		2004-06-30 00:00:00		2004-10-20 00:00:00		2004-12-31 00:00:00		None		2004-12-31 00:00:00		2005-06-30 00:00:00		2005-06-30 00:00:00		2005-12-31 00:00:00		2005-12-31 00:00:00		2006-12-31 00:00:00		2006-12-31 00:00:00		2014-06-30 00:00:00		2014-12-31 00:00:00		2014-09-30 00:00:00		2014-08-21 00:00:00		2014-10-24 00:00:00		2008-12-31 00:00:00		2008-12-31 00:00:00		2010-10-18 00:00:00		None		2010-10-29 00:00:00		2010-10-29 00:00:00		2010-11-01 00:00:00		2010-12-31 00:00:00		2010-12-31 00:00:00		2014-03-14 00:00:00		2015-01-21 00:00:00		2014-12-31 00:00:00		2014-09-23 00:00:00		2014-06-30 00:00:00		2014-09-16 00:00:00		2014-04-28 00:00:00		2020-06-30 00:00:00		2018-12-31 00:00:00		2020-10-05 00:00:00		2020-10-08 00:00:00		2020-10-26 00:00:00		2020-10-30 00:00:00		2017-12-31 00:00:00		2018-12-31 00:00:00		2020-10-12 00:00:00		2017-12-31 00:00:00		2020-10-23 00:00:00		2020-10-05 00:00:00		2019-12-31 00:00:00		2020-10-19 00:00:00		2020-10-26 00:00:00		2020-10-26 00:00:00		2020-10-26 00:00:00		2020-10-26 00:00:00		2020-10-26 00:00:00		2020-10-05 00:00:00		2020-11-04 00:00:00		2020-10-16 00:00:00		2020-10-21 00:00:00		2020-12-31 00:00:00		2021-06-30 00:00:00		2018-09-14 00:00:00		2020-10-20 00:00:00		2020-10-30 00:00:00		2019-12-31 00:00:00		2020-10-30 00:00:00		2020-10-30 00:00:00		2020-10-30 00:00:00		2020-10-30 00:00:00		2020-10-26 00:00:00		2020-10-23 00:00:00		2020-12-31 00:00:00		2020-06-30 00:00:00		2020-08-18 00:00:00		2021-12-31 00:00:00		2022-04-29 00:00:00		2021-06-30 00:00:00		2022-08-30 00:00:00		2022-09-06 00:00:00		2022-09-16 00:00:00		2022-09-26 00:00:00		2022-06-30 00:00:00		2021-12-31 00:00:00		2021-12-31 00:00:00		2022-06-30 00:00:00		2021-12-31 00:00:00		2022-09-19 00:00:00		2022-10-20 00:00:00		2022-11-07 00:00:00
rpt_date		None		2002-01-10 00:00:00		None		None		2002-02-20 00:00:00		None		2002-10-23 00:00:00		None		None		None		2002-07-23 00:00:00		2002-10-22 00:00:00		None		2002-11-01 00:00:00		2002-11-01 00:00:00		None		2003-01-22 00:00:00		2002-10-29 00:00:00		None		2003-10-07 00:00:00		2003-07-08 00:00:00		None		None		None		2004-01-08 00:00:00		None		2004-07-27 00:00:00		None		2004-10-20 00:00:00		2005-01-25 00:00:00		None		None		None		2005-07-28 00:00:00		2006-01-13 00:00:00		None		2007-01-24 00:00:00		None		2014-07-09 00:00:00		None		2014-09-30 00:00:00		2014-08-21 00:00:00		2014-10-24 00:00:00		None		2009-01-28 00:00:00		2010-10-18 00:00:00		None		2010-10-29 00:00:00		None		2010-11-01 00:00:00		2011-01-20 00:00:00		None		2014-03-14 00:00:00		2015-01-21 00:00:00		2015-01-21 00:00:00		2014-09-23 00:00:00		None		2014-09-16 00:00:00		2014-04-28 00:00:00		2020-07-31 00:00:00		None		2020-10-05 00:00:00		2020-10-08 00:00:00		2020-10-26 00:00:00		2020-10-30 00:00:00		None		2019-01-23 00:00:00		2020-10-12 00:00:00		2018-01-17 00:00:00		2020-10-23 00:00:00		2020-10-05 00:00:00		2020-01-30 00:00:00		2020-10-19 00:00:00		2020-10-26 00:00:00		2020-10-26 00:00:00		2020-10-26 00:00:00		2020-10-26 00:00:00		2020-10-26 00:00:00		2020-10-05 00:00:00		2020-11-04 00:00:00		2020-10-16 00:00:00		2020-10-21 00:00:00		None		2021-07-23 00:00:00		2018-09-14 00:00:00		2020-10-20 00:00:00		2020-10-30 00:00:00		None		2020-10-30 00:00:00		2020-10-30 00:00:00		2020-10-30 00:00:00		2020-10-30 00:00:00		2020-10-26 00:00:00		2020-10-23 00:00:00		2021-01-29 00:00:00		None		2020-08-18 00:00:00		2022-01-13 00:00:00		2022-04-29 00:00:00		None		2022-08-30 00:00:00		2022-09-06 00:00:00		2022-09-16 00:00:00		2022-09-26 00:00:00		2022-07-27 00:00:00		2022-07-25 00:00:00		None		None		None		2022-09-19 00:00:00		2022-10-20 00:00:00		2022-11-07 00:00:00
filing_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22001		None		None		22001		22001		None		None		None		22001		None		22001		None		22001		22001		None		None		None		22001		22001		None		22001		None		22001		None		22001		22001		22001		None		22001		22001		None		22001		None		22001		22001		None		22001		22001		22001		22001		None		22001		22001		22001		None		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		None		None		None		22001		22001		22001

Table: filer_to_filer_type

filer_id		1239171
filer_type		10
active		Y
race		0
session_id		2001
category		0
category_type		40502
sub_category		0
effect_dt		2001-07-31 00:00:00
sub_category_type		0
election_type		0
sub_category_a		None
nyq_dt		None
party_cd		0
county_cd		18018
district_cd		0

Table: filer_xref

filer_id		1239171
xref_id		1239171
effect_dt		2001-10-18 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1239171		1239171		1239171
filer_id		1239171		1239171		1239171
filer_type		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE
status		ACTIVE		ACTIVE		ACTIVE
effect_dt		2001-07-31 00:00:00		2001-07-31 00:00:00		2001-07-31 00:00:00
naml		KLEIN II, ROBERT N. AND AFFILIATED ENTITY KLEIN FINANCIAL CORPORATION		KLEIN II, ROBERT N.		KLEIN II, ROBERT N. & CONNIE R. KLEIN
namf		None		None		None
namt		None		None		None
nams		None		None		None
adr1		None		None		None
adr2		None		None		None
city		FRESNO		FRESNO		FRESNO
st		CA		CA		CA
zip4		93721		93721		93721
phon		5594417901		5594417901		5594417901
fax		None		None		None
email		None		None		None

Table: filers

filer_id		1239171

Table: received_filings

filer_id		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171		1239171
filing_file_name		805588_0.cal		821826_0.cal		852927_0.cal		876540_0.cal		877092_0.cal		882223_0.cal		886804_0.cal		876540_1.cal		907612_0.cal		941427_0.cal		962701_0.cal		979434_0.cal		1049955_0.cal		1079941_0.cal		1117279_0.cal		1145469_0.cal		1397211_0.cal		1232261_0.cal		1540513_0.cal		1528715_0.cal		1842758_0.cal		1829139_0.cal		1539025_0.cal		1566153_0.cal		1885660_0.cal		1879522_0.cal		1889916_0.cal		1887706_0.cal		1905213_0.cal		1879522_1.cal		2492744_0.cal		2292005_0.cal		2509996_0.cal		2523358_0.cal		2513774_0.cal		2522263_0.cal		2509994_0.cal		2533020_0.cal		2527436_0.cal		2527441_0.cal		2527443_0.cal		2527447_0.cal		2527449_0.cal		2528402_0.cal		2738010_0.cal		2523350_0.cal		2674722_0.cal		2522305_0.cal		2717339_0.cal		2723854_0.cal
received_date		2002-01-10 00:00:00		2002-02-21 00:00:00		2002-07-29 00:00:00		2002-10-22 00:00:00		2002-10-23 00:00:00		2002-10-29 00:00:00		2002-11-01 00:00:00		2002-11-01 00:00:00		2003-01-28 00:00:00		2003-07-14 00:00:00		2003-10-09 00:00:00		2004-01-10 00:00:00		2004-10-20 00:00:00		2005-01-31 00:00:00		2005-07-29 00:00:00		2006-01-27 00:00:00		2009-02-02 00:00:00		2007-01-26 00:00:00		2010-11-01 00:00:00		2010-10-18 00:00:00		2014-04-28 00:00:00		2014-03-14 00:00:00		2010-10-29 00:00:00		2011-01-26 00:00:00		2014-09-16 00:00:00		2014-08-21 00:00:00		2014-09-30 00:00:00		2014-09-23 00:00:00		2014-10-24 00:00:00		2015-01-21 00:00:00		2020-08-18 00:00:00		2018-09-14 00:00:00		2020-10-05 00:00:00		2020-10-26 00:00:00		2020-10-12 00:00:00		2020-10-23 00:00:00		2020-10-05 00:00:00		2020-11-04 00:00:00		2020-10-30 00:00:00		2020-10-30 00:00:00		2020-10-30 00:00:00		2020-10-30 00:00:00		2020-10-30 00:00:00		2020-10-30 00:00:00		2022-10-20 00:00:00		2020-10-26 00:00:00		2022-04-29 00:00:00		2020-10-23 00:00:00		2022-09-06 00:00:00		2022-09-26 00:00:00
filing_directory		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		805588		821826		852927		876540		877092		882223		886804		876540		907612		941427		962701		979434		1049955		1079941		1117279		1145469		1397211		1232261		1540513		1528715		1842758		1829139		1539025		1566153		1885660		1879522		1889916		1887706		1905213		1879522		2492744		2292005		2509996		2523358		2513774		2522263		2509994		2533020		2527436		2527441		2527443		2527447		2527449		2528402		2738010		2523350		2674722		2522305		2717339		2723854
form_id		F461		F497		F461		F497		F497		F497		F497		F497		F461		F461		F461		F461		F497		F461		F461		F461		F461		F461		F497		F497		F497		F497		F497		F461		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497
receive_comment		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted