FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
28 rows where Foreign_Principal_Termination_Date = "2006-03-31" sorted by Foreign_Principal_Termination_Date
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Address_1, Address_2, Zip, Foreign_Principal_Termination_Date (date), Registrant_Date (date)
Foreign_Principal 28
- Atlantic Canadian Tourism Partnership 1
- Citigate Public Affairs 1
- Embassy of El Salvador 1
- Embassy of the Republic of Korea (a U.S. treaty ally) 1
- Government of Abu Dhabi 1
- Government of Honduras, Embassy, Comision Nacional De Administracion de Cuotas Textiles y Prendas de Vestir 1
- Government of Sweden 1
- Inchcape Shipping Services (through ISS Marine Services, Inc.) 1
- Japan National Tourist Organization 1
- Kingdom of Morocco 1
- Ministerio de Economia Republica de El Salvador 1
- Panama National Economic Council 1
- Poland Ministry of Privatization 1
- Republic of Bulgaria 1
- Republic of Costa Rica 1
- Republic of Finland 1
- Republic of Gabon 1
- Republic of Hungary 1
- Republic of Macedonia 1
- Republic of Singapore 1
- Republic of South Africa 1
- Republic of Ukraine 1
- Republic of the Philippines 1
- State Bank of Vietnam 1
- State of Qatar 1
- Transitional Federal Government of Somalia Republic 1
- Ulster Unionist Council 1
- Welsh Development Agency 1
Country/Location_Represented 25
- EL SALVADOR 2
- GREAT BRITAIN 2
- UNITED ARAB EMIRATES 2
- BULGARIA 1
- CANADA 1
- COSTA RICA 1
- FINLAND 1
- GABON 1
- HONDURAS 1
- HUNGARY 1
- JAPAN 1
- KOREA, SOUTH 1
- MACEDONIA 1
- MOROCCO 1
- NORTHERN IRELAND 1
- PANAMA 1
- PHILIPPINES 1
- POLAND 1
- QATAR 1
- SINGAPORE 1
- SOMALI DEMOCRATIC REPUBLIC 1
- SOUTH AFRICA 1
- SWEDEN 1
- UKRAINE 1
- VIETNAM 1
Foreign_Principal_Registration_Date (date) 21 ✖
- 2006-05-31 5
- 2005-11-01 3
- 2005-03-07 2
- 1972-07-03 1
- 1978-05-02 1
- 1979-01-24 1
- 1985-05-16 1
- 1986-04-24 1
- 1992-04-09 1
- 1993-07-29 1
- 1995-09-07 1
- 1996-04-24 1
- 1999-03-02 1
- 1999-12-16 1
- 2002-03-04 1
- 2002-10-18 1
- 2004-04-16 1
- 2004-05-06 1
- 2005-04-14 1
- 2005-08-31 1
- 2006-03-31 1
Registrant_Name 12
- White & Case, LLP 16
- Sandler, Travis & Rosenberg, P.A. 2
- AWS Services 1
- Bannerman & Associates, Inc. 1
- Hill and Knowlton Strategies, LLC 1
- International Policy Solutions, LLC 1
- Japan National Tourist Organization, San Francisco 1
- Korea - U.S. Consulting, Inc. (KCI) 1
- M. Silver Associates, Inc. 1
- Schmeltzer, Aptaker & Shepard, P.C. 1
- State Affairs Company 1
- Welsh Development Agency 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4646 | 4646 | 2006-03-31 | Atlantic Canadian Tourism Partnership | 2005-08-31 | CANADA | M. Silver Associates, Inc. 3131 | 1980-07-15 | M. Silver Associates, Inc. | P.O. Box 2050 Chalottetown, PE Canada C1A 7N7 | ||||
4647 | 4647 | 2006-03-31 | Citigate Public Affairs | 2005-03-07 | GREAT BRITAIN | State Affairs Company 5674 | 2005-03-07 | State Affairs Company | 26 Grosvenor Gardens London | ||||
4648 | 4648 | 2006-03-31 | Embassy of El Salvador | 1993-07-29 | EL SALVADOR | Bannerman & Associates, Inc. 3964 | 1987-04-28 | Bannerman & Associates, Inc. | Washington | DC | |||
4649 | 4649 | 2006-03-31 | Embassy of the Republic of Korea (a U.S. treaty ally) | 2002-03-04 | KOREA, SOUTH | Korea - U.S. Consulting, Inc. (KCI) 5480 | 2002-03-04 | Korea - U.S. Consulting, Inc. (KCI) | 2450 Massachusetts Avenue, N.W. 20008 | DC | |||
4650 | 4650 | 2006-03-31 | Government of Abu Dhabi | 2006-05-31 | UNITED ARAB EMIRATES | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | Adwea Building | P.O. Box 6120 Abu Dhabi | |||
4651 | 4651 | 2006-03-31 | Government of Honduras, Embassy, Comision Nacional De Administracion de Cuotas Textiles y Prendas de Vestir | 1999-03-02 | HONDURAS | Schmeltzer, Aptaker & Shepard, P.C. 5304 | 1999-03-02 | Schmeltzer, Aptaker & Shepard, P.C. | 3007 Tilden Street, N.W. | DC | |||
4652 | 4652 | 2006-03-31 | Government of Sweden | 2006-05-31 | SWEDEN | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | Box 240 | Stockholm 101 24 | |||
4653 | 4653 | 2006-03-31 | Inchcape Shipping Services (through ISS Marine Services, Inc.) | 2006-03-31 | UNITED ARAB EMIRATES | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 2180 North Loop West | Houston | TX | 77018-8014 | |
4654 | 4654 | 2006-03-31 | Japan National Tourist Organization | 1972-07-03 | JAPAN | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | Tokyo | ||||
4655 | 4655 | 2006-03-31 | Kingdom of Morocco | 1985-05-16 | MOROCCO | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | Rabat | ||||
4656 | 4656 | 2006-03-31 | Ministerio de Economia Republica de El Salvador | 2002-10-18 | EL SALVADOR | Sandler, Travis & Rosenberg, P.A. 5303 | 1998-12-07 | Sandler, Travis & Rosenberg, P.A. | Alameda Juan Pablo II y Calle Guadalupe, Edif, C-2 Plan Maestro, Centro de Gabierno San Salvador, C | ||||
4657 | 4657 | 2006-03-31 | Panama National Economic Council | 2004-05-06 | PANAMA | Sandler, Travis & Rosenberg, P.A. 5303 | 1998-12-07 | Sandler, Travis & Rosenberg, P.A. | Apartado Postal 9658 Panama 4 Panama City | ||||
4658 | 4658 | 2006-03-31 | Poland Ministry of Privatization | 2004-04-16 | POLAND | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | Ministry of Economy Ministerstwo Gospodarki Department Handlu; USLUG Plac Trzech Krzyzy 3/5; 00-50 | ||||
4659 | 4659 | 2006-03-31 | Republic of Bulgaria | 1992-04-09 | BULGARIA | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | Sofia | ||||
4660 | 4660 | 2006-03-31 | Republic of Costa Rica | 2005-11-01 | COSTA RICA | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | Avenida 3a Calle 40 | Apartado 1278-1007 | San Jose | ||
4661 | 4661 | 2006-03-31 | Republic of Finland | 2006-05-31 | FINLAND | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | Snell Maninkatu 1A | Helsinki 00023 | |||
4662 | 4662 | 2006-03-31 | Republic of Gabon | 1978-05-02 | GABON | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | Libreville | ||||
4663 | 4663 | 2006-03-31 | Republic of Hungary | 2006-05-31 | HUNGARY | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | Csalogany U 9-11 | Budapest, H-1027 | |||
4664 | 4664 | 2006-03-31 | Republic of Macedonia | 2005-11-01 | MACEDONIA | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | Dame Cruev 14, 1000 Skopje | ||||
4665 | 4665 | 2006-03-31 | Republic of Singapore | 1979-01-24 | SINGAPORE | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | |||||
4666 | 4666 | 2006-03-31 | Republic of South Africa | 2006-05-31 | SOUTH AFRICA | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 399 Duncan Street | Hatfield 0083 | |||
4667 | 4667 | 2006-03-31 | Republic of Ukraine | 1999-12-16 | UKRAINE | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | Head of External Debt Department Ministry of Finance Klev | ||||
4668 | 4668 | 2006-03-31 | Republic of the Philippines | 2005-04-14 | PHILIPPINES | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | Office of the Solicitor General | ||||
4669 | 4669 | 2006-03-31 | State Bank of Vietnam | 1996-04-24 | VIETNAM | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | Hanoi | ||||
4670 | 4670 | 2006-03-31 | State of Qatar | 2005-11-01 | QATAR | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | Supreme Council Box 23224 | Doha State | |||
4671 | 4671 | 2006-03-31 | Transitional Federal Government of Somalia Republic | 2005-03-07 | SOMALI DEMOCRATIC REPUBLIC | International Policy Solutions, LLC 5672 | 2005-03-07 | International Policy Solutions, LLC | P.O. Box 415 - 00606 Nairobi, Kenya | ||||
4672 | 4672 | 2006-03-31 | Ulster Unionist Council | 1995-09-07 | NORTHERN IRELAND | AWS Services 5043 | 1995-09-07 | AWS Services | Belfast | ||||
4673 | 4673 | 2006-03-31 | Welsh Development Agency | 1986-04-24 | GREAT BRITAIN | Welsh Development Agency 3819 | 1986-04-24 | Welsh Development Agency |
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]) );