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 1999-10-31
This data as json, CSV (advanced)
Registration_Number 8
Registrant_Name 8
City 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34418 | 34418 | 1999-10-31 | 1998-04-03 | Burch | Charles F., Jr. | Arianespace, Inc. 3673 | 1985-04-30 | Arianespace, Inc. | 601 13th Street, N.W. | Suite 710 North | Washington | DC | 20005 |
34419 | 34419 | 1999-10-31 | 1997-04-11 | Silverman | Stephanie E. | Manatt, Phelps & Phillips 5171 | 1997-04-11 | Manatt, Phelps & Phillips | 700 12th Street, N.W. | Suite 1100 | Washington | DC | 20005 |
34420 | 34420 | 1999-10-31 | 1998-04-16 | Ryberg | Paul, Jr. | Pierson Semmes and Bemis, L.L.P. 5252 | 1998-04-16 | Pierson Semmes and Bemis, L.L.P. | 1054 Thirty-First Street, N.W. | Suite 300 | Washington | DC | 20007 |
34421 | 34421 | 1999-10-31 | 1985-04-30 | Heydon | Douglas A. | Arianespace, Inc. 3673 | 1985-04-30 | Arianespace, Inc. | 601 13th Street, N.W. | Suite 710 North | Washington | DC | 20005 |
34422 | 34422 | 1999-10-31 | 1995-07-18 | Ratley | Lonnie O. | Daimler-Chrysler Aerospace of North America, Inc. 4719 | 1992-10-09 | Daimler-Chrysler Aerospace of North America, Inc. | 1401 H Street, N.W. | Suite 700 | Washington | DC | 20005 |
34423 | 34423 | 1999-10-31 | 1991-08-06 | Keefe | Kevin S. | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
34424 | 34424 | 1999-10-31 | 1995-09-08 | Esser | Jakob | Representative of German Industry and Trade 4274 | 1989-07-21 | Representative of German Industry and Trade | 1130 Connecticut Avenue, NW | Suite 1200 | Washington | DC | 20036 |
34425 | 34425 | 1999-10-31 | 1996-10-16 | Goch | David P. | Webster, Chamberlain & Bean 5136 | 1996-10-16 | Webster, Chamberlain & Bean | 1747 Pennsylvania Avenue, N.W. | Suite 1000 | Washington | DC | 20006 |
34426 | 34426 | 1999-10-31 | 1996-10-16 | Herold | Arthur L. | Webster, Chamberlain & Bean 5136 | 1996-10-16 | Webster, Chamberlain & Bean | 1747 Pennsylvania Avenue, N.W. | Suite 1000 | Washington | DC | 20006 |
34427 | 34427 | 1999-10-31 | 1997-10-22 | Gissen | William | Levin Public Relations & Marketing, Inc. 5217 | 1997-10-22 | Levin Public Relations & Marketing, Inc. | 30 Glenn Street | White Plains | NY | 10603 | |
34428 | 34428 | 1999-10-31 | 1997-10-22 | Levin | Donald M. | Levin Public Relations & Marketing, Inc. 5217 | 1997-10-22 | Levin Public Relations & Marketing, Inc. | 30 Glenn Street | White Plains | NY | 10603 |
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]) );