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 2001-03-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Address_1, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 14
- Italian Trade Commission 2
- British Trade Development Office 1
- Cayman Islands Department of Tourism 1
- Croatian National Tourist Office, Inc. 1
- Democratic Republic of the Congo 1
- Government of Georgia, Embassy 1
- Government of Japan 1
- Hamburg Business Development Corporation 1
- His Excellency Ibrahim Saminu Turaki, Governor Jigawa State 1
- Japan Cotton Textile Exporters' Association 1
- Japan External Trade Organization (JETRO) 1
- Republic of Georgia 1
- Singapore Technologies Engineering (USA), Inc. 1
- VEVE Group 1
Registrant_Name 12
- Global Communicators/ Harff Communications, Inc. 3
- Japan Economic Institute of America 2
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- BKSH & Associates 1
- Business Network Corporation 1
- Capitol Advisors, Inc. 1
- Caribou Technologies, Inc. 1
- Cohen & Woods International, Inc. 1
- Hill and Knowlton Strategies, LLC 1
- O'Leary Clarke & Partners, Inc. 1
- Oliver A. Dulle, Jr. & Company, Inc. 1
- Spring O'Brien & Company, Inc. 1
Country/Location_Represented 11
- JAPAN 3
- GEORGIA 2
- ITALY 2
- ALBANIA 1
- CAYMAN ISLANDS 1
- CONGO, REPUBLIC OF THE 1
- CROATIA 1
- GERMANY 1
- GREAT BRITAIN 1
- NIGERIA 1
- SINGAPORE 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4589 | 4589 | 2001-03-31 | Japan Cotton Textile Exporters' Association | 1956-01-25 | JAPAN | Japan Economic Institute of America 929 | 1956-01-25 | Japan Economic Institute of America | Osaka | ||||
4590 | 4590 | 2001-03-31 | British Trade Development Office | 1985-03-19 | GREAT BRITAIN | Spring O'Brien & Company, Inc. 3661 | 1985-03-19 | Spring O'Brien & Company, Inc. | New York | NY | |||
4591 | 4591 | 2001-03-31 | Cayman Islands Department of Tourism | 1986-02-20 | CAYMAN ISLANDS | O'Leary Clarke & Partners, Inc. 3780 | 1986-02-20 | O'Leary Clarke & Partners, Inc. | |||||
4592 | 4592 | 2001-03-31 | Croatian National Tourist Office, Inc. | 2000-11-03 | CROATIA | Global Communicators/ Harff Communications, Inc. 5241 | 1998-03-05 | Global Communicators/ Harff Communications, Inc. | New York | NY | |||
4593 | 4593 | 2001-03-31 | Democratic Republic of the Congo | 1999-02-11 | CONGO, REPUBLIC OF THE | Cohen & Woods International, Inc. 5003 | 1995-03-10 | Cohen & Woods International, Inc. | Kinshasa | ||||
4594 | 4594 | 2001-03-31 | Government of Georgia, Embassy | 1998-03-25 | GEORGIA | Capitol Advisors, Inc. 5245 | 1998-03-25 | Capitol Advisors, Inc. | 1511 K Street, N.W., Suite 400 | DC | |||
4595 | 4595 | 2001-03-31 | Government of Japan | 1956-01-25 | JAPAN | Japan Economic Institute of America 929 | 1956-01-25 | Japan Economic Institute of America | Washington | DC | |||
4596 | 4596 | 2001-03-31 | Hamburg Business Development Corporation | 1999-03-31 | GERMANY | Global Communicators/ Harff Communications, Inc. 5241 | 1998-03-05 | Global Communicators/ Harff Communications, Inc. | Hamburger Strasse 11 D 22083 | ||||
4597 | 4597 | 2001-03-31 | His Excellency Ibrahim Saminu Turaki, Governor Jigawa State | 2000-12-14 | NIGERIA | BKSH & Associates 5402 | 2000-12-14 | BKSH & Associates | Government House Dutse, Jigawa State | ||||
4598 | 4598 | 2001-03-31 | Italian Trade Commission | 2001-02-05 | ITALY | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Fashion Center 499 Park Avenue New York 10022 | NY | |||
4599 | 4599 | 2001-03-31 | Italian Trade Commission | 2000-07-05 | ITALY | Oliver A. Dulle, Jr. & Company, Inc. 4739 | 1992-12-17 | Oliver A. Dulle, Jr. & Company, Inc. | Via Liszt 21 00144 ROMA | ||||
4600 | 4600 | 2001-03-31 | Japan External Trade Organization (JETRO) | 1997-11-24 | JAPAN | Business Network Corporation 4513 | 1991-05-20 | Business Network Corporation | Tokyo | ||||
4601 | 4601 | 2001-03-31 | Republic of Georgia | 2001-04-17 | GEORGIA | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | Ministry of Finance of the Republic of Georgia 70, IR. Abashidze Street, 380062 Tbilishi | ||||
4602 | 4602 | 2001-03-31 | Singapore Technologies Engineering (USA), Inc. | 2000-04-18 | SINGAPORE | Caribou Technologies, Inc. 5367 | 2000-04-18 | Caribou Technologies, Inc. | 7701 Lemmon Avenue Dallas 75209 | TX | |||
4603 | 4603 | 2001-03-31 | VEVE Group | 2001-05-11 | ALBANIA | Global Communicators/ Harff Communications, Inc. 5241 | 1998-03-05 | Global Communicators/ Harff Communications, Inc. | Bulevardi Deshmovet e Kombit Tirana |
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]) );