FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
22 rows where "Foreign_Principal_Termination_Date" is on date 2008-12-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Address_2, Zip, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 22
- Danish Patent and Trademark Office 1
- Embassy of Japan 1
- Embassy of the Republic of Korea 1
- Embassy of the Republic of Peru 1
- Federation of the Industries of the State of Sao Paulo 1
- Government of Georgia, National Security Council 1
- Government of Southern Sudan 1
- Government of Vanuatu 1
- Government of the Republic of Palau (Compact Review Commission) 1
- Government of the Republic of Trinidad and Tobago (via Ainsley Gill Associates, LLC) 1
- Instituto Espanol De Comercio Exterior 1
- Korea International Trade Association 1
- Ministry of Foreign Relations Republic of Panama 1
- Ministry of Industry and Trade of the Government of Vietnam 1
- Paul Calder LeRoux 1
- Republic of Palau, Embassy 1
- Ricardo, UK 1
- Royal Hashemite Court 1
- Russian Federation through the Washington Group 1
- Small Business Corporation (SBC) (f/k/a SMIPC) 1
- Tourism Promotion Corporation of Chile 1
- Yoro K. Fall 1
Registrant_Name 19
- Dickens & Madson Canada, Inc. 3
- Fierce, Isakowitz & Blalock 2
- ACG, LLC 1
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- Development Counsellors International 1
- G2 Worldwide, Inc. 1
- Hyde Park Communications, Inc. 1
- Integrated Solutions Group, LLC 1
- Ogilvy Public Relations Worldwide 1
- Orion Strategies LLC 1
- Parvin, C. Landon 1
- Powell Goldstein, LLP 1
- Rivers, Stephen M. 1
- Sidley Austin LLP 1
- Small Business Corporation (f/k/a Small & Medium Industry Promotion Corporation "SMIPC") 1
- Squire Patton Boggs, LLP 1
- Tramposch, Albert 1
- U.S. - Southern Sudan Development Company 1
- Van Scoyoc Associates, Inc. 1
Country/Location_Represented 19
- KOREA, SOUTH 3
- PALAU 2
- BRAZIL 1
- CHILE 1
- DENMARK 1
- GEORGIA 1
- GREAT BRITAIN 1
- INTERNATIONAL 1
- JAPAN 1
- JORDAN 1
- PANAMA 1
- PERU 1
- RUSSIA 1
- SENEGAL 1
- SPAIN 1
- SUDAN 1
- TRINIDAD AND TOBAGO 1
- VANUATU 1
- VIETNAM 1
City 14
- - 7
- Washington 3
- Amman 1
- Dakar-Fann 1
- Hanoi 1
- Juba 1
- Koror 1
- Makati City 1
- Moscow 1
- Port Vila 1
- Port-of-Spain 1
- Sao Paulo, SP 1
- Seoul 1
- West Sussex 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16629 | 16629 | 2008-12-31 | Danish Patent and Trademark Office | 2006-12-07 | DENMARK | Tramposch, Albert 5779 | 2006-12-07 | Tramposch, Albert | Helgeshoj Alle 81, 2630 Taastrup | ||||
16630 | 16630 | 2008-12-31 | Embassy of Japan | 2003-04-08 | JAPAN | Parvin, C. Landon 5551 | 2003-04-08 | Parvin, C. Landon | 2520 Massachusetts Avenue, N.W. 20008 | DC | |||
16634 | 16634 | 2008-12-31 | Government of Georgia, National Security Council | 2008-06-11 | GEORGIA | Orion Strategies LLC 5437 | 2001-05-30 | Orion Strategies LLC | Ingorokva St. 7 Tbilisi, 0134 | ||||
16639 | 16639 | 2008-12-31 | Instituto Espanol De Comercio Exterior | 2005-02-01 | SPAIN | G2 Worldwide, Inc. 5667 | 2005-02-01 | G2 Worldwide, Inc. | 405 Lexington Avenue 44th Floor New York | NY | |||
16641 | 16641 | 2008-12-31 | Ministry of Foreign Relations Republic of Panama | 2005-03-25 | PANAMA | ACG, LLC 5677 | 2005-03-25 | ACG, LLC | Casco Antiguo | ||||
16648 | 16648 | 2008-12-31 | Small Business Corporation (SBC) (f/k/a SMIPC) | 2002-03-15 | KOREA, SOUTH | Small Business Corporation (f/k/a Small & Medium Industry Promotion Corporation "SMIPC") 5486 | 2002-03-15 | Small Business Corporation (f/k/a Small & Medium Industry Promotion Corporation "SMIPC") | 24-3, Yoido-dong, Yonglungpu-gu, Seoul 150-1718 | ||||
16649 | 16649 | 2008-12-31 | Tourism Promotion Corporation of Chile | 2006-11-02 | CHILE | Development Counsellors International 4777 | 1993-03-12 | Development Counsellors International | |||||
16646 | 16646 | 2008-12-31 | Royal Hashemite Court | 2007-04-16 | JORDAN | Rivers, Stephen M. 5800 | 2007-04-16 | Rivers, Stephen M. | Amman | ||||
16650 | 16650 | 2008-12-31 | Yoro K. Fall | 2007-01-10 | SENEGAL | Dickens & Madson Canada, Inc. 5784 | 2007-01-10 | Dickens & Madson Canada, Inc. | Villa 35, Mamelles Universite | Quakam/Dakar, Senegal | Dakar-Fann | ||
16642 | 16642 | 2008-12-31 | Ministry of Industry and Trade of the Government of Vietnam | 2007-12-20 | VIETNAM | Sidley Austin LLP 3731 | 1985-09-13 | Sidley Austin LLP | 54 Hai Ba Trung Street | Hanoi | |||
16635 | 16635 | 2008-12-31 | Government of Southern Sudan | 2010-09-23 | SUDAN | U.S. - Southern Sudan Development Company 6002 | 2010-09-23 | U.S. - Southern Sudan Development Company | Juba | ||||
16637 | 16637 | 2008-12-31 | Government of the Republic of Palau (Compact Review Commission) | 2007-02-27 | PALAU | Powell Goldstein, LLP 5796 | 2007-02-27 | Powell Goldstein, LLP | Koror | ||||
16643 | 16643 | 2008-12-31 | Paul Calder LeRoux | 2007-04-09 | INTERNATIONAL | Dickens & Madson Canada, Inc. 5784 | 2007-01-10 | Dickens & Madson Canada, Inc. | 2137 Dasmarinas Village | Makati City | |||
16647 | 16647 | 2008-12-31 | Russian Federation through the Washington Group | 2008-02-27 | RUSSIA | Integrated Solutions Group, LLC 5855 | 2008-02-27 | Integrated Solutions Group, LLC | 4 Staraya Square | Moscow | |||
16636 | 16636 | 2008-12-31 | Government of Vanuatu | 2007-12-13 | VANUATU | Dickens & Madson Canada, Inc. 5784 | 2007-01-10 | Dickens & Madson Canada, Inc. | c/o J.L. Tasone, Assistant Minister of Lands | Port Vila | |||
16638 | 16638 | 2008-12-31 | Government of the Republic of Trinidad and Tobago (via Ainsley Gill Associates, LLC) | 2008-07-01 | TRINIDAD AND TOBAGO | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | Ministry of Finance - International Financial Center | Independence Square | Port-of-Spain | ||
16633 | 16633 | 2008-12-31 | Federation of the Industries of the State of Sao Paulo | 2008-08-01 | BRAZIL | Fierce, Isakowitz & Blalock 5654 | 2004-10-29 | Fierce, Isakowitz & Blalock | Av. Paulista, 1313-4th Fl. | 0311-923 | Sao Paulo, SP | ||
16640 | 16640 | 2008-12-31 | Korea International Trade Association | 2006-10-16 | KOREA, SOUTH | Fierce, Isakowitz & Blalock 5654 | 2004-10-29 | Fierce, Isakowitz & Blalock | KITA, Attn: Team Leader (America's Team) | Trade Tower, World Trade Center 159-1 Samsung-dong, Kangnam-gu | Seoul | ||
16631 | 16631 | 2008-12-31 | Embassy of the Republic of Korea | 2007-06-18 | KOREA, SOUTH | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | |
16632 | 16632 | 2008-12-31 | Embassy of the Republic of Peru | 2007-02-27 | PERU | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 1700 Massachusetts Avenue, NW | Washington | DC | 20036 | |
16644 | 16644 | 2008-12-31 | Republic of Palau, Embassy | 2008-02-22 | PALAU | Hyde Park Communications, Inc. 5854 | 2008-02-22 | Hyde Park Communications, Inc. | 1700 Pennsylvania Avenue, NW | Suite 400 | Washington | DC | 20006 |
16645 | 16645 | 2008-12-31 | Ricardo, UK | 2006-07-28 | GREAT BRITAIN | Van Scoyoc Associates, Inc. 5401 | 2000-12-14 | Van Scoyoc Associates, Inc. | Shoreham Technical Centre | Shoreham-by-Sea | West Sussex |
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]) );