Home

Filer ID: 1307147

Table: cvr_lobby_disclosure

filing_id		1350736		1451275		1377266		1421389		1392907		1436550		1538319		1507789		1484416		1464202		1620452		1607789		1571067		1590623		1637121		1707962		1678924		1657233		1734138		1800287		1782362		1765058		1817116		1870402		1845805		1845080		1911127		1981573		1964359		1993161		2060098		2035690		2008565		2099943		2176012		2129730		2157367		2210306		2194118		2274061		2232441		2339116		2319337		2392569		2376821		2465834		2434335		2414570		2482832		2547914		2525419		2576640		2707790		2677292		2748570
amend_id		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		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
form_type		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615
sender_id		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		1261533		F00409		1261533		1261533		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		E24747		E24747		E24747
filer_id		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147
entity_cd		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY
filer_naml		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO
filer_namf		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL
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
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
report_num		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000
rpt_date		2008-07-31 00:00:00		2009-10-31 00:00:00		2008-10-20 00:00:00		2009-04-30 00:00:00		2009-01-31 00:00:00		2009-07-31 00:00:00		2010-10-31 00:00:00		2010-07-31 00:00:00		2010-04-30 00:00:00		2010-01-31 00:00:00		2011-10-31 00:00:00		2011-07-31 00:00:00		2011-01-31 00:00:00		2011-04-30 00:00:00		2012-01-31 00:00:00		2012-10-31 00:00:00		2012-07-31 00:00:00		2012-04-30 00:00:00		2013-01-31 00:00:00		2013-10-31 00:00:00		2013-07-31 00:00:00		2013-04-16 00:00:00		2014-01-31 00:00:00		2014-07-14 00:00:00		2014-04-30 00:00:00		2014-04-22 00:00:00		2014-10-18 00:00:00		2015-07-16 00:00:00		2015-04-28 00:00:00		2015-10-16 00:00:00		2016-07-25 00:00:00		2016-04-19 00:00:00		2016-01-27 00:00:00		2016-10-17 00:00:00		2017-07-28 00:00:00		2017-01-24 00:00:00		2017-04-27 00:00:00		2018-01-31 00:00:00		2017-10-16 00:00:00		2018-07-19 00:00:00		2018-04-17 00:00:00		2019-01-22 00:00:00		2018-10-25 00:00:00		2019-07-22 00:00:00		2019-04-18 00:00:00		2020-04-09 00:00:00		2020-01-21 00:00:00		2019-10-21 00:00:00		2020-07-23 00:00:00		2021-01-20 00:00:00		2020-10-25 00:00:00		2021-04-20 00:00:00		2022-08-01 00:00:00		2022-04-30 00:00:00		2022-10-31 00:00:00
from_date		2008-04-21 00:00:00		2009-07-01 00:00:00		2008-07-01 00:00:00		2009-01-01 00:00:00		2008-10-01 00:00:00		2009-04-01 00:00:00		2010-07-01 00:00:00		2010-04-01 00:00:00		2010-01-01 00:00:00		2009-10-01 00:00:00		2011-07-01 00:00:00		2011-04-01 00:00:00		2010-10-01 00:00:00		2011-01-01 00:00:00		2011-10-01 00:00:00		2012-07-01 00:00:00		2012-04-01 00:00:00		2012-01-01 00:00:00		2012-10-01 00:00:00		2013-07-01 00:00:00		2013-04-01 00:00:00		2013-01-01 00:00:00		2013-10-01 00:00:00		2014-04-01 00:00:00		2014-01-01 00:00:00		2014-03-17 00:00:00		2014-07-01 00:00:00		2015-04-01 00:00:00		2015-01-01 00:00:00		2015-07-01 00:00:00		2016-04-01 00:00:00		2016-01-01 00:00:00		2015-10-01 00:00:00		2016-07-01 00:00:00		2017-04-01 00:00:00		2016-10-01 00:00:00		2017-01-01 00:00:00		2017-10-01 00:00:00		2017-07-01 00:00:00		2018-04-01 00:00:00		2018-01-01 00:00:00		2018-10-01 00:00:00		2018-07-01 00:00:00		2019-04-01 00:00:00		2019-01-01 00:00:00		2020-01-01 00:00:00		2019-10-01 00:00:00		2019-07-01 00:00:00		2020-04-01 00:00:00		2020-10-01 00:00:00		2020-07-01 00:00:00		2021-01-01 00:00:00		2022-04-01 00:00:00		2022-01-01 00:00:00		2022-07-01 00:00:00
thru_date		2008-06-30 00:00:00		2009-09-30 00:00:00		2008-09-30 00:00:00		2009-03-31 00:00:00		2008-12-31 00:00:00		2009-06-30 00:00:00		2010-09-30 00:00:00		2010-06-30 00:00:00		2010-03-31 00:00:00		2009-12-31 00:00:00		2011-09-30 00:00:00		2011-06-30 00:00:00		2010-12-31 00:00:00		2011-03-31 00:00:00		2011-12-31 00:00:00		2012-09-30 00:00:00		2012-06-30 00:00:00		2012-03-31 00:00:00		2012-12-31 00:00:00		2013-09-30 00:00:00		2013-06-30 00:00:00		2013-03-31 00:00:00		2013-12-31 00:00:00		2014-06-30 00:00:00		2014-03-06 00:00:00		2014-03-31 00:00:00		2014-08-15 00:00:00		2015-06-30 00:00:00		2015-03-31 00:00:00		2015-09-30 00:00:00		2016-06-30 00:00:00		2016-03-31 00:00:00		2015-12-31 00:00:00		2016-09-30 00:00:00		2017-06-30 00:00:00		2016-12-31 00:00:00		2017-03-31 00:00:00		2017-12-31 00:00:00		2017-09-30 00:00:00		2018-06-30 00:00:00		2018-03-31 00:00:00		2018-12-31 00:00:00		2018-09-30 00:00:00		2019-06-30 00:00:00		2019-03-31 00:00:00		2020-03-31 00:00:00		2019-12-31 00:00:00		2019-09-30 00:00:00		2020-06-30 00:00:00		2020-12-31 00:00:00		2020-09-30 00:00:00		2021-03-31 00:00:00		2022-06-30 00:00:00		2022-03-31 00:00:00		2022-09-30 00:00:00
cum_beg_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
firm_id		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		F00409		1261533		F00409		1261533		1261533		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		1374043		E24747		E24747		E24747
firm_name		KP PUBLIC AFFAIRS		KP PUBLIC AFFAIRS		KP PUBLIC AFFAIRS		KP PUBLIC AFFAIRS		KP PUBLIC AFFAIRS		KP PUBLIC AFFAIRS		KP PUBLIC AFFAIRS		KP PUBLIC AFFAIRS		KP PUBLIC AFFAIRS		KP PUBLIC AFFAIRS		KP PUBLIC AFFAIRS		KP PUBLIC AFFAIRS		KP PUBLIC AFFAIRS		KP PUBLIC AFFAIRS		KP PUBLIC AFFAIRS		KP PUBLIC AFFAIRS		KP PUBLIC AFFAIRS		KP PUBLIC AFFAIRS		KP PUBLIC AFFAIRS		KP PUBLIC AFFAIRS		KP PUBLIC AFFAIRS		KP PUBLIC AFFAIRS		KP PUBLIC AFFAIRS		POLITICAL SOLUTIONS, LLC		KP PUBLIC AFFAIRS		POLITICAL SOLUTIONS, LLC		POLITICAL SOLUTIONS, LLC		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		WESTERN STATES PETROLEUM ASSOCIATION		WESTERN STATES PETROLEUM ASSOCIATION		WESTERN STATES PETROLEUM ASSOCIATION
firm_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		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO
firm_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
firm_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		90024		90024		90024		91311		91311		90024		91311		91311		91311		91311		91311		91311		91311		91311		91311		91311		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814
firm_phon		916 448-2162		916 448-2162		916 448-2162		916 448-2162		916 448-2162		916 448-2162		916 448-2162		916 448-2162		916 448-2162		916 448-2162		916 448-2162		916 448-2162		916 448-2162		916 448-2162		916 448-2162		916 448-2162		916 448-2162		916 448-2162		916 448-2162		916 448-2162		916 448-2162		916 448-2162		916 448-2162		916 492-2766		916 448-2162		916 492-2766		916 492-2766		(310) 443-6009		(310) 443-6009		(310) 443-6009		(888) 848-4754		(888) 848-4754		(310) 443-6009		(888) 848-4754		(888) 848-4754		(888) 848-4754		(888) 848-4754		(888) 848-4754		(888) 848-4754		(888) 848-4754		(888) 848-4754		(888) 848-4754		(888) 848-4754		916 503-3602		916 503-3602		916 503-3602		916 503-3602		916 503-3602		916 503-3602		916 503-3602		916 503-3602		916 503-3602		415 389-6800		415 389-6800		415 389-6800
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		SAN RAFAEL		SAN RAFAEL		SAN RAFAEL
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		CA		CA		CA
mail_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		94901		94901		94901
mail_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
sig_date		2008-07-21 00:00:00		2009-10-16 00:00:00		2008-10-20 00:00:00		2009-04-17 00:00:00		2009-01-20 00:00:00		2009-07-20 00:00:00		2008-10-20 00:00:00		2010-07-15 00:00:00		2010-04-25 00:00:00		2010-01-24 00:00:00		2011-10-18 00:00:00		2011-07-23 00:00:00		2011-01-23 00:00:00		2011-04-18 00:00:00		2012-01-23 00:00:00		2012-10-15 00:00:00		2012-07-26 00:00:00		2012-04-24 00:00:00		2013-01-17 00:00:00		2013-10-22 00:00:00		2013-07-19 00:00:00		2013-04-19 00:00:00		2014-01-24 00:00:00		2014-07-14 00:00:00		2014-04-27 00:00:00		2014-04-22 00:00:00		2014-10-18 00:00:00		2015-07-16 00:00:00		2015-04-28 00:00:00		2015-10-16 00:00:00		2016-07-25 00:00:00		2016-04-19 00:00:00		2016-01-27 00:00:00		2016-10-17 00:00:00		2017-07-28 00:00:00		2017-01-24 00:00:00		2017-04-27 00:00:00		2018-01-31 00:00:00		2017-10-16 00:00:00		2018-07-19 00:00:00		2018-04-17 00:00:00		2019-01-22 00:00:00		2018-10-25 00:00:00		2019-07-22 00:00:00		2019-04-18 00:00:00		2020-04-09 00:00:00		2020-01-21 00:00:00		2019-10-21 00:00:00		2020-07-23 00:00:00		2021-01-20 00:00:00		2020-10-25 00:00:00		2021-04-20 00:00:00		2022-08-01 00:00:00		2022-04-30 00:00:00		2022-10-31 00:00:00
sig_loc		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		LOS ANGELES, CA		LOS ANGELES, CA		LOS ANGELES, CA		LOS ANGELES, CA		LOS ANGELES, CA		LOS ANGELES, CA		LOS ANGELES, CA		LOS ANGELES, CA		LOS ANGELES, CA		LOS ANGELES, CA		LOS ANGELES, CA		LOS ANGELES, CA		LOS ANGELES, CA		LOS ANGELES, CA		LOS ANGELES, CA		LOS ANGELES, CA		LOS ANGELES, CA		LOS ANGELES, CA		LOS ANGELES, CA		LOS ANGELES, CA		LOS ANGELES, CA		LOS ANGELES, CA		LOS ANGELES, CA		LOS ANGELES, CA		LOS ANGELES, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA
sig_naml		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (4442000-SLM)		DEIRO (433000-SSD)		DEIRO (4442000-SLM)		DEIRO (4442000-SLM)		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO
sig_namf		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL
sig_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
sig_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
prn_naml		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (433000-SSD)		DEIRO (4442000-SLM)		DEIRO (433000-SSD)		DEIRO (4442000-SLM)		DEIRO (4442000-SLM)		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO
prn_namf		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL
prn_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
prn_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
sig_title		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
nopart1_cb		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X
nopart2_cb		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X
part1_1_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
part1_2_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
ctrib_n_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
ctrib_y_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
lby_actvty		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
lobby_n_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
lobby_y_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
major_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
major_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
major_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
major_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
rcpcmte_nm		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rcpcmte_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

Table: cvr_registration

filing_id		1337275		1386439		1554230		1720580		1827808		1922884		1922884		1963296		2109079		2109079		2328078		2328078		2541958		2573101		2647139		2647139
amend_id		0		0		0		0		0		0		1		0		0		1		0		1		0		0		0		1
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F604		F604		F604		F604		F604		F604		F604		F606		F604		F604		F604		F604		F604		F606		F604		F604
sender_id		F00409		F00409		F00409		F00409		1261533		1374043		1374043		1307147		1374043		1374043		1374043		1374043		1374043		1307147		E24747		E24747
filer_id		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147
entity_cd		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY
filer_naml		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO
filer_namf		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL J.		PAUL		PAUL
filer_namt		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
report_num		000		000		000		000		000		000		001		000		000		001		000		001		000		000		000		001
rpt_date		2008-04-21 00:00:00		2008-12-29 00:00:00		2010-12-06 00:00:00		2012-12-10 00:00:00		2014-03-06 00:00:00		2014-12-05 00:00:00		2015-06-16 00:00:00		2014-08-15 00:00:00		2016-11-08 00:00:00		2017-02-02 00:00:00		2018-12-03 00:00:00		2019-04-22 00:00:00		2020-12-18 00:00:00		2021-03-31 00:00:00		2022-02-03 00:00:00		2022-07-25 00:00:00
ls_beg_yr		2007		2009		2011		2013		2013		2015		2015		2013		2017		2017		2019		2019		2021		2021		2021		2021
ls_end_yr		2008		2010		2012		2014		2014		2016		2016		2014		2018		2018		2020		2020		2022		2022		2022		2022
qual_date		None		None		None		None		2014-03-17 00:00:00		2015-01-01 00:00:00		None		None		None		None		None		None		None		None		2022-01-24 00:00:00		None
eff_date		None		None		None		None		None		None		None		2014-08-15 00:00:00		None		None		None		None		None		2021-03-31 00:00:00		None		None
bus_city		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO
bus_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
bus_zip4		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814
bus_phon		916 448-2162		916 448-2162		916 448-2162		916 448-2162		916 492-2766		(916) 503-1409		(916) 503-1409		None		(916) 503-3602		(916) 503-3602		(916) 503-3602		(916) 503-3602		(916) 503-3602		None		(415) 389-6800		(415) 389-6800
bus_fax		None		916 448-4923		916 448-4923		916 448-4923		None		(916) 503-2401		(916) 503-2401		None		(916) 503-2401		(916) 503-2401		(916) 503-2401		(916) 503-2401		(916) 503-2401		None		None		None
bus_email		None		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]
mail_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		SAN RAFAEL		SAN RAFAEL
mail_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		CA		CA
mail_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		94901		94901
mail_phon		None		None		None		None		None		None		None		None		None		None		None		None		None		916 503-3602		None		None
sig_date		2008-04-21 00:00:00		2008-12-11 00:00:00		2010-12-06 00:00:00		2012-12-10 00:00:00		2014-03-06 00:00:00		2014-12-05 00:00:00		2015-06-16 00:00:00		2014-08-15 00:00:00		2016-11-08 00:00:00		2017-02-02 00:00:00		2018-12-03 00:00:00		2019-04-22 00:00:00		2020-12-18 00:00:00		2021-03-31 00:00:00		2022-01-31 00:00:00		2022-07-22 00:00:00
sig_loc		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA
sig_naml		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO
sig_namf		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL J.		PAUL		PAUL
sig_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sig_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
prn_naml		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO
prn_namf		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL J.		PAUL		PAUL
prn_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
prn_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sig_title		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST (4442)SLC		LOBBYIST		LOBBYIST		LOBBYIST (4442-SLM)		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		SENIOR DIRECTOR		SENIOR DIRECTOR
stmt_firm		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
ind_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
trade_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
oth_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
a_b_name		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
a_b_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
a_b_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
a_b_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
descrip_1		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
descrip_2		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
c_less50		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
c_more50		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
ind_class		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
ind_descr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_class		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_descr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
auth_name		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
auth_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
auth_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
auth_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
lobby_int		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
influen_yn		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
firm_name		KP PUBLIC AFFAIRS		KP PUBLIC AFFAIRS		KP PUBLIC AFFAIRS		KP PUBLIC AFFAIRS		POLITICAL SOLUTIONS LLC		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		POLITICAL SOLUTIONS, LLC		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		CALIFORNIA RESOURCES CORPORATION AND SUBSIDIARIES		WESTERN STATES PETROLEUM ASSOCIATION		WESTERN STATES PETROLEUM ASSOCIATION
newcert_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		X		None
rencert_cb		None		X		None		None		None		X		None		None		X		None		X		None		X		None		None		None
complet_dt		2007-08-16 00:00:00		None		2010-11-17 00:00:00		2012-11-08 00:00:00		2012-11-08 00:00:00		None		2015-06-16 00:00:00		None		None		2017-02-02 00:00:00		None		2019-01-10 00:00:00		None		None		None		2022-07-21 00:00:00
lby_reg_cb		X		X		X		X		X		X		X		None		X		X		X		X		X		None		X		X
lby_604_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
st_leg_yn		Y		Y		Y		Y		Y		Y		Y		None		Y		Y		Y		Y		Y		None		None		None
st_agency		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
lobby_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
l_firm_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filer_address

filer_id		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147
adrid		2137923		2160129		2203628		2410288		2507425		2465931		2278622		2546862		2546863		2312552		2349288		2531704		2531703
effect_dt		2008-04-21 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2017-01-01 00:00:00		2021-01-01 00:00:00		2019-01-01 00:00:00		2013-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2014-03-17 00:00:00		2015-01-01 00:00:00		2022-01-24 00:00:00		2022-01-24 00:00:00
add_type		7051		7051		7051		7051		7051		7051		7051		7051		7082		7051		7051		7082		7051
session_id		2007		2009		2011		2017		2021		2019		2013		2023		2023		2013		2015		2021		2021

Table: filer_ethics_class

filer_id		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147
session_id		2007		2009		2011		2013		2015		2017		2019		2021
ethics_date		2007-08-16 00:00:00		2009-01-16 00:00:00		2010-11-17 00:00:00		2012-11-08 00:00:00		2015-06-16 00:00:00		2017-02-02 00:00:00		2019-01-10 00:00:00		2022-07-21 00:00:00

Table: filer_filings

filer_id		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147
filing_id		1782362		1963572		1963296		1922884		1981573		1964359		1870402		1911127		1337275		1350736		1332591		1332593		1392907		1386439		1377266		1421389		1414299		1414309		1464202		1451275		1436550		1484416		1507789		1554230		1560570		1538319		1590623		1607789		1571067		1637121		1657233		1620452		1678924		1828995		1800287		1817116		1926563		1922884		1720580		1707962		1742874		1734138		1845080		1845805		1827808		1765058		1971529		2434335		2337074		2482832		2339116		2392569		2414570		2008565		1993161		2035690		2060098		2099943		2109079		2112402		2133826		2129730		2109079		2176012		2157367		2274061		2376821		2210306		2378919		2328078		2525419		2547914		2465834		2328078		2194118		2319337		2232441		2607744		2677292		2573101		2541958		2586926		2707790		2652371		2576640		2647139		2709917		2647139		2748570
period_id		214		None		219		222		222		221		218		219		194		194		None		None		196		196		195		197		None		None		200		199		198		201		202		204		None		203		205		206		204		208		209		207		210		None		215		216		None		220		212		211		None		212		217		217		217		213		None		240		None		242		236		238		239		224		223		225		226		227		228		None		None		228		229		230		229		234		237		232		None		236		243		244		241		238		231		235		233		None		249		245		244		None		250		None		245		251		None		249		251
form_id		F615		F606		F606		F604		F615		F615		F615		F615		F604		F615		F604		F999		F615		F604		F615		F615		F604		F604		F615		F615		F615		F615		F615		F604		F604		F615		F615		F615		F615		F615		F615		F615		F615		F604		F615		F615		F604		F604		F604		F615		F604		F615		F615		F615		F604		F615		F604		F615		F604		F615		F615		F615		F615		F615		F615		F615		F615		F615		F604		F604		F604		F615		F604		F615		F615		F615		F615		F615		F604		F604		F615		F615		F615		F604		F615		F615		F615		F606		F615		F606		F604		F604		F615		F604		F615		F604		F604		F604		F615
filing_sequence		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0
filing_date		2013-07-31 00:00:00		2015-04-28 00:00:00		2015-04-28 00:00:00		2015-06-23 00:00:00		2015-07-31 00:00:00		2015-04-29 00:00:00		2014-07-30 00:00:00		2014-10-31 00:00:00		2008-05-27 00:00:00		2008-07-31 00:00:00		2008-05-02 00:00:00		2008-05-15 00:00:00		2009-01-27 00:00:00		2008-12-30 00:00:00		2008-10-30 00:00:00		2009-04-30 00:00:00		2008-12-30 00:00:00		2009-01-16 00:00:00		2010-01-31 00:00:00		2009-10-29 00:00:00		2009-07-30 00:00:00		2010-04-29 00:00:00		2010-08-02 00:00:00		2010-12-28 00:00:00		2010-12-28 00:00:00		2010-10-28 00:00:00		2011-04-29 00:00:00		2011-08-01 00:00:00		2011-01-31 00:00:00		2012-01-31 00:00:00		2012-04-30 00:00:00		2011-10-27 00:00:00		2012-07-31 00:00:00		2014-03-13 00:00:00		2013-10-31 00:00:00		2014-01-30 00:00:00		2015-01-01 00:00:00		2015-01-05 00:00:00		2012-12-27 00:00:00		2012-10-30 00:00:00		2012-12-27 00:00:00		2013-01-28 00:00:00		2014-04-30 00:00:00		2014-04-30 00:00:00		2014-03-13 00:00:00		2013-04-30 00:00:00		2015-06-16 00:00:00		2020-01-23 00:00:00		2018-12-13 00:00:00		2020-07-29 00:00:00		2019-01-24 00:00:00		2019-07-24 00:00:00		2019-10-23 00:00:00		2016-01-28 00:00:00		2015-10-21 00:00:00		2016-04-29 00:00:00		2016-07-28 00:00:00		2016-10-29 00:00:00		2016-11-30 00:00:00		2016-12-01 00:00:00		2017-02-02 00:00:00		2017-01-31 00:00:00		2017-03-22 00:00:00		2017-07-31 00:00:00		2017-05-01 00:00:00		2018-07-31 00:00:00		2019-04-24 00:00:00		2018-01-31 00:00:00		2019-04-25 00:00:00		2018-12-13 00:00:00		2020-10-28 00:00:00		2021-01-27 00:00:00		2020-04-15 00:00:00		2019-04-23 00:00:00		2017-10-31 00:00:00		2018-10-31 00:00:00		2018-04-18 00:00:00		2021-04-12 00:00:00		2022-05-02 00:00:00		2021-04-09 00:00:00		2021-01-04 00:00:00		2021-01-06 00:00:00		2022-08-01 00:00:00		2022-02-04 00:00:00		2021-04-25 00:00:00		2022-07-28 00:00:00		2022-07-28 00:00:00		2022-02-03 00:00:00		2022-10-31 00:00:00
stmnt_type		10001		10003		10001		10002		10001		10001		10001		10001		10001		10001		10005		10005		10001		10001		10001		10001		10005		10006		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10005		10001		10001		10001		10005		10001		10001		10001		10001		10001		10006		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10006		10001		10002		10001		10001		10001		10001		10001		10006		10001		10001		10001		10001		10002		10001		10001		10001		10003		10001		10001		10001		10005		10001		10005		10001		10002		10005		10001		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003
session_id		2013		2013		2013		2015		2015		2015		2013		2013		2007		2007		2007		2007		2007		2009		2007		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2009		2011		2011		2009		2011		2011		2011		2011		2013		2013		2013		2015		2015		2013		2011		2013		2011		2013		2013		2013		2013		2015		2019		2019		2019		2017		2019		2019		2015		2015		2015		2015		2015		2017		2017		2017		2015		2017		2017		2017		2017		2019		2017		2019		2019		2019		2019		2019		2019		2017		2017		2017		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		ASAETERN		YRODRIGU		YRODRIGU		PBANFORD		JINGRAM		AGLADNEY		ASAETERN		ASAETERN		YRODRIGU		LTHIBAUL		YRODRIGU		YRODRIGU		CFLAGG		YRODRIGU		CFLAGG		CFLAGG		YRODRIGU		CPON		CFLAGG		CFLAGG		CFLAGG		JINGRAM		ASAETERN		YRODRIGU		YRODRIGU		ASAETERN		JINGRAM		ASAETERN		ASAETERN		ASAETERN		ASAETERN		ASAETERN		AGLADNEY		YRODRIGU		ASAETERN		ASAETERN		PBANFORD		PBANFORD		SARRIAGA		ASAETERN		SARRIAGA		ASAETERN		ASAETERN		ASAETERN		YRODRIGU		ASAETERN		PBANFORD		VUKSTINA		GPEREZ		CVANLIEW		AGLADNEY		VUKSTINA		VUKSTINA		AGLADNEY		JINGRAM		AGLADNEY		AGLADNEY		AGLADNEY		PBANFORD		PBANFORD		KBANH		AGLADNEY		GPEREZ		SMCCONNAN		JINGRAM		AGLADNEY		SUSHAKOV		AGLADNEY		VUKSTINA		GPEREZ		GTAYLOR		JRAMOS		VUKSTINA		VUKSTINA		SMCCONNAN		JFRONEFIELD		AGLADNEY		JMENDOZA		CHATRIDGE		JMENDOZA		JMENDOZA		JMENDOZA		CAFILER		JMENDOZA		CHATRIDGE		CVANLIEW		CVANLIEW		JMENDOZA		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
fine_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003
rpt_start		2013-04-01 00:00:00		1900-01-01 00:00:00		2014-08-15 00:00:00		2015-06-16 00:00:00		2015-04-01 00:00:00		2015-01-01 00:00:00		2014-04-01 00:00:00		2014-07-01 00:00:00		2008-04-21 00:00:00		2008-04-21 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2008-10-01 00:00:00		2008-12-29 00:00:00		2008-07-01 00:00:00		2009-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2009-10-01 00:00:00		2009-07-01 00:00:00		2009-04-01 00:00:00		2010-01-01 00:00:00		2010-04-01 00:00:00		2010-12-06 00:00:00		1900-01-01 00:00:00		2010-07-01 00:00:00		2011-01-01 00:00:00		2011-04-01 00:00:00		2010-10-01 00:00:00		2011-10-01 00:00:00		2012-01-01 00:00:00		2011-07-01 00:00:00		2012-04-01 00:00:00		1900-01-01 00:00:00		2013-07-01 00:00:00		2013-10-01 00:00:00		1900-01-01 00:00:00		2014-12-05 00:00:00		2012-12-10 00:00:00		2012-07-01 00:00:00		1900-01-01 00:00:00		2012-10-01 00:00:00		2014-03-17 00:00:00		2014-01-01 00:00:00		2014-03-06 00:00:00		2013-01-01 00:00:00		1900-01-01 00:00:00		2019-10-01 00:00:00		1900-01-01 00:00:00		2020-04-01 00:00:00		2018-10-01 00:00:00		2019-04-01 00:00:00		2019-07-01 00:00:00		2015-10-01 00:00:00		2015-07-01 00:00:00		2016-01-01 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		2016-11-08 00:00:00		1900-01-01 00:00:00		None		2016-10-01 00:00:00		2017-02-02 00:00:00		2017-04-01 00:00:00		2017-01-01 00:00:00		2018-04-01 00:00:00		2019-01-01 00:00:00		2017-10-01 00:00:00		1900-01-01 00:00:00		2018-12-03 00:00:00		2020-07-01 00:00:00		2020-10-01 00:00:00		2020-01-01 00:00:00		2019-04-22 00:00:00		2017-07-01 00:00:00		2018-07-01 00:00:00		2018-01-01 00:00:00		1900-01-01 00:00:00		2022-01-01 00:00:00		2021-03-31 00:00:00		2020-12-18 00:00:00		1900-01-01 00:00:00		2022-04-01 00:00:00		1900-01-01 00:00:00		2021-01-01 00:00:00		2022-07-25 00:00:00		1900-01-01 00:00:00		2022-02-03 00:00:00		2022-07-01 00:00:00
rpt_end		2013-06-30 00:00:00		1900-01-01 00:00:00		2014-08-15 00:00:00		2015-06-16 00:00:00		2015-06-30 00:00:00		2015-03-31 00:00:00		2014-06-30 00:00:00		2014-08-15 00:00:00		2008-04-21 00:00:00		2008-06-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2008-12-31 00:00:00		2008-12-29 00:00:00		2008-09-30 00:00:00		2009-03-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2009-12-31 00:00:00		2009-09-30 00:00:00		2009-06-30 00:00:00		2010-03-31 00:00:00		2010-06-30 00:00:00		2010-12-06 00:00:00		1900-01-01 00:00:00		2010-09-30 00:00:00		2011-03-31 00:00:00		2011-06-30 00:00:00		2010-12-31 00:00:00		2011-12-31 00:00:00		2012-03-31 00:00:00		2011-09-30 00:00:00		2012-06-30 00:00:00		1900-01-01 00:00:00		2013-09-30 00:00:00		2013-12-31 00:00:00		1900-01-01 00:00:00		2014-12-05 00:00:00		2012-12-10 00:00:00		2012-09-30 00:00:00		1900-01-01 00:00:00		2012-12-31 00:00:00		2014-03-31 00:00:00		2014-03-06 00:00:00		2014-03-06 00:00:00		2013-03-31 00:00:00		1900-01-01 00:00:00		2019-12-31 00:00:00		1900-01-01 00:00:00		2020-06-30 00:00:00		2018-12-31 00:00:00		2019-06-30 00:00:00		2019-09-30 00:00:00		2015-12-31 00:00:00		2015-09-30 00:00:00		2016-03-31 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		2016-11-08 00:00:00		1900-01-01 00:00:00		None		2016-12-31 00:00:00		2017-02-02 00:00:00		2017-06-30 00:00:00		2017-03-31 00:00:00		2018-06-30 00:00:00		2019-03-31 00:00:00		2017-12-31 00:00:00		1900-01-01 00:00:00		2018-12-03 00:00:00		2020-09-30 00:00:00		2020-12-31 00:00:00		2020-03-31 00:00:00		2019-04-22 00:00:00		2017-09-30 00:00:00		2018-09-30 00:00:00		2018-03-31 00:00:00		1900-01-01 00:00:00		2022-03-31 00:00:00		2021-03-31 00:00:00		2020-12-18 00:00:00		1900-01-01 00:00:00		2022-06-30 00:00:00		1900-01-01 00:00:00		2021-03-31 00:00:00		2022-07-25 00:00:00		1900-01-01 00:00:00		2022-02-03 00:00:00		2022-09-30 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filing_type		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		None		None		22001		22001		22001		22001		None		None		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		None		22001		22001		22001		None		22001		22001		22001		22001		22001		None		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		None		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		None		22001		None		22001		22001		None		22001		22001

Table: filer_to_filer_type

filer_id		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147
filer_type		4		4		4		4		4		4		4		4		4		4		4		4
active		Y		Y		Y		Y		Y		Y		T		Y		Y		N		T		Y
race		None		None		0		None		None		None		None		None		None		None		None		None
session_id		2011		2013		2007		2009		2021		2015		2013		2017		2019		2023		2021		2021
category		None		None		0		None		None		None		None		None		None		None		None		None
category_type		None		None		0		None		None		None		None		None		None		None		None		None
sub_category		None		None		0		None		None		None		None		None		None		None		None		None
effect_dt		2011-01-01 00:00:00		2013-01-01 00:00:00		2008-04-21 00:00:00		2009-01-01 00:00:00		2021-01-01 00:00:00		2015-01-01 00:00:00		2014-08-15 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2023-01-01 00:00:00		2021-03-31 00:00:00		2022-01-24 00:00:00
sub_category_type		None		None		0		None		None		None		None		None		None		None		None		None
election_type		None		None		0		None		None		None		None		None		None		None		None		None
sub_category_a		None		None		None		None		None		None		None		None		None		None		None		None
nyq_dt		None		None		None		None		None		None		None		None		None		None		None		None
party_cd		None		None		0		None		None		None		None		None		None		None		None		None
county_cd		None		None		0		None		None		None		None		None		None		None		None		None
district_cd		None		None		0		None		None		None		None		None		None		None		None		None

Table: filer_xref

filer_id		1307147
xref_id		1307147
effect_dt		2008-05-15 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147
filer_id		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147
filer_type		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST
status		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE
effect_dt		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00
naml		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO		DEIRO
namf		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL J.		PAUL J.		PAUL J.		PAUL J.		PAUL J.		PAUL J.		PAUL J.		PAUL J.		PAUL J.		PAUL J.		PAUL J.		PAUL J.		PAUL J.		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL		PAUL
namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr1		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr2		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
city		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN RAFAEL		SACRAMENTO		SAN RAFAEL		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN RAFAEL		SACRAMENTO		SAN RAFAEL		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN RAFAEL		SACRAMENTO		SAN RAFAEL		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN RAFAEL		SACRAMENTO		SAN RAFAEL		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN RAFAEL		SACRAMENTO		SAN RAFAEL		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN RAFAEL		SACRAMENTO		SAN RAFAEL		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN RAFAEL		SACRAMENTO		SAN RAFAEL		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN RAFAEL		SACRAMENTO		SAN RAFAEL		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN RAFAEL		SACRAMENTO		SAN RAFAEL		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN RAFAEL		SACRAMENTO		SAN RAFAEL
st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		95814		95608		95814		95814		95814		95814		95814		95814		95814		95814		94901		95814		94901		95814		95608		95814		95814		95814		95814		95814		95814		95814		95814		94901		95814		94901		95814		95608		95814		95814		95814		95814		95814		95814		95814		95814		94901		95814		94901		95814		95608		95814		95814		95814		95814		95814		95814		95814		95814		94901		95814		94901		95814		95608		95814		95814		95814		95814		95814		95814		95814		95814		94901		95814		94901		95814		95608		95814		95814		95814		95814		95814		95814		95814		95814		94901		95814		94901		95814		95608		95814		95814		95814		95814		95814		95814		95814		95814		94901		95814		94901		95814		95608		95814		95814		95814		95814		95814		95814		95814		95814		94901		95814		94901		95814		95608		95814		95814		95814		95814		95814		95814		95814		95814		94901		95814		94901		95814		95608		95814		95814		95814		95814		95814		95814		95814		95814		94901		95814		94901
phon		9164482162		9164482162		9164482162		9164482162		9164922766		9165031409		9165033602		9165033602		9165033602		4153896800				4153896800				9164482162		9164482162		9164482162		9164482162		9164922766		9165031409		9165033602		9165033602		9165033602		4153896800				4153896800				9164482162		9164482162		9164482162		9164482162		9164922766		9165031409		9165033602		9165033602		9165033602		4153896800				4153896800				9164482162		9164482162		9164482162		9164482162		9164922766		9165031409		9165033602		9165033602		9165033602		4153896800				4153896800				9164482162		9164482162		9164482162		9164482162		9164922766		9165031409		9165033602		9165033602		9165033602		4153896800				4153896800				9164482162		9164482162		9164482162		9164482162		9164922766		9165031409		9165033602		9165033602		9165033602		4153896800				4153896800				9164482162		9164482162		9164482162		9164482162		9164922766		9165031409		9165033602		9165033602		9165033602		4153896800				4153896800				9164482162		9164482162		9164482162		9164482162		9164922766		9165031409		9165033602		9165033602		9165033602		4153896800				4153896800				9164482162		9164482162		9164482162		9164482162		9164922766		9165031409		9165033602		9165033602		9165033602		4153896800				4153896800				9164482162		9164482162		9164482162		9164482162		9164922766		9165031409		9165033602		9165033602		9165033602		4153896800				4153896800
fax		None		9164484923		9164484923		9164484923				9165032401		9165032401		9165032401		9165032401										None		9164484923		9164484923		9164484923				9165032401		9165032401		9165032401		9165032401										None		9164484923		9164484923		9164484923				9165032401		9165032401		9165032401		9165032401										None		9164484923		9164484923		9164484923				9165032401		9165032401		9165032401		9165032401										None		9164484923		9164484923		9164484923				9165032401		9165032401		9165032401		9165032401										None		9164484923		9164484923		9164484923				9165032401		9165032401		9165032401		9165032401										None		9164484923		9164484923		9164484923				9165032401		9165032401		9165032401		9165032401										None		9164484923		9164484923		9164484923				9165032401		9165032401		9165032401		9165032401										None		9164484923		9164484923		9164484923				9165032401		9165032401		9165032401		9165032401										None		9164484923		9164484923		9164484923				9165032401		9165032401		9165032401		9165032401
email		None		[email protected]		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None		None		[email protected]		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None		None		[email protected]		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None		None		[email protected]		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None		None		[email protected]		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None		None		[email protected]		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None		None		[email protected]		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None		None		[email protected]		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None		None		[email protected]		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None		None		[email protected]		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None

Table: filers

filer_id		1307147

Table: lobbying_chg_log

filer_id		1307147		1307147		1307147
change_no		0		1		2
session_id		2007		2013		2013
log_dt		2008-05-02 00:00:00		2014-03-11 00:00:00		2014-08-21 00:00:00
filer_type		4		4		4
correction_flg		Y		None		None
action		ADDED		DELETED		DELETED
attribute_changed		FIRM		FIRM		FIRM
ethics_dt		None		None		None
interests		None		None		None
filer_full_name		DEIRO, PAUL		PAUL DEIRO		PAUL DEIRO
filer_city		None		None		None
filer_st		None		None		None
filer_zip		None		None		None
filer_phone		None		None		None
entity_type		3		3		3
entity_name		KP PUBLIC AFFAIRS		KP PUBLIC AFFAIRS		POLITICAL SOLUTIONS, LLC
entity_city		None		None		None
entity_st		None		None		None
entity_zip		None		None		None
entity_phone		None		None		None
entity_id		1147235		1147235		1261533
responsible_officer		None		None		None
effect_dt		2008-04-21 00:00:00		2014-03-06 00:00:00		2014-08-15 00:00:00

Table: received_filings

filer_id		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147		1307147
filing_file_name		1337275_0.cal		1507789_0.cal		1554230_0.cal		1392907_0.cal		1350736_0.cal		1484416_0.cal		1451275_0.cal		1464202_0.cal		1436550_0.cal		1421389_0.cal		1386439_0.cal		1377266_0.cal		1845080_0.cal		1845805_0.cal		1734138_0.cal		1678924_0.cal		1782362_0.cal		1538319_0.cal		1571067_0.cal		63922.cal		1827808_0.cal		1817116_0.cal		1607789_0.cal		1590623_0.cal		1800287_0.cal		1765058_0.cal		1637121_0.cal		1620452_0.cal		1707962_0.cal		1720580_0.cal		1657233_0.cal		1870402_0.cal		1981573_0.cal		1922884_1.cal		409435.cal		2129730_0.cal		2109079_1.cal		2060098_0.cal		1993161_0.cal		2008565_0.cal		2109079_0.cal		2099943_0.cal		1964359_0.cal		1922884_0.cal		1911127_0.cal		2035690_0.cal		2176012_0.cal		2157367_0.cal		2328078_1.cal		2339116_0.cal		2274061_0.cal		2392569_0.cal		2210306_0.cal		2482832_0.cal		2376821_0.cal		2434335_0.cal		2328078_0.cal		2465834_0.cal		2194118_0.cal		2414570_0.cal		2319337_0.cal		2232441_0.cal		2707790_0.cal		2677292_0.cal		2547914_0.cal		2576640_0.cal		2525419_0.cal		2647139_0.cal		2748570_0.cal		2647139_1.cal		2541958_0.cal
received_date		2008-05-27 00:00:00		2010-08-02 00:00:00		2010-12-28 00:00:00		2009-01-27 00:00:00		2008-07-31 00:00:00		2010-04-29 00:00:00		2009-10-29 00:00:00		2010-01-31 00:00:00		2009-07-30 00:00:00		2009-04-30 00:00:00		2008-12-30 00:00:00		2008-10-30 00:00:00		2014-04-30 00:00:00		2014-04-30 00:00:00		2013-01-28 00:00:00		2012-07-31 00:00:00		2013-07-31 00:00:00		2010-10-28 00:00:00		2011-01-31 00:00:00		2014-03-13 00:00:00		2014-03-13 00:00:00		2014-01-30 00:00:00		2011-08-01 00:00:00		2011-04-29 00:00:00		2013-10-31 00:00:00		2013-04-30 00:00:00		2012-01-31 00:00:00		2011-10-27 00:00:00		2012-10-30 00:00:00		2012-12-27 00:00:00		2012-04-30 00:00:00		2014-07-30 00:00:00		2015-07-31 00:00:00		2015-06-23 00:00:00		2015-06-23 00:00:00		2017-01-31 00:00:00		2017-03-22 00:00:00		2016-07-28 00:00:00		2015-10-21 00:00:00		2016-01-28 00:00:00		2016-11-30 00:00:00		2016-10-29 00:00:00		2015-04-29 00:00:00		2015-01-05 00:00:00		2014-10-31 00:00:00		2016-04-29 00:00:00		2017-07-31 00:00:00		2017-05-01 00:00:00		2019-04-23 00:00:00		2019-01-24 00:00:00		2018-07-31 00:00:00		2019-07-24 00:00:00		2018-01-31 00:00:00		2020-07-29 00:00:00		2019-04-24 00:00:00		2020-01-23 00:00:00		2018-12-13 00:00:00		2020-04-15 00:00:00		2017-10-31 00:00:00		2019-10-23 00:00:00		2018-10-31 00:00:00		2018-04-18 00:00:00		2022-08-01 00:00:00		2022-05-02 00:00:00		2021-01-27 00:00:00		2021-04-25 00:00:00		2020-10-28 00:00:00		2022-02-03 00:00:00		2022-10-31 00:00:00		2022-07-28 00:00:00		2021-01-04 00:00:00
filing_directory		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/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/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		1337275		1507789		1554230		1392907		1350736		1484416		1451275		1464202		1436550		1421389		1386439		1377266		1845080		1845805		1734138		1678924		1782362		1538319		1571067		None		1827808		1817116		1607789		1590623		1800287		1765058		1637121		1620452		1707962		1720580		1657233		1870402		1981573		1922884		None		2129730		2109079		2060098		1993161		2008565		2109079		2099943		1964359		1922884		1911127		2035690		2176012		2157367		2328078		2339116		2274061		2392569		2210306		2482832		2376821		2434335		2328078		2465834		2194118		2414570		2319337		2232441		2707790		2677292		2547914		2576640		2525419		2647139		2748570		2647139		2541958
form_id		F604		F615		F604		F615		F615		F615		F615		F615		F615		F615		F604		F615		F615		F615		F615		F615		F615		F615		F615		None		F604		F615		F615		F615		F615		F615		F615		F615		F615		F604		F615		F615		F615		F604		None		F615		F604		F615		F615		F615		F604		F615		F615		F604		F615		F615		F615		F615		F604		F615		F615		F615		F615		F615		F615		F615		F604		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F604		F615		F604		F604
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 passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted