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

31 rows where Registrant_Name = "Development Counsellors International, Ltd."

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

Foreign_Principal 29

  • Grand Duchy of Luxembourg 2
  • Trinidad & Tobago Industrial Development Corporation 2
  • Acapulco Cultural & Convention Center 1
  • Australian Tourist Commission 1
  • Bahamas Agricultural & Industrial Corporation 1
  • Barbados Industrial Development Corporation 1
  • Chamber of Foreign Trade 1
  • ECIPS (Eastern Caribbean Investment Promotion Service) 1
  • French Industrial Development Agency 1
  • Glenrothes Development Corporation 1
  • Greater Niagara Chamber of Commerce 1
  • Grenada Industrial Development Corporation 1
  • Handelsblatt 1
  • Hellenic Development Corporation 1
  • ICD Austria (Industrial Cooperation & Development, Inc.) 1
  • Industrial Enterprises, Inc. 1
  • Italian Counsellors International, U.S. Representative for Mezzogiorno Office 1
  • Luxembourg Board of Economic Development 1
  • Netherlands/Antilles Economic Mission 1
  • Newfoundland Department of Industrial Development 1
  • Nigerian Office 1
  • Nova Scotia Department of Trade & Industry 1
  • Ontario Department of Economics & Development 1
  • Province of Ontario 1
  • St. Lucia National Development Corporation 1
  • State of New South Wales Australia 1
  • Swedish Tourist Board 1
  • Thailand Board of Investment 1
  • United Nations Industrial Development Organization 1

Country/Location_Represented 20

  • CANADA 6
  • LUXEMBOURG 3
  • AUSTRALIA 2
  • GERMANY, FEDERAL REPUBLIC OF 2
  • INTERNATIONAL 2
  • TRINIDAD AND TOBAGO 2
  • AUSTRIA 1
  • BAHAMAS 1
  • BARBADOS 1
  • FRANCE 1
  • GREECE 1
  • GRENADA 1
  • ITALY 1
  • MEXICO 1
  • NETHERLANDS ANTILLES 1
  • NIGERIA 1
  • SAINT LUCIA 1
  • SCOTLAND 1
  • SWEDEN 1
  • THAILAND 1

State 3

  • - 19
  • NY 11
  • CA 1

Registrant_Name 1

  • Development Counsellors International, Ltd. · 31 ✖

City 1

  • - 31
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
856 856 1982-01-01 United Nations Industrial Development Organization 1980-02-29 INTERNATIONAL Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.       NY  
1715 1715 1985-01-31 Netherlands/Antilles Economic Mission 1976-05-11 NETHERLANDS ANTILLES Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.       NY  
2686 2686 1991-02-20 Grand Duchy of Luxembourg 1985-10-30 LUXEMBOURG Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.          
2687 2687 1991-02-20 State of New South Wales Australia 1961-01-30 AUSTRALIA Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.       NY  
3250 3250 1976-03-01 Nova Scotia Department of Trade & Industry 1963-08-29 CANADA Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.          
3496 3496 1961-03-07 Nigerian Office 1961-03-07 NIGERIA Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.       NY  
3757 3757 1978-03-15 Industrial Enterprises, Inc. 1978-03-10 CANADA Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.          
4318 4318 1965-03-31 Ontario Department of Economics & Development 1962-12-14 CANADA Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.          
5095 5095 1987-04-08 Bahamas Agricultural & Industrial Corporation 1987-02-25 BAHAMAS Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.          
7045 7045 1978-05-31 Chamber of Foreign Trade 1978-01-27 GERMANY, FEDERAL REPUBLIC OF Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.          
7365 7365 1977-06-01 Acapulco Cultural & Convention Center 1976-04-01 MEXICO Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.          
7748 7748 1990-06-11 Swedish Tourist Board 1988-07-11 SWEDEN Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.          
8054 8054 1966-06-24 Greater Niagara Chamber of Commerce 1966-05-31 CANADA Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.          
8365 8365 1983-06-30 Grand Duchy of Luxembourg 1982-07-19 LUXEMBOURG Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.          
8373 8373 1983-06-30 Trinidad & Tobago Industrial Development Corporation 1972-01-18 TRINIDAD AND TOBAGO Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.       NY  
8396 8396 1985-06-30 Luxembourg Board of Economic Development 1982-12-01 LUXEMBOURG Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.          
8405 8405 1986-06-30 Glenrothes Development Corporation 1980-06-11 SCOTLAND Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.          
8415 8415 1987-06-30 Grenada Industrial Development Corporation 1987-04-09 GRENADA Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.          
9071 9071 1986-07-07 St. Lucia National Development Corporation 1977-09-02 SAINT LUCIA Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.          
9181 9181 1982-07-11 Handelsblatt 1984-03-16 GERMANY, FEDERAL REPUBLIC OF Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.       NY  
9377 9377 1987-07-20 Newfoundland Department of Industrial Development 1976-01-22 CANADA Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.          
9482 9482 1985-07-26 Hellenic Development Corporation 1984-11-01 GREECE Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.       NY  
9700 9700 1965-07-31 Trinidad & Tobago Industrial Development Corporation 1962-03-05 TRINIDAD AND TOBAGO Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd. Trinidad        
9973 9973 1979-08-01 French Industrial Development Agency 1979-04-09 FRANCE Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.       NY  
12336 12336 1982-10-01 ICD Austria (Industrial Cooperation & Development, Inc.) 1983-04-29 AUSTRIA Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.          
12788 12788 1965-10-17 Thailand Board of Investment 1975-11-25 THAILAND Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.          
13976 13976 1987-11-15 Australian Tourist Commission 1985-03-05 AUSTRALIA Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.       CA  
14326 14326 1961-11-30 Province of Ontario 1961-12-18 CANADA Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.       NY  
14377 14377 1988-11-30 ECIPS (Eastern Caribbean Investment Promotion Service) 1988-07-01 INTERNATIONAL Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd. New York     NY  
15133 15133 1986-12-15 Barbados Industrial Development Corporation 1985-10-01 BARBADOS Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.          
15842 15842 1980-12-31 Italian Counsellors International, U.S. Representative for Mezzogiorno Office 1980-12-19 ITALY Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.       NY  

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 427.668ms · 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