FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where Address_1 = "The Hague" and Country/Location_Represented = "NETHERLANDS" sorted by Registrant_Name
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 13
- Alofs, Edward J. 1
- Arnold & Porter Kaye Scholer LLP 1
- Braun & Company 1
- Brown, Francis Lestrade 1
- C.J. LaRoche & Company, Inc. 1
- Covington & Burling 1
- Davis, Gillenwater, Lynch & Doane 1
- De Vries, Henry Peter 1
- EG&A International, Inc. 1
- FCB/InterMarketing 1
- Free Holland on the Seas, Inc. 1
- Hill & Knowlton, Inc. 1
- LKP International, Ltd. 1
Foreign_Principal 9
- Netherlands National Tourist Office 3
- Government of the Netherlands 2
- KLM Royal Dutch Airlines 2
- Dutch Employers' Federation 1
- Industrial Consultants Netherlands, B.V. 1
- NRV Holiday, B.V. 1
- Netherlands Minister of Social Affairs (Through its Representative J.F. van Hengel) 1
- Netherlands Ministry of Economic Affairs 1
- Netherlands Ministry of Finance 1
State 1
- - 13
Country/Location_Represented 1
- NETHERLANDS · 13 ✖
City 1
- - 13
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6136 | 6136 | 1965-05-01 | Netherlands Ministry of Economic Affairs | 1964-05-08 | NETHERLANDS | Alofs, Edward J. 1725 | 1964-05-08 | Alofs, Edward J. | The Hague | ||||
15905 | 15905 | 1984-12-31 | Dutch Employers' Federation | 1980-03-27 | NETHERLANDS | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | The Hague | ||||
10876 | 10876 | 1961-08-31 | KLM Royal Dutch Airlines | 1959-11-20 | NETHERLANDS | Braun & Company 1298 | 1959-11-20 | Braun & Company | The Hague | ||||
8838 | 8838 | 1972-07-01 | KLM Royal Dutch Airlines | 1956-08-30 | NETHERLANDS | Brown, Francis Lestrade 974 | 1956-08-30 | Brown, Francis Lestrade | The Hague | ||||
6543 | 6543 | 1964-05-15 | Netherlands National Tourist Office | 1964-04-27 | NETHERLANDS | C.J. LaRoche & Company, Inc. 1716 | 1964-04-27 | C.J. LaRoche & Company, Inc. | The Hague | ||||
5154 | 5154 | 1957-04-11 | Government of the Netherlands | 1955-06-28 | NETHERLANDS | Covington & Burling 523 | 1948-04-16 | Covington & Burling | The Hague | ||||
15840 | 15840 | 1980-12-31 | Industrial Consultants Netherlands, B.V. | 1980-02-15 | NETHERLANDS | Davis, Gillenwater, Lynch & Doane 3089 | 1980-02-15 | Davis, Gillenwater, Lynch & Doane | The Hague | ||||
7872 | 7872 | 1966-06-16 | Netherlands Ministry of Finance | 1956-06-05 | NETHERLANDS | De Vries, Henry Peter 955 | 1956-06-05 | De Vries, Henry Peter | The Hague | ||||
15664 | 15664 | 1968-12-31 | Netherlands National Tourist Office | 1963-01-31 | NETHERLANDS | EG&A International, Inc. 1584 | 1962-11-28 | EG&A International, Inc. | The Hague | ||||
6407 | 6407 | 1991-05-08 | NRV Holiday, B.V. | 1989-03-15 | NETHERLANDS | FCB/InterMarketing 3628 | 1984-11-06 | FCB/InterMarketing | The Hague | ||||
15539 | 15539 | 1954-12-31 | Netherlands Minister of Social Affairs (Through its Representative J.F. van Hengel) | 1947-04-28 | NETHERLANDS | Free Holland on the Seas, Inc. 459 | 1947-04-28 | Free Holland on the Seas, Inc. | The Hague | ||||
10968 | 10968 | 1983-08-31 | Government of the Netherlands | 1978-07-25 | NETHERLANDS | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | The Hague | ||||
3278 | 3278 | 1985-03-01 | Netherlands National Tourist Office | 1974-06-03 | NETHERLANDS | LKP International, Ltd. 2514 | 1974-06-03 | LKP International, Ltd. | The Hague |
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]) );