FARA_All_ForeignPrincipals

List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

57 rows where State = "TX"

View and edit SQL

Suggested facets: Address_1, Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State

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
320   Huawei Technologies USA 2019-03-15 CHINA 6650 6650 2019-03-15 Racepoint Global, Inc. 5700 Tennyson Parkway Suite 500 Plano TX 75024
321   Huawei Technologies USA, Inc. 2019-10-03 CHINA 6736 6736 2019-10-03 Pivot Integrated Communications, a division of BCW LLC 5700 Tennyson Parkway Suite 500 Plano TX 75024
484   Nnamdi Kanu Leader of the Indigenous People of Biafra IPOB 2019-10-01 BIAFRA 6170 6170 2013-05-14 Mercury Public Affairs, LLC Nnamdi Kanu 7432 East Trimmier Road Killeen TX 76542
1581 1971-01-31 Air France 1970-05-18 FRANCE 1814 1814 1964-11-06 Association Films, Inc. Dallas     TX  
1798 2017-01-31 Consulate General of Mexico 2016-06-22 MEXICO 5932 5932 2009-04-24 Raben Group, LLC 4507 San Jacinto Street   Houston TX 77004
2089 1993-02-05 Lehndorff & Babson Real Estate Counsel 1988-03-29 GERMANY 3076 3076 1979-12-13 Mayer, Brown & Platt Dallas     TX  
2301 1992-02-13 Aerospatiale Helicopter Corporation 1990-03-15 FRANCE 3988 3988 1987-05-28 Crowell & Moring International, Ltd. Grand Prairie     TX  
2306 1992-02-13 Turbomeca Engine Corporation 1990-03-15 FRANCE 3988 3988 1987-05-28 Crowell & Moring International, Ltd. Grand Prairie     TX  
2978 2019-02-28 Wanhua Chemical Group Company, Ltd. through Wanhua Chemical US Operations LLC 2018-08-06 CHINA 6580 6580 2018-08-06 AUX Initiatives LLC 757 N. Eldridge Parkway, Suite 560   Houston TX 77494
3794 1998-03-23 Petrobras America, Inc. 1996-04-11 BRAZIL 3275 3275 1981-09-23 Graham & James, L.L.P. Houston     TX  
3841 1986-03-26 AHMSA Steel International, Inc. 1978-05-10 MEXICO 2072 2072 1968-01-30 Daniels, Houlihan & Palmeter San Antonio     TX  
3869 1981-03-27 Japan Trade Center 1981-03-27 JAPAN 3218 3218 1981-03-27 Barton, Richard Leon Houston     TX  
4228 1988-03-31 Consul General of Canada/Southwest Region 1987-12-22 CANADA 4078 4078 1987-12-22 E. Bruce Harrison Company/Southwest, Inc. Dallas     TX  
4230 1988-03-31 De Acero America (Wiresteel Corporation) 1986-03-10 MEXICO 3046 3046 1979-08-09 Manchester Associates, Ltd.       TX  
4238 1988-03-31 Sidermex International 1985-06-04 MEXICO 3046 3046 1979-08-09 Manchester Associates, Ltd. San Antonio     TX  
4387 2001-03-31 Singapore Technologies Engineering (USA), Inc. 2000-04-18 SINGAPORE 5367 5367 2000-04-18 Caribou Technologies, Inc. 7701 Lemmon Avenue Dallas 75209     TX  
4438 2006-03-31 Inchcape Shipping Services (through ISS Marine Services, Inc.) 2006-03-31 UNITED ARAB EMIRATES 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC 2180 North Loop West   Houston TX 77018-8014
5045 2011-04-15 Levant Suez Consulting Corporation for Sheikh Fahad Al Ali Al Sabah thru GrayLoeffler, LLC 2011-03-25 KUWAIT 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 4002 Townsville Circle #105 Missouri City TX 77459
5510 1970-04-30 Italian Trade Commissioner 1969-04-30 ITALY 2131 2131 1969-04-30 Aylin Advertising Agency, Inc. Houston     TX  
6551 2005-05-27 JETRO - Houston 2004-11-01 JAPAN 5658 5658 2004-11-01 Fogarty Klein Monroe 1221 McKinney, Suite 4141, Houston, Texas 77010     TX  
6567 1993-05-28 Methanex, Inc. 1993-03-26 CANADA 4783 4783 1993-03-26 McClure, Trotter & Mentz Houston     TX  
6674 2014-05-30 Assembly of the Friends of Azerbaijan 2014-04-14 AZERBAIJAN 6184 6184 2013-09-05 APCO Worldwide, Inc. Galleria Tower 1, 2700 Post Oak Blvd., Suite 1750   Houston TX 77056
7107 2011-06-01 Levant Suez Consulting Corporation for Sheik Fahad Al Ali Al Sabah and Fahad Al Salem Center 2011-03-14 KUWAIT 5806 5806 2007-05-07 Gray Global Advisors, LLC 4002 Townsville Circle #105 Missouri City TX 77459
7324 1994-06-08 Wiresteel 1988-06-22 MEXICO 4149 4149 1988-06-22 Manchester Trade, Inc. Houston     TX  
7490 1998-06-15 Siderca Corporation 1994-09-28 ARGENTINA 4953 4953 1994-09-28 Chlopak, Leonard, Schechter & Associates, Inc. Houston     TX  
7757 1986-06-27 Japan Trade Center 1983-05-27 JAPAN 3479 3479 1983-05-27 Goebel, Chilton G., Jr. Houston     TX  
7759 2014-06-27 Borusan Mannesmann 2014-05-19 TURKEY 6065 6065 2011-09-23 Roberti + White, LLC 363 N. Sam Houston Parkway E, Suite 1700   Houston TX 77060
7948 1978-06-30 JETRO, Dallas Office 1977-08-03 JAPAN 2818 2818 1977-08-03 Unicorp International, Inc. Dallas     TX  
8048 1988-06-30 BNS, Inc. 1988-04-11 GREAT BRITAIN 3492 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP Irving     TX  
8852 1981-07-15 Japan External Trade Organization 1981-07-15 JAPAN 3259 3259 1981-07-15 Bozell & Jacobs, Inc. Houston     TX  
8950 1985-07-19 Deminex U.S. Oil Company 1982-05-13 GERMANY, FEDERAL REPUBLIC OF 3369 3369 1982-05-13 Kilgore & Kilgore, Inc.       TX  
8985 1988-07-21 Japan National Tourist Organization, Dallas 1972-08-15 JAPAN 2369 2369 1972-08-15 Sauermann, Donald J. Dallas     TX  
9004 1993-07-21 Wyndham Ambassodor Beach Hotel, Nassau, Bahamas 1984-07-04 BAHAMAS 3110 3110 1980-06-03 Robinsons, Inc. Dallas     TX  
9005 1993-07-21 Wyndham New Kingston Hotel, Kingston, Jamaica 1984-07-04 JAMAICA 3110 3110 1980-06-03 Robinsons, Inc. Dallas     TX  
9006 1993-07-21 Wyndham Royal Bahamian Hotel, Nassau, Bahamas 1984-07-04 BAHAMAS 3110 3110 1980-06-03 Robinsons, Inc. Dallas     TX  
9050 1984-07-25 Italian Trade Commission 1983-02-11 ITALY 3441 3441 1983-02-11 A.R. Busse & Associates, Inc. Houston     TX  
9153 1977-07-28 Unicorp International, Inc. 1977-07-28 JAPAN 2816 2816 1977-07-28 Sanders & Associates Advertising & Public Relations Dallas     TX  
9834 1987-08-11 Andino Chemical Shipping Company 1987-01-09 MEXICO 3925 3925 1987-01-09 Schmeltzer, Aptaker & Sheppard, P.C. Houston     TX  
10453 1981-08-31 Bahama Islands Tourist Office 1974-03-07 BAHAMAS 1814 1814 1964-11-06 Association Films, Inc. Dallas     TX  
11066 1994-09-12 Crisa Corporation 1990-07-25 MEXICO 3744 3744 1985-10-03 Brownstein, Zeidman & Lore Plano     TX  
11184 2004-09-15 JETRO - Houston 2001-03-16 JAPAN 5415 5415 2001-03-16 Brouillard Communications 2121 McKinney Suite 4141 Houston 77010     TX  
11329 1978-09-25 Japan Trade Center, Houston (Japan External Trade Organization, Dallas) 1978-08-03 JAPAN 2740 2740 1976-12-17 Hill & Knowlton, Inc. Dallas     TX  
11330 1982-09-25 Italian Trade Commission 1982-08-31 ITALY 3406 3406 1982-08-31 A.R. Busse & Associates, Inc. Houston     TX  
11453 1979-09-30 JETRO (Japan External Trade Organization) 1979-08-08 JAPAN 2740 2740 1976-12-17 Hill & Knowlton, Inc. Dallas     TX  
11619 2000-09-30 JETRO, Houston 1990-12-19 JAPAN 4504 4504 1991-04-25 Fogarty Klein & Partners Public Relations Houston     TX  
11652 2003-09-30 JETRO, Houston 1992-11-09 JAPAN 4293 4293 1989-09-15 Baker Botts L.L.P. Houston     TX  
12124 1992-10-14 Aerospaciale Helicopter Corporation 1981-04-02 FRANCE 3179 3179 1980-12-12 Parrish & Company, Inc. Grand Prarie     TX  
12440 1989-10-25 Autonomous University of Guadalajara 1989-09-20 MEXICO 2836 2836 1977-10-12 North American Precis Syndicate San Antonio     TX  
13761 1982-11-30 Japan External Trade Organization 1971-11-04 JAPAN 2287 2287 1971-11-04 Bozell & Jacobs, Inc. Houston     TX  
14652 1983-12-21 AHMSA Steel International, Inc. 1979-11-26 MEXICO 2944 2944 1978-08-09 Fasturn, Inc. San Antonio     TX  
14713 1992-12-23 Enichem Elastomers Americas, Inc. 1991-08-09 ITALY 4259 4259 1989-05-25 Cassidy & Associates, Inc. Houston     TX  
14840 1988-12-30 BNS, Inc. 1988-04-18 GREAT BRITAIN 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP Irving     TX  
14853 1993-12-30 Methanex, Inc. 1993-05-13 CANADA 4830 4830 1993-05-13 McClure, Trotter & Mentz, Chartered Houston     TX  
15479 1989-12-31 Japan External Trade Organization 1986-08-27 JAPAN 3878 3878 1986-08-27 Klein Partnership Houston     TX  
15573 1991-12-31 Saudi Refining, Inc. 1988-06-30 SAUDI ARABIA 2469 2469 1973-10-23 Burson-Marsteller Houston     TX  
15575 1991-12-31 Sidermex International 1988-06-22 MEXICO 4149 4149 1988-06-22 Manchester Trade, Inc. Houston     TX  
16130 2016-12-31 Consulate General of Mexico through Raben Group 2016-06-17 MEXICO 6361 6361 2016-06-17 Information Management Services, Inc. 4507 San Jacinto Street   Houston TX 77004

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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)
);
Powered by Datasette · Query took 177.057ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history