FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where City = "Washington" and "Short_Form_Date" is on date 1986-01-23
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_1, Zip
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 |
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]) );