FARA_All_ShortForms

List of all short form registrants (active and terminated)

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

471 rows where State = "TX"

View and edit SQL

Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

Registration_Number

State

  • TX · 471
Link rowid Short_Form_Termination_Date Short_Form_Date Short_Form_Last_Name Short_Form_First_Name Registration_Number Registration_Date Registrant_Name Address_1 Address_2 City State Zip
56   2019-01-07 Khan Umer 6625 6625 2019-01-07 Pakistan Tehreek-E-Insaf USA, LLC 7207 Regency Square Blvd. Suite 247 Houston TX 77036
59   2019-01-08 AlRumaih Saleh I. 6390 6390 2016-11-14 Aramco Affiliated Services Company (AASC) Two Allen Center 1200 Smith Street, 36th Floor Houston TX 77002
60   2019-01-08 Bayounis Abdulrahman 6390 6390 2016-11-14 Aramco Affiliated Services Company (AASC) Two Allen Center 1200 Smith Street, 36th Floor Houston TX 77002
325   2010-02-18 Alsalih Mark K. 5974 5974 2010-02-18 Alsalih, Mark K. 6624 Bermuda Dunes Drive   Plano TX 75093
334   2018-02-20 Kultgen David B. 6527 6527 2018-02-20 Law Office of David B. Kultgen 11841 Overlook Pass   Austin TX 78738
440   2018-03-13 Hirai Toshinaga 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
612   2019-04-12 Koyama Isao 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
614   2019-04-12 McKisick Sheridan 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
622   2019-04-15 Burki Sajjad 6625 6625 2019-01-07 Pakistan Tehreek-E-Insaf USA, LLC 7207 Regency Square Blvd. Suite 247 Houston TX 77036
655   2013-04-23 Sanders Keith 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
665   2019-04-24 Irshad Faisal 6625 6625 2019-01-07 Pakistan Tehreek-E-Insaf USA, LLC 7207 Regency Square Blvd. Suite 247 Houston TX 77036
666   2019-04-24 Zaman Khan Qamar 6625 6625 2019-01-07 Pakistan Tehreek-E-Insaf USA, LLC 7207 Regency Square Blvd. Suite 247 Houston TX 77036
677   2019-04-25 Black Kristin 6669 6669 2019-04-25 Hulsen Media Services LLC 2400 Laramie Trail   Austin TX 78745
681   2019-04-25 Hulsen Meenah 6669 6669 2019-04-25 Hulsen Media Services LLC 2400 Laramie Trail   Austin TX 78745
770   2019-05-02 Khan Ali Asim 6625 6625 2019-01-07 Pakistan Tehreek-E-Insaf USA, LLC 7207 Regency Square Blvd. Suite 247 Houston TX 77036
778   2016-05-04 Al-Dilaymi Kamil Ismail 5974 5974 2010-02-18 Alsalih, Mark K. 6624 Bermuda Dunes Drive   Plano TX 75093
787   2019-05-06 Cawley Justin 6672 6672 2019-05-06 McGinnis Lochridge 600 Congress Avenue Suite 2100 Austin TX 78701
788   2019-05-06 Lutz Martin 6672 6672 2019-05-06 McGinnis Lochridge 600 Congress Avenue Suite 2100 Austin TX 78701
867   2019-05-19 Ettinger Brian 6682 6682 2019-05-19 Linden Government Solutions, LLC 5120 Woodway Drive Suite 5004 Houston TX 77056
868   2019-05-19 Payne Stephen 6682 6682 2019-05-19 Linden Government Solutions, LLC 5120 Woodway Drive Suite 5004 Houston TX 77056
933   2019-05-28 Fleming Joseph 6682 6682 2019-05-19 Linden Government Solutions, LLC 5120 Woodway Drive Suite 5004 Houston TX 77056
955   2019-05-30 Wheeler Brandon 6682 6682 2019-05-19 Linden Government Solutions, LLC 5120 Woodway Drive Suite 5004 Houston TX 77056
1174   2019-07-12 Polyansky David 6700 6700 2019-07-12 Clout Public Affairs, LLC 1001 Congress Avenue Suite 100 Austin TX 78701
1183   2019-07-15 Kasraie Saghar Erica 6682 6682 2019-05-19 Linden Government Solutions, LLC 5120 Woodway Drive Suite 5004 Houston TX 77056
1208   2019-07-22 Frazier Catherine 6700 6700 2019-07-12 Clout Public Affairs, LLC 1001 Congress Avenue Suite 100 Austin TX 78701
1209   2019-07-22 Soni Abhineet Jimmy 6700 6700 2019-07-12 Clout Public Affairs, LLC 1001 Congress Avenue Suite 100 Austin TX 78701
1254   2019-07-29 Hanson James 5974 5974 2010-02-18 Alsalih, Mark K. 6624 Bermuda Dunes Drive   Plano TX 75093
1686   2019-10-01 Shioiri Emi 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
1777   2019-10-16 Sakurauchi Masahiro 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
1895   2017-10-30 Nakagawa Naoto 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
1981   2016-11-14 Abul-Hamayel B.A. 6390 6390 2016-11-14 Aramco Affiliated Services Company (AASC) Two Allen Center 1200 Smith Street, 36th Floor Houston TX 77002
2089   2018-11-27 Alghamdi Adel Misfer 4184 4184 1988-10-13 Saudi Refining, Inc. One Allen Center 500 Dallas Street Houston TX 77002
2292   2019-12-20 Alshammari Mohammad S. 6390 6390 2016-11-14 Aramco Affiliated Services Company (AASC) Two Allen Center 1200 Smith Street, 36th Floor Houston TX 77002
2359   2019-12-31 Brewster James 6778 6778 2019-12-31 Insignias Global, LLC 3522 Prescott Avenue   Dallas TX 75219
2360   2019-12-31 Fox Kristen 6778 6778 2019-12-31 Insignias Global, LLC 3522 Prescott Avenue   Dallas TX 75219
2361   2019-12-31 Satawake Bob Joe 6778 6778 2019-12-31 Insignias Global, LLC 3522 Prescott Avenue   Dallas TX 75219
2446 1977-01-01 1971-11-04 Welch William F. 2287 2287 1971-11-04 Bozell & Jacobs, Inc. 2 Allen Center Suite 2000 Houston TX 77002
2572 1991-01-01 1990-01-25 McAdams Harry E. 4334 4334 1990-01-25 Loeffler & Leath, Inc. 7710 Jones Maltsberger Suite 540 San Antonio TX 78216
2756 2011-01-01 2001-11-06 Durnerin Veronique M. 5481 5481 2001-11-06 OIC Services, Inc. 12337 Jones Road Suite 301 Houston TX 77070
2997 1979-01-04 1974-07-30 Busse Alvin R. 2408 2408 1973-02-21 A.R. Busse & Associates, Inc. 1333 West Loop, South Suite 1230 Houston TX 77027
3039 2001-01-04 2001-02-14 Iwano Hiroshi 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
3082 2001-01-05 2000-04-19 Kodama Masaaki 2820 2820 1977-08-08 JETRO, Dallas (Japan External Trade Organization) 2050 Stemmons Freeway #152-1 P.O. Box 420370 Dallas TX 75342-0370
3096 2018-01-05 2015-04-22 Kurokawa Junji 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
3287 1987-01-09 1986-08-27 Takamura Taketoshi 3878 3878 1986-08-27 Klein Partnership 1201 Louisiana Suite 3426 Houston TX 77002-5213
3412 1987-01-12 1986-03-19 Jones B. Calvin 3800 3800 1986-03-19 Jones, B. Calvin 3000 South Post Oak Suite 100 Houston TX 77056
3418 1996-01-12 1995-11-02 Kilday Anne Marie 4928 4928 1994-07-15 Public Strategies, Inc. 98 San Jacinto Boulevard Suite 900 Austin TX 78701
3463 2005-01-13 2004-03-26 Feldhaus Stephen M. 5615 5615 2004-03-26 Fulbright & Jaworski, LLP 1301 McKinney Suite 5100 Houston TX 77010-3095
3612 2012-01-15 2012-02-07 Hutcheson Ron 5913 5913 2009-03-05 Public Strategies, Inc. 98 San Jacinto Boulevard Suite 1200 Austin TX 78701
3919 2013-01-20 2013-01-09 Butt Iqbal Ahmad 5975 5975 2010-02-25 PTI USA, LLC 315 Maple Street   Richardson TX 75081
3920 2013-01-20 2013-02-24 Mirza Mohammad Akram 5975 5975 2010-02-25 PTI USA, LLC 315 Maple Street   Richardson TX 75081
3921 2013-01-20 2012-09-17 Asad Khan Muhammad 5975 5975 2010-02-25 PTI USA, LLC 315 Maple Street   Richardson TX 75081
3922 2013-01-20 2012-12-19 Khan Sherry Safdar 5975 5975 2010-02-25 PTI USA, LLC 315 Maple Street   Richardson TX 75081
4067 1983-01-24 1978-01-19 Mouffok Lahouari 2298 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
4068 1983-01-24 1978-04-05 Mir Omar 2298 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
4069 1983-01-24 1978-12-22 Mapes William R. , Jr. 2298 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
4095 2013-01-24 2013-01-24 Trevino Joshua 6152 6152 2013-01-24 Trevino Strategies & Media, Inc. 4115 Rosedale Avenue Unit A Austin TX 78755
4617 1965-01-31 1964-12-17 Cuevas Enrique Valles las 1836 1836 1964-12-17 Spanish National Tourist Office, Dallas 1418 Commerce Street   Dallas TX 75201
4636 1972-01-31 1965-04-13 Garza Joel Quinones 1882 1882 1965-04-13 Mexican Government Tourism Office, San Antonio GPM South Tower Suite 240 San Antonio TX 78216
4676 1981-01-31 1981-01-22 Kara Abdelhamid 2298 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
4679 1981-01-31 1980-07-21 Berkane Abdelghani 2298 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
4755 1990-01-31 1989-05-12 Sharr Seth L. 4184 4184 1988-10-13 Saudi Refining, Inc. One Allen Center 500 Dallas Street Houston TX 77002
4883 1997-01-31 1995-07-21 Rosenberg Richelle A. 5037 5037 1995-07-21 Carlberg & Associates, Inc. 2800 Post Oak Boulevard Suite 3400 Houston TX 77056-6106
4905 1999-01-31 1990-05-14 Woelfel Frank R. 4184 4184 1988-10-13 Saudi Refining, Inc. One Allen Center 500 Dallas Street Houston TX 77002
4928 2001-01-31 1996-01-19 Martin Jack L. 4928 4928 1994-07-15 Public Strategies, Inc. 98 San Jacinto Boulevard Suite 900 Austin TX 78701
4932 2001-01-31 1996-03-04 Mashek William S. 4928 4928 1994-07-15 Public Strategies, Inc. 98 San Jacinto Boulevard Suite 900 Austin TX 78701
4933 2001-01-31 1997-03-22 Smith Glenn W. 4928 4928 1994-07-15 Public Strategies, Inc. 98 San Jacinto Boulevard Suite 900 Austin TX 78701
4937 2001-01-31 1996-06-05 McClure Frederick D. 4928 4928 1994-07-15 Public Strategies, Inc. 98 San Jacinto Boulevard Suite 900 Austin TX 78701
4938 2001-01-31 1994-07-15 DeVore Jack 4928 4928 1994-07-15 Public Strategies, Inc. 98 San Jacinto Boulevard Suite 900 Austin TX 78701
4939 2001-01-31 1994-07-15 Taylor James S. 4928 4928 1994-07-15 Public Strategies, Inc. 98 San Jacinto Boulevard Suite 900 Austin TX 78701
4948 2001-01-31 2000-08-22 Dickie Joseph R. 4928 4928 1994-07-15 Public Strategies, Inc. 98 San Jacinto Boulevard Suite 900 Austin TX 78701
4949 2001-01-31 1995-09-18 Eller Jeff 4928 4928 1994-07-15 Public Strategies, Inc. 98 San Jacinto Boulevard Suite 900 Austin TX 78701
4954 2001-01-31 1998-11-30 Laing Barbara 4928 4928 1994-07-15 Public Strategies, Inc. 98 San Jacinto Boulevard Suite 900 Austin TX 78701
4955 2001-01-31 1996-12-26 Wallace Roger 4928 4928 1994-07-15 Public Strategies, Inc. 98 San Jacinto Boulevard Suite 900 Austin TX 78701
5837 1980-02-06 1978-04-05 Benbrahim Mohamed 2298 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
5966 1980-02-08 1980-02-08 Baker W. Randolph 2926 2926 1978-07-06 Dale Henderson, Inc. 2200 North Loop West Suite 100 Houston TX 77018
5967 1980-02-08 1978-07-06 Babb Terry M. 2926 2926 1978-07-06 Dale Henderson, Inc. 2200 North Loop West Suite 100 Houston TX 77018
5968 1980-02-08 1978-07-06 Henderson Claudine L. 2926 2926 1978-07-06 Dale Henderson, Inc. 2200 North Loop West Suite 100 Houston TX 77018
5969 1980-02-08 1978-07-06 Henderson H. Dale 2926 2926 1978-07-06 Dale Henderson, Inc. 2200 North Loop West Suite 100 Houston TX 77018
5970 1980-02-08 1978-07-06 McElwain William E. 2926 2926 1978-07-06 Dale Henderson, Inc. 2200 North Loop West Suite 100 Houston TX 77018
6134 1990-02-10 1988-12-02 Nakata Yutaka 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
6236 1987-02-12 1985-01-31 Choi Kyu Jae 2652 2652 1976-01-16 Korea Trade Center, Dallas 12720 Hillcrest Road Suite 390 Dallas TX 75230-2040
6450 2014-02-14 2013-04-23 Shimada Aki 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
7048 1995-02-24 1994-09-20 Christian Elizabeth 4928 4928 1994-07-15 Public Strategies, Inc. 98 San Jacinto Boulevard Suite 900 Austin TX 78701
7141 1997-02-25 1993-02-16 Park Poong 2652 2652 1976-01-16 Korea Trade Center, Dallas 12720 Hillcrest Road Suite 390 Dallas TX 75230-2040
7375 1979-02-28 1977-12-02 Minato Yunosuke 2348 2348 1972-07-03 Japan National Tourist Organization, Dallas 2121 San Jacinto Street Suite 980 - LB-53 Dallas TX 75201
7491 1994-02-28 1992-03-11 Ellis Rodney G. 4630 4630 1992-03-11 Solar & Ellis, L.L.P. 1331 Lamar Suite 1550 Houston TX 77010
7492 1994-02-28 1992-03-11 Solar J. Michael 4630 4630 1992-03-11 Solar & Ellis, L.L.P. 1331 Lamar Suite 1550 Houston TX 77010
7715 2007-02-28 2007-12-28 McNabb Stephen M. 5842 5842 2007-12-28 Fulbright & Jaworski, LLP 1301 McKinney #5100 Fulbright Tower Houston TX 77010-3095
7843 2019-02-28 2017-10-30 Uchida Kaori 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
8119 1979-03-01 1977-02-17 Brahimi Abdelhamid 2298 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
8138 1984-03-01 1980-09-19 Jones B. Calvin 3150 3150 1980-09-19 Jones, B. Calvin 3000 South Post Oak Suite 100 Houston TX 77056
8153 1988-03-01 1987-02-03 Nakagami Masaru 2820 2820 1977-08-08 JETRO, Dallas (Japan External Trade Organization) 2050 Stemmons Freeway #152-1 P.O. Box 420370 Dallas TX 75342-0370
8325 1979-03-02 1977-08-08 Yoshihashi Toshio 2820 2820 1977-08-08 JETRO, Dallas (Japan External Trade Organization) 2050 Stemmons Freeway #152-1 P.O. Box 420370 Dallas TX 75342-0370
8333 1994-03-02 1986-08-19 Shannon Edfred L. , Jr. 3841 3841 1986-06-06 Santa Fe (U.S. Holdings) Inc. Two Lincoln Centre 5420 LBJ Freeway, Suite 1100 Dallas TX 75240-2648
8470 1982-03-04 1979-10-01 Yoshida Toshi 2820 2820 1977-08-08 JETRO, Dallas (Japan External Trade Organization) 2050 Stemmons Freeway #152-1 P.O. Box 420370 Dallas TX 75342-0370
8504 1976-03-05 1975-01-24 Stovall James T. , III 2298 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
8507 1976-03-05 1971-12-17 Guellal Cherif 2298 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
8782 1974-03-08 1971-11-04 Bresenhan Karoline 2287 2287 1971-11-04 Bozell & Jacobs, Inc. 2 Allen Center Suite 2000 Houston TX 77002
8840 1979-03-09 1977-08-03 Inoue Hiro 2818 2818 1977-08-03 Unicorp International, Inc. 4835 LBJ Freeway Suite 630 Dallas TX 75234
8841 1979-03-09 1977-11-29 Shaw John F. 2818 2818 1977-08-03 Unicorp International, Inc. 4835 LBJ Freeway Suite 630 Dallas TX 75234

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [FARA_All_ShortForms] (
   [Short_Form_Termination_Date] TEXT,
   [Short_Form_Date] TEXT,
   [Short_Form_Last_Name] TEXT,
   [Short_Form_First_Name] TEXT,
   [Registration_Number] INTEGER,
   [Registration_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 387.418ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history