FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where "Foreign_Principal_Termination_Date" is on date 2011-12-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Address_1, Zip, Registrant_Date (date)
Registrant_Name 11
- Daniel J. Edelman, Inc. 2
- APCO Worldwide, Inc. 1
- FGS Global (US) LLC (FKA FGH Holdings LLC) 1
- Fenton Communications 1
- KWR International, Inc. 1
- Levick Strategic Communications 1
- Miller & Chevalier, Chartered 1
- Nelson Mullins Riley & Scarborough, LLP 1
- Rosemont Associates, LLC 1
- Salvatore Services, LLC 1
- U.S. - Emirates Alliance, LLC 1
Foreign_Principal 11
- Embassy of the Republic of Korea 2
- Alberta Energy 1
- Board of Foreign Trade (BOFT) 1
- Government of Ecuador, Ministry for the Coordination of Production, Employment and Competitiveness 1
- Government of Malaysia, Embassy 1
- International Counsel Bureau on behalf of Kuwaiti Detainees Committee 1
- Peoples Democratic Party of the Republic of Equatorial Guinea 1
- Promotion and Investment Board, Province of Riau Islands 1
- Suzlon Energy Ltd. 1
- Taipei Economic and Cultural Representative Office in the U.S. 1
- U.A.E. Embassy 1
Country/Location_Represented 10
- KOREA, SOUTH 2
- TAIWAN 2
- CANADA 1
- ECUADOR 1
- EQUATORIAL GUINEA 1
- INDIA 1
- INDONESIA 1
- KUWAIT 1
- MALAYSIA 1
- UNITED ARAB EMIRATES 1
City 7
- - 5
- Washington 2
- 62502 Putrajaya 1
- Abu Dhabi 1
- Malabo 1
- Quito 1
- Tanjungpinang 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16690 | 16690 | 2011-12-31 | Alberta Energy | 2010-11-15 | CANADA | Nelson Mullins Riley & Scarborough, LLP 5928 | 2009-04-10 | Nelson Mullins Riley & Scarborough, LLP | |||||
16691 | 16691 | 2011-12-31 | Board of Foreign Trade (BOFT) | 2002-07-16 | TAIWAN | Miller & Chevalier, Chartered 5365 | 2000-04-03 | Miller & Chevalier, Chartered | Taipei | ||||
16696 | 16696 | 2011-12-31 | International Counsel Bureau on behalf of Kuwaiti Detainees Committee | 2004-10-08 | KUWAIT | Levick Strategic Communications 5649 | 2004-10-08 | Levick Strategic Communications | P.O Box 0941 Safat | ||||
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 | |||
16700 | 16700 | 2011-12-31 | Taipei Economic and Cultural Representative Office in the U.S. | 2005-02-02 | TAIWAN | Rosemont Associates, LLC 5668 | 2005-02-02 | Rosemont Associates, LLC | 4201 Wisconsin Avenue, NW 20016 | DC | |||
16695 | 16695 | 2011-12-31 | Government of Malaysia, Embassy | 2009-07-27 | MALAYSIA | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | Office of the Chief Secretary to the Government | Prime Minister's Department, Level 4, East Parcel A Federal Government Administrative Centre | 62502 Putrajaya | ||
16701 | 16701 | 2011-12-31 | U.A.E. Embassy | 2007-01-22 | UNITED ARAB EMIRATES | U.S. - Emirates Alliance, LLC 5785 | 2007-01-22 | U.S. - Emirates Alliance, LLC | P.O. Box 4442 | Abu Dhabi | |||
16697 | 16697 | 2011-12-31 | Peoples Democratic Party of the Republic of Equatorial Guinea | 2010-12-23 | EQUATORIAL GUINEA | Salvatore Services, LLC 6012 | 2010-12-23 | Salvatore Services, LLC | D. Acacio Mane | S/M Gustavo Envela | Malabo | ||
16694 | 16694 | 2011-12-31 | Government of Ecuador, Ministry for the Coordination of Production, Employment and Competitiveness | 2010-06-10 | ECUADOR | Fenton Communications 5945 | 2009-06-26 | Fenton Communications | Av. Coruna y 12 de Octubre, Edificio altana Paza 4to piso. | Quito | |||
16698 | 16698 | 2011-12-31 | Promotion and Investment Board, Province of Riau Islands | 2011-06-29 | INDONESIA | KWR International, Inc. 5119 | 1996-07-02 | KWR International, Inc. | Tanjungpinang | ||||
16692 | 16692 | 2011-12-31 | Embassy of the Republic of Korea | 2010-09-20 | KOREA, SOUTH | FGS Global (US) LLC (FKA FGH Holdings LLC) 5666 | 2005-01-31 | FGS Global (US) LLC (FKA FGH Holdings LLC) | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
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 |
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]) );