FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where "Short_Form_Termination_Date" is on date 1989-02-28
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 9
Registrant_Name 9
City 6
- Los Angeles 5
- Cambridge 2
- New York 2
- Washington 2
- Boston 1
- Jersey City 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7937 | 7937 | 1989-02-28 | 1987-01-05 | Marks | Roberta G. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
7938 | 7938 | 1989-02-28 | 1987-01-29 | Dailey | Linda Leigh | AEGIS Insurance Services, Inc. (AISI) 3932 | 1987-01-29 | AEGIS Insurance Services, Inc. (AISI) | 10 Exchange Place | Jersey City | NJ | 07302 | |
7939 | 7939 | 1989-02-28 | 1984-03-21 | Barr | William P. | Shaw, Pittman, Potts & Trowbridge 2580 | 1975-02-21 | Shaw, Pittman, Potts & Trowbridge | 2300 N Street, N.W. | Washington | DC | 20037-1128 | |
7940 | 7940 | 1989-02-28 | 1987-04-17 | Togneri | Martin | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
7941 | 7941 | 1989-02-28 | 1984-05-10 | Hamberger | Martin G. | Lipsen, Whitten & Diamond 3586 | 1984-05-10 | Lipsen, Whitten & Diamond | 1725 DeSales Street, N.W. | Suite 800 | Washington | DC | 20036 |
7942 | 7942 | 1989-02-28 | 1981-06-04 | Fontaine | Michee | A.F. Sabo Associates, Inc. 3115 | 1980-06-27 | A.F. Sabo Associates, Inc. | 575 Lexington Avenue | Suite 2200 | New York | NY | 10022 |
7943 | 7943 | 1989-02-28 | 1987-06-11 | Moody | Howard J. | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
7944 | 7944 | 1989-02-28 | 1988-07-13 | Elfe | Constantin | J.R. Bechtle & Company 4019 | 1987-08-03 | J.R. Bechtle & Company | 185 Devonshire Street | Suite 350 | Boston | MA | 02110 |
7945 | 7945 | 1989-02-28 | 1985-08-21 | Boonchim | Manit | Tourism Authority of Thailand, Los Angeles 2178 | 1969-12-19 | Tourism Authority of Thailand, Los Angeles | 611 North Larchmont Boulevard | 1st Floor | Los Angeles | CA | 90004 |
7946 | 7946 | 1989-02-28 | 1986-08-28 | Parsons | Craig A. | Rifkind, Pondel & Parsons 3879 | 1986-08-28 | Rifkind, Pondel & Parsons | 11601 Wilshire Boulevard | Suite 760 | Los Angeles | CA | 90025 |
7947 | 7947 | 1989-02-28 | 1986-08-28 | Rifkind | Melvyn S. | Rifkind, Pondel & Parsons 3879 | 1986-08-28 | Rifkind, Pondel & Parsons | 11601 Wilshire Boulevard | Suite 760 | Los Angeles | CA | 90025 |
7948 | 7948 | 1989-02-28 | 1986-08-28 | Romano | Gregory F. | Rifkind, Pondel & Parsons 3879 | 1986-08-28 | Rifkind, Pondel & Parsons | 11601 Wilshire Boulevard | Suite 760 | Los Angeles | CA | 90025 |
7949 | 7949 | 1989-02-28 | 1986-08-28 | Wilkinson | Cecilia A. | Rifkind, Pondel & Parsons 3879 | 1986-08-28 | Rifkind, Pondel & Parsons | 11601 Wilshire Boulevard | Suite 760 | Los Angeles | CA | 90025 |
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]) );