FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where Short_Form_Termination_Date = "1994-03-29"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Registration_Date, Address_2, Short_Form_Termination_Date (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11054 | 11054 | 1994-03-29 | 1987-02-20 | Lopez | Francisco J. Gurria | Mexican Tourism Board 1754 | 1964-06-09 | Mexican Tourism Board | 400 Madison Avenue | Suite 11C | New York | NY | 10017 |
11055 | 11055 | 1994-03-29 | 1994-03-29 | Foochs | Arkadiy I. | Foochs, Arkadiy I. 4905 | 1994-03-29 | Foochs, Arkadiy I. | McLan Building | 4121 Eighteenth Avenue | Brooklyn | NY | 11218 |
11056 | 11056 | 1994-03-29 | 1994-03-29 | Iannacone | Randolph Frank | Foochs, Arkadiy I. 4905 | 1994-03-29 | Foochs, Arkadiy I. | McLan Building | 4121 Eighteenth Avenue | Brooklyn | NY | 11218 |
11057 | 11057 | 1994-03-29 | 1994-03-29 | Lerner | Gary | Foochs, Arkadiy I. 4905 | 1994-03-29 | Foochs, Arkadiy I. | McLan Building | 4121 Eighteenth Avenue | Brooklyn | NY | 11218 |
11058 | 11058 | 1994-03-29 | 1994-03-29 | Pesin | Victoria | Foochs, Arkadiy I. 4905 | 1994-03-29 | Foochs, Arkadiy I. | McLan Building | 4121 Eighteenth Avenue | Brooklyn | NY | 11218 |
11059 | 11059 | 1994-03-29 | 1992-04-09 | Bahlke | Conrad G. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11060 | 11060 | 1994-03-29 | 1987-06-08 | Kersner | Steven P. | Brownstein, Zeidman & Lore 3744 | 1985-10-03 | Brownstein, Zeidman & Lore | 1401 New York Avenue, N.W. | Suite 900 | Washington | DC | 20005 |
11061 | 11061 | 1994-03-29 | 1985-10-03 | Altschuler | Irwin P. | Brownstein, Zeidman & Lore 3744 | 1985-10-03 | Brownstein, Zeidman & Lore | 1401 New York Avenue, N.W. | Suite 900 | Washington | DC | 20005 |
11062 | 11062 | 1994-03-29 | 1987-11-02 | Almada | Alicia Rodriguez Familiar | Mexican Tourism Board 1754 | 1964-06-09 | Mexican Tourism Board | 400 Madison Avenue | Suite 11C | New York | NY | 10017 |
11063 | 11063 | 1994-03-29 | 1986-12-02 | Lee | Sam S.M. | Taiwan Trade Center New York Inc. 3652 | 1985-02-28 | Taiwan Trade Center New York Inc. | One Penn Plaza | Suite 2025 | New York | NY | 10119 |
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]) );