FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where Registrant_Name = "Fleishman-Hillard, Inc." and State = "DC" sorted by Registrant_Date
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Registrant_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 10
- Embassy of Denmark 1
- Embassy of Japan in the United States of America 1
- Embassy of Rwanda 1
- Embassy of Singapore 1
- Embassy of South Africa 1
- Government of Qatar, Embassy 1
- Government of Spain, Embassy 1
- Government of Turkey, Embassy 1
- Government of the Republic of Turkey, Embassy 1
- Royal Norwegian Government, Embassy 1
Country/Location_Represented 9
City 3
- - 6
- Washington 3
- Washington 1
State 1
- DC · 10 ✖
Registrant_Name 1
- Fleishman-Hillard, Inc. · 10 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4558 | 4558 | 1997-03-31 | Royal Norwegian Government, Embassy | 1997-03-06 | NORWAY | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | Washington | DC | |||
7153 | 7153 | 1996-05-31 | Embassy of South Africa | 1996-04-24 | SOUTH AFRICA | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | Washington | DC | |||
7156 | 7156 | 1996-05-31 | Government of Qatar, Embassy | 1996-03-29 | QATAR | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | Washington | DC | |||
8425 | 8425 | 1988-06-30 | Government of Spain, Embassy | 1988-01-19 | SPAIN | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | Washington | DC | |||
10152 | 10152 | 2004-08-05 | Embassy of Rwanda | 2003-09-22 | RWANDA | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 1714 New Hampshire Avenue, N.W. 20009 | DC | |||
14471 | 14471 | 1997-11-30 | Government of Turkey, Embassy | 1994-06-09 | TURKEY | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | Washington | DC | |||
3127 | 3127 | 2018-02-28 | Embassy of Singapore | 2013-03-12 | SINGAPORE | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 3501 International Place, NW | Washington | DC | 20008 | |
3983 | 3983 | 2021-03-22 | Embassy of Japan in the United States of America | 2021-01-30 | JAPAN | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 2520 Massachusetts Avenue NW | Washington | DC | 20008 | |
6080 | 6080 | 2014-04-30 | Government of the Republic of Turkey, Embassy | 2007-09-24 | TURKEY | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 2525 Massachusetts Avenue, NW | Washington | DC | 20008 | |
12235 | 12235 | 2016-09-30 | Embassy of Denmark | 2016-07-25 | DENMARK | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 3200 Whitehaven Street, NW | Washington | DC | 20008 |
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]) );