FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where "Short_Form_Date" is on date 1985-08-21
This data as json, CSV (advanced)
Suggested facets: Address_2, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5024 | 5024 | 1988-01-31 | 1985-08-21 | Jantrupon | Montri | Tourism Authority of Thailand, Los Angeles 2178 | 1969-12-19 | Tourism Authority of Thailand, Los Angeles | 611 North Larchmont Boulevard | 1st Floor | Los Angeles | CA | 90004 |
5754 | 5754 | 1987-02-01 | 1985-08-21 | Shvets | Yuri B. | New York Bureau of the Telegraph Agency of Russia (TASS) 464 | 1947-06-03 | New York Bureau of the Telegraph Agency of Russia (TASS) | 50 Rockefeller Plaza | New York | NY | 10020 | |
7701 | 7701 | 1986-02-26 | 1985-08-21 | Thompson | Adolf A. | Jamaican-American Foundation, Inc. 3722 | 1985-08-21 | Jamaican-American Foundation, Inc. | Post Office Box 112-553 | Miami | FL | 33111 | |
7784 | 7784 | 1987-02-27 | 1985-08-21 | Pew | Gilda B. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
7945 | 7945 | 1989-02-28 | 1985-08-21 | Boonchim | Manit | Tourism Authority of Thailand, Los Angeles 2178 | 1969-12-19 | Tourism Authority of Thailand, Los Angeles | 611 North Larchmont Boulevard | 1st Floor | Los Angeles | CA | 90004 |
16395 | 16395 | 1986-05-15 | 1985-08-21 | Mullegan | Carolyn P. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
23715 | 23715 | 1986-07-21 | 1985-08-21 | DeLaney | Paul H. | Law Offices of Paul H. DeLaney, Jr. 3724 | 1985-08-21 | Law Offices of Paul H. DeLaney, Jr. | 1920 N Street, N.W. | Suite 610 | Washington | DC | 20036 |
38232 | 38232 | 1990-12-13 | 1985-08-21 | Borisenko | Igor E. | New York Bureau of the Telegraph Agency of Russia (TASS) 464 | 1947-06-03 | New York Bureau of the Telegraph Agency of Russia (TASS) | 50 Rockefeller Plaza | New York | NY | 10020 |
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]) );