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, Foreign_Principal_Termination_Date, Foreign_Principal, Foreign_Principal_Registration_Date, [Country/Location_Represented], Registration_Number, Registrant_Date, Registrant_Name, Address_1, Address_2, City, State, Zip from FARA_All_ForeignPrincipals where "Country/Location_Represented" = :p0 and date("Foreign_Principal_Registration_Date") = :p1 and "Registrant_Name" = :p2 and "State" = :p3 order by rowid limit 101

 
select rowid, Foreign_Principal_Termination_Date, Foreign_Principal, Foreign_Principal_Registration_Date, [Country/Location_Represented], Registration_Number, Registrant_Date, Registrant_Name, Address_1, Address_2, City, State, Zip from FARA_All_ForeignPrincipals where "Country/Location_Represented" = :p0 and date("Foreign_Principal_Registration_Date") = :p1 and "Registrant_Name" = :p2 and "State" = :p3 order by rowid limit 101

Query parameters

This data as json, CSV

rowid	Foreign_Principal_Termination_Date	Foreign_Principal	Foreign_Principal_Registration_Date	Country/Location_Represented	Registration_Number	Registrant_Date	Registrant_Name	Address_1	Address_2	City	State	Zip
6457	1991-05-11	New Hampshire Ball Bearings, Inc.	1988-09-13	JAPAN	3301	1981-11-10	Hill and Knowlton Strategies, LLC	Peterborough			NH