FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
6 rows where "Foreign_Principal_Termination_Date" is on date 2012-11-30 sorted by City
This data as json, CSV (advanced)
Suggested facets: Zip, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 6
Foreign_Principal 6
- City of Osaka Municipal Government 1
- Information Affairs Authority, Kingdom of Bahrain via Joe Trippi and Associates 1
- Moroccan American Center for Policy 1
- Sheikh Khalid Bin Saqr Al Qasimi, Crown Prince and Deputy Ruler, Ras Al Khaimah, United Arab Emirates 1
- Taipei Economic and Cultural Representative Office 1
- Tilda, Ltd. (Tilda Rice) 1
Country/Location_Represented 6
- BAHRAIN 1
- GREAT BRITAIN 1
- JAPAN 1
- MOROCCO 1
- TAIWAN 1
- UNITED ARAB EMIRATES 1
City 4
- - 2
- Washington 2
- Isa Town 1
- Osaka 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14545 | 14545 | 2012-11-30 | Sheikh Khalid Bin Saqr Al Qasimi, Crown Prince and Deputy Ruler, Ras Al Khaimah, United Arab Emirates | 2010-05-28 | UNITED ARAB EMIRATES | Venable, LLP 5931 | 2009-04-17 | Venable, LLP | |||||
14547 | 14547 | 2012-11-30 | Tilda, Ltd. (Tilda Rice) | 1997-05-30 | GREAT BRITAIN | O'Mara, Charles J. 5181 | 1997-05-30 | O'Mara, Charles J. | Rainham Essex | ||||
14543 | 14543 | 2012-11-30 | Information Affairs Authority, Kingdom of Bahrain via Joe Trippi and Associates | 2011-08-23 | BAHRAIN | Sanitas International, LLC 5963 | 2009-11-18 | Sanitas International, LLC | P.O. Box 253 | Isa Town | |||
14542 | 14542 | 2012-11-30 | City of Osaka Municipal Government | 2010-03-12 | JAPAN | City of Osaka, Chicago Office 5979 | 2010-03-12 | City of Osaka, Chicago Office | City Hall | 1-3-20 Nakanoshima, Kita-ku | Osaka | ||
14544 | 14544 | 2012-11-30 | Moroccan American Center for Policy | 2009-12-02 | MOROCCO | Moffett Group, LLC 5802 | 2007-04-17 | Moffett Group, LLC | 1220 L Street, NW | Suite 411 | Washington | DC | 20005 |
14546 | 14546 | 2012-11-30 | Taipei Economic and Cultural Representative Office | 2010-12-13 | TAIWAN | Capitol Hill Strategies, LLC 6009 | 2010-12-13 | Capitol Hill Strategies, LLC | 4201 Wisconsin Avenue, NW | Washington | DC | 20016 |
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]) );