OpenCalAccess

Filer ID: 1266808

Table: cvr_campaign_disclosure
filing_id	1070223	1140127	1172153	1110847	1203276	1226292	1182331	1302058	1333164	1333221	1333164	1276239	1334856	1318609	1342097	1429682	1367502	1387781	1362669	1489264	1489264	1457024	1473138	1457024	1429682	1498897	1557074	1527938	1521022	1598787	1645861	1626495	1670019	1723302	1692433	1826602	1830216	1809418	1775876	1849100	1836487	1861568	1851783	1924536	1945387	1972543	2002295	2045090	2044156	2081838	2073705	2053385	2165738	2117293	2199995	2262671	2295219	2293027	2331520	2388402	2428463	2479433
amend_id	0	0	0	0	0	0	0	0	1	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	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
rec_type	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR
form_type	F460	F460	F460	F460	F460	F460	F460	F460	F460	F497	F460	F460	F497	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F497	F460	F460	F460	F497	F497	F460	F460	F460	F497	F460	F460	F460	F497	F460	F497	F460	F460	F460	F460	F460	F460	F497	F460	F460	F460	F460
filer_id	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808
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
filer_naml	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC
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
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
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
report_num	000	000	000	000	000	000	000	000	001	000	000	000	000	000	000	000	000	000	000	000	001	001	000	000	001	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000
rpt_date	2005-01-05 00:00:00	2006-01-03 00:00:00	2006-05-21 00:00:00	2005-06-27 00:00:00	2006-10-02 00:00:00	2007-01-02 00:00:00	2006-07-05 00:00:00	2008-01-03 00:00:00	2008-05-20 00:00:00	2008-05-19 00:00:00	2008-05-18 00:00:00	2007-07-05 00:00:00	2008-05-22 00:00:00	2008-03-17 00:00:00	2008-07-01 00:00:00	2009-07-08 00:00:00	2008-10-20 00:00:00	2009-01-06 00:00:00	2008-10-06 00:00:00	2010-05-28 00:00:00	2010-05-24 00:00:00	2010-03-16 00:00:00	2010-03-18 00:00:00	2010-01-06 00:00:00	2009-08-19 00:00:00	2010-07-01 00:00:00	2011-01-04 00:00:00	2010-10-18 00:00:00	2010-10-01 00:00:00	2011-07-05 00:00:00	2012-03-19 00:00:00	2012-01-03 00:00:00	2012-07-02 00:00:00	2013-01-03 00:00:00	2012-10-01 00:00:00	2014-03-07 00:00:00	2014-03-18 00:00:00	2014-01-09 00:00:00	2013-07-16 00:00:00	2014-05-12 00:00:00	2014-04-07 00:00:00	2014-07-03 00:00:00	2014-05-19 00:00:00	2015-01-07 00:00:00	2015-02-20 00:00:00	2015-07-01 00:00:00	2016-01-04 00:00:00	2016-05-23 00:00:00	2016-05-18 00:00:00	2016-09-26 00:00:00	2016-09-02 00:00:00	2016-07-01 00:00:00	2017-07-05 00:00:00	2017-01-04 00:00:00	2018-01-02 00:00:00	2018-07-02 00:00:00	2018-09-24 00:00:00	2018-09-18 00:00:00	2019-01-02 00:00:00	2019-07-01 00:00:00	2020-01-02 00:00:00	2020-07-02 00:00:00
stmt_type	SA	SA	PE	SA	PE	SA	SA	SA	PE	None	PE	SA	None	PE	SA	PE	PE	SA	PE	PE	PE	SA	PE	SA	SA	SA	SA	PE	PE	SA	PE	SA	SA	SA	PE	None	PE	SA	SA	None	None	SA	PE	SA	None	SA	SA	PE	None	PE	None	SA	SA	SA	SA	SA	PE	None	SA	SA	SA	TS
late_rptno	None	None	None	None	None	None	None	None	None	1	None	None	2	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	P14-1	None	None	None	P14-3	P14-2	None	None	None	SE-0315	None	None	None	P2016-1	None	G2016-1	None	None	None	None	None	None	GE-1106#1	None	None	None	None
from_date	2004-01-01 00:00:00	2005-07-01 00:00:00	2006-01-01 00:00:00	2005-01-01 00:00:00	2006-07-01 00:00:00	2006-10-01 00:00:00	2006-05-21 00:00:00	2007-07-01 00:00:00	2008-03-18 00:00:00	None	2008-03-18 00:00:00	2007-01-01 00:00:00	None	2008-01-01 00:00:00	2008-05-18 00:00:00	2009-01-01 00:00:00	2008-10-01 00:00:00	2008-10-19 00:00:00	2008-07-01 00:00:00	2010-03-18 00:00:00	2010-03-18 00:00:00	2009-07-01 00:00:00	2010-01-01 00:00:00	2009-07-01 00:00:00	2009-01-01 00:00:00	2010-05-23 00:00:00	2010-10-17 00:00:00	2010-10-01 00:00:00	2010-07-01 00:00:00	2011-01-01 00:00:00	2012-01-01 00:00:00	2011-07-01 00:00:00	2012-03-18 00:00:00	2012-10-01 00:00:00	2012-07-01 00:00:00	None	2014-01-01 00:00:00	2013-07-01 00:00:00	2013-01-01 00:00:00	None	None	2014-05-18 00:00:00	2014-03-18 00:00:00	2014-07-01 00:00:00	None	2015-01-01 00:00:00	2015-07-01 00:00:00	2016-01-01 00:00:00	None	2016-07-01 00:00:00	None	2016-05-22 00:00:00	2017-01-01 00:00:00	2016-09-25 00:00:00	2017-07-01 00:00:00	2018-01-01 00:00:00	2018-07-01 00:00:00	None	2018-09-23 00:00:00	2019-01-01 00:00:00	2019-07-01 00:00:00	2020-01-01 00:00:00
thru_date	2004-12-31 00:00:00	2005-12-31 00:00:00	2006-05-20 00:00:00	2005-06-30 00:00:00	2006-09-30 00:00:00	2006-12-31 00:00:00	2006-06-30 00:00:00	2007-12-31 00:00:00	2008-05-17 00:00:00	None	2008-05-17 00:00:00	2007-06-30 00:00:00	None	2008-03-17 00:00:00	2008-06-30 00:00:00	2009-06-30 00:00:00	2008-10-18 00:00:00	2008-12-31 00:00:00	2008-09-30 00:00:00	2010-05-22 00:00:00	2010-05-22 00:00:00	2009-12-31 00:00:00	2010-03-17 00:00:00	2009-12-31 00:00:00	2009-06-30 00:00:00	2010-06-30 00:00:00	2010-12-31 00:00:00	2010-10-16 00:00:00	2010-09-30 00:00:00	2011-06-30 00:00:00	2012-03-17 00:00:00	2011-12-31 00:00:00	2012-06-30 00:00:00	2012-12-31 00:00:00	2012-09-30 00:00:00	None	2014-03-17 00:00:00	2013-12-31 00:00:00	2013-06-30 00:00:00	None	None	2014-06-30 00:00:00	2014-05-17 00:00:00	2014-12-31 00:00:00	None	2015-06-30 00:00:00	2015-12-31 00:00:00	2016-05-21 00:00:00	None	2016-09-24 00:00:00	None	2016-06-30 00:00:00	2017-06-30 00:00:00	2016-12-31 00:00:00	2017-12-31 00:00:00	2018-06-30 00:00:00	2018-09-22 00:00:00	None	2018-12-31 00:00:00	2019-06-30 00:00:00	2019-12-31 00:00:00	2020-06-01 00:00:00
elect_date	None	None	2006-06-06 00:00:00	None	2006-11-07 00:00:00	None	None	None	2008-06-03 00:00:00	None	2008-06-03 00:00:00	None	None	2008-06-03 00:00:00	None	None	2008-11-04 00:00:00	None	2008-11-04 00:00:00	2010-06-08 00:00:00	2010-06-08 00:00:00	None	2010-06-08 00:00:00	None	None	None	None	2010-11-02 00:00:00	2010-11-02 00:00:00	None	2012-06-05 00:00:00	None	None	None	2012-11-06 00:00:00	None	2014-06-03 00:00:00	None	None	None	None	None	2014-06-03 00:00:00	None	None	None	None	2016-06-07 00:00:00	None	2016-11-08 00:00:00	None	None	None	None	None	None	2018-11-06 00:00:00	None	None	None	None	None
filer_city	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
filer_zip4	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	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280
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
file_email	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	[email protected] 359900SSB	359900 - SSB	[email protected] 359900SSB	[email protected] 359900SSB	[email protected] 359900SSB	[email protected] 359900SSB	[email protected] 359900SSB	[email protected] 359900SSB	[email protected] 359900SSB	[email protected] 359900SSB
mail_city	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
mail_st	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
mail_zip4	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
tres_naml	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman
tres_namf	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard
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
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
tres_city	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	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	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	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	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280
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
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
cmtte_type	G	G	G	G	G	G	G	G	G	None	G	G	None	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	None	G	G	G	None	None	G	G	G	None	G	G	G	None	G	None	G	G	G	G	G	G	None	G	G	G	G
control_yn	Y	Y	Y	Y	Y	Y	Y	Y	Y	None	Y	Y	None	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	None	Y	Y	Y	None	None	Y	Y	Y	None	Y	Y	Y	None	Y	None	Y	Y	Y	Y	Y	Y	None	Y	Y	Y	Y
sponsor_yn	N	N	N	N	N	N	N	N	N	None	N	N	None	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	None	N	N	N	None	None	N	N	N	None	N	N	N	None	N	None	N	N	N	N	N	N	None	N	N	N	N
primfrm_yn	N	N	N	N	N	N	N	N	N	None	N	N	None	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	None	N	N	N	None	None	N	N	N	None	N	N	N	None	N	None	N	N	N	N	N	N	None	N	N	N	N
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
amendexp_1	None	None	None	None	None	None	None	None	Amending to include an accrued expense and an inkind contribution to Mike Villines	None	None	None	None	None	None	None	None	None	None	None	Amending to correct report signature date.	Amending to delete an accrued expense inadvertantly included in the filed report	None	None	Amending to include an accrued expense	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
amendexp_2	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

Table: cvr_so
filing_id	1070308	1070308	1070308	1070308	1070308	1070308
amend_id	0	1	2	3	4	5
rec_type	CVR	CVR	CVR	CVR	CVR	CVR
form_type	F410	F410	F410	F410	F410	F410
filer_id	1266808	1266808	1266808	1266808	1266808	1266808
entity_cd	RCP	RCP	RCP	RCP	RCP	RCP
filer_naml	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC	California Oncology Political Action Committee AKA CalCancerPAC
filer_namf	None	None	None	None	None	None
filer_namt	None	None	None	None	None	None
filer_nams	None	None	None	None	None	None
report_num	000	001	002	003	004	005
rpt_date	2005-01-06 00:00:00	2008-12-15 00:00:00	2012-12-10 00:00:00	2013-02-05 00:00:00	2018-01-02 00:00:00	2020-07-02 00:00:00
qual_cb	None	None	None	X	X	X
qualfy_dt	2004-07-09 00:00:00	2004-07-09 00:00:00	2004-07-09 00:00:00	2004-07-09 00:00:00	2004-07-09 00:00:00	2004-07-09 00:00:00
term_date	None	None	None	None	None	2020-06-01 00:00:00
city	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento
st	CA	CA	CA	CA	CA	CA
zip4	95814	95814	95814	95814	95814	95814
phone	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280
county_res	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento
county_act	None	None	None	None	None	None
mail_city	None	None	None	None	None	None
mail_st	None	None	None	None	None	None
mail_zip4	None	None	None	None	None	None
cmte_fax	None	None	None	None	None	None
cmte_email	359900 - SSB	359900 - SSB	359900 - SSB	359900 - SSB	[email protected] 359900SSB	[email protected] 359900SSB
tres_naml	Eichman	Eichman	Eichman	Eichman	Eichman	Eichman
tres_namf	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard	J. Richard
tres_namt	None	None	None	None	None	None
tres_nams	None	None	None	None	None	None
tres_city	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento
tres_st	CA	CA	CA	CA	CA	CA
tres_zip4	95814	95814	95814	95814	95814	95814
tres_phon	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280	(916) 442-2280
actvty_lvl	ST	ST	ST	ST	ST	ST
com82013yn	None	None	None	None	None	None
com82013nm	None	None	None	None	None	None
com82013id	None	None	None	None	None	None
control_cb	None	None	None	None	None	None
bank_nam	Bank of America	None	Wells Fargo Bank, N.A.	Wells Fargo Bank, N.A.	Wells Fargo Bank, N.A.	Wells Fargo Bank, N.A.
bank_adr1	1130 K Street	None	400 Capitol Mall, Sacramento, CA 95814	400 Capitol Mall, Sacramento, CA 95814	400 Capitol Mall, Sacramento, CA 95814	400 Capitol Mall, Sacramento, CA 95814
bank_adr2	None	None	None	None	None	None
bank_city	Sacramento	None	www.wellsfargo.com	www.wellsfargo.com	www.wellsfargo.com	www.wellsfargo.com
bank_st	CA	None	None	None	None	None
bank_zip4	95814	None	None	None	None	None
bank_phon	None	None	916-440-4331	916-440-4331	916-440-4331	916-440-4331
acct_opendt	None	None	None	None	None	None
surplusdsp	None	None	None	None	None	None
primfc_cb	None	None	None	None	None	None
genpurp_cb	None	None	None	None	None	None
gpc_descr	This committee expects to support numerous candidates for state constitutional offices, state legislature, county & city offices, each of whom will be listed in the committee's campaign statements, filed pursuant to Government Code 84200, et seq.	This committee expects to support numerous candidates for state constitutional offices, state legislature, county & city offices, each of whom will be listed in the committee's campaign statements, filed pursuant to Government Code 84200, et seq.	This committee expects to support numerous candidates for state constitutional offices, state legislature, county & city offices, each of whom will be listed in the committee's campaign statements, filed pursuant to Government Code 84200, et seq.	This committee expects to support numerous candidates for state constitutional offices, state legislature, county & city offices, each of whom will be listed in the committee's campaign statements, filed pursuant to Government Code 84200, et seq.	This committee expects to support numerous candidates for state constitutional offices, state legislature, county & city offices, each of whom will be listed in the committee's campaign statements, filed pursuant to Government Code 84200, et seq.	This committee expects to support numerous candidates for state constitutional offices, state legislature, county & city offices, each of whom will be listed in the committee's campaign statements, filed pursuant to Government Code 84200, et seq.
sponsor_cb	None	None	None	None	X	X
brdbase_cb	None	None	None	None	None	None
smcont_qualdt	None	None	None	None	None	None

Table: filer_acronyms
acronym		CANCERPAC
filer_id		1266808

Table: filer_address
filer_id	1266808	1266808	1266808
adrid	2069373	2156235	2444275
effect_dt	2002-07-24 00:00:00	2004-07-09 00:00:00	2018-01-05 00:00:00
add_type	7051	7051	7051
session_id	2003	2003	2017

Table: filer_filings
filer_id	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808
filing_id	1022819	1070223	1070308	1109066	1110847	1115688	1140127	1140386	1182331	1184063	1172732	1172153	1205332	1203276	1226292	1227182	1276239	1276561	1302058	1777779	1775876	1972989	1972543	1849100	1861568	1861374	1862005	1809418	1944642	1945387	1302472	1319248	1318609	1334856	1333164	1333164	1333221	1333547	1333643	1335892	1333643	1342736	1342097	1367502	1362669	1363642	1371486	1388077	1384208	1387781	1070308	1429682	1430339	1430339	1457024	1429682	1457720	1457024	1473138	1489264	1489264	1490196	1490196	1498897	1474402	1457720	1499065	1529219	1527938	1523336	1521022	1557959	1557074	1599243	1598787	1626495	1627488	1645861	1646505	1670551	1670019	1826602	1810221	1830216	1832903	1693210	1692433	1924536	1070308	1070308	1728490	1723302	1731570	1851783	1836487	1751237	1757278	2002295	2003164	2356260	2262671	2295219	2491735	2293027	2201062	2447648	2045090	2044156	2052085	2073705	2060052	2053385	2081838	2091362	2117293	2118166	2165738	2167158	2298137	2331520	2388402	2264171	1070308	2479433	2199995	2489024	2394741	2428463	2200825	1070308
period_id	None	177	181	None	181	None	183	None	186	None	None	185	None	187	188	None	189	None	191	None	213	None	221	218	218	None	None	215	None	221	None	None	193	194	193	193	194	None	None	None	None	None	194	196	195	None	None	None	None	196	196	197	None	None	199	197	None	199	201	201	201	None	None	202	None	None	None	None	204	None	203	None	204	None	205	207	None	209	None	None	209	217	None	217	None	None	211	219	212	213	None	212	None	217	218	None	None	223	None	None	233	235	None	235	None	None	225	226	None	227	None	226	227	None	227	None	229	None	None	235	237	None	243	241	231	None	None	239	None	233
form_id	F410	F460	F410	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F497	F460	F460	F460	F460	F460	F497	F460	F460	F460	F497	F460	F460	F497	F497	F460	F497	F460	F460	F460	F460	F460	F460	F460	F460	F410	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	F497	F460	F460	F460	F460	F460	F460	F410	F410	F460	F460	F410	F460	F497	F666	F410	F460	F460	F460	F460	F460	F460	F497	F460	F460	F460	F497	F460	F497	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F410	F460	F460	F410	F460	F460	F410	F410
filing_sequence	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	1	0	1	0	1	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	2	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	5	0	0	0	0	0	0	4
filing_date	2004-07-14 00:00:00	2005-01-05 00:00:00	2005-01-06 00:00:00	2005-01-13 00:00:00	2005-07-05 00:00:00	2005-07-05 00:00:00	2006-01-03 00:00:00	2006-01-04 00:00:00	2006-07-05 00:00:00	2006-07-07 00:00:00	2006-05-22 00:00:00	2006-05-21 00:00:00	2006-10-02 00:00:00	2006-10-02 00:00:00	2007-01-03 00:00:00	2007-01-05 00:00:00	2007-07-05 00:00:00	2007-07-06 00:00:00	2008-01-03 00:00:00	2013-07-18 00:00:00	2013-07-16 00:00:00	2015-07-02 00:00:00	2015-07-01 00:00:00	2014-05-12 00:00:00	2014-07-08 00:00:00	2014-05-20 00:00:00	2014-07-08 00:00:00	2014-01-09 00:00:00	2015-01-13 00:00:00	2015-02-20 00:00:00	2008-01-07 00:00:00	2008-03-19 00:00:00	2008-03-18 00:00:00	2008-05-22 00:00:00	2008-05-21 00:00:00	2008-05-19 00:00:00	2008-05-19 00:00:00	2008-05-19 00:00:00	2008-05-19 00:00:00	2008-05-22 00:00:00	2008-05-21 00:00:00	2008-07-09 00:00:00	2008-07-07 00:00:00	2008-10-20 00:00:00	2008-10-06 00:00:00	2008-10-06 00:00:00	2008-10-21 00:00:00	2009-01-08 00:00:00	2008-12-16 00:00:00	2009-01-07 00:00:00	2008-12-15 00:00:00	2009-07-08 00:00:00	2009-07-09 00:00:00	2009-08-21 00:00:00	2010-01-07 00:00:00	2009-08-19 00:00:00	2010-01-12 00:00:00	2010-03-18 00:00:00	2010-03-18 00:00:00	2010-05-24 00:00:00	2010-05-24 00:00:00	2010-05-25 00:00:00	2010-05-25 00:00:00	2010-07-01 00:00:00	2010-03-18 00:00:00	2010-03-18 00:00:00	2010-07-01 00:00:00	2010-10-18 00:00:00	2010-10-18 00:00:00	2010-10-01 00:00:00	2010-10-01 00:00:00	2011-01-06 00:00:00	2011-01-05 00:00:00	2011-07-07 00:00:00	2011-07-06 00:00:00	2012-01-04 00:00:00	2012-01-05 00:00:00	2012-03-19 00:00:00	2012-03-20 00:00:00	2012-07-06 00:00:00	2012-07-05 00:00:00	2014-03-07 00:00:00	2014-01-10 00:00:00	2014-03-19 00:00:00	2014-03-20 00:00:00	2012-10-02 00:00:00	2012-10-01 00:00:00	2015-01-11 00:00:00	2012-12-17 00:00:00	2013-02-05 00:00:00	2013-01-10 00:00:00	2013-01-08 00:00:00	2012-12-18 00:00:00	2014-05-20 00:00:00	2014-04-07 00:00:00	2013-02-28 00:00:00	2013-02-05 00:00:00	2016-01-05 00:00:00	2016-01-05 00:00:00	2019-01-02 00:00:00	2018-07-05 00:00:00	2018-09-25 00:00:00	2020-07-28 00:00:00	2018-09-18 00:00:00	2018-01-05 00:00:00	2020-01-07 00:00:00	2016-05-23 00:00:00	2016-05-19 00:00:00	2016-05-24 00:00:00	2016-09-02 00:00:00	2016-07-06 00:00:00	2016-07-05 00:00:00	2016-09-27 00:00:00	2016-09-27 00:00:00	2017-01-05 00:00:00	2017-01-05 00:00:00	2017-07-06 00:00:00	2017-07-06 00:00:00	2018-09-25 00:00:00	2019-01-02 00:00:00	2019-07-02 00:00:00	2018-07-06 00:00:00	2020-07-20 00:00:00	2020-07-20 00:00:00	2018-01-04 00:00:00	2020-07-27 00:00:00	2019-07-03 00:00:00	2020-01-07 00:00:00	2018-01-05 00:00:00	2018-01-04 00:00:00
stmnt_type	10005	10001	10001	10005	10001	10005	10001	10005	10001	10005	10005	10001	10005	10001	10001	10005	10001	10005	10001	10005	10001	10005	10001	10001	10001	10005	10005	10001	10005	10001	10005	10005	10001	10001	10002	10001	10001	10005	10005	10005	10006	10005	10001	10001	10001	10005	10005	10005	10006	10001	10002	10001	10005	10006	10001	10002	10005	10002	10001	10002	10001	10005	10006	10001	10005	10006	10005	10005	10001	10005	10001	10005	10001	10005	10001	10001	10005	10001	10005	10005	10001	10001	10005	10001	10005	10005	10001	10001	10002	10002	10005	10001	10006	10001	10001	10005	10002	10001	10005	10005	10001	10001	10003	10001	10005	10005	10001	10001	10005	10001	10005	10001	10001	10005	10001	10005	10001	10005	10005	10001	10001	10005	10002	10001	10001	10003	10005	10001	10006	10002
stmnt_status	11003	11003	11003	11001	11003	11001	11003	11001	11003	11001	11001	11003	11001	11003	11003	11001	11003	11001	11003	11001	11001	11001	11001	11001	11003	11001	11003	11003	11003	11001	11001	11001	11003	11001	11003	11003	11001	11001	11001	11001	11003	11001	11003	11003	11003	11003	11003	11003	11001	11003	11003	11001	11001	11003	11001	11003	11001	11001	11001	11003	11003	11001	11003	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11003	11001	11001	11003	11003	11003	11001	11001	11003	11003	11001	11001	11001	11003	11001	11001	11001	11003	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001
session_id	2003	2003	2005	2003	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2007	2007	2007	2013	2013	2015	2015	2013	2013	2013	2013	2013	2013	2015	2007	2007	2007	2007	2007	2007	2007	2007	2007	2007	2007	2007	2007	2007	2007	2007	2007	2009	2007	2007	2007	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2011	2011	2011	2011	2011	2011	2011	2011	2013	2013	2013	2013	2011	2011	2013	2011	2013	2011	2011	2011	2013	2013	2009	2013	2015	2015	2017	2017	2017	2019	2017	2017	2019	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2017	2017	2017	2017	2019	2017	2019	2019	2017	2019	2019	2019	2017	2017
user_id	EMCENTEE	COMPLETED	COMPLETED	CFLAGG	*	CFLAGG	*	GPEREZ	*	GPEREZ	CFLAGG	*	GPEREZ	*	*	SARRIAGA	*	SARRIAGA	*	SMCCONNAN	SMCCONNAN	SARRIAGA	SARRIAGA	WBROWN	CAFILER	MDIGRAZIA	MPACHECO	CAFILER	GCLARA	WBROWN	SARRIAGA	SARRIAGA	*	DHORRELL	*	*	DHORRELL	LHOANG	TMILLER	LHOANG	LHOANG	SARRIAGA	*	*	*	RGEREMIA	RGEREMIA	JVAZQUEZ	RGEREMIA	*	*	CPON	CPON	JVAZQUEZ	CPON	*	CPON	MMORENO	MMORENO	*	*	SARRIAGA	JVAZQUEZ	CPON	MMORENO	JVAZQUEZ	CPON	SMCCONNAN	SMCCONNAN	SMCCONNAN	SMCCONNAN	CPON	CPON	SMCCONNAN	SMCCONNAN	SMCCONNAN	SMCCONNAN	CPON	CPON	MPACHECO	CPON	WBROWN	MPACHECO	SARRIAGA	SARRIAGA	MPACHECO	CAFILER	CAFILER	TRAMON	TRAMON	MPACHECO	CAFILER	TRAMON	MDIGRAZIA	WBROWN	NLANDERS	TRAMON	SARRIAGA	SARRIAGA	JFONSECA	HSTOVALL	BSINGH	KRUSSELL	CAFILER	LBARTHOL	LFEDOROV	SMCCONNAN	KBANH	SMCCONNAN	PDEO	CPON	CPON	LPALMER	LPALMER	CPON	CPON	RPOOJA	RPOOJA	BSINGH	CAFILER	HCOURSEY	HSTOVALL	LPHEAV	LPHEAV	LBARTHOL	LPHEAV	HCOURSEY	LFEDOROV	TRAMON	TRAMON
special_audit	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	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	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11001	11003	11003	11001	11003	11001	11003	11003	11003	11001	11003	11003	11003	11001	11003	11003	11001	11001	11001	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11001	11003	11001	11003	11001	11003	11001	11003	11003	11003	11003	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11001	11001	11001	11001	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11003	11003	11003	11003	11003	11003
rpt_start	None	2004-01-01 00:00:00	2005-01-06 00:00:00	2004-01-01 00:00:00	2005-01-01 00:00:00	2005-01-01 00:00:00	2005-07-01 00:00:00	2005-07-01 00:00:00	2006-05-21 00:00:00	2006-05-21 00:00:00	2006-01-01 00:00:00	2006-01-01 00:00:00	2006-07-01 00:00:00	2006-07-01 00:00:00	2006-10-01 00:00:00	2006-10-01 00:00:00	2007-01-01 00:00:00	2007-01-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	2015-01-01 00:00:00	2014-05-12 00:00:00	2014-05-18 00:00:00	2014-03-18 00:00:00	2014-05-18 00:00:00	2013-07-01 00:00:00	2014-07-01 00:00:00	2015-02-20 00:00:00	2007-07-01 00:00:00	2008-01-01 00:00:00	2008-01-01 00:00:00	2008-05-22 00:00:00	2008-03-18 00:00:00	2008-03-18 00:00:00	2008-05-19 00:00:00	None	2008-03-18 00:00:00	None	2008-03-18 00:00:00	2008-05-18 00:00:00	2008-05-18 00:00:00	2008-10-01 00:00:00	2008-07-01 00:00:00	2008-07-01 00:00:00	2008-10-01 00:00:00	2008-10-19 00:00:00	None	2008-10-19 00:00:00	2008-12-15 00:00:00	2009-01-01 00:00:00	2009-01-01 00:00:00	2009-01-01 00:00:00	2009-07-01 00:00:00	2009-01-01 00:00:00	2009-07-01 00:00:00	2009-07-01 00:00:00	2010-01-01 00:00:00	2010-03-18 00:00:00	2010-03-18 00:00:00	2010-03-18 00:00:00	2010-03-18 00:00:00	2010-05-23 00:00:00	2010-01-01 00:00:00	2009-07-01 00:00:00	2010-05-23 00:00:00	2010-10-01 00:00:00	2010-10-01 00:00:00	2010-07-01 00:00:00	2010-07-01 00:00:00	2010-10-17 00:00:00	2010-10-17 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2011-07-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	2014-03-07 00:00:00	2013-07-01 00:00:00	2014-01-01 00:00:00	2014-01-01 00:00:00	2012-07-01 00:00:00	2012-07-01 00:00:00	2014-07-01 00:00:00	2012-12-10 00:00:00	2013-02-05 00:00:00	2012-10-01 00:00:00	2012-10-01 00:00:00	None	2014-03-18 00:00:00	2014-04-07 00:00:00	2009-01-01 00:00:00	None	2015-07-01 00:00:00	2015-07-01 00:00:00	2018-09-23 00:00:00	2018-01-01 00:00:00	2018-07-01 00:00:00	2020-01-01 00:00:00	2018-09-18 00:00:00	2017-07-01 00:00:00	2019-07-01 00:00:00	2016-01-01 00:00:00	2016-05-18 00:00:00	2016-01-01 00:00:00	2016-09-02 00:00:00	2016-05-22 00:00:00	2016-05-22 00:00:00	2016-07-01 00:00:00	2016-07-01 00:00:00	2016-09-25 00:00:00	2016-09-25 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2018-07-01 00:00:00	2018-09-23 00:00:00	2019-01-01 00:00:00	2018-01-01 00:00:00	2020-07-02 00:00:00	2020-01-01 00:00:00	2017-07-01 00:00:00	None	2019-01-01 00:00:00	2019-07-01 00:00:00	None	2018-01-02 00:00:00
rpt_end	None	2004-12-31 00:00:00	2005-01-06 00:00:00	2004-12-31 00:00:00	2005-06-30 00:00:00	2005-06-30 00:00:00	2005-12-31 00:00:00	2005-12-31 00:00:00	2006-06-30 00:00:00	2006-06-30 00:00:00	2006-05-20 00:00:00	2006-05-20 00:00:00	2006-09-30 00:00:00	2006-09-30 00:00:00	2006-12-31 00:00:00	2006-12-31 00:00:00	2007-06-30 00:00:00	2007-06-30 00:00:00	2007-12-31 00:00:00	2013-06-30 00:00:00	2013-06-30 00:00:00	2015-06-30 00:00:00	2015-06-30 00:00:00	2014-05-12 00:00:00	2014-06-30 00:00:00	2014-05-17 00:00:00	2014-06-30 00:00:00	2013-12-31 00:00:00	2014-12-31 00:00:00	2015-02-20 00:00:00	2007-12-31 00:00:00	2008-03-17 00:00:00	2008-03-17 00:00:00	2008-05-22 00:00:00	2008-05-17 00:00:00	2008-05-17 00:00:00	2008-05-19 00:00:00	None	2008-05-17 00:00:00	None	2008-05-17 00:00:00	2008-06-30 00:00:00	2008-06-30 00:00:00	2008-10-18 00:00:00	2008-09-30 00:00:00	2008-09-30 00:00:00	2008-10-18 00:00:00	2008-12-31 00:00:00	None	2008-12-31 00:00:00	2008-12-15 00:00:00	2009-06-30 00:00:00	2009-06-30 00:00:00	2009-06-30 00:00:00	2009-12-31 00:00:00	2009-06-30 00:00:00	2009-12-31 00:00:00	2009-12-31 00:00:00	2010-03-17 00:00:00	2010-05-22 00:00:00	2010-05-22 00:00:00	2010-05-22 00:00:00	2010-05-22 00:00:00	2010-06-30 00:00:00	2010-03-17 00:00:00	2009-12-31 00:00:00	2010-06-30 00:00:00	2010-10-16 00:00:00	2010-10-16 00:00:00	2010-09-30 00:00:00	2010-09-30 00:00:00	2010-12-31 00:00:00	2010-12-31 00:00:00	2011-06-30 00:00:00	2011-06-30 00:00:00	2011-12-31 00:00:00	2011-12-31 00:00:00	2012-03-17 00:00:00	2012-03-17 00:00:00	2012-06-30 00:00:00	2012-06-30 00:00:00	2014-03-07 00:00:00	2013-12-31 00:00:00	2014-03-17 00:00:00	2014-03-17 00:00:00	2012-09-30 00:00:00	2012-09-30 00:00:00	2014-12-31 00:00:00	2012-12-10 00:00:00	2013-02-05 00:00:00	2012-12-31 00:00:00	2012-12-31 00:00:00	None	2014-05-17 00:00:00	2014-04-07 00:00:00	2010-12-31 00:00:00	None	2015-12-31 00:00:00	2015-12-31 00:00:00	2018-12-31 00:00:00	2018-06-30 00:00:00	2018-09-22 00:00:00	2020-06-01 00:00:00	2018-09-18 00:00:00	2017-12-31 00:00:00	2019-12-31 00:00:00	2016-05-21 00:00:00	2016-05-18 00:00:00	2016-05-21 00:00:00	2016-09-02 00:00:00	2016-06-30 00:00:00	2016-06-30 00:00:00	2016-09-24 00:00:00	2016-09-24 00:00:00	2016-12-31 00:00:00	2016-12-31 00:00:00	2017-06-30 00:00:00	2017-06-30 00:00:00	2018-09-22 00:00:00	2018-12-31 00:00:00	2019-06-30 00:00:00	2018-06-30 00:00:00	2020-07-02 00:00:00	2020-06-01 00:00:00	2017-12-31 00:00:00	None	2019-06-30 00:00:00	2019-12-31 00:00:00	None	2018-01-02 00:00:00
rpt_date	None	2005-01-05 00:00:00	None	None	2005-06-27 00:00:00	None	2006-01-03 00:00:00	None	2006-07-05 00:00:00	None	None	2006-05-21 00:00:00	None	2006-10-02 00:00:00	2007-01-02 00:00:00	None	2007-07-05 00:00:00	None	2008-01-03 00:00:00	None	2013-07-16 00:00:00	None	2015-07-01 00:00:00	2014-05-12 00:00:00	2014-07-03 00:00:00	None	None	2014-01-09 00:00:00	None	2015-02-20 00:00:00	None	None	2008-03-17 00:00:00	2008-05-22 00:00:00	2008-05-20 00:00:00	2008-05-18 00:00:00	2008-05-19 00:00:00	None	None	None	None	None	2008-07-01 00:00:00	2008-10-20 00:00:00	2008-10-06 00:00:00	None	None	None	None	2009-01-06 00:00:00	None	2009-07-08 00:00:00	None	None	2010-01-06 00:00:00	2009-08-19 00:00:00	None	2010-03-16 00:00:00	2010-03-18 00:00:00	2010-05-24 00:00:00	2010-05-28 00:00:00	None	None	2010-07-01 00:00:00	None	None	None	None	2010-10-18 00:00:00	None	2010-10-01 00:00:00	None	2011-01-04 00:00:00	None	2011-07-05 00:00:00	2012-01-03 00:00:00	None	2012-03-19 00:00:00	None	None	2012-07-02 00:00:00	2014-03-07 00:00:00	None	2014-03-18 00:00:00	None	None	2012-10-01 00:00:00	2015-01-07 00:00:00	None	None	None	2013-01-03 00:00:00	None	2014-05-19 00:00:00	2014-04-07 00:00:00	None	None	2016-01-04 00:00:00	None	None	2018-07-02 00:00:00	2018-09-24 00:00:00	None	2018-09-18 00:00:00	None	None	2016-05-23 00:00:00	2016-05-18 00:00:00	None	2016-09-02 00:00:00	None	2016-07-01 00:00:00	2016-09-26 00:00:00	None	2017-01-04 00:00:00	None	2017-07-05 00:00:00	None	None	2019-01-02 00:00:00	2019-07-01 00:00:00	None	None	2020-07-02 00:00:00	2018-01-02 00:00:00	None	None	2020-01-02 00:00:00	None	None
filing_type	None	22001	22001	None	22001	None	22001	None	22001	None	None	22001	None	22001	22001	None	22001	None	22001	None	22001	None	22001	22001	22001	None	None	22001	None	22001	None	None	22001	22001	22001	22001	22001	None	None	None	None	None	22001	22001	22001	None	None	None	None	22001	22001	22001	None	None	22001	22001	None	22001	22001	22001	22001	None	None	22001	None	None	None	None	22001	None	22001	None	22001	None	22001	22001	None	22001	None	None	22001	22001	None	22001	None	None	22001	22001	22001	22001	None	22001	None	22001	22001	None	None	22001	None	None	22001	22001	None	22001	None	None	22001	22001	None	22001	None	22001	22001	None	22001	None	22001	None	None	22001	22001	None	22001	22001	22001	None	None	22001	None	22001

Table: filer_to_filer_type
filer_id	1266808	1266808
filer_type	16	16
active	Y	T
race	0	0
session_id	2003	2019
category	0	0
category_type	40502	40502
sub_category	40103	40103
effect_dt	2004-07-14 00:00:00	2020-06-01 00:00:00
sub_category_type	0	0
election_type	0	0
sub_category_a	S	S
nyq_dt	2004-07-09 00:00:00	2004-07-09 00:00:00
party_cd	0	0
county_cd	18004	18004
district_cd	0	0

Table: filer_xref
filer_id		1266808
xref_id		1266808
effect_dt		2004-07-14 00:00:00
migration_source		CLAIMS

Table: filername
xref_filer_id	1266808	1266808	1266808
filer_id	1266808	1266808	1266808
filer_type	RECIPIENT COMMITTEE	RECIPIENT COMMITTEE	RECIPIENT COMMITTEE
status	TERMINATED	TERMINATED	TERMINATED
effect_dt	2020-06-01 00:00:00	2020-06-01 00:00:00	2020-06-01 00:00:00
naml	CALIFORNIA ONCOLOGY POLITICAL ACTION COMMITTEE AKA CALCANCERPAC	CALIFORNIA ONCOLOGY POLITICAL ACTION COMMITTEE AKA CALCANCERPAC	CALIFORNIA ONCOLOGY POLITICAL ACTION COMMITTEE AKA CALCANCERPAC
namf	None	None	None
namt	None	None	None
nams	None	None	None
adr1	None	None	None
adr2	None	None	None
city	SACRAMENTO	SACRAMENTO	SACRAMENTO
st	CA	CA	CA
zip4	95814	95814	95814
phon	9164422280	9164422280	9164422280
fax	None	None	None
email	None	359900 - SSB	[email protected]

Table: filers
filer_id		1266808

Table: received_filings
filer_id	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808	1266808
filing_file_name	339385.cal	1070308_0.cal	1333221_0.cal	318123.cal	318405.cal	319000.cal	319091.cal	319352.cal	1334856_0.cal	10616.cal	10667.cal	10739.cal	1849100_0.cal	1836487_0.cal	1826602_0.cal	2044156_0.cal	353339.cal	353382.cal	2073705_0.cal	1945387_0.cal	2293027_0.cal
received_date	2005-01-05 00:00:00	2005-01-06 00:00:00	2008-05-19 00:00:00	2009-08-18 00:00:00	2009-08-18 00:00:00	2009-08-18 00:00:00	2009-08-18 00:00:00	2009-08-18 00:00:00	2008-05-22 00:00:00	2008-12-15 00:00:00	2008-12-15 00:00:00	2008-12-15 00:00:00	2014-05-12 00:00:00	2014-04-07 00:00:00	2014-03-07 00:00:00	2016-05-19 00:00:00	2016-07-05 00:00:00	2016-07-05 00:00:00	2016-09-02 00:00:00	2015-02-20 00:00:00	2018-09-18 00:00:00
filing_directory	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/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/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
filing_id	None	1070308	1333221	None	None	None	None	None	1334856	None	None	None	1849100	1836487	1826602	2044156	None	None	2073705	1945387	2293027
form_id	None	F410	F497	None	None	None	None	None	F497	None	None	None	F497	F497	F497	F497	None	None	F497	F497	F497
receive_comment	Filing did not pass validation	Filing accepted	Filing accepted	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing accepted	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing did not pass validation	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing accepted