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 1985-02-15
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6933 | 6933 | 1985-02-15 | 1984-02-08 | Upshaw | Georgia S. | Markham/Novell Communications, Ltd. 3464 | 1983-04-27 | Markham/Novell Communications, Ltd. | 211 East 43rd Street | Suite 1106 | New York | NY | 10017 |
6934 | 6934 | 1985-02-15 | 1984-03-12 | Anthony | Carmen Gonzales | M. Silver Associates, Inc. 3131 | 1980-07-15 | M. Silver Associates, Inc. | 747 Third Avenue, 23rd Floor | New York | NY | 10017-2803 | |
6935 | 6935 | 1985-02-15 | 1986-03-21 | Finn | A. Michael | Italian Public Relations Associates - Italpublic, S.p.A. 3676 | 1985-03-27 | Italian Public Relations Associates - Italpublic, S.p.A. | 315 East 86th Street | Apartment 21F, East | New York | NY | 10028 |
6936 | 6936 | 1985-02-15 | 1986-03-21 | Gollrad | Bette E. | Italian Public Relations Associates - Italpublic, S.p.A. 3676 | 1985-03-27 | Italian Public Relations Associates - Italpublic, S.p.A. | 315 East 86th Street | Apartment 21F, East | New York | NY | 10028 |
6937 | 6937 | 1985-02-15 | 1986-03-21 | Ketchum | David P. | Italian Public Relations Associates - Italpublic, S.p.A. 3676 | 1985-03-27 | Italian Public Relations Associates - Italpublic, S.p.A. | 315 East 86th Street | Apartment 21F, East | New York | NY | 10028 |
6938 | 6938 | 1985-02-15 | 1984-05-01 | Kelly | Joan Larson | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
6939 | 6939 | 1985-02-15 | 1985-06-19 | Koehler | Christine Elaine | Hannaford Company, Inc. 2850 | 1977-11-29 | Hannaford Company, Inc. | 655 - 15th Street, N.W. | Suite 200 | Washington | DC | 20005 |
6940 | 6940 | 1985-02-15 | 1984-09-18 | Berger | Robert Glenn | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
6941 | 6941 | 1985-02-15 | 1983-10-07 | Buley | John M. , Jr. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 |
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]) );