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

28 rows where Registration_Number = 4671

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • Porter/Novelli · 28 ✖

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
3802 3802 1993-01-15 1992-05-18 Sylvia David Porter/Novelli 4671 1992-05-18 Porter/Novelli 1909 K Street Suite 400 Washington DC 20006
5122 5122 1993-01-31 1992-05-18 Druckenmiller Robert T. Porter/Novelli 4671 1992-05-18 Porter/Novelli 1909 K Street Suite 400 Washington DC 20006
5242 5242 2001-01-31 1998-08-14 Epstein Mark Porter/Novelli 4671 1992-05-18 Porter/Novelli 1909 K Street Suite 400 Washington DC 20006
5243 5243 2001-01-31 1998-08-14 Laveran Donna Porter/Novelli 4671 1992-05-18 Porter/Novelli 1909 K Street Suite 400 Washington DC 20006
5244 5244 2001-01-31 1998-08-14 McCann Thomas Porter/Novelli 4671 1992-05-18 Porter/Novelli 1909 K Street Suite 400 Washington DC 20006
5245 5245 2001-01-31 1998-08-14 Sandor Shawn Porter/Novelli 4671 1992-05-18 Porter/Novelli 1909 K Street Suite 400 Washington DC 20006
11773 11773 1997-03-31 1998-08-14 Gilcreast David Porter/Novelli 4671 1992-05-18 Porter/Novelli 1909 K Street Suite 400 Washington DC 20006
13863 13863 1993-04-21 1992-05-18 Oshima Jeri Porter/Novelli 4671 1992-05-18 Porter/Novelli 1909 K Street Suite 400 Washington DC 20006
14825 14825 2000-04-30 1998-08-14 Akil Deann Porter/Novelli 4671 1992-05-18 Porter/Novelli 1909 K Street Suite 400 Washington DC 20006
18990 18990 1996-06-06 1995-04-11 Sandor Shawn G. Porter/Novelli 4671 1992-05-18 Porter/Novelli 1909 K Street Suite 400 Washington DC 20006
19068 19068 1994-06-08 1992-05-18 Hussein Patricia Yu Porter/Novelli 4671 1992-05-18 Porter/Novelli 1909 K Street Suite 400 Washington DC 20006
23791 23791 1994-07-22 1993-10-28 Beardsley David A. Porter/Novelli 4671 1992-05-18 Porter/Novelli 1909 K Street Suite 400 Washington DC 20006
24562 24562 1996-07-30 1992-05-18 Swerling Gerald Porter/Novelli 4671 1992-05-18 Porter/Novelli 1909 K Street Suite 400 Washington DC 20006
24921 24921 1998-07-31 1992-05-18 Healy James Porter/Novelli 4671 1992-05-18 Porter/Novelli 1909 K Street Suite 400 Washington DC 20006
26630 26630 1998-08-14 1994-05-02 Powers Charles H. Porter/Novelli 4671 1992-05-18 Porter/Novelli 1909 K Street Suite 400 Washington DC 20006
28336 28336 1998-08-31 1992-05-18 Cady Donald H. Porter/Novelli 4671 1992-05-18 Porter/Novelli 1909 K Street Suite 400 Washington DC 20006
29037 29037 1994-09-02 1992-05-18 Doner Lynne Porter/Novelli 4671 1992-05-18 Porter/Novelli 1909 K Street Suite 400 Washington DC 20006
30030 30030 1998-09-18 1992-05-18 Cox William Porter/Novelli 4671 1992-05-18 Porter/Novelli 1909 K Street Suite 400 Washington DC 20006
32464 32464 1993-10-08 1992-05-18 Hart Louisa Porter/Novelli 4671 1992-05-18 Porter/Novelli 1909 K Street Suite 400 Washington DC 20006
33775 33775 1993-10-28 1992-05-18 Kiker John Porter/Novelli 4671 1992-05-18 Porter/Novelli 1909 K Street Suite 400 Washington DC 20006
33776 33776 1993-10-28 1992-05-18 Russell Bridget Porter/Novelli 4671 1992-05-18 Porter/Novelli 1909 K Street Suite 400 Washington DC 20006
40764 40764 1993-12-31 1992-05-18 Jones Amy Porter/Novelli 4671 1992-05-18 Porter/Novelli 1909 K Street Suite 400 Washington DC 20006
40783 40783 1994-12-31 1992-05-18 Gould Robert J. Porter/Novelli 4671 1992-05-18 Porter/Novelli 1909 K Street Suite 400 Washington DC 20006
40784 40784 1994-12-31 1992-05-18 Snyder Danny D. Porter/Novelli 4671 1992-05-18 Porter/Novelli 1909 K Street Suite 400 Washington DC 20006
40796 40796 1994-12-31 1993-10-28 Moser Diane M. Porter/Novelli 4671 1992-05-18 Porter/Novelli 1909 K Street Suite 400 Washington DC 20006
40852 40852 1995-12-31 1992-05-18 Ledford Majorie Porter/Novelli 4671 1992-05-18 Porter/Novelli 1909 K Street Suite 400 Washington DC 20006
40853 40853 1995-12-31 1992-05-18 Maguire Susan Porter/Novelli 4671 1992-05-18 Porter/Novelli 1909 K Street Suite 400 Washington DC 20006
40975 40975 1996-12-31 1992-05-18 Pratt Ron Porter/Novelli 4671 1992-05-18 Porter/Novelli 1909 K Street Suite 400 Washington DC 20006

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