fara: FARA_All_ForeignPrincipals: 6 rows where where City = "Beirut"

List of all foreign principals (active and terminated)

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

6 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
47	47		Association of Banks in Lebanon	2020-05-19	LEBANON	6825 6825	2020-05-19	Carlos Abadi	Gouraud Street		Beirut
957	957	2018-01-02	Saad Hariri through Millennium Group Services	2011-11-01	LEBANON	6074 6074	2011-11-01	Bridges International Group			Beirut
9857	9857	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
10762	10762	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
10763	10763	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
11759	11759	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)
);