FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
19 rows where Address_1 = "Houston" sorted by Registrant_Date
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Registrant_Date (date) 18 ✖
- 1988-06-22 2
- 1969-04-30 1
- 1971-11-04 1
- 1973-10-23 1
- 1981-03-27 1
- 1981-07-15 1
- 1981-09-23 1
- 1982-08-31 1
- 1983-02-11 1
- 1983-05-27 1
- 1986-08-27 1
- 1987-01-09 1
- 1989-05-25 1
- 1989-09-15 1
- 1991-04-25 1
- 1993-03-26 1
- 1993-05-13 1
- 1994-09-28 1
Registrant_Name 16
- A.R. Busse & Associates, Inc. 2
- Bozell & Jacobs, Inc. 2
- Manchester Trade, Inc. 2
- Aylin Advertising Agency, Inc. 1
- Baker Botts L.L.P. 1
- Barton, Richard Leon 1
- Burson-Marsteller 1
- Cassidy & Associates, Inc. 1
- Chlopak, Leonard, Schechter & Associates, Inc. 1
- Fogarty Klein & Partners Public Relations 1
- Goebel, Chilton G., Jr. 1
- Graham & James, L.L.P. 1
- Klein Partnership 1
- McClure, Trotter & Mentz 1
- McClure, Trotter & Mentz, Chartered 1
- Schmeltzer, Aptaker & Sheppard, P.C. 1
Foreign_Principal 13
- Japan External Trade Organization 3
- Italian Trade Commission 2
- JETRO, Houston 2
- Japan Trade Center 2
- Methanex, Inc. 2
- Andino Chemical Shipping Company 1
- Enichem Elastomers Americas, Inc. 1
- Italian Trade Commissioner 1
- Petrobras America, Inc. 1
- Saudi Refining, Inc. 1
- Siderca Corporation 1
- Sidermex International 1
- Wiresteel 1
Country/Location_Represented 7
State 1
- TX 19
City 1
- - 19
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5792 | 5792 | 1970-04-30 | Italian Trade Commissioner | 1969-04-30 | ITALY | Aylin Advertising Agency, Inc. 2131 | 1969-04-30 | Aylin Advertising Agency, Inc. | Houston | 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 | |||
16218 | 16218 | 1991-12-31 | Saudi Refining, Inc. | 1988-06-30 | SAUDI ARABIA | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | Houston | TX | |||
4082 | 4082 | 1981-03-27 | Japan Trade Center | 1981-03-27 | JAPAN | Barton, Richard Leon 3218 | 1981-03-27 | Barton, Richard Leon | Houston | TX | |||
9260 | 9260 | 1981-07-15 | Japan External Trade Organization | 1981-07-15 | JAPAN | Bozell & Jacobs, Inc. 3259 | 1981-07-15 | Bozell & Jacobs, Inc. | Houston | TX | |||
4004 | 4004 | 1998-03-23 | Petrobras America, Inc. | 1996-04-11 | BRAZIL | Graham & James, L.L.P. 3275 | 1981-09-23 | Graham & James, L.L.P. | Houston | 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 | |||
9462 | 9462 | 1984-07-25 | Italian Trade Commission | 1983-02-11 | ITALY | A.R. Busse & Associates, Inc. 3441 | 1983-02-11 | A.R. Busse & Associates, Inc. | Houston | TX | |||
8130 | 8130 | 1986-06-27 | Japan Trade Center | 1983-05-27 | JAPAN | Goebel, Chilton G., Jr. 3479 | 1983-05-27 | Goebel, Chilton G., Jr. | 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 | |||
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 | |||
7682 | 7682 | 1994-06-08 | Wiresteel | 1988-06-22 | MEXICO | Manchester Trade, Inc. 4149 | 1988-06-22 | Manchester Trade, Inc. | 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 | |||
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 | |||
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 | |||
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 | |||
6891 | 6891 | 1993-05-28 | Methanex, Inc. | 1993-03-26 | CANADA | McClure, Trotter & Mentz 4783 | 1993-03-26 | McClure, Trotter & Mentz | Houston | 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 | |||
7854 | 7854 | 1998-06-15 | Siderca Corporation | 1994-09-28 | ARGENTINA | Chlopak, Leonard, Schechter & Associates, Inc. 4953 | 1994-09-28 | Chlopak, Leonard, Schechter & Associates, Inc. | Houston | TX |
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]) );