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

16 rows where Registration_Number = 3476

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date

State 1

Registration_Number 1

  • One NorthEast · 16 ✖

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
8466 8466 1996-02-29 1991-04-17 Donnelly Bruce Edward One NorthEast 3476 1983-05-25 One NorthEast Meadows Corporate Center 2850 West Golf Road, Suite 401 Rolling Meadows IL 60008-4033
8813 8813 1996-03-01 1995-11-21 Niedermeyer Jennifer Ann One NorthEast 3476 1983-05-25 One NorthEast Meadows Corporate Center 2850 West Golf Road, Suite 401 Rolling Meadows IL 60008-4033
14662 14662 1995-04-30 1986-02-10 McMurtry Ian W. One NorthEast 3476 1983-05-25 One NorthEast Meadows Corporate Center 2850 West Golf Road, Suite 401 Rolling Meadows IL 60008-4033
20175 20175 1994-06-24 1993-06-08 Fisher Janet Elizabeth One NorthEast 3476 1983-05-25 One NorthEast Meadows Corporate Center 2850 West Golf Road, Suite 401 Rolling Meadows IL 60008-4033
20177 20177 1994-06-24 1990-07-16 Greenland Peter John One NorthEast 3476 1983-05-25 One NorthEast Meadows Corporate Center 2850 West Golf Road, Suite 401 Rolling Meadows IL 60008-4033
21054 21054 1986-06-30 1983-05-25 Martin Kenneth S. One NorthEast 3476 1983-05-25 One NorthEast Meadows Corporate Center 2850 West Golf Road, Suite 401 Rolling Meadows IL 60008-4033
21083 21083 1988-06-30 1987-03-24 Creighton Robert Blake One NorthEast 3476 1983-05-25 One NorthEast Meadows Corporate Center 2850 West Golf Road, Suite 401 Rolling Meadows IL 60008-4033
27326 27326 1984-08-24 1983-05-25 Brown Douglas Arthur One NorthEast 3476 1983-05-25 One NorthEast Meadows Corporate Center 2850 West Golf Road, Suite 401 Rolling Meadows IL 60008-4033
29441 29441 1995-09-08 1995-05-24 Flowers Carol Dunker One NorthEast 3476 1983-05-25 One NorthEast Meadows Corporate Center 2850 West Golf Road, Suite 401 Rolling Meadows IL 60008-4033
36392 36392 2000-11-25 2001-02-20 MacKenzie Robert L. One NorthEast 3476 1983-05-25 One NorthEast Meadows Corporate Center 2850 West Golf Road, Suite 401 Rolling Meadows IL 60008-4033
36393 36393 2000-11-25 1995-04-05 McIntosh Heather D. One NorthEast 3476 1983-05-25 One NorthEast Meadows Corporate Center 2850 West Golf Road, Suite 401 Rolling Meadows IL 60008-4033
36394 36394 2000-11-25 1994-06-24 Stoner Mark L. One NorthEast 3476 1983-05-25 One NorthEast Meadows Corporate Center 2850 West Golf Road, Suite 401 Rolling Meadows IL 60008-4033
36395 36395 2000-11-25 1999-08-06 Pennington Giles Edward One NorthEast 3476 1983-05-25 One NorthEast Meadows Corporate Center 2850 West Golf Road, Suite 401 Rolling Meadows IL 60008-4033
36396 36396 2000-11-25 1999-08-06 Smith Trevor One NorthEast 3476 1983-05-25 One NorthEast Meadows Corporate Center 2850 West Golf Road, Suite 401 Rolling Meadows IL 60008-4033
36397 36397 2000-11-25 1994-09-23 Kubenik Margaret M. One NorthEast 3476 1983-05-25 One NorthEast Meadows Corporate Center 2850 West Golf Road, Suite 401 Rolling Meadows IL 60008-4033
36398 36398 2000-11-25 1994-09-23 Minick Marsha A. One NorthEast 3476 1983-05-25 One NorthEast Meadows Corporate Center 2850 West Golf Road, Suite 401 Rolling Meadows IL 60008-4033

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