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

36 rows where Country/Location_Represented = "MOROCCO" and State = "DC"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Foreign_Principal_Termination_Date, Address_1, Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)

Registrant_Name >30

  • Daniel J. Edelman, Inc. 2
  • Gray Global Advisors, LLC 2
  • Moffett Group, LLC 2
  • Tew Cardenas, LLP 2
  • Akin, Gump, Strauss, Hauer & Feld, LLP 1
  • Avatar Enterprises, Inc. 1
  • Beckerman 1
  • Blank Rome Government Relations, LLC 1
  • Boland & Madigan, Inc. 1
  • Brownstein Hyatt Farber Schreck, LLP 1
  • Cassidy & Associates, Inc. 1
  • Convention Consultants - Helen Spiess Morgan 1
  • Dutko Worldwide, LLC 1
  • Edelman International Corporation 1
  • Gray Global Strategies, Inc. 1
  • Hill & Knowlton, Inc. 1
  • Holly Strategies Incorporated 1
  • Hurwitz & Abramson 1
  • Husch Blackwell, LLP 1
  • Livingston Group, LLC 1
  • Mayer Brown, LLP 1
  • North American Precis Syndicate 1
  • Nurnberger & Associates, Inc. 1
  • Podesta Group, Inc. 1
  • Powell Tate, Inc. 1
  • Powell, Goldstein, Frazer & Murphy, L.L.P. 1
  • Shami, Saba L. 1
  • Sorini, Samet & Associates, LLC 1
  • Terrab, Mostafa 1
  • ThirdCircle, Inc. 1
  • …

Foreign_Principal 13

  • Moroccan American Center for Policy 9
  • Embassy of Morocco 5
  • Embassy of the Kingdom of Morocco 5
  • Kingdom of Morocco, Embassy 5
  • Government of Morocco 3
  • Government of Morocco, Embassy 2
  • Embassy of Morocco through Brownstein Hatt Farber Schreck, LLP 1
  • Government of Morocco, Embassy (through Private Public Solutions) 1
  • Government of the Kingdom of Morocco, Embassy 1
  • His Excellency M'Hamed Bargach, Embassy of Morocco 1
  • Ministry of Foreign Affairs of the Kingdom of Morocco, Embassy 1
  • Moroccan American Center for Policy through the Amani Group, LLC 1
  • Moroccan American Center for Policy, Inc. 1

City 2

  • Washington 23
  • - 13

State 1

  • DC · 36 ✖

Country/Location_Represented 1

  • MOROCCO · 36 ✖
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
178 178   Embassy of Morocco through Brownstein Hatt Farber Schreck, LLP 2021-12-05 MOROCCO Holly Strategies Incorporated 6605 2018-10-31 Holly Strategies Incorporated 3508 International Drive NW   Washington DC 20008
179 179   Embassy of Morocco 2018-04-13 MOROCCO ThirdCircle, Inc. 6540 2018-04-13 ThirdCircle, Inc. 1601 21st Street, NW   Washington DC 20009
180 180   Embassy of Morocco 2021-12-01 MOROCCO Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 3508 International Drive, NW   Washington DC 20008
195 195   Embassy of the Kingdom of Morocco 2021-11-08 MOROCCO Yorktown Solutions, LLC 6491 2017-11-19 Yorktown Solutions, LLC 3508 International drive NW Washington DC 20008
196 196   Embassy of the Kingdom of Morocco 2021-11-11 MOROCCO Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 3508 International Drive, NW   Washington DC 20008
782 782 1959-01-01 Embassy of Morocco 1957-11-05 MOROCCO Convention Consultants - Helen Spiess Morgan 1080 1957-11-05 Convention Consultants - Helen Spiess Morgan Washington     DC  
1845 1845 2003-01-31 Embassy of Morocco 2002-11-15 MOROCCO Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 1601 21st Street, N.W. 20009     DC  
1878 1878 2009-01-31 Moroccan American Center for Policy 2007-02-01 MOROCCO Tew Cardenas, LLP 5562 2003-06-10 Tew Cardenas, LLP 1101 Vermont Avenue, NW Suite 411 Washington DC 20005
1898 1898 2014-01-31 Moroccan American Center for Policy 2012-07-23 MOROCCO Gray Global Strategies, Inc. 6116 2012-07-23 Gray Global Strategies, Inc. 1221 L Street, NW Suite 411 Washington DC 20005
2083 2083 2019-02-01 Government of the Kingdom of Morocco, Embassy 2014-07-30 MOROCCO Mayer Brown, LLP 6236 2014-07-30 Mayer Brown, LLP 1601 21st, NW   Washington DC 20009
2549 2549 1979-02-15 Government of Morocco 1977-11-18 MOROCCO Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc. Washington     DC  
3009 3009 1996-02-28 Embassy of Morocco 1995-02-16 MOROCCO Hurwitz & Abramson 4995 1995-02-16 Hurwitz & Abramson Washington     DC  
3981 3981 2006-03-22 Ministry of Foreign Affairs of the Kingdom of Morocco, Embassy 2003-12-18 MOROCCO Livingston Group, LLC 5356 2000-01-31 Livingston Group, LLC 1601 21st Street, N.W. 20009     DC  
4723 4723 2012-03-31 Moroccan American Center for Policy 2011-05-19 MOROCCO Dutko Worldwide, LLC 6041 2011-05-19 Dutko Worldwide, LLC 1220 L Street, NW #411 Washington DC 20005
4962 4962 2017-04-01 Embassy of the Kingdom of Morocco 2016-04-01 MOROCCO Sorini, Samet & Associates, LLC 5839 2007-11-12 Sorini, Samet & Associates, LLC 1601 21st Street, NW   Washington DC 20036
6070 6070 2012-04-30 Moroccan American Center for Policy 2010-12-03 MOROCCO Blank Rome Government Relations, LLC 6025 2010-12-03 Blank Rome Government Relations, LLC 1220 L Street, NW Suite 411 Washington DC 20005
6168 6168 1979-05-01 Government of Morocco 1978-10-26 MOROCCO Edelman International Corporation 2548 1974-11-29 Edelman International Corporation Washington     DC  
7240 7240 2012-05-31 Moroccan American Center for Policy 2009-02-27 MOROCCO Gray Global Advisors, LLC 5806 2007-05-07 Gray Global Advisors, LLC 1220 L Street, NW Suite 411 Washington DC 20005
8666 8666 2007-06-30 Government of Morocco, Embassy (through Private Public Solutions) 2007-05-18 MOROCCO Podesta Group, Inc. 5813 2007-05-18 Podesta Group, Inc. 1601 21st Street, NW   Washington DC 20009
8672 8672 2008-06-30 Embassy of the Kingdom of Morocco 2004-11-10 MOROCCO Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 1601 21st Street, N.W. 20009     DC  
8680 8680 2009-06-30 Kingdom of Morocco, Embassy 2007-07-27 MOROCCO Avatar Enterprises, Inc. 5821 2007-07-27 Avatar Enterprises, Inc. Embassy of the Kingdom of Morocco 1601 21st Street, NW Washington DC 20009
8721 8721 2014-06-30 Government of Morocco, Embassy 2007-04-17 MOROCCO Moffett Group, LLC 5802 2007-04-17 Moffett Group, LLC Embassy of the Kingdom of Morocco 1601 21st Street, NW Washington DC 20009
9828 9828 1999-07-31 Government of Morocco, Embassy 1999-01-27 MOROCCO Shami, Saba L. 5297 1999-01-27 Shami, Saba L. Washington     DC  
10008 10008 1990-08-01 His Excellency M'Hamed Bargach, Embassy of Morocco 1987-03-31 MOROCCO Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. Washington     DC  
10058 10058 2018-08-01 Embassy of the Kingdom of Morocco 2016-06-22 MOROCCO Husch Blackwell, LLP 6362 2016-06-22 Husch Blackwell, LLP 1601 21st Street, NW   Washington DC 20009
12170 12170 2006-09-30 Moroccan American Center for Policy 2007-02-16 MOROCCO Tew Cardenas, LLP 5562 2003-06-10 Tew Cardenas, LLP 1101 Vermont Avenue, NW Suite 411 Washington DC 20005
12621 12621 1986-10-12 Government of Morocco 1985-05-24 MOROCCO North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       DC  
13481 13481 2017-10-31 Moroccan American Center for Policy through the Amani Group, LLC 2009-03-06 MOROCCO Nurnberger & Associates, Inc. 5809 2007-05-11 Nurnberger & Associates, Inc. 1220 L Street, NW Suite 411 Washington DC 20005
13482 13482 2017-10-31 Moroccan American Center for Policy 2009-02-19 MOROCCO Vision Americas, LLC 5907 2009-02-19 Vision Americas, LLC 1220 L Street, NW Suite 411 Washington DC 20005
13483 13483 2017-10-31 Moroccan American Center for Policy 2014-02-26 MOROCCO Gray Global Advisors, LLC 5806 2007-05-07 Gray Global Advisors, LLC 1220 L Street, NW Suite 411 Washington DC 20005
14138 14138 2013-11-21 Kingdom of Morocco, Embassy 2013-11-21 MOROCCO Terrab, Mostafa 6198 2013-11-21 Terrab, Mostafa 1601 21st Street, NW   Washington DC 20009
14544 14544 2012-11-30 Moroccan American Center for Policy 2009-12-02 MOROCCO Moffett Group, LLC 5802 2007-04-17 Moffett Group, LLC 1220 L Street, NW Suite 411 Washington DC 20005
14569 14569 2017-11-30 Moroccan American Center for Policy, Inc. 2008-08-14 MOROCCO Beckerman 5877 2008-08-14 Beckerman 1220 L Street, NW Suite 411 Washington DC 20005
15145 15145 1998-12-15 Kingdom of Morocco, Embassy 1998-05-22 MOROCCO Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. Washington     DC  
15146 15146 1998-12-15 Kingdom of Morocco, Embassy 1998-05-26 MOROCCO Boland & Madigan, Inc. 5147 1996-12-30 Boland & Madigan, Inc. 1601 21st Street, N.W.     DC  
16438 16438 1998-12-31 Kingdom of Morocco, Embassy 1998-05-22 MOROCCO Powell Tate, Inc. 5148 1996-12-30 Powell Tate, Inc. 1601 21st Street, N.W.     DC  

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 195.386ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history