FARA_All_ForeignPrincipals

Table actions
List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

8 rows where Foreign_Principal = "Hashemite Kingdom of Jordan"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Address_1, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State 2

City 2

Foreign_Principal 1

  • Hashemite Kingdom of Jordan · 8 ✖

Country/Location_Represented 1

Link rowid ▼ Foreign_Principal_Termination_Date Foreign_Principal Foreign_Principal_Registration_Date Country/Location_Represented Registration_Number Registrant_Date Registrant_Name Address_1 Address_2 City State Zip
969 969 1996-01-01 Hashemite Kingdom of Jordan 1988-07-13 JORDAN Aspen Hill Enterprises, Ltd. 4158 1988-07-13 Aspen Hill Enterprises, Ltd. Amman        
8060 8060 1984-06-24 Hashemite Kingdom of Jordan 1983-11-07 JORDAN Neill, Mullenholz, Shaw & Seeger 3384 1982-06-18 Neill, Mullenholz, Shaw & Seeger          
11830 11830 1985-09-26 Hashemite Kingdom of Jordan 1975-04-11 JORDAN Doremus & Company 2319 1972-02-18 Doremus & Company Amman        
14736 14736 2019-12-01 Hashemite Kingdom of Jordan 2018-06-25 JORDAN White & Case LLP 6393 2016-11-21 White & Case LLP 3504 International Drive, NW   Washington DC 20008
14826 14826 1990-12-05 Hashemite Kingdom of Jordan 1983-11-17 JORDAN Washington International Group, Inc. 3320 1982-01-05 Washington International Group, Inc. Amman        
15599 15599 1960-12-31 Hashemite Kingdom of Jordan 1960-06-27 JORDAN Brooks, William F. 1373 1960-06-27 Brooks, William F. Amman        
15656 15656 1967-12-31 Hashemite Kingdom of Jordan 1967-08-30 JORDAN Fund for the Relief of Jordan 2045 1967-08-30 Fund for the Relief of Jordan Amman        
16011 16011 1987-12-31 Hashemite Kingdom of Jordan 1981-10-06 JORDAN IBTT Consultants, Inc. 3281 1981-10-06 IBTT Consultants, Inc. Amman        

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [FARA_All_ForeignPrincipals] (
   [Foreign_Principal_Termination_Date] TEXT,
   [Foreign_Principal] TEXT,
   [Foreign_Principal_Registration_Date] TEXT,
   [Country/Location_Represented] TEXT,
   [Registration_Number] INTEGER,
   [Registrant_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])
);