FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where "Foreign_Principal_Termination_Date" is on date 2011-06-30 sorted by City
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Zip, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 9
- Ali Taslimi (for Iraq Camp Ashraf prisoners) 1
- Federacion Nacional de Departamentos 1
- Hong Kong Tourism Board 1
- International Business Wales a/k/a Welsh Development Agency 1
- North West Development Agency, One Northeast, 1
- Partido Accion Nacional (PAN) 1
- Republic of Colombia 1
- Republic of Gabon 1
- United Mexican States (Mexico")" 1
Country/Location_Represented 7
- COLOMBIA 2
- MEXICO 2
- GABON 1
- GREAT BRITAIN 1
- HONG KONG 1
- IRAQ 1
- UNITED KINGDOM 1
Registrant_Name 5
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8699 | 8699 | 2011-06-30 | North West Development Agency, One Northeast, | 1986-06-16 | GREAT BRITAIN | North of England 3844 | 1986-06-16 | North of England | Manchester | ||||
8703 | 8703 | 2011-06-30 | United Mexican States (Mexico")" | 2011-02-15 | MEXICO | Reid Collins & Tsai LLP 5993 | 2010-06-24 | Reid Collins & Tsai LLP | |||||
8696 | 8696 | 2011-06-30 | Federacion Nacional de Departamentos | 2010-06-24 | COLOMBIA | Reid Collins & Tsai LLP 5993 | 2010-06-24 | Reid Collins & Tsai LLP | Carrera 7 N 32-33 Of 801 - 802 | Bogota | |||
8701 | 8701 | 2011-06-30 | Republic of Colombia | 2010-06-24 | COLOMBIA | Reid Collins & Tsai LLP 5993 | 2010-06-24 | Reid Collins & Tsai LLP | Carrera 8 #6-64 | Bogota | |||
8698 | 8698 | 2011-06-30 | International Business Wales a/k/a Welsh Development Agency | 2008-06-30 | UNITED KINGDOM | Spring O'Brien & Company, Inc. 5872 | 2008-06-30 | Spring O'Brien & Company, Inc. | Wales | Cardiff | |||
8695 | 8695 | 2011-06-30 | Ali Taslimi (for Iraq Camp Ashraf prisoners) | 2011-07-27 | IRAQ | BLJ Worldwide LTD 5875 | 2008-06-17 | BLJ Worldwide LTD | Soderstrasse 110 64280 | Darmstadt | |||
8700 | 8700 | 2011-06-30 | Partido Accion Nacional (PAN) | 2010-11-24 | MEXICO | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Av. Coyoacan No. 1546 - Col. Del Valle | Deleg. Benito | Juarez | ||
8697 | 8697 | 2011-06-30 | Hong Kong Tourism Board | 2008-06-30 | HONG KONG | Spring O'Brien & Company, Inc. 5872 | 2008-06-30 | Spring O'Brien & Company, Inc. | 10940 Wilshire Blvd. | Los Angeles | CA | 90024 | |
8702 | 8702 | 2011-06-30 | Republic of Gabon | 2011-07-14 | GABON | BLJ Worldwide LTD 5875 | 2008-06-17 | BLJ Worldwide LTD | 18 E 41st Street #9 | New York | NY | 10017-8380 |
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]) );