FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where Document_Type = "Short-Form" and Registrant_Name = "Moroccan National Tourist Office"
This data as json, CSV (advanced)
Registrant_Name 1
- Moroccan National Tourist Office · 10 ✖
Foreign_Principal_Name 1
- - 10
Foreign_Principal_Country 1
- - 10
Document_Type 1
- Short-Form · 10 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
3163 | 3163 | 1978-01-04 | Moroccan National Tourist Office | Moroccan National Tourist Office 1793 | Short-Form | Available-FARA-Public-Office | |||
3164 | 3164 | 1978-01-04 | Moroccan National Tourist Office | Moroccan National Tourist Office 1793 | Short-Form | Available-FARA-Public-Office | |||
3165 | 3165 | 1978-01-04 | Moroccan National Tourist Office | Moroccan National Tourist Office 1793 | Short-Form | Available-FARA-Public-Office | |||
26596 | 26596 | 1969-03-10 | Moroccan National Tourist Office | Moroccan National Tourist Office 1793 | Short-Form | Available-FARA-Public-Office | |||
43502 | 43502 | 1965-04-28 | Moroccan National Tourist Office | Moroccan National Tourist Office 1793 | Short-Form | Available-FARA-Public-Office | |||
53187 | 53187 | 2011-05-19 | Moroccan National Tourist Office | Moroccan National Tourist Office 1793 | Short-Form | Aberaouz, Hamid | https://efile.fara.gov/docs/1793-Short-Form-20110519-20.pdf | ||
53188 | 53188 | 2011-05-19 | Moroccan National Tourist Office | Moroccan National Tourist Office 1793 | Short-Form | Ghadouani, Chakib El Mokhtar | https://efile.fara.gov/docs/1793-Short-Form-20110519-18.pdf | ||
74549 | 74549 | 1965-07-08 | Moroccan National Tourist Office | Moroccan National Tourist Office 1793 | Short-Form | Available-FARA-Public-Office | |||
99271 | 99271 | 1964-09-21 | Moroccan National Tourist Office | Moroccan National Tourist Office 1793 | Short-Form | Available-FARA-Public-Office | |||
129507 | 129507 | 1972-12-07 | Moroccan National Tourist Office | Moroccan National Tourist Office 1793 | Short-Form | Available-FARA-Public-Office |
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]) );