FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
7 rows where Short_Form_Date = "1987-09-25"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, Zip, Short_Form_Date (date), Registration_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7796 | 7796 | 1997-02-27 | 1987-09-25 | Cohen | Leslie A. | Karen Weiner Escalera Associates, Inc. 3405 | 1982-08-27 | Karen Weiner Escalera Associates, Inc. | 104 Fifth Avenue | 11th Floor | New York | NY | 10011 |
11610 | 11610 | 1989-03-31 | 1987-09-25 | Birkbeck | William D. | Lowe Marschalk, Inc. 3670 | 1985-03-29 | Lowe Marschalk, Inc. | 1345 Avenue of the Americas | New York | NY | 10105 | |
12901 | 12901 | 1995-04-07 | 1987-09-25 | Heiman | Bruce J. | Preston, Gates & Ellis, L.L.P. 3567 | 1984-03-22 | Preston, Gates & Ellis, L.L.P. | 5000 Columbia Center | 701 Fifth Avenue | Seattle | WA | 98104-7078 |
23558 | 23558 | 1995-07-18 | 1987-09-25 | Ahmed | Mohamod Abdilahi | Somaliland Republic Office 3640 | 1985-01-18 | Somaliland Republic Office | P.O. Box 90917 | Washington | DC | 20090 | |
29483 | 29483 | 1988-09-09 | 1987-09-25 | Rouvelas | Emanuel | Preston, Gates & Ellis, L.L.P. 3567 | 1984-03-22 | Preston, Gates & Ellis, L.L.P. | 5000 Columbia Center | 701 Fifth Avenue | Seattle | WA | 98104-7078 |
33481 | 33481 | 1987-10-23 | 1987-09-25 | Konkol | Karen | Lowe Marschalk, Inc. 3670 | 1985-03-29 | Lowe Marschalk, Inc. | 1345 Avenue of the Americas | New York | NY | 10105 | |
37740 | 37740 | 1997-12-04 | 1987-09-25 | Mierzewski | Michael B. | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 |
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]) );