FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
4 rows where "Foreign_Principal_Termination_Date" is on date 2023-05-31
This data as json, CSV (advanced)
Suggested facets: Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Registrant_Name 4
Foreign_Principal 4
Country/Location_Represented 4
- IRAQ 1
- MONTENEGRO 1
- QATAR 1
- SAUDI ARABIA 1
City 4
- - 1
- Baghdad 1
- Crna Gora 1
- Washington 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7299 | 7299 | 2023-05-31 | Government of Montenegro | 2022-12-23 | MONTENEGRO | Bipartizan Solutions Inc. 7209 | 2022-12-23 | Bipartizan Solutions Inc. | Office of the Prime Minister, Karadordeva bb Podgorica | Crna Gora | |||
7300 | 7300 | 2023-05-31 | Government of Qatar | 2017-06-09 | QATAR | Ashcroft Law Firm, LLC 6438 | 2017-06-09 | Ashcroft Law Firm, LLC | 2555 M Street, NW | Washington | DC | 20037 | |
7301 | 7301 | 2023-05-31 | Ministry of Oil of the Republic of Iraq | 2022-06-03 | IRAQ | Cleary Gottlieb Steen & Hamilton LLP 6964 | 2021-05-25 | Cleary Gottlieb Steen & Hamilton LLP | Oil Complex Building Port Saeed Street | Baghdad | |||
7302 | 7302 | 2023-05-31 | Muslim World League | 2022-06-02 | SAUDI ARABIA | BGR Government Affairs, LLC 5430 | 2001-05-10 | BGR Government Affairs, LLC | 5300, Old Makkah Jeddah Road, Umm Al-Joud | Makkah Al-Mukarramah |
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]) );