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, 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

rowidForeign_Principal_Termination_DateForeign_PrincipalForeign_Principal_Registration_DateCountry/Location_RepresentedRegistration_NumberRegistrant_DateRegistrant_NameAddress_1Address_2CityStateZip
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  
Powered by Datasette · Queries took 8.708ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history