FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
30 rows where Address_1 = "" and Country/Location_Represented = "NETHERLANDS"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Foreign_Principal_Termination_Date (date), Registrant_Date (date)
Foreign_Principal 30
- Amsterdam Stock Exchange 1
- Amsterdam-Rotterdam Bank 1
- Brandon Mesritz & Company 1
- Central Bureau of Fruit & Vegetable Auctions in Holland 1
- City of Rotterdam 1
- Committee of European Shipowners 1
- Delft Instruments, N.V. 1
- Economic Information Service of the Netherlands Ministry of Economic Affairs 1
- Elsevier Science Publishers, B.V. 1
- Embassy of the Netherlands 1
- Foundation The Netherlands-The U.S. of America 200 1
- Holland Plant Exporters Association 1
- Holland-American Cruises 1
- Hoogovens Group, B.V. 1
- Java Textiel Maatschappij 1
- KLM Royal Dutch Airlines 1
- Kingdom of the Netherlands 1
- Koninkljke Nederlandse Hoogovens, N.V. 1
- N.V. Indisch Kantoor van Koopman & Company 1
- Netherlands Government Information Service 1
- Netherlands Government, Ministry of Foreign Affairs of the Kingdom of the Netherlands 1
- Netherlands Ministry of Economic Affairs 1
- Noro Realty Advisors, Inc. 1
- RSV Mining Equipment, B.V. 1
- Smit-Lloyd, B.V. 1
- Stedelijk Museum Amsterdam 1
- Stichting Civitas Christiana 1
- Suriname, part of the Kingdom of the Netherlands 1
- Van der Giessen de Noord 1
- Volvo Car, B.V. 1
Foreign_Principal_Registration_Date (date) 29 ✖
- 1942-08-14 2
- 1944-01-08 1
- 1947-07-14 1
- 1947-09-10 1
- 1949-09-15 1
- 1950-08-22 1
- 1951-10-16 1
- 1959-10-30 1
- 1962-09-26 1
- 1966-12-31 1
- 1967-10-16 1
- 1970-09-28 1
- 1978-08-03 1
- 1980-08-08 1
- 1981-03-31 1
- 1982-01-29 1
- 1982-05-28 1
- 1983-05-04 1
- 1983-12-13 1
- 1984-09-18 1
- 1985-09-04 1
- 1986-04-10 1
- 1986-05-30 1
- 1987-03-24 1
- 1987-08-11 1
- 1989-06-28 1
- 1991-08-08 1
- 2012-04-26 1
- 2019-12-02 1
Registrant_Name 26
- Bernard Preyer Company 2
- Netherland Publishing Corporation 2
- Netherlands Chamber of Commerce in the U.S. 2
- North American Precis Syndicate 2
- Bishop, Cook, Purcell & Reynolds 1
- Burson-Marsteller 1
- Dow, Lohnes & Albertson, L.L.P. 1
- FCB/InterMarketing 1
- Feltus, Randolph 1
- Fierce, Donald L. 1
- Foundation for a Christian Civilization, Inc. 1
- Hill and Knowlton Strategies, LLC 1
- IPAC, Inc. 1
- James, Leonard Gage 1
- Kaye, Scholer, Fierman, Hays & Handler 1
- King & Spalding 1
- Lake, James H. 1
- Netherland-American Foundation, Inc. 1
- Netherlands Information Service 1
- Peabody, Lambert & Meyers 1
- Powell, Goldstein, Frazer & Murphy, L.L.P. 1
- Ruder Finn, Inc. 1
- Schoenfeld Film Distribution Corporation 1
- Strong, George Eugene 1
- Suriname Philatelic Agency, Ltd. 1
- Surrey & Morse 1
Country/Location_Represented 1
- NETHERLANDS · 30 ✖
City 1
- - 30
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1073 | 1073 | 1979-01-05 | KLM Royal Dutch Airlines | 1978-08-03 | NETHERLANDS | Peabody, Lambert & Meyers 2765 | 1977-03-29 | Peabody, Lambert & Meyers | |||||
1277 | 1277 | 1948-01-14 | Holland Plant Exporters Association | 1947-07-14 | NETHERLANDS | Strong, George Eugene 478 | 1947-07-14 | Strong, George Eugene | |||||
1570 | 1570 | 2017-01-27 | Stichting Civitas Christiana | 2019-12-02 | NETHERLANDS | Foundation for a Christian Civilization, Inc. 6759 | 2019-12-02 | Foundation for a Christian Civilization, Inc. | |||||
1717 | 1717 | 1986-01-31 | Elsevier Science Publishers, B.V. | 1981-03-31 | NETHERLANDS | Kaye, Scholer, Fierman, Hays & Handler 3221 | 1981-03-31 | Kaye, Scholer, Fierman, Hays & Handler | |||||
2460 | 2460 | 1945-02-14 | Brandon Mesritz & Company | 1942-08-14 | NETHERLANDS | Bernard Preyer Company 96 | 1942-08-14 | Bernard Preyer Company | |||||
2462 | 2462 | 1945-02-14 | N.V. Indisch Kantoor van Koopman & Company | 1942-08-14 | NETHERLANDS | Bernard Preyer Company 96 | 1942-08-14 | Bernard Preyer Company | |||||
2643 | 2643 | 1985-02-18 | Volvo Car, B.V. | 1984-09-18 | NETHERLANDS | Bishop, Cook, Purcell & Reynolds 3050 | 1979-08-17 | Bishop, Cook, Purcell & Reynolds | |||||
4171 | 4171 | 1988-03-30 | Smit-Lloyd, B.V. | 1987-08-11 | NETHERLANDS | Dow, Lohnes & Albertson, L.L.P. 3452 | 1983-03-17 | Dow, Lohnes & Albertson, L.L.P. | |||||
4900 | 4900 | 1986-04-01 | Noro Realty Advisors, Inc. | 1986-04-10 | NETHERLANDS | King & Spalding 3812 | 1986-04-10 | King & Spalding | |||||
5156 | 5156 | 1969-04-11 | Committee of European Shipowners | 1962-09-26 | NETHERLANDS | James, Leonard Gage 1554 | 1962-07-03 | James, Leonard Gage | |||||
5203 | 5203 | 1986-04-12 | Amsterdam Stock Exchange | 1985-09-04 | NETHERLANDS | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5543 | 5543 | 1952-04-25 | Java Textiel Maatschappij | 1949-09-15 | NETHERLANDS | Netherland Publishing Corporation 589 | 1949-09-15 | Netherland Publishing Corporation | |||||
5550 | 5550 | 1952-04-25 | Koninkljke Nederlandse Hoogovens, N.V. | 1951-10-16 | NETHERLANDS | Netherland Publishing Corporation 589 | 1949-09-15 | Netherland Publishing Corporation | |||||
6191 | 6191 | 1984-05-01 | Van der Giessen de Noord | 1983-12-13 | NETHERLANDS | Fierce, Donald L. 3541 | 1983-12-13 | Fierce, Donald L. | |||||
6404 | 6404 | 1991-05-08 | City of Rotterdam | 1986-05-30 | NETHERLANDS | FCB/InterMarketing 3628 | 1984-11-06 | FCB/InterMarketing | |||||
8182 | 8182 | 1944-06-30 | Kingdom of the Netherlands | 1944-01-08 | NETHERLANDS | Netherland-American Foundation, Inc. 229 | 1944-01-08 | Netherland-American Foundation, Inc. | |||||
8329 | 8329 | 1979-06-30 | Netherlands Government Information Service | 1967-10-16 | NETHERLANDS | Schoenfeld Film Distribution Corporation 2056 | 1967-10-16 | Schoenfeld Film Distribution Corporation | |||||
10305 | 10305 | 1992-08-12 | Hoogovens Group, B.V. | 1989-06-28 | NETHERLANDS | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | |||||
10630 | 10630 | 1996-08-20 | Delft Instruments, N.V. | 1991-08-08 | NETHERLANDS | IPAC, Inc. 4008 | 1987-07-08 | IPAC, Inc. | |||||
10735 | 10735 | 1983-08-25 | RSV Mining Equipment, B.V. | 1982-05-28 | NETHERLANDS | Lake, James H. 3374 | 1982-05-29 | Lake, James H. | |||||
10887 | 10887 | 1972-08-31 | Netherlands Government, Ministry of Foreign Affairs of the Kingdom of the Netherlands | 1966-12-31 | NETHERLANDS | Netherlands Information Service 2048 | 1966-12-31 | Netherlands Information Service | |||||
12214 | 12214 | 2012-09-30 | Stedelijk Museum Amsterdam | 2012-04-26 | NETHERLANDS | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | |||||
12294 | 12294 | 1948-10-01 | Embassy of the Netherlands | 1947-09-10 | NETHERLANDS | Feltus, Randolph 381 | 1946-10-16 | Feltus, Randolph | |||||
12321 | 12321 | 1976-10-01 | Economic Information Service of the Netherlands Ministry of Economic Affairs | 1970-09-28 | NETHERLANDS | Netherlands Chamber of Commerce in the U.S. 639 | 1950-08-22 | Netherlands Chamber of Commerce in the U.S. | |||||
12324 | 12324 | 1976-10-01 | Netherlands Ministry of Economic Affairs | 1950-08-22 | NETHERLANDS | Netherlands Chamber of Commerce in the U.S. 639 | 1950-08-22 | Netherlands Chamber of Commerce in the U.S. | |||||
12597 | 12597 | 1984-10-11 | Holland-American Cruises | 1983-05-04 | NETHERLANDS | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
15128 | 15128 | 1982-12-15 | Foundation The Netherlands-The U.S. of America 200 | 1982-01-29 | NETHERLANDS | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | |||||
15383 | 15383 | 1963-12-26 | Suriname, part of the Kingdom of the Netherlands | 1959-10-30 | NETHERLANDS | Suriname Philatelic Agency, Ltd. 1290 | 1959-10-30 | Suriname Philatelic Agency, Ltd. | |||||
15854 | 15854 | 1981-12-31 | Amsterdam-Rotterdam Bank | 1980-08-08 | NETHERLANDS | Surrey & Morse 2649 | 1976-01-05 | Surrey & Morse | |||||
16102 | 16102 | 1989-12-31 | Central Bureau of Fruit & Vegetable Auctions in Holland | 1987-03-24 | NETHERLANDS | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC |
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]) );