FARA_All_ForeignPrincipals
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 sorted by Registration_Number
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Address_2, Zip, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 17
- Bavarian Ministry for Economic Affairs, Infrastructure, Transport and Technology 1
- China-United States Exchange Foundation 1
- City of Heidelberg, Germany 1
- Commercial Procurement Office of Defense Cooperation, Netherlands 1
- Danish Meat Association (DMA) 1
- Dubai Civil Aviation Authority 1
- Federation of Industries of the State of Sao Paulo (FIESP) 1
- German Insurance Association (GDV) 1
- Government of Dubai 1
- Government of Georgia 1
- Government of Rwanda 1
- Korea Trade-Investment Promotion Agency 1
- Office of Commercial Affairs of the Royal Thai Embassy 1
- Peruvian Export and Tourism Promotion Board 1
- Republika Srpska 1
- Serbia Investment and Export Promotion Agency (SIEPA) through Rasky Baerlein Strategic Communications, Inc. 1
- Uruguay Ministry of Economy and Finance 1
Registrant_Name 15
- Akin, Gump, Strauss, Hauer & Feld, LLP 3
- BLJ Worldwide LTD 1
- Bavarian Ministry for Economic Affairs, Infrastructure, Transport and Technology 1
- Berry, Max N. 1
- Burson-Marsteller 1
- Cassidy & Associates, Inc. 1
- Chadwick, Kirsten A./Fierce, Isakowitz, & Blalock 1
- Development Counsellors International 1
- Gephardt Group Government Affairs, LLC 1
- Kreab Gavin Anderson (USA), Inc. 1
- O'Brien Gentry & Scott, LLC 1
- Passacantilli, Daniel 1
- Quinn Gillespie & Associates, LLC 1
- Squire Patton Boggs, LLP 1
- W2 Group, Inc. 1
Country/Location_Represented 13
- GERMANY 3
- SERBIA 2
- UNITED ARAB EMIRATES 2
- BRAZIL 1
- CHINA 1
- DENMARK 1
- GEORGIA 1
- KOREA, SOUTH 1
- NETHERLANDS 1
- PERU 1
- RWANDA 1
- THAILAND 1
- URUGUAY 1
City 9
- - 7
- Dubai 2
- Washington 2
- Belgrade 1
- Heidelberg 1
- Kigali 1
- Mincetur 1
- Sao Paulo 1
- Washington, DC 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
16677 | 16677 | 2010-12-31 | Danish Meat Association (DMA) | 1997-05-28 | DENMARK | Berry, Max N. 2216 | 1970-10-30 | Berry, Max N. | Bruxelles | ||||
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 | |||
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 | ||
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 | ||
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 | |||
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 |
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 | ||||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 |
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]) );