Home

Filer ID: 1376452

Table: cvr_campaign_disclosure

filing_id		2031347		2033152		2032618		2032022		2034249		2041011		2040457		2041721		2042133		2048865		2033204		2030504		2028805		2012068		2023709		2040548		2025559		2025129		2025369		2026446		2027290		2025883		2027639		1986033		1981806		2010465		2043109		2046670		2044772		2046515		2044652		2045940		2083159		2087439		2082419		2081915		2085005		2083957		2094517		2081396		2086492		2087021		2080451		2068301		2072090		2070511		2071634		2073408		2073763		2073771		2069931		2072517		2076226		2078393		2080076		2067868		2069416		2070999		2075466		2075945		2060273		2095227		2103723		2083957		2089121		2088449		2089169		2090079		2090801		2092443		2089121		2173665		2125739		2101869		2097711		2102832		2104256		2105182		2105588		2097930		2103068		2104381		2105019
amend_id		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		1		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		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		F497		F497		F497		F497		F460		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F460		F460		F497		F497		F497		F460		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		F460		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F460		F460		F497		F497		F497		F497		F497		F497		F460		F497		F497		F497
filer_id		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452
entity_cd		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		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		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 2016		Moorlach for Senate 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
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
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
report_num		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		001		000		000		000		000		000		000		001		000		000		000		000		000		000		000		000		000		000		000		000
rpt_date		2016-04-22 00:00:00		2016-04-27 00:00:00		2016-04-26 00:00:00		2016-04-25 00:00:00		2016-04-27 00:00:00		2016-05-09 00:00:00		2016-05-06 00:00:00		2016-05-11 00:00:00		2016-05-12 00:00:00		2016-06-02 00:00:00		2016-04-27 00:00:00		2016-04-21 00:00:00		2016-04-15 00:00:00		2016-02-01 00:00:00		2016-03-28 00:00:00		2016-05-06 00:00:00		2016-04-02 00:00:00		2016-03-31 00:00:00		2016-04-01 00:00:00		2016-04-06 00:00:00		2016-04-11 00:00:00		2016-04-04 00:00:00		2016-04-12 00:00:00		2015-08-17 00:00:00		2015-07-31 00:00:00		2016-01-21 00:00:00		2016-05-16 00:00:00		2016-05-26 00:00:00		2016-05-21 00:00:00		2016-05-25 00:00:00		2016-05-20 00:00:00		2016-05-25 00:00:00		2016-09-27 00:00:00		2016-10-11 00:00:00		2016-09-28 00:00:00		2016-09-27 00:00:00		2016-10-04 00:00:00		2016-09-30 00:00:00		2016-10-24 00:00:00		2016-09-26 00:00:00		2016-10-07 00:00:00		2016-10-10 00:00:00		2016-09-22 00:00:00		2016-08-15 00:00:00		2016-08-26 00:00:00		2016-08-22 00:00:00		2016-08-25 00:00:00		2016-09-01 00:00:00		2016-09-02 00:00:00		2016-09-02 00:00:00		2016-08-18 00:00:00		2016-08-29 00:00:00		2016-09-13 00:00:00		2016-09-16 00:00:00		2016-09-22 00:00:00		2016-08-12 00:00:00		2016-08-17 00:00:00		2016-08-23 00:00:00		2016-09-09 00:00:00		2016-09-12 00:00:00		2016-07-18 00:00:00		2016-10-25 00:00:00		2016-11-02 00:00:00		2016-09-30 00:00:00		2016-10-14 00:00:00		2016-10-13 00:00:00		2016-10-14 00:00:00		2016-10-17 00:00:00		2016-10-18 00:00:00		2016-10-20 00:00:00		2016-10-14 00:00:00		2017-07-20 00:00:00		2017-01-23 00:00:00		2016-10-31 00:00:00		2016-10-27 00:00:00		2016-11-01 00:00:00		2016-11-03 00:00:00		2016-11-04 00:00:00		2016-11-06 00:00:00		2016-10-24 00:00:00		2016-11-01 00:00:00		2016-11-03 00:00:00		2016-11-04 00:00:00
stmt_type		None		None		None		None		PE		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		SA		SA		None		None		None		PE		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		SA		None		None		None		None		None		None		None		None		None		None		TS		SA		None		None		None		None		None		None		PE		None		None		None
late_rptno		2016-12		2016-15		2016-14		2016-13		None		2016-19		2016-17		2016-20		2016-21		2016-27		2016-16		2016-11		2016-10		1-2016		2016-2		2016-18		2016-5		2016-3		2016-4		2016-7		2016-8		2016-6		2016-9		2015-1		None		None		2016-22		2016-26		2016-24		None		2016-23		2016-25		None		2016-53		2016-48		2016-47		2016-50		2016-49		2016-60		2016-46		2016-51		2016-52		2016-45		2016-29		2016-35		2016-32		2016-34		2016-37		2016-38		2016-39		2016-31		2016-36		2016-42		2016-43		2016-44		2016-28		2016-30		2016-33		2016-40		2016-41		None		2016-61		2016-66		2016-49		2016-55		2016-54		2016-56		2016-57		2016-58		2016-59		2016-55		None		None		2016-63		2016-62		2016-64		2016-67		2016-70		2016-71		None		2016-65		2016-68		2016-69
from_date		None		None		None		None		2016-01-01 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2015-01-01 00:00:00		2015-07-01 00:00:00		None		None		None		2016-04-24 00:00:00		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		2016-05-22 00:00:00		None		None		None		None		None		None		None		None		None		None		2017-01-01 00:00:00		2016-10-23 00:00:00		None		None		None		None		None		None		2016-09-25 00:00:00		None		None		None
thru_date		None		None		None		None		2016-04-23 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2015-06-30 00:00:00		2015-12-31 00:00:00		None		None		None		2016-05-21 00:00:00		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		2016-06-30 00:00:00		None		None		None		None		None		None		None		None		None		None		2017-06-30 00:00:00		2016-12-31 00:00:00		None		None		None		None		None		None		2016-10-22 00:00:00		None		None		None
elect_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_city		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine
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
filer_zip4		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618
filer_phon		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448
filer_fax		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807		949-858-6807
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]		jeneve		[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
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
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
tres_naml		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater		Slater
tres_namf		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen		Jen
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
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
tres_city		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine		Irvine
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		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		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618		92618
tres_phon		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448		949-858-7448
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
tres_email		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cmtte_type		None		None		None		None		C		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		C		C		None		None		None		C		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		C		None		None		None		None		None		None		None		None		None		None		C		C		None		None		None		None		None		None		C		None		None		None
control_yn		None		None		None		None		Y		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Y		Y		None		None		None		Y		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		Y		None		None		None		None		None		None		None		None		None		None		Y		Y		None		None		None		None		None		None		Y		None		None		None
sponsor_yn		None		None		None		None		N		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		N		N		None		None		None		N		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		N		None		None		None		None		None		None		None		None		None		None		N		N		None		None		None		None		None		None		N		None		None		None
primfrm_yn		None		None		None		None		N		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		N		N		None		None		None		N		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		N		None		None		None		None		None		None		None		None		None		None		N		N		None		None		None		None		None		None		N		None		None		None
brdbase_yn		None		None		None		None		N		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		N		N		None		None		None		N		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		N		None		None		None		None		None		None		None		None		None		None		N		N		None		None		None		None		None		None		N		None		None		None
amendexp_1		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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_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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
cand_naml		None		None		None		None		Moorlach		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Moorlach		Moorlach		None		None		None		Moorlach		None		None		Moorlach		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Moorlach		None		None		None		None		None		None		None		None		None		None		Moorlach		Moorlach		None		None		None		None		None		None		Moorlach		None		None		None
cand_namf		None		None		None		None		John		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		John		John		None		None		None		John		None		None		John		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		John		None		None		None		None		None		None		None		None		None		None		John		John		None		None		None		None		None		None		John		None		None		None
cand_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
cand_city		None		None		None		None		Irvine		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Irvine		Irvine		None		None		None		Irvine		None		None		Irvine		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Irvine		None		None		None		None		None		None		None		None		None		None		Irvine		Irvine		None		None		None		None		None		None		Irvine		None		None		None
cand_st		None		None		None		None		CA		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		CA		CA		None		None		None		CA		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		CA		None		None		None		None		None		None		None		None		None		None		CA		CA		None		None		None		None		None		None		CA		None		None		None
cand_zip4		None		None		None		None		92618		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		92618		92618		None		None		None		92618		None		None		92618		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		92618		None		None		None		None		None		None		None		None		None		None		92618		92618		None		None		None		None		None		None		92618		None		None		None
cand_phon		None		None		None		None		949-858-7448		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		949-858-7448		949-858-7448		None		None		None		949-858-7448		None		None		949-858-7448		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		949-858-7448		None		None		None		None		None		None		None		None		None		None		949-858-7448		949-858-7448		None		None		None		None		None		None		949-858-7448		None		None		None
cand_fax		None		None		None		None		949-858-6807		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		949-858-6807		949-858-6807		None		None		None		949-858-6807		None		None		949-858-6807		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		949-858-6807		None		None		None		None		None		None		None		None		None		None		949-858-6807		949-858-6807		None		None		None		None		None		None		949-858-6807		None		None		None
cand_email		None		None		None		None		[email protected]		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		[email protected]		None		None		[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		[email protected]		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		None		None		[email protected]		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
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
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
office_cd		None		None		None		None		SEN		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		SEN		SEN		None		None		None		SEN		None		None		SEN		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		SEN		None		None		None		None		None		None		None		None		None		None		SEN		SEN		None		None		None		None		None		None		SEN		None		None		None
offic_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_cd		None		None		None		None		SEN		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		SEN		SEN		None		None		None		SEN		None		None		SEN		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		SEN		None		None		None		None		None		None		None		None		None		None		SEN		SEN		None		None		None		None		None		None		SEN		None		None		None
juris_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
dist_no		None		None		None		None		37		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		37		37		None		None		None		37		None		None		37		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		37		None		None		None		None		None		None		None		None		None		None		37		37		None		None		None		None		None		None		37		None		None		None
off_s_h_cd		None		None		None		None		H		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		H		H		None		None		None		H		None		None		H		None		None		None		None		None		None		None		None		None		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		H		H		None		None		None		None		None		None		H		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
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
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
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
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
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

Table: cvr_so

filing_id		2010484		2010484
amend_id		0		1
rec_type		CVR		CVR
form_type		F410		F410
filer_id		1376452		1376452
entity_cd		RCP		RCP
filer_naml		Moorlach for Senate 2016		Moorlach for Senate 2016
filer_namf		None		None
filer_namt		None		None
filer_nams		None		None
report_num		000		001
rpt_date		2016-01-21 00:00:00		2016-01-29 00:00:00
qual_cb		X		X
qualfy_dt		2015-04-23 00:00:00		2015-04-23 00:00:00
term_date		None		None
city		Irvine		Irvine
st		CA		CA
zip4		92618		92618
phone		949-858-7448		949-858-7448
county_res		Orange		Orange
county_act		None		None
mail_city		None		None
mail_st		None		None
mail_zip4		None		None
cmte_fax		949-858-6807		949-858-6807
cmte_email		[email protected]		[email protected]
tres_naml		Slater		Slater
tres_namf		Jen		Jen
tres_namt		None		None
tres_nams		None		None
tres_city		Irvine		Irvine
tres_st		CA		CA
tres_zip4		92618		92618
tres_phon		949-858-7448		949-858-7448
actvty_lvl		None		None
com82013yn		None		None
com82013nm		None		None
com82013id		None		None
control_cb		X		X
bank_nam		Bank of America		Bank of America
bank_adr1		26831 Aliso Creek Rd		26831 Aliso Creek Rd
bank_adr2		None		None
bank_city		Aliso Viejo		Aliso Viejo
bank_st		CA		CA
bank_zip4		92656		92656
bank_phon		949-616-7892		949-616-7892
acct_opendt		None		None
surplusdsp		None		None
primfc_cb		None		None
genpurp_cb		None		None
gpc_descr		None		None
sponsor_cb		None		None
brdbase_cb		None		None
smcont_qualdt		None		None

Table: filer_address

filer_id		1376452		1376452
adrid		2385287		2359720
effect_dt		2016-01-29 00:00:00		2015-04-01 00:00:00
add_type		7051		7051
session_id		2015		2015

Table: filer_filings

filer_id		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452
filing_id		1981806		1955686		1967432		1983628		1986033		2013697		2010465		2025559		2025883		2025369		2026446		2010484		2010484		2012068		2014041		2027639		2045940		2044772		2030504		2046515		2033204		2023709		2043109		2025129		2032022		2028805		2027290		2032618		2033152		2034249		2040457		2041721		2041180		2044652		2041011		2040548		2066381		2046670		2049777		2031347		2048865		2060273		2042133		2075466		2069416		2080076		2067868		2073771		2072090		2083159		2073408		2073763		2068301		2070511		2071634		2075945		2072517		2080451		2069931		2070999		2076226		2081915		2078393		2085005		2081396		2083957		2087439		2087021		2089121		2103068		2089121		2094517		2083957		2088449		2089169		2090079		2090801		2097711		2101869		2092443		2082419		2102832		2104256		2105588		2086492		2105182		2095227		2104381		2105019		2092282		2097930		2125739		2103723		2111796		2140292		2173665		2178104		2182924
period_id		221		None		None		None		223		None		223		226		226		226		226		225		225		225		None		226		226		226		226		226		226		225		226		225		226		226		226		226		226		225		226		226		None		226		226		226		None		226		None		226		226		226		226		227		227		227		227		227		227		227		227		227		227		227		227		227		227		227		227		227		227		227		227		228		227		227		228		228		228		228		228		228		227		228		228		228		228		228		228		228		227		228		228		228		228		228		228		228		228		None		227		228		228		None		None		229		None		None
form_id		F460		F410		F410		F460		F497		F410		F460		F497		F497		F497		F497		F410		F410		F497		F460		F497		F497		F497		F497		F460		F497		F497		F497		F497		F497		F497		F497		F497		F497		F460		F497		F497		F460		F497		F497		F497		F460		F497		F460		F497		F497		F460		F497		F497		F497		F497		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		F497		F497		F497		F497		F497		F497		F460		F460		F460		F497		F460		F460		F460		F460		F410
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		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
filing_date		2015-07-31 00:00:00		2015-04-01 00:00:00		2015-05-01 00:00:00		2015-07-30 00:00:00		2015-08-17 00:00:00		2016-01-29 00:00:00		2016-01-29 00:00:00		2016-04-02 00:00:00		2016-04-04 00:00:00		2016-04-01 00:00:00		2016-04-06 00:00:00		2016-01-29 00:00:00		2016-01-29 00:00:00		2016-02-01 00:00:00		2016-01-29 00:00:00		2016-04-12 00:00:00		2016-05-25 00:00:00		2016-05-21 00:00:00		2016-04-21 00:00:00		2016-05-26 00:00:00		2016-04-27 00:00:00		2016-03-28 00:00:00		2016-05-16 00:00:00		2016-03-31 00:00:00		2016-04-25 00:00:00		2016-04-15 00:00:00		2016-04-11 00:00:00		2016-04-26 00:00:00		2016-04-27 00:00:00		2016-04-28 00:00:00		2016-05-06 00:00:00		2016-05-11 00:00:00		2016-04-28 00:00:00		2016-05-20 00:00:00		2016-05-09 00:00:00		2016-05-06 00:00:00		2016-08-01 00:00:00		2016-05-26 00:00:00		2016-05-26 00:00:00		2016-04-22 00:00:00		2016-06-02 00:00:00		2016-07-28 00:00:00		2016-05-12 00:00:00		2016-09-09 00:00:00		2016-08-17 00:00:00		2016-09-22 00:00:00		2016-08-12 00:00:00		2016-09-02 00:00:00		2016-08-26 00:00:00		2016-09-29 00:00:00		2016-09-01 00:00:00		2016-09-02 00:00:00		2016-08-15 00:00:00		2016-08-22 00:00:00		2016-08-25 00:00:00		2016-09-12 00:00:00		2016-08-29 00:00:00		2016-09-22 00:00:00		2016-08-18 00:00:00		2016-08-23 00:00:00		2016-09-13 00:00:00		2016-09-27 00:00:00		2016-09-16 00:00:00		2016-10-04 00:00:00		2016-09-26 00:00:00		2016-09-30 00:00:00		2016-10-11 00:00:00		2016-10-10 00:00:00		2016-10-22 00:00:00		2016-11-01 00:00:00		2016-10-14 00:00:00		2016-10-24 00:00:00		2016-10-18 00:00:00		2016-10-13 00:00:00		2016-10-14 00:00:00		2016-10-17 00:00:00		2016-10-18 00:00:00		2016-10-27 00:00:00		2016-10-31 00:00:00		2016-10-20 00:00:00		2016-09-28 00:00:00		2016-11-01 00:00:00		2016-11-03 00:00:00		2016-11-06 00:00:00		2016-10-07 00:00:00		2016-11-04 00:00:00		2016-10-25 00:00:00		2016-11-03 00:00:00		2016-11-04 00:00:00		2016-09-29 00:00:00		2016-10-27 00:00:00		2017-01-27 00:00:00		2016-11-02 00:00:00		2016-10-27 00:00:00		2017-01-26 00:00:00		2017-07-28 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00
stmnt_type		10001		10005		10006		10005		10001		10006		10001		10001		10001		10001		10001		10001		10002		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10005		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10002		10001		10001		10001		10002		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10005		10005		10001		10003		10003
stmnt_status		11001		11001		11001		11001		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		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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001
session_id		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		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2017
user_id		MDIGRAZIA		DWALKER		TRAMON		MDIGRAZIA		CREYNOLDS		CHATRIDGE		SMCCONNAN		CREYNOLDS		CREYNOLDS		CREYNOLDS		CREYNOLDS		CAFILER		TRAMON		CREYNOLDS		SMCCONNAN		CREYNOLDS		KBANH		KBANH		CREYNOLDS		SARRIAGA		CREYNOLDS		CREYNOLDS		KBANH		CREYNOLDS		CREYNOLDS		CREYNOLDS		CREYNOLDS		CREYNOLDS		CREYNOLDS		CAFILER		CREYNOLDS		CREYNOLDS		SARRIAGA		KBANH		CREYNOLDS		CREYNOLDS		SMCCONNAN		KBANH		SARRIAGA		CREYNOLDS		KBANH		SMCCONNAN		CREYNOLDS		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		CPON		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		GKURIMOT		PDEO		PDEO		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		PDEO		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		RGEREMIA		GKURIMOT		CPON		GPEREZ		CPON		GKURIMOT		GPEREZ		CPON		RPOOJA		RPOOJA		TRAMON
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
fine_audit		11001		11003		11003		11001		11001		11003		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		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		11001		11001		11001		11001		11001		11001		11003		11003		11001		11003		11003		11003		11003		11003
rpt_start		2015-01-01 00:00:00		None		None		2015-01-01 00:00:00		2015-08-17 00:00:00		None		2015-07-01 00:00:00		2016-04-02 00:00:00		2016-04-04 00:00:00		2016-04-01 00:00:00		2016-04-06 00:00:00		2016-01-21 00:00:00		2016-01-29 00:00:00		2016-02-01 00:00:00		2015-07-01 00:00:00		2016-04-12 00:00:00		2016-05-25 00:00:00		2016-05-21 00:00:00		2016-04-21 00:00:00		2016-04-24 00:00:00		2016-04-27 00:00:00		2016-03-28 00:00:00		2016-05-16 00:00:00		2016-03-31 00:00:00		2016-04-25 00:00:00		2016-04-15 00:00:00		2016-04-11 00:00:00		2016-04-26 00:00:00		2016-04-27 00:00:00		2016-01-01 00:00:00		2016-05-06 00:00:00		2016-05-11 00:00:00		2016-01-01 00:00:00		2016-05-20 00:00:00		2016-05-09 00:00:00		2016-05-06 00:00:00		2016-05-22 00:00:00		2016-05-26 00:00:00		2016-04-24 00:00:00		2016-04-22 00:00:00		2016-06-02 00:00:00		2016-05-22 00:00:00		2016-05-12 00:00:00		2016-09-09 00:00:00		2016-08-17 00:00:00		2016-09-22 00:00:00		2016-08-12 00:00:00		2016-09-02 00:00:00		2016-08-26 00:00:00		2016-07-01 00:00:00		2016-09-01 00:00:00		2016-09-02 00:00:00		2016-08-15 00:00:00		2016-08-22 00:00:00		2016-08-25 00:00:00		2016-09-12 00:00:00		2016-08-29 00:00:00		2016-09-22 00:00:00		2016-08-18 00:00:00		2016-08-23 00:00:00		2016-09-13 00:00:00		2016-09-27 00:00:00		2016-09-16 00:00:00		2016-10-04 00:00:00		2016-09-26 00:00:00		2016-09-30 00:00:00		2016-10-11 00:00:00		2016-10-10 00:00:00		2016-10-14 00:00:00		2016-11-01 00:00:00		2016-10-14 00:00:00		2016-10-24 00:00:00		2016-09-30 00:00:00		2016-10-13 00:00:00		2016-10-14 00:00:00		2016-10-17 00:00:00		2016-10-18 00:00:00		2016-10-27 00:00:00		2016-10-31 00:00:00		2016-10-20 00:00:00		2016-09-28 00:00:00		2016-11-01 00:00:00		2016-11-03 00:00:00		2016-11-06 00:00:00		2016-10-07 00:00:00		2016-11-04 00:00:00		2016-10-25 00:00:00		2016-11-03 00:00:00		2016-11-04 00:00:00		2016-07-01 00:00:00		2016-09-25 00:00:00		2016-10-23 00:00:00		2016-11-02 00:00:00		2016-09-25 00:00:00		2016-10-23 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		None
rpt_end		2015-06-30 00:00:00		None		None		2015-06-30 00:00:00		2015-08-17 00:00:00		None		2015-12-31 00:00:00		2016-04-02 00:00:00		2016-04-04 00:00:00		2016-04-01 00:00:00		2016-04-06 00:00:00		2016-01-21 00:00:00		2016-01-29 00:00:00		2016-02-01 00:00:00		2015-12-31 00:00:00		2016-04-12 00:00:00		2016-05-25 00:00:00		2016-05-21 00:00:00		2016-04-21 00:00:00		2016-05-21 00:00:00		2016-04-27 00:00:00		2016-03-28 00:00:00		2016-05-16 00:00:00		2016-03-31 00:00:00		2016-04-25 00:00:00		2016-04-15 00:00:00		2016-04-11 00:00:00		2016-04-26 00:00:00		2016-04-27 00:00:00		2016-04-23 00:00:00		2016-05-06 00:00:00		2016-05-11 00:00:00		2016-04-23 00:00:00		2016-05-20 00:00:00		2016-05-09 00:00:00		2016-05-06 00:00:00		2016-06-30 00:00:00		2016-05-26 00:00:00		2016-05-21 00:00:00		2016-04-22 00:00:00		2016-06-02 00:00:00		2016-06-30 00:00:00		2016-05-12 00:00:00		2016-09-09 00:00:00		2016-08-17 00:00:00		2016-09-22 00:00:00		2016-08-12 00:00:00		2016-09-02 00:00:00		2016-08-26 00:00:00		2016-09-24 00:00:00		2016-09-01 00:00:00		2016-09-02 00:00:00		2016-08-15 00:00:00		2016-08-22 00:00:00		2016-08-25 00:00:00		2016-09-12 00:00:00		2016-08-29 00:00:00		2016-09-22 00:00:00		2016-08-18 00:00:00		2016-08-23 00:00:00		2016-09-13 00:00:00		2016-09-27 00:00:00		2016-09-16 00:00:00		2016-10-04 00:00:00		2016-09-26 00:00:00		2016-09-30 00:00:00		2016-10-11 00:00:00		2016-10-10 00:00:00		2016-10-14 00:00:00		2016-11-01 00:00:00		2016-10-14 00:00:00		2016-10-24 00:00:00		2016-09-30 00:00:00		2016-10-13 00:00:00		2016-10-14 00:00:00		2016-10-17 00:00:00		2016-10-18 00:00:00		2016-10-27 00:00:00		2016-10-31 00:00:00		2016-10-20 00:00:00		2016-09-28 00:00:00		2016-11-01 00:00:00		2016-11-03 00:00:00		2016-11-06 00:00:00		2016-10-07 00:00:00		2016-11-04 00:00:00		2016-10-25 00:00:00		2016-11-03 00:00:00		2016-11-04 00:00:00		2016-09-24 00:00:00		2016-10-22 00:00:00		2016-12-31 00:00:00		2016-11-02 00:00:00		2016-10-22 00:00:00		2016-12-31 00:00:00		2017-06-30 00:00:00		2017-06-30 00:00:00		None
rpt_date		2015-07-31 00:00:00		None		None		None		2015-08-17 00:00:00		None		2016-01-21 00:00:00		2016-04-02 00:00:00		2016-04-04 00:00:00		2016-04-01 00:00:00		2016-04-06 00:00:00		None		None		2016-02-01 00:00:00		None		2016-04-12 00:00:00		2016-05-25 00:00:00		2016-05-21 00:00:00		2016-04-21 00:00:00		2016-05-25 00:00:00		2016-04-27 00:00:00		2016-03-28 00:00:00		2016-05-16 00:00:00		2016-03-31 00:00:00		2016-04-25 00:00:00		2016-04-15 00:00:00		2016-04-11 00:00:00		2016-04-26 00:00:00		2016-04-27 00:00:00		2016-04-27 00:00:00		2016-05-06 00:00:00		2016-05-11 00:00:00		None		2016-05-20 00:00:00		2016-05-09 00:00:00		2016-05-06 00:00:00		None		2016-05-26 00:00:00		None		2016-04-22 00:00:00		2016-06-02 00:00:00		2016-07-18 00:00:00		2016-05-12 00:00:00		2016-09-09 00:00:00		2016-08-17 00:00:00		2016-09-22 00:00:00		2016-08-12 00:00:00		2016-09-02 00:00:00		2016-08-26 00:00:00		2016-09-27 00:00:00		2016-09-01 00:00:00		2016-09-02 00:00:00		2016-08-15 00:00:00		2016-08-22 00:00:00		2016-08-25 00:00:00		2016-09-12 00:00:00		2016-08-29 00:00:00		2016-09-22 00:00:00		2016-08-18 00:00:00		2016-08-23 00:00:00		2016-09-13 00:00:00		2016-09-27 00:00:00		2016-09-16 00:00:00		2016-10-04 00:00:00		2016-09-26 00:00:00		2016-09-30 00:00:00		2016-10-11 00:00:00		2016-10-10 00:00:00		2016-10-14 00:00:00		2016-11-01 00:00:00		2016-10-14 00:00:00		2016-10-24 00:00:00		2016-09-30 00:00:00		2016-10-13 00:00:00		2016-10-14 00:00:00		2016-10-17 00:00:00		2016-10-18 00:00:00		2016-10-27 00:00:00		2016-10-31 00:00:00		2016-10-20 00:00:00		2016-09-28 00:00:00		2016-11-01 00:00:00		2016-11-03 00:00:00		2016-11-06 00:00:00		2016-10-07 00:00:00		2016-11-04 00:00:00		2016-10-25 00:00:00		2016-11-03 00:00:00		2016-11-04 00:00:00		None		2016-10-24 00:00:00		2017-01-23 00:00:00		2016-11-02 00:00:00		None		None		2017-07-20 00:00:00		None		None
filing_type		22001		None		None		None		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		None		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		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		None		None		22001		None		None

Table: filer_to_filer_type

filer_id		1376452		1376452		1376452
filer_type		16		16		16
active		Y		Y		T
race		0		0		0
session_id		2015		2015		2017
category		40002		40002		40002
category_type		40502		40502		40502
sub_category		0		0		0
effect_dt		2015-05-01 00:00:00		2015-04-01 00:00:00		2017-06-30 00:00:00
sub_category_type		0		0		0
election_type		0		0		0
sub_category_a		None		None		None
nyq_dt		2015-04-23 00:00:00		None		2015-04-23 00:00:00
party_cd		16002		16002		16002
county_cd		18036		18036		18036
district_cd		0		0		0

Table: filer_xref

filer_id		1376452
xref_id		1376452
effect_dt		2015-04-02 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1376452		1376452
filer_id		1376452		1376452
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		TERMINATED		TERMINATED
effect_dt		2017-06-30 00:00:00		2017-06-30 00:00:00
naml		MOORLACH FOR SENATE 2016		MOORLACH FOR SENATE 2016
namf		None		None
namt		None		None
nams		None		None
adr1		None		None
adr2		None		None
city		IRVINE		IRVINE
st		CA		CA
zip4		92618		92618
phon		9498587448		9498587448
fax		9498586807		9498586807
email		[email protected]		[email protected]

Table: filers

filer_id		1376452

Table: received_filings

filer_id		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452		1376452
filing_file_name		196570.cal		517125.cal		2069416_0.cal		2072517_0.cal		2044652_0.cal		2044772_0.cal		2046670_0.cal		2048865_0.cal		407014.cal		2012068_0.cal		2105182_0.cal		2102832_0.cal		2104381_0.cal		2103068_0.cal		2104256_0.cal		2105588_0.cal		2103723_0.cal		2105019_0.cal		2078393_0.cal		2080076_0.cal		2081396_0.cal		2101869_0.cal		2087021_0.cal		2080451_0.cal		2087439_0.cal		2081915_0.cal		2082419_0.cal		2085005_0.cal		2028805_0.cal		2027639_0.cal		2026446_0.cal		2041011_0.cal		2025559_0.cal		2025129_0.cal		2027290_0.cal		2030504_0.cal		2025369_0.cal		2023709_0.cal		2095227_0.cal		2089169_0.cal		2090079_0.cal		2090801_0.cal		2097711_0.cal		2089121_1.cal		2089121_0.cal		2092443_0.cal		2094517_0.cal		2071634_0.cal		2073771_0.cal		2076226_0.cal		2067868_0.cal		2086492_0.cal		2070511_0.cal		2088449_0.cal		2068301_0.cal		2072090_0.cal		2069931_0.cal		2073408_0.cal		2075945_0.cal		2075466_0.cal		2073763_0.cal		2042133_0.cal		2041721_0.cal		2040457_0.cal		2040548_0.cal		2033152_0.cal		2033204_0.cal		2043109_0.cal		2031347_0.cal		2032022_0.cal
received_date		2015-07-31 00:00:00		2017-07-28 00:00:00		2016-08-17 00:00:00		2016-08-29 00:00:00		2016-05-20 00:00:00		2016-05-21 00:00:00		2016-05-26 00:00:00		2016-06-02 00:00:00		2016-01-29 00:00:00		2016-02-01 00:00:00		2016-11-04 00:00:00		2016-11-01 00:00:00		2016-11-03 00:00:00		2016-11-01 00:00:00		2016-11-03 00:00:00		2016-11-06 00:00:00		2016-11-02 00:00:00		2016-11-04 00:00:00		2016-09-16 00:00:00		2016-09-22 00:00:00		2016-09-26 00:00:00		2016-10-31 00:00:00		2016-10-10 00:00:00		2016-09-22 00:00:00		2016-10-11 00:00:00		2016-09-27 00:00:00		2016-09-28 00:00:00		2016-10-04 00:00:00		2016-04-15 00:00:00		2016-04-12 00:00:00		2016-04-06 00:00:00		2016-05-09 00:00:00		2016-04-02 00:00:00		2016-03-31 00:00:00		2016-04-11 00:00:00		2016-04-21 00:00:00		2016-04-01 00:00:00		2016-03-28 00:00:00		2016-10-25 00:00:00		2016-10-14 00:00:00		2016-10-17 00:00:00		2016-10-18 00:00:00		2016-10-27 00:00:00		2016-10-22 00:00:00		2016-10-14 00:00:00		2016-10-20 00:00:00		2016-10-24 00:00:00		2016-08-25 00:00:00		2016-09-02 00:00:00		2016-09-13 00:00:00		2016-08-12 00:00:00		2016-10-07 00:00:00		2016-08-22 00:00:00		2016-10-13 00:00:00		2016-08-15 00:00:00		2016-08-26 00:00:00		2016-08-18 00:00:00		2016-09-01 00:00:00		2016-09-12 00:00:00		2016-09-09 00:00:00		2016-09-02 00:00:00		2016-05-12 00:00:00		2016-05-11 00:00:00		2016-05-06 00:00:00		2016-05-06 00:00:00		2016-04-27 00:00:00		2016-04-27 00:00:00		2016-05-16 00:00:00		2016-04-22 00:00:00		2016-04-25 00:00:00
filing_directory		/cafiler/disclose/ca99/temp		/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/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/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		None		None		2069416		2072517		2044652		2044772		2046670		2048865		None		2012068		2105182		2102832		2104381		2103068		2104256		2105588		2103723		2105019		2078393		2080076		2081396		2101869		2087021		2080451		2087439		2081915		2082419		2085005		2028805		2027639		2026446		2041011		2025559		2025129		2027290		2030504		2025369		2023709		2095227		2089169		2090079		2090801		2097711		2089121		2089121		2092443		2094517		2071634		2073771		2076226		2067868		2086492		2070511		2088449		2068301		2072090		2069931		2073408		2075945		2075466		2073763		2042133		2041721		2040457		2040548		2033152		2033204		2043109		2031347		2032022
form_id		None		None		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		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497
receive_comment		Filing did not pass validation		Filing passed validation, but failed DB constraints		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 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