home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for 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

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

Foreign_Principal 15

  • Government of the Kingdom of Saudi Arabia 2
  • King Abdullah City for Atomic and Renewable Energy (KACARE) 1
  • Kingdom of Saudi Arabia Ministry of Communications and Information Technology MCIT") through Informa Saudi Arabia Limited ("Informa")" 1
  • Ministry of Commerce and Industry Kingdom of Saudi Arabia 1
  • Ministry of Commerce and Industry, Kingdom of Saudi Arabia (through the Loeffler Group LLP) 1
  • Ministry of Culture - KSA 1
  • Ministry of Energy, Industry, and Mineral Resources of the Kingdom of Saudi Arabia 1
  • Ministry of Foreign Affairs for the Kingdom of Saudi Arabia through Brownstein Hyatt Farber Schreck, LLP 1
  • Ministry of Industry and Mineral Resources - KSA 1
  • Ministry of Media (through Thiqah Business Services Co.) 1
  • Ministry of Petroleum and Mineral Resources, Kingdom of Saudi Arabia 1
  • Neom Company 1
  • Salman Al-Ansari 1
  • Saudi Food & Drug Authority Kingdom of Saudi Arabia 1
  • The Royal Commission for AlUlA 1

Registrant_Name 14

  • Daniel J. Edelman, Inc. 2
  • Hill and Knowlton Strategies, LLC 2
  • APCO Worldwide LLC 1
  • Aramco Affiliated Services Company (AASC) 1
  • Burke, Martha Ann 1
  • Dewey & LeBoeuf, LLP 1
  • King & Spalding LLP 1
  • Loeffler Group, LLP 1
  • MMGY Global, LLC 1
  • MPD Consultants, LLC 1
  • Nicolla Hewitt Communications Corp. 1
  • Pillsbury Winthrop Shaw Pittman, LLP 1
  • SAPRAC, Inc. 1
  • White & Case, LLP 1

Country/Location_Represented 2

  • SAUDI ARABIA 15
  • INTERNATIONAL 1

State 1

  • - 16

City 1

  • Riyadh · 16 ✖
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
295 295   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    
445 445   Ministry of Culture - KSA 2022-06-09 SAUDI ARABIA Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. King Faisal Road, Al-Bujairi, Al-Diriyah   Riyadh    
451 451   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    
467 467   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    
505 505   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    
677 677   The Royal Commission for AlUlA 2023-02-16 SAUDI ARABIA MMGY Global, LLC 6492 2017-11-27 MMGY Global, LLC 7747 Amr Aldamri Street, Al Safarat, Unit No 1   Riyadh    
970 970 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    
1452 1452 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    
3137 3137 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    
6012 6012 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    
7409 7409 2022-06-01 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    
8696 8696 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    
10208 10208 2022-08-11 Salman Al-Ansari 2017-08-30 SAUDI ARABIA SAPRAC, Inc. 6457 2017-08-30 SAPRAC, Inc. 13322 Al Yasmin St PO Box 51191 Riyadh    
12320 12320 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    
12458 12458 2022-10-07 Ministry of Industry and Mineral Resources - KSA 2022-09-16 SAUDI ARABIA APCO Worldwide LLC 6582 2018-08-22 APCO Worldwide LLC Conference Boulevard, King Abdullah Financial District, 32nd Floor   Riyadh    
16534 16534 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])
);
Powered by Datasette · Queries took 145.343ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history