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

308 rows where City = "Houston" and State = "TX"

✖
✖
✖

✎ 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 81
  • Saudi Refining, Inc. 45
  • Sonatrach, Inc. 26
  • Aramco Affiliated Services Company (AASC) 11
  • CITGO Petroleum Corporation (CPC) 10
  • 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
  • PDV Holding, Inc. (PDVH) 6
  • Austrian Trade Commission in the U.S., Houston 5
  • Klein Partnership 5
  • Team Eagle 5
  • Pakistan Tehreek-E-Insaf USA, LLC 5
  • CITGO Holding, Inc. (CITGOH) 5
  • Brouillard Communications 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
  • German State of Rheinland-Pfalz Commercial Office 2
  • …

Registrant_Name >30

  • JETRO, Houston 81
  • Saudi Refining, Inc. 45
  • Sonatrach, Inc. 26
  • Aramco Affiliated Services Company (AASC) 11
  • Bozell & Jacobs, Inc. 10
  • CITGO Petroleum Corporation (CPC) 10
  • 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
  • PDV Holding, Inc. (PDVH) 6
  • Austrian Trade Commission in the U.S., Houston 5
  • CITGO Holding, Inc. (CITGOH) 5
  • Klein Partnership 5
  • Pakistan Tehreek-E-Insaf USA, LLC 5
  • Team Eagle 5
  • A.R. Busse & Associates, Inc. 4
  • Brouillard Communications 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
  • J&D International Consulting Services, LLC 2
  • …

State 1

  • TX · 308 ✖

City 1

  • Houston · 308 ✖
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
697 697   2022-03-30 Jordá Carlos E. CITGO Holding, Inc. (CITGOH) 6995 2021-08-20 CITGO Holding, Inc. (CITGOH) 1293 Eldridge Parkway   Houston TX 77077
698 698   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
699 699   2022-03-30 Vera Fernando J CITGO Holding, Inc. (CITGOH) 6995 2021-08-20 CITGO Holding, Inc. (CITGOH) 1293 Eldridge Parkway   Houston TX 77077
700 700   2022-03-30 Vera Fernando J. CITGO Petroleum Corporation (CPC) 6996 2021-08-20 CITGO Petroleum Corporation (CPC) 1293 Eldridge Parkway   Houston TX 77077
701 701   2022-03-30 Wilhelm Samuel CITGO Petroleum Corporation (CPC) 6996 2021-08-20 CITGO Petroleum Corporation (CPC) 1293 Eldridge Parkway   Houston TX 77077
703 703   2023-03-30 Zuklic John David CITGO Holding, Inc. (CITGOH) 6995 2021-08-20 CITGO Holding, Inc. (CITGOH) 1293 Eldridge Parkway   Houston TX 77077
828 828   2023-04-18 Mayu Hobo JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
859 859   2013-04-23 Sanders Keith JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
993 993   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
1003 1003   2023-05-11 Rincon Edgar CITGO Petroleum Corporation (CPC) 6996 2021-08-20 CITGO Petroleum Corporation (CPC) 1293 Eldridge Parkway   Houston TX 77077
1004 1004   2023-05-11 Rincón Edgar PDV Holding, Inc. (PDVH) 6997 2021-08-20 PDV Holding, Inc. (PDVH) 1293 Eldridge Parkway   Houston TX 77077
1107 1107   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
1323 1323   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
1435 1435   2022-07-19 Loftis James Lloyd Vinson & Elkins LLP 7142 2022-07-19 Vinson & Elkins LLP 845 Texas Avenue Suite 4700 Houston TX 77002
1626 1626   2020-08-17 Okimoto Kenji JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
1642 1642   2021-08-20 Jorda Carlos E. CITGO Petroleum Corporation (CPC) 6996 2021-08-20 CITGO Petroleum Corporation (CPC) 1293 Eldridge Parkway   Houston TX 77077
1646 1646   2021-08-20 Vera Fernando J. PDV Holding, Inc. (PDVH) 6997 2021-08-20 PDV Holding, Inc. (PDVH) 1293 Eldridge Parkway   Houston TX 77077
1647 1647   2021-08-20 Wilhelm Samuel CITGO Holding, Inc. (CITGOH) 6995 2021-08-20 CITGO Holding, Inc. (CITGOH) 1293 Eldridge Parkway   Houston TX 77077
1648 1648   2021-08-20 Wilhelm Samuel PDV Holding, Inc. (PDVH) 6997 2021-08-20 PDV Holding, Inc. (PDVH) 1293 Eldridge Parkway   Houston TX 77077
1735 1735   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
1771 1771   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
1842 1842   2021-09-24 Robbins Kate CITGO Petroleum Corporation (CPC) 6996 2021-08-20 CITGO Petroleum Corporation (CPC) 1293 Eldridge Parkway   Houston TX 77077
1883 1883   2022-09-30 Jordá Carlos E PDV Holding, Inc. (PDVH) 6997 2021-08-20 PDV Holding, Inc. (PDVH) 1293 Eldridge Parkway   Houston TX 77077
1895 1895   2021-10-05 Zuklic John David CITGO Petroleum Corporation (CPC) 6996 2021-08-20 CITGO Petroleum Corporation (CPC) 1293 Eldridge Parkway   Houston TX 77077
1969 1969   2019-10-16 Sakurauchi Masahiro JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
1985 1985   2022-10-19 Hirasawa Yuka JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
1987 1987   2022-10-19 killian Chika JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
2042 2042   2021-10-27 Schmidt Karl D. CITGO Petroleum Corporation (CPC) 6996 2021-08-20 CITGO Petroleum Corporation (CPC) 1293 Eldridge Parkway   Houston TX 77077
2225 2225   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
2484 2484   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
2578 2578 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
2889 2889 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
3154 3154 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
3196 3196 2001-01-04 2001-02-14 Iwano Hiroshi JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
3256 3256 2018-01-05 2015-04-22 Kurokawa Junji JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
3485 3485 1987-01-09 1986-08-27 Takamura Taketoshi Klein Partnership 3878 1986-08-27 Klein Partnership 1201 Louisiana Suite 3426 Houston TX 77002-5213
3620 3620 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
3638 3638 2021-01-12 2019-04-12 McKisick Sheridan JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
3674 3674 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
3849 3849 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
3850 3850 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
4337 4337 1983-01-24 1978-01-19 Mouffok Lahouari Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
4338 4338 1983-01-24 1978-04-05 Mir Omar Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
4339 4339 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
4974 4974 1981-01-31 1981-01-22 Kara Abdelhamid Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
4977 4977 1981-01-31 1980-07-21 Berkane Abdelghani Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
5053 5053 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
5181 5181 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
5203 5203 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
6222 6222 1980-02-06 1978-04-05 Benbrahim Mohamed Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
6368 6368 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
6369 6369 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
6370 6370 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
6371 6371 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
6372 6372 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
6540 6540 1990-02-10 1988-12-02 Nakata Yutaka JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
6877 6877 2014-02-14 2013-04-23 Shimada Aki JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
8003 8003 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
8004 8004 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
8227 8227 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
8363 8363 2019-02-28 2017-10-30 Uchida Kaori JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
8731 8731 1979-03-01 1977-02-17 Brahimi Abdelhamid Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
8750 8750 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
8990 8990 2023-03-02 2019-10-01 Shioiri Emi JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
9151 9151 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
9154 9154 1976-03-05 1971-12-17 Guellal Cherif Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
9448 9448 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
9623 9623 1982-03-11 1979-05-18 Suganuma Koki JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
9741 9741 2004-03-12 2001-08-13 Kobara Makoto JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
9779 9779 1992-03-13 1989-08-07 Oishi Shintaro JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
10063 10063 1996-03-16 1992-10-29 Nemoto Hiroyuki JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
10139 10139 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
10140 10140 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
10141 10141 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
10142 10142 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
10143 10143 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
10614 10614 1994-03-23 1992-01-24 Campos Marc A. Campos Communications, Inc. 4609 1992-01-24 Campos Communications, Inc. 816 Ralfallen   Houston TX 77008
10615 10615 1994-03-23 1992-01-24 Campos Tony Campos Communications, Inc. 4609 1992-01-24 Campos Communications, Inc. 816 Ralfallen   Houston TX 77008
10759 10759 1995-03-25 1992-05-19 Sato Yoshiki JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
10904 10904 2013-03-27 2008-11-03 Kimura Makoto JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
11191 11191 2004-03-30 2002-06-14 Ozawa Jingo JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
11498 11498 1981-03-31 1980-04-01 Bousselham Mohammed Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
11499 11499 1981-03-31 1980-04-01 Rerbal Mohammed Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
11503 11503 1981-03-31 1980-07-21 Rahali Mohamed L. Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
11611 11611 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
11627 11627 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
11628 11628 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
11629 11629 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
11630 11630 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
11631 11631 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
11632 11632 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
11797 11797 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
12033 12033 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
12185 12185 2016-03-31 2014-04-25 Maeda Shinobu JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
12543 12543 2010-04-01 2006-05-09 Kurita Kaoru JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
12651 12651 2008-04-02 1999-07-14 Bosch David D. Saudi Refining, Inc. 4184 1988-10-13 Saudi Refining, Inc. One Allen Center 500 Dallas Street Houston TX 77002
13389 13389 1981-04-15 1981-01-22 Belhadj Ali Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
13651 13651 2007-04-17 2003-08-01 Nakamizo Takashi JETRO, Houston 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
13857 13857 1988-04-21 1984-10-11 Suess Gerhard-Philipp German State of Rheinland-Pfalz Commercial Office 3619 1984-10-11 German State of Rheinland-Pfalz Commercial Office 1800 West Loop, South Suite 1510 Houston TX 77027
13858 13858 1988-04-21 1984-10-11 de Boer Kurt W. German State of Rheinland-Pfalz Commercial Office 3619 1984-10-11 German State of Rheinland-Pfalz Commercial Office 1800 West Loop, South Suite 1510 Houston TX 77027

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 663.262ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows