FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where City = "" and Registration_Number = 5198
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Address_2, Foreign_Principal_Termination_Date (date)
Foreign_Principal 11
- Association of Cyprus Banks 1
- Barseback Kraft AB 1
- Cayman Islands Ministry of Financial Services, Commerce & Environment 1
- Empresa Estatal de Telecomunicaciones (Emetel) 1
- Empresa Nacional del Uranio, S.A. (ENUSA) 1
- Government of Georgia 1
- Government of Liechtenstein 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
- Secretaria de Economia 1
- iFLYTEK Co., Ltd. 1
Country/Location_Represented 11
- CAYMAN ISLANDS 1
- CHINA 1
- CYPRUS 1
- ECUADOR 1
- GEORGIA 1
- KOSOVA 1
- LIECHTENSTEIN 1
- MEXICO 1
- SAUDI ARABIA 1
- SPAIN 1
- SWEDEN 1
Registrant_Name 1
City 1
- - · 11 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 | ||||
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 | |||
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 |
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]) );