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 7 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 "City" = :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
2886 2012-02-27 Serbia Investment and Export Promotion Agency (SIEPA) through Rasky Baerlein Strategic Communications, Inc. 2008-12-04 SERBIA 5896 2008-12-04 Taylor, Simon Vlajkoviceva 3/V 1100   Belgrade    
6062 2010-04-30 Republic of Serbia 2009-04-27 SERBIA 5933 2009-04-27 Advanced Practical Solutions, LLC Nemanjina 11 11000 Belgrade    
6791 2012-05-24 Tomislav Nikolic, President Serbian Progressive Party (SNS-Srpska Napredna Stranka) 2010-10-06 SERBIA 6003 2010-10-06 Montgomery, William Dale Cika Ljubina Street   Belgrade    
8929 2010-07-01 Karic, Milanka, Bogoljub, Dragomir 2009-04-03 SERBIA 5898 2008-12-09 Alcalde & Fay, Ltd. Uzicka 35 Dr. Theodora Borockog 35 11070 New Belgrade Belgrade    
11901 2012-09-29 Republic of Serbia through Roberti & White, LLC 2011-10-15 SERBIA 6070 2011-10-15 Strategic Partnership Alliance, Ltd. Nemanjina 11   Belgrade    
12212 2012-09-30 Republic of Serbia 2011-09-23 SERBIA 6065 2011-09-23 Roberti + White, LLC Ministry of Foreign Affairs, Republic of Serbia 24-26 Kneza Milosa St. Belgrade    
16688 2010-12-31 Serbia Investment and Export Promotion Agency (SIEPA) through Rasky Baerlein Strategic Communications, Inc. 2008-12-04 SERBIA 5897 2008-12-04 Passacantilli, Daniel Vlajkoviceva 3/V 1100   Belgrade    
Powered by Datasette · Queries took 9.004ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history