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 "Registrant_Name" = :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
33695 1980-10-27 1978-05-09 Ruef Leland C. 2898 1978-05-09 Cook, Ruef, Spann & Weiser, Inc. Post Office Box 5845   Columbia SC 29250
33696 1980-10-27 1978-05-09 Spann William F. 2898 1978-05-09 Cook, Ruef, Spann & Weiser, Inc. Post Office Box 5845   Columbia SC 29250
Powered by Datasette · Queries took 22.921ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history