Home

Filer ID: 1337063

Table: cvr_lobby_disclosure
filing_id   1603591   1622590   1603591   1632735   1707376   1673427   1652278   1734264   1799172   1776282   1759080   1815063   1908472   1864403   1841641   1908472   1977527   1963667   1933242   1995804   2059466   2034516   2034516   2007523   2092409   2175847   2123717   2155237   2190123   2237311   2275249   2210954   2311426   2376692   2346668   2398861   2441401   2470636   2418078   2484965   2528690   2553080   2528690   2484965   2600496   2580196   2621591   2674795   2703730   2641040   2748218
amend_id   1   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1   0   0   0   0   0   0   1   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1   1   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
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
sender_id   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063
filer_id   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063
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
filer_naml   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, & HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC
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
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
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
report_num   001   000   000   000   000   000   000   000   000   000   000   000   000   000   000   001   000   000   000   000   000   000   001   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   001   001   000   000   000   000   000   000   000
rpt_date   2011-11-01 00:00:00   2011-10-31 00:00:00   2011-07-26 00:00:00   2012-01-27 00:00:00   2012-10-30 00:00:00   2012-07-23 00:00:00   2012-04-16 00:00:00   2013-01-29 00:00:00   2013-10-30 00:00:00   2013-07-18 00:00:00   2013-04-18 00:00:00   2014-01-29 00:00:00   2014-10-29 00:00:00   2014-07-21 00:00:00   2014-04-25 00:00:00   2015-05-06 00:00:00   2015-07-27 00:00:00   2015-04-29 00:00:00   2015-01-30 00:00:00   2015-10-29 00:00:00   2016-07-27 00:00:00   2016-04-28 00:00:00   2016-04-29 00:00:00   2016-01-27 00:00:00   2016-10-20 00:00:00   2017-07-31 00:00:00   2017-01-25 00:00:00   2017-04-28 00:00:00   2017-10-25 00:00:00   2018-04-26 00:00:00   2018-07-31 00:00:00   2018-01-31 00:00:00   2018-10-24 00:00:00   2019-04-24 00:00:00   2019-01-31 00:00:00   2019-07-31 00:00:00   2020-01-31 00:00:00   2020-04-30 00:00:00   2019-10-30 00:00:00   2020-07-31 00:00:00   2020-10-31 00:00:00   2021-02-01 00:00:00   2020-12-18 00:00:00   2020-12-18 00:00:00   2021-07-30 00:00:00   2021-04-30 00:00:00   2021-10-28 00:00:00   2022-04-29 00:00:00   2022-07-29 00:00:00   2022-01-28 00:00:00   2022-10-31 00:00:00
from_date   2011-04-01 00:00:00   2011-07-01 00:00:00   2011-04-01 00:00:00   2011-10-01 00:00:00   2012-07-01 00:00:00   2012-04-01 00:00:00   2012-01-01 00:00:00   2012-10-01 00:00:00   2013-07-01 00:00:00   2013-04-01 00:00:00   2013-01-01 00:00:00   2013-10-01 00:00:00   2014-07-01 00:00:00   2014-04-01 00:00:00   2014-01-01 00:00:00   2014-07-01 00:00:00   2015-04-01 00:00:00   2015-01-01 00:00:00   2014-10-01 00:00:00   2015-07-01 00:00:00   2016-04-01 00:00:00   2016-01-01 00:00:00   2016-01-01 00:00:00   2015-10-01 00:00:00   2016-07-01 00:00:00   2017-04-01 00:00:00   2016-10-01 00:00:00   2017-01-01 00:00:00   2017-07-01 00:00:00   2018-01-01 00:00:00   2018-04-01 00:00:00   2017-10-01 00:00:00   2018-07-01 00:00:00   2019-01-01 00:00:00   2018-10-01 00:00:00   2019-03-01 00:00:00   2019-10-01 00:00:00   2020-01-01 00:00:00   2019-07-01 00:00:00   2020-04-01 00:00:00   2020-07-01 00:00:00   2020-10-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   2021-07-01 00:00:00   2022-01-01 00:00:00   2022-04-01 00:00:00   2021-10-01 00:00:00   2022-07-01 00:00:00
thru_date   2011-06-30 00:00:00   2011-09-30 00:00:00   2011-06-30 00:00:00   2011-12-31 00:00:00   2012-09-30 00:00:00   2012-06-30 00:00:00   2012-03-31 00:00:00   2012-12-31 00:00:00   2013-09-30 00:00:00   2013-06-30 00:00:00   2013-03-31 00:00:00   2013-12-31 00:00:00   2014-09-30 00:00:00   2014-06-30 00:00:00   2014-03-31 00:00:00   2014-09-30 00:00:00   2015-06-30 00:00:00   2015-03-31 00:00:00   2014-12-31 00:00:00   2015-09-30 00:00:00   2016-06-30 00:00:00   2016-03-31 00:00:00   2016-03-31 00:00:00   2015-12-31 00:00:00   2016-09-30 00:00:00   2017-06-30 00:00:00   2016-12-31 00:00:00   2017-03-31 00:00:00   2017-09-30 00:00:00   2018-03-31 00:00:00   2018-06-30 00:00:00   2017-12-31 00:00:00   2018-09-30 00:00:00   2019-03-31 00:00:00   2018-12-31 00:00:00   2019-06-30 00:00:00   2019-12-31 00:00:00   2020-03-31 00:00:00   2019-09-30 00:00:00   2020-06-30 00:00:00   2020-09-30 00:00:00   2020-12-31 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-09-30 00:00:00   2022-03-31 00:00:00   2022-06-30 00:00:00   2021-12-31 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   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   2014-01-01 00:00:00   2014-01-01 00:00:00   2014-01-01 00:00:00   2014-01-01 00:00:00   2015-01-01 00:00:00   2015-01-01 00:00:00   2014-01-01 00:00:00   2015-01-01 00:00:00   2016-01-01 00:00:00   2016-01-01 00:00:00   2016-01-01 00:00:00   2015-01-01 00:00:00   2016-01-01 00:00:00   2017-01-01 00:00:00   2016-01-01 00:00:00   2017-01-01 00:00:00   2017-01-01 00:00:00   2018-01-01 00:00:00   2018-01-01 00:00:00   2017-01-01 00:00:00   2018-01-01 00:00:00   2019-01-01 00:00:00   2018-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   2020-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   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
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
firm_city   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO
firm_st   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL
firm_zip4   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606
firm_phon   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700
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
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
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
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
sig_date   2011-11-01 00:00:00   2011-10-31 00:00:00   2011-07-21 00:00:00   2012-01-27 00:00:00   2012-10-30 00:00:00   2012-07-23 00:00:00   2012-04-10 00:00:00   2013-01-29 00:00:00   2013-10-29 00:00:00   2013-07-18 00:00:00   2013-04-18 00:00:00   2014-01-28 00:00:00   2014-10-29 00:00:00   2014-07-21 00:00:00   2014-04-25 00:00:00   2015-05-06 00:00:00   2015-07-27 00:00:00   2015-04-29 00:00:00   2015-01-30 00:00:00   2015-10-29 00:00:00   2016-07-27 00:00:00   2016-04-28 00:00:00   2016-04-29 00:00:00   2016-01-27 00:00:00   2016-10-20 00:00:00   2017-07-27 00:00:00   2017-01-25 00:00:00   2017-04-28 00:00:00   2017-10-25 00:00:00   2018-04-26 00:00:00   2018-07-31 00:00:00   2017-01-31 00:00:00   2018-10-24 00:00:00   2019-04-24 00:00:00   2019-01-31 00:00:00   2019-07-31 00:00:00   2020-01-31 00:00:00   2020-04-30 00:00:00   2019-10-30 00:00:00   2020-07-30 00:00:00   2020-10-29 00:00:00   2021-01-29 00:00:00   2020-12-18 00:00:00   2020-12-18 00:00:00   2021-07-27 00:00:00   2021-04-30 00:00:00   2021-10-28 00:00:00   2022-04-29 00:00:00   2022-07-29 00:00:00   2021-01-28 00:00:00   2022-10-31 00:00:00
sig_loc   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago. IL   Chicago, Illinois   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL   Chicago, IL
sig_naml   Ramey   Smith   Smith   Ramey   Smith   Smith   Smith   Ramey   Ramey   Ramey   Ramey   Ramey   Ramey   Ramey   Ramey   Ramey   Ramey   Ramey   Ramey   Ramey   Ramey   Ramey   Ramey   Ramey   Ramey   Mullen   Ramey   Mullen   Mullen   Mullen   Mullen   Mullen   Mullen   Mullen   Mullen   Mullen   Sneed   Sneed   Mullen   Sneed   Walsh   Walsh   Walsh   Walsh   Walsh   Walsh   Walsh   Walsh   walsh   Walsh   Walsh
sig_namf   Randall   Roger E.   Roger E.   Randall   Roger E.   Roger E.   Roger E.   Randall   Randall   Randall   Randall   Randall   Randall   Randall   Randall   Randall   Randall   Randall   Randall   Randall G.   Randall G.   Randall G.   Randall G.   Randall G.   Randall G.   Mary Jo C.   Randall G.   Mary Jo C.   Mary Jo C.   Mary Jo C.   Mary Jo C.   Mary Jo C.   Mary Jo C.   Mary Jo C.   Mary Jo C.   Mary Jo C.   Shamina   Shamina   Mary Jo C.   Shamina   Lauren   Lauren   Lauren   Lauren   Lauren   Lauren   Lauren   Lauren   lauren   Lauren   Lauren
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
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
prn_naml   Ramey   Smith   Smith   Ramey   Smith   Smith   Smith   Ramey   Ramey   Ramey   Ramey   Ramey   Ramey   Ramey   Ramey   Ramey   Ramey   Ramey   Ramey   Ramey   Ramey   Ramey   Ramey   Ramey   Ramey   Mullen   Ramey   Mullen   Mullen   Mullen   Mullen   Mullen   Mullen   Mullen   Mullen   Mullen   Sneed   Sneed   Mullen   Sneed   Walsh   Walsh   Walsh   Walsh   Walsh   Walsh   Walsh   Walsh   walsh   Walsh   Walsh
prn_namf   Randall   Roger E.   Roger E.   Randall   Roger E.   Roger E.   Roger E.   Randall   Randall   Randall   Randall   Randall   Randall   Randall   Randall   Randall   Randall   Randall   Randall   Randall G.   Randall G.   Randall G.   Randall G.   Randall G.   Randall G.   Mary Jo C.   Randall G.   Mary Jo C.   Mary Jo C.   Mary Jo C.   Mary Jo C.   Mary Jo C.   Mary Jo C.   Mary Jo C.   Mary Jo C.   Mary Jo C.   Shamina   Shamina   Mary Jo C.   Shamina   Lauren   Lauren   Lauren   Lauren   Lauren   Lauren   Lauren   Lauren   lauren   Lauren   Lauren
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
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
sig_title   Deputy Compliance Officer   Chief Compliance Officer   Chief Compliance Officer   Deputy Compliance Officer   Chief Compliance Officer   Chief Compliance Officer   Chief Compliance Officer   Senior Compliance Officer   Senior Compliance Officer   Senior Compliance Officer   Senior Compliance Officer   Chief Compliance Officer   Chief Compliance Officer   Chief Conpliance 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   Chief Compliance Officer   Vice President, Deputy Compliance Officer   Chief Compliance Officer   Vice President, Deputy Compliance Officer   VP, Deputy Compliance Officer   Vice President, Deputy Compliance Officer   VP, Deputy Compliance Officer   Vice President, Deputy Compliance Officer   VP, Deputy Compliance Officer   Vice President, Deputy Compliance Officer   VP, Deputy Compliance Officer   VP, Deputy Compliance Officer   CCO & Deputy General Counsel   CCO & Deputy General Counsel   VP, Deputy Compliance Officer   CCO & Deputy General Counsel   VP, DCO & AGC   VP, DCO & AGC   VP, DCO & AGC   VP, DCO & AGC   VP, DCO & AGC   VP, DCO & AGC   VP, DCO & AGC   SVP   SVP   SVP, Head of Compliance - PE & Ops & DGC   SVP
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
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
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
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
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
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
lby_actvty   Servicing CalSTRS account   Servicing CalSTRS account and marketing new products to CalPERS which is a prospective client.   None   Servicing CalSTRS account and marketing new products to CalPERS which is a prospective client.   Servicing CalSTRS account and marketing new products to CalPERS which is a prospective client.   Servicing CalSTRS account and marketing new products to CalPERS which is a prospective client.   Servicing CalSTRS account and marketing new products to CalPERS which is a prospective client.   Servicing CalSTRS account and marketing new products to CalPERS which is a prospective client.   Servicing CalSTRS account and marketing new products to CalPERS which is a prospective client.   Servicing CalSTRS account and marketing new products to CalPERS which is a prospective client.   Servicing CalSTRS account and marketing new products to CalPERS which is a prospective client.   Servicing CalSTRS account and marketing new products to CalPERS which is a prospective client.   Servicing CalSTRS account and marketing new products to CalPERS which is a prospective client.   Servicing CalSTRS account and marketing new products to CalPERS which is a prospective client.   Servicing CalSTRS account and marketing new products to CalPERS which is a prospective client.   Servicing CalSTRS account and marketing new products to CalPERS which is a prospective client.   Servicing CalSTRS account and marketing new products to CalPERS which is a prospective client.   Servicing CalSTRS account and marketing new products to CalPERS which is a prospective client.   Servicing CalSTRS account and marketing new products to CalPERS which is a prospective client.   Servicing CalSTRS account and marketing new products to CalPERS which is a prospective client.   Servicing CalSTRS account and marketing new products to CalPERS which is a prospective client.   Servicing CalSTRS account and marketing new products to CalPERS which is a prospective client.   Servicing CalSTRS account and marketing new products to CalPERS which is a prospective client.   Servicing CalSTRS account and marketing new products to CalPERS which is a prospective client.   Servicing CalSTRS account and marketing new products to CalPERS which is a prospective client.   Servicing and marketing new products to CalSTRS account Marketing new products to CalPERS which is a prospective client   Servicing CalSTRS account and marketing new products to CalPERS which is a prospective client.   ? Servicing and marketing new products to CalSTRS account ? Marketing new products to CalPERS which is a prospective client   Servicing and marketing new products to CalSTRS account Marketing new products to CalPERS which is a prospective client   Servicing and marketing new products to CalSTRS account and University of California - Regents Marketing new products to CalPERS   Servicing and marketing new products to CalSTRS account and University of California - Regents   Servicing and marketing new products to CalSTRS account and University of California - Regents Marketing new products to CalPERS   Servicing and marketing new products to CalSTRS account and University of California - Regents   Servicing existing investments and marketing new products to CalSTRS and the University of California Board of Regents. Marketing new products to CalPERS.   Servicing and marketing new products to CalSTRS account and University of California - Regents   Servicing existing investments and marketing new products to CalSTRS and the University of California Board of Regents. Marketing new products to CalPERS.   Servicing existing investments and marketing new products to CalSTRS and the University of California Board of Regents. Marketing new products to CalPERS.   Servicing existing investments and marketing new products to CalSTRS and the University of California Board of Regents. Marketing new products to CalPERS.   Servicing existing investments and marketing new products to CalSTRS and the University of California Board of Regents. Marketing new products to CalPERS.   Servicing existing investments and marketing new products to CalSTRS and the University of California Board of Regents. Marketing new products to CalPERS.   Servicing existing investments and marketing new products to CalSTRS and the University of California Board of Regents. Marketing new products to CalPERS.   Servicing existing investments and marketing new products to CalSTRS and the University of California Board of Regents. Marketing new products to CalPERS.   Servicing existing investments and marketing new products to CalSTRS and the University of California Board of Regents. Marketing new products to CalPERS.   Servicing existing investments and marketing new products to CalSTRS and the University of California Board of Regents. Marketing new products to CalPERS.   Servicing existing investments and marketing new products to CalSTRS and the University of California Board of Regents. Marketing new products to CalPERS.   Servicing existing investments and marketing new products to CalSTRS and the University of California Board of Regents. Marketing new products to CalPERS.   Servicing existing investments and marketing new products to CalSTRS and the University of California Board of Regents. Marketing new products to CalPERS.   Servicing existing investments and marketing new products to CalSTRS and the University of California Board of Regents. Marketing new products to CalPERS.   Servicing existing investments and marketing new products to CalSTRS and the University of California Board of Regents. Marketing new products to CalPERS.   Servicing existing investments and marketing new products to CalSTRS and the University of California Board of Regents. Marketing new products to CalPERS.   Servicing existing investments and marketing new products to CalSTRS and the University of California Board of Regents. Marketing new products to CalPERS.
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
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
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
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
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
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
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
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
Table: filer_address
filer_id   1337063   1337063   1337063   1337063   1337063   1337063   1337063
adrid   2212755   2413365   2466951   2287242   2545751   2338305   2505463
effect_dt   2011-02-14 00:00:00   2017-01-01 00:00:00   2019-01-01 00:00:00   2013-02-25 00:00:00   2023-01-01 00:00:00   2015-06-10 00:00:00   2021-01-01 00:00:00
add_type   7051   7051   7051   7051   7051   7051   7051
session_id   2011   2017   2019   2013   2023   2015   2021
Table: filer_filings
filer_id   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063
filing_id   1776282   1963667   1970672   1908472   1977527   1864403   1799172   1908472   1580642   1588019   1603591   1603591   1624192   1622590   1632735   1652278   1673427   1815063   1933242   1707376   1734264   1841641   1759080   1762804   1995804   1987079   2261419   2484965   2584153   2262086   2528690   2418078   2470636   2237311   2007523   2034516   2034516   2059466   2074120   2092409   2123717   2155237   2162899   2175847   2338030   2311426   2528690   2398861   2376692   2210954   2484965   2190123   2275249   2346668   2441401   2641040   2553080   2580196   2674795   2600496   2703730   2621591   2748218
period_id   214   221   None   219   222   218   215   219   None   None   206   206   None   207   208   209   210   216   220   211   212   217   213   None   223   None   None   242   None   None   243   239   241   233   224   225   225   226   None   227   228   229   None   230   None   235   243   237   237   232   242   231   234   236   240   248   244   245   249   246   250   247   251
form_id   F635   F635   F603   F635   F635   F635   F635   F635   F603   F635   F635   F635   F690   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F603   F635   F605   F605   F635   F603   F888   F635   F635   F635   F635   F635   F635   F635   F635   F605   F635   F635   F635   F603   F635   F603   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635
filing_sequence   0   0   0   1   0   0   0   0   0   0   0   1   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1   0   0   0   0   0   0   0   0   0   1   0   0   0   1   0   0   0   0   0   0   0   0   0   0   0   0
filing_date   2013-07-18 00:00:00   2015-04-29 00:00:00   2015-06-10 00:00:00   2015-05-06 00:00:00   2015-07-27 00:00:00   2014-07-21 00:00:00   2013-10-30 00:00:00   2014-10-29 00:00:00   2011-02-14 00:00:00   2011-04-21 00:00:00   2011-07-26 00:00:00   2011-11-01 00:00:00   2011-11-04 00:00:00   2011-10-31 00:00:00   2012-01-27 00:00:00   2012-04-16 00:00:00   2012-07-23 00:00:00   2014-01-29 00:00:00   2015-01-30 00:00:00   2012-10-30 00:00:00   2013-01-29 00:00:00   2014-04-25 00:00:00   2013-04-18 00:00:00   2013-02-25 00:00:00   2015-10-29 00:00:00   2015-08-21 00:00:00   2018-06-21 00:00:00   2020-07-31 00:00:00   2021-01-14 00:00:00   2018-06-21 00:00:00   2020-10-31 00:00:00   2019-10-30 00:00:00   2020-04-30 00:00:00   2018-04-26 00:00:00   2016-01-27 00:00:00   2016-04-28 00:00:00   2016-04-29 00:00:00   2016-07-27 00:00:00   2016-08-11 00:00:00   2016-10-20 00:00:00   2017-01-25 00:00:00   2017-04-28 00:00:00   2017-05-31 00:00:00   2017-07-31 00:00:00   2018-12-21 00:00:00   2018-10-24 00:00:00   2020-12-18 00:00:00   2019-07-31 00:00:00   2019-04-24 00:00:00   2018-01-31 00:00:00   2020-12-18 00:00:00   2017-10-25 00:00:00   2018-07-31 00:00:00   2019-01-31 00:00:00   2020-01-31 00:00:00   2022-01-28 00:00:00   2021-02-01 00:00:00   2021-04-30 00:00:00   2022-04-29 00:00:00   2021-07-30 00:00:00   2022-07-29 00:00:00   2021-10-28 00:00:00   2022-10-31 00:00:00
stmnt_type   10001   10001   10005   10002   10001   10001   10001   10001   10005   10005   10001   10002   10005   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10005   10001   10006   10006   10001   10005   10005   10001   10001   10001   10001   10001   10001   10002   10001   10006   10001   10001   10001   10005   10001   10001   10001   10002   10001   10001   10001   10002   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001
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   11003   11001   11003   11001   11003
session_id   2013   2015   2015   2013   2015   2013   2013   2013   2011   2011   2011   2011   2011   2011   2011   2011   2011   2013   2013   2011   2011   2013   2013   2013   2015   2015   2017   2019   2021   2017   2019   2019   2019   2017   2015   2015   2015   2015   2015   2015   2015   2017   2017   2017   2019   2017   2019   2019   2019   2017   2019   2017   2017   2017   2019   2021   2019   2021   2021   2021   2021   2021   2021
user_id   ASAETERN   AGLADNEY   YRODRIGU   AGLADNEY   AGLADNEY   AGLADNEY   ASAETERN   AGLADNEY   PBANFORD   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   ASAETERN   AGLADNEY   ASAETERN   ASAETERN   MPACHECO   AGLADNEY   AGLADNEY   AGLADNEY   ASAETERN   YRODRIGU   JINGRAM   YRODRIGU   YRODRIGU   MKIRKHAM   JMENDOZA   YRODRIGU   MKIRKHAM   SUSHAKOV   SUSHAKOV   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   YRODRIGU   AGLADNEY   AGLADNEY   AGLADNEY   YRODRIGU   AGLADNEY   DMCCASTL   AGLADNEY   GTAYLOR   AGLADNEY   VUKSTINA   AGLADNEY   GTAYLOR   AGLADNEY   AGLADNEY   AGLADNEY   GTAYLOR   CHATRIDGE   GTAYLOR   GTAYLOR   CAFILER   MKIRKHAM   CAFILER   MKIRKHAM   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
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   11003   11001   11003   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   11003   11001   11003   11001   11003
rpt_start   2013-04-01 00:00:00   2015-01-01 00:00:00   1900-01-01 00:00:00   2014-07-01 00:00:00   2015-04-01 00:00:00   2014-04-01 00:00:00   2013-07-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-04-01 00:00:00   2011-01-01 00:00:00   2011-07-01 00:00:00   2011-10-01 00:00:00   2012-01-01 00:00:00   2012-04-01 00:00:00   2013-10-01 00:00:00   2014-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   1900-01-01 00:00:00   2015-07-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2020-04-01 00:00:00   1900-01-01 00:00:00   None   2020-07-01 00:00:00   2019-07-01 00:00:00   2020-01-01 00:00:00   2018-01-01 00:00:00   2015-10-01 00:00:00   2016-01-01 00:00:00   2016-01-01 00:00:00   2016-04-01 00:00:00   1900-01-01 00:00:00   2016-07-01 00:00:00   2016-10-01 00:00:00   2017-01-01 00:00:00   1900-01-01 00:00:00   2017-04-01 00:00:00   1900-01-01 00:00:00   2018-07-01 00:00:00   2020-07-01 00:00:00   2019-03-01 00:00:00   2019-01-01 00:00:00   2017-10-01 00:00:00   2020-04-01 00:00:00   2017-07-01 00:00:00   2018-04-01 00:00:00   2018-10-01 00:00:00   2019-10-01 00:00:00   2021-10-01 00:00:00   2020-10-01 00:00:00   2021-01-01 00:00:00   2022-01-01 00:00:00   2021-04-01 00:00:00   2022-04-01 00:00:00   2021-07-01 00:00:00   2022-07-01 00:00:00
rpt_end   2013-06-30 00:00:00   2015-03-31 00:00:00   1900-01-01 00:00:00   2014-09-30 00:00:00   2015-06-30 00:00:00   2014-06-30 00:00:00   2013-09-30 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-06-30 00:00:00   2011-03-31 00:00:00   2011-09-30 00:00:00   2011-12-31 00:00:00   2012-03-31 00:00:00   2012-06-30 00:00:00   2013-12-31 00:00:00   2014-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   1900-01-01 00:00:00   2015-09-30 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2020-06-30 00:00:00   1900-01-01 00:00:00   None   2020-09-30 00:00:00   2019-09-30 00:00:00   2020-03-31 00:00:00   2018-03-31 00:00:00   2015-12-31 00:00:00   2016-03-31 00:00:00   2016-03-31 00:00:00   2016-06-30 00:00:00   1900-01-01 00:00:00   2016-09-30 00:00:00   2016-12-31 00:00:00   2017-03-31 00:00:00   1900-01-01 00:00:00   2017-06-30 00:00:00   1900-01-01 00:00:00   2018-09-30 00:00:00   2020-09-30 00:00:00   2019-06-30 00:00:00   2019-03-31 00:00:00   2017-12-31 00:00:00   2020-06-30 00:00:00   2017-09-30 00:00:00   2018-06-30 00:00:00   2018-12-31 00:00:00   2019-12-31 00:00:00   2021-12-31 00:00:00   2020-12-31 00:00:00   2021-03-31 00:00:00   2022-03-31 00:00:00   2021-06-30 00:00:00   2022-06-30 00:00:00   2021-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
filing_type   22006   22006   None   22006   22006   22006   22006   22006   None   None   22006   22006   None   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006   None   22006   None   None   22006   None   None   22006   22006   22006   22006   22006   22006   22006   22006   None   22006   22006   22006   None   22006   None   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006
Table: filer_interests
filer_id   1337063   1337063   1337063   1337063   1337063   1337063   1337063
session_id   2011   2013   2017   2021   2019   2015   2023
interest_cd   40312   40312   40312   40312   40312   40312   40312
effect_date   2011-02-14 00:00:00   2013-02-25 00:00:00   2017-01-01 00:00:00   2021-01-01 00:00:00   2019-01-01 00:00:00   2015-06-10 00:00:00   2023-01-01 00:00:00
Table: filer_to_filer_type
filer_id   1337063   1337063   1337063   1337063   1337063   1337063   1337063
filer_type   2   2   2   2   2   2   2
active   Y   Y   Y   Y   Y   Y   N
race   0   0   None   None   None   None   None
session_id   2013   2011   2019   2015   2017   2021   2023
category   0   0   None   None   None   None   None
category_type   0   0   None   None   None   None   None
sub_category   0   0   None   None   None   None   None
effect_dt   2013-02-25 00:00:00   2011-02-14 00:00:00   2019-01-01 00:00:00   2015-06-10 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   0   None   None   None   None   None
election_type   0   0   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   0   None   None   None   None   None
county_cd   0   0   None   None   None   None   None
district_cd   0   0   None   None   None   None   None
Table: filer_xref
filer_id   1337063
xref_id   1337063
effect_dt   2011-03-03 00:00:00
migration_source   CLAIMS
Table: filername
xref_filer_id   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063
filer_id   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063   1337063
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
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
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
naml   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, HEITMAN INTERNATIONAL HK LIMITED & HEITMAN SECURITIES LLC
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
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
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
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
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
city   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO
st   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL
zip4   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606   60606
phon   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700   3128555700
fax   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
email   None   None   None   None   None   lauren.walsh@heitman.com   lauren.walsh@heitman.com   None   None   None   None   None   lauren.walsh@heitman.com   lauren.walsh@heitman.com   None   None   None   None   None   lauren.walsh@heitman.com   lauren.walsh@heitman.com   None   None   None   None   None   lauren.walsh@heitman.com   lauren.walsh@heitman.com   None   None   None   None   None   lauren.walsh@heitman.com   lauren.walsh@heitman.com   None   None   None   None   None   lauren.walsh@heitman.com   lauren.walsh@heitman.com   None   None   None   None   None   lauren.walsh@heitman.com   lauren.walsh@heitman.com
Table: filers
filer_id   1337063
Table: lobbying_chg_log
filer_id   1337063   1337063   1337063   1337063   1337063   1337063   1337063
change_no   0   1   2   3   4   5   6
session_id   2013   2013   2015   2015   2015   2017   2017
log_dt   2013-02-25 00:00:00   2013-02-25 00:00:00   2015-06-10 00:00:00   2015-06-10 00:00:00   2015-08-21 00:00:00   2017-05-31 00:00:00   2017-05-31 00:00:00
filer_type   2   2   2   2   2   2   2
correction_flg   Y   Y   Y   None   Y   Y   Y
action   ADDED   ADDED   ADDED   SET ACTIVE   ADDED   ADDED   ADDED
attribute_changed   LOBBYIST   LOBBYIST   LOBBYIST   LOBBYIST   LOBBYIST   LOBBYIST   LOBBYIST
ethics_dt   None   None   None   None   None   None   None
interests   None   None   None   None   None   None   None
filer_full_name   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   HEITMAN LLC ON BEHALF OF ITSELF AND ITS AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC; HEITMAN INTERNATIONAL LLC; AND HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, & HEITMAN SECURITIES LLC   ON BEHALF OF HEITMAN LLC & AFFILIATES: HEITMAN CAPITAL MANAGEMENT LLC, HEITMAN INTERNATIONAL LLC, & HEITMAN SECURITIES LLC
filer_city   None   None   None   None   CHICAGO   CHICAGO   CHICAGO
filer_st   None   None   None   None   IL   IL   IL
filer_zip   None   None   None   None   60606   60606   60606
filer_phone   None   None   None   None   3128555700   3128555700   3128555700
entity_type   4   4   4   4   4   4   4
entity_name   INGALL, LEWIS   POLITO, CHRISTINA   INGALL, LEWIS   CHRISTINA POLITO   MANCUSO, JOHN   INGALL, LEWIS S.   MANCUSO, JOHN
entity_city   None   None   None   None   None   None   None
entity_st   None   None   None   None   None   None   None
entity_zip   None   None   None   None   None   None   None
entity_phone   None   None   None   None   None   None   None
entity_id   1337067   0   1337067   1337068   None   None   None
responsible_officer   None   None   None   None   None   None   None
effect_dt   2013-02-25 00:00:00   2013-02-25 00:00:00   2015-06-10 00:00:00   2015-06-10 00:00:00   2015-08-18 00:00:00   2017-05-31 00:00:00   2017-05-31 00:00:00