FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where "Short_Form_Date" is on date 1989-03-09
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Zip
Registration_Number 8
Registrant_Name 8
City 5
- New York 4
- Seattle 4
- Washington 4
- Chicago 2
- New York 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2691 | 2691 | 1990-01-01 | 1989-03-09 | Sullivan | Jay R. | Murphy & Demory, Ltd. 4095 | 1988-03-03 | Murphy & Demory, Ltd. | 2550 M Street, N.W. | Suite 275 | Washington | DC | 20037-1301 |
8268 | 8268 | 2014-02-28 | 1989-03-09 | Hoff | Paul S. | Foster Garvey PC 3047 | 1979-08-09 | Foster Garvey PC | 1111 Third Avenue | Suite 3000 | Seattle | WA | 98101 |
8269 | 8269 | 2014-02-28 | 1989-03-09 | Wegman | Richard A. | Foster Garvey PC 3047 | 1979-08-09 | Foster Garvey PC | 1111 Third Avenue | Suite 3000 | Seattle | WA | 98101 |
10809 | 10809 | 1991-03-26 | 1989-03-09 | Goodfader | Alan | Murphy & Demory, Ltd. 4095 | 1988-03-03 | Murphy & Demory, Ltd. | 2550 M Street, N.W. | Suite 275 | Washington | DC | 20037-1301 |
11164 | 11164 | 1993-03-30 | 1989-03-09 | Orleansky | Vladimir Yurjevich | Amtorg Trading Corporation 596 | 1949-11-07 | Amtorg Trading Corporation | 15 West 36th Street | 6th Floor | New York | NY | 10018 |
11662 | 11662 | 1992-03-31 | 1989-03-09 | Yang | Hyo Sik | Korea Trade Center, Chicago 2648 | 1975-12-31 | Korea Trade Center, Chicago | 111 East Wacker Drive | Suite 2229 | Chicago | IL | 60601 |
19299 | 19299 | 1991-06-12 | 1989-03-09 | Suzuki | Minoru | Japan National Tourism Organization 769 | 1953-05-26 | Japan National Tourism Organization | 250 Park Avenue Suite. 1900 | New York | NY | 10177 | |
19761 | 19761 | 1993-06-17 | 1989-03-09 | Murphy | Daniel J. | Murphy & Demory, Ltd. 4095 | 1988-03-03 | Murphy & Demory, Ltd. | 2550 M Street, N.W. | Suite 275 | Washington | DC | 20037-1301 |
21115 | 21115 | 1989-06-30 | 1989-03-09 | Francis | Colin E. | Welsh Development Agency 3819 | 1986-04-24 | Welsh Development Agency | 191 North Wacker Drive | Suite 1685 | Chicago | IL | 60606 |
26727 | 26727 | 1989-08-15 | 1989-03-09 | Kramnick | Rebecca | Foster Garvey PC 3047 | 1979-08-09 | Foster Garvey PC | 1111 Third Avenue | Suite 3000 | Seattle | WA | 98101 |
31041 | 31041 | 1990-09-30 | 1989-03-09 | Kaushal | Lokesh | India Trade Promotion Organization 2975 | 1978-10-26 | India Trade Promotion Organization | 100 Park Avenue | 16th Floor | New York | NY | 10017 |
33625 | 33625 | 1991-10-25 | 1989-03-09 | Aljushnikova | Natalia Andreevna | Amtorg Trading Corporation 596 | 1949-11-07 | Amtorg Trading Corporation | 15 West 36th Street | 6th Floor | New York | NY | 10018 |
34344 | 34344 | 1994-10-31 | 1989-03-09 | Ono | Kaneyuki | Japan National Tourism Organization 769 | 1953-05-26 | Japan National Tourism Organization | 250 Park Avenue Suite. 1900 | New York | NY | 10177 | |
36546 | 36546 | 1991-11-29 | 1989-03-09 | Kornienko | Oleg G. | Amtorg Trading Corporation 596 | 1949-11-07 | Amtorg Trading Corporation | 15 West 36th Street | 6th Floor | New York | NY | 10018 |
37413 | 37413 | 1991-12-01 | 1989-03-09 | Wilson | Stacey L. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
42025 | 42025 | 2016-12-31 | 1989-03-09 | Bailey | Harold G. | Foster Garvey PC 3047 | 1979-08-09 | Foster Garvey PC | 1111 Third Avenue | Suite 3000 | Seattle | WA | 98101 |
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]) );