FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
34 rows where Foreign_Principal_Termination_Date = "1987-12-31" and State = "" sorted by Address_1
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal >30
- Asociacion de Empresas RENFE/Patentes TALGO, S.A. 1
- Association for the Advancement of Human Rights in Japan 1
- Association of British Insurers 1
- Bahamas Ministry of Tourism 1
- British Airports Authority 1
- Canadian Forest Industries Council 1
- Cayman Airways, Ltd. 1
- Cayman Islands Government 1
- Cayman Turtle Farm (1983), Ltd. 1
- Costa Rica Private Shirt Industry 1
- Fur Institute of Canada 1
- General Administration of Civil Aviation of China (CAAC) 1
- Government of Antigua & Barbuda 1
- Government of Libya 1
- Government of the Republic of Singapore 1
- Hashemite Kingdom of Jordan 1
- Major Saad Haddad, Free Lebanon, Merjayoun, Lebanon 1
- Manitoba Energy Authority 1
- NTS (Narodno-Trudovoy Soyuz) 1
- New Zealand Government Tourist Office 1
- Panama Apparel Association 1
- Republic of Ciskei 1
- Republic of Korea 1
- Sahrawi Arab Democratic Republic (SADR) 1
- Sir William Lithgow 1
- Societe Generale de Surveillance, S.A. 1
- South African Sugar Association (SASA) 1
- St. Lucia Tourist Board 1
- State of Yucatan, Mexico (Assets & Business of Registrant Acquired by Hill & Knowlton, Inc., Registration No. 3301) 1
- Swedish Trade Council (Formerly: Sveriges Exportrad) 1
- …
Registrant_Name 26
- Finley Kumble Wagner Heine Underberg Manley Myerson & Casey 5
- Merren, Orren 3
- International Development Systems, Inc. 2
- Solter, Myron W. 2
- A.I.T. Corporation 1
- APCO Associates 1
- Aramtek Corporation 1
- Carl Byoir & Associates, Inc. 1
- Guerra-Mondragon, Gabriel 1
- Heron, Burchette, Ruckert & Rothwell 1
- Hill and Knowlton Strategies, LLC 1
- IBTT Consultants, Inc. 1
- Kilpatrick & Cody 1
- Modern Education Services, Inc. 1
- Morgan, Gary Russell 1
- N.W. Ayer & Son, Inc. 1
- NTS-Alliance of Russian Solidarists 1
- O'Melveny & Myers 1
- Peter Rothholz Associates, Inc. 1
- Radin & Associates, Inc. 1
- Riley, Thomas G. 1
- South African Sugar Association (SASA) 1
- St. Maxens & Company 1
- Tayoun, Joseph John 1
- TransSwiss Exports, Ltd. 1
- Warren/Kremer Advertising, Inc. 1
Country/Location_Represented 26
- CANADA 3
- CAYMAN ISLANDS 3
- GREAT BRITAIN 3
- CHINA 2
- TAIWAN 2
- ALGERIA 1
- ANTIGUA & BARBUDA 1
- BAHAMAS 1
- CISKEI 1
- COSTA RICA 1
- GERMANY, FEDERAL REPUBLIC OF 1
- JAPAN 1
- JORDAN 1
- KOREA, SOUTH 1
- LEBANON 1
- LIBYA 1
- MEXICO 1
- NEW ZEALAND 1
- PANAMA 1
- SAINT LUCIA 1
- SINGAPORE 1
- SOUTH AFRICA 1
- SPAIN 1
- SWEDEN 1
- SWITZERLAND 1
- USSR 1
State 1
- - · 34 ✖
City 1
- - 34
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16000 | 16000 | 1987-12-31 | Cayman Airways, Ltd. | 1984-07-20 | CAYMAN ISLANDS | Merren, Orren 3412 | 1982-09-29 | Merren, Orren | |||||
16001 | 16001 | 1987-12-31 | Cayman Islands Government | 1982-09-29 | CAYMAN ISLANDS | Merren, Orren 3412 | 1982-09-29 | Merren, Orren | |||||
16002 | 16002 | 1987-12-31 | Cayman Turtle Farm (1983), Ltd. | 1984-07-20 | CAYMAN ISLANDS | Merren, Orren 3412 | 1982-09-29 | Merren, Orren | |||||
16009 | 16009 | 1987-12-31 | Government of Libya | 1977-07-13 | LIBYA | Aramtek Corporation 2810 | 1977-07-13 | Aramtek Corporation | |||||
16010 | 16010 | 1987-12-31 | Government of the Republic of Singapore | 1985-08-23 | SINGAPORE | St. Maxens & Company 3726 | 1985-08-23 | St. Maxens & Company | |||||
16020 | 16020 | 1987-12-31 | Republic of Korea | 1984-01-31 | KOREA, SOUTH | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
16027 | 16027 | 1987-12-31 | Swedish Trade Council (Formerly: Sveriges Exportrad) | 1982-03-16 | SWEDEN | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | |||||
16011 | 16011 | 1987-12-31 | Hashemite Kingdom of Jordan | 1981-10-06 | JORDAN | IBTT Consultants, Inc. 3281 | 1981-10-06 | IBTT Consultants, Inc. | Amman | ||||
16022 | 16022 | 1987-12-31 | Sir William Lithgow | 1986-11-03 | GREAT BRITAIN | Finley Kumble Wagner Heine Underberg Manley Myerson & Casey 2799 | 1977-06-29 | Finley Kumble Wagner Heine Underberg Manley Myerson & Casey | Argyllshire | ||||
16006 | 16006 | 1987-12-31 | General Administration of Civil Aviation of China (CAAC) | 1987-04-03 | CHINA | Finley Kumble Wagner Heine Underberg Manley Myerson & Casey 2799 | 1977-06-29 | Finley Kumble Wagner Heine Underberg Manley Myerson & Casey | Beijing | ||||
16031 | 16031 | 1987-12-31 | Yan Shan Science & Technology Corporation | 1981-04-15 | CHINA | A.I.T. Corporation 3228 | 1981-04-15 | A.I.T. Corporation | Beijing | ||||
16019 | 16019 | 1987-12-31 | Republic of Ciskei | 1985-02-06 | CISKEI | Morgan, Gary Russell 3648 | 1985-02-06 | Morgan, Gary Russell | Bisho | ||||
16025 | 16025 | 1987-12-31 | St. Lucia Tourist Board | 1987-05-08 | SAINT LUCIA | Warren/Kremer Advertising, Inc. 3977 | 1987-05-08 | Warren/Kremer Advertising, Inc. | Castries | ||||
16024 | 16024 | 1987-12-31 | South African Sugar Association (SASA) | 1986-09-29 | SOUTH AFRICA | South African Sugar Association (SASA) 3892 | 1986-09-29 | South African Sugar Association (SASA) | Durban | ||||
16021 | 16021 | 1987-12-31 | Sahrawi Arab Democratic Republic (SADR) | 1986-11-17 | ALGERIA | Guerra-Mondragon, Gabriel 3907 | 1986-11-17 | Guerra-Mondragon, Gabriel | El Aioun Setlmt West | ||||
16016 | 16016 | 1987-12-31 | NTS (Narodno-Trudovoy Soyuz) | 1973-11-20 | USSR | NTS-Alliance of Russian Solidarists 565 | 1949-03-07 | NTS-Alliance of Russian Solidarists | Frankfurt | ||||
16030 | 16030 | 1987-12-31 | Verband der Chemischen Industrie, E.V. (VCI) | 1987-07-08 | GERMANY, FEDERAL REPUBLIC OF | O'Melveny & Myers 3346 | 1982-03-12 | O'Melveny & Myers | Frankfurt am Main | ||||
16023 | 16023 | 1987-12-31 | Societe Generale de Surveillance, S.A. | 1986-10-21 | SWITZERLAND | TransSwiss Exports, Ltd. 3899 | 1986-10-21 | TransSwiss Exports, Ltd. | Geneva | ||||
16014 | 16014 | 1987-12-31 | Major Saad Haddad, Free Lebanon, Merjayoun, Lebanon | 1981-12-03 | LEBANON | Tayoun, Joseph John 3315 | 1981-12-03 | Tayoun, Joseph John | Good Fence - Metulla | ||||
15996 | 15996 | 1987-12-31 | Association of British Insurers | 1985-10-04 | GREAT BRITAIN | Finley Kumble Wagner Heine Underberg Manley Myerson & Casey 2799 | 1977-06-29 | Finley Kumble Wagner Heine Underberg Manley Myerson & Casey | London | ||||
15998 | 15998 | 1987-12-31 | British Airports Authority | 1984-08-23 | GREAT BRITAIN | Kilpatrick & Cody 3610 | 1984-08-29 | Kilpatrick & Cody | London | ||||
15994 | 15994 | 1987-12-31 | Asociacion de Empresas RENFE/Patentes TALGO, S.A. | 1987-05-21 | SPAIN | Finley Kumble Wagner Heine Underberg Manley Myerson & Casey 2799 | 1977-06-29 | Finley Kumble Wagner Heine Underberg Manley Myerson & Casey | Madrid | ||||
16015 | 16015 | 1987-12-31 | Manitoba Energy Authority | 1986-12-24 | CANADA | Radin & Associates, Inc. 3921 | 1986-12-24 | Radin & Associates, Inc. | Manitoba | ||||
16026 | 16026 | 1987-12-31 | State of Yucatan, Mexico (Assets & Business of Registrant Acquired by Hill & Knowlton, Inc., Registration No. 3301) | 1986-12-15 | MEXICO | Carl Byoir & Associates, Inc. 3170 | 1980-11-24 | Carl Byoir & Associates, Inc. | Merida, Yucatan | ||||
15997 | 15997 | 1987-12-31 | Bahamas Ministry of Tourism | 1982-09-27 | BAHAMAS | N.W. Ayer & Son, Inc. 3411 | 1982-09-27 | N.W. Ayer & Son, Inc. | Nassau | ||||
15999 | 15999 | 1987-12-31 | Canadian Forest Industries Council | 1985-05-21 | CANADA | APCO Associates 3597 | 1984-06-20 | APCO Associates | Ottawa | ||||
16018 | 16018 | 1987-12-31 | Panama Apparel Association | 1987-07-13 | PANAMA | International Development Systems, Inc. 4012 | 1987-07-13 | International Development Systems, Inc. | Panama | ||||
16003 | 16003 | 1987-12-31 | Costa Rica Private Shirt Industry | 1987-07-13 | COSTA RICA | International Development Systems, Inc. 4012 | 1987-07-13 | International Development Systems, Inc. | San Jose | ||||
16007 | 16007 | 1987-12-31 | Government of Antigua & Barbuda | 1977-06-29 | ANTIGUA & BARBUDA | Finley Kumble Wagner Heine Underberg Manley Myerson & Casey 2799 | 1977-06-29 | Finley Kumble Wagner Heine Underberg Manley Myerson & Casey | St. John's | ||||
15993 | 15993 | 1987-12-31 | Taiwan Mushroom Packers' United Export Corporation | 1972-06-05 | TAIWAN | Solter, Myron W. 1970 | 1966-03-22 | Solter, Myron W. | Taipei | ||||
16028 | 16028 | 1987-12-31 | Taiwan Regional Association of Rubber Industries | 1987-09-29 | TAIWAN | Solter, Myron W. 1970 | 1966-03-22 | Solter, Myron W. | Taipei | ||||
15995 | 15995 | 1987-12-31 | Association for the Advancement of Human Rights in Japan | 1986-01-27 | JAPAN | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell | Tokyo | ||||
16005 | 16005 | 1987-12-31 | Fur Institute of Canada | 1987-09-01 | CANADA | Riley, Thomas G. 4034 | 1987-09-01 | Riley, Thomas G. | Toronto, Ontario | ||||
16017 | 16017 | 1987-12-31 | New Zealand Government Tourist Office | 1977-09-16 | NEW ZEALAND | Peter Rothholz Associates, Inc. 2830 | 1977-09-16 | Peter Rothholz Associates, Inc. | Wellington |
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]) );