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 = 4332

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Date (date)

State 1

Registration_Number 1

  • Washington Group · 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
5799 5799 1996-02-01 1991-10-02 Spees Richard L. Washington Group 4332 1990-01-18 Washington Group 1401 K Street, N.W. Suite 400 Washington DC 20005
7786 7786 1990-02-27 1990-02-23 Fielek Henrietta Stella Washington Group 4332 1990-01-18 Washington Group 1401 K Street, N.W. Suite 400 Washington DC 20005
7988 7988 1992-02-28 1990-02-06 Copeland James M. , Jr. Washington Group 4332 1990-01-18 Washington Group 1401 K Street, N.W. Suite 400 Washington DC 20005
24876 24876 1996-07-31 1995-02-28 Rogers Edwina Washington Group 4332 1990-01-18 Washington Group 1401 K Street, N.W. Suite 400 Washington DC 20005
24882 24882 1996-07-31 1991-10-02 Smith G. Wayne Washington Group 4332 1990-01-18 Washington Group 1401 K Street, N.W. Suite 400 Washington DC 20005
35105 35105 1990-11-02 1990-03-07 Allison Edward E. Washington Group 4332 1990-01-18 Washington Group 1401 K Street, N.W. Suite 400 Washington DC 20005
40602 40602 1990-12-31 1990-01-18 Halsey Steven Craig Washington Group 4332 1990-01-18 Washington Group 1401 K Street, N.W. Suite 400 Washington DC 20005
41069 41069 1998-12-31 1990-01-18 Raffaelli John D. Washington Group 4332 1990-01-18 Washington Group 1401 K Street, N.W. Suite 400 Washington DC 20005
41071 41071 1998-12-31 1994-01-25 O'Hanlon G. John Washington Group 4332 1990-01-18 Washington Group 1401 K Street, N.W. Suite 400 Washington DC 20005
41072 41072 1998-12-31 1994-01-25 Saunders Tonya Washington Group 4332 1990-01-18 Washington Group 1401 K Street, N.W. Suite 400 Washington DC 20005
41073 41073 1998-12-31 1994-01-25 Springer David E. Washington Group 4332 1990-01-18 Washington Group 1401 K Street, N.W. Suite 400 Washington DC 20005
41081 41081 1998-12-31 1994-04-08 Reed Morgan William , III Washington Group 4332 1990-01-18 Washington Group 1401 K Street, N.W. Suite 400 Washington DC 20005
41101 41101 1998-12-31 1994-08-10 Allen Kevin D. Washington Group 4332 1990-01-18 Washington Group 1401 K Street, N.W. Suite 400 Washington DC 20005
41109 41109 1998-12-31 1998-10-09 Blount John Washington Group 4332 1990-01-18 Washington Group 1401 K Street, N.W. Suite 400 Washington DC 20005
41110 41110 1998-12-31 1998-10-09 Lewis Rita M. Washington Group 4332 1990-01-18 Washington Group 1401 K Street, N.W. Suite 400 Washington DC 20005

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