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

15 rows where Registration_Number = 698

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date (date), Registration_Date (date)

State 1

Registration_Number 1

  • Chenea, Virgil Edward · 15 ✖

Registrant_Name 1

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
20068 20068 1967-06-23 1953-06-11 Sandquist Robert L. Chenea, Virgil Edward 698 1951-11-26 Chenea, Virgil Edward 1633-4 DuPont Building   Miami FL  
20069 20069 1967-06-23 1966-06-17 Bary Martin Harold Chenea, Virgil Edward 698 1951-11-26 Chenea, Virgil Edward 1633-4 DuPont Building   Miami FL  
20070 20070 1967-06-23 1966-06-17 McDaniel Richard B. Chenea, Virgil Edward 698 1951-11-26 Chenea, Virgil Edward 1633-4 DuPont Building   Miami FL  
20072 20072 1967-06-23 1960-06-24 Foreman Richard Roy Chenea, Virgil Edward 698 1951-11-26 Chenea, Virgil Edward 1633-4 DuPont Building   Miami FL  
20073 20073 1967-06-23 1963-06-27 Norris Jack Alexander Chenea, Virgil Edward 698 1951-11-26 Chenea, Virgil Edward 1633-4 DuPont Building   Miami FL  
20074 20074 1967-06-23 1952-08-07 Grant Gordon Blayney Chenea, Virgil Edward 698 1951-11-26 Chenea, Virgil Edward 1633-4 DuPont Building   Miami FL  
20075 20075 1967-06-23 1951-11-26 Henley H. Kurtz Chenea, Virgil Edward 698 1951-11-26 Chenea, Virgil Edward 1633-4 DuPont Building   Miami FL  
20076 20076 1967-06-23 1951-11-26 Huddleston Thomas LaFayette , Jr. Chenea, Virgil Edward 698 1951-11-26 Chenea, Virgil Edward 1633-4 DuPont Building   Miami FL  
20077 20077 1967-06-23 1951-11-26 Thacher William Clifford Chenea, Virgil Edward 698 1951-11-26 Chenea, Virgil Edward 1633-4 DuPont Building   Miami FL  
20078 20078 1967-06-23 1951-11-26 West Forbes Edmund Chenea, Virgil Edward 698 1951-11-26 Chenea, Virgil Edward 1633-4 DuPont Building   Miami FL  
20079 20079 1967-06-23 1963-12-05 Bishop Willis E. , II Chenea, Virgil Edward 698 1951-11-26 Chenea, Virgil Edward 1633-4 DuPont Building   Miami FL  
20080 20080 1967-06-23 1958-12-10 Carrington David Lumsden Chenea, Virgil Edward 698 1951-11-26 Chenea, Virgil Edward 1633-4 DuPont Building   Miami FL  
20081 20081 1967-06-23 1961-12-15 Florman Nils Kohler Chenea, Virgil Edward 698 1951-11-26 Chenea, Virgil Edward 1633-4 DuPont Building   Miami FL  
20082 20082 1967-06-23 1959-12-18 Ramey Frank Bracken , Jr. Chenea, Virgil Edward 698 1951-11-26 Chenea, Virgil Edward 1633-4 DuPont Building   Miami FL  
20083 20083 1967-06-23 1965-12-27 Cloudman Olin Burnell Chenea, Virgil Edward 698 1951-11-26 Chenea, Virgil Edward 1633-4 DuPont Building   Miami FL  

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