FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where "Foreign_Principal_Termination_Date" is on date 1996-01-01 sorted by Address_2
This data as json, CSV (advanced)
Suggested facets: Registrant_Date, Address_1, Foreign_Principal_Registration_Date (date)
Foreign_Principal 15
- Avions de Transport Regional, Groupement d'Interet Economique 1
- Berna Products Corporation 1
- British Telecommunications, PLC 1
- British Tourist Authority 1
- CONACEX NORESTE, A.C. 1
- Cayman Airways 1
- Government of Denmark 1
- Grand Metropolitan, Inc. 1
- Hashemite Kingdom of Jordan 1
- Interbank Aruba, N.V. 1
- Major British Banks Group 1
- Nedlloyd Lijnen, B.V. 1
- Ross University 1
- Volga-Dnepr J.S. Cargo Airline 1
- Yeun-Jun Chung 1
Country/Location_Represented 12
- GREAT BRITAIN 4
- ARUBA 1
- CAYMAN ISLANDS 1
- DENMARK 1
- DOMINICA 1
- FRANCE 1
- JORDAN 1
- KOREA, SOUTH 1
- MEXICO 1
- NETHERLANDS 1
- RUSSIA 1
- SWITZERLAND 1
Registrant_Name 11
- Hogan Lovells US LLP 3
- MWW/Strategic Communications, Inc. 3
- Aspen Hill Enterprises, Ltd. 1
- BT North America, Inc., Washington Office 1
- Eckert, Seamans, Cherin & Mellott 1
- Manatt, Phelps & Phillips 1
- Marston Webb & Associates, Inc. 1
- O'Leary Clarke & Partners, Inc. 1
- Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 1
- Shaw, Pittman, Potts & Trowbridge 1
- Washington Group 1
City 1
- - 15
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
961 | 961 | 1996-01-01 | Avions de Transport Regional, Groupement d'Interet Economique | 1994-11-30 | FRANCE | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | Blagnac Cedex | ||||
962 | 962 | 1996-01-01 | Berna Products Corporation | 1993-02-16 | SWITZERLAND | MWW/Strategic Communications, Inc. 4542 | 1991-07-12 | MWW/Strategic Communications, Inc. | Coral Gables | FL | |||
963 | 963 | 1996-01-01 | British Telecommunications, PLC | 1991-09-18 | GREAT BRITAIN | BT North America, Inc., Washington Office 4566 | 1991-09-18 | BT North America, Inc., Washington Office | London | ||||
964 | 964 | 1996-01-01 | British Tourist Authority | 1974-08-12 | GREAT BRITAIN | Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 2530 | 1974-08-12 | Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. | |||||
965 | 965 | 1996-01-01 | CONACEX NORESTE, A.C. | 1994-06-08 | MEXICO | Manatt, Phelps & Phillips 3736 | 1985-09-20 | Manatt, Phelps & Phillips | Monterrey | ||||
966 | 966 | 1996-01-01 | Cayman Airways | 1991-12-27 | CAYMAN ISLANDS | O'Leary Clarke & Partners, Inc. 3780 | 1986-02-20 | O'Leary Clarke & Partners, Inc. | Cayman Islands | ||||
967 | 967 | 1996-01-01 | Government of Denmark | 1993-10-01 | DENMARK | Marston Webb & Associates, Inc. 4209 | 1989-01-24 | Marston Webb & Associates, Inc. | New York | NY | |||
968 | 968 | 1996-01-01 | Grand Metropolitan, Inc. | 1993-05-18 | GREAT BRITAIN | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | Westport | CT | |||
969 | 969 | 1996-01-01 | Hashemite Kingdom of Jordan | 1988-07-13 | JORDAN | Aspen Hill Enterprises, Ltd. 4158 | 1988-07-13 | Aspen Hill Enterprises, Ltd. | Amman | ||||
970 | 970 | 1996-01-01 | Interbank Aruba, N.V. | 1994-12-27 | ARUBA | MWW/Strategic Communications, Inc. 4542 | 1991-07-12 | MWW/Strategic Communications, Inc. | Oranjestad | ||||
971 | 971 | 1996-01-01 | Major British Banks Group | 1996-03-21 | GREAT BRITAIN | Shaw, Pittman, Potts & Trowbridge 2580 | 1975-02-21 | Shaw, Pittman, Potts & Trowbridge | London | ||||
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 | ||||
973 | 973 | 1996-01-01 | Ross University | 1992-05-05 | DOMINICA | MWW/Strategic Communications, Inc. 4542 | 1991-07-12 | MWW/Strategic Communications, Inc. | |||||
974 | 974 | 1996-01-01 | Volga-Dnepr J.S. Cargo Airline | 1993-12-20 | RUSSIA | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | Ulyanovsk | ||||
975 | 975 | 1996-01-01 | Yeun-Jun Chung | 1995-06-23 | KOREA, SOUTH | Washington Group 4332 | 1990-01-18 | Washington Group | Seoul |
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]) );