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

17 rows where Registration_Number = 5321

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Last_Name, Registration_Date (date)

State 1

  • NY 17

Registration_Number 1

  • Saudi Petroleum International, Inc. · 17 ✖

Registrant_Name 1

  • Saudi Petroleum International, Inc. 17

City 1

  • New York 17
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
476 476   2023-03-01 List Robert Saudi Petroleum International, Inc. 5321 1999-07-21 Saudi Petroleum International, Inc. 52 Madison Avenue   New York NY 10022
1501 1501   1999-07-28 McAward Patrick J. Saudi Petroleum International, Inc. 5321 1999-07-21 Saudi Petroleum International, Inc. 52 Madison Avenue   New York NY 10022
1716 1716   2016-09-03 Al-Hokail Samer Saudi Petroleum International, Inc. 5321 1999-07-21 Saudi Petroleum International, Inc. 52 Madison Avenue   New York NY 10022
12517 12517 2003-04-01 2000-10-05 Al-Tubayyeb Adil Saudi Petroleum International, Inc. 5321 1999-07-21 Saudi Petroleum International, Inc. 52 Madison Avenue   New York NY 10022
18702 18702 2022-06-02 1999-07-21 Cassidy Robert H. Saudi Petroleum International, Inc. 5321 1999-07-21 Saudi Petroleum International, Inc. 52 Madison Avenue   New York NY 10022
21853 21853 2016-06-30 2014-09-16 AlMukhaild Abdulmoshen A Saudi Petroleum International, Inc. 5321 1999-07-21 Saudi Petroleum International, Inc. 52 Madison Avenue   New York NY 10022
23966 23966 2000-07-24 1999-07-21 Rafie Munir Saudi Petroleum International, Inc. 5321 1999-07-21 Saudi Petroleum International, Inc. 52 Madison Avenue   New York NY 10022
31224 31224 1999-09-30 1999-08-06 Chappell David F. Saudi Petroleum International, Inc. 5321 1999-07-21 Saudi Petroleum International, Inc. 52 Madison Avenue   New York NY 10022
31225 31225 1999-09-30 1999-08-06 Doyle Sr. Patrick J. Saudi Petroleum International, Inc. 5321 1999-07-21 Saudi Petroleum International, Inc. 52 Madison Avenue   New York NY 10022
31226 31226 1999-09-30 1999-08-06 Findeisen James A. Saudi Petroleum International, Inc. 5321 1999-07-21 Saudi Petroleum International, Inc. 52 Madison Avenue   New York NY 10022
31227 31227 1999-09-30 1999-08-06 Knouse Mark Saudi Petroleum International, Inc. 5321 1999-07-21 Saudi Petroleum International, Inc. 52 Madison Avenue   New York NY 10022
31228 31228 1999-09-30 1999-08-06 Perkins Bill Saudi Petroleum International, Inc. 5321 1999-07-21 Saudi Petroleum International, Inc. 52 Madison Avenue   New York NY 10022
31229 31229 1999-09-30 1999-08-06 Pierobon James Saudi Petroleum International, Inc. 5321 1999-07-21 Saudi Petroleum International, Inc. 52 Madison Avenue   New York NY 10022
31230 31230 1999-09-30 1999-08-06 Schock Carey Saudi Petroleum International, Inc. 5321 1999-07-21 Saudi Petroleum International, Inc. 52 Madison Avenue   New York NY 10022
31231 31231 1999-09-30 1999-08-06 Vilade C. Edwin Saudi Petroleum International, Inc. 5321 1999-07-21 Saudi Petroleum International, Inc. 52 Madison Avenue   New York NY 10022
31232 31232 1999-09-30 1999-08-06 Walker Russell J. Saudi Petroleum International, Inc. 5321 1999-07-21 Saudi Petroleum International, Inc. 52 Madison Avenue   New York NY 10022
32178 32178 2013-10-02 2000-10-16 Walker Russell J. Saudi Petroleum International, Inc. 5321 1999-07-21 Saudi Petroleum International, Inc. 52 Madison Avenue   New York NY 10022

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 698.247ms · 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