FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where City = "New York" and "Short_Form_Termination_Date" is on date 1993-06-30
This data as json, CSV (advanced)
Suggested facets: Address_1, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21179 | 21179 | 1993-06-30 | 1990-02-12 | Rosen | Margrit Stephanie (Peggy) | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
21180 | 21180 | 1993-06-30 | 1991-02-27 | Thompson | Mary Helen | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
21181 | 21181 | 1993-06-30 | 1980-03-28 | Ryan | Burton T. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
21183 | 21183 | 1993-06-30 | 1991-04-09 | Baker | Audrey H. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
21186 | 21186 | 1993-06-30 | 1989-09-14 | Laroia | Pradeep | India Trade Promotion Organization 2975 | 1978-10-26 | India Trade Promotion Organization | 100 Park Avenue | 16th Floor | New York | NY | 10017 |
21187 | 21187 | 1993-06-30 | 1989-09-21 | Lane | Janet C. | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
21189 | 21189 | 1993-06-30 | 1989-10-10 | Wilson | Kathleen Isabella | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
21190 | 21190 | 1993-06-30 | 1990-10-10 | Hanchet | Markham G. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
21191 | 21191 | 1993-06-30 | 1990-10-10 | Schwartz | Larry W. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
21194 | 21194 | 1993-06-30 | 1991-11-04 | Walker | Gary Christopher | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
21195 | 21195 | 1993-06-30 | 1992-11-05 | Kelly | Brendan J. | International Communications Marketing, Inc. (ICM) 4733 | 1992-11-05 | International Communications Marketing, Inc. (ICM) | 666 Fifth Avenue | New York | NY | 10103 | |
21196 | 21196 | 1993-06-30 | 1992-11-05 | Van de Bovenkamp | Gerrit P. | International Communications Marketing, Inc. (ICM) 4733 | 1992-11-05 | International Communications Marketing, Inc. (ICM) | 666 Fifth Avenue | New York | NY | 10103 |
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]) );