FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where "Foreign_Principal_Termination_Date" is on date 2002-12-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registrant_Date, Address_1, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 16
- Agency for Humanitarian Technologies 1
- Bord Failte Eireann (Government of Ireland Tourist Board) 1
- Council of Hellenes Abroad 1
- Dubai 2003 1
- Embassy of the Republic of Mexico 1
- Government of Haiti 1
- Government of Mexico, Embassy 1
- Government of the Congo 1
- Government of the Yukon Territory 1
- His Excellency Ibrahim Saminu Turaki, Governor Jigawa State, Nigeria 1
- Hitachi, Ltd. 1
- International Olive Oil Council 1
- Republic of Costa Rica 1
- Rome Cavalien Hilton 1
- Taipei Economic and Cultural Representative Office (TECRO) 1
- Vela International Marine Limited 1
Country/Location_Represented 15
- MEXICO 2
- CANADA 1
- CONGO, DEMOCRATIC REPUBLIC OF THE 1
- COSTA RICA 1
- GREECE 1
- HAITI 1
- INTERNATIONAL 1
- IRELAND 1
- ITALY 1
- JAPAN 1
- NIGERIA 1
- SAUDI ARABIA 1
- TAIWAN 1
- UKRAINE 1
- UNITED ARAB EMIRATES 1
Registrant_Name 14
- BKSH & Associates 2
- Hill and Knowlton Strategies, LLC 2
- BGR Government Affairs, LLC 1
- Barron-Birrell, Inc. 1
- Burson-Marsteller 1
- Downen, Robert L. 1
- Downey McGrath Group, Inc. 1
- Lane Marketing Communications 1
- Miller Thomson LLP 1
- Ruder Finn, Inc. 1
- Scott, Thomas J. 1
- Skadden, Arps, Slate, Meagher & Flom, LLP 1
- Squire Patton Boggs, LLP 1
- Tourism Ireland 1
City 1
- - 16
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16512 | 16512 | 2002-12-31 | Agency for Humanitarian Technologies | 2001-06-28 | UKRAINE | BKSH & Associates 5402 | 2000-12-14 | BKSH & Associates | 7 Leontovicha, Apt. 6 Kyiv 01030 | ||||
16513 | 16513 | 2002-12-31 | Bord Failte Eireann (Government of Ireland Tourist Board) | 1974-08-01 | IRELAND | Tourism Ireland 536 | 1948-08-16 | Tourism Ireland | Dublin | ||||
16514 | 16514 | 2002-12-31 | Council of Hellenes Abroad | 2003-07-09 | GREECE | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | North & South America region - 360 N. Michigan Avenue, Suite 1109 Chicago 60601 (headquarters in T | IL | |||
16515 | 16515 | 2002-12-31 | Dubai 2003 | 2002-05-13 | UNITED ARAB EMIRATES | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | P.O. Box 40022 United Arab Emirates | ||||
16516 | 16516 | 2002-12-31 | Embassy of the Republic of Mexico | 2001-10-02 | MEXICO | BGR Government Affairs, LLC 5430 | 2001-05-10 | BGR Government Affairs, LLC | 1911 Pennsylvania Avenue, N.W. 20006 | DC | |||
16517 | 16517 | 2002-12-31 | Government of Haiti | 2002-01-18 | HAITI | Downey McGrath Group, Inc. 5411 | 2001-02-13 | Downey McGrath Group, Inc. | Kurzban, Kurzban, Weinger & Tetzeli Plaza 2650, Second Floor 2650 SW 27th Avenue Miami 33133 | FL | |||
16518 | 16518 | 2002-12-31 | Government of Mexico, Embassy | 2001-10-04 | MEXICO | Skadden, Arps, Slate, Meagher & Flom, LLP 5460 | 2001-10-04 | Skadden, Arps, Slate, Meagher & Flom, LLP | 1911 Pennsylvania Avenue, N.W. 20006 | DC | |||
16519 | 16519 | 2002-12-31 | Government of the Congo | 2002-09-16 | CONGO, DEMOCRATIC REPUBLIC OF THE | Barron-Birrell, Inc. 5363 | 1997-12-09 | Barron-Birrell, Inc. | Office of the Congo | ||||
16520 | 16520 | 2002-12-31 | Government of the Yukon Territory | 2001-03-27 | CANADA | Miller Thomson LLP 5422 | 2001-03-27 | Miller Thomson LLP | |||||
16521 | 16521 | 2002-12-31 | His Excellency Ibrahim Saminu Turaki, Governor Jigawa State, Nigeria | 2002-01-28 | NIGERIA | BKSH & Associates 5402 | 2000-12-14 | BKSH & Associates | Government House Dutse, Jigawa State | ||||
16522 | 16522 | 2002-12-31 | Hitachi, Ltd. | 1987-03-30 | JAPAN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
16523 | 16523 | 2002-12-31 | International Olive Oil Council | 2000-07-07 | INTERNATIONAL | Lane Marketing Communications 5377 | 2000-07-07 | Lane Marketing Communications | Principe de Vergara, 154 28002 | ||||
16524 | 16524 | 2002-12-31 | Republic of Costa Rica | 2001-10-02 | COSTA RICA | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | San Jose | ||||
16525 | 16525 | 2002-12-31 | Rome Cavalien Hilton | 2002-06-07 | ITALY | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | Via Cadlolo, 101, 00136 Rome | ||||
16526 | 16526 | 2002-12-31 | Taipei Economic and Cultural Representative Office (TECRO) | 2002-06-10 | TAIWAN | Downen, Robert L. 5502 | 2002-06-10 | Downen, Robert L. | 4201 Wisconsin Avenue, N.W. 20016 | DC | |||
16527 | 16527 | 2002-12-31 | Vela International Marine Limited | 2002-07-09 | SAUDI ARABIA | Scott, Thomas J. 5509 | 2002-07-09 | Scott, Thomas J. | Vela International Marine Limited, Tower Building, Room T-1031, Dhahran, 31311 |
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]) );