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

13 rows where Registrant_Name = "Sanitas International, LLC"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

Foreign_Principal 13

  • Abdullah Abdullah Presidential Campaign 1
  • Ghani, Ashraf 1
  • Government of the Republic of the Congo via Empire Solutions LLC 1
  • Information Affairs Authority, Kingdom of Bahrain via Joe Trippi and Associates 1
  • International Waterfront Resources Limited on behalf of the Port of Spain International Waterfront Centre 1
  • Iraqiya List 1
  • Libya Institute of Advanced Studies (LIAS) 1
  • Minou Tavarez Mirabal 1
  • OJSC Belarusian Potash Company 1
  • Party of Justice and Trust 1
  • Sheik Jamal al-Dhari, Peace Ambassadors for Iraq (PAFI) 1
  • South African Democracy Network (SADN) 1
  • Subianto, Prabowo 1

Country/Location_Represented 11

  • AFGHANISTAN 2
  • IRAQ 2
  • BAHRAIN 1
  • BELARUS 1
  • BOSNIA & HERZEGOVINA 1
  • CONGO, DEMOCRATIC REPUBLIC OF THE 1
  • DOMINICAN REPUBLIC 1
  • INDONESIA 1
  • LIBYA 1
  • TRINIDAD AND TOBAGO 1
  • ZIMBABWE 1

City 7

  • - 7
  • Baghdad 1
  • Isa Town 1
  • Jakarta 1
  • Kabul 1
  • New York 1
  • Port of Spain 1

State 2

  • - 12
  • NY 1

Registrant_Name 1

  • Sanitas International, LLC · 13 ✖
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
1893 1893 2013-01-31 Iraqiya List 2012-04-25 IRAQ Sanitas International, LLC 5963 2009-11-18 Sanitas International, LLC     Baghdad    
3853 3853 2011-03-17 Government of the Republic of the Congo via Empire Solutions LLC 2011-03-15 CONGO, DEMOCRATIC REPUBLIC OF THE Sanitas International, LLC 5963 2009-11-18 Sanitas International, LLC 1123 Broadway, Suite 1117   New York NY 10010
6087 6087 2016-04-30 OJSC Belarusian Potash Company 2015-09-28 BELARUS Sanitas International, LLC 5963 2009-11-18 Sanitas International, LLC 35 Masherova Ave. 220002 Minsk, Republic of Belarus UNP 192050251      
6090 6090 2016-04-30 Sheik Jamal al-Dhari, Peace Ambassadors for Iraq (PAFI) 2015-11-24 IRAQ Sanitas International, LLC 5963 2009-11-18 Sanitas International, LLC          
6379 6379 2015-05-07 Libya Institute of Advanced Studies (LIAS) 2015-03-10 LIBYA Sanitas International, LLC 5963 2009-11-18 Sanitas International, LLC Tobruk        
7260 7260 2016-05-31 Minou Tavarez Mirabal 2016-02-26 DOMINICAN REPUBLIC Sanitas International, LLC 5963 2009-11-18 Sanitas International, LLC Calle Fernando Valerio, #5 esq. Dr. Nunez y Dominguez Ensanche La Julia Santo Domingo, D.N.      
7944 7944 2014-06-19 Abdullah Abdullah Presidential Campaign 2014-06-09 AFGHANISTAN Sanitas International, LLC 5963 2009-11-18 Sanitas International, LLC Kabul        
9887 9887 2010-07-31 International Waterfront Resources Limited on behalf of the Port of Spain International Waterfront Centre 2009-11-18 TRINIDAD AND TOBAGO Sanitas International, LLC 5963 2009-11-18 Sanitas International, LLC 3840 Sackville St   Port of Spain    
11389 11389 2014-09-05 Ghani, Ashraf 2014-07-14 AFGHANISTAN Sanitas International, LLC 5963 2009-11-18 Sanitas International, LLC     Kabul    
12940 12940 2014-10-22 Party of Justice and Trust 2014-09-29 BOSNIA & HERZEGOVINA Sanitas International, LLC 5963 2009-11-18 Sanitas International, LLC Nikole Subica Zrinskog 4, 88000, Mostar        
13464 13464 2013-10-31 South African Democracy Network (SADN) 2013-07-29 ZIMBABWE Sanitas International, LLC 5963 2009-11-18 Sanitas International, LLC P.O. Box 91199 Aucland Park 20006 Johannesburg, South Africa      
13648 13648 2014-11-01 Subianto, Prabowo 2014-07-14 INDONESIA Sanitas International, LLC 5963 2009-11-18 Sanitas International, LLC     Jakarta    
14543 14543 2012-11-30 Information Affairs Authority, Kingdom of Bahrain via Joe Trippi and Associates 2011-08-23 BAHRAIN Sanitas International, LLC 5963 2009-11-18 Sanitas International, LLC P.O. Box 253   Isa Town    

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 343.502ms · 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