FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
7 rows where "Short_Form_Date" is on date 1975-08-25
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17128 | 17128 | 1978-05-26 | 1975-08-25 | Stefanskiy | Valery Pavlovich | Amtorg Trading Corporation 596 | 1949-11-07 | Amtorg Trading Corporation | 15 West 36th Street | 6th Floor | New York | NY | 10018 |
20136 | 20136 | 1978-06-24 | 1975-08-25 | Shoborov | Evueni Ivanovich | Amtorg Trading Corporation 596 | 1949-11-07 | Amtorg Trading Corporation | 15 West 36th Street | 6th Floor | New York | NY | 10018 |
29006 | 29006 | 1976-09-02 | 1975-08-25 | Nikolski | Mikhail V. | Intourist U.S.A., Inc. 1240 | 1959-06-23 | Intourist U.S.A., Inc. | 610 Fifth Avenue | Suite 603 | New York | NY | 10020 |
29264 | 29264 | 1978-09-06 | 1975-08-25 | Kryazhev | Vitaliy G. | Intourist U.S.A., Inc. 1240 | 1959-06-23 | Intourist U.S.A., Inc. | 610 Fifth Avenue | Suite 603 | New York | NY | 10020 |
30053 | 30053 | 1977-09-19 | 1975-08-25 | Fidell | Eugene R. | LeBoeuf, Lamb, Leiby & MacRae 2169 | 1969-11-10 | LeBoeuf, Lamb, Leiby & MacRae | 1757 N Street, N.W. | Washington | DC | 20036 | |
33615 | 33615 | 1988-10-25 | 1975-08-25 | Strunkin | Vladimir Vasilyewich | Amtorg Trading Corporation 596 | 1949-11-07 | Amtorg Trading Corporation | 15 West 36th Street | 6th Floor | New York | NY | 10018 |
39392 | 39392 | 1988-12-30 | 1975-08-25 | McNeil | Thomas David | U.S. Office of the British Broadcasting Corporation 505 | 1947-12-01 | U.S. Office of the British Broadcasting Corporation | 630 Fifth Avenue | New York | NY | 10111 |
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]) );