FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
7 rows where Registrant_Date = "2018-12-21" sorted by Foreign_Principal_Termination_Date
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Registration_Number, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15307 | 15307 | 2018-12-21 | Government of Israel, Ministry of Tourism (through the Israeli Government Advertising Agency LAPAM) | 2018-12-21 | ISRAEL | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | |||||
16848 | 16848 | 2019-12-31 | Civil Organization, Citizen | 2018-12-21 | UKRAINE | Federal Advocates, Inc. 6623 | 2018-12-21 | Federal Advocates, Inc. | |||||
16858 | 16858 | 2019-12-31 | Political Party Justice"" | 2018-12-21 | UKRAINE | Federal Advocates, Inc. 6623 | 2018-12-21 | Federal Advocates, Inc. | |||||
16866 | 16866 | 2019-12-31 | ZESET | 2018-12-21 | UKRAINE | Federal Advocates, Inc. 6623 | 2018-12-21 | Federal Advocates, Inc. | |||||
15165 | 15165 | 2020-12-15 | Atout France-France Tourism Development Agency | 2019-03-08 | FRANCE | Media Planning International Corporation 6621 | 2018-12-21 | Media Planning International Corporation | 79/81 rue de Clichy 75009 Paris | ||||
16902 | 16902 | 2021-12-31 | Government of Israel, Ministry of Tourism (through the Israeli Government Advertising Agency LAPAM) | 2018-12-21 | ISRAEL | Media Planning International Corporation 6621 | 2018-12-21 | Media Planning International Corporation | |||||
8790 | 8790 | 2022-06-30 | Promote Iceland | 2020-10-08 | ICELAND | Media Planning International Corporation 6621 | 2018-12-21 | Media Planning International Corporation | Sundagoro"um 2 104" | Reysavik |
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]) );