Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Address_2, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal
Country/Location_Represented
City
Registrant_Name
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 57 | 57 | Barcelona Turisme Convention Bureau | 2017-04-25 | SPAIN | 4777 4777 | 1993-03-12 | Development Counsellors International | Passatge de la Concepcio, 7-9 | 08008 Barcelona | ||||
| 473 | 473 | Netherlands Foreign Investment Agency | 2015-04-30 | NETHERLANDS | 4777 4777 | 1993-03-12 | Development Counsellors International | Prinses Beatrixlaan 2 2595 AL The Hague | |||||
| 512 | 512 | PromPeru | 2013-07-03 | PERU | 4777 4777 | 1993-03-12 | Development Counsellors International | Ave. Republica de Panama No 3655 | San Isidro, Lima 27 | ||||
| 577 | 577 | Scottish Development International | 2012-05-01 | UNITED KINGDOM | 4777 4777 | 1993-03-12 | Development Counsellors International | 150 Broomielaw 5 Atlantic Quay | Glasgow, Scotland G2 8LU | ||||
| 1528 | 1528 | 1999-01-30 | Swedish Travel & Tourism Council | 1993-12-17 | SWEDEN | 4777 4777 | 1993-03-12 | Development Counsellors International | New York | NY | |||
| 2217 | 2217 | 2014-02-10 | APEV Romania | 2011-05-10 | ROMANIA | 4777 4777 | 1993-03-12 | Development Counsellors International | |||||
| 2865 | 2865 | 2000-02-28 | Government of Western Australia | 1999-11-18 | AUSTRALIA | 4777 4777 | 1993-03-12 | Development Counsellors International | Box 7234 | ||||
| 2939 | 2939 | 2014-02-28 | Tourism & Events Queensland | 2013-10-31 | AUSTRALIA | 4777 4777 | 1993-03-12 | Development Counsellors International | Level 10, 30 Markerston Street | Brisbane | Queensland 4000 | ||
| 4359 | 4359 | 2000-03-31 | Scottish Tourist Board | 1999-01-08 | SCOTLAND | 4777 4777 | 1993-03-12 | Development Counsellors International | Edinburgh | ||||
| 4498 | 4498 | 2012-03-31 | Proexport Colombia | 2009-10-29 | COLOMBIA | 4777 4777 | 1993-03-12 | Development Counsellors International | Calle 28A No 13A-15 Piso 35 | Bogota | |||
| 4512 | 4512 | 2014-03-31 | Ecuador Ministry of Tourism | 2013-07-02 | ECUADOR | 4777 4777 | 1993-03-12 | Development Counsellors International | |||||
| 4696 | 4696 | 2010-04-01 | Investment Promotion Agency of Spain - INTERES | 2006-11-02 | SPAIN | 4777 4777 | 1993-03-12 | Development Counsellors International | |||||
| 4713 | 4713 | 2019-04-01 | Turismo Chile | 2014-10-30 | CHILE | 4777 4777 | 1993-03-12 | Development Counsellors International | Av. Providencia 2088, Oficinia 20 Santiago | ||||
| 5022 | 5022 | 1999-04-15 | Investissement- Quebec | 1999-11-18 | CANADA | 4777 4777 | 1993-03-12 | Development Counsellors International | 2001 McGill College Montreal Q 13H3AIGI | ||||
| 5730 | 5730 | 2006-04-30 | Hong Kong Tourism Board | 2002-10-30 | HONG KONG | 4777 4777 | 1993-03-12 | Development Counsellors International | 10940 Wilshire Boulevard Suite 2050 L.A 90024-3915 | CA | |||
| 5732 | 5732 | 2006-04-30 | UK Trade & Investment | 2005-04-29 | GREAT BRITAIN | 4777 4777 | 1993-03-12 | Development Counsellors International | Kingsgate House 66-74 Victoria Street London S101E 6SW | ||||
| 5783 | 5783 | 2015-04-30 | Economic Promotion Agency of Tuscany | 2014-05-08 | ITALY | 4777 4777 | 1993-03-12 | Development Counsellors International | |||||
| 6644 | 6644 | 1997-05-30 | Government of Cayman Islands/Tourism, Aviation & Commerce | 1999-01-08 | CAYMAN ISLANDS | 4777 4777 | 1993-03-12 | Development Counsellors International | Government Administration Building | ||||
| 6647 | 6647 | 2000-05-30 | St. Lucia National Development Corporation | 1999-11-18 | SAINT LUCIA | 4777 4777 | 1993-03-12 | Development Counsellors International | 27 Brazil Street | ||||
| 6828 | 6828 | 1999-05-31 | Petro-Canada | 1999-01-08 | CANADA | 4777 4777 | 1993-03-12 | Development Counsellors International | Calgary | ||||
| 6839 | 6839 | 2001-05-31 | Fideicomiso Puente Internacional Solidaridad | 2001-10-11 | MEXICO | 4777 4777 | 1993-03-12 | Development Counsellors International | Loma Redonda 2721 Monterrey, NL CP64710 | ||||
| 8147 | 8147 | 1996-06-30 | Geneva Departement de l'Economie Publique | 1993-05-11 | SWITZERLAND | 4777 4777 | 1993-03-12 | Development Counsellors International | Geneve | ||||
| 8160 | 8160 | 1997-06-30 | Botswana Development Corporation, Limited | 1999-01-08 | BOTSWANA | 4777 4777 | 1993-03-12 | Development Counsellors International | Gaborone | ||||
| 8219 | 8219 | 2001-06-30 | Manitoba Trade & Investment Corporation Department of Industry, Trade & Mines | 2001-10-11 | CANADA | 4777 4777 | 1993-03-12 | Development Counsellors International | 410-155 Carlton Street Winnipeg, Manitoba R3C 3H | ||||
| 8233 | 8233 | 2002-06-30 | South Australia | 2002-04-29 | AUSTRALIA | 4777 4777 | 1993-03-12 | Development Counsellors International | Regus Tysons Corner 4th Floor 1750 Tysons Boulevard McLean 22102 | VA | |||
| 8268 | 8268 | 2006-06-30 | Swedish Travel & Tourism Council | 2005-04-29 | SWEDEN | 4777 4777 | 1993-03-12 | Development Counsellors International | Sveriges Rese - Och Turistrad AB Box 3030 Stockholm | ||||
| 8347 | 8347 | 2016-06-30 | Tourism Tasmania | 2001-12-07 | AUSTRALIA | 4777 4777 | 1993-03-12 | Development Counsellors International | GPO Box 825 H Hobart 700 | ||||
| 9385 | 9385 | 1997-07-31 | Barbados Investment & Development Corporation | 1999-01-08 | BARBADOS | 4777 4777 | 1993-03-12 | Development Counsellors International | New York | NY | |||
| 9449 | 9449 | 2009-07-31 | Saskatchewan Industry & Resources | 2007-05-04 | CANADA | 4777 4777 | 1993-03-12 | Development Counsellors International | |||||
| 10378 | 10378 | 1998-08-30 | Costa Rican Investment and Trade Development Board | 1999-01-08 | COSTA RICA | 4777 4777 | 1993-03-12 | Development Counsellors International | New York | NY | |||
| 10588 | 10588 | 1999-08-31 | South African Tourism Board | 1993-03-12 | SOUTH AFRICA | 4777 4777 | 1993-03-12 | Development Counsellors International | New York | NY | |||
| 10591 | 10591 | 2000-08-31 | Sun International | 2001-03-19 | SOUTH AFRICA | 4777 4777 | 1993-03-12 | Development Counsellors International | 3 Sandown Valley Crescent Sandown, Gauteng Johannesburg | ||||
| 11014 | 11014 | 1996-09-11 | Government of Newfoundland & Labrador | 1996-06-28 | CANADA | 4777 4777 | 1993-03-12 | Development Counsellors International | |||||
| 11575 | 11575 | 1998-09-30 | Greater Glasgow & Clyde Valley Tourist Board | 1999-01-08 | SCOTLAND | 4777 4777 | 1993-03-12 | Development Counsellors International | Glasgow | ||||
| 11602 | 11602 | 2001-09-30 | Government of Trinidad & Tobago | 2001-03-19 | TRINIDAD AND TOBAGO | 4777 4777 | 1993-03-12 | Development Counsellors International | 10-14 Philipps Street Port of Spain | ||||
| 11659 | 11659 | 2007-09-30 | Northern Ireland Tourist Board | 2007-05-04 | NORTHERN IRELAND | 4777 4777 | 1993-03-12 | Development Counsellors International | |||||
| 11679 | 11679 | 2010-09-30 | Welsh Development Agency | 2005-10-26 | GREAT BRITAIN | 4777 4777 | 1993-03-12 | Development Counsellors International | Trafalgar House, 5 Fitzalan Place | Cardiff, United Kingdom CF24OED | |||
| 12826 | 12826 | 2004-10-31 | Singita Private Game Reserve | 2003-05-02 | SOUTH AFRICA | 4777 4777 | 1993-03-12 | Development Counsellors International | 53 Autumn Road Rivonia 2128 Sandton | ||||
| 13871 | 13871 | 2001-11-30 | Spanish Embassy | 2001-12-07 | SPAIN | 4777 4777 | 1993-03-12 | Development Counsellors International | 405 Lexington Avenue 44th Floor New York 10174 | NY | |||
| 13898 | 13898 | 2006-11-30 | Korea Trade Investment Promotion Agency | 2004-10-25 | KOREA, SOUTH | 4777 4777 | 1993-03-12 | Development Counsellors International | 300-9, Yomgok-dong, Seocho-gu, Seoul | ||||
| 15808 | 15808 | 2000-12-31 | Government of the Cayman Islands | 2000-05-09 | CAYMAN ISLANDS | 4777 4777 | 1993-03-12 | Development Counsellors International | Adm. Bldg. Elgin Ave. Georgetown, Grand Cayman | ||||
| 15828 | 15828 | 2001-12-31 | Invest in Finland Bureau | 2001-03-19 | FINLAND | 4777 4777 | 1993-03-12 | Development Counsellors International | Aleksanterinkatu 17, P.O. Box 800 FIN-00101 Helsinki | ||||
| 15861 | 15861 | 2003-12-31 | Flanders Foreign Investment Office | 2000-05-09 | BELGIUM | 4777 4777 | 1993-03-12 | Development Counsellors International | G. Vander Lindenstaat 9 3000 Leuven | ||||
| 15892 | 15892 | 2004-12-31 | Taipei Economic and Cultural Office in New York Investment and Trade Office | 2004-10-25 | TAIWAN | 4777 4777 | 1993-03-12 | Development Counsellors International | 126 East 56th Street, 8th Floor New York 10022 | NY | |||
| 15977 | 15977 | 2008-12-31 | Tourism Promotion Corporation of Chile | 2006-11-02 | CHILE | 4777 4777 | 1993-03-12 | Development Counsellors International | |||||
| 16014 | 16014 | 2010-12-31 | Peruvian Export and Tourism Promotion Board | 2008-10-31 | PERU | 4777 4777 | 1993-03-12 | Development Counsellors International | Calle 1 Oeste N 50, piso 13 Edificio | Mincetur | |||
| 16087 | 16087 | 2014-12-31 | Tourism Toronto | 2010-04-29 | CANADA | 4777 4777 | 1993-03-12 | Development Counsellors International | 207 Queens Quay West | Suite 405 Toronto M5J1A7 |
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) );