FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where "Foreign_Principal_Registration_Date" is on date 1986-08-11 sorted by rowid
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Registrant_Date, Registrant_Date (date)
Foreign_Principal 17
- AB Volvo 1
- Australian Department of Trade 1
- British Crown Imports, Inc. 1
- Canadian Society for Defense of Tradition, Family & Property 1
- Fokker-VFW International 1
- Government of Aruba 1
- Government of Canada 1
- Hong Kong Government Information Services 1
- Hong Kong Trade Development Council 1
- Instituto Boliviano de Turismo 1
- JETRO, New York 1
- Japan Machine Tool Builders' Association 1
- Japan Machinery Exporters' Association 1
- Japan Metal Forming Machine Builders' Association 1
- Korean Airlines 1
- Mozambique National Resistance (RENAMO) 1
- Stelco, Inc. 1
Foreign_Principal_Termination_Date (date) 14 ✖
- 1987-01-15 3
- 1986-08-19 2
- 1986-02-04 1
- 1986-07-29 1
- 1987-05-15 1
- 1988-02-18 1
- 1988-02-26 1
- 1988-04-30 1
- 1988-09-25 1
- 1988-12-31 1
- 1989-06-30 1
- 1992-09-09 1
- 1993-11-30 1
- 1995-04-21 1
Registrant_Name 12
- Ernest Wittenberg Associates, Inc. 3
- Milbank, Tweed, Hadley & McCloy 3
- Ernest Beyl Public Relations, Inc. 2
- AbramsonEhrlichManes, Inc. 1
- Alonso Jr., Andres 1
- Campaign Planning, Inc. 1
- Da Costa, Mario Navarro 1
- Dentsu Burson-Marsteller, Inc. 1
- Mark A. Siegel & Associates, Inc. 1
- Serapiao, Luis B. 1
- Volvo North American Corporation 1
- Weatherly & Associates, Inc. 1
Country/Location_Represented 10
- JAPAN 4
- CANADA 3
- HONG KONG 3
- ARUBA 1
- AUSTRALIA 1
- BOLIVIA 1
- KOREA, SOUTH 1
- MOZAMBIQUE 1
- NETHERLANDS 1
- SWEDEN 1
City 1
- - 17
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1326 | 1326 | 1987-01-15 | Japan Machine Tool Builders' Association | 1986-08-11 | JAPAN | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Tokyo | ||||
1327 | 1327 | 1987-01-15 | Japan Machinery Exporters' Association | 1986-08-11 | JAPAN | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Tokyo | ||||
1328 | 1328 | 1987-01-15 | Japan Metal Forming Machine Builders' Association | 1986-08-11 | JAPAN | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Tokyo | ||||
2188 | 2188 | 1986-02-04 | Stelco, Inc. | 1986-08-11 | CANADA | Ernest Wittenberg Associates, Inc. 3601 | 1984-06-26 | Ernest Wittenberg Associates, Inc. | Toronto | ||||
2646 | 2646 | 1988-02-18 | Instituto Boliviano de Turismo | 1986-08-11 | BOLIVIA | Alonso Jr., Andres 3868 | 1986-08-11 | Alonso Jr., Andres | La Paz | ||||
2862 | 2862 | 1988-02-26 | Government of Canada | 1986-08-11 | CANADA | Campaign Planning, Inc. 3862 | 1986-07-25 | Campaign Planning, Inc. | |||||
5467 | 5467 | 1995-04-21 | JETRO, New York | 1986-08-11 | JAPAN | Dentsu Burson-Marsteller, Inc. 3861 | 1986-07-23 | Dentsu Burson-Marsteller, Inc. | New York | NY | |||
5833 | 5833 | 1988-04-30 | Australian Department of Trade | 1986-08-11 | AUSTRALIA | Ernest Beyl Public Relations, Inc. 3463 | 1983-04-26 | Ernest Beyl Public Relations, Inc. | |||||
6562 | 6562 | 1987-05-15 | Korean Airlines | 1986-08-11 | KOREA, SOUTH | Weatherly & Associates, Inc. 3860 | 1986-07-17 | Weatherly & Associates, Inc. | |||||
8439 | 8439 | 1989-06-30 | Government of Aruba | 1986-08-11 | ARUBA | Mark A. Siegel & Associates, Inc. 3865 | 1986-08-01 | Mark A. Siegel & Associates, Inc. | |||||
9585 | 9585 | 1986-07-29 | AB Volvo | 1986-08-11 | SWEDEN | Volvo North American Corporation 3864 | 1986-07-29 | Volvo North American Corporation | Gothenburg | ||||
10613 | 10613 | 1986-08-19 | British Crown Imports, Inc. | 1986-08-11 | HONG KONG | Ernest Wittenberg Associates, Inc. 3773 | 1986-07-17 | Ernest Wittenberg Associates, Inc. | |||||
10614 | 10614 | 1986-08-19 | Hong Kong Trade Development Council | 1986-08-11 | HONG KONG | Ernest Wittenberg Associates, Inc. 3773 | 1986-07-17 | Ernest Wittenberg Associates, Inc. | |||||
11470 | 11470 | 1992-09-09 | Mozambique National Resistance (RENAMO) | 1986-08-11 | MOZAMBIQUE | Serapiao, Luis B. 3867 | 1986-08-08 | Serapiao, Luis B. | Goromgosa | ||||
11817 | 11817 | 1988-09-25 | Hong Kong Government Information Services | 1986-08-11 | HONG KONG | Ernest Beyl Public Relations, Inc. 3463 | 1983-04-26 | Ernest Beyl Public Relations, Inc. | |||||
14443 | 14443 | 1993-11-30 | Fokker-VFW International | 1986-08-11 | NETHERLANDS | AbramsonEhrlichManes, Inc. 3103 | 1980-04-30 | AbramsonEhrlichManes, Inc. | Amsterdam | ||||
16041 | 16041 | 1988-12-31 | Canadian Society for Defense of Tradition, Family & Property | 1986-08-11 | CANADA | Da Costa, Mario Navarro 3863 | 1986-07-29 | Da Costa, Mario Navarro | Montreal |
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]) );