FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

73 rows where Registration_Number = 1839

✎ View and edit SQL

This data as json, CSV (advanced)

State 1

Registration_Number 1

  • Milbank, Tweed, Hadley & McCloy · 73 ✖

Registrant_Name 1

City 1

Link rowid ▼ Short_Form_Termination_Date Short_Form_Date Short_Form_Last_Name Short_Form_First_Name Registration_Number Registration_Date Registrant_Name Address_1 Address_2 City State Zip
2569 2569 1975-01-01 1974-08-01 Wang Francis S.L. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
2572 2572 1976-01-01 1975-02-18 Young John Timothy Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
2576 2576 1977-01-01 1975-08-20 Mandel Stuart Jay Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
2579 2579 1978-01-01 1975-02-18 Haberkern Roy C. , Jr. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
2587 2587 1980-01-01 1977-03-01 Schechter Diane Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
2596 2596 1982-01-01 1965-01-11 Kyle Charles Derrick Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
2597 2597 1982-01-01 1977-03-01 Rogers John E. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
2599 2599 1982-01-01 1974-08-01 Borsook Lana R. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
2600 2600 1982-01-01 1976-09-18 Randt Clark T. , Jr. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
2632 2632 1986-01-01 1986-01-23 Liu Theodore Em-Po Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
2637 2637 1986-01-01 1966-08-09 Shapiro Isaac Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
2651 2651 1987-01-01 1986-08-08 Mathias D. Stephen Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
2661 2661 1988-01-01 1972-01-20 Smith Briscoe R. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
2668 2668 1988-01-01 1974-08-13 Keebler Stuart E. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
3155 3155 1980-01-04 1978-03-01 Castleberry William Lesse Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
3614 3614 1979-01-12 1977-08-23 Conner John T. , Jr. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6541 6541 1992-02-10 1986-01-23 Fletcher Phillip Douglas Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6542 6542 1992-02-10 1986-01-23 Marcuss Stanley J. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6543 6543 1992-02-10 1971-02-19 Mortimer Peter M. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6544 6544 1992-02-10 1977-03-01 Siphron Joseph R. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6545 6545 1992-02-10 1977-03-01 Wight Richard J. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6546 6546 1992-02-10 1978-03-01 Brach Richard S. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6547 6547 1992-02-10 1978-03-01 Gerstell Glenn S. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6548 6548 1992-02-10 1978-03-01 Gewirtz Elliot Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6549 6549 1992-02-10 1978-03-01 Tufaro Richard C. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6550 6550 1992-02-10 1985-03-01 Persinger Joseph M. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6551 6551 1992-02-10 1978-03-06 Dean John W. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6552 6552 1992-02-10 1991-03-27 Bajak Curtis W. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6553 6553 1992-02-10 1991-04-09 von Mehren Philip T. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6554 6554 1992-02-10 1974-04-17 White Harry E. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6555 6555 1992-02-10 1965-06-22 Brewster Walter Rice Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6557 6557 1992-02-10 1987-07-02 Harris David J. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6558 6558 1992-02-10 1987-07-02 Tuttle Baldwin B. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6559 6559 1992-02-10 1990-07-11 Dammers Clifford R. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6560 6560 1992-02-10 1966-08-09 Williams Thomas Allison Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6561 6561 1992-02-10 1971-08-13 Hardin Adlai S. , Jr. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6562 6562 1992-02-10 1974-08-13 Cooke Warren F. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6563 6563 1992-02-10 1974-08-13 Radick Barry G. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6564 6564 1992-02-10 1979-08-15 Immergut Mel M. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6565 6565 1992-02-10 1975-08-20 Farabaugh Eugene F. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6566 6566 1992-02-10 1975-08-21 Brooks Russell E. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6567 6567 1992-02-10 1977-08-23 Forsyth George J. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6568 6568 1992-02-10 1977-08-23 Kneip Frederick C. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6569 6569 1992-02-10 1977-08-23 Siegfried David C. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6570 6570 1992-02-10 1975-09-02 Holderness G. Malcolm Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6571 6571 1992-02-10 1967-10-10 Logan Francis D. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6572 6572 1992-02-10 1967-10-10 Peet Charles D. , Jr. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
9505 9505 1979-03-09 1977-03-01 Shields Day R. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
9506 9506 1979-03-09 1978-03-01 White Scott Bennett Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
9830 9830 1989-03-14 1965-01-11 McCloy John J. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
15352 15352 1981-05-01 1978-03-06 Simmons Harry L. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
15959 15959 1971-05-09 1965-01-11 DuVal Clive Livingston , II Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
18628 18628 1978-06-02 1978-03-01 Frederick Samuel. A. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
18743 18743 1977-06-03 1974-08-01 Boyle Roger Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
22193 22193 1990-07-01 1965-01-11 Orr Michael Frank Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
22625 22625 1979-07-06 1978-03-01 Isaacson Marilyn Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
26154 26154 1981-08-07 1977-03-01 Altschuler Fredric L. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
26821 26821 1978-08-16 1976-09-18 Sutcliffe Ralph J. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
27401 27401 1977-08-25 1977-03-01 Harvey Thomas E. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
27703 27703 1986-08-29 1986-01-23 Bauman Dena R. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
29204 29204 1975-09-05 1975-08-20 Wolf G. Velsor , Jr. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
30262 30262 1986-09-22 1978-03-01 Levin Michael J. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
31060 31060 1990-09-30 1986-08-11 Green Carl J. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
32506 32506 1991-10-09 1977-08-23 Schlesinger Anthony D. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
35936 35936 1977-11-16 1977-03-01 Osborne John S. , Jr. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
40060 40060 1978-12-31 1965-01-11 Steifel Edward Henry Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
40123 40123 1980-12-31 1977-03-01 Kirkland Arthur C. , Jr. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
40124 40124 1980-12-31 1977-03-01 Reichard Peter J. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
40312 40312 1985-12-31 1978-03-01 Murray Ralph C. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
40450 40450 1988-12-31 1965-01-11 Stark Richard Alvin Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
40469 40469 1988-12-31 1985-03-29 Richardson Elliot L. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
40640 40640 1990-12-31 1971-08-13 Jackson William E. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
40699 40699 1991-12-31 1971-08-13 Connick Andrew J. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [FARA_All_ShortForms] (
   [Short_Form_Termination_Date] TEXT,
   [Short_Form_Date] TEXT,
   [Short_Form_Last_Name] TEXT,
   [Short_Form_First_Name] TEXT,
   [Registration_Number] INTEGER,
   [Registration_Date] TEXT,
   [Registrant_Name] TEXT,
   [Address_1] TEXT,
   [Address_2] TEXT,
   [City] TEXT,
   [State] TEXT,
   [Zip] TEXT,
   FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number])
);