Home

Filer ID: 1374752

Table: cvr_campaign_disclosure

filing_id		1973014		1967944		1973014		2047368		2032571		2031612		2045406		2034566		2033175		2035797		2031452		2039784		2039501		2041675		2042107		2042587		2029252		2029260		2012464		2019681		2021659		2023038		2025451		2025673		2026854		2022333		2024207		2028512		2037860		2027575		2028008		2027140		1982244		2020136		2002039		2044443		2043007		2048414		2044543		2042995		2043273		2043806		2046632		2045918		2046510		2081028		2081140		2082250		2083412		2083892		2083011		2093100		2082254		2083011		2086443		2084253		2084998		2071665		2070539		2070527		2072481		2072483		2073013		2068334		2071360		2068941		2074647		2076988		2076252		2078360		2078867		2079634		2072591		2072483		2073212		2075801		2075128		2049864		2050106		2050307		2050308		2051263		2072395		2050674		2063815		2065952		2067138		2076259		2097477		2097563		2095734		2103623		2088530		2089452		2090576		2104712		2090593		2092539		2091805		2092049		2093899		2093750		2094765		2129489		2100200		2097944		2104651		2105585		2106289		2103150		2098871		2105035		2181265
amend_id		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		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		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		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		F497		F497		F497		F460		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F460		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F460		F497		F497		F497		F497		F497		F497		F497		F497		F497		F460		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		F460		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F460		F497		F460		F497		F497		F497		F497		F497		F497		F460
filer_id		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752
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		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		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016
filer_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		001		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		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		001		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000
rpt_date		2015-07-06 00:00:00		2015-05-11 00:00:00		2015-07-14 00:00:00		2016-05-27 00:00:00		2016-04-26 00:00:00		2016-04-23 00:00:00		2016-05-24 00:00:00		2016-04-25 00:00:00		2016-04-27 00:00:00		2016-04-29 00:00:00		2016-04-22 00:00:00		2016-05-05 00:00:00		2016-05-04 00:00:00		2016-05-11 00:00:00		2016-05-12 00:00:00		2016-05-13 00:00:00		2016-04-18 00:00:00		2016-04-18 00:00:00		2016-01-13 00:00:00		2016-03-10 00:00:00		2016-03-21 00:00:00		2016-03-24 00:00:00		2016-04-01 00:00:00		2016-04-04 00:00:00		2016-04-08 00:00:00		2016-03-22 00:00:00		2016-03-29 00:00:00		2016-04-14 00:00:00		2016-05-02 00:00:00		2016-04-12 00:00:00		2016-04-13 00:00:00		2016-04-10 00:00:00		2015-07-17 00:00:00		2016-03-11 00:00:00		2015-12-30 00:00:00		2016-05-20 00:00:00		2016-05-16 00:00:00		2016-06-01 00:00:00		2016-05-20 00:00:00		2016-05-16 00:00:00		2016-05-17 00:00:00		2016-05-18 00:00:00		2016-05-23 00:00:00		2016-05-25 00:00:00		2016-05-26 00:00:00		2016-09-24 00:00:00		2016-09-25 00:00:00		2016-09-28 00:00:00		2016-09-25 00:00:00		2016-09-30 00:00:00		2016-09-30 00:00:00		2016-10-21 00:00:00		2016-09-28 00:00:00		2016-09-29 00:00:00		2016-10-07 00:00:00		2016-10-02 00:00:00		2016-10-04 00:00:00		2016-08-25 00:00:00		2016-08-22 00:00:00		2016-08-22 00:00:00		2016-08-29 00:00:00		2016-08-29 00:00:00		2016-08-31 00:00:00		2016-08-15 00:00:00		2016-08-24 00:00:00		2016-08-16 00:00:00		2016-09-07 00:00:00		2016-09-14 00:00:00		2016-09-13 00:00:00		2016-09-16 00:00:00		2016-09-19 00:00:00		2016-09-21 00:00:00		2016-08-29 00:00:00		2016-08-29 00:00:00		2016-08-31 00:00:00		2016-09-12 00:00:00		2016-09-08 00:00:00		2016-06-06 00:00:00		2016-06-07 00:00:00		2016-06-07 00:00:00		2016-06-07 00:00:00		2016-06-13 00:00:00		2016-08-27 00:00:00		2016-06-08 00:00:00		2016-07-20 00:00:00		2016-08-05 00:00:00		2016-08-10 00:00:00		2016-09-13 00:00:00		2016-10-27 00:00:00		2016-10-27 00:00:00		2016-10-25 00:00:00		2016-11-02 00:00:00		2016-10-13 00:00:00		2016-10-15 00:00:00		2016-10-18 00:00:00		2016-11-03 00:00:00		2016-10-18 00:00:00		2016-10-20 00:00:00		2016-10-19 00:00:00		2016-10-19 00:00:00		2016-10-23 00:00:00		2016-10-22 00:00:00		2016-10-24 00:00:00		2017-01-25 00:00:00		2016-10-29 00:00:00		2016-10-24 00:00:00		2016-11-03 00:00:00		2016-11-06 00:00:00		2016-11-08 00:00:00		2016-11-01 00:00:00		2016-10-28 00:00:00		2016-11-04 00:00:00		2017-08-21 00:00:00
stmt_type		None		None		None		None		None		None		None		PE		None		None		None		None		None		None		None		None		None		None		SA		None		None		None		None		None		None		None		None		None		None		None		None		None		SA		None		None		None		None		None		None		None		None		None		PE		None		None		None		None		None		PE		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		PE		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		SA		None		PE		None		None		None		None		None		None		TS
late_rptno		15-2		15-1		15-2		16-36		16-18		16-17		16-33		None		16-19		16-20		16-16		16-23		16-22		16-24		16-25		16-26		16-14		16-15		None		16-1		16-3		16-5		16-7		16-8		16-9		16-4		16-6		16-13		16-21		16-11		16-12		16-10		None		16-2		15-3		16-31		16-28		16-37		16-32		16-27		16-29		16-30		None		16-34		16-35		16-66		16-67		16-68		None		16-71		16-70		16-82		16-69		16-70		16-74		16-72		16-73		16-51		16-49		16-48		16-53		16-54		16-55		16-46		16-50		16-47		16-57		16-62		16-60		16-63		16-64		16-65		16-55		16-54		16-56		16-59		16-58		16-38		16-39		16-40		16-41		16-43		16-52		16-42		None		16-44		16-45		16-61		16-87		16-88		16-86		16-92		16-75		16-76		16-77		16-94		16-78		16-81		16-79		16-80		16-84		16-83		16-8/5		None		16-90		None		16-93		16-96		16-97		16-91		16-89		16-95		None
from_date		None		None		None		None		None		None		None		2016-01-01 00:00:00		None		None		None		None		None		None		None		None		None		None		2015-07-01 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		2015-01-01 00:00:00		None		None		None		None		None		None		None		None		None		2016-04-24 00:00:00		None		None		None		None		None		2016-07-01 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2016-05-22 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2016-10-23 00:00:00		None		2016-09-25 00:00:00		None		None		None		None		None		None		2017-01-01 00:00:00
thru_date		None		None		None		None		None		None		None		2016-04-23 00:00:00		None		None		None		None		None		None		None		None		None		None		2015-12-31 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		2015-06-30 00:00:00		None		None		None		None		None		None		None		None		None		2016-05-21 00:00:00		None		None		None		None		None		2016-09-24 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2016-06-30 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2016-12-31 00:00:00		None		2016-10-22 00:00:00		None		None		None		None		None		None		2017-03-01 00:00:00
elect_date		None		None		None		None		None		None		None		2016-06-07 00:00:00		None		None		None		None		None		None		None		None		None		None		2016-06-07 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		2016-06-07 00:00:00		None		None		None		None		None		None		None		None		None		2016-06-07 00:00:00		None		None		None		None		None		2016-06-07 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2016-06-07 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2016-06-07 00:00:00		None		2016-06-07 00:00:00		None		None		None		None		None		None		2016-06-07 00:00:00
filer_city		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona		Corona
filer_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		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		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882		92882
filer_phon		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722		951-223-6722
filer_fax		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
file_email		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[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		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana
mail_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
mail_zip4		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705
tres_naml		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray		Ray
tres_namf		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa		Lysa
tres_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_city		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana		Santa Ana
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		CA		CA		CA		CA		CA		CA		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		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705		92705
tres_phon		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295		714-540-2295
tres_fax		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cmtte_type		None		None		None		None		None		None		None		C		None		None		None		None		None		None		None		None		None		None		C		None		None		None		None		None		None		None		None		None		None		None		None		None		C		None		None		None		None		None		None		None		None		None		C		None		None		None		None		None		C		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		C		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		C		None		C		None		None		None		None		None		None		C
control_yn		None		None		None		None		None		None		None		Y		None		None		None		None		None		None		None		None		None		None		Y		None		None		None		None		None		None		None		None		None		None		None		None		None		Y		None		None		None		None		None		None		None		None		None		Y		None		None		None		None		None		Y		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Y		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Y		None		Y		None		None		None		None		None		None		Y
sponsor_yn		None		None		None		None		None		None		None		N		None		None		None		None		None		None		None		None		None		None		N		None		None		None		None		None		None		None		None		None		None		None		None		None		N		None		None		None		None		None		None		None		None		None		N		None		None		None		None		None		N		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		N		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		N		None		N		None		None		None		None		None		None		N
primfrm_yn		None		None		None		None		None		None		None		N		None		None		None		None		None		None		None		None		None		None		N		None		None		None		None		None		None		None		None		None		None		None		None		None		N		None		None		None		None		None		None		None		None		None		N		None		None		None		None		None		N		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		N		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		N		None		N		None		None		None		None		None		None		N
brdbase_yn		None		None		None		None		None		None		None		N		None		None		None		None		None		None		None		None		None		None		N		None		None		None		None		None		None		None		None		None		None		None		None		None		N		None		None		None		None		None		None		None		None		None		N		None		None		None		None		None		N		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		N		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		N		None		N		None		None		None		None		None		None		N
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		Typo on CRP amount		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
amendexp_3		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rpt_att_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cmtte_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
reportname		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rptfromdt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rptthrudt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
emplbus_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_name		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_inter		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
busact_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
busactvity		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
assoc_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
assoc_int		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
other_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
other_int		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_naml		None		None		None		None		None		None		None		Linder		None		None		None		None		None		None		None		None		None		None		Linder		None		None		None		None		None		None		None		None		None		None		None		None		None		Linder		None		None		None		None		None		None		None		None		None		Linder		None		None		None		None		None		Linder		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Linder		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Linder		None		Linder		None		None		None		None		None		None		Linder
cand_namf		None		None		None		None		None		None		None		Eric		None		None		None		None		None		None		None		None		None		None		Eric		None		None		None		None		None		None		None		None		None		None		None		None		None		Eric		None		None		None		None		None		None		None		None		None		Eric		None		None		None		None		None		Eric		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Eric		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Eric		None		Eric		None		None		None		None		None		None		Eric
cand_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_city		None		None		None		None		None		None		None		Corona		None		None		None		None		None		None		None		None		None		None		Corona		None		None		None		None		None		None		None		None		None		None		None		None		None		Corona		None		None		None		None		None		None		None		None		None		Corona		None		None		None		None		None		Corona		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Corona		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Corona		None		Corona		None		None		None		None		None		None		Corona
cand_st		None		None		None		None		None		None		None		CA		None		None		None		None		None		None		None		None		None		None		CA		None		None		None		None		None		None		None		None		None		None		None		None		None		CA		None		None		None		None		None		None		None		None		None		CA		None		None		None		None		None		CA		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		CA		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		CA		None		CA		None		None		None		None		None		None		CA
cand_zip4		None		None		None		None		None		None		None		92882		None		None		None		None		None		None		None		None		None		None		92882		None		None		None		None		None		None		None		None		None		None		None		None		None		92882		None		None		None		None		None		None		None		None		None		92882		None		None		None		None		None		92882		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		92882		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		92882		None		92882		None		None		None		None		None		None		92882
cand_phon		None		None		None		None		None		None		None		714-867-7096		None		None		None		None		None		None		None		None		None		None		714-867-7096		None		None		None		None		None		None		None		None		None		None		None		None		None		714-867-7096		None		None		None		None		None		None		None		None		None		714-867-7096		None		None		None		None		None		714-867-7096		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		714-867-7096		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		714-867-7096		None		714-867-7096		None		None		None		None		None		None		714-867-7096
cand_fax		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_email		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_name		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_num		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_juris		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
office_cd		None		None		None		None		None		None		None		ASM		None		None		None		None		None		None		None		None		None		None		ASM		None		None		None		None		None		None		None		None		None		None		None		None		None		ASM		None		None		None		None		None		None		None		None		None		ASM		None		None		None		None		None		ASM		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		ASM		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		ASM		None		ASM		None		None		None		None		None		None		ASM
offic_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_cd		None		None		None		None		None		None		None		ASM		None		None		None		None		None		None		None		None		None		None		ASM		None		None		None		None		None		None		None		None		None		None		None		None		None		ASM		None		None		None		None		None		None		None		None		None		ASM		None		None		None		None		None		ASM		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		ASM		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		ASM		None		ASM		None		None		None		None		None		None		ASM
juris_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
dist_no		None		None		None		None		None		None		None		60		None		None		None		None		None		None		None		None		None		None		60		None		None		None		None		None		None		None		None		None		None		None		None		None		60		None		None		None		None		None		None		None		None		None		60		None		None		None		None		None		60		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		60		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		60		None		60		None		None		None		None		None		None		60
off_s_h_cd		None		None		None		None		None		None		None		H		None		None		None		None		None		None		None		None		None		None		H		None		None		None		None		None		None		None		None		None		None		None		None		None		H		None		None		None		None		None		None		None		None		None		H		None		None		None		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		None		None		None		None		None		None		None		None		H		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		H		None		H		None		None		None		None		None		None		H
sup_opp_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
employer		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
occupation		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
selfemp_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		1973730		1973730
amend_id		1		0
rec_type		CVR		CVR
form_type		F410		F410
filer_id		1374752		1374752
entity_cd		RCP		RCP
filer_naml		Eric Linder for Assembly 2016		Eric Linder for Assembly 2016
filer_namf		None		None
filer_namt		None		None
filer_nams		None		None
report_num		001		000
rpt_date		2015-07-10 00:00:00		2015-07-10 00:00:00
qual_cb		X		X
qualfy_dt		2015-02-02 00:00:00		2015-02-02 00:00:00
term_date		None		None
city		Corona		Corona
st		CA		CA
zip4		92882		92882
phone		951-223-6722		951-223-6722
county_res		Riverside		Riverside
county_act		Riverside		Riverside
mail_city		Santa Ana		Santa Ana
mail_st		CA		CA
mail_zip4		92705		92705
cmte_fax		None		None
cmte_email		[email protected]		[email protected]
tres_naml		Ray		Ray
tres_namf		Lysa		Lysa
tres_namt		None		None
tres_nams		None		None
tres_city		Santa Ana		Santa Ana
tres_st		CA		CA
tres_zip4		92705		92705
tres_phon		714-540-2295		714-540-2295
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		3730 Bristol St		3730 Bristol St
bank_adr2		None		None
bank_city		Santa Ana		Santa Ana
bank_st		CA		CA
bank_zip4		92705		92705
bank_phon		714-973-1000		714-973-1000
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		1374752		1374752		1374752
adrid		2372631		2372630		2349620
effect_dt		2015-08-04 00:00:00		2015-08-04 00:00:00		2015-01-23 00:00:00
add_type		7082		7051		7051
session_id		2015		2015		2015

Table: filer_filings

filer_id		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752
filing_id		1973014		1973730		1967944		1973730		1973014		1929800		1988923		2002039		1982244		1985511		1985142		2019426		2019681		2023038		2025673		2025451		2024207		2022333		2012464		2045406		2046510		2020136		2045918		2027575		2046632		2021659		2027140		2043007		2037860		2029252		2029260		2028512		2031612		2028008		2032571		2041675		2039501		2033175		2039784		2042995		2043273		2035797		2042587		2044443		2044543		2026854		2043806		2067138		2065952		2048414		2031452		2047368		2049864		2050307		2050308		2051263		2050106		2034285		2034566		2050674		2042107		2063815		2050833		2065609		2074647		2075128		2075801		2072591		2072483		2073212		2084998		2072483		2072395		2071665		2072481		2082254		2083011		2070539		2076252		2070527		2073013		2078867		2068941		2071360		2082250		2068334		2078360		2083412		2079634		2086443		2084253		2086250		2083892		2083011		2076259		2090576		2093899		2088530		2089452		2091805		2093750		2094765		2090593		2092539		2097944		2097563		2076988		2097477		2100200		2081028		2081140		2104651		2104712		2106289		2105585		2103150		2095734		2105035		2092049		2098871		2129489		2103623		2108512		2093100		2139648		2186877		2181265		2187138
period_id		223		223		222		223		223		None		None		224		221		None		None		None		225		225		226		226		225		225		223		226		226		225		226		226		226		225		226		226		226		226		226		226		226		226		226		226		226		226		226		226		226		226		226		226		226		226		226		227		227		226		226		226		226		226		226		226		226		None		225		226		226		226		None		None		227		227		227		227		227		227		228		227		227		227		227		227		227		227		227		227		227		227		227		227		227		227		227		227		227		228		228		None		227		227		227		228		228		228		228		228		228		228		228		228		227		228		227		228		228		227		227		228		228		228		228		228		228		228		228		228		228		228		None		228		None		None		229		None
form_id		F497		F410		F497		F410		F497		F410		F410		F497		F460		F410		F460		F460		F497		F497		F497		F497		F497		F497		F460		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		F460		F460		F497		F497		F460		F460		F460		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		F460		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F460		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F460		F497		F460		F497		F460		F410		F460		F460
filing_sequence		0		1		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		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		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
filing_date		2015-07-06 00:00:00		2015-07-10 00:00:00		2015-05-11 00:00:00		2015-07-10 00:00:00		2015-07-14 00:00:00		2015-01-23 00:00:00		2015-09-08 00:00:00		2015-12-30 00:00:00		2015-07-31 00:00:00		2015-08-04 00:00:00		2015-07-30 00:00:00		2016-02-01 00:00:00		2016-03-10 00:00:00		2016-03-24 00:00:00		2016-04-04 00:00:00		2016-04-01 00:00:00		2016-03-29 00:00:00		2016-03-22 00:00:00		2016-02-01 00:00:00		2016-05-24 00:00:00		2016-05-26 00:00:00		2016-03-11 00:00:00		2016-05-25 00:00:00		2016-04-12 00:00:00		2016-05-26 00:00:00		2016-03-21 00:00:00		2016-04-10 00:00:00		2016-05-16 00:00:00		2016-05-02 00:00:00		2016-04-18 00:00:00		2016-04-18 00:00:00		2016-04-14 00:00:00		2016-04-23 00:00:00		2016-04-13 00:00:00		2016-04-26 00:00:00		2016-05-11 00:00:00		2016-05-04 00:00:00		2016-04-27 00:00:00		2016-05-05 00:00:00		2016-05-16 00:00:00		2016-05-17 00:00:00		2016-04-29 00:00:00		2016-05-13 00:00:00		2016-05-20 00:00:00		2016-05-20 00:00:00		2016-04-08 00:00:00		2016-05-18 00:00:00		2016-08-10 00:00:00		2016-08-05 00:00:00		2016-06-01 00:00:00		2016-04-22 00:00:00		2016-05-27 00:00:00		2016-06-06 00:00:00		2016-06-07 00:00:00		2016-06-07 00:00:00		2016-06-13 00:00:00		2016-06-07 00:00:00		2016-04-27 00:00:00		2016-04-28 00:00:00		2016-06-08 00:00:00		2016-05-12 00:00:00		2016-08-01 00:00:00		2016-05-26 00:00:00		2016-08-01 00:00:00		2016-09-07 00:00:00		2016-09-08 00:00:00		2016-09-12 00:00:00		2016-08-29 00:00:00		2016-08-29 00:00:00		2016-08-31 00:00:00		2016-10-04 00:00:00		2016-08-29 00:00:00		2016-08-27 00:00:00		2016-08-25 00:00:00		2016-08-29 00:00:00		2016-09-28 00:00:00		2016-09-29 00:00:00		2016-08-22 00:00:00		2016-09-13 00:00:00		2016-08-22 00:00:00		2016-08-31 00:00:00		2016-09-19 00:00:00		2016-08-16 00:00:00		2016-08-24 00:00:00		2016-09-28 00:00:00		2016-08-15 00:00:00		2016-09-16 00:00:00		2016-09-29 00:00:00		2016-09-21 00:00:00		2016-10-07 00:00:00		2016-10-02 00:00:00		2016-09-29 00:00:00		2016-09-30 00:00:00		2016-09-30 00:00:00		2016-09-13 00:00:00		2016-10-18 00:00:00		2016-10-23 00:00:00		2016-10-13 00:00:00		2016-10-15 00:00:00		2016-10-19 00:00:00		2016-10-22 00:00:00		2016-10-24 00:00:00		2016-10-18 00:00:00		2016-10-20 00:00:00		2016-10-27 00:00:00		2016-10-27 00:00:00		2016-09-14 00:00:00		2016-10-27 00:00:00		2016-10-29 00:00:00		2016-09-24 00:00:00		2016-09-25 00:00:00		2016-11-03 00:00:00		2016-11-03 00:00:00		2016-11-08 00:00:00		2016-11-06 00:00:00		2016-11-01 00:00:00		2016-10-25 00:00:00		2016-11-04 00:00:00		2016-10-19 00:00:00		2016-10-28 00:00:00		2017-01-31 00:00:00		2016-11-02 00:00:00		2016-10-27 00:00:00		2016-10-21 00:00:00		2017-01-31 00:00:00		2017-10-04 00:00:00		2017-08-21 00:00:00		2017-10-02 00:00:00
stmnt_type		10001		10002		10001		10001		10002		10005		10006		10001		10001		10006		10005		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		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10005		10005		10001		10001		10001		10001		10002		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10002		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		10005		10001		10005		10003		10001		10003
stmnt_status		11001		11001		11003		11003		11001		11003		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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		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		GKURIMOT		TRAMON		CAFILER		CAFILER		GKURIMOT		CPON		TRAMON		GKURIMOT		MDIGRAZIA		TRAMON		MDIGRAZIA		LPALMER		KBANH		KBANH		KBANH		KBANH		KBANH		KBANH		CAFILER		KBANH		KBANH		KBANH		KBANH		KBANH		SMCCONNAN		KBANH		KBANH		KBANH		KBANH		KBANH		KBANH		KBANH		KBANH		KBANH		KBANH		KBANH		KBANH		KBANH		KBANH		KBANH		KBANH		KBANH		KBANH		GKURIMOT		GKURIMOT		KBANH		KBANH		PDEO		PDEO		KBANH		KBANH		KBANH		KBANH		KBANH		KBANH		KBANH		KBANH		MDIGRAZIA		MDIGRAZIA		KBANH		KBANH		SMCCONNAN		SARRIAGA		SMCCONNAN		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		CPON		PDEO		PDEO		PDEO		CPON		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		GPEREZ		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		LBARTHOL		PDEO		GPEREZ		PDEO		LBARTHOL		PADAMS		CSAGABAEN		CSAGABAEN
special_audit		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11001		11003		11003		11003		11001		11003		11003		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11003		11003		11001		11001
rpt_start		2015-07-06 00:00:00		2015-07-10 00:00:00		2015-05-11 00:00:00		2015-07-10 00:00:00		2015-07-14 00:00:00		None		None		2015-12-30 00:00:00		2015-01-01 00:00:00		None		2015-01-01 00:00:00		2015-07-01 00:00:00		2016-03-10 00:00:00		2016-03-24 00:00:00		2016-04-04 00:00:00		2016-04-01 00:00:00		2016-03-29 00:00:00		2016-03-22 00:00:00		2015-07-01 00:00:00		2016-05-24 00:00:00		2016-05-26 00:00:00		2016-03-11 00:00:00		2016-05-25 00:00:00		2016-04-12 00:00:00		2016-04-24 00:00:00		2016-03-21 00:00:00		2016-04-10 00:00:00		2016-05-16 00:00:00		2016-05-02 00:00:00		2016-04-18 00:00:00		2016-04-18 00:00:00		2016-04-14 00:00:00		2016-04-23 00:00:00		2016-04-13 00:00:00		2016-04-26 00:00:00		2016-05-11 00:00:00		2016-05-04 00:00:00		2016-04-27 00:00:00		2016-05-05 00:00:00		2016-05-16 00:00:00		2016-05-17 00:00:00		2016-04-29 00:00:00		2016-05-13 00:00:00		2016-05-20 00:00:00		2016-05-20 00:00:00		2016-04-08 00:00:00		2016-05-18 00:00:00		2016-08-10 00:00:00		2016-08-05 00:00:00		2016-06-01 00:00:00		2016-04-22 00:00:00		2016-05-27 00:00:00		2016-06-06 00:00:00		2016-06-07 00:00:00		2016-06-07 00:00:00		2016-06-13 00:00:00		2016-06-07 00:00:00		2016-01-01 00:00:00		2016-01-01 00:00:00		2016-06-08 00:00:00		2016-05-12 00:00:00		2016-05-22 00:00:00		2016-04-24 00:00:00		2016-05-22 00:00:00		2016-09-07 00:00:00		2016-09-08 00:00:00		2016-09-12 00:00:00		2016-08-29 00:00:00		2016-08-29 00:00:00		2016-08-31 00:00:00		2016-10-04 00:00:00		2016-08-29 00:00:00		2016-08-27 00:00:00		2016-08-25 00:00:00		2016-08-29 00:00:00		2016-09-28 00:00:00		2016-09-29 00:00:00		2016-08-22 00:00:00		2016-09-13 00:00:00		2016-08-22 00:00:00		2016-08-31 00:00:00		2016-09-19 00:00:00		2016-08-16 00:00:00		2016-08-24 00:00:00		2016-09-28 00:00:00		2016-08-15 00:00:00		2016-09-16 00:00:00		2016-07-01 00:00:00		2016-09-21 00:00:00		2016-10-07 00:00:00		2016-10-02 00:00:00		2016-07-01 00:00:00		2016-09-30 00:00:00		2016-09-30 00:00:00		2016-09-13 00:00:00		2016-10-18 00:00:00		2016-10-23 00:00:00		2016-10-13 00:00:00		2016-10-15 00:00:00		2016-10-19 00:00:00		2016-10-22 00:00:00		2016-10-24 00:00:00		2016-10-18 00:00:00		2016-10-20 00:00:00		2016-09-25 00:00:00		2016-10-27 00:00:00		2016-09-14 00:00:00		2016-10-27 00:00:00		2016-10-29 00:00:00		2016-09-24 00:00:00		2016-09-25 00:00:00		2016-11-03 00:00:00		2016-11-03 00:00:00		2016-11-08 00:00:00		2016-11-06 00:00:00		2016-11-01 00:00:00		2016-10-25 00:00:00		2016-11-04 00:00:00		2016-10-19 00:00:00		2016-10-28 00:00:00		2016-10-23 00:00:00		2016-11-02 00:00:00		2016-09-25 00:00:00		2016-10-21 00:00:00		2016-10-23 00:00:00		None		2017-01-01 00:00:00		2017-01-01 00:00:00
rpt_end		2015-07-06 00:00:00		2015-07-10 00:00:00		2015-05-11 00:00:00		2015-07-10 00:00:00		2015-07-14 00:00:00		None		None		2015-12-30 00:00:00		2015-06-30 00:00:00		None		2015-06-30 00:00:00		2015-12-31 00:00:00		2016-03-10 00:00:00		2016-03-24 00:00:00		2016-04-04 00:00:00		2016-04-01 00:00:00		2016-03-29 00:00:00		2016-03-22 00:00:00		2015-12-31 00:00:00		2016-05-24 00:00:00		2016-05-26 00:00:00		2016-03-11 00:00:00		2016-05-25 00:00:00		2016-04-12 00:00:00		2016-05-21 00:00:00		2016-03-21 00:00:00		2016-04-10 00:00:00		2016-05-16 00:00:00		2016-05-02 00:00:00		2016-04-18 00:00:00		2016-04-18 00:00:00		2016-04-14 00:00:00		2016-04-23 00:00:00		2016-04-13 00:00:00		2016-04-26 00:00:00		2016-05-11 00:00:00		2016-05-04 00:00:00		2016-04-27 00:00:00		2016-05-05 00:00:00		2016-05-16 00:00:00		2016-05-17 00:00:00		2016-04-29 00:00:00		2016-05-13 00:00:00		2016-05-20 00:00:00		2016-05-20 00:00:00		2016-04-08 00:00:00		2016-05-18 00:00:00		2016-08-10 00:00:00		2016-08-05 00:00:00		2016-06-01 00:00:00		2016-04-22 00:00:00		2016-05-27 00:00:00		2016-06-06 00:00:00		2016-06-07 00:00:00		2016-06-07 00:00:00		2016-06-13 00:00:00		2016-06-07 00:00:00		2016-04-23 00:00:00		2016-04-23 00:00:00		2016-06-08 00:00:00		2016-05-12 00:00:00		2016-06-30 00:00:00		2016-05-21 00:00:00		2016-06-30 00:00:00		2016-09-07 00:00:00		2016-09-08 00:00:00		2016-09-12 00:00:00		2016-08-29 00:00:00		2016-08-29 00:00:00		2016-08-31 00:00:00		2016-10-04 00:00:00		2016-08-29 00:00:00		2016-08-27 00:00:00		2016-08-25 00:00:00		2016-08-29 00:00:00		2016-09-28 00:00:00		2016-09-29 00:00:00		2016-08-22 00:00:00		2016-09-13 00:00:00		2016-08-22 00:00:00		2016-08-31 00:00:00		2016-09-19 00:00:00		2016-08-16 00:00:00		2016-08-24 00:00:00		2016-09-28 00:00:00		2016-08-15 00:00:00		2016-09-16 00:00:00		2016-09-24 00:00:00		2016-09-21 00:00:00		2016-10-07 00:00:00		2016-10-02 00:00:00		2016-09-24 00:00:00		2016-09-30 00:00:00		2016-09-30 00:00:00		2016-09-13 00:00:00		2016-10-18 00:00:00		2016-10-23 00:00:00		2016-10-13 00:00:00		2016-10-15 00:00:00		2016-10-19 00:00:00		2016-10-22 00:00:00		2016-10-24 00:00:00		2016-10-18 00:00:00		2016-10-20 00:00:00		2016-10-22 00:00:00		2016-10-27 00:00:00		2016-09-14 00:00:00		2016-10-27 00:00:00		2016-10-29 00:00:00		2016-09-24 00:00:00		2016-09-25 00:00:00		2016-11-03 00:00:00		2016-11-03 00:00:00		2016-11-08 00:00:00		2016-11-06 00:00:00		2016-11-01 00:00:00		2016-10-25 00:00:00		2016-11-04 00:00:00		2016-10-19 00:00:00		2016-10-28 00:00:00		2016-12-31 00:00:00		2016-11-02 00:00:00		2016-10-22 00:00:00		2016-10-21 00:00:00		2016-12-31 00:00:00		None		2017-03-01 00:00:00		2017-03-01 00:00:00
rpt_date		2015-07-06 00:00:00		None		2015-05-11 00:00:00		None		2015-07-14 00:00:00		None		None		2015-12-30 00:00:00		2015-07-17 00:00:00		None		None		None		2016-03-10 00:00:00		2016-03-24 00:00:00		2016-04-04 00:00:00		2016-04-01 00:00:00		2016-03-29 00:00:00		2016-03-22 00:00:00		2016-01-13 00:00:00		2016-05-24 00:00:00		2016-05-26 00:00:00		2016-03-11 00:00:00		2016-05-25 00:00:00		2016-04-12 00:00:00		2016-05-23 00:00:00		2016-03-21 00:00:00		2016-04-10 00:00:00		2016-05-16 00:00:00		2016-05-02 00:00:00		2016-04-18 00:00:00		2016-04-18 00:00:00		2016-04-14 00:00:00		2016-04-23 00:00:00		2016-04-13 00:00:00		2016-04-26 00:00:00		2016-05-11 00:00:00		2016-05-04 00:00:00		2016-04-27 00:00:00		2016-05-05 00:00:00		2016-05-16 00:00:00		2016-05-17 00:00:00		2016-04-29 00:00:00		2016-05-13 00:00:00		2016-05-20 00:00:00		2016-05-20 00:00:00		2016-04-08 00:00:00		2016-05-18 00:00:00		2016-08-10 00:00:00		2016-08-05 00:00:00		2016-06-01 00:00:00		2016-04-22 00:00:00		2016-05-27 00:00:00		2016-06-06 00:00:00		2016-06-07 00:00:00		2016-06-07 00:00:00		2016-06-13 00:00:00		2016-06-07 00:00:00		None		2016-04-25 00:00:00		2016-06-08 00:00:00		2016-05-12 00:00:00		2016-07-20 00:00:00		None		None		2016-09-07 00:00:00		2016-09-08 00:00:00		2016-09-12 00:00:00		2016-08-29 00:00:00		2016-08-29 00:00:00		2016-08-31 00:00:00		2016-10-04 00:00:00		2016-08-29 00:00:00		2016-08-27 00:00:00		2016-08-25 00:00:00		2016-08-29 00:00:00		2016-09-28 00:00:00		2016-09-29 00:00:00		2016-08-22 00:00:00		2016-09-13 00:00:00		2016-08-22 00:00:00		2016-08-31 00:00:00		2016-09-19 00:00:00		2016-08-16 00:00:00		2016-08-24 00:00:00		2016-09-28 00:00:00		2016-08-15 00:00:00		2016-09-16 00:00:00		2016-09-25 00:00:00		2016-09-21 00:00:00		2016-10-07 00:00:00		2016-10-02 00:00:00		None		2016-09-30 00:00:00		2016-09-30 00:00:00		2016-09-13 00:00:00		2016-10-18 00:00:00		2016-10-23 00:00:00		2016-10-13 00:00:00		2016-10-15 00:00:00		2016-10-19 00:00:00		2016-10-22 00:00:00		2016-10-24 00:00:00		2016-10-18 00:00:00		2016-10-20 00:00:00		2016-10-24 00:00:00		2016-10-27 00:00:00		2016-09-14 00:00:00		2016-10-27 00:00:00		2016-10-29 00:00:00		2016-09-24 00:00:00		2016-09-25 00:00:00		2016-11-03 00:00:00		2016-11-03 00:00:00		2016-11-08 00:00:00		2016-11-06 00:00:00		2016-11-01 00:00:00		2016-10-25 00:00:00		2016-11-04 00:00:00		2016-10-19 00:00:00		2016-10-28 00:00:00		2017-01-25 00:00:00		2016-11-02 00:00:00		None		2016-10-21 00:00:00		None		None		2017-08-21 00:00:00		None
filing_type		22001		22001		22001		22001		22001		None		None		22001		22001		None		None		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		None		22001		22001		22001		22001		None		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		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		None		22001		None		None		22001		None

Table: filer_to_filer_type

filer_id		1374752		1374752		1374752
filer_type		16		16		16
active		T		Y		Y
race		0		0		0
session_id		2017		2015		2015
category		40002		40002		40002
category_type		40502		40502		40502
sub_category		0		0		0
effect_dt		2017-03-01 00:00:00		2015-01-23 00:00:00		2015-08-04 00:00:00
sub_category_type		0		0		0
election_type		0		0		0
sub_category_a		None		None		None
nyq_dt		2015-02-02 00:00:00		None		2015-02-02 00:00:00
party_cd		16002		16002		16002
county_cd		18039		18039		18039
district_cd		0		0		0

Table: filer_xref

filer_id		1374752
xref_id		1374752
effect_dt		2015-01-26 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1374752		1374752		1374752
filer_id		1374752		1374752		1374752
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		TERMINATED		TERMINATED		TERMINATED
effect_dt		2017-03-01 00:00:00		2017-03-01 00:00:00		2017-03-01 00:00:00
naml		LINDER FOR ASSEMBLY 2016; ERIC		LINDER FOR ASSEMBLY 2016; ERIC		LINDER FOR ASSEMBLY 2016; ERIC
namf		None		None		None
namt		None		None		None
nams		None		None		None
adr1		None		None		None
adr2		None		None		None
city		CORONA		CORONA		SANTA ANA
st		CA		CA		CA
zip4		92882		92882		92705
phon		9512236722		9512236722		9512236722
fax		None		None		None
email		[email protected]		[email protected]		[email protected]

Table: filers

filer_id		1374752

Table: received_filings

filer_id		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752		1374752
filing_file_name		251634.cal		1973014_0.cal		250257.cal		248473.cal		251612.cal		251699.cal		1967944_0.cal		1973014_1.cal		2047368_0.cal		2050106_0.cal		2050307_0.cal		2050308_0.cal		2072481_0.cal		2072483_0.cal		491765.cal		2043806_0.cal		2044543_0.cal		2050674_0.cal		2045406_0.cal		2044443_0.cal		2048414_0.cal		2051263_0.cal		2049864_0.cal		2045918_0.cal		2046510_0.cal		2028008_0.cal		2002039_0.cal		2106289_0.cal		2103623_0.cal		2075128_0.cal		2104651_0.cal		2103150_0.cal		2104712_0.cal		2105585_0.cal		2105035_0.cal		2078867_0.cal		2081140_0.cal		2081028_0.cal		2083892_0.cal		2078360_0.cal		2083011_1.cal		2097477_0.cal		2097563_0.cal		2079634_0.cal		2088530_0.cal		2083011_0.cal		2084998_0.cal		2082250_0.cal		2084253_0.cal		2029252_0.cal		2029260_0.cal		2021659_0.cal		2022333_0.cal		2020136_0.cal		2025451_0.cal		2024207_0.cal		2026854_0.cal		2023038_0.cal		2019681_0.cal		2025673_0.cal		2027140_0.cal		2028512_0.cal		2027575_0.cal		2095734_0.cal		2093100_0.cal		2089452_0.cal		2042995_0.cal		2043007_0.cal		2090593_0.cal		2100200_0.cal		2092049_0.cal		2093750_0.cal		2092539_0.cal		2094765_0.cal		2093899_0.cal		2090576_0.cal		2091805_0.cal		2098871_0.cal		2073013_0.cal		2071665_0.cal		2070539_0.cal		2073212_0.cal		2076252_0.cal		2076259_0.cal		2082254_0.cal		2072591_0.cal		2072483_1.cal		2075801_0.cal		2065952_0.cal		2068334_0.cal		2068941_0.cal		2067138_0.cal		2071360_0.cal		2072395_0.cal		2074647_0.cal		2070527_0.cal		2076988_0.cal		2086443_0.cal		2035797_0.cal		2042107_0.cal		2031452_0.cal		2039784_0.cal		2031612_0.cal		2042587_0.cal		2032571_0.cal		2033175_0.cal		2043273_0.cal		2037860_0.cal		2039501_0.cal		33630.cal
received_date		2015-05-11 00:00:00		2015-07-06 00:00:00		2015-07-10 00:00:00		2015-07-10 00:00:00		2015-05-11 00:00:00		2015-05-11 00:00:00		2015-05-11 00:00:00		2015-07-14 00:00:00		2016-05-27 00:00:00		2016-06-07 00:00:00		2016-06-07 00:00:00		2016-06-07 00:00:00		2016-08-29 00:00:00		2016-08-29 00:00:00		2016-05-25 00:00:00		2016-05-18 00:00:00		2016-05-20 00:00:00		2016-06-08 00:00:00		2016-05-24 00:00:00		2016-05-20 00:00:00		2016-06-01 00:00:00		2016-06-13 00:00:00		2016-06-06 00:00:00		2016-05-25 00:00:00		2016-05-26 00:00:00		2016-04-13 00:00:00		2015-12-30 00:00:00		2016-11-08 00:00:00		2016-11-02 00:00:00		2016-09-08 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-04 00:00:00		2016-09-19 00:00:00		2016-09-25 00:00:00		2016-09-24 00:00:00		2016-09-30 00:00:00		2016-09-16 00:00:00		2016-09-30 00:00:00		2016-10-27 00:00:00		2016-10-27 00:00:00		2016-09-21 00:00:00		2016-10-13 00:00:00		2016-09-29 00:00:00		2016-10-04 00:00:00		2016-09-28 00:00:00		2016-10-02 00:00:00		2016-04-18 00:00:00		2016-04-18 00:00:00		2016-03-21 00:00:00		2016-03-22 00:00:00		2016-03-11 00:00:00		2016-04-01 00:00:00		2016-03-29 00:00:00		2016-04-08 00:00:00		2016-03-24 00:00:00		2016-03-10 00:00:00		2016-04-04 00:00:00		2016-04-10 00:00:00		2016-04-14 00:00:00		2016-04-12 00:00:00		2016-10-25 00:00:00		2016-10-21 00:00:00		2016-10-15 00:00:00		2016-05-16 00:00:00		2016-05-16 00:00:00		2016-10-18 00:00:00		2016-10-29 00:00:00		2016-10-19 00:00:00		2016-10-22 00:00:00		2016-10-20 00:00:00		2016-10-24 00:00:00		2016-10-23 00:00:00		2016-10-18 00:00:00		2016-10-19 00:00:00		2016-10-28 00:00:00		2016-08-31 00:00:00		2016-08-25 00:00:00		2016-08-22 00:00:00		2016-08-31 00:00:00		2016-09-13 00:00:00		2016-09-13 00:00:00		2016-09-28 00:00:00		2016-08-29 00:00:00		2016-08-29 00:00:00		2016-09-12 00:00:00		2016-08-05 00:00:00		2016-08-15 00:00:00		2016-08-16 00:00:00		2016-08-10 00:00:00		2016-08-24 00:00:00		2016-08-27 00:00:00		2016-09-07 00:00:00		2016-08-22 00:00:00		2016-09-14 00:00:00		2016-10-07 00:00:00		2016-04-29 00:00:00		2016-05-12 00:00:00		2016-04-22 00:00:00		2016-05-05 00:00:00		2016-04-23 00:00:00		2016-05-13 00:00:00		2016-04-26 00:00:00		2016-04-27 00:00:00		2016-05-17 00:00:00		2016-05-02 00:00:00		2016-05-04 00:00:00		2017-08-21 00:00:00
filing_directory		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/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/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		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp
filing_id		None		1973014		None		None		None		None		1967944		1973014		2047368		2050106		2050307		2050308		2072481		2072483		None		2043806		2044543		2050674		2045406		2044443		2048414		2051263		2049864		2045918		2046510		2028008		2002039		2106289		2103623		2075128		2104651		2103150		2104712		2105585		2105035		2078867		2081140		2081028		2083892		2078360		2083011		2097477		2097563		2079634		2088530		2083011		2084998		2082250		2084253		2029252		2029260		2021659		2022333		2020136		2025451		2024207		2026854		2023038		2019681		2025673		2027140		2028512		2027575		2095734		2093100		2089452		2042995		2043007		2090593		2100200		2092049		2093750		2092539		2094765		2093899		2090576		2091805		2098871		2073013		2071665		2070539		2073212		2076252		2076259		2082254		2072591		2072483		2075801		2065952		2068334		2068941		2067138		2071360		2072395		2074647		2070527		2076988		2086443		2035797		2042107		2031452		2039784		2031612		2042587		2032571		2033175		2043273		2037860		2039501		None
form_id		None		F497		None		None		None		None		F497		F497		F497		F497		F497		F497		F497		F497		None		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		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		None
receive_comment		Filing did not pass validation		Filing accepted		Filing passed validation, but failed DB constraints		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		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 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		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints