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 2 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 "Registration_Number" = :p0 and "State" = :p1 order by rowid 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
42357 2020-12-31 2019-12-03 Hathaway Anne Frances 6761 2019-12-03 Hathaway Strategies, LLC 303 N Alabama Street Suite 390 Indianapolis IN 46204
42359 2020-12-31 2019-12-06 Phelps Timothy Robert 6761 2019-12-03 Hathaway Strategies, LLC 303 N Alabama Street Suite 390 Indianapolis IN 46204
Powered by Datasette · Queries took 22.859ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history