FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where Address_1 = "Algiers"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Registration_Number, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Foreign_Principal 15
- Sonatrach 2
- Algeria 1
- Algerian People's Party 1
- Bank of Algeria, Acting on behalf of the Government of the Republic of Algeria 1
- Bureau Algerian de Recherches et d'Exploitations Minieres (BAREM) 1
- Democratic & Popular Republic of Algeria 1
- Democratic and Popular Republic of Algeria/Office of the Presidency 1
- Government of Algeria 1
- Minister of Industry & Energy of Algeria 1
- Office of Studies & Expert Opinions (Democratic & Popular Republic of Algeria) 1
- SONATRACH - Societe Nationale de Transport et de Commercialisation des Hydrocarbures 1
- Societe Nationale Pour la Recherche, Production, Transport, Transormation et la Commercialisation des Hydrocarbures 1
- Societe Nationale Sonatrach 1
- Societe Nationale de Recherches et d'Etploitations Minieres (SONAREM) 1
- Societe Nationale de Transport et de Commercialisation des Hydrocarbons (Agency of Government of Algeria) (SONATRACH) 1
Registrant_Date (date) 12 ✖
- 1965-04-05 4
- 1982-12-10 2
- 1947-01-17 1
- 1962-07-02 1
- 1969-07-25 1
- 1972-02-18 1
- 1973-12-14 1
- 1974-08-27 1
- 1974-10-24 1
- 1975-03-26 1
- 1993-07-01 1
- 1995-02-06 1
Registrant_Name 11
State 1
- - 16
Country/Location_Represented 1
- ALGERIA 16
City 1
- - 16
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1633 | 1633 | 1976-01-30 | Algeria | 1973-12-14 | ALGERIA | Kleindienst, Richard G. 2483 | 1973-12-14 | Kleindienst, Richard G. | Algiers | ||||
2345 | 2345 | 1977-02-10 | Sonatrach | 1977-02-11 | ALGERIA | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | Algiers | ||||
2709 | 2709 | 1995-02-22 | Office of Studies & Expert Opinions (Democratic & Popular Republic of Algeria) | 1993-07-01 | ALGERIA | Katten, Muchin & Zavis 4825 | 1993-07-01 | Katten, Muchin & Zavis | Algiers | ||||
5157 | 5157 | 1977-04-11 | Bureau Algerian de Recherches et d'Exploitations Minieres (BAREM) | 1966-11-15 | ALGERIA | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | Algiers | ||||
5158 | 5158 | 1977-04-11 | Societe Nationale de Recherches et d'Etploitations Minieres (SONAREM) | 1973-05-18 | ALGERIA | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | Algiers | ||||
5160 | 5160 | 1977-04-11 | Minister of Industry & Energy of Algeria | 1973-05-18 | ALGERIA | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | Algiers | ||||
5162 | 5162 | 1977-04-11 | Societe Nationale de Transport et de Commercialisation des Hydrocarbons (Agency of Government of Algeria) (SONATRACH) | 1965-04-05 | ALGERIA | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | Algiers | ||||
5405 | 5405 | 1971-04-19 | Societe Nationale Pour la Recherche, Production, Transport, Transormation et la Commercialisation des Hydrocarbures | 1969-06-25 | ALGERIA | Paul R. Gibson & Associates 2149 | 1969-07-25 | Paul R. Gibson & Associates | Algiers | ||||
5421 | 5421 | 1965-04-20 | Democratic & Popular Republic of Algeria | 1964-12-21 | ALGERIA | Casey, Lane & Mittendorf 1553 | 1962-07-02 | Casey, Lane & Mittendorf | Algiers | ||||
6575 | 6575 | 2000-05-15 | Democratic and Popular Republic of Algeria/Office of the Presidency | 1999-09-28 | ALGERIA | JWI, LLC 4990 | 1995-02-06 | JWI, LLC | Algiers | ||||
8309 | 8309 | 1976-06-30 | Societe Nationale Sonatrach | 1974-10-17 | ALGERIA | Kearns International 2542 | 1974-10-24 | Kearns International | Algiers | ||||
9311 | 9311 | 1947-07-17 | Algerian People's Party | 1947-01-17 | ALGERIA | North African Independence Movement 427 | 1947-01-17 | North African Independence Movement | Algiers | ||||
11943 | 11943 | 1978-09-30 | Government of Algeria | 1975-03-26 | ALGERIA | Clifford & Warnke 2564 | 1975-03-26 | Clifford & Warnke | Algiers | ||||
12791 | 12791 | 1974-10-17 | Sonatrach | 1974-08-27 | ALGERIA | Kearns International 2531 | 1974-08-27 | Kearns International | Algiers | ||||
13606 | 13606 | 1994-11-01 | Bank of Algeria, Acting on behalf of the Government of the Republic of Algeria | 1993-05-03 | ALGERIA | Jones Day 3427 | 1982-12-10 | Jones Day | Algiers | ||||
14686 | 14686 | 1986-12-01 | SONATRACH - Societe Nationale de Transport et de Commercialisation des Hydrocarbures | 1982-12-10 | ALGERIA | Jones Day 3427 | 1982-12-10 | Jones Day | Algiers |
Advanced export
JSON shape: default, array, newline-delimited
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]) );