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

1 row where Document_Type = "Exhibit AB" and Foreign_Principal_Name = "The Government of the Turks and Caicos Islands"

✎ View and edit SQL

This data as json, CSV (advanced)

Foreign_Principal_Name 1

  • The Government of the Turks and Caicos Islands · 1 ✖

Foreign_Principal_Country 1

Document_Type 1

  • Exhibit AB · 1 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
108013 108013 2022-10-10 FGS Global (US) LLC (FKA FGH Holdings LLC) FGS Global (US) LLC (FKA FGH Holdings LLC) 5666 Exhibit AB   The Government of the Turks and Caicos Islands TURKS AND CAICOS ISLANDS https://efile.fara.gov/docs/5666-Exhibit-AB-20221010-77.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])
);