Home

Filer ID: 1335099

Table: cvr_lobby_disclosure

filing_id		1621797		1599443		1599443		1585310		1626751		1626751		1650472		1678458		1650472		1650472		1716433		1723931		1792658		1780301		1761658		1811982		1890987		1836370		1863590		1811982		1863590		1836370		1924012		1990231		1973620		1957122		2006543		2058364		2084357		2025367		2117488		2166396		2166396		2152541		2187565		2200361		2234169		2200361		2305978		2264266		2370321		2389805		2331485		2430212		2413328		2413328		2465726		2430212		2465726		2549307		2479548		2524943		2479548		2596076		2578831		2634069		2620750		2674401		2697792		2743995
amend_id		0		1		0		0		0		1		1		0		0		2		0		0		0		0		0		0		0		1		1		1		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		1		0		0		0		0		0		0		1		0		0		1		1		0		1		0		0		0		0		0		0		0		0		0
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
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
sender_id		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099
filer_id		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099
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
filer_naml		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS 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
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
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
report_num		000		001		000		000		000		001		001		000		000		002		000		000		000		000		000		000		000		001		001		001		000		000		000		000		000		000		000		000		000		000		000		001		000		000		000		000		000		001		000		000		000		000		000		000		001		000		000		001		001		000		001		000		000		000		000		000		000		000		000		000
rpt_date		2011-10-31 00:00:00		2011-09-23 00:00:00		2011-07-11 00:00:00		2011-04-07 00:00:00		2012-01-05 00:00:00		2012-01-05 00:00:00		2012-05-15 00:00:00		2012-07-31 00:00:00		2012-04-04 00:00:00		2012-05-15 00:00:00		2012-12-07 00:00:00		2013-01-10 00:00:00		2013-10-03 00:00:00		2013-07-30 00:00:00		2013-04-25 00:00:00		2014-01-22 00:00:00		2014-10-02 00:00:00		2014-08-07 00:00:00		2014-08-07 00:00:00		2014-08-07 00:00:00		2014-07-16 00:00:00		2014-04-07 00:00:00		2015-01-08 00:00:00		2015-10-01 00:00:00		2015-07-09 00:00:00		2015-04-09 00:00:00		2016-01-25 00:00:00		2016-07-26 00:00:00		2016-10-03 00:00:00		2016-04-01 00:00:00		2017-01-05 00:00:00		2017-07-18 00:00:00		2017-07-11 00:00:00		2017-04-24 00:00:00		2017-10-12 00:00:00		2018-01-05 00:00:00		2018-04-23 00:00:00		2018-01-17 00:00:00		2018-10-12 00:00:00		2018-07-13 00:00:00		2019-04-04 00:00:00		2019-07-12 00:00:00		2019-01-02 00:00:00		2020-01-14 00:00:00		2019-10-17 00:00:00		2019-10-16 00:00:00		2020-04-14 00:00:00		2020-07-08 00:00:00		2020-07-08 00:00:00		2021-01-28 00:00:00		2020-09-02 00:00:00		2020-10-28 00:00:00		2020-07-21 00:00:00		2021-07-23 00:00:00		2021-04-29 00:00:00		2022-01-12 00:00:00		2021-10-27 00:00:00		2022-04-29 00:00:00		2022-07-12 00:00:00		2022-10-27 00:00:00
from_date		2011-07-01 00:00:00		2011-04-01 00:00:00		2011-04-01 00:00:00		2011-01-01 00:00:00		2011-09-01 00:00:00		2011-10-01 00:00:00		2012-01-01 00:00:00		2012-04-01 00:00:00		2012-01-01 00:00:00		2012-01-01 00:00:00		2012-07-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-31 00:00:00		2014-07-01 00:00:00		2014-01-01 00:00:00		2014-04-01 00:00:00		2013-10-01 00:00:00		2014-04-01 00:00:00		2014-01-01 00:00:00		2014-10-01 00:00:00		2015-07-01 00:00:00		2015-04-01 00:00:00		2015-01-01 00:00:00		2015-10-01 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		2016-01-01 00:00:00		2016-10-01 00:00:00		2017-04-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-07-01 00:00:00		2017-10-01 00:00:00		2018-01-01 00:00:00		2017-10-01 00:00:00		2018-07-01 00:00:00		2018-04-01 00:00:00		2019-01-01 00:00:00		2019-04-01 00:00:00		2018-10-01 00:00:00		2019-10-01 00:00:00		2019-07-01 00:00:00		2019-07-01 00:00:00		2020-01-01 00:00:00		2019-10-01 00:00:00		2020-01-01 00:00:00		2020-10-01 00:00:00		2020-04-01 00:00:00		2020-07-01 00:00:00		2020-04-01 00:00:00		2021-04-01 00:00:00		2021-01-01 00:00:00		2020-10-01 00:00:00		2021-07-01 00:00:00		2022-01-01 00:00:00		2022-04-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-06-30 00:00:00		2011-03-31 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2012-03-31 00:00:00		2012-06-30 00:00:00		2012-03-31 00:00:00		2012-03-31 00:00:00		2012-09-30 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-09-30 00:00:00		2014-03-31 00:00:00		2014-06-30 00:00:00		2013-12-31 00:00:00		2014-06-30 00:00:00		2014-03-31 00:00:00		2014-12-31 00:00:00		2015-09-30 00:00:00		2015-06-30 00:00:00		2015-03-31 00:00:00		2015-12-31 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		2016-03-31 00:00:00		2016-12-31 00:00:00		2017-06-30 00:00:00		2017-06-30 00:00:00		2017-03-31 00:00:00		2017-09-30 00:00:00		2017-12-31 00:00:00		2018-03-31 00:00:00		2017-12-31 00:00:00		2018-09-30 00:00:00		2018-06-30 00:00:00		2019-03-31 00:00:00		2019-06-30 00:00:00		2018-12-31 00:00:00		2019-12-31 00:00:00		2019-09-30 00:00:00		2019-09-30 00:00:00		2020-03-31 00:00:00		2019-12-31 00:00:00		2020-03-31 00:00:00		2020-12-31 00:00:00		2020-06-30 00:00:00		2020-09-30 00:00:00		2020-06-30 00:00:00		2021-06-30 00:00:00		2021-03-31 00:00:00		2021-12-31 00:00:00		2021-09-30 00:00:00		2022-03-31 00:00:00		2022-06-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		None		None		2011-01-01 00:00:00		2011-01-01 00:00:00		2012-01-01 00:00:00		2012-01-01 00:00:00		2012-01-01 00:00:00		2012-01-01 00:00:00		2012-01-01 00:00:00		2012-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2014-01-01 00:00:00		2014-01-01 00:00:00		2013-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		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2020-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		2019-01-01 00:00:00		2019-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-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
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
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
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
firm_zip4		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019
firm_phon		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122310559		2122310559		2122311849		2122310559		2122310559		2122310559		2122310559		2122310559		2122310559		2122311253		2122310559		2122310559		2122310559		2122311253		2122311253		2122311253		2122311253		2122311253		2122311253		2122311253
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
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
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
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
sig_date		2011-10-31 00:00:00		2011-09-23 00:00:00		2011-07-11 00:00:00		2011-04-07 00:00:00		2012-01-05 00:00:00		2012-01-05 00:00:00		2012-05-15 00:00:00		2012-07-31 00:00:00		2012-04-04 00:00:00		2012-05-15 00:00:00		2012-10-04 00:00:00		2013-01-10 00:00:00		2013-10-01 00:00:00		2013-07-29 00:00:00		2013-04-25 00:00:00		2014-01-22 00:00:00		2014-10-02 00:00:00		2014-08-07 00:00:00		2014-08-07 00:00:00		2014-08-07 00:00:00		2014-07-16 00:00:00		2014-04-07 00:00:00		2015-01-08 00:00:00		2015-10-01 00:00:00		2015-07-09 00:00:00		2015-04-09 00:00:00		2016-01-25 00:00:00		2016-07-26 00:00:00		2016-10-03 00:00:00		2016-04-01 00:00:00		2017-01-05 00:00:00		2017-07-18 00:00:00		2017-07-11 00:00:00		2017-04-24 00:00:00		2017-10-12 00:00:00		2018-01-05 00:00:00		2018-04-23 00:00:00		2018-01-17 00:00:00		2018-10-12 00:00:00		2018-07-13 00:00:00		2019-04-04 00:00:00		2019-07-01 00:00:00		2019-01-02 00:00:00		2020-01-14 00:00:00		2019-10-17 00:00:00		2019-10-16 00:00:00		2020-04-14 00:00:00		2020-07-08 00:00:00		2020-07-08 00:00:00		2021-01-28 00:00:00		2020-09-02 00:00:00		2020-10-28 00:00:00		2020-07-21 00:00:00		2021-07-21 00:00:00		2021-04-29 00:00:00		2022-01-12 00:00:00		2021-10-27 00:00:00		2022-04-30 00:00:00		2022-07-12 00:00:00		2022-10-27 00:00:00
sig_loc		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 NY		New York, NY		New York, NY		NEW YORK NEW YORK		New York		New York NY		New York,New York		New York New York		New York, New York		New York, New York		NEW YORK NY		New York New York		New York, NY		New York		New York City New York		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		NEW YORK, NEW YORK		NEW YORK, NEW YORK		New York,NY		NEW YORK, NEW YORK		New York, NY		New York, NY		New York, New York		New York, NY		New York, 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 New York		New York, NY		New York		New York, New York		New York, New York		New York, New York		New York, NY
sig_naml		Lazar		Lazar		Lazar		Lazar		Lazar		Lazar		Mody		Mody		Mody		Mody		Hennessey		Hennessey		Hennessey		HENNESSEY		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		HENNESSEY		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Gevanter		Hennessey		Gevanter		Gevanter		Gevanter		Gevanter		Gevanter		Gevanter		Gevanter		Gevanter		Gevanter		Gevanter		Hennessey		Gevanter		Selby		Selby		Selby		Selby		Selby
sig_namf		Andrew		Andrew		Andrew		Andrew		Andrew		Andrew		Andrea		Andrea		Andrea		Andrea		Robert		Rob		Robert		ROB		Robert		Robert		Robert		Robert		Robert		Robert		ROB		Robert		Rob		Robert		Robert		Robert		Robert		Rob		Rob		Rob		Rob		Rob		Rob		Rob		Rob		Rob		Rob		Rob		Rob		Rob		Rob		Derek		Robert		Derek		Derek		Derek		Derek		Derek		Derek		Derek		Derek		Derek		Derek		Rob		Derek		Joe		Joseph		Joseph		Joseph		Joseph
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
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
prn_naml		Lazar		Lazar		Lazar		Lazar		Lazar		Lazar		Mody		Mody		Mody		Mody		Hennessey		Hennessey		Hennessey		HENNESSEY		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		HENNESSEY		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Gevanter		Hennessey		Gevanter		Gevanter		Gevanter		Gevanter		Gevanter		Gevanter		Gevanter		Gevanter		Gevanter		Gevanter		Hennessey		Gevanter		Selby		Selby		Selby		Selby		Selby
prn_namf		Andrew		Andrew		Andrew		Andrew		Andrew		Andrew		Andrea		Andrea		Andrea		Andrea		Robert		Rob		Robert		ROB		Robert		Robert		Robert		Robert		Robert		Robert		ROB		Robert		Rob		Robert		Robert		Robert		Robert		Rob		Rob		Rob		Rob		Rob		Rob		Rob		Rob		Rob		Rob		Rob		Rob		Rob		Rob		Derek		Robert		Derek		Derek		Derek		Derek		Derek		Derek		Derek		Derek		Derek		Derek		Rob		Derek		Joe		Joseph		Joseph		Joseph		Joseph
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
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
sig_title		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Vice President		Vice President		Vice President		Vice President		Compliance Manager		Compliance Manager		Manager		COMPLIANCE MANAGER		Manager		Manager		Compliance Manager		Manager		Manager		Manager		MANAGER		Compliance Manager		Compliance Manager		Compliance Manager		Senior Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Deputy Chief Compliance Officer		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Mr.
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
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
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
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
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
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
lby_actvty		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		CalPERS CalSTRS UC Regents		None		CalPERS CalSTRS UC Regents CalSTA		CalPERS CalSTRS UC Regents CalSTA		None		None		None		CalPERS and CalSTRS		CalPERS and CalSTRS		CalPERS and CalSTRS		CalPERS and CalSTRS		CalPERS and CalSTRS		CalPERS and CalSTRS		CalPERS		CalPERS and CalSTRS		CalPERS		None		No lobbying activity.
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
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
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
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
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
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
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
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

Table: cvr_registration

filing_id		1560064		1560064		1560064		1560064		1560064		1717037		1717037		1917263		1917263		2108793		2108793		2108793		2108793		2108793		2108793		2325006		2325006		2368514		2537096		2537096
amend_id		0		1		2		3		4		0		1		0		1		0		1		2		3		4		5		0		1		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
form_type		F603		F603		F603		F603		F603		F603		F603		F603		F603		F603		F603		F603		F603		F603		F603		F603		F603		F606		F603		F603
sender_id		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099
filer_id		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099
entity_cd		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LBY		LEM		LEM
filer_naml		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.
filer_namf		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
filer_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
report_num		000		001		002		003		004		000		001		000		001		000		001		002		003		004		005		000		001		000		000		001
rpt_date		2011-01-14 00:00:00		2011-03-10 00:00:00		2011-03-10 00:00:00		2011-03-10 00:00:00		2012-04-04 00:00:00		2012-12-13 00:00:00		2013-12-17 00:00:00		2014-12-08 00:00:00		2015-03-26 00:00:00		2016-11-29 00:00:00		2017-02-02 00:00:00		2017-04-21 00:00:00		2018-01-17 00:00:00		2018-05-07 00:00:00		2018-10-08 00:00:00		2018-11-08 00:00:00		2019-03-12 00:00:00		2019-03-25 00:00:00		2020-12-16 00:00:00		2021-01-29 00:00:00
ls_beg_yr		2011		2011		2011		2011		2011		2013		2013		2015		2015		2017		2017		2017		2017		2017		2017		2019		2019		2019		2021		2021
ls_end_yr		2012		2012		2012		2012		2012		2014		2014		2016		2016		2018		2018		2018		2018		2018		2018		2020		2020		2020		2022		2022
qual_date		2011-01-14 00:00:00		2011-01-14 00:00:00		2011-01-14 00:00:00		2011-01-14 00:00:00		2011-01-14 00:00:00		None		None		2011-01-14 00:00:00		2011-01-14 00:00:00		2011-01-14 00:00:00		2011-01-14 00:00:00		2011-01-14 00:00:00		2011-01-14 00:00:00		2011-01-14 00:00:00		2011-01-14 00:00:00		2011-01-14 00:00:00		2011-01-14 00:00:00		None		2019-07-01 00:00:00		2019-07-01 00:00:00
eff_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2019-03-12 00:00:00		None		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		NEW YORK		NEW YORK		NEW YORK
bus_st		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY
bus_zip4		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019
bus_phon		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122311849		2122310559		2122310559		2122310559		2122311253		2122311253
bus_fax		2122311838		2122311838		2122311838		2122311838		2122311838		2122311838		2122311838		2122311838		2122311838		2122311838		2122311838		2122311838		2122311838		2122311838		2122311838		2122311838		2122311838		2122311838		None		None
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]		[email protected]		[email protected]		[email protected]
mail_city		None		None		None		None		None		None		None		NEW YORK		NEW YORK		None		None		None		None		None		None		None		None		None		None		None
mail_st		None		None		None		None		None		None		None		NY		NY		None		None		None		None		None		None		None		None		None		None		None
mail_zip4		None		None		None		None		None		None		None		10019		10019		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
sig_date		2011-01-14 00:00:00		2011-03-10 00:00:00		2011-03-10 00:00:00		2011-03-10 00:00:00		2012-04-04 00:00:00		2012-12-12 00:00:00		2013-12-17 00:00:00		2014-12-08 00:00:00		2015-03-26 00:00:00		2016-11-29 00:00:00		2017-02-02 00:00:00		2017-04-21 00:00:00		2018-01-17 00:00:00		2018-05-07 00:00:00		2018-10-08 00:00:00		2018-11-08 00:00:00		2019-03-12 00:00:00		2019-03-25 00:00:00		2020-12-16 00:00:00		2021-01-29 00:00:00
sig_loc		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sig_naml		Kernan		Kernan		Kernan		Kernan		Kernan		Kernan		Kernan		Hennessey		HENNESSEY		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Gevanter		Gevanter
sig_namf		Michael		Michael		Michael		Michael		Michael		Michael		Michael		Robert		ROBERT		Robert		Robert		Rob		Rob		Rob		Rob		Rob		Rob		Rob		Derek		Derek
sig_namt		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
prn_naml		Kernan		Kernan		Kernan		Kernan		Kernan		Kernan		Kernan		Hennessey		HENNESSEY		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Hennessey		Gevanter		Gevanter
prn_namf		Michael		Michael		Michael		Michael		Michael		Michael		Michael		Robert		ROBERT		Robert		Robert		Rob		Rob		Rob		Rob		Rob		Rob		Rob		Derek		Derek
prn_namt		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
sig_title		General Counsel and Secretary		General Counsel and Secretary		General Counsel and Secretary		General Counsel and Secretary		General Counsel		General Counsel and Secretary		General Counsel		Compliance Manager		COMPLIANCE		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager		Compliance Manager
stmt_firm		None		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		None
bus_cb		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		None		X		X
trade_cb		None		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		None
a_b_name		None		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		None
a_b_st		None		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		None
descrip_1		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
descrip_2		Investment Manager		Investment Manager		Investment Manager		Investment Manager		Investment Manager		INVESTMENT MANAGER		INVESTMENT MANAGER		Investment Manager		Investment Manager		Investment Manager		Investment Manager		Investment Manager		Investment Manager		Investment Manager		Investment Manager		Investment Manager		Investment Manager		None		Investment Manager		Investment Manager
c_less50		None		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		None
ind_class		None		None		None		None		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		None		None		None		None
bus_class		FIN		FIN		FIN		FIN		FIN		FIN		FIN		FIN		FIN		FIN		FIN		FIN		FIN		FIN		FIN		FIN		FIN		None		FIN		FIN
bus_descr		None		None		None		None		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		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		None
auth_st		None		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		None
lobby_int		Investments		Investments		Investments		Investments		Investments		None		None		Macquarie Infrastructure and Real Assets markets private equity infrastructure funds and co-investments to CalPERS,CalSTRS and URegents		Macquarie Infrastructure and Real Assets markets private equity infrastructure funds and co-investments to CalPERS,CalSTRS and URegents		Macquarie Infrastructure and Real Assets Inc. markets private equity funds and co-investment and direct investment opportunities to CalPERS, CalSTRS and URegents.		Macquarie Infrastructure and Real Assets Inc. markets private equity funds and co-investment and direct investment opportunities to CalPERS, CalSTRS and URegents.		Macquarie Infrastructure and Real Assets Inc. markets private equity funds and co-investment and direct investment opportunities to CalPERS, CalSTRS and URegents.		Macquarie Infrastructure and Real Assets Inc. markets private equity funds and co-investment and direct investment opportunities to CalPERS, CalSTRS and URegents.		Macquarie Infrastructure and Real Assets Inc. markets private equity funds and co-investment and direct investment opportunities to CalPERS, CalSTRS and URegents.		Macquarie Infrastructure and Real Assets Inc. markets private equity funds and co-investment and direct investment opportunities to CalPERS, CalSTRS and URegents.		Macquarie Infrastructure and Real Assets Inc. markets private equity funds and co-investment and direct investment opportunities to CalPERS, CalSTRS and URegents.		Macquarie Infrastructure and Real Assets Inc. markets private equity funds and co-investment and direct investment opportunities to CalPERS, CalSTRS and URegents.		None		Macquarie Infrastructure and Real Assets Inc. markets private equity funds and co-investment, and direct investment opportunities to CalPERS, CalSTRS and URegents.		Macquarie Infrastructure and Real Assets Inc. markets private equity funds and co-investment, and direct investment opportunities to CalPERS, CalSTRS and URegents.
influen_yn		Y		Y		Y		Y		Y		None		None		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		None		Y		Y
firm_name		None		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		None
rencert_cb		None		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		None
lby_reg_cb		None		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		None
st_leg_yn		None		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		None
lobby_cb		None		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		None

Table: filer_address

filer_id		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099
adrid		2209731		2554267		2436461		2417476		2256156		2466639		2337060		2505258
effect_dt		2011-01-01 00:00:00		2023-01-01 00:00:00		2017-06-20 00:00:00		2017-01-01 00:00:00		2013-01-01 00:00:00		2019-01-01 00:00:00		2015-01-01 00:00:00		2021-01-01 00:00:00
add_type		7051		7051		7050		7051		7051		7051		7051		7051
session_id		2011		2023		2017		2017		2013		2019		2015		2021

Table: filer_filings

filer_id		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099
filing_id		1780301		1973620		1863590		1717037		1792658		1808273		1790301		1946636		1917263		1957122		1564355		1560064		1560064		1585310		1599443		1560064		1560064		1599443		1626751		1626751		1621797		1616718		1650472		1560064		1650472		1678458		1650472		1811982		1693186		1924662		1917263		1924012		1717037		1718447		1890987		1836370		1863590		1811982		1716433		1723931		1836370		1761658		1990231		2203772		2370321		2413328		2200361		2325006		2234169		2537096		2524943		2465726		2108793		2108793		2368514		2430212		2305505		2305526		2305978		2006543		2025367		2058364		2084357		2111101		2107642		2117488		2108793		2107647		2107649		2107655		2110304		2152541		2108793		2108793		2166396		2166396		2148384		2159012		2108793		2389805		2325006		2334832		2465726		2410810		2430212		2549307		2247708		2409105		2200361		2578831		2479548		2537096		2331485		2413328		2383907		2187565		2264266		2545671		2479548		2620750		2697792		2596076		2701995		2634069		2664519		2674401		2743995
period_id		214		222		218		216		215		None		None		None		221		221		None		205		205		205		206		205		205		206		207		208		207		None		209		210		209		210		209		216		None		None		220		220		212		None		219		217		218		216		211		212		217		213		223		None		237		239		232		237		233		244		243		241		234		233		237		240		None		None		235		224		225		226		227		None		None		228		228		None		None		None		None		229		230		229		229		230		None		None		236		238		236		None		241		None		240		244		None		None		232		245		242		245		236		239		None		231		234		None		242		247		250		246		None		244		None		249		251
form_id		F635		F635		F635		F603		F635		F605		F605		F603		F603		F635		F603		F603		F603		F635		F635		F603		F603		F635		F635		F635		F635		F605		F635		F603		F635		F635		F635		F635		F605		F603		F603		F635		F603		F603		F635		F635		F635		F635		F635		F635		F635		F635		F635		F605		F635		F635		F635		F603		F635		F603		F635		F635		F603		F603		F606		F635		F605		F888		F635		F635		F635		F635		F635		F603		F605		F635		F603		F888		F605		F605		F605		F635		F603		F603		F635		F635		F605		F605		F603		F635		F603		F603		F635		F605		F635		F635		F605		F605		F635		F635		F635		F603		F635		F635		F605		F635		F635		F603		F635		F635		F635		F635		F605		F635		F605		F635		F635
filing_sequence		0		0		0		1		0		0		0		0		1		0		0		0		1		0		1		2		3		0		0		1		0		0		0		4		1		0		2		0		0		0		0		0		0		0		0		1		1		1		0		0		0		0		0		0		0		1		1		1		0		0		0		1		4		3		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		2		1		0		1		0		0		5		0		0		0		0		0		1		0		0		0		0		0		0		1		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0
filing_date		2013-07-30 00:00:00		2015-07-09 00:00:00		2014-07-16 00:00:00		2013-12-17 00:00:00		2013-10-03 00:00:00		2013-12-24 00:00:00		2013-08-15 00:00:00		2015-02-19 00:00:00		2015-03-26 00:00:00		2015-04-09 00:00:00		2011-01-19 00:00:00		2011-01-14 00:00:00		2011-03-10 00:00:00		2011-04-07 00:00:00		2011-09-23 00:00:00		2011-03-10 00:00:00		2011-03-10 00:00:00		2011-07-11 00:00:00		2012-01-05 00:00:00		2012-01-05 00:00:00		2011-10-31 00:00:00		2011-09-28 00:00:00		2012-04-04 00:00:00		2012-04-04 00:00:00		2012-05-15 00:00:00		2012-07-31 00:00:00		2012-05-15 00:00:00		2014-01-22 00:00:00		2012-10-01 00:00:00		2014-12-05 00:00:00		2014-12-08 00:00:00		2015-01-08 00:00:00		2012-12-13 00:00:00		2012-12-11 00:00:00		2014-10-02 00:00:00		2014-08-07 00:00:00		2014-08-07 00:00:00		2014-08-07 00:00:00		2012-12-07 00:00:00		2013-01-10 00:00:00		2014-04-07 00:00:00		2013-04-25 00:00:00		2015-10-01 00:00:00		2018-01-19 00:00:00		2019-04-04 00:00:00		2019-10-17 00:00:00		2018-01-17 00:00:00		2019-03-12 00:00:00		2018-04-23 00:00:00		2020-12-16 00:00:00		2020-10-28 00:00:00		2020-07-08 00:00:00		2018-05-07 00:00:00		2018-01-17 00:00:00		2019-03-25 00:00:00		2020-01-14 00:00:00		2018-10-10 00:00:00		2018-10-10 00:00:00		2018-10-12 00:00:00		2016-01-25 00:00:00		2016-04-01 00:00:00		2016-07-26 00:00:00		2016-10-03 00:00:00		2016-12-08 00:00:00		2016-11-14 00:00:00		2017-01-05 00:00:00		2016-11-29 00:00:00		2016-11-14 00:00:00		2016-11-10 00:00:00		2016-11-10 00:00:00		2016-12-08 00:00:00		2017-04-24 00:00:00		2017-04-21 00:00:00		2017-02-02 00:00:00		2017-07-11 00:00:00		2017-07-18 00:00:00		2017-02-16 00:00:00		2017-04-28 00:00:00		2018-10-08 00:00:00		2019-07-12 00:00:00		2018-11-08 00:00:00		2018-11-14 00:00:00		2020-04-14 00:00:00		2019-09-03 00:00:00		2020-07-08 00:00:00		2021-01-28 00:00:00		2018-05-08 00:00:00		2019-07-23 00:00:00		2018-01-05 00:00:00		2021-04-29 00:00:00		2020-07-21 00:00:00		2021-01-29 00:00:00		2019-01-02 00:00:00		2019-10-16 00:00:00		2019-03-26 00:00:00		2017-10-12 00:00:00		2018-07-13 00:00:00		2020-12-28 00:00:00		2020-09-02 00:00:00		2021-10-27 00:00:00		2022-07-12 00:00:00		2021-07-23 00:00:00		2022-07-19 00:00:00		2022-01-12 00:00:00		2022-03-24 00:00:00		2022-04-29 00:00:00		2022-10-27 00:00:00
stmnt_type		10001		10001		10001		10002		10001		10006		10006		10006		10002		10001		10005		10001		10002		10001		10002		10002		10002		10001		10001		10002		10001		10006		10001		10002		10002		10001		10002		10001		10006		10005		10001		10001		10001		10005		10001		10002		10002		10002		10001		10001		10001		10001		10001		10005		10001		10002		10002		10002		10001		10001		10001		10002		10002		10002		10001		10001		10006		10005		10001		10001		10001		10001		10001		10005		10006		10001		10001		10005		10006		10006		10006		10001		10002		10002		10001		10002		10005		10005		10002		10001		10001		10001		10001		10005		10002		10001		10005		10005		10001		10001		10001		10002		10001		10001		10005		10001		10001		10005		10002		10001		10001		10001		10002		10001		10002		10001		10001
stmnt_status		11001		11001		11001		11003		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		11003		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		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11003		11003
session_id		2013		2015		2013		2013		2013		2013		2013		2015		2015		2015		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2013		2011		2015		2015		2013		2013		2013		2013		2013		2013		2013		2011		2011		2013		2013		2015		2017		2019		2019		2017		2019		2017		2021		2019		2019		2017		2017		2019		2019		2017		2017		2017		2015		2015		2015		2015		2017		2015		2015		2017		2015		2015		2015		2015		2017		2017		2017		2017		2017		2017		2017		2017		2019		2019		2019		2019		2019		2019		2019		2017		2019		2017		2021		2019		2021		2017		2019		2019		2017		2017		2021		2019		2021		2021		2021		2021		2019		2021		2021		2021
user_id		AGLADNEY		AGLADNEY		AGLADNEY		CAFILER		AGLADNEY		ASAETERN		YRODRIGU		PBANFORD		YRODRIGU		AGLADNEY		YRODRIGU		YRODRIGU		YRODRIGU		AGLADNEY		AGLADNEY		YRODRIGU		YRODRIGU		AGLADNEY		ASAETERN		ASAETERN		ASAETERN		YRODRIGU		AGLADNEY		YRODRIGU		AGLADNEY		ASAETERN		AGLADNEY		ASAETERN		YRODRIGU		PBANFORD		PBANFORD		AGLADNEY		GKURIMOT		GKURIMOT		AGLADNEY		ASAETERN		AGLADNEY		ASAETERN		RGEREMIA		ASAETERN		ASAETERN		ASAETERN		JINGRAM		GPEREZ		VUKSTINA		GTAYLOR		AGLADNEY		CAFILER		AGLADNEY		SARRIAGA		GTAYLOR		GTAYLOR		GPEREZ		GPEREZ		CAFILER		GTAYLOR		YRODRIGU		YRODRIGU		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		PBANFORD		YRODRIGU		AGLADNEY		PBANFORD		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		AGLADNEY		GPEREZ		GPEREZ		AGLADNEY		YRODRIGU		GPEREZ		GPEREZ		YRODRIGU		VUKSTINA		SARRIAGA		SARRIAGA		GTAYLOR		SARRIAGA		GTAYLOR		GTAYLOR		GPEREZ		GPEREZ		AGLADNEY		GTAYLOR		GTAYLOR		CAFILER		AGLADNEY		GTAYLOR		SARRIAGA		AGLADNEY		AGLADNEY		SARRIAGA		GTAYLOR		GTAYLOR		CAFILER		GTAYLOR		MMERCHANT		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		11003		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		11003		11001		11001		11001		11003		11001		11003		11001		11001		11003		11003		11003		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11003		11003		11003		11001		11003		11003		11001		11003		11001		11001		11003		11003		11001		11001		11001		11003		11001		11001		11003		11001		11001		11003		11001		11001		11003		11001		11003		11003		11003		11003		11003
rpt_start		2013-04-01 00:00:00		2015-04-01 00:00:00		2014-04-01 00:00:00		2013-12-17 00:00:00		2013-07-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2015-03-26 00:00:00		2015-01-01 00:00:00		1900-01-01 00:00:00		2011-01-14 00:00:00		2011-03-10 00:00:00		2011-01-01 00:00:00		2011-04-01 00:00:00		2011-03-10 00:00:00		2011-03-10 00:00:00		2011-04-01 00:00:00		2011-09-01 00:00:00		2011-10-01 00:00:00		2011-07-01 00:00:00		1900-01-01 00:00:00		2012-01-01 00:00:00		2012-04-04 00:00:00		2012-01-01 00:00:00		2012-04-01 00:00:00		2012-01-01 00:00:00		2013-10-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2014-12-08 00:00:00		2014-10-01 00:00:00		2012-12-13 00:00:00		1900-01-01 00:00:00		2014-07-01 00:00:00		2014-01-01 00:00:00		2014-04-01 00:00:00		2013-10-01 00:00:00		2012-07-01 00:00:00		2012-10-01 00:00:00		2014-01-01 00:00:00		2013-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		2017-10-01 00:00:00		2019-03-12 00:00:00		2018-01-01 00:00:00		2020-12-16 00:00:00		2020-07-01 00:00:00		2020-01-01 00:00:00		2018-05-07 00:00:00		2018-01-17 00:00:00		2019-03-25 00:00:00		2019-10-01 00:00:00		1900-01-01 00:00:00		None		2018-07-01 00:00:00		2015-10-01 00:00:00		2016-01-01 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2016-10-01 00:00:00		2016-11-29 00:00:00		None		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2017-01-01 00:00:00		2017-04-21 00:00:00		2017-02-02 00:00:00		2017-01-01 00:00:00		2017-04-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2018-10-08 00:00:00		2019-04-01 00:00:00		2018-11-08 00:00:00		1900-01-01 00:00:00		2020-01-01 00:00:00		1900-01-01 00:00:00		2019-10-01 00:00:00		2020-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2017-10-01 00:00:00		2021-01-01 00:00:00		2020-04-01 00:00:00		2021-01-29 00:00:00		2018-10-01 00:00:00		2019-07-01 00:00:00		1900-01-01 00:00:00		2017-07-01 00:00:00		2018-04-01 00:00:00		1900-01-01 00:00:00		2020-04-01 00:00:00		2021-07-01 00:00:00		2022-04-01 00:00:00		2021-04-01 00:00:00		1900-01-01 00:00:00		2020-10-01 00:00:00		1900-01-01 00:00:00		2022-01-01 00:00:00		2022-07-01 00:00:00
rpt_end		2013-06-30 00:00:00		2015-06-30 00:00:00		2014-06-30 00:00:00		2013-12-17 00:00:00		2013-09-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2015-03-26 00:00:00		2015-03-31 00:00:00		1900-01-01 00:00:00		2011-01-14 00:00:00		2011-03-10 00:00:00		2011-03-31 00:00:00		2011-06-30 00:00:00		2011-03-10 00:00:00		2011-03-10 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2011-09-30 00:00:00		1900-01-01 00:00:00		2012-03-31 00:00:00		2012-04-04 00:00:00		2012-03-31 00:00:00		2012-06-30 00:00:00		2012-03-31 00:00:00		2013-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2014-12-08 00:00:00		2014-12-31 00:00:00		2012-12-13 00:00:00		1900-01-01 00:00:00		2014-09-30 00:00:00		2014-03-31 00:00:00		2014-06-30 00:00:00		2013-12-31 00:00:00		2012-09-30 00:00:00		2012-12-31 00:00:00		2014-03-31 00:00:00		2013-03-31 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		2017-12-31 00:00:00		2019-03-12 00:00:00		2018-03-31 00:00:00		2020-12-16 00:00:00		2020-09-30 00:00:00		2020-03-31 00:00:00		2018-05-07 00:00:00		2018-01-17 00:00:00		2019-03-25 00:00:00		2019-12-31 00:00:00		1900-01-01 00:00:00		None		2018-09-30 00:00:00		2015-12-31 00:00:00		2016-03-31 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2016-12-31 00:00:00		2016-11-29 00:00:00		None		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2017-03-31 00:00:00		2017-04-21 00:00:00		2017-02-02 00:00:00		2017-06-30 00:00:00		2017-06-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2018-10-08 00:00:00		2019-06-30 00:00:00		2018-11-08 00:00:00		1900-01-01 00:00:00		2020-03-31 00:00:00		1900-01-01 00:00:00		2019-12-31 00:00:00		2020-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2017-12-31 00:00:00		2021-03-31 00:00:00		2020-06-30 00:00:00		2021-01-29 00:00:00		2018-12-31 00:00:00		2019-09-30 00:00:00		1900-01-01 00:00:00		2017-09-30 00:00:00		2018-06-30 00:00:00		1900-01-01 00:00:00		2020-06-30 00:00:00		2021-09-30 00:00:00		2022-06-30 00:00:00		2021-06-30 00:00:00		1900-01-01 00:00:00		2021-12-31 00:00:00		1900-01-01 00:00:00		2022-03-31 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		22006		22006		22006		22006		None		None		None		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		None		None		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		None		22006		22006		22006		22006		22006		None		None		22006		22006		None		None		None		None		22006		22006		22006		22006		22006		None		None		22006		22006		22006		None		22006		None		22006		22006		None		None		22006		22006		22006		22006		22006		22006		None		22006		22006		None		22006		22006		22006		22006		None		22006		None		22006		22006

Table: filer_interests

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

Table: filer_to_filer_type

filer_id		1335099		1335099		1335099		1335099		1335099		1335099		1335099
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		2017		2015		2019		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-01 00:00:00		2017-01-01 00:00:00		2015-01-01 00:00:00		2019-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		1335099
xref_id		1335099
effect_dt		2011-01-14 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099
filer_id		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099
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		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS 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		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019
phon		2122311849		2122311849		2122311849		2122311849		2122311849		2122310559		2122311253		2122311253		2122311849		2122311849		2122311849		2122311849		2122311849		2122310559		2122311253		2122311253		2122311849		2122311849		2122311849		2122311849		2122311849		2122310559		2122311253		2122311253		2122311849		2122311849		2122311849		2122311849		2122311849		2122310559		2122311253		2122311253		2122311849		2122311849		2122311849		2122311849		2122311849		2122310559		2122311253		2122311253		2122311849		2122311849		2122311849		2122311849		2122311849		2122310559		2122311253		2122311253		2122311849		2122311849		2122311849		2122311849		2122311849		2122310559		2122311253		2122311253
fax		2122311838		2122311838		2122311838		2122311838		2122311838		2122311838						2122311838		2122311838		2122311838		2122311838		2122311838		2122311838						2122311838		2122311838		2122311838		2122311838		2122311838		2122311838						2122311838		2122311838		2122311838		2122311838		2122311838		2122311838						2122311838		2122311838		2122311838		2122311838		2122311838		2122311838						2122311838		2122311838		2122311838		2122311838		2122311838		2122311838						2122311838		2122311838		2122311838		2122311838		2122311838		2122311838
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		1335099

Table: lobbying_chg_log

filer_id		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099		1335099
change_no		1		2		3		0		4		5		7		6		9		8
session_id		2011		2011		2013		2013		2017		2017		2017		2017		2017		2017
log_dt		2011-09-28 00:00:00		2012-10-01 00:00:00		2013-12-24 00:00:00		2013-08-15 00:00:00		2017-04-28 00:00:00		2017-04-28 00:00:00		2018-05-08 00:00:00		2018-01-19 00:00:00		2018-10-10 00:00:00		2018-05-08 00:00:00
filer_type		2		2		2		2		2		2		2		2		2		2
correction_flg		None		None		None		None		Y		None		None		Y		Y		Y
action		SET ACTIVE		DELETED		DELETED		ADDED		TERMINATE		TERMINATED		DELETED		DELETED		TERMINATED		ADDED
attribute_changed		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST
ethics_dt		None		None		None		None		None		None		None		None		None		None
interests		None		None		None		None		None		None		None		None		None		None
filer_full_name		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.		MACQUARIE INFRASTRUCTURE AND REAL ASSETS INC.
filer_city		None		None		None		None		NEW YORK		None		None		None		NEW YORK		NEW YORK
filer_st		None		None		None		None		NY		None		None		None		NY		NY
filer_zip		None		None		None		None		10019		None		None		None		10019		10019
filer_phone		None		None		None		None		2122311849		None		None		None		2122311849		2122311849
entity_type		4		4		4		4		4		4		4		4		4		4
entity_name		RAYMOND J. COSMAN		LAURA M. WARNER		MICHAEL COOK		GUILLERMO MARROQUIN		GLASCOTT, MICHAEL		GLASCOTT, MICHAEL		HILLARY RIPLEY		MARROQUIN, GUILLERMO		DADA, SUHAIL H.		GOLDEN, LESLIE
entity_city		None		None		None		None		None		None		None		None		None		None
entity_st		None		None		None		None		None		None		None		None		None		None
entity_zip		None		None		None		None		None		None		None		None		None		None
entity_phone		None		None		None		None		None		None		None		None		None		None
entity_id		1341585		1335555		1353859		1335646		1387972		1392441		1387972		1335646		None		None
responsible_officer		None		None		None		None		None		None		None		None		None		None
effect_dt		2011-08-08 00:00:00		2012-08-31 00:00:00		2013-12-12 00:00:00		2013-07-29 00:00:00		2017-04-21 00:00:00		2017-04-21 00:00:00		2018-05-07 00:00:00		2017-12-22 00:00:00		2018-09-30 00:00:00		2018-05-07 00:00:00

Table: received_filings

filer_id		1335099		1335099		1335099		1335099		1335099		1335099
filing_file_name		229374.cal		229769.cal		455342.cal		461261.cal		461330.cal		471844.cal
received_date		2021-01-29 00:00:00		2021-01-29 00:00:00		2021-01-18 00:00:00		2021-01-18 00:00:00		2021-01-18 00:00:00		2021-01-19 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
filing_id		None		None		None		None		None		None
form_id		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