FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 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
- 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
- Embassy of the Republic of Turkey 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
- Hikvision USA, Inc. 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
- The Government of the Republic of the Philippines 1
- Top Sport 1
Country/Location_Represented
- PHILIPPINES 3
- CHINA 2
- SAUDI ARABIA 2
- SINGAPORE 2
- JAPAN 1
- MEXICO 1
- NIGERIA 1
- RUSSIA 1
- SRI LANKA 1
- TUNISIA 1
- TURKEY 1
- UNITED ARAB EMIRATES 1
City
- - 14
- City of Industry 1
- Torrance 1
- Washington 1
Registrant_Name
- BCW LLC 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 273 | 273 | Government of Ras Al Khaimah | 2019-06-12 | UNITED ARAB EMIRATES | 6227 6227 | 2014-06-18 | BCW LLC | 8th Floor Business Centre 4, Wing B | RAK Free Trade Zone Authority AL Nakheel Ras Al Khaimah | ||||
| 304 | 304 | Hikvision USA, Inc. | 2018-08-01 | CHINA | 6227 6227 | 2014-06-18 | BCW LLC | 18639 Railroad Street | City of Industry | CA | 91748 | ||
| 634 | 634 | The Government of the Republic of the Philippines | 2020-04-30 | PHILIPPINES | 6227 6227 | 2014-06-18 | BCW LLC | ||||||
| 1072 | 1072 | 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 | 6227 6227 | 2014-06-18 | BCW LLC | 3655 Torrance Blvd. Suite 300 | Torrance | CA | 90503 | |
| 1807 | 1807 | 2019-01-31 | Government Technology Agency of Singapore (via BCW Asia Pacific) | 2020-05-13 | SINGAPORE | 6227 6227 | 2014-06-18 | BCW LLC | |||||
| 1808 | 1808 | 2019-01-31 | Government Technology Agency of Singapore | 2018-12-03 | SINGAPORE | 6227 6227 | 2014-06-18 | BCW LLC | 10 Pasir Panjang Road #10-01 Mapletree Business City | Singapore 117438 | |||
| 2983 | 2983 | 2018-02-28 | International Military Counter Terrorism Coalition Center (IMCTC) | 2017-01-27 | SAUDI ARABIA | 6227 6227 | 2014-06-18 | BCW LLC | |||||
| 4590 | 4590 | 2019-03-31 | Huawei Technologies Co. Ltd. (via BCW Asia Pacific) | 2019-03-20 | CHINA | 6227 6227 | 2014-06-18 | BCW LLC | Bantian Huawei Base, Longgang District | Shenzhen, 518129 | |||
| 6336 | 6336 | 2014-05-16 | Delano Family Limited | 2014-06-18 | NIGERIA | 6227 6227 | 2014-06-18 | BCW LLC | 6 Bawku Street, Wuse 2, Abuja | ||||
| 6997 | 6997 | 2019-05-31 | Republic of the Philippines | 2018-09-06 | PHILIPPINES | 6227 6227 | 2014-06-18 | BCW LLC | DOF Building, BSP Complex, Roxas Blvd., 1004 Metro Manila | ||||
| 8874 | 8874 | 2020-07-13 | NEOM Company | 2020-07-02 | SAUDI ARABIA | 6227 6227 | 2014-06-18 | BCW LLC | NEOM Company | Information Technology & Communication Complex (ITCC) 2nd Floor Building IN-01, Al Nakeel Dist. | |||
| 9683 | 9683 | 2016-08-01 | Top Sport | 2016-05-31 | RUSSIA | 6227 6227 | 2014-06-18 | BCW LLC | 43, Section 3, Volgogradskiy Prospect | Moscow 109316 | |||
| 10786 | 10786 | 2019-08-31 | Government of the Republic of the Philippines | 2018-09-26 | PHILIPPINES | 6227 6227 | 2014-06-18 | BCW LLC | A. Mabini corner P. Ocampo Sr. Streets, Malate, Manila | ||||
| 13027 | 13027 | 2019-10-31 | Kobe Steel, Ltd. | 2017-11-28 | JAPAN | 6227 6227 | 2014-06-18 | BCW LLC | 9-12, Kita - Shinagawa 5-chome | Shinagawa-ku Tokyo 141-8688 | |||
| 16269 | 16269 | 2017-12-31 | Consejo de PromocionTuristica de Mexico, S.A. de C.V. | 2016-05-11 | MEXICO | 6227 6227 | 2014-06-18 | BCW LLC | Viaducto Miguel Aleman No. 105 | Colonia Escandon, Delegacion Miguel Hidalgo, CP 11800 Mexico Distrito Federal | |||
| 16272 | 16272 | 2017-12-31 | Embassy of the Republic of Turkey | 2017-05-09 | TURKEY | 6227 6227 | 2014-06-18 | BCW LLC | 2525 Massachusetts Avenue, NW | Washington | DC | 20008 | |
| 16340 | 16340 | 2020-12-31 | Ennahdha Party | 2014-09-18 | TUNISIA | 6227 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) );