FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
22 rows where Registration_Number = 6227 sorted by Address_2
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Address_2, Zip, Foreign_Principal_Termination_Date (date)
Foreign_Principal_Registration_Date (date) 22 ✖
- 2014-06-18 1
- 2014-06-23 1
- 2014-09-18 1
- 2016-05-11 1
- 2016-05-31 1
- 2017-01-27 1
- 2017-05-09 1
- 2017-11-28 1
- 2018-08-01 1
- 2018-09-06 1
- 2018-09-26 1
- 2018-12-03 1
- 2019-03-20 1
- 2019-06-12 1
- 2020-04-30 1
- 2020-05-13 1
- 2020-07-02 1
- 2021-08-03 1
- 2021-12-13 1
- 2022-02-15 1
- 2022-03-29 1
- 2022-09-22 1
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
Address_1 19 ✖
- - 4
- 1 Robinson Road 1
- 10 Pasir Panjang Road #10-01 Mapletree Business City 1
- 18639 Railroad Street 1
- 2525 Massachusetts Avenue, NW 1
- 3655 Torrance Blvd. Suite 300 1
- 43, Section 3, Volgogradskiy Prospect 1
- 55 Bryanston Street 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
- Abu Dhabi National Oil Company Headquarters Building 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 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
Registrant_Date (date) 1 ✖
- 2014-06-18 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | |||||
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 | |||||
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 | ||||
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 | ||||
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 | |||||
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 | |||
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 | ||||
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 | |||
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 | ||
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. | |||
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 | ||
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 | |||
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 | ||||
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 | |||
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 | |||
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 |
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]) );