FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where Country/Location_Represented = "SWEDEN", Registrant_Date = "1942-07-28" and Registrant_Name = "Swedish Information Service"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 14
- ASEA (Swedish General Electric Company) 1
- Ahlen & Akerlund 1
- Albert Bonnier Publishing House 1
- Bofors 1
- Cellulosa Company 1
- Cooperative Union 1
- Enskilda Banken 1
- Grangesberg Company 1
- SKF (Swedish Ball Bearing Company) 1
- Skandinaviska Banken 1
- Stora Kopparbergs Mining Company 1
- Svenska Handelsbanken 1
- Swedish Government 1
- Swedish Ministry for Foreign Affairs 1
State 1
- - 14
Registrant_Name 1
- Swedish Information Service · 14 ✖
Country/Location_Represented 1
- SWEDEN · 14 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13781 | 13781 | 1973-11-07 | ASEA (Swedish General Electric Company) | 1942-07-28 | SWEDEN | Swedish Information Service 70 | 1942-07-28 | Swedish Information Service | |||||
13782 | 13782 | 1973-11-07 | Ahlen & Akerlund | 1942-07-28 | SWEDEN | Swedish Information Service 70 | 1942-07-28 | Swedish Information Service | Stockholm | ||||
13783 | 13783 | 1973-11-07 | Albert Bonnier Publishing House | 1942-07-28 | SWEDEN | Swedish Information Service 70 | 1942-07-28 | Swedish Information Service | Stockholm | ||||
13784 | 13784 | 1973-11-07 | Bofors | 1942-07-28 | SWEDEN | Swedish Information Service 70 | 1942-07-28 | Swedish Information Service | Bofors | ||||
13785 | 13785 | 1973-11-07 | Cellulosa Company | 1942-07-28 | SWEDEN | Swedish Information Service 70 | 1942-07-28 | Swedish Information Service | Stockholm | ||||
13786 | 13786 | 1973-11-07 | Cooperative Union | 1942-07-28 | SWEDEN | Swedish Information Service 70 | 1942-07-28 | Swedish Information Service | Stockholm | ||||
13787 | 13787 | 1973-11-07 | Enskilda Banken | 1942-07-28 | SWEDEN | Swedish Information Service 70 | 1942-07-28 | Swedish Information Service | Stockholm | ||||
13788 | 13788 | 1973-11-07 | Grangesberg Company | 1942-07-28 | SWEDEN | Swedish Information Service 70 | 1942-07-28 | Swedish Information Service | Stockholm | ||||
13789 | 13789 | 1973-11-07 | SKF (Swedish Ball Bearing Company) | 1942-07-28 | SWEDEN | Swedish Information Service 70 | 1942-07-28 | Swedish Information Service | Gothenburg | ||||
13790 | 13790 | 1973-11-07 | Skandinaviska Banken | 1942-07-28 | SWEDEN | Swedish Information Service 70 | 1942-07-28 | Swedish Information Service | Stockholm | ||||
13791 | 13791 | 1973-11-07 | Stora Kopparbergs Mining Company | 1942-07-28 | SWEDEN | Swedish Information Service 70 | 1942-07-28 | Swedish Information Service | Falun | ||||
13792 | 13792 | 1973-11-07 | Svenska Handelsbanken | 1942-07-28 | SWEDEN | Swedish Information Service 70 | 1942-07-28 | Swedish Information Service | Gothenburg | ||||
13793 | 13793 | 1973-11-07 | Swedish Government | 1942-07-28 | SWEDEN | Swedish Information Service 70 | 1942-07-28 | Swedish Information Service | Stockholm | ||||
13794 | 13794 | 1973-11-07 | Swedish Ministry for Foreign Affairs | 1973-05-24 | SWEDEN | Swedish Information Service 70 | 1942-07-28 | Swedish Information Service | Stockholm |
Advanced export
JSON shape: default, array, newline-delimited
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]) );