FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where Country/Location_Represented = "DENMARK", "Foreign_Principal_Registration_Date" is on date 1942-07-20 and Registrant_Name = "Haight, Griffin, Deming & Gardner"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date (date), Registrant_Date (date)
Foreign_Principal 9
- Aktieselskabet Dampskibsselskabet Norden 1
- Aktieselskabet Dampskibsselskabet Svendborg 1
- Aktieselskabet Dampskibsselskabet Vesterhavet 1
- Dampskibsselskabet AF1912 Aktieselskabet 1
- Dampskibsselskabet Hafnia Aktieselskab 1
- Dampskibsselskabet Torm Aktieselskab 1
- Danske Rederes Retsvaern (Danish Shipowners' Defense Association) 1
- Nordisk Skibsrederforening (Northern Shipowners' Association) 1
- Rederiet Ocean Aktieselskab 1
State 1
- - 9
Registrant_Name 1
- Haight, Griffin, Deming & Gardner · 9 ✖
Country/Location_Represented 1
- DENMARK · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9494 | 9494 | 1946-07-27 | Danske Rederes Retsvaern (Danish Shipowners' Defense Association) | 1942-07-20 | DENMARK | Haight, Griffin, Deming & Gardner 56 | 1942-07-20 | Haight, Griffin, Deming & Gardner | Copenhagen | ||||
9496 | 9496 | 1946-07-27 | Nordisk Skibsrederforening (Northern Shipowners' Association) | 1942-07-20 | DENMARK | Haight, Griffin, Deming & Gardner 56 | 1942-07-20 | Haight, Griffin, Deming & Gardner | Copenhagen | ||||
9497 | 9497 | 1946-07-27 | Aktieselskabet Dampskibsselskabet Norden | 1942-07-20 | DENMARK | Haight, Griffin, Deming & Gardner 56 | 1942-07-20 | Haight, Griffin, Deming & Gardner | Copenhagen | ||||
9498 | 9498 | 1946-07-27 | Aktieselskabet Dampskibsselskabet Svendborg | 1942-07-20 | DENMARK | Haight, Griffin, Deming & Gardner 56 | 1942-07-20 | Haight, Griffin, Deming & Gardner | Copenhagen | ||||
9499 | 9499 | 1946-07-27 | Aktieselskabet Dampskibsselskabet Vesterhavet | 1942-07-20 | DENMARK | Haight, Griffin, Deming & Gardner 56 | 1942-07-20 | Haight, Griffin, Deming & Gardner | Copenhagen | ||||
9501 | 9501 | 1946-07-27 | Dampskibsselskabet AF1912 Aktieselskabet | 1942-07-20 | DENMARK | Haight, Griffin, Deming & Gardner 56 | 1942-07-20 | Haight, Griffin, Deming & Gardner | Copenhagen | ||||
9502 | 9502 | 1946-07-27 | Dampskibsselskabet Hafnia Aktieselskab | 1942-07-20 | DENMARK | Haight, Griffin, Deming & Gardner 56 | 1942-07-20 | Haight, Griffin, Deming & Gardner | Copenhagen | ||||
9503 | 9503 | 1946-07-27 | Dampskibsselskabet Torm Aktieselskab | 1942-07-20 | DENMARK | Haight, Griffin, Deming & Gardner 56 | 1942-07-20 | Haight, Griffin, Deming & Gardner | Copenhagen | ||||
9509 | 9509 | 1946-07-27 | Rederiet Ocean Aktieselskab | 1942-07-20 | DENMARK | Haight, Griffin, Deming & Gardner 56 | 1942-07-20 | Haight, Griffin, Deming & Gardner | Copenhagen |
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]) );