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

8 rows where Foreign_Principal = "Embassy of the Republic of Turkey" and State = "DC"

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Address_1, Zip, Registrant_Date (date)

City 2

State 1

Foreign_Principal 1

  • Embassy of the Republic of Turkey · 8 ✖

Country/Location_Represented 1

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
4015 4015 1994-03-24 Embassy of the Republic of Turkey 1990-01-18 TURKEY Thompson & Company 4094 1988-02-25 Thompson & Company Washington     DC  
6526 6526 1981-05-14 Embassy of the Republic of Turkey 1980-08-08 TURKEY International Government Consultants, Inc. 3137 1980-08-08 International Government Consultants, Inc. Washington     DC  
7250 7250 2015-05-31 Embassy of the Republic of Turkey 2014-05-23 TURKEY Alpaytac, Inc. 6224 2014-05-23 Alpaytac, Inc. 2525 Massachusetts Avenue, NW   Washington DC 20006
9874 9874 2007-07-31 Embassy of the Republic of Turkey 2002-12-20 TURKEY Harbour Group, LLC 5478 2002-03-04 Harbour Group, LLC 2525 Massachusetts Avenue, N.W. 20008     DC  
11283 11283 1994-09-01 Embassy of the Republic of Turkey 1990-01-18 TURKEY Washington Group 4332 1990-01-18 Washington Group Washington     DC  
12965 12965 2020-10-23 Embassy of the Republic of Turkey 2018-05-04 TURKEY Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 2525 Massachusetts Avenue, NW   Washington DC 20008
13970 13970 1982-11-15 Embassy of the Republic of Turkey 1981-07-20 TURKEY Jack McDonald Associates, Inc. 3038 1979-07-13 Jack McDonald Associates, Inc. Washington     DC  
16802 16802 2017-12-31 Embassy of the Republic of Turkey 2017-05-09 TURKEY BCW LLC 6227 2014-06-18 BCW LLC 2525 Massachusetts Avenue, NW   Washington DC 20008

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