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 2006-04-30 sorted by City
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Address_2, Zip, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 10
- Bayelsa State Government, Federal Republic of Nigeria through Africana Consultants, LLC 1
- Cross Rivers State Government, Federal Republic of Nigeria through Africana Consultants, LLC 1
- Demetrio Sodi 1
- Elettronica Veneta & IN.El., S.p.A. 1
- Embassy of El Salvador 1
- Herty Alianza 2006 1
- Hong Kong Tourism Board 1
- Nigerian Investment Promotion Commission 1
- UK Trade & Investment 1
- Vuk Jeremic 1
Country/Location_Represented 8
- NIGERIA 3
- EL SALVADOR 1
- GREAT BRITAIN 1
- HONG KONG 1
- ITALY 1
- MEXICO 1
- NICARAGUA 1
- SERBIA 1
Registrant_Name 7
City 4
- - 7
- Abuja 1
- Managua 1
- Washington 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6022 | 6022 | 2006-04-30 | Bayelsa State Government, Federal Republic of Nigeria through Africana Consultants, LLC | 2005-10-26 | NIGERIA | Saint-Louis & Johnson, P.C. 5717 | 2005-10-26 | Saint-Louis & Johnson, P.C. | Secretariat Complex PMB 09 | Yenagoa, Bayelsa State | |||
6023 | 6023 | 2006-04-30 | Cross Rivers State Government, Federal Republic of Nigeria through Africana Consultants, LLC | 2005-10-26 | NIGERIA | Saint-Louis & Johnson, P.C. 5717 | 2005-10-26 | Saint-Louis & Johnson, P.C. | Governor's Office Podium Block (2nd Floor), State Secretariat Complex | PMB 5098 Port Harcourt | |||
6024 | 6024 | 2006-04-30 | Demetrio Sodi | 2005-10-20 | MEXICO | Zemi Communications, LLC 5714 | 2005-10-20 | Zemi Communications, LLC | Jose Maria Ibarraran, No. 71 | Col. San Jose Insurgentes, CP 03900 Mexico, D.F, | |||
6025 | 6025 | 2006-04-30 | Elettronica Veneta & IN.El., S.p.A. | 1999-08-06 | ITALY | Gibbons & Company, Inc. 4367 | 1990-04-18 | Gibbons & Company, Inc. | Via Postumia, 16 31045 Motta di Livenza (Treviso) | ||||
6028 | 6028 | 2006-04-30 | Hong Kong Tourism Board | 2002-10-30 | HONG KONG | Development Counsellors International 4777 | 1993-03-12 | Development Counsellors International | 10940 Wilshire Boulevard Suite 2050 L.A 90024-3915 | CA | |||
6030 | 6030 | 2006-04-30 | UK Trade & Investment | 2005-04-29 | GREAT BRITAIN | Development Counsellors International 4777 | 1993-03-12 | Development Counsellors International | Kingsgate House 66-74 Victoria Street London S101E 6SW | ||||
6031 | 6031 | 2006-04-30 | Vuk Jeremic | 2003-10-08 | SERBIA | Rabin, Sheves, Lipkin-Shahak & Birger, LLC 5524 | 2002-10-15 | Rabin, Sheves, Lipkin-Shahak & Birger, LLC | 5 Bircaninova Street 11000 Belgrade | ||||
6029 | 6029 | 2006-04-30 | Nigerian Investment Promotion Commission | 2005-10-19 | NIGERIA | Business Council for International Understanding, Inc. (BCIU) 5713 | 2005-10-19 | Business Council for International Understanding, Inc. (BCIU) | Plot 1181, Aguiyi Ironsi St. | Maitama District, P.M.B. 381 Garki | Abuja | ||
6027 | 6027 | 2006-04-30 | Herty Alianza 2006 | 2006-04-06 | NICARAGUA | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | Primavera entrada Las Colinas | Pollos Tip Top 80 Varas Abajo, Casa #6 | Managua | ||
6026 | 6026 | 2006-04-30 | Embassy of El Salvador | 2006-04-06 | EL SALVADOR | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | 2308 California Street, NW | Washington | DC | 20008 |
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]) );