Home

Filer ID: 1379198

Table: cvr_campaign_disclosure

filing_id		1998299		2036765		2036776		2028965		2017722		2020511		2021502		1998299		2013042		2015807		2042330		2028495		2013042		2001280		2000631		2000631		1992293		2002124		1999093		1999443		1990454		2052750		2083540		2064695		2084521		2072816		2067966		2084050		2073438		2070413		2067970		2054965		2051317		2036765		2064695		2073438		2084521		2091976		2097101		2175546		2130362		2130362		2110310		2097977		2130362		2130362		2138972		2099532		2099514		2064695		2097977		2103419		2083540		2103419		2211104		2302865		2292231		2312960		2296733		2276418		2418189		2347175		2395704		2459911		2440619		2459911		2482183		2550385		2506046		2505269		2520529		2621310		2672474		2598986		2640881		2725480		2711682		2729927		2704043		2742739		2751101
amend_id		0		0		0		0		0		0		0		1		1		0		0		0		0		0		1		0		0		0		0		0		0		0		0		1		0		0		0		0		1		0		0		0		0		1		0		0		1		0		0		0		2		3		0		1		0		1		0		0		0		2		0		0		1		1		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F460		F460		F497		F497		F497		F497		F497		F460		F460		F497		F497		F497		F460		F497		F497		F497		F497		F497		F497		F497		F497		F497		F460		F460		F497		F497		F497		F497		F497		F497		F497		F497		F497		F460		F460		F497		F497		F497		F497		F460		F460		F460		F497		F460		F460		F460		F497		F511		F497		F460		F460		F497		F460		F497		F460		F497		F497		F460		F460		F460		F460		F460		F460		F497		F460		F497		F460		F460		F497		F497		F460		F460		F460		F460		F460		F460		F497		F497		F460		F460		F497
filer_id		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198
entity_cd		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		BMC		RCP		BMC		BMC		BMC		BMC		BMC		BMC		BMC		None		BMC		BMC		BMC		BMC		BMC		BMC		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		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Californians Against the Misleading Rx Measure, sponsored by Pharmaceutical Research and Manufacturers of America		Californians Against the Misleading Rx Measure, sponsored by Pharmaceutical Research and Manufacturers of America		Californians Against the Misleading Rx Measure, sponsored by Pharmaceutical Research and Manufacturers of America		Californians Against the Misleading Rx Measure, sponsored by Pharmaceutical Research and Manufacturers of America		Californians Against the Misleading Rx Measure, sponsored by Pharmaceutical Research and Manufacturers of America		Californians Against the Misleading Rx Measure, sponsored by Pharmaceutical Research and Manufacturers of America		Californians Against the Misleading Rx Measure, sponsored by Pharmaceutical Research and Manufacturers of America		Californians Against the Misleading Rx Measure, sponsored by Pharmaceutical Research and Manufacturers of America		Californians Against the Misleading Rx Measure, sponsored by Pharmaceutical Research and Manufacturers of America		Californians Against the Misleading Rx Measure, sponsored by Pharmaceutical Research and Manufacturers of America		Californians Against the Misleading Rx Measure, sponsored by Pharmaceutical Research and Manufacturers of America		Californians Against the Misleading Rx Measure, sponsored by Pharmaceutical Research and Manufacturers of America		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Californians Against the Misleading Rx Measure, sponsored by Pharmaceutical Research and Manufacturers of America		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Californians Against the Misleading Rx Measure, sponsored by Pharmaceutical Research and Manufacturers of America		No on Prop 61 - Californians Against the Deceptive Rx Proposition, a coalition of veterans doctors patient advocates seniors taxpayers and members of Pharmaceutical Research and Manufacturers of Amer.		No on Prop 61 - Californians Against the Deceptive Rx Proposition, a coalition of veterans doctors patient advocates seniors taxpayers and members of Pharmaceutical Research and Manufacturers of Amer.		No on Prop 61 - Californians Against the Deceptive Rx Proposition, a coalition of veterans doctors patient advocates seniors taxpayers and members of Pharmaceutical Research and Manufacturers of Amer.		No on Prop 61 - Californians Against the Deceptive Rx Proposition, a coalition of veterans doctors patient advocates seniors taxpayers and members of Pharmaceutical Research and Manufacturers of Amer.		No on Prop 61 - Californians Against the Deceptive Rx Proposition, a coalition of veterans doctors patient advocates seniors taxpayers and members of Pharmaceutical Research and Manufacturers of Amer.		No on Prop 61 - Californians Against the Deceptive Rx Proposition, a coalition of veterans doctors patient advocates seniors taxpayers and members of Pharmaceutical Research and Manufacturers of Amer.		No on Prop 61 - Californians Against the Deceptive Rx Proposition, a coalition of veterans doctors patient advocates seniors taxpayers and members of Pharmaceutical Research and Manufacturers of Amer.		No on Prop 61 - Californians Against the Deceptive Rx Proposition, a coalition of veterans doctors patient advocates seniors taxpayers and members of Pharmaceutical Research and Manufacturers of Amer.		No on Prop 61 - Californians Against the Deceptive Rx Proposition, a coalition of veterans doctors patient advocates seniors taxpayers and members of Pharmaceutical Research and Manufacturers of Amer.		No on Prop 61 - Californians Against the Deceptive Rx Proposition, a coalition of veterans doctors patient advocates seniors taxpayers and members of Pharmaceutical Research and Manufacturers of Amer.		Californians Against the Misleading Rx Measure, sponsored by Pharmaceutical Research and Manufacturers of America		No on Prop 61 - Californians Against the Deceptive Rx Proposition, a coalition of veterans doctors patient advocates seniors taxpayers and members of Pharmaceutical Research and Manufacturers of Amer.		No on Prop 61 - Californians Against the Deceptive Rx Proposition, a coalition of veterans doctors patient advocates seniors taxpayers and members of Pharmaceutical Research and Manufacturers of Amer.		No on Prop 61 - Californians Against the Deceptive Rx Proposition, a coalition of veterans doctors patient advocates seniors taxpayers and members of Pharmaceutical Research and Manufacturers of Amer.		No on Prop 61 - Californians Against the Deceptive Rx Proposition, a coalition of veterans doctors patient advocates seniors taxpayers and members of Pharmaceutical Research and Manufacturers of Amer.		No on Prop 61 - Californians Against the Deceptive Rx Proposition, a coalition of veterans doctors patient advocates seniors taxpayers and members of Pharmaceutical Research and Manufacturers of Amer.		No on Prop 61 - Californians Against the Deceptive Rx Proposition, a coalition of veterans doctors patient advocates seniors taxpayers and members of Pharmaceutical Research and Manufacturers of Amer.		Pharmaceutical Research and Manufacturers of America California Initiative Fund		No on Prop 61 - Californians Against the Deceptive Rx Proposition, a coalition of veterans doctors patient advocates seniors taxpayers and members of Pharmaceutical Research and Manufacturers of Amer.		No on Prop 61 - Californians Against the Deceptive Rx Proposition, a coalition of veterans doctors patient advocates seniors taxpayers and members of Pharmaceutical Research and Manufacturers of Amer.		No on Prop 61 - Californians Against the Deceptive Rx Proposition, a coalition of veterans doctors patient advocates seniors taxpayers and members of Pharmaceutical Research and Manufacturers of Amer.		No on Prop 61 - Californians Against the Deceptive Rx Proposition, a coalition of veterans doctors patient advocates seniors taxpayers and members of Pharmaceutical Research and Manufacturers of Amer.		No on Prop 61 - Californians Against the Deceptive Rx Proposition, a coalition of veterans doctors patient advocates seniors taxpayers and members of Pharmaceutical Research and Manufacturers of Amer.		No on Prop 61 - Californians Against the Deceptive Rx Proposition, a coalition of veterans doctors patient advocates seniors taxpayers and members of Pharmaceutical Research and Manufacturers of Amer.		No on Prop 61 - Californians Against the Deceptive Rx Proposition, a coalition of veterans doctors patient advocates seniors taxpayers and members of Pharmaceutical Research and Manufacturers of Amer.		NO ON PROP 61 - CALIFORNIANS AGAINST THE DECEPTIVE RX PROPOSITION, A COALITION OF VETERANS DOCTORS PATIENT ADVOCATES SENIORS TAXPAYERS AND MEMBERS OF PHARMACEUTICAL RESEARCH AND MANUFACTURERS OF AMER.		No on Prop 61 - Californians Against the Deceptive Rx Proposition, a coalition of veterans doctors patient advocates seniors taxpayers and members of Pharmaceutical Research and Manufacturers of Amer.		No on Prop 61 - Californians Against the Deceptive Rx Proposition, a coalition of veterans doctors patient advocates seniors taxpayers and members of Pharmaceutical Research and Manufacturers of Amer.		No on Prop 61 - Californians Against the Deceptive Rx Proposition, a coalition of veterans doctors patient advocates seniors taxpayers and members of Pharmaceutical Research and Manufacturers of Amer.		No on Prop 61 - Californians Against the Deceptive Rx Proposition, a coalition of veterans doctors patient advocates seniors taxpayers and members of Pharmaceutical Research and Manufacturers of Amer.		No on Prop 61 - Californians Against the Deceptive Rx Proposition, a coalition of veterans doctors patient advocates seniors taxpayers and members of Pharmaceutical Research and Manufacturers of Amer.		No on Prop 61 - Californians Against the Deceptive Rx Proposition, a coalition of veterans doctors patient advocates seniors taxpayers and members of Pharmaceutical Research and Manufacturers of Amer.		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Pharmaceutical Research and Manufacturers of America California Initiative Fund - No on Proposition 10		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Pharmaceutical Research and Manufacturers of America California Initiative Fund - No on Proposition 10		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Pharmaceutical Research and Manufacturers of America California Initiative Fund
filer_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
report_num		000		000		000		000		000		000		000		001		001		000		000		000		000		000		001		000		000		000		000		000		000		000		000		001		000		000		000		000		001		000		000		000		000		001		000		000		001		000		000		000		002		003		000		001		000		001		000		000		000		002		000		000		001		001		000		000		000		000		000		000		000		000		000		000		000		001		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000
rpt_date		2015-11-02 00:00:00		2016-05-02 00:00:00		2016-04-29 00:00:00		2016-04-15 00:00:00		2016-02-26 00:00:00		2016-03-14 00:00:00		2016-03-18 00:00:00		2016-03-18 00:00:00		2016-03-18 00:00:00		2016-02-12 00:00:00		2016-05-12 00:00:00		2016-04-13 00:00:00		2016-02-01 00:00:00		2015-12-14 00:00:00		2016-01-27 00:00:00		2015-12-04 00:00:00		2015-10-16 00:00:00		2015-12-31 00:00:00		2015-11-06 00:00:00		2015-11-11 00:00:00		2015-10-02 00:00:00		2016-06-24 00:00:00		2016-09-29 00:00:00		2016-09-29 00:00:00		2016-10-03 00:00:00		2016-08-30 00:00:00		2016-08-12 00:00:00		2016-09-30 00:00:00		2016-09-19 00:00:00		2016-08-19 00:00:00		2016-08-11 00:00:00		2016-07-13 00:00:00		2016-06-13 00:00:00		2016-08-01 00:00:00		2016-08-01 00:00:00		2016-09-01 00:00:00		2016-10-19 00:00:00		2016-10-19 00:00:00		2016-10-26 00:00:00		2017-07-31 00:00:00		2017-03-15 00:00:00		2017-04-20 00:00:00		2016-12-08 00:00:00		2017-01-31 00:00:00		2017-01-31 00:00:00		2017-02-23 00:00:00		2017-02-17 00:00:00		2016-10-28 00:00:00		2016-10-28 00:00:00		2016-10-27 00:00:00		2016-10-27 00:00:00		2016-11-01 00:00:00		2016-09-27 00:00:00		2016-11-22 00:00:00		2018-01-31 00:00:00		2018-10-05 00:00:00		2018-09-14 00:00:00		2018-10-25 00:00:00		2018-09-27 00:00:00		2018-07-25 00:00:00		2019-10-31 00:00:00		2019-01-31 00:00:00		2019-07-31 00:00:00		2020-02-28 00:00:00		2020-01-31 00:00:00		2020-04-10 00:00:00		2020-07-21 00:00:00		2021-01-18 00:00:00		2020-09-25 00:00:00		2020-09-24 00:00:00		2020-10-17 00:00:00		2021-10-13 00:00:00		2022-04-26 00:00:00		2021-07-15 00:00:00		2022-01-19 00:00:00		2022-09-24 00:00:00		2022-08-16 00:00:00		2022-10-07 00:00:00		2022-07-23 00:00:00		2022-10-22 00:00:00		2022-11-02 00:00:00
stmt_type		QT		QT		None		None		None		None		None		QT		SA		None		None		None		SA		None		None		None		None		None		None		None		None		None		PE		SA		None		None		None		None		None		None		None		None		None		QT		SA		None		None		None		None		SA		SA		SA		None		PE		SA		SA		None		None		None		SA		PE		None		PE		None		PE		None		None		PE		PE		SA		SY		SA		SA		None		SA		None		PE		SA		None		None		PE		SY		PE		SA		QT		PE		None		None		SA		PE		None
late_rptno		None		None		179303-115		179303-114		179303-110		179303-111		179303-112		None		None		179303-109		179303-116		179303-113		None		179303-107		179303-106		179303-106		179303-103		179303-108		179303-104		179303-105		179303-02		179303-118		None		None		179303-127		179303-124		179303-121		179303-126		179303-125		179303-122		179303-120		179303-119		179303-117		None		None		179303-125		179303-127		179303-128		179303-131		None		None		None		179303-134		None		None		None		179303-135		None		179303-132		None		None		179303-133		None		179303-133		None		179303-138		179303-137		None		None		None		None		None		None		179303-139		None		179303-139		None		None		179303-141		179303-140		None		None		None		None		None		None		179303-142		179303-143		None		None		179303-144
from_date		2015-01-01 00:00:00		2016-01-01 00:00:00		None		None		None		None		None		2015-01-01 00:00:00		2015-10-01 00:00:00		None		None		None		2015-10-01 00:00:00		None		None		None		None		None		None		None		None		None		2016-07-01 00:00:00		2016-04-01 00:00:00		None		None		None		None		None		None		None		None		None		2016-01-01 00:00:00		2016-04-01 00:00:00		None		None		None		None		2017-01-01 00:00:00		2016-10-23 00:00:00		2016-10-23 00:00:00		None		2016-09-25 00:00:00		2016-10-23 00:00:00		2016-10-23 00:00:00		None		None		None		2016-04-01 00:00:00		2016-09-25 00:00:00		None		2016-07-01 00:00:00		None		2017-07-01 00:00:00		None		None		2018-09-23 00:00:00		2018-07-01 00:00:00		2018-01-01 00:00:00		2019-07-01 00:00:00		2018-10-21 00:00:00		2019-01-01 00:00:00		None		2019-10-01 00:00:00		None		2020-01-01 00:00:00		2020-10-18 00:00:00		None		None		2020-07-01 00:00:00		2021-07-01 00:00:00		2022-01-01 00:00:00		2021-01-01 00:00:00		2021-10-01 00:00:00		2022-07-01 00:00:00		None		None		2022-04-24 00:00:00		2022-09-25 00:00:00		None
thru_date		2015-09-30 00:00:00		2016-03-31 00:00:00		None		None		None		None		None		2015-09-30 00:00:00		2015-12-31 00:00:00		None		None		None		2015-12-31 00:00:00		None		None		None		None		None		None		None		None		None		2016-09-24 00:00:00		2016-06-30 00:00:00		None		None		None		None		None		None		None		None		None		2016-03-31 00:00:00		2016-06-30 00:00:00		None		None		None		None		2017-06-30 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		None		2016-10-22 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		None		None		None		2016-06-30 00:00:00		2016-10-22 00:00:00		None		2016-09-24 00:00:00		None		2017-12-31 00:00:00		None		None		2018-10-20 00:00:00		2018-09-22 00:00:00		2018-06-30 00:00:00		2019-09-30 00:00:00		2018-12-31 00:00:00		2019-06-30 00:00:00		None		2019-12-31 00:00:00		None		2020-06-30 00:00:00		2020-12-31 00:00:00		None		None		2020-10-17 00:00:00		2021-09-30 00:00:00		2022-04-23 00:00:00		2021-06-30 00:00:00		2021-12-31 00:00:00		2022-09-24 00:00:00		None		None		2022-06-30 00:00:00		2022-10-22 00:00:00		None
elect_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2016-11-08 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2016-11-08 00:00:00		None		None		None		None		None		None		2016-11-08 00:00:00		None		2016-11-08 00:00:00		None		None		None		None		2018-11-06 00:00:00		2018-11-06 00:00:00		None		None		None		None		None		None		None		None		None		None		None		2020-11-03 00:00:00		None		2022-06-07 00:00:00		None		None		2022-11-08 00:00:00		2022-06-07 00:00:00		2022-11-08 00:00:00		None		2022-11-08 00:00:00		2022-11-08 00:00:00
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		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento
filer_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
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		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814
filer_phon		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757
filer_fax		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		None		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759
file_email		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]
mail_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
mail_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
mail_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_naml		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		None		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		None		None		Hiltachk		Hiltachk		None
tres_namf		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		None		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		None		None		Thomas W.		Thomas W.		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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		None		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		None		None		Sacramento		Sacramento		None
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		None		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		None		None		CA		CA		None
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		None		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		None		None		95814		95814		None
tres_phon		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		None		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		None		None		(916) 442-7757		(916) 442-7757		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_email		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cmtte_type		B		B		None		None		None		None		None		B		B		None		None		None		B		None		None		None		None		None		None		None		None		None		B		B		None		None		None		None		None		None		None		None		None		B		B		None		None		None		None		G		B		B		None		B		B		B		None		None		None		B		B		None		B		None		G		None		None		P		G		G		G		P		G		None		G		None		G		G		None		None		G		G		G		G		G		G		None		None		G		G		None
control_yn		Y		Y		None		None		None		None		None		Y		Y		None		None		None		Y		None		None		None		None		None		None		None		None		None		Y		Y		None		None		None		None		None		None		None		None		None		Y		Y		None		None		None		None		Y		Y		Y		None		Y		Y		Y		None		None		None		Y		Y		None		Y		None		Y		None		None		None		Y		Y		Y		None		Y		None		Y		None		Y		Y		None		None		Y		Y		Y		Y		Y		Y		None		None		Y		Y		None
sponsor_yn		N		N		None		None		None		None		None		N		N		None		None		None		N		None		None		None		None		None		None		None		None		None		N		N		None		None		None		None		None		None		None		None		None		N		N		None		None		None		None		N		N		N		None		N		N		N		None		None		None		N		N		None		N		None		N		None		None		None		N		N		N		None		N		None		N		None		N		N		None		None		N		N		N		N		N		N		None		None		N		N		None
primfrm_yn		Y		Y		None		None		None		None		None		Y		Y		None		None		None		Y		None		None		None		None		None		None		None		None		None		Y		Y		None		None		None		None		None		None		None		None		None		Y		Y		None		None		None		None		N		Y		Y		None		Y		Y		Y		None		None		None		Y		Y		None		Y		None		N		None		None		None		N		N		N		None		N		None		N		None		N		N		None		None		N		N		N		N		N		N		None		None		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		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		Include additional accrued expense on Schedule F and corresponding sub-vendor on Schedule G.		Include additional accrued expenses on Schedule F and corresponding sub-vendors on Schedule G.		None		None		None		None		None		Adjust amount received for one contribution.		None		None		None		None		None		None		None		None		Include additional accrued expenses on Schedule F and corresponding sub-payments on Schedule G.		None		None		None		None		Adjust amount of non-monetary contribution.		None		None		None		None		Include additional accrued expenses on Schedule F and corresponding sub-payment on Schedule G.		None		None		Adjust amount of non-monetary contribution.		None		None		None		Include additional accrued expense on Schedule F and corresponding sub-payments on Schedule G.		Include additional accrued expense on Schedule F.		None		Include additional accrued expenses on Schedule F and corresponding sub-payments on Schedule G.		None		Include additional accrued expense on Schedule F.		None		None		None		Include additional accrued expenses on Schedule F and corresponding sub-payments on Schedule G.		None		None		Include additional accrued expenses on Schedule F and corresponding sub-payments on Schedule G.		Adjust amount of non-monetary contribution.		None		None		None		None		None		None		None		None		None		None		None		Amend to include contributions received.		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
amendexp_2		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
amendexp_3		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rpt_att_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cmtte_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
reportname		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rptfromdt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rptthrudt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
emplbus_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_name		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_inter		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
busact_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
busactvity		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
assoc_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
assoc_int		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
other_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
other_int		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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		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		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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		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		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		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		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_email		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_name		State Prescription Drug Purchases, AG 15-0009		State Prescription Drug Purchases, AG 15-0009		None		None		None		None		None		State Prescription Drug Purchases, AG 15-0009		State Prescription Drug Purchases, AG 15-0009		None		None		None		State Prescription Drug Purchases, AG 15-0009		None		None		None		None		None		None		None		None		None		Proposition 61		Proposition 61		None		None		None		None		None		None		None		None		None		Proposition 61		Proposition 61		None		None		None		None		None		Proposition 61		Proposition 61		None		Proposition 61		Proposition 61		Proposition 61		None		None		None		Proposition 61		Proposition 61		None		Proposition 61		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_num		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_juris		Statewide		Statewide		None		None		None		None		None		Statewide		Statewide		None		None		None		Statewide		None		None		None		None		None		None		None		None		None		Statewide		Statewide		None		None		None		None		None		None		None		None		None		Statewide		Statewide		None		None		None		None		None		Statewide		Statewide		None		Statewide		Statewide		Statewide		None		None		None		Statewide		Statewide		None		Statewide		None		None		None		None		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		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		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		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		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		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sup_opp_cd		O		O		None		None		None		None		None		O		O		None		None		None		O		None		None		None		None		None		None		None		None		None		O		O		None		None		None		None		None		None		None		None		None		O		O		None		None		None		None		None		O		O		None		O		O		O		None		None		None		O		O		None		O		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
employer		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
occupation		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
selfemp_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: cvr_so

filing_id		1986876		1986876		1986876		1986876		1986876		1986876		1986876		1986876		1986876		1986876
amend_id		0		2		1		3		5		4		6		7		8		9
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F410		F410		F410		F410		F410		F410		F410		F410		F410		F410
filer_id		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198
entity_cd		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP
filer_naml		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Californians Against the Misleading Rx Measure, sponsored by Pharmaceutical Research and Manufacturers of America		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Californians Against the Misleading Rx Measure, sponsored by Pharmaceutical Research and Manufacturers of America		No on Prop 61 - Californians Against the Deceptive Rx Proposition, a coalition of veterans doctors patient advocates seniors taxpayers and members of Pharmaceutical Research and Manufacturers of Amer.		No on Prop 61 - Californians Against the Deceptive Rx Proposition, a coalition of veterans doctors patient advocates seniors taxpayers and members of Pharmaceutical Research and Manufacturers of Amer.		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Pharmaceutical Research and Manufacturers of America California Initiative Fund - No on Proposition 10		Pharmaceutical Research and Manufacturers of America California Initiative Fund		Pharmaceutical Research and Manufacturers of America California Initiative Fund
filer_namf		None		None		None		None		None		None		None		None		None		None
filer_namt		None		None		None		None		None		None		None		None		None		None
filer_nams		None		None		None		None		None		None		None		None		None		None
report_num		000		002		001		003		005		004		006		007		008		009
rpt_date		2015-08-24 00:00:00		2016-01-21 00:00:00		2015-09-28 00:00:00		2016-06-08 00:00:00		2016-08-04 00:00:00		2016-07-08 00:00:00		2017-06-06 00:00:00		2018-10-17 00:00:00		2019-01-31 00:00:00		2021-08-26 00:00:00
qual_cb		None		X		X		X		X		X		X		X		X		X
qualfy_dt		None		2015-09-22 00:00:00		2015-09-22 00:00:00		2015-09-22 00:00:00		2015-09-22 00:00:00		2015-09-22 00:00:00		2015-09-22 00:00:00		2015-09-22 00:00:00		2015-09-22 00:00:00		2015-09-22 00:00:00
term_date		None		None		None		None		None		None		None		None		None		None
city		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento
st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814
phone		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757
county_res		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento
county_act		Statewide		Statewide		Statewide		Statewide		Statewide		Statewide		Statewide		Statewide		Statewide		Statewide
mail_city		None		None		None		None		None		None		None		None		None		None
mail_st		None		None		None		None		None		None		None		None		None		None
mail_zip4		None		None		None		None		None		None		None		None		None		None
cmte_fax		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759		(916) 442-7759
cmte_email		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]
tres_naml		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk		Hiltachk
tres_namf		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.		Thomas W.
tres_namt		None		None		None		None		None		None		None		None		None		None
tres_nams		None		None		None		None		None		None		None		None		None		None
tres_city		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento
tres_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
tres_zip4		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814
tres_phon		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757		(916) 442-7757
actvty_lvl		None		None		None		None		None		None		ST		None		ST		ST
com82013yn		None		None		None		None		None		None		None		None		None		None
com82013nm		None		None		None		None		None		None		None		None		None		None
com82013id		None		None		None		None		None		None		None		None		None		None
control_cb		None		None		None		None		None		None		None		None		None		None
bank_nam		California Bank & Trust		California Bank & Trust		California Bank & Trust		California Bank & Trust		California Bank & Trust		California Bank & Trust		California Bank & Trust		California Bank & Trust		California Bank & Trust		California Bank & Trust
bank_adr1		550 South Hope Street, Suite 100		550 South Hope Street, Suite 100		550 South Hope Street, Suite 100		550 South Hope Street, Suite 100		550 South Hope Street, Suite 100		550 South Hope Street, Suite 100		550 South Hope Street, Suite 100		550 South Hope Street, Suite 100		550 South Hope Street, Suite 100		550 South Hope Street, Suite 100
bank_adr2		None		None		None		None		None		None		None		None		None		None
bank_city		Los Angeles		Los Angeles		Los Angeles		Los Angeles		Los Angeles		Los Angeles		Los Angeles		Los Angeles		Los Angeles		Los Angeles
bank_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
bank_zip4		90071		90071		90071		90071		90071		90071		90071		90071		90071		90071
bank_phon		(213) 228-1700		(213) 228-1700		(213) 228-1700		(213) 228-1700		(213) 228-1700		(213) 228-1700		(213) 228-1700		(213) 228-1700		(213) 228-1700		(213) 228-1700
acct_opendt		None		None		None		None		None		None		None		None		None		None
surplusdsp		None		None		None		None		None		None		None		None		None		None
primfc_cb		X		X		X		X		X		X		None		X		None		None
genpurp_cb		None		None		None		None		None		None		X		None		X		X
gpc_descr		None		None		None		None		None		None		Support or oppose state or local measures.		None		Support or oppose state or local measures.		Support or oppose state or local measures.
sponsor_cb		X		X		X		X		X		X		X		X		X		X
brdbase_cb		None		None		None		None		None		None		None		None		None		None
smcont_qualdt		None		None		None		None		None		None		None		None		None		None

Table: filer_address

filer_id		1379198
adrid		2371828
effect_dt		2015-08-14 00:00:00
add_type		7051
session_id		2015

Table: filer_filings

filer_id		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198
filing_id		1992293		1986876		1998557		1998299		2002124		1986876		1990454		1990562		2001280		2000631		1985875		2211104		2308714		2370427		2277455		2347175		2312960		2321779		2446055		2013042		2017722		2015807		2009179		2021502		2020511		2000631		1999093		1999443		1986876		1998299		2013042		2023710		2042330		2042488		2028965		2023710		2036765		2036776		1998557		2028495		2036765		2052750		1986876		1986876		2055107		2054965		2051317		2064695		2067970		2051157		1986876		2067855		2073438		2084521		2064695		2072816		2067966		2073438		2075882		2083540		2084050		2070413		2064695		2099514		2099532		2103419		2097977		2084521		2091976		2097101		2094355		2083540		2075882		2103419		2108866		2075882		2110310		2094355		2130362		2042488		2097977		2130362		2138972		2147274		2147274		2175546		2178168		2130362		2130362		2147274		2108866		2162842		2147274		1986876		2217314		2292231		2440619		2384492		2418189		2358612		2574013		2296733		2298155		2276418		2395704		2550385		2459911		2520529		2401173		2534093		2302865		1986876		2488458		1986876		2672474		2459911		2421725		2506046		2505269		2482183		2711682		2626561		2680343		2621310		2598986		2618003		2640881		2609760		1986876		2704043		2657031		2743026		2725480		2729927		2726927		2751101		2742739
period_id		224		223		None		221		224		223		224		None		224		224		None		231		None		None		None		236		235		None		None		224		225		225		None		225		225		225		224		224		225		221		224		None		226		None		226		None		225		226		None		226		225		226		226		227		None		227		226		226		227		None		227		None		227		228		226		227		227		227		None		227		227		227		226		228		None		228		227		228		228		228		None		227		None		228		None		None		228		None		228		None		227		228		229		None		None		229		None		228		228		None		None		None		None		230		None		235		240		None		239		None		None		235		None		233		237		244		241		243		None		None		236		237		None		236		249		242		None		243		243		241		251		None		None		247		245		None		248		None		247		250		None		None		251		252		None		252		251
form_id		F497		F410		F460		F460		F497		F410		F497		F410		F497		F497		F410		F460		F410		F410		F460		F460		F460		F460		F460		F460		F497		F497		F410		F497		F497		F497		F497		F497		F410		F460		F460		F460		F497		F460		F497		F460		F460		F497		F460		F497		F460		F497		F410		F410		F410		F497		F497		F460		F497		F410		F410		F410		F497		F497		F460		F497		F497		F497		F460		F460		F497		F497		F460		F497		F511		F497		F460		F497		F497		F497		F460		F460		F460		F497		F460		F460		F497		F460		F460		F460		F460		F460		F497		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F410		F460		F497		F460		F666		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F497		F410		F460		F410		F460		F497		F460		F497		F497		F460		F497		F460		F460		F460		F460		F460		F460		F410		F410		F460		F460		F460		F460		F497		F460		F497		F460
filing_sequence		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		1		0		0		2		1		1		0		0		0		0		1		0		0		1		0		1		0		3		4		0		0		0		0		0		0		5		0		0		0		1		0		0		1		0		0		0		0		2		0		0		0		0		1		0		0		0		1		2		1		0		1		0		1		3		1		1		0		0		0		1		0		0		1		2		3		2		0		2		6		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		8		0		7		0		1		0		0		0		0		0		0		0		0		0		0		0		0		9		0		0		0		0		0		0		0		0
filing_date		2015-10-16 00:00:00		2015-09-29 00:00:00		2015-11-02 00:00:00		2015-11-02 00:00:00		2015-12-31 00:00:00		2015-08-24 00:00:00		2015-10-02 00:00:00		2015-09-29 00:00:00		2015-12-14 00:00:00		2015-12-04 00:00:00		2015-08-14 00:00:00		2018-01-31 00:00:00		2018-10-17 00:00:00		2019-01-31 00:00:00		2018-07-31 00:00:00		2019-01-31 00:00:00		2018-10-25 00:00:00		2018-10-25 00:00:00		2020-01-30 00:00:00		2016-02-01 00:00:00		2016-02-26 00:00:00		2016-02-12 00:00:00		2016-01-22 00:00:00		2016-03-18 00:00:00		2016-03-14 00:00:00		2016-01-28 00:00:00		2015-11-06 00:00:00		2015-11-11 00:00:00		2016-01-22 00:00:00		2016-03-21 00:00:00		2016-03-21 00:00:00		2016-02-01 00:00:00		2016-05-12 00:00:00		2016-05-02 00:00:00		2016-04-15 00:00:00		2016-03-21 00:00:00		2016-04-29 00:00:00		2016-04-29 00:00:00		2016-03-21 00:00:00		2016-04-14 00:00:00		2016-08-01 00:00:00		2016-06-24 00:00:00		2016-06-09 00:00:00		2016-07-08 00:00:00		2016-07-08 00:00:00		2016-07-13 00:00:00		2016-06-13 00:00:00		2016-08-01 00:00:00		2016-08-12 00:00:00		2016-06-09 00:00:00		2016-08-11 00:00:00		2016-08-11 00:00:00		2016-09-01 00:00:00		2016-10-03 00:00:00		2016-09-29 00:00:00		2016-08-30 00:00:00		2016-08-12 00:00:00		2016-09-19 00:00:00		2016-08-01 00:00:00		2016-09-29 00:00:00		2016-09-30 00:00:00		2016-08-19 00:00:00		2016-10-27 00:00:00		2016-10-28 00:00:00		2016-10-28 00:00:00		2016-11-01 00:00:00		2016-10-27 00:00:00		2016-10-19 00:00:00		2016-10-19 00:00:00		2016-10-26 00:00:00		2016-09-29 00:00:00		2016-10-27 00:00:00		2016-10-27 00:00:00		2016-11-22 00:00:00		2016-10-27 00:00:00		2016-09-29 00:00:00		2016-12-09 00:00:00		2016-10-27 00:00:00		2017-04-26 00:00:00		2016-08-01 00:00:00		2017-01-31 00:00:00		2017-01-31 00:00:00		2017-02-17 00:00:00		2017-01-31 00:00:00		2017-02-24 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00		2017-02-24 00:00:00		2017-03-22 00:00:00		2017-04-26 00:00:00		2017-01-31 00:00:00		2017-06-07 00:00:00		2017-03-22 00:00:00		2017-06-07 00:00:00		2018-01-31 00:00:00		2018-09-14 00:00:00		2020-01-30 00:00:00		2019-03-29 00:00:00		2019-10-30 00:00:00		2019-01-31 00:00:00		2021-01-29 00:00:00		2018-09-27 00:00:00		2018-09-27 00:00:00		2018-07-31 00:00:00		2019-07-29 00:00:00		2021-01-29 00:00:00		2020-02-28 00:00:00		2020-10-22 00:00:00		2019-07-31 00:00:00		2020-10-22 00:00:00		2018-10-05 00:00:00		2019-01-31 00:00:00		2020-07-31 00:00:00		2018-10-17 00:00:00		2022-04-28 00:00:00		2020-04-10 00:00:00		2019-10-30 00:00:00		2020-09-25 00:00:00		2020-09-24 00:00:00		2020-07-28 00:00:00		2022-08-16 00:00:00		2021-10-29 00:00:00		2022-04-28 00:00:00		2021-10-28 00:00:00		2021-07-29 00:00:00		2021-07-30 00:00:00		2022-01-28 00:00:00		2021-08-30 00:00:00		2021-08-27 00:00:00		2022-07-29 00:00:00		2022-01-28 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-10-07 00:00:00		2022-07-29 00:00:00		2022-11-02 00:00:00		2022-10-27 00:00:00
stmnt_type		10001		10002		10005		10001		10001		10001		10001		10006		10001		10001		10005		10001		10006		10006		10005		10001		10001		10005		10005		10001		10001		10001		10006		10001		10001		10002		10001		10001		10002		10002		10002		10005		10001		10005		10001		10006		10001		10001		10006		10001		10002		10001		10002		10002		10006		10001		10001		10001		10001		10006		10002		10006		10001		10001		10002		10001		10001		10002		10005		10001		10001		10001		10002		10001		10001		10001		10001		10002		10001		10001		10005		10002		10006		10002		10005		10006		10001		10006		10002		10006		10002		10001		10001		10005		10006		10001		10005		10002		10002		10006		10006		10006		10006		10002		10005		10001		10001		10005		10001		10005		10005		10001		10005		10001		10001		10001		10001		10001		10005		10005		10001		10002		10005		10002		10001		10002		10005		10001		10001		10001		10001		10005		10005		10001		10001		10005		10001		10006		10002		10001		10005		10005		10001		10001		10005		10001		10001
stmnt_status		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11003		11001		11003		11003		11003		11003		11001		11001		11001		11003		11001		11001		11003		11003		11003		11003		11001		11003		11003		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11003		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003
session_id		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2019		2017		2017		2017		2017		2019		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2015		2015		2017		2017		2015		2015		2015		2015		2017		2015		2017		2017		2017		2019		2015		2019		2017		2021		2017		2017		2017		2019		2019		2019		2019		2019		2019		2017		2019		2019		2017		2021		2019		2019		2019		2019		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		CREYNOLDS		TRAMON		MDIGRAZIA		MDIGRAZIA		CREYNOLDS		CAFILER		CREYNOLDS		TRAMON		CREYNOLDS		CREYNOLDS		DWALKER		HSTOVALL		TRAMON		TRAMON		SARRIAGA		BCOLON		HSTOVALL		HSTOVALL		VUKSTINA		MDIGRAZIA		CREYNOLDS		CREYNOLDS		TRAMON		CREYNOLDS		CREYNOLDS		CREYNOLDS		CREYNOLDS		CREYNOLDS		TRAMON		MDIGRAZIA		CAFILER		MDIGRAZIA		CREYNOLDS		MDIGRAZIA		CREYNOLDS		LPALMER		MDIGRAZIA		CREYNOLDS		LPALMER		CREYNOLDS		CAFILER		RGEREMIA		DHOANG		TRAMON		TRAMON		RGEREMIA		RGEREMIA		SARRIAGA		GKURIMOT		DHOANG		TRAMON		TRAMON		GKURIMOT		GKURIMOT		CAFILER		GKURIMOT		RGEREMIA		GKURIMOT		SARRIAGA		SARRIAGA		GKURIMOT		RGEREMIA		CAFILER		GKURIMOT		*		GKURIMOT		HSTOVALL		GKURIMOT		GKURIMOT		GKURIMOT		SARRIAGA		CAFILER		MPACHECO		GKURIMOT		HSTOVALL		MPACHECO		PDEO		MPACHECO		CAFILER		MPACHECO		CAFILER		SARRIAGA		PBANFORD		SARRIAGA		MPACHECO		LBARTHOL		LBARTHOL		CAFILER		CAFILER		SMCCONNAN		DMCCASTL		LPALMER		SMCCONNAN		CAFILER		HSTOVALL		CAFILER		VUKSTINA		AROJAS		LPHEAV		BCOLON		AXIONG		MXIONG		MXIONG		SARRIAGA		BCOLON		AXIONG		CAFILER		IMEDINA		BCOLON		IMEDINA		CAFILER		TRAMON		IMEDINA		TRAMON		KRUSSELL		CAFILER		LPHEAV		CAFILER		CAFILER		IMEDINA		CAFILER		KRUSSELL		KRUSSELL		KRUSSELL		DCODY		DCODY		KRUSSELL		IMEDINA		CAFILER		CAFILER		KRUSSELL		LPHEAV		CAFILER		CAFILER		JMAVES		CAFILER		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
fine_audit		11001		11003		11001		11001		11001		11003		11001		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		11003		11003		11001		11001		11001		11001		11003		11001		11001		11003		11001		11003		11001		11003		11003		11003		11001		11001		11003		11001		11003		11003		11003		11001		11001		11003		11001		11001		11001		11003		11003		11001		11001		11003		11001		11003		11001		11003		11001		11001		11001		11003		11003		11003		11001		11003		11003		11001		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
rpt_start		2015-10-16 00:00:00		2015-09-28 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-12-31 00:00:00		2015-08-24 00:00:00		2015-10-02 00:00:00		None		2015-12-14 00:00:00		2015-12-04 00:00:00		None		2017-07-01 00:00:00		None		None		2018-01-01 00:00:00		2018-10-21 00:00:00		2018-09-23 00:00:00		2018-09-23 00:00:00		2019-10-01 00:00:00		2015-10-01 00:00:00		2016-02-26 00:00:00		2016-02-12 00:00:00		None		2016-03-18 00:00:00		2016-03-14 00:00:00		2016-01-27 00:00:00		2015-11-06 00:00:00		2015-11-11 00:00:00		2016-01-21 00:00:00		2015-01-01 00:00:00		2015-10-01 00:00:00		2015-10-01 00:00:00		2016-05-12 00:00:00		2016-01-01 00:00:00		2016-04-15 00:00:00		2015-10-01 00:00:00		2016-01-01 00:00:00		2016-04-29 00:00:00		2015-01-01 00:00:00		2016-04-13 00:00:00		2016-01-01 00:00:00		2016-06-24 00:00:00		2016-06-08 00:00:00		2016-07-08 00:00:00		None		2016-07-13 00:00:00		2016-06-13 00:00:00		2016-04-01 00:00:00		2016-08-11 00:00:00		None		2016-08-04 00:00:00		None		2016-09-01 00:00:00		2016-10-03 00:00:00		2016-04-01 00:00:00		2016-08-30 00:00:00		2016-08-12 00:00:00		2016-09-19 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		2016-09-30 00:00:00		2016-08-19 00:00:00		2016-04-01 00:00:00		2016-10-28 00:00:00		None		2016-11-01 00:00:00		2016-09-25 00:00:00		2016-10-19 00:00:00		2016-10-19 00:00:00		2016-10-26 00:00:00		2016-07-01 00:00:00		2016-07-01 00:00:00		2016-04-01 00:00:00		2016-11-22 00:00:00		2016-09-25 00:00:00		2016-04-01 00:00:00		2016-12-08 00:00:00		2016-07-01 00:00:00		2016-10-23 00:00:00		2016-01-01 00:00:00		2016-09-25 00:00:00		2016-10-23 00:00:00		2017-02-17 00:00:00		2016-10-23 00:00:00		2016-10-23 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2016-10-23 00:00:00		2016-10-23 00:00:00		2016-10-23 00:00:00		2016-09-25 00:00:00		None		2016-10-23 00:00:00		2017-06-06 00:00:00		2017-07-01 00:00:00		2018-09-14 00:00:00		2019-10-01 00:00:00		2015-01-01 00:00:00		2019-07-01 00:00:00		2018-10-21 00:00:00		2020-10-18 00:00:00		2018-07-01 00:00:00		2018-07-01 00:00:00		2018-01-01 00:00:00		2019-01-01 00:00:00		2020-10-18 00:00:00		2020-02-28 00:00:00		2020-07-01 00:00:00		2019-01-01 00:00:00		2020-07-01 00:00:00		2018-10-05 00:00:00		2019-01-31 00:00:00		2020-01-01 00:00:00		2018-10-17 00:00:00		2022-01-01 00:00:00		2020-04-10 00:00:00		2019-07-01 00:00:00		2020-09-25 00:00:00		2020-09-24 00:00:00		2020-01-01 00:00:00		2022-08-16 00:00:00		2021-07-01 00:00:00		2022-01-01 00:00:00		2021-07-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-10-01 00:00:00		None		2021-08-26 00:00:00		2022-04-24 00:00:00		2021-10-01 00:00:00		2022-07-01 00:00:00		2022-07-01 00:00:00		2022-10-07 00:00:00		2022-04-24 00:00:00		2022-11-02 00:00:00		2022-09-25 00:00:00
rpt_end		2015-10-16 00:00:00		2015-09-28 00:00:00		2015-09-30 00:00:00		2015-09-30 00:00:00		2015-12-31 00:00:00		2015-08-24 00:00:00		2015-10-02 00:00:00		None		2015-12-14 00:00:00		2015-12-04 00:00:00		None		2017-12-31 00:00:00		None		None		2018-06-30 00:00:00		2018-12-31 00:00:00		2018-10-20 00:00:00		2018-10-20 00:00:00		2019-12-31 00:00:00		2015-12-31 00:00:00		2016-02-26 00:00:00		2016-02-12 00:00:00		None		2016-03-18 00:00:00		2016-03-14 00:00:00		2016-01-27 00:00:00		2015-11-06 00:00:00		2015-11-11 00:00:00		2016-01-21 00:00:00		2015-09-30 00:00:00		2015-12-31 00:00:00		2015-12-31 00:00:00		2016-05-12 00:00:00		2016-03-31 00:00:00		2016-04-15 00:00:00		2015-12-31 00:00:00		2016-03-31 00:00:00		2016-04-29 00:00:00		2015-09-30 00:00:00		2016-04-13 00:00:00		2016-03-31 00:00:00		2016-06-24 00:00:00		2016-06-08 00:00:00		2016-07-08 00:00:00		None		2016-07-13 00:00:00		2016-06-13 00:00:00		2016-06-30 00:00:00		2016-08-11 00:00:00		None		2016-08-04 00:00:00		None		2016-09-01 00:00:00		2016-10-03 00:00:00		2016-06-30 00:00:00		2016-08-30 00:00:00		2016-08-12 00:00:00		2016-09-19 00:00:00		2016-06-30 00:00:00		2016-09-24 00:00:00		2016-09-30 00:00:00		2016-08-19 00:00:00		2016-06-30 00:00:00		2016-10-28 00:00:00		None		2016-11-01 00:00:00		2016-10-22 00:00:00		2016-10-19 00:00:00		2016-10-19 00:00:00		2016-10-26 00:00:00		2016-09-24 00:00:00		2016-09-24 00:00:00		2016-06-30 00:00:00		2016-11-22 00:00:00		2016-10-22 00:00:00		2016-06-30 00:00:00		2016-12-08 00:00:00		2016-09-24 00:00:00		2016-12-31 00:00:00		2016-03-31 00:00:00		2016-10-22 00:00:00		2016-12-31 00:00:00		2017-02-17 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		2016-12-31 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		2016-10-22 00:00:00		None		2016-12-31 00:00:00		2017-06-06 00:00:00		2017-12-31 00:00:00		2018-09-14 00:00:00		2019-12-31 00:00:00		2016-12-31 00:00:00		2019-09-30 00:00:00		2018-12-31 00:00:00		2020-12-31 00:00:00		2018-09-22 00:00:00		2018-09-22 00:00:00		2018-06-30 00:00:00		2019-06-30 00:00:00		2020-12-31 00:00:00		2020-02-28 00:00:00		2020-10-17 00:00:00		2019-06-30 00:00:00		2020-10-17 00:00:00		2018-10-05 00:00:00		2019-01-31 00:00:00		2020-06-30 00:00:00		2018-10-17 00:00:00		2022-04-23 00:00:00		2020-04-10 00:00:00		2019-09-30 00:00:00		2020-09-25 00:00:00		2020-09-24 00:00:00		2020-06-30 00:00:00		2022-08-16 00:00:00		2021-09-30 00:00:00		2022-04-23 00:00:00		2021-09-30 00:00:00		2021-06-30 00:00:00		2021-06-30 00:00:00		2021-12-31 00:00:00		None		2021-08-26 00:00:00		2022-06-30 00:00:00		2021-12-31 00:00:00		2022-09-24 00:00:00		2022-09-24 00:00:00		2022-10-07 00:00:00		2022-06-30 00:00:00		2022-11-02 00:00:00		2022-10-22 00:00:00
rpt_date		2015-10-16 00:00:00		None		None		2015-11-02 00:00:00		2015-12-31 00:00:00		None		2015-10-02 00:00:00		None		2015-12-14 00:00:00		2015-12-04 00:00:00		None		2018-01-31 00:00:00		None		None		None		2019-01-31 00:00:00		2018-10-25 00:00:00		None		None		2016-02-01 00:00:00		2016-02-26 00:00:00		2016-02-12 00:00:00		None		2016-03-18 00:00:00		2016-03-14 00:00:00		2016-01-27 00:00:00		2015-11-06 00:00:00		2015-11-11 00:00:00		None		2016-03-18 00:00:00		2016-03-18 00:00:00		None		2016-05-12 00:00:00		None		2016-04-15 00:00:00		None		2016-05-02 00:00:00		2016-04-29 00:00:00		None		2016-04-13 00:00:00		2016-08-01 00:00:00		2016-06-24 00:00:00		None		None		None		2016-07-13 00:00:00		2016-06-13 00:00:00		2016-08-01 00:00:00		2016-08-11 00:00:00		None		None		None		2016-09-01 00:00:00		2016-10-03 00:00:00		2016-09-29 00:00:00		2016-08-30 00:00:00		2016-08-12 00:00:00		2016-09-19 00:00:00		None		2016-09-29 00:00:00		2016-09-30 00:00:00		2016-08-19 00:00:00		2016-10-27 00:00:00		2016-10-28 00:00:00		None		2016-11-01 00:00:00		2016-10-27 00:00:00		2016-10-19 00:00:00		2016-10-19 00:00:00		2016-10-26 00:00:00		None		2016-09-27 00:00:00		None		2016-11-22 00:00:00		None		None		2016-12-08 00:00:00		None		2017-04-20 00:00:00		None		2017-01-31 00:00:00		2017-01-31 00:00:00		2017-02-17 00:00:00		None		None		2017-07-31 00:00:00		None		2017-02-23 00:00:00		2017-03-15 00:00:00		None		None		None		None		None		None		2018-09-14 00:00:00		2020-01-31 00:00:00		None		2019-10-31 00:00:00		None		None		2018-09-27 00:00:00		None		2018-07-25 00:00:00		2019-07-31 00:00:00		2021-01-18 00:00:00		2020-02-28 00:00:00		2020-10-17 00:00:00		None		None		2018-10-05 00:00:00		None		None		None		2022-04-26 00:00:00		2020-04-10 00:00:00		None		2020-09-25 00:00:00		2020-09-24 00:00:00		2020-07-21 00:00:00		2022-08-16 00:00:00		None		None		2021-10-13 00:00:00		2021-07-15 00:00:00		None		2022-01-19 00:00:00		None		None		2022-07-23 00:00:00		None		None		2022-09-24 00:00:00		2022-10-07 00:00:00		None		2022-11-02 00:00:00		2022-10-22 00:00:00
filing_type		22001		22001		None		22001		22001		22001		22001		None		22001		22001		None		22001		None		None		None		22001		22001		None		None		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		None		22001		None		22001		22001		None		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		None		22001		None		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22006		22001		22001		22001		22001		22001		None		22001		None		22001		None		None		22001		None		22001		None		22001		22001		22001		None		None		22001		None		22001		22001		None		None		None		None		22001		None		22001		22001		None		22001		None		None		22001		None		22001		22001		22001		22001		22001		None		None		22001		22001		None		22001		22001		22001		None		22001		22001		22001		22001		None		None		22001		22001		None		22001		None		22001		22001		None		None		22001		22001		None		22001		22001

Table: filer_to_filer_type

filer_id		1379198		1379198		1379198		1379198		1379198
filer_type		16		16		16		16		16
active		Y		Y		Y		Y		Y
race		0		0		0		0		0
session_id		2017		2019		2015		2015		2017
category		0		0		0		0		0
category_type		40502		40502		40502		40502		40502
sub_category		40103		40103		40101		40101		40101
effect_dt		2017-06-07 00:00:00		2019-01-31 00:00:00		2015-09-29 00:00:00		2015-08-14 00:00:00		2018-10-17 00:00:00
sub_category_type		0		0		0		0		0
election_type		0		0		0		0		0
sub_category_a		S		S		S		S		S
nyq_dt		2015-09-22 00:00:00		2015-09-22 00:00:00		2015-09-22 00:00:00		None		2015-09-22 00:00:00
party_cd		0		0		0		0		0
county_cd		18004		18004		18004		18004		18004
district_cd		0		0		0		0		0

Table: filer_xref

filer_id		1379198
xref_id		1379198
effect_dt		2015-08-14 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1379198		1379198		1379198		1379198		1379198		1379198
filer_id		1379198		1379198		1379198		1379198		1379198		1379198
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		2019-01-31 00:00:00		2019-01-31 00:00:00		2019-01-31 00:00:00		2019-01-31 00:00:00		2019-01-31 00:00:00		2019-01-31 00:00:00
naml		PHARMACEUTICAL RESEARCH AND MANUFACTURERS OF AMERICA CALIFORNIA INITIATIVE FUND		PHARMACEUTICAL RESEARCH AND MANUFACTURERS OF AMERICA CALIFORNIA INITIATIVE FUND - NO ON PROPOSITION 10		PHARMACEUTICAL RESEARCH AND MANUFACTURERS OF AMERICA CALIFORNIA INITIATIVE FUND		NO ON PROP 61 - CALIFORNIANS AGAINST THE DECEPTIVE RX PROPOSITION, A COALITION OF VETERANS DOCTORS PATIENT ADVOCATES SENIORS TAXPAYERS AND MEMBERS OF PHARMACEUTICAL RESEARCH AND MANUFACTURERS OF AMER.		CALIFORNIANS AGAINST THE MISLEADING RX MEASURE, SPONSORED BY PHARMACEUTICAL RESEARCH AND MANUFACTURERS OF AMERICA		PHARMACEUTICAL RESEARCH AND MANUFACTURERS OF AMERICA CALIFORNIA INITIATIVE FUND
namf		None		None		None		None		None		None
namt		None		None		None		None		None		None
nams		None		None		None		None		None		None
adr1		None		None		None		None		None		None
adr2		None		None		None		None		None		None
city		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO
st		CA		CA		CA		CA		CA		CA
zip4		95814		95814		95814		95814		95814		95814
phon		9164427757		9164427757		9164427757		9164427757		9164427757		9164427757
fax		9164427759		9164427759		9164427759		9164427759		9164427759		9164427759
email		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]

Table: filers

filer_id		1379198

Table: received_filings

filer_id		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198		1379198
filing_file_name		1990454_0.cal		2138972_0.cal		2054965_0.cal		2051317_0.cal		2001280_0.cal		1999093_0.cal		2002124_0.cal		1999443_0.cal		1992293_0.cal		2000631_0.cal		2000631_1.cal		2110310_0.cal		2103419_0.cal		2103419_1.cal		2097101_0.cal		2084050_0.cal		2073438_1.cal		2020511_0.cal		2028965_0.cal		2017722_0.cal		2015807_0.cal		2028495_0.cal		2021502_0.cal		2084521_1.cal		2091976_0.cal		2099514_0.cal		2084521_0.cal		2067970_0.cal		51112.cal		2073438_0.cal		2070413_0.cal		2072816_0.cal		2067966_0.cal		2042330_0.cal		2036776_0.cal		2052750_0.cal		182075.cal		2292231_0.cal		2459911_0.cal		2459911_1.cal		2302865_0.cal		2751101_0.cal		2711682_0.cal		2729927_0.cal		2506046_0.cal		2505269_0.cal
received_date		2015-10-02 00:00:00		2017-02-17 00:00:00		2016-07-13 00:00:00		2016-06-13 00:00:00		2015-12-14 00:00:00		2015-11-06 00:00:00		2015-12-31 00:00:00		2015-11-11 00:00:00		2015-10-16 00:00:00		2015-12-04 00:00:00		2016-01-28 00:00:00		2016-12-09 00:00:00		2016-11-01 00:00:00		2016-11-22 00:00:00		2016-10-26 00:00:00		2016-09-30 00:00:00		2016-09-19 00:00:00		2016-03-14 00:00:00		2016-04-15 00:00:00		2016-02-26 00:00:00		2016-02-12 00:00:00		2016-04-14 00:00:00		2016-03-18 00:00:00		2016-10-19 00:00:00		2016-10-19 00:00:00		2016-10-28 00:00:00		2016-10-03 00:00:00		2016-08-12 00:00:00		2016-08-01 00:00:00		2016-09-01 00:00:00		2016-08-19 00:00:00		2016-08-30 00:00:00		2016-08-12 00:00:00		2016-05-12 00:00:00		2016-04-29 00:00:00		2016-06-24 00:00:00		2019-01-31 00:00:00		2018-09-14 00:00:00		2020-02-28 00:00:00		2020-04-10 00:00:00		2018-10-05 00:00:00		2022-11-02 00:00:00		2022-08-16 00:00:00		2022-10-07 00:00:00		2020-09-25 00:00:00		2020-09-24 00:00:00
filing_directory		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		1990454		2138972		2054965		2051317		2001280		1999093		2002124		1999443		1992293		2000631		2000631		2110310		2103419		2103419		2097101		2084050		2073438		2020511		2028965		2017722		2015807		2028495		2021502		2084521		2091976		2099514		2084521		2067970		None		2073438		2070413		2072816		2067966		2042330		2036776		2052750		None		2292231		2459911		2459911		2302865		2751101		2711682		2729927		2506046		2505269
form_id		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		None		F497		F497		F497		F497		F497		F497		F497		None		F497		F497		F497		F497		F497		F497		F497		F497		F497
receive_comment		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted