FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where Address_1 = "Gothenburg"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Registration_Number, Registrant_Date
Registrant_Name 8
Registrant_Date (date) 7 ✖
- 1942-07-28 2
- 1994-12-05 2
- 1942-07-06 1
- 1943-03-03 1
- 1961-08-01 1
- 1978-03-17 1
- 1986-07-29 1
Foreign_Principal 6
State 1
- - 9
Country/Location_Represented 1
- SWEDEN 9
City 1
- - 9
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2134 | 2134 | 1961-02-03 | Swedish American Line | 1955-01-27 | SWEDEN | Caples Company 34 | 1943-03-03 | Caples Company | Gothenburg | ||||
8529 | 8529 | 1995-06-30 | Swedish Shipowners' Association | 1994-12-05 | SWEDEN | Lorentzon, Ola 4975 | 1994-12-05 | Lorentzon, Ola | Gothenburg | ||||
9585 | 9585 | 1986-07-29 | AB Volvo | 1986-08-11 | SWEDEN | Volvo North American Corporation 3864 | 1986-07-29 | Volvo North American Corporation | Gothenburg | ||||
10823 | 10823 | 1972-08-29 | Port of Gothenburg | 1969-08-05 | SWEDEN | Swedish-American Chamber of Commerce, Inc. 13 | 1942-07-06 | Swedish-American Chamber of Commerce, Inc. | Gothenburg | ||||
13206 | 13206 | 1965-10-31 | Swedish American Line | 1961-08-01 | SWEDEN | Geyer & Oswald, Inc. 1468 | 1961-08-01 | Geyer & Oswald, Inc. | Gothenburg | ||||
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 | ||||
13792 | 13792 | 1973-11-07 | Svenska Handelsbanken | 1942-07-28 | SWEDEN | Swedish Information Service 70 | 1942-07-28 | Swedish Information Service | Gothenburg | ||||
15499 | 15499 | 1995-12-30 | Swedish Shipowners' Association | 1994-12-05 | SWEDEN | Jessing, Per Ingvar 4976 | 1994-12-05 | Jessing, Per Ingvar | Gothenburg | ||||
16281 | 16281 | 1995-12-31 | Swedish Shipowners' Association | 1994-12-05 | SWEDEN | LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 | 1978-03-17 | LeBoeuf, Lamb, Greene & MacRae, L.L.P. | Gothenburg |
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]) );