FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where "Foreign_Principal_Termination_Date" is on date 1995-06-30 sorted by City
This data as json, CSV (advanced)
Suggested facets: Address_1, Registrant_Date (date)
Registrant_Name 11
Foreign_Principal 11
- Australian Meat & Livestock Corporation 1
- Board of Foreign Trade, Ministry of Economic Affairs 1
- Brambles U.S.A., Inc. 1
- COBE Laboratories, Inc. 1
- China External Trade Development Council (CETRA")" 1
- Government of Ukraine, Embassy 1
- Mexican Investment Board 1
- Ministry of Defense, Republic of Croatia 1
- Oil Insurance, Ltd. 1
- Rabintex Industries, Ltd. 1
- Swedish Shipowners' Association 1
Country/Location_Represented 8
City 1
- - 11
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8529 | 8529 | 1995-06-30 | Swedish Shipowners' Association | 1994-12-05 | SWEDEN | Lorentzon, Ola 4975 | 1994-12-05 | Lorentzon, Ola | Gothenburg | ||||
8530 | 8530 | 1995-06-30 | Australian Meat & Livestock Corporation | 1993-06-18 | AUSTRALIA | Brouillard Communications 4819 | 1993-06-18 | Brouillard Communications | New York | NY | |||
8531 | 8531 | 1995-06-30 | Board of Foreign Trade, Ministry of Economic Affairs | 1985-09-26 | TAIWAN | NKM Associates, Inc. 3739 | 1985-09-26 | NKM Associates, Inc. | Taipei | ||||
8532 | 8532 | 1995-06-30 | Brambles U.S.A., Inc. | 1989-09-08 | AUSTRALIA | Mayer, Brown & Platt 3076 | 1979-12-13 | Mayer, Brown & Platt | Chicago | IL | |||
8533 | 8533 | 1995-06-30 | COBE Laboratories, Inc. | 1994-12-16 | SWEDEN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Lakewood | CO | |||
8534 | 8534 | 1995-06-30 | China External Trade Development Council (CETRA")" | 1992-03-27 | TAIWAN | Grey Advertising, Inc. 4641 | 1992-03-27 | Grey Advertising, Inc. | Taipei | ||||
8535 | 8535 | 1995-06-30 | Government of Ukraine, Embassy | 1994-12-02 | UKRAINE | Ronald S. Winton & Associates 4978 | 1994-12-02 | Ronald S. Winton & Associates | Washington | DC | |||
8536 | 8536 | 1995-06-30 | Mexican Investment Board | 1991-04-18 | MEXICO | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | Mexico City | ||||
8537 | 8537 | 1995-06-30 | Ministry of Defense, Republic of Croatia | 1993-12-17 | CROATIA | Global Enterprises Group, Inc. 4877 | 1993-12-17 | Global Enterprises Group, Inc. | Petra Kresimira | ||||
8538 | 8538 | 1995-06-30 | Oil Insurance, Ltd. | 1994-06-17 | BERMUDA | Cahill, Gordon & Reindel 4920 | 1994-06-17 | Cahill, Gordon & Reindel | Pembroke | ||||
8539 | 8539 | 1995-06-30 | Rabintex Industries, Ltd. | 1993-09-14 | ISRAEL | Rafiah, Zvi 4736 | 1992-12-01 | Rafiah, Zvi | Bnei Brak |
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]) );