FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
22 rows where "Registrant_Date" is on date 1982-04-08 sorted by State
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Registration_Number, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Foreign_Principal 22
- AEG-Kanis Turbinenfabrik GmbH 1
- Air New Zealand, Ltd. 1
- Amadeus Global Travel Distribution, S.A. 1
- Banking Federation of the European Union 1
- British Gas Corporation 1
- British Virgin Islands Tourist Board 1
- Commission of the European Communities 1
- Commission of the European Union 1
- Deutsche Lufthansa Aktiengesellschaft 1
- Deutsche Lufthansa, A.G. 1
- Enewetak/Ujelang Local Government Council 1
- European Communities 1
- Government of Tibet In Exile 1
- Government of the Federal Republic of Germany 1
- Grand Metropolitan, PLC 1
- Hapag-Lloyd Aktiengesellschaft 1
- Kingdom of the Netherlands 1
- Rafael Group 1
- Shoreline Mutual (Bermuda), Ltd. 1
- Sumitomo Metal Industries, Ltd. 1
- Swiss Bankers' Association 1
- Wendell Investments, Ltd. 1
Address_1 18 ✖
Country/Location_Represented 13
Registrant_Name 2
City 1
- - 22
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
84 | 84 | British Virgin Islands Tourist Board | 1982-04-08 | BRITISH VIRGIN ISLANDS | British Virgin Islands Tourist Board 3354 | 1982-04-08 | British Virgin Islands Tourist Board | Tortola | |||||
1389 | 1389 | 1996-01-17 | Shoreline Mutual (Bermuda), Ltd. | 1994-05-04 | BERMUDA | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | Hamilton | ||||
2483 | 2483 | 1984-02-14 | Hapag-Lloyd Aktiengesellschaft | 1982-04-08 | GERMANY, FEDERAL REPUBLIC OF | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | Hamburg | ||||
2501 | 2501 | 1996-02-14 | Swiss Bankers' Association | 1992-10-13 | SWITZERLAND | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | Basle | ||||
3280 | 3280 | 1986-03-01 | Government of the Federal Republic of Germany | 1986-03-07 | GERMANY, FEDERAL REPUBLIC OF | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | Bonn | ||||
4881 | 4881 | 1983-04-01 | AEG-Kanis Turbinenfabrik GmbH | 1982-09-27 | GERMANY, FEDERAL REPUBLIC OF | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | Essen | ||||
7137 | 7137 | 1994-05-31 | Deutsche Lufthansa, A.G. | 1994-02-15 | GERMANY | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | Cologne | ||||
8111 | 8111 | 1989-06-26 | Enewetak/Ujelang Local Government Council | 1988-11-04 | MARSHALL ISLANDS | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | Nitijela Majuro | ||||
9327 | 9327 | 1984-07-17 | British Gas Corporation | 1983-11-01 | GREAT BRITAIN | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | London | ||||
11838 | 11838 | 1989-09-26 | Air New Zealand, Ltd. | 1988-05-25 | NEW ZEALAND | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | Auckland | ||||
12569 | 12569 | 1995-10-09 | Banking Federation of the European Union | 1995-05-25 | INTERNATIONAL | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | Bruxelles | ||||
12716 | 12716 | 1990-10-15 | Deutsche Lufthansa Aktiengesellschaft | 1983-04-01 | GERMANY | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | Koelin | ||||
13826 | 13826 | 1989-11-08 | Amadeus Global Travel Distribution, S.A. | 1989-05-08 | SPAIN | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | Madrid | ||||
13862 | 13862 | 1986-11-10 | Commission of the European Communities | 1984-05-09 | INTERNATIONAL | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | Brussels | ||||
13863 | 13863 | 1986-11-10 | Sumitomo Metal Industries, Ltd. | 1984-11-08 | JAPAN | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | Tokyo | ||||
13984 | 13984 | 1989-11-15 | Government of Tibet In Exile | 1985-07-10 | TIBET | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | |||||
14868 | 14868 | 1988-12-07 | Grand Metropolitan, PLC | 1988-10-25 | GREAT BRITAIN | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | |||||
14869 | 14869 | 1988-12-07 | Wendell Investments, Ltd. | 1988-10-25 | GREAT BRITAIN | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | London | ||||
1387 | 1387 | 1995-01-17 | Commission of the European Union | 1994-03-11 | INTERNATIONAL | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | Washington | DC | |||
4516 | 4516 | 1992-03-31 | European Communities | 1987-11-23 | GREAT BRITAIN | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | Washington | DC | |||
5619 | 5619 | 1984-04-27 | Kingdom of the Netherlands | 1982-04-08 | NETHERLANDS | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | Washington | DC | |||
6568 | 6568 | 1991-05-15 | Rafael Group | 1990-11-07 | BRITISH VIRGIN ISLANDS | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | New York | NY |
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]) );