OpenCalAccess

Filer ID: 1268631

Table: cvr_campaign_disclosure
filing_id	1663990	1647483	1637431	1678878	1703801	1739137	1694732	1783043	1832363	1817463	1832363	1853465	1871795	1852696	1853465	1893117	1890706	1931143	1927561	1903898	1978638	2084469	2086686	2063575	2057277	2171319	2127300	2097937	2171319	2201504	2222639	2260862	2253857	2237309	2253857	2312765	2312785	2296779	2311047	2270708	2341923	2336673	2312785	2341923	2396920	2312785	2296779	2296779	2396920	2440841	2440841	2486451	2551222	2601670	2641464	2672124	2596246	2724726	2704526	2686146	2726137	2744049	2751795
amend_id	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	1	0	0	0	0	0	1	0	0	0	0	0	1	0	1	0	0	2	1	2	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0
rec_type	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR
form_type	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F497	F460	F460	F497	F460	F497	F460	F460	F497	F460	F460	F460	F460	F460	F460	F460	F460	F497	F497	F460	F460	F460	F497	F460	F460	F497	F460	F460	F497	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F497	F497	F460	F460	F460	F460	F497
filer_id	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631
entity_cd	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP	RCP
filer_naml	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC
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
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
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
report_num	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	001	000	000	000	000	000	001	000	000	000	000	000	001	000	001	000	000	002	001	002	001	001	000	000	000	000	000	000	000	000	000	000	000	000	000
rpt_date	2012-05-19 00:00:00	2012-03-16 00:00:00	2012-01-13 00:00:00	2012-07-09 00:00:00	2012-10-22 00:00:00	2013-01-21 00:00:00	2012-10-02 00:00:00	2013-07-10 00:00:00	2014-03-24 00:00:00	2014-01-20 00:00:00	2014-07-24 00:00:00	2014-07-24 00:00:00	2014-07-28 00:00:00	2014-05-21 00:00:00	2014-05-21 00:00:00	2014-10-05 00:00:00	2014-10-02 00:00:00	2015-01-21 00:00:00	2015-01-21 00:00:00	2014-10-22 00:00:00	2015-07-09 00:00:00	2016-10-03 00:00:00	2016-10-08 00:00:00	2016-07-27 00:00:00	2015-12-16 00:00:00	2017-07-25 00:00:00	2017-01-30 00:00:00	2016-10-26 00:00:00	2017-09-05 00:00:00	2018-01-11 00:00:00	2018-03-15 00:00:00	2018-06-15 00:00:00	2018-05-24 00:00:00	2018-04-25 00:00:00	2018-06-15 00:00:00	2018-10-25 00:00:00	2018-10-25 00:00:00	2018-09-26 00:00:00	2018-10-23 00:00:00	2018-07-18 00:00:00	2019-07-31 00:00:00	2019-01-21 00:00:00	2019-01-22 00:00:00	2019-01-22 00:00:00	2019-07-30 00:00:00	2019-07-31 00:00:00	2019-01-28 00:00:00	2019-07-30 00:00:00	2020-04-23 00:00:00	2020-04-23 00:00:00	2020-01-30 00:00:00	2020-07-31 00:00:00	2021-01-29 00:00:00	2021-07-29 00:00:00	2022-01-28 00:00:00	2022-04-27 00:00:00	2021-07-23 00:00:00	2022-09-28 00:00:00	2022-07-29 00:00:00	2022-05-25 00:00:00	2022-09-29 00:00:00	2022-10-27 00:00:00	2022-11-03 00:00:00
stmt_type	PE	PE	SA	SA	PE	SA	PE	SA	PE	SA	PE	PE	SA	None	PE	PE	None	SA	None	PE	SA	None	PE	SA	SA	SA	SA	PE	SA	SA	None	None	PE	PE	PE	None	PE	PE	None	SA	SA	None	PE	SA	SA	PE	PE	PE	SA	SA	SA	SA	SA	SA	SA	PE	None	None	SA	PE	PE	PE	None
late_rptno	None	None	None	None	None	None	None	None	None	None	None	None	None	1M-052114-1	None	None	1M-100214-1	None	1M-012115-1	None	None	20161003-A	None	None	None	None	None	None	None	None	20180315-A	20180615A	None	None	None	20181025-A	None	None	20181023-A	None	None	20190121-A	None	None	None	None	None	None	None	None	None	None	None	None	None	None	2021-LCR-001	2021-LCR-002	None	None	None	None	2021-LCR-003
from_date	2012-03-18 00:00:00	2012-01-01 00:00:00	2011-07-01 00:00:00	2012-05-20 00:00:00	2012-10-01 00:00:00	2012-10-21 00:00:00	2012-07-01 00:00:00	2013-01-01 00:00:00	2014-01-01 00:00:00	2013-07-01 00:00:00	2014-01-01 00:00:00	2014-03-18 00:00:00	2014-05-18 00:00:00	2014-05-13 00:00:00	2014-03-18 00:00:00	2014-07-01 00:00:00	2014-10-01 00:00:00	2014-10-19 00:00:00	2014-10-24 00:00:00	2014-10-01 00:00:00	2015-01-01 00:00:00	2016-10-03 00:00:00	2016-07-01 00:00:00	2016-01-01 00:00:00	2015-07-01 00:00:00	2017-01-01 00:00:00	2016-10-23 00:00:00	2016-09-25 00:00:00	2017-01-01 00:00:00	2017-07-01 00:00:00	2018-03-15 00:00:00	None	2018-04-22 00:00:00	2018-01-01 00:00:00	2018-04-22 00:00:00	2018-09-24 00:00:00	2018-09-23 00:00:00	2018-07-01 00:00:00	2018-10-22 00:00:00	2018-05-20 00:00:00	2018-10-21 00:00:00	2018-10-08 00:00:00	2018-09-23 00:00:00	2018-10-21 00:00:00	2019-01-01 00:00:00	2018-09-23 00:00:00	2018-07-01 00:00:00	2018-07-01 00:00:00	2019-01-01 00:00:00	2019-07-01 00:00:00	2019-07-01 00:00:00	2020-01-01 00:00:00	2020-07-01 00:00:00	2021-01-01 00:00:00	2021-07-01 00:00:00	2022-01-01 00:00:00	2021-07-23 00:00:00	2022-08-16 00:00:00	2022-05-22 00:00:00	2022-04-24 00:00:00	2022-07-01 00:00:00	2022-09-25 00:00:00	2022-11-03 00:00:00
thru_date	2012-05-19 00:00:00	2012-03-17 00:00:00	2011-12-31 00:00:00	2012-06-30 00:00:00	2012-10-20 00:00:00	2012-12-31 00:00:00	2012-09-30 00:00:00	2013-06-30 00:00:00	2014-03-17 00:00:00	2013-12-31 00:00:00	2014-03-17 00:00:00	2014-05-17 00:00:00	2014-06-30 00:00:00	2014-05-21 00:00:00	2014-05-17 00:00:00	2014-09-30 00:00:00	2014-10-02 00:00:00	2014-12-31 00:00:00	2014-10-28 00:00:00	2014-10-18 00:00:00	2015-06-30 00:00:00	2016-10-03 00:00:00	2016-09-24 00:00:00	2016-06-30 00:00:00	2015-12-31 00:00:00	2017-06-30 00:00:00	2016-12-31 00:00:00	2016-10-22 00:00:00	2017-06-30 00:00:00	2017-12-31 00:00:00	2018-03-15 00:00:00	None	2018-05-19 00:00:00	2018-04-21 00:00:00	2018-05-19 00:00:00	2018-09-24 00:00:00	2018-10-20 00:00:00	2018-09-22 00:00:00	2018-10-22 00:00:00	2018-06-30 00:00:00	2018-12-31 00:00:00	2018-10-08 00:00:00	2018-10-20 00:00:00	2018-12-31 00:00:00	2019-06-30 00:00:00	2018-10-20 00:00:00	2018-09-22 00:00:00	2018-09-22 00:00:00	2019-06-30 00:00:00	2019-12-31 00:00:00	2019-12-31 00:00:00	2020-06-30 00:00:00	2020-12-31 00:00:00	2021-06-30 00:00:00	2021-12-31 00:00:00	2022-04-23 00:00:00	2021-07-23 00:00:00	2022-09-28 00:00:00	2022-06-30 00:00:00	2022-05-21 00:00:00	2022-09-24 00:00:00	2022-10-22 00:00:00	2022-11-03 00:00:00
elect_date	None	2012-06-05 00:00:00	None	None	2012-11-06 00:00:00	None	2012-11-06 00:00:00	None	2014-06-03 00:00:00	None	2014-06-03 00:00:00	2014-06-03 00:00:00	None	None	2014-06-03 00:00:00	2014-11-04 00:00:00	None	None	None	2014-11-04 00:00:00	None	None	2016-11-08 00:00:00	None	None	None	None	2016-11-08 00:00:00	None	None	None	None	2018-06-05 00:00:00	2018-06-05 00:00:00	2018-06-05 00:00:00	None	2018-11-06 00:00:00	2018-11-06 00:00:00	None	None	None	None	2018-11-06 00:00:00	None	None	2018-11-06 00:00:00	2018-11-06 00:00:00	2018-11-06 00:00:00	None	None	None	None	None	None	None	2022-06-07 00:00:00	None	None	None	2022-06-07 00:00:00	2022-11-08 00:00:00	2022-11-08 00:00:00	None
filer_city	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Dos Palos	Dos Palos	Dos Palos	Dos Palos	Dos Palos	Fresno	Fresno	Fresno	Fresno	Fresno	Fresno	Fresno	Fresno	Fresno	Fresno
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
filer_zip4	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93620	93620	93620	93620	93620	93721-2924	93721-2924	93721-2924	93721-2924	93721-2924	93721-2924	93721-2924	93721-2924	93721-2924	93721-2924
filer_phon	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	(209) 826-1134	(209) 826-1134	(209) 826-1134	(209) 826-1134	(209) 826-1134	(559) 266-3453	(559) 266-3453	(559) 266-3453	(559) 266-3453	(559) 266-3453	(559) 266-3453	(559) 266-3453	(559) 266-3453	(559) 266-3453	(559) 266-3453
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
file_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	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]
mail_city	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
mail_st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
mail_zip4	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
tres_naml	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	None	Michael	Michael	None	Michael	None	Michael	Michael	None	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	None	None	Michael	Michael	Michael	None	Michael	Michael	None	Michael	Michael	None	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	Michael	None	None	Michael	Michael	Michael	Michael	None
tres_namf	Cannon	Cannon	Cannon	Cannon	Cannon	Cannon	Cannon	Cannon	Cannon	Cannon	Cannon	Cannon	Cannon	None	Cannon	Cannon	None	Cannon	None	Cannon	Cannon	None	Cannon	Cannon	Cannon	Cannon	Cannon	Cannon	Cannon	Cannon	None	None	Cannon	Cannon	Cannon	None	Cannon	Cannon	None	Cannon	Cannon	None	Cannon	Cannon	Cannon	Cannon	Cannon	Cannon	Cannon	Cannon	Cannon	Cannon	Cannon	Cannon	Cannon	Cannon	None	None	Cannon	Cannon	Cannon	Cannon	None
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
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
tres_city	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	None	Los Banos	Los Banos	None	Los Banos	None	Los Banos	Los Banos	None	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	None	None	Los Banos	Los Banos	Los Banos	None	Los Banos	Los Banos	None	Los Banos	Los Banos	None	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	Los Banos	None	None	Los Banos	Los Banos	Los Banos	Los Banos	None
tres_st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	None	CA	CA	None	CA	None	CA	CA	None	CA	CA	CA	CA	CA	CA	CA	CA	None	None	CA	CA	CA	None	CA	CA	None	CA	CA	None	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	None	None	CA	CA	CA	CA	None
tres_zip4	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	None	93635	93635	None	93635	None	93635	93635	None	93635	93635	93635	93635	93635	93635	93635	93635	None	None	93635	93635	93635	None	93635	93635	None	93635	93635	None	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	93635	None	None	93635	93635	93635	93635	None
tres_phon	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	None	209-826-1134	209-826-1134	None	209-826-1134	None	209-826-1134	209-826-1134	None	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	None	None	209-826-1134	209-826-1134	209-826-1134	None	209-826-1134	209-826-1134	None	209-826-1134	209-826-1134	None	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	209-826-1134	None	None	209-826-1134	209-826-1134	209-826-1134	209-826-1134	None
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
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
cmtte_type	G	G	G	G	G	G	G	G	G	G	G	G	G	None	G	G	None	G	None	G	G	None	G	G	G	G	G	G	G	G	None	None	G	G	G	None	G	G	None	G	G	None	G	G	G	G	G	G	G	G	G	G	G	G	G	G	None	None	G	G	G	G	None
control_yn	N	N	N	N	N	N	N	N	N	N	N	N	N	None	N	N	None	N	None	N	N	None	N	N	N	N	N	N	N	N	None	None	N	N	N	None	N	N	None	N	N	None	N	N	N	N	N	N	N	N	N	N	N	N	N	N	None	None	N	N	N	N	None
sponsor_yn	N	N	N	N	N	N	N	N	N	N	N	N	N	None	N	N	None	N	None	N	N	None	N	N	N	N	N	N	N	N	None	None	N	N	N	None	N	N	None	N	N	None	N	N	N	N	N	N	N	N	N	N	N	N	N	N	None	None	N	N	N	N	None
primfrm_yn	N	N	N	N	N	N	N	N	N	N	N	N	N	None	N	N	None	N	None	N	N	None	N	N	N	N	N	N	N	N	None	None	N	N	N	None	N	N	None	N	N	None	N	N	N	N	N	N	N	N	N	N	N	N	N	N	None	None	N	N	N	N	None
brdbase_yn	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
amendexp_1	None	None	None	None	None	None	None	None	None	None	Additional Disclosure	Additional Disclosure	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Additional Disclosure	None	None	None	None	None	Additional Disclosure	None	None	None	None	None	Additional Disclosure	None	Additional Disclosure	None	None	Additional Disclosure	Additional Disclosure	Additional Disclosure	Updated Disclosure.	Updated Disclosure.	None	None	None	None	None	None	None	None	None	None	None	None	None
amendexp_2	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
cand_naml	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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_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
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
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
cand_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
cand_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
cand_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
cand_phon	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
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
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
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
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
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
office_cd	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
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
juris_cd	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
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
dist_no	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
off_s_h_cd	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
sup_opp_cd	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
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
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
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
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
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

Table: cvr_so
filing_id	1723357	1723357	1723357
amend_id	0	1	2
rec_type	CVR	CVR	CVR
form_type	F410	F410	F410
filer_id	1268631	1268631	1268631
entity_cd	COM	COM	COM
filer_naml	Exchange Contractors State PAC	Exchange Contractors State PAC	Exchange Contractors State PAC
filer_namf	None	None	None
filer_namt	None	None	None
filer_nams	None	None	None
report_num	000	001	002
rpt_date	2013-01-08 00:00:00	2013-01-08 00:00:00	2021-04-29 00:00:00
qual_cb	X	X	X
qualfy_dt	2004-01-06 00:00:00	2004-01-06 00:00:00	2004-01-06 00:00:00
term_date	None	None	None
city	Los Banos	Los Banos	Fresno
st	CA	CA	CA
zip4	93635	93635	93721-2924
phone	209-826-1134	209-826-1134	(559) 266-3453
county_res	Merced	Merced	Merced
county_act	Multiple	Multiple	Multiple
mail_city	Los Banos	Los Banos	None
mail_st	CA	CA	None
mail_zip4	93635	93635	None
cmte_fax	None	None	None
cmte_email	None	None	[email protected]
tres_naml	Michael	Michael	Michael
tres_namf	Cannon	Cannon	Cannon
tres_namt	None	None	None
tres_nams	None	None	None
tres_city	Los Banos	Los Banos	Los Banos
tres_st	CA	CA	CA
tres_zip4	93635	93635	93635
tres_phon	209-826-1134	209-826-1134	209-826-1134
actvty_lvl	ST	ST	ST
com82013yn	None	None	None
com82013nm	None	None	None
com82013id	None	None	None
control_cb	X	X	None
bank_nam	WestAmerica Bank	WestAmerica Bank	WestAmerica Bank
bank_adr1	953 West Pacheco Boulevard	953 West Pacheco Boulevard	1507 Center Avenue
bank_adr2	None	None	None
bank_city	Los Banos	Los Banos	Dos Palos
bank_st	CA	CA	CA
bank_zip4	93635	93635	93620
bank_phon	209-826-7760	209-826-7760	209-392-2300
acct_opendt	None	None	None
surplusdsp	None	None	None
primfc_cb	None	None	None
genpurp_cb	X	X	X
gpc_descr	To support state county and local candidates and ballot measures	To support state county and local candidates and ballot measures	To support state county and local candidates and ballot measures
sponsor_cb	None	None	None
brdbase_cb	None	None	None
smcont_qualdt	None	None	None

Table: filer_address
filer_id	1268631	1268631	1268631	1268631	1268631
adrid	2071928	2169691	2169690	2518861	2488409
effect_dt	2004-08-18 00:00:00	2009-06-15 00:00:00	2009-06-15 00:00:00	2021-05-27 00:00:00	2019-10-15 00:00:00
add_type	7051	7082	7051	7051	7051
session_id	2003	2009	2009	2021	2019

Table: filer_filings
filer_id	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631
filing_id	1043826	1050534	1038820	1114201	1087870	1123545	1106378	1147349	1169549	1186440	1211154	1230777	1281307	1263116	1306203	1293581	1783043	1786980	1978638	1853465	1871795	1832363	1853465	1944565	1893117	1895160	1903898	1325927	1343622	1366127	1396182	1417855	1396182	1427688	1417855	1441707	1448817	1432136	1432136	1466338	1482172	1499946	1535634	1567896	1611657	1637431	1610817	1639054	1647483	1648753	1666668	1663990	1678878	1825067	1696148	1694732	1683528	1927561	1931143	1913070	1709967	1703801	1890706	1857761	1874712	1835423	1857761	1739137	1723357	1723357	1832363	1852696	1817463	1835423	1749786	1753177	1986451	2212884	2222639	2171319	2311047	2253857	2312785	2302065	2318834	2178521	2318834	2358429	2296779	2312785	2341923	2008049	2057277	2063575	2086686	2084469	2076730	2097937	2090677	2127300	2112123	2145030	2171319	2178521	2274583	2296779	2413843	2396920	2260862	2318834	2448756	2401223	2440841	2312765	2312785	2494700	2551222	2358429	2237309	2270708	2448756	2256092	2256092	2341923	2336673	2201504	2401221	2401223	2302065	2243795	2396920	2440841	2253857	2296779	2676610	2686146	2486451	2586128	2596246	2576221	2601670	2672124	2624060	2688549	2724726	2647911	2641464	1723357	2704526	2726137	2747622	2744049	2740505	2751795
period_id	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	213	None	221	217	218	217	217	None	219	None	220	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	207	None	None	209	None	None	209	210	None	None	211	None	221	220	None	None	212	220	None	None	None	None	212	213	213	217	218	215	None	None	None	None	None	233	229	236	234	235	None	None	None	None	None	235	235	236	None	223	225	227	228	None	227	None	228	None	None	229	None	None	235	None	237	234	None	None	None	239	236	235	None	243	None	233	234	None	None	None	236	237	231	None	None	None	None	237	239	234	235	None	250	241	None	247	None	245	249	None	None	251	None	247	246	250	251	None	251	None	252
form_id	F460	F460	F410	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F410	F460	F410	F460	F460	F460	F460	F460	F460	F460	F460	F410	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F497	F460	F460	F460	F460	F497	F460	F460	F460	F460	F460	F410	F410	F460	F497	F460	F460	F460	F410	F460	F460	F497	F460	F497	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F497	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F410	F460	F497	F460	F460	F460	F460	F497	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F497	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F410	F497	F460	F460	F460	F460	F460	F497	F460	F460	F410	F460	F460	F460	F460	F460	F497
filing_sequence	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	1	0	0	0	0	0	0	0	0	0	0	1	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	1	1	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	2	1	1	1	2	1	0	1	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	1	1	0	0	0	0	0	0	1	1	1	2	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	0	0	0	0	0
filing_date	2004-04-19 00:00:00	2004-10-18 00:00:00	2004-08-18 00:00:00	2005-07-21 00:00:00	2005-01-31 00:00:00	2004-07-01 00:00:00	2005-04-11 00:00:00	2006-01-30 00:00:00	2006-05-01 00:00:00	2006-07-17 00:00:00	2006-10-12 00:00:00	2007-01-16 00:00:00	2007-07-18 00:00:00	2007-04-13 00:00:00	2008-01-24 00:00:00	2007-10-17 00:00:00	2013-07-31 00:00:00	2013-07-31 00:00:00	2015-07-28 00:00:00	2014-07-31 00:00:00	2014-07-31 00:00:00	2014-07-31 00:00:00	2014-05-22 00:00:00	2015-01-29 00:00:00	2014-10-06 00:00:00	2014-10-06 00:00:00	2014-10-23 00:00:00	2008-04-14 00:00:00	2008-07-14 00:00:00	2008-10-06 00:00:00	2009-01-29 00:00:00	2009-04-14 00:00:00	2009-06-15 00:00:00	2009-06-15 00:00:00	2009-07-03 00:00:00	2009-07-20 00:00:00	2009-10-19 00:00:00	2009-08-18 00:00:00	2009-07-20 00:00:00	2010-01-27 00:00:00	2010-04-20 00:00:00	2010-07-09 00:00:00	2010-10-21 00:00:00	2011-01-24 00:00:00	2011-08-02 00:00:00	2012-01-31 00:00:00	2011-08-01 00:00:00	2012-01-31 00:00:00	2012-03-22 00:00:00	2012-03-22 00:00:00	2012-05-24 00:00:00	2012-05-24 00:00:00	2012-07-31 00:00:00	2014-01-31 00:00:00	2012-10-05 00:00:00	2012-10-05 00:00:00	2012-07-31 00:00:00	2015-01-21 00:00:00	2015-01-27 00:00:00	2014-10-23 00:00:00	2012-10-25 00:00:00	2012-10-25 00:00:00	2014-10-02 00:00:00	2014-05-22 00:00:00	2014-07-31 00:00:00	2014-08-01 00:00:00	2014-08-01 00:00:00	2013-01-31 00:00:00	2013-01-08 00:00:00	2013-01-08 00:00:00	2014-03-24 00:00:00	2014-05-21 00:00:00	2014-01-31 00:00:00	2014-03-24 00:00:00	2013-01-31 00:00:00	2013-01-09 00:00:00	2015-07-30 00:00:00	2018-01-19 00:00:00	2018-03-15 00:00:00	2017-09-12 00:00:00	2018-10-23 00:00:00	2018-05-24 00:00:00	2019-07-31 00:00:00	2019-02-04 00:00:00	2019-02-04 00:00:00	2017-09-14 00:00:00	2019-07-31 00:00:00	2019-07-31 00:00:00	2018-09-27 00:00:00	2019-01-28 00:00:00	2019-01-28 00:00:00	2016-01-22 00:00:00	2016-07-21 00:00:00	2016-08-01 00:00:00	2016-10-07 00:00:00	2016-10-03 00:00:00	2016-08-01 00:00:00	2016-10-27 00:00:00	2016-10-12 00:00:00	2017-01-30 00:00:00	2016-10-27 00:00:00	2017-01-31 00:00:00	2017-07-25 00:00:00	2017-07-31 00:00:00	2018-07-30 00:00:00	2019-01-28 00:00:00	2019-10-15 00:00:00	2019-07-30 00:00:00	2018-06-15 00:00:00	2018-10-25 00:00:00	2020-04-27 00:00:00	2020-04-27 00:00:00	2020-01-30 00:00:00	2018-10-25 00:00:00	2018-10-25 00:00:00	2020-07-31 00:00:00	2021-01-29 00:00:00	2019-02-01 00:00:00	2018-04-26 00:00:00	2018-07-27 00:00:00	2020-01-31 00:00:00	2018-05-24 00:00:00	2018-07-30 00:00:00	2019-07-31 00:00:00	2019-01-21 00:00:00	2018-01-11 00:00:00	2019-07-31 00:00:00	2019-07-31 00:00:00	2018-09-27 00:00:00	2018-04-26 00:00:00	2020-04-23 00:00:00	2020-04-23 00:00:00	2018-06-15 00:00:00	2019-07-30 00:00:00	2022-04-28 00:00:00	2022-05-25 00:00:00	2020-07-31 00:00:00	2021-05-27 00:00:00	2021-07-23 00:00:00	2021-01-30 00:00:00	2021-07-31 00:00:00	2022-04-27 00:00:00	2021-08-02 00:00:00	2022-05-26 00:00:00	2022-09-28 00:00:00	2022-01-31 00:00:00	2022-01-28 00:00:00	2021-04-30 00:00:00	2022-07-29 00:00:00	2022-09-29 00:00:00	2022-09-30 00:00:00	2022-10-27 00:00:00	2022-08-01 00:00:00	2022-11-03 00:00:00
stmnt_type	10005	10005	10005	10005	10005	10005	10005	10005	10005	10005	10005	10005	10005	10005	10005	10005	10001	10005	10001	10002	10001	10002	10001	10005	10001	10005	10001	10005	10005	10005	10005	10005	10006	10006	10006	10006	10005	10006	10005	10005	10005	10005	10005	10005	10006	10001	10005	10005	10001	10005	10005	10001	10001	10005	10005	10001	10005	10001	10001	10005	10005	10001	10001	10005	10005	10006	10006	10001	10001	10002	10001	10001	10001	10005	10005	10006	10005	10005	10001	10002	10001	10001	10002	10006	10006	10006	10006	10006	10001	10002	10001	10005	10001	10001	10001	10001	10005	10001	10005	10001	10005	10005	10001	10005	10005	10002	10006	10001	10001	10005	10006	10006	10001	10001	10001	10005	10001	10005	10001	10001	10005	10005	10002	10002	10001	10001	10005	10005	10005	10005	10002	10002	10002	10002	10005	10001	10001	10006	10001	10005	10001	10001	10005	10005	10001	10005	10001	10002	10001	10001	10005	10001	10005	10001
stmnt_status	11003	11003	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11003	11003	11003	11001	11001	11003	11003	11001	11003	11001	11001	11001	11001	11001	11003	11001	11003	11003	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11003	11001	11001	11003	11003	11003	11003	11003	11001	11003	11003	11003	11001	11003	11001	11001	11003	11001	11001	11003	11001	11003	11001	11003	11003	11001	11001	11003	11003	11001	11003	11003	11003	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11001	11001	11003	11001	11001	11001	11003	11003	11003	11003	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11003	11003	11003	11003	11003
session_id	2003	2003	2003	2005	2003	2003	2005	2005	2005	2005	2005	2005	2007	2007	2007	2007	2013	2013	2015	2013	2013	2013	2013	2013	2013	2013	2013	2007	2007	2007	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2011	2011	2011	2011	2011	2011	2011	2011	2011	2013	2011	2011	2011	2015	2013	2013	2011	2011	2013	2013	2013	2013	2013	2011	2013	2013	2013	2013	2013	2013	2011	2013	2015	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2017	2017	2017	2017	2019	2019	2017	2017	2019	2019	2019	2017	2017	2019	2019	2017	2017	2017	2019	2017	2017	2017	2019	2017	2019	2019	2017	2017	2019	2019	2017	2017	2021	2021	2019	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021
user_id	DHORRELL	EMCENTEE	PBANFORD	GKURIMOT	GKURIMOT	GGILMORE	GKURIMOT	GKURIMOT	GKURIMOT	GKURIMOT	GKURIMOT	GKURIMOT	GPEREZ	GPEREZ	RGEREMIA	CFLAGG	MDIGRAZIA	MDIGRAZIA	CAFILER	CAFILER	CAFILER	MDIGRAZIA	MDIGRAZIA	GCLARA	CAFILER	GPEREZ	CAFILER	GKURIMOT	GKURIMOT	GKURIMOT	CPON	SARRIAGA	JVAZQUEZ	RGEREMIA	JVAZQUEZ	RGEREMIA	CPON	JVAZQUEZ	SARRIAGA	MMORENO	SARRIAGA	SARRIAGA	SMCCONNAN	CPON	TRAMON	CPON	CPON	CPON	SARRIAGA	SARRIAGA	MDIGRAZIA	MDIGRAZIA	CPON	GGILMORE	MPACHECO	CAFILER	CPON	WBROWN	CAFILER	MPACHECO	MPACHECO	CAFILER	CAFILER	MDIGRAZIA	MPACHECO	MPACHECO	MPACHECO	MDIGRAZIA	CAFILER	TRAMON	MDIGRAZIA	CAFILER	MDIGRAZIA	MDIGRAZIA	MPACHECO	TRAMON	MPACHECO	HSTOVALL	CAFILER	CAFILER	GKURIMOT	BSINGH	CAFILER	JFONSECA	JFRONEFIELD	SMCCONNAN	HCOURSEY	HCOURSEY	CSAGABAEN	JFRONEFIELD	AROJAS	SMCCONNAN	GCLARA	SARRIAGA	SJENSEN	PDEO	SARRIAGA	GPEREZ	SJENSEN	SARRIAGA	GPEREZ	SARRIAGA	RPOOJA	RPOOJA	HSTOVALL	CAFILER	TRAMON	SARRIAGA	RGEREMIA	JFRONEFIELD	SUSHAKOV	SUSHAKOV	SARRIAGA	RGEREMIA	JFRONEFIELD	KRUSSELL	CREYNOLDS	AROJAS	CSAGABAEN	HSTOVALL	SARRIAGA	BSINGH	HSTOVALL	CAFILER	RGEREMIA	HSTOVALL	HCOURSEY	SARRIAGA	CSAGABAEN	CSAGABAEN	CAFILER	CAFILER	CAFILER	CAFILER	KRUSSELL	KRUSSELL	KRUSSELL	IMEDINA	CAFILER	CREYNOLDS	KRUSSELL	KRUSSELL	KRUSSELL	KRUSSELL	RGEREMIA	KRUSSELL	KRUSSELL	CAFILER	CAFILER	CAFILER	LPHEAV	CAFILER	JMAVES	CAFILER
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
fine_audit	11003	11003	11003	11001	11001	11003	11001	11001	11001	11001	11001	11001	11003	11003	11003	11003	11001	11001	11003	11003	11003	11003	11001	11003	11003	11003	11003	11001	11001	11001	11001	11003	11003	11003	11003	11003	11001	11003	11003	11001	11003	11003	11001	11001	11003	11001	11001	11001	11003	11003	11001	11001	11001	11003	11003	11003	11001	11001	11003	11003	11003	11003	11003	11001	11003	11003	11003	11001	11003	11003	11001	11003	11001	11001	11003	11003	11003	11003	11003	11003	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11001	11001	11003	11001	11001	11003	11003	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11003	11003	11003	11003	11001	11003	11003	11003	11001	11003	11003	11003	11003	11003	11003	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003
rpt_start	2004-01-01 00:00:00	2004-07-01 00:00:00	None	2005-01-01 00:00:00	2004-10-01 00:00:00	2004-04-01 00:00:00	2005-01-01 00:00:00	2005-07-01 00:00:00	2006-01-01 00:00:00	2006-04-01 00:00:00	2006-07-01 00:00:00	2006-10-01 00:00:00	2007-04-01 00:00:00	2007-01-01 00:00:00	2007-10-01 00:00:00	2007-07-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	2015-01-01 00:00:00	2014-03-18 00:00:00	2014-05-18 00:00:00	2014-01-01 00:00:00	2014-03-18 00:00:00	2014-10-19 00:00:00	2014-07-01 00:00:00	2014-07-01 00:00:00	2014-10-01 00:00:00	2008-01-01 00:00:00	2008-04-01 00:00:00	2008-07-01 00:00:00	2008-10-01 00:00:00	2009-01-01 00:00:00	2008-10-01 00:00:00	None	2009-01-01 00:00:00	None	2009-07-01 00:00:00	2009-01-01 00:00:00	2009-04-01 00:00:00	2009-10-01 00:00:00	2010-01-01 00:00:00	2010-04-01 00:00:00	2010-07-01 00:00:00	2010-10-01 00:00:00	None	2011-07-01 00:00:00	2011-01-01 00:00:00	2011-07-01 00:00:00	2012-01-01 00:00:00	2012-01-01 00:00:00	2012-03-18 00:00:00	2012-03-18 00:00:00	2012-05-20 00:00:00	2013-07-01 00:00:00	2012-07-01 00:00:00	2012-07-01 00:00:00	2012-05-20 00:00:00	2015-01-21 00:00:00	2014-10-19 00:00:00	2014-10-01 00:00:00	2012-10-01 00:00:00	2012-10-01 00:00:00	2014-10-02 00:00:00	2014-03-18 00:00:00	2014-05-18 00:00:00	2014-01-01 00:00:00	2014-03-18 00:00:00	2012-10-21 00:00:00	2013-01-08 00:00:00	2013-01-08 00:00:00	2014-01-01 00:00:00	2014-05-21 00:00:00	2013-07-01 00:00:00	2014-01-01 00:00:00	2012-10-21 00:00:00	None	2015-01-01 00:00:00	2017-07-01 00:00:00	2018-03-15 00:00:00	2017-01-01 00:00:00	2018-10-23 00:00:00	2018-04-22 00:00:00	2018-09-23 00:00:00	2018-07-01 00:00:00	2018-09-23 00:00:00	2017-01-01 00:00:00	2018-09-23 00:00:00	2018-10-21 00:00:00	2018-07-01 00:00:00	2018-09-23 00:00:00	2018-10-21 00:00:00	2015-07-01 00:00:00	2015-07-01 00:00:00	2016-01-01 00:00:00	2016-07-01 00:00:00	2016-10-03 00:00:00	2016-01-01 00:00:00	2016-09-25 00:00:00	2016-07-01 00:00:00	2016-10-23 00:00:00	2016-09-25 00:00:00	2016-10-23 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2018-05-20 00:00:00	2018-07-01 00:00:00	None	2019-01-01 00:00:00	2018-06-15 00:00:00	2018-09-23 00:00:00	2019-07-01 00:00:00	2019-01-01 00:00:00	2019-07-01 00:00:00	2018-10-25 00:00:00	2018-09-23 00:00:00	2020-01-01 00:00:00	2020-07-01 00:00:00	2018-10-21 00:00:00	2018-01-01 00:00:00	2018-05-20 00:00:00	2019-07-01 00:00:00	2018-04-22 00:00:00	2018-04-22 00:00:00	2018-10-21 00:00:00	2019-01-21 00:00:00	2017-07-01 00:00:00	2018-07-01 00:00:00	2019-01-01 00:00:00	2018-07-01 00:00:00	2018-01-01 00:00:00	2019-01-01 00:00:00	2019-07-01 00:00:00	2018-04-22 00:00:00	2018-07-01 00:00:00	2022-01-01 00:00:00	2022-04-24 00:00:00	2020-01-01 00:00:00	None	2021-07-23 00:00:00	2020-07-01 00:00:00	2021-01-01 00:00:00	2022-01-01 00:00:00	2021-01-01 00:00:00	2022-04-24 00:00:00	2022-09-28 00:00:00	2021-07-01 00:00:00	2021-07-01 00:00:00	2021-04-29 00:00:00	2022-05-22 00:00:00	2022-07-01 00:00:00	2022-07-01 00:00:00	2022-09-25 00:00:00	2022-04-24 00:00:00	2022-11-03 00:00:00
rpt_end	2004-03-31 00:00:00	2004-09-30 00:00:00	None	2005-06-30 00:00:00	2004-12-31 00:00:00	2004-06-30 00:00:00	2005-04-01 00:00:00	2005-12-31 00:00:00	2006-04-01 00:00:00	2006-06-30 00:00:00	2006-10-10 00:00:00	2006-12-31 00:00:00	2007-06-30 00:00:00	2007-03-31 00:00:00	2007-12-31 00:00:00	2007-09-30 00:00:00	2013-06-30 00:00:00	2013-06-30 00:00:00	2015-06-30 00:00:00	2014-05-17 00:00:00	2014-06-30 00:00:00	2014-03-17 00:00:00	2014-05-17 00:00:00	2014-12-31 00:00:00	2014-09-30 00:00:00	2014-09-30 00:00:00	2014-10-18 00:00:00	2008-03-31 00:00:00	2008-06-30 00:00:00	2008-09-30 00:00:00	2008-12-31 00:00:00	2009-03-31 00:00:00	2008-12-31 00:00:00	None	2009-03-31 00:00:00	None	2009-09-30 00:00:00	2009-06-30 00:00:00	2009-06-30 00:00:00	2009-12-31 00:00:00	2010-03-31 00:00:00	2010-06-30 00:00:00	2010-09-30 00:00:00	2010-12-31 00:00:00	None	2011-12-31 00:00:00	2011-06-30 00:00:00	2011-12-31 00:00:00	2012-03-17 00:00:00	2012-03-17 00:00:00	2012-05-19 00:00:00	2012-05-19 00:00:00	2012-06-30 00:00:00	2013-12-31 00:00:00	2012-09-30 00:00:00	2012-09-30 00:00:00	2012-06-30 00:00:00	2015-01-21 00:00:00	2014-12-31 00:00:00	2014-10-18 00:00:00	2012-10-20 00:00:00	2012-10-20 00:00:00	2014-10-02 00:00:00	2014-05-17 00:00:00	2014-06-30 00:00:00	2014-03-17 00:00:00	2014-05-17 00:00:00	2012-12-31 00:00:00	2013-01-08 00:00:00	2013-01-08 00:00:00	2014-03-17 00:00:00	2014-05-21 00:00:00	2013-12-31 00:00:00	2014-03-17 00:00:00	2012-12-31 00:00:00	None	2015-06-30 00:00:00	2017-12-31 00:00:00	2018-03-15 00:00:00	2017-06-30 00:00:00	2018-10-23 00:00:00	2018-05-19 00:00:00	2018-10-20 00:00:00	2018-09-22 00:00:00	2018-10-20 00:00:00	2017-06-30 00:00:00	2018-10-20 00:00:00	2018-12-31 00:00:00	2018-09-22 00:00:00	2018-10-20 00:00:00	2018-12-31 00:00:00	2015-12-31 00:00:00	2015-12-31 00:00:00	2016-06-30 00:00:00	2016-09-24 00:00:00	2016-10-03 00:00:00	2016-06-30 00:00:00	2016-10-22 00:00:00	2016-09-24 00:00:00	2016-12-31 00:00:00	2016-10-22 00:00:00	2016-12-31 00:00:00	2017-06-30 00:00:00	2017-06-30 00:00:00	2018-06-30 00:00:00	2018-09-22 00:00:00	None	2019-06-30 00:00:00	2018-06-15 00:00:00	2018-10-20 00:00:00	2019-12-31 00:00:00	2019-06-30 00:00:00	2019-12-31 00:00:00	2018-10-25 00:00:00	2018-10-20 00:00:00	2020-06-30 00:00:00	2020-12-31 00:00:00	2018-12-31 00:00:00	2018-04-21 00:00:00	2018-06-30 00:00:00	2019-12-31 00:00:00	2018-05-19 00:00:00	2018-05-19 00:00:00	2018-12-31 00:00:00	2019-01-21 00:00:00	2017-12-31 00:00:00	2018-09-22 00:00:00	2019-06-30 00:00:00	2018-09-22 00:00:00	2018-04-21 00:00:00	2019-06-30 00:00:00	2019-12-31 00:00:00	2018-05-19 00:00:00	2018-09-22 00:00:00	2022-04-23 00:00:00	2022-05-21 00:00:00	2020-06-30 00:00:00	None	2021-07-23 00:00:00	2020-12-31 00:00:00	2021-06-30 00:00:00	2022-04-23 00:00:00	2021-06-30 00:00:00	2022-05-21 00:00:00	2022-09-28 00:00:00	2021-12-31 00:00:00	2021-12-31 00:00:00	2021-04-29 00:00:00	2022-06-30 00:00:00	2022-09-24 00:00:00	2022-09-24 00:00:00	2022-10-22 00:00:00	2022-06-30 00:00:00	2022-11-03 00:00:00
rpt_date	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	2013-07-10 00:00:00	None	2015-07-09 00:00:00	2014-07-24 00:00:00	2014-07-28 00:00:00	2014-07-24 00:00:00	2014-05-21 00:00:00	None	2014-10-05 00:00:00	None	2014-10-22 00:00:00	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	2012-01-13 00:00:00	None	None	2012-03-16 00:00:00	None	None	2012-05-19 00:00:00	2012-07-09 00:00:00	None	None	2012-10-02 00:00:00	None	2015-01-21 00:00:00	2015-01-21 00:00:00	None	None	2012-10-22 00:00:00	2014-10-02 00:00:00	None	None	None	None	2013-01-21 00:00:00	None	None	2014-03-24 00:00:00	2014-05-21 00:00:00	2014-01-20 00:00:00	None	None	None	None	None	2018-03-15 00:00:00	2017-09-05 00:00:00	2018-10-23 00:00:00	2018-05-24 00:00:00	2019-07-31 00:00:00	None	None	None	None	None	2018-09-26 00:00:00	2019-01-22 00:00:00	2019-01-22 00:00:00	None	2015-12-16 00:00:00	2016-07-27 00:00:00	2016-10-08 00:00:00	2016-10-03 00:00:00	None	2016-10-26 00:00:00	None	2017-01-30 00:00:00	None	None	2017-07-25 00:00:00	None	None	2019-01-28 00:00:00	None	2019-07-30 00:00:00	2018-06-15 00:00:00	None	None	None	2020-01-30 00:00:00	2018-10-25 00:00:00	2018-10-25 00:00:00	None	2021-01-29 00:00:00	None	2018-04-25 00:00:00	2018-07-18 00:00:00	None	None	None	2019-07-31 00:00:00	2019-01-21 00:00:00	2018-01-11 00:00:00	None	None	None	None	2020-04-23 00:00:00	2020-04-23 00:00:00	2018-06-15 00:00:00	2019-07-30 00:00:00	None	2022-05-25 00:00:00	2020-07-31 00:00:00	None	2021-07-23 00:00:00	None	2021-07-29 00:00:00	2022-04-27 00:00:00	None	None	2022-09-28 00:00:00	None	2022-01-28 00:00:00	None	2022-07-29 00:00:00	2022-09-29 00:00:00	None	2022-10-27 00:00:00	None	2022-11-03 00:00:00
filing_type	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	22001	None	22001	22001	22001	22001	22001	None	22001	None	22001	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	22001	None	None	22001	None	None	22001	22001	None	None	22001	None	22001	22001	None	None	22001	22001	None	None	None	None	22001	22001	22001	22001	22001	22001	None	None	None	None	None	22001	22001	22001	22001	22001	None	None	None	None	None	22001	22001	22001	None	22001	22001	22001	22001	None	22001	None	22001	None	None	22001	None	None	22001	None	22001	22001	None	None	None	22001	22001	22001	None	22001	None	22001	22001	None	None	None	22001	22001	22001	None	None	None	None	22001	22001	22001	22001	None	22001	22001	None	22001	None	22001	22001	None	None	22001	None	22001	22001	22001	22001	None	22001	None	22001

Table: filer_to_filer_type
filer_id		1268631
filer_type		16
active		Y
race		0
session_id		2003
category		0
category_type		40502
sub_category		40103
effect_dt		2004-08-18 00:00:00
sub_category_type		0
election_type		0
sub_category_a		None
nyq_dt		2004-01-06 00:00:00
party_cd		0
county_cd		18030
district_cd		0

Table: filer_xref
filer_id		1268631
xref_id		1268631
effect_dt		2004-08-25 00:00:00
migration_source		CLAIMS

Table: filername
xref_filer_id	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631
filer_id	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631
filer_type	RECIPIENT COMMITTEE	RECIPIENT COMMITTEE	RECIPIENT COMMITTEE	RECIPIENT COMMITTEE	RECIPIENT COMMITTEE	RECIPIENT COMMITTEE	RECIPIENT COMMITTEE	RECIPIENT COMMITTEE	RECIPIENT COMMITTEE	RECIPIENT COMMITTEE
status	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE
effect_dt	2004-08-18 00:00:00	2004-08-18 00:00:00	2004-08-18 00:00:00	2004-08-18 00:00:00	2004-08-18 00:00:00	2004-08-18 00:00:00	2004-08-18 00:00:00	2004-08-18 00:00:00	2004-08-18 00:00:00	2004-08-18 00:00:00
naml	EXCHANGE CONTRACTORS PAC	EXCHANGE CONTRACTORS PAC	EXCHANGE CONTRACTORS PAC	EXCHANGE CONTRACTORS PAC	EXCHANGE CONTRACTORS PAC	EXCHANGE CONTRACTORS STATE PAC	EXCHANGE CONTRACTORS STATE PAC	EXCHANGE CONTRACTORS STATE PAC	EXCHANGE CONTRACTORS STATE PAC	EXCHANGE CONTRACTORS STATE PAC
namf	None	None	None	None	None	None	None	None	None	None
namt	None	None	None	None	None	None	None	None	None	None
nams	None	None	None	None	None	None	None	None	None	None
adr1	None	None	None	None	None	None	None	None	None	None
adr2	None	None	None	None	None	None	None	None	None	None
city	LOS BANOS	LOS BANOS	LOS BANOS	DOS PALOS	FRESNO	LOS BANOS	LOS BANOS	LOS BANOS	DOS PALOS	FRESNO
st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA
zip4	93635	93635	93635	93620	937212924	93635	93635	93635	93620	937212924
phon	2098265706	2098261134	2098261134	2098261134	5592663453	2098265706	2098261134	2098261134	2098261134	5592663453
fax	None	None	None	None	None	None	None	None	None	None
email	None	None	None	None	[email protected]	None	None	None	None	[email protected]

Table: filers
filer_id		1268631

Table: received_filings
filer_id	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631	1268631
filing_file_name	1723357_0.cal	1723357_1.cal	2084469_0.cal	1890706_0.cal	2222639_0.cal	2311047_0.cal	277233.cal	2260862_0.cal	2312765_0.cal	2336673_0.cal	1723357_2.cal	2596246_0.cal
received_date	2013-01-08 00:00:00	2013-01-08 00:00:00	2016-10-03 00:00:00	2014-10-02 00:00:00	2018-03-15 00:00:00	2018-10-23 00:00:00	2018-06-15 00:00:00	2018-06-15 00:00:00	2018-10-25 00:00:00	2019-01-21 00:00:00	2021-04-30 00:00:00	2021-07-23 00:00:00
filing_directory	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal
filing_id	1723357	1723357	2084469	1890706	2222639	2311047	None	2260862	2312765	2336673	1723357	2596246
form_id	F410	F410	F497	F497	F497	F497	None	F497	F497	F497	F410	F497
receive_comment	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted