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

12 rows where Foreign_Principal_Country = "GUINEA"

✎ View and edit SQL

This data as json, CSV (advanced)

Foreign_Principal_Country 1

  • GUINEA · 12 ✖

Document_Type 1

Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
1003 1003 1985-01-01 WHITE & CASE White & Case, LLP 2759 Exhibit AB   REPUBLIC OF GUINEA GUINEA https://efile.fara.gov/docs/2759-Exhibit-AB-19850101-D027IO03.pdf
2987 2987 1992-01-03 NORTH AMERICAN PRECIS SYNDICATE North American Precis Syndicate 2836 Exhibit AB   EMBASSY OF GUINEA GUINEA https://efile.fara.gov/docs/2836-Exhibit-AB-19920103-D05S8304.pdf
25567 25567 1989-03-06 WASHINGTON INTERNATIONAL GROUP, INC. Washington International Group, Inc. 3320 Exhibit AB   GOVERNMENT OF GUINEA GUINEA https://efile.fara.gov/docs/3320-Exhibit-AB-19890306-D0T7W801.pdf
30233 30233 2015-03-23 Nelson Mullins Riley & Scarborough, LLP Nelson Mullins Riley & Scarborough, LLP 5928 Exhibit AB   Republic of Guinea GUINEA https://efile.fara.gov/docs/5928-Exhibit-AB-20150323-13.pdf
50468 50468 1995-05-09 WASHINGTON & CHRISTIAN Washington & Christian 4569 Exhibit AB   REPUBLIC OF GUINEA (A/K/A REPUBLIQUE DE GUINEE) GUINEA https://efile.fara.gov/docs/4569-Exhibit-AB-19950509-DGPDUO01.pdf
52762 52762 2021-05-17 Ambessa Solutions LLC Ambessa Solutions LLC 6962 Exhibit AB   Union of Democratic Forces of Guinea (UFDG) and Cellou Dalein Diallo GUINEA https://efile.fara.gov/docs/6962-Exhibit-AB-20210517-1.pdf
67901 67901 1995-06-27 WASHINGTON & CHRISTIAN Washington & Christian 4569 Exhibit AB   REPUBLIC OF GUINEA (A/K/A REPUBLIQUE DE GUINEE) GUINEA https://efile.fara.gov/docs/4569-Exhibit-AB-19950627-DGPEAY01.pdf
87650 87650 2019-08-14 Scribe Strategies & Advisors, Inc. Scribe Strategies & Advisors, Inc. 6305 Exhibit AB   Embassy of the Republic of Guinea GUINEA https://efile.fara.gov/docs/6305-Exhibit-AB-20190814-7.pdf
88331 88331 2014-08-18 JWI, LLC JWI, LLC 4990 Exhibit AB   Union des Forces Democratique de Guinee (UFDG) GUINEA https://efile.fara.gov/docs/4990-Exhibit-AB-20140818-24.pdf
116902 116902 1992-11-02 BARRON-BIRRELL, INC. Barron-Birrell, Inc. 4729 Exhibit AB   REPUBLIC OF GUINEA GUINEA https://efile.fara.gov/docs/4729-Exhibit-AB-19921102-D1XT7G02.pdf
130918 130918 2015-12-14 Nelson Mullins Riley & Scarborough, LLP Nelson Mullins Riley & Scarborough, LLP 5928 Exhibit AB   Republic of Guinea GUINEA https://efile.fara.gov/docs/5928-Exhibit-AB-20151214-20.pdf
131361 131361 2014-12-16 JWI, LLC JWI, LLC 4990 Exhibit AB   Union des Forces Democratique de Guinee (UFDG) GUINEA https://efile.fara.gov/docs/4990-Exhibit-AB-20141216-25.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])
);