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

3 rows where Foreign_Principal_Country = "INTERNATIONAL" and Registrant_Name = "Hill and Knowlton Strategies, LLC"

✎ View and edit SQL

This data as json, CSV (advanced)

Document_Type 2

Registrant_Name 1

  • Hill and Knowlton Strategies, LLC · 3 ✖

Foreign_Principal_Country 1

  • INTERNATIONAL · 3 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
68868 68868 2023-06-29 Hill and Knowlton Strategies, LLC Hill and Knowlton Strategies, LLC 3301 Informational Materials   United Nations Office of the High Representative for the Least Developed Countries, Landlocked Developing Countries and Small Island Developing States (UN-OHRLLS) INTERNATIONAL https://efile.fara.gov/docs/3301-Informational-Materials-20230629-77.pdf
68869 68869 2023-06-29 Hill and Knowlton Strategies, LLC Hill and Knowlton Strategies, LLC 3301 Informational Materials   United Nations Office of the High Representative for the Least Developed Countries, Landlocked Developing Countries and Small Island Developing States (UN-OHRLLS) INTERNATIONAL https://efile.fara.gov/docs/3301-Informational-Materials-20230629-78.pdf
123493 123493 2021-11-30 Hill and Knowlton Strategies, LLC Hill and Knowlton Strategies, LLC 3301 Exhibit AB   United Nations (UN-OHRLLS) INTERNATIONAL https://efile.fara.gov/docs/3301-Exhibit-AB-20211130-47.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])
);