FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

17 rows where "Short_Form_Termination_Date" is on date 1991-09-04

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Last_Name, Registration_Date, Address_2, Zip, Short_Form_Termination_Date (date)

State 2

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
29152 29152 1991-09-04 1974-02-01 Huyler Leroy A. Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
29153 29153 1991-09-04 1975-02-05 Buckingham Jerry Ray Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
29154 29154 1991-09-04 1975-02-05 Johnson David Livingstone Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
29155 29155 1991-09-04 1975-02-05 Kuszpit Kenneth Allen Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
29156 29156 1991-09-04 1986-03-10 Gibbs Ronn L. Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
29157 29157 1991-09-04 1991-05-01 Klimentov Dimitri New York Bureau of the Telegraph Agency of Russia (TASS) 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
29158 29158 1991-09-04 1978-05-25 Carey Juanita Lilith Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
29159 29159 1991-09-04 1978-05-25 Keer James R. Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
29160 29160 1991-09-04 1975-07-30 Zrmack Robert John Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
29161 29161 1991-09-04 1972-08-03 van Helden Hendrik G. Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
29162 29162 1991-09-04 1977-08-05 Hershowitz Aron Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
29163 29163 1991-09-04 1977-08-05 Johnson Diane Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
29164 29164 1991-09-04 1973-08-08 Brady Robert Elwood Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
29165 29165 1991-09-04 1973-08-14 Almunia Miguel T. Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
29166 29166 1991-09-04 1973-08-14 Norris Jack A. Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
29167 29167 1991-09-04 1973-08-14 Torrey Diane Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
29168 29168 1991-09-04 1985-08-26 Barnathan Herman Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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])
);