FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
25 rows where "Foreign_Principal_Termination_Date" is on date 2012-12-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Address_1, Zip, Registrant_Date (date)
Foreign_Principal 24
- National Security Council of Georgia 2
- Alliance for a Green Revolution in Africa (AGRA) 1
- Azerbaijan America Alliance Corporation Board of Directors 1
- Canadian Tourism Commission 1
- Deutsche Bahn AG - DB US Holding Corporation 1
- Embassy of the Republic of Korea 1
- Funes & Asociados Publicidad 1
- Government of Georgia, National Security Council 1
- Government of the Federal District (Mexico City) 1
- Grayling Momentum, on behalf of Grayling Momentum's client Qatar National Security Programme (QNFSP) 1
- Islamic Supreme Council of Iraq 1
- Kingdom of Morocco (via Gerson Global Strategic Advisors) 1
- Korea International Trade Association (KITA) 1
- Ministry of Finance of the Republic of Iraq 1
- Mongolian Investment Initiative 1
- Office of Commercial Affairs of the Royal Thai Embassy 1
- Oficina de Visitantes y Convenciones de Vallarta Nayarit 1
- Republic of Korea, Embassy 1
- Singapore Tourism Board 1
- Swiss Private Bankers Association 1
- Taipei Economic and Cultural Representative Office in the United States 1
- Transitional National Council/The Libyan Interim National Council 1
- Turkish Culture & Tourism Office 1
- Via Rail 1
Registrant_Name 19
- M. Silver Associates, Inc. 4
- IPG DXTRA, Inc 3
- Podesta Group, Inc. 2
- Azerbaijan America Alliance Corporation 1
- BLJ Worldwide LTD 1
- Cardenas Partners, LLC 1
- Cleary, Gottlieb, Steen & Hamilton, LLP 1
- Gephardt Group Government Affairs, LLC 1
- Global Communicators, LLC 1
- Grayling Connecting Point, LLC 1
- Harbour Group, LLC 1
- ISCI-USA, Inc. 1
- Orion Strategies LLC 1
- Park Strategies, LLC 1
- Ruder Finn, Inc. 1
- Singer Bonjean Strategies 1
- Squire Patton Boggs, LLP 1
- Strategy XXI Group, LLC 1
- Venn Strategies, LLC 1
Country/Location_Represented 18
- GEORGIA 3
- KOREA, SOUTH 3
- CANADA 2
- IRAQ 2
- MEXICO 2
- AZERBAIJAN 1
- EL SALVADOR 1
- GERMANY 1
- INTERNATIONAL 1
- LIBYA 1
- MONGOLIA 1
- MOROCCO 1
- QATAR 1
- SINGAPORE 1
- SWITZERLAND 1
- TAIWAN 1
- THAILAND 1
- TURKEY 1
City 7
- - 13
- Washington 6
- New York 2
- Baghdad 1
- San Salvador 1
- Tarrytown 1
- Tbilisi 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16702 | 16702 | 2012-12-31 | Grayling Momentum, on behalf of Grayling Momentum's client Qatar National Security Programme (QNFSP) | 2012-09-14 | QATAR | Grayling Connecting Point, LLC 6133 | 2012-09-14 | Grayling Connecting Point, LLC | Emiri Diwan, Doha P.O. Box 923 | ||||
16703 | 16703 | 2012-12-31 | Alliance for a Green Revolution in Africa (AGRA) | 2010-05-24 | INTERNATIONAL | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | Eden Square, Bloc 1 | Westlands 00800, Nairobi | |||
16705 | 16705 | 2012-12-31 | Canadian Tourism Commission | 2010-07-22 | CANADA | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | Suite 1400, FOur Bentall Centre | 1055 Dunsmuir Street, BOx 49230 Vancouver, BC Canada V7X 1L2 | |||
16709 | 16709 | 2012-12-31 | Government of Georgia, National Security Council | 2009-12-09 | GEORGIA | Orion Strategies LLC 5437 | 2001-05-30 | Orion Strategies LLC | National Security Council of Georgia | Ingorokva St. 7 Tbilisi, 0134 | |||
16710 | 16710 | 2012-12-31 | Government of the Federal District (Mexico City) | 2009-09-18 | MEXICO | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | Avenida Nuevo Leon No. 56, Piso 8 | Col. Hippodromo Condesa C.P. 06100 Delegacion Cuauhemoc, Distrito Federal | |||
16712 | 16712 | 2012-12-31 | Kingdom of Morocco (via Gerson Global Strategic Advisors) | 2011-07-14 | MOROCCO | BLJ Worldwide LTD 5875 | 2008-06-17 | BLJ Worldwide LTD | |||||
16713 | 16713 | 2012-12-31 | Korea International Trade Association (KITA) | 2010-02-04 | KOREA, SOUTH | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | |||||
16714 | 16714 | 2012-12-31 | Ministry of Finance of the Republic of Iraq | 2004-07-15 | IRAQ | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Ministry of Finance Palestine Street Baghdad | ||||
16715 | 16715 | 2012-12-31 | Mongolian Investment Initiative | 2012-06-14 | MONGOLIA | Venn Strategies, LLC 6110 | 2012-06-14 | Venn Strategies, LLC | |||||
16717 | 16717 | 2012-12-31 | National Security Council of Georgia | 2012-07-09 | GEORGIA | Gephardt Group Government Affairs, LLC 5874 | 2008-07-21 | Gephardt Group Government Affairs, LLC | Ingorokva Street 7 | 0134 Tbilisi | |||
16719 | 16719 | 2012-12-31 | Oficina de Visitantes y Convenciones de Vallarta Nayarit | 2007-09-06 | MEXICO | M. Silver Associates, Inc. 3131 | 1980-07-15 | M. Silver Associates, Inc. | Av. Cocoteros #85 Sur Local 16-A Paradise Plaza | ||||
16722 | 16722 | 2012-12-31 | Swiss Private Bankers Association | 2009-11-05 | SWITZERLAND | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | Rue Bouy Lysberg 8 | CH-1211 Genevall | |||
16726 | 16726 | 2012-12-31 | Via Rail | 2002-10-01 | CANADA | M. Silver Associates, Inc. 3131 | 1980-07-15 | M. Silver Associates, Inc. | 3 Place Ville - Marie Suite 500 Montreal, Quebec H3B 209 | ||||
16711 | 16711 | 2012-12-31 | Islamic Supreme Council of Iraq | 2008-10-06 | IRAQ | ISCI-USA, Inc. 5885 | 2008-10-06 | ISCI-USA, Inc. | Street #55, House #24, Alkarada Alshariquieah, Babylon District | Baghdad | |||
16721 | 16721 | 2012-12-31 | Singapore Tourism Board | 2008-10-14 | SINGAPORE | M. Silver Associates, Inc. 3131 | 1980-07-15 | M. Silver Associates, Inc. | 1156 Avenue of the Americas | New York | NY | 10036 | |
16725 | 16725 | 2012-12-31 | Turkish Culture & Tourism Office | 2010-03-12 | TURKEY | M. Silver Associates, Inc. 3131 | 1980-07-15 | M. Silver Associates, Inc. | 821 United Nations Plaza, 4th Floor | New York | NY | 10017 | |
16708 | 16708 | 2012-12-31 | Funes & Asociados Publicidad | 2011-12-15 | EL SALVADOR | Cardenas Partners, LLC 6080 | 2011-12-15 | Cardenas Partners, LLC | Torre Futura, Nivel 12 Local 3 | 87 Av. Nte y 9a Calle Poniente | San Salvador | ||
16706 | 16706 | 2012-12-31 | Deutsche Bahn AG - DB US Holding Corporation | 2011-12-23 | GERMANY | Strategy XXI Group, LLC 6058 | 2011-08-18 | Strategy XXI Group, LLC | DB US Holding Corporation | 120 White Plains Road | Tarrytown | NY | 10591 |
16716 | 16716 | 2012-12-31 | National Security Council of Georgia | 2010-02-03 | GEORGIA | Podesta Group, Inc. 5926 | 2009-04-01 | Podesta Group, Inc. | Ingorokv st. 7 | Tbilisi | |||
16704 | 16704 | 2012-12-31 | Azerbaijan America Alliance Corporation Board of Directors | 2011-06-07 | AZERBAIJAN | Azerbaijan America Alliance Corporation 6046 | 2011-06-07 | Azerbaijan America Alliance Corporation | 1101 Pennsylvania Avenue, NW Suite 600 | Washington | DC | 20004 | |
16707 | 16707 | 2012-12-31 | Embassy of the Republic of Korea | 2010-09-21 | KOREA, SOUTH | Singer Bonjean Strategies 6001 | 2010-09-21 | Singer Bonjean Strategies | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
16718 | 16718 | 2012-12-31 | Office of Commercial Affairs of the Royal Thai Embassy | 2007-09-05 | THAILAND | Global Communicators, LLC 5817 | 2007-06-26 | Global Communicators, LLC | 1024 Wisconsin Avenue, NW | Washington | DC | 20007 | |
16720 | 16720 | 2012-12-31 | Republic of Korea, Embassy | 2011-07-29 | KOREA, SOUTH | Podesta Group, Inc. 5926 | 2009-04-01 | Podesta Group, Inc. | 2450 Massachussets Avenue, NW | Washington | DC | 20008 | |
16723 | 16723 | 2012-12-31 | Taipei Economic and Cultural Representative Office in the United States | 2009-01-09 | TAIWAN | Park Strategies, LLC 5908 | 2009-01-09 | Park Strategies, LLC | 4201 Wisconsin Avenue, NW | Washington | DC | 20016 | |
16724 | 16724 | 2012-12-31 | Transitional National Council/The Libyan Interim National Council | 2011-04-06 | LIBYA | Harbour Group, LLC 5478 | 2002-03-04 | Harbour Group, LLC | 2201 Wyoming 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]) );