FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where Registrant_Name = "Ogilvy Public Relations Worldwide" sorted by Registrant_Date
This data as json, CSV (advanced)
Suggested facets: Address_1, Address_2, Foreign_Principal_Termination_Date (date)
Foreign_Principal_Registration_Date (date) 11 ✖
- 2007-05-07 1
- 2007-12-31 1
- 2008-07-01 1
- 2009-02-10 1
- 2011-10-17 1
- 2012-01-25 1
- 2012-06-28 1
- 2012-12-21 1
- 2013-04-02 1
- 2014-03-11 1
- 2014-12-18 1
Foreign_Principal 10
- Embassy of Chile 2
- CCTV America 1
- Embassy of Pakistan 1
- Government of Hong Kong Special Administrative Region 1
- Government of Peru 1
- Government of the Republic of Trinidad and Tobago (via Ainsley Gill Associates, LLC) 1
- Mexico Ministry of Tourism 1
- Procolombia 1
- State of the Netherlands/Royal Netherlands Embassy 1
- Tourism Fiji 1
Country/Location_Represented 10
- CHILE 2
- CHINA 1
- COLOMBIA 1
- FIJI 1
- HONG KONG 1
- MEXICO 1
- NETHERLANDS 1
- PAKISTAN 1
- PERU 1
- TRINIDAD AND TOBAGO 1
City 5
- Washington 6
- - 2
- Miami 1
- New York 1
- Port-of-Spain 1
Registrant_Name 1
- Ogilvy Public Relations Worldwide · 11 ✖
Registrant_Date (date) 1 ✖
- 2007-05-07 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3351 | 3351 | 2015-03-01 | Government of Peru | 2014-12-18 | PERU | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | Av. Javier Prado Oeste 1440-San Isidro, | Lima, Peru | |||
4721 | 4721 | 2012-03-31 | CCTV America | 2012-01-25 | CHINA | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1099 New York Avenue, NW | Suite 430 | Washington | DC | 20001 |
4732 | 4732 | 2013-03-31 | Government of Hong Kong Special Administrative Region | 2007-05-07 | HONG KONG | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | Commissioner for Economic and Trade Affairs, United States of America | 1520 18th Street, NW | Washington | DC | 20036 |
4740 | 4740 | 2014-03-31 | Embassy of Chile | 2013-04-02 | CHILE | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1732 Massachusetts Avenue, NW | Washington | DC | 20036 | |
6719 | 6719 | 2008-05-22 | Embassy of Pakistan | 2007-12-31 | PAKISTAN | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 3517 International Court, NW | Washington | DC | 20008 | |
7262 | 7262 | 2016-05-31 | Tourism Fiji | 2012-12-21 | FIJI | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 5777 West Century Boulevard | Suite 220 | New York | NY | 90045 |
8712 | 8712 | 2013-06-30 | Mexico Ministry of Tourism | 2011-10-17 | MEXICO | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | Viaducto M. Aleman 105, Piso 6 | COL. Escandon Miguel Hidalgo 11800 Mexico, D.F. | |||
9892 | 9892 | 2012-07-31 | Embassy of Chile | 2012-06-28 | CHILE | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1732 Massachusetts Avenue, NW | Washington | DC | 20036 | |
16638 | 16638 | 2008-12-31 | Government of the Republic of Trinidad and Tobago (via Ainsley Gill Associates, LLC) | 2008-07-01 | TRINIDAD AND TOBAGO | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | Ministry of Finance - International Financial Center | Independence Square | Port-of-Spain | ||
16670 | 16670 | 2009-12-31 | State of the Netherlands/Royal Netherlands Embassy | 2009-02-10 | NETHERLANDS | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 4200 Linnean Avenue, NW | Washington | DC | 20008 | |
16770 | 16770 | 2015-12-31 | Procolombia | 2014-03-11 | COLOMBIA | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 601 Brickell Key Drive | Miami | FL | 33131 |
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]) );