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

2 rows where Foreign_Principal_Country = "SPAIN" and Foreign_Principal_Name = "Catalan National Assembly in the United States of America Association"

✎ View and edit SQL

This data as json, CSV (advanced)

Foreign_Principal_Name 1

  • Catalan National Assembly in the United States of America Association · 2 ✖

Foreign_Principal_Country 1

  • SPAIN · 2 ✖

Document_Type 1

Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
45318 45318 2022-04-30 Catalan National Assembly in the United States of America Association Catalan National Assembly in the United States of America Association 7111 Exhibit AB   Catalan National Assembly in the United States of America Association SPAIN https://efile.fara.gov/docs/7111-Exhibit-AB-20220430-1.pdf
122658 122658 2022-11-29 Miquel Fernandez Barros Miquel Fernandez Barros 7197 Exhibit AB   Catalan National Assembly in the United States of America Association SPAIN https://efile.fara.gov/docs/7197-Exhibit-AB-20221129-1.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])
);