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

13 rows where City = "Riyadh"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Country/Location_Represented 2

State 1

  • - 13

City 1

  • Riyadh · 13 ✖
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
307 307   Government of the Kingdom of Saudi Arabia 2016-11-14 SAUDI ARABIA Aramco Affiliated Services Company (AASC) 6390 2016-11-14 Aramco Affiliated Services Company (AASC)     Riyadh    
400 400   Kingdom of Saudi Arabia Ministry of Communications and Information Technology MCIT") through Informa Saudi Arabia Limited ("Informa")" 2021-10-08 SAUDI ARABIA Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Imam Saud Bin Abdulaziz Bin Mohammed Rd An Nakheel Riyadh    
466 466   Ministry of Energy, Industry, and Mineral Resources of the Kingdom of Saudi Arabia 2018-02-21 SAUDI ARABIA King & Spalding LLP 6501 2017-12-21 King & Spalding LLP     Riyadh    
487 487   Ministry of Media (through Thiqah Business Services Co.) 2022-01-03 SAUDI ARABIA Nicolla Hewitt Communications Corp. 7065 2022-01-03 Nicolla Hewitt Communications Corp. Amr ibn al-Aas Street, P.O. Box 570   Riyadh    
521 521   Neom Company 2021-10-07 INTERNATIONAL Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Information Technology and Communicatin Complex (ITCC) Second Floor, Building IN-01, Al Nakheel District 12382 P.O. Box 10 11411 Riyadh    
620 620   Salman Al-Ansari 2017-08-30 SAUDI ARABIA SAPRAC, Inc. 6457 2017-08-30 SAPRAC, Inc. 13322 Al Yasmin St PO Box 51191 Riyadh    
974 974 2007-01-01 Ministry of Commerce and Industry Kingdom of Saudi Arabia 2006-02-22 SAUDI ARABIA Loeffler Group, LLP 5432 2001-05-18 Loeffler Group, LLP King Abdulaziz Street   Riyadh    
1448 1448 2015-01-23 King Abdullah City for Atomic and Renewable Energy (KACARE) 2011-10-17 SAUDI ARABIA Pillsbury Winthrop Shaw Pittman, LLP 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP P.O. Box 2022 Al Akaria Plaza Square, Entrance 2   Riyadh    
3117 3117 2008-02-29 Ministry of Commerce and Industry, Kingdom of Saudi Arabia (through the Loeffler Group LLP) 2006-03-20 SAUDI ARABIA MPD Consultants, LLC 5540 2003-02-25 MPD Consultants, LLC     Riyadh    
5967 5967 2012-04-30 Saudi Food & Drug Authority Kingdom of Saudi Arabia 2011-10-03 SAUDI ARABIA Dewey & LeBoeuf, LLP 6066 2011-10-03 Dewey & LeBoeuf, LLP 3292 North Highway Al Nafal Unit (1) Riyadh    
8618 8618 2019-06-30 Ministry of Foreign Affairs for the Kingdom of Saudi Arabia through Brownstein Hyatt Farber Schreck, LLP 2017-06-06 SAUDI ARABIA Burke, Martha Ann 6437 2017-06-06 Burke, Martha Ann Nasseriya Street   Riyadh    
12182 12182 2006-10-01 Government of the Kingdom of Saudi Arabia 2005-07-20 SAUDI ARABIA White & Case, LLP 2759 1977-03-09 White & Case, LLP     Riyadh    
16363 16363 2007-12-31 Ministry of Petroleum and Mineral Resources, Kingdom of Saudi Arabia 2008-01-28 SAUDI ARABIA Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Al-Maather Street 6th Floor, Room #609 Riyadh    

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