home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for FARA_All_ForeignPrincipals
List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

56 rows where Registrant_Name = "Development Counsellors International" sorted by Registrant_Name

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Address_2, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

Foreign_Principal >30

  • Swedish Travel & Tourism Council 2
  • APEV Romania 1
  • Barbados Investment & Development Corporation 1
  • Barcelona Turisme Convention Bureau 1
  • Belize Tourism Board 1
  • Botswana Development Corporation, Limited 1
  • Costa Rica Investment Promotion Authority 1
  • Costa Rican Investment and Trade Development Board 1
  • Department of Culture and Tourism - Abu Dhabi 1
  • Economic Promotion Agency of Tuscany 1
  • Ecuador Ministry of Tourism 1
  • Fideicomiso Puente Internacional Solidaridad 1
  • Flanders Foreign Investment Office 1
  • Geneva Departement de l'Economie Publique 1
  • Government of Cayman Islands/Tourism, Aviation & Commerce 1
  • Government of Newfoundland & Labrador 1
  • Government of Trinidad & Tobago 1
  • Government of Western Australia 1
  • Government of the Cayman Islands 1
  • Greater Glasgow & Clyde Valley Tourist Board 1
  • Hong Kong Tourism Board 1
  • Invest in Finland Bureau 1
  • Investissement- Quebec 1
  • Investment Promotion Agency of Spain - INTERES 1
  • Israel Ministry of Tourism 1
  • Korea Trade Investment Promotion Agency 1
  • Manitoba Trade & Investment Corporation Department of Industry, Trade & Mines 1
  • Monaco Government Tourist and Convention Authority 1
  • Netherlands Foreign Investment Agency 1
  • Northern Ireland Tourist Board 1
  • …

Country/Location_Represented >30

  • CANADA 6
  • AUSTRALIA 4
  • SCOTLAND 3
  • SOUTH AFRICA 3
  • SPAIN 3
  • BELGIUM 2
  • CAYMAN ISLANDS 2
  • CHILE 2
  • COSTA RICA 2
  • GREAT BRITAIN 2
  • PERU 2
  • SWEDEN 2
  • SWITZERLAND 2
  • AUSTRIA 1
  • BARBADOS 1
  • BELIZE 1
  • BOTSWANA 1
  • COLOMBIA 1
  • ECUADOR 1
  • FINLAND 1
  • HONG KONG 1
  • ISRAEL 1
  • ITALY 1
  • KOREA, SOUTH 1
  • MEXICO 1
  • MONACO 1
  • NETHERLANDS 1
  • NORTHERN IRELAND 1
  • ROMANIA 1
  • SAINT LUCIA 1
  • …

City 12

  • - 45
  • Abu Dhabi 1
  • Belize City 1
  • Bogota 1
  • Brussels 1
  • Cedex 1
  • Edinburgh 1
  • Escazu San Jose 1
  • Mincetur 1
  • New York, NY 1
  • Queensland 4000 1
  • Vienna 1

State 4

  • - 48
  • NY 6
  • CA 1
  • VA 1

Registrant_Name 1

  • Development Counsellors International · 56 ✖
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
71 71   Belize Tourism Board 2022-11-13 BELIZE Development Counsellors International 4777 1993-03-12 Development Counsellors International PO Box 325, 864 Regent Street Belize City    
130 130   Costa Rica Investment Promotion Authority 2021-05-07 COSTA RICA Development Counsellors International 4777 1993-03-12 Development Counsellors International Plaza Roble/ Los Balcunes 4th FLoor Escazu San Jose    
142 142   Department of Culture and Tourism - Abu Dhabi 2021-10-29 UNITED ARAB EMIRATES Development Counsellors International 4777 1993-03-12 Development Counsellors International Nation Towers Offices, Corniche P,O. Box 94000 Abu Dhabi    
361 361   Israel Ministry of Tourism 2023-04-20 ISRAEL Development Counsellors International 4777 1993-03-12 Development Counsellors International 5 Bank Street Jeruselam        
494 494   Monaco Government Tourist and Convention Authority 2022-05-09 MONACO Development Counsellors International 4777 1993-03-12 Development Counsellors International 2, rue de la Lujerneta   Cedex    
526 526   Netherlands Foreign Investment Agency 2015-04-30 NETHERLANDS Development Counsellors International 4777 1993-03-12 Development Counsellors International Prinses Beatrixlaan 2 2595 AL The Hague        
663 663   Switzerland Tourism 2023-04-26 SWITZERLAND Development Counsellors International 4777 1993-03-12 Development Counsellors International 608 5th Avenue, Suite 603   New York, NY    
749 749   Vienna Tourist Board 2022-05-09 AUSTRIA Development Counsellors International 4777 1993-03-12 Development Counsellors International Invalidenstrasse 6   Vienna    
752 752   Visit Scotland 2021-10-29 SCOTLAND Development Counsellors International 4777 1993-03-12 Development Counsellors International Ocean Point, 94 Ocean drive   Edinburgh    
769 769   visit.brussels 2022-05-09 BELGIUM Development Counsellors International 4777 1993-03-12 Development Counsellors International Rue Royale 2-4 Koningsstraat   Brussels    
1648 1648 1999-01-30 Swedish Travel & Tourism Council 1993-12-17 SWEDEN Development Counsellors International 4777 1993-03-12 Development Counsellors International New York     NY  
2113 2113 2021-02-02 Barcelona Turisme Convention Bureau 2017-04-25 SPAIN Development Counsellors International 4777 1993-03-12 Development Counsellors International Passatge de la Concepcio, 7-9 08008 Barcelona      
2362 2362 2014-02-10 APEV Romania 2011-05-10 ROMANIA Development Counsellors International 4777 1993-03-12 Development Counsellors International          
3036 3036 2000-02-28 Government of Western Australia 1999-11-18 AUSTRALIA Development Counsellors International 4777 1993-03-12 Development Counsellors International Box 7234        
3110 3110 2014-02-28 Tourism & Events Queensland 2013-10-31 AUSTRALIA Development Counsellors International 4777 1993-03-12 Development Counsellors International Level 10, 30 Markerston Street Brisbane Queensland 4000    
4243 4243 2020-03-30 Scottish Development International 2012-05-01 UNITED KINGDOM Development Counsellors International 4777 1993-03-12 Development Counsellors International 150 Broomielaw 5 Atlantic Quay Glasgow, Scotland G2 8LU      
4586 4586 2000-03-31 Scottish Tourist Board 1999-01-08 SCOTLAND Development Counsellors International 4777 1993-03-12 Development Counsellors International Edinburgh        
4725 4725 2012-03-31 Proexport Colombia 2009-10-29 COLOMBIA Development Counsellors International 4777 1993-03-12 Development Counsellors International Calle 28A No 13A-15 Piso 35   Bogota    
4739 4739 2014-03-31 Ecuador Ministry of Tourism 2013-07-02 ECUADOR Development Counsellors International 4777 1993-03-12 Development Counsellors International          
4955 4955 2010-04-01 Investment Promotion Agency of Spain - INTERES 2006-11-02 SPAIN Development Counsellors International 4777 1993-03-12 Development Counsellors International          
4972 4972 2019-04-01 Turismo Chile 2014-10-30 CHILE Development Counsellors International 4777 1993-03-12 Development Counsellors International Av. Providencia 2088, Oficinia 20 Santiago        
5303 5303 1999-04-15 Investissement- Quebec 1999-11-18 CANADA Development Counsellors International 4777 1993-03-12 Development Counsellors International 2001 McGill College Montreal Q 13H3AIGI        
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        
6081 6081 2015-04-30 Economic Promotion Agency of Tuscany 2014-05-08 ITALY Development Counsellors International 4777 1993-03-12 Development Counsellors International          
6986 6986 1997-05-30 Government of Cayman Islands/Tourism, Aviation & Commerce 1999-01-08 CAYMAN ISLANDS Development Counsellors International 4777 1993-03-12 Development Counsellors International Government Administration Building        
6989 6989 2000-05-30 St. Lucia National Development Corporation 1999-11-18 SAINT LUCIA Development Counsellors International 4777 1993-03-12 Development Counsellors International 27 Brazil Street        
7173 7173 1999-05-31 Petro-Canada 1999-01-08 CANADA Development Counsellors International 4777 1993-03-12 Development Counsellors International Calgary        
7184 7184 2001-05-31 Fideicomiso Puente Internacional Solidaridad 2001-10-11 MEXICO Development Counsellors International 4777 1993-03-12 Development Counsellors International Loma Redonda 2721 Monterrey, NL CP64710        
8540 8540 1996-06-30 Geneva Departement de l'Economie Publique 1993-05-11 SWITZERLAND Development Counsellors International 4777 1993-03-12 Development Counsellors International Geneve        
8553 8553 1997-06-30 Botswana Development Corporation, Limited 1999-01-08 BOTSWANA Development Counsellors International 4777 1993-03-12 Development Counsellors International Gaborone        
8612 8612 2001-06-30 Manitoba Trade & Investment Corporation Department of Industry, Trade & Mines 2001-10-11 CANADA Development Counsellors International 4777 1993-03-12 Development Counsellors International 410-155 Carlton Street Winnipeg, Manitoba R3C 3H        
8626 8626 2002-06-30 South Australia 2002-04-29 AUSTRALIA Development Counsellors International 4777 1993-03-12 Development Counsellors International Regus Tysons Corner 4th Floor 1750 Tysons Boulevard McLean 22102     VA  
8661 8661 2006-06-30 Swedish Travel & Tourism Council 2005-04-29 SWEDEN Development Counsellors International 4777 1993-03-12 Development Counsellors International Sveriges Rese - Och Turistrad AB Box 3030 Stockholm        
8740 8740 2016-06-30 Tourism Tasmania 2001-12-07 AUSTRALIA Development Counsellors International 4777 1993-03-12 Development Counsellors International GPO Box 825 H Hobart 700        
9821 9821 1997-07-31 Barbados Investment & Development Corporation 1999-01-08 BARBADOS Development Counsellors International 4777 1993-03-12 Development Counsellors International New York     NY  
9885 9885 2009-07-31 Saskatchewan Industry & Resources 2007-05-04 CANADA Development Counsellors International 4777 1993-03-12 Development Counsellors International          
10856 10856 1998-08-30 Costa Rican Investment and Trade Development Board 1999-01-08 COSTA RICA Development Counsellors International 4777 1993-03-12 Development Counsellors International New York     NY  
11066 11066 1999-08-31 South African Tourism Board 1993-03-12 SOUTH AFRICA Development Counsellors International 4777 1993-03-12 Development Counsellors International New York     NY  
11069 11069 2000-08-31 Sun International 2001-03-19 SOUTH AFRICA Development Counsellors International 4777 1993-03-12 Development Counsellors International 3 Sandown Valley Crescent Sandown, Gauteng Johannesburg        
11515 11515 1996-09-11 Government of Newfoundland & Labrador 1996-06-28 CANADA Development Counsellors International 4777 1993-03-12 Development Counsellors International          
12095 12095 1998-09-30 Greater Glasgow & Clyde Valley Tourist Board 1999-01-08 SCOTLAND Development Counsellors International 4777 1993-03-12 Development Counsellors International Glasgow        
12122 12122 2001-09-30 Government of Trinidad & Tobago 2001-03-19 TRINIDAD AND TOBAGO Development Counsellors International 4777 1993-03-12 Development Counsellors International 10-14 Philipps Street Port of Spain        
12181 12181 2007-09-30 Northern Ireland Tourist Board 2007-05-04 NORTHERN IRELAND Development Counsellors International 4777 1993-03-12 Development Counsellors International          
12201 12201 2010-09-30 Welsh Development Agency 2005-10-26 GREAT BRITAIN Development Counsellors International 4777 1993-03-12 Development Counsellors International Trafalgar House, 5 Fitzalan Place Cardiff, United Kingdom CF24OED      
13418 13418 2004-10-31 Singita Private Game Reserve 2003-05-02 SOUTH AFRICA Development Counsellors International 4777 1993-03-12 Development Counsellors International 53 Autumn Road Rivonia 2128 Sandton        
13507 13507 2020-10-31 PromPeru 2013-07-03 PERU Development Counsellors International 4777 1993-03-12 Development Counsellors International Ave. Republica de Panama No 3655 San Isidro, Lima 27      
14497 14497 2001-11-30 Spanish Embassy 2001-12-07 SPAIN Development Counsellors International 4777 1993-03-12 Development Counsellors International 405 Lexington Avenue 44th Floor New York 10174     NY  
14524 14524 2006-11-30 Korea Trade Investment Promotion Agency 2004-10-25 KOREA, SOUTH Development Counsellors International 4777 1993-03-12 Development Counsellors International 300-9, Yomgok-dong, Seocho-gu, Seoul        
16480 16480 2000-12-31 Government of the Cayman Islands 2000-05-09 CAYMAN ISLANDS Development Counsellors International 4777 1993-03-12 Development Counsellors International Adm. Bldg. Elgin Ave. Georgetown, Grand Cayman        
16500 16500 2001-12-31 Invest in Finland Bureau 2001-03-19 FINLAND Development Counsellors International 4777 1993-03-12 Development Counsellors International Aleksanterinkatu 17, P.O. Box 800 FIN-00101 Helsinki        
16533 16533 2003-12-31 Flanders Foreign Investment Office 2000-05-09 BELGIUM Development Counsellors International 4777 1993-03-12 Development Counsellors International G. Vander Lindenstaat 9 3000 Leuven        
16564 16564 2004-12-31 Taipei Economic and Cultural Office in New York Investment and Trade Office 2004-10-25 TAIWAN Development Counsellors International 4777 1993-03-12 Development Counsellors International 126 East 56th Street, 8th Floor New York 10022     NY  
16649 16649 2008-12-31 Tourism Promotion Corporation of Chile 2006-11-02 CHILE Development Counsellors International 4777 1993-03-12 Development Counsellors International          
16686 16686 2010-12-31 Peruvian Export and Tourism Promotion Board 2008-10-31 PERU Development Counsellors International 4777 1993-03-12 Development Counsellors International Calle 1 Oeste N 50, piso 13 Edificio   Mincetur    
16759 16759 2014-12-31 Tourism Toronto 2010-04-29 CANADA Development Counsellors International 4777 1993-03-12 Development Counsellors International 207 Queens Quay West Suite 405 Toronto M5J1A7      

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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])
);
Powered by Datasette · Queries took 230.917ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows