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

10 rows where Country/Location_Represented = "ALGERIA" and State = "DC"

✎ View and edit SQL

This data as json, CSV (advanced)

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

City 2

State 1

Country/Location_Represented 1

  • ALGERIA · 10 ✖
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
960 960 1995-01-01 Republic of Algeria 1993-06-18 ALGERIA Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L Washington     DC  
1866 1866 2007-01-31 Government of the Democratic and Popular Republic of Algeria, Embassy 2006-01-17 ALGERIA Carmen Group Incorporated 5727 2006-01-17 Carmen Group Incorporated 2118 Kalorama Road, NW   Washington DC 20008
4798 4798 2021-03-31 Government of the People's Democratic Republic of Algeria, Embassy 2007-05-25 ALGERIA Foley Hoag, LLP 4776 1993-03-02 Foley Hoag, LLP 2118 Kalorama Road, NW   Washington DC 20008
5417 5417 2004-04-19 Government of Algeria, Embassy 2004-04-19 ALGERIA Lichfield Group, Inc 5616 2004-04-19 Lichfield Group, Inc Embassy of Algeria 2118 Kalorama Road 20008     DC  
6109 6109 2020-04-30 Government of the Democratic and Popular Republic of Algeria 2018-11-06 ALGERIA Keene, David A. d/b/a Keene Consulting 6608 2018-11-06 Keene, David A. d/b/a Keene Consulting 2118 Kalorama Rd NW   Washington DC 20008
6503 6503 1965-05-13 Algerian Embassy (Through Washburn, Stringer Associates, Inc.) 1965-05-13 ALGERIA Fred W. Johnson & Company 1891 1965-05-13 Fred W. Johnson & Company Washington     DC  
7627 7627 1966-06-06 Embassy of Algeria 1966-05-16 ALGERIA Abdeslem, Belkacem 1977 1966-05-16 Abdeslem, Belkacem Washington     DC  
8267 8267 1968-06-30 Government of Algeria 1965-03-23 ALGERIA Murden & Company, Inc. 1510 1962-01-17 Murden & Company, Inc. Washington     DC  
9056 9056 1964-07-07 Embassy of the Republic of Algeria 1964-07-07 ALGERIA Hal Hazelrigg, Inc. 1769 1964-07-07 Hal Hazelrigg, Inc. Washington     DC  
13608 13608 1994-11-01 Embassy of the Democratic Republic of Algeria 1993-05-28 ALGERIA Jones Day 3427 1982-12-10 Jones Day 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])
);