FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where "Foreign_Principal_Termination_Date" is on date 2021-06-30 sorted by City
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Address_2, Zip, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 9
Registrant_Name 8
Country/Location_Represented 7
- QATAR 3
- AFGHANISTAN 1
- CROATIA 1
- GUYANA 1
- ISRAEL 1
- JAPAN 1
- SAUDI ARABIA 1
City 4
- - 5
- Washington 2
- Georgetown 1
- Kabul 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8778 | 8778 | 2021-06-30 | Public Investment Fund | 2019-02-25 | SAUDI ARABIA | KARV Communications, Inc. 6162 | 2013-04-08 | KARV Communications, Inc. | Alraidah Digital City, Building CS01, Al Nakhil District | P.O. Box 6847 Riyadh 11452 | |||
8780 | 8780 | 2021-06-30 | Qatar Tourism Authority | 2018-04-30 | QATAR | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 24624 Lusail Expy, Doha | ||||
8781 | 8781 | 2021-06-30 | Republic of Croatia | 2011-08-05 | CROATIA | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Dezmanova 10 Zagreb | ||||
8782 | 8782 | 2021-06-30 | Shalom Corps Ltd. (CC) | 2021-01-22 | ISRAEL | Rabinowitz, Inc. d/b/a Bluelight Strategies 6913 | 2021-01-22 | Rabinowitz, Inc. d/b/a Bluelight Strategies | 3 HaTsedef St. | Herzliya | |||
8784 | 8784 | 2021-06-30 | Tokyo Electric Power Company (TEPCO) | 2013-06-15 | JAPAN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1-1-3 Uchisaiwai-cho, Chiyoda-ku, Tokyo | ||||
8776 | 8776 | 2021-06-30 | Co-operative Republic of Guyana | 2021-01-09 | GUYANA | The Cormac Group LLC 6906 | 2021-01-09 | The Cormac Group LLC | 254 South Road & Shiv Chanderpaul Drive | Georgetown | |||
8783 | 8783 | 2021-06-30 | The Islamic Republic of Afghanistan | 2021-06-21 | AFGHANISTAN | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Presidental Place | Kabul | |||
8777 | 8777 | 2021-06-30 | Embassy of the State of Qatar | 2021-03-05 | QATAR | Integrated Strategy Group LLC 6933 | 2021-03-05 | Integrated Strategy Group LLC | 2555 M Street, NW | Washington | DC | 20037 | |
8779 | 8779 | 2021-06-30 | Qatar American Institute | 2020-06-04 | QATAR | Coast to Coast Strategies, LLC 6833 | 2020-06-04 | Coast to Coast Strategies, LLC | 101 Constitution Ave. NW, | Suite 901 East | Washington | DC | 20001 |
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]) );