Home

Filer ID: 1374093

Table: cvr_campaign_disclosure

filing_id		1931540		2029921		2031071		2031316		2031527		2036199		2039660		2036271		2036847		2041539		2040418		2041264		2034910		2039194		2033731		2021539		2036847		2021293		2020851		2022557		2025526		2025239		2021763		2022321		2013064		2000252		1982721		1982721		2049089		2048328		2046430		2045542		2042867		2043196		2064032		2047000		2087368		2095509		2081580		2083417		2087016		2070773		2070538		2069156		2073895		2071693		2072592		2074338		2077573		2078323		2078486		2079975		2070435		2068085		2068420		2072592		2073155		2071799		2076066		2078681		2078486		2079452		2053581		2050160		2050391		2067241		2050139		2070548		2053591		2087764		2088878		2090444		2090439		2176461		2130827		2098115		2105081		2105843		2098374		2099380		2102980		2176461		2237903		2233147		2211587
amend_id		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		1		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		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		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		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F450		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F460		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F460		F497		F460		F460		F497		F497		F497		F497		F497		F497		F460		F460		F497		F497		F497		F460		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		F497		F497		F497		F497		F497		F497		F497		F460		F460		F460		F497		F497		F497		F497		F497		F460		F460		F497		F460
filer_id		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093
entity_cd		RCP		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		RCP		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL
filer_naml		OBERNOLTE FOR ASSEMBLY 2016; JAY		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		OBERNOLTE FOR ASSEMBLY 2016; JAY		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016		Jay Obernolte for Assembly 2016
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		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		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		None		None		None		None		None		None		None		None
report_num		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		000		001		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		001		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		001		000		000		000
rpt_date		2015-01-28 00:00:00		2016-04-19 00:00:00		2016-04-21 00:00:00		2016-04-22 00:00:00		2016-04-22 00:00:00		2016-04-29 00:00:00		2016-05-04 00:00:00		2016-04-29 00:00:00		2016-05-02 00:00:00		2016-05-11 00:00:00		2016-05-06 00:00:00		2016-05-10 00:00:00		2016-04-25 00:00:00		2016-05-03 00:00:00		2016-04-27 00:00:00		2016-03-18 00:00:00		2016-04-29 00:00:00		2016-03-17 00:00:00		2016-03-15 00:00:00		2016-03-22 00:00:00		2016-04-01 00:00:00		2016-03-31 00:00:00		2016-03-21 00:00:00		2016-03-22 00:00:00		2016-01-26 00:00:00		2015-11-30 00:00:00		2015-09-24 00:00:00		2015-07-31 00:00:00		2016-06-02 00:00:00		2016-06-01 00:00:00		2016-05-26 00:00:00		2016-05-24 00:00:00		2016-05-13 00:00:00		2016-05-16 00:00:00		2016-08-01 00:00:00		2016-05-24 00:00:00		2016-10-11 00:00:00		2016-10-25 00:00:00		2016-09-26 00:00:00		2016-09-29 00:00:00		2016-10-10 00:00:00		2016-08-22 00:00:00		2016-08-22 00:00:00		2016-08-16 00:00:00		2016-09-02 00:00:00		2016-08-25 00:00:00		2016-09-06 00:00:00		2016-09-06 00:00:00		2016-09-14 00:00:00		2016-09-16 00:00:00		2016-09-16 00:00:00		2016-09-22 00:00:00		2016-08-19 00:00:00		2016-08-12 00:00:00		2016-08-15 00:00:00		2016-08-29 00:00:00		2016-08-31 00:00:00		2016-08-25 00:00:00		2016-09-12 00:00:00		2016-09-16 00:00:00		2016-09-16 00:00:00		2016-09-20 00:00:00		2016-07-06 00:00:00		2016-06-07 00:00:00		2016-06-07 00:00:00		2016-08-10 00:00:00		2016-06-07 00:00:00		2016-08-22 00:00:00		2016-07-06 00:00:00		2016-10-11 00:00:00		2016-10-14 00:00:00		2016-10-17 00:00:00		2016-10-17 00:00:00		2017-07-25 00:00:00		2017-01-25 00:00:00		2016-10-23 00:00:00		2016-11-04 00:00:00		2016-11-07 00:00:00		2016-10-27 00:00:00		2016-10-28 00:00:00		2016-11-01 00:00:00		2017-08-24 00:00:00		2018-04-24 00:00:00		2018-04-19 00:00:00		2018-01-31 00:00:00
stmt_type		SA		None		None		None		None		None		None		None		None		None		None		None		PE		None		None		None		None		None		None		None		None		None		None		None		SA		None		SA		SA		None		None		None		None		None		None		SA		PE		None		None		None		PE		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		SA		SA		PE		None		None		None		None		None		SA		TS		None		SA
late_rptno		None		04.19.16.1		04.21.16.1		04.21.16.2		04.22.16.1		04.29.16.1		05.06.16.1		04.28.16.2		04.29.16.2		05.10.16.1		05.05.16.1		05.09.16.1		None		05.03.16.1		04.27.16.1		03.18.16.1		04.29.16.2		03.17.16.1		03.15.16.1		03.22.16.1		04.01.16.1		03.31.16.1		03.21.16.1		03.21.16.2		None		2015-1		None		None		06.02.16.1		05.31.16.1		05.25.16.1		05.23.16.1		05.13.16.1		05.16.16.1		None		None		10.11.16.1		10.25.16.1		09.26.16.1		None		10.08.16.2		08.22.16.3		08.22.16.1		08.16.16.3		09.02.16.1		08.24.16.1		08.29.161a		09.06.16.1		09.14.16.1		09.16.16.1		09/16/2016		09.21.16.1		08.19.16.2		08.12.16.1		08.15.16.1		08.29.16.1		08.31.16.1		08.25.16.1		09.12.16.1		09.16.16.3		09/16/2016		09.20.16.1		07.06.16.1		06.07.16.2		06.07.16.3		08.10.16.1		06.06.16.1		08.22.16.2		07.06.16.2		10.11.16.2		10.13.16.1		10.17.16.2		10.17.16.1		None		None		None		11.04.16.1		11.07.16.1		10.26.16.1		10.28.16.1		11.01.16.1		None		None		180418.1		None
from_date		2014-01-01 00:00:00		None		None		None		None		None		None		None		None		None		None		None		2016-01-01 00:00:00		None		None		None		None		None		None		None		None		None		None		None		2015-07-01 00:00:00		None		2015-01-01 00:00:00		2015-01-01 00:00:00		None		None		None		None		None		None		2016-05-22 00:00:00		2016-04-24 00:00:00		None		None		None		2016-07-01 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		2017-01-01 00:00:00		2016-10-23 00:00:00		2016-09-25 00:00:00		None		None		None		None		None		2017-01-01 00:00:00		2018-01-01 00:00:00		None		2017-07-01 00:00:00
thru_date		2014-12-31 00:00:00		None		None		None		None		None		None		None		None		None		None		None		2016-04-23 00:00:00		None		None		None		None		None		None		None		None		None		None		None		2015-12-31 00:00:00		None		2015-06-30 00:00:00		2015-06-30 00:00:00		None		None		None		None		None		None		2016-06-30 00:00:00		2016-05-21 00:00:00		None		None		None		2016-09-24 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		2017-06-30 00:00:00		2016-12-31 00:00:00		2016-10-22 00:00:00		None		None		None		None		None		2017-06-30 00:00:00		2018-04-21 00:00:00		None		2017-12-31 00:00:00
elect_date		None		None		None		None		None		None		None		None		None		None		None		None		2016-06-07 00:00:00		None		None		None		None		None		None		None		None		None		None		None		2016-06-07 00:00:00		None		2016-06-07 00:00:00		2016-06-07 00:00:00		None		None		None		None		None		None		2016-06-07 00:00:00		2016-06-07 00:00:00		None		None		None		2016-11-08 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		2016-11-08 00:00:00		2016-11-08 00:00:00		2016-11-08 00:00:00		None		None		None		None		None		2016-11-08 00:00:00		2016-11-08 00:00:00		None		2016-11-08 00:00:00
filer_city		SACRAMENTO		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		SACRAMENTO		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento
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		CA		CA		CA		CA		CA		CA		CA		CA
filer_zip4		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814
filer_phon		9164766926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		9164766926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		9164766926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926
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		None		None		None		None		None		None		None		None
file_email		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]
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		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		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		None		None		None		None		None		None		None		None
tres_naml		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		None		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch		Burch
tres_namf		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		None		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan		Bryan
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
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
tres_city		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		None		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento
tres_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		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
tres_zip4		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		None		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814
tres_phon		9164766926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		9164766926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		None		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926		916-476-6926
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		None		None		None		None		None		None		None		None
tres_email		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		P		None		None		None		None		None		None		None		None		None		None		None		C		None		None		None		None		None		None		None		None		None		None		None		C		None		C		C		None		None		None		None		None		None		C		C		None		None		None		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		C		C		C		None		None		None		None		None		C		C		None		C
control_yn		None		None		None		None		None		None		None		None		None		None		None		None		Y		None		None		None		None		None		None		None		None		None		None		None		Y		None		Y		Y		None		None		None		None		None		None		Y		Y		None		None		None		Y		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Y		Y		Y		None		None		None		None		None		Y		Y		None		Y
sponsor_yn		None		None		None		None		None		None		None		None		None		None		None		None		N		None		None		None		None		None		None		None		None		None		None		None		N		None		N		N		None		None		None		None		None		None		N		N		None		None		None		N		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		N		N		N		None		None		None		None		None		N		N		None		N
primfrm_yn		None		None		None		None		None		None		None		None		None		None		None		None		N		None		None		None		None		None		None		None		None		None		None		None		N		None		None		N		None		None		None		None		None		None		N		N		None		None		None		N		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		N		N		N		None		None		None		None		None		N		N		None		N
brdbase_yn		None		None		None		None		None		None		None		None		None		None		None		None		N		None		None		None		None		None		None		None		None		None		None		None		N		None		None		N		None		None		None		None		None		None		N		N		None		None		None		N		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		N		N		N		None		None		None		None		None		N		N		None		N
amendexp_1		None		None		None		None		None		None		None		None		To void contributions received		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		To add additional signature.		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		To correct donor contribution information.		None		None		None		None		None		None		None		None		None		None		None		None		None		To remove contribution disclosed on prior report.		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		To add additional signature.		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		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		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		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		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		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		None		None		None		None		None		None		None		None
emplbus_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		None		None		None		None		None		None		None		None
bus_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
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_inter		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		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		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		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		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		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		None		None		None		None		None		None		None		None
cand_naml		None		None		None		None		None		None		None		None		None		None		None		None		Obernolte		None		None		None		None		None		None		None		None		None		None		None		Obernolte		None		Obernolte		Obernolte		None		None		None		None		None		None		Obernolte		Obernolte		None		None		None		Obernolte		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Obernolte		Obernolte		Obernolte		None		None		None		None		None		Obernolte		Obernolte		None		Obernolte
cand_namf		None		None		None		None		None		None		None		None		None		None		None		None		Jay		None		None		None		None		None		None		None		None		None		None		None		Jay		None		Jay		Jay		None		None		None		None		None		None		Jay		Jay		None		None		None		Jay		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Jay		Jay		Jay		None		None		None		None		None		Jay		Jay		None		Jay
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
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
cand_city		None		None		None		None		None		None		None		None		None		None		None		None		Big Bear Lake		None		None		None		None		None		None		None		None		None		None		None		Big Bear Lake		None		Big Bear Lake		Big Bear Lake		None		None		None		None		None		None		Big Bear Lake		Big Bear Lake		None		None		None		Big Bear Lake		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Big Bear Lake		Big Bear Lake		Big Bear Lake		None		None		None		None		None		Big Bear Lake		Big Bear Lake		None		Big Bear Lake
cand_st		None		None		None		None		None		None		None		None		None		None		None		None		CA		None		None		None		None		None		None		None		None		None		None		None		CA		None		CA		CA		None		None		None		None		None		None		CA		CA		None		None		None		CA		None		None		None		None		None		None		None		None		None		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		CA		CA		None		None		None		None		None		CA		CA		None		CA
cand_zip4		None		None		None		None		None		None		None		None		None		None		None		None		92315		None		None		None		None		None		None		None		None		None		None		None		92315		None		92315		92315		None		None		None		None		None		None		92315		92315		None		None		None		92315		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		92315		92315		92315		None		None		None		None		None		92315		92315		None		92315
cand_phon		None		None		None		None		None		None		None		None		None		None		None		None		909-866-0501		None		None		None		None		None		None		None		None		None		None		None		909-866-0501		None		9098660501		909-866-0501		None		None		None		None		None		None		909-866-0501		909-866-0501		None		None		None		909-866-0501		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		909-866-0501		909-866-0501		909-866-0501		None		None		None		None		None		909-866-0501		909-866-0501		None		909-866-0501
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		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		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
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
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
office_cd		None		None		None		None		None		None		None		None		None		None		None		None		ASM		None		None		None		None		None		None		None		None		None		None		None		ASM		None		ASM		ASM		None		None		None		None		None		None		ASM		ASM		None		None		None		ASM		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		ASM		ASM		ASM		None		None		None		None		None		ASM		ASM		None		ASM
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
juris_cd		None		None		None		None		None		None		None		None		None		None		None		None		ASM		None		None		None		None		None		None		None		None		None		None		None		ASM		None		ASM		ASM		None		None		None		None		None		None		ASM		ASM		None		None		None		ASM		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		ASM		ASM		ASM		None		None		None		None		None		ASM		ASM		None		ASM
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
dist_no		None		None		None		None		None		None		None		None		None		None		None		None		33		None		None		None		None		None		None		None		None		None		None		None		33		None		33		33		None		None		None		None		None		None		33		33		None		None		None		33		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		33		33		33		None		None		None		None		None		33		33		None		33
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
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
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		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		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		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		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		None		None		None		None		None		None		None		None

Table: cvr_so

filing_id		1938758
amend_id		0
rec_type		CVR
form_type		F410
filer_id		1374093
entity_cd		RCP
filer_naml		OBERNOLTE FOR ASSEMBLY 2016; JAY
filer_namf		None
filer_namt		None
filer_nams		None
report_num		000
rpt_date		2015-02-06 00:00:00
qual_cb		None
qualfy_dt		2015-01-28 00:00:00
term_date		None
city		SACRAMENTO
st		CA
zip4		95814
phone		9164766926
county_res		None
county_act		None
mail_city		None
mail_st		None
mail_zip4		None
cmte_fax		None
cmte_email		[email protected]
tres_naml		Burch
tres_namf		Bryan
tres_namt		None
tres_nams		None
tres_city		Sacramento
tres_st		CA
tres_zip4		95814
tres_phon		9164766926
actvty_lvl		None
com82013yn		None
com82013nm		None
com82013id		None
control_cb		X
bank_nam		US Bank
bank_adr1		936 State Street
bank_adr2		None
bank_city		Santa Barbara
bank_st		CA
bank_zip4		93101
bank_phon		8059572245
acct_opendt		None
surplusdsp		None
primfc_cb		None
genpurp_cb		None
gpc_descr		None
sponsor_cb		None
brdbase_cb		None
smcont_qualdt		None

Table: filer_address

filer_id		1374093		1374093
adrid		2440088		2347596
effect_dt		2017-08-25 00:00:00		2014-12-16 00:00:00
add_type		7051		7051
session_id		2017		2013

Table: filer_filings

filer_id		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093
filing_id		1982721		1953101		1938758		1941435		1918489		1931540		1984838		2000252		1984838		2213131		2178081		2176461		2021539		2020851		2021293		2022557		2025526		2014511		1982721		2014511		2022321		2013064		2045542		2036847		2046430		2034910		2039194		2025239		2031071		2033731		2021763		2029921		2036847		2036271		2036199		2040418		2031316		2038147		2031527		2039660		2041264		2043196		2042867		2041539		2067241		2050139		2066139		2053591		2049089		2048328		2050524		2050160		2047000		2064032		2068420		2079975		2050391		2068085		2072592		2073155		2074338		2078681		2078486		2079452		2072592		2073895		2070538		2077573		2070773		2071693		2053581		2078486		2083417		2081580		2087764		2070435		2070548		2076066		2087016		2069156		2087368		2102980		2088878		2090444		2095509		2089824		2098115		2090439		2078323		2098374		2071799		2099380		2105843		2105081		2108267		2130827		2138481		2176461		2178081		2233147		2239533		2211587		2238792		2202103		2182474		2237903
period_id		221		None		221		None		None		217		None		224		None		None		None		229		225		225		225		225		226		None		221		None		225		223		226		226		226		225		226		225		226		226		225		226		226		226		226		226		226		None		226		226		226		226		226		226		227		226		None		227		226		226		None		226		226		226		227		227		226		227		227		227		227		227		227		227		227		227		227		227		227		227		227		227		227		227		228		227		227		227		228		227		228		228		228		228		228		None		227		228		227		228		227		228		228		228		None		228		None		229		None		234		None		231		None		None		None		233
form_id		F460		F410		F410		F450		F410		F450		F460		F497		F460		F460		F460		F460		F497		F497		F497		F497		F497		F460		F460		F460		F497		F460		F497		F497		F497		F460		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F460		F497		F497		F497		F497		F497		F497		F497		F497		F460		F497		F497		F497		F460		F497		F460		F460		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F460		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F460		F460		F497		F497		F497		F497		F497		F497		F497		F460		F460		F460		F460		F460		F497		F460		F460		F410		F666		F410		F460
filing_sequence		0		0		0		0		0		0		1		0		0		0		1		1		0		0		0		0		0		0		1		1		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		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		0		0		0
filing_date		2015-07-31 00:00:00		2015-03-06 00:00:00		2015-02-06 00:00:00		2015-02-02 00:00:00		2014-12-16 00:00:00		2015-01-28 00:00:00		2015-10-02 00:00:00		2015-11-30 00:00:00		2015-07-31 00:00:00		2018-01-31 00:00:00		2017-08-25 00:00:00		2017-08-24 00:00:00		2016-03-18 00:00:00		2016-03-15 00:00:00		2016-03-17 00:00:00		2016-03-22 00:00:00		2016-04-01 00:00:00		2016-02-01 00:00:00		2015-09-24 00:00:00		2016-02-17 00:00:00		2016-03-22 00:00:00		2016-02-01 00:00:00		2016-05-24 00:00:00		2016-05-02 00:00:00		2016-05-26 00:00:00		2016-04-28 00:00:00		2016-05-03 00:00:00		2016-03-31 00:00:00		2016-04-21 00:00:00		2016-04-27 00:00:00		2016-03-21 00:00:00		2016-04-19 00:00:00		2016-04-29 00:00:00		2016-04-29 00:00:00		2016-04-29 00:00:00		2016-05-06 00:00:00		2016-04-22 00:00:00		2016-04-28 00:00:00		2016-04-22 00:00:00		2016-05-04 00:00:00		2016-05-10 00:00:00		2016-05-16 00:00:00		2016-05-13 00:00:00		2016-05-11 00:00:00		2016-08-10 00:00:00		2016-06-07 00:00:00		2016-08-01 00:00:00		2016-07-06 00:00:00		2016-06-02 00:00:00		2016-06-01 00:00:00		2016-05-26 00:00:00		2016-06-07 00:00:00		2016-05-26 00:00:00		2016-08-01 00:00:00		2016-08-15 00:00:00		2016-09-22 00:00:00		2016-06-07 00:00:00		2016-08-12 00:00:00		2016-08-29 00:00:00		2016-08-31 00:00:00		2016-09-06 00:00:00		2016-09-16 00:00:00		2016-09-16 00:00:00		2016-09-20 00:00:00		2016-09-06 00:00:00		2016-09-02 00:00:00		2016-08-22 00:00:00		2016-09-14 00:00:00		2016-08-22 00:00:00		2016-08-25 00:00:00		2016-07-06 00:00:00		2016-09-16 00:00:00		2016-09-29 00:00:00		2016-09-26 00:00:00		2016-10-11 00:00:00		2016-08-19 00:00:00		2016-08-22 00:00:00		2016-09-12 00:00:00		2016-10-10 00:00:00		2016-08-16 00:00:00		2016-10-11 00:00:00		2016-11-01 00:00:00		2016-10-14 00:00:00		2016-10-17 00:00:00		2016-10-25 00:00:00		2016-09-29 00:00:00		2016-10-27 00:00:00		2016-10-17 00:00:00		2016-09-16 00:00:00		2016-10-27 00:00:00		2016-08-25 00:00:00		2016-10-28 00:00:00		2016-11-07 00:00:00		2016-11-04 00:00:00		2016-10-27 00:00:00		2017-01-31 00:00:00		2017-01-31 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00		2018-04-19 00:00:00		2018-04-26 00:00:00		2018-01-31 00:00:00		2018-04-26 00:00:00		2017-11-30 00:00:00		2017-08-25 00:00:00		2018-04-26 00:00:00
stmnt_type		10001		10006		10001		10005		10005		10001		10006		10001		10005		10005		10006		10002		10001		10001		10001		10001		10001		10005		10002		10006		10001		10001		10001		10002		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10002		10001		10002		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10005		10001		10005		10001		10005		10001		10003		10005		10006		10001
stmnt_status		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001
session_id		2015		2015		2015		2013		2013		2013		2015		2015		2015		2017		2017		2017		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2017		2017		2017		2017		2017		2015		2017		2017
user_id		MDIGRAZIA		TRAMON		TRAMON		SMCCONNAN		CPON		SMCCONNAN		MPACHECO		GKURIMOT		MDIGRAZIA		LBARTHOL		SMCCONNAN		CAFILER		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		MDIGRAZIA		MDIGRAZIA		MPACHECO		GKURIMOT		MDIGRAZIA		RGEREMIA		GKURIMOT		KBANH		SMCCONNAN		KBANH		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		KBANH		GKURIMOT		SMCCONNAN		GKURIMOT		KBANH		KBANH		KBANH		KBANH		KBANH		PDEO		KBANH		MPACHECO		RGEREMIA		KBANH		KBANH		SMCCONNAN		KBANH		SMCCONNAN		CAFILER		PDEO		PDEO		KBANH		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		RGEREMIA		PDEO		PDEO		PDEO		RGEREMIA		PDEO		GPEREZ		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		GPEREZ		GPEREZ		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		GPEREZ		CPON		CPON		CSAGABAEN		CSAGABAEN		CAFILER		HSTOVALL		LBARTHOL		PADAMS		SBROWN		TRAMON		HSTOVALL
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
fine_audit		11001		11003		11003		11001		11003		11001		11003		11001		11001		11003		11003		11003		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
rpt_start		2015-01-01 00:00:00		None		2015-02-06 00:00:00		2014-01-01 00:00:00		None		2014-01-01 00:00:00		2015-01-01 00:00:00		2015-11-30 00:00:00		2015-01-01 00:00:00		2017-07-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2016-03-18 00:00:00		2016-03-15 00:00:00		2016-03-17 00:00:00		2016-03-22 00:00:00		2016-04-01 00:00:00		2015-07-01 00:00:00		2015-01-01 00:00:00		2015-07-01 00:00:00		2016-03-22 00:00:00		2015-07-01 00:00:00		2016-05-24 00:00:00		2016-05-02 00:00:00		2016-05-26 00:00:00		2016-01-01 00:00:00		2016-05-03 00:00:00		2016-03-31 00:00:00		2016-04-21 00:00:00		2016-04-27 00:00:00		2016-03-21 00:00:00		2016-04-19 00:00:00		2016-04-29 00:00:00		2016-04-29 00:00:00		2016-04-29 00:00:00		2016-05-06 00:00:00		2016-04-22 00:00:00		2016-01-01 00:00:00		2016-04-22 00:00:00		2016-05-04 00:00:00		2016-05-10 00:00:00		2016-05-16 00:00:00		2016-05-13 00:00:00		2016-05-11 00:00:00		2016-08-10 00:00:00		2016-06-07 00:00:00		2016-05-22 00:00:00		2016-07-06 00:00:00		2016-06-02 00:00:00		2016-06-01 00:00:00		2016-04-24 00:00:00		2016-06-07 00:00:00		2016-04-24 00:00:00		2016-05-22 00:00:00		2016-08-15 00:00:00		2016-09-22 00:00:00		2016-06-07 00:00:00		2016-08-12 00:00:00		2016-08-29 00:00:00		2016-08-31 00:00:00		2016-09-06 00:00:00		2016-09-16 00:00:00		2016-09-16 00:00:00		2016-09-20 00:00:00		2016-09-06 00:00:00		2016-09-02 00:00:00		2016-08-22 00:00:00		2016-09-14 00:00:00		2016-08-22 00:00:00		2016-08-25 00:00:00		2016-07-06 00:00:00		2016-09-16 00:00:00		2016-07-01 00:00:00		2016-09-26 00:00:00		2016-10-11 00:00:00		2016-08-19 00:00:00		2016-08-22 00:00:00		2016-09-12 00:00:00		2016-10-10 00:00:00		2016-08-16 00:00:00		2016-10-11 00:00:00		2016-11-01 00:00:00		2016-10-14 00:00:00		2016-10-17 00:00:00		2016-10-25 00:00:00		2016-07-01 00:00:00		2016-09-25 00:00:00		2016-10-17 00:00:00		2016-09-16 00:00:00		2016-10-27 00:00:00		2016-08-25 00:00:00		2016-10-28 00:00:00		2016-11-07 00:00:00		2016-11-04 00:00:00		2016-09-25 00:00:00		2016-10-23 00:00:00		2016-10-23 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2018-04-19 00:00:00		2018-01-01 00:00:00		2017-07-01 00:00:00		None		2014-01-01 00:00:00		None		2018-01-01 00:00:00
rpt_end		2015-06-30 00:00:00		None		2015-02-06 00:00:00		2014-12-31 00:00:00		None		2014-12-31 00:00:00		2015-06-30 00:00:00		2015-11-30 00:00:00		2015-06-30 00:00:00		2017-12-31 00:00:00		2017-06-30 00:00:00		2017-06-30 00:00:00		2016-03-18 00:00:00		2016-03-15 00:00:00		2016-03-17 00:00:00		2016-03-22 00:00:00		2016-04-01 00:00:00		2015-12-31 00:00:00		2015-06-30 00:00:00		2015-12-31 00:00:00		2016-03-22 00:00:00		2015-12-31 00:00:00		2016-05-24 00:00:00		2016-05-02 00:00:00		2016-05-26 00:00:00		2016-04-23 00:00:00		2016-05-03 00:00:00		2016-03-31 00:00:00		2016-04-21 00:00:00		2016-04-27 00:00:00		2016-03-21 00:00:00		2016-04-19 00:00:00		2016-04-29 00:00:00		2016-04-29 00:00:00		2016-04-29 00:00:00		2016-05-06 00:00:00		2016-04-22 00:00:00		2016-04-23 00:00:00		2016-04-22 00:00:00		2016-05-04 00:00:00		2016-05-10 00:00:00		2016-05-16 00:00:00		2016-05-13 00:00:00		2016-05-11 00:00:00		2016-08-10 00:00:00		2016-06-07 00:00:00		2016-06-30 00:00:00		2016-07-06 00:00:00		2016-06-02 00:00:00		2016-06-01 00:00:00		2016-05-21 00:00:00		2016-06-07 00:00:00		2016-05-21 00:00:00		2016-06-30 00:00:00		2016-08-15 00:00:00		2016-09-22 00:00:00		2016-06-07 00:00:00		2016-08-12 00:00:00		2016-08-29 00:00:00		2016-08-31 00:00:00		2016-09-06 00:00:00		2016-09-16 00:00:00		2016-09-16 00:00:00		2016-09-20 00:00:00		2016-09-06 00:00:00		2016-09-02 00:00:00		2016-08-22 00:00:00		2016-09-14 00:00:00		2016-08-22 00:00:00		2016-08-25 00:00:00		2016-07-06 00:00:00		2016-09-16 00:00:00		2016-09-24 00:00:00		2016-09-26 00:00:00		2016-10-11 00:00:00		2016-08-19 00:00:00		2016-08-22 00:00:00		2016-09-12 00:00:00		2016-10-10 00:00:00		2016-08-16 00:00:00		2016-10-11 00:00:00		2016-11-01 00:00:00		2016-10-14 00:00:00		2016-10-17 00:00:00		2016-10-25 00:00:00		2016-09-24 00:00:00		2016-10-22 00:00:00		2016-10-17 00:00:00		2016-09-16 00:00:00		2016-10-27 00:00:00		2016-08-25 00:00:00		2016-10-28 00:00:00		2016-11-07 00:00:00		2016-11-04 00:00:00		2016-10-22 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		2017-06-30 00:00:00		2017-06-30 00:00:00		2018-04-19 00:00:00		2018-04-21 00:00:00		2017-12-31 00:00:00		None		2016-12-31 00:00:00		None		2018-04-21 00:00:00
rpt_date		2015-07-31 00:00:00		None		None		None		None		2015-01-28 00:00:00		None		2015-11-30 00:00:00		None		None		None		2017-08-24 00:00:00		2016-03-18 00:00:00		2016-03-15 00:00:00		2016-03-17 00:00:00		2016-03-22 00:00:00		2016-04-01 00:00:00		None		2015-09-24 00:00:00		None		2016-03-22 00:00:00		2016-01-26 00:00:00		2016-05-24 00:00:00		2016-05-02 00:00:00		2016-05-26 00:00:00		2016-04-25 00:00:00		2016-05-03 00:00:00		2016-03-31 00:00:00		2016-04-21 00:00:00		2016-04-27 00:00:00		2016-03-21 00:00:00		2016-04-19 00:00:00		2016-04-29 00:00:00		2016-04-29 00:00:00		2016-04-29 00:00:00		2016-05-06 00:00:00		2016-04-22 00:00:00		None		2016-04-22 00:00:00		2016-05-04 00:00:00		2016-05-10 00:00:00		2016-05-16 00:00:00		2016-05-13 00:00:00		2016-05-11 00:00:00		2016-08-10 00:00:00		2016-06-07 00:00:00		None		2016-07-06 00:00:00		2016-06-02 00:00:00		2016-06-01 00:00:00		None		2016-06-07 00:00:00		2016-05-24 00:00:00		2016-08-01 00:00:00		2016-08-15 00:00:00		2016-09-22 00:00:00		2016-06-07 00:00:00		2016-08-12 00:00:00		2016-08-29 00:00:00		2016-08-31 00:00:00		2016-09-06 00:00:00		2016-09-16 00:00:00		2016-09-16 00:00:00		2016-09-20 00:00:00		2016-09-06 00:00:00		2016-09-02 00:00:00		2016-08-22 00:00:00		2016-09-14 00:00:00		2016-08-22 00:00:00		2016-08-25 00:00:00		2016-07-06 00:00:00		2016-09-16 00:00:00		2016-09-29 00:00:00		2016-09-26 00:00:00		2016-10-11 00:00:00		2016-08-19 00:00:00		2016-08-22 00:00:00		2016-09-12 00:00:00		2016-10-10 00:00:00		2016-08-16 00:00:00		2016-10-11 00:00:00		2016-11-01 00:00:00		2016-10-14 00:00:00		2016-10-17 00:00:00		2016-10-25 00:00:00		None		2016-10-23 00:00:00		2016-10-17 00:00:00		2016-09-16 00:00:00		2016-10-27 00:00:00		2016-08-25 00:00:00		2016-10-28 00:00:00		2016-11-07 00:00:00		2016-11-04 00:00:00		None		2017-01-25 00:00:00		None		2017-07-25 00:00:00		None		2018-04-19 00:00:00		None		2018-01-31 00:00:00		None		None		None		2018-04-24 00:00:00
filing_type		22001		None		22006		None		None		22006		None		22001		None		None		None		22001		22001		22001		22001		22001		22001		None		22006		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22006		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		None		22001		None		22001		None		22001		None		None		None		22001

Table: filer_to_filer_type

filer_id		1374093		1374093		1374093		1374093
filer_type		16		16		16		16
active		Y		Y		T		Y
race		0		0		0		0
session_id		2017		2013		2017		2015
category		40002		40002		40002		40002
category_type		40502		40502		40502		40502
sub_category		0		0		0		0
effect_dt		2017-08-25 00:00:00		2014-12-16 00:00:00		2018-04-21 00:00:00		2015-03-06 00:00:00
sub_category_type		0		0		0		0
election_type		0		0		0		0
sub_category_a		None		None		None		None
nyq_dt		2015-01-28 00:00:00		None		2015-01-28 00:00:00		2015-01-28 00:00:00
party_cd		16002		16002		16002		16002
county_cd		18041		18004		18041		18004
district_cd		0		0		0		0

Table: filer_xref

filer_id		1374093
xref_id		1374093
effect_dt		2014-12-16 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1374093		1374093
filer_id		1374093		1374093
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		TERMINATED		TERMINATED
effect_dt		2018-04-21 00:00:00		2018-04-21 00:00:00
naml		OBERNOLTE FOR ASSEMBLY 2016; JAY		OBERNOLTE FOR ASSEMBLY 2016; JAY
namf		None		None
namt		None		None
nams		None		None
adr1		None		None
adr2		None		None
city		SACRAMENTO		SACRAMENTO
st		CA		CA
zip4		95814		95814
phon		9164766926		9164766926
fax		None		None
email		[email protected]		[email protected]

Table: filers

filer_id		1374093

Table: received_filings

filer_id		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093		1374093
filing_file_name		2050139_0.cal		2050160_0.cal		2069156_0.cal		2050391_0.cal		2049089_0.cal		2046430_0.cal		2045542_0.cal		2053581_0.cal		2053591_0.cal		2048328_0.cal		2000252_0.cal		2102980_0.cal		2077573_0.cal		2105843_0.cal		2105081_0.cal		2079975_0.cal		2087016_0.cal		9756.cal		2087764_0.cal		2081580_0.cal		2079452_0.cal		2087368_0.cal		2078681_0.cal		2078323_0.cal		2029921_0.cal		2021763_0.cal		2022321_0.cal		2025526_0.cal		2020851_0.cal		2021293_0.cal		2021539_0.cal		2022557_0.cal		2025239_0.cal		2088878_0.cal		2099380_0.cal		2090439_0.cal		2090444_0.cal		2095509_0.cal		2098374_0.cal		2076066_0.cal		2073155_0.cal		2071693_0.cal		2070538_0.cal		2071799_0.cal		2073895_0.cal		2068085_0.cal		2072592_1.cal		2074338_0.cal		2072592_0.cal		2068420_0.cal		2067241_0.cal		2070435_0.cal		2070548_0.cal		400476.cal		2070773_0.cal		2042867_0.cal		2041539_0.cal		2036199_0.cal		2039660_0.cal		2036271_0.cal		2031071_0.cal		2040418_0.cal		2041264_0.cal		2036847_0.cal		2031316_0.cal		2039194_0.cal		2033731_0.cal		2031527_0.cal		2043196_0.cal		2036847_1.cal		223612.cal		2233147_0.cal
received_date		2016-06-07 00:00:00		2016-06-07 00:00:00		2016-08-16 00:00:00		2016-06-07 00:00:00		2016-06-02 00:00:00		2016-05-26 00:00:00		2016-05-24 00:00:00		2016-07-06 00:00:00		2016-07-06 00:00:00		2016-06-01 00:00:00		2015-11-30 00:00:00		2016-11-01 00:00:00		2016-09-14 00:00:00		2016-11-07 00:00:00		2016-11-04 00:00:00		2016-09-22 00:00:00		2016-10-10 00:00:00		2016-10-11 00:00:00		2016-10-11 00:00:00		2016-09-26 00:00:00		2016-09-20 00:00:00		2016-10-11 00:00:00		2016-09-16 00:00:00		2016-09-16 00:00:00		2016-04-19 00:00:00		2016-03-21 00:00:00		2016-03-22 00:00:00		2016-04-01 00:00:00		2016-03-15 00:00:00		2016-03-17 00:00:00		2016-03-18 00:00:00		2016-03-22 00:00:00		2016-03-31 00:00:00		2016-10-14 00:00:00		2016-10-28 00:00:00		2016-10-17 00:00:00		2016-10-17 00:00:00		2016-10-25 00:00:00		2016-10-27 00:00:00		2016-09-12 00:00:00		2016-08-31 00:00:00		2016-08-25 00:00:00		2016-08-22 00:00:00		2016-08-25 00:00:00		2016-09-02 00:00:00		2016-08-12 00:00:00		2016-09-06 00:00:00		2016-09-06 00:00:00		2016-08-29 00:00:00		2016-08-15 00:00:00		2016-08-10 00:00:00		2016-08-19 00:00:00		2016-08-22 00:00:00		2016-08-22 00:00:00		2016-08-22 00:00:00		2016-05-13 00:00:00		2016-05-11 00:00:00		2016-04-29 00:00:00		2016-05-04 00:00:00		2016-04-29 00:00:00		2016-04-21 00:00:00		2016-05-06 00:00:00		2016-05-10 00:00:00		2016-04-29 00:00:00		2016-04-22 00:00:00		2016-05-03 00:00:00		2016-04-27 00:00:00		2016-04-22 00:00:00		2016-05-16 00:00:00		2016-05-02 00:00:00		2015-07-31 00:00:00		2018-04-19 00:00:00
filing_directory		/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/temp		/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/temp		/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/temp		/cafiler/disclose/ca99/cal
filing_id		2050139		2050160		2069156		2050391		2049089		2046430		2045542		2053581		2053591		2048328		2000252		2102980		2077573		2105843		2105081		2079975		2087016		None		2087764		2081580		2079452		2087368		2078681		2078323		2029921		2021763		2022321		2025526		2020851		2021293		2021539		2022557		2025239		2088878		2099380		2090439		2090444		2095509		2098374		2076066		2073155		2071693		2070538		2071799		2073895		2068085		2072592		2074338		2072592		2068420		2067241		2070435		2070548		None		2070773		2042867		2041539		2036199		2039660		2036271		2031071		2040418		2041264		2036847		2031316		2039194		2033731		2031527		2043196		2036847		None		2233147
form_id		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		None		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		F497		F497		F497		F497		F497		F497		F497		F497		F497		None		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		None		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 passed validation, but failed DB constraints		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 passed validation, but failed DB constraints		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 passed validation, but failed DB constraints		Filing accepted