FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
20 rows where "Registrant_Date" is on date 2001-05-10 and State = "DC" sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_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
Address_1 18 ✖
- - 2
- 2450 Massachusetts Avenue, NW 2
- 1015 18th Street, N.W. Suite 704 1
- 1333 16th Street, NW 1
- 1401 16th St. NW 1
- 1708 New Hampshire Avenue, NW 1
- 1747 Pennsylvania Avenue, NW 1
- 1911 Pennsylvania Avenue, N.W. 20006 1
- 2107 Massachusetts Avenue, NW 1
- 2555 M Street, NW 1
- 2640 16th Street, NW 1
- 2741 34th Street, NW 1
- 3007 Tilden Street, N.W. Suite 4M 20008 1
- 3014 Massachusetts Avenue, N.W. 1
- 3502 International Drive, NW 1
- 3510 International Drive, NW 1
- 601 New Hampshire Avenue, NW 1
- Embassy of the State of Qatar 4200 Wisconsin Avenue, NW 20016 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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |||
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 | |||
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 | |
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 | |
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 | |||
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 | |||
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 | |||
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 | |
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 | |||
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 | ||
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 | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );