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 = "2007-08-31" sorted by City
This data as json, CSV (advanced)
Suggested facets: Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Registrant_Name 12
Foreign_Principal 12
- Bank of Montreal 1
- Embassy of Norway 1
- Embassy of the Republic of Cyprus 1
- Embassy of the Republic of Cyprus, through Covington & Burling LLP 1
- Embassy of the Republic of Peru through Patton Boggs 1
- Government of Albania 1
- Government of Togolese Republic 1
- Government of Turkey, Embassy 1
- Her Majesty the Queen in Right of Ontario as represented by the Minister of the Environment 1
- Iraqi Tawafuq Front aka Iraqi Accordance Front 1
- Republic of China (Taiwan) 1
- Republic of Cyprus, Embassy 1
Country/Location_Represented 9
City 6
- - 5
- Washington 3
- Baghdad 1
- Taipai 1
- Toronto 1
- Toronto, Ontario 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11110 | 11110 | 2007-08-31 | Embassy of Norway | 2004-09-21 | NORWAY | Roth, Susan 5646 | 2004-09-21 | Roth, Susan | 2720 34th Street, N.W. 20008 | DC | |||
11114 | 11114 | 2007-08-31 | Government of Albania | 2008-06-12 | ALBANIA | Ridge Global, LLC 5868 | 2008-06-12 | Ridge Global, LLC | Blv. Deshmoret e Kombit | Keshili Ministrave Tirana | |||
11115 | 11115 | 2007-08-31 | Government of Togolese Republic | 2006-10-19 | TOGO | Whitaker Group, Inc. 5539 | 2003-02-13 | Whitaker Group, Inc. | |||||
11116 | 11116 | 2007-08-31 | Government of Turkey, Embassy | 2000-02-16 | TURKEY | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 2525 Massachusetts Avenue, N.W. 20008 | DC | |||
11120 | 11120 | 2007-08-31 | Republic of Cyprus, Embassy | 2004-05-07 | CYPRUS | Covington & Burling, LLP 5621 | 2004-05-07 | Covington & Burling, LLP | 2211 R Street, N.W. 20008 | DC | |||
11118 | 11118 | 2007-08-31 | Iraqi Tawafuq Front aka Iraqi Accordance Front | 2007-02-05 | IRAQ | Zenith Consulting, Inc. 5792 | 2007-02-05 | Zenith Consulting, Inc. | Yarmouk District | Baghdad | |||
11119 | 11119 | 2007-08-31 | Republic of China (Taiwan) | 2005-03-15 | TAIWAN | BGR Government Affairs, LLC 5430 | 2001-05-10 | BGR Government Affairs, LLC | National Security Council No. 122, Sec. 1, Chungching S. Road | Taipai | |||
11109 | 11109 | 2007-08-31 | Bank of Montreal | 2008-02-29 | CANADA | Carmen Group Incorporated 5727 | 2006-01-17 | Carmen Group Incorporated | 3300 Bloor Street West | Centre Tower - 6th Floor | Toronto | ||
11117 | 11117 | 2007-08-31 | Her Majesty the Queen in Right of Ontario as represented by the Minister of the Environment | 2006-08-15 | CANADA | Gilberts Washington, Inc. 5763 | 2006-09-28 | Gilberts Washington, Inc. | Ministry of the Environment Strategic Wash Project | 135 St. Clair Avenue W, 7th Floor | Toronto, Ontario | ||
11111 | 11111 | 2007-08-31 | Embassy of the Republic of Cyprus | 2006-09-21 | CYPRUS | Weber Shandwick, Inc. 5579 | 2003-10-02 | Weber Shandwick, Inc. | 2211 R Street, NW | Washington | DC | 20008 | |
11112 | 11112 | 2007-08-31 | Embassy of the Republic of Cyprus, through Covington & Burling LLP | 2006-11-29 | CYPRUS | BKSH & Associates 5402 | 2000-12-14 | BKSH & Associates | 1201 Pennsylvania Avenue, NW | Washington | DC | 20004 | |
11113 | 11113 | 2007-08-31 | Embassy of the Republic of Peru through Patton Boggs | 2007-08-03 | PERU | James & Hoffman, PC 5822 | 2007-08-03 | James & Hoffman, PC | 1700 Massachusetts Avenue, NW | Washington | DC | 20036 |
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]) );