FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
7 rows where Address_1 = "Jeddah" and Country/Location_Represented = "SAUDI ARABIA" sorted by Registrant_Date
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 7
Foreign_Principal 7
State 1
- - 7
Country/Location_Represented 1
- SAUDI ARABIA · 7 ✖
City 1
- - 7
Link | rowid | Foreign_Principal_Termination_Date | Foreign_Principal | Foreign_Principal_Registration_Date | Country/Location_Represented | Registration_Number | Registrant_Date ▼ | Registrant_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13919 | 13919 | 1972-11-13 | Saudi Arabian Government | 1972-03-15 | SAUDI ARABIA | Ivins, Phillips & Barker 2326 | 1972-03-15 | Ivins, Phillips & Barker | Jeddah | ||||
4906 | 4906 | 1987-04-01 | Foreign Ministry, Kingdom of Saudi Arabia | 1978-03-17 | SAUDI ARABIA | LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 | 1978-03-17 | LeBoeuf, Lamb, Greene & MacRae, L.L.P. | Jeddah | ||||
5005 | 5005 | 1987-04-03 | Ministry of Foreign Affairs, Kingdom of Saudi Arabia | 1978-03-17 | SAUDI ARABIA | Conner, Stephen N. 2870 | 1978-03-17 | Conner, Stephen N. | Jeddah | ||||
1372 | 1372 | 1991-01-16 | Foreign Liaison Bureau | 1981-09-01 | SAUDI ARABIA | Cook, J. Crawford 3191 | 1981-01-22 | Cook, J. Crawford | Jeddah | ||||
1760 | 1760 | 1991-01-31 | Taher Group of Companies | 1990-10-16 | SAUDI ARABIA | Pintak/Brown International 4424 | 1990-10-16 | Pintak/Brown International | Jeddah | ||||
13318 | 13318 | 1991-10-31 | Sheikh Kamal Adham | 1991-09-23 | SAUDI ARABIA | Rogers Jr., Edward M. 4570 | 1991-09-23 | Rogers Jr., Edward M. | Jeddah | ||||
14879 | 14879 | 1996-12-07 | Sheikh Khalid Bin Mahfouz | 1992-07-10 | SAUDI ARABIA | Smith, Lawrence G. 4690 | 1992-07-10 | Smith, Lawrence G. | Jeddah |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_ForeignPrincipals] ( [Foreign_Principal_Termination_Date] TEXT, [Foreign_Principal] TEXT, [Foreign_Principal_Registration_Date] TEXT, [Country/Location_Represented] TEXT, [Registration_Number] INTEGER, [Registrant_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]) );