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 2009-08-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Address_2, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 9
- Bloc - Yulia Tymoshenko (BYuT) 1
- El Al Israel Airlines 1
- Embassy of Venezuela 1
- Federal Republic of Nigeria 1
- Fundacion Siglo XXI 1
- Kingdom of Saudi Arabia Ministry of Commerce and Industry 1
- Movimiento Poder Ciudadano, Siglo 21 1
- Office of the UAE Pavilion for the Venice Biennale 1
- Taipei Economic & Cultural Representative Office, Republic of China 1
Country/Location_Represented 9
- BOLIVIA 1
- COLOMBIA 1
- ISRAEL 1
- NIGERIA 1
- SAUDI ARABIA 1
- TAIWAN 1
- UKRAINE 1
- UNITED ARAB EMIRATES 1
- VENEZUELA 1
Registrant_Name 6
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11125 | 11125 | 2009-08-31 | Bloc - Yulia Tymoshenko (BYuT) | 2006-11-07 | UKRAINE | TD International, LLC 5775 | 2006-11-07 | TD International, LLC | P.O. Box 81, Kyiv, 01133 | ||||
11127 | 11127 | 2009-08-31 | Embassy of Venezuela | 2004-02-27 | VENEZUELA | Latin America Information Office LLC 5609 | 2004-02-27 | Latin America Information Office LLC | 1099 30th Street, N.W. 20007 | DC | |||
11128 | 11128 | 2009-08-31 | Federal Republic of Nigeria | 2007-09-21 | NIGERIA | Watts Partners (J.C. Watts Companies) 5641 | 2004-08-27 | Watts Partners (J.C. Watts Companies) | Maputo Street, Wuse Zone 3, P.M.N. 130 | Garki, Abuja | |||
11130 | 11130 | 2009-08-31 | Kingdom of Saudi Arabia Ministry of Commerce and Industry | 2009-04-03 | SAUDI ARABIA | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | Riyadh, 11162 | ||||
11133 | 11133 | 2009-08-31 | Taipei Economic & Cultural Representative Office, Republic of China | 1997-08-14 | TAIWAN | Asia Associates, Inc. 5201 | 1997-08-15 | Asia Associates, Inc. | Washington | DC | |||
11131 | 11131 | 2009-08-31 | Movimiento Poder Ciudadano, Siglo 21 | 2009-05-27 | COLOMBIA | Latin America Information Office LLC 5609 | 2004-02-27 | Latin America Information Office LLC | Calle 25 No. 6-91 piso 13 | Bogota | |||
11132 | 11132 | 2009-08-31 | Office of the UAE Pavilion for the Venice Biennale | 2009-05-05 | UNITED ARAB EMIRATES | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | P.O. Box 60478 | Dubai | |||
11129 | 11129 | 2009-08-31 | Fundacion Siglo XXI | 2008-12-17 | BOLIVIA | Latin America Information Office LLC 5609 | 2004-02-27 | Latin America Information Office LLC | Edificio Araceli, Piso 1 Departamento E, Zona Calacoto, | La Paz | |||
11126 | 11126 | 2009-08-31 | El Al Israel Airlines | 2006-05-03 | ISRAEL | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 15 East 26th Street | New York | NY | 10010 |
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]) );