FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where "Short_Form_Date" is on date 1989-02-07
This data as json, CSV (advanced)
These facets timed out: City
Registration_Number 6
Registrant_Name 6
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3291 | 3291 | 1996-01-06 | 1989-02-07 | Sturbitts | Charlene A. | Rose Communications, Inc. 4003 | 1987-07-06 | Rose Communications, Inc. | 1625 K Street, N.W., | Suite 790 | Washington | DC | 20006 |
7339 | 7339 | 1991-02-21 | 1989-02-07 | Stern | Paula | Winthrop, Stimson, Putnam & Roberts, Washington Office 3873 | 1986-08-21 | Winthrop, Stimson, Putnam & Roberts, Washington Office | 1133 Connecticut Avenue, N.W. | Washington | DC | 20036 | |
13636 | 13636 | 1990-04-17 | 1989-02-07 | Abu | Amirrudin | Malaysia Tourism Promotion Board 2510 | 1974-04-17 | Malaysia Tourism Promotion Board | 818 West Seventh Street | Suite 970 | Los Angeles | CA | 90017-3432 |
24536 | 24536 | 1993-07-30 | 1989-02-07 | Morgan | Lloyd B. | Netherlands Chamber of Commerce in the U.S., Inc. 456 | 1947-04-16 | Netherlands Chamber of Commerce in the U.S., Inc. | One Rockefeller Plaza | New York | NY | 10020 | |
30311 | 30311 | 1991-09-23 | 1989-02-07 | Usumoto | Tomiichi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
32461 | 32461 | 1991-10-08 | 1989-02-07 | Hozaki | Yasuo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
34925 | 34925 | 1990-11-01 | 1989-02-07 | Griendt | Pieter S. der | Netherlands Chamber of Commerce in the U.S., Inc. 456 | 1947-04-16 | Netherlands Chamber of Commerce in the U.S., Inc. | One Rockefeller Plaza | New York | NY | 10020 | |
35298 | 35298 | 1991-11-05 | 1989-02-07 | Haarsma | Johannes F.M. | Netherlands Chamber of Commerce in the U.S., Inc. 456 | 1947-04-16 | Netherlands Chamber of Commerce in the U.S., Inc. | One Rockefeller Plaza | New York | NY | 10020 | |
39403 | 39403 | 1989-12-30 | 1989-02-07 | Rock | James W. | Gold & Liebengood, Inc. 3700 | 1985-07-09 | Gold & Liebengood, Inc. | 1455 Pennsylvania Avenue, N.W. | Suite 950 | Washington | DC | 20004 |
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]) );