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

20 rows where Registration_Number = 69

✎ View and edit SQL

This data as json, CSV (advanced)

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

State

  • 20

Registrant_Name

Country/Location_Represented

City

  • 20
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
7814 7814 1946-06-30 Stockholms Superfosfat Fabriks A.B. (Stockholm's Superphosphate Company) 1945-03-02 SWEDEN 69 69 1942-07-28 Swedish Industries Fund, Inc.          
7815 7815 1946-06-30 A.B. Bofors Nobelkrut 1942-07-28 SWEDEN 69 69 1942-07-28 Swedish Industries Fund, Inc.          
7816 7816 1946-06-30 A.B. Elektrolux 1942-07-28 SWEDEN 69 69 1942-07-28 Swedish Industries Fund, Inc.          
7817 7817 1946-06-30 A.B. Gasaccumulator 1945-03-02 SWEDEN 69 69 1942-07-28 Swedish Industries Fund, Inc.          
7818 7818 1946-06-30 A.B. Ljungstroms Angturbin 1942-07-28 SWEDEN 69 69 1942-07-28 Swedish Industries Fund, Inc.          
7819 7819 1946-06-30 A.B. Separator 1942-07-28 SWEDEN 69 69 1942-07-28 Swedish Industries Fund, Inc.          
7820 7820 1946-06-30 A.B. Svenska Amerikalinjen 1942-07-28 SWEDEN 69 69 1942-07-28 Swedish Industries Fund, Inc.          
7821 7821 1946-06-30 A.B. Svenska Kullager Fabriken 1942-07-28 SWEDEN 69 69 1942-07-28 Swedish Industries Fund, Inc.          
7822 7822 1946-06-30 A.B. Svenska Ostasiastiska Kompaniet (Swedish East Asiatic Company 1945-03-02 SWEDEN 69 69 1942-07-28 Swedish Industries Fund, Inc.          
7823 7823 1946-06-30 A.B. Tirfing S.S. Line 1945-03-02 SWEDEN 69 69 1942-07-28 Swedish Industries Fund, Inc.          
7824 7824 1946-06-30 A.B. de Lavals Angturbin 1942-07-28 SWEDEN 69 69 1942-07-28 Swedish Industries Fund, Inc.          
7825 7825 1946-06-30 Axel Axelson Johnson 1942-07-28 SWEDEN 69 69 1942-07-28 Swedish Industries Fund, Inc.          
7826 7826 1946-06-30 Brostrom-Koncernen 1942-07-28 SWEDEN 69 69 1942-07-28 Swedish Industries Fund, Inc.          
7827 7827 1946-06-30 Elektriska Svetsnings A.B. 1942-07-28 SWEDEN 69 69 1942-07-28 Swedish Industries Fund, Inc.          
7828 7828 1946-06-30 Kooperativa Forbundet 1942-07-28 SWEDEN 69 69 1942-07-28 Swedish Industries Fund, Inc.          
7830 7830 1946-06-30 Sandvikens Jernverks A.B. 1942-07-28 SWEDEN 69 69 1942-07-28 Swedish Industries Fund, Inc.          
7831 7831 1946-06-30 Stora Kopparbergs Company 1945-03-02 SWEDEN 69 69 1942-07-28 Swedish Industries Fund, Inc.          
7832 7832 1946-06-30 Svenska Cellulosa-Aktiebolaget 1942-07-28 SWEDEN 69 69 1942-07-28 Swedish Industries Fund, Inc.          
7833 7833 1946-06-30 Swedish-America-Mexico Line 1945-03-02 SWEDEN 69 69 1942-07-28 Swedish Industries Fund, Inc.          
7834 7834 1946-06-30 Telefon A.B. L.M. Ericsson 1942-07-28 SWEDEN 69 69 1942-07-28 Swedish Industries Fund, Inc.          

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 · Query took 181.92ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history