FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
5 rows where "Short_Form_Termination_Date" is on date 1995-02-15
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 5
Registrant_Name 5
City 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6950 | 6950 | 1995-02-15 | 1992-03-13 | Mohamed | Yazid Ben | ASEAN Promotional Chapter for Tourism - North America 2744 | 1977-01-04 | ASEAN Promotional Chapter for Tourism - North America | c/o Tourism Authority of Thailand | 611 North Larchmont Blvd., 1st Floor | Los Angeles | CA | 90004 |
6951 | 6951 | 1995-02-15 | 1993-04-16 | Crawford | Charles S. | Crawford & Company Public Relations 4796 | 1993-04-16 | Crawford & Company Public Relations | 1330 Connecticut Avenue, N.W. | Suite 340 | Washington | DC | 20036 |
6952 | 6952 | 1995-02-15 | 1984-05-01 | Lathem | Ellen M. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
6953 | 6953 | 1995-02-15 | 1993-11-04 | Meltsner | James R. | Evans Group, Ltd. 4222 | 1989-03-02 | Evans Group, Ltd. | 1200 G Street, N.W. | Suite 800 | Washington | DC | 20005 |
6954 | 6954 | 1995-02-15 | 1989-12-21 | Marengo | Daniel J. | Fontayne Group, Inc. 3752 | 1985-10-30 | Fontayne Group, Inc. | 430 Colorado Avenue, Penthouse | Santa Monica | CA | 90401 |
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]) );