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

16 rows where City = "Washington", 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)

Country/Location_Represented 14

State 1

Registrant_Name 1

City 1

  • Washington · 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
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
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  
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
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])
);