filing_id | 2571945 | 2526984 | 2526984 | 2638097 | 2615748 | 2582157 | 2593128 | 2615748 | 2700739 | 2737311 | 2670606 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | |||||||||||
rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | |||||||||||
form_type | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | |||||||||||
sender_id | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | |||||||||||
filer_id | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | |||||||||||
entity_cd | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | |||||||||||
filer_naml | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | |||||||||||
filer_namf | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | |||||||||||
filer_namt | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
filer_nams | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
report_num | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | |||||||||||
rpt_date | 2021-04-05 00:00:00 | 2021-01-07 00:00:00 | 2020-10-29 00:00:00 | 2022-01-26 00:00:00 | 2021-10-13 00:00:00 | 2021-05-03 00:00:00 | 2021-07-14 00:00:00 | 2021-10-13 00:00:00 | 2022-07-25 00:00:00 | 2022-10-20 00:00:00 | 2022-04-26 00:00:00 | |||||||||||
from_date | 2020-10-01 00:00:00 | 2020-07-01 00:00:00 | 2020-07-01 00:00:00 | 2021-10-01 00:00:00 | 2021-07-01 00:00:00 | 2021-01-01 00:00:00 | 2021-04-01 00:00:00 | 2021-07-01 00:00:00 | 2022-04-01 00:00:00 | 2022-07-01 00:00:00 | 2022-01-01 00:00:00 | |||||||||||
thru_date | 2020-12-31 00:00:00 | 2020-09-30 00:00:00 | 2020-09-30 00:00:00 | 2021-12-31 00:00:00 | 2021-09-30 00:00:00 | 2021-03-31 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2022-06-30 00:00:00 | 2022-09-30 00:00:00 | 2022-03-31 00:00:00 | |||||||||||
cum_beg_dt | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
firm_id | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | |||||||||||
firm_name | Waterfall Asset Management, LLC | Waterfall Asset Management, LLC | Waterfall Asset Management, LLC | Waterfall Asset Management, LLC | Waterfall Asset Management, LLC | Waterfall Asset Management, LLC | Waterfall Asset Management, LLC | Waterfall Asset Management, LLC | Waterfall Asset Management, LLC | Waterfall Asset Management, LLC | Waterfall Asset Management, LLC | |||||||||||
firm_city | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | |||||||||||
firm_st | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | |||||||||||
firm_zip4 | 10020 | 10020 | 10020 | 10020 | 10020 | 10020 | 10020 | 10020 | 10020 | 10020 | 10020 | |||||||||||
firm_phon | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | |||||||||||
mail_city | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
mail_st | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
mail_zip4 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
mail_phon | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
sig_date | 2021-04-05 00:00:00 | 2021-01-08 00:00:00 | 2020-10-29 00:00:00 | 2022-01-26 00:00:00 | 2021-10-13 00:00:00 | 2021-05-03 00:00:00 | 2021-07-14 00:00:00 | 2021-10-13 00:00:00 | 2022-07-25 00:00:00 | 2022-10-20 00:00:00 | 2022-04-26 00:00:00 | |||||||||||
sig_loc | New York, New York | New York NY, | New York | New York, New York | New York, New York | New York, New York | New York, NY | New York, New York | New York, New York | New York, New York | New York, New York | |||||||||||
sig_naml | Andrews | Andrews | Andrews | Andrews | Eliran | Andrews | Andrews | Andrews | Andrews | Andrews | Andrews | |||||||||||
sig_namf | John | John | John | John | Sharon | John | John | John | John | John | John | |||||||||||
sig_namt | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
sig_nams | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
prn_naml | Andrews | Andrews | Andrews | Andrews | Eliran | Andrews | Andrews | Andrews | Andrews | Andrews | Andrews | |||||||||||
prn_namf | John | John | John | John | Sharon | John | John | John | John | John | John | |||||||||||
prn_namt | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
prn_nams | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
sig_title | Managing Director | Managing Director | Managing Director | Managing Director | Managing Director | Managing Director | Managing Director | Managing Director | Managing Director | Managing Director | Managing Director | |||||||||||
nopart1_cb | X | X | X | X | X | X | X | X | X | X | X | |||||||||||
nopart2_cb | 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 | |||||||||||
part1_2_cb | 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 | |||||||||||
ctrib_y_cb | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
lby_actvty | 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 | |||||||||||
lobby_y_cb | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
major_naml | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
major_namf | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
major_namt | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
major_nams | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
rcpcmte_nm | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
rcpcmte_id | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 2212810 | 2409810 | 2484238 | 2508679 | 2467651 | 2255856 | 2546820 | 2340534 | 2324751 | |||||||||
effect_dt | 2011-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-07-01 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2013-01-01 00:00:00 | 2023-01-01 00:00:00 | 2015-01-01 00:00:00 | 2014-08-05 00:00:00 | |||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | |||||||||
session_id | 2011 | 2017 | 2019 | 2021 | 2019 | 2013 | 2023 | 2015 | 2013 |
filer_id | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2011 | 2013 | 2015 | 2017 | 2019 | 2021 | ||||||
ethics_date | 2011-08-11 00:00:00 | 2013-04-11 00:00:00 | 2015-04-09 00:00:00 | 2017-06-22 00:00:00 | 2019-06-27 00:00:00 | 2021-03-12 00:00:00 |
filer_id | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 1786345 | 1966802 | 1970685 | 1801868 | 1960540 | 1580880 | 1590427 | 1620068 | 1631277 | 1609741 | 1659136 | 1613104 | 1684786 | 1684778 | 1930644 | 1913330 | 1719229 | 1714361 | 1877545 | 1877441 | 1767055 | 1748846 | 1758692 | 1995669 | 1984380 | 2322937 | 2405731 | 2450378 | 2010178 | 2046449 | 2066939 | 2112645 | 2164310 | 2172986 | 2148166 | 2148173 | 2160570 | 2270487 | 2219649 | 2245835 | 2475660 | 2188850 | 2354864 | 2526984 | 2410017 | 2382612 | 2407098 | 2420653 | 2531492 | 2615748 | 2582157 | 2638097 | 2615748 | 2700739 | 2571945 | 2593128 | 2592134 | 2526984 | 2670606 | 2737311 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 230 | None | None | None | None | None | 233 | 241 | 231 | None | 243 | None | None | None | None | None | 247 | 245 | 248 | 247 | 250 | 244 | 246 | None | 243 | 249 | 251 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | F615 | F604 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F690 | F615 | F615 | F615 | F604 | F615 | F604 | F606 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 2013-07-22 00:00:00 | 2015-04-27 00:00:00 | 2015-06-09 00:00:00 | 2013-10-31 00:00:00 | 2015-04-09 00:00:00 | 2011-02-24 00:00:00 | 2011-04-28 00:00:00 | 2011-10-26 00:00:00 | 2012-01-24 00:00:00 | 2011-07-27 00:00:00 | 2012-04-30 00:00:00 | 2011-08-11 00:00:00 | 2012-08-01 00:00:00 | 2012-07-31 00:00:00 | 2015-01-23 00:00:00 | 2014-10-28 00:00:00 | 2012-12-13 00:00:00 | 2012-11-02 00:00:00 | 2014-08-13 00:00:00 | 2014-08-13 00:00:00 | 2013-04-30 00:00:00 | 2013-01-29 00:00:00 | 2013-04-11 00:00:00 | 2015-10-20 00:00:00 | 2015-07-21 00:00:00 | 2018-10-23 00:00:00 | 2019-07-31 00:00:00 | 2020-01-28 00:00:00 | 2016-01-25 00:00:00 | 2016-04-21 00:00:00 | 2016-07-28 00:00:00 | 2016-11-21 00:00:00 | 2017-06-22 00:00:00 | 2017-07-21 00:00:00 | 2017-02-07 00:00:00 | 2017-02-07 00:00:00 | 2017-05-01 00:00:00 | 2018-07-26 00:00:00 | 2018-01-30 00:00:00 | 2018-04-30 00:00:00 | 2020-05-26 00:00:00 | 2017-10-18 00:00:00 | 2019-01-30 00:00:00 | 2020-10-29 00:00:00 | 2019-08-02 00:00:00 | 2019-04-30 00:00:00 | 2019-06-27 00:00:00 | 2019-10-31 00:00:00 | 2020-07-31 00:00:00 | 2021-10-13 00:00:00 | 2021-05-03 00:00:00 | 2022-01-26 00:00:00 | 2021-10-13 00:00:00 | 2022-07-25 00:00:00 | 2021-04-05 00:00:00 | 2021-07-14 00:00:00 | 2021-03-30 00:00:00 | 2021-01-07 00:00:00 | 2022-04-26 00:00:00 | 2022-10-20 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10005 | 10005 | 10005 | 10005 | 10006 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10006 | 10006 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10003 | 10005 | 10005 | 10006 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10006 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10001 | 10006 | 10005 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10005 | 10002 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 2013 | 2013 | 2015 | 2013 | 2015 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2013 | 2011 | 2013 | 2013 | 2013 | 2011 | 2013 | 2015 | 2015 | 2017 | 2019 | 2019 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2019 | 2017 | 2017 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2019 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | ASAETERN | AGLADNEY | YRODRIGU | ASAETERN | PBANFORD | CFLAGG | ASAETERN | AGLADNEY | ASAETERN | ASAETERN | AGLADNEY | MPACHECO | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | GKURIMOT | ASAETERN | YRODRIGU | YRODRIGU | AGLADNEY | AGLADNEY | SMCCONNAN | AGLADNEY | MPACHECO | AGLADNEY | AGLADNEY | MKIRKHAM | AGLADNEY | AGLADNEY | AGLADNEY | GPEREZ | PBANFORD | SMCCONNAN | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | MKIRKHAM | AGLADNEY | AGLADNEY | GTAYLOR | SARRIAGA | AGLADNEY | SARRIAGA | AGLADNEY | MKIRKHAM | GTAYLOR | AROJAS | RATTIYEH | GTAYLOR | CAFILER | LPHEAV | CHATRIDGE | MMERCHANT | GTAYLOR | CAFILER | CAFILER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 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 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 2013-04-01 00:00:00 | 2015-01-01 00:00:00 | 1900-01-01 00:00:00 | 2013-07-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-07-01 00:00:00 | 2011-09-30 00:00:00 | 2011-04-01 00:00:00 | 2012-01-01 00:00:00 | 1900-01-01 00:00:00 | 2011-10-01 00:00:00 | 2012-04-01 00:00:00 | 2014-10-01 00:00:00 | 2014-08-05 00:00:00 | 1900-01-01 00:00:00 | 2012-07-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2013-01-01 00:00:00 | 2012-10-01 00:00:00 | 1900-01-01 00:00:00 | 2015-07-01 00:00:00 | 2015-04-01 00:00:00 | 2018-07-01 00:00:00 | 2019-04-01 00:00:00 | 2019-10-01 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-04-01 00:00:00 | 2016-07-01 00:00:00 | 2016-10-01 00:00:00 | 2017-01-01 00:00:00 | 2018-04-01 00:00:00 | 2017-10-01 00:00:00 | 2018-01-01 00:00:00 | 2020-01-01 00:00:00 | 2017-07-01 00:00:00 | 2018-10-01 00:00:00 | 2020-07-01 00:00:00 | 1900-01-01 00:00:00 | 2019-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-07-01 00:00:00 | 2020-04-01 00:00:00 | 2021-07-01 00:00:00 | 2021-01-01 00:00:00 | 2021-10-01 00:00:00 | 2021-07-01 00:00:00 | 2022-04-01 00:00:00 | 2020-10-01 00:00:00 | 2021-04-01 00:00:00 | 1900-01-01 00:00:00 | 2020-07-01 00:00:00 | 2022-01-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 2013-06-30 00:00:00 | 2015-03-31 00:00:00 | 1900-01-01 00:00:00 | 2013-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2011-03-31 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2011-06-30 00:00:00 | 2012-03-31 00:00:00 | 1900-01-01 00:00:00 | 2011-12-31 00:00:00 | 2012-06-30 00:00:00 | 2014-12-31 00:00:00 | 2014-09-30 00:00:00 | 1900-01-01 00:00:00 | 2012-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2013-03-31 00:00:00 | 2012-12-31 00:00:00 | 1900-01-01 00:00:00 | 2015-09-30 00:00:00 | 2015-06-30 00:00:00 | 2018-09-30 00:00:00 | 2019-06-30 00:00:00 | 2019-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-06-30 00:00:00 | 2016-09-30 00:00:00 | 2016-12-31 00:00:00 | 2017-03-31 00:00:00 | 2018-06-30 00:00:00 | 2017-12-31 00:00:00 | 2018-03-31 00:00:00 | 2020-03-31 00:00:00 | 2017-09-30 00:00:00 | 2018-12-31 00:00:00 | 2020-09-30 00:00:00 | 1900-01-01 00:00:00 | 2019-03-31 00:00:00 | 1900-01-01 00:00:00 | 2019-09-30 00:00:00 | 2020-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-03-31 00:00:00 | 2021-12-31 00:00:00 | 2021-09-30 00:00:00 | 2022-06-30 00:00:00 | 2020-12-31 00:00:00 | 2021-06-30 00:00:00 | 1900-01-01 00:00:00 | 2020-09-30 00:00:00 | 2022-03-31 00:00:00 | 2022-09-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 22006 | None | None | None | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 |
filer_id | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |||||||||
active | Y | Y | T | Y | Y | Y | Y | Y | N | |||||||||
race | 0 | None | None | None | None | None | None | None | None | |||||||||
session_id | 2011 | 2013 | 2013 | 2013 | 2019 | 2015 | 2021 | 2017 | 2023 | |||||||||
category | 0 | None | None | None | None | None | None | None | None | |||||||||
category_type | 0 | None | None | None | None | None | None | None | None | |||||||||
sub_category | 0 | None | None | None | None | None | None | None | None | |||||||||
effect_dt | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-08-28 00:00:00 | 2014-08-05 00:00:00 | 2019-01-01 00:00:00 | 2015-01-01 00:00:00 | 2021-01-01 00:00:00 | 2017-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||||
sub_category_type | 0 | None | None | None | None | None | None | None | None | |||||||||
election_type | 0 | None | None | None | None | None | None | None | None | |||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | |||||||||
nyq_dt | None | None | None | None | None | None | None | None | None | |||||||||
party_cd | 0 | None | None | None | None | None | None | None | None | |||||||||
county_cd | 0 | None | None | None | None | None | None | None | None | |||||||||
district_cd | 0 | None | None | None | None | None | None | None | None |
filer_id | 1337095 | |
---|---|---|
xref_id | 1337095 | |
effect_dt | 2011-03-03 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | 1337095 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
effect_dt | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 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 | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | ANDREWS | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN R. | JOHN RUSSELL | JOHN RUSSELL | JOHN RUSSELL | JOHN RUSSELL | JOHN RUSSELL | JOHN RUSSELL | JOHN RUSSELL | JOHN RUSSELL | JOHN RUSSELL | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr1 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | NEW YORK | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
st | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | NY | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 10036 | 10036 | 10036 | 10036 | 10036 | 10036 | 10020 | 10020 | 10036 | 10036 | 10036 | 10036 | 10036 | 10036 | 10020 | 10020 | 10036 | 10036 | 10036 | 10036 | 10036 | 10036 | 10020 | 10020 | 10036 | 10036 | 10036 | 10036 | 10036 | 10036 | 10020 | 10020 | 10020 | 10020 | 10020 | 10020 | 10036 | 10036 | 10036 | 10036 | 10036 | 10036 | 10020 | 10020 | 10020 | 10036 | 10036 | 10036 | 10036 | 10036 | 10036 | 10020 | 10020 | 10020 | 10036 | 10036 | 10036 | 10036 | 10036 | 10036 | 10020 | 10020 | 10020 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 2128438935 | 2127302000 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2128438935 | 2127302000 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2128438935 | 2127302000 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2128438935 | 2127302000 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2128438935 | 2127302000 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2128438935 | 2127302000 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2128438935 | 2127302000 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | 2122574600 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | None | 2122574699 | 2122574699 | 2122574699 | None | None | 2122574699 | 2122574699 | 2122574699 | None | None | 2122574699 | 2122574699 | 2122574699 | None | None | 2122574699 | 2122574699 | 2122574699 | None | None | 2122574699 | 2122574699 | 2122574699 | None | None | 2122574699 | 2122574699 | 2122574699 | None | None | 2122574699 | 2122574699 | 2122574699 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
[email protected] | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] |
filer_id | 1337095 |
---|
filer_id | 1337095 | 1337095 | 1337095 | 1337095 | ||||
---|---|---|---|---|---|---|---|---|
change_no | 1 | 0 | 2 | 3 | ||||
session_id | 2013 | 2013 | 2013 | 2015 | ||||
log_dt | 2013-10-31 00:00:00 | 2014-08-13 00:00:00 | 2014-08-13 00:00:00 | 2015-06-09 00:00:00 | ||||
filer_type | 4 | 4 | 4 | 4 | ||||
correction_flg | None | None | None | Y | ||||
action | DELETED | ADDED | TERMINATED | ADDED | ||||
attribute_changed | EMPLOYER | EMPLOYER | EMPLOYER | |||||
ethics_dt | None | None | None | None | ||||
interests | None | None | None | None | ||||
filer_full_name | JOHN RUSSELL ANDREWS | JOHN RUSSELL ANDREWS | ANDREWS, JOHN RUSSELL | ANDREWS, JOHN R. | ||||
filer_city | None | None | None | NEW YORK | ||||
filer_st | None | None | None | NY | ||||
filer_zip | None | None | None | 10036 | ||||
filer_phone | None | None | None | 2127302000 | ||||
entity_type | 2 | 2 | 4 | 2 | ||||
entity_name | M.D. SASS SECURITIES, LLC | WATERFALL ASSET MANAGEMENT, LLC | None | WATERFALL ASSET MANAGEMENT, LLC | ||||
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 | 1337093 | 1369587 | 0 | None | ||||
responsible_officer | None | None | None | None | ||||
effect_dt | 2013-08-28 00:00:00 | 2014-08-05 00:00:00 | 2013-08-28 00:00:00 | 2015-01-01 00:00:00 |