FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where City = "New York" and Registrant_Name = "Saudi Petroleum International, Inc."
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_Last_Name, Short_Form_First_Name, Short_Form_Termination_Date (date), Registration_Date (date)
State 1
- NY 17
Registration_Number 1
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
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]) );