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

18 rows where Country/Location_Represented = "ANGOLA" and State = "DC"

✎ View and edit SQL

This data as json, CSV (advanced)

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

City 2

State 1

Country/Location_Represented 1

  • ANGOLA · 18 ✖
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
946 946 1992-01-01 Free Angola Information Service (UNITA) 1986-12-10 ANGOLA Griffin Communications 3913 1986-06-10 Griffin Communications Washington     DC  
1062 1062 1990-01-03 UNITA (Through Free Angola Information Service) 1987-09-01 ANGOLA American Expressions, Inc. 4035 1987-09-01 American Expressions, Inc. Washington     DC  
2447 2447 1995-02-13 Government of the Republic of Angola 1994-03-21 ANGOLA Strategic Policy, Inc. 4206 1989-01-13 Strategic Policy, Inc. Embassy, Washington     DC  
5063 5063 1995-04-06 Republic of Angola 1994-04-18 ANGOLA APCO Worldwide, Inc. 4561 1991-09-03 APCO Worldwide, Inc. Washington     DC  
5149 5149 2006-04-10 Government of the Republic of Angola, Embassy 1996-07-02 ANGOLA C/R International, L.L.C. 5117 1996-07-02 C/R International, L.L.C. Washington     DC  
7085 7085 1990-05-31 Uniao Nacional para Independencia Total de Angola (UNITA) 1988-06-24 ANGOLA TKC International, Inc. 3075 1979-12-13 TKC International, Inc. Washington     DC  
7222 7222 2009-05-31 Government of the Republic of Angola, Embassy through Patton Boggs, LLP 2008-05-27 ANGOLA Washington Global Consultants, LLC 5865 2008-05-27 Washington Global Consultants, LLC 2108 16th Street, NW   Washington DC 20009
8468 8468 1990-06-30 UNITA (Uniao Nacional de Independencia Total de Angola National Union for the Total Independence of Angola) 1990-04-10 ANGOLA Keene, Shirley & Associates, Inc. 3997 1987-06-19 Keene, Shirley & Associates, Inc. Washington     DC  
8622 8622 2002-06-30 Government of the Republic of Angola, Embassy 2001-04-13 ANGOLA Cohen & Woods International, Inc. 5003 1995-03-10 Cohen & Woods International, Inc. Embassy of the Republic of Angola 2100-2108 16th Street, N.W. 20009     DC  
8692 8692 2010-06-30 Government of the Republic of Angola, Embassy 2008-05-19 ANGOLA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2108 16th Street, NW   Washington DC 20009
11146 11146 2012-08-31 Government of Angola 1993-08-26 ANGOLA Samuels International Associates, Inc. 4848 1993-08-26 Samuels International Associates, Inc. Washington     DC  
11280 11280 1990-09-01 UNITA 1987-01-12 ANGOLA NM International, Inc. 3927 1987-01-12 NM International, Inc. Washington     DC  
12018 12018 1990-09-30 Democratic Renaissance Movement of Angola 1990-03-27 ANGOLA Democratic Renaissance Movement of Angola (D.R.M.A.) 4359 1990-03-27 Democratic Renaissance Movement of Angola (D.R.M.A.) Washington     DC  
12110 12110 2000-09-30 Commercial Section of the Embassy of Angola 1998-03-25 ANGOLA Bristol Group, Inc. 5247 1998-03-25 Bristol Group, Inc.       DC  
12385 12385 1997-10-01 National Union for the Total Independence of Angola 1996-08-02 ANGOLA Norquist, Grover Glenn 5061 1995-09-08 Norquist, Grover Glenn Washington     DC  
14983 14983 1993-12-10 Permanent Mission of Angola to the Organization of American States (OAS) 1992-11-17 ANGOLA Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Washington     DC  
16114 16114 1989-12-31 Free Angola Information Service 1987-01-09 ANGOLA Government Relations International, Inc. 3929 1987-01-09 Government Relations International, Inc. Washington     DC  
16422 16422 1997-12-31 National Union for the Total Independence of Angola (UNITA) 1996-02-29 ANGOLA Sellars, Duncan W. 5096 1996-02-29 Sellars, Duncan W. Washington     DC  

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