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

478 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 · 478
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
74   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
77   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
310   2010-02-18 Alsalih Mark K. 5974 5974 2010-02-18 Alsalih, Mark K. 6624 Bermuda Dunes Drive   Plano TX 75093
321   2018-02-20 Kultgen David B. 6527 6527 2018-02-20 Law Office of David B. Kultgen 11841 Overlook Pass   Austin TX 78738
512   2020-03-20 Smalley George F. 6804 6804 2020-03-20 Bridge Builder Communications 7518 Awty School Lane   Houston TX 77055
556   2020-03-27 Meservey Lulu Cheng 6808 6808 2020-03-27 TrailRunner International LLC 600 N. Carroll Ave., Suite 100   Southlake TX 76092
557   2020-03-27 Shortridge Patrick 6808 6808 2020-03-27 TrailRunner International LLC 600 N. Carroll Ave., Suite 100   Southlake TX 76092
558   2020-03-27 Walker Georgia 6808 6808 2020-03-27 TrailRunner International LLC 600 N. Carroll Ave., Suite 100   Southlake TX 76092
559   2020-03-27 Wilkinson James R 6808 6808 2020-03-27 TrailRunner International LLC 600 N. Carroll Ave., Suite 100   Southlake TX 76092
684   2019-04-12 Koyama Isao 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
685   2019-04-12 McKisick Sheridan 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
693   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
726   2013-04-23 Sanders Keith 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
734   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
735   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
741   2019-04-25 Black Kristin 6669 6669 2019-04-25 Hulsen Media Services LLC 2400 Laramie Trail   Austin TX 78745
745   2019-04-25 Hulsen Meenah 6669 6669 2019-04-25 Hulsen Media Services LLC 2400 Laramie Trail   Austin TX 78745
840   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
847   2016-05-04 Al-Dilaymi Kamil Ismail 5974 5974 2010-02-18 Alsalih, Mark K. 6624 Bermuda Dunes Drive   Plano TX 75093
855   2019-05-06 Cawley Justin 6672 6672 2019-05-06 McGinnis Lochridge 600 Congress Avenue Suite 2100 Austin TX 78701
932   2019-05-19 Ettinger Brian 6682 6682 2019-05-19 Linden Government Solutions, LLC 5120 Woodway Drive Suite 5004 Houston TX 77056
933   2019-05-19 Payne Stephen 6682 6682 2019-05-19 Linden Government Solutions, LLC 5120 Woodway Drive Suite 5004 Houston TX 77056
1004   2019-05-28 Fleming Joseph 6682 6682 2019-05-19 Linden Government Solutions, LLC 5120 Woodway Drive Suite 5004 Houston TX 77056
1164   2020-06-19 Jolly Stuart 6682 6682 2019-05-19 Linden Government Solutions, LLC 5120 Woodway Drive Suite 5004 Houston TX 77056
1410   2019-07-29 Hanson James 5974 5974 2010-02-18 Alsalih, Mark K. 6624 Bermuda Dunes Drive   Plano TX 75093
1532   2020-08-17 Okimoto Kenji 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
1839   2019-10-01 Shioiri Emi 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
1919   2019-10-16 Sakurauchi Masahiro 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
2021   2017-10-30 Nakagawa Naoto 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
2188   2018-11-27 Alghamdi Adel Misfer 4184 4184 1988-10-13 Saudi Refining, Inc. One Allen Center 500 Dallas Street Houston TX 77002
2365   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
2506 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
2632 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
2817 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
3059 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
3101 2001-01-04 2001-02-14 Iwano Hiroshi 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
3145 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
3159 2018-01-05 2015-04-22 Kurokawa Junji 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
3350 1987-01-09 1986-08-27 Takamura Taketoshi 3878 3878 1986-08-27 Klein Partnership 1201 Louisiana Suite 3426 Houston TX 77002-5213
3478 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
3484 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
3529 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
3680 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
3988 2013-01-20 2013-01-09 Butt Iqbal Ahmad 5975 5975 2010-02-25 PTI USA, LLC 315 Maple Street   Richardson TX 75081
3989 2013-01-20 2013-02-24 Mirza Mohammad Akram 5975 5975 2010-02-25 PTI USA, LLC 315 Maple Street   Richardson TX 75081
3990 2013-01-20 2012-09-17 Asad Khan Muhammad 5975 5975 2010-02-25 PTI USA, LLC 315 Maple Street   Richardson TX 75081
3991 2013-01-20 2012-12-19 Khan Sherry Safdar 5975 5975 2010-02-25 PTI USA, LLC 315 Maple Street   Richardson TX 75081
4137 1983-01-24 1978-01-19 Mouffok Lahouari 2298 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
4138 1983-01-24 1978-04-05 Mir Omar 2298 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
4139 1983-01-24 1978-12-22 Mapes William R. , Jr. 2298 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
4165 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
4698 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
4717 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
4757 1981-01-31 1981-01-22 Kara Abdelhamid 2298 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
4760 1981-01-31 1980-07-21 Berkane Abdelghani 2298 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
4836 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
4964 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
4986 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
5009 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
5013 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
5014 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
5018 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
5019 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
5020 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
5029 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
5030 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
5035 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
5036 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
5937 1980-02-06 1978-04-05 Benbrahim Mohamed 2298 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
6073 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
6074 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
6075 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
6076 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
6077 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
6241 1990-02-10 1988-12-02 Nakata Yutaka 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
6345 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
6559 2014-02-14 2013-04-23 Shimada Aki 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
7168 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
7261 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
7498 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
7614 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
7615 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
7838 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
7972 2019-02-28 2017-10-30 Uchida Kaori 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
8261 1979-03-01 1977-02-17 Brahimi Abdelhamid 2298 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
8280 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
8295 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
8469 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
8477 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
8615 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
8649 1976-03-05 1975-01-24 Stovall James T. , III 2298 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
8652 1976-03-05 1971-12-17 Guellal Cherif 2298 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
8928 1974-03-08 1971-11-04 Bresenhan Karoline 2287 2287 1971-11-04 Bozell & Jacobs, Inc. 2 Allen Center Suite 2000 Houston TX 77002
8986 1979-03-09 1977-08-03 Inoue Hiro 2818 2818 1977-08-03 Unicorp International, Inc. 4835 LBJ Freeway Suite 630 Dallas TX 75234
8987 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
9091 1982-03-11 1979-05-18 Suganuma Koki 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
9171 1985-03-12 1981-05-28 Kitade Akira 2348 2348 1972-07-03 Japan National Tourist Organization, Dallas 2121 San Jacinto Street Suite 980 - LB-53 Dallas TX 75201
9203 2004-03-12 2001-08-13 Kobara Makoto 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
9241 1992-03-13 1989-08-07 Oishi Shintaro 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
9512 1996-03-16 1992-10-29 Nemoto Hiroyuki 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010

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 330.056ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history