FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
7 rows where Foreign_Principal_Termination_Date = "2011-02-28"
This data as json, CSV (advanced)
Suggested facets: Zip, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 7
Foreign_Principal 7
- Brunei Investment Agency 1
- Council for Leather Exports (CLE) 1
- Defense Procurement Office, United Kingdom 1
- Egyptian Press and Information Office, Embassy 1
- Government of the Republic of Trinidad & Tobago 1
- International Counsel Bureau 1
- Taipei Economic & Cultural Representative Office in the U.S. (TECRO) 1
Country/Location_Represented 7
- BRUNEI 1
- EGYPT 1
- INDIA 1
- KUWAIT 1
- TAIWAN 1
- TRINIDAD AND TOBAGO 1
- UNITED KINGDOM 1
City 6
- - 2
- Egmore, Chennai 1
- Jalan Kebangsaan 1
- Safat 1
- Washington 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3091 | 3091 | 2011-02-28 | Brunei Investment Agency | 2010-11-17 | BRUNEI | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | Ministry of Finance Building, 11th Floor | Commonwealth Drive | Jalan Kebangsaan | ||
3092 | 3092 | 2011-02-28 | Council for Leather Exports (CLE) | 2010-04-14 | INDIA | Global Footwear Partnerships, LLC 5984 | 2010-04-14 | Global Footwear Partnerships, LLC | CMDA Tower - 11, 3rd Floor, Gandhi - Irwin Bridge Road | Egmore, Chennai | |||
3093 | 3093 | 2011-02-28 | Defense Procurement Office, United Kingdom | 2010-01-11 | UNITED KINGDOM | O'Brien Gentry & Scott, LLC 5971 | 2010-01-11 | O'Brien Gentry & Scott, LLC | 3100 Massachusetts Avenue, NW | Washington, DC | |||
3094 | 3094 | 2011-02-28 | Egyptian Press and Information Office, Embassy | 2009-04-27 | EGYPT | CLS Strategies 5774 | 2006-10-06 | CLS Strategies | 1666 Connecticut Avenue, NW | Suite 440 | Washington | DC | 20009 |
3095 | 3095 | 2011-02-28 | Government of the Republic of Trinidad & Tobago | 2004-02-13 | TRINIDAD AND TOBAGO | AGA Group, LLC 5600 | 2004-02-13 | AGA Group, LLC | Port-of-Prince | ||||
3096 | 3096 | 2011-02-28 | International Counsel Bureau | 2010-08-27 | KUWAIT | Madison Group, LLC 5997 | 2010-08-27 | Madison Group, LLC | Dasman Commercial Complex | P.O. Box 20941 - Block No. 3 - 8th Floor, Al-Sharq | Safat | ||
3097 | 3097 | 2011-02-28 | Taipei Economic & Cultural Representative Office in the U.S. (TECRO) | 2001-12-17 | TAIWAN | McGuireWoods Consulting, LLC 5408 | 2001-02-05 | McGuireWoods Consulting, LLC | 4201 Wisconsin Avenue, N.W. 20016 | DC |
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]) );