FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where "Foreign_Principal_Termination_Date" is on date 2006-08-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Address_1, Address_2, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 13
- Asian Development Bank 1
- Civil Aviation Authority of Macau 1
- Embassy of Republic of the Philippines 1
- Government of Pakistan 1
- Instituto Nacional de Aviacao Civil (INAC) 1
- International Counsel Bureau, Kuwaiti Counsel for the families of Kuwaiti Citizens at Guantanamo Bay 1
- Joint Committee on Compact Economic Negotiations, Micronesia 1
- Liaoning Province Government 1
- Philippine Chamber of Commerce and Industry 1
- Republic of Cyprus, Embassy 1
- Republic of Cyprus, Embassy through Covington & Burling 1
- Taiwan Studies Institute 1
- United Lao Council for Peace, Freedom and Reconstruction 1
Country/Location_Represented 11
- CYPRUS 2
- PHILIPPINES 2
- CHINA 1
- INTERNATIONAL 1
- KUWAIT 1
- LAOS 1
- MACAU 1
- MICRONESIA 1
- PAKISTAN 1
- PORTUGAL 1
- TAIWAN 1
Registrant_Name 9
- Zuckert, Scoutt & Rasenberger, L.L.P. 3
- Prism Public Affairs 2
- Stanton Communications 2
- Chadbourne & Parke, LLP 1
- Federalist Group, an Ogilvy PR Worldwide Company 1
- Hill and Knowlton Strategies, LLC 1
- Hogan Lovells US LLP 1
- Shearman & Sterling, LLP 1
- United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) 1
City 4
- - 10
- Islamabad 1
- Pasay City 1
- Washington 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11096 | 11096 | 2006-08-31 | Asian Development Bank | 2005-05-18 | INTERNATIONAL | Chadbourne & Parke, LLP 5685 | 2005-05-18 | Chadbourne & Parke, LLP | 6 ADB Avenue, P.O. Box 789 City of Mandaluyong | Manila 0980 | |||
11097 | 11097 | 2006-08-31 | Civil Aviation Authority of Macau | 1994-08-01 | MACAU | Zuckert, Scoutt & Rasenberger, L.L.P. 4933 | 1994-08-01 | Zuckert, Scoutt & Rasenberger, L.L.P. | |||||
11100 | 11100 | 2006-08-31 | Instituto Nacional de Aviacao Civil (INAC) | 2003-08-20 | PORTUGAL | Zuckert, Scoutt & Rasenberger, L.L.P. 4933 | 1994-08-01 | Zuckert, Scoutt & Rasenberger, L.L.P. | Rua B. Edificio 4, 5, 6, Aeroporta da Portela 1749-034 Lisbon | ||||
11101 | 11101 | 2006-08-31 | International Counsel Bureau, Kuwaiti Counsel for the families of Kuwaiti Citizens at Guantanamo Bay | 2005-02-25 | KUWAIT | Shearman & Sterling, LLP 5670 | 2005-02-25 | Shearman & Sterling, LLP | Dasman Commercial Complex Block No. 3, 8th Floor P.O. Box 20941 Safat 13070 Sharq | ||||
11102 | 11102 | 2006-08-31 | Joint Committee on Compact Economic Negotiations, Micronesia | 2002-05-29 | MICRONESIA | Zuckert, Scoutt & Rasenberger, L.L.P. 4933 | 1994-08-01 | Zuckert, Scoutt & Rasenberger, L.L.P. | Palikir Pohnpei Federated States of Micronesia, FM 96941 | ||||
11103 | 11103 | 2006-08-31 | Liaoning Province Government | 2003-12-31 | CHINA | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | Legal Affairs Office of Liaoning Province Government #45 Beiling Avenue, Shenyang 110032, P.R. | ||||
11105 | 11105 | 2006-08-31 | Republic of Cyprus, Embassy through Covington & Burling | 2004-06-17 | CYPRUS | Federalist Group, an Ogilvy PR Worldwide Company 5628 | 2004-06-17 | Federalist Group, an Ogilvy PR Worldwide Company | 2211 R Street, N.W. 20008 | DC | |||
11106 | 11106 | 2006-08-31 | Republic of Cyprus, Embassy | 2004-05-07 | CYPRUS | Prism Public Affairs 5620 | 2004-05-07 | Prism Public Affairs | 2211 R Street, N.W. 20008 | DC | |||
11107 | 11107 | 2006-08-31 | Taiwan Studies Institute | 2006-04-24 | TAIWAN | Prism Public Affairs 5620 | 2004-05-07 | Prism Public Affairs | 134 Hsichang Street | Taipei, Taiwan | |||
11108 | 11108 | 2006-08-31 | United Lao Council for Peace, Freedom and Reconstruction | 2004-08-11 | LAOS | United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) 5639 | 2004-08-11 | United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) | Mouang Nyeum, Borikhamsai | ||||
11099 | 11099 | 2006-08-31 | Government of Pakistan | 2005-09-26 | PAKISTAN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Information and Broadcasting Division | 4th Floor - Cabinet Block | Islamabad | ||
11104 | 11104 | 2006-08-31 | Philippine Chamber of Commerce and Industry | 2005-12-23 | PHILIPPINES | Stanton Communications 5724 | 2005-12-23 | Stanton Communications | Philippine International Convention Center (PICC) | Secretariat Building, CCP Complex, Roxas Boulevard | Pasay City | ||
11098 | 11098 | 2006-08-31 | Embassy of Republic of the Philippines | 2005-12-23 | PHILIPPINES | Stanton Communications 5724 | 2005-12-23 | Stanton Communications | 1600 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]) );