FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
23 rows where Country/Location_Represented = "NETHERLANDS", "Foreign_Principal_Registration_Date" is on date 1949-09-15 and Registrant_Date = "1949-09-15"
This data as json, CSV (advanced)
Suggested facets: Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 23
- Administratie Mij Unitas, N.V. 1
- Algemene Kunstzijde Unie 1
- Bataafse Petroleum Maatschappij, N.V. 1
- Billiton Maatschappij 1
- Erven Ankersmit 1
- G. Dikkers & Company 1
- Gebroeders Stork 1
- H. Ten Cate & Company 1
- Heemaf, N.V. 1
- Heineken's Breweries 1
- Holland America Lijn 1
- Java Textiel Maatschappij 1
- Koninklijke Paketvaartmaatschappij 1
- Lever Brothers & Unilever 1
- Nederl. Linoleumfabriek, N.V. 1
- Nederlandse Stoomblekerij 1
- Pierson & Company 1
- Rigtersbeek, N.V. 1
- Stearinekaarsen Fabriek, N.V. 1
- Stoomvaart Mij Nederland, N.V. 1
- Terwindt & Arntz 1
- Twijsntra & Company 1
- Vredesstein Rubber 1
State 1
- - 23
Registrant_Name 1
Country/Location_Represented 1
- NETHERLANDS · 23 ✖
City 1
- - 23
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5526 | 5526 | 1952-04-25 | Heineken's Breweries | 1949-09-15 | NETHERLANDS | Netherland Publishing Corporation 589 | 1949-09-15 | Netherland Publishing Corporation | Amsterdam | ||||
5528 | 5528 | 1952-04-25 | Administratie Mij Unitas, N.V. | 1949-09-15 | NETHERLANDS | Netherland Publishing Corporation 589 | 1949-09-15 | Netherland Publishing Corporation | Utrecht | ||||
5529 | 5529 | 1952-04-25 | Algemene Kunstzijde Unie | 1949-09-15 | NETHERLANDS | Netherland Publishing Corporation 589 | 1949-09-15 | Netherland Publishing Corporation | Arnhem | ||||
5531 | 5531 | 1952-04-25 | Bataafse Petroleum Maatschappij, N.V. | 1949-09-15 | NETHERLANDS | Netherland Publishing Corporation 589 | 1949-09-15 | Netherland Publishing Corporation | Hague | ||||
5532 | 5532 | 1952-04-25 | Billiton Maatschappij | 1949-09-15 | NETHERLANDS | Netherland Publishing Corporation 589 | 1949-09-15 | Netherland Publishing Corporation | Hague | ||||
5533 | 5533 | 1952-04-25 | Erven Ankersmit | 1949-09-15 | NETHERLANDS | Netherland Publishing Corporation 589 | 1949-09-15 | Netherland Publishing Corporation | Deventer | ||||
5534 | 5534 | 1952-04-25 | G. Dikkers & Company | 1949-09-15 | NETHERLANDS | Netherland Publishing Corporation 589 | 1949-09-15 | Netherland Publishing Corporation | Hengelo | ||||
5535 | 5535 | 1952-04-25 | Gebroeders Stork | 1949-09-15 | NETHERLANDS | Netherland Publishing Corporation 589 | 1949-09-15 | Netherland Publishing Corporation | Hengelo | ||||
5537 | 5537 | 1952-04-25 | H. Ten Cate & Company | 1949-09-15 | NETHERLANDS | Netherland Publishing Corporation 589 | 1949-09-15 | Netherland Publishing Corporation | Almelo | ||||
5539 | 5539 | 1952-04-25 | Heemaf, N.V. | 1949-09-15 | NETHERLANDS | Netherland Publishing Corporation 589 | 1949-09-15 | Netherland Publishing Corporation | Hengelo | ||||
5540 | 5540 | 1952-04-25 | Holland America Lijn | 1949-09-15 | NETHERLANDS | Netherland Publishing Corporation 589 | 1949-09-15 | Netherland Publishing Corporation | Rotterdam | ||||
5543 | 5543 | 1952-04-25 | Java Textiel Maatschappij | 1949-09-15 | NETHERLANDS | Netherland Publishing Corporation 589 | 1949-09-15 | Netherland Publishing Corporation | |||||
5547 | 5547 | 1952-04-25 | Koninklijke Paketvaartmaatschappij | 1949-09-15 | NETHERLANDS | Netherland Publishing Corporation 589 | 1949-09-15 | Netherland Publishing Corporation | Amsterdam | ||||
5551 | 5551 | 1952-04-25 | Lever Brothers & Unilever | 1949-09-15 | NETHERLANDS | Netherland Publishing Corporation 589 | 1949-09-15 | Netherland Publishing Corporation | Rotterdam | ||||
5554 | 5554 | 1952-04-25 | Nederl. Linoleumfabriek, N.V. | 1949-09-15 | NETHERLANDS | Netherland Publishing Corporation 589 | 1949-09-15 | Netherland Publishing Corporation | Krommenie | ||||
5555 | 5555 | 1952-04-25 | Nederlandse Stoomblekerij | 1949-09-15 | NETHERLANDS | Netherland Publishing Corporation 589 | 1949-09-15 | Netherland Publishing Corporation | Nijverdal | ||||
5556 | 5556 | 1952-04-25 | Pierson & Company | 1949-09-15 | NETHERLANDS | Netherland Publishing Corporation 589 | 1949-09-15 | Netherland Publishing Corporation | Amsterdam | ||||
5557 | 5557 | 1952-04-25 | Rigtersbeek, N.V. | 1949-09-15 | NETHERLANDS | Netherland Publishing Corporation 589 | 1949-09-15 | Netherland Publishing Corporation | Enschede | ||||
5560 | 5560 | 1952-04-25 | Stearinekaarsen Fabriek, N.V. | 1949-09-15 | NETHERLANDS | Netherland Publishing Corporation 589 | 1949-09-15 | Netherland Publishing Corporation | Gouda | ||||
5562 | 5562 | 1952-04-25 | Stoomvaart Mij Nederland, N.V. | 1949-09-15 | NETHERLANDS | Netherland Publishing Corporation 589 | 1949-09-15 | Netherland Publishing Corporation | Amsterdam | ||||
5564 | 5564 | 1952-04-25 | Terwindt & Arntz | 1949-09-15 | NETHERLANDS | Netherland Publishing Corporation 589 | 1949-09-15 | Netherland Publishing Corporation | Nijmegen | ||||
5565 | 5565 | 1952-04-25 | Twijsntra & Company | 1949-09-15 | NETHERLANDS | Netherland Publishing Corporation 589 | 1949-09-15 | Netherland Publishing Corporation | Maarsen | ||||
5568 | 5568 | 1952-04-25 | Vredesstein Rubber | 1949-09-15 | NETHERLANDS | Netherland Publishing Corporation 589 | 1949-09-15 | Netherland Publishing Corporation | Loosduinen |
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]) );