FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where Address_1 = "Tunis"
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)
Registrant_Name 14
- Marshall, Leon, Weill & Mahony 2
- Afridi, Angell & Pelletreau LLP 1
- Doremus & Company 1
- Georgetown Associates, Inc. 1
- Laitman, Leon 1
- Martin, Ryan, Haley & Associates, Inc. 1
- North African Independence Movement 1
- Palestine Affairs Center 1
- Powell Tate, Inc. 1
- Rahman, Hasan Abdel 1
- Shandwick Public Affairs, Inc. 1
- Tunisia Investment Promotion Agency 1
- Washington International Group, Inc. 1
- White & Case, LLP 1
Registrant_Date (date) 13 ✖
- 1975-05-16 2
- 1988-04-28 2
- 1947-01-17 1
- 1958-10-02 1
- 1972-02-18 1
- 1973-12-05 1
- 1974-06-06 1
- 1977-03-09 1
- 1979-04-02 1
- 1982-01-05 1
- 1996-12-30 1
- 1997-12-17 1
- 1998-02-04 1
Foreign_Principal 13
- Republic of Tunisia 2
- Tunisian Agency for External Communications 2
- Agence de Promotion des Investissements 1
- Agency for Promotion of Investment 1
- Bank for Economic Development of Tunisia 1
- Destour Party 1
- Government of Tunisia 1
- Government of Tunisia (Chadli Tnani)(Bahi Ladgham) 1
- Hasan Abdel Rahman 1
- League of Arab States 1
- Tunisian External Communication Agency (TECA) 1
- Tunisian Government 1
- Tunisian-American Friendship Society 1
State 1
- - 15
City 1
- - 15
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2924 | 2924 | 1978-02-28 | Republic of Tunisia | 1978-02-23 | TUNISIA | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | Tunis | ||||
3555 | 3555 | 1991-03-09 | Republic of Tunisia | 1988-06-20 | TUNISIA | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | Tunis | ||||
5656 | 5656 | 1994-04-28 | League of Arab States | 1988-04-28 | PALESTINE | Palestine Affairs Center 4133 | 1988-04-28 | Palestine Affairs Center | Tunis | ||||
5775 | 5775 | 1960-04-30 | Government of Tunisia (Chadli Tnani)(Bahi Ladgham) | 1958-10-02 | TUNISIA | Laitman, Leon 1176 | 1958-10-02 | Laitman, Leon | Tunis | ||||
8146 | 8146 | 2002-06-28 | Tunisian External Communication Agency (TECA) | 1998-11-23 | TUNISIA | Afridi, Angell & Pelletreau LLP 5231 | 1998-02-04 | Afridi, Angell & Pelletreau LLP | Tunis | ||||
9019 | 9019 | 1993-07-05 | Government of Tunisia | 1992-04-10 | TUNISIA | Washington International Group, Inc. 3320 | 1982-01-05 | Washington International Group, Inc. | Tunis | ||||
9312 | 9312 | 1947-07-17 | Destour Party | 1947-01-17 | TUNISIA | North African Independence Movement 427 | 1947-01-17 | North African Independence Movement | Tunis | ||||
9982 | 9982 | 1981-08-01 | Agence de Promotion des Investissements | 1979-04-02 | TUNISIA | Tunisia Investment Promotion Agency 3011 | 1979-04-02 | Tunisia Investment Promotion Agency | Tunis | ||||
12724 | 12724 | 1999-10-15 | Tunisian Agency for External Communications | 1998-01-12 | TUNISIA | Powell Tate, Inc. 5148 | 1996-12-30 | Powell Tate, Inc. | Tunis | ||||
12725 | 12725 | 1999-10-15 | Tunisian Agency for External Communications | 1999-12-10 | TUNISIA | Shandwick Public Affairs, Inc. 5220 | 1997-12-17 | Shandwick Public Affairs, Inc. | Tunis | ||||
15202 | 15202 | 1973-12-18 | Tunisian Government | 1973-12-05 | TUNISIA | Georgetown Associates, Inc. 2482 | 1973-12-05 | Georgetown Associates, Inc. | Tunis | ||||
15219 | 15219 | 1974-12-19 | Tunisian-American Friendship Society | 1974-06-06 | TUNISIA | Martin, Ryan, Haley & Associates, Inc. 2517 | 1974-06-06 | Martin, Ryan, Haley & Associates, Inc. | Tunis | ||||
15735 | 15735 | 1975-12-31 | Agency for Promotion of Investment | 1975-05-16 | TUNISIA | Marshall, Leon, Weill & Mahony 2584 | 1975-05-16 | Marshall, Leon, Weill & Mahony | Tunis | ||||
15736 | 15736 | 1975-12-31 | Bank for Economic Development of Tunisia | 1975-05-16 | TUNISIA | Marshall, Leon, Weill & Mahony 2584 | 1975-05-16 | Marshall, Leon, Weill & Mahony | Tunis | ||||
16060 | 16060 | 1988-12-31 | Hasan Abdel Rahman | 1988-04-28 | TUNISIA | Rahman, Hasan Abdel 4132 | 1988-04-28 | Rahman, Hasan Abdel | Tunis |
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]) );