FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where "Registrant_Date" is on date 2001-05-30 sorted by Foreign_Principal_Termination_Date
This data as json, CSV (advanced)
Suggested facets: Address_2, Foreign_Principal_Termination_Date (date)
Address_1 12 ✖
- 1101 30th Street, N.W., Suite 302 1
- 1607 23rd Street, N.W. 20008 1
- 1615 New Hampshire Avenue, N.W. #300 1
- 2129 Wyoming Avenue, NW 1
- 2520 Massachusetts Avenue, NW 1
- 2833 M Street, NW 1
- 4201 Wisconsin Avenue, NW 20016 1
- Embassy of the Republic of Latvia 4325 17th Street, N.W. 20011 1
- Ingorokva St. 7 Tbilisi, 0134 1
- Ministry of Foreign Affairs Podgorica 1
- National Security Council of Georgia 1
- St. 45A 1
Foreign_Principal 10
- Government of Georgia, National Security Council 2
- Government of the Republic of Macedonia, Embassy 2
- Embassy of Mongolia 1
- Government of Georgia, Embassy 1
- Government of Romania, Embassy 1
- Ministry of Foreign Affairs of Japan, Embassy 1
- Ministry of Foreign Affairs of the Republic of Latvia, Embassy 1
- Republic of Montenegro 1
- Taipei Economic and Cultural Representative Office (TECRO) 1
- United National Movement of Georgia 1
Country/Location_Represented 8
City 2
- - 9
- Washington 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6578 | 6578 | 2003-05-15 | Ministry of Foreign Affairs of the Republic of Latvia, Embassy | 2001-05-30 | LATVIA | Orion Strategies LLC 5437 | 2001-05-30 | Orion Strategies LLC | Embassy of the Republic of Latvia 4325 17th Street, N.W. 20011 | DC | |||
16554 | 16554 | 2004-12-31 | Government of Romania, Embassy | 2002-01-30 | ROMANIA | Orion Strategies LLC 5437 | 2001-05-30 | Orion Strategies LLC | 1607 23rd Street, N.W. 20008 | DC | |||
1468 | 1468 | 2007-01-22 | Government of the Republic of Macedonia, Embassy | 2003-02-11 | MACEDONIA | Orion Strategies LLC 5437 | 2001-05-30 | Orion Strategies LLC | 1101 30th Street, N.W., Suite 302 | DC | |||
7217 | 7217 | 2008-05-31 | Government of Georgia, Embassy | 2004-04-06 | GEORGIA | Orion Strategies LLC 5437 | 2001-05-30 | Orion Strategies LLC | 1615 New Hampshire Avenue, N.W. #300 | DC | |||
16634 | 16634 | 2008-12-31 | Government of Georgia, National Security Council | 2008-06-11 | GEORGIA | Orion Strategies LLC 5437 | 2001-05-30 | Orion Strategies LLC | Ingorokva St. 7 Tbilisi, 0134 | ||||
7223 | 7223 | 2009-05-31 | Government of the Republic of Macedonia, Embassy | 2008-01-04 | MACEDONIA | Orion Strategies LLC 5437 | 2001-05-30 | Orion Strategies LLC | 2129 Wyoming Avenue, NW | Washington | DC | ||
16709 | 16709 | 2012-12-31 | Government of Georgia, National Security Council | 2009-12-09 | GEORGIA | Orion Strategies LLC 5437 | 2001-05-30 | Orion Strategies LLC | National Security Council of Georgia | Ingorokva St. 7 Tbilisi, 0134 | |||
4747 | 4747 | 2014-03-31 | Taipei Economic and Cultural Representative Office (TECRO) | 2005-04-14 | TAIWAN | Orion Strategies LLC 5437 | 2001-05-30 | Orion Strategies LLC | 4201 Wisconsin Avenue, NW 20016 | DC | |||
15272 | 15272 | 2014-12-20 | Embassy of Mongolia | 2014-09-17 | MONGOLIA | Orion Strategies LLC 5437 | 2001-05-30 | Orion Strategies LLC | 2833 M Street, NW | Washington | DC | 20007 | |
16771 | 16771 | 2015-12-31 | Republic of Montenegro | 2009-11-13 | MONTENEGRO | Orion Strategies LLC 5437 | 2001-05-30 | Orion Strategies LLC | Ministry of Foreign Affairs Podgorica | ||||
4242 | 4242 | 2020-03-30 | Ministry of Foreign Affairs of Japan, Embassy | 2014-11-10 | JAPAN | Orion Strategies LLC 5437 | 2001-05-30 | Orion Strategies LLC | 2520 Massachusetts Avenue, NW | Washington | DC | ||
12537 | 12537 | 2020-10-07 | United National Movement of Georgia | 2019-10-25 | GEORGIA | Orion Strategies LLC 5437 | 2001-05-30 | Orion Strategies LLC | St. 45A | Kakheti, Highway, Tbilisi |
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]) );