FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where "Foreign_Principal_Termination_Date" is on date 2001-02-28 sorted by City
This data as json, CSV (advanced)
Registrant_Name 10
- Dalley, George A. 1
- Denison, George H. 1
- Eastern Caribbean Investment Promotion Service 1
- Hakuhodo Incorporated 1
- Hill and Knowlton Strategies, LLC 1
- International Trade & Development Agency, Inc. 1
- Jellinek, Schwartz & Connolly, Inc. 1
- Pillsbury Winthrop L.L.P. 1
- Shandwick USA, Inc. 1
- Somaliland Liaison Mission 1
Foreign_Principal 10
- Government of Jamaica, Embassy 1
- Government of the Republic of Somaliland 1
- Government of the Republic of the Marshall Islands, Embassy 1
- Islamic Republic of Mauritania 1
- Japan Automobile Manufacturers' Association (JAMA) 1
- Japanese Government Prime Ministers Office 1
- Ministry of Economic Affairs, Tourism, Social Affairs and Culture of Aruba 1
- Ministry of Finance, Chile 1
- Organization of Eastern Caribbean States 1
- Royal Thai Embassy 1
Country/Location_Represented 9
- JAPAN 2
- ARUBA 1
- CHILE 1
- INTERNATIONAL 1
- JAMAICA 1
- MARSHALL ISLANDS 1
- MAURITANIA 1
- SOMALI DEMOCRATIC REPUBLIC 1
- THAILAND 1
City 1
- - 10
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3038 | 3038 | 2001-02-28 | Japan Automobile Manufacturers' Association (JAMA) | 1993-07-01 | JAPAN | Jellinek, Schwartz & Connolly, Inc. 4345 | 1990-02-23 | Jellinek, Schwartz & Connolly, Inc. | Washington | DC | |||
3039 | 3039 | 2001-02-28 | Government of Jamaica, Embassy | 2000-10-23 | JAMAICA | Dalley, George A. 5393 | 2000-10-23 | Dalley, George A. | 1520 New Hampshire Avenue, N.W. 20036 | DC | |||
3040 | 3040 | 2001-02-28 | Government of the Republic of Somaliland | 2000-02-04 | SOMALI DEMOCRATIC REPUBLIC | Somaliland Liaison Mission 5357 | 2000-02-04 | Somaliland Liaison Mission | Hargeisa | ||||
3041 | 3041 | 2001-02-28 | Government of the Republic of the Marshall Islands, Embassy | 1998-10-30 | MARSHALL ISLANDS | Pillsbury Winthrop L.L.P. 5286 | 1998-10-30 | Pillsbury Winthrop L.L.P. | Embassy, 2433 Massachusetts Avenue, N.W. Washington, DC 20008 | ||||
3042 | 3042 | 2001-02-28 | Islamic Republic of Mauritania | 1996-10-03 | MAURITANIA | Denison, George H. 4991 | 1995-02-14 | Denison, George H. | Nouakchott | ||||
3043 | 3043 | 2001-02-28 | Japanese Government Prime Ministers Office | 2001-02-07 | JAPAN | Hakuhodo Incorporated 5409 | 2001-02-07 | Hakuhodo Incorporated | 1-6-1 Nagatacyo, Chiyoda-ku Tokyo 100-8914 | ||||
3044 | 3044 | 2001-02-28 | Ministry of Economic Affairs, Tourism, Social Affairs and Culture of Aruba | 1999-05-11 | ARUBA | Shandwick USA, Inc. 5315 | 1999-05-11 | Shandwick USA, Inc. | Oranjestad | ||||
3045 | 3045 | 2001-02-28 | Ministry of Finance, Chile | 1999-04-21 | CHILE | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Teatinos 120 Santiago | ||||
3046 | 3046 | 2001-02-28 | Organization of Eastern Caribbean States | 1988-01-14 | INTERNATIONAL | Eastern Caribbean Investment Promotion Service 4080 | 1988-01-14 | Eastern Caribbean Investment Promotion Service | Castries | ||||
3047 | 3047 | 2001-02-28 | Royal Thai Embassy | 1987-03-05 | THAILAND | International Trade & Development Agency, Inc. 3690 | 1985-06-13 | International Trade & Development Agency, Inc. | Washington | DC |
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]) );