filing_id | 2094872 | 2171033 | 2152015 | 2120741 | 2152014 | 2190368 | 2270493 | 2205809 | 2234896 | 2306971 | 2342045 | 2378353 | 2394589 | 2466072 | 2437611 | 2414550 | 2548593 | 2479963 | 2521746 | 2575856 | 2620135 | 2598673 | 2636401 | 2670453 | 2698636 | 2742569 | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
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 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | ||||||||||||||||||||||||||
sender_id | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | ||||||||||||||||||||||||||
filer_id | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | ||||||||||||||||||||||||||
entity_cd | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | ||||||||||||||||||||||||||
filer_naml | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | ||||||||||||||||||||||||||
filer_namf | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | ||||||||||||||||||||||||||
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 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | ||||||||||||||||||||||||||
rpt_date | 2016-10-25 00:00:00 | 2017-07-25 00:00:00 | 2017-04-20 00:00:00 | 2017-01-19 00:00:00 | 2017-04-20 00:00:00 | 2017-10-25 00:00:00 | 2018-07-27 00:00:00 | 2018-01-26 00:00:00 | 2018-04-24 00:00:00 | 2018-10-16 00:00:00 | 2019-01-28 00:00:00 | 2019-04-29 00:00:00 | 2019-07-29 00:00:00 | 2020-04-17 00:00:00 | 2020-01-29 00:00:00 | 2019-10-23 00:00:00 | 2021-01-28 00:00:00 | 2020-07-22 00:00:00 | 2020-10-23 00:00:00 | 2021-04-21 00:00:00 | 2021-10-26 00:00:00 | 2021-07-28 00:00:00 | 2022-01-22 00:00:00 | 2022-04-25 00:00:00 | 2022-07-18 00:00:00 | 2022-10-27 00:00:00 | ||||||||||||||||||||||||||
from_date | 2016-09-07 00:00:00 | 2017-04-01 00:00:00 | 2017-03-15 00:00:00 | 2016-10-01 00:00:00 | 2017-01-01 00:00:00 | 2017-07-01 00:00:00 | 2018-04-01 00:00:00 | 2017-10-01 00:00:00 | 2018-01-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 | 2020-01-01 00:00:00 | 2019-10-01 00:00:00 | 2019-07-01 00:00:00 | 2020-10-01 00:00:00 | 2020-04-01 00:00:00 | 2020-07-01 00:00:00 | 2021-01-01 00:00:00 | 2021-07-01 00:00:00 | 2021-04-01 00:00:00 | 2021-10-01 00:00:00 | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||
thru_date | 2016-09-30 00:00:00 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 2016-12-31 00:00:00 | 2017-03-14 00:00:00 | 2017-09-30 00:00:00 | 2018-06-30 00:00:00 | 2017-12-31 00:00:00 | 2018-03-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 | 2020-03-31 00:00:00 | 2019-12-31 00:00:00 | 2019-09-30 00:00:00 | 2020-12-31 00:00:00 | 2020-06-30 00:00:00 | 2020-09-30 00:00:00 | 2021-03-31 00:00:00 | 2021-09-30 00:00:00 | 2021-06-30 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 2022-09-30 00:00:00 | ||||||||||||||||||||||||||
cum_beg_dt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||
firm_id | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | ||||||||||||||||||||||||||
firm_name | Teachers Insurance and Annuity Association (TIAA) | Nuveen Services, LLC | Nuveen Services, LLC | Teachers Insurance and Annuity Association (TIAA) | Teachers Insurance and Annuity Association (TIAA) | Nuveen Services, LLC | NUVEEN SERVICES, LLC | Nuveen Services, LLC | Nuveen Services, LLC | None | Nuveen Services, LLC | Nuveen Services, LLC | Nuveen Services, LLC | Nuveen Services, LLC | Nuveen Services, LLC | Nuveen Services, LLC | Nuveen Services | Nuveen Services LLC | Nuveen Services | NUVEEN SERVICES LLC | Nuveen Services LLC | Nuveen Services LLC | Nuveen Services LLC | Nuveen Services LLC | Nuveen Services LLC | NUVEEN SERVICES LLC | ||||||||||||||||||||||||||
firm_city | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | ||||||||||||||||||||||||||
firm_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | NY | NY | NY | NY | NY | NY | NY | ||||||||||||||||||||||||||
firm_zip4 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 10016 | 10016 | 10016 | 10016 | 10016 | 10016 | 10016 | ||||||||||||||||||||||||||
firm_phon | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | ||||||||||||||||||||||||||
mail_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | EDISON | EDISON | EDISON | EDISON | EDISON | EDISON | EDISON | ||||||||||||||||||||||||||
mail_st | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | NJ | NJ | NJ | NJ | NJ | NJ | NJ | ||||||||||||||||||||||||||
mail_zip4 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 08820 | 08820 | 08820 | 08820 | 08820 | 08820 | 08820 | ||||||||||||||||||||||||||
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 | 2016-10-25 00:00:00 | 2017-07-25 00:00:00 | 2017-04-20 00:00:00 | 2017-01-19 00:00:00 | 2017-04-20 00:00:00 | 2017-10-25 00:00:00 | 2018-07-27 00:00:00 | 2018-01-26 00:00:00 | 2018-04-24 00:00:00 | 2018-10-16 00:00:00 | 2019-01-28 00:00:00 | 2019-04-29 00:00:00 | 2019-07-29 00:00:00 | 2020-04-17 00:00:00 | 2020-01-29 00:00:00 | 2019-10-23 00:00:00 | 2021-01-28 00:00:00 | 2020-07-22 00:00:00 | 2020-10-23 00:00:00 | 2021-04-21 00:00:00 | 2021-10-26 00:00:00 | 2021-07-28 00:00:00 | 2022-01-22 00:00:00 | 2022-04-25 00:00:00 | 2022-07-18 00:00:00 | 2022-10-27 00:00:00 | ||||||||||||||||||||||||||
sig_loc | San Francisco, CA | SAN FRANCISCO, CA | San Francisco, CA | San Francisco, CA | San Francisco, CA | San Francisco, CA | SAN FRANCISCO, CA | SAN FRANCISCO, CA | San Francisco, CA | San Francisco, CA | San Francisco, CA | San Francisco, CA | New York, NY | San Francisco, CA | San Francisco, CA | New York, NY | San Francisco, CA | San Francisco,CA | San Francisco, CA | New York, NY | New York, NY | New York, NY | New York, NY | New York, NY | New York, NY | New York, NY | ||||||||||||||||||||||||||
sig_naml | Khandavilli | KHANDAVILLI | Khandavilli | Khandavilli | Khandavilli | Khandavilli | KHANDAVILLI | KHANDAVILLI | Khandavilli | Khandavilli | KHANDAVILLI | Khandavilli | McKillen | Khandavilli | Khandavilli | Khandavilli | Khandavilli | Khandavilli | Khandavilli | Khandavilli | Khandavilli | Khandavilli | Khandavilli | Khandavilli | Khandavilli | Khandavilli | ||||||||||||||||||||||||||
sig_namf | Sayuri | SAYURI | Sayuri | Sayuri | Sayuri | Sayuri | SAYURI | SAYURI | Sayuri | Sayuri | SAYURI | Sayri | Angela | Sayuri | Sayuri | Sayuri | Sayuri | Sayuri | Sayuri | Sayuri | Sayuri | Sayuri | Sayuri | Sayuri | Sayuri | Sayuri | ||||||||||||||||||||||||||
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 | Khandavilli | KHANDAVILLI | Khandavilli | Khandavilli | Khandavilli | Khandavilli | KHANDAVILLI | KHANDAVILLI | Khandavilli | Khandavilli | KHANDAVILLI | Khandavilli | McKillen | Khandavilli | Khandavilli | Khandavilli | Khandavilli | Khandavilli | Khandavilli | Khandavilli | Khandavilli | Khandavilli | Khandavilli | Khandavilli | Khandavilli | Khandavilli | ||||||||||||||||||||||||||
prn_namf | Sayuri | SAYURI | Sayuri | Sayuri | Sayuri | Sayuri | SAYURI | SAYURI | Sayuri | Sayuri | SAYURI | Sayri | Angela | Sayuri | Sayuri | Sayuri | Sayuri | Sayuri | Sayuri | Sayuri | Sayuri | Sayuri | Sayuri | Sayuri | Sayuri | Sayuri | ||||||||||||||||||||||||||
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 | Global Asset Manager | ASSISTANT VICE PRESIDENT | Assistant Vice President | Global Asset Manager | Assistant Vice President | Assistant Vice President | None | ASSISTANT VICE PRESIDENT | None | Assistant Vice President | None | Assistant Vice President | None | None | None | None | None | Assistant Vice President | None | Vice President, Real Estate Sepcialist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | ||||||||||||||||||||||||||
nopart1_cb | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | ||||||||||||||||||||||||||
nopart2_cb | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | ||||||||||||||||||||||||||
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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||
ctrib_y_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||
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 |
filer_id | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 2405939 | 2421893 | 2466888 | 2545682 | 2545683 | 2513550 | 2513547 | |||||||
effect_dt | 2016-08-29 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | |||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7082 | 7082 | 7051 | |||||||
session_id | 2015 | 2017 | 2019 | 2023 | 2023 | 2021 | 2021 |
filer_id | 1389927 | 1389927 | 1389927 | |||
---|---|---|---|---|---|---|
session_id | 2017 | 2019 | 2021 | |||
ethics_date | 2017-04-20 00:00:00 | 2019-01-10 00:00:00 | 2020-12-11 00:00:00 |
filer_id | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | ||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 2270493 | 2306971 | 2387754 | 2437611 | 2205809 | 2394589 | 2075423 | 2094872 | 2122455 | 2120741 | 2148457 | 2152014 | 2171033 | 2152015 | 2158954 | 2234896 | 2560728 | 2414550 | 2342045 | 2190368 | 2378353 | 2548593 | 2466016 | 2466072 | 2479963 | 2620135 | 2598673 | 2521746 | 2698636 | 2670453 | 2536799 | 2636401 | 2575856 | 2742569 | ||||||||||||||||||||||||||||||||||
period_id | 234 | 235 | None | 240 | 232 | 238 | None | 227 | None | 228 | None | 229 | 230 | 229 | None | 233 | None | 239 | 236 | 231 | 237 | 244 | None | 241 | 242 | 247 | 246 | 243 | 250 | 249 | None | 248 | 245 | 251 | ||||||||||||||||||||||||||||||||||
form_id | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | ||||||||||||||||||||||||||||||||||
filing_sequence | 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 | ||||||||||||||||||||||||||||||||||
filing_date | 2018-07-27 00:00:00 | 2018-10-16 00:00:00 | 2018-12-31 00:00:00 | 2020-01-29 00:00:00 | 2018-01-26 00:00:00 | 2019-07-29 00:00:00 | 2016-09-07 00:00:00 | 2016-10-25 00:00:00 | 2017-01-13 00:00:00 | 2017-01-19 00:00:00 | 2017-03-16 00:00:00 | 2017-04-20 00:00:00 | 2017-07-25 00:00:00 | 2017-04-20 00:00:00 | 2017-04-20 00:00:00 | 2018-04-24 00:00:00 | 2020-12-29 00:00:00 | 2019-10-23 00:00:00 | 2019-01-28 00:00:00 | 2017-10-25 00:00:00 | 2019-04-29 00:00:00 | 2021-01-28 00:00:00 | 2020-04-06 00:00:00 | 2020-04-17 00:00:00 | 2020-07-22 00:00:00 | 2021-10-26 00:00:00 | 2021-07-28 00:00:00 | 2020-10-23 00:00:00 | 2022-07-18 00:00:00 | 2022-04-25 00:00:00 | 2020-11-30 00:00:00 | 2022-01-22 00:00:00 | 2021-04-21 00:00:00 | 2022-10-27 00:00:00 | ||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10006 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11002 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||
session_id | 2017 | 2017 | 2019 | 2019 | 2017 | 2019 | 2015 | 2015 | 2017 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2021 | 2019 | 2017 | 2017 | 2019 | 2019 | 2019 | 2019 | 2019 | 2021 | 2021 | 2019 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||
user_id | JFRONEFIELD | JFRONEFIELD | SARRIAGA | MKIRKHAM | AGLADNEY | VUKSTINA | YRODRIGU | AGLADNEY | GPEREZ | AGLADNEY | GPEREZ | SMCCONNAN | SMCCONNAN | SMCCONNAN | PBANFORD | AGLADNEY | SARRIAGA | VUKSTINA | JFRONEFIELD | YRODRIGU | AGLADNEY | MLUONG | AROJAS | MKIRKHAM | MKIRKHAM | GTAYLOR | CHATRIDGE | MKIRKHAM | CAFILER | CAFILER | CVANLIEW | RATTIYEH | GTAYLOR | 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 | ||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||
rpt_start | 2018-04-01 00:00:00 | 2018-07-01 00:00:00 | 1900-01-01 00:00:00 | 2019-10-01 00:00:00 | 2017-10-01 00:00:00 | 2019-04-01 00:00:00 | 1900-01-01 00:00:00 | 2016-09-07 00:00:00 | 1900-01-01 00:00:00 | 2016-10-01 00:00:00 | 1900-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-04-01 00:00:00 | 2017-03-15 00:00:00 | 1900-01-01 00:00:00 | 2018-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-07-01 00:00:00 | 2018-10-01 00:00:00 | 2017-07-01 00:00:00 | 2019-01-01 00:00:00 | 2020-10-01 00:00:00 | 1900-01-01 00:00:00 | 2020-01-01 00:00:00 | 2020-04-01 00:00:00 | 2021-07-01 00:00:00 | 2021-04-01 00:00:00 | 2020-07-01 00:00:00 | 2022-04-01 00:00:00 | 2022-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-10-01 00:00:00 | 2021-01-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||
rpt_end | 2018-06-30 00:00:00 | 2018-09-30 00:00:00 | 1900-01-01 00:00:00 | 2019-12-31 00:00:00 | 2017-12-31 00:00:00 | 2019-06-30 00:00:00 | 1900-01-01 00:00:00 | 2016-09-30 00:00:00 | 1900-01-01 00:00:00 | 2016-12-31 00:00:00 | 1900-01-01 00:00:00 | 2017-03-14 00:00:00 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 1900-01-01 00:00:00 | 2018-03-31 00:00:00 | 1900-01-01 00:00:00 | 2019-09-30 00:00:00 | 2018-12-31 00:00:00 | 2017-09-30 00:00:00 | 2019-03-31 00:00:00 | 2020-12-31 00:00:00 | 1900-01-01 00:00:00 | 2020-03-31 00:00:00 | 2020-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-06-30 00:00:00 | 2020-09-30 00:00:00 | 2022-06-30 00:00:00 | 2022-03-31 00:00:00 | 1900-01-01 00:00:00 | 2021-12-31 00:00:00 | 2021-03-31 00:00:00 | 2022-09-30 00:00:00 | ||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||
filing_type | 22006 | 22006 | None | 22006 | 22006 | 22006 | None | 22006 | None | 22006 | None | 22006 | 22006 | 22006 | None | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 |
filer_id | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |||||||
active | Y | Y | R | S | Y | Y | N | |||||||
race | 0 | None | None | 0 | None | None | None | |||||||
session_id | 2017 | 2019 | 2019 | 2015 | 2021 | 2019 | 2023 | |||||||
category | 0 | None | None | 0 | None | None | None | |||||||
category_type | 0 | None | None | 0 | None | None | None | |||||||
sub_category | 0 | None | None | 0 | None | None | None | |||||||
effect_dt | 2017-01-01 00:00:00 | 2020-11-30 00:00:00 | 2019-06-30 00:00:00 | 2016-08-29 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||
sub_category_type | 0 | None | None | 0 | None | None | None | |||||||
election_type | 0 | None | None | 0 | None | None | None | |||||||
sub_category_a | None | None | None | None | None | None | None | |||||||
nyq_dt | None | None | None | None | None | None | None | |||||||
party_cd | 0 | None | None | 0 | None | None | None | |||||||
county_cd | 0 | None | None | 0 | None | None | None | |||||||
district_cd | 0 | None | None | 0 | None | None | None |
filer_id | 1389927 | |
---|---|---|
xref_id | 1389927 | |
effect_dt | 2016-09-09 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | |||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | 1389927 | |||||||||||||||||||||||||||||||||||
filer_type | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | |||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||
naml | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | KHANDAVILLI | |||||||||||||||||||||||||||||||||||
namf | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | SAYURI | |||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||
city | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | NEW YORK | EDISON | NEW YORK | EDISON | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | NEW YORK | EDISON | NEW YORK | EDISON | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | NEW YORK | EDISON | NEW YORK | EDISON | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | NEW YORK | EDISON | NEW YORK | EDISON | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | NEW YORK | EDISON | NEW YORK | EDISON | |||||||||||||||||||||||||||||||||||
st | CA | CA | CA | NY | NJ | NY | NJ | CA | CA | CA | NY | NJ | NY | NJ | CA | CA | CA | NY | NJ | NY | NJ | CA | CA | CA | NY | NJ | NY | NJ | CA | CA | CA | NY | NJ | NY | NJ | |||||||||||||||||||||||||||||||||||
zip4 | 94105 | 94105 | 94105 | 10016 | 08820 | 10016 | 08820 | 94105 | 94105 | 94105 | 10016 | 08820 | 10016 | 08820 | 94105 | 94105 | 94105 | 10016 | 08820 | 10016 | 08820 | 94105 | 94105 | 94105 | 10016 | 08820 | 10016 | 08820 | 94105 | 94105 | 94105 | 10016 | 08820 | 10016 | 08820 | |||||||||||||||||||||||||||||||||||
phon | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | 7327633281 | |||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||
sayuri@khandavilli@tiaa.org | sayuri@khandavilli@nuveen.com | sayuri.khandavilli@tiaa.org | sayuri.khandavilli@tiaa.org | None | sayuri.khandavilli@tiaa.org | None | sayuri@khandavilli@tiaa.org | sayuri@khandavilli@nuveen.com | sayuri.khandavilli@tiaa.org | sayuri.khandavilli@tiaa.org | None | sayuri.khandavilli@tiaa.org | None | sayuri@khandavilli@tiaa.org | sayuri@khandavilli@nuveen.com | sayuri.khandavilli@tiaa.org | sayuri.khandavilli@tiaa.org | None | sayuri.khandavilli@tiaa.org | None | sayuri@khandavilli@tiaa.org | sayuri@khandavilli@nuveen.com | sayuri.khandavilli@tiaa.org | sayuri.khandavilli@tiaa.org | None | sayuri.khandavilli@tiaa.org | None | sayuri@khandavilli@tiaa.org | sayuri@khandavilli@nuveen.com | sayuri.khandavilli@tiaa.org | sayuri.khandavilli@tiaa.org | None | sayuri.khandavilli@tiaa.org | None |
filer_id | 1389927 |
---|
filer_id | 1389927 | 1389927 | ||
---|---|---|---|---|
change_no | 1 | 0 | ||
session_id | 2017 | 2017 | ||
log_dt | 2017-03-16 00:00:00 | 2017-03-16 00:00:00 | ||
filer_type | 4 | 4 | ||
correction_flg | Y | Y | ||
action | DELETED | ADDED | ||
attribute_changed | EMPLOYER | EMPLOYER | ||
ethics_dt | None | None | ||
interests | None | None | ||
filer_full_name | KHANDAVILLI, SAYURI | KHANDAVILLI, SAYURI | ||
filer_city | None | None | ||
filer_st | None | None | ||
filer_zip | None | None | ||
filer_phone | None | None | ||
entity_type | 2 | 2 | ||
entity_name | TEACHERS INSURANCE AND ANNUITY ASSOCIATION (TIAA) | NUVEEN SERVICES, LLC | ||
entity_city | None | None | ||
entity_st | None | None | ||
entity_zip | None | None | ||
entity_phone | None | None | ||
entity_id | 1144455 | 1395472 | ||
responsible_officer | None | None | ||
effect_dt | 2017-03-14 00:00:00 | 2017-03-15 00:00:00 |