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

15 rows where Foreign_Principal = "Government of Aruba"

Search:

descending

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
257	257		Government of Aruba	1978-12-29	ARUBA	2987 2987	1978-12-29	Aruba Tourism Authority	Oranjestad
875	875	1991-01-01	Government of Aruba	1987-02-13	ARUBA	1750 1750	1964-06-04	Arnold & Porter Kaye Scholer, LLP	Oranjestad
963	963	2015-01-01	Government of Aruba	2014-07-28	ARUBA	5774 5774	2006-10-06	CLS Strategies	Ministry of Finance and Government Organization	L.G. Smith Boulevard 76 Oranjestad Aruba, Caribbean Sea
1722	1722	1999-01-31	Government of Aruba	1995-01-09	ARUBA	4200 4200	1989-01-06	Mark A. Siegel & Associates, Inc.	Oranjestad
1756	1756	2006-01-31	Government of Aruba	2003-12-10	ARUBA	5557 5557	2003-04-23	Alexander Strategy Group	L.G. Smith Boulevard, 76, Oranjestad
1913	1913	1989-02-01	Government of Aruba	1986-01-17	ARUBA	3906 3906	1986-11-17	Rendon Company	Oranjestad
1937	1937	1999-02-01	Government of Aruba	1995-05-18	ARUBA	3869 3869	1986-08-13	Winston & Strawn	Oranjestad
2415	2415	1990-02-15	Government of Aruba	1989-01-06	ARUBA	4200 4200	1989-01-06	Mark A. Siegel & Associates, Inc.	Oranjestad
2577	2577	1995-02-23	Government of Aruba	1989-11-21	ARUBA	3075 3075	1979-12-13	TKC International, Inc.
4949	4949	1989-04-13	Government of Aruba	1988-07-05	ARUBA	3869 3869	1986-08-13	Winston & Strawn
8013	8013	1989-06-30	Government of Aruba	1986-08-11	ARUBA	3865 3865	1986-08-01	Mark A. Siegel & Associates, Inc.
8426	8426	1990-07-01	Government of Aruba	1990-06-12	ARUBA	4385 4385	1990-06-12	Stackig, Sanderson & White	Oranjestad
12822	12822	2017-10-31	Government of Aruba	2009-12-15	ARUBA	5965 5965	2009-12-15	Hills Stern & Morley, LLP	L.G. Smith Blvd. 76		Oranjestad
13304	13304	2001-11-15	Government of Aruba	1995-04-11	ARUBA	4449 4449	1990-12-17	Rendon Group, Inc.	Oranjestad
15900	15900	2009-12-31	Government of Aruba	2006-03-24	ARUBA	5741 5741	2006-03-24	MITA Group, Inc.	J.E. Irausquin Plaza		Oranjestad

Advanced export

JSON shape: default, array, newline-delimited

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)
);