FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
113 rows where "Registrant_Date" is on date 1984-11-15 sorted by Registrant_Date
This data as json, CSV (advanced)
Foreign_Principal 13
- CNIA - Critical National Infrastructure Authority, Abu Dhabi 1
- Embassy of the Republic of Korea 1
- Government of Argentina 1
- Government of Georgia 1
- Government of Portugal (Foreign Ministry) 1
- Government of Trinidad and Tobago (through Ainsley Gill & Associates) 1
- Hong Kong Economic & Trade Office 1
- Macau Handover Ceremony Coordination Office 1
- SECOFI 1
- Suzlon Energy Ltd. 1
- The Global Covenant of Mayors for Climate & Energy on behalf of the European Climate Foundation 1
- United Nations Development Programme on behalf of the Government of Panama 1
- White House Writers Group on behalf of the Polish National Foundation 1
Country/Location_Represented 13
- ARGENTINA 1
- GEORGIA 1
- HONG KONG 1
- INDIA 1
- KOREA, SOUTH 1
- MACAU 1
- MEXICO 1
- NETHERLANDS 1
- PANAMA 1
- POLAND 1
- PORTUGAL 1
- TRINIDAD AND TOBAGO 1
- UNITED ARAB EMIRATES 1
City 3
- - 10
- Washington 2
- Abu Dhabi 1
Registrant_Name 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14846 | 14846 | 2000-12-06 | Hong Kong Economic & Trade Office | 2000-11-21 | HONG KONG | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 1520 18th Street, N.W. | DC | |||
16329 | 16329 | 1995-12-31 | Government of Portugal (Foreign Ministry) | 1994-08-25 | PORTUGAL | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | Lisboa | ||||
16466 | 16466 | 1999-12-31 | Macau Handover Ceremony Coordination Office | 1999-09-17 | MACAU | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | Avenue de Amizada, 207 P.O. Box 1955 | ||||
16486 | 16486 | 2000-12-31 | SECOFI | 1999-09-17 | MEXICO | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | SECOFI - NAFTA Office Embassy of Mexico 1911 Pennsylvania Avenue., N.W. | DC | |||
16549 | 16549 | 2004-12-31 | Government of Georgia | 2004-11-10 | GEORGIA | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | Office of the Prime Minister Government of Georgia 7, Ingorokva str. 0134 Tbilisi | ||||
16593 | 16593 | 2005-12-31 | Government of Trinidad and Tobago (through Ainsley Gill & Associates) | 2005-09-16 | TRINIDAD AND TOBAGO | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 1627 K Street, NW | #901 | Washington | DC | 20006 |
16651 | 16651 | 2009-12-31 | CNIA - Critical National Infrastructure Authority, Abu Dhabi | 2009-10-01 | UNITED ARAB EMIRATES | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | Airport Road | Al Bateen Air Base 62220 | Abu Dhabi | ||
16693 | 16693 | 2011-12-31 | Embassy of the Republic of Korea | 2010-09-24 | KOREA, SOUTH | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
16699 | 16699 | 2011-12-31 | Suzlon Energy Ltd. | 2010-06-25 | INDIA | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 5th Floor, Godrej Millennium 9, Koregaon Park Road | Pune - 411 001 | |||
16827 | 16827 | 2018-12-31 | Government of Argentina | 2018-11-13 | ARGENTINA | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | Av. Julio A. Roca 782 Piso * | Buenos Aires | |||
16839 | 16839 | 2018-12-31 | The Global Covenant of Mayors for Climate & Energy on behalf of the European Climate Foundation | 2018-12-20 | NETHERLANDS | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 2513 AM | Riviervismarkt 5 The Hague | |||
16865 | 16865 | 2019-12-31 | White House Writers Group on behalf of the Polish National Foundation | 2020-02-26 | POLAND | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | |||||
16914 | 16914 | 2021-12-31 | United Nations Development Programme on behalf of the Government of Panama | 2020-11-06 | PANAMA | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | Clayton, Ciudad del Saber, Edif. 129 Casa de las | Naciones Unidas, Ciudad de Panama |
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]) );