FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where "Short_Form_Termination_Date" is on date 1987-07-31
This data as json, CSV (advanced)
Suggested facets: Zip, Short_Form_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24751 | 24751 | 1987-07-31 | 1987-03-06 | Elwell | Stephen | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
24752 | 24752 | 1987-07-31 | 1985-04-10 | Goitiandia | Ray | Korea Trade Center, Los Angeles 2646 | 1975-12-19 | Korea Trade Center, Los Angeles | 4801 Wilshire Boulevard | Suite 104 | Los Angeles | CA | 90010-3813 |
24753 | 24753 | 1987-07-31 | 1986-04-23 | O'Mara | Patrick J. | Tanaka, Michele N. 948 | 1956-04-24 | Tanaka, Michele N. | 655 - 15th Street, N.W. | Suite 800 | Washington | DC | 20005 |
24754 | 24754 | 1987-07-31 | 1985-04-30 | Josephson | Diana H. | Arianespace, Inc. 3673 | 1985-04-30 | Arianespace, Inc. | 601 13th Street, N.W. | Suite 710 North | Washington | DC | 20005 |
24755 | 24755 | 1987-07-31 | 1987-05-12 | Payer | Catherine | Arter & Hadden 3942 | 1987-03-03 | Arter & Hadden | 1801 K Street, N.W. | Suite 400K | Washington | DC | 20006 |
24756 | 24756 | 1987-07-31 | 1986-06-18 | Baroody | Joseph D. | Wagner, Hines & Avary, Inc. 3845 | 1986-06-18 | Wagner, Hines & Avary, Inc. | 1899 L Street, N.W. | Suite 500 | Washington | DC | 20036 |
24757 | 24757 | 1987-07-31 | 1984-10-23 | Moss | Jane Susan Salad | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
24758 | 24758 | 1987-07-31 | 1983-11-15 | Caglar | Resat | Representative of the Turkish Republic of Northern Cyprus 2619 | 1975-10-16 | Representative of the Turkish Republic of Northern Cyprus | 821 First Avenue | Floor 13 | New York | NY | 10017 |
24759 | 24759 | 1987-07-31 | 1976-12-09 | Hollands | Frederick William Clements | Hong Kong Tourism Board 2110 | 1968-10-29 | Hong Kong Tourism Board | 5901 W CENTURY BLVD. | SUITE 650 | Los Angeles | CA | 90045 |
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]) );