fara

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

Custom SQL query returning 5 rows (hide)

select rowid, Short_Form_Termination_Date, Short_Form_Date, Short_Form_Last_Name, Short_Form_First_Name, Registration_Number, Registration_Date, Registrant_Name, Address_1, Address_2, City, State, Zip from FARA_All_ShortForms where "Registration_Number" = :p0 order by rowid limit 101

 
select rowid, Short_Form_Termination_Date, Short_Form_Date, Short_Form_Last_Name, Short_Form_First_Name, Registration_Number, Registration_Date, Registrant_Name, Address_1, Address_2, City, State, Zip from FARA_All_ShortForms where "Registration_Number" = :p0 order by rowid limit 101

Query parameters

This data as json, CSV

rowid	Short_Form_Termination_Date	Short_Form_Date	Short_Form_Last_Name	Short_Form_First_Name	Registration_Number	Registration_Date	Registrant_Name	Address_1	City	State	Zip
10052	1984-03-16	1983-08-16	Burke	Kelly H.	3510	1983-08-16	Stafford, Burke & Hecker, Inc.	1006 Cameron Street	Alexandria	VA	22314
10053	1984-03-16	1983-08-16	Clarke	Joseph J. F.	3510	1983-08-16	Stafford, Burke & Hecker, Inc.	1006 Cameron Street	Alexandria	VA	22314
10054	1984-03-16	1983-08-16	Hecker	Guy L. , Jr.	3510	1983-08-16	Stafford, Burke & Hecker, Inc.	1006 Cameron Street	Alexandria	VA	22314
10055	1984-03-16	1983-08-16	Rogers	Sidney D.	3510	1983-08-16	Stafford, Burke & Hecker, Inc.	1006 Cameron Street	Alexandria	VA	22314
10056	1984-03-16	1983-08-16	Stafford	Thomas P.	3510	1983-08-16	Stafford, Burke & Hecker, Inc.	1006 Cameron Street	Alexandria	VA	22314