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 1989-06-30 sorted by City
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Address_1, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 15
- Alfredo Cristiani 1
- Carlos Andres Perez, President-Elect of Venezuela 1
- Chinese Association for Human Rights; Chinese Press Institute; Chinese National Assn. of Industry & Commerce 1
- European Community 1
- Government of Aruba 1
- Government of Bermuda 1
- Israel Ministry of Tourism 1
- Komatsu Electronic Metals 1
- Korea Foreign Trade Association (KFTA) 1
- Mexican Government Tourism Office (Consejo Nacional de Turismo) 1
- New Zealand Government Tourist Board 1
- Palm Oil Registration & Licensing Authority (PORLA) 1
- Perta Oil Marketing, Ltd. 1
- STC, PLC 1
- Unitary Tax Campaign, Ltd. 1
Registrant_Name 14
- Hill and Knowlton Strategies, LLC 2
- Daniel J. Edelman, Inc. 1
- GCI Group, Inc. 1
- George C. Benson, Ltd. 1
- Hannaford Company, Inc. 1
- IPG DXTRA, Inc 1
- Lowe Marschalk, Inc. 1
- Mark A. Siegel & Associates, Inc. 1
- O'Connor & Hannan, L.L.P. 1
- Palumbo & Cerrell, Inc. 1
- Squire Patton Boggs, LLP 1
- Sutherland, Asbill & Brennan 1
- Swidler Berlin Shereff Friedman, LLP 1
- Washington Policy & Analysis 1
Country/Location_Represented 14
- GREAT BRITAIN 2
- ARUBA 1
- BERMUDA 1
- EL SALVADOR 1
- HONG KONG 1
- INTERNATIONAL 1
- ISRAEL 1
- JAPAN 1
- KOREA, SOUTH 1
- MALAYSIA 1
- MEXICO 1
- NEW ZEALAND 1
- TAIWAN 1
- VENEZUELA 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8435 | 8435 | 1989-06-30 | Alfredo Cristiani | 1989-04-27 | EL SALVADOR | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | San Salvador | ||||
8436 | 8436 | 1989-06-30 | Carlos Andres Perez, President-Elect of Venezuela | 1989-01-27 | VENEZUELA | Washington Policy & Analysis 4211 | 1989-01-27 | Washington Policy & Analysis | Caracas | ||||
8437 | 8437 | 1989-06-30 | Chinese Association for Human Rights; Chinese Press Institute; Chinese National Assn. of Industry & Commerce | 1989-06-02 | TAIWAN | Hannaford Company, Inc. 2850 | 1977-11-29 | Hannaford Company, Inc. | Taipei | ||||
8438 | 8438 | 1989-06-30 | European Community | 1986-09-26 | INTERNATIONAL | Palumbo & Cerrell, Inc. 3888 | 1986-09-26 | Palumbo & Cerrell, Inc. | Washington | DC | |||
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. | |||||
8440 | 8440 | 1989-06-30 | Government of Bermuda | 1986-04-22 | BERMUDA | Sutherland, Asbill & Brennan 3307 | 1981-11-20 | Sutherland, Asbill & Brennan | Hamilton | ||||
8441 | 8441 | 1989-06-30 | Israel Ministry of Tourism | 1989-04-18 | ISRAEL | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | New York | NY | |||
8442 | 8442 | 1989-06-30 | Komatsu Electronic Metals | 1988-12-31 | JAPAN | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | New York | NY | |||
8443 | 8443 | 1989-06-30 | Korea Foreign Trade Association (KFTA) | 1989-03-22 | KOREA, SOUTH | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | Seoul | ||||
8444 | 8444 | 1989-06-30 | Mexican Government Tourism Office (Consejo Nacional de Turismo) | 1987-07-13 | MEXICO | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
8445 | 8445 | 1989-06-30 | New Zealand Government Tourist Board | 1985-03-29 | NEW ZEALAND | Lowe Marschalk, Inc. 3670 | 1985-03-29 | Lowe Marschalk, Inc. | CA | ||||
8446 | 8446 | 1989-06-30 | Palm Oil Registration & Licensing Authority (PORLA) | 1987-06-17 | MALAYSIA | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Kuala Lumpur | ||||
8447 | 8447 | 1989-06-30 | Perta Oil Marketing, Ltd. | 1980-12-24 | HONG KONG | George C. Benson, Ltd. 3183 | 1980-12-24 | George C. Benson, Ltd. | |||||
8448 | 8448 | 1989-06-30 | STC, PLC | 1988-10-07 | GREAT BRITAIN | Swidler Berlin Shereff Friedman, LLP 4079 | 1988-01-07 | Swidler Berlin Shereff Friedman, LLP | London | ||||
8449 | 8449 | 1989-06-30 | Unitary Tax Campaign, Ltd. | 1986-02-13 | GREAT BRITAIN | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | London |
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]) );