FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where Address_1 = "Addis Ababa"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Registrant_Date (date) 17 ✖
- 1946-04-23 1
- 1947-02-17 1
- 1953-09-28 1
- 1956-04-10 1
- 1957-05-08 1
- 1957-06-21 1
- 1958-12-17 1
- 1961-09-11 1
- 1961-10-04 1
- 1973-10-25 1
- 1985-01-18 1
- 1987-12-27 1
- 1992-01-29 1
- 1993-04-02 1
- 1993-11-10 1
- 2005-08-25 1
- 2006-11-22 1
Registrant_Name 14
- Scott, Robert Day 4
- Coalition for Unity and Democracy Relief & Development Association (Kinijit) 1
- DeBello, Yirgu Megerssa 1
- Donald S. Dawson & James W. Riddell 1
- Edward K. Moss International 1
- Ethiopian Philatelic Agency, Ltd. 1
- Garreston, Albert H. 1
- Hanfore, Yohannes 1
- John A. Cairns & Company, Inc. 1
- Oromo Liberation Front, North America Office 1
- Pehle, Riemer, Luxford & Naiden 1
- Sheldon Ritter International Public Relations 1
- Somaliland Republic Office 1
- Teckle, Tesfu Berhane 1
Foreign_Principal 12
- Imperial Ethiopian Government 5
- Southern Ethiopia People's Democratic Coalition 2
- Board of Liquidation, Bank of Ethiopia (In Liquidation) 1
- Coalition for Unity & Democracy (Kinijit) Party 1
- Empire of Ethiopia 1
- Eritrean People's Movement 1
- Ethiopian Airlines 1
- Government of Ethiopia 1
- Imperial Government of Ethiopia 1
- Ministry of Commerce, Industry & Toursim of the Imperial Ethiopian Government 1
- Oromo Liberation Front (OLF) 1
- Somali National Movement 1
Country/Location_Represented 3
State 1
- - 17
City 1
- - 17
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
545 | 545 | Oromo Liberation Front (OLF) | 1992-01-29 | ETHIOPIA | Oromo Liberation Front, North America Office 4610 | 1992-01-29 | Oromo Liberation Front, North America Office | Addis Ababa | |||||
3387 | 3387 | 1954-03-03 | Imperial Government of Ethiopia | 1953-09-28 | ETHIOPIA | Scott, Robert Day 790 | 1953-09-28 | Scott, Robert Day | Addis Ababa | ||||
3594 | 3594 | 1963-03-11 | Imperial Ethiopian Government | 1961-09-11 | ETHIOPIA | Ethiopian Philatelic Agency, Ltd. 1476 | 1961-09-11 | Ethiopian Philatelic Agency, Ltd. | Addis Ababa | ||||
6867 | 6867 | 1994-05-27 | Southern Ethiopia People's Democratic Coalition | 1993-04-02 | ETHIOPIA | Hanfore, Yohannes 4788 | 1993-04-02 | Hanfore, Yohannes | Addis Ababa | ||||
7632 | 7632 | 1974-06-06 | Ministry of Commerce, Industry & Toursim of the Imperial Ethiopian Government | 1973-10-25 | ETHIOPIA | Donald S. Dawson & James W. Riddell 2471 | 1973-10-25 | Donald S. Dawson & James W. Riddell | Addis Ababa | ||||
7741 | 7741 | 1956-06-11 | Imperial Ethiopian Government | 1956-04-10 | ETHIOPIA | Scott, Robert Day 942 | 1956-04-10 | Scott, Robert Day | Addis Ababa | ||||
7970 | 7970 | 1960-06-21 | Imperial Ethiopian Government | 1957-06-21 | ETHIOPIA | Garreston, Albert H. 1040 | 1957-06-21 | Garreston, Albert H. | Addis Ababa | ||||
8479 | 8479 | 1991-06-30 | Ethiopian Airlines | 1988-01-06 | ETHIOPIA | Sheldon Ritter International Public Relations 4077 | 1987-12-27 | Sheldon Ritter International Public Relations | Addis Ababa | ||||
9350 | 9350 | 1995-07-18 | Somali National Movement | 1985-01-18 | SOMALI DEMOCRATIC REPUBLIC | Somaliland Republic Office 3640 | 1985-01-18 | Somaliland Republic Office | Addis Ababa | ||||
10553 | 10553 | 1957-08-16 | Imperial Ethiopian Government | 1957-05-08 | ETHIOPIA | Scott, Robert Day 1021 | 1957-05-08 | Scott, Robert Day | Addis Ababa | ||||
11121 | 11121 | 2008-08-31 | Eritrean People's Movement | 2005-08-25 | ERITREA | Teckle, Tesfu Berhane 5707 | 2005-08-25 | Teckle, Tesfu Berhane | Addis Ababa | ||||
11216 | 11216 | 1963-09-01 | Government of Ethiopia | 1963-03-04 | ETHIOPIA | Edward K. Moss International 1483 | 1961-10-04 | Edward K. Moss International | Addis Ababa | ||||
12944 | 12944 | 1946-10-23 | Empire of Ethiopia | 1946-04-23 | ETHIOPIA | John A. Cairns & Company, Inc. 354 | 1946-04-23 | John A. Cairns & Company, Inc. | Addis Ababa | ||||
13527 | 13527 | 1959-11-01 | Imperial Ethiopian Government | 1958-12-17 | ETHIOPIA | Scott, Robert Day 1191 | 1958-12-17 | Scott, Robert Day | Addis Ababa | ||||
14176 | 14176 | 2006-11-22 | Coalition for Unity & Democracy (Kinijit) Party | 2006-11-22 | ETHIOPIA | Coalition for Unity and Democracy Relief & Development Association (Kinijit) 5778 | 2006-11-22 | Coalition for Unity and Democracy Relief & Development Association (Kinijit) | Addis Ababa | ||||
14437 | 14437 | 1993-11-30 | Southern Ethiopia People's Democratic Coalition | 1993-11-10 | ETHIOPIA | DeBello, Yirgu Megerssa 4868 | 1993-11-10 | DeBello, Yirgu Megerssa | Addis Ababa | ||||
15334 | 15334 | 1952-12-23 | Board of Liquidation, Bank of Ethiopia (In Liquidation) | 1950-03-29 | ETHIOPIA | Pehle, Riemer, Luxford & Naiden 439 | 1947-02-17 | Pehle, Riemer, Luxford & Naiden | Addis Ababa |
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]) );