home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for FARA_All_ForeignPrincipals
List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

19 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)

Registrant_Name 18

  • Livingston Group, LLC 2
  • Akbar, Mir H. 1
  • Alexandria Group International LLC 1
  • Alsalih, Mark K. 1
  • Andreae & Associates 1
  • BGR Government Affairs, LLC 1
  • Bitar, Janet M. 1
  • Cleary Gottlieb Steen & Hamilton LLP 1
  • Focus on Advocacy and Advancement of International Relations 1
  • Fulbright & Jaworski, LLP 1
  • ISCI-USA, Inc. 1
  • Iraqi Center for Development 1
  • Maggs & McDermott LLC, Attorneys at Law 1
  • Pillsbury Winthrop Shaw Pittman, LLP 1
  • Prime Policy Group 1
  • Sanitas International, LLC 1
  • Vinson & Elkins LLP 1
  • Zenith Consulting, Inc. 1

Foreign_Principal 18

  • Ministry of Foreign Affairs, Government of the Republic of Iraq 2
  • American University of Iraq- Baghdad 1
  • Dr. Nahro Mohammad Abdulkarim Al- Kasnazan Al-Husseini, Secretary General, Coalition of Iraqi National Unity (CINU) 1
  • For Iraq United 1
  • Government of Iraq 1
  • Government of the Republic of Iraq Office of the Prime Minister 1
  • Iraqi Government 1
  • Iraqi Ministry of Oil 1
  • Iraqi National Accord 1
  • Iraqi Tawafuq Front aka Iraqi Accordance Front 1
  • Iraqiya List 1
  • Islamic Supreme Council of Iraq 1
  • Khamis Khanjar and Sarmad Khanjar 1
  • Ministry of Oil of the Republic of Iraq 1
  • Nahro Mohammad Abdul Karim Al-Kasnazan Al-Husseini, Secretary General, Coalition of Iraqi National Unity (CINU) 1
  • Republic of Iraq 1
  • Sheikh Nawaf al Jarba 1
  • Tajdeed Electoral Slate 1

State 1

  • - 19

Country/Location_Represented 1

  • IRAQ 19

City 1

  • Baghdad · 19 ✖
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
354 354   Iraqi Ministry of Oil 2022-07-19 IRAQ Vinson & Elkins LLP 7142 2022-07-19 Vinson & Elkins LLP 8CRM+8C5, Falastin St.   Baghdad    
473 473   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    
482 482   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    
1864 1864 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    
1883 1883 2013-01-31 Iraqiya List 2012-04-25 IRAQ Sanitas International, LLC 5963 2009-11-18 Sanitas International, LLC     Baghdad    
1923 1923 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    
2561 2561 2013-02-15 Tajdeed Electoral Slate 2010-02-18 IRAQ Alsalih, Mark K. 5974 2010-02-18 Alsalih, Mark K.     Baghdad    
4013 4013 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    
5161 5161 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    
5319 5319 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    
9524 9524 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    
10019 10019 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    
11091 11091 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    
12810 12810 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    
14206 14206 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    
14287 14287 2010-11-29 Sheikh Nawaf al Jarba 2010-12-08 IRAQ Prime Policy Group 6008 2010-12-08 Prime Policy Group     Baghdad    
14705 14705 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    
14819 14819 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    
16681 16681 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])
);
Powered by Datasette · Queries took 161.652ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history