FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where Foreign_Principal_Country = "ISRAEL" and Foreign_Principal_Name = "Government of Israel, Ministry of Tourism (through the Israeli Government Advertising Agency LAPAM)" sorted by Date_Stamped
This data as json, CSV (advanced)
Date_Stamped (date) 5 ✖
- 2018-12-21 4
- 2019-01-30 1
- 2019-02-01 1
- 2020-01-06 1
- 2021-05-21 1
Registrant_Name 2
Document_Type 2
Foreign_Principal_Name 1
- Government of Israel, Ministry of Tourism (through the Israeli Government Advertising Agency LAPAM) · 8 ✖
Foreign_Principal_Country 1
- ISRAEL · 8 ✖
Link | rowid | Date_Stamped ▼ | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
132603 | 132603 | 2018-12-21 | 6622 | Havas Media Group USA LLC 6622 | Informational Materials | Government of Israel, Ministry of Tourism (through the Israeli Government Advertising Agency LAPAM) | ISRAEL | https://efile.fara.gov/docs/6622-Informational-Materials-20181221-6.pdf | |
132604 | 132604 | 2018-12-21 | 6622 | Havas Media Group USA LLC 6622 | Informational Materials | Government of Israel, Ministry of Tourism (through the Israeli Government Advertising Agency LAPAM) | ISRAEL | https://efile.fara.gov/docs/6622-Informational-Materials-20181221-7.pdf | |
132605 | 132605 | 2018-12-21 | 6622 | Havas Media Group USA LLC 6622 | Informational Materials | Government of Israel, Ministry of Tourism (through the Israeli Government Advertising Agency LAPAM) | ISRAEL | https://efile.fara.gov/docs/6622-Informational-Materials-20181221-8.pdf | |
132669 | 132669 | 2018-12-21 | Media Planning International Corporation | Media Planning International Corporation 6621 | Exhibit AB | Government of Israel, Ministry of Tourism (through the Israeli Government Advertising Agency LAPAM) | ISRAEL | https://efile.fara.gov/docs/6621-Exhibit-AB-20181221-1.pdf | |
9256 | 9256 | 2019-01-30 | Media Planning International Corporation | Media Planning International Corporation 6621 | Informational Materials | Government of Israel, Ministry of Tourism (through the Israeli Government Advertising Agency LAPAM) | ISRAEL | https://efile.fara.gov/docs/6621-Informational-Materials-20190130-2.pdf | |
13446 | 13446 | 2019-02-01 | Media Planning International Corporation | Media Planning International Corporation 6621 | Informational Materials | Government of Israel, Ministry of Tourism (through the Israeli Government Advertising Agency LAPAM) | ISRAEL | https://efile.fara.gov/docs/6621-Informational-Materials-20190201-1.pdf | |
3727 | 3727 | 2020-01-06 | Media Planning International Corporation | Media Planning International Corporation 6621 | Informational Materials | Government of Israel, Ministry of Tourism (through the Israeli Government Advertising Agency LAPAM) | ISRAEL | https://efile.fara.gov/docs/6621-Informational-Materials-20200106-6.pdf | |
53832 | 53832 | 2021-05-21 | Media Planning International Corporation | Media Planning International Corporation 6621 | Informational Materials | Government of Israel, Ministry of Tourism (through the Israeli Government Advertising Agency LAPAM) | ISRAEL | https://efile.fara.gov/docs/6621-Informational-Materials-20210521-8.pdf |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_RegistrantDocs] ( [Date_Stamped] TEXT, [Registrant_Name] TEXT, [Registration_Number] INTEGER, [Document_Type] TEXT, [Short_Form_Name] TEXT, [Foreign_Principal_Name] TEXT, [Foreign_Principal_Country] TEXT, [URL] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );