FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where City = "New York" and "Short_Form_Termination_Date" is on date 1998-12-31
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Zip, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41078 | 41078 | 1998-12-31 | 1998-02-20 | Cho | Hong Yun | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
41079 | 41079 | 1998-12-31 | 1997-03-10 | Peng | Xiaoqiao (Shelley) | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
41080 | 41080 | 1998-12-31 | 1980-03-28 | Calder | Duncan G. , III | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
41088 | 41088 | 1998-12-31 | 1993-05-03 | Gleason | Joseph Boyce | Manning, Selvage & Lee 4684 | 1992-06-10 | Manning, Selvage & Lee | 79 Madison Avenue | New York | NY | 10016-7880 | |
41089 | 41089 | 1998-12-31 | 1993-05-03 | Marcis | Julie | Manning, Selvage & Lee 4684 | 1992-06-10 | Manning, Selvage & Lee | 79 Madison Avenue | New York | NY | 10016-7880 | |
41093 | 41093 | 1998-12-31 | 1992-06-10 | Rennert | Vince | Manning, Selvage & Lee 4684 | 1992-06-10 | Manning, Selvage & Lee | 79 Madison Avenue | New York | NY | 10016-7880 | |
41094 | 41094 | 1998-12-31 | 1992-06-10 | Tannen | Andy | Manning, Selvage & Lee 4684 | 1992-06-10 | Manning, Selvage & Lee | 79 Madison Avenue | New York | NY | 10016-7880 | |
41095 | 41095 | 1998-12-31 | 1998-06-11 | Fitzgerald | Mary Clare | Hughes Hubbard & Reed, LLP 5261 | 1998-06-11 | Hughes Hubbard & Reed, LLP | One Battery Park Plaza | New York | NY | 10004-1482 | |
41096 | 41096 | 1998-12-31 | 1998-06-11 | Hammond | Steven A. | Hughes Hubbard & Reed, LLP 5261 | 1998-06-11 | Hughes Hubbard & Reed, LLP | One Battery Park Plaza | New York | NY | 10004-1482 | |
41097 | 41097 | 1998-12-31 | 1998-06-11 | Townsend | John M. | Hughes Hubbard & Reed, LLP 5261 | 1998-06-11 | Hughes Hubbard & Reed, LLP | One Battery Park Plaza | New York | NY | 10004-1482 | |
41098 | 41098 | 1998-12-31 | 1998-06-11 | Weeks | L. Mark | Hughes Hubbard & Reed, LLP 5261 | 1998-06-11 | Hughes Hubbard & Reed, LLP | One Battery Park Plaza | New York | NY | 10004-1482 | |
41099 | 41099 | 1998-12-31 | 1967-06-23 | Kaiden | Nina Wright | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
41104 | 41104 | 1998-12-31 | 1996-09-03 | Boye-Moeller | Jarl | European Travel Commission 574 | 1949-06-30 | European Travel Commission | c/o Spring O'Brien | 30 West 26th Street, 4th Floor | New York | NY | 10010 |
41106 | 41106 | 1998-12-31 | 1984-09-18 | Rooney | Paul C. , Jr. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
41107 | 41107 | 1998-12-31 | 1998-09-22 | Barniville | Nick | Enterprise Ireland 2518 | 1974-06-08 | Enterprise Ireland | Ireland House | 345 Park Avenue, 17th Floor | New York | NY | 10154-0037 |
41111 | 41111 | 1998-12-31 | 1993-10-12 | Loventhal-Kohut | Ann | Manning, Selvage & Lee 4684 | 1992-06-10 | Manning, Selvage & Lee | 79 Madison Avenue | New York | NY | 10016-7880 | |
41113 | 41113 | 1998-12-31 | 1991-11-18 | Lavroff | Barbara | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
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]) );