FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where "Foreign_Principal_Termination_Date" is on date 2000-03-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 9
- Consulate General of Japan 1
- Electronic Industry Association of Japan 1
- Government of Hong Kong Special Administrative Region (Hong Kong Economic & Trade Office) 1
- Government of Peru, Embassy 1
- Government of the Republic of Armenia 1
- President-elect Kim Dae Jung and members of his transition team 1
- Scottish Tourist Board 1
- Sveriges Radio Aktiebolag 1
- VEVE Group 1
Registrant_Name 8
- Shandwick Public Affairs, Inc. 2
- Bernhagen & Associates 1
- Carlington Sales Canada Corporation 1
- David Morey Group, Inc. (DMG) 1
- Development Counsellors International 1
- Global Communicators/ Harff Communications, Inc. 1
- Shepardson Stern & Kaminsky 1
- Sveriges Television AB (Swedish Broadcasting Corporation) 1
Country/Location_Represented 8
City 1
- - 9
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4580 | 4580 | 2000-03-31 | Consulate General of Japan | 1987-06-15 | JAPAN | Bernhagen & Associates 3992 | 1987-06-15 | Bernhagen & Associates | Seattle | WA | |||
4581 | 4581 | 2000-03-31 | Electronic Industry Association of Japan | 1999-12-10 | JAPAN | Shandwick Public Affairs, Inc. 5220 | 1997-12-17 | Shandwick Public Affairs, Inc. | Tokyo | ||||
4582 | 4582 | 2000-03-31 | Government of Hong Kong Special Administrative Region (Hong Kong Economic & Trade Office) | 1998-04-10 | HONG KONG | Shandwick Public Affairs, Inc. 5220 | 1997-12-17 | Shandwick Public Affairs, Inc. | 1520 18th Street N.W. | DC | |||
4583 | 4583 | 2000-03-31 | Government of Peru, Embassy | 1999-10-26 | PERU | Shepardson Stern & Kaminsky 5335 | 1999-10-26 | Shepardson Stern & Kaminsky | 1700 Massachusetts Avenue, N.W. | DC | |||
4584 | 4584 | 2000-03-31 | Government of the Republic of Armenia | 1999-12-09 | ARMENIA | Carlington Sales Canada Corporation 5347 | 1999-12-09 | Carlington Sales Canada Corporation | Ministry of Finance 1 Melik-Adamyan St. Yerevan 375010 | ||||
4585 | 4585 | 2000-03-31 | President-elect Kim Dae Jung and members of his transition team | 1998-02-19 | KOREA, SOUTH | David Morey Group, Inc. (DMG) 5236 | 1998-02-19 | David Morey Group, Inc. (DMG) | Seoul | ||||
4586 | 4586 | 2000-03-31 | Scottish Tourist Board | 1999-01-08 | SCOTLAND | Development Counsellors International 4777 | 1993-03-12 | Development Counsellors International | Edinburgh | ||||
4587 | 4587 | 2000-03-31 | Sveriges Radio Aktiebolag | 1989-06-14 | SWEDEN | Sveriges Television AB (Swedish Broadcasting Corporation) 1676 | 1964-01-02 | Sveriges Television AB (Swedish Broadcasting Corporation) | Stockholm | ||||
4588 | 4588 | 2000-03-31 | VEVE Group | 1999-03-31 | ALBANIA | Global Communicators/ Harff Communications, Inc. 5241 | 1998-03-05 | Global Communicators/ Harff Communications, Inc. | Blvd. Deshmoret 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]) );