Home

Filer ID: 1376215

Table: cvr_lobby_disclosure
filing_id   1990222   1974784   1959494   1974784   1959494   2006382   2057638   2116997   2029270   2092148   2166669   2150181   2187474   2229568   2262485   2201087   2302742   2337132   2376628   2390921   2415403   2575066   2593406   2621485   2642770   2744808
amend_id   0   0   1   1   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0
rec_type   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR
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
sender_id   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215
filer_id   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215
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
filer_naml   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, 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
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
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
report_num   000   000   001   001   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000
rpt_date   2015-10-01 00:00:00   2015-07-16 00:00:00   2015-07-21 00:00:00   2015-07-21 00:00:00   2015-04-20 00:00:00   2016-01-25 00:00:00   2016-07-25 00:00:00   2017-01-04 00:00:00   2016-04-18 00:00:00   2016-10-20 00:00:00   2017-07-12 00:00:00   2017-04-10 00:00:00   2017-10-12 00:00:00   2018-04-10 00:00:00   2018-07-05 00:00:00   2018-01-10 00:00:00   2018-10-05 00:00:00   2019-01-22 00:00:00   2019-04-24 00:00:00   2019-07-18 00:00:00   2019-10-25 00:00:00   2021-04-20 00:00:00   2021-07-15 00:00:00   2021-10-28 00:00:00   2022-01-31 00:00:00   2022-10-28 00:00:00
from_date   2015-07-01 00:00:00   2015-04-01 00:00:00   2015-03-09 00:00:00   2015-04-01 00:00:00   2015-03-09 00:00:00   2015-10-01 00:00:00   2016-04-01 00:00:00   2016-10-01 00:00:00   2016-01-01 00:00:00   2016-07-01 00:00:00   2017-04-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   2018-10-01 00:00:00   2019-01-01 00:00:00   2019-04-01 00:00:00   2019-07-01 00:00:00   2021-01-01 00:00:00   2021-04-01 00:00:00   2021-07-01 00:00:00   2021-10-01 00:00:00   2022-07-01 00:00:00
thru_date   2015-09-30 00:00:00   2015-06-30 00:00:00   2015-03-31 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-12-31 00:00:00   2016-03-31 00:00:00   2016-09-30 00:00:00   2017-06-30 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   2018-12-31 00:00:00   2019-03-31 00:00:00   2019-06-30 00:00:00   2019-09-30 00:00:00   2021-03-31 00:00:00   2021-06-30 00:00:00   2021-09-30 00:00:00   2021-12-31 00:00:00   2022-09-30 00:00:00
cum_beg_dt   2015-03-09 00:00:00   2015-03-09 00:00:00   2015-03-09 00:00:00   2015-03-09 00:00:00   2015-03-09 00:00:00   2015-03-09 00:00:00   2015-03-09 00:00:00   2015-03-09 00:00:00   2015-03-09 00:00:00   2015-03-09 00:00:00   2017-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   2018-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-04-01 00:00:00   2021-07-01 00:00:00   2021-10-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
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
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
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
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
firm_phon   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300
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
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
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
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
sig_date   2015-10-01 00:00:00   2015-07-16 00:00:00   2015-07-21 00:00:00   2015-07-21 00:00:00   2015-04-20 00:00:00   2016-01-25 00:00:00   2016-07-22 00:00:00   2017-01-04 00:00:00   2016-04-18 00:00:00   2016-10-20 00:00:00   2017-07-12 00:00:00   2017-04-10 00:00:00   2017-10-12 00:00:00   2018-04-04 00:00:00   2018-07-05 00:00:00   2018-01-04 00:00:00   2018-10-05 00:00:00   2019-01-22 00:00:00   2019-04-24 00:00:00   2019-07-18 00:00:00   2019-10-25 00:00:00   2021-04-20 00:00:00   2021-07-15 00:00:00   2021-10-28 00:00:00   2021-01-31 00:00:00   2022-10-25 00:00:00
sig_loc   Chicago, IL   Chicago, IL   Chicago   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, Illinois   Chicago, IL   Chicago, Illinois   Chicago, Illinois   Chicago, IL
sig_naml   Johnson   Johnson   Johnson   Johnson   Johnson   Johnson   Johnson   Johnson   Johnson   Johnson   Griffin   Johnson   Griffin   Griffin   Griffin   Griffin   Griffin   Griffin   Griffin   Griffin   Griffin   Rodriguez-Ayala   Rodriguez-Ayala   Rodriguez-Ayala   Rodriguez-Ayala   Rodriguez-Ayala
sig_namf   Nancy   Nancy   Nancy   Nancy   Nancy   Nancy   Nancy   Nancy   Nancy   Nancy   Lawrence   Nancy   Lawrence   Lawrence   Lawrence   Lawrence   Lawrence   Lawrence   Lawrence   Lawrence   Lawrence   Emma   Emma   Emma   Emma   Emma
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
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
prn_naml   Johnson   Johnson   Johnson   Johnson   Johnson   Johnson   Johnson   Johnson   Johnson   Johnson   Griffin   Johnson   Griffin   Griffin   Griffin   Griffin   Griffin   Griffin   Griffin   Griffin   Griffin   Rodriguez-Ayala   Rodriguez-Ayala   Rodriguez-Ayala   Rodriguez-Ayala   Rodriguez-Ayala
prn_namf   Nancy   Nancy   Nancy   Nancy   Nancy   Nancy   Nancy   Nancy   Nancy   Nancy   Lawrence   Nancy   Lawrence   Lawrence   Lawrence   Lawrence   Lawrence   Lawrence   Lawrence   Lawrence   Lawrence   Emma   Emma   Emma   Emma   Emma
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
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
sig_title   Head of Client Relationships   Head of Client Relationships   Head of Client Relationships   Head of Client Relationships   Head of Client Relationships   Head of Client Relationships   Head of Client Relationships   Head of Client Relationships   Head of Client Relationships   Head of Client Relationships   Chief Compliance Officer and General Counsel   Head of Client Relationships   Chief Compliance Officer and General Counsel   Chief Compliance Officer and General Counsel   Chief Compliance Officer and General Counsel   Chief Compliance Officer and General Counsel   Chief Compliance Officer and General Counsel   CCO   CCO   CCO   CCO   General Counsel & CCO   General Counsel   General Counsel & CCO   General Counsel & CCO   General Counsel & CCO
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
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
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
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
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
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
lby_actvty   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None.   None.   None.   None.   None.
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
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
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
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
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
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
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
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
Table: cvr_registration
filing_id   2337116   2436148   2337116   2568262   2621518
amend_id   0   0   1   0   0
rec_type   CVR   CVR   CVR   CVR   CVR
form_type   F603   F606   F603   F603   F606
sender_id   1376215   1376215   1376215   1376215   1376215
filer_id   1376215   1376215   1376215   1376215   1376215
entity_cd   LCO   LBY   LCO   LEM   LBY
filer_naml   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.
filer_namf   None   None   None   None   None
filer_namt   None   None   None   None   None
filer_nams   None   None   None   None   None
report_num   000   000   001   000   000
rpt_date   2019-01-22 00:00:00   2020-01-27 00:00:00   2020-10-29 00:00:00   2021-03-22 00:00:00   2021-10-28 00:00:00
ls_beg_yr   2019   2019   2019   2021   2021
ls_end_yr   2020   2020   2020   2022   2022
qual_date   2019-01-01 00:00:00   None   2019-01-01 00:00:00   2021-03-16 00:00:00   None
eff_date   None   2020-01-10 00:00:00   None   None   2021-10-28 00:00:00
bus_city   CHICAGO   CHICAGO   CHICAGO   CHICAGO   CHICAGO
bus_st   IL   IL   IL   IL   IL
bus_zip4   60606   60606   60606   60606   60606
bus_phon   3125850300   3125850300   3125850300   3125850300   3125850300
bus_fax   None   None   None   None   None
bus_email   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]
mail_city   None   None   None   None   None
mail_st   None   None   None   None   None
mail_zip4   None   None   None   None   None
mail_phon   None   None   None   None   None
sig_date   2019-01-22 00:00:00   2020-01-27 00:00:00   2020-10-29 00:00:00   2021-03-22 00:00:00   2021-10-28 00:00:00
sig_loc   None   None   None   None   None
sig_naml   Griffin   Griffin   Rodriguez-Ayala   Rodriguez-Ayala   Rodriguez-Ayala
sig_namf   Lawrence   Lawrence   Emma   Emma   Emma
sig_namt   None   None   None   None   None
sig_nams   None   None   None   None   None
prn_naml   Griffin   Griffin   Rodriguez-Ayala   Rodriguez-Ayala   Rodriguez-Ayala
prn_namf   Lawrence   Lawrence   Emma   Emma   Emma
prn_namt   None   None   None   None   None
prn_nams   None   None   None   None   None
sig_title   CCO   CCO   General Counsel   General Counsel   General Counsel & CCO
stmt_firm   None   None   None   None   None
ind_cb   None   None   None   None   None
bus_cb   X   None   X   X   None
trade_cb   None   None   None   None   None
oth_cb   None   None   None   None   None
a_b_name   None   None   None   None   None
a_b_city   None   None   None   None   None
a_b_st   None   None   None   None   None
a_b_zip4   None   None   None   None   None
descrip_1   None   None   None   None   None
descrip_2   LGIMA was established in 2006, is an SEC registered investment Advisor and CFTC regulated Commodity Trading Advisor. Based in Chicago, IL and specialize in index, fixed income, and liability driven investment services for the US institutional markets, primarily focusing on pension plan assets.   None   LGIMA was established in 2006, is an SEC registered investment Advisor and CFTC regulated Commodity Trading Advisor. Based in Chicago, IL and specialize in index, fixed income, and liability driven investment services for the US institutional markets, primarily focusing on pension plan assets.   LGIM America was established in 2006. It is an SEC registered investment advisor and CFTC regulated Commodity Trading Advisor. It specializes in index, fixed income, and liability driven investment services for the US institutional investor market, primarily focusing on pension plan assets.   None
c_less50   None   None   None   None   None
c_more50   None   None   None   None   None
ind_class   None   None   None   None   None
ind_descr   None   None   None   None   None
bus_class   PRO   None   PRO   PRO   None
bus_descr   None   None   None   None   None
auth_name   None   None   None   None   None
auth_city   None   None   None   None   None
auth_st   None   None   None   None   None
auth_zip4   None   None   None   None   None
lobby_int   We have no intent to influence the State Legislature.   None   We have no intent to influence the State Legislature.   Management of public plan assets and response to public retirement plan RFPs.   None
influen_yn   None   None   None   None   None
firm_name   None   None   None   None   None
newcert_cb   None   None   None   None   None
rencert_cb   None   None   None   None   None
complet_dt   None   None   None   None   None
lby_reg_cb   None   None   None   None   None
lby_604_cb   None   None   None   None   None
st_leg_yn   None   None   None   None   None
st_agency   None   None   None   None   None
lobby_cb   None   None   None   None   None
l_firm_cb   None   None   None   None   None
Table: filer_address
filer_id   1376215   1376215   1376215   1376215   1376215
adrid   2554198   2413488   2519801   2466575   2359200
effect_dt   2023-01-01 00:00:00   2017-01-01 00:00:00   2021-01-01 00:00:00   2019-01-01 00:00:00   2015-03-09 00:00:00
add_type   7051   7051   7051   7051   7051
session_id   2023   2017   2021   2019   2015
Table: filer_filings
filer_id   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215
filing_id   1959494   1974784   1974784   1959494   1955881   1990222   2201087   2446354   2302742   2436148   2390921   2006382   2014653   2029270   2057638   2092148   2111425   2116997   2150181   2166669   2446265   2415403   2337116   2187474   2535118   2337132   2229568   2376628   2262485   2575066   2642770   2686460   2686464   2674255   2651114   2700587   2593406   2647206   2683814   2683817   2337116   2588992   2621518   2715710   2568262   2621485   2744808
period_id   221   222   222   221   None   223   232   None   235   241   238   224   None   225   226   227   None   228   229   230   None   239   237   231   None   236   233   237   234   245   248   None   None   None   None   None   246   None   None   None   244   None   248   None   245   247   251
form_id   F635   F635   F635   F635   F603   F635   F635   F606   F635   F606   F635   F635   F605   F635   F635   F635   F603   F635   F635   F635   F603   F635   F603   F635   F603   F635   F635   F635   F635   F635   F635   F603   F605   F635   F606   F635   F635   F635   F605   F605   F603   F603   F606   F635   F603   F635   F635
filing_sequence   1   1   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1   0   0   0   0   0   0
filing_date   2015-07-21 00:00:00   2015-07-21 00:00:00   2015-07-16 00:00:00   2015-04-20 00:00:00   2015-03-17 00:00:00   2015-10-01 00:00:00   2018-01-10 00:00:00   2020-01-30 00:00:00   2018-10-05 00:00:00   2020-01-27 00:00:00   2019-07-18 00:00:00   2016-01-25 00:00:00   2016-02-05 00:00:00   2016-04-18 00:00:00   2016-07-25 00:00:00   2016-10-20 00:00:00   2016-12-05 00:00:00   2017-01-04 00:00:00   2017-04-10 00:00:00   2017-07-12 00:00:00   2020-01-30 00:00:00   2019-10-25 00:00:00   2019-01-22 00:00:00   2017-10-12 00:00:00   2020-09-11 00:00:00   2019-01-22 00:00:00   2018-04-10 00:00:00   2019-04-24 00:00:00   2018-07-05 00:00:00   2021-04-20 00:00:00   2022-01-31 00:00:00   2022-04-28 00:00:00   2022-04-28 00:00:00   2022-04-28 00:00:00   2022-02-02 00:00:00   2022-07-15 00:00:00   2021-07-15 00:00:00   2022-02-01 00:00:00   2022-04-28 00:00:00   2022-04-28 00:00:00   2020-10-29 00:00:00   2021-02-05 00:00:00   2021-10-28 00:00:00   2021-11-01 00:00:00   2021-03-22 00:00:00   2021-10-28 00:00:00   2022-10-28 00:00:00
stmnt_type   10002   10002   10001   10001   10005   10001   10001   10003   10001   10001   10001   10001   10006   10001   10001   10001   10005   10001   10001   10001   10005   10001   10001   10001   10005   10001   10001   10001   10001   10001   10001   10005   10002   10005   10003   10005   10001   10005   10002   10002   10002   10005   10001   10005   10001   10001   10001
stmnt_status   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11003
session_id   2015   2015   2015   2015   2015   2015   2017   2019   2017   2019   2019   2015   2015   2015   2015   2015   2017   2015   2017   2017   2019   2019   2019   2017   2019   2017   2017   2019   2017   2021   2021   2019   2019   2021   2021   2021   2021   2021   2019   2021   2019   2021   2021   2021   2021   2021   2021
user_id   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   PBANFORD   AGLADNEY   AGLADNEY   AROJAS   AGLADNEY   CAFILER   CAFILER   AGLADNEY   YRODRIGU   AGLADNEY   AGLADNEY   AGLADNEY   YRODRIGU   AGLADNEY   AGLADNEY   AGLADNEY   AROJAS   CAFILER   CAFILER   AGLADNEY   AROJAS   AGLADNEY   AGLADNEY   CAFILER   AGLADNEY   MKIRKHAM   MKIRKHAM   MMERCHANT   MMERCHANT   MKIRKHAM   JMENDOZA   CHATRIDGE   MKIRKHAM   MKIRKHAM   MKIRKHAM   MKIRKHAM   AROJAS   JMENDOZA   CAFILER   MKIRKHAM   JMENDOZA   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
fine_audit   11001   11001   11001   11001   11001   11001   11001   11003   11001   11003   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11003   11001   11003   11001   11001   11003   11001   11001   11001   11003   11003   11001   11003   11003   11001   11001   11003   11003   11003   11003   11003   11001   11003   11001   11003
rpt_start   2015-03-09 00:00:00   2015-04-01 00:00:00   2015-04-01 00:00:00   2015-03-09 00:00:00   1900-01-01 00:00:00   2015-07-01 00:00:00   2017-10-01 00:00:00   1900-01-01 00:00:00   2018-07-01 00:00:00   2020-01-27 00:00:00   2019-04-01 00:00:00   2015-10-01 00:00:00   1900-01-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   2016-10-01 00:00:00   2017-01-01 00:00:00   2017-04-01 00:00:00   1900-01-01 00:00:00   2019-07-01 00:00:00   2019-01-22 00:00:00   2017-07-01 00:00:00   1900-01-01 00:00:00   2018-10-01 00:00:00   2018-01-01 00:00:00   2019-01-01 00:00:00   2018-04-01 00:00:00   2021-01-01 00:00:00   2021-10-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2022-01-01 00:00:00   1900-01-01 00:00:00   2022-04-01 00:00:00   2021-04-01 00:00:00   2021-10-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2020-10-29 00:00:00   1900-01-01 00:00:00   2021-10-28 00:00:00   2021-07-01 00:00:00   2021-03-22 00:00:00   2021-07-01 00:00:00   2022-07-01 00:00:00
rpt_end   2015-03-31 00:00:00   2015-06-30 00:00:00   2015-06-30 00:00:00   2015-03-31 00:00:00   1900-01-01 00:00:00   2015-09-30 00:00:00   2017-12-31 00:00:00   1900-01-01 00:00:00   2018-09-30 00:00:00   2020-01-27 00:00:00   2019-06-30 00:00:00   2015-12-31 00:00:00   1900-01-01 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   2016-12-31 00:00:00   2017-03-31 00:00:00   2017-06-30 00:00:00   1900-01-01 00:00:00   2019-09-30 00:00:00   2019-01-22 00:00:00   2017-09-30 00:00:00   1900-01-01 00:00:00   2018-12-31 00:00:00   2018-03-31 00:00:00   2019-03-31 00:00:00   2018-06-30 00:00:00   2021-03-31 00:00:00   2021-12-31 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2022-03-31 00:00:00   1900-01-01 00:00:00   2022-06-30 00:00:00   2021-06-30 00:00:00   2021-12-31 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2020-10-29 00:00:00   1900-01-01 00:00:00   2021-10-28 00:00:00   2021-09-30 00:00:00   2021-03-22 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
filing_type   22006   22006   22006   22006   None   22006   22006   None   22006   22006   22006   22006   None   22006   22006   22006   None   22006   22006   22006   None   22006   22006   22006   None   22006   22006   22006   22006   22006   22006   None   None   None   None   None   22006   None   None   None   22006   None   22006   None   22006   22006   22006
Table: filer_interests
filer_id   1376215   1376215   1376215   1376215   1376215
session_id   2015   2019   2017   2023   2021
interest_cd   40315   40315   40312   40315   40315
effect_date   2015-03-09 00:00:00   2019-01-01 00:00:00   2017-01-01 00:00:00   2023-01-01 00:00:00   2021-01-01 00:00:00
Table: filer_to_filer_type
filer_id   1376215   1376215   1376215   1376215   1376215   1376215   1376215
filer_type   2   2   2   2   2   2   2
active   S   Y   Y   Y   N   Y   T
race   None   0   None   None   None   None   None
session_id   2019   2015   2017   2019   2023   2021   2019
category   None   0   None   None   None   None   None
category_type   None   0   None   None   None   None   None
sub_category   None   0   None   None   None   None   None
effect_dt   2019-01-01 00:00:00   2015-03-09 00:00:00   2017-01-01 00:00:00   2020-09-01 00:00:00   2023-01-01 00:00:00   2021-01-01 00:00:00   2020-01-10 00:00:00
sub_category_type   None   0   None   None   None   None   None
election_type   None   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   None   0   None   None   None   None   None
county_cd   None   0   None   None   None   None   None
district_cd   None   0   None   None   None   None   None
Table: filer_xref
filer_id   1376215
xref_id   1376215
effect_dt   2015-03-19 00:00:00
migration_source   CLAIMS
Table: filername
xref_filer_id   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215
filer_id   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215
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
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
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
naml   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, 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
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
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
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
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
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
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
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
phon   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300   3125850300
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
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]
Table: filers
filer_id   1376215
Table: lobbying_chg_log
filer_id   1376215   1376215   1376215   1376215
change_no   1   0   2   3
session_id   2015   2019   2019   2021
log_dt   2015-03-17 00:00:00   2020-09-11 00:00:00   2020-01-30 00:00:00   2022-04-28 00:00:00
filer_type   2   2   2   2
correction_flg   Y   None   None   None
action   ADDED   ADDED   CHANGED   SET ACTIVE
attribute_changed   LOBBYIST   LOBBYIST   RESPONSIBLE OFFICER   
ethics_dt   None   None   None   None
interests   None   None   None   None
filer_full_name   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.   LEGAL & GENERAL INVESTMENT MANAGEMENT AMERICA, INC.
filer_city   CHICAGO   None   None   None
filer_st   IL   None   None   None
filer_zip   60606   None   None   None
filer_phone   3125850300   None   None   None
entity_type   4   4   20   2
entity_name   TOOMEY, MARK D.   SHAUNA CONZA   CHIEF COMPLIANCE OFFICER LAWRENCE GRIFFIN   None
entity_city   None   None   None   None
entity_st   None   None   None   None
entity_zip   None   None   None   None
entity_phone   None   None   None   None
entity_id   None   1428828   1434771   0
responsible_officer   None   None   None   None
effect_dt   2015-03-17 00:00:00   2020-08-01 00:00:00   2019-01-01 00:00:00   2021-01-01 00:00:00
Table: received_filings
filer_id   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215   1376215
filing_file_name   26128.cal   262760.cal   299458.cal   299473.cal   299610.cal   299584.cal   434253.cal   434415.cal   434400.cal   338159.cal   243749.cal   243907.cal   243878.cal   243955.cal   238385.cal
received_date   2017-01-04 00:00:00   2016-11-29 00:00:00   2019-01-22 00:00:00   2019-01-22 00:00:00   2019-01-22 00:00:00   2019-01-22 00:00:00   2018-11-07 00:00:00   2018-11-07 00:00:00   2018-11-07 00:00:00   2021-03-22 00:00:00   2021-03-15 00:00:00   2021-03-15 00:00:00   2021-03-15 00:00:00   2021-03-15 00:00:00   2021-03-15 00:00:00
filing_directory   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp
filing_id   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
form_id   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
receive_comment   Filing did not pass validation   Filing did not pass validation   Filing did not pass validation   Filing did not pass validation   Filing did not pass validation   Filing did not pass validation   Filing did not pass validation   Filing did not pass validation   Filing did not pass validation   Filing did not pass validation   Filing did not pass validation   Filing did not pass validation   Filing did not pass validation   Filing did not pass validation   Filing did not pass validation