home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for 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

334 rows where City = "Houston"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registration_Number >30

  • JETRO, Houston 80
  • Saudi Refining, Inc. 45
  • Caribbean Tourism Organization, USA Inc. 30
  • Sonatrach, Inc. 26
  • Aramco Affiliated Services Company (AASC) 11
  • CITGO Petroleum Corporation (CPC) 9
  • Dale Henderson, Inc. 8
  • Bozell & Jacobs, Inc. 7
  • Fogarty Klein & Partners Public Relations 7
  • CITGO Petroleum Corporation ("CPC") 7
  • Bankers Capital Management, Inc. 6
  • Fulbright & Jaworski, LLP 6
  • Linden Government Solutions, LLC 6
  • Austrian Trade Commission in the U.S., Houston 5
  • Klein Partnership 5
  • Team Eagle 5
  • Pakistan Tehreek-E-Insaf USA, LLC 5
  • PDV Holding, Inc. (PDVH) 5
  • Brouillard Communications 4
  • CITGO Holding, Inc. (CITGOH) 4
  • Mel Anderson Communications, Inc. 3
  • Bozell & Jacobs, Inc. 3
  • Campos Communications, Inc. 3
  • Brown Nelson & Associates, Inc. 3
  • Fogarty Klein Monroe 3
  • Mexican Ministry of Tourism, Houston 2
  • Aylin Advertising Agency, Inc. 2
  • A.R. Busse & Associates, Inc. 2
  • James Finlay International, Inc. 2
  • Government of Alberta, Canada 2
  • …

Registrant_Name >30

  • JETRO, Houston 80
  • Saudi Refining, Inc. 45
  • Caribbean Tourism Organization, USA Inc. 30
  • Sonatrach, Inc. 26
  • Aramco Affiliated Services Company (AASC) 11
  • Bozell & Jacobs, Inc. 10
  • CITGO Petroleum Corporation (CPC) 9
  • Dale Henderson, Inc. 8
  • CITGO Petroleum Corporation ("CPC") 7
  • Fogarty Klein & Partners Public Relations 7
  • Fulbright & Jaworski, LLP 7
  • Bankers Capital Management, Inc. 6
  • Linden Government Solutions, LLC 6
  • Austrian Trade Commission in the U.S., Houston 5
  • Klein Partnership 5
  • PDV Holding, Inc. (PDVH) 5
  • Pakistan Tehreek-E-Insaf USA, LLC 5
  • Team Eagle 5
  • A.R. Busse & Associates, Inc. 4
  • Brouillard Communications 4
  • CITGO Holding, Inc. (CITGOH) 4
  • Campos Communications, Inc. 4
  • Brown Nelson & Associates, Inc. 3
  • Fogarty Klein Monroe 3
  • Mel Anderson Communications, Inc. 3
  • Aylin Advertising Agency, Inc. 2
  • Carlberg & Associates, Inc. 2
  • Gerger Hennessy & McFarlane LLP 2
  • German State of Rheinland-Pfalz Commercial Office 2
  • Government of Alberta, Canada 2
  • …

State 2

  • TX 304
  • - 30

City 1

  • Houston · 334 ✖
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
622 622   2012-03-27 Bramble Sylma Brown Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
665 665   2022-03-30 Jordá Carlos E. CITGO Holding, Inc. (CITGOH) 6995 2021-08-20 CITGO Holding, Inc. (CITGOH) 1293 Eldridge Parkway   Houston TX 77077
666 666   2022-03-30 Lynch Jr John E CITGO Holding, Inc. (CITGOH) 6995 2021-08-20 CITGO Holding, Inc. (CITGOH) 1293 Eldridge Parkway   Houston TX 77077
667 667   2022-03-30 Vera Fernando J CITGO Holding, Inc. (CITGOH) 6995 2021-08-20 CITGO Holding, Inc. (CITGOH) 1293 Eldridge Parkway   Houston TX 77077
668 668   2022-03-30 Vera Fernando J. CITGO Petroleum Corporation (CPC) 6996 2021-08-20 CITGO Petroleum Corporation (CPC) 1293 Eldridge Parkway   Houston TX 77077
669 669   2022-03-30 Wilhelm Samuel CITGO Petroleum Corporation (CPC) 6996 2021-08-20 CITGO Petroleum Corporation (CPC) 1293 Eldridge Parkway   Houston TX 77077
793 793   2013-04-23 Sanders Keith JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
907 907   2022-05-09 Yousef Sameer Aramco Affiliated Services Company (AASC) 6390 2016-11-14 Aramco Affiliated Services Company (AASC) Two Allen Center 1200 Smith Street, 36th Floor Houston TX 77002
998 998   2022-05-25 Biltagi Rania Aramco Affiliated Services Company (AASC) 6390 2016-11-14 Aramco Affiliated Services Company (AASC) Two Allen Center 1200 Smith Street, 36th Floor Houston TX 77002
1210 1210   2021-06-29 Alafaleg Nabeel I. Aramco Affiliated Services Company (AASC) 6390 2016-11-14 Aramco Affiliated Services Company (AASC) Two Allen Center 1200 Smith Street, 36th Floor Houston TX 77002
1295 1295   2022-07-19 Loftis James Lloyd Vinson & Elkins LLP 7142 2022-07-19 Vinson & Elkins LLP 845 Texas Avenue Suite 4700 Houston TX 77002
1348 1348   2021-07-28 Walters Neil Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
1469 1469   2020-08-17 Okimoto Kenji JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
1485 1485   2021-08-20 Jorda Carlos E. CITGO Petroleum Corporation (CPC) 6996 2021-08-20 CITGO Petroleum Corporation (CPC) 1293 Eldridge Parkway   Houston TX 77077
1486 1486   2021-08-20 Lynch Jr. John E. CITGO Petroleum Corporation (CPC) 6996 2021-08-20 CITGO Petroleum Corporation (CPC) 1293 Eldridge Parkway   Houston TX 77077
1490 1490   2021-08-20 Vera Fernando J. PDV Holding, Inc. (PDVH) 6997 2021-08-20 PDV Holding, Inc. (PDVH) 1293 Eldridge Parkway   Houston TX 77077
1491 1491   2021-08-20 Wilhelm Samuel CITGO Holding, Inc. (CITGOH) 6995 2021-08-20 CITGO Holding, Inc. (CITGOH) 1293 Eldridge Parkway   Houston TX 77077
1492 1492   2021-08-20 Wilhelm Samuel PDV Holding, Inc. (PDVH) 6997 2021-08-20 PDV Holding, Inc. (PDVH) 1293 Eldridge Parkway   Houston TX 77077
1590 1590   2022-09-06 Mubarak Ammar Aramco Affiliated Services Company (AASC) 6390 2016-11-14 Aramco Affiliated Services Company (AASC) Two Allen Center 1200 Smith Street, 36th Floor Houston TX 77002
1626 1626   2022-09-13 Borges Fabio Aramco Affiliated Services Company (AASC) 6390 2016-11-14 Aramco Affiliated Services Company (AASC) Two Allen Center 1200 Smith Street, 36th Floor Houston TX 77002
1702 1702   2021-09-24 Robbins Kate CITGO Petroleum Corporation (CPC) 6996 2021-08-20 CITGO Petroleum Corporation (CPC) 1293 Eldridge Parkway   Houston TX 77077
1749 1749   2022-09-30 Jordá Carlos E PDV Holding, Inc. (PDVH) 6997 2021-08-20 PDV Holding, Inc. (PDVH) 1293 Eldridge Parkway   Houston TX 77077
1753 1753   2019-10-01 Shioiri Emi JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
1763 1763   2021-10-05 Zuklic John David CITGO Petroleum Corporation (CPC) 6996 2021-08-20 CITGO Petroleum Corporation (CPC) 1293 Eldridge Parkway   Houston TX 77077
1842 1842   2019-10-16 Sakurauchi Masahiro JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
1858 1858   2022-10-19 Hirasawa Yuka JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
1860 1860   2022-10-19 killian Chika JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
1919 1919   2021-10-27 Schmidt Karl D. CITGO Petroleum Corporation (CPC) 6996 2021-08-20 CITGO Petroleum Corporation (CPC) 1293 Eldridge Parkway   Houston TX 77077
2115 2115   2021-11-24 AlAfaleg Nabeel I. Saudi Refining, Inc. 4184 1988-10-13 Saudi Refining, Inc. One Allen Center 500 Dallas Street Houston TX 77002
2394 2394   2021-12-30 Harbi Bader A. Aramco Affiliated Services Company (AASC) 6390 2016-11-14 Aramco Affiliated Services Company (AASC) Two Allen Center 1200 Smith Street, 36th Floor Houston TX 77002
2434 2434 1962-01-01 1961-09-05 Illenberger Theodora Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
2488 2488 1977-01-01 1971-11-04 Welch William F. Bozell & Jacobs, Inc. 2287 1971-11-04 Bozell & Jacobs, Inc. 2 Allen Center Suite 2000 Houston TX 77002
2799 2799 2011-01-01 2001-11-06 Durnerin Veronique M. OIC Services, Inc. 5481 2001-11-06 OIC Services, Inc. 12337 Jones Road Suite 301 Houston TX 77070
3058 3058 1979-01-04 1974-07-30 Busse Alvin R. A.R. Busse & Associates, Inc. 2408 1973-02-21 A.R. Busse & Associates, Inc. 1333 West Loop, South Suite 1230 Houston TX 77027
3100 3100 2001-01-04 2001-02-14 Iwano Hiroshi JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
3160 3160 2018-01-05 2015-04-22 Kurokawa Junji JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
3167 3167 1959-01-06 1958-02-03 Tilker Kay Burr Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
3389 3389 1987-01-09 1986-08-27 Takamura Taketoshi Klein Partnership 3878 1986-08-27 Klein Partnership 1201 Louisiana Suite 3426 Houston TX 77002-5213
3523 3523 1987-01-12 1986-03-19 Jones B. Calvin Jones, B. Calvin 3800 1986-03-19 Jones, B. Calvin 3000 South Post Oak Suite 100 Houston TX 77056
3541 3541 2021-01-12 2019-04-12 McKisick Sheridan JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
3576 3576 2005-01-13 2004-03-26 Feldhaus Stephen M. Fulbright & Jaworski, LLP 5615 2004-03-26 Fulbright & Jaworski, LLP 1301 McKinney Suite 5100 Houston TX 77010-3095
3751 3751 2021-01-15 2019-05-19 Payne Stephen Linden Government Solutions, LLC 6682 2019-05-19 Linden Government Solutions, LLC 5120 Woodway Drive Suite 5004 Houston TX 77056
3752 3752 2021-01-15 2019-05-28 Fleming Joseph Linden Government Solutions, LLC 6682 2019-05-19 Linden Government Solutions, LLC 5120 Woodway Drive Suite 5004 Houston TX 77056
4236 4236 1983-01-24 1978-01-19 Mouffok Lahouari Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
4237 4237 1983-01-24 1978-04-05 Mir Omar Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
4238 4238 1983-01-24 1978-12-22 Mapes William R. , Jr. Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
4805 4805 1963-01-31 1961-01-18 Craig Nicholas Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
4867 4867 1981-01-31 1981-01-22 Kara Abdelhamid Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
4870 4870 1981-01-31 1980-07-21 Berkane Abdelghani Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
4946 4946 1990-01-31 1989-05-12 Sharr Seth L. Saudi Refining, Inc. 4184 1988-10-13 Saudi Refining, Inc. One Allen Center 500 Dallas Street Houston TX 77002
5010 5010 1992-01-31 1971-10-27 Lee Minnette H. Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
5074 5074 1997-01-31 1995-07-21 Rosenberg Richelle A. Carlberg & Associates, Inc. 5037 1995-07-21 Carlberg & Associates, Inc. 2800 Post Oak Boulevard Suite 3400 Houston TX 77056-6106
5096 5096 1999-01-31 1990-05-14 Woelfel Frank R. Saudi Refining, Inc. 4184 1988-10-13 Saudi Refining, Inc. One Allen Center 500 Dallas Street Houston TX 77002
5538 5538 1960-02-01 1959-09-10 Cobean Anne M. Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
6106 6106 1980-02-06 1978-04-05 Benbrahim Mohamed Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
6250 6250 1980-02-08 1980-02-08 Baker W. Randolph Dale Henderson, Inc. 2926 1978-07-06 Dale Henderson, Inc. 2200 North Loop West Suite 100 Houston TX 77018
6251 6251 1980-02-08 1978-07-06 Babb Terry M. Dale Henderson, Inc. 2926 1978-07-06 Dale Henderson, Inc. 2200 North Loop West Suite 100 Houston TX 77018
6252 6252 1980-02-08 1978-07-06 Henderson Claudine L. Dale Henderson, Inc. 2926 1978-07-06 Dale Henderson, Inc. 2200 North Loop West Suite 100 Houston TX 77018
6253 6253 1980-02-08 1978-07-06 Henderson H. Dale Dale Henderson, Inc. 2926 1978-07-06 Dale Henderson, Inc. 2200 North Loop West Suite 100 Houston TX 77018
6254 6254 1980-02-08 1978-07-06 McElwain William E. Dale Henderson, Inc. 2926 1978-07-06 Dale Henderson, Inc. 2200 North Loop West Suite 100 Houston TX 77018
6422 6422 1990-02-10 1988-12-02 Nakata Yutaka JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
6748 6748 2014-02-14 2013-04-23 Shimada Aki JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
7870 7870 1994-02-28 1992-03-11 Ellis Rodney G. Solar & Ellis, L.L.P. 4630 1992-03-11 Solar & Ellis, L.L.P. 1331 Lamar Suite 1550 Houston TX 77010
7871 7871 1994-02-28 1992-03-11 Solar J. Michael Solar & Ellis, L.L.P. 4630 1992-03-11 Solar & Ellis, L.L.P. 1331 Lamar Suite 1550 Houston TX 77010
8094 8094 2007-02-28 2007-12-28 McNabb Stephen M. Fulbright & Jaworski, LLP 5842 2007-12-28 Fulbright & Jaworski, LLP 1301 McKinney #5100 Fulbright Tower Houston TX 77010-3095
8230 8230 2019-02-28 2017-10-30 Uchida Kaori JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
8590 8590 1979-03-01 1977-02-17 Brahimi Abdelhamid Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
8609 8609 1984-03-01 1980-09-19 Jones B. Calvin Jones, B. Calvin 3150 1980-09-19 Jones, B. Calvin 3000 South Post Oak Suite 100 Houston TX 77056
9007 9007 1976-03-05 1975-01-24 Stovall James T. , III Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
9010 9010 1976-03-05 1971-12-17 Guellal Cherif Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
9290 9290 1974-03-08 1971-11-04 Bresenhan Karoline Bozell & Jacobs, Inc. 2287 1971-11-04 Bozell & Jacobs, Inc. 2 Allen Center Suite 2000 Houston TX 77002
9461 9461 1982-03-11 1979-05-18 Suganuma Koki JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
9579 9579 2004-03-12 2001-08-13 Kobara Makoto JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
9617 9617 1992-03-13 1989-08-07 Oishi Shintaro JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
9900 9900 1996-03-16 1992-10-29 Nemoto Hiroyuki JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
9976 9976 1990-03-17 1990-03-19 Al-Eady Mohammed A. Saudi Refining, Inc. 4184 1988-10-13 Saudi Refining, Inc. One Allen Center 500 Dallas Street Houston TX 77002
9977 9977 1990-03-17 1990-03-19 Al-Isa Abdulla I. Saudi Refining, Inc. 4184 1988-10-13 Saudi Refining, Inc. One Allen Center 500 Dallas Street Houston TX 77002
9978 9978 1990-03-17 1990-03-19 Al-Mulhim Ibrahim A. Saudi Refining, Inc. 4184 1988-10-13 Saudi Refining, Inc. One Allen Center 500 Dallas Street Houston TX 77002
9979 9979 1990-03-17 1990-03-19 Al-Qamarah Ali H. Saudi Refining, Inc. 4184 1988-10-13 Saudi Refining, Inc. One Allen Center 500 Dallas Street Houston TX 77002
9980 9980 1990-03-17 1990-03-19 Al-Umairy Abdul Rahman A. Saudi Refining, Inc. 4184 1988-10-13 Saudi Refining, Inc. One Allen Center 500 Dallas Street Houston TX 77002
10450 10450 1994-03-23 1992-01-24 Campos Marc A. Campos Communications, Inc. 4609 1992-01-24 Campos Communications, Inc. 816 Ralfallen   Houston TX 77008
10451 10451 1994-03-23 1992-01-24 Campos Tony Campos Communications, Inc. 4609 1992-01-24 Campos Communications, Inc. 816 Ralfallen   Houston TX 77008
10593 10593 1995-03-25 1992-05-19 Sato Yoshiki JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
10738 10738 2013-03-27 2008-11-03 Kimura Makoto JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
10905 10905 2002-03-29 1992-02-28 Youngman Michael J. Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
11022 11022 2004-03-30 2002-06-14 Ozawa Jingo JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
11328 11328 1981-03-31 1980-04-01 Bousselham Mohammed Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
11329 11329 1981-03-31 1980-04-01 Rerbal Mohammed Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
11333 11333 1981-03-31 1980-07-21 Rahali Mohamed L. Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
11441 11441 1989-03-31 1988-10-13 Schultz Thomas Q. Saudi Refining, Inc. 4184 1988-10-13 Saudi Refining, Inc. One Allen Center 500 Dallas Street Houston TX 77002
11457 11457 1990-03-31 1987-09-29 Doll David M. Bankers Capital Management, Inc. 4044 1987-09-29 Bankers Capital Management, Inc. 601 Milam 6901 Texas Commerce Tower Houston TX 77002
11458 11458 1990-03-31 1987-09-29 Graham Michael Bankers Capital Management, Inc. 4044 1987-09-29 Bankers Capital Management, Inc. 601 Milam 6901 Texas Commerce Tower Houston TX 77002
11459 11459 1990-03-31 1987-09-29 Graham Patrick Harold Bankers Capital Management, Inc. 4044 1987-09-29 Bankers Capital Management, Inc. 601 Milam 6901 Texas Commerce Tower Houston TX 77002
11460 11460 1990-03-31 1987-09-29 LeGaye Daniel E. Bankers Capital Management, Inc. 4044 1987-09-29 Bankers Capital Management, Inc. 601 Milam 6901 Texas Commerce Tower Houston TX 77002
11461 11461 1990-03-31 1987-09-29 Loder Barry Charles Bankers Capital Management, Inc. 4044 1987-09-29 Bankers Capital Management, Inc. 601 Milam 6901 Texas Commerce Tower Houston TX 77002
11462 11462 1990-03-31 1987-09-29 Trevino Daniel K. , III Bankers Capital Management, Inc. 4044 1987-09-29 Bankers Capital Management, Inc. 601 Milam 6901 Texas Commerce Tower Houston TX 77002
11627 11627 1998-03-31 1996-10-21 Russell Burnell J. Oceans International Corporation 5134 1996-10-26 Oceans International Corporation 5005 Mitchelldale Suite 121 Houston TX 77092
11863 11863 2009-03-31 2009-01-23 Zimmerman Bruce V. Saudi Refining, Inc. 4184 1988-10-13 Saudi Refining, Inc. One Allen Center 500 Dallas Street Houston TX 77002
12015 12015 2016-03-31 2014-04-25 Maeda Shinobu JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
12354 12354 2010-04-01 2006-05-09 Kurita Kaoru JETRO, Houston 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 · Queries took 289.634ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history