FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where Registration_Number = 5321 and State = "NY"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Last_Name, Registration_Date (date)
Short_Form_Date (date) 8 ✖
- 1999-08-06 9
- 1999-07-21 2
- 1999-07-28 1
- 2000-10-05 1
- 2000-10-16 1
- 2014-09-16 1
- 2016-09-03 1
- 2023-03-01 1
State 1
- NY · 17 ✖
Registration_Number 1
- Saudi Petroleum International, Inc. · 17 ✖
Registrant_Name 1
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]) );