FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where Zip = 77002
This data as json, CSV (advanced)
Suggested facets: Termination_Date, Name, Business_Name, Address_2, Registration_Date (date), Termination_Date (date)
Registration_Number ▼ | Registration_Date | Termination_Date | Name | Business_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|
1847 | 1965-01-27 | 1976-12-31 | Mexican Ministry of Tourism, Houston | Delegation De La Secretaria De Turismo | 805 Walker Avenue | Houston | TX | 77002 | |
2287 | 1971-11-04 | 1982-11-30 | Bozell & Jacobs, Inc. | 2 Allen Center | Suite 2000 | Houston | TX | 77002 | |
3218 | 1981-03-27 | 1981-03-27 | Barton, Richard Leon | 2000 - 2 Allen Center | Houston | TX | 77002 | ||
3259 | 1981-07-15 | 1981-07-15 | Bozell & Jacobs, Inc. | 2 Allen Center | Suite 2000 | Houston | TX | 77002 | |
3351 | 1982-04-05 | 1985-09-05 | James Finlay International, Inc. | InterFirst Plaza | Suite 2600 | Houston | TX | 77002 | |
3356 | 1982-04-20 | 1988-12-31 | Luxton-Jones, Roger Louis | 1100 Louisiana | Suite 2600 | Houston | TX | 77002 | |
4044 | 1987-09-29 | 1990-03-31 | Bankers Capital Management, Inc. | 601 Milam | 6901 Texas Commerce Tower | Houston | TX | 77002 | |
4184 | 1988-10-13 | Saudi Refining, Inc. | One Allen Center | 500 Dallas Street | Houston | TX | 77002 | ||
6390 | 2016-11-14 | Aramco Affiliated Services Company (AASC) | Two Allen Center | 1200 Smith Street, 36th Floor | Houston | TX | 77002 | ||
6948 | 2021-04-15 | 2021-05-07 | Gerger Hennessy & McFarlane LLP | 1001 Fannin Street | Suite 2450 | Houston | TX | 77002 | |
7142 | 2022-07-19 | Vinson & Elkins LLP | 845 Texas Avenue | Suite 4700 | Houston | TX | 77002 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [FARA_All_Registrants] ( [Registration_Number] INTEGER PRIMARY KEY, [Registration_Date] TEXT, [Termination_Date] TEXT, [Name] TEXT, [Business_Name] TEXT, [Address_1] TEXT, [Address_2] TEXT, [City] TEXT, [State] TEXT, [Zip] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );