FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

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

26 rows where Registration_Number = 2298

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date, Short_Form_First_Name, Short_Form_Date (date)

State 1

Registration_Number 1

  • Sonatrach, Inc. · 26 ✖

Registrant_Name 1

City 1

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
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
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
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
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
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
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
18440 18440 1980-06-01 1980-04-01 Bouhaddouda Hammoudi Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
20970 20970 1981-06-30 1981-01-22 Bettahar Salem Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
24716 24716 1981-07-31 1980-04-01 Djabelkheir Djamel Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
24717 24717 1981-07-31 1980-04-01 Skakni Said Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
25513 25513 1980-08-01 1977-08-03 Benghomrani Abderrahimane Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
31839 31839 1976-10-01 1976-07-23 Rezkallah Adbel Kader Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
34882 34882 1980-11-01 1978-04-05 Rouabah Abderrachid Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
35815 35815 1980-11-15 1977-06-19 Bitam Abdellah Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
38378 38378 1980-12-15 1981-01-22 Kacemi Abderrahmane Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
38379 38379 1980-12-15 1980-07-21 Yakoub Bachir Sidi Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
38493 38493 1974-12-16 1971-12-17 Schultz Frank A. Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
40116 40116 1980-12-31 1981-01-22 Labbani Larbi Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
40154 40154 1980-12-31 1980-07-21 Boumaiza Mohamed Sonatrach, Inc. 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027

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])
);