FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
7 rows where "Short_Form_Termination_Date" is on date 1985-02-15 and State = "NY"
This data as json, CSV (advanced)
Suggested facets: Address_1, Zip, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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]) );