FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where "Foreign_Principal_Termination_Date" is on date 1997-12-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Registrant_Date (date)
Registrant_Name 17
- Brady Company, Inc. 1
- Burson-Marsteller 1
- Chlopak, Leonard, Schechter & Associates, Inc. 1
- Daedalus International Corporation 1
- GCI Group, Inc. 1
- Graydon Associates, Inc. 1
- Kelley Swofford Roy Helmke, Inc. 1
- Lou Hammond & Associates, Inc. 1
- Manchester Trade, Ltd. 1
- Mayer, Brown & Platt 1
- Michael Solomon Associates 1
- Nichols - Dezenhall Communications Management Group, Ltd. 1
- O'Connor & Hannan, L.L.P. 1
- Robison International, Inc. 1
- Sellars, Duncan W. 1
- Severance International, Inc. 1
- Varney, Kevin P. 1
Foreign_Principal 17
- Australian Tourist Commission 1
- Bank for Foreign Economic Affairs of Russia (the BFEA) aka Bank for Foreign Trade of Russia 1
- British Aerospace, Inc. 1
- Chonghwa Telecom Company, Ltd. 1
- Conseil du Developpement Economique Canton de Vaud - Suisse 1
- Danish Ministry of Business & Industry 1
- Government of Israel, Economic Mission to North America 1
- Government of the Republic of Colombia, Administrative Department of the Presidency 1
- Hoechst Marion Roussel Deutschland GmbH 1
- International Business Communications, Inc. 1
- Meat Industry Council 1
- Ministry of Commerce & Industry, Government of Mexico 1
- National Union for the Total Independence of Angola (UNITA) 1
- Office of the Prime Minister Mesut Yilmaz - Republic of Turkey 1
- Proexport 1
- Republic of Gabon 1
- Sealand Housing Corporation 1
Country/Location_Represented 15
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16410 | 16410 | 1997-12-31 | Australian Tourist Commission | 1995-06-23 | AUSTRALIA | Lou Hammond & Associates, Inc. 3682 | 1985-05-23 | Lou Hammond & Associates, Inc. | Los Angeles | CA | |||
16411 | 16411 | 1997-12-31 | Bank for Foreign Economic Affairs of Russia (the BFEA) aka Bank for Foreign Trade of Russia | 1990-04-13 | RUSSIA | Mayer, Brown & Platt 3076 | 1979-12-13 | Mayer, Brown & Platt | New York | NY | |||
16412 | 16412 | 1997-12-31 | British Aerospace, Inc. | 1992-04-20 | GREAT BRITAIN | Robison International, Inc. 3950 | 1987-03-20 | Robison International, Inc. | Washington | DC | |||
16413 | 16413 | 1997-12-31 | Chonghwa Telecom Company, Ltd. | 1997-03-07 | TAIWAN | Severance International, Inc. 5038 | 1995-07-26 | Severance International, Inc. | Taipei | ||||
16414 | 16414 | 1997-12-31 | Conseil du Developpement Economique Canton de Vaud - Suisse | 1993-10-20 | SWITZERLAND | Graydon Associates, Inc. 4820 | 1993-06-23 | Graydon Associates, Inc. | Lausanne | ||||
16415 | 16415 | 1997-12-31 | Danish Ministry of Business & Industry | 1996-11-08 | DENMARK | Brady Company, Inc. 5138 | 1996-11-08 | Brady Company, Inc. | Copenhagen | ||||
16416 | 16416 | 1997-12-31 | Government of Israel, Economic Mission to North America | 1997-08-13 | ISRAEL | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | New York | NY | |||
16417 | 16417 | 1997-12-31 | Government of the Republic of Colombia, Administrative Department of the Presidency | 1997-06-04 | COLOMBIA | Kelley Swofford Roy Helmke, Inc. 5182 | 1997-06-04 | Kelley Swofford Roy Helmke, Inc. | Bogota | ||||
16418 | 16418 | 1997-12-31 | Hoechst Marion Roussel Deutschland GmbH | 1997-09-11 | GERMANY | Chlopak, Leonard, Schechter & Associates, Inc. 4953 | 1994-09-28 | Chlopak, Leonard, Schechter & Associates, Inc. | Bad Soden | ||||
16419 | 16419 | 1997-12-31 | International Business Communications, Inc. | 1993-09-14 | JAPAN | Michael Solomon Associates 3923 | 1987-01-06 | Michael Solomon Associates | Tokyo | ||||
16420 | 16420 | 1997-12-31 | Meat Industry Council | 1997-06-05 | AUSTRALIA | Nichols - Dezenhall Communications Management Group, Ltd. 5184 | 1997-06-05 | Nichols - Dezenhall Communications Management Group, Ltd. | Sydney | ||||
16421 | 16421 | 1997-12-31 | Ministry of Commerce & Industry, Government of Mexico | 1994-10-04 | MEXICO | Manchester Trade, Ltd. 4956 | 1994-10-04 | Manchester Trade, Ltd. | |||||
16422 | 16422 | 1997-12-31 | National Union for the Total Independence of Angola (UNITA) | 1996-02-29 | ANGOLA | Sellars, Duncan W. 5096 | 1996-02-29 | Sellars, Duncan W. | Washington | DC | |||
16423 | 16423 | 1997-12-31 | Office of the Prime Minister Mesut Yilmaz - Republic of Turkey | 1997-12-29 | TURKEY | Varney, Kevin P. 5223 | 1997-12-27 | Varney, Kevin P. | Ankara | ||||
16424 | 16424 | 1997-12-31 | Proexport | 1995-05-22 | COLOMBIA | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | Washington | DC | |||
16425 | 16425 | 1997-12-31 | Republic of Gabon | 1997-06-19 | GABON | Daedalus International Corporation 5186 | 1997-06-19 | Daedalus International Corporation | Libreville | ||||
16426 | 16426 | 1997-12-31 | Sealand Housing Corporation | 1997-09-25 | HONG KONG | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | Central |
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]) );