FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where "Foreign_Principal_Termination_Date" is on date 2001-09-30 sorted by City
This data as json, CSV (advanced)
Suggested facets: Address_2, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 12
- Advantage Associates Inc. 1
- Barron-Birrell, Inc. 1
- Berger Hirschberg Strategies, LLC 1
- Development Counsellors International 1
- GCI Group, Inc. 1
- Global Communicators/ Harff Communications, Inc. 1
- Hill and Knowlton Strategies, LLC 1
- InterVISTAS-ga2 Consulting, Inc. 1
- Ryberg and Smith, LLP 1
- Troutman Sanders, LLP 1
- Washington World Group, Ltd. 1
- Yitzhaki, Eliyahu 1
Foreign_Principal 12
- Agency for Humanitarian Technologies 1
- Austrian Airlines 1
- British Tourist Authority 1
- Government of Trinidad & Tobago 1
- Jordan Tourism Board 1
- Ministry of Justice and Ministry of Foreign Affairs & Trade Government of the Kingdom of Swaziland 1
- Natural Resources Canada 1
- Rafael U.S.A., Inc. 1
- Sekar Mahoni Sakti Foundation 1
- Shalom Corps Ltd. (CC) 1
- Welsh Development Agency 1
- Zimbabwe Democracy Trust 1
Country/Location_Represented 10
- GREAT BRITAIN 2
- ISRAEL 2
- AUSTRIA 1
- CANADA 1
- INDONESIA 1
- JORDAN 1
- SWAZILAND 1
- TRINIDAD AND TOBAGO 1
- UKRAINE 1
- ZIMBABWE 1
City 1
- - 12
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12119 | 12119 | 2001-09-30 | Agency for Humanitarian Technologies | 2002-01-25 | UKRAINE | Washington World Group, Ltd. 5016 | 1995-04-20 | Washington World Group, Ltd. | 7 Leontovicha Street, #6 Kiev 01030 | ||||
12120 | 12120 | 2001-09-30 | Austrian Airlines | 2000-10-02 | AUSTRIA | InterVISTAS-ga2 Consulting, Inc. 4902 | 1994-03-14 | InterVISTAS-ga2 Consulting, Inc. | Vienna | ||||
12121 | 12121 | 2001-09-30 | British Tourist Authority | 2001-08-10 | GREAT BRITAIN | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | Thames Tower Black's Road London, W6 9EL | ||||
12122 | 12122 | 2001-09-30 | Government of Trinidad & Tobago | 2001-03-19 | TRINIDAD AND TOBAGO | Development Counsellors International 4777 | 1993-03-12 | Development Counsellors International | 10-14 Philipps Street Port of Spain | ||||
12123 | 12123 | 2001-09-30 | Jordan Tourism Board | 1998-08-19 | JORDAN | Global Communicators/ Harff Communications, Inc. 5241 | 1998-03-05 | Global Communicators/ Harff Communications, Inc. | Amman | ||||
12124 | 12124 | 2001-09-30 | Ministry of Justice and Ministry of Foreign Affairs & Trade Government of the Kingdom of Swaziland | 2001-05-18 | SWAZILAND | Ryberg and Smith, LLP 5433 | 2001-05-18 | Ryberg and Smith, LLP | P.O. Box 518 Mbabane | ||||
12125 | 12125 | 2001-09-30 | Natural Resources Canada | 2000-06-02 | CANADA | Troutman Sanders, LLP 5329 | 1999-09-24 | Troutman Sanders, LLP | Ottawa, Ontario | ||||
12126 | 12126 | 2001-09-30 | Rafael U.S.A., Inc. | 1997-09-15 | ISRAEL | Yitzhaki, Eliyahu 5211 | 1997-09-15 | Yitzhaki, Eliyahu | Washington | DC | |||
12127 | 12127 | 2001-09-30 | Sekar Mahoni Sakti Foundation | 2001-03-21 | INDONESIA | Advantage Associates Inc. 5419 | 2001-03-21 | Advantage Associates Inc. | Graha BIP, BIP, 10th Floor jl. Gatot Subroto KAV.23 Jakarta 12930 | ||||
12128 | 12128 | 2001-09-30 | Shalom Corps Ltd. (CC) | 2021-01-26 | ISRAEL | Berger Hirschberg Strategies, LLC 6917 | 2021-01-26 | Berger Hirschberg Strategies, LLC | 3 HaTsedef St. | Herzliya | |||
12129 | 12129 | 2001-09-30 | Welsh Development Agency | 1997-12-24 | GREAT BRITAIN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Cardiff | ||||
12130 | 12130 | 2001-09-30 | Zimbabwe Democracy Trust | 2001-06-18 | ZIMBABWE | Barron-Birrell, Inc. 5363 | 1997-12-09 | Barron-Birrell, Inc. | 16 St. John's Lane London, ECIM 4AF, UK |
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]) );