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

20 rows where Registration_Number = 3489

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date, Short_Form_First_Name, Short_Form_Date (date)

State 1

Registration_Number 1

  • Global U.S.A., Inc. · 20 ✖

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
5015 5015 1987-01-31 1985-03-25 Timmons William E. Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. 2121 K Street, N.W. Suite 650 Washington DC 20037
6838 6838 1996-02-14 1993-01-19 Denysyk Bohdan Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. 2121 K Street, N.W. Suite 650 Washington DC 20037
6839 6839 1996-02-14 1984-02-10 Nugent John M. , Jr. Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. 2121 K Street, N.W. Suite 650 Washington DC 20037
6841 6841 1996-02-14 1987-05-04 Golwen Anne H. Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. 2121 K Street, N.W. Suite 650 Washington DC 20037
6844 6844 1996-02-14 1988-06-14 Kopp George S. Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. 2121 K Street, N.W. Suite 650 Washington DC 20037
6849 6849 1996-02-14 1993-07-09 Berkove Naomi Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. 2121 K Street, N.W. Suite 650 Washington DC 20037
6850 6850 1996-02-14 1993-07-09 Brown Rosamond S. Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. 2121 K Street, N.W. Suite 650 Washington DC 20037
6853 6853 1996-02-14 1992-07-31 Bannerman Edward R.M. Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. 2121 K Street, N.W. Suite 650 Washington DC 20037
19572 19572 1993-06-15 1986-07-14 Fierce Donald L. Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. 2121 K Street, N.W. Suite 650 Washington DC 20037
23106 23106 1986-07-14 1986-07-24 Wilson Deborah Fry Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. 2121 K Street, N.W. Suite 650 Washington DC 20037
24309 24309 1993-07-28 1987-06-10 Dresen Anna-Maria Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. 2121 K Street, N.W. Suite 650 Washington DC 20037
25978 25978 1986-08-05 1986-06-17 McIntosh Joanna K. Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. 2121 K Street, N.W. Suite 650 Washington DC 20037
27708 27708 1991-08-29 1990-10-03 Anderson Stanton D. Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. 2121 K Street, N.W. Suite 650 Washington DC 20037
28096 28096 1986-08-31 1985-03-13 Conkling Robert J. Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. 2121 K Street, N.W. Suite 650 Washington DC 20037
29867 29867 1992-09-15 1986-01-31 Denysyk Bohdan Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. 2121 K Street, N.W. Suite 650 Washington DC 20037
30124 30124 1990-09-20 1986-01-23 Morris William H. , Jr. Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. 2121 K Street, N.W. Suite 650 Washington DC 20037
36375 36375 1992-11-25 1992-11-09 Brown Michael Arrington Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. 2121 K Street, N.W. Suite 650 Washington DC 20037
36657 36657 1983-11-30 1983-06-24 Waldmann Raymond J. Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. 2121 K Street, N.W. Suite 650 Washington DC 20037
38308 38308 1995-12-14 1994-09-07 Shackelford Lottie H. Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. 2121 K Street, N.W. Suite 650 Washington DC 20037
38991 38991 1984-12-23 1983-06-24 Farrell J. Michael Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. 2121 K Street, N.W. Suite 650 Washington DC 20037

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