FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
39 rows where Address_1 = "Cairo"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Foreign_Principal 35
- Arab Republic of Egypt 3
- Government of Egypt 2
- League of Arab States 2
- Abdul Hackim Amer 1
- Al Missaa 1
- Algerian Delegation of the Front of National Liberation 1
- Allal Al Fassi 1
- Ameer Abdul Kareem Al-Khutabi 1
- American Chamber of Commerce in Egypt 1
- Arab African Bank 1
- Arab Republic of Egypt, Ministry of Argriculture & Irrigation 1
- Arab Republic of Egypt, Ministry of Defense 1
- Arab Republic of Egypt, Ministry of Tourism 1
- Ashraf Pahlavi 1
- Committee for Freedom of North America 1
- Committee for Unity of the Nile Valley 1
- Egypt 1
- Egypt (Through Hart Marketing Resources) 1
- Egyptian Garment Exporters' Association 1
- Egyptian Ministry of Foreign Affairs 1
- Egyptian State Department of Tourism 1
- Government of Egypt, Ministry of Tourism 1
- Hassan Tatanaki 1
- League of the Arab States 1
- MISR Travel 1
- Ministry of Foreign Affairs Government of the Arab Republic of Egypt 1
- Ministry of Foreign Trade 1
- Mohammad Reza Pahlavi 1
- Palestine Liberation Organization 1
- Postal Administration of Egypt (UAR) 1
- Republic of Egypt 1
- Senator W. Doo (Commercial Bank of Egypt) 1
- Sophocles Venizelos, Minister of the Navy, Greek Government in Exile 1
- United Arab Republic Tourist Office 1
- United Arb Republic 1
Registrant_Name 32
- Al-Bayan 2
- Armao & Company, Inc. 2
- Bouhafa, El Abed 2
- Fasturn, Inc. 2
- Kelly, Nason, Inc. 2
- United States Arab-Asian Institute, Inc. 2
- Washington International Group, Inc. 2
- Advocacy International, Ltd. 1
- Ait-Ahmed, Hussein 1
- Arab Information Center 1
- Atwater Bradley Company, Inc. 1
- Bannerman & Associates, Inc. 1
- Beach, Rex M.S. 1
- Carmen Group, Inc. 1
- Committee For Unity Of The Nile Valley 1
- Daniel J. Edelman, Inc. 1
- Davies, Harry 1
- Doremus & Company 1
- Egyptian Government Tourist Office 1
- Egyptian Information Bureau 1
- Hart Marketing Resources 1
- Hoey, John J. 1
- Kehr, Ernest A. 1
- Lind, Lewis Merkt 1
- MISR Travel 1
- Murphy, John M. 1
- Owen III, Thomas M. 1
- P.A. Consulting Group, Inc. 1
- Palestine Liberation Organization, New York 1
- Perry, Marilyn Edith 1
- Petran, Tabitha 1
- Susan Davis International & Public Affairs 1
Registrant_Date (date) 32 ✖
- 1942-07-30 2
- 1947-06-04 2
- 1957-05-16 2
- 1957-06-25 2
- 1978-08-09 2
- 1980-08-12 2
- 1982-01-05 2
- 1943-06-11 1
- 1945-12-12 1
- 1947-06-06 1
- 1950-11-08 1
- 1955-03-03 1
- 1956-08-23 1
- 1957-03-14 1
- 1957-07-03 1
- 1959-04-16 1
- 1960-01-13 1
- 1965-01-22 1
- 1965-09-15 1
- 1972-02-18 1
- 1976-10-27 1
- 1977-02-10 1
- 1977-06-01 1
- 1977-07-28 1
- 1983-02-16 1
- 1985-03-12 1
- 1987-04-28 1
- 1987-09-23 1
- 1989-03-20 1
- 1989-09-07 1
- 1992-06-02 1
- 2000-07-14 1
Country/Location_Represented 6
State 1
- - 39
City 1
- - 39
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1184 | 1184 | 1968-01-10 | League of Arab States | 1967-05-12 | EGYPT | Atwater Bradley Company, Inc. 1925 | 1965-09-15 | Atwater Bradley Company, Inc. | Cairo | ||||
1839 | 1839 | 2002-01-31 | Ministry of Foreign Trade | 2000-07-14 | EGYPT | P.A. Consulting Group, Inc. 5378 | 2000-07-14 | P.A. Consulting Group, Inc. | Cairo | ||||
2648 | 2648 | 1990-02-18 | Egypt (Through Hart Marketing Resources) | 1989-10-03 | EGYPT | Carmen Group, Inc. 4233 | 1989-03-20 | Carmen Group, Inc. | Cairo | ||||
2728 | 2728 | 1988-02-23 | Arab Republic of Egypt, Ministry of Defense | 1987-09-23 | EGYPT | Advocacy International, Ltd. 4041 | 1987-09-23 | Advocacy International, Ltd. | Cairo | ||||
3080 | 3080 | 2007-02-28 | Arab Republic of Egypt | 1990-03-22 | EGYPT | Bannerman & Associates, Inc. 3964 | 1987-04-28 | Bannerman & Associates, Inc. | Cairo | ||||
3504 | 3504 | 1995-03-07 | Egyptian Garment Exporters' Association | 1994-09-08 | EGYPT | Fasturn, Inc. 2944 | 1978-08-09 | Fasturn, Inc. | Cairo | ||||
3676 | 3676 | 2000-03-12 | Ministry of Foreign Affairs Government of the Arab Republic of Egypt | 1997-05-20 | EGYPT | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | Cairo | ||||
3705 | 3705 | 1957-03-14 | Al Missaa | 1957-03-14 | EGYPT | Petran, Tabitha 1008 | 1957-03-14 | Petran, Tabitha | Cairo | ||||
4827 | 4827 | 1948-04-01 | Committee for Unity of the Nile Valley | 1947-06-06 | EGYPT | Committee For Unity Of The Nile Valley 467 | 1947-06-06 | Committee For Unity Of The Nile Valley | Cairo | ||||
5462 | 5462 | 1993-04-21 | Government of Egypt, Ministry of Tourism | 1989-09-07 | EGYPT | Hart Marketing Resources 4286 | 1989-09-07 | Hart Marketing Resources | Cairo | ||||
6596 | 6596 | 1960-05-16 | Egypt | 1958-01-29 | EGYPT | United States Arab-Asian Institute, Inc. 1028 | 1957-05-16 | United States Arab-Asian Institute, Inc. | Cairo | ||||
6600 | 6600 | 1960-05-16 | United Arb Republic | 1958-11-19 | EGYPT | United States Arab-Asian Institute, Inc. 1028 | 1957-05-16 | United States Arab-Asian Institute, Inc. | Cairo | ||||
7319 | 7319 | 1957-06-01 | League of the Arab States | 1954-07-27 | TUNISIA | Bouhafa, El Abed 466 | 1947-06-04 | Bouhafa, El Abed | Cairo | ||||
7367 | 7367 | 1978-06-01 | Arab Republic of Egypt, Ministry of Argriculture & Irrigation | 1977-02-10 | EGYPT | Owen III, Thomas M. 2755 | 1977-02-10 | Owen III, Thomas M. | Cairo | ||||
7740 | 7740 | 1943-06-11 | Sophocles Venizelos, Minister of the Navy, Greek Government in Exile | 1943-06-11 | EGYPT | Davies, Harry 196 | 1943-06-11 | Davies, Harry | Cairo | ||||
8798 | 8798 | 1946-07-01 | Senator W. Doo (Commercial Bank of Egypt) | 1945-12-12 | EGYPT | Lind, Lewis Merkt 331 | 1945-12-12 | Lind, Lewis Merkt | Cairo | ||||
9668 | 9668 | 1964-07-31 | Egyptian State Department of Tourism | 1955-03-31 | EGYPT | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Cairo | ||||
9696 | 9696 | 1964-07-31 | United Arab Republic Tourist Office | 1958-10-08 | UNITED ARAB EMIRATES | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Cairo | ||||
10142 | 10142 | 1994-08-05 | American Chamber of Commerce in Egypt | 1994-02-25 | EGYPT | Washington International Group, Inc. 3320 | 1982-01-05 | Washington International Group, Inc. | Cairo | ||||
10165 | 10165 | 1981-08-06 | Arab African Bank | 1977-12-06 | EGYPT | Hoey, John J. 2790 | 1977-06-01 | Hoey, John J. | Cairo | ||||
10898 | 10898 | 1978-08-31 | Arab Republic of Egypt | 1978-02-14 | EGYPT | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | Cairo | ||||
10900 | 10900 | 1980-08-31 | Ashraf Pahlavi | 1980-08-12 | EGYPT | Armao & Company, Inc. 3139 | 1980-08-12 | Armao & Company, Inc. | Cairo | ||||
10901 | 10901 | 1980-08-31 | Mohammad Reza Pahlavi | 1980-08-12 | EGYPT | Armao & Company, Inc. 3139 | 1980-08-12 | Armao & Company, Inc. | Cairo | ||||
11210 | 11210 | 1962-09-01 | Abdul Hackim Amer | 1959-01-22 | EGYPT | Al-Bayan 1042 | 1957-06-25 | Al-Bayan | Cairo | ||||
11213 | 11213 | 1962-09-01 | Ameer Abdul Kareem Al-Khutabi | 1957-06-25 | EGYPT | Al-Bayan 1042 | 1957-06-25 | Al-Bayan | Cairo | ||||
11476 | 11476 | 1993-09-09 | Government of Egypt | 1993-03-12 | EGYPT | Fasturn, Inc. 2944 | 1978-08-09 | Fasturn, Inc. | Cairo | ||||
11764 | 11764 | 1992-09-22 | Hassan Tatanaki | 1992-06-02 | LIBYA | Murphy, John M. 4679 | 1992-06-02 | Murphy, John M. | Cairo | ||||
12360 | 12360 | 1987-10-01 | Government of Egypt | 1983-02-16 | EGYPT | Susan Davis International & Public Affairs 3444 | 1983-02-16 | Susan Davis International & Public Affairs | Cairo | ||||
12776 | 12776 | 1992-10-16 | MISR Travel | 1977-07-28 | EGYPT | MISR Travel 2815 | 1977-07-28 | MISR Travel | Cairo | ||||
12974 | 12974 | 1966-10-24 | Postal Administration of Egypt (UAR) | 1959-04-16 | EGYPT | Kehr, Ernest A. 1219 | 1959-04-16 | Kehr, Ernest A. | Cairo | ||||
13090 | 13090 | 1958-10-28 | Committee for Freedom of North America | 1957-07-03 | EGYPT | Beach, Rex M.S. 1044 | 1957-07-03 | Beach, Rex M.S. | Cairo | ||||
13562 | 13562 | 1984-11-01 | Palestine Liberation Organization | 1967-04-17 | EGYPT | Palestine Liberation Organization, New York 1845 | 1965-01-22 | Palestine Liberation Organization, New York | Cairo | ||||
13722 | 13722 | 1952-11-05 | Egyptian Ministry of Foreign Affairs | 1950-11-08 | EGYPT | Egyptian Information Bureau 648 | 1950-11-08 | Egyptian Information Bureau | Cairo | ||||
14166 | 14166 | 1989-11-22 | Arab Republic of Egypt | 1982-01-05 | EGYPT | Washington International Group, Inc. 3320 | 1982-01-05 | Washington International Group, Inc. | Cairo | ||||
14346 | 14346 | 1976-11-30 | League of Arab States | 1976-12-30 | EGYPT | Perry, Marilyn Edith 2731 | 1976-10-27 | Perry, Marilyn Edith | Cairo | ||||
15557 | 15557 | 1956-12-31 | Algerian Delegation of the Front of National Liberation | 1956-08-23 | ALGERIA | Ait-Ahmed, Hussein 968 | 1956-08-23 | Ait-Ahmed, Hussein | Cairo | ||||
15563 | 15563 | 1957-12-31 | Allal Al Fassi | 1952-04-30 | MOROCCO | Bouhafa, El Abed 466 | 1947-06-04 | Bouhafa, El Abed | Cairo | ||||
15712 | 15712 | 1973-12-31 | Republic of Egypt | 1955-03-03 | EGYPT | Arab Information Center 876 | 1955-03-03 | Arab Information Center | Cairo | ||||
16038 | 16038 | 1988-12-31 | Arab Republic of Egypt, Ministry of Tourism | 1960-01-13 | EGYPT | Egyptian Government Tourist Office 1322 | 1960-01-13 | Egyptian Government Tourist Office | Cairo |
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]) );