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

20 rows where Registration_Number = 5430 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 19

  • Embassy of the Republic of Korea 2
  • Ambassador Carlos Vecchio Embassy of the Bolivarian Republic of Venezuela 1
  • Center for Studies and Media Affairs at the Saudi Royal Court 1
  • Embassy of Honduras 1
  • Embassy of Kazakhstan USA 1
  • Embassy of Poland 1
  • Embassy of the Bolivarian Republic of Venezuela 1
  • Embassy of the Kingdom of Bahrain to the United States of America 1
  • Embassy of the Republic of Azerbaijan 1
  • Embassy of the Republic of Bolivia 1
  • Embassy of the Republic of Mexico 1
  • Embassy of the Republic of Serbia 1
  • Embassy of the State of Eritrea 1
  • Embassy of the State of Qatar 1
  • Government of the People's Republic of Bangladesh, Embassy 1
  • Kurdish Regional Government (formerly known as Kurdish Democratic Party) 1
  • National Council of Resistance of Iran-U.S. Representative Office 1
  • Republic of India, Embassy 1
  • State of Qatar, Embassy 1

Country/Location_Represented 17

  • KOREA, SOUTH 2
  • QATAR 2
  • VENEZUELA 2
  • AZERBAIJAN 1
  • BAHRAIN 1
  • BANGLADESH 1
  • BOLIVIA 1
  • ERITREA 1
  • HONDURAS 1
  • INDIA 1
  • IRAN 1
  • IRAQ 1
  • KAZAKHSTAN 1
  • MEXICO 1
  • POLAND 1
  • SAUDI ARABIA 1
  • SERBIA 1

City 2

  • Washington 16
  • - 4

State 1

  • DC · 20 ✖

Registrant_Name 1

  • BGR Government Affairs, LLC 20
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
12 12   Government of the People's Republic of Bangladesh, Embassy 2013-09-23 BANGLADESH BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC 3510 International Drive, NW   Washington DC 20008
193 193   Embassy of the Kingdom of Bahrain to the United States of America 2018-06-12 BAHRAIN BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC 3502 International Drive, NW   Washington DC 20008
200 200   Embassy of the Republic of Azerbaijan 2017-03-20 AZERBAIJAN BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC 2741 34th Street, NW   Washington DC 20008
213 213   Embassy of the Republic of Serbia 2023-07-28 SERBIA BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC 1333 16th Street, NW   Washington DC 20036
226 226   Embassy of the State of Qatar 2021-12-08 QATAR BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC 2555 M Street, NW   Washington DC 20037
414 414   Kurdish Regional Government (formerly known as Kurdish Democratic Party) 2004-06-25 IRAQ BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC 1015 18th Street, N.W. Suite 704   Washington DC 20036
514 514   National Council of Resistance of Iran-U.S. Representative Office 2021-06-28 IRAN BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC 1747 Pennsylvania Avenue, NW Suite 1125 Washington DC 20006
590 590   Republic of India, Embassy 2005-09-12 INDIA BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC 2107 Massachusetts Avenue, NW   Washington DC 20008
5365 5365 2019-04-17 Ambassador Carlos Vecchio Embassy of the Bolivarian Republic of Venezuela 2019-04-17 VENEZUELA BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC     Washington DC  
7230 7230 2010-05-31 Embassy of Poland 2008-05-28 POLAND BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC 2640 16th Street, NW   Washington DC 20009
7255 7255 2015-05-31 State of Qatar, Embassy 2004-12-14 QATAR BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC Embassy of the State of Qatar 4200 Wisconsin Avenue, NW 20016     DC  
7468 7468 2021-06-01 Embassy of the Bolivarian Republic of Venezuela 2019-04-12 VENEZUELA BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC     Washington DC  
8636 8636 2004-06-30 Embassy of Honduras 2002-11-27 HONDURAS BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC 3007 Tilden Street, N.W. Suite 4M 20008     DC  
8656 8656 2006-06-30 Embassy of the State of Eritrea 2006-02-03 ERITREA BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC 1708 New Hampshire Avenue, NW   Washington DC 20009
10114 10114 2018-08-03 Center for Studies and Media Affairs at the Saudi Royal Court 2016-03-15 SAUDI ARABIA BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC 601 New Hampshire Avenue, NW   Washington DC 20037
11077 11077 2002-08-31 Embassy of the Republic of Bolivia 2002-05-02 BOLIVIA BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC 3014 Massachusetts Avenue, N.W.     DC  
16516 16516 2002-12-31 Embassy of the Republic of Mexico 2001-10-02 MEXICO BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC 1911 Pennsylvania Avenue, N.W. 20006     DC  
16783 16783 2016-12-31 Embassy of the Republic of Korea 2015-04-17 KOREA, SOUTH BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC 2450 Massachusetts Avenue, NW   Washington DC 20008
16896 16896 2021-12-31 Embassy of Kazakhstan USA 2020-05-01 KAZAKHSTAN BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC 1401 16th St. NW   Washington DC 20036
16923 16923 2022-12-31 Embassy of the Republic of Korea 2018-06-26 KOREA, SOUTH BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC 2450 Massachusetts 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 127.214ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history