FARA_All_ForeignPrincipals

Table actions
List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

17 rows where "Foreign_Principal_Termination_Date" is on date 2010-12-31

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Registration_Number, Registrant_Date, Address_1, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

Country/Location_Represented 13

State 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
16673 16673 2010-12-31 Bavarian Ministry for Economic Affairs, Infrastructure, Transport and Technology 2004-09-29 GERMANY Bavarian Ministry for Economic Affairs, Infrastructure, Transport and Technology 5647 2004-09-29 Bavarian Ministry for Economic Affairs, Infrastructure, Transport and Technology Prinzregenten Strasse 28 80538 Muenchen        
16674 16674 2010-12-31 China-United States Exchange Foundation 2010-08-03 CHINA BLJ Worldwide LTD 5875 2008-06-17 BLJ Worldwide LTD 15/F shun Ho Tower 24-30 Ice House Street, Central      
16675 16675 2010-12-31 City of Heidelberg, Germany 2009-10-27 GERMANY Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Rathaus/Town Hall/Mairie Postfach 10 55 20, D-69045 Heidelberg    
16676 16676 2010-12-31 Commercial Procurement Office of Defense Cooperation, Netherlands 2010-01-11 NETHERLANDS O'Brien Gentry & Scott, LLC 5971 2010-01-11 O'Brien Gentry & Scott, LLC 4200 Linnean Avenue, NW   Washington, DC    
16677 16677 2010-12-31 Danish Meat Association (DMA) 1997-05-28 DENMARK Berry, Max N. 2216 1970-10-30 Berry, Max N. Bruxelles        
16678 16678 2010-12-31 Dubai Civil Aviation Authority 2010-01-05 UNITED ARAB EMIRATES Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP The Government of Dubai Legal Affairs Department Board P.O. Box 446 Dubai    
16679 16679 2010-12-31 Federation of Industries of the State of Sao Paulo (FIESP) 2009-09-08 BRAZIL Chadwick, Kirsten A./Fierce, Isakowitz, & Blalock 5950 2009-09-08 Chadwick, Kirsten A./Fierce, Isakowitz, & Blalock Av. Paulista, 1313-4th Fl. 0311-023 Sao Paulo    
16680 16680 2010-12-31 German Insurance Association (GDV) 2010-06-28 GERMANY Kreab Gavin Anderson (USA), Inc.  5824 2007-08-09 Kreab Gavin Anderson (USA), Inc. WilhelmstraBe 43 G Berlin 10117      
16681 16681 2010-12-31 Government of Dubai 2010-01-05 UNITED ARAB EMIRATES Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP The Government of Dubai Legal Affairs Department Board P.O. Box 446 Dubai    
16682 16682 2010-12-31 Government of Georgia 2010-01-22 GEORGIA Gephardt Group Government Affairs, LLC 5874 2008-07-21 Gephardt Group Government Affairs, LLC Ingorokva St. 7 Tiblisi, 0134      
16683 16683 2010-12-31 Government of Rwanda 2011-08-12 RWANDA W2 Group, Inc. 6055 2011-08-12 W2 Group, Inc. Ministry of Foreign Affairs and Cooperation Boulevard de la Revolution Place de I'Independence Kigali    
16684 16684 2010-12-31 Korea Trade-Investment Promotion Agency 2010-01-15 KOREA, SOUTH Cassidy & Associates, Inc. 5643 2004-09-10 Cassidy & Associates, Inc. 1225 Eye Street, NW Suite 920 Washington DC 20005
16685 16685 2010-12-31 Office of Commercial Affairs of the Royal Thai Embassy 2010-03-31 THAILAND Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 1024 Wisconsin Avenue, NW   Washington DC 20007
16686 16686 2010-12-31 Peruvian Export and Tourism Promotion Board 2008-10-31 PERU Development Counsellors International 4777 1993-03-12 Development Counsellors International Calle 1 Oeste N 50, piso 13 Edificio   Mincetur    
16687 16687 2010-12-31 Republika Srpska 2007-03-22 SERBIA Quinn Gillespie & Associates, LLC 5753 2006-06-01 Quinn Gillespie & Associates, LLC Vlada Republika Srpska Vuka Karadzica 4 78000 Banjaluka BIH        
16688 16688 2010-12-31 Serbia Investment and Export Promotion Agency (SIEPA) through Rasky Baerlein Strategic Communications, Inc. 2008-12-04 SERBIA Passacantilli, Daniel 5897 2008-12-04 Passacantilli, Daniel Vlajkoviceva 3/V 1100   Belgrade    
16689 16689 2010-12-31 Uruguay Ministry of Economy and Finance 2011-09-07 URUGUAY Burson-Marsteller 2469 1973-10-23 Burson-Marsteller Colonia 1206 Montevideo, Republica Oriental del Uruguay      

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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])
);