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 9 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 "Registration_Number" = :p0 order by rowid limit 101

Query parameters

This data as json, CSV

rowidForeign_Principal_Termination_DateForeign_PrincipalForeign_Principal_Registration_DateCountry/Location_RepresentedRegistration_NumberRegistrant_DateRegistrant_NameAddress_1Address_2CityStateZip
1693 1971-01-31 Italian State Tourist Office 1964-07-15 ITALY 1381 1960-07-29 Donald N. Martin & Company, Inc. New York     NY  
3325 2000-03-01 Tourist Office of Spain 1999-09-21 SPAIN 1381 1960-07-29 Donald N. Martin & Company, Inc. 666 Fifth Avenue New York, NY 10103     NY  
7545 1993-06-03 British Tourist Authority 1986-10-27 GREAT BRITAIN 1381 1960-07-29 Donald N. Martin & Company, Inc. New York     NY  
7546 1993-06-03 Cyprus Tourism Organization 1984-12-06 CYPRUS 1381 1960-07-29 Donald N. Martin & Company, Inc. New York     NY  
7547 1993-06-03 East Asia Travel Association 1985-10-01 INTERNATIONAL 1381 1960-07-29 Donald N. Martin & Company, Inc. Tokyo        
11076 2001-08-31 Portuguese National Tourist Office 2001-01-05 PORTUGAL 1381 1960-07-29 Donald N. Martin & Company, Inc. 590 Fifth Avenue New York 10036     NY  
14838 1984-12-06 Danish Tourist Board 1984-12-06 DENMARK 1381 1960-07-29 Donald N. Martin & Company, Inc. New York     NY  
15817 1979-12-31 Belgian National Tourist Office 1974-02-23 BELGIUM 1381 1960-07-29 Donald N. Martin & Company, Inc. Brussels        
16532 2003-12-31 European Travel Commission 1960-07-29 INTERNATIONAL 1381 1960-07-29 Donald N. Martin & Company, Inc. New York     NY  
Powered by Datasette · Queries took 8.7ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history