Home

Filer ID: 1334849

Table: cvr_lobby_disclosure

filing_id		1617556		1602488		1592422		1629241		1617556		1629241		1697518		1653319		1672050		1794233		1776912		1759942		1759987		1776912		1759987		1810319		1794233		1907129		1858210		1858210		1860835		1959844		1918073		1994160		1977465		2061144		2061144		2011754		1994160		2022972		2011754		2097200		2173549		2129294		2157632		2129294		2191385		2191385		2212492		2269899		2241620		2173549		2269899		2173549		2241620		2373705		2395451		2316722		2342725		2316722		2469123		2437735		2417130		2417130		2528444		2373705		2395451		2437735		2551264		2482062		2469123		2630336		2577776		2612088		2655232		2704311		2679314		2744986		2744986
amend_id		0		0		0		1		1		0		0		0		0		0		0		0		0		1		1		0		1		0		0		1		0		0		0		0		0		1		0		1		1		0		0		0		0		1		0		0		0		1		0		1		0		2		0		1		1		0		0		0		0		1		0		0		0		1		0		1		1		1		0		0		1		0		0		0		0		0		0		0		1
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
form_type		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635
sender_id		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849
filer_id		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849
entity_cd		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM
filer_naml		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.
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
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
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
report_num		000		000		000		001		001		000		000		000		000		000		000		000		000		001		001		000		001		000		000		001		000		000		000		000		000		001		000		001		001		000		000		000		000		001		000		000		000		001		000		001		000		002		000		001		001		000		000		000		000		001		000		000		000		001		000		001		001		001		000		000		001		000		000		000		000		000		000		000		001
rpt_date		2011-10-14 00:00:00		2011-07-22 00:00:00		2011-05-03 00:00:00		2012-01-31 00:00:00		2012-01-31 00:00:00		2012-01-18 00:00:00		2012-10-11 00:00:00		2012-04-20 00:00:00		2012-07-17 00:00:00		2013-10-15 00:00:00		2013-07-22 00:00:00		2013-04-19 00:00:00		2013-04-19 00:00:00		2013-11-19 00:00:00		2013-11-19 00:00:00		2014-01-15 00:00:00		2013-11-19 00:00:00		2014-10-28 00:00:00		2014-06-03 00:00:00		2014-06-13 00:00:00		2014-07-02 00:00:00		2015-04-21 00:00:00		2014-12-12 00:00:00		2015-10-26 00:00:00		2015-07-27 00:00:00		2016-10-04 00:00:00		2016-07-29 00:00:00		2016-02-04 00:00:00		2016-02-04 00:00:00		2016-03-24 00:00:00		2016-02-01 00:00:00		2016-10-27 00:00:00		2017-07-28 00:00:00		2017-05-01 00:00:00		2017-05-01 00:00:00		2017-01-31 00:00:00		2017-10-27 00:00:00		2017-11-14 00:00:00		2018-02-01 00:00:00		2018-10-11 00:00:00		2018-04-30 00:00:00		2017-11-14 00:00:00		2018-07-26 00:00:00		2017-11-08 00:00:00		2018-07-03 00:00:00		2019-04-16 00:00:00		2019-07-29 00:00:00		2018-10-30 00:00:00		2019-01-29 00:00:00		2019-01-29 00:00:00		2020-04-29 00:00:00		2020-01-29 00:00:00		2019-10-29 00:00:00		2020-12-18 00:00:00		2020-10-30 00:00:00		2020-12-18 00:00:00		2020-12-18 00:00:00		2020-12-18 00:00:00		2021-01-29 00:00:00		2020-07-28 00:00:00		2020-12-18 00:00:00		2021-12-07 00:00:00		2021-04-27 00:00:00		2021-09-20 00:00:00		2022-03-04 00:00:00		2022-07-29 00:00:00		2022-05-04 00:00:00		2022-10-28 00:00:00		2022-10-28 00:00:00
from_date		2011-07-01 00:00:00		2011-04-01 00:00:00		2011-01-01 00:00:00		2011-10-01 00:00:00		2011-07-01 00:00:00		2011-10-01 00:00:00		2012-07-01 00:00:00		2012-01-01 00:00:00		2012-04-01 00:00:00		2013-07-01 00:00:00		2013-04-01 00:00:00		2012-10-01 00:00:00		2013-01-01 00:00:00		2013-04-01 00:00:00		2013-01-01 00:00:00		2013-10-01 00:00:00		2013-07-01 00:00:00		2014-07-01 00:00:00		2014-01-01 00:00:00		2014-01-01 00:00:00		2014-04-01 00:00:00		2015-01-01 00:00:00		2014-10-01 00:00:00		2015-07-01 00:00:00		2015-04-01 00:00:00		2016-04-01 00:00:00		2016-04-01 00:00:00		2015-10-01 00:00:00		2015-07-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		2016-10-01 00:00:00		2017-07-01 00:00:00		2017-07-01 00:00:00		2017-10-01 00:00:00		2018-04-01 00:00:00		2018-01-01 00:00:00		2017-04-01 00:00:00		2018-04-01 00:00:00		2017-04-01 00:00:00		2018-01-01 00:00:00		2019-01-01 00:00:00		2019-04-01 00:00:00		2018-07-01 00:00:00		2018-10-01 00:00:00		2018-07-01 00:00:00		2020-01-01 00:00:00		2019-10-01 00:00:00		2019-07-01 00:00:00		2019-07-01 00:00:00		2020-07-01 00:00:00		2019-01-01 00:00:00		2019-04-01 00:00:00		2019-10-01 00:00:00		2020-10-01 00:00:00		2020-04-01 00:00:00		2020-01-01 00:00:00		2021-07-01 00:00:00		2021-01-01 00:00:00		2021-04-01 00:00:00		2021-10-01 00:00:00		2022-04-01 00:00:00		2022-01-01 00:00:00		2022-07-01 00:00:00		2022-07-01 00:00:00
thru_date		2011-09-30 00:00:00		2011-06-30 00:00:00		2011-03-31 00:00:00		2011-12-31 00:00:00		2011-09-30 00:00:00		2011-12-31 00:00:00		2012-09-30 00:00:00		2012-03-31 00:00:00		2012-06-30 00:00:00		2013-09-30 00:00:00		2013-06-30 00:00:00		2012-12-31 00:00:00		2013-03-31 00:00:00		2013-06-30 00:00:00		2013-03-31 00:00:00		2013-12-31 00:00:00		2013-09-30 00:00:00		2014-09-30 00:00:00		2014-03-31 00:00:00		2014-03-31 00:00:00		2014-06-30 00:00:00		2015-03-31 00:00:00		2014-12-31 00:00:00		2015-09-30 00:00:00		2015-06-30 00:00:00		2016-06-30 00:00:00		2016-06-30 00:00:00		2015-12-31 00:00:00		2015-09-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		2016-12-31 00:00:00		2017-09-30 00:00:00		2017-09-30 00:00:00		2017-12-31 00:00:00		2018-06-30 00:00:00		2018-03-31 00:00:00		2017-06-30 00:00:00		2018-06-30 00:00:00		2017-06-30 00:00:00		2018-03-31 00:00:00		2019-03-31 00:00:00		2019-06-30 00:00:00		2018-09-30 00:00:00		2018-12-31 00:00:00		2018-09-30 00:00:00		2020-03-31 00:00:00		2019-12-31 00:00:00		2019-09-30 00:00:00		2019-09-30 00:00:00		2020-09-30 00:00:00		2019-03-31 00:00:00		2019-06-30 00:00:00		2019-12-31 00:00:00		2020-12-31 00:00:00		2020-06-30 00:00:00		2020-03-31 00:00:00		2021-09-30 00:00:00		2021-03-31 00:00:00		2021-06-30 00:00:00		2021-12-31 00:00:00		2022-06-30 00:00:00		2022-03-31 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00
cum_beg_dt		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2013-01-25 00:00:00		2013-01-25 00:00:00		2013-01-25 00:00:00		2013-01-25 00:00:00		2013-01-25 00:00:00		2014-01-01 00:00:00		2013-01-25 00:00:00		2013-01-25 00:00:00		2015-01-01 00:00:00		2013-01-25 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2017-01-01 00:00:00		2015-01-01 00:00:00		2017-01-01 00:00:00		2015-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2015-01-01 00:00:00		2017-01-01 00:00:00		2015-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2015-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2015-01-01 00:00:00		2019-01-01 00:00:00		2021-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2021-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2021-01-01 00:00:00
firm_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
firm_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
firm_city		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK
firm_st		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY
firm_zip4		10017		10017		10017		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036
firm_phon		2127634700		2127634700		2127634700		2129082600		2129082600		2129082600		2129082600		2129082600		2129082600		2129082600		2129082600		2129082600		2129082600		2129082600		2129082600		2129082600		2129082600		2129082600		2129082600		2129082600		2129082600		2129082720		2129082600		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720
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
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
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
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sig_date		2011-10-14 00:00:00		2011-07-22 00:00:00		2011-05-03 00:00:00		2012-01-31 00:00:00		2012-01-31 00:00:00		2012-01-18 00:00:00		2012-10-11 00:00:00		2012-04-20 00:00:00		2012-07-17 00:00:00		2013-10-15 00:00:00		2013-07-16 00:00:00		2013-04-19 00:00:00		2013-04-19 00:00:00		2013-11-19 00:00:00		2013-11-19 00:00:00		2014-01-15 00:00:00		2013-11-19 00:00:00		2014-10-28 00:00:00		2014-05-03 00:00:00		2014-06-13 00:00:00		2014-07-02 00:00:00		2015-04-21 00:00:00		2014-12-12 00:00:00		2015-10-26 00:00:00		2015-07-27 00:00:00		2016-10-04 00:00:00		2016-07-30 00:00:00		2016-02-03 00:00:00		2016-02-03 00:00:00		2016-03-24 00:00:00		2016-01-30 00:00:00		2016-10-27 00:00:00		2017-07-29 00:00:00		2017-05-01 00:00:00		2017-05-01 00:00:00		2017-01-31 00:00:00		2017-10-27 00:00:00		2017-11-17 00:00:00		2018-02-01 00:00:00		2018-10-11 00:00:00		2018-04-30 00:00:00		2017-11-17 00:00:00		2018-07-26 00:00:00		2017-11-08 00:00:00		2019-07-03 00:00:00		2019-04-16 00:00:00		2019-07-29 00:00:00		2018-10-30 00:00:00		2019-01-29 00:00:00		2019-01-29 00:00:00		2020-01-29 00:00:00		2020-01-29 00:00:00		2019-10-29 00:00:00		2020-12-18 00:00:00		2020-10-30 00:00:00		2020-12-18 00:00:00		2020-12-18 00:00:00		2020-12-18 00:00:00		2021-01-29 00:00:00		2020-07-28 00:00:00		2020-12-18 00:00:00		2021-12-07 00:00:00		2021-04-28 00:00:00		2021-09-30 00:00:00		2022-03-04 00:00:00		2022-07-29 00:00:00		2022-05-04 00:00:00		2022-10-28 00:00:00		2022-10-28 00:00:00
sig_loc		San Francisco, CA		San Francisco, CA		New York, NY		San Francisco		San Francisco		San Francisco		San Francisco		San Francisco		San Francisco		New York, NY		New York, NY		New York		San Francisco		New York		New York		New York		New York		New York, NY		New York, NY		New York		New York, NY		New York, NY		New York, NY		New York, NY		New York, NY		New York, NY		New York, NY		New York, NY		New York, NY		New York, NY		New York, NY		New York, NY		New York, NY		New York, New York		New York, New York		New York, NY		New York, NY		New York, NY		New York		New York, NY		New York		New York, NY		New York, NY		New York, NY		New York		New York, New York		New York		New York New York		New York		New York		New York		New York		New York		New York		New York		New York		New York		New York		New York		New York		New York		Broomfield		New York		New York		Denver		Broomfield		Broomfield		Broomfield		Broomfield
sig_naml		Sanchez		Sanchez		Sanchez		Sanchez		Sanchez		Sanchez		Borukhov		Sanchez		Sanchez		Ailey		Ailey		Ailey		Ailey		Ailey		Ailey		Ailey		Ailey		Moore		Moore		Moore		Moore		Moore		Moore		Moore		Moore		Pierre		Henry		Moore		Moore		Moore		Moore		Pierre		Jimenez		Jimenez		Jimenez		Henry		Henry		Jimenez		Henry		Jimenez		Henry		Jimenez		Jimenez		Jimenez		Henry		Jimenez		Henry		Henry		Henry		Henry		Henry		Henry		Henry		Henry		Henry		Henry		Henry		Henry		Henry		Henry		Henry		McClanahan		Henry		Henry		McClanahan		McClanahan		McClanahan		McClanahan		McClanahan
sig_namf		Jerald		Jerald		Jerald		Jerald		Jerald		Jerald		Anastasia		Jerald		Jerald		Asher		Asher		Asher		Asher		Asher		Asher		Asher		Asher		Mitzie		Mitzie		Mitzie		Mitzie		Mitzie		Mitzie		Mitzie		Mitzie		Mitzie		Kelly		Mitzie		Mitzie		Mitzie		Mitzie		Mitzie		Oliver		Oliver		Oliver		Kelly		Kelly		Oliver		Kelly		Oliver		Kelly		Oliver		Oliver		Oliver		Kelly		Oliver		Kelly		Kelly		Kelly		Kelly		Kelly		Kelly		Kelly-Marie		Kelly		Kelly		Kelly		Kelly		Kelly		Kelly		Kelly		Kelly		Tara		Kelly		Kelly		Tara		Tara		Tara		Tara		Tara
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		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None
prn_naml		Sanchez		Sanchez		Sanchez		Sanchez		Sanchez		Sanchez		Borukhov		Sanchez		Sanchez		Ailey		Ailey		Ailey		Ailey		Ailey		Ailey		Ailey		Ailey		Moore		Moore		Moore		Moore		Moore		Moore		Moore		Moore		Pierre		Henry		Moore		Moore		Moore		Moore		Pierre		Jimenez		Jimenez		Jimenez		Henry		Henry		Jimenez		Henry		Jimenez		Henry		Jimenez		Jimenez		Jimenez		Henry		Jimenez		Henry		Henry		Henry		Henry		Henry		Henry		Henry		Henry		Henry		Henry		Henry		Henry		Henry		Henry		Henry		McClanahan		Henry		Henry		McClanahan		McClanahan		McClanahan		McClanahan		McClanahan
prn_namf		Jerald		Jerald		Jerald		Jerald		Jerald		Jerald		Anastasia		Jerald		Jerald		Asher		Asher		Asher		Asher		Asher		Asher		Asher		Asher		Mitzie		Mitzie		Mitzie		Mitzie		Mitzie		Mitzie		Mitzie		Mitzie		Mitzie		Kelly		Mitzie		Mitzie		Mitzie		Mitzie		Mitzie		Oliver		Oliver		Oliver		Kelly		Kelly		Oliver		Kelly		Oliver		Kelly		Oliver		Oliver		Oliver		Kelly		Oliver		Kelly		Kelly		Kelly		Kelly		Kelly		Kelly		Kelly-Marie		Kelly		Kelly		Kelly		Kelly		Kelly		Kelly		Kelly		Kelly		Tara		Kelly		Kelly		Tara		Tara		Tara		Tara		Tara
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		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sig_title		Chief Compliance Officer		Chief Compliance Officer		Chief Compliance Officer		Chief Compliance Officer		Chief Compliance Officer		Chief Compliance Officer		Compliance Officer		Chief Compliance Officer		Chief Compliance Officer		Chief Compliance Officer		Chief Compliance Officer		Chief Compliance Officer		Chief Compliance Officer		Chief Compliance Officer		Chief Compliance Officer		Chief Compliance Officer		Chief Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		CCO		CCO		CCO		Compliance Officer		Compliance Officer		compliance officer		Compliance Officer		Compliance Officer		Compliance Officer		compliance officer		Compliance Officer		CCO		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer
nopart1_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
nopart2_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
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		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None
ctrib_n_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		X		X		X		X		X		X		X		X		X		X		None		None		X		X
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		None		None		None		None		None		None		None		None		None		None		X		X		None		None
lby_actvty		None		CalPERS		CalPERS		NONE		NONE		None		NONE		NONE		NONE		NONE		NONE		NONE		NONE		NONE		NONE		NONE		NONE		None		None		None		None		California Public Employees' Retirement System (CalPERS) California State Teachers' Retirement System (CalSTRS)		None		California Public Employees' Retirement System (CalPERS), CalSTRS, UC Regents		California Public Employees' Retirement System (CalPERS), UC Regents		California Public Employees' Retirement System (CalPERS), CalSTRS		California Public Employees' Retirement System (CalPERS), CalSTRS		California Public Employees' Retirement System (CalPERS), CalSTRS		California Public Employees' Retirement System (CalPERS), CalSTRS, UC Regents		California Public Employees' Retirement System (CalPERS), CalSTRS		California Public Employees' Retirement System (CalPERS), CalSTRS		CalSTRS		CalSTRS University of California		CalSTRS		CalSTRS		CalSTRS		CalSTRS University of California		CalSTRS University of California UC Regents		CalSTRS University of California UC Regents		CalSTRS CalPERS UC Regents		CalSTRS CalPERS		CalSTRS University of California UC Regents		CalSTRS CalPERS UC Regents		CalSTRS University of California		CalSTRS CalPERS		CalSTRS, CalPERS, UC Regents		CalSTRS, CalPERS		CalSTRS, CalPERS, UC Regents		CalSTRS, CalPERS, UC Regents		CalSTRS, CalPERS, UC Regents		CalSTRS		CalSTRS, CalPERS		CalSTRS, CalPERS		CalSTRS, CalPERS		CalSTRS, CalPers		CalSTRS, CalPERS, UC Regents		CalSTRS, CalPERS		CalSTRS, CalPERS		CalSTRS, CalPers		CalSTRS		CalSTRS		N/A		None		None		N/A		Nothing to report.		N/A		CalPERS and CalSTRS		CalPERS and CalSTRS
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		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		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		None		None		None		None		None		None		None		None		None		None		N/A		N/A		N/A		N/A
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		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		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		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		None		None		None		None		None		None		None		None		None		None		N/A		N/A		N/A		N/A
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		None		None		None		None		None		None		None		None		None		None		N/A		N/A		N/A		N/A

Table: cvr_registration

filing_id		1714850		1914902		2104141		2104141		2104141		2104141		2104141		2198178		2198178		2198178		2198178		2198178		2198178		2198178		2198178		2536593		2536593		2631759		2536593
amend_id		0		0		1		0		4		2		3		0		1		2		3		4		5		7		6		0		1		0		2
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F603		F603		F603		F603		F603		F603		F603		F603		F603		F603		F603		F603		F603		F603		F603		F603		F603		F606		F603
sender_id		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849
filer_id		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849
entity_cd		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LBY		LEM
filer_naml		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.
filer_namf		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
filer_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
report_num		000		000		001		000		004		002		003		000		001		002		003		004		005		007		006		000		001		000		002
rpt_date		2012-11-26 00:00:00		2014-11-13 00:00:00		2016-12-06 00:00:00		2016-11-03 00:00:00		2017-04-28 00:00:00		2017-03-24 00:00:00		2017-03-28 00:00:00		2017-12-12 00:00:00		2017-12-14 00:00:00		2018-03-27 00:00:00		2018-03-27 00:00:00		2018-03-28 00:00:00		2018-08-31 00:00:00		2019-12-18 00:00:00		2019-04-23 00:00:00		2020-12-11 00:00:00		2020-12-18 00:00:00		2021-12-23 00:00:00		2021-12-23 00:00:00
ls_beg_yr		2013		2015		2017		2017		2017		2017		2017		2019		2019		2019		2019		2019		2019		2019		2019		2021		2021		2021		2021
ls_end_yr		2014		2016		2018		2018		2018		2018		2018		2020		2020		2020		2020		2020		2020		2020		2020		2022		2022		2022		2022
qual_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
eff_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2021-06-30 00:00:00		None
bus_city		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		BROOMFIELD		NEW YORK
bus_st		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		CO		NY
bus_zip4		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		10036		80021		10036
bus_phon		2129082600		2129082720		2129082755		2129082720		2129082755		2129082755		2129082755		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		2129082720		None		2129082720
bus_fax		2127634701		2129082601		2129082601		2129082601		2129082601		2129082601		2129082601		2129082601		2129082601		2129082601		2129082601		2129082601		2129082601		2129082601		2129082601		2129082601		2129082601		None		2129082601
bus_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]		None		[email protected]
mail_city		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
mail_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
mail_phon		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sig_date		2012-11-26 00:00:00		2014-11-14 00:00:00		2016-12-06 00:00:00		2016-11-03 00:00:00		2017-04-28 00:00:00		2016-12-06 00:00:00		2017-03-28 00:00:00		2017-12-12 00:00:00		2017-12-14 00:00:00		2018-03-27 00:00:00		2018-03-27 00:00:00		2018-03-28 00:00:00		2018-08-31 00:00:00		2901-12-18 00:00:00		2019-04-16 00:00:00		2020-12-11 00:00:00		2020-12-18 00:00:00		2021-12-23 00:00:00		2021-12-23 00:00:00
sig_loc		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sig_naml		Lindberg		Moore		Jimenez		Pierre		Jimenez		Jimenez		Jimenez		Jimenez		Jimenez		Jimenez		Jimenez		Jimenez		Jimenez		Henry		Jimenez		Henry		Henry		McClanahan		McClanahan
sig_namf		Brooks		Mitzie		Oliver		Mitzie		Oliver		Oliver		Oliver		Oliver		Oliver		Oliver		Oliver		Oliver		Oliver		Kelly		Oliver		Kelly		Kelly		Tara		Tara
sig_namt		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
prn_naml		Lindberg		Moore		Jimenez		Pierre		Jimenez		Jimenez		Jimenez		Jimenez		Jimenez		Jimenez		Jimenez		Jimenez		Jimenez		Henry		Jimenez		Henry		Henry		McClanahan		McClanahan
prn_namf		Brooks		Mitzie		Oliver		Mitzie		Oliver		Oliver		Oliver		Oliver		Oliver		Oliver		Oliver		Oliver		Oliver		Kelly		Oliver		Kelly		Kelly		Tara		Tara
prn_namt		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
sig_title		Vice President		Compliance Officer		CCO		Compliance Officer		CCO		CCO		CCO		Compliance Officer		CCO		CCO		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer		CCO		Compliance Officer		Compliance Officer		Compliance Officer		Compliance Officer
stmt_firm		None		None		None		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		None		None		None
bus_cb		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		None		X
trade_cb		None		None		None		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		None		None		None
a_b_name		None		None		None		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		None		None		None
a_b_st		None		None		None		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		None		None		None
descrip_1		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
descrip_2		Investment Management Services		Investment management services		Investment management services		Investment management services		Investment management services		Investment management services		Investment management services		Investment Management Services		Investment Management Services		Investment Management Services		Investment Management Services		Investment Management Services		Investment Management Services		Investment Management Services		Investment Management Services		Asset management		Asset management		None		Asset management
c_less50		None		None		None		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		None		None		None
ind_class		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		OTH		OTH		None		OTH
ind_descr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Investment management private equity		Investment management private equity		None		Investment management private equity
bus_class		FIN		FIN		FIN		FIN		FIN		FIN		FIN		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		None		None		None		None
bus_descr		None		None		None		None		None		None		None		Partners Group is a private fund investment manager		Partners Group is a private fund investment manager		Partners Group is a private fund investment manager		Partners Group is a private fund investment manager		Partners Group is a private fund investment manager		Partners Group is a private fund investment manager		Partners Group is a private fund investment manager		Partners Group is a private fund investment manager		None		None		None		None
auth_name		None		None		None		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		None		None		None
auth_st		None		None		None		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		None		None		None
lobby_int		Investment management services		None		None		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		None		None		None
firm_name		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
newcert_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rencert_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
complet_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
lby_reg_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
lby_604_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
st_leg_yn		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
st_agency		None		None		None		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		None		None		None
l_firm_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filer_address

filer_id		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849
adrid		2209387		2221955		2413610		2272376		2467004		2545832		2337617		2505509
effect_dt		2011-01-01 00:00:00		2011-09-30 00:00:00		2017-01-01 00:00:00		2013-01-25 00:00:00		2019-01-01 00:00:00		2023-01-01 00:00:00		2015-01-01 00:00:00		2021-01-01 00:00:00
add_type		7051		7051		7051		7051		7051		7051		7051		7051
session_id		2011		2011		2017		2013		2019		2023		2015		2021

Table: filer_filings

filer_id		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849
filing_id		1959844		1970976		1977465		1860835		1858210		1776912		1776912		1759987		1794233		1794233		1810319		1920954		1907129		1558022		1592422		1602488		1629241		1617556		1629241		1617943		1617556		1616663		1653319		1672050		1697518		1914902		1918073		1714850		1858210		1759942		1759987		1759115		1994160		2227549		2373705		2417130		2316722		2342725		2173549		2482062		2241620		1994160		2022972		2011754		2011754		2061144		2061144		2104141		2110272		2097200		2129294		2104141		2104141		2104141		2154346		2154366		2173549		2129294		2104141		2157632		2269899		2387231		2198178		2316722		2528444		2395451		2198178		2198178		2191385		2198178		2536593		2536593		2551264		2427172		2241620		2373705		2395451		2437735		2199291		2198178		2469123		2212492		2198178		2417130		2337484		2173549		2191385		2469123		2269899		2198178		2198178		2661740		2655232		2612088		2679314		2630336		2704311		2437735		2635968		2694329		2639012		2577776		2536593		2631759		2585985		2744986		2744986
period_id		221		None		222		218		217		214		214		213		215		215		216		None		219		None		205		206		208		207		208		None		207		None		209		210		211		220		220		212		217		212		213		None		223		None		237		239		235		236		230		242		233		223		225		224		224		226		226		228		None		227		228		228		229		230		None		None		230		228		229		229		234		None		238		235		243		238		233		233		231		232		244		244		244		None		233		237		238		240		None		233		241		232		232		239		None		230		231		241		234		235		240		None		248		246		249		247		250		240		None		None		None		245		248		248		None		251		251
form_id		F635		F605		F635		F635		F635		F635		F635		F635		F635		F635		F635		F603		F635		F603		F635		F635		F635		F635		F635		F605		F635		F605		F635		F635		F635		F603		F635		F603		F635		F635		F635		F603		F635		F605		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F603		F603		F635		F635		F603		F603		F603		F605		F603		F635		F635		F603		F635		F635		F605		F603		F635		F635		F635		F603		F603		F635		F603		F603		F603		F635		F605		F635		F635		F635		F635		F605		F603		F635		F635		F603		F635		F603		F635		F635		F635		F635		F603		F603		F605		F635		F635		F635		F635		F635		F635		F605		F605		F603		F635		F603		F606		F603		F635		F635
filing_sequence		0		0		0		0		1		0		1		1		1		0		0		0		0		0		0		0		0		1		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		1		0		0		1		0		1		0		0		0		0		1		2		4		0		0		0		1		3		0		0		0		6		1		0		0		2		3		1		0		0		1		0		0		1		1		1		0		0		4		1		0		1		1		0		2		0		0		1		5		7		0		0		0		0		0		0		1		0		0		0		0		2		0		0		0		1
filing_date		2015-04-21 00:00:00		2015-06-15 00:00:00		2015-07-27 00:00:00		2014-07-02 00:00:00		2014-06-13 00:00:00		2013-07-22 00:00:00		2013-11-19 00:00:00		2013-11-19 00:00:00		2013-11-19 00:00:00		2013-10-15 00:00:00		2014-01-15 00:00:00		2014-12-01 00:00:00		2014-10-28 00:00:00		2011-01-05 00:00:00		2011-05-03 00:00:00		2011-07-22 00:00:00		2012-01-18 00:00:00		2012-01-31 00:00:00		2012-01-31 00:00:00		2011-10-04 00:00:00		2011-10-14 00:00:00		2011-09-09 00:00:00		2012-04-20 00:00:00		2012-07-17 00:00:00		2012-10-11 00:00:00		2014-11-13 00:00:00		2014-12-12 00:00:00		2012-11-26 00:00:00		2014-06-03 00:00:00		2013-04-19 00:00:00		2013-04-19 00:00:00		2013-01-25 00:00:00		2015-10-26 00:00:00		2018-04-02 00:00:00		2019-04-16 00:00:00		2019-10-29 00:00:00		2018-10-30 00:00:00		2019-01-29 00:00:00		2017-11-08 00:00:00		2020-07-28 00:00:00		2018-04-30 00:00:00		2016-02-04 00:00:00		2016-03-24 00:00:00		2016-02-01 00:00:00		2016-02-04 00:00:00		2016-07-29 00:00:00		2016-10-04 00:00:00		2016-11-03 00:00:00		2016-12-05 00:00:00		2016-10-27 00:00:00		2017-01-31 00:00:00		2016-12-06 00:00:00		2017-03-24 00:00:00		2017-04-28 00:00:00		2017-04-25 00:00:00		2017-04-03 00:00:00		2017-07-28 00:00:00		2017-05-01 00:00:00		2017-03-28 00:00:00		2017-05-01 00:00:00		2018-07-26 00:00:00		2019-06-03 00:00:00		2019-04-23 00:00:00		2019-01-29 00:00:00		2020-10-30 00:00:00		2019-07-29 00:00:00		2018-03-27 00:00:00		2018-03-27 00:00:00		2017-11-14 00:00:00		2017-12-12 00:00:00		2020-12-11 00:00:00		2020-12-18 00:00:00		2021-01-29 00:00:00		2019-12-27 00:00:00		2018-07-03 00:00:00		2020-12-18 00:00:00		2020-12-18 00:00:00		2020-01-29 00:00:00		2017-12-26 00:00:00		2018-03-28 00:00:00		2020-12-18 00:00:00		2018-02-01 00:00:00		2017-12-14 00:00:00		2020-12-18 00:00:00		2018-12-18 00:00:00		2017-11-14 00:00:00		2017-10-27 00:00:00		2020-04-29 00:00:00		2018-10-11 00:00:00		2018-08-31 00:00:00		2019-12-18 00:00:00		2022-03-21 00:00:00		2022-03-04 00:00:00		2021-09-20 00:00:00		2022-05-04 00:00:00		2021-12-07 00:00:00		2022-07-29 00:00:00		2020-12-18 00:00:00		2022-01-04 00:00:00		2022-05-31 00:00:00		2022-01-24 00:00:00		2021-04-27 00:00:00		2021-12-23 00:00:00		2021-12-23 00:00:00		2021-01-21 00:00:00		2022-10-28 00:00:00		2022-10-28 00:00:00
stmnt_type		10001		10006		10001		10001		10002		10001		10002		10002		10002		10001		10001		10005		10001		10005		10001		10001		10001		10002		10002		10006		10001		10006		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10005		10001		10001		10001		10001		10002		10001		10001		10002		10001		10001		10002		10001		10002		10001		10005		10001		10001		10002		10002		10002		10005		10005		10001		10002		10002		10001		10001		10005		10002		10002		10001		10001		10002		10002		10002		10001		10001		10002		10001		10005		10002		10002		10002		10001		10005		10002		10002		10001		10002		10002		10005		10002		10002		10001		10002		10002		10002		10002		10001		10001		10001		10001		10001		10002		10002		10002		10005		10001		10002		10001		10005		10001		10002
stmnt_status		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		11001		11001		11001		11003		11001		11003		11001		11003		11003		11001		11001		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11003		11001		11003		11003		11001		11001		11001		11001		11003		11003		11001		11003		11003
session_id		2015		2015		2015		2013		2013		2013		2013		2013		2013		2013		2013		2015		2013		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2015		2013		2013		2013		2011		2013		2013		2015		2017		2019		2019		2017		2017		2017		2019		2017		2015		2015		2015		2015		2015		2015		2017		2017		2015		2015		2017		2017		2017		2017		2017		2017		2015		2017		2017		2017		2017		2019		2017		2019		2019		2019		2019		2017		2019		2021		2021		2019		2019		2017		2019		2019		2019		2017		2019		2019		2017		2019		2019		2019		2017		2017		2019		2017		2019		2019		2021		2021		2021		2021		2021		2021		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		AGLADNEY		YRODRIGU		AGLADNEY		AGLADNEY		RGEREMIA		AGLADNEY		AGLADNEY		AGLADNEY		ASAETERN		ASAETERN		ASAETERN		GKURIMOT		AGLADNEY		CFLAGG		AGLADNEY		AGLADNEY		ASAETERN		AGLADNEY		ASAETERN		CFLAGG		ASAETERN		YRODRIGU		AGLADNEY		ASAETERN		AGLADNEY		YRODRIGU		AGLADNEY		YRODRIGU		RGEREMIA		RGEREMIA		AGLADNEY		SARRIAGA		AGLADNEY		GPEREZ		VUKSTINA		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		MKIRKHAM		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		PBANFORD		GPEREZ		AGLADNEY		AGLADNEY		PBANFORD		GPEREZ		YRODRIGU		GPEREZ		GPEREZ		AGLADNEY		AGLADNEY		GPEREZ		AGLADNEY		AGLADNEY		GPEREZ		CAFILER		AGLADNEY		MKIRKHAM		AGLADNEY		GPEREZ		GPEREZ		AGLADNEY		GPEREZ		JMENDOZA		CAFILER		MKIRKHAM		SARRIAGA		AGLADNEY		CAFILER		CAFILER		GTAYLOR		GPEREZ		GPEREZ		CAFILER		KBANH		GPEREZ		CAFILER		SARRIAGA		AGLADNEY		AGLADNEY		GTAYLOR		AGLADNEY		CAFILER		CAFILER		CVANLIEW		CHATRIDGE		AROJAS		LPHEAV		LPHEAV		CAFILER		CAFILER		MMERCHANT		CVANLIEW		JMENDOZA		GTAYLOR		CAFILER		CAFILER		JMENDOZA		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
fine_audit		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		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11003		11003		11001		11001		11003		11001		11001		11003		11003		11001		11001		11001		11003		11003		11001		11003		11003		11003		11001		11003		11001		11003		11003		11001		11003		11003		11003		11001		11003		11003		11003		11001		11001		11001		11001		11003		11003		11003		11001		11001		11001		11001		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003
rpt_start		2015-01-01 00:00:00		1900-01-01 00:00:00		2015-04-01 00:00:00		2014-04-01 00:00:00		2014-01-01 00:00:00		2013-04-01 00:00:00		2013-04-01 00:00:00		2013-01-01 00:00:00		2013-07-01 00:00:00		2013-07-01 00:00:00		2013-10-01 00:00:00		1900-01-01 00:00:00		2014-07-01 00:00:00		1900-01-01 00:00:00		2011-01-01 00:00:00		2011-04-01 00:00:00		2011-10-01 00:00:00		2011-07-01 00:00:00		2011-10-01 00:00:00		1900-01-01 00:00:00		2011-07-01 00:00:00		1900-01-01 00:00:00		2012-01-01 00:00:00		2012-04-01 00:00:00		2012-07-01 00:00:00		2014-11-13 00:00:00		2014-10-01 00:00:00		2012-11-26 00:00:00		2014-01-01 00:00:00		2012-10-01 00:00:00		2013-01-01 00:00:00		1900-01-01 00:00:00		2015-07-01 00:00:00		1900-01-01 00:00:00		2019-01-01 00:00:00		2019-07-01 00:00:00		2018-07-01 00:00:00		2018-10-01 00:00:00		2017-04-01 00:00:00		2020-04-01 00:00:00		2018-01-01 00:00:00		2015-07-01 00:00:00		2016-01-01 00:00:00		2015-10-01 00:00:00		2015-10-01 00:00:00		2016-04-01 00:00:00		2016-04-01 00:00:00		2016-11-03 00:00:00		1900-01-01 00:00:00		2016-07-01 00:00:00		2016-10-01 00:00:00		2016-12-06 00:00:00		2017-03-24 00:00:00		2017-04-28 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2017-04-01 00:00:00		2016-10-01 00:00:00		2017-03-28 00:00:00		2017-01-01 00:00:00		2018-04-01 00:00:00		1900-01-01 00:00:00		2019-04-23 00:00:00		2018-07-01 00:00:00		2020-07-01 00:00:00		2019-04-01 00:00:00		2018-03-27 00:00:00		2018-03-27 00:00:00		2017-07-01 00:00:00		2017-12-12 00:00:00		2020-12-11 00:00:00		2020-12-18 00:00:00		2020-10-01 00:00:00		1900-01-01 00:00:00		2018-01-01 00:00:00		2019-01-01 00:00:00		2019-04-01 00:00:00		2019-10-01 00:00:00		1900-01-01 00:00:00		2018-03-28 00:00:00		2020-01-01 00:00:00		2017-10-01 00:00:00		2017-12-14 00:00:00		2019-07-01 00:00:00		1900-01-01 00:00:00		2017-04-01 00:00:00		2017-07-01 00:00:00		2020-01-01 00:00:00		2018-04-01 00:00:00		2018-08-31 00:00:00		2019-12-18 00:00:00		1900-01-01 00:00:00		2021-10-01 00:00:00		2021-04-01 00:00:00		2022-01-01 00:00:00		2021-07-01 00:00:00		2022-04-01 00:00:00		2019-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2021-01-01 00:00:00		2021-12-23 00:00:00		2021-12-23 00:00:00		1900-01-01 00:00:00		2022-07-01 00:00:00		2022-07-01 00:00:00
rpt_end		2015-03-31 00:00:00		1900-01-01 00:00:00		2015-06-30 00:00:00		2014-06-30 00:00:00		2014-03-31 00:00:00		2013-06-30 00:00:00		2013-06-30 00:00:00		2013-03-31 00:00:00		2013-09-30 00:00:00		2013-09-30 00:00:00		2013-12-31 00:00:00		1900-01-01 00:00:00		2014-09-30 00:00:00		1900-01-01 00:00:00		2011-03-31 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2011-09-30 00:00:00		2011-12-31 00:00:00		1900-01-01 00:00:00		2011-09-30 00:00:00		1900-01-01 00:00:00		2012-03-31 00:00:00		2012-06-30 00:00:00		2012-09-30 00:00:00		2014-11-13 00:00:00		2014-12-31 00:00:00		2012-11-26 00:00:00		2014-03-31 00:00:00		2012-12-31 00:00:00		2013-03-31 00:00:00		1900-01-01 00:00:00		2015-09-30 00:00:00		1900-01-01 00:00:00		2019-03-31 00:00:00		2019-09-30 00:00:00		2018-09-30 00:00:00		2018-12-31 00:00:00		2017-06-30 00:00:00		2020-06-30 00:00:00		2018-03-31 00:00:00		2015-09-30 00:00:00		2016-03-31 00:00:00		2015-12-31 00:00:00		2015-12-31 00:00:00		2016-06-30 00:00:00		2016-06-30 00:00:00		2016-11-03 00:00:00		1900-01-01 00:00:00		2016-09-30 00:00:00		2016-12-31 00:00:00		2016-12-06 00:00:00		2017-03-24 00:00:00		2017-04-28 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2017-06-30 00:00:00		2016-12-31 00:00:00		2017-03-28 00:00:00		2017-03-31 00:00:00		2018-06-30 00:00:00		1900-01-01 00:00:00		2019-04-23 00:00:00		2018-09-30 00:00:00		2020-09-30 00:00:00		2019-06-30 00:00:00		2018-03-27 00:00:00		2018-03-27 00:00:00		2017-09-30 00:00:00		2017-12-12 00:00:00		2020-12-11 00:00:00		2020-12-18 00:00:00		2020-12-31 00:00:00		1900-01-01 00:00:00		2018-03-31 00:00:00		2019-03-31 00:00:00		2019-06-30 00:00:00		2019-12-31 00:00:00		1900-01-01 00:00:00		2018-03-28 00:00:00		2020-03-31 00:00:00		2017-12-31 00:00:00		2017-12-14 00:00:00		2019-09-30 00:00:00		1900-01-01 00:00:00		2017-06-30 00:00:00		2017-09-30 00:00:00		2020-03-31 00:00:00		2018-06-30 00:00:00		2018-08-31 00:00:00		2019-12-18 00:00:00		1900-01-01 00:00:00		2021-12-31 00:00:00		2021-06-30 00:00:00		2022-03-31 00:00:00		2021-09-30 00:00:00		2022-06-30 00:00:00		2019-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2021-03-31 00:00:00		2021-12-23 00:00:00		2021-12-23 00:00:00		1900-01-01 00:00:00		2022-09-30 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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filing_type		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		None		22006		22006		22006		22006		22006		None		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		None		None		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		None		None		None		22006		22006		22006		None		22006		22006

Table: filer_interests

filer_id		1334849		1334849		1334849		1334849		1334849		1334849		1334849
session_id		2013		2011		2017		2021		2015		2019		2023
interest_cd		40304		40304		40304		40312		40304		40312		40312
effect_date		2013-01-25 00:00:00		2011-01-01 00:00:00		2017-01-01 00:00:00		2021-01-01 00:00:00		2015-01-01 00:00:00		2019-01-01 00:00:00		2023-01-01 00:00:00

Table: filer_to_filer_type

filer_id		1334849		1334849		1334849		1334849		1334849		1334849		1334849
filer_type		2		2		2		2		2		2		2
active		Y		Y		Y		Y		Y		Y		N
race		0		None		None		None		None		None		None
session_id		2011		2013		2019		2015		2017		2021		2023
category		0		None		None		None		None		None		None
category_type		0		None		None		None		None		None		None
sub_category		0		None		None		None		None		None		None
effect_dt		2011-01-01 00:00:00		2013-01-25 00:00:00		2019-01-01 00:00:00		2015-01-01 00:00:00		2017-01-01 00:00:00		2021-01-01 00:00:00		2023-01-01 00:00:00
sub_category_type		0		None		None		None		None		None		None
election_type		0		None		None		None		None		None		None
sub_category_a		None		None		None		None		None		None		None
nyq_dt		None		None		None		None		None		None		None
party_cd		0		None		None		None		None		None		None
county_cd		0		None		None		None		None		None		None
district_cd		0		None		None		None		None		None		None

Table: filer_xref

filer_id		1334849
xref_id		1334849
effect_dt		2011-01-07 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849
filer_id		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849
filer_type		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER
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
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
naml		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.
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
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
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
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
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
city		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK
st		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY
zip4		10017		10036		10036		10036		10036		10036		10036		10036		10017		10036		10036		10036		10036		10036		10036		10036		10017		10036		10036		10036		10036		10036		10036		10036		10017		10036		10036		10036		10036		10036		10036		10036		10017		10036		10036		10036		10036		10036		10036		10036		10017		10036		10036		10036		10036		10036		10036		10036		10017		10036		10036		10036		10036		10036		10036		10036
phon		2127634700		2129082600		2129082600		2129082720		2129082720		2129082720		2129082720		2129082720		2127634700		2129082600		2129082600		2129082720		2129082720		2129082720		2129082720		2129082720		2127634700		2129082600		2129082600		2129082720		2129082720		2129082720		2129082720		2129082720		2127634700		2129082600		2129082600		2129082720		2129082720		2129082720		2129082720		2129082720		2127634700		2129082600		2129082600		2129082720		2129082720		2129082720		2129082720		2129082720		2127634700		2129082600		2129082600		2129082720		2129082720		2129082720		2129082720		2129082720		2127634700		2129082600		2129082600		2129082720		2129082720		2129082720		2129082720		2129082720
fax		2127634701		2127634701		2127634701		2129082601		2129082601		2129082601		2129082601		2129082601		2127634701		2127634701		2127634701		2129082601		2129082601		2129082601		2129082601		2129082601		2127634701		2127634701		2127634701		2129082601		2129082601		2129082601		2129082601		2129082601		2127634701		2127634701		2127634701		2129082601		2129082601		2129082601		2129082601		2129082601		2127634701		2127634701		2127634701		2129082601		2129082601		2129082601		2129082601		2129082601		2127634701		2127634701		2127634701		2129082601		2129082601		2129082601		2129082601		2129082601		2127634701		2127634701		2127634701		2129082601		2129082601		2129082601		2129082601		2129082601
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]

Table: filers

filer_id		1334849

Table: lobbying_chg_log

filer_id		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849
change_no		1		3		2		4		5		6		7		0		8
session_id		2011		2013		2013		2017		2017		2017		2017		2017		2017
log_dt		2011-09-09 00:00:00		2013-01-25 00:00:00		2013-01-25 00:00:00		2016-12-05 00:00:00		2017-04-03 00:00:00		2017-04-03 00:00:00		2017-12-26 00:00:00		2017-12-26 00:00:00		2019-06-03 00:00:00
filer_type		2		2		2		2		2		2		2		2		2
correction_flg		Y		Y		Y		None		None		None		None		Y		None
action		ADDED		ADDED		ADDED		SET ACTIVE		SET ACTIVE		IN SUSPENSE		SET ACTIVE		ADDED		DELETED
attribute_changed		LOBBYIST		LOBBYIST		LOBBYIST				LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST
ethics_dt		None		None		None		None		None		None		None		None		None
interests		None		None		None		None		None		None		None		None		None
filer_full_name		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.		PARTNERS GROUP (USA) INC.
filer_city		None		NEW YORK		NEW YORK		None		None		None		None		None		None
filer_st		None		NY		NY		None		None		None		None		None		None
filer_zip		None		10036		10036		None		None		None		None		None		None
filer_phone		None		2129082600		2129082600		None		None		None		None		None		None
entity_type		4		4		4		2		4		4		4		4		4
entity_name		MOEN, STEVEN R.		MOEN, STEVEN R.		HUNTER, DAVID R.		None		MOEN, STEVEN R.		MOEN, STEVEN R.		OSBORN, KYLE R.		OSBORN, KYLE R.		DAVID R. HUNTER
entity_city		None		None		None		None		None		None		None		None		None
entity_st		None		None		None		None		None		None		None		None		None
entity_zip		None		None		None		None		None		None		None		None		None
entity_phone		None		None		None		None		None		None		None		None		None
entity_id		1340711		None		None		0		1340711		1340711		1400981		1400981		1334852
responsible_officer		None		None		None		None		None		None		None		None		None
effect_dt		2011-07-21 00:00:00		2013-01-25 00:00:00		2013-01-25 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-07-01 00:00:00		2017-12-15 00:00:00		2017-12-15 00:00:00		2017-12-29 00:00:00

Table: received_filings

filer_id		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849		1334849
filing_file_name		152249.cal		232075.cal		232267.cal		190929.cal		191069.cal		85535.cal		85604.cal		85685.cal		104668.cal		104861.cal		220235.cal		263548.cal		263853.cal		502598.cal		502648.cal		502679.cal		502789.cal		502820.cal		503128.cal		503200.cal		503222.cal		271158.cal		271497.cal
received_date		2017-04-24 00:00:00		2017-04-27 00:00:00		2017-04-27 00:00:00		2017-04-26 00:00:00		2017-04-26 00:00:00		2017-04-20 00:00:00		2017-04-20 00:00:00		2017-04-20 00:00:00		2017-04-21 00:00:00		2017-04-21 00:00:00		2017-04-27 00:00:00		2017-04-28 00:00:00		2017-04-28 00:00:00		2017-04-13 00:00:00		2017-04-13 00:00:00		2017-04-13 00:00:00		2017-04-13 00:00:00		2017-04-13 00:00:00		2017-04-13 00:00:00		2017-04-13 00:00:00		2017-04-13 00:00:00		2017-04-28 00:00:00		2017-04-28 00:00:00
filing_directory		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp
filing_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
form_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
receive_comment		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation