home / fara

Menu
  • Search all tables
  • GraphQL API

fara

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

Custom SQL query returning 3 rows (hide)

 
1
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 "City" = :p0 and "Registrant_Name" = :p1 order by Registrant_Name limit 101

Query parameters

This data as json, CSV

rowidShort_Form_Termination_DateShort_Form_DateShort_Form_Last_NameShort_Form_First_NameRegistration_NumberRegistration_DateRegistrant_NameAddress_1Address_2CityStateZip
23013 1995-07-12 1995-05-30 Denison George H. 5022 1995-05-30 Washington Public Affairs Group 5910 Woodacres Drive   Bethesda MD 20816
32686 1993-10-12 1991-07-15 Denison George H. 4543 1991-07-15 Washington Public Affairs Group 5910 Woodacres Drive   Bethesda MD 20816
40716 1991-12-31 1991-09-23 Sanders David G. 4543 1991-07-15 Washington Public Affairs Group 5910 Woodacres Drive   Bethesda MD 20816
Powered by Datasette · Queries took 19.529ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history