FARA_All_RegistrantDocs

Table actions
List of URLs to all registrant docs (available in PDF format)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

11 rows where Document_Type = "Informational Materials" and Foreign_Principal_Country = "FRANCE"

✎ View and edit SQL

This data as json, CSV (advanced)

Foreign_Principal_Country 1

  • FRANCE · 11 ✖

Document_Type 1

  • Informational Materials · 11 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
57006 57006 2018-05-31 Quinn & Co. of NY LTD. Quinn & Co. of NY LTD. 6433 Informational Materials   Paris and Ile-de-France through Atout France FRANCE https://efile.fara.gov/docs/6433-Informational-Materials-20180531-10.pdf
78029 78029 2020-07-22 Media Planning International Corporation Media Planning International Corporation 6621 Informational Materials   Atout France-France Tourism Development Agency FRANCE https://efile.fara.gov/docs/6621-Informational-Materials-20200722-7.pdf
86660 86660 2021-08-09 Daniel J. Edelman, Inc. Daniel J. Edelman, Inc. 3634 Informational Materials   AXA FRANCE https://efile.fara.gov/docs/3634-Informational-Materials-20210809-42.pdf
96614 96614 2019-09-09 Media Planning International Corporation Media Planning International Corporation 6621 Informational Materials   Atout France-France Tourism Development Agency FRANCE https://efile.fara.gov/docs/6621-Informational-Materials-20190909-4.pdf
96615 96615 2019-09-09 Media Planning International Corporation Media Planning International Corporation 6621 Informational Materials   Atout France-France Tourism Development Agency FRANCE https://efile.fara.gov/docs/6621-Informational-Materials-20190909-5.pdf
108794 108794 2022-10-14 Daniel J. Edelman, Inc. Daniel J. Edelman, Inc. 3634 Informational Materials   AXA FRANCE https://efile.fara.gov/docs/3634-Informational-Materials-20221014-111.pdf
128452 128452 2022-12-01 Logan Circle Group, LL Logan Circle Group, LLC 7189 Informational Materials   Identity and Democracy Group/French Delegation to the European Parliament (ID Group) FRANCE https://efile.fara.gov/docs/7189-Informational-Materials-20221201-6.pdf
128453 128453 2022-12-01 Logan Circle Group, LLC Logan Circle Group, LLC 7189 Informational Materials   Identity and Democracy Group/French Delegation to the European Parliament (ID Group) FRANCE https://efile.fara.gov/docs/7189-Informational-Materials-20221201-1.pdf
128454 128454 2022-12-01 Logan Circle Group, LLC Logan Circle Group, LLC 7189 Informational Materials   Identity and Democracy Group/French Delegation to the European Parliament (ID Group) FRANCE https://efile.fara.gov/docs/7189-Informational-Materials-20221201-2.pdf
128455 128455 2022-12-01 Logan Circle Group, LLC Logan Circle Group, LLC 7189 Informational Materials   Identity and Democracy Group/French Delegation to the European Parliament (ID Group) FRANCE https://efile.fara.gov/docs/7189-Informational-Materials-20221201-4.pdf
132053 132053 2017-12-19 Quinn & Co. of NY LTD. Quinn & Co. of NY LTD. 6433 Informational Materials   Paris and Ile-de-France through Atout France FRANCE https://efile.fara.gov/docs/6433-Informational-Materials-20171219-3.pdf

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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])
);