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

32 rows where Registrant_Name = "Arent Fox Kintner Plotkin & Kahn, PLLC"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

Foreign_Principal 30

  • Outokumpu Oy 2
  • Perrier Group 2
  • Bankruptcy Estate of Wartsila Marine Industries, Inc. 1
  • California Steel Industries, Inc. 1
  • Clarke Group 1
  • Constructora Nacional de Carros de Ferrocarril 1
  • FANUC, Ltd. 1
  • Federal Republic of Nigeria 1
  • Finnish Guarantee Board 1
  • Government of the Republic of Haiti 1
  • Hoesch Rohr, A.G. 1
  • Hoesch Tubular Products Company 1
  • International Computers, Ltd. 1
  • LAPEC Nigeria, Ltd. 1
  • Lagos State Nigeria 1
  • Lars Krogh & Company, A.S. 1
  • Neptune Orient Lines, Ltd. 1
  • Nova Scotia Resources, Ltd. 1
  • Patton & Morgan Corporation 1
  • Potash Corporation of Saskatchewan 1
  • Potash Corporation of Saskatchewan & its Subsidiaries, Inc. 1
  • Republic of Chile, Embassy of Chile 1
  • Sitmar Cruises, Inc. 1
  • Solmecs Corporation 1
  • Sony Corporation 1
  • TVW Paper Machines, Inc. 1
  • Toyota Motor Corporation 1
  • Uranerzbergbau GmbH 1
  • Vereinigte Edelstahlwerke, A.G. 1
  • Voest-Alpine, A.G. 1

Country/Location_Represented 18

  • FINLAND 5
  • CANADA 4
  • JAPAN 3
  • NIGERIA 3
  • AUSTRIA 2
  • FRANCE 2
  • GERMANY, FEDERAL REPUBLIC OF 2
  • AUSTRALIA 1
  • BRAZIL 1
  • CHILE 1
  • GERMANY 1
  • GREAT BRITAIN 1
  • HAITI 1
  • KOREA, SOUTH 1
  • MEXICO 1
  • NETHERLANDS 1
  • NORWAY 1
  • SINGAPORE 1

State 5

  • - 27
  • DC 2
  • CA 1
  • CT 1
  • GA 1

Registrant_Name 1

  • Arent Fox Kintner Plotkin & Kahn, PLLC · 32 ✖

City 1

  • - 32
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
911 911 1988-01-01 Perrier Group 1985-05-29 FRANCE Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC          
915 915 1988-01-01 Voest-Alpine, A.G. 1985-01-14 AUSTRIA Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Linz        
1996 1996 1980-02-01 Constructora Nacional de Carros de Ferrocarril 1978-03-21 MEXICO Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC          
2004 2004 1982-02-01 Potash Corporation of Saskatchewan 1976-02-18 CANADA Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Regina, Saskatchewan        
2039 2039 1991-02-01 Bankruptcy Estate of Wartsila Marine Industries, Inc. 1990-03-20 FINLAND Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Helsinki        
2651 2651 1992-02-18 Federal Republic of Nigeria 1991-10-21 NIGERIA Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Lagos        
2652 2652 1992-02-18 International Computers, Ltd. 1985-10-01 GREAT BRITAIN Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC London        
2653 2653 1992-02-18 LAPEC Nigeria, Ltd. 1991-10-21 NIGERIA Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Ikeja        
2654 2654 1992-02-18 Lagos State Nigeria 1991-10-21 NIGERIA Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Ikeja        
2655 2655 1992-02-18 Outokumpu Oy 1987-03-28 FINLAND Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Helsinki        
2656 2656 1992-02-18 Potash Corporation of Saskatchewan & its Subsidiaries, Inc. 1987-09-17 CANADA Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC          
2658 2658 1992-02-18 Uranerzbergbau GmbH 1985-07-08 GERMANY Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Bonn        
2937 2937 1983-02-28 Patton & Morgan Corporation 1983-02-01 KOREA, SOUTH Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Seoul        
3260 3260 1981-03-01 Solmecs Corporation 1980-11-07 NETHERLANDS Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Amsterdam        
3864 3864 1985-03-18 Sitmar Cruises, Inc. 1983-05-18 AUSTRALIA Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC          
3875 3875 1993-03-18 FANUC, Ltd. 1992-06-04 JAPAN Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Yamanashi        
3876 3876 1993-03-18 Perrier Group 1990-12-03 FRANCE Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Greenwich     CT  
3877 3877 1993-03-18 Toyota Motor Corporation 1983-05-04 JAPAN Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Aichi Prefecture        
9450 9450 1982-07-23 Lars Krogh & Company, A.S. 1982-12-13 NORWAY Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Oslo        
10211 10211 1989-08-08 California Steel Industries, Inc. 1989-06-06 BRAZIL Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Fontana     CA  
10597 10597 1985-08-18 Nova Scotia Resources, Ltd. 1983-01-05 CANADA Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Halifax Nova Scotia        
10600 10600 1989-08-18 Neptune Orient Lines, Ltd. 1985-10-25 SINGAPORE Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC          
10601 10601 1991-08-18 Clarke Group 1990-09-26 CANADA Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC British Columbia        
10602 10602 1991-08-18 Finnish Guarantee Board 1990-03-20 FINLAND Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Helsinki        
10603 10603 1991-08-18 Sony Corporation 1986-07-14 JAPAN Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Tokyo        
11236 11236 1980-09-01 Outokumpu Oy 1977-03-15 FINLAND Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Helsinki        
11687 11687 1993-09-17 Republic of Chile, Embassy of Chile 1991-11-07 CHILE Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Washington     DC  
12094 12094 1998-09-30 Government of the Republic of Haiti 1991-10-10 HAITI Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Washington     DC  
12891 12891 1988-10-21 Hoesch Rohr, A.G. 1985-07-15 GERMANY, FEDERAL REPUBLIC OF Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC          
12892 12892 1988-10-21 Hoesch Tubular Products Company 1985-07-15 GERMANY, FEDERAL REPUBLIC OF Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC          
13799 13799 1983-11-07 Vereinigte Edelstahlwerke, A.G. 1982-03-18 AUSTRIA Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Vienna        
15989 15989 1986-12-31 TVW Paper Machines, Inc. 1985-06-27 FINLAND Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Atlanta     GA  

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 243.996ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows