FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
22 rows where Registrant_Name = "Pillsbury Winthrop Shaw Pittman, LLP" sorted by Registrant_Name
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Foreign_Principal 22
- Association of Cyprus Banks 1
- Bangladesh Nationalist Party 1
- Barseback Kraft AB 1
- Cayman Islands Ministry of Financial Services, Commerce & Environment 1
- Cloud Innovation Ltd. and LARUS Limited 1
- Corporate Association of the Gaesong Industrial Complex (CAGIC) at the direction of South Korean consultancy HC & Sons LLC (HC & Sons) 1
- Embassy of Qatar 1
- Empresa Estatal de Telecomunicaciones (Emetel) 1
- Empresa Nacional del Uranio, S.A. (ENUSA) 1
- Government of Georgia 1
- Government of Liechtenstein 1
- Government of Taiwan (Taipei Economic and Cultural Representative Office) 1
- Government of the Republic of Korea, Embassy 1
- International Counsel Bureau, Kuwaiti Counsel for the Families of Kuwaiti Citizens at Guantanamo Bay 1
- Khamis Khanjar and Sarmad Khanjar 1
- King Abdullah City for Atomic and Renewable Energy (KACARE) 1
- Ministry of Energy, Industry, and Mineral Resources (MEIM) King Abdullah City for Atomic and Renewable Energy (K.A.CARE) 1
- Ministry of Foreign Affairs of Kosovo 1
- NSO Group 1
- Royal Embassy of Saudi Arabia 1
- Secretaria de Economia 1
- iFLYTEK Co., Ltd. 1
Address_1 22 ✖
- 15, Demetriou Karatasou Str., 1
- 16 Galgaley HaPlada Street 1
- 2450 Massachusetts Avenue, NW 1
- 2555 M Street, NW 1
- 4201 Wisconsin Avenue, NW 1
- 50 Fremont Street San Francisco 1
- 601 New Hampshire Avenue, NW 1
- Al Radwan Company 1
- Cloud:c/o Appleby Global Services (Seychelles) Limited 1
- Dasman Commercial Complex Block No. 3, 8th Floor 1
- Government Administration Building, Box 126 1
- Hefei City, No. 666 Wangjiang Road West 1
- LODDEKOPINGE 1
- Madrid 1
- Ministry of Foreign Affairs Building 1
- Naya Paltan 1
- P.O. Box 2022 Al Akaria Plaza Square, Entrance 2 1
- Postal Code 11191 1
- Quito 1
- Regierrungsgebaude, FL - 4940 Vaduz 1
- Suite 706 Kbiz Bldg. 1
- Tbilisi, Georgia 0175 1
Country/Location_Represented 19
- SAUDI ARABIA 3
- KOREA, SOUTH 2
- BANGLADESH 1
- CAYMAN ISLANDS 1
- CHINA 1
- CYPRUS 1
- ECUADOR 1
- GEORGIA 1
- INTERNATIONAL 1
- IRAQ 1
- ISRAEL 1
- KOSOVA 1
- KUWAIT 1
- LIECHTENSTEIN 1
- MEXICO 1
- QATAR 1
- SPAIN 1
- SWEDEN 1
- TAIWAN 1
Registrant_Name 1
- Pillsbury Winthrop Shaw Pittman, LLP · 22 ✖
Registrant_Date (date) 1 ✖
- 1997-07-31 22
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
118 | 118 | Cloud Innovation Ltd. and LARUS Limited | 2021-11-19 | INTERNATIONAL | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Cloud:c/o Appleby Global Services (Seychelles) Limited | Suite 202,2nd Floor,Eden Plaza,Eden Island,Mahe,Seychelles; LARUS: A3,ll/F,TML Tower,Tsuen Wan,N.T, | HONG KONG | |||
186 | 186 | Embassy of Qatar | 2018-03-23 | QATAR | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | 2555 M Street, NW | Washington | DC | 20037 | ||
508 | 508 | NSO Group | 2021-06-30 | ISRAEL | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | 16 Galgaley HaPlada Street | 4672216 | Herzelia | |||
630 | 630 | Secretaria de Economia | 1998-04-09 | MEXICO | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | 50 Fremont Street San Francisco | CA | ||||
767 | 767 | iFLYTEK Co., Ltd. | 2019-06-26 | CHINA | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Hefei City, No. 666 Wangjiang Road West | Anhui Province | ||||
1175 | 1175 | 2016-01-09 | International Counsel Bureau, Kuwaiti Counsel for the Families of Kuwaiti Citizens at Guantanamo Bay | 2006-08-07 | KUWAIT | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Dasman Commercial Complex Block No. 3, 8th Floor | P.O. Box 20941, Safat 13070 | Sharq | ||
1482 | 1482 | 2015-01-23 | King Abdullah City for Atomic and Renewable Energy (KACARE) | 2011-10-17 | SAUDI ARABIA | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | P.O. Box 2022 Al Akaria Plaza Square, Entrance 2 | Riyadh | |||
1813 | 1813 | 1998-01-31 | Barseback Kraft AB | 1997-11-12 | SWEDEN | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | LODDEKOPINGE | ||||
1815 | 1815 | 1998-01-31 | Empresa Nacional del Uranio, S.A. (ENUSA) | 1997-11-12 | SPAIN | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Madrid | ||||
2069 | 2069 | 2008-02-01 | Bangladesh Nationalist Party | 2007-06-13 | BANGLADESH | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Naya Paltan | Dhaka | |||
4762 | 4762 | 2016-03-31 | Royal Embassy of Saudi Arabia | 2015-03-26 | SAUDI ARABIA | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | 601 New Hampshire Avenue, NW | Washington | DC | 20037 | |
9382 | 9382 | 1998-07-20 | Empresa Estatal de Telecomunicaciones (Emetel) | 1997-07-31 | ECUADOR | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Quito | ||||
9835 | 9835 | 2001-07-31 | Government of Liechtenstein | 2000-05-25 | LIECHTENSTEIN | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Regierrungsgebaude, FL - 4940 Vaduz | ||||
9936 | 9936 | 2020-07-31 | Association of Cyprus Banks | 2019-08-28 | CYPRUS | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | 15, Demetriou Karatasou Str., | 4th Floor, Flat 401 Nicosia 2024 | |||
9938 | 9938 | 2020-07-31 | Ministry of Foreign Affairs of Kosovo | 2018-09-10 | KOSOVA | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Ministry of Foreign Affairs Building | Str. Luan Haradinaj" No. 32 10000 Pristina " | |||
10545 | 10545 | 2017-08-15 | Government of Georgia | 2015-04-24 | GEORGIA | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Tbilisi, Georgia 0175 | P. Ingorovka Str. N7 | |||
10772 | 10772 | 2022-08-26 | Ministry of Energy, Industry, and Mineral Resources (MEIM) King Abdullah City for Atomic and Renewable Energy (K.A.CARE) | 2018-02-20 | SAUDI ARABIA | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Postal Code 11191 | Riyadh MEIM | |||
12590 | 12590 | 2022-10-10 | Corporate Association of the Gaesong Industrial Complex (CAGIC) at the direction of South Korean consultancy HC & Sons LLC (HC & Sons) | 2021-07-21 | KOREA, SOUTH | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Suite 706 Kbiz Bldg. | 30 Eunhaeng-ro Yeongdeungpo-gu | Seoul | ||
13454 | 13454 | 2011-10-31 | Government of Taiwan (Taipei Economic and Cultural Representative Office) | 2010-12-15 | TAIWAN | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | 4201 Wisconsin Avenue, NW | Washington | DC | 20016 | |
14849 | 14849 | 2019-12-06 | Khamis Khanjar and Sarmad Khanjar | 2019-06-10 | IRAQ | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Al Radwan Company | Mishmisheh Building 14 Ramadan Street, Mansur District | Baghdad | ||
16870 | 16870 | 2020-12-31 | Cayman Islands Ministry of Financial Services, Commerce & Environment | 2016-09-02 | CAYMAN ISLANDS | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Government Administration Building, Box 126 | 133 Elgin Avenue, Grand Cayman KY1-9000 | |||
16925 | 16925 | 2022-12-31 | Government of the Republic of Korea, Embassy | 2011-11-10 | KOREA, SOUTH | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 |
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]) );