FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
22 rows where Registration_Number = 6227
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Address_1, Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 22
- Abu Dhabi Future Energy Company PJ3C Masdar 1
- Beltway Government Strategies Inc. (for the Office of the Monitoring MP for the Ministry of External Affairs of Sri Lanka) 1
- Consejo de PromocionTuristica de Mexico, S.A. de C.V. 1
- Delano Family Limited 1
- Department of Culture and Tourism - Abu Dhabi 1
- Embassy of the Republic of Turkey 1
- Ennahdha Party 1
- Ennahdha Party Diaspora Group 1
- Government Technology Agency of Singapore 1
- Government Technology Agency of Singapore (via BCW Asia Pacific) 1
- Government of Ras Al Khaimah 1
- Government of the Republic of the Philippines 1
- Huawei Technologies Co. Ltd. (via BCW Asia Pacific) 1
- International Military Counter Terrorism Coalition Center (IMCTC) 1
- Kobe Steel, Ltd. 1
- NEOM Company 1
- Office of United Arab (UAE) Climate Change Special Envoy 1
- Republic of the Philippines 1
- SES Holding Pte.Ltd. 1
- The Government of the Republic of the Philippines 1
- Top Sport 1
- Hikvision USA Inc. as an agent of Hikvision 1
Country/Location_Represented 12
- UNITED ARAB EMIRATES 4
- PHILIPPINES 3
- SINGAPORE 3
- CHINA 2
- SAUDI ARABIA 2
- TUNISIA 2
- JAPAN 1
- MEXICO 1
- NIGERIA 1
- RUSSIA 1
- SRI LANKA 1
- TURKEY 1
City 6
- - 17
- Abu Dhabi 1
- City of Industry 1
- London 1
- Torrance 1
- Washington 1
Registrant_Name 1
- BCW LLC 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25 | 25 | Abu Dhabi Future Energy Company PJ3C Masdar | 2022-09-22 | UNITED ARAB EMIRATES | BCW LLC 6227 | 2014-06-18 | BCW LLC | PO Box 54115 | Abu Dhabi | ||||
| 140 | 140 | Department of Culture and Tourism - Abu Dhabi | 2022-03-29 | UNITED ARAB EMIRATES | BCW LLC 6227 | 2014-06-18 | BCW LLC | PO Box 94000 | Nation Towers Offices, Corniche, Abu Dhabi | ||||
| 293 | 293 | Government of Ras Al Khaimah | 2019-06-12 | UNITED ARAB EMIRATES | BCW LLC 6227 | 2014-06-18 | BCW LLC | 8th Floor Business Centre 4, Wing B | RAK Free Trade Zone Authority AL Nakheel Ras Al Khaimah | ||||
| 695 | 695 | The Government of the Republic of the Philippines | 2020-04-30 | PHILIPPINES | BCW LLC 6227 | 2014-06-18 | BCW LLC | ||||||
| 765 | 765 | Hikvision USA Inc. as an agent of Hikvision | 2018-08-01 | CHINA | BCW LLC 6227 | 2014-06-18 | BCW LLC | 18639 Railroad Street | City of Industry | CA | 91748 | ||
| 1043 | 1043 | 2022-01-01 | Ennahdha Party Diaspora Group | 2021-08-03 | TUNISIA | BCW LLC 6227 | 2014-06-18 | BCW LLC | 55 Bryanston Street | Marble Arch Tower W1H | London | ||
| 1045 | 1045 | 2022-01-01 | Office of United Arab (UAE) Climate Change Special Envoy | 2021-12-13 | UNITED ARAB EMIRATES | BCW LLC 6227 | 2014-06-18 | BCW LLC | Abu Dhabi National Oil Company Headquarters Building | Corniche Road | Abu Dhabi | ||
| 1172 | 1172 | 2015-01-09 | Beltway Government Strategies Inc. (for the Office of the Monitoring MP for the Ministry of External Affairs of Sri Lanka) | 2014-06-23 | SRI LANKA | BCW LLC 6227 | 2014-06-18 | BCW LLC | 3655 Torrance Blvd. Suite 300 | Torrance | CA | 90503 | |
| 1920 | 1920 | 2019-01-31 | Government Technology Agency of Singapore (via BCW Asia Pacific) | 2020-05-13 | SINGAPORE | BCW LLC 6227 | 2014-06-18 | BCW LLC | |||||
| 1921 | 1921 | 2019-01-31 | Government Technology Agency of Singapore | 2018-12-03 | SINGAPORE | BCW LLC 6227 | 2014-06-18 | BCW LLC | 10 Pasir Panjang Road #10-01 Mapletree Business City | Singapore 117438 | |||
| 2580 | 2580 | 2022-02-15 | SES Holding Pte.Ltd. | 2022-02-15 | SINGAPORE | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1 Robinson Road | #18-00 A/A Tower | |||
| 3130 | 3130 | 2018-02-28 | International Military Counter Terrorism Coalition Center (IMCTC) | 2017-01-27 | SAUDI ARABIA | BCW LLC 6227 | 2014-06-18 | BCW LLC | |||||
| 4784 | 4784 | 2019-03-31 | Huawei Technologies Co. Ltd. (via BCW Asia Pacific) | 2019-03-20 | CHINA | BCW LLC 6227 | 2014-06-18 | BCW LLC | Bantian Huawei Base, Longgang District | Shenzhen, 518129 | |||
| 6613 | 6613 | 2014-05-16 | Delano Family Limited | 2014-06-18 | NIGERIA | BCW LLC 6227 | 2014-06-18 | BCW LLC | 6 Bawku Street, Wuse 2, Abuja | ||||
| 7284 | 7284 | 2019-05-31 | Republic of the Philippines | 2018-09-06 | PHILIPPINES | BCW LLC 6227 | 2014-06-18 | BCW LLC | DOF Building, BSP Complex, Roxas Blvd., 1004 Metro Manila | ||||
| 9227 | 9227 | 2020-07-13 | NEOM Company | 2020-07-02 | SAUDI ARABIA | BCW LLC 6227 | 2014-06-18 | BCW LLC | NEOM Company | Information Technology & Communication Complex (ITCC) 2nd Floor Building IN-01, Al Nakeel Dist. | |||
| 10051 | 10051 | 2016-08-01 | Top Sport | 2016-05-31 | RUSSIA | BCW LLC 6227 | 2014-06-18 | BCW LLC | 43, Section 3, Volgogradskiy Prospect | Moscow 109316 | |||
| 11177 | 11177 | 2019-08-31 | Government of the Republic of the Philippines | 2018-09-26 | PHILIPPINES | BCW LLC 6227 | 2014-06-18 | BCW LLC | A. Mabini corner P. Ocampo Sr. Streets, Malate, Manila | ||||
| 13498 | 13498 | 2019-10-31 | Kobe Steel, Ltd. | 2017-11-28 | JAPAN | BCW LLC 6227 | 2014-06-18 | BCW LLC | 9-12, Kita - Shinagawa 5-chome | Shinagawa-ku Tokyo 141-8688 | |||
| 16799 | 16799 | 2017-12-31 | Consejo de PromocionTuristica de Mexico, S.A. de C.V. | 2016-05-11 | MEXICO | BCW LLC 6227 | 2014-06-18 | BCW LLC | Viaducto Miguel Aleman No. 105 | Colonia Escandon, Delegacion Miguel Hidalgo, CP 11800 Mexico Distrito Federal | |||
| 16802 | 16802 | 2017-12-31 | Embassy of the Republic of Turkey | 2017-05-09 | TURKEY | BCW LLC 6227 | 2014-06-18 | BCW LLC | 2525 Massachusetts Avenue, NW | Washington | DC | 20008 | |
| 16874 | 16874 | 2020-12-31 | Ennahdha Party | 2014-09-18 | TUNISIA | BCW LLC 6227 | 2014-06-18 | BCW LLC |
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]) );