FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
20 rows where "Short_Form_Date" is on date 1986-01-23
This data as json, CSV (advanced)
Suggested facets: Address_1, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
5120 | 5120 | 1993-01-31 | 1986-01-23 | Boyd | Robert W. A. | Nova Scotia Information Centre 3078 | 1979-12-18 | Nova Scotia Information Centre | 1800 Argyle Street Suite 603 | Box 456 | Halifax | ||
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 | |
7608 | 7608 | 1987-02-25 | 1986-01-23 | Brodie | Lawrence P. | Milbank, Furia Samuels 3837 | 1986-01-23 | Milbank, Furia Samuels | 1825 I Street, N.W. | Washington | DC | 20006 | |
7609 | 7609 | 1987-02-25 | 1986-01-23 | Diamond | Harry L. | Milbank, Furia Samuels 3837 | 1986-01-23 | Milbank, Furia Samuels | 1825 I Street, N.W. | Washington | DC | 20006 | |
7610 | 7610 | 1987-02-25 | 1986-01-23 | Fletcher | Phillip D. | Milbank, Furia Samuels 3837 | 1986-01-23 | Milbank, Furia Samuels | 1825 I Street, N.W. | Washington | DC | 20006 | |
7611 | 7611 | 1987-02-25 | 1986-01-23 | Furia | Edward W. | Milbank, Furia Samuels 3837 | 1986-01-23 | Milbank, Furia Samuels | 1825 I Street, N.W. | Washington | DC | 20006 | |
7612 | 7612 | 1987-02-25 | 1986-01-23 | LeSourd | Michelle D. | Milbank, Furia Samuels 3837 | 1986-01-23 | Milbank, Furia Samuels | 1825 I Street, N.W. | Washington | DC | 20006 | |
7613 | 7613 | 1987-02-25 | 1986-01-23 | Marcuss | Stanley J. | Milbank, Furia Samuels 3837 | 1986-01-23 | Milbank, Furia Samuels | 1825 I Street, N.W. | Washington | DC | 20006 | |
7614 | 7614 | 1987-02-25 | 1986-01-23 | Richardson | Elliot L. | Milbank, Furia Samuels 3837 | 1986-01-23 | Milbank, Furia Samuels | 1825 I Street, N.W. | Washington | DC | 20006 | |
7615 | 7615 | 1987-02-25 | 1986-01-23 | Seeley | James J. | Milbank, Furia Samuels 3837 | 1986-01-23 | Milbank, Furia Samuels | 1825 I Street, N.W. | Washington | DC | 20006 | |
11542 | 11542 | 1986-03-31 | 1986-01-23 | Shapiro | Isaac | Milbank, Furia Samuels 3837 | 1986-01-23 | Milbank, Furia Samuels | 1825 I Street, N.W. | Washington | DC | 20006 | |
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 | |
27704 | 27704 | 1986-08-29 | 1986-01-23 | Liu | Theodore Em-Po | Milbank, Furia Samuels 3837 | 1986-01-23 | Milbank, Furia Samuels | 1825 I Street, N.W. | Washington | DC | 20006 | |
29615 | 29615 | 1986-09-12 | 1986-01-23 | Bauman | Dena R. | Milbank, Furia Samuels 3837 | 1986-01-23 | Milbank, Furia Samuels | 1825 I Street, N.W. | Washington | DC | 20006 | |
29839 | 29839 | 1988-09-15 | 1986-01-23 | Fursland | Richard Curtis | Gavin Anderson Doremus & Company 3378 | 1982-06-15 | Gavin Anderson Doremus & Company | 11 West 42nd Street | 8th Floor | New York | NY | 10036 |
30124 | 30124 | 1990-09-20 | 1986-01-23 | Morris | William H. , Jr. | Global U.S.A., Inc. 3489 | 1983-06-24 | Global U.S.A., Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
33431 | 33431 | 1998-10-22 | 1986-01-23 | Thomas | Sadie Anne | Nova Scotia Information Centre 3078 | 1979-12-18 | Nova Scotia Information Centre | 1800 Argyle Street Suite 603 | Box 456 | Halifax | ||
40453 | 40453 | 1988-12-31 | 1986-01-23 | Worden | George M. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );