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

21 rows where Country/Location_Represented = "SYRIA"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

City 6

State 3

Country/Location_Represented 1

  • SYRIA · 21 ✖
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
664 664   Syrian Democratic Council 2018-01-31 SYRIA U.S. Mission of the Syrian Democratic Council 6516 2018-01-31 U.S. Mission of the Syrian Democratic Council Democratic Federation of Northern Syria, Adderbeseyeh Hassakah      
732 732   U.S. Mission of the Syrian Democratic Council 2020-07-26 SYRIA AF International, LLC 6639 2019-02-18 AF International, LLC 800 Maine Avenue, SW, Suite 200 Washington DC    
3978 3978 1994-03-22 Syrian Arab Republic 1963-04-01 SYRIA Arab Information Center 876 1955-03-03 Arab Information Center Damascus, Syria        
4476 4476 1990-03-31 Central Bank of Syria 1987-09-29 SYRIA Bankers Capital Management, Inc. 4044 1987-09-29 Bankers Capital Management, Inc. Damascus        
4479 4479 1990-03-31 Commercial Bank of Syria 1987-09-29 SYRIA Bankers Capital Management, Inc. 4044 1987-09-29 Bankers Capital Management, Inc. Damascus        
4493 4493 1990-03-31 Syrian Arab Republic 1987-09-29 SYRIA Bankers Capital Management, Inc. 4044 1987-09-29 Bankers Capital Management, Inc. Damascus        
5108 5108 2013-04-08 National Coalition of Syrian Revolution and Opposition Forces 2013-04-08 SYRIA U.S. Office of the National Coalition of Syrian Revolution and Opposition Forces 6164 2013-04-08 U.S. Office of the National Coalition of Syrian Revolution and Opposition Forces Fifth Compound 90th Street Villa 306 Cairo    
6065 6065 2011-04-30 Presidency of the Syrian Arab Republic 2011-07-29 SYRIA BLJ Worldwide LTD 5875 2008-06-17 BLJ Worldwide LTD Office of the FIrst Lady of the Syrian Arab Republic   Damascus    
9290 9290 2022-07-15 National Coalition of Syrian Revolutionary and Opposition Forces 2020-09-28 SYRIA Idlbi, Qutaiba 6870 2020-09-28 Idlbi, Qutaiba Senlikkoy mahallesi, Konakli sokak, no 50, Florya Bakirkoy, Istanbul 34140      
9576 9576 2022-07-28 Tribal Council of Palmyra and Badia 2021-01-20 SYRIA Diab, Mahmoud 6910 2021-01-20 Diab, Mahmoud Rukban Internally Displaced Camp, Area 55        
9897 9897 2013-07-31 People of Syria 2012-02-28 SYRIA National Change Party 6092 2012-02-28 National Change Party          
9917 9917 2018-07-31 Asfari, Ayman 2018-02-05 SYRIA LB International Solutions, LLC 6210 2014-03-03 LB International Solutions, LLC     London    
11639 11639 1989-09-15 Embassy of the Syrian Arab Republic 1989-05-10 SYRIA van Kloberg & Associates, Ltd. 3466 1983-05-09 van Kloberg & Associates, Ltd. Washington     DC  
12640 12640 2019-10-12 High Negotiations Committee of the Syrian Opposition (HNC) 2017-02-22 SYRIA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP HNC Headquarters, Riyadh        
12815 12815 1960-10-18 Syrian Broadcasting System 1957-10-18 SYRIA Hagan, Mary Frances 1073 1957-10-18 Hagan, Mary Frances Damascus        
13076 13076 1988-10-27 Permanent Mission of the Syrian Arab Republic to the U.N. 1979-05-24 SYRIA Perry, Marilyn Edith 2731 1976-10-27 Perry, Marilyn Edith New York     NY  
14857 14857 1946-12-07 Nihmeh Thabet 1943-04-23 SYRIA Syrian National Party in the U.S. 32 1942-07-24 Syrian National Party in the U.S. Beer Hasan        
14858 14858 1946-12-07 Syrian National Party 1942-07-24 SYRIA Syrian National Party in the U.S. 32 1942-07-24 Syrian National Party in the U.S.          
15714 15714 1973-12-31 Republic of Syria 1955-03-03 SYRIA Arab Information Center 876 1955-03-03 Arab Information Center Damascus        
16840 16840 2018-12-31 US Office of the National Coalition of Syrian Revolution and Opposition Forces 2013-04-08 SYRIA Independent Diplomat, Inc. 5860 2008-04-03 Independent Diplomat, Inc. 1101 Pennsylvania Avenue, NW Suite 6620 Washington DC 20004
16908 16908 2021-12-31 Kurdish Defense Forces YPG/SDF 2021-04-29 SYRIA Dornan, James E. III 6951 2021-04-29 Dornan, James E. III Al-Nashwa Neighborhood, Central Prison Street - next to Al-Baladi Stadium A1 Hasakah      

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