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 "Foreign_Principal_Country" = :p0 and "Registration_Number" = :p1 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 "Foreign_Principal_Country" = :p0 and "Registration_Number" = :p1 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
42545	2023-04-24	PM Group, LLC	7262	Exhibit AB		Brave Group	SOUTH AFRICA	https://efile.fara.gov/docs/7262-Exhibit-AB-20230424-1.pdf