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

1 row where Foreign_Principal_Country = "COSTA RICA" and Registrant_Name = "Arent Fox, LLP"

✎ View and edit SQL

This data as json, CSV (advanced)

Registrant_Name 1

  • Arent Fox, LLP · 1 ✖

Foreign_Principal_Country 1

  • COSTA RICA · 1 ✖

Document_Type 1

Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
106882 106882 2009-10-05 Arent Fox, LLP Arent Fox, LLP 5882 Exhibit AB   Laura Chinchilla Miranda, nominee of Partido Liberacion Nacional (National Liberation Party) for President of the Republic of Costa Rica COSTA RICA https://efile.fara.gov/docs/5882-Exhibit-AB-20091005-6.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])
);