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 1999-06-30 sorted by City
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registrant_Date, Foreign_Principal_Registration_Date (date)
Foreign_Principal 11
- Atlantis Submarines International, Inc. 1
- Bank Polska Kasa Opieki, S.A. 1
- Embassy of Ukraine to the U.S.A. 1
- Government of Togo, Embassy 1
- Kuwait Airways 1
- Middle East Airlines 1
- Permanent Mission of Ukraine to the United Nations 1
- Project Echo Partners, South Coast Metropole Partnership Le Havre City Council, Cherbourg City Council, Flevoland Province Council 1
- State of Qatar, Embassy 1
- Taiwan Ministry of Foreign Affairs Board of Foreign Trade, China External Trade Development Council (CETRA) 1
- Toyo Kogyo, Ltd. (Mazda Motor Corporation) a/k/a Mazda Motor Corporation 1
Country/Location_Represented 9
Registrant_Name 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8578 | 8578 | 1999-06-30 | Atlantis Submarines International, Inc. | 1992-02-12 | CANADA | Leone & Leone, Ltd. 4619 | 1992-02-12 | Leone & Leone, Ltd. | British Columbia | ||||
8579 | 8579 | 1999-06-30 | Bank Polska Kasa Opieki, S.A. | 1954-02-23 | POLAND | Pekao Trading Corporation 817 | 1954-02-23 | Pekao Trading Corporation | Warsaw | ||||
8580 | 8580 | 1999-06-30 | Embassy of Ukraine to the U.S.A. | 1992-06-08 | UKRAINE | Foundation in Support of Diplomatic Missions of Ukraine, Inc 4683 | 1992-06-08 | Foundation in Support of Diplomatic Missions of Ukraine, Inc | Washington | DC | |||
8581 | 8581 | 1999-06-30 | Government of Togo, Embassy | 1998-06-26 | TOGO | Fein, Bruce 5263 | 1998-06-26 | Fein, Bruce | Washington | DC | |||
8582 | 8582 | 1999-06-30 | Kuwait Airways | 1980-04-07 | KUWAIT | Dickstein Shapiro, LLP 3028 | 1979-06-07 | Dickstein Shapiro, LLP | New York | NY | |||
8583 | 8583 | 1999-06-30 | Middle East Airlines | 1981-07-22 | INTERNATIONAL | Dickstein Shapiro, LLP 3028 | 1979-06-07 | Dickstein Shapiro, LLP | Beirut | ||||
8584 | 8584 | 1999-06-30 | Permanent Mission of Ukraine to the United Nations | 1992-06-08 | UKRAINE | Foundation in Support of Diplomatic Missions of Ukraine, Inc 4683 | 1992-06-08 | Foundation in Support of Diplomatic Missions of Ukraine, Inc | New York | NY | |||
8585 | 8585 | 1999-06-30 | Project Echo Partners, South Coast Metropole Partnership Le Havre City Council, Cherbourg City Council, Flevoland Province Council | 1999-08-03 | INTERNATIONAL | Barbara Burns & Associates, Inc. 4600 | 1991-12-06 | Barbara Burns & Associates, Inc. | Southhampton City Council Floor 2, Marland House 17 Civic Centre Road Southhampton S04 7PQ UK | ||||
8586 | 8586 | 1999-06-30 | State of Qatar, Embassy | 1996-09-06 | QATAR | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Washington | DC | |||
8587 | 8587 | 1999-06-30 | Taiwan Ministry of Foreign Affairs Board of Foreign Trade, China External Trade Development Council (CETRA) | 1998-03-24 | TAIWAN | Weber Group 5250 | 1998-03-24 | Weber Group | Taipei World Trade Center Exhibition Hall 2A-18 5 Hsin Yi Road, Sec. 5 Taipei | ||||
8588 | 8588 | 1999-06-30 | Toyo Kogyo, Ltd. (Mazda Motor Corporation) a/k/a Mazda Motor Corporation | 1989-02-16 | JAPAN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Hiroshima |
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]) );