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

15 rows where City = "Baghdad"

✎ View and edit SQL

This data as json, atom, CSV (advanced)

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

State

  • 15

Country/Location_Represented

City

  • Baghdad · 15 ✖
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
376 376   Khamis Khanjar and Sarmad Khanjar 2019-06-10 IRAQ 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Al Radwan Company Mishmisheh Building 14 Ramadan Street, Mansur District Baghdad    
467 467   Ministry of Foreign Affairs, Government of the Republic of Iraq 2017-12-12 IRAQ 6344 6344 2016-03-25 Livingston Group, LLC     Baghdad    
1774 1774 2008-01-31 Iraqi National Accord 2007-08-20 IRAQ 5430 5430 2001-05-10 BGR Government Affairs, LLC al-Zaytoun Street al-Harthia District Baghdad    
1793 1793 2013-01-31 Iraqiya List 2012-04-25 IRAQ 5963 5963 2009-11-18 Sanitas International, LLC     Baghdad    
2430 2430 2013-02-15 Tajdeed Electoral Slate 2010-02-18 IRAQ 5974 5974 2010-02-18 Alsalih, Mark K.     Baghdad    
4880 4880 2007-04-11 Iraqi Government 2006-09-19 IRAQ 5768 5768 2006-09-19 Focus on Advocacy and Advancement of International Relations     Baghdad    
5037 5037 2010-04-16 Dr. Nahro Mohammad Abdulkarim Al- Kasnazan Al-Husseini, Secretary General, Coalition of Iraqi National Unity (CINU) 2010-03-04 IRAQ 5977 5977 2010-03-04 Akbar, Mir H. CINU Abu Nuas Street District 915 Lane 22, Building 282 Baghdad    
9077 9077 2012-07-27 Government of Iraq 2012-01-06 IRAQ 6084 6084 2012-01-06 Iraqi Center for Development International Zone Prime Minister's Offcie   Baghdad    
9549 9549 2010-08-01 Government of the Republic of Iraq Office of the Prime Minister 2008-01-04 IRAQ 5845 5845 2008-01-04 Maggs & McDermott LLC, Attorneys at Law Office of the Prime Minister Council of Ministers Building International Zone Baghdad    
10588 10588 2007-08-31 Iraqi Tawafuq Front aka Iraqi Accordance Front 2007-02-05 IRAQ 5792 5792 2007-02-05 Zenith Consulting, Inc. Yarmouk District   Baghdad    
12193 12193 2010-10-18 Republic of Iraq 2007-12-28 IRAQ 5842 5842 2007-12-28 Fulbright & Jaworski, LLP Ms. Hanan M. Nassef Legal Department, Ministry of Justice Baghdad    
13536 13536 2009-11-24 Nahro Mohammad Abdul Karim Al-Kasnazan Al-Husseini, Secretary General, Coalition of Iraqi National Unity (CINU) 2008-05-02 IRAQ 5863 5863 2008-05-02 Bitar, Janet M. CINU Al Jadriyah Alou Nuas Street, District 915 Lane 22, Building 282 Baghdad    
13616 13616 2010-11-29 Sheikh Nawaf al Jarba 2010-12-08 IRAQ 6008 6008 2010-12-08 Prime Policy Group     Baghdad    
14013 14013 2017-12-01 For Iraq United 2017-09-12 IRAQ 6371 6371 2016-08-17 Andreae & Associates 610 Avenue Block 17 Al Yarmuk No. 13 Baghdad    
15950 15950 2012-12-31 Islamic Supreme Council of Iraq 2008-10-06 IRAQ 5885 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 · Query took 144.964ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history