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

5 rows where City = "Beirut"

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
987	987	2018-01-02	Saad Hariri through Millennium Group Services	2011-11-01	LEBANON	6074 6074	2011-11-01	Bridges International Group			Beirut
9720	9720	2018-08-08	Office of the Prime Minister of Lebanon	2017-05-11	LEBANON	6429 6429	2017-05-11	Brooke, William W.	Riad El-Solh Square		Beirut
10619	10619	2011-08-31	Millennium Group Services	2010-08-13	LEBANON	5998 5998	2010-08-13	Duane Morris Government Affairs, LLC	Al-Shouaa Building, 12th Floor	Rashid Karami Street Verdun District	Beirut
10620	10620	2011-08-31	Murr Television (aka MurrTV)	2011-07-27	LEBANON	5875 5875	2008-06-17	BLJ Worldwide LTD	Mr. Elie Nauouzi RML Building	Fouad Chehab Avenue - Achrafieh Fassouh	Beirut
11599	11599	2006-09-30	National Dialogue Party of Lebanon	2006-06-05	LEBANON	5430 5430	2001-05-10	BGR Government Affairs, LLC	Dona Maria Str. Marj el Zouhour Bldg.	Rass El Nabeh	Beirut

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