FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where City = "" and Registration_Number = 6227
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Address_2, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Foreign_Principal 17
- Abu Dhabi Future Energy Company PJ3C Masdar 1
- Consejo de PromocionTuristica de Mexico, S.A. de C.V. 1
- Delano Family Limited 1
- Department of Culture and Tourism - Abu Dhabi 1
- Ennahdha Party 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
- Republic of the Philippines 1
- SES Holding Pte.Ltd. 1
- The Government of the Republic of the Philippines 1
- Top Sport 1
Address_1 14 ✖
- - 4
- 1 Robinson Road 1
- 10 Pasir Panjang Road #10-01 Mapletree Business City 1
- 43, Section 3, Volgogradskiy Prospect 1
- 6 Bawku Street, Wuse 2, Abuja 1
- 8th Floor Business Centre 4, Wing B 1
- 9-12, Kita - Shinagawa 5-chome 1
- A. Mabini corner P. Ocampo Sr. Streets, Malate, Manila 1
- Bantian Huawei Base, Longgang District 1
- DOF Building, BSP Complex, Roxas Blvd., 1004 Metro Manila 1
- NEOM Company 1
- PO Box 54115 1
- PO Box 94000 1
- Viaducto Miguel Aleman No. 105 1
Country/Location_Represented 10
- PHILIPPINES 3
- SINGAPORE 3
- UNITED ARAB EMIRATES 3
- SAUDI ARABIA 2
- CHINA 1
- JAPAN 1
- MEXICO 1
- NIGERIA 1
- RUSSIA 1
- TUNISIA 1
State 1
- - 17
Registrant_Name 1
- BCW LLC 17
Registrant_Date (date) 1 ✖
- 2014-06-18 17
City 1
- - · 17 ✖
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 | ||||||
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 | |||
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]) );