OpenCalAccess

Filer ID: 1358245

Table: cvr_campaign_disclosure
filing_id	1781937	1827204	1827398	1832244	1833356	1826722	1838013	1830083	1829490	1828108	1830640	1829089	1831359	1832231	1800938	1800938	1796429	1802427	1805025	1806176	1806405	1806176	1818050	1802020	1793216	1793613	1794097	1799525	1826724	1795557	1798760	1797074	1799525	1806619	1806783	1794425	1795888	1828108	1796983	1795870	1793216	1794218	1797412	1792929	1802564	1807557	1783760	1792699	1792562	1792564	1792781	1792820	1847318	1847987	1849168	1836300	1846741	1841136	1836128	1853553	1838139	1839225	1839951	1832231	1837449	1838928	1841273	1841853	1881610	1876847	1886118	1875827	1876847	1877202	1887407	1878378	1877671	1878944	1881610	1884734	1884333	1885784	1859995	1857002	1858026	1858027	1880761	1872435	1858028	1856468	1856634	1850368	1849579	1851049	1852597	1852598	1805025	1818050	1853805	1781937	1796983	1854812	1855411	1893259	1849493	1889083	1889964	1889795	1895488	1895491	1888940	1891702	1930072	1934912	1937268	1904598	1904026	1912380	1911518	1913541	1913546	1913547	1913954	1914002	1919023	1907689	1912471	1919034	1904598	1896110	1898728	1896549	1899488	1900781	1904026	1988032	1893259	1904598	1937268	1981863	2002483
amend_id	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	1	0	0	0	0	0	1	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	0	0	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	1	1	0	1	1	0	0	0	0	0	0	0	0	0	0	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	1	2	1	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	CVR	CVR	CVR	CVR	CVR
form_type	F460	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F460	F497	F497	F497	F497	F460	F497	F497	F497	F460	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F460	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	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	F460	F497	F497	F497	F497	F497	F497	F497	F497	F460	F460	F460	F460	F460	F497	F497	F460	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F460	F460	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F460	F497	F497	F497	F497	F497	F497	F497	F460	F460	F460	F460	F460
filer_id	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245
entity_cd	RCP	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	CTL	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	CTL	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	CTL	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	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
filer_naml	Sebastian Ridley-Thomas for Assembly	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly	Sebastian Ridley-Thomas for Assembly	Sebastian Ridley-Thomas for Assembly	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly	Sebastian Ridley-Thomas for Assembly	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly	Sebastian Ridley-Thomas for Assembly	Sebastian Ridley-Thomas for Assembly	Sebastian Ridley-Thomas for Assembly	Sebastian Ridley-Thomas for Assembly	Sebastian Ridley-Thomas for Assembly	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas 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	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	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	None	None	None	None	None
report_num	000	000	000	000	000	000	000	000	000	001	000	000	000	000	000	1	000	000	000	000	000	1	000	000	1	000	000	1	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	001	000	000	000	000	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	001	001	000	001	001	000	000	000	000	000	000	000	000	000	000	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	001	002	001	000	000
rpt_date	2013-06-30 00:00:00	2014-03-11 00:00:00	2014-03-11 00:00:00	2014-03-24 00:00:00	2014-03-25 00:00:00	2014-03-07 00:00:00	2014-04-11 00:00:00	2014-03-18 00:00:00	2014-03-17 00:00:00	2014-03-19 00:00:00	2014-03-19 00:00:00	2014-03-14 00:00:00	2014-03-21 00:00:00	2014-03-24 00:00:00	2013-10-31 00:00:00	2013-10-31 00:00:00	2013-10-22 00:00:00	2013-11-05 00:00:00	2013-11-21 00:00:00	2013-11-27 00:00:00	2013-12-02 00:00:00	2013-12-03 00:00:00	2013-12-31 00:00:00	2013-11-01 00:00:00	2013-10-10 00:00:00	2013-10-10 00:00:00	2013-10-14 00:00:00	2013-10-30 00:00:00	2014-03-07 00:00:00	2013-10-18 00:00:00	2013-10-29 00:00:00	2013-10-24 00:00:00	2013-10-30 00:00:00	2013-12-03 00:00:00	2013-12-04 00:00:00	2013-10-16 00:00:00	2013-10-21 00:00:00	2014-03-13 00:00:00	2013-10-24 00:00:00	2013-10-11 00:00:00	2013-10-09 00:00:00	2013-10-15 00:00:00	2013-10-25 00:00:00	2013-10-07 00:00:00	2013-11-06 00:00:00	2013-12-17 00:00:00	2013-07-31 00:00:00	2013-10-03 00:00:00	2013-10-02 00:00:00	2013-10-02 00:00:00	2013-10-04 00:00:00	2013-10-05 00:00:00	2014-05-05 00:00:00	2014-05-07 00:00:00	2014-05-12 00:00:00	2014-04-07 00:00:00	2014-05-01 00:00:00	2014-04-24 00:00:00	2014-04-04 00:00:00	2014-05-22 00:00:00	2014-04-14 00:00:00	2014-04-17 00:00:00	2014-04-21 00:00:00	2014-05-22 00:00:00	2014-04-09 00:00:00	2014-04-16 00:00:00	2014-04-24 00:00:00	2014-04-25 00:00:00	2014-09-17 00:00:00	2014-09-17 00:00:00	2014-09-17 00:00:00	2014-08-08 00:00:00	2014-08-13 00:00:00	2014-08-13 00:00:00	2014-09-22 00:00:00	2014-08-18 00:00:00	2014-08-14 00:00:00	2014-08-19 00:00:00	2014-08-29 00:00:00	2014-09-11 00:00:00	2014-09-10 00:00:00	2014-09-16 00:00:00	2014-06-20 00:00:00	2014-05-30 00:00:00	2014-06-03 00:00:00	2014-06-03 00:00:00	2014-08-26 00:00:00	2014-07-31 00:00:00	2014-06-03 00:00:00	2014-05-29 00:00:00	2014-05-30 00:00:00	2014-05-15 00:00:00	2014-05-13 00:00:00	2014-05-16 00:00:00	2014-05-21 00:00:00	2014-05-21 00:00:00	2014-05-22 00:00:00	2014-05-22 00:00:00	2014-05-22 00:00:00	2014-05-22 00:00:00	2014-05-22 00:00:00	2014-05-23 00:00:00	2014-05-27 00:00:00	2014-10-06 00:00:00	2014-05-13 00:00:00	2014-09-27 00:00:00	2014-09-30 00:00:00	2014-09-30 00:00:00	2014-10-08 00:00:00	2014-10-08 00:00:00	2014-09-26 00:00:00	2014-10-03 00:00:00	2015-01-26 00:00:00	2015-01-30 00:00:00	2015-02-02 00:00:00	2015-02-02 00:00:00	2014-10-27 00:00:00	2014-10-31 00:00:00	2014-10-31 00:00:00	2014-11-03 00:00:00	2014-11-03 00:00:00	2014-11-03 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-12-18 00:00:00	2014-10-28 00:00:00	2014-10-31 00:00:00	2014-12-18 00:00:00	2014-10-23 00:00:00	2014-10-09 00:00:00	2014-10-15 00:00:00	2014-10-10 00:00:00	2014-10-16 00:00:00	2014-10-20 00:00:00	2014-10-23 00:00:00	2015-09-01 00:00:00	2015-07-29 00:00:00	2015-07-29 00:00:00	2015-07-29 00:00:00	2015-07-30 00:00:00	2016-01-05 00:00:00
stmt_type	SA	None	None	None	None	None	None	None	None	None	None	None	None	PE	None	None	None	None	PE	None	None	None	SA	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	PE	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	PE	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	SA	None	None	None	None	None	None	None	None	PE	SA	PE	SA	PE	None	None	PE	None	None	None	None	None	None	None	None	None	None	SA	PE	None	None	None	None	None	None	None	None	None	None	None	None	PE	None	None	None	None	None	None	None	PE	PE	SA	SA	TS
late_rptno	None	9792	9793	9971	9994	9771	10189	9898	9896	9847	9931	9874	9953	None	1	2	1	1	None	1	1	2	None	1	1	2	1	2	9772	1	1	2	1	1	1	1	2	9847	None	1	1	1	1	1	1	1	1	1	1	2	1	1	10597	10647	10772	10125	10522	10389	10113	11167	10199	10264	10326	None	10157	10242	10403	10432	11939	11716	12235	11673	11716	11727	12336	11759	11735	11801	11939	12103	12070	12205	11575	11490	11539	11547	11874	None	11548	11417	11449	10917	10844	10993	11109	11112	None	None	None	None	None	11190	11306	None	10812	12536	12623	12592	12938	12949	12492	12744	14364	14378	None	None	13652	14159	14087	14256	14239	14250	14280	14284	14327	13916	14192	14329	None	13001	13258	13102	13343	13461	13652	15019	None	None	None	None	None
from_date	2013-01-01 00:00:00	None	None	None	None	None	None	None	None	None	None	None	None	2014-01-01 00:00:00	None	None	None	None	2013-10-20 00:00:00	None	None	None	2013-11-17 00:00:00	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	2013-07-01 00:00:00	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	2014-01-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	2014-05-18 00:00:00	None	None	None	None	None	None	None	None	2013-10-20 00:00:00	2013-11-17 00:00:00	2014-03-18 00:00:00	2013-01-01 00:00:00	2013-07-01 00:00:00	None	None	2014-07-01 00:00:00	None	None	None	None	None	None	None	None	None	None	2014-10-19 00:00:00	2014-10-01 00:00:00	None	None	None	None	None	None	None	None	None	None	None	None	2014-10-01 00:00:00	None	None	None	None	None	None	None	2014-07-01 00:00:00	2014-10-01 00:00:00	2014-10-19 00:00:00	2015-01-01 00:00:00	2015-07-01 00:00:00
thru_date	2013-06-30 00:00:00	None	None	None	None	None	None	None	None	None	None	None	None	2014-03-17 00:00:00	None	None	None	None	2013-11-16 00:00:00	None	None	None	2013-12-31 00:00:00	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	2013-10-19 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	2014-03-17 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	2014-06-30 00:00:00	None	None	None	None	None	None	None	None	2013-11-16 00:00:00	2013-12-31 00:00:00	2014-05-17 00:00:00	2013-06-30 00:00:00	2013-10-19 00:00:00	None	None	2014-09-30 00:00:00	None	None	None	None	None	None	None	None	None	None	2014-12-31 00:00:00	2014-10-18 00:00:00	None	None	None	None	None	None	None	None	None	None	None	None	2014-10-18 00:00:00	None	None	None	None	None	None	None	2014-09-30 00:00:00	2014-10-18 00:00:00	2014-12-31 00:00:00	2015-06-30 00:00:00	2015-12-03 00:00:00
elect_date	2014-06-06 00:00:00	None	None	None	None	None	None	None	None	None	None	None	None	2014-06-03 00:00:00	None	None	None	None	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	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	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	None	None	None	None	None	None	None	2013-12-03 00:00:00	None	2014-06-03 00:00:00	None	2013-12-03 00:00:00	None	None	2014-11-04 00:00:00	None	None	None	None	None	None	None	None	None	None	None	2014-11-04 00:00:00	None	None	None	None	None	None	None	None	None	None	None	None	2014-11-04 00:00:00	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
filer_city	Los Angeles	Los Angeles	Los Angeles	Sacramento	Sacramento	Los Angeles	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento
filer_st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	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	90046	90046	90046	95814	95814	90046	95814	95814	95814	95814	95814	95814	95814	95814	90046	90046	90046	90046	90046	90046	90046	90046	90046	90046	90046	90046	90046	90046	90046	90046	90046	90046	90046	90046	90046	90046	90046	90046	90046	90046	90046	90046	90046	90046	90046	90046	90046	90046	90046	90046	90046	90046	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814
filer_phon	(213) 479-6620	(213) 479-6620	(213) 479-6620	(916) 442-2952	(916) 442-2952	(213)479-6620	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(213) 479-6620	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952
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	None	None	None	None	None
file_email	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]	None	None	None	None	None	None	None	None	None	None	None	None	None	None	[email protected]	None	None	None	None	None	None	None	None	[email protected]	None	None	None	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]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[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	Sacramento	Sacramento	None	None	Sacramento	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Sacramento	None	None	None	None	None	None	None	None	Sacramento	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
mail_st	None	CA	CA	None	None	CA	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
mail_zip4	None	95814	95814	None	None	95814	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	95814	None	None	None	None	None	None	None	None	95814	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
tres_naml	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	None	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	None	None	None	None	Ridley-Thomas	None	None	None	Ridley-Thomas	None	None	None	None	None	Ridley-Thomas	None	None	None	None	None	None	None	None	Ridley-Thomas	Ridley-Thomas	None	None	None	None	None	None	None	None	None	None	None	None	None	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas
tres_namf	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	None	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	None	None	None	None	Sebastian	None	None	None	Sebastian	None	None	None	None	None	Sebastian	None	None	None	None	None	None	None	None	Sebastian	Sebastian	None	None	None	None	None	None	None	None	None	None	None	None	None	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian
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	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	None	None	None	None	None
tres_city	Los Angeles	Los Angeles	Los Angeles	Sacramento	Sacramento	None	Sacramento	Los Angeles	Los Angeles	Sacramento	Sacramento	Los Angeles	Sacramento	Sacramento	None	None	None	None	Los Angeles	None	None	None	Los Angeles	None	None	None	None	None	Los Angeles	None	None	None	None	None	None	None	None	Los Angeles	Los Angeles	None	None	None	None	None	None	None	None	None	None	None	None	None	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento
tres_st	None	CA	CA	CA	CA	None	CA	CA	CA	CA	CA	CA	CA	CA	None	None	None	None	None	None	None	None	None	None	None	None	None	None	CA	None	None	None	None	None	None	None	None	CA	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	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA
tres_zip4	90046	90046	90046	95814	95814	None	95814	90046	90046	95814	95814	90046	95814	95814	None	None	None	None	90046	None	None	None	90046	None	None	None	None	None	90046	None	None	None	None	None	None	None	None	90046	90046	None	None	None	None	None	None	None	None	None	None	None	None	None	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814
tres_phon	(213) 479-6620	(213) 479-6620	(213) 479-6620	(916) 442-2952	(916) 442-2952	None	(916) 442-2952	(213) 479-6620	(213) 479-6620	(916) 442-2952	(916) 442-2952	(213) 479-6620	(916) 442-2952	(916) 442-2952	None	None	None	None	(213) 479-6620	None	None	None	(213) 479-6620	None	None	None	None	None	(213) 479-6620	None	None	None	None	None	None	None	None	(213) 479-6620	(213) 479-6620	None	None	None	None	None	None	None	None	None	None	None	None	None	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952
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	None	None	None	None	None
tres_email	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None	None	C	None	None	None	None	C	None	None	None	C	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	C	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	C	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	C	None	None	None	None	None	None	None	None	C	C	C	C	C	None	None	C	None	None	None	None	None	None	None	None	None	None	C	C	None	None	None	None	None	None	None	None	None	None	None	None	C	None	None	None	None	None	None	None	C	C	C	C	C
control_yn	Y	None	None	None	None	None	None	None	None	None	None	None	None	Y	None	None	None	None	Y	None	None	None	Y	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Y	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Y	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Y	None	None	None	None	None	None	None	None	Y	Y	Y	Y	Y	None	None	Y	None	None	None	None	None	None	None	None	None	None	Y	Y	None	None	None	None	None	None	None	None	None	None	None	None	Y	None	None	None	None	None	None	None	Y	Y	Y	Y	Y
sponsor_yn	N	None	None	None	None	None	None	None	None	None	None	None	None	N	None	None	None	None	N	None	None	None	N	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	N	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	N	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	N	None	None	None	None	None	None	None	None	N	N	N	N	N	None	None	N	None	None	None	None	None	None	None	None	None	None	N	N	None	None	None	None	None	None	None	None	None	None	None	None	N	None	None	None	None	None	None	None	N	N	N	N	N
primfrm_yn	None	None	None	None	None	None	None	None	None	None	None	None	None	N	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	N	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	N	None	None	None	None	None	None	None	None	N	N	N	N	N	None	None	N	None	None	None	None	None	None	None	None	None	None	N	N	None	None	None	None	None	None	None	None	None	None	None	None	N	None	None	None	None	None	None	None	N	N	N	N	N
brdbase_yn	None	None	None	None	None	None	None	None	None	None	None	None	None	N	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	N	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	N	None	None	None	None	None	None	None	None	N	N	N	N	N	None	None	N	None	None	None	None	None	None	None	None	None	None	N	N	None	None	None	None	None	None	None	None	None	None	None	None	N	None	None	None	None	None	None	None	N	N	N	N	N
amendexp_1	None	None	None	None	None	None	None	None	None	Update contribution amount	None	None	None	None	None	Amend contributions	None	None	None	None	None	Amend contributions	None	None	Amend contributions and contributions made	None	None	Amend contributions	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Update Summary Page, Schedule F, and Schedule G	None	None	None	None	Remove contribution	Remove voided contribution	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Update Summary Page, Schedule A, Schedule E, Schedule F, and Schedule G	Update Summary Page, Schedule A, Schedule D, Schedule E, Schedule F, and Schedule G	None	Update Summary Page and Schedule A	Update Summary Page, Schedule A, Schedule C, Schedule D, Schedule E, Schedule F, and Schedule G	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Update Summary Page, Schedule A, Schedule F, and Schedule G	Update contributions made	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Update Summary page and Schedule F	Update Summary page & Schedule F	Update Summary page and Schedule F	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	None	None	None	None	None
cand_naml	Sebastian	None	None	None	None	None	None	None	None	None	None	None	None	Ridley-Thomas	None	None	None	None	Sebastian	None	None	None	Sebastian	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Sebastian	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Ridley-Thomas	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Ridley-Thomas	None	None	None	None	None	None	None	None	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	None	None	Ridley-Thomas	None	None	None	None	None	None	None	None	None	None	Ridley-Thomas	Ridley-Thomas	None	None	None	None	None	None	None	None	None	None	None	None	Ridley-Thomas	None	None	None	None	None	None	None	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas
cand_namf	Ridley-Thomas	None	None	None	None	None	None	None	None	None	None	None	None	Sebastian	None	None	None	None	Ridley-Thomas	None	None	None	Ridley-Thomas	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Ridley-Thomas	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Sebastian	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Sebastian	None	None	None	None	None	None	None	None	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian	None	None	Sebastian	None	None	None	None	None	None	None	None	None	None	Sebastian	Sebastian	None	None	None	None	None	None	None	None	None	None	None	None	Sebastian	None	None	None	None	None	None	None	Sebastian	Sebastian	Sebastian	Sebastian	Sebastian
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	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	None	None	None	None	None
cand_city	Los Angeles	None	None	None	None	None	None	None	None	None	None	None	None	Sacramento	None	None	None	None	Los Angeles	None	None	None	Los Angeles	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Los Angeles	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Sacramento	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Sacramento	None	None	None	None	None	None	None	None	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	None	None	Sacramento	None	None	None	None	None	None	None	None	None	None	Sacramento	Sacramento	None	None	None	None	None	None	None	None	None	None	None	None	Sacramento	None	None	None	None	None	None	None	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento
cand_st	CA	None	None	None	None	None	None	None	None	None	None	None	None	CA	None	None	None	None	CA	None	None	None	CA	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	CA	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	CA	None	None	None	None	None	None	None	None	CA	CA	CA	CA	CA	None	None	CA	None	None	None	None	None	None	None	None	None	None	CA	CA	None	None	None	None	None	None	None	None	None	None	None	None	CA	None	None	None	None	None	None	None	CA	CA	CA	CA	CA
cand_zip4	90071	None	None	None	None	None	None	None	None	None	None	None	None	95814	None	None	None	None	90071	None	None	None	90071	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	90071	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	95814	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	95814	None	None	None	None	None	None	None	None	95814	95814	95814	95814	95814	None	None	95814	None	None	None	None	None	None	None	None	None	None	95814	95814	None	None	None	None	None	None	None	None	None	None	None	None	95814	None	None	None	None	None	None	None	95814	95814	95814	95814	95814
cand_phon	None	None	None	None	None	None	None	None	None	None	None	None	None	(916) 442-2952	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	(916) 442-2952	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	(916) 442-2952	None	None	None	None	None	None	None	None	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	None	None	(916) 442-2952	None	None	None	None	None	None	None	None	None	None	(916) 442-2952	(916) 442-2952	None	None	None	None	None	None	None	None	None	None	None	None	(916) 442-2952	None	None	None	None	None	None	None	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952	(916) 442-2952
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	None	None	None	None	None
cand_email	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bal_name	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	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	None	None	None	None	None
office_cd	None	None	None	None	None	None	None	None	None	None	None	None	None	ASM	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	ASM	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	ASM	None	None	None	None	None	None	None	None	ASM	ASM	ASM	ASM	ASM	None	None	ASM	None	None	None	None	None	None	None	None	None	None	ASM	ASM	None	None	None	None	None	None	None	None	None	None	None	None	ASM	None	None	None	None	None	None	None	ASM	ASM	ASM	ASM	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	None	None	None	None	None
juris_cd	None	None	None	None	None	None	None	None	None	None	None	None	None	ASM	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	ASM	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	ASM	None	None	None	None	None	None	None	None	ASM	ASM	ASM	ASM	ASM	None	None	ASM	None	None	None	None	None	None	None	None	None	None	ASM	ASM	None	None	None	None	None	None	None	None	None	None	None	None	ASM	None	None	None	None	None	None	None	ASM	ASM	ASM	ASM	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	None	None	None	None	None
dist_no	0	None	None	None	None	None	None	None	None	None	None	None	None	54	None	None	None	None	0	None	None	None	0	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	0	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	54	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	54	None	None	None	None	None	None	None	None	54	54	54	54	54	None	None	54	None	None	None	None	None	None	None	None	None	None	54	54	None	None	None	None	None	None	None	None	None	None	None	None	54	None	None	None	None	None	None	None	54	54	54	54	54
off_s_h_cd	S	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	S	None	None	None	S	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
sup_opp_cd	S	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	S	None	None	None	S	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
employer	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	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	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	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	None	None	None	None	None

Table: cvr_so
filing_id	1830912	1830912	1830912
amend_id	0	1	2
rec_type	CVR	CVR	CVR
form_type	F410	F410	F410
filer_id	1358245	1358245	1358245
entity_cd	RCP	RCP	RCP
filer_naml	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas for Assembly 2014	Sebastian Ridley-Thomas 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	2014-03-20 00:00:00	2014-03-20 00:00:00	2016-01-05 00:00:00
qual_cb	X	X	X
qualfy_dt	2013-06-17 00:00:00	2013-06-17 00:00:00	2013-06-17 00:00:00
term_date	None	None	2015-12-03 00:00:00
city	Sacramento	Sacramento	Sacramento
st	CA	CA	CA
zip4	95814	95814	95814
phone	(916) 442-2952	(916) 442-2952	(916) 442-2952
county_res	Sacramento	Sacramento	Sacramento
county_act	None	None	None
mail_city	None	None	None
mail_st	None	None	None
mail_zip4	None	None	None
cmte_fax	None	None	None
cmte_email	[email protected]	[email protected]	[email protected]
tres_naml	Ridley-Thomas	Ridley-Thomas	Ridley-Thomas
tres_namf	Sebastian	Sebastian	Sebastian
tres_namt	None	None	None
tres_nams	None	None	None
tres_city	Sacramento	Sacramento	Sacramento
tres_st	CA	CA	CA
tres_zip4	95814	95814	95814
tres_phon	(916) 442-2952	(916) 442-2952	(916) 442-2952
actvty_lvl	None	None	None
com82013yn	None	None	None
com82013nm	None	None	None
com82013id	None	None	None
control_cb	X	X	X
bank_nam	One United Bank	One United Bank	One United Bank
bank_adr1	3683 Crenshaw Blvd.	3683 Crenshaw Blvd.	3683 Crenshaw Blvd.
bank_adr2	None	None	None
bank_city	Los Angeles	Los Angeles	Los Angeles
bank_st	CA	CA	CA
bank_zip4	90016	90016	90016
bank_phon	(323) 290-4848	(323) 290-4848	(323) 290-4848
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	1358245	1358245
adrid	2289566	2315096
effect_dt	2013-06-10 00:00:00	2014-03-20 00:00:00
add_type	7051	7051
session_id	2013	2013

Table: filer_filings
filer_id	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245
filing_id	1770443	1783760	1781937	1785501	1776767	1893259	1904598	1937268	1981863	1872435	1856468	1849168	1820902	1805835	1798303	1796983	1818050	1855411	1857002	1858026	1833647	1785501	1849493	1832231	1854812	1859995	1781937	1805025	1854659	1838928	1856634	1853553	1853805	1841853	1798760	1795870	1797074	1802020	1805835	1806783	1807557	1794218	1792562	1792564	1792929	1793216	1798303	1796429	1797412	1802427	1800938	1806176	1800938	1792699	1792781	1792820	1793216	1793613	1806405	1806176	1794097	1795557	1794425	1795888	1930072	1940872	1934912	1937268	1904598	1891702	1893259	1911518	1895491	1889964	1889795	1912471	1894386	1912380	1878378	1896110	1895488	1896549	1880761	1900781	1899488	1904026	1904026	1907367	1802564	1826722	1826724	1829089	1829490	1806619	1830640	1828108	1828108	1830912	1830912	1832231	1830083	1831359	1827398	1818050	1827204	1805025	1833356	1832244	1796983	1799525	1799525	1820902	1907689	1919034	1898728	1913541	1913546	1913954	1914002	1919023	1913547	1904598	1888940	1877202	1858028	1889083	1881610	1876847	1886118	1858027	1875827	1876847	1878944	1881610	1877671	1878751	1884734	1884333	1885784	1887407	1847318	1847987	1850368	1849579	1851049	1836760	1841136	1846741	1852597	1852598	1833647	1836128	1836300	1838013	1838139	1839225	1839951	1837449	1841273	1983593	2002483	1940872	1907367	1894386	1907367	1830912	2002599	1988032	2019620	2003056
period_id	None	215	213	None	None	219	220	220	221	218	218	218	None	None	None	215	216	218	218	218	None	None	218	217	218	218	213	216	None	218	218	218	217	218	216	216	216	216	None	216	216	216	216	216	216	216	None	216	216	216	216	216	216	216	216	216	216	216	216	216	216	216	216	216	221	None	221	220	220	220	219	220	220	219	219	220	None	220	219	220	220	220	219	220	220	220	220	None	216	217	217	217	217	216	217	217	217	217	217	217	217	217	217	216	217	216	217	217	215	216	216	None	220	220	220	220	220	220	220	220	220	220	219	219	218	219	219	219	219	218	219	219	219	219	219	None	219	219	219	219	218	218	218	218	218	None	218	218	218	218	None	218	218	218	218	218	218	218	218	None	223	None	None	None	None	225	None	223	None	None
form_id	F410	F497	F460	F460	F410	F460	F460	F460	F460	F460	F497	F497	F460	F460	F460	F460	F460	F497	F497	F497	F460	F460	F497	F460	F497	F497	F460	F460	F460	F497	F497	F497	F460	F497	F497	F497	F497	F497	F460	F497	F497	F497	F497	F497	F497	F497	F460	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F460	F497	F460	F460	F497	F460	F497	F497	F497	F497	F497	F460	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F460	F497	F497	F497	F497	F497	F497	F497	F497	F497	F410	F410	F460	F497	F497	F497	F460	F497	F460	F497	F497	F460	F497	F497	F460	F497	F497	F497	F497	F497	F497	F497	F497	F497	F460	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F460	F497	F497	F497	F497	F497	F497	F497	F497	F497	F410	F497	F497	F497	F497	F460	F497	F497	F497	F497	F497	F497	F497	F497	F460	F460	F460	F460	F460	F460	F410	F410	F497	F666	F460
filing_sequence	0	0	0	0	0	1	2	1	0	0	0	0	1	1	1	1	1	0	0	0	1	1	0	1	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	1	0	0	0	0	0	1	0	0	1	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	1	0	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	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	0	0	0	0	1	2	1	1	2	0	0	0	0
filing_date	2013-06-10 00:00:00	2013-07-31 00:00:00	2013-07-31 00:00:00	2013-07-31 00:00:00	2013-07-12 00:00:00	2015-07-31 00:00:00	2015-07-31 00:00:00	2015-07-31 00:00:00	2015-07-31 00:00:00	2014-07-31 00:00:00	2014-05-29 00:00:00	2014-05-12 00:00:00	2014-05-22 00:00:00	2014-05-22 00:00:00	2014-05-22 00:00:00	2014-05-22 00:00:00	2014-05-22 00:00:00	2014-05-27 00:00:00	2014-05-30 00:00:00	2014-06-03 00:00:00	2014-05-22 00:00:00	2014-05-22 00:00:00	2014-05-13 00:00:00	2014-05-22 00:00:00	2014-05-23 00:00:00	2014-06-20 00:00:00	2014-05-22 00:00:00	2014-05-22 00:00:00	2014-05-22 00:00:00	2014-04-16 00:00:00	2014-05-30 00:00:00	2014-05-22 00:00:00	2014-05-22 00:00:00	2014-04-25 00:00:00	2013-10-29 00:00:00	2013-10-21 00:00:00	2013-10-24 00:00:00	2013-11-01 00:00:00	2013-11-21 00:00:00	2013-12-04 00:00:00	2013-12-17 00:00:00	2013-10-15 00:00:00	2013-10-02 00:00:00	2013-10-02 00:00:00	2013-10-07 00:00:00	2013-10-09 00:00:00	2013-10-25 00:00:00	2013-10-22 00:00:00	2013-10-25 00:00:00	2013-11-05 00:00:00	2013-10-31 00:00:00	2013-11-27 00:00:00	2013-10-31 00:00:00	2013-10-03 00:00:00	2013-10-04 00:00:00	2013-10-05 00:00:00	2013-10-10 00:00:00	2013-10-10 00:00:00	2013-12-03 00:00:00	2013-12-03 00:00:00	2013-10-14 00:00:00	2013-10-18 00:00:00	2013-10-16 00:00:00	2013-10-21 00:00:00	2015-01-26 00:00:00	2015-07-31 00:00:00	2015-01-30 00:00:00	2015-02-02 00:00:00	2015-02-02 00:00:00	2014-10-03 00:00:00	2014-10-06 00:00:00	2014-10-31 00:00:00	2014-10-08 00:00:00	2014-09-30 00:00:00	2014-09-30 00:00:00	2014-10-31 00:00:00	2014-10-06 00:00:00	2014-10-31 00:00:00	2014-08-18 00:00:00	2014-10-09 00:00:00	2014-10-08 00:00:00	2014-10-10 00:00:00	2014-08-26 00:00:00	2014-10-20 00:00:00	2014-10-16 00:00:00	2014-10-23 00:00:00	2014-10-27 00:00:00	2014-10-23 00:00:00	2013-11-06 00:00:00	2014-03-07 00:00:00	2014-03-07 00:00:00	2014-03-14 00:00:00	2014-03-17 00:00:00	2013-12-03 00:00:00	2014-03-19 00:00:00	2014-03-13 00:00:00	2014-03-19 00:00:00	2014-03-20 00:00:00	2014-03-20 00:00:00	2014-03-24 00:00:00	2014-03-18 00:00:00	2014-03-21 00:00:00	2014-03-11 00:00:00	2014-01-31 00:00:00	2014-03-11 00:00:00	2013-11-21 00:00:00	2014-03-25 00:00:00	2014-03-24 00:00:00	2013-10-24 00:00:00	2013-10-30 00:00:00	2013-10-30 00:00:00	2014-01-31 00:00:00	2014-10-28 00:00:00	2014-12-18 00:00:00	2014-10-15 00:00:00	2014-11-03 00:00:00	2014-11-03 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-12-18 00:00:00	2014-11-03 00:00:00	2014-10-23 00:00:00	2014-09-26 00:00:00	2014-08-13 00:00:00	2014-06-03 00:00:00	2014-09-27 00:00:00	2014-09-17 00:00:00	2014-09-17 00:00:00	2014-09-17 00:00:00	2014-06-03 00:00:00	2014-08-08 00:00:00	2014-08-13 00:00:00	2014-08-19 00:00:00	2014-08-29 00:00:00	2014-08-14 00:00:00	2014-08-01 00:00:00	2014-09-11 00:00:00	2014-09-10 00:00:00	2014-09-16 00:00:00	2014-09-22 00:00:00	2014-05-05 00:00:00	2014-05-07 00:00:00	2014-05-15 00:00:00	2014-05-13 00:00:00	2014-05-16 00:00:00	2014-03-20 00:00:00	2014-04-24 00:00:00	2014-05-01 00:00:00	2014-05-21 00:00:00	2014-05-21 00:00:00	2014-03-24 00:00:00	2014-04-04 00:00:00	2014-04-07 00:00:00	2014-04-11 00:00:00	2014-04-14 00:00:00	2014-04-17 00:00:00	2014-04-21 00:00:00	2014-04-09 00:00:00	2014-04-24 00:00:00	2015-07-31 00:00:00	2016-01-05 00:00:00	2015-07-31 00:00:00	2015-07-31 00:00:00	2015-07-31 00:00:00	2015-02-02 00:00:00	2016-01-05 00:00:00	2016-01-05 00:00:00	2015-09-01 00:00:00	2016-02-29 00:00:00	2016-01-05 00:00:00
stmnt_type	10005	10001	10001	10005	10006	10002	10002	10002	10001	10001	10001	10001	10006	10006	10006	10002	10002	10001	10001	10001	10006	10006	10001	10002	10001	10001	10002	10002	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10002	10001	10001	10001	10001	10001	10002	10001	10001	10002	10001	10001	10001	10001	10001	10005	10001	10001	10002	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10002	10005	10001	10001	10001	10001	10001	10001	10001	10001	10002	10001	10002	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10002	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10002	10002	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10006	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10006	10006	10006	10006	10003	10003	10001	10005	10003
stmnt_status	11003	11001	11001	11001	11001	11003	11003	11003	11001	11003	11001	11001	11003	11003	11003	11003	11001	11001	11001	11001	11003	11003	11001	11003	11001	11001	11003	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	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	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11003	11003	11003	11001	11001	11001	11003	11003
session_id	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	2015	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	2015	2015	2013	2013	2013	2013	2015	2015	2015	2013	2015
user_id	GPEREZ	WBROWN	MDIGRAZIA	MDIGRAZIA	TRAMON	CAFILER	CAFILER	CAFILER	SARRIAGA	CAFILER	CREYNOLDS	CREYNOLDS	MPACHECO	MPACHECO	MPACHECO	CAFILER	MDIGRAZIA	CREYNOLDS	CREYNOLDS	CREYNOLDS	MPACHECO	MPACHECO	CREYNOLDS	CAFILER	CREYNOLDS	CREYNOLDS	CAFILER	MDIGRAZIA	GPEREZ	CREYNOLDS	CREYNOLDS	CREYNOLDS	CAFILER	CREYNOLDS	WBROWN	WBROWN	WBROWN	WBROWN	CPON	WBROWN	WBROWN	WBROWN	WBROWN	WBROWN	WBROWN	WBROWN	CPON	WBROWN	WBROWN	WBROWN	WBROWN	WBROWN	WBROWN	WBROWN	WBROWN	WBROWN	WBROWN	WBROWN	WBROWN	WBROWN	WBROWN	WBROWN	WBROWN	WBROWN	GKURIMOT	MPACHECO	CREYNOLDS	MDIGRAZIA	MDIGRAZIA	CREYNOLDS	SMCCONNAN	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	SMCCONNAN	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	SARRIAGA	WBROWN	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	WBROWN	CREYNOLDS	GKURIMOT	GKURIMOT	CAFILER	TRAMON	MDIGRAZIA	CREYNOLDS	CREYNOLDS	CREYNOLDS	MDIGRAZIA	CREYNOLDS	CPON	CREYNOLDS	CREYNOLDS	CPON	WBROWN	WBROWN	MDIGRAZIA	CREYNOLDS	GKURIMOT	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	GKURIMOT	CREYNOLDS	SARRIAGA	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	GPEREZ	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	TRAMON	CREYNOLDS	CREYNOLDS	GKURIMOT	GKURIMOT	MDIGRAZIA	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	CREYNOLDS	SARRIAGA	CAFILER	MPACHECO	MPACHECO	MPACHECO	MPACHECO	TRAMON	TRAMON	RGEREMIA	SBROWN	MPACHECO
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	11003	11003	11003	11003	11003
fine_audit	11003	11001	11001	11001	11003	11003	11003	11003	11003	11003	11001	11001	11003	11003	11003	11003	11003	11001	11001	11001	11003	11003	11001	11003	11001	11001	11003	11003	11003	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11003	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11003	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11003	11003	11003	11003	11003	11003	11001	11003	11003
rpt_start	None	2013-07-31 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	None	2014-07-01 00:00:00	2014-10-01 00:00:00	2014-10-19 00:00:00	2015-01-01 00:00:00	2014-05-18 00:00:00	2014-05-29 00:00:00	2014-05-12 00:00:00	2013-11-17 00:00:00	2013-10-20 00:00:00	2013-07-01 00:00:00	2013-07-01 00:00:00	2013-11-17 00:00:00	2014-05-27 00:00:00	2014-05-30 00:00:00	2014-06-03 00:00:00	2014-01-01 00:00:00	2013-01-01 00:00:00	2014-05-13 00:00:00	2014-01-01 00:00:00	2014-05-23 00:00:00	2014-06-20 00:00:00	2013-01-01 00:00:00	2013-10-20 00:00:00	2014-03-18 00:00:00	2014-04-16 00:00:00	2014-05-30 00:00:00	2014-05-22 00:00:00	2014-03-18 00:00:00	2014-04-25 00:00:00	2013-10-29 00:00:00	2013-10-11 00:00:00	2013-10-24 00:00:00	2013-11-01 00:00:00	2013-10-20 00:00:00	2013-12-04 00:00:00	2013-12-17 00:00:00	2013-10-15 00:00:00	2013-10-02 00:00:00	2013-10-02 00:00:00	2013-10-07 00:00:00	2013-10-09 00:00:00	2013-07-01 00:00:00	2013-10-22 00:00:00	2013-10-25 00:00:00	2013-11-05 00:00:00	2013-10-31 00:00:00	2013-11-27 00:00:00	2013-10-31 00:00:00	2013-10-03 00:00:00	2013-10-04 00:00:00	2013-10-05 00:00:00	2013-10-10 00:00:00	2013-10-10 00:00:00	2013-12-02 00:00:00	2013-12-03 00:00:00	2013-10-14 00:00:00	2013-10-18 00:00:00	2013-10-16 00:00:00	2013-10-21 00:00:00	2015-01-26 00:00:00	2014-10-19 00:00:00	2015-01-30 00:00:00	2014-10-19 00:00:00	2014-10-01 00:00:00	2014-10-03 00:00:00	2014-07-01 00:00:00	2014-10-31 00:00:00	2014-10-08 00:00:00	2014-09-30 00:00:00	2014-09-30 00:00:00	2014-10-31 00:00:00	2014-07-01 00:00:00	2014-10-31 00:00:00	2014-08-18 00:00:00	2014-10-09 00:00:00	2014-10-08 00:00:00	2014-10-10 00:00:00	2014-08-26 00:00:00	2014-10-20 00:00:00	2014-10-16 00:00:00	2014-10-23 00:00:00	2014-10-27 00:00:00	2014-10-01 00:00:00	2013-11-06 00:00:00	2014-03-07 00:00:00	2014-03-07 00:00:00	2014-03-14 00:00:00	2014-03-17 00:00:00	2013-12-03 00:00:00	2014-03-19 00:00:00	2014-03-13 00:00:00	2014-03-19 00:00:00	2014-03-20 00:00:00	2014-03-20 00:00:00	2014-01-01 00:00:00	2014-03-18 00:00:00	2014-03-21 00:00:00	2014-03-11 00:00:00	2013-11-17 00:00:00	2014-03-11 00:00:00	2013-10-20 00:00:00	2014-03-25 00:00:00	2014-03-24 00:00:00	2013-07-01 00:00:00	2013-10-30 00:00:00	2013-10-30 00:00:00	2013-11-17 00:00:00	2014-10-28 00:00:00	2014-12-18 00:00:00	2014-10-15 00:00:00	2014-11-03 00:00:00	2014-11-03 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-12-18 00:00:00	2014-11-03 00:00:00	2014-10-01 00:00:00	2014-09-26 00:00:00	2014-08-13 00:00:00	2014-06-03 00:00:00	2014-09-27 00:00:00	2014-09-17 00:00:00	2014-09-17 00:00:00	2014-09-17 00:00:00	2014-06-03 00:00:00	2014-08-08 00:00:00	2014-08-13 00:00:00	2014-08-19 00:00:00	2014-08-29 00:00:00	2014-08-14 00:00:00	2014-05-18 00:00:00	2014-09-11 00:00:00	2014-09-10 00:00:00	2014-09-16 00:00:00	2014-09-22 00:00:00	2014-05-05 00:00:00	2014-05-07 00:00:00	2014-05-15 00:00:00	2014-05-13 00:00:00	2014-05-16 00:00:00	None	2014-04-24 00:00:00	2014-05-01 00:00:00	2014-05-21 00:00:00	2014-05-21 00:00:00	2014-01-01 00:00:00	2014-04-04 00:00:00	2014-04-07 00:00:00	2014-04-11 00:00:00	2014-04-14 00:00:00	2014-04-17 00:00:00	2014-04-21 00:00:00	2014-04-09 00:00:00	2014-04-24 00:00:00	2015-01-01 00:00:00	2015-07-01 00:00:00	2014-10-19 00:00:00	2014-10-01 00:00:00	2014-07-01 00:00:00	2014-10-01 00:00:00	2016-01-05 00:00:00	None	2015-09-01 00:00:00	2013-01-01 00:00:00	2015-07-01 00:00:00
rpt_end	None	2013-07-31 00:00:00	2013-06-30 00:00:00	2013-06-30 00:00:00	None	2014-09-30 00:00:00	2014-10-18 00:00:00	2014-12-31 00:00:00	2015-06-30 00:00:00	2014-06-30 00:00:00	2014-05-29 00:00:00	2014-05-12 00:00:00	2013-12-31 00:00:00	2013-11-16 00:00:00	2013-10-19 00:00:00	2013-10-19 00:00:00	2013-12-31 00:00:00	2014-05-27 00:00:00	2014-05-30 00:00:00	2014-06-03 00:00:00	2014-03-17 00:00:00	2013-06-30 00:00:00	2014-05-13 00:00:00	2014-03-17 00:00:00	2014-05-23 00:00:00	2014-06-20 00:00:00	2013-06-30 00:00:00	2013-11-16 00:00:00	2014-05-17 00:00:00	2014-04-16 00:00:00	2014-05-30 00:00:00	2014-05-22 00:00:00	2014-05-17 00:00:00	2014-04-25 00:00:00	2013-10-29 00:00:00	2013-10-11 00:00:00	2013-10-24 00:00:00	2013-11-01 00:00:00	2013-11-16 00:00:00	2013-12-04 00:00:00	2013-12-17 00:00:00	2013-10-15 00:00:00	2013-10-02 00:00:00	2013-10-02 00:00:00	2013-10-07 00:00:00	2013-10-09 00:00:00	2013-10-19 00:00:00	2013-10-22 00:00:00	2013-10-25 00:00:00	2013-11-05 00:00:00	2013-10-31 00:00:00	2013-11-27 00:00:00	2013-10-31 00:00:00	2013-10-03 00:00:00	2013-10-04 00:00:00	2013-10-05 00:00:00	2013-10-10 00:00:00	2013-10-10 00:00:00	2013-12-02 00:00:00	2013-12-03 00:00:00	2013-10-14 00:00:00	2013-10-18 00:00:00	2013-10-16 00:00:00	2013-10-21 00:00:00	2015-01-26 00:00:00	2014-12-31 00:00:00	2015-01-30 00:00:00	2014-12-31 00:00:00	2014-10-18 00:00:00	2014-10-03 00:00:00	2014-09-30 00:00:00	2014-10-31 00:00:00	2014-10-08 00:00:00	2014-09-30 00:00:00	2014-09-30 00:00:00	2014-10-31 00:00:00	2014-09-30 00:00:00	2014-10-31 00:00:00	2014-08-18 00:00:00	2014-10-09 00:00:00	2014-10-08 00:00:00	2014-10-10 00:00:00	2014-08-26 00:00:00	2014-10-20 00:00:00	2014-10-16 00:00:00	2014-10-23 00:00:00	2014-10-27 00:00:00	2014-10-18 00:00:00	2013-11-06 00:00:00	2014-03-07 00:00:00	2014-03-07 00:00:00	2014-03-14 00:00:00	2014-03-17 00:00:00	2013-12-03 00:00:00	2014-03-19 00:00:00	2014-03-13 00:00:00	2014-03-19 00:00:00	2014-03-20 00:00:00	2014-03-20 00:00:00	2014-03-17 00:00:00	2014-03-18 00:00:00	2014-03-21 00:00:00	2014-03-11 00:00:00	2013-12-31 00:00:00	2014-03-11 00:00:00	2013-11-16 00:00:00	2014-03-25 00:00:00	2014-03-24 00:00:00	2013-10-19 00:00:00	2013-10-30 00:00:00	2013-10-30 00:00:00	2013-12-31 00:00:00	2014-10-28 00:00:00	2014-12-18 00:00:00	2014-10-15 00:00:00	2014-11-03 00:00:00	2014-11-03 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-12-18 00:00:00	2014-11-03 00:00:00	2014-10-18 00:00:00	2014-09-26 00:00:00	2014-08-13 00:00:00	2014-06-03 00:00:00	2014-09-27 00:00:00	2014-09-17 00:00:00	2014-09-17 00:00:00	2014-09-17 00:00:00	2014-06-03 00:00:00	2014-08-08 00:00:00	2014-08-13 00:00:00	2014-08-19 00:00:00	2014-08-29 00:00:00	2014-08-14 00:00:00	2014-06-30 00:00:00	2014-09-11 00:00:00	2014-09-10 00:00:00	2014-09-16 00:00:00	2014-09-22 00:00:00	2014-05-05 00:00:00	2014-05-07 00:00:00	2014-05-15 00:00:00	2014-05-13 00:00:00	2014-05-16 00:00:00	None	2014-04-24 00:00:00	2014-05-01 00:00:00	2014-05-21 00:00:00	2014-05-21 00:00:00	2014-03-17 00:00:00	2014-04-04 00:00:00	2014-04-07 00:00:00	2014-04-11 00:00:00	2014-04-14 00:00:00	2014-04-17 00:00:00	2014-04-21 00:00:00	2014-04-09 00:00:00	2014-04-24 00:00:00	2015-06-30 00:00:00	2015-12-03 00:00:00	2014-12-31 00:00:00	2014-10-18 00:00:00	2014-09-30 00:00:00	2014-10-18 00:00:00	2016-01-05 00:00:00	None	2015-09-01 00:00:00	2013-12-31 00:00:00	2015-12-03 00:00:00
rpt_date	None	2013-07-31 00:00:00	2013-06-30 00:00:00	None	None	2015-07-29 00:00:00	2015-07-29 00:00:00	2015-07-29 00:00:00	2015-07-30 00:00:00	2014-07-31 00:00:00	2014-05-29 00:00:00	2014-05-12 00:00:00	None	None	None	2014-05-22 00:00:00	2014-05-22 00:00:00	2014-05-27 00:00:00	2014-05-30 00:00:00	2014-06-03 00:00:00	None	None	2014-05-13 00:00:00	2014-05-22 00:00:00	2014-05-23 00:00:00	2014-06-20 00:00:00	2014-05-22 00:00:00	2014-05-22 00:00:00	None	2014-04-16 00:00:00	2014-05-30 00:00:00	2014-05-22 00:00:00	2014-05-22 00:00:00	2014-04-25 00:00:00	2013-10-29 00:00:00	2013-10-11 00:00:00	2013-10-24 00:00:00	2013-11-01 00:00:00	None	2013-12-04 00:00:00	2013-12-17 00:00:00	2013-10-15 00:00:00	2013-10-02 00:00:00	2013-10-02 00:00:00	2013-10-07 00:00:00	2013-10-09 00:00:00	None	2013-10-22 00:00:00	2013-10-25 00:00:00	2013-11-05 00:00:00	2013-10-31 00:00:00	2013-11-27 00:00:00	2013-10-31 00:00:00	2013-10-03 00:00:00	2013-10-04 00:00:00	2013-10-05 00:00:00	2013-10-10 00:00:00	2013-10-10 00:00:00	2013-12-02 00:00:00	2013-12-03 00:00:00	2013-10-14 00:00:00	2013-10-18 00:00:00	2013-10-16 00:00:00	2013-10-21 00:00:00	2015-01-26 00:00:00	None	2015-01-30 00:00:00	2015-02-02 00:00:00	2015-02-02 00:00:00	2014-10-03 00:00:00	2014-10-06 00:00:00	2014-10-31 00:00:00	2014-10-08 00:00:00	2014-09-30 00:00:00	2014-09-30 00:00:00	2014-10-31 00:00:00	None	2014-10-31 00:00:00	2014-08-18 00:00:00	2014-10-09 00:00:00	2014-10-08 00:00:00	2014-10-10 00:00:00	2014-08-26 00:00:00	2014-10-20 00:00:00	2014-10-16 00:00:00	2014-10-23 00:00:00	2014-10-27 00:00:00	None	2013-11-06 00:00:00	2014-03-07 00:00:00	2014-03-07 00:00:00	2014-03-14 00:00:00	2014-03-17 00:00:00	2013-12-03 00:00:00	2014-03-19 00:00:00	2014-03-13 00:00:00	2014-03-19 00:00:00	None	None	2014-03-24 00:00:00	2014-03-18 00:00:00	2014-03-21 00:00:00	2014-03-11 00:00:00	2013-12-31 00:00:00	2014-03-11 00:00:00	2013-11-21 00:00:00	2014-03-25 00:00:00	2014-03-24 00:00:00	2013-10-24 00:00:00	2013-10-30 00:00:00	2013-10-30 00:00:00	None	2014-10-28 00:00:00	2014-12-18 00:00:00	2014-10-15 00:00:00	2014-11-03 00:00:00	2014-11-03 00:00:00	2014-11-04 00:00:00	2014-11-04 00:00:00	2014-12-18 00:00:00	2014-11-03 00:00:00	2014-10-23 00:00:00	2014-09-26 00:00:00	2014-08-13 00:00:00	2014-06-03 00:00:00	2014-09-27 00:00:00	2014-09-17 00:00:00	2014-09-17 00:00:00	2014-09-17 00:00:00	2014-06-03 00:00:00	2014-08-08 00:00:00	2014-08-13 00:00:00	2014-08-19 00:00:00	2014-08-29 00:00:00	2014-08-14 00:00:00	None	2014-09-11 00:00:00	2014-09-10 00:00:00	2014-09-16 00:00:00	2014-09-22 00:00:00	2014-05-05 00:00:00	2014-05-07 00:00:00	2014-05-15 00:00:00	2014-05-13 00:00:00	2014-05-16 00:00:00	None	2014-04-24 00:00:00	2014-05-01 00:00:00	2014-05-21 00:00:00	2014-05-21 00:00:00	None	2014-04-04 00:00:00	2014-04-07 00:00:00	2014-04-11 00:00:00	2014-04-14 00:00:00	2014-04-17 00:00:00	2014-04-21 00:00:00	2014-04-09 00:00:00	2014-04-24 00:00:00	None	2016-01-05 00:00:00	None	None	None	None	None	None	2015-09-01 00:00:00	None	None
filing_type	None	22001	22001	None	None	22001	22001	22001	22001	22001	22001	22001	None	None	None	22001	22001	22001	22001	22001	None	None	22001	22001	22001	22001	22001	22001	None	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	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	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	None	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	None	None	None	None	22001	None	22001	None	None

Table: filer_to_filer_type
filer_id	1358245	1358245	1358245	1358245
filer_type	16	16	16	16
active	Y	Y	Y	T
race	0	0	0	0
session_id	2013	2013	2013	2015
category	40002	40002	40002	40002
category_type	40502	40502	40502	40502
sub_category	0	0	0	0
effect_dt	2014-03-20 00:00:00	2013-07-12 00:00:00	2013-06-10 00:00:00	2015-12-03 00:00:00
sub_category_type	0	0	0	0
election_type	0	0	0	0
sub_category_a	None	None	None	None
nyq_dt	2013-06-17 00:00:00	2013-06-17 00:00:00	None	2013-06-17 00:00:00
party_cd	16001	16001	16001	16001
county_cd	18004	18026	18026	18004
district_cd	0	0	0	0

Table: filer_xref
filer_id		1358245
xref_id		1358245
effect_dt		2013-06-10 00:00:00
migration_source		CLAIMS

Table: filername
xref_filer_id	1358245	1358245	1358245	1358245
filer_id	1358245	1358245	1358245	1358245
filer_type	RECIPIENT COMMITTEE	RECIPIENT COMMITTEE	RECIPIENT COMMITTEE	RECIPIENT COMMITTEE
status	TERMINATED	TERMINATED	TERMINATED	TERMINATED
effect_dt	2015-12-03 00:00:00	2015-12-03 00:00:00	2015-12-03 00:00:00	2015-12-03 00:00:00
naml	RIDLEY-THOMAS FOR ASSEMBLY 2013, SEBASTIAN	RIDLEY-THOMAS FOR ASSEMBLY 2013, SEBASTIAN	RIDLEY-THOMAS FOR ASSEMBLY 2014, SEBASTIAN	RIDLEY-THOMAS FOR ASSEMBLY 2014, SEBASTIAN
namf	None	None	None	None
namt	None	None	None	None
nams	None	None	None	None
adr1	None	None	None	None
adr2	None	None	None	None
city	LOS ANGELES	SACRAMENTO	LOS ANGELES	SACRAMENTO
st	CA	CA	CA	CA
zip4	90046	95814	90046	95814
phon	2134796620	9164422952	2134796620	9164422952
fax	2134022808		2134022808
email	[email protected]	[email protected]	[email protected]	[email protected]

Table: filers
filer_id		1358245

Table: received_filings
filer_id	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245	1358245
filing_file_name	1846741_0.cal	1850368_0.cal	1849493_0.cal	1849579_0.cal	1847318_0.cal	1847987_0.cal	1837449_0.cal	1852597_0.cal	1852598_0.cal	1830083_0.cal	1839225_0.cal	1849168_0.cal	1829490_0.cal	1841136_0.cal	1851049_0.cal	1828108_1.cal	1830640_0.cal	1841273_0.cal	1836300_0.cal	205066.cal	205385.cal	1838139_0.cal	1832244_0.cal	204797.cal	204859.cal	1831359_0.cal	1838928_0.cal	1833356_0.cal	1783760_0.cal	1829089_0.cal	1798760_0.cal	1802564_0.cal	92624.cal	92607.cal	401204.cal	1795557_0.cal	1795870_0.cal	233117.cal	401116.cal	1797412_0.cal	1800938_0.cal	1806176_0.cal	1794097_0.cal	1796429_0.cal	1792781_0.cal	1792820_0.cal	1792929_0.cal	1800938_1.cal	1802020_0.cal	1795888_0.cal	1794218_0.cal	1794425_0.cal	1793216_1.cal	1793613_0.cal	1802427_0.cal	1797074_0.cal	1827204_0.cal	1838013_0.cal	1806619_0.cal	1807557_0.cal	1839951_0.cal	1806783_0.cal	1841853_0.cal	1827398_0.cal	1828108_0.cal	1826722_0.cal	1826724_0.cal	1806405_0.cal	1806176_1.cal	1856468_0.cal	1857002_0.cal	1859995_0.cal	1856634_0.cal	1876847_1.cal	1886118_0.cal	1854812_0.cal	1836128_0.cal	1853553_0.cal	1858026_0.cal	1858027_0.cal	1877202_0.cal	1878378_0.cal	1878944_0.cal	1884734_0.cal	1877671_0.cal	1881610_0.cal	1875827_0.cal	1880761_0.cal	1876847_0.cal	1884333_0.cal	1881610_1.cal	1887407_0.cal	1891702_0.cal	1889795_0.cal	1888940_0.cal	1889964_0.cal	1895488_0.cal	1895491_0.cal	1889083_0.cal	1896549_0.cal	1898728_0.cal	1899488_0.cal	1904026_1.cal	1907689_0.cal	1900781_0.cal	1904026_0.cal	1913541_0.cal	1913546_0.cal	1912380_0.cal	1913547_0.cal	1913954_0.cal	1930072_0.cal	1914002_0.cal	1912471_0.cal	1919034_0.cal	1911518_0.cal	1919023_0.cal	1934912_0.cal
received_date	2014-05-01 00:00:00	2014-05-15 00:00:00	2014-05-13 00:00:00	2014-05-13 00:00:00	2014-05-05 00:00:00	2014-05-07 00:00:00	2014-04-09 00:00:00	2014-05-21 00:00:00	2014-05-21 00:00:00	2014-03-18 00:00:00	2014-04-17 00:00:00	2014-05-12 00:00:00	2014-03-17 00:00:00	2014-04-24 00:00:00	2014-05-16 00:00:00	2014-03-19 00:00:00	2014-03-19 00:00:00	2014-04-24 00:00:00	2014-04-07 00:00:00	2014-03-20 00:00:00	2014-03-20 00:00:00	2014-04-14 00:00:00	2014-03-24 00:00:00	2014-03-20 00:00:00	2014-03-20 00:00:00	2014-03-21 00:00:00	2014-04-16 00:00:00	2014-03-25 00:00:00	2013-07-31 00:00:00	2014-03-14 00:00:00	2013-10-29 00:00:00	2013-11-06 00:00:00	2014-03-14 00:00:00	2014-03-14 00:00:00	2013-10-02 00:00:00	2013-10-18 00:00:00	2013-10-21 00:00:00	2013-10-21 00:00:00	2013-10-02 00:00:00	2013-10-25 00:00:00	2013-10-31 00:00:00	2013-11-27 00:00:00	2013-10-14 00:00:00	2013-10-22 00:00:00	2013-10-04 00:00:00	2013-10-05 00:00:00	2013-10-07 00:00:00	2013-10-31 00:00:00	2013-11-01 00:00:00	2013-10-21 00:00:00	2013-10-15 00:00:00	2013-10-16 00:00:00	2013-10-10 00:00:00	2013-10-10 00:00:00	2013-11-05 00:00:00	2013-10-24 00:00:00	2014-03-11 00:00:00	2014-04-11 00:00:00	2013-12-03 00:00:00	2013-12-17 00:00:00	2014-04-21 00:00:00	2013-12-04 00:00:00	2014-04-25 00:00:00	2014-03-11 00:00:00	2014-03-13 00:00:00	2014-03-07 00:00:00	2014-03-07 00:00:00	2013-12-03 00:00:00	2013-12-03 00:00:00	2014-05-29 00:00:00	2014-05-30 00:00:00	2014-06-20 00:00:00	2014-05-30 00:00:00	2014-09-17 00:00:00	2014-09-17 00:00:00	2014-05-23 00:00:00	2014-04-04 00:00:00	2014-05-22 00:00:00	2014-06-03 00:00:00	2014-06-03 00:00:00	2014-08-13 00:00:00	2014-08-18 00:00:00	2014-08-19 00:00:00	2014-09-11 00:00:00	2014-08-14 00:00:00	2014-08-29 00:00:00	2014-08-08 00:00:00	2014-08-26 00:00:00	2014-08-13 00:00:00	2014-09-10 00:00:00	2014-09-17 00:00:00	2014-09-22 00:00:00	2014-10-03 00:00:00	2014-09-30 00:00:00	2014-09-26 00:00:00	2014-09-30 00:00:00	2014-10-08 00:00:00	2014-10-08 00:00:00	2014-09-27 00:00:00	2014-10-10 00:00:00	2014-10-15 00:00:00	2014-10-16 00:00:00	2014-10-27 00:00:00	2014-10-28 00:00:00	2014-10-20 00:00:00	2014-10-23 00:00:00	2014-11-03 00:00:00	2014-11-03 00:00:00	2014-10-31 00:00:00	2014-11-03 00:00:00	2014-11-04 00:00:00	2015-01-26 00:00:00	2014-11-04 00:00:00	2014-10-31 00:00:00	2014-12-18 00:00:00	2014-10-31 00:00:00	2014-12-18 00:00:00	2015-01-30 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/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/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	1846741	1850368	1849493	1849579	1847318	1847987	1837449	1852597	1852598	1830083	1839225	1849168	1829490	1841136	1851049	1828108	1830640	1841273	1836300	None	None	1838139	1832244	None	None	1831359	1838928	1833356	1783760	1829089	1798760	1802564	None	None	None	1795557	1795870	None	None	1797412	1800938	1806176	1794097	1796429	1792781	1792820	1792929	1800938	1802020	1795888	1794218	1794425	1793216	1793613	1802427	1797074	1827204	1838013	1806619	1807557	1839951	1806783	1841853	1827398	1828108	1826722	1826724	1806405	1806176	1856468	1857002	1859995	1856634	1876847	1886118	1854812	1836128	1853553	1858026	1858027	1877202	1878378	1878944	1884734	1877671	1881610	1875827	1880761	1876847	1884333	1881610	1887407	1891702	1889795	1888940	1889964	1895488	1895491	1889083	1896549	1898728	1899488	1904026	1907689	1900781	1904026	1913541	1913546	1912380	1913547	1913954	1930072	1914002	1912471	1919034	1911518	1919023	1934912
form_id	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	None	None	F497	F497	None	None	F497	F497	F497	F497	F497	F497	F497	None	None	None	F497	F497	None	None	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497	F497
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 did not pass validation	Filing did not pass validation	Filing accepted	Filing accepted	Filing did not pass validation	Filing did not pass validation	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	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