home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for FARA_All_ForeignPrincipals
List of all foreign principals (active and terminated)

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

8 rows where Country/Location_Represented = "CHAD"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registrant_Name 7

  • Squire Patton Boggs, LLP 2
  • Arnold & Porter Kaye Scholer LLP 1
  • Hayward International 1
  • Scribe Strategies & Advisors, Inc. 1
  • Squire, Sanders & Dempsey, L.L.P. 1
  • Washington World Group, Ltd. 1
  • Yorktown Solutions, LLC 1

Foreign_Principal 7

  • Embassy of the Republic of Chad 2
  • Ambassador-at - Large Kitoko Gaea Ngoulou 1
  • De Havilland Aircraft of Canada, Ltd. 1
  • Government of the Republic of Chad, Embassy 1
  • Les Transformateurs 1
  • Republic of Chad 1
  • Republic of Tchad (Chad) 1

State 2

  • - 4
  • DC 4

City 2

  • - 6
  • Washington 2

Country/Location_Represented 1

  • CHAD · 8 ✖
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
47 47   Ambassador-at - Large Kitoko Gaea Ngoulou 2022-12-23 CHAD Yorktown Solutions, LLC 6491 2017-11-19 Yorktown Solutions, LLC Presidency of the Republic of Chad, PO Box 74 N'Djamen      
428 428   Les Transformateurs 2023-05-16 CHAD Scribe Strategies & Advisors, Inc. 6305 2015-07-20 Scribe Strategies & Advisors, Inc.          
1005 1005 2009-01-01 Embassy of the Republic of Chad 2007-08-29 CHAD Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2002 R Street, NW   Washington DC 20009
6187 6187 1983-05-01 De Havilland Aircraft of Canada, Ltd. 1981-04-10 CHAD Arnold & Porter Kaye Scholer LLP 1750 1964-06-04 Arnold & Porter Kaye Scholer LLP Downsview        
7481 7481 1965-06-02 Republic of Tchad (Chad) 1963-07-08 CHAD Squire, Sanders & Dempsey, L.L.P. 746 1952-12-02 Squire, Sanders & Dempsey, L.L.P. Washington     DC  
8147 8147 2012-06-28 Embassy of the Republic of Chad 2011-08-25 CHAD Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2401 Massachusetts Avenue, NW   Washington DC 20008
11658 11658 2001-09-15 Government of the Republic of Chad, Embassy 2002-01-25 CHAD Washington World Group, Ltd. 5016 1995-04-20 Washington World Group, Ltd. 2002 R Street, N.W.     DC  
14459 14459 1995-11-30 Republic of Chad 1995-11-30 CHAD Hayward International 5081 1995-11-30 Hayward International N'Djamena        

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])
);
Powered by Datasette · Queries took 125.06ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows