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

20 rows where Foreign_Principal = "Royal Embassy of Saudi Arabia"

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	City	State	Zip
591	591		Royal Embassy of Saudi Arabia	2017-03-31	SAUDI ARABIA	6412 6412	2017-03-31	Capitol Media Group	601 New Hampshire Avenue, NW	Washington	DC	20037
592	592		Royal Embassy of Saudi Arabia	2019-11-12	SAUDI ARABIA	6749 6749	2019-11-12	Larson Shannahan Slifka Group, LLC	601 New Hampshire Avenue, NW	Washington	DC	20037
949	949	2009-01-01	Royal Embassy of Saudi Arabia	2002-12-06	SAUDI ARABIA	5432 5432	2001-05-18	Loeffler Group, LLP	601 New Hampshire Avenue, N.W. 20037		DC
983	983	1981-01-02	Royal Embassy of Saudi Arabia	1978-03-20	SAUDI ARABIA	2869 2869	1978-03-20	J. Crawford Cook, Inc.	Washington		DC
1333	1333	2019-01-19	Royal Embassy of Saudi Arabia	2016-11-09	SAUDI ARABIA	6389 6389	2016-11-09	Nazer, Fahad	601 New Hampshire Avenue, NW	Washington	DC	20037
2047	2047	2007-02-03	Royal Embassy of Saudi Arabia	2006-02-23	SAUDI ARABIA	5734 5734	2006-02-23	DNX Partners, LLC	600 New Hampshire Avenue, NW	Washington	DC	20037
2781	2781	1987-02-28	Royal Embassy of Saudi Arabia	1986-03-11	SAUDI ARABIA	3734 3734	1985-09-18	Michael K. Deaver & Associates	Washington		DC
3064	3064	1976-03-01	Royal Embassy of Saudi Arabia	1975-11-25	SAUDI ARABIA	2632 2632	1975-11-25	Saudi Arabian Information Center	Washington		DC
4146	4146	1979-03-31	Royal Embassy of Saudi Arabia	1978-04-07	SAUDI ARABIA	2881 2881	1978-04-07	Michael W. Moynihan & Associates, Inc.	Washington		DC
4530	4530	2016-03-31	Royal Embassy of Saudi Arabia	2015-03-26	SAUDI ARABIA	5198 5198	1997-07-31	Pillsbury Winthrop Shaw Pittman, LLP	601 New Hampshire Avenue, NW	Washington	DC	20037
4920	4920	1986-04-12	Royal Embassy of Saudi Arabia	1985-04-25	SAUDI ARABIA	2836 2836	1977-10-12	North American Precis Syndicate			DC
5907	5907	2016-05-01	Royal Embassy of Saudi Arabia	2015-03-31	SAUDI ARABIA	3712 3712	1985-08-05	DLA Piper US LLP
11255	11255	1995-09-25	Royal Embassy of Saudi Arabia	1995-07-14	SAUDI ARABIA	5036 5036	1995-07-14	Gibson, Dunn & Crutcher	Washington		DC
11673	11673	2018-09-30	Royal Embassy of Saudi Arabia	2017-06-06	SAUDI ARABIA	5478 5478	2002-03-04	Harbour Group, LLC	601 New Hampshire Avenue, NW	Washington	DC	20037
11853	11853	1994-10-04	Royal Embassy of Saudi Arabia	1993-02-23	SAUDI ARABIA	4769 4769	1993-02-23	Leggett, Carroll H.	Washington		DC
12045	12045	1993-10-14	Royal Embassy of Saudi Arabia	1985-01-24	SAUDI ARABIA	2850 2850	1977-11-29	Hannaford Company, Inc.	Washington		DC
12952	12952	2001-11-01	Royal Embassy of Saudi Arabia	2001-09-20	SAUDI ARABIA	2469 2469	1973-10-23	Burson-Marsteller	601 New Hampshire Avenue, N.W. 20037		DC
13124	13124	1999-11-07	Royal Embassy of Saudi Arabia	1996-12-30	SAUDI ARABIA	5148 5148	1996-12-30	Powell Tate, Inc.	Washington		DC
13997	13997	2000-12-01	Royal Embassy of Saudi Arabia	1995-07-28	SAUDI ARABIA	4259 4259	1989-05-25	Cassidy & Associates, Inc.			DC
15727	15727	2000-12-31	Royal Embassy of Saudi Arabia	1999-12-10	SAUDI ARABIA	5220 5220	1997-12-17	Shandwick Public Affairs, Inc.	601 New Hampshire Avenue, N.W.		DC

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