FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where "Registrant_Date" is on date 2007-05-07
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Address_2, Zip, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 15
- Embassy of Chile 2
- Moroccan American Center for Policy 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
- Hong Kong Economic Trade Office (HKETO) 1
- Hong Kong Trade Development Council through GrayLoeffler 1
- Levant Suez Consulting Corporation for Sheik Fahad Al Ali Al Sabah and Fahad Al Salem Center 1
- Mexico Ministry of Tourism 1
- Office of President of the Republic of Congo through Trout Cacheris 1
- Procolombia 1
- State of the Netherlands/Royal Netherlands Embassy 1
- Tourism Fiji 1
Country/Location_Represented 13
- HONG KONG 3
- CHILE 2
- MOROCCO 2
- CHINA 1
- COLOMBIA 1
- CONGO, DEMOCRATIC REPUBLIC OF THE 1
- FIJI 1
- KUWAIT 1
- MEXICO 1
- NETHERLANDS 1
- PAKISTAN 1
- PERU 1
- TRINIDAD AND TOBAGO 1
City 6
- Washington 9
- - 4
- Miami 1
- Missouri City 1
- New York 1
- Port-of-Spain 1
Registrant_Name 2
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 | |
6054 | 6054 | 2009-04-30 | Hong Kong Economic Trade Office (HKETO) | 2007-05-07 | HONG KONG | Gray Global Advisors, LLC 5806 | 2007-05-07 | Gray Global Advisors, LLC | 1520 18th Street, 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 | |
7240 | 7240 | 2012-05-31 | Moroccan American Center for Policy | 2009-02-27 | MOROCCO | Gray Global Advisors, LLC 5806 | 2007-05-07 | Gray Global Advisors, LLC | 1220 L Street, NW | Suite 411 | Washington | DC | 20005 |
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 |
7453 | 7453 | 2011-06-01 | Levant Suez Consulting Corporation for Sheik Fahad Al Ali Al Sabah and Fahad Al Salem Center | 2011-03-14 | KUWAIT | Gray Global Advisors, LLC 5806 | 2007-05-07 | Gray Global Advisors, LLC | 4002 Townsville Circle | #105 | Missouri City | TX | 77459 |
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 | |
13483 | 13483 | 2017-10-31 | Moroccan American Center for Policy | 2014-02-26 | MOROCCO | Gray Global Advisors, LLC 5806 | 2007-05-07 | Gray Global Advisors, LLC | 1220 L Street, NW | Suite 411 | Washington | DC | 20005 |
13642 | 13642 | 2011-11-01 | Hong Kong Trade Development Council through GrayLoeffler | 2009-06-30 | HONG KONG | Gray Global Advisors, LLC 5806 | 2007-05-07 | Gray Global Advisors, LLC | |||||
14723 | 14723 | 2009-12-01 | Office of President of the Republic of Congo through Trout Cacheris | 2008-09-25 | CONGO, DEMOCRATIC REPUBLIC OF THE | Gray Global Advisors, LLC 5806 | 2007-05-07 | Gray Global Advisors, LLC | Brazzaville | ||||
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]) );