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

6 rows where Country/Location_Represented = "CAYMAN ISLANDS" and Foreign_Principal = "Cayman Islands Department of Tourism"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • - 6

Foreign_Principal 1

  • Cayman Islands Department of Tourism · 6 ✖

Country/Location_Represented 1

  • CAYMAN ISLANDS · 6 ✖

City 1

  • - 6
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
103 103   Cayman Islands Department of Tourism 2016-09-26 CAYMAN ISLANDS Coyne Public Relations, LLC 6177 2013-08-07 Coyne Public Relations, LLC Government Administration Building Box 134 133 Elgin Avenue Grand Cayman KY 1-9000      
4591 4591 2001-03-31 Cayman Islands Department of Tourism 1986-02-20 CAYMAN ISLANDS O'Leary Clarke & Partners, Inc. 3780 1986-02-20 O'Leary Clarke & Partners, Inc.          
5185 5185 1977-04-12 Cayman Islands Department of Tourism 1976-09-15 CAYMAN ISLANDS Samuel B. Crispin & Associates, Inc. 2720 1976-09-15 Samuel B. Crispin & Associates, Inc. Grand Cayman        
5328 5328 1993-04-16 Cayman Islands Department of Tourism 1987-07-22 CAYMAN ISLANDS Cohen Associates, Ltd., Inc. 4016 1987-07-22 Cohen Associates, Ltd., Inc. Grand Cayman        
9109 9109 2015-07-08 Cayman Islands Department of Tourism 2009-09-02 CAYMAN ISLANDS Missy Farren & Associates, Ltd. d/b/a MFA 5949 2009-09-02 Missy Farren & Associates, Ltd. d/b/a MFA Regatta Office Park, Windward 3 Grand Cayman, KY1 - 1102      
14787 14787 1982-12-04 Cayman Islands Department of Tourism 1980-06-03 CAYMAN ISLANDS Robinsons, Inc. 3110 1980-06-03 Robinsons, Inc. Grand Cayman        

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