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

21 rows where Registrant_Name = "Akin, Gump, Strauss, Hauer & Feld, LLP" 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_Date (date)

Foreign_Principal 20

  • Embassy of the Republic of Korea 2
  • Adela Raz, Safiullah Delawar, and Adbul Hadi Nejrabi 1
  • American Produce Association, Inc. 1
  • Embassy of Japan 1
  • Embassy of Panama 1
  • Embassy of the Kingdom of Cambodia 1
  • Embassy of the Kingdom of Morocco 1
  • Embassy of the United Arab Emirates 1
  • Government of British Columbia 1
  • Government of Norway 1
  • Government of the Republic of the Marshall Islands 1
  • Hong Kong Trade Development Council 1
  • Mazda (North America), Inc. 1
  • Ministry of Foreign Affairs, Embassy 1
  • Office of Commercial Affairs of the Royal Thai Embassy 1
  • Office of Commercial Affairs, Royal Thai Embassy 1
  • Republic of Chile 1
  • Republic of Colombia (Embassy) 1
  • Republic of India, Embassy 1
  • Republic of Korea, Embassy 1

Country/Location_Represented 16

  • JAPAN 3
  • KOREA, SOUTH 3
  • THAILAND 2
  • AFGHANISTAN 1
  • CAMBODIA 1
  • CANADA 1
  • CHILE 1
  • COLOMBIA 1
  • HONG KONG 1
  • INDIA 1
  • INTERNATIONAL 1
  • MARSHALL ISLANDS 1
  • MOROCCO 1
  • NORWAY 1
  • PANAMA 1
  • UNITED ARAB EMIRATES 1

City 2

  • Washington 13
  • - 8

State 1

  • DC · 21 ✖

Registrant_Name 1

  • Akin, Gump, Strauss, Hauer & Feld, LLP · 21 ✖
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
161 161   Embassy of Japan 2011-03-02 JAPAN Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2520 Massachusetts Avenue, NW   Washington DC 20008
194 194   Embassy of the Kingdom of Cambodia 2022-01-21 CAMBODIA Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 4530 16th Street, NW   Washington DC 20011
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
232 232   Embassy of the United Arab Emirates 2007-09-10 UNITED ARAB EMIRATES Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 3522 International Court, NW Suite 400 Washington DC 20008
313 313   Government of the Republic of the Marshall Islands 2017-09-06 MARSHALL ISLANDS Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2433 Massachusetts Avenue, NW   Washington DC 20008
332 332   Hong Kong Trade Development Council 2022-03-31 HONG KONG Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 1520 18th Street, NW   Washington DC 20036
4749 4749 2015-03-31 Ministry of Foreign Affairs, Embassy 2014-05-16 JAPAN Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2520 Massachusetts Avenue, NW   Washington DC 20008
8078 8078 1996-06-24 Mazda (North America), Inc. 1991-09-24 JAPAN Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP Washington     DC  
8751 8751 2018-06-30 Office of Commercial Affairs, Royal Thai Embassy 2018-07-18 THAILAND Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 1024 Wisconsin Avenue, NW   Washington DC 20007
11052 11052 1997-08-31 Republic of Korea, Embassy 1997-03-14 KOREA, SOUTH Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP Washington     DC  
12158 12158 2004-09-30 Republic of India, Embassy 2003-03-21 INDIA Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2107 Massachusetts Avenue, N.W.     DC  
14722 14722 2009-12-01 Embassy of Panama 2007-05-01 PANAMA Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2862 McGill Terrace, NW   Washington DC 20008
15367 15367 1988-12-24 American Produce Association, Inc. 1987-11-06 INTERNATIONAL Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP Washington     DC  
15374 15374 1994-12-24 Republic of Chile 1992-02-21 CHILE Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP Washington     DC  
15376 15376 1996-12-24 Government of Norway 1992-08-14 NORWAY Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP Washington     DC  
15380 15380 2003-12-24 Republic of Colombia (Embassy) 1999-02-08 COLOMBIA Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2118 Leroy Place, N.W.     DC  
16631 16631 2008-12-31 Embassy of the Republic of Korea 2007-06-18 KOREA, SOUTH Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2450 Massachusetts Avenue, NW   Washington DC 20008
16685 16685 2010-12-31 Office of Commercial Affairs of the Royal Thai Embassy 2010-03-31 THAILAND Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 1024 Wisconsin Avenue, NW   Washington DC 20007
16801 16801 2017-12-31 Embassy of the Republic of Korea 2010-05-25 KOREA, SOUTH Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2450 Massachusetts Avenue, NW   Washington DC 20008
16804 16804 2017-12-31 Government of British Columbia 1998-01-15 CANADA Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2118 Leroy Place, N.W.     DC  
16917 16917 2022-12-31 Adela Raz, Safiullah Delawar, and Adbul Hadi Nejrabi 2021-11-02 AFGHANISTAN Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP c/o Consulate of Afghanistan 2341 Wyoming Avenue, NW Washington DC 20008

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