FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
65 rows where State = "TX"
This data as json, CSV (advanced)
Registrant_Name 22
- Hill & Knowlton, Inc. 2
- A.R. Busse & Associates, Inc. 1
- Ahmed, Tanweer 1
- Association Films, Inc. 1
- Baker Botts L.L.P. 1
- Bozell & Jacobs, Inc. 1
- Brouillard Communications 1
- Brownstein, Zeidman & Lore 1
- Burson-Marsteller 1
- Cassidy & Associates, Inc. 1
- Cleary, Gottlieb, Steen & Hamilton, LLP 1
- Fasturn, Inc. 1
- Fogarty Klein & Partners Public Relations 1
- Information Management Services, Inc. 1
- Klein Partnership 1
- Manchester Trade, Inc. 1
- McClure, Trotter & Mentz, Chartered 1
- North American Precis Syndicate 1
- Parrish & Company, Inc. 1
- Pivot Integrated Communications, a division of BCW LLC 1
- Racepoint Global, Inc. 1
- Schmeltzer, Aptaker & Sheppard, P.C. 1
Foreign_Principal 21
- JETRO, Houston 2
- Japan External Trade Organization 2
- AHMSA Steel International, Inc. 1
- Aerospaciale Helicopter Corporation 1
- Ahmed, Tanweer 1
- Andino Chemical Shipping Company 1
- Autonomous University of Guadalajara 1
- BNS, Inc. 1
- Bahama Islands Tourist Office 1
- Consulate General of Mexico through Raben Group 1
- Crisa Corporation 1
- Enichem Elastomers Americas, Inc. 1
- Huawei Technologies USA 1
- Huawei Technologies USA, Inc. 1
- Italian Trade Commission 1
- JETRO (Japan External Trade Organization) 1
- JETRO - Houston 1
- Japan Trade Center, Houston (Japan External Trade Organization, Dallas) 1
- Methanex, Inc. 1
- Saudi Refining, Inc. 1
- Sidermex International 1
Country/Location_Represented 10
- JAPAN 7
- MEXICO 6
- CHINA 2
- ITALY 2
- BAHAMAS 1
- CANADA 1
- FRANCE 1
- GREAT BRITAIN 1
- PAKISTAN 1
- SAUDI ARABIA 1
State 1
- TX · 23 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9937 | 9937 | 2020-07-31 | Huawei Technologies USA, Inc. | 2019-10-03 | CHINA | Pivot Integrated Communications, a division of BCW LLC 6736 | 2019-10-03 | Pivot Integrated Communications, a division of BCW LLC | 5700 Tennyson Parkway | Suite 500 | Plano | TX | 75024 |
10268 | 10268 | 1987-08-11 | Andino Chemical Shipping Company | 1987-01-09 | MEXICO | Schmeltzer, Aptaker & Sheppard, P.C. 3925 | 1987-01-09 | Schmeltzer, Aptaker & Sheppard, P.C. | Houston | TX | |||
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 | |
10906 | 10906 | 1981-08-31 | Bahama Islands Tourist Office | 1974-03-07 | BAHAMAS | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | Dallas | TX | |||
11542 | 11542 | 1994-09-12 | Crisa Corporation | 1990-07-25 | MEXICO | Brownstein, Zeidman & Lore 3744 | 1985-10-03 | Brownstein, Zeidman & Lore | Plano | TX | |||
11660 | 11660 | 2004-09-15 | JETRO - Houston | 2001-03-16 | JAPAN | Brouillard Communications 5415 | 2001-03-16 | Brouillard Communications | 2121 McKinney Suite 4141 Houston 77010 | TX | |||
11813 | 11813 | 1978-09-25 | Japan Trade Center, Houston (Japan External Trade Organization, Dallas) | 1978-08-03 | JAPAN | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | Dallas | TX | |||
11814 | 11814 | 1982-09-25 | Italian Trade Commission | 1982-08-31 | ITALY | A.R. Busse & Associates, Inc. 3406 | 1982-08-31 | A.R. Busse & Associates, Inc. | Houston | TX | |||
11947 | 11947 | 1979-09-30 | JETRO (Japan External Trade Organization) | 1979-08-08 | JAPAN | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | Dallas | TX | |||
12113 | 12113 | 2000-09-30 | JETRO, Houston | 1990-12-19 | JAPAN | Fogarty Klein & Partners Public Relations 4504 | 1991-04-25 | Fogarty Klein & Partners Public Relations | Houston | TX | |||
12147 | 12147 | 2003-09-30 | JETRO, Houston | 1992-11-09 | JAPAN | Baker Botts L.L.P. 4293 | 1989-09-15 | Baker Botts L.L.P. | Houston | TX | |||
12673 | 12673 | 1992-10-14 | Aerospaciale Helicopter Corporation | 1981-04-02 | FRANCE | Parrish & Company, Inc. 3179 | 1980-12-12 | Parrish & Company, Inc. | Grand Prarie | TX | |||
13001 | 13001 | 1989-10-25 | Autonomous University of Guadalajara | 1989-09-20 | MEXICO | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | San Antonio | TX | |||
14360 | 14360 | 1982-11-30 | Japan External Trade Organization | 1971-11-04 | JAPAN | Bozell & Jacobs, Inc. 2287 | 1971-11-04 | Bozell & Jacobs, Inc. | Houston | TX | |||
15289 | 15289 | 1983-12-21 | AHMSA Steel International, Inc. | 1979-11-26 | MEXICO | Fasturn, Inc. 2944 | 1978-08-09 | Fasturn, Inc. | San Antonio | TX | |||
15351 | 15351 | 1992-12-23 | Enichem Elastomers Americas, Inc. | 1991-08-09 | ITALY | Cassidy & Associates, Inc. 4259 | 1989-05-25 | Cassidy & Associates, Inc. | Houston | TX | |||
15485 | 15485 | 1988-12-30 | BNS, Inc. | 1988-04-18 | GREAT BRITAIN | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Irving | TX | |||
15498 | 15498 | 1993-12-30 | Methanex, Inc. | 1993-05-13 | CANADA | McClure, Trotter & Mentz, Chartered 4830 | 1993-05-13 | McClure, Trotter & Mentz, Chartered | Houston | TX | |||
16124 | 16124 | 1989-12-31 | Japan External Trade Organization | 1986-08-27 | JAPAN | Klein Partnership 3878 | 1986-08-27 | Klein Partnership | Houston | TX | |||
16218 | 16218 | 1991-12-31 | Saudi Refining, Inc. | 1988-06-30 | SAUDI ARABIA | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | Houston | TX | |||
16220 | 16220 | 1991-12-31 | Sidermex International | 1988-06-22 | MEXICO | Manchester Trade, Inc. 4149 | 1988-06-22 | Manchester Trade, Inc. | Houston | TX | |||
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 | |
16906 | 16906 | 2021-12-31 | Huawei Technologies USA | 2019-03-15 | CHINA | Racepoint Global, Inc. 6650 | 2019-03-15 | Racepoint Global, Inc. | 5700 Tennyson Parkway | Suite 500 | Plano | TX | 75024 |
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]) );