FARA_All_Registrants

List of all registrant data (active and terminated)

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

51 rows where City = "Houston"

View and edit SQL

Suggested facets: Business_Name, Zip, Registration_Date (date), Termination_Date (date)

State

City

  • Houston · 51
Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
362 1946-06-27 1948-12-27 Gibler, Frank   1929 Heaney Drive   Houston TX  
1239 1959-06-22 1959-12-22 Major, Dale R.   5009 Fannin Street   Houston TX  
1769 1964-07-07 1964-07-07 Hal Hazelrigg, Inc.   1400 South Post Oak Road #20 Post Office Box 22264 Houston TX  
1847 1965-01-27 1976-12-31 Mexican Ministry of Tourism, Houston Delegation De La Secretaria De Turismo 805 Walker Avenue   Houston TX 77002
2131 1969-04-30 1970-04-30 Aylin Advertising Agency, Inc.   2737 Buffalo Speedway   Houston TX 77006
2277 1971-09-20   JETRO, Houston   1221 McKinney Street Suite 4141 Houston TX 77010
2287 1971-11-04 1982-11-30 Bozell & Jacobs, Inc.   2 Allen Center Suite 2000 Houston TX 77002
2298 1971-12-17 1983-01-24 Sonatrach, Inc.   Post Office Box 27041   Houston TX 77027
2408 1973-02-21 1979-01-04 A.R. Busse & Associates, Inc.   1333 West Loop, South Suite 1230 Houston TX 77027
2926 1978-07-06 1980-02-08 Dale Henderson, Inc.   2200 North Loop West Suite 100 Houston TX 77018
3080 1980-01-08 1980-10-21 Mel Anderson Communications, Inc.   6901 Corporate Drive Suite 201 Houston TX 77036
3149 1980-09-19 1989-04-28 Romanian Trade Promotion Office, Houston   515 Tallowood Road Suite 20 Houston TX 77024
3150 1980-09-19 1984-03-01 Jones, B. Calvin   3000 South Post Oak Suite 100 Houston TX 77056
3218 1981-03-27 1981-03-27 Barton, Richard Leon   2000 - 2 Allen Center   Houston TX 77002
3230 1981-04-20 1983-11-01 Peggy Dyer & Associates   605 Colquitt   Houston TX 77006
3259 1981-07-15 1981-07-15 Bozell & Jacobs, Inc.   2 Allen Center Suite 2000 Houston TX 77002
3288 1981-10-08 1982-07-09 John D. Brady & Associates, Inc.   1 West Loop, South Suite 206 Houston TX 77027
3294 1981-10-21 1987-12-03 St. John, Terry St. John & Associates 2312 West Main   Houston TX 77098
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
3406 1982-08-31 1982-09-25 A.R. Busse & Associates, Inc.   1333 West Loop, South Suite 1230 Houston TX 77027
3410 1982-09-20 1995-06-30 Austrian Trade Commission in the U.S., Houston   1300 Post Oak Boulevard Suite 1700 Houston TX 77056
3441 1983-02-11 1984-07-25 A.R. Busse & Associates, Inc.   1333 West Loop, South Suite 1230 Houston TX 77027
3589 1984-05-22 1989-06-17 Government of Alberta, Canada   5444 Westheimer Suite 1425 Houston TX 77056
3619 1984-10-11 1988-04-21 German State of Rheinland-Pfalz Commercial Office   1800 West Loop, South Suite 1510 Houston TX 77027
3800 1986-03-19 1987-01-12 Jones, B. Calvin   3000 South Post Oak Suite 100 Houston TX 77056
3878 1986-08-27 1989-12-31 Klein Partnership   1201 Louisiana Suite 3426 Houston TX 77002-5213
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
4504 1991-04-25 2000-10-31 Fogarty Klein & Partners Public Relations   7155 Old Katy Road Suite 100 Houston TX 77024
4609 1992-01-24 1994-03-23 Campos Communications, Inc.   816 Ralfallen   Houston TX 77008
4615 1992-02-12 1999-08-28 Brown Nelson & Associates, Inc.   6200 Savoy Drive Suite 350 Houston TX 77036
4630 1992-03-11 1994-02-28 Solar & Ellis, L.L.P.   1331 Lamar Suite 1550 Houston TX 77010
4927 1994-07-11 1994-12-31 Campos Communications, Inc.   816 Ralfallen   Houston TX 77008
5024 1995-06-19 1995-12-31 DeLay, Randolph L.   2925 Briarpark Suite 1150 Houston TX 77042
5037 1995-07-21 1997-01-31 Carlberg & Associates, Inc. Rives Carlberg Agency 2800 Post Oak Boulevard Suite 3400 Houston TX 77056-6106
5134 1996-10-26 2001-10-31 Oceans International Corporation   5005 Mitchelldale Suite 121 Houston TX 77092
5415 2001-03-16 2004-09-15 Brouillard Communications   10111 Richmond Avenue Suite 375 Houston TX 77042
5466 2001-12-19 2004-12-31 Team Eagle   5847 San Felipe Suite 3275 Houston TX 77057
5481 2001-11-06 2014-05-31 OIC Services, Inc.   12337 Jones Road Suite 301 Houston TX 77070
5510 2002-07-22 2004-07-31 Eric Bing & Company, Inc.   One Riverway Suite 1700 Houston TX 77056
5615 2004-03-26 2005-03-31 Fulbright & Jaworski, LLP   1301 McKinney Suite 5100 Houston TX 77010-3095
5658 2004-11-01 2005-05-27 Fogarty Klein Monroe   7155 Old Katy Road Suite 100 Houston TX 77024
5692 2005-07-01 2007-07-31 J&D International Consulting Services, LLC   2200 Post Oak Boulevard Suite 310 Houston TX 77056
5842 2007-12-28 2010-12-31 Fulbright & Jaworski, LLP   1301 McKinney #5100 Fulbright Tower Houston TX 77010-3095
6390 2016-11-14   Aramco Affiliated Services Company (AASC)   Two Allen Center 1200 Smith Street, 36th Floor Houston TX 77002
6464 2017-09-15 2018-10-12 Baker Botts, LLP   910 Louisiana Street   Houston TX 77002-4995
6625 2019-01-07   Pakistan Tehreek-E-Insaf USA, LLC   7207 Regency Square Blvd. Suite 247 Houston TX 77036
6682 2019-05-19   Linden Government Solutions, LLC   5120 Woodway Drive Suite 5004 Houston TX 77056
6751 2019-11-19   Untermeyer, Charles Graves   10000 Memorial Drive Suite 920 Houston TX 77024
6804 2020-03-20   Bridge Builder Communications   7518 Awty School Lane   Houston TX 77055

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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