FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
19 rows where Address_1 = "Rotterdam"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Foreign_Principal 14
- Nedlloyd Lijnen, B.V. 3
- RSV Mining Equipment, B.V. 3
- City of Rotterdam 2
- B.V. Stevedore Company Quick Dispatch 1
- Chamber of Commerce of the City of Rotterdam 1
- Holland America Lijn 1
- Hollandsche Bank Unie, N.V. 1
- Koninklijke Rotterdamsche Lloyd 1
- Lever Brothers & Unilever 1
- Loyens & Volkmaars 1
- Reibel, B.V., Shipping & Forwarding 1
- Rotterdam Distriport 1
- Rotterdam Port Management Company 1
- Rotterdamsche Droogdok Mij, N.V. 1
Registration_Number 13 ✖
- Netherland Publishing Corporation 5
- FCB/InterMarketing 3
- FCB New York 1
- Haight, Gardner, Poor & Havens 1
- Advance Coal Management Corporation 1
- Holland & Knight 1
- Heron, Burchette, Ruckert & Rothwell 1
- Benner, Burnett & Coleman 1
- William J. Dyess Associates, Inc. 1
- Golin/Harris Communications, Inc. 1
- Cadwalader, Wickersham & Taft 1
- InterMarketing, Ltd. 1
- Eckert, Seamans, Cherin & Mellott 1
Registrant_Name 13
- Netherland Publishing Corporation 5
- FCB/InterMarketing 3
- Advance Coal Management Corporation 1
- Benner, Burnett & Coleman 1
- Cadwalader, Wickersham & Taft 1
- Eckert, Seamans, Cherin & Mellott 1
- FCB New York 1
- Golin/Harris Communications, Inc. 1
- Haight, Gardner, Poor & Havens 1
- Heron, Burchette, Ruckert & Rothwell 1
- Holland & Knight 1
- InterMarketing, Ltd. 1
- William J. Dyess Associates, Inc. 1
Registrant_Date (date) 12 ✖
- 1949-09-15 5
- 1984-11-06 3
- 1982-05-28 2
- 1973-03-28 1
- 1980-05-21 1
- 1983-06-23 1
- 1985-03-07 1
- 1986-06-10 1
- 1987-03-18 1
- 1988-01-21 1
- 1994-08-29 1
- 1995-10-11 1
State 1
- - 19
Country/Location_Represented 1
- NETHERLANDS 19
City 1
- - 19
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
972 | 972 | 1996-01-01 | Nedlloyd Lijnen, B.V. | 1995-10-11 | NETHERLANDS | Eckert, Seamans, Cherin & Mellott 5057 | 1995-10-11 | Eckert, Seamans, Cherin & Mellott | Rotterdam | ||||
1754 | 1754 | 1991-01-31 | City of Rotterdam | 1987-11-06 | NETHERLANDS | Golin/Harris Communications, Inc. 3949 | 1987-03-18 | Golin/Harris Communications, Inc. | Rotterdam | ||||
3437 | 3437 | 1983-03-04 | RSV Mining Equipment, B.V. | 1982-05-28 | NETHERLANDS | Holland & Knight 3375 | 1982-05-28 | Holland & Knight | Rotterdam | ||||
5540 | 5540 | 1952-04-25 | Holland America Lijn | 1949-09-15 | NETHERLANDS | Netherland Publishing Corporation 589 | 1949-09-15 | Netherland Publishing Corporation | Rotterdam | ||||
5541 | 5541 | 1952-04-25 | Hollandsche Bank Unie, N.V. | 1950-05-01 | NETHERLANDS | Netherland Publishing Corporation 589 | 1949-09-15 | Netherland Publishing Corporation | Rotterdam | ||||
5548 | 5548 | 1952-04-25 | Koninklijke Rotterdamsche Lloyd | 1950-05-01 | NETHERLANDS | Netherland Publishing Corporation 589 | 1949-09-15 | Netherland Publishing Corporation | Rotterdam | ||||
5551 | 5551 | 1952-04-25 | Lever Brothers & Unilever | 1949-09-15 | NETHERLANDS | Netherland Publishing Corporation 589 | 1949-09-15 | Netherland Publishing Corporation | Rotterdam | ||||
5558 | 5558 | 1952-04-25 | Rotterdamsche Droogdok Mij, N.V. | 1950-05-01 | NETHERLANDS | Netherland Publishing Corporation 589 | 1949-09-15 | Netherland Publishing Corporation | Rotterdam | ||||
6403 | 6403 | 1991-05-08 | Chamber of Commerce of the City of Rotterdam | 1990-12-03 | NETHERLANDS | FCB/InterMarketing 3628 | 1984-11-06 | FCB/InterMarketing | Rotterdam | ||||
6410 | 6410 | 1991-05-08 | Reibel, B.V., Shipping & Forwarding | 1989-03-15 | NETHERLANDS | FCB/InterMarketing 3628 | 1984-11-06 | FCB/InterMarketing | Rotterdam | ||||
6411 | 6411 | 1991-05-08 | Rotterdam Distriport | 1989-03-15 | NETHERLANDS | FCB/InterMarketing 3628 | 1984-11-06 | FCB/InterMarketing | Rotterdam | ||||
7401 | 7401 | 1988-06-01 | RSV Mining Equipment, B.V. | 1983-06-23 | NETHERLANDS | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell | Rotterdam | ||||
8429 | 8429 | 1988-06-30 | Loyens & Volkmaars | 1988-01-21 | NETHERLANDS | Cadwalader, Wickersham & Taft 4083 | 1988-01-21 | Cadwalader, Wickersham & Taft | Rotterdam | ||||
9043 | 9043 | 1989-07-06 | Nedlloyd Lijnen, B.V. | 1988-08-18 | NETHERLANDS | Benner, Burnett & Coleman 3654 | 1985-03-07 | Benner, Burnett & Coleman | Rotterdam | ||||
10734 | 10734 | 1983-08-25 | RSV Mining Equipment, B.V. | 1982-05-28 | NETHERLANDS | Advance Coal Management Corporation 3373 | 1982-05-28 | Advance Coal Management Corporation | Rotterdam | ||||
11031 | 11031 | 1994-08-31 | Rotterdam Port Management Company | 1994-08-29 | NETHERLANDS | InterMarketing, Ltd. 4940 | 1994-08-29 | InterMarketing, Ltd. | Rotterdam | ||||
12491 | 12491 | 1993-10-05 | City of Rotterdam | 1988-09-30 | NETHERLANDS | FCB New York 2415 | 1973-03-28 | FCB New York | Rotterdam | ||||
14127 | 14127 | 1993-11-21 | Nedlloyd Lijnen, B.V. | 1990-01-30 | NETHERLANDS | Haight, Gardner, Poor & Havens 3108 | 1980-05-21 | Haight, Gardner, Poor & Havens | Rotterdam | ||||
14371 | 14371 | 1987-11-30 | B.V. Stevedore Company Quick Dispatch | 1986-06-10 | NETHERLANDS | William J. Dyess Associates, Inc. 3843 | 1986-06-10 | William J. Dyess Associates, Inc. | Rotterdam |
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]) );