FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where "Foreign_Principal_Termination_Date" is on date 2013-06-30 sorted by City
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 10
Foreign_Principal 10
- Central Bank of Somalia 1
- Government of the Republika Srpska 1
- Island Territory of St. Maarten 1
- Mexico Ministry of Tourism 1
- Ministry of Justice of Ukraine ( MOJ")" 1
- Pakistan Tehreek-e-Insaf 1
- Republic of Kenya 1
- Serial Enterprises Limited 1
- Shafallah Center for Children with Special Needs 1
- Tiangang Sung 1
Country/Location_Represented 9
- HONG KONG 2
- BOSNIA & HERZEGOVINA 1
- KENYA 1
- MEXICO 1
- PAKISTAN 1
- QATAR 1
- SOMALI DEMOCRATIC REPUBLIC 1
- ST. MARTIN 1
- UKRAINE 1
City 5
- - 6
- Banja Luka 1
- Doha 1
- Islam-Abad 1
- Nairobi 1
State 1
- - 10
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8709 | 8709 | 2013-06-30 | Central Bank of Somalia | 2013-04-04 | SOMALI DEMOCRATIC REPUBLIC | Moffett Group, LLC 5802 | 2007-04-17 | Moffett Group, LLC | P.O. Box 11 55 Corso Somalia | Mogadishu | |||
8711 | 8711 | 2013-06-30 | Island Territory of St. Maarten | 1998-12-21 | ST. MARTIN | St. Maarten Tourist Office 5294 | 1998-12-21 | St. Maarten Tourist Office | Philipsburg | ||||
8712 | 8712 | 2013-06-30 | Mexico Ministry of Tourism | 2011-10-17 | MEXICO | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | Viaducto M. Aleman 105, Piso 6 | COL. Escandon Miguel Hidalgo 11800 Mexico, D.F. | |||
8713 | 8713 | 2013-06-30 | Ministry of Justice of Ukraine ( MOJ")" | 2019-01-18 | UKRAINE | Skadden, Arps, Slate, Meagher & Flom 6617 | 2019-01-18 | Skadden, Arps, Slate, Meagher & Flom | |||||
8716 | 8716 | 2013-06-30 | Serial Enterprises Limited | 2013-03-07 | HONG KONG | 42West, LLC 6156 | 2013-03-07 | 42West, LLC | 12/Floor, No. 3 Lockhart Road | Wanchai | |||
8718 | 8718 | 2013-06-30 | Tiangang Sung | 2012-12-24 | HONG KONG | Peter O'Toole, LLC 6147 | 2012-12-24 | Peter O'Toole, LLC | Suite 5304 on 53/F Central Plaza | 18 Harbour Road Wanchai | |||
8710 | 8710 | 2013-06-30 | Government of the Republika Srpska | 2012-02-29 | BOSNIA & HERZEGOVINA | Innovative Global Initiatives and Solutions, LLC 6093 | 2012-02-29 | Innovative Global Initiatives and Solutions, LLC | 78000 Trg | Banja Luka | |||
8717 | 8717 | 2013-06-30 | Shafallah Center for Children with Special Needs | 2010-08-03 | QATAR | BLJ Worldwide LTD 5875 | 2008-06-17 | BLJ Worldwide LTD | P.O. Box 4251 | Doha | |||
8714 | 8714 | 2013-06-30 | Pakistan Tehreek-e-Insaf | 2010-02-25 | PAKISTAN | PTI USA, LLC 5975 | 2010-02-25 | PTI USA, LLC | St. #84 Secotr G-6/4, | Islam-Abad | |||
8715 | 8715 | 2013-06-30 | Republic of Kenya | 2009-07-01 | KENYA | CLS Strategies 5774 | 2006-10-06 | CLS Strategies | Office of the President | P.O. Box 62345-00200 | Nairobi |
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]) );