FARA_All_RegistrantDocs

Table actions
List of URLs to all registrant docs (available in PDF format)

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

15 rows where Foreign_Principal_Country = "CAYMAN ISLANDS" and Foreign_Principal_Name = "Cayman Islands Department of Tourism"

✎ View and edit SQL

This data as json, CSV (advanced)

Document_Type 2

Foreign_Principal_Name 1

  • Cayman Islands Department of Tourism · 15 ✖

Foreign_Principal_Country 1

  • CAYMAN ISLANDS · 15 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
5025 5025 2016-01-12 Coyne Public Relations, LLC Coyne Public Relations, LLC 6177 Informational Materials   Cayman Islands Department of Tourism CAYMAN ISLANDS https://efile.fara.gov/docs/6177-Informational-Materials-20160112-4.pdf
13401 13401 2010-02-01 Missy Farren & Associates, Ltd. d/b/a MFA Missy Farren & Associates, Ltd. d/b/a MFA 5949 Exhibit AB   Cayman Islands Department of Tourism CAYMAN ISLANDS https://efile.fara.gov/docs/5949-Exhibit-AB-20100201-2.pdf
24135 24135 2017-03-01 Coyne Public Relations, LLC Coyne Public Relations, LLC 6177 Informational Materials   Cayman Islands Department of Tourism CAYMAN ISLANDS https://efile.fara.gov/docs/6177-Informational-Materials-20170301-8.pdf
27898 27898 2019-03-14 Coyne Public Relations, LLC Coyne Public Relations, LLC 6177 Informational Materials   Cayman Islands Department of Tourism CAYMAN ISLANDS https://efile.fara.gov/docs/6177-Informational-Materials-20190314-20.pdf
28751 28751 2020-03-17 Coyne Public Relations, LLC Coyne Public Relations, LLC 6177 Informational Materials   Cayman Islands Department of Tourism CAYMAN ISLANDS https://efile.fara.gov/docs/6177-Informational-Materials-20200317-21.pdf
29286 29286 2018-03-19 Coyne Public Relations, LLC Coyne Public Relations, LLC 6177 Informational Materials   Cayman Islands Department of Tourism CAYMAN ISLANDS https://efile.fara.gov/docs/6177-Informational-Materials-20180319-18.pdf
29345 29345 2021-03-19 Coyne Public Relations, LLC Coyne Public Relations, LLC 6177 Informational Materials   Cayman Islands Department of Tourism CAYMAN ISLANDS https://efile.fara.gov/docs/6177-Informational-Materials-20210319-23.pdf
29594 29594 2023-03-20 Coyne Public Relations, LLC Coyne Public Relations, LLC 6177 Informational Materials   Cayman Islands Department of Tourism CAYMAN ISLANDS https://efile.fara.gov/docs/6177-Informational-Materials-20230320-26.pdf
44874 44874 2010-04-30 Missy Farren & Associates, Ltd. d/b/a MFA Missy Farren & Associates, Ltd. d/b/a MFA 5949 Exhibit AB   Cayman Islands Department of Tourism CAYMAN ISLANDS https://efile.fara.gov/docs/5949-Exhibit-AB-20100430-3.pdf
89290 89290 2017-08-23 Coyne Public Relations, LLC Coyne Public Relations, LLC 6177 Informational Materials   Cayman Islands Department of Tourism CAYMAN ISLANDS https://efile.fara.gov/docs/6177-Informational-Materials-20170823-13.pdf
95196 95196 2009-09-02 Missy Farren & Associates, Ltd. d/b/a MFA Missy Farren & Associates, Ltd. d/b/a MFA 5949 Exhibit AB   Cayman Islands Department of Tourism CAYMAN ISLANDS https://efile.fara.gov/docs/5949-Exhibit-AB-20090902-1.pdf
97819 97819 2021-09-14 Coyne Public Relations, LLC Coyne Public Relations, LLC 6177 Informational Materials   Cayman Islands Department of Tourism CAYMAN ISLANDS https://efile.fara.gov/docs/6177-Informational-Materials-20210914-24.pdf
98495 98495 2018-09-17 Coyne Public Relations, LLC Coyne Public Relations, LLC 6177 Informational Materials   Cayman Islands Department of Tourism CAYMAN ISLANDS https://efile.fara.gov/docs/6177-Informational-Materials-20180917-19.pdf
98525 98525 2020-09-17 Coyne Public Relations, LLC Coyne Public Relations, LLC 6177 Informational Materials   Cayman Islands Department of Tourism CAYMAN ISLANDS https://efile.fara.gov/docs/6177-Informational-Materials-20200917-22.pdf
100642 100642 2016-09-26 Coyne Public Relations, LLC Coyne Public Relations, LLC 6177 Exhibit AB   Cayman Islands Department of Tourism CAYMAN ISLANDS https://efile.fara.gov/docs/6177-Exhibit-AB-20160926-3.pdf

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [FARA_All_RegistrantDocs] (
   [Date_Stamped] TEXT,
   [Registrant_Name] TEXT,
   [Registration_Number] INTEGER,
   [Document_Type] TEXT,
   [Short_Form_Name] TEXT,
   [Foreign_Principal_Name] TEXT,
   [Foreign_Principal_Country] TEXT,
   [URL] TEXT,
   FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number])
);