FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
20 rows where Country/Location_Represented = "YEMEN" sorted by Address_2
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Registration_Number, Registrant_Date, Address_1, Address_2, Zip, Foreign_Principal_Termination_Date (date), Registrant_Date (date)
Foreign_Principal_Registration_Date (date) 20 ✖
- 1955-03-03 1
- 1964-01-23 1
- 1979-05-31 1
- 1989-12-06 1
- 1990-02-08 1
- 1992-04-22 1
- 2001-02-22 1
- 2010-03-25 1
- 2010-11-29 1
- 2011-08-04 1
- 2012-06-21 1
- 2018-01-19 1
- 2018-05-08 1
- 2019-02-27 1
- 2019-11-15 1
- 2021-08-03 1
- 2021-08-21 1
- 2021-09-30 1
- 2022-02-09 1
- 2023-05-05 1
Registrant_Name 18
- QORVIS LLC 3
- Ahmed, Summer 1
- Arab Information Center 1
- Atef, Ahmed Ali 1
- Baker Botts L.L.P. 1
- DLA Piper US LLP 1
- Grassroots Political Consulting LLC 1
- Hill and Knowlton Strategies, LLC 1
- Hyperfocal Communications, LLC 1
- Independent Diplomat, Inc. 1
- Patton, Blow, Verrill, Brand & Boggs 1
- Perry, Marilyn Edith 1
- Southern Transitional Council (US), Ltd. 1
- Squire Patton Boggs, LLP 1
- Sulaiman, Alkhadher Nasr 1
- Swayne, Daniel L. 1
- Tully Rinckey, PLLC 1
- Wagner, Hines & Avary, Inc. 1
Foreign_Principal 15
- Southern Transitional Council (STC) 4
- Ministry of Foreign Affairs of the Republic of Yemen 2
- Southern Transitional Council 2
- Al-Ahmar Trading Group 1
- Alliance of Yemeni Opposition Groups 1
- Bell Pottinger Sans Frontieres on behalf of Yemen 1
- Embassy of the Republic of Yemen 1
- Government of the Yemen Arab Republic 1
- Government of the Yemen Arab Republic, Yemen Mission to the United Nations 1
- Mutawakilite Kingdom of Yemen 1
- Permanent Mission of the Yemen Arab Republic to the U.N. 1
- Republic of Yemen 1
- Republic of Yemen Air Force 1
- Republic of Yemen through Bell Pottinger Middle East 1
- Southern Traditional Council 1
Country/Location_Represented 1
- YEMEN · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
214 | 214 | Embassy of the Republic of Yemen | 2019-02-27 | YEMEN | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 2319 Wyoming Avenue, NW | Washington | DC | 20008 | ||
646 | 646 | Southern Transitional Council (STC) | 2019-11-15 | YEMEN | Independent Diplomat, Inc. 5860 | 2008-04-03 | Independent Diplomat, Inc. | Aden | |||||
1368 | 1368 | 1964-01-16 | Government of the Yemen Arab Republic, Yemen Mission to the United Nations | 1964-01-23 | YEMEN | Patton, Blow, Verrill, Brand & Boggs 1636 | 1963-06-06 | Patton, Blow, Verrill, Brand & Boggs | Sana | ||||
1838 | 1838 | 2002-01-31 | Ministry of Foreign Affairs of the Republic of Yemen | 2001-02-22 | YEMEN | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | Sana'a | ||||
4047 | 4047 | 2010-03-25 | Republic of Yemen Air Force | 2010-03-25 | YEMEN | Swayne, Daniel L. 5983 | 2010-03-25 | Swayne, Daniel L. | 1 Airport Road | Sana'a | |||
8115 | 8115 | 2013-06-26 | Al-Ahmar Trading Group | 2012-06-21 | YEMEN | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Sabafon Blue Building Zubairi Street P.O. Box 18550 Sana'ss | ||||
9417 | 9417 | 2000-07-21 | Ministry of Foreign Affairs of the Republic of Yemen | 1992-04-22 | YEMEN | Baker Botts L.L.P. 4293 | 1989-09-15 | Baker Botts L.L.P. | Sana'a | ||||
9766 | 9766 | 1990-07-31 | Alliance of Yemeni Opposition Groups | 1990-02-08 | YEMEN | Wagner, Hines & Avary, Inc. 3845 | 1986-06-18 | Wagner, Hines & Avary, Inc. | Washington | DC | |||
10234 | 10234 | 1990-08-09 | Government of the Yemen Arab Republic | 1989-12-06 | YEMEN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Sanaa | ||||
12284 | 12284 | 2022-09-30 | Republic of Yemen | 2021-09-30 | YEMEN | Tully Rinckey, PLLC 7020 | 2021-09-30 | Tully Rinckey, PLLC | 2319 Wyoming Avenue, NW | Washington | DC | 20008 | |
13077 | 13077 | 1988-10-27 | Permanent Mission of the Yemen Arab Republic to the U.N. | 1979-05-31 | YEMEN | Perry, Marilyn Edith 2731 | 1976-10-27 | Perry, Marilyn Edith | New York | NY | |||
15710 | 15710 | 1973-12-31 | Mutawakilite Kingdom of Yemen | 1955-03-03 | YEMEN | Arab Information Center 876 | 1955-03-03 | Arab Information Center | San'aa | ||||
3151 | 3151 | 2022-02-28 | Southern Transitional Council | 2021-08-21 | YEMEN | Sulaiman, Alkhadher Nasr 6998 | 2021-08-21 | Sulaiman, Alkhadher Nasr | Tawahi Crater | Aden | |||
14579 | 14579 | 2018-11-30 | Southern Transitional Council (STC) | 2018-01-19 | YEMEN | Grassroots Political Consulting LLC 6483 | 2017-11-01 | Grassroots Political Consulting LLC | 1 Gold Mohur Beach, Al-Tauahi | Aden | |||
644 | 644 | Southern Traditional Council | 2021-08-03 | YEMEN | Ahmed, Summer 6983 | 2021-08-03 | Ahmed, Summer | 1 Gold Mohur Beach, Al-Tawahi | Aden, South Yemen | ||||
2302 | 2302 | 2022-02-08 | Southern Transitional Council (STC) | 2018-05-08 | YEMEN | Southern Transitional Council (US), Ltd. 6552 | 2018-05-08 | Southern Transitional Council (US), Ltd. | 1 Gold Mohur Beach, Al-Tawahi | Aden, South Yemen | |||
647 | 647 | Southern Transitional Council | 2023-05-05 | YEMEN | Hyperfocal Communications, LLC 7267 | 2023-05-05 | Hyperfocal Communications, LLC | 1 Gold Mohr Beach | Al-Tawahi | Aden | |||
645 | 645 | Southern Transitional Council (STC) | 2022-02-09 | YEMEN | Atef, Ahmed Ali 7078 | 2022-02-09 | Atef, Ahmed Ali | STC Headquarters, 1Gold Mohr Beach | Al-Tawahi, Aden, South Yemen | ||||
14536 | 14536 | 2010-11-30 | Republic of Yemen through Bell Pottinger Middle East | 2010-11-29 | YEMEN | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 11th Floor, East Tower | Bahrain Financial Harbour | Manama | ||
12411 | 12411 | 2011-10-01 | Bell Pottinger Sans Frontieres on behalf of Yemen | 2011-08-04 | YEMEN | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 14 Curzon Street | London W1J 5HN |
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]) );