OpenCalAccess

Filer ID: 1359992

Table: cvr_campaign_disclosure
filing_id	1832659	1834111	1826499	1826782	1827184	1831154	1830186	1831374	1807080	1809613	1807012	1807366	1827558	1790408	1792620	1848585	1846815	1847492	1848988	1834707	1836226	1838052	1838686	1834762	1839397	1840924	1886206	1886399	1886867	1881780	1885162	1885201	1874977	1887522	1876477	1877374	1880410	1879909	1879334	1880385	1883277	1883450	1884698	1882848	1885181	1885191	1885426	1882868	1891802	1884251	1886529	1885522	1885760	1880542	1853197	1882971	1873871	1873871	1873235	1857040	1852943	1853197	1851170	1850486	1854167	1855556	1889448	1899146	1888127	1890151	1892428	1894996	1893767	1888683	1889825	1888398	1889032	1890147	1889131	1889818	1890392	1889440	1936533	1905839	1908461	1908446	1906257	1904898	1908446	1910776	1912704	1913962	1893767	1905094	1907893	1907894	1914089	1904871	1873235	1916491	1904871	1905696	1899091	1896862	1896645	1896482	1899112	1900402	1900379	1900381	1900400	1900268	1901101	1901103	1913677	1902076	1913719	1898204	1896245	1896839	1897011	1897030	1897161	1899108	1950703	2035174	2021809	2003239	1936533	1981480	2047297	2083658	2064558	2131624	2105407	2098677
amend_id	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	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	1	0	0	0	1	0	0	0	0	1	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	1	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	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR
form_type	F460	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	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	F460	F497	F497	F460	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	F497	F497	F497	F497	F460	F497	F497	F497	F497	F460	F460	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	F460	F497	F460	F460	F460	F460	F460	F460	F460	F497	F460
filer_id	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992
entity_cd	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	RCP	CTL	RCP	RCP	CTL	RCP	RCP	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	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	CAO	RCP	CTL	CTL	CTL	CAO	CAO	CAO	CAO	CAO	CAO
filer_naml	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	HADLEY FOR ASSEMBLY 2014, DAVID	Hadley for Assembly 2014, David	HADLEY FOR ASSEMBLY 2014, DAVID	HADLEY FOR ASSEMBLY 2014, DAVID	Hadley for Assembly 2014, David	HADLEY FOR ASSEMBLY 2014, DAVID	HADLEY FOR ASSEMBLY 2014, DAVID	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	David Hadley for Assembly 2014	David Hadley for Assembly 2014	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	Hadley for Assembly 2014, David	David Hadley for Assembly 2014	David Hadley for Assembly 2014	David Hadley for Assembly 2014	David Hadley for Assembly 2014	David Hadley for Assembly 2014	David Hadley for Assembly 2014
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	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	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
report_num	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	001	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	001	000	000	000	001	000	000	000	000	001	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	001	000	000	000	000	000	000	000
rpt_date	2014-03-24 00:00:00	2014-03-26 00:00:00	2014-03-07 00:00:00	2014-03-08 00:00:00	2014-03-10 00:00:00	2014-03-21 00:00:00	2014-03-18 00:00:00	2014-03-21 00:00:00	2013-12-11 00:00:00	2014-01-10 00:00:00	2013-12-10 00:00:00	2013-12-17 00:00:00	2014-03-12 00:00:00	2013-09-07 00:00:00	2013-10-02 00:00:00	2014-05-08 00:00:00	2014-05-01 00:00:00	2014-05-06 00:00:00	2014-05-11 00:00:00	2014-03-31 00:00:00	2014-04-05 00:00:00	2014-04-12 00:00:00	2014-04-15 00:00:00	2014-03-31 00:00:00	2014-04-17 00:00:00	2014-04-23 00:00:00	2014-09-18 00:00:00	2014-09-18 00:00:00	2014-09-19 00:00:00	2014-09-02 00:00:00	2014-09-12 00:00:00	2014-09-14 00:00:00	2014-08-07 00:00:00	2014-09-23 00:00:00	2014-08-12 00:00:00	2014-08-14 00:00:00	2014-08-25 00:00:00	2014-08-22 00:00:00	2014-08-20 00:00:00	2014-08-25 00:00:00	2014-09-08 00:00:00	2014-09-09 00:00:00	2014-09-11 00:00:00	2014-09-05 00:00:00	2014-09-13 00:00:00	2014-09-13 00:00:00	2014-09-15 00:00:00	2014-09-05 00:00:00	2014-10-03 00:00:00	2014-09-10 00:00:00	2014-09-18 00:00:00	2014-09-15 00:00:00	2014-09-16 00:00:00	2014-08-26 00:00:00	2014-07-29 00:00:00	2014-09-05 00:00:00	2014-08-06 00:00:00	2014-08-06 00:00:00	2014-07-31 00:00:00	2014-05-30 00:00:00	2014-05-21 00:00:00	2014-05-22 00:00:00	2014-05-16 00:00:00	2014-05-15 00:00:00	2014-05-22 00:00:00	2014-05-28 00:00:00	2014-09-29 00:00:00	2014-10-16 00:00:00	2014-09-24 00:00:00	2014-10-01 00:00:00	2014-10-06 00:00:00	2014-10-08 00:00:00	2014-10-06 00:00:00	2014-09-26 00:00:00	2014-09-30 00:00:00	2014-09-25 00:00:00	2014-09-26 00:00:00	2014-10-01 00:00:00	2014-09-27 00:00:00	2014-09-30 00:00:00	2014-10-01 00:00:00	2014-09-29 00:00:00	2015-02-02 00:00:00	2014-10-25 00:00:00	2014-10-29 00:00:00	2014-10-29 00:00:00	2014-10-27 00:00:00	2014-10-23 00:00:00	2014-10-30 00:00:00	2014-10-30 00:00:00	2014-11-01 00:00:00	2014-11-04 00:00:00	2014-11-25 00:00:00	2014-10-24 00:00:00	2014-10-28 00:00:00	2014-10-28 00:00:00	2014-11-05 00:00:00	2014-11-25 00:00:00	2014-11-25 00:00:00	2014-11-26 00:00:00	2014-10-23 00:00:00	2014-10-25 00:00:00	2014-10-16 00:00:00	2014-10-12 00:00:00	2014-10-10 00:00:00	2014-10-10 00:00:00	2014-10-16 00:00:00	2014-10-19 00:00:00	2014-10-19 00:00:00	2014-10-19 00:00:00	2014-10-19 00:00:00	2014-10-18 00:00:00	2014-10-20 00:00:00	2014-10-20 00:00:00	2014-11-03 00:00:00	2014-10-22 00:00:00	2014-11-04 00:00:00	2014-10-15 00:00:00	2014-10-09 00:00:00	2014-10-11 00:00:00	2014-10-13 00:00:00	2014-10-13 00:00:00	2014-10-13 00:00:00	2014-10-16 00:00:00	2015-03-04 00:00:00	2016-04-26 00:00:00	2016-03-21 00:00:00	2016-01-12 00:00:00	2015-08-26 00:00:00	2015-07-31 00:00:00	2016-05-23 00:00:00	2016-09-24 00:00:00	2016-07-25 00:00:00	2017-01-26 00:00:00	2016-11-04 00:00:00	2016-10-26 00:00:00
stmt_type	PE	None	None	None	None	None	None	None	None	SA	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	SA	None	None	PE	None	None	None	None	None	None	None	None	None	None	PE	None	None	None	None	None	None	None	None	None	SA	None	None	None	None	None	None	None	None	None	PE	None	None	None	None	PE	SA	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	PE	None	SA	SA	SA	PE	PE	SA	TS	None	PE
late_rptno	None	8	1	2	3	6	5	7	4	None	3	5	4	1	2	18	16	17	19	9	11	12	13	10	14	15	20140918-0733301	20140918-4103357	20140919-8330957	20140902-1148493	20140912-1023981	20140914-9138452	20140807-1029474	20140923-8740808	20140812-6613581	20140814-5305139	20140825-1363489	20140822-1740534	20140820-7261927	20140825-9952051	20140908-266299E-02	20140909-760586	20140911-028811E-02	20140905-438418E-02	20140913-9374964	20140913-9681818	20140915-3615991	20140905-2320673	20141003-4850885	20140910-2322657	20140918-2014734	20140915-3736536	20140916-7427484	20140826-2582361	None	20140905-3524439	20140806-20245	20140806-7027552	None	25	22	None	21	20	23	24	20140929-4355432	20141016-5051386	20140924-1047022	20141001-8548242	20141006-5098535	20141008-4706385	None	20140926-1528589	20140930-5907099	20140925-2907678	20140926-5275385	20141001-9360468	20140927-4943201	20140930-4327661	20141001-7213098	20140929-3795435	None	20141025-9605829	20141029-940716	20141029-6435053	20141027-707095E-02	20141023-70776	20141030-2531855	20141030-7177088	20141101-4910089	20141104-1309168	None	20141024-7623255	20141028-8260004	20141028-966372E-02	20141105-239773	None	None	20141126-379925	None	20141025-178158	20141016-7494165	20141012-334469	20141010-273928E-02	20141010-3065912	20141016-1533319	20141019-9008905	20141019-2544367	20141019-537594	20141019-9310266	20141018-2745325	20141020-3349726	20141020-3938105	20141103-1709253	20141022-4617731	20141104-2608759	20141015-5557825	20141009-6438562	20141011-8238031	20141013-417483E-02	20141013-9898798	20141013-4328882	20141016-8144037	20150304-7950861	None	20	None	None	None	None	None	None	None	313	None
from_date	2014-01-01 00:00:00	2014-03-25 00:00:00	2014-03-05 00:00:00	2014-03-05 00:00:00	2014-03-05 00:00:00	2014-03-05 00:00:00	2014-03-05 00:00:00	2014-03-05 00:00:00	None	2013-07-01 00:00:00	None	None	2014-03-05 00:00:00	None	None	2014-05-08 00:00:00	2014-05-01 00:00:00	2014-05-05 00:00:00	2014-05-09 00:00:00	2014-03-31 00:00:00	2014-04-04 00:00:00	2014-04-11 00:00:00	2014-04-15 00:00:00	2014-03-31 00:00:00	2014-04-16 00:00:00	2014-04-22 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	2014-03-18 00:00:00	None	None	None	2014-05-18 00:00:00	2014-05-27 00:00:00	2014-05-16 00:00:00	2014-03-18 00:00:00	2014-05-16 00:00:00	2014-05-14 00:00:00	2014-05-21 00:00:00	2014-05-01 00:00:00	None	None	None	None	None	None	2014-07-01 00:00:00	None	None	None	None	None	None	None	None	None	2014-10-19 00:00:00	None	None	None	None	None	None	None	None	None	2014-07-01 00:00:00	None	None	None	None	2014-10-01 00:00:00	2014-05-18 00:00:00	None	2014-10-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	2016-01-01 00:00:00	None	2015-07-01 00:00:00	2014-10-19 00:00:00	2015-01-01 00:00:00	2016-04-24 00:00:00	2016-07-01 00:00:00	2016-05-22 00:00:00	2016-10-23 00:00:00	None	2016-09-25 00:00:00
thru_date	2014-03-17 00:00:00	2014-03-25 00:00:00	2014-06-03 00:00:00	2014-06-03 00:00:00	2014-06-03 00:00:00	2014-06-03 00:00:00	2014-06-03 00:00:00	2014-06-03 00:00:00	None	2013-12-31 00:00:00	None	None	2014-06-03 00:00:00	None	None	2014-05-08 00:00:00	2014-05-01 00:00:00	2014-05-05 00:00:00	2014-05-10 00:00:00	2014-03-31 00:00:00	2014-04-04 00:00:00	2014-04-11 00:00:00	2014-04-15 00:00:00	2014-03-31 00:00:00	2014-04-17 00:00:00	2014-04-23 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	2014-05-17 00:00:00	None	None	None	2014-06-30 00:00:00	2014-05-30 00:00:00	2014-05-16 00:00:00	2014-05-17 00:00:00	2014-05-16 00:00:00	2014-05-15 00:00:00	2014-05-22 00:00:00	2014-05-28 00:00:00	None	None	None	None	None	None	2014-09-30 00:00:00	None	None	None	None	None	None	None	None	None	2014-12-31 00:00:00	None	None	None	None	None	None	None	None	None	2014-09-30 00:00:00	None	None	None	None	2014-10-18 00:00:00	2014-06-30 00:00:00	None	2014-10-18 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	2016-04-23 00:00:00	None	2015-12-31 00:00:00	2014-12-31 00:00:00	2015-06-30 00:00:00	2016-05-21 00:00:00	2016-09-24 00:00:00	2016-06-30 00:00:00	2016-12-31 00:00:00	None	2016-10-22 00:00:00
elect_date	2014-06-03 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	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-06-03 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	None	None	None	2014-06-03 00:00:00	None	None	None	None	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	None	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	None	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	None	2016-06-07 00:00:00	2014-11-04 00:00:00	2016-11-08 00:00:00	None	None	2016-06-07 00:00:00	2016-11-08 00:00:00	None	None	2016-11-08 00:00:00	2016-11-08 00:00:00
filer_city	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	MANHATTAN BEACH	Manhattan Beach	MANHATTAN BEACH	MANHATTAN BEACH	Manhattan Beach	MANHATTAN BEACH	MANHATTAN BEACH	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach
filer_st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	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	90266	90266	90266	90266	90266	90266	90266	90266	90266	90266	90266	90266	90266	90266	90266	90266	90266	90266	90266	90266	90266	90266	90266	90266	90266	90266	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266	90266-2725	90266-2725	90266-2725	90266	90266	90266	90266	90266	90266	90266	90266	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266	90266-2725	90266-2725	90266-2725	90266-2725	90266	90266	90266	90266	90266	90266
filer_phon	310-600-6937	310-600-6937	310-600-6937	310-600-6937	310-600-6937	310-600-6937	310-600-6937	310-600-6937	3106006937	310-600-6937	3106006937	3106006937	310-600-6937	3106006937	3106006937	310-600-6937	310-600-6937	310-600-6937	310-600-6937	310-600-6937	310-600-6937	310-600-6937	310-600-6937	310-600-6937	310-600-6937	310-600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	310-600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	310-600-6937	310-600-6937	310-600-6937	310-600-6937	310-600-6937	310-600-6937	310-600-6937	310-600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	310-600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	310 600-6937	310 600-6937	(310) 600-6937	(310) 600-6937	(310) 600-6937	310 600-6937	310 600-6937	310 600-6937	310 600-6937	310 600-6937	310 600-6937
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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
file_email	None	None	None	None	None	None	None	None	[email protected]	None	[email protected]	[email protected]	None	[email protected]	[email protected]	None	None	None	None	None	None	None	None	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	None	None	None	None	None	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]
mail_city	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Manhattan Beach	Manhattan Beach	None	None	None	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach
mail_st	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	CA	CA	None	None	None	CA	CA	CA	CA	CA	CA
mail_zip4	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	90266	90266-2725	None	None	None	90266	90266	90266	90266	90266	90266
tres_naml	Montgomery	None	None	None	None	None	None	None	None	Montgomery	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Montgomery	Lawler	Lawler	Lawler	Montgomery	None	None	Montgomery	None	None	None	None	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	None	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	Lawler	None	Lawler
tres_namf	Thomas	None	None	None	None	None	None	None	None	Thomas	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Thomas	Kelly	Kelly	Kelly	Thomas	None	None	Thomas	None	None	None	None	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	None	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	Kelly	None	Kelly
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	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	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	San Rafael	None	None	None	None	None	None	None	None	San Rafael	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	San Rafael	Willows	Willows	Willows	San Rafael	None	None	San Rafael	None	None	None	None	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	Willows	None	Willows	Willows	Willows	Willows	Hilmar	Hilmar	Hilmar	None	Hilmar
tres_st	CA	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	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	None	None	CA	None	None	None	None	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	None	CA	CA	CA	CA	CA	CA	CA	None	CA
tres_zip4	94901	None	None	None	None	None	None	None	None	94901	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	94901	95988-9788	95988-9788	95988-9788	94901	None	None	94901	None	None	None	None	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	95988-9788	None	95988-9788	95988-9788	95988-9788	95988-9788	95324	95324	95324	None	95324
tres_phon	415-250-4036	None	None	None	None	None	None	None	None	415-250-4036	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	415-250-4036	(530) 934-5823	(530) 934-5823	(530) 934-5823	415-250-4036	None	None	415-250-4036	None	None	None	None	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	5309345823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	(530) 934-5823	530 934-5823	None	(530) 934-5823	(530) 934-5823	(530) 934-5823	530 934-5823	209-656-1542	209-656-1542	209-656-1542	None	209-656-1542
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	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	[email protected]	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cmtte_type	C	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	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	None	None	C	None	None	None	None	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	C	None	C	C	C	C	C	C	C	None	C
control_yn	Y	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	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	None	None	Y	None	None	None	None	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	None	Y	Y	Y	Y	Y	Y	Y	None	Y
sponsor_yn	N	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	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	None	None	N	None	None	None	None	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	None	N	N	N	N	N	N	N	None	N
primfrm_yn	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
brdbase_yn	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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_1	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Expenses accidentally omitted	None	None	Update employer and 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	Ammendment is to correct contributor name for J. Demetree and to include aggregated contribution.	None	None	None	To Update donor info.	None	None	None	None	To Update donor info.	Summary page, Schedule E and Donor and Vendor info.	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	To Update two street addresses.	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	Hadley	None	None	None	None	None	None	None	None	Hadley	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Hadley	None	None	None	Hadley	None	None	Hadley	None	None	None	None	None	None	None	None	None	None	Hadley	None	None	None	None	None	None	None	None	None	Hadley	None	None	None	None	None	None	None	None	None	Hadley	None	None	None	None	Hadley	Hadley	None	Hadley	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Hadley	None	Hadley	Hadley	Hadley	Hadley	Hadley	Hadley	Hadley	None	Hadley
cand_namf	David	None	None	None	None	None	None	None	None	David	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	David	None	None	None	David	None	None	David	None	None	None	None	None	None	None	None	None	None	David	None	None	None	None	None	None	None	None	None	David	None	None	None	None	None	None	None	None	None	David	None	None	None	None	David	David	None	David	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	David	None	David	David	David	David	David	David	David	None	David
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	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	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	Manhattan Beach	None	None	None	None	None	None	None	None	Manhattan Beach	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Manhattan Beach	None	None	None	Manhattan Beach	None	None	Manhattan Beach	None	None	None	None	None	None	None	None	None	None	Manhattan Beach	None	None	None	None	None	None	None	None	None	Manhattan Beach	None	None	None	None	None	None	None	None	None	Manhattan Beach	None	None	None	None	Manhattan Beach	Manhattan Beach	None	Manhattan Beach	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Manhattan Beach	None	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	Manhattan Beach	None	Manhattan Beach
cand_st	CA	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	None	None	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	CA	None	None	CA	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	None	None	None	None	CA	None	None	None	None	CA	CA	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	CA	None	CA	CA	CA	CA	CA	CA	CA	None	CA
cand_zip4	92066	None	None	None	None	None	None	None	None	92066	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	92066	None	None	None	92066	None	None	92066	None	None	None	None	None	None	None	None	None	None	90266-2725	None	None	None	None	None	None	None	None	None	90266-2725	None	None	None	None	None	None	None	None	None	90266-2725	None	None	None	None	90266-2725	92066	None	90266-2725	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	90266-2725	None	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	90266-2725	None	90266-2725
cand_phon	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	(310) 600-6937	None	None	None	None	None	None	None	None	None	(310) 600-6937	None	None	None	None	None	None	None	None	None	(310) 600-6937	None	None	None	None	(310) 600-6937	None	None	(310) 600-6937	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	(310) 600-6937	(310) 600-6937	(310) 600-6937	None	None	None	None	None	None
cand_fax	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	[email protected]	None	None	None	None	None	None	None	None	None	[email protected]	None	None	None	None	None	None	None	None	None	[email protected]	None	None	None	None	[email protected]	None	None	[email protected]	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	[email protected]	[email protected]	[email protected]	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	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	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	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	ASM	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	None	None	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	ASM	None	None	ASM	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	None	None	None	None	ASM	None	None	None	None	ASM	ASM	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	GOV	None	ASM	ASM	ASM	ASM	ASM	ASM	ASM	None	ASM
offic_dscr	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	ASM	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	None	None	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	ASM	None	None	ASM	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	None	None	None	None	ASM	None	None	None	None	ASM	ASM	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	STW	None	ASM	ASM	ASM	ASM	ASM	ASM	ASM	None	ASM
juris_dscr	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	66	None	None	None	None	None	None	None	None	66	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	66	None	None	None	66	None	None	66	None	None	None	None	None	None	None	None	None	None	66	None	None	None	None	None	None	None	None	None	66	None	None	None	None	None	None	None	None	None	66	None	None	None	None	66	66	None	66	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	66	None	66	66	66	66	66	66	66	None	66
off_s_h_cd	S	None	None	None	None	None	None	None	None	S	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	S	None	None	None	S	None	None	S	None	None	None	None	None	None	None	None	None	None	S	None	None	None	None	None	None	None	None	None	S	None	None	None	None	None	None	None	None	None	S	None	None	None	None	S	S	None	S	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	S	None	S	S	S	S	S	S	S	None	S
sup_opp_cd	S	None	None	None	None	None	None	None	None	S	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	S	None	None	None	S	None	None	S	None	None	None	None	None	None	None	None	None	None	S	None	None	None	None	None	None	None	None	None	S	None	None	None	None	None	None	None	None	None	S	None	None	None	None	S	S	None	S	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	S	None	S	S	S	S	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	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	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	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	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	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	1789394	1789394	1789394
amend_id	0	1	2
rec_type	CVR	CVR	CVR
form_type	F410	F410	F410
filer_id	1359992	1359992	1359992
entity_cd	RCP	RCP	COM
filer_naml	HADLEY FOR ASSEMBLY 2014, DAVID	HADLEY FOR ASSEMBLY 2014, DAVID	David Hadley for Assembly 2014
filer_namf	None	None	None
filer_namt	None	None	None
filer_nams	None	None	None
report_num	000	001	002
rpt_date	2013-08-28 00:00:00	2014-07-30 00:00:00	2017-01-25 00:00:00
qual_cb	None	None	X
qualfy_dt	2013-08-28 00:00:00	2013-08-28 00:00:00	2013-08-28 00:00:00
term_date	None	None	2016-12-31 00:00:00
city	MANHATTAN BEACH	MANHATTAN BEACH	Manhattan Beach
st	CA	CA	CA
zip4	90266	90266	90266
phone	3106006937	3106006937	310 600-6937
county_res	None	LOS ANGELES	Los Angeles
county_act	None	None	None
mail_city	None	None	Manhattan Beach
mail_st	None	None	CA
mail_zip4	None	None	90266
cmte_fax	None	None	None
cmte_email	[email protected]	[email protected]	[email protected];
tres_naml	Montgomery	Lawler	Lawler
tres_namf	Thomas	Kelly	Kelly
tres_namt	None	None	None
tres_nams	None	None	None
tres_city	San Rafael	Willows	Hilmar
tres_st	CA	CA	CA
tres_zip4	94901	95988	95324
tres_phon	4152504036	5309345823	209-656-1542
actvty_lvl	None	None	None
com82013yn	None	None	None
com82013nm	None	None	None
com82013id	None	None	None
control_cb	X	X	X
bank_nam	Chase Bank	TRI COUNTIES	Tri Counties
bank_adr1	300 Las Gallinas Ave	210 N TEHAMA	210 North Tehama Street
bank_adr2	None	None	None
bank_city	San Rafael	Willows	Willows
bank_st	CA	CA	CA
bank_zip4	94901	95988	95988
bank_phon	4154795439	5309349121	530 934-9121
acct_opendt	None	None	None
surplusdsp	None	None	None
primfc_cb	None	None	None
genpurp_cb	None	None	None
gpc_descr	None	None	None
sponsor_cb	None	None	None
brdbase_cb	None	None	None
smcont_qualdt	None	None	None

Table: filer_address
filer_id		1359992
adrid		2297171
effect_dt		2013-08-27 00:00:00
add_type		7051
session_id		2013

Table: filer_filings
filer_id	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992
filing_id	1789278	1789394	1981480	1789394	1857040	1853197	1857428	1852943	1854167	1855556	1853197	1807366	1807012	1809613	1807080	1792620	1790408	1791034	1906795	1940877	1950703	1894160	1874011	1936533	1908446	1908461	1891802	1893767	1908446	1910776	1896839	1897011	1897161	1898204	1894996	1889448	1907893	1907894	1912704	1897030	1899091	1894160	1896245	1896862	1899146	1896645	1901101	1901103	1899112	1902076	1885426	1885522	1886867	1896482	1904898	1905696	1905839	1905094	1888683	1890147	1906257	1906795	1827184	1827558	1826499	1826782	1830186	1831374	1832659	1813129	1904871	1873235	1916491	1899108	1904871	1914089	1893767	1913677	1900268	1900379	1900381	1900400	1900402	1913962	1913719	1889440	1888398	1889818	1889825	1889032	1889131	1890392	1877049	1874011	1873871	1881780	1857428	1880385	1880542	1888127	1885162	1885201	1887522	1892428	1890151	1873871	1879334	1873235	1874977	1880410	1876477	1877374	1879909	1882848	1882868	1882971	1883450	1884698	1883277	1885181	1885191	1884251	1886206	1886399	1886529	1885760	1848585	1831154	1850486	1851170	1834133	1847492	1846815	1848988	1836226	1834707	1834762	1838686	1838052	1839397	1834111	1840924	1940877	2003239	1936533	1984786	2018299	2035174	2021809	2039028	2066761	2047297	2048844	2055317	2064558	2083658	2065707	2105407	2098677	2094163	2112132	2131624	1789394	2134907	2141670
period_id	None	215	221	219	218	217	None	218	218	218	217	216	216	215	216	216	215	None	None	None	221	None	None	220	220	220	220	219	220	220	220	220	220	220	220	219	220	220	220	220	220	None	220	220	220	220	220	220	220	220	219	219	219	220	220	220	220	220	219	220	220	None	217	217	217	217	217	217	217	None	220	218	220	220	220	220	219	220	220	220	220	220	220	220	220	219	219	219	219	219	219	220	None	None	219	219	None	219	219	219	219	219	219	220	220	219	219	218	219	219	219	219	219	219	219	219	219	219	219	219	219	219	219	219	219	219	218	217	218	218	None	218	218	218	218	217	217	218	218	218	217	218	None	223	220	None	None	225	225	None	None	226	None	None	226	227	None	228	227	None	None	228	229	None	None
form_id	F410	F410	F460	F410	F497	F460	F460	F497	F497	F497	F460	F497	F497	F460	F497	F497	F497	F410	F460	F460	F497	F460	F460	F460	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	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F460	F497	F497	F497	F497	F497	F497	F460	F460	F460	F460	F497	F497	F460	F497	F460	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F410	F460	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	F497	F497	F497	F497	F497	F497	F497	F497	F497	F460	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F460	F460	F460	F460	F460	F460	F497	F460	F410	F460	F460	F666	F460	F460	F460	F497	F460	F460	F460	F460	F410	F410	F460
filing_sequence	0	0	0	1	0	0	0	0	0	0	1	0	0	0	0	0	0	0	1	0	0	1	1	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	0
filing_date	2013-08-27 00:00:00	2013-08-28 00:00:00	2015-07-31 00:00:00	2014-07-30 00:00:00	2014-05-30 00:00:00	2014-05-22 00:00:00	2014-05-22 00:00:00	2014-05-21 00:00:00	2014-05-22 00:00:00	2014-05-28 00:00:00	2014-07-29 00:00:00	2013-12-17 00:00:00	2013-12-10 00:00:00	2014-01-10 00:00:00	2013-12-11 00:00:00	2013-10-02 00:00:00	2013-09-07 00:00:00	2013-09-06 00:00:00	2014-12-03 00:00:00	2015-02-02 00:00:00	2015-03-04 00:00:00	2014-12-03 00:00:00	2014-12-03 00:00:00	2015-02-02 00:00:00	2014-10-29 00:00:00	2014-10-29 00:00:00	2014-10-03 00:00:00	2014-10-06 00:00:00	2014-10-30 00:00:00	2014-10-30 00:00:00	2014-10-11 00:00:00	2014-10-13 00:00:00	2014-10-13 00:00:00	2014-10-15 00:00:00	2014-10-08 00:00:00	2014-09-29 00:00:00	2014-10-28 00:00:00	2014-10-28 00:00:00	2014-11-01 00:00:00	2014-10-13 00:00:00	2014-10-16 00:00:00	2014-10-06 00:00:00	2014-10-09 00:00:00	2014-10-12 00:00:00	2014-10-16 00:00:00	2014-10-10 00:00:00	2014-10-20 00:00:00	2014-10-20 00:00:00	2014-10-16 00:00:00	2014-10-22 00:00:00	2014-09-15 00:00:00	2014-09-15 00:00:00	2014-09-19 00:00:00	2014-10-10 00:00:00	2014-10-23 00:00:00	2014-10-25 00:00:00	2014-10-25 00:00:00	2014-10-24 00:00:00	2014-09-26 00:00:00	2014-10-01 00:00:00	2014-10-27 00:00:00	2014-10-23 00:00:00	2014-03-10 00:00:00	2014-03-12 00:00:00	2014-03-07 00:00:00	2014-03-08 00:00:00	2014-03-18 00:00:00	2014-03-21 00:00:00	2014-03-24 00:00:00	2014-01-22 00:00:00	2014-11-25 00:00:00	2014-11-25 00:00:00	2014-11-26 00:00:00	2014-10-16 00:00:00	2014-10-23 00:00:00	2014-11-05 00:00:00	2014-11-25 00:00:00	2014-11-03 00:00:00	2014-10-18 00:00:00	2014-10-19 00:00:00	2014-10-19 00:00:00	2014-10-19 00:00:00	2014-10-19 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-09-29 00:00:00	2014-09-25 00:00:00	2014-09-30 00:00:00	2014-09-30 00:00:00	2014-09-26 00:00:00	2014-09-27 00:00:00	2014-10-01 00:00:00	2014-08-07 00:00:00	2014-07-31 00:00:00	2014-08-06 00:00:00	2014-09-02 00:00:00	2014-08-04 00:00:00	2014-08-25 00:00:00	2014-08-26 00:00:00	2014-09-24 00:00:00	2014-09-12 00:00:00	2014-09-14 00:00:00	2014-09-23 00:00:00	2014-10-06 00:00:00	2014-10-01 00:00:00	2014-08-06 00:00:00	2014-08-20 00:00:00	2014-07-31 00:00:00	2014-08-07 00:00:00	2014-08-25 00:00:00	2014-08-12 00:00:00	2014-08-14 00:00:00	2014-08-22 00:00:00	2014-09-05 00:00:00	2014-09-05 00:00:00	2014-09-05 00:00:00	2014-09-09 00:00:00	2014-09-11 00:00:00	2014-09-08 00:00:00	2014-09-13 00:00:00	2014-09-13 00:00:00	2014-09-10 00:00:00	2014-09-18 00:00:00	2014-09-18 00:00:00	2014-09-18 00:00:00	2014-09-16 00:00:00	2014-05-08 00:00:00	2014-03-21 00:00:00	2014-05-15 00:00:00	2014-05-16 00:00:00	2014-03-24 00:00:00	2014-05-06 00:00:00	2014-05-01 00:00:00	2014-05-11 00:00:00	2014-04-05 00:00:00	2014-03-31 00:00:00	2014-03-31 00:00:00	2014-04-15 00:00:00	2014-04-12 00:00:00	2014-04-17 00:00:00	2014-03-26 00:00:00	2014-04-23 00:00:00	2015-09-09 00:00:00	2016-01-12 00:00:00	2015-08-26 00:00:00	2015-07-31 00:00:00	2016-02-01 00:00:00	2016-04-28 00:00:00	2016-03-21 00:00:00	2016-04-28 00:00:00	2016-08-02 00:00:00	2016-05-26 00:00:00	2016-05-25 00:00:00	2016-06-30 00:00:00	2016-08-01 00:00:00	2016-09-29 00:00:00	2016-08-01 00:00:00	2016-11-04 00:00:00	2016-10-27 00:00:00	2016-09-29 00:00:00	2016-10-27 00:00:00	2017-01-31 00:00:00	2017-02-02 00:00:00	2017-02-01 00:00:00	2017-01-31 00:00:00
stmnt_type	10005	10001	10001	10002	10001	10001	10005	10001	10001	10001	10002	10001	10001	10001	10001	10001	10001	10006	10006	10005	10001	10006	10006	10001	10001	10001	10001	10001	10002	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10005	10002	10002	10001	10001	10001	10001	10002	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10006	10005	10002	10001	10006	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	10001	10001	10001	10001	10001	10001	10001	10006	10001	10002	10005	10005	10001	10001	10005	10006	10001	10005	10005	10001	10001	10005	10001	10001	10005	10005	10001	10003	10003	10003
stmnt_status	11003	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11001	11001	11001	11001	11003	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	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001
session_id	2013	2013	2015	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2015	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2015	2013	2015	2015	2015	2015	2015	2015	2015	2015	2013	2015	2015	2015	2015	2015	2015	2015	2015	2017	2017	2015
user_id	GPEREZ	TRAMON	MDIGRAZIA	TRAMON	RGEREMIA	CAFILER	GPEREZ	RGEREMIA	CREYNOLDS	RGEREMIA	MDIGRAZIA	WBROWN	WBROWN	CPON	WBROWN	WBROWN	WBROWN	TRAMON	MPACHECO	SMCCONNAN	CREYNOLDS	MPACHECO	MPACHECO	SMCCONNAN	CREYNOLDS	CREYNOLDS	CREYNOLDS	SMCCONNAN	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	SMCCONNAN	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	SARRIAGA	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	SARRIAGA	CPON	CAFILER	CAFILER	CREYNOLDS	CREYNOLDS	SARRIAGA	CREYNOLDS	CAFILER	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	TRAMON	MDIGRAZIA	CREYNOLDS	CREYNOLDS	MPACHECO	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	MDIGRAZIA	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	SARRIAGA	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	MPACHECO	SARRIAGA	MDIGRAZIA	MDIGRAZIA	SARRIAGA	SMCCONNAN	KBANH	SMCCONNAN	TRAMON	DMCCASTL	SARRIAGA	SBROWN	SMCCONNAN	LLEONG	SMCCONNAN	PDEO	GPEREZ	LLEONG	GPEREZ	SARRIAGA	RSAGARIO	RSAGARIO	SARRIAGA
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	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003
fine_audit	11003	11003	11001	11003	11001	11003	11003	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11003	11003	11001	11001	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11003	11001	11003	11003	11001	11001	11003	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11003	11001	11003	11001	11001	11001	11003	11001	11003	11003	11001	11003	11001	11001	11003	11003	11003	11003	11003	11003	11003
rpt_start	None	2013-08-28 00:00:00	2015-01-01 00:00:00	2014-07-30 00:00:00	2014-05-30 00:00:00	2014-03-18 00:00:00	2014-03-18 00:00:00	2014-05-21 00:00:00	2014-05-22 00:00:00	2014-05-28 00:00:00	2014-03-18 00:00:00	2013-12-17 00:00:00	2013-12-10 00:00:00	2013-07-01 00:00:00	2013-12-11 00:00:00	2013-10-02 00:00:00	2013-09-07 00:00:00	None	2014-10-01 00:00:00	2014-10-19 00:00:00	2015-03-04 00:00:00	2014-07-01 00:00:00	2014-05-18 00:00:00	2014-10-19 00:00:00	2014-10-29 00:00:00	2014-10-29 00:00:00	2014-10-03 00:00:00	2014-07-01 00:00:00	2014-10-30 00:00:00	2014-10-30 00:00:00	2014-10-11 00:00:00	2014-10-13 00:00:00	2014-10-13 00:00:00	2014-10-15 00:00:00	2014-10-08 00:00:00	2014-09-29 00:00:00	2014-10-28 00:00:00	2014-10-28 00:00:00	2014-11-01 00:00:00	2014-10-13 00:00:00	2014-10-16 00:00:00	2014-07-01 00:00:00	2014-10-09 00:00:00	2014-10-12 00:00:00	2014-10-16 00:00:00	2014-10-10 00:00:00	2014-10-20 00:00:00	2014-10-20 00:00:00	2014-10-16 00:00:00	2014-10-22 00:00:00	2014-09-15 00:00:00	2014-09-15 00:00:00	2014-09-19 00:00:00	2014-10-10 00:00:00	2014-10-23 00:00:00	2014-10-25 00:00:00	2014-10-25 00:00:00	2014-10-24 00:00:00	2014-09-26 00:00:00	2014-10-01 00:00:00	2014-10-27 00:00:00	2014-10-01 00:00:00	2014-03-10 00:00:00	2014-03-12 00:00:00	2014-03-07 00:00:00	2014-03-08 00:00:00	2014-03-18 00:00:00	2014-03-21 00:00:00	2014-01-01 00:00:00	2013-07-01 00:00:00	2014-10-01 00:00:00	2014-05-18 00:00:00	2014-11-26 00:00:00	2014-10-16 00:00:00	2014-10-01 00:00:00	2014-11-05 00:00:00	2014-07-01 00:00:00	2014-11-03 00:00:00	2014-10-18 00:00:00	2014-10-19 00:00:00	2014-10-19 00:00:00	2014-10-19 00:00:00	2014-10-19 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-09-29 00:00:00	2014-09-25 00:00:00	2014-09-30 00:00:00	2014-09-30 00:00:00	2014-09-26 00:00:00	2014-09-27 00:00:00	2014-10-01 00:00:00	None	2014-05-18 00:00:00	2014-08-06 00:00:00	2014-09-02 00:00:00	2014-03-18 00:00:00	2014-08-25 00:00:00	2014-08-26 00:00:00	2014-09-24 00:00:00	2014-09-12 00:00:00	2014-09-14 00:00:00	2014-09-23 00:00:00	2014-10-06 00:00:00	2014-10-01 00:00:00	2014-08-06 00:00:00	2014-08-20 00:00:00	2014-05-18 00:00:00	2014-08-07 00:00:00	2014-08-25 00:00:00	2014-08-12 00:00:00	2014-08-14 00:00:00	2014-08-22 00:00:00	2014-09-05 00:00:00	2014-09-05 00:00:00	2014-09-05 00:00:00	2014-09-09 00:00:00	2014-09-11 00:00:00	2014-09-08 00:00:00	2014-09-13 00:00:00	2014-09-13 00:00:00	2014-09-10 00:00:00	2014-09-18 00:00:00	2014-09-18 00:00:00	2014-09-18 00:00:00	2014-09-16 00:00:00	2014-05-08 00:00:00	2014-03-21 00:00:00	2014-05-15 00:00:00	2014-05-16 00:00:00	2014-01-01 00:00:00	2014-05-06 00:00:00	2014-05-01 00:00:00	2014-05-11 00:00:00	2014-04-05 00:00:00	2014-03-31 00:00:00	2014-03-31 00:00:00	2014-04-15 00:00:00	2014-04-12 00:00:00	2014-04-17 00:00:00	2014-03-26 00:00:00	2014-04-23 00:00:00	2014-10-19 00:00:00	2015-07-01 00:00:00	2014-10-19 00:00:00	2015-01-01 00:00:00	2015-07-01 00:00:00	2016-01-01 00:00:00	2016-03-21 00:00:00	2016-01-01 00:00:00	None	2016-04-24 00:00:00	2016-04-23 00:00:00	2013-01-01 00:00:00	2016-05-22 00:00:00	2016-07-01 00:00:00	2016-05-22 00:00:00	2016-11-04 00:00:00	2016-09-25 00:00:00	2016-07-01 00:00:00	2016-09-25 00:00:00	2016-10-23 00:00:00	2017-01-25 00:00:00	None	2016-10-23 00:00:00
rpt_end	None	2013-08-28 00:00:00	2015-06-30 00:00:00	2014-07-30 00:00:00	2014-05-30 00:00:00	2014-05-17 00:00:00	2014-05-17 00:00:00	2014-05-21 00:00:00	2014-05-22 00:00:00	2014-05-28 00:00:00	2014-05-17 00:00:00	2013-12-17 00:00:00	2013-12-10 00:00:00	2013-12-31 00:00:00	2013-12-11 00:00:00	2013-10-02 00:00:00	2013-09-07 00:00:00	None	2014-10-18 00:00:00	2014-12-31 00:00:00	2015-03-04 00:00:00	2014-09-30 00:00:00	2014-06-30 00:00:00	2014-12-31 00:00:00	2014-10-29 00:00:00	2014-10-29 00:00:00	2014-10-03 00:00:00	2014-09-30 00:00:00	2014-10-30 00:00:00	2014-10-30 00:00:00	2014-10-11 00:00:00	2014-10-13 00:00:00	2014-10-13 00:00:00	2014-10-15 00:00:00	2014-10-08 00:00:00	2014-09-29 00:00:00	2014-10-28 00:00:00	2014-10-28 00:00:00	2014-11-01 00:00:00	2014-10-13 00:00:00	2014-10-16 00:00:00	2014-09-30 00:00:00	2014-10-09 00:00:00	2014-10-12 00:00:00	2014-10-16 00:00:00	2014-10-10 00:00:00	2014-10-20 00:00:00	2014-10-20 00:00:00	2014-10-16 00:00:00	2014-10-22 00:00:00	2014-09-15 00:00:00	2014-09-15 00:00:00	2014-09-19 00:00:00	2014-10-10 00:00:00	2014-10-23 00:00:00	2014-10-25 00:00:00	2014-10-25 00:00:00	2014-10-24 00:00:00	2014-09-26 00:00:00	2014-10-01 00:00:00	2014-10-27 00:00:00	2014-10-18 00:00:00	2014-03-10 00:00:00	2014-03-12 00:00:00	2014-03-07 00:00:00	2014-03-08 00:00:00	2014-03-18 00:00:00	2014-03-21 00:00:00	2014-03-17 00:00:00	2013-12-31 00:00:00	2014-10-18 00:00:00	2014-06-30 00:00:00	2014-11-26 00:00:00	2014-10-16 00:00:00	2014-10-18 00:00:00	2014-11-05 00:00:00	2014-09-30 00:00:00	2014-11-03 00:00:00	2014-10-18 00:00:00	2014-10-19 00:00:00	2014-10-19 00:00:00	2014-10-19 00:00:00	2014-10-19 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-09-29 00:00:00	2014-09-25 00:00:00	2014-09-30 00:00:00	2014-09-30 00:00:00	2014-09-26 00:00:00	2014-09-27 00:00:00	2014-10-01 00:00:00	None	2014-06-30 00:00:00	2014-08-06 00:00:00	2014-09-02 00:00:00	2014-05-17 00:00:00	2014-08-25 00:00:00	2014-08-26 00:00:00	2014-09-24 00:00:00	2014-09-12 00:00:00	2014-09-14 00:00:00	2014-09-23 00:00:00	2014-10-06 00:00:00	2014-10-01 00:00:00	2014-08-06 00:00:00	2014-08-20 00:00:00	2014-06-30 00:00:00	2014-08-07 00:00:00	2014-08-25 00:00:00	2014-08-12 00:00:00	2014-08-14 00:00:00	2014-08-22 00:00:00	2014-09-05 00:00:00	2014-09-05 00:00:00	2014-09-05 00:00:00	2014-09-09 00:00:00	2014-09-11 00:00:00	2014-09-08 00:00:00	2014-09-13 00:00:00	2014-09-13 00:00:00	2014-09-10 00:00:00	2014-09-18 00:00:00	2014-09-18 00:00:00	2014-09-18 00:00:00	2014-09-16 00:00:00	2014-05-08 00:00:00	2014-03-21 00:00:00	2014-05-15 00:00:00	2014-05-16 00:00:00	2014-03-17 00:00:00	2014-05-06 00:00:00	2014-05-01 00:00:00	2014-05-11 00:00:00	2014-04-05 00:00:00	2014-03-31 00:00:00	2014-03-31 00:00:00	2014-04-15 00:00:00	2014-04-12 00:00:00	2014-04-17 00:00:00	2014-03-26 00:00:00	2014-04-23 00:00:00	2014-12-31 00:00:00	2015-12-31 00:00:00	2014-12-31 00:00:00	2015-06-30 00:00:00	2015-12-31 00:00:00	2016-04-23 00:00:00	2016-03-21 00:00:00	2016-04-23 00:00:00	None	2016-05-21 00:00:00	2016-05-21 00:00:00	2014-06-30 00:00:00	2016-06-30 00:00:00	2016-09-24 00:00:00	2016-06-30 00:00:00	2016-11-04 00:00:00	2016-10-22 00:00:00	2016-09-24 00:00:00	2016-10-22 00:00:00	2016-12-31 00:00:00	2017-01-25 00:00:00	None	2016-12-31 00:00:00
rpt_date	None	None	2015-07-31 00:00:00	None	2014-05-30 00:00:00	2014-05-22 00:00:00	None	2014-05-21 00:00:00	2014-05-22 00:00:00	2014-05-28 00:00:00	2014-07-29 00:00:00	2013-12-17 00:00:00	2013-12-10 00:00:00	2014-01-10 00:00:00	2013-12-11 00:00:00	2013-10-02 00:00:00	2013-09-07 00:00:00	None	None	None	2015-03-04 00:00:00	None	None	2015-02-02 00:00:00	2014-10-29 00:00:00	2014-10-29 00:00:00	2014-10-03 00:00:00	2014-10-06 00:00:00	2014-10-30 00:00:00	2014-10-30 00:00:00	2014-10-11 00:00:00	2014-10-13 00:00:00	2014-10-13 00:00:00	2014-10-15 00:00:00	2014-10-08 00:00:00	2014-09-29 00:00:00	2014-10-28 00:00:00	2014-10-28 00:00:00	2014-11-01 00:00:00	2014-10-13 00:00:00	2014-10-16 00:00:00	None	2014-10-09 00:00:00	2014-10-12 00:00:00	2014-10-16 00:00:00	2014-10-10 00:00:00	2014-10-20 00:00:00	2014-10-20 00:00:00	2014-10-16 00:00:00	2014-10-22 00:00:00	2014-09-15 00:00:00	2014-09-15 00:00:00	2014-09-19 00:00:00	2014-10-10 00:00:00	2014-10-23 00:00:00	2014-10-25 00:00:00	2014-10-25 00:00:00	2014-10-24 00:00:00	2014-09-26 00:00:00	2014-10-01 00:00:00	2014-10-27 00:00:00	None	2014-03-10 00:00:00	2014-03-12 00:00:00	2014-03-07 00:00:00	2014-03-08 00:00:00	2014-03-18 00:00:00	2014-03-21 00:00:00	2014-03-24 00:00:00	None	2014-11-25 00:00:00	2014-11-25 00:00:00	2014-11-26 00:00:00	2014-10-16 00:00:00	2014-10-23 00:00:00	2014-11-05 00:00:00	2014-11-25 00:00:00	2014-11-03 00:00:00	2014-10-18 00:00:00	2014-10-19 00:00:00	2014-10-19 00:00:00	2014-10-19 00:00:00	2014-10-19 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-09-29 00:00:00	2014-09-25 00:00:00	2014-09-30 00:00:00	2014-09-30 00:00:00	2014-09-26 00:00:00	2014-09-27 00:00:00	2014-10-01 00:00:00	None	None	2014-08-06 00:00:00	2014-09-02 00:00:00	None	2014-08-25 00:00:00	2014-08-26 00:00:00	2014-09-24 00:00:00	2014-09-12 00:00:00	2014-09-14 00:00:00	2014-09-23 00:00:00	2014-10-06 00:00:00	2014-10-01 00:00:00	2014-08-06 00:00:00	2014-08-20 00:00:00	2014-07-31 00:00:00	2014-08-07 00:00:00	2014-08-25 00:00:00	2014-08-12 00:00:00	2014-08-14 00:00:00	2014-08-22 00:00:00	2014-09-05 00:00:00	2014-09-05 00:00:00	2014-09-05 00:00:00	2014-09-09 00:00:00	2014-09-11 00:00:00	2014-09-08 00:00:00	2014-09-13 00:00:00	2014-09-13 00:00:00	2014-09-10 00:00:00	2014-09-18 00:00:00	2014-09-18 00:00:00	2014-09-18 00:00:00	2014-09-16 00:00:00	2014-05-08 00:00:00	2014-03-21 00:00:00	2014-05-15 00:00:00	2014-05-16 00:00:00	None	2014-05-06 00:00:00	2014-05-01 00:00:00	2014-05-11 00:00:00	2014-04-05 00:00:00	2014-03-31 00:00:00	2014-03-31 00:00:00	2014-04-15 00:00:00	2014-04-12 00:00:00	2014-04-17 00:00:00	2014-03-26 00:00:00	2014-04-23 00:00:00	None	2016-01-12 00:00:00	2015-08-26 00:00:00	None	None	2016-04-26 00:00:00	2016-03-21 00:00:00	None	None	2016-05-23 00:00:00	None	None	2016-07-25 00:00:00	2016-09-24 00:00:00	None	2016-11-04 00:00:00	2016-10-26 00:00:00	None	None	2017-01-26 00:00:00	None	None	None
filing_type	None	22006	22001	22006	22001	22001	None	22001	22001	22001	22001	22006	22006	22001	22006	22006	22006	None	None	None	22001	None	None	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	None	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	None	None	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	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	None	None	22001	22001	None	None	22001	None	None	22001	22001	None	22001	22001	None	None	22001	22001	None	None

Table: filer_to_filer_type
filer_id	1359992	1359992	1359992
filer_type	16	16	16
active	Y	Y	T
race	0	0	0
session_id	2013	2013	2015
category	40002	40002	40002
category_type	40502	40502	40502
sub_category	0	0	0
effect_dt	2013-08-27 00:00:00	2013-09-06 00:00:00	2016-12-31 00:00:00
sub_category_type	0	0	0
election_type	0	0	0
sub_category_a	None	None	None
nyq_dt	None	2013-08-28 00:00:00	2013-08-28 00:00:00
party_cd	16002	16002	16002
county_cd	18026	18026	18026
district_cd	0	0	0

Table: filer_xref
filer_id		1359992
xref_id		1359992
effect_dt		2013-08-27 00:00:00
migration_source		CLAIMS

Table: filername
xref_filer_id		1359992
filer_id		1359992
filer_type		RECIPIENT COMMITTEE
status		TERMINATED
effect_dt		2016-12-31 00:00:00
naml		HADLEY FOR ASSEMBLY 2014, DAVID
namf		None
namt		None
nams		None
adr1		None
adr2		None
city		MANHATTAN BEACH
st		CA
zip4		90266
phon		3106006937
fax		None
email		[email protected]

Table: filers
filer_id		1359992

Table: received_filings
filer_id	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992	1359992
filing_file_name	1847492_0.cal	1851170_0.cal	1846815_0.cal	1848585_0.cal	1848988_0.cal	1850486_0.cal	1831374_0.cal	1840924_0.cal	1830186_0.cal	1834707_0.cal	1839397_0.cal	1831154_0.cal	1834111_0.cal	1834762_0.cal	1836226_0.cal	1838686_0.cal	1790408_0.cal	1826499_0.cal	1792620_0.cal	1827184_0.cal	1838052_0.cal	1807012_0.cal	1807366_0.cal	1827558_0.cal	1826782_0.cal	1807080_0.cal	1809613_0.cal	1789394_1.cal	1853197_0.cal	1852943_0.cal	1854167_0.cal	1857040_0.cal	1855556_0.cal	1936533_1.cal	1981480_0.cal	344071.cal	1789394_2.cal	344129.cal	2003239_0.cal	1873871_1.cal	1879909_0.cal	1883277_0.cal	1882971_0.cal	1885162_0.cal	1885191_0.cal	1881780_0.cal	1880410_0.cal	1880542_0.cal	1873871_0.cal	1883450_0.cal	1885760_0.cal	1874977_0.cal	1885181_0.cal	1884698_0.cal	1876477_0.cal	1879334_0.cal	1886399_0.cal	1885426_0.cal	1882868_0.cal	1884251_0.cal	1882848_0.cal	1885522_0.cal	2021809_0.cal	1889448_0.cal	1886867_0.cal	1889032_0.cal	1886529_0.cal	1890392_0.cal	1894996_0.cal	1908446_0.cal	1908461_0.cal	1888683_0.cal	1889440_0.cal	1891802_0.cal	1898204_0.cal	1887522_0.cal	1889818_0.cal	1896245_0.cal	1889825_0.cal	1890147_0.cal	1896839_0.cal	1889131_0.cal	1896862_0.cal	1897011_0.cal	1890151_0.cal	1892428_0.cal	1888127_0.cal	1888398_0.cal	1907893_0.cal	1907894_0.cal	1899091_0.cal	1899146_0.cal	1906257_0.cal	1899112_0.cal	1900400_0.cal	1900402_0.cal	1905696_0.cal	1904871_0.cal	1904898_0.cal	1908446_1.cal	1910776_0.cal	1905839_0.cal	1900379_0.cal	1900381_0.cal	1901101_0.cal	1901103_0.cal	1899108_0.cal	1902076_0.cal	1905094_0.cal	1912704_0.cal	1913719_0.cal	1913962_0.cal	1913677_0.cal	1893767_1.cal	1904871_1.cal	1916491_0.cal	1914089_0.cal	1950703_0.cal	1936533_0.cal	1886206_0.cal	1880385_0.cal
received_date	2014-05-06 00:00:00	2014-05-16 00:00:00	2014-05-01 00:00:00	2014-05-08 00:00:00	2014-05-11 00:00:00	2014-05-15 00:00:00	2014-03-21 00:00:00	2014-04-23 00:00:00	2014-03-18 00:00:00	2014-03-31 00:00:00	2014-04-17 00:00:00	2014-03-21 00:00:00	2014-03-26 00:00:00	2014-03-31 00:00:00	2014-04-05 00:00:00	2014-04-15 00:00:00	2013-09-07 00:00:00	2014-03-07 00:00:00	2013-10-02 00:00:00	2014-03-10 00:00:00	2014-04-12 00:00:00	2013-12-10 00:00:00	2013-12-17 00:00:00	2014-03-12 00:00:00	2014-03-08 00:00:00	2013-12-11 00:00:00	2014-01-10 00:00:00	2014-07-30 00:00:00	2014-05-22 00:00:00	2014-05-21 00:00:00	2014-05-22 00:00:00	2014-05-30 00:00:00	2014-05-28 00:00:00	2015-08-26 00:00:00	2015-07-31 00:00:00	2017-02-02 00:00:00	2017-02-02 00:00:00	2017-02-02 00:00:00	2016-01-12 00:00:00	2014-08-06 00:00:00	2014-08-22 00:00:00	2014-09-08 00:00:00	2014-09-05 00:00:00	2014-09-12 00:00:00	2014-09-13 00:00:00	2014-09-02 00:00:00	2014-08-25 00:00:00	2014-08-26 00:00:00	2014-08-06 00:00:00	2014-09-09 00:00:00	2014-09-16 00:00:00	2014-08-07 00:00:00	2014-09-13 00:00:00	2014-09-11 00:00:00	2014-08-12 00:00:00	2014-08-20 00:00:00	2014-09-18 00:00:00	2014-09-15 00:00:00	2014-09-05 00:00:00	2014-09-10 00:00:00	2014-09-05 00:00:00	2014-09-15 00:00:00	2016-03-21 00:00:00	2014-09-29 00:00:00	2014-09-19 00:00:00	2014-09-26 00:00:00	2014-09-18 00:00:00	2014-10-01 00:00:00	2014-10-08 00:00:00	2014-10-29 00:00:00	2014-10-29 00:00:00	2014-09-26 00:00:00	2014-09-29 00:00:00	2014-10-03 00:00:00	2014-10-15 00:00:00	2014-09-23 00:00:00	2014-09-30 00:00:00	2014-10-09 00:00:00	2014-09-30 00:00:00	2014-10-01 00:00:00	2014-10-11 00:00:00	2014-09-27 00:00:00	2014-10-12 00:00:00	2014-10-13 00:00:00	2014-10-01 00:00:00	2014-10-06 00:00:00	2014-09-24 00:00:00	2014-09-25 00:00:00	2014-10-28 00:00:00	2014-10-28 00:00:00	2014-10-16 00:00:00	2014-10-16 00:00:00	2014-10-27 00:00:00	2014-10-16 00:00:00	2014-10-19 00:00:00	2014-10-19 00:00:00	2014-10-25 00:00:00	2014-10-23 00:00:00	2014-10-23 00:00:00	2014-10-30 00:00:00	2014-10-30 00:00:00	2014-10-25 00:00:00	2014-10-19 00:00:00	2014-10-19 00:00:00	2014-10-20 00:00:00	2014-10-20 00:00:00	2014-10-16 00:00:00	2014-10-22 00:00:00	2014-10-24 00:00:00	2014-11-01 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-11-03 00:00:00	2014-11-25 00:00:00	2014-11-25 00:00:00	2014-11-26 00:00:00	2014-11-05 00:00:00	2015-03-04 00:00:00	2015-02-02 00:00:00	2014-09-18 00:00:00	2014-08-25 00:00:00
filing_directory	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/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
filing_id	1847492	1851170	1846815	1848585	1848988	1850486	1831374	1840924	1830186	1834707	1839397	1831154	1834111	1834762	1836226	1838686	1790408	1826499	1792620	1827184	1838052	1807012	1807366	1827558	1826782	1807080	1809613	1789394	1853197	1852943	1854167	1857040	1855556	1936533	1981480	None	1789394	None	2003239	1873871	1879909	1883277	1882971	1885162	1885191	1881780	1880410	1880542	1873871	1883450	1885760	1874977	1885181	1884698	1876477	1879334	1886399	1885426	1882868	1884251	1882848	1885522	2021809	1889448	1886867	1889032	1886529	1890392	1894996	1908446	1908461	1888683	1889440	1891802	1898204	1887522	1889818	1896245	1889825	1890147	1896839	1889131	1896862	1897011	1890151	1892428	1888127	1888398	1907893	1907894	1899091	1899146	1906257	1899112	1900400	1900402	1905696	1904871	1904898	1908446	1910776	1905839	1900379	1900381	1901101	1901103	1899108	1902076	1905094	1912704	1913719	1913962	1913677	1893767	1904871	1916491	1914089	1950703	1936533	1886206	1880385
form_id	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	F410	F460	F497	F497	F497	F497	F460	F460	None	F410	None	F460	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	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	F460	F460	F497	F497	F497	F460	F497	F497
receive_comment	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	Filing accepted	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	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