FARA_All_ForeignPrincipals

Table actions
List of all foreign principals (active and terminated)

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

14 rows where "Foreign_Principal_Termination_Date" is on date 1994-03-21

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Registration_Number, Registrant_Date, Foreign_Principal_Registration_Date (date), Registrant_Date (date)

Country/Location_Represented 11

State 2

City 1

  • - 14
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
3933 3933 1994-03-21 AECL 1993-09-21 CANADA Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Ottawa, Ontario,        
3934 3934 1994-03-21 Australian Nuclear Science & Technology Organization (ANSTO) 1992-10-19 AUSTRALIA Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge New South Wales        
3935 3935 1994-03-21 Belgian Nuclear Research Centre (C.E.N./S.C.K.) 1993-01-13 BELGIUM Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Boeretang        
3936 3936 1994-03-21 Delft University of Tech 1993-05-03 NETHERLANDS Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Delft        
3937 3937 1994-03-21 Forschungszentrum Geesthacht GmbH (GKSS) 1992-10-19 GERMANY Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Geesthacht        
3938 3938 1994-03-21 Hahn - Meitner - Institut Berlin GmbH (HMI) Hahn - Meitner - Institut 1992-10-19 GERMANY Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Berlin        
3939 3939 1994-03-21 Japan Atomic Energy Research Institute (JAERI")" 1993-09-21 JAPAN Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Washington     DC  
3940 3940 1994-03-21 Joint Research Centre 1992-10-19 NETHERLANDS Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Petten        
3941 3941 1994-03-21 Osterreichisches Forschungszentrum Seibersdorf GmbH (ASTRA) 1992-10-19 AUSTRIA Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Seibersdorf        
3942 3942 1994-03-21 Paul Scherrer Institute Research Reactor Saphir 1993-09-21 SWITZERLAND Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Villigen        
3943 3943 1994-03-21 Riso National Laboratory (RISO) 1992-10-19 DENMARK Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Roskilde        
3944 3944 1994-03-21 Studsvik Nuclear, A.B. (SKB) 1992-10-19 SWEDEN Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Nykoping        
3945 3945 1994-03-21 Technical University of Munich 1993-05-03 GERMANY Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Reaktorstation        
3946 3946 1994-03-21 Teddy Kollek 1993-07-09 ISRAEL Teddy Kollek for Mayor 4828 1993-07-09 Teddy Kollek for Mayor Jerusalem        

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])
);