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

9 rows where Registrant_Name = "Carmen Group, Inc."

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Foreign_Principal_Termination_Date, Registration_Number, Registrant_Date, Address_2, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

Country/Location_Represented 7

State 2

Registrant_Name 1

  • Carmen Group, Inc. · 9 ✖

City 1

  • - 9
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
2648 2648 1990-02-18 Egypt (Through Hart Marketing Resources) 1989-10-03 EGYPT Carmen Group, Inc. 4233 1989-03-20 Carmen Group, Inc. Cairo        
4043 4043 1990-03-25 Committee for Free Elections & Democracy in Nicaragua 1989-10-04 NICARAGUA Carmen Group, Inc. 4233 1989-03-20 Carmen Group, Inc. Miami     FL  
10036 10036 2000-08-01 Parville Finance, Ltd. 1999-08-06 KAZAKHSTAN Carmen Group, Inc. 5320 1999-07-21 Carmen Group, Inc. The Lake Building, Suite 120 Wickham Cay 1, Road Town, Tortola,        
10037 10037 2000-08-01 Republic of Kazakhstan 1999-07-21 KAZAKHSTAN Carmen Group, Inc. 5320 1999-07-21 Carmen Group, Inc. Astana        
12009 12009 1989-09-30 Mohammed Harajchi 1989-03-20 IRAN Carmen Group, Inc. 4233 1989-03-20 Carmen Group, Inc. Nassau        
15298 15298 1992-12-21 CEIC Holding, Ltd., for the Government of Tatarstan 1992-05-28 RUSSIA Carmen Group, Inc. 4675 1992-05-28 Carmen Group, Inc. Ontario        
15300 15300 1992-12-21 Nippon Pillow Block Sales Company, Ltd. through Tanaka Ritger & Middleton 1992-06-05 JAPAN Carmen Group, Inc. 4675 1992-05-28 Carmen Group, Inc. Tokyo        
16150 16150 1990-12-31 City of Managua, Nicaragua 1990-07-24 NICARAGUA Carmen Group, Inc. 4233 1989-03-20 Carmen Group, Inc. Managua        
16728 16728 2013-12-31 Cayman Islands Government 2013-09-16 CAYMAN ISLANDS Carmen Group, Inc. 6188 2013-09-16 Carmen Group, Inc. 133 Elgin Avenue Grand Cayman KY1-9000      

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