FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where "Short_Form_Termination_Date" is on date 1992-10-02
This data as json, CSV (advanced)
Suggested facets: Short_Form_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32162 | 32162 | 1992-10-02 | 1989-01-31 | Andes | Phyllis E. | Oppenheimer, Wolff & Donnelly 3485 | 1983-06-16 | Oppenheimer, Wolff & Donnelly | 1020 - 19th Street, N.W. | Suite 400 | Washington | DC | 20036 |
32163 | 32163 | 1992-10-02 | 1990-02-21 | Wolff | Richard J. | Kekst & Company, Inc. 4342 | 1990-02-21 | Kekst & Company, Inc. | 437 Madison Avenue | New York | NY | 10022 | |
32164 | 32164 | 1992-10-02 | 1992-04-13 | Kronfeld | David A. | Kekst & Company, Inc. 4342 | 1990-02-21 | Kekst & Company, Inc. | 437 Madison Avenue | New York | NY | 10022 | |
32165 | 32165 | 1992-10-02 | 1992-04-13 | Siegfried | Robert D. | Kekst & Company, Inc. 4342 | 1990-02-21 | Kekst & Company, Inc. | 437 Madison Avenue | New York | NY | 10022 | |
32166 | 32166 | 1992-10-02 | 1989-04-14 | Helmer | Howard M. | Foodcom, Inc. 4218 | 1989-02-21 | Foodcom, Inc. | 708 Third Avenue | 18th Floor | New York | NY | 10017 |
32167 | 32167 | 1992-10-02 | 1990-05-15 | Zagaris | Bruce | Oppenheimer, Wolff & Donnelly 3485 | 1983-06-16 | Oppenheimer, Wolff & Donnelly | 1020 - 19th Street, N.W. | Suite 400 | Washington | DC | 20036 |
32168 | 32168 | 1992-10-02 | 1990-05-16 | Kekst | Gershon | Kekst & Company, Inc. 4342 | 1990-02-21 | Kekst & Company, Inc. | 437 Madison Avenue | New York | NY | 10022 | |
32169 | 32169 | 1992-10-02 | 1983-07-14 | Pedersen | James F. | Oppenheimer, Wolff & Donnelly 3485 | 1983-06-16 | Oppenheimer, Wolff & Donnelly | 1020 - 19th Street, N.W. | Suite 400 | Washington | DC | 20036 |
32170 | 32170 | 1992-10-02 | 1991-07-25 | Summer | Jane Lee | Boonshaft-Lewis & Savitch Public Relations, Inc. 4548 | 1991-07-25 | Boonshaft-Lewis & Savitch Public Relations, Inc. | 1888 Century Park, East | Suite 330 | Los Angeles | CA | 90067 |
32171 | 32171 | 1992-10-02 | 1992-10-02 | Mir | Analisa | van Kloberg & Associates, Ltd. 3466 | 1983-05-09 | van Kloberg & Associates, Ltd. | 1129 - 20th Street, N.W. | Suite 400 | Washington | DC | 20036 |
32172 | 32172 | 1992-10-02 | 1990-11-23 | Davies | Thomas | Kekst & Company, Inc. 4342 | 1990-02-21 | Kekst & Company, Inc. | 437 Madison Avenue | New York | NY | 10022 |
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]) );