filing_id | 1618475 | 1631067 | 1704931 | 1674709 | 1652647 | 1631067 | 1733125 | 1795369 | 1779567 | 1763469 | 1812638 | 1839725 | 1906708 | 1839725 | 1867439 | 1929436 | 1994595 | 1979988 | 1960789 | 2059815 | 2009790 | 1994595 | 2030049 | 2096253 | 2129377 | |||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
sender_id | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | |||||||||||||||||||||||||
filer_id | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
filer_naml | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | BARINGS REAL ESTATE ADVISERS 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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
report_num | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | |||||||||||||||||||||||||
rpt_date | 2011-10-20 00:00:00 | 2012-01-24 00:00:00 | 2012-10-26 00:00:00 | 2012-07-26 00:00:00 | 2012-04-18 00:00:00 | 2012-03-05 00:00:00 | 2013-01-28 00:00:00 | 2013-10-17 00:00:00 | 2013-07-29 00:00:00 | 2013-04-29 00:00:00 | 2014-01-24 00:00:00 | 2014-04-21 00:00:00 | 2014-10-28 00:00:00 | 2014-07-02 00:00:00 | 2014-07-28 00:00:00 | 2015-01-26 00:00:00 | 2015-10-27 00:00:00 | 2015-07-30 00:00:00 | 2015-04-23 00:00:00 | 2016-07-28 00:00:00 | 2016-01-29 00:00:00 | 2016-02-05 00:00:00 | 2016-04-20 00:00:00 | 2016-10-26 00:00:00 | 2017-01-31 00:00:00 | |||||||||||||||||||||||||
from_date | 2011-07-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 | 2011-10-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-01-01 00:00:00 | 2014-07-01 00:00:00 | 2014-01-01 00:00:00 | 2014-04-01 00:00:00 | 2014-10-01 00:00:00 | 2015-07-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2016-04-01 00:00:00 | 2015-10-01 00:00:00 | 2015-07-01 00:00:00 | 2016-01-01 00:00:00 | 2016-07-01 00:00:00 | 2016-10-01 00:00:00 | |||||||||||||||||||||||||
thru_date | 2011-09-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 | 2011-12-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-03-31 00:00:00 | 2014-09-30 00:00:00 | 2014-03-31 00:00:00 | 2014-06-30 00:00:00 | 2014-12-31 00:00:00 | 2015-09-30 00:00:00 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 2016-06-30 00:00:00 | 2015-12-31 00:00:00 | 2015-09-30 00:00:00 | 2016-03-31 00:00:00 | 2016-09-30 00:00:00 | 2016-12-31 00:00:00 | |||||||||||||||||||||||||
cum_beg_dt | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 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 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
firm_city | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | |||||||||||||||||||||||||
firm_st | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | |||||||||||||||||||||||||
firm_zip4 | 06103 | 06103 | 06103 | 06103 | 06103 | 06103 | 06103 | 06103 | 06103 | 06103 | 06103 | 06103 | 06103 | 06103 | 06103 | 06103 | 06103 | 06103 | 06103 | 06103 | 06103 | 06103 | 06103 | 06103 | 06103 | |||||||||||||||||||||||||
firm_phon | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
sig_date | 2011-10-20 00:00:00 | 2012-01-24 00:00:00 | 2012-10-26 00:00:00 | 2012-07-26 00:00:00 | 2012-04-18 00:00:00 | 2012-03-05 00:00:00 | 2013-01-28 00:00:00 | 2013-10-17 00:00:00 | 2013-07-29 00:00:00 | 2013-04-29 00:00:00 | 2014-01-24 00:00:00 | 2014-04-21 00:00:00 | 2014-10-28 00:00:00 | 2014-07-02 00:00:00 | 2014-07-28 00:00:00 | 2015-01-26 00:00:00 | 2015-10-27 00:00:00 | 2015-07-30 00:00:00 | 2015-04-23 00:00:00 | 2016-07-28 00:00:00 | 2016-01-29 00:00:00 | 2016-02-05 00:00:00 | 2016-04-19 00:00:00 | 2016-10-26 00:00:00 | 2017-01-31 00:00:00 | |||||||||||||||||||||||||
sig_loc | Hartford, CT | Hartford, CT | Hartford, CT | Hartford, CT | Hartford, CT | Hartford CT | HARTFORD, CT | Hartford, CT | Hartford | Hartford, CT | Hartford CT | Hartford, CT | Hartford, CT | Hartford CT | Hartford CT | Hartford,CT | Hartford, CT | Hartford CT | Hartford, CT | Hartford, CT | Hartford, CT | Hartford, CT | Hartford, CT | Hartford, CT | Hartford, CT | |||||||||||||||||||||||||
sig_naml | Lilienthal | Lilienthal | Lilienthal | Lilienthal | Bond | Lilienthal | Bond | Bond | Bond | Lilienthal | Bond | Bond | Bond | Bond | Bond | Bond | Sitton | Bond | Bond | Sitton | Sitton | Lilienthal | Sitton | Sitton | Sitton | |||||||||||||||||||||||||
sig_namf | Martin | Martin | Martin | Martin | Graham | Martin | Graham | Graham | Graham | Martin | Graham | Graham | Graham | Graham | Graham | Graham | J.D. | Graham | Graham | J.D. | J.D. | Martin | J.D. | J.D. | J.D. | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
prn_naml | Lilienthal | Lilienthal | Lilienthal | Lilienthal | Bond | Lilienthal | Bond | Bond | Bond | Lilienthal | Bond | Bond | Bond | Bond | Bond | Bond | Sitton | Bond | Bond | Sitton | Sitton | Lilienthal | Sitton | Sitton | Sitton | |||||||||||||||||||||||||
prn_namf | Martin | Martin | Martin | Martin | Graham | Martin | Graham | Graham | Graham | Martin | Graham | Graham | Graham | Graham | Graham | Graham | J.D. | Graham | Graham | J.D. | J.D. | Martin | J.D. | J.D. | J.D. | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
sig_title | AVP - Compliance | AVP | AVP | AVP | M.D. | AVP | M.D. | MD | MD | AVP | MD | MD | M.D. | MD | MD | MD | Managing Director | MD | M.D. | Managing Director | Managing Director | AVP | Managing Director | Managing Director | Managing Director | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
lby_actvty | 1. University of California 2. San Diego County Employees Retirement Assoc. 3. San Diego City Employees Retirement Assoc. 4. LA County Employees Retirement System 5. LA City Employees Retirement Assoc. 6. Marin County Employees Retirement Assoc. 7. LA Water and Power Emplyees Retirement Plan | 1. University of California 2. San Diego County Employees Retirement Assoc. 3. LA County Employees Retirement System 4. Marin County Employees Retirement Assoc. | 1. SDCERA 2. SDCERS 3. Univ. of CA 4. Marin CERA 5. Mendocino CERA 6. SCERS | 1. LACERA 2. SDCERA 3. SDCERS 4. Univ. of CA | 1. LACERA 2. SDCERA 3. SDCERS 4. CalSTRS 5. UC Board of Regents | 1. University of California 2. San Diego County Employees Retirement Assoc. 3. LA County Employees Retirement System 4. Marin County Employees Retirement Assoc. | 1. SDCERA 2. SDCERS 3. Univ. of CA 4. Marin CERA 5. SCERS 6. LACERA | 1. LA County ERA 2. San Diego County ERA 3. Univ. of CA Regents 4. Alameda County ERA 5. Santa Barbara County ERS | 1. LA County ERA 2. San Diego County ERA 3. Mendocino County ERA 4. Sacramento County ERS | 1. San Francisco ERS 2. LA County ERA 3. San Diego County ERA 4. Univ. of CA 5. CalSTRS 6. San Diego City ERS 7. LA City ERS 8. Sonoma County ERA 9. Mendocino County ERA 10. Tulare County ERA 11. Sacramento County ERS | 1. LA County ERA 2. San Diego City ERA 3. Univ. of CA Regents | 1. LA County ERA 2. San Diego County ERA 3. Univ. of CA Regents | 1. Univ. of CA Regents 2. LACERA 3. SDCERA 4. SFERS 5. SCERS | 1. LA County ERA 2. San Diego County ERA 3. Univ. of CA Regents | 1. LA County ERA 2. San Diego County ERA 3. Univ. of CA Regents | 1. Univ. of CA Regents 2. SCERS 3. SDCERA 4. LACERA 5. SDCERA 6. CalSTRS | 1. Univ. of CA Regents 2. CalPERS 3. LACERA 4. SCERS 5. SDCERA | 1. Univ. of CA Regents 2. SCERS 3. OCERS 4. LACERA 5. SDCERA 6. Mendocino County | 1. Univ. of CA Regents 2. SCERS 3. OCERS 4. LACERA | 1. Univ. of CA Regents 2. CalPERS 3. CalSTRS | 1. Univ. of CA Regents 2. CalPERS | 1. Univ. of CA Regents 2. CalPERS 3. LACERA 4. SCERS 5. SDCERA | 1. Univ. of CA Regents 2. CalPERS 3. CalSTRS | 1. Univ. of CA Regents | 1. Univ. of CA Regents 2. 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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 |
filing_id | 1917569 | 1917569 | ||
---|---|---|---|---|
amend_id | 0 | 1 | ||
rec_type | CVR | CVR | ||
form_type | F603 | F603 | ||
sender_id | 1337608 | 1337608 | ||
filer_id | 1337608 | 1337608 | ||
entity_cd | LEM | LEM | ||
filer_naml | CORNERSTONE REAL ESTATE ADVISERS LLC | BARINGS REAL ESTATE ADVISERS LLC | ||
filer_namf | None | None | ||
filer_namt | None | None | ||
filer_nams | None | None | ||
report_num | 000 | 001 | ||
rpt_date | 2014-12-09 00:00:00 | 2016-10-26 00:00:00 | ||
ls_beg_yr | 2015 | 2015 | ||
ls_end_yr | 2016 | 2016 | ||
qual_date | None | None | ||
eff_date | None | None | ||
bus_city | HARTFORD | HARTFORD | ||
bus_st | CT | CT | ||
bus_zip4 | 06103 | 06103 | ||
bus_phon | 8605092200 | 8605092200 | ||
bus_fax | None | None | ||
bus_email | None | [email protected] | ||
mail_city | None | None | ||
mail_st | None | None | ||
mail_zip4 | None | None | ||
mail_phon | None | None | ||
sig_date | 2014-12-09 00:00:00 | 2016-10-26 00:00:00 | ||
sig_loc | None | None | ||
sig_naml | Bond | Lilienthal | ||
sig_namf | Graham | Martin | ||
sig_namt | None | None | ||
sig_nams | None | None | ||
prn_naml | Bond | Lilienthal | ||
prn_namf | Graham | Martin | ||
prn_namt | None | None | ||
prn_nams | None | None | ||
sig_title | MD | AVP | ||
stmt_firm | None | None | ||
ind_cb | None | None | ||
bus_cb | X | X | ||
trade_cb | None | None | ||
oth_cb | None | None | ||
a_b_name | None | None | ||
a_b_city | None | None | ||
a_b_st | None | None | ||
a_b_zip4 | None | None | ||
descrip_1 | None | None | ||
descrip_2 | Cornerstone is an SEC registered investment adviser specializing in real estate. It markets its products and services to institutional investors, including private and public pension plans, foundations and taxable entities, nationwide. | Cornerstone is an SEC registered investment adviser specializing in real estate. It markets its products and services to institutional investors, including private and public pension plans, foundations and taxable entities, nationwide. | ||
c_less50 | None | None | ||
c_more50 | None | None | ||
ind_class | None | None | ||
ind_descr | None | None | ||
bus_class | OTH | OTH | ||
bus_descr | Investment Adviser | Investment Adviser | ||
auth_name | None | None | ||
auth_city | None | None | ||
auth_st | None | None | ||
auth_zip4 | None | None | ||
lobby_int | Cornerstone is an SEC registered investment adviser specializing in real estate, marketing its products and services to California governmental pension plans. | Cornerstone is an SEC registered investment adviser specializing in real estate, marketing its products and services to California governmental pension plans. | ||
influen_yn | None | None | ||
firm_name | None | None | ||
newcert_cb | None | None | ||
rencert_cb | None | None | ||
complet_dt | None | None | ||
lby_reg_cb | None | None | ||
lby_604_cb | None | None | ||
st_leg_yn | None | None | ||
st_agency | None | None | ||
lobby_cb | None | None | ||
l_firm_cb | None | None |
filer_id | 1337608 | 1337608 | 1337608 | |||
---|---|---|---|---|---|---|
adrid | 2213845 | 2277715 | 2340718 | |||
effect_dt | 2011-02-16 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | |||
add_type | 7051 | 7051 | 7051 | |||
session_id | 2011 | 2013 | 2015 |
filer_id | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 1779567 | 1979988 | 1839725 | 1839725 | 1795369 | 1960789 | 1917569 | 1906708 | 1584418 | 1593970 | 1592492 | 1631067 | 1609697 | 1618475 | 1652647 | 1631067 | 1812638 | 1674709 | 1929436 | 1923347 | 1704931 | 1867439 | 1721120 | 1763469 | 1733125 | 1994595 | 1994595 | 1989397 | 2009790 | 2030049 | 2055566 | 2059815 | 1917569 | 2096253 | 2129377 | 2108079 | ||||||||||||||||||||||||||||||||||||
period_id | 214 | 222 | 217 | 217 | 215 | 221 | 220 | 219 | None | None | None | 208 | None | 207 | 209 | 208 | 216 | 210 | 220 | None | 211 | 218 | None | 213 | 212 | 223 | 223 | None | 224 | 225 | None | 226 | 228 | 227 | 228 | None | ||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F603 | F635 | F603 | F605 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F603 | F635 | F635 | F603 | F635 | F635 | F635 | F635 | F605 | F635 | F635 | F605 | F635 | F603 | F635 | F635 | F605 | ||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 1 | 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 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||
filing_date | 2013-07-29 00:00:00 | 2015-07-30 00:00:00 | 2014-07-02 00:00:00 | 2014-04-21 00:00:00 | 2013-10-17 00:00:00 | 2015-04-23 00:00:00 | 2014-12-09 00:00:00 | 2014-10-28 00:00:00 | 2011-03-02 00:00:00 | 2011-04-08 00:00:00 | 2011-05-02 00:00:00 | 2012-01-24 00:00:00 | 2011-07-29 00:00:00 | 2011-10-20 00:00:00 | 2012-04-18 00:00:00 | 2012-03-05 00:00:00 | 2014-01-24 00:00:00 | 2012-07-26 00:00:00 | 2015-01-26 00:00:00 | 2014-12-19 00:00:00 | 2012-10-26 00:00:00 | 2014-07-28 00:00:00 | 2012-12-24 00:00:00 | 2013-04-29 00:00:00 | 2013-01-28 00:00:00 | 2016-02-05 00:00:00 | 2015-10-27 00:00:00 | 2015-09-18 00:00:00 | 2016-01-29 00:00:00 | 2016-04-20 00:00:00 | 2016-07-13 00:00:00 | 2016-07-28 00:00:00 | 2016-10-26 00:00:00 | 2016-10-26 00:00:00 | 2017-01-31 00:00:00 | 2016-11-18 00:00:00 | ||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10006 | 10005 | 10001 | 10005 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10002 | 10001 | 10006 | 10001 | 10001 | 10006 | 10001 | 10002 | 10001 | 10001 | 10006 | ||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | ||||||||||||||||||||||||||||||||||||
session_id | 2013 | 2015 | 2013 | 2013 | 2013 | 2015 | 2015 | 2013 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2011 | 2013 | 2015 | 2011 | 2013 | 2013 | 2013 | 2011 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | ||||||||||||||||||||||||||||||||||||
user_id | AGLADNEY | AGLADNEY | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | PBANFORD | AGLADNEY | PBANFORD | ASAETERN | AGLADNEY | ASAETERN | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | PBANFORD | ASAETERN | AGLADNEY | GKURIMOT | ASAETERN | ASAETERN | AGLADNEY | AGLADNEY | YRODRIGU | AGLADNEY | AGLADNEY | PBANFORD | AGLADNEY | YRODRIGU | AGLADNEY | AGLADNEY | YRODRIGU | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | ||||||||||||||||||||||||||||||||||||
rpt_start | 2013-04-01 00:00:00 | 2015-04-01 00:00:00 | 2014-01-01 00:00:00 | 2014-01-01 00:00:00 | 2013-07-01 00:00:00 | 2015-01-01 00:00:00 | 2014-12-09 00:00:00 | 2014-07-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-10-01 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 2012-01-01 00:00:00 | 2011-10-01 00:00:00 | 2013-10-01 00:00:00 | 2012-04-01 00:00:00 | 2014-10-01 00:00:00 | 1900-01-01 00:00:00 | 2012-07-01 00:00:00 | 2014-04-01 00:00:00 | 1900-01-01 00:00:00 | 2013-01-01 00:00:00 | 2012-10-01 00:00:00 | 2015-07-01 00:00:00 | 2015-07-01 00:00:00 | 1900-01-01 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-10-26 00:00:00 | 2016-07-01 00:00:00 | 2016-10-01 00:00:00 | 1900-01-01 00:00:00 | ||||||||||||||||||||||||||||||||||||
rpt_end | 2013-06-30 00:00:00 | 2015-06-30 00:00:00 | 2014-03-31 00:00:00 | 2014-03-31 00:00:00 | 2013-09-30 00:00:00 | 2015-03-31 00:00:00 | 2014-12-09 00:00:00 | 2014-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2011-03-31 00:00:00 | 2011-12-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2012-03-31 00:00:00 | 2011-12-31 00:00:00 | 2013-12-31 00:00:00 | 2012-06-30 00:00:00 | 2014-12-31 00:00:00 | 1900-01-01 00:00:00 | 2012-09-30 00:00:00 | 2014-06-30 00:00:00 | 1900-01-01 00:00:00 | 2013-03-31 00:00:00 | 2012-12-31 00:00:00 | 2015-09-30 00:00:00 | 2015-09-30 00:00:00 | 1900-01-01 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 1900-01-01 00:00:00 | 2016-06-30 00:00:00 | 2016-10-26 00:00:00 | 2016-09-30 00:00:00 | 2016-12-31 00:00:00 | 1900-01-01 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 | ||||||||||||||||||||||||||||||||||||
filing_type | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | None | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | None |
filer_id | 1337608 | 1337608 | 1337608 | |||
---|---|---|---|---|---|---|
session_id | 2013 | 2011 | 2015 | |||
interest_cd | 40312 | 40312 | 40312 | |||
effect_date | 2013-01-01 00:00:00 | 2011-02-16 00:00:00 | 2015-01-01 00:00:00 |
filer_id | 1337608 | 1337608 | 1337608 | |||
---|---|---|---|---|---|---|
filer_type | 2 | 2 | 2 | |||
active | Y | Y | Y | |||
race | 0 | None | None | |||
session_id | 2011 | 2013 | 2015 | |||
category | 0 | None | None | |||
category_type | 0 | None | None | |||
sub_category | 0 | None | None | |||
effect_dt | 2011-02-16 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | |||
sub_category_type | 0 | None | None | |||
election_type | 0 | None | None | |||
sub_category_a | None | None | None | |||
nyq_dt | None | None | None | |||
party_cd | 0 | None | None | |||
county_cd | 0 | None | None | |||
district_cd | 0 | None | None |
filer_id | 1337608 | |
---|---|---|
xref_id | 1337608 | |
effect_dt | 2011-03-29 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | 1337608 | |||||||||||||||
filer_type | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | |||||||||||||||
status | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | |||||||||||||||
effect_dt | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | |||||||||||||||
naml | BARINGS REAL ESTATE ADVISERS LLC | BARINGS REAL ESTATE ADVISERS LLC | BARINGS REAL ESTATE ADVISERS LLC | BARINGS REAL ESTATE ADVISERS LLC | BARINGS REAL ESTATE ADVISERS LLC | BARINGS REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | |||||||||||||||
namf | 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 | |||||||||||||||
nams | 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 | |||||||||||||||
adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
city | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | HARTFORD | |||||||||||||||
st | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | CT | |||||||||||||||
zip4 | 06103 | 06103 | 06103 | 06103 | 06103 | 06103 | 06103 | 06103 | 06103 | 06103 | 06103 | 06103 | 06103 | 06103 | 06103 | |||||||||||||||
phon | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | 8605092200 | |||||||||||||||
fax | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
None | None | [email protected] | None | None | [email protected] | None | None | [email protected] | None | None | [email protected] | None | None | [email protected] |
filer_id | 1337608 |
---|
filer_id | 1337608 | 1337608 | 1337608 | |||
---|---|---|---|---|---|---|
change_no | 0 | 1 | 2 | |||
session_id | 2011 | 2015 | 2015 | |||
log_dt | 2011-03-02 00:00:00 | 2015-09-18 00:00:00 | 2015-09-18 00:00:00 | |||
filer_type | 2 | 2 | 2 | |||
correction_flg | Y | Y | Y | |||
action | ADDED | TERMINATED | ADDED | |||
attribute_changed | LOBBYIST | LOBBYIST | LOBBYIST | |||
ethics_dt | None | None | None | |||
interests | None | None | None | |||
filer_full_name | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | CORNERSTONE REAL ESTATE ADVISERS LLC | |||
filer_city | None | None | HARTFORD | |||
filer_st | None | None | CT | |||
filer_zip | None | None | 06103 | |||
filer_phone | None | None | 8605092200 | |||
entity_type | 4 | 4 | 4 | |||
entity_name | KENDAL, PATRICK T. | BOND, GRAHAM J. | SITTON, J.D. | |||
entity_city | None | None | None | |||
entity_st | None | None | None | |||
entity_zip | None | None | None | |||
entity_phone | None | None | None | |||
entity_id | 1337610 | 1338571 | None | |||
responsible_officer | None | None | None | |||
effect_dt | 2011-02-16 00:00:00 | 2015-08-31 00:00:00 | 2015-09-14 00:00:00 |