FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where City = "Houston" sorted by Registrant_Name
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Address_2, Foreign_Principal_Termination_Date (date), Registrant_Date (date)
Registrant_Name 9
Foreign_Principal_Registration_Date (date) 9 ✖
- 2006-03-31 1
- 2014-04-14 1
- 2014-05-19 1
- 2016-06-17 1
- 2016-06-22 1
- 2018-08-06 1
- 2021-05-11 1
- 2021-07-26 1
- 2021-11-30 1
Foreign_Principal 9
- Ad Hoc Board of Petroleos de Venezuela, S.A. through PDV Holding, Inc. 1
- Ahmed, Tanweer 1
- Assembly of the Friends of Azerbaijan 1
- Borusan Mannesmann 1
- Consulate General of Mexico 1
- Consulate General of Mexico through Raben Group 1
- Inchcape Shipping Services (through ISS Marine Services, Inc.) 1
- UNIPEC America Inc. 1
- Wanhua Chemical Group Company, Ltd. through Wanhua Chemical US Operations LLC 1
Country/Location_Represented 7
- CHINA 2
- MEXICO 2
- AZERBAIJAN 1
- PAKISTAN 1
- TURKEY 1
- UNITED ARAB EMIRATES 1
- VENEZUELA 1
State 1
- TX 9
City 1
- Houston · 9 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6999 | 6999 | 2014-05-30 | Assembly of the Friends of Azerbaijan | 2014-04-14 | AZERBAIJAN | APCO Worldwide, Inc. 6184 | 2013-09-05 | APCO Worldwide, Inc. | Galleria Tower 1, 2700 Post Oak Blvd., Suite 1750 | Houston | TX | 77056 | |
3139 | 3139 | 2019-02-28 | Wanhua Chemical Group Company, Ltd. through Wanhua Chemical US Operations LLC | 2018-08-06 | CHINA | AUX Initiatives LLC 6580 | 2018-08-06 | AUX Initiatives LLC | 757 N. Eldridge Parkway, Suite 560 | Houston | TX | 77494 | |
10347 | 10347 | 2021-08-14 | Ahmed, Tanweer | 2021-07-26 | PAKISTAN | Ahmed, Tanweer 6981 | 2021-07-26 | Ahmed, Tanweer | 17154 Butte Creek Rd | Houston | TX | 77090 | |
4653 | 4653 | 2006-03-31 | Inchcape Shipping Services (through ISS Marine Services, Inc.) | 2006-03-31 | UNITED ARAB EMIRATES | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 2180 North Loop West | Houston | TX | 77018-8014 | |
16776 | 16776 | 2016-12-31 | Consulate General of Mexico through Raben Group | 2016-06-17 | MEXICO | Information Management Services, Inc. 6361 | 2016-06-17 | Information Management Services, Inc. | 4507 San Jacinto Street | Houston | TX | 77004 | |
29 | 29 | Ad Hoc Board of Petroleos de Venezuela, S.A. through PDV Holding, Inc. | 2021-11-30 | VENEZUELA | Klein/Johnson Group LLC 7049 | 2021-11-30 | Klein/Johnson Group LLC | 1293 Eldridge Parkway | Houston | TX | 77077 | ||
736 | 736 | UNIPEC America Inc. | 2021-05-11 | CHINA | McCollum, Jonathan 6960 | 2021-05-11 | McCollum, Jonathan | 3050 Post Oak Blvd | Suite 900 | Houston | TX | 77056 | |
1909 | 1909 | 2017-01-31 | Consulate General of Mexico | 2016-06-22 | MEXICO | Raben Group, LLC 5932 | 2009-04-24 | Raben Group, LLC | 4507 San Jacinto Street | Houston | TX | 77004 | |
8132 | 8132 | 2014-06-27 | Borusan Mannesmann | 2014-05-19 | TURKEY | Roberti + White, LLC 6065 | 2011-09-23 | Roberti + White, LLC | 363 N. Sam Houston Parkway E, Suite 1700 | Houston | TX | 77060 |
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]) );