FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where "Foreign_Principal_Termination_Date" is on date 2009-06-30 sorted by City
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Address_1, Address_2, Zip, Registrant_Date (date)
Foreign_Principal 13
- Embassy of Panama 1
- Embassy of the United Arab Emirates 1
- Government of Romania 1
- Japan Airport Consultant, Inc. 1
- Kingdom of Morocco, Embassy 1
- Moroccan National Tourist Office 1
- National Development Corporation 1
- Pacific Consultants Co., Ltd 1
- Republic of Panama, Embassy 1
- Republic of Panama, Embassy through the Washington Group 1
- Taipei Economic & Cultural Representative Office in the U.S. 1
- Taipei Economic and Cultural Representative Office (TECRO) 1
- Tourism New Zealand 1
Registrant_Name 11
- Spectrum Group Members, LLC 2
- Spring O'Brien & Company, Inc. 2
- Avatar Enterprises, Inc. 1
- Clark & Weinstock 1
- Global USA, Inc. 1
- Harbour Group, LLC 1
- Integrated Solutions Group, LLC 1
- Parven Pomper Strategies, Inc. 1
- Pepperwood International Corp. 1
- St. Lucia National Development Corporation 1
- Williams Mullen Strategies, Inc. 1
Country/Location_Represented 8
- PANAMA 3
- JAPAN 2
- MOROCCO 2
- TAIWAN 2
- NEW ZEALAND 1
- ROMANIA 1
- SAINT LUCIA 1
- UNITED ARAB EMIRATES 1
City 5
- - 5
- Washington 5
- Bucharest 1
- New York 1
- Santa Monica 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8677 | 8677 | 2009-06-30 | Embassy of the United Arab Emirates | 2007-01-22 | UNITED ARAB EMIRATES | Harbour Group, LLC 5478 | 2002-03-04 | Harbour Group, LLC | P.O. Box 4442 Abu Dhabi | ||||
8679 | 8679 | 2009-06-30 | Japan Airport Consultant, Inc. | 2009-12-04 | JAPAN | Spectrum Group Members, LLC 5894 | 2008-12-01 | Spectrum Group Members, LLC | 5-33-10, Hongo, Bunkyo-ku | ||||
8682 | 8682 | 2009-06-30 | National Development Corporation | 1977-06-24 | SAINT LUCIA | St. Lucia National Development Corporation 2796 | 1977-06-24 | St. Lucia National Development Corporation | |||||
8683 | 8683 | 2009-06-30 | Pacific Consultants Co., Ltd | 2009-12-04 | JAPAN | Spectrum Group Members, LLC 5894 | 2008-12-01 | Spectrum Group Members, LLC | 7-5, Sekido 1-chome, Tamashi, Tokyo 206-8550 | ||||
8687 | 8687 | 2009-06-30 | Taipei Economic and Cultural Representative Office (TECRO) | 1998-12-16 | TAIWAN | Global USA, Inc. 5292 | 1998-12-16 | Global USA, Inc. | 4201 Wisconsin Avenue, N.W. | DC | |||
8678 | 8678 | 2009-06-30 | Government of Romania | 2005-07-21 | ROMANIA | Williams Mullen Strategies, Inc. 5698 | 2005-07-21 | Williams Mullen Strategies, Inc. | Office of the Prime Minister Piata Victoriei, No. 1 | Sector 1 | Bucharest | ||
8681 | 8681 | 2009-06-30 | Moroccan National Tourist Office | 2008-06-30 | MOROCCO | Spring O'Brien & Company, Inc. 5872 | 2008-06-30 | Spring O'Brien & Company, Inc. | 160 West 40th Street | New York | NY | 10018 | |
8688 | 8688 | 2009-06-30 | Tourism New Zealand | 2008-06-30 | NEW ZEALAND | Spring O'Brien & Company, Inc. 5872 | 2008-06-30 | Spring O'Brien & Company, Inc. | 501 Santa Monica Blvd. | Santa Monica | CA | 90401 | |
8676 | 8676 | 2009-06-30 | Embassy of Panama | 2007-03-22 | PANAMA | Parven Pomper Strategies, Inc. 5781 | 2006-12-19 | Parven Pomper Strategies, Inc. | 2862 McGill Terrace, NW | Washington | DC | 20008 | |
8680 | 8680 | 2009-06-30 | Kingdom of Morocco, Embassy | 2007-07-27 | MOROCCO | Avatar Enterprises, Inc. 5821 | 2007-07-27 | Avatar Enterprises, Inc. | Embassy of the Kingdom of Morocco | 1601 21st Street, NW | Washington | DC | 20009 |
8684 | 8684 | 2009-06-30 | Republic of Panama, Embassy through the Washington Group | 2008-02-27 | PANAMA | Integrated Solutions Group, LLC 5855 | 2008-02-27 | Integrated Solutions Group, LLC | 2862 McGill Terrace, NW | Washington | DC | 20008 | |
8685 | 8685 | 2009-06-30 | Republic of Panama, Embassy | 2009-02-17 | PANAMA | Clark & Weinstock 5914 | 2009-03-06 | Clark & Weinstock | 2862 McGill Terrace, NW | Washington | DC | 20008 | |
8686 | 8686 | 2009-06-30 | Taipei Economic & Cultural Representative Office in the U.S. | 2009-02-27 | TAIWAN | Pepperwood International Corp. 5912 | 2009-02-27 | Pepperwood International Corp. | 4201 Wisconsin Avenue, NW | Washington | DC | 20016-2937 |
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]) );