FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
25 rows where "Registration_Date" is on date 1999-07-21
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Address_2, Short_Form_Termination_Date (date), Registration_Date (date)
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 | ||
3629 | 3629 | 2001-01-12 | 2000-08-31 | Fox | James Edward | Carmen Group, Inc. 5320 | 1999-07-21 | Carmen Group, Inc. | 1299 Pennsylvania Avenue, N.W. | Suite 800 West | Washington | DC | 20004 |
5229 | 5229 | 2001-01-31 | 2000-02-29 | Strow | Christopher James Reid | Carmen Group, Inc. 5320 | 1999-07-21 | Carmen Group, Inc. | 1299 Pennsylvania Avenue, N.W. | Suite 800 West | Washington | DC | 20004 |
5238 | 5238 | 2001-01-31 | 1999-07-21 | Carmen | Gerald P. | Carmen Group, Inc. 5320 | 1999-07-21 | Carmen Group, Inc. | 1299 Pennsylvania Avenue, N.W. | Suite 800 West | Washington | DC | 20004 |
5241 | 5241 | 2001-01-31 | 1999-08-04 | Stevens, Jr. | Jack R. | Carmen Group, Inc. 5320 | 1999-07-21 | Carmen Group, Inc. | 1299 Pennsylvania Avenue, N.W. | Suite 800 West | Washington | DC | 20004 |
5248 | 5248 | 2001-01-31 | 1999-09-24 | Adesnik | Ryan M. | Carmen Group, Inc. 5320 | 1999-07-21 | Carmen Group, Inc. | 1299 Pennsylvania Avenue, N.W. | Suite 800 West | Washington | DC | 20004 |
5808 | 5808 | 2000-02-01 | 1999-09-24 | Burkett | Robert L. | Carmen Group, Inc. 5320 | 1999-07-21 | Carmen Group, Inc. | 1299 Pennsylvania Avenue, N.W. | Suite 800 West | Washington | DC | 20004 |
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 | |
21364 | 21364 | 2000-06-30 | 1999-08-18 | Hannaford | Peter D. | Carmen Group, Inc. 5320 | 1999-07-21 | Carmen Group, Inc. | 1299 Pennsylvania Avenue, N.W. | Suite 800 West | Washington | DC | 20004 |
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 | |
26756 | 26756 | 2000-08-15 | 1999-07-21 | Barton | Trent A. | Carmen Group, Inc. 5320 | 1999-07-21 | Carmen Group, Inc. | 1299 Pennsylvania Avenue, N.W. | Suite 800 West | Washington | DC | 20004 |
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]) );