FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where Address_2 = "" and City = "Baghdad"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Registration_Number, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Registrant_Name 11
- Livingston Group, LLC 2
- Alexandria Group International LLC 1
- Alsalih, Mark K. 1
- Cleary Gottlieb Steen & Hamilton LLP 1
- Focus on Advocacy and Advancement of International Relations 1
- ISCI-USA, Inc. 1
- Iraqi Center for Development 1
- Prime Policy Group 1
- Sanitas International, LLC 1
- Vinson & Elkins LLP 1
- Zenith Consulting, Inc. 1
Registrant_Date (date) 11 ✖
- 2016-03-25 2
- 2006-09-19 1
- 2007-02-05 1
- 2008-10-06 1
- 2009-11-18 1
- 2010-02-18 1
- 2010-12-08 1
- 2012-01-06 1
- 2019-08-15 1
- 2021-05-25 1
- 2022-07-19 1
Foreign_Principal 11
- Ministry of Foreign Affairs, Government of the Republic of Iraq 2
- American University of Iraq- Baghdad 1
- Government of Iraq 1
- Iraqi Government 1
- Iraqi Ministry of Oil 1
- Iraqi Tawafuq Front aka Iraqi Accordance Front 1
- Iraqiya List 1
- Islamic Supreme Council of Iraq 1
- Ministry of Oil of the Republic of Iraq 1
- Sheikh Nawaf al Jarba 1
- Tajdeed Electoral Slate 1
Address_1 7 ✖
State 1
- - 12
Country/Location_Represented 1
- IRAQ 12
City 1
- Baghdad · 12 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
356 | 356 | Iraqi Ministry of Oil | 2022-07-19 | IRAQ | Vinson & Elkins LLP 7142 | 2022-07-19 | Vinson & Elkins LLP | 8CRM+8C5, Falastin St. | Baghdad | ||||
477 | 477 | Ministry of Foreign Affairs, Government of the Republic of Iraq | 2021-12-30 | IRAQ | Livingston Group, LLC 6344 | 2016-03-25 | Livingston Group, LLC | Baghdad | |||||
1893 | 1893 | 2013-01-31 | Iraqiya List | 2012-04-25 | IRAQ | Sanitas International, LLC 5963 | 2009-11-18 | Sanitas International, LLC | Baghdad | ||||
1933 | 1933 | 2022-01-31 | American University of Iraq- Baghdad | 2021-01-02 | IRAQ | Alexandria Group International LLC 6707 | 2019-08-15 | Alexandria Group International LLC | Baghdad Airport Road | Baghdad | |||
2571 | 2571 | 2013-02-15 | Tajdeed Electoral Slate | 2010-02-18 | IRAQ | Alsalih, Mark K. 5974 | 2010-02-18 | Alsalih, Mark K. | Baghdad | ||||
4024 | 4024 | 2021-03-24 | Ministry of Foreign Affairs, Government of the Republic of Iraq | 2017-12-12 | IRAQ | Livingston Group, LLC 6344 | 2016-03-25 | Livingston Group, LLC | Baghdad | ||||
5176 | 5176 | 2007-04-11 | Iraqi Government | 2006-09-19 | IRAQ | Focus on Advocacy and Advancement of International Relations 5768 | 2006-09-19 | Focus on Advocacy and Advancement of International Relations | Baghdad | ||||
7301 | 7301 | 2023-05-31 | Ministry of Oil of the Republic of Iraq | 2022-06-03 | IRAQ | Cleary Gottlieb Steen & Hamilton LLP 6964 | 2021-05-25 | Cleary Gottlieb Steen & Hamilton LLP | Oil Complex Building Port Saeed Street | Baghdad | |||
9551 | 9551 | 2012-07-27 | Government of Iraq | 2012-01-06 | IRAQ | Iraqi Center for Development 6084 | 2012-01-06 | Iraqi Center for Development | International Zone Prime Minister's Offcie | Baghdad | |||
11118 | 11118 | 2007-08-31 | Iraqi Tawafuq Front aka Iraqi Accordance Front | 2007-02-05 | IRAQ | Zenith Consulting, Inc. 5792 | 2007-02-05 | Zenith Consulting, Inc. | Yarmouk District | Baghdad | |||
14315 | 14315 | 2010-11-29 | Sheikh Nawaf al Jarba | 2010-12-08 | IRAQ | Prime Policy Group 6008 | 2010-12-08 | Prime Policy Group | Baghdad | ||||
16711 | 16711 | 2012-12-31 | Islamic Supreme Council of Iraq | 2008-10-06 | IRAQ | ISCI-USA, Inc. 5885 | 2008-10-06 | ISCI-USA, Inc. | Street #55, House #24, Alkarada Alshariquieah, Babylon District | Baghdad |
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]) );