fara

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

Custom SQL query returning 3 rows (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 "State" = :p0 order by [Country/Location_Represented] 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 "State" = :p0 order by [Country/Location_Represented] 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	State
7348	1967-06-01	Alfredo Raimundo do Rego	1966-02-08	DOMINICA	1962	1966-02-08	Martins, Nelson Dias	Bristol	RI
14444	1993-11-30	International Crystal Federation	1993-04-12	INTERNATIONAL	4793	1993-04-12	Albertine Enterprises, Inc.	Warwick	RI
14702	1993-12-01	International Crystal Federation	1993-04-08	INTERNATIONAL	4792	1993-04-08	Thompson Group, Inc.	Warwick	RI