Home

Filer ID: 1373700

Table: cvr_campaign_disclosure

filing_id		1937372		1979798		2035131		2033802		2013227		2015316		2002501		2035131		2046772		2083186		2082541		2084473		2067961		2035131		2072242		2064442		2046772		2105302		2090365		2167387		2176468		2148910		2130682		2137807		2178845		2083186		2107021		2097817		2103931		2246958		2228998		2229523		2211912		2254292		2238258		2250914		2253085		2258807		2245084		2224296		2273404		2398365		2346577		2435872		2479216		2546704
amend_id		0		0		0		0		0		0		0		1		0		0		0		0		0		2		0		0		1		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
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
form_type		F460		F460		F460		F497		F460		F497		F497		F460		F460		F460		F497		F497		F497		F460		F497		F460		F460		F497		F497		F497		F460		F497		F460		F497		F497		F460		F497		F460		F497		F497		F497		F497		F460		F460		F460		F497		F497		F497		F497		F497		F460		F460		F460		F460		F460		F460
filer_id		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700
entity_cd		RCP		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
filer_naml		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018		Mendoza for Senate 2018
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
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
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
report_num		000		000		000		000		000		000		000		001		000		000		000		000		000		002		000		000		001		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
rpt_date		2014-12-31 00:00:00		2015-07-17 00:00:00		2016-04-28 00:00:00		2016-04-27 00:00:00		2016-02-01 00:00:00		2016-02-10 00:00:00		2016-01-05 00:00:00		2016-05-26 00:00:00		2016-05-26 00:00:00		2016-09-29 00:00:00		2016-09-28 00:00:00		2016-10-03 00:00:00		2016-08-12 00:00:00		2016-08-24 00:00:00		2016-08-26 00:00:00		2016-08-01 00:00:00		2016-08-01 00:00:00		2016-11-04 00:00:00		2016-10-17 00:00:00		2017-07-14 00:00:00		2017-07-31 00:00:00		2017-03-30 00:00:00		2017-01-31 00:00:00		2017-02-15 00:00:00		2017-08-03 00:00:00		2016-10-25 00:00:00		2016-11-10 00:00:00		2016-10-27 00:00:00		2016-11-02 00:00:00		2018-05-07 00:00:00		2018-04-06 00:00:00		2018-04-09 00:00:00		2018-01-31 00:00:00		2018-05-24 00:00:00		2018-04-26 00:00:00		2018-05-18 00:00:00		2018-05-24 00:00:00		2018-06-01 00:00:00		2018-05-02 00:00:00		2018-03-22 00:00:00		2018-07-30 00:00:00		2019-07-31 00:00:00		2019-01-17 00:00:00		2020-01-19 00:00:00		2020-07-17 00:00:00		2021-01-25 00:00:00
stmt_type		SA		SA		PE		None		SA		None		None		PE		PE		PE		None		None		None		PE		None		SA		PE		None		None		None		SA		None		SA		None		None		PE		None		PE		None		None		None		None		SA		PE		PE		None		None		None		None		None		SA		SA		SA		SA		SA		TS
late_rptno		None		None		None		16381		None		15492		15395		None		None		None		18870		19055		17656		None		17894		None		None		21347		19865		07-14TM		None		03-30TM		None		21773		08-03TM		None		21526		None		21132		05-07-TM		04-06-TM		04-09-TM		None		None		None		05-18-TM		05-24-TM		06-01-IA		05-02-TM		03-22-TM		None		None		None		None		None		None
from_date		2014-01-01 00:00:00		2015-01-01 00:00:00		2016-01-01 00:00:00		None		2015-07-01 00:00:00		None		None		2016-01-01 00:00:00		2016-04-24 00:00:00		2016-07-01 00:00:00		None		None		None		2016-01-01 00:00:00		None		2016-05-22 00:00:00		2016-04-24 00:00:00		None		None		None		2017-01-01 00:00:00		None		2016-10-23 00:00:00		None		None		2016-07-01 00:00:00		None		2016-09-25 00:00:00		None		None		None		None		2017-07-01 00:00:00		2018-04-22 00:00:00		2018-01-01 00:00:00		None		None		None		None		None		2018-05-20 00:00:00		2019-01-01 00:00:00		2018-07-01 00:00:00		2019-07-01 00:00:00		2020-01-01 00:00:00		2020-07-01 00:00:00
thru_date		2014-12-31 00:00:00		2015-06-30 00:00:00		2016-04-23 00:00:00		None		2015-12-31 00:00:00		None		None		2016-04-23 00:00:00		2016-05-21 00:00:00		2016-09-24 00:00:00		None		None		None		2016-04-23 00:00:00		None		2016-06-30 00:00:00		2016-05-21 00:00:00		None		None		None		2017-06-30 00:00:00		None		2016-12-31 00:00:00		None		None		2016-09-24 00:00:00		None		2016-10-22 00:00:00		None		None		None		None		2017-12-31 00:00:00		2018-05-19 00:00:00		2018-04-21 00:00:00		None		None		None		None		None		2018-06-30 00:00:00		2019-06-30 00:00:00		2018-12-31 00:00:00		2019-12-31 00:00:00		2020-06-30 00:00:00		2020-12-31 00:00:00
elect_date		None		None		2016-06-07 00:00:00		None		2018-06-04 00:00:00		None		None		2016-06-07 00:00:00		2016-06-07 00:00:00		2016-11-08 00:00:00		None		None		None		2016-06-07 00:00:00		None		None		2016-06-07 00:00:00		None		None		None		2018-06-05 00:00:00		None		None		None		None		2016-11-08 00:00:00		None		2016-11-08 00:00:00		None		None		None		None		2018-06-05 00:00:00		2018-06-05 00:00:00		2018-06-05 00:00:00		None		None		None		None		None		2018-06-05 00:00:00		2018-06-05 00:00:00		2018-06-05 00:00:00		2018-06-05 00:00:00		2018-06-05 00:00:00		2018-06-05 00:00:00
filer_city		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach
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
filer_zip4		90807		90807		90807		90807		90807		90807		90807		90807		90807		90807		90807		90807		90807		90807		90807		90807		90807		90807		90807		90802		90802		90802		90807		90807		90802		90807		90807		90807		90807		90802		90802		90802		90802		90802		90802		90802		90802		90802		90802		90802		90802		90802		90802		90802		90802		90802
filer_phon		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		562-983-0815		562-983-0815		562-983-0815		(562) 427-2100		(562) 427-2100		562-983-0815		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		562-983-0815		562-983-0815		562-983-0815		562-983-0815		562-983-0815		562-983-0815		562-983-0815		562-983-0815		562-983-0815		562-983-0815		562-983-0815		562-983-0815		562-983-0815		562-983-0815		562-983-0815		562-983-0815		562-983-0815
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
file_email		None		None		[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		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		None		None		None		Sacramento		Sacramento		None		Sacramento		Sacramento		Sacramento		Sacramento		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
mail_st		None		None		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		None		None		None		CA		CA		None		CA		CA		CA		CA		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
mail_zip4		None		None		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		None		None		None		95814		95814		None		95814		95814		95814		95814		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_naml		Mendoza		Mendoza		Mendoza		Mendoza		Mendoza		Mendoza		Mendoza		Mendoza		Mendoza		Mendoza		Mendoza		Mendoza		Mendoza		Mendoza		Mendoza		Mendoza		Mendoza		Mendoza		Mendoza		Crummitt		Crummitt		Crummitt		Mendoza		Mendoza		Crummitt		Mendoza		Mendoza		Mendoza		Mendoza		Crummitt		Crummitt		Crummitt		Crummitt		Crummitt		Crummitt		Crummitt		Crummitt		Crummitt		Crummitt		Crummitt		Crummitt		Crummitt		Crummitt		Crummitt		Crummitt		Crummitt
tres_namf		Tony		Tony		Tony		Tony		Tony		Tony		Tony		Tony		Tony		Tony		Tony		Tony		Tony		Tony		Tony		Tony		Tony		Tony		Tony		Gary		Gary		Gary		Tony		Tony		Gary		Tony		Tony		Tony		Tony		Gary		Gary		Gary		Gary		Gary		Gary		Gary		Gary		Gary		Gary		Gary		Gary		Gary		Gary		Gary		Gary		Gary
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
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
tres_city		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach
tres_st		None		None		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
tres_zip4		90807		90807		90807		90807		90807		90807		90807		90807		90807		90807		90807		90807		90807		90807		90807		90807		90807		90807		90807		90802		90802		90802		90807		90807		90802		90807		90807		90807		90807		90802		90802		90802		90802		90802		90802		90802		90802		90802		90802		90802		90802		90802		90802		90802		90802		90802
tres_phon		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		562-983-0815		562-983-0815		562-983-0815		(562) 427-2100		(562) 427-2100		562-983-0815		(562) 427-2100		(562) 427-2100		(562) 427-2100		(562) 427-2100		562-983-0815		562-983-0815		562-983-0815		562-983-0815		562-983-0815		562-983-0815		562-983-0815		562-983-0815		562-983-0815		562-983-0815		562-983-0815		562-983-0815		562-983-0815		562-983-0815		562-983-0815		562-983-0815		562-983-0815
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
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
cmtte_type		C		C		C		None		C		None		None		C		C		C		None		None		None		C		None		C		C		None		None		None		C		None		C		None		None		C		None		C		None		None		None		None		C		C		C		None		None		None		None		None		C		C		C		C		C		C
control_yn		Y		Y		Y		None		Y		None		None		Y		Y		Y		None		None		None		Y		None		Y		Y		None		None		None		Y		None		Y		None		None		Y		None		Y		None		None		None		None		Y		Y		Y		None		None		None		None		None		Y		Y		Y		Y		Y		Y
sponsor_yn		N		N		N		None		N		None		None		N		N		N		None		None		None		N		None		N		N		None		None		None		N		None		N		None		None		N		None		N		None		None		None		None		N		N		N		None		None		None		None		None		N		N		N		N		N		N
primfrm_yn		None		None		N		None		N		None		None		N		N		N		None		None		None		N		None		N		N		None		None		None		N		None		N		None		None		N		None		N		None		None		None		None		N		N		N		None		None		None		None		None		N		N		N		N		N		N
brdbase_yn		None		None		N		None		N		None		None		N		N		N		None		None		None		N		None		N		N		None		None		None		N		None		N		None		None		N		None		N		None		None		None		None		N		N		N		None		None		None		None		None		N		N		N		N		N		N
amendexp_1		None		None		None		None		None		None		None		Amend Schedule A, Summary Page		None		None		None		None		None		Amend Schedule A		None		None		Update Summary Page, Sch. A, Sch. F, Sch. G		None		None		None		None		None		None		None		None		Amend Schdedule A, F, G, Summary Page		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
cand_naml		Mendoza		Mendoza		Mendoza		None		Mendoza		None		None		Mendoza		Mendoza		Mendoza		None		None		None		Mendoza		None		Mendoza		Mendoza		None		None		None		Mendoza		None		Mendoza		None		None		Mendoza		None		Mendoza		None		None		None		None		Mendoza		Mendoza		Mendoza		None		None		None		None		None		Mendoza		Mendoza		Mendoza		Mendoza		Mendoza		Mendoza
cand_namf		Tony		Tony		Tony		None		Tony		None		None		Tony		Tony		Tony		None		None		None		Tony		None		Tony		Tony		None		None		None		Tony		None		Tony		None		None		Tony		None		Tony		None		None		None		None		Tony		Tony		Tony		None		None		None		None		None		Tony		Tony		Tony		Tony		Tony		Tony
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
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
cand_city		Long Beach		Long Beach		Long Beach		None		Long Beach		None		None		Long Beach		Long Beach		Long Beach		None		None		None		Long Beach		None		Long Beach		Long Beach		None		None		None		Long Beach		None		Long Beach		None		None		Long Beach		None		Long Beach		None		None		None		None		Long Beach		Long Beach		Long Beach		None		None		None		None		None		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach
cand_st		CA		CA		CA		None		CA		None		None		CA		CA		CA		None		None		None		CA		None		CA		CA		None		None		None		CA		None		CA		None		None		CA		None		CA		None		None		None		None		CA		CA		CA		None		None		None		None		None		CA		CA		CA		CA		CA		CA
cand_zip4		90807		90807		90807		None		90807		None		None		90807		90807		90807		None		None		None		90807		None		90807		90807		None		None		None		90802		None		90807		None		None		90807		None		90807		None		None		None		None		90802		90802		90802		None		None		None		None		None		90802		90802		90802		90802		90802		90802
cand_phon		(562) 427-2100		(562) 427-2100		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		562-983-0815		562-983-0815		None		None		None		None		None		562-983-0815		562-983-0815		562-983-0815		562-983-0815		562-983-0815		562-983-0815
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
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		[email protected]		[email protected]		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]
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
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
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
office_cd		None		None		SEN		None		SEN		None		None		SEN		SEN		SEN		None		None		None		SEN		None		SEN		SEN		None		None		None		SEN		None		SEN		None		None		SEN		None		SEN		None		None		None		None		SEN		SEN		SEN		None		None		None		None		None		SEN		SEN		SEN		SEN		SEN		SEN
offic_dscr		Senate District		Senate District		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_cd		None		None		SEN		None		SEN		None		None		SEN		SEN		SEN		None		None		None		SEN		None		SEN		SEN		None		None		None		SEN		None		SEN		None		None		SEN		None		SEN		None		None		None		None		SEN		SEN		SEN		None		None		None		None		None		SEN		SEN		SEN		SEN		SEN		SEN
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
dist_no		34		34		32		None		32		None		None		32		32		32		None		None		None		32		None		32		32		None		None		None		32		None		32		None		None		32		None		32		None		None		None		None		32		32		32		None		None		None		None		None		32		32		32		32		32		32
off_s_h_cd		H		H		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		H		None		None		None		None		None		None		None		None		None		None		None		H		H		H		None		None		None		None		None		H		H		H		H		H		H
sup_opp_cd		S		S		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
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
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
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
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

Table: cvr_so

filing_id		1917376		1917376		1917376		1917376
amend_id		1		0		2		3
rec_type		CVR		CVR		CVR		CVR
form_type		F410		F410		F410		F410
filer_id		1373700		1373700		1373700		1373700
entity_cd		RCP		RCP		RCP		RCP
filer_naml		MENDOZA FOR SENATE 2018		MENDOZA FOR SENATE 2018		MENDOZA FOR SENATE 2018		Mendoza for Senate 2018
filer_namf		None		None		None		None
filer_namt		None		None		None		None
filer_nams		None		None		None		None
report_num		001		000		002		3
rpt_date		2014-12-08 00:00:00		2014-12-08 00:00:00		2014-12-08 00:00:00		2015-12-30 00:00:00
qual_cb		X		X		None		X
qualfy_dt		None		None		2014-11-21 00:00:00		2014-11-21 00:00:00
term_date		None		None		None		None
city		LONG BEACH		LONG BEACH		LONG BEACH		Long Beach
st		CA		CA		CA		CA
zip4		90807		90807		90807		90807
phone		5624272100		5624272100		5624272100		(562) 427-2100
county_res		Los Angeles		None		Los Angeles		Los Angeles
county_act		None		None		None		None
mail_city		None		None		None		Sacramento
mail_st		None		None		None		CA
mail_zip4		None		None		None		95814
cmte_fax		None		None		None		None
cmte_email		[email protected]		[email protected]		[email protected]		[email protected]
tres_naml		Mendoza		Mendoza		Mendoza		Mendoza
tres_namf		Tony		Tony		Tony		Tony
tres_namt		None		None		None		None
tres_nams		None		None		None		None
tres_city		Long Beach		Long Beach		Long Beach		Long Beach
tres_st		CA		CA		CA		CA
tres_zip4		90807		90807		90807		90807
tres_phon		5624272100		5624272100		5624272100		(562) 427-2100
actvty_lvl		None		None		None		None
com82013yn		None		None		None		None
com82013nm		None		None		None		None
com82013id		None		None		None		None
control_cb		X		X		X		X
bank_nam		Torrey Pines Bank		Torrey Pines Bank		Torrey Pines Bank		Wells Fargo Bank
bank_adr1		601 W. Fifth St., Ste. 100		601 W. Fifth St., Ste. 100		601 W. Fifth St., Ste. 100		400 Capitol Mall
bank_adr2		None		None		None		None
bank_city		Los Angeles		Los Angeles		Los Angeles		Sacramento
bank_st		CA		CA		CA		CA
bank_zip4		90071		90071		90071		95814
bank_phon		2133625200		2133625200		2133625200		(916) 440-4205
acct_opendt		None		None		None		None
surplusdsp		None		None		None		None
primfc_cb		None		None		None		None
genpurp_cb		None		None		None		None
gpc_descr		None		None		None		None
sponsor_cb		None		None		None		None
brdbase_cb		None		None		None		None
smcont_qualdt		None		None		None		None

Table: filer_address

filer_id		1373700		1373700		1373700		1373700
adrid		2432462		2335877		2379224		2379223
effect_dt		2017-03-14 00:00:00		2014-11-19 00:00:00		2015-12-30 00:00:00		2015-12-30 00:00:00
add_type		7051		7051		7082		7051
session_id		2017		2013		2015		2015

Table: filer_filings

filer_id		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700
filing_id		1979798		1937372		1939333		1917376		1917376		1918000		1916015		1917376		2002355		1917376		2002501		1984769		2246958		2228998		2254292		2238258		2273404		2224296		2245084		2256603		2479216		2493601		2280005		2250914		2016448		2015316		2013227		2033802		2035131		2039883		2046772		2049318		2035131		2039883		2083186		2067961		2035131		2072242		2084473		2046772		2064442		2065735		2103931		2049318		2082541		2092588		2105302		2090365		2083186		2097817		2039883		2092588		2108167		2107021		2146479		2148910		2137807		2130682		2178845		2176468		2179411		2140717		2253085		2167387		2211912		2363771		2258807		2546704		2247208		2398365		2405227		2229523		2446918		2435872		2488195		2214337		2346577		2558606		2560067
period_id		221		217		None		220		220		None		None		220		None		224		225		None		234		234		234		233		234		233		234		None		241		None		None		234		None		225		223		226		225		None		226		None		225		None		227		227		225		227		228		226		226		None		228		None		227		None		228		228		227		227		None		None		None		228		None		229		229		228		231		229		None		None		234		231		231		None		234		243		None		237		None		234		None		239		None		None		235		None		None
form_id		F460		F460		F460		F410		F410		F410		F410		F410		F410		F410		F497		F460		F497		F497		F460		F460		F460		F497		F497		F460		F460		F666		F460		F497		F460		F497		F460		F497		F460		F460		F460		F460		F460		F460		F460		F497		F460		F497		F497		F460		F460		F460		F497		F460		F497		F460		F497		F497		F460		F460		F460		F460		F460		F497		F410		F497		F497		F460		F497		F460		F460		F460		F497		F497		F460		F460		F497		F460		F460		F460		F460		F497		F460		F460		F460		F460		F460		F410		F460
filing_sequence		0		0		0		0		2		0		0		1		0		3		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		1		0		0		2		0		0		1		0		0		0		1		0		0		0		0		1		0		2		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
filing_date		2015-07-29 00:00:00		2015-02-02 00:00:00		2015-02-02 00:00:00		2014-12-08 00:00:00		2014-12-08 00:00:00		2014-12-08 00:00:00		2014-11-19 00:00:00		2014-12-08 00:00:00		2015-12-30 00:00:00		2015-12-30 00:00:00		2016-01-05 00:00:00		2015-07-31 00:00:00		2018-05-07 00:00:00		2018-04-06 00:00:00		2018-05-24 00:00:00		2018-04-26 00:00:00		2018-07-30 00:00:00		2018-03-22 00:00:00		2018-05-02 00:00:00		2018-05-24 00:00:00		2020-07-18 00:00:00		2020-07-31 00:00:00		2018-08-01 00:00:00		2018-05-18 00:00:00		2016-02-01 00:00:00		2016-02-10 00:00:00		2016-02-01 00:00:00		2016-04-27 00:00:00		2016-04-28 00:00:00		2016-04-28 00:00:00		2016-05-26 00:00:00		2016-05-26 00:00:00		2016-05-26 00:00:00		2016-05-27 00:00:00		2016-09-29 00:00:00		2016-08-12 00:00:00		2016-08-24 00:00:00		2016-08-26 00:00:00		2016-10-03 00:00:00		2016-08-01 00:00:00		2016-08-01 00:00:00		2016-08-01 00:00:00		2016-11-02 00:00:00		2016-08-02 00:00:00		2016-09-28 00:00:00		2016-09-29 00:00:00		2016-11-04 00:00:00		2016-10-17 00:00:00		2016-10-27 00:00:00		2016-10-27 00:00:00		2016-08-26 00:00:00		2016-10-28 00:00:00		2016-10-27 00:00:00		2016-11-10 00:00:00		2017-03-14 00:00:00		2017-03-30 00:00:00		2017-02-15 00:00:00		2017-01-31 00:00:00		2017-08-04 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00		2017-01-31 00:00:00		2018-05-24 00:00:00		2017-07-14 00:00:00		2018-01-31 00:00:00		2019-01-31 00:00:00		2018-06-01 00:00:00		2021-01-25 00:00:00		2018-04-26 00:00:00		2019-07-31 00:00:00		2019-07-31 00:00:00		2018-04-09 00:00:00		2020-01-30 00:00:00		2020-01-26 00:00:00		2020-07-24 00:00:00		2018-01-31 00:00:00		2019-01-30 00:00:00		2021-02-01 00:00:00		2021-01-28 00:00:00
stmnt_type		10001		10001		10005		10001		10002		10006		10005		10002		10006		10002		10001		10005		10001		10001		10001		10001		10001		10001		10001		10005		10001		10005		10005		10001		10005		10001		10001		10001		10001		10005		10001		10005		10002		10006		10001		10001		10002		10001		10001		10002		10001		10005		10001		10006		10001		10005		10001		10001		10002		10001		10006		10006		10005		10001		10006		10001		10001		10001		10001		10001		10005		10005		10001		10001		10001		10005		10001		10001		10005		10001		10005		10001		10005		10001		10005		10005		10001		10003		10003
stmnt_status		11001		11001		11003		11003		11003		11001		11003		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11003		11001		11001		11001		11003		11001		11003		11003		11001		11003		11001		11001		11001		11001		11001		11003		11003		11001		11001		11003		11001		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001
session_id		2015		2013		2013		2013		2013		2013		2013		2013		2015		2015		2015		2015		2017		2017		2017		2017		2017		2017		2017		2017		2019		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		2017		2017		2017		2015		2017		2017		2017		2015		2017		2017		2017		2017		2017		2019		2017		2019		2019		2017		2019		2019		2019		2017		2017		2021		2021
user_id		MDIGRAZIA		MDIGRAZIA		GCLARA		CAFILER		CAFILER		TRAMON		CPON		TRAMON		TRAMON		TRAMON		RGEREMIA		MDIGRAZIA		CAFILER		CAFILER		HSTOVALL		HSTOVALL		JFRONEFIELD		CAFILER		RGEREMIA		HSTOVALL		IMEDINA		AROBERTS		JFRONEFIELD		CAFILER		MPACHECO		RGEREMIA		CAFILER		KBANH		SARRIAGA		SARRIAGA		SARRIAGA		SARRIAGA		CAFILER		MPACHECO		SARRIAGA		RGEREMIA		CAFILER		RGEREMIA		PDEO		CAFILER		SMCCONNAN		SMCCONNAN		PDEO		MPACHECO		PDEO		SARRIAGA		PDEO		PDEO		CAFILER		GPEREZ		MPACHECO		MPACHECO		GPEREZ		RGEREMIA		LPALMER		PBANFORD		PBANFORD		CPON		RGEREMIA		RPOOJA		RPOOJA		CPON		CAFILER		RGEREMIA		CSAGABAEN		LPALMER		CAFILER		SUSHAKOV		HSTOVALL		HCOURSEY		HCOURSEY		CAFILER		YMORA		YMORA		IMEDINA		CSAGABAEN		LPALMER		JMENDOZA		SUSHAKOV
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
fine_audit		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11001		11003		11001		11001		11001		11003		11001		11003		11001		11001		11003		11003		11003		11003		11003		11001		11003		11001		11001		11003		11001		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
rpt_start		2015-01-01 00:00:00		2014-01-01 00:00:00		2014-01-01 00:00:00		2014-12-08 00:00:00		2014-12-08 00:00:00		None		None		2014-12-08 00:00:00		None		2015-12-30 00:00:00		2016-01-05 00:00:00		2015-01-01 00:00:00		2018-05-07 00:00:00		2018-04-06 00:00:00		2018-04-22 00:00:00		2018-01-01 00:00:00		2018-05-20 00:00:00		2018-03-22 00:00:00		2018-05-02 00:00:00		2018-04-22 00:00:00		2020-01-01 00:00:00		2014-01-01 00:00:00		2018-05-20 00:00:00		2018-05-18 00:00:00		2015-07-01 00:00:00		2016-02-10 00:00:00		2015-07-01 00:00:00		2016-04-27 00:00:00		2016-01-01 00:00:00		2016-01-01 00:00:00		2016-04-24 00:00:00		2016-04-24 00:00:00		2016-01-01 00:00:00		2016-01-01 00:00:00		2016-07-01 00:00:00		2016-08-12 00:00:00		2016-01-01 00:00:00		2016-08-26 00:00:00		2016-10-03 00:00:00		2016-04-24 00:00:00		2016-05-22 00:00:00		2016-05-22 00:00:00		2016-11-02 00:00:00		2016-04-24 00:00:00		2016-09-28 00:00:00		2016-07-01 00:00:00		2016-11-04 00:00:00		2016-10-17 00:00:00		2016-07-01 00:00:00		2016-09-25 00:00:00		2016-01-01 00:00:00		2016-07-01 00:00:00		2016-09-25 00:00:00		2016-11-10 00:00:00		None		2017-03-30 00:00:00		2017-02-15 00:00:00		2016-10-23 00:00:00		2017-08-03 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2016-10-23 00:00:00		2018-05-24 00:00:00		2017-07-14 00:00:00		2017-07-01 00:00:00		2018-07-01 00:00:00		2018-06-01 00:00:00		2020-07-01 00:00:00		2018-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2018-04-09 00:00:00		2019-07-01 00:00:00		2019-07-01 00:00:00		2020-01-01 00:00:00		2017-07-01 00:00:00		2018-07-01 00:00:00		None		2020-07-01 00:00:00
rpt_end		2015-06-30 00:00:00		2014-12-31 00:00:00		2014-12-31 00:00:00		2014-12-08 00:00:00		2014-12-08 00:00:00		None		None		2014-12-08 00:00:00		None		2015-12-30 00:00:00		2016-01-05 00:00:00		2015-06-30 00:00:00		2018-05-07 00:00:00		2018-04-06 00:00:00		2018-05-19 00:00:00		2018-04-21 00:00:00		2018-06-30 00:00:00		2018-03-22 00:00:00		2018-05-02 00:00:00		2018-05-19 00:00:00		2020-06-30 00:00:00		2018-06-30 00:00:00		2018-06-30 00:00:00		2018-05-18 00:00:00		2015-12-31 00:00:00		2016-02-10 00:00:00		2015-12-31 00:00:00		2016-04-27 00:00:00		2016-04-23 00:00:00		2016-04-23 00:00:00		2016-05-21 00:00:00		2016-05-21 00:00:00		2016-04-23 00:00:00		2016-04-23 00:00:00		2016-09-24 00:00:00		2016-08-12 00:00:00		2016-04-23 00:00:00		2016-08-26 00:00:00		2016-10-03 00:00:00		2016-05-21 00:00:00		2016-06-30 00:00:00		2016-06-30 00:00:00		2016-11-02 00:00:00		2016-05-21 00:00:00		2016-09-28 00:00:00		2016-09-24 00:00:00		2016-11-04 00:00:00		2016-10-17 00:00:00		2016-09-24 00:00:00		2016-10-22 00:00:00		2016-04-23 00:00:00		2016-09-24 00:00:00		2016-10-22 00:00:00		2016-11-10 00:00:00		None		2017-03-30 00:00:00		2017-02-15 00:00:00		2016-12-31 00:00:00		2017-08-03 00:00:00		2017-06-30 00:00:00		2017-06-30 00:00:00		2016-12-31 00:00:00		2018-05-24 00:00:00		2017-07-14 00:00:00		2017-12-31 00:00:00		2018-12-31 00:00:00		2018-06-01 00:00:00		2020-12-31 00:00:00		2018-04-21 00:00:00		2019-06-30 00:00:00		2019-06-30 00:00:00		2018-04-09 00:00:00		2019-12-31 00:00:00		2019-12-31 00:00:00		2020-06-30 00:00:00		2017-12-31 00:00:00		2018-12-31 00:00:00		None		2020-12-31 00:00:00
rpt_date		2015-07-17 00:00:00		2014-12-31 00:00:00		None		None		None		None		None		None		None		None		2016-01-05 00:00:00		None		2018-05-07 00:00:00		2018-04-06 00:00:00		2018-05-24 00:00:00		2018-04-26 00:00:00		2018-07-30 00:00:00		2018-03-22 00:00:00		2018-05-02 00:00:00		None		2020-07-17 00:00:00		None		None		2018-05-18 00:00:00		None		2016-02-10 00:00:00		2016-02-01 00:00:00		2016-04-27 00:00:00		2016-04-28 00:00:00		None		2016-05-26 00:00:00		None		2016-05-26 00:00:00		None		2016-09-29 00:00:00		2016-08-12 00:00:00		2016-08-24 00:00:00		2016-08-26 00:00:00		2016-10-03 00:00:00		2016-08-01 00:00:00		2016-08-01 00:00:00		None		2016-11-02 00:00:00		None		2016-09-28 00:00:00		None		2016-11-04 00:00:00		2016-10-17 00:00:00		2016-10-25 00:00:00		2016-10-27 00:00:00		None		None		None		2016-11-10 00:00:00		None		2017-03-30 00:00:00		2017-02-15 00:00:00		2017-01-31 00:00:00		2017-08-03 00:00:00		2017-07-31 00:00:00		None		None		2018-05-24 00:00:00		2017-07-14 00:00:00		2018-01-31 00:00:00		None		2018-06-01 00:00:00		2021-01-25 00:00:00		None		2019-07-31 00:00:00		None		2018-04-09 00:00:00		None		2020-01-19 00:00:00		None		None		2019-01-17 00:00:00		None		None
filing_type		22001		22001		None		22006		22006		None		None		22006		None		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		None		22001		None		None		22001		None		22001		22001		22001		22001		None		22001		None		22001		None		22001		22001		22001		22001		22001		22001		22001		None		22001		None		22001		None		22001		22001		22001		22001		None		None		None		22001		None		22001		22001		22001		22001		22001		None		None		22001		22001		22001		None		22001		22001		None		22001		None		22001		None		22001		None		None		22001		None		None

Table: filer_to_filer_type

filer_id		1373700		1373700		1373700
filer_type		16		16		16
active		Y		Y		T
race		0		0		0
session_id		2013		2013		2019
category		40002		40002		40002
category_type		40502		40502		40502
sub_category		0		0		0
effect_dt		2014-12-08 00:00:00		2014-11-19 00:00:00		2020-12-31 00:00:00
sub_category_type		0		0		0
election_type		0		0		0
sub_category_a		None		None		None
nyq_dt		2014-11-21 00:00:00		None		2014-11-21 00:00:00
party_cd		16001		16001		16001
county_cd		18026		18026		18026
district_cd		0		0		0

Table: filer_xref

filer_id		1373700
xref_id		1373700
effect_dt		2014-11-20 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1373700		1373700		1373700		1373700
filer_id		1373700		1373700		1373700		1373700
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		TERMINATED		TERMINATED		TERMINATED		TERMINATED
effect_dt		2020-12-31 00:00:00		2020-12-31 00:00:00		2020-12-31 00:00:00		2020-12-31 00:00:00
naml		MENDOZA FOR SENATE 2018		MENDOZA FOR SENATE 2018		MENDOZA FOR SENATE 2018		MENDOZA FOR SENATE 2018
namf		None		None		None		None
namt		None		None		None		None
nams		None		None		None		None
adr1		None		None		None		None
adr2		None		None		None		None
city		LONG BEACH		LONG BEACH		SACRAMENTO		LONG BEACH
st		CA		CA		CA		CA
zip4		90807		90807		95814		90802
phon		5624272100		5624272100		5624272100		5629830815
fax		None		None		None		None
email		[email protected]		[email protected]		[email protected]		[email protected]

Table: filers

filer_id		1373700

Table: received_filings

filer_id		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700		1373700
filing_file_name		2148910_0.cal		1917376_3.cal		2002501_0.cal		2105302_0.cal		2107021_0.cal		2103931_0.cal		120967.cal		2015316_0.cal		1917376_2.cal		2084473_0.cal		2072242_0.cal		2067961_0.cal		2033802_0.cal		2167387_0.cal		2178845_0.cal		2082541_0.cal		105789.cal		2246958_0.cal		2228998_0.cal		2245084_0.cal		2250914_0.cal		2253085_0.cal		2258807_0.cal		2229523_0.cal		75369.cal
received_date		2017-03-30 00:00:00		2015-12-30 00:00:00		2016-01-05 00:00:00		2016-11-04 00:00:00		2016-11-10 00:00:00		2016-11-02 00:00:00		2016-09-29 00:00:00		2016-02-10 00:00:00		2014-12-08 00:00:00		2016-10-03 00:00:00		2016-08-26 00:00:00		2016-08-12 00:00:00		2016-04-27 00:00:00		2017-07-14 00:00:00		2017-08-04 00:00:00		2016-09-28 00:00:00		2017-07-31 00:00:00		2018-05-07 00:00:00		2018-04-06 00:00:00		2018-05-02 00:00:00		2018-05-18 00:00:00		2018-05-24 00:00:00		2018-06-01 00:00:00		2018-04-09 00:00:00		2021-01-25 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/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/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/temp
filing_id		2148910		1917376		2002501		2105302		2107021		2103931		None		2015316		1917376		2084473		2072242		2067961		2033802		2167387		2178845		2082541		None		2246958		2228998		2245084		2250914		2253085		2258807		2229523		None
form_id		F497		F410		F497		F497		F497		F497		None		F497		F410		F497		F497		F497		F497		F497		F497		F497		None		F497		F497		F497		F497		F497		F497		F497		None
receive_comment		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints