home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for FARA_All_ForeignPrincipals
List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

25 rows where Registrant_Name = "Sidley Austin LLP"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Address_1, Address_2, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

Foreign_Principal 23

  • Government of the Cayman Islands 2
  • Ivaniuschenko, Yuriy 2
  • Department for International Trade, Government of the United Kingdom 1
  • Government of El Salvador, Treasury Ministry 1
  • Government of Hong Kong 1
  • Government of Israel 1
  • Hikvision USA, Inc. 1
  • Hong Kong Trade Development Council 1
  • JSC VTB Bank 1
  • Manufacturers Life Insurance Company 1
  • Ministry of Industry and Trade of the Government of Vietnam 1
  • Moscow Narodny Bank 1
  • Moscow Norodny Bank, Ltd. 1
  • Office of Privacy Commissioner of Canada 1
  • Pohang Iron & Steel Company 1
  • Proexport 1
  • Republic of Equatorial Guinea, Embassy 1
  • Republic of Korea, Embassy 1
  • Republic of Panama 1
  • State Bank of Vietnam 1
  • TENEX, Joint Stock Company 1
  • YPF Sociedad Anonima 1
  • beIN Media Group LLC 1

Country/Location_Represented 16

  • RUSSIA 4
  • CANADA 2
  • CAYMAN ISLANDS 2
  • HONG KONG 2
  • KOREA, SOUTH 2
  • UKRAINE 2
  • VIETNAM 2
  • ARGENTINA 1
  • CHINA 1
  • COLOMBIA 1
  • EL SALVADOR 1
  • EQUATORIAL GUINEA 1
  • ISRAEL 1
  • PANAMA 1
  • QATAR 1
  • UNITED KINGDOM 1

City 6

  • - 19
  • Hanoi 2
  • Kyiv 1
  • London 1
  • Moscow 1
  • Ottawa 1

State 2

  • - 21
  • DC 4

Registrant_Name 1

  • Sidley Austin LLP · 25 ✖
Link 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
283 283   Government of Israel 1992-07-27 ISRAEL Sidley Austin LLP 3731 1985-09-13 Sidley Austin LLP Jerusalem        
327 327   Hikvision USA, Inc. 2022-10-14 CHINA Sidley Austin LLP 3731 1985-09-13 Sidley Austin LLP          
2792 2792 2022-02-25 JSC VTB Bank 2015-10-23 RUSSIA Sidley Austin LLP 3731 1985-09-13 Sidley Austin LLP 12 Presnenskaya emb., Moscow 123100      
3514 3514 2023-03-07 Department for International Trade, Government of the United Kingdom 2020-11-30 UNITED KINGDOM Sidley Austin LLP 3731 1985-09-13 Sidley Austin LLP 3 Whitehall Place SW1A ZAW London    
3692 3692 2001-03-13 Republic of Panama 1998-11-23 PANAMA Sidley Austin LLP 3731 1985-09-13 Sidley Austin LLP Balboa y Federico Boyd        
4696 4696 2009-03-31 Office of Privacy Commissioner of Canada 2006-05-10 CANADA Sidley Austin LLP 3731 1985-09-13 Sidley Austin LLP Place de Ville, Tower B 112 Kent Street, Suite 300 Ottawa    
4783 4783 2019-03-31 Hong Kong Trade Development Council 2002-10-15 HONG KONG Sidley Austin LLP 3731 1985-09-13 Sidley Austin LLP 1520 18th Street, N.W. 20036     DC  
4824 4824 2023-03-31 YPF Sociedad Anonima 2022-03-09 ARGENTINA Sidley Austin LLP 3731 1985-09-13 Sidley Austin LLP Macacha Guemes 515 C1106 BKK Ciudad Autonoma de Buenos Aires      
5261 5261 1992-04-14 Government of El Salvador, Treasury Ministry 1991-08-14 EL SALVADOR Sidley Austin LLP 3731 1985-09-13 Sidley Austin LLP San Salvador        
5262 5262 1992-04-14 Pohang Iron & Steel Company 1989-06-01 KOREA, SOUTH Sidley Austin LLP 3731 1985-09-13 Sidley Austin LLP Pohang City        
5263 5263 1992-04-14 Republic of Korea, Embassy 1991-08-14 KOREA, SOUTH Sidley Austin LLP 3731 1985-09-13 Sidley Austin LLP Washington     DC  
5356 5356 1992-04-17 Manufacturers Life Insurance Company 1992-03-10 CANADA Sidley Austin LLP 3731 1985-09-13 Sidley Austin LLP Ontario        
5496 5496 1993-04-23 Moscow Narodny Bank 1989-06-01 RUSSIA Sidley Austin LLP 3731 1985-09-13 Sidley Austin LLP London        
10221 10221 2006-08-08 Proexport 2002-10-15 COLOMBIA Sidley Austin LLP 3731 1985-09-13 Sidley Austin LLP 1901 L Street Suite 700 20036     DC  
11306 11306 2016-09-01 Government of the Cayman Islands 2010-03-05 CAYMAN ISLANDS Sidley Austin LLP 3731 1985-09-13 Sidley Austin LLP Government Administration Building Elgin Avenue, George Town      
11692 11692 2021-09-17 State Bank of Vietnam 2021-04-30 VIETNAM Sidley Austin LLP 3731 1985-09-13 Sidley Austin LLP 49 Ly Thai To   Hanoi    
12168 12168 2006-09-30 Government of the Cayman Islands 1985-09-13 CAYMAN ISLANDS Sidley Austin LLP 3731 1985-09-13 Sidley Austin LLP          
12274 12274 2021-09-30 TENEX, Joint Stock Company 2020-07-20 RUSSIA Sidley Austin LLP 3731 1985-09-13 Sidley Austin LLP 2813 Ozerkovsksya-nab-11584   Moscow    
12414 12414 2011-10-01 Ivaniuschenko, Yuriy 2011-03-08 UKRAINE Sidley Austin LLP 3731 1985-09-13 Sidley Austin LLP 5 Hrushevskoho Street   Kyiv    
12646 12646 1995-10-13 Moscow Norodny Bank, Ltd. 1993-10-01 RUSSIA Sidley Austin LLP 3731 1985-09-13 Sidley Austin LLP London        
12739 12739 2018-10-15 beIN Media Group LLC 2018-10-08 QATAR Sidley Austin LLP 3731 1985-09-13 Sidley Austin LLP          
13834 13834 1996-11-08 Government of Hong Kong 1996-02-21 HONG KONG Sidley Austin LLP 3731 1985-09-13 Sidley Austin LLP Kowloon        
16624 16624 2007-12-31 Republic of Equatorial Guinea, Embassy 2004-08-16 EQUATORIAL GUINEA Sidley Austin LLP 3731 1985-09-13 Sidley Austin LLP Embassy of Equatorial Guinea 2020 16th Street, N.W. 20005     DC  
16642 16642 2008-12-31 Ministry of Industry and Trade of the Government of Vietnam 2007-12-20 VIETNAM Sidley Austin LLP 3731 1985-09-13 Sidley Austin LLP 54 Hai Ba Trung Street   Hanoi    
16749 16749 2014-12-31 Ivaniuschenko, Yuriy 2013-01-31 UKRAINE Sidley Austin LLP 3731 1985-09-13 Sidley Austin LLP 5 Hrushevskoho str. Kyiv, 01021      

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [FARA_All_ForeignPrincipals] (
   [Foreign_Principal_Termination_Date] TEXT,
   [Foreign_Principal] TEXT,
   [Foreign_Principal_Registration_Date] TEXT,
   [Country/Location_Represented] TEXT,
   [Registration_Number] INTEGER,
   [Registrant_Date] TEXT,
   [Registrant_Name] TEXT,
   [Address_1] TEXT,
   [Address_2] TEXT,
   [City] TEXT,
   [State] TEXT,
   [Zip] TEXT,
   FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number])
);
Powered by Datasette · Queries took 271.197ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history