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

17 rows where City = "Baghdad"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Foreign_Principal_Termination_Date, Registration_Number, Registrant_Date, Address_1, Address_2, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State 1

  • - 17

Country/Location_Represented 1

City 1

  • Baghdad · 17 ✖
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
46 46   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    
476 476   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    
1837 1837 2008-01-31 Iraqi National Accord 2007-08-20 IRAQ BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC al-Zaytoun Street al-Harthia District Baghdad    
1856 1856 2013-01-31 Iraqiya List 2012-04-25 IRAQ Sanitas International, LLC 5963 2009-11-18 Sanitas International, LLC     Baghdad    
2525 2525 2013-02-15 Tajdeed Electoral Slate 2010-02-18 IRAQ Alsalih, Mark K. 5974 2010-02-18 Alsalih, Mark K.     Baghdad    
3947 3947 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    
5077 5077 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    
5235 5235 2010-04-16 Dr. Nahro Mohammad Abdulkarim Al- Kasnazan Al-Husseini, Secretary General, Coalition of Iraqi National Unity (CINU) 2010-03-04 IRAQ Akbar, Mir H. 5977 2010-03-04 Akbar, Mir H. CINU Abu Nuas Street District 915 Lane 22, Building 282 Baghdad    
9383 9383 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    
9871 9871 2010-08-01 Government of the Republic of Iraq Office of the Prime Minister 2008-01-04 IRAQ Maggs & McDermott LLC, Attorneys at Law 5845 2008-01-04 Maggs & McDermott LLC, Attorneys at Law Office of the Prime Minister Council of Ministers Building International Zone Baghdad    
10927 10927 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    
12609 12609 2010-10-18 Republic of Iraq 2007-12-28 IRAQ Fulbright & Jaworski, LLP 5842 2007-12-28 Fulbright & Jaworski, LLP Ms. Hanan M. Nassef Legal Department, Ministry of Justice Baghdad    
13996 13996 2009-11-24 Nahro Mohammad Abdul Karim Al-Kasnazan Al-Husseini, Secretary General, Coalition of Iraqi National Unity (CINU) 2008-05-02 IRAQ Bitar, Janet M. 5863 2008-05-02 Bitar, Janet M. CINU Al Jadriyah Alou Nuas Street, District 915 Lane 22, Building 282 Baghdad    
14077 14077 2010-11-29 Sheikh Nawaf al Jarba 2010-12-08 IRAQ Prime Policy Group 6008 2010-12-08 Prime Policy Group     Baghdad    
14491 14491 2017-12-01 For Iraq United 2017-09-12 IRAQ Andreae & Associates 6371 2016-08-17 Andreae & Associates 610 Avenue Block 17 Al Yarmuk No. 13 Baghdad    
14603 14603 2019-12-06 Khamis Khanjar and Sarmad Khanjar 2019-06-10 IRAQ Pillsbury Winthrop Shaw Pittman, LLP 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Al Radwan Company Mishmisheh Building 14 Ramadan Street, Mansur District Baghdad    
16452 16452 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

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])
);