fara

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

Custom SQL query returning 1 row (hide)

select rowid, Date_Stamped, Registrant_Name, Registration_Number, Document_Type, Short_Form_Name, Foreign_Principal_Name, Foreign_Principal_Country, URL from FARA_All_RegistrantDocs where "Document_Type" = :p0 and "Foreign_Principal_Name" = :p1 and "Registrant_Name" = :p2 order by rowid limit 101

 
select rowid, Date_Stamped, Registrant_Name, Registration_Number, Document_Type, Short_Form_Name, Foreign_Principal_Name, Foreign_Principal_Country, URL from FARA_All_RegistrantDocs where "Document_Type" = :p0 and "Foreign_Principal_Name" = :p1 and "Registrant_Name" = :p2 order by rowid limit 101

Query parameters

This data as json, CSV

rowid	Date_Stamped	Registrant_Name	Registration_Number	Document_Type	Short_Form_Name	Foreign_Principal_Name	Foreign_Principal_Country	URL
134665	2019-12-30	Biggs, Allison	6777	Informational Materials		Embassy of the State of Qatar	QATAR	https://efile.fara.gov/docs/6777-Informational-Materials-20191230-2.pdf