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
253	253		Government of Aruba	1978-12-29	ARUBA	2987 2987	1978-12-29	Aruba Tourism Authority	Oranjestad
856	856	1991-01-01	Government of Aruba	1987-02-13	ARUBA	1750 1750	1964-06-04	Arnold & Porter Kaye Scholer, LLP	Oranjestad
944	944	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
1712	1712	1999-01-31	Government of Aruba	1995-01-09	ARUBA	4200 4200	1989-01-06	Mark A. Siegel & Associates, Inc.	Oranjestad
1746	1746	2006-01-31	Government of Aruba	2003-12-10	ARUBA	5557 5557	2003-04-23	Alexander Strategy Group	L.G. Smith Boulevard, 76, Oranjestad
1908	1908	1989-02-01	Government of Aruba	1986-01-17	ARUBA	3906 3906	1986-11-17	Rendon Company	Oranjestad
1932	1932	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
2579	2579	1995-02-23	Government of Aruba	1989-11-21	ARUBA	3075 3075	1979-12-13	TKC International, Inc.
4978	4978	1989-04-13	Government of Aruba	1988-07-05	ARUBA	3869 3869	1986-08-13	Winston & Strawn
8065	8065	1989-06-30	Government of Aruba	1986-08-11	ARUBA	3865 3865	1986-08-01	Mark A. Siegel & Associates, Inc.
8484	8484	1990-07-01	Government of Aruba	1990-06-12	ARUBA	4385 4385	1990-06-12	Stackig, Sanderson & White	Oranjestad
12912	12912	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
13401	13401	2001-11-15	Government of Aruba	1995-04-11	ARUBA	4449 4449	1990-12-17	Rendon Group, Inc.	Oranjestad
16013	16013	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)
);