FARA_All_ForeignPrincipals

Table actions
List of all foreign principals (active and terminated)

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

19 rows where Country/Location_Represented = "MALAWI"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Registration_Number, Registrant_Date, Address_1, Address_2, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State 3

City 2

Country/Location_Represented 1

  • MALAWI · 19 ✖
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
854 854 1982-01-01 Tea Association (Central Africa), Ltd. 1971-07-15 MALAWI Tea Council of the U.S.A., Inc. 1853 1965-02-10 Tea Council of the U.S.A., Inc. Blantyre        
1438 1438 2019-01-20 Minister Hon. Atupele Austin Muluzi and UDF 2019-01-20 MALAWI Silverbridge, Khendhrah  6619 2019-01-20 Silverbridge, Khendhrah          
1756 1756 1991-01-31 Government of Malawi 1971-02-18 MALAWI Trippe, Jerry Collier 2243 1971-02-18 Trippe, Jerry Collier Zomba        
3007 3007 1995-02-28 United Democratic Front 1993-08-17 MALAWI Banda, Thokozani Manyika 4859 1993-08-17 Banda, Thokozani Manyika Limbe        
3998 3998 1994-03-23 Tea Association of Malawi, Ltd. 1991-01-31 MALAWI Tea Council of the U.S.A., Inc. 1853 1965-02-10 Tea Council of the U.S.A., Inc. Blantyre        
6085 6085 2016-04-30 Government of the Republic of Malawi 2015-04-23 MALAWI Nelson Mullins Riley & Scarborough, LLP 5928 2009-04-10 Nelson Mullins Riley & Scarborough, LLP Office of the President and Cabinet Private Bag 301 Lilongwe 3      
7849 7849 1993-06-15 United Front for Multiparty Democracy in Malawi 1992-04-14 MALAWI Reichler & Soble 3582 1984-05-09 Reichler & Soble Lusaka        
8274 8274 1968-06-30 Malawi Mission to the United Nations 1965-07-08 MALAWI Patton, Blow, Verrill, Brand & Boggs 1636 1963-06-06 Patton, Blow, Verrill, Brand & Boggs New York     NY  
8558 8558 1997-06-30 Tea Association of Malawi, Ltd. 1997-01-30 MALAWI Tea Council of the U.S.A., Inc. 1853 1965-02-10 Tea Council of the U.S.A., Inc. Blantyre        
8705 8705 2012-06-30 Government of the Republic of Malawi 2012-04-05 MALAWI Whitaker Group, Inc. 5539 2003-02-13 Whitaker Group, Inc. Private Bag 301 Capital City Lilongwe    
10708 10708 1988-08-24 Government of Malawi 1986-09-26 MALAWI Duncan, Allen & Talmage 3503 1983-07-25 Duncan, Allen & Talmage          
12132 12132 2002-09-30 BIZINFO, Ltd. 2001-10-30 MALAWI APCO Worldwide, Inc. 4561 1991-09-03 APCO Worldwide, Inc. Monex International Trade Center, Suite 306 Baja Toiruu - 35 Ulaanbaatar CPO Box 1001        
12208 12208 2012-09-30 Government of the Republic of Malawi through Whitaker Group Inc. 2012-04-11 MALAWI Moffett Group, LLC 5802 2007-04-17 Moffett Group, LLC Private Bag 301 Capital City Lilongwe    
12497 12497 2018-10-05 Government of the Republic of Malawi 2017-10-30 MALAWI Nelson Mullins Riley & Scarborough, LLP 5928 2009-04-10 Nelson Mullins Riley & Scarborough, LLP Office of the President and Cabinet Private Bag 301 Liongwe 3      
12513 12513 1993-10-06 Government of Malawi 1992-07-31 MALAWI Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Washington     DC  
13173 13173 2002-10-30 Government of the Republic of Malawi 2002-02-04 MALAWI DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Private Bag 301 Capital City Lilongwe 3 Central Africa        
15326 15326 1994-12-22 United Front for Multiparty Democracy in Malawi 1993-03-03 MALAWI Foley Hoag, LLP 4776 1993-03-02 Foley Hoag, LLP Lusaka        
15435 15435 1994-12-28 United Democratic Front 1993-05-26 MALAWI Covington & Burling 4807 1993-05-26 Covington & Burling Limbe        
15500 15500 1995-12-30 Tea Association of Malawi, Ltd. 1994-08-02 MALAWI Tea Council of the U.S.A., Inc. 1853 1965-02-10 Tea Council of the U.S.A., Inc. Blantyre        

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