FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
1 row where "Date_Stamped" is on date 2023-03-30, Foreign_Principal_Country = "UKRAINE" and Foreign_Principal_Name = "The Government of Ukraine, The Ministry of Culture and Information Policy ("MCIP") through GroupM Sp z.o.o, incorporated in Poland ("GroupM Poland")"
This data as json, CSV (advanced)
These facets timed out: Document_Type, Foreign_Principal_Name, Foreign_Principal_Country
Registrant_Name 1
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
32483 | 32483 | 2023-03-30 | Group M Worldwide, LLC | Group M Worldwide, LLC 7160 | Informational Materials | The Government of Ukraine, The Ministry of Culture and Information Policy ("MCIP") through GroupM Sp z.o.o, incorporated in Poland ("GroupM Poland") | UKRAINE | https://efile.fara.gov/docs/7160-Informational-Materials-20230330-2.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]) );