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 Registration_Number = 1421

View and edit SQL

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

State

City

  • 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
775 1982-01-01 United Nations Industrial Development Organization 1980-02-29 INTERNATIONAL 1421 1421 1961-01-30 Development Counsellors International, Ltd.       NY  
1597 1985-01-31 Netherlands/Antilles Economic Mission 1976-05-11 NETHERLANDS ANTILLES 1421 1421 1961-01-30 Development Counsellors International, Ltd.       NY  
2525 1991-02-20 Grand Duchy of Luxembourg 1985-10-30 LUXEMBOURG 1421 1421 1961-01-30 Development Counsellors International, Ltd.          
2526 1991-02-20 State of New South Wales Australia 1961-01-30 AUSTRALIA 1421 1421 1961-01-30 Development Counsellors International, Ltd.       NY  
3057 1976-03-01 Nova Scotia Department of Trade & Industry 1963-08-29 CANADA 1421 1421 1961-01-30 Development Counsellors International, Ltd.          
3292 1961-03-07 Nigerian Office 1961-03-07 NIGERIA 1421 1421 1961-01-30 Development Counsellors International, Ltd.       NY  
3539 1978-03-15 Industrial Enterprises, Inc. 1978-03-10 CANADA 1421 1421 1961-01-30 Development Counsellors International, Ltd.          
4085 1965-03-31 Ontario Department of Economics & Development 1962-12-14 CANADA 1421 1421 1961-01-30 Development Counsellors International, Ltd.          
4808 1987-04-08 Bahamas Agricultural & Industrial Corporation 1987-02-25 BAHAMAS 1421 1421 1961-01-30 Development Counsellors International, Ltd.          
6682 1978-05-31 Chamber of Foreign Trade 1978-01-27 GERMANY, FEDERAL REPUBLIC OF 1421 1421 1961-01-30 Development Counsellors International, Ltd.          
6984 1977-06-01 Acapulco Cultural & Convention Center 1976-04-01 MEXICO 1421 1421 1961-01-30 Development Counsellors International, Ltd.          
7350 1990-06-11 Swedish Tourist Board 1988-07-11 SWEDEN 1421 1421 1961-01-30 Development Counsellors International, Ltd.          
7644 1966-06-24 Greater Niagara Chamber of Commerce 1966-05-31 CANADA 1421 1421 1961-01-30 Development Counsellors International, Ltd.          
7952 1983-06-30 Grand Duchy of Luxembourg 1982-07-19 LUXEMBOURG 1421 1421 1961-01-30 Development Counsellors International, Ltd.          
7960 1983-06-30 Trinidad & Tobago Industrial Development Corporation 1972-01-18 TRINIDAD AND TOBAGO 1421 1421 1961-01-30 Development Counsellors International, Ltd.       NY  
7983 1985-06-30 Luxembourg Board of Economic Development 1982-12-01 LUXEMBOURG 1421 1421 1961-01-30 Development Counsellors International, Ltd.          
7992 1986-06-30 Glenrothes Development Corporation 1980-06-11 SCOTLAND 1421 1421 1961-01-30 Development Counsellors International, Ltd.          
8002 1987-06-30 Grenada Industrial Development Corporation 1987-04-09 GRENADA 1421 1421 1961-01-30 Development Counsellors International, Ltd.          
8628 1986-07-07 St. Lucia National Development Corporation 1977-09-02 SAINT LUCIA 1421 1421 1961-01-30 Development Counsellors International, Ltd.          
8732 1982-07-11 Handelsblatt 1984-03-16 GERMANY, FEDERAL REPUBLIC OF 1421 1421 1961-01-30 Development Counsellors International, Ltd.       NY  
8923 1987-07-20 Newfoundland Department of Industrial Development 1976-01-22 CANADA 1421 1421 1961-01-30 Development Counsellors International, Ltd.          
9026 1985-07-26 Hellenic Development Corporation 1984-11-01 GREECE 1421 1421 1961-01-30 Development Counsellors International, Ltd.       NY  
9238 1965-07-31 Trinidad & Tobago Industrial Development Corporation 1962-03-05 TRINIDAD AND TOBAGO 1421 1421 1961-01-30 Development Counsellors International, Ltd. Trinidad        
9495 1979-08-01 French Industrial Development Agency 1979-04-09 FRANCE 1421 1421 1961-01-30 Development Counsellors International, Ltd.       NY  
11752 1982-10-01 ICD Austria (Industrial Cooperation & Development, Inc.) 1983-04-29 AUSTRIA 1421 1421 1961-01-30 Development Counsellors International, Ltd.          
12177 1965-10-17 Thailand Board of Investment 1975-11-25 THAILAND 1421 1421 1961-01-30 Development Counsellors International, Ltd.          
13324 1987-11-15 Australian Tourist Commission 1985-03-05 AUSTRALIA 1421 1421 1961-01-30 Development Counsellors International, Ltd.       CA  
13668 1961-11-30 Province of Ontario 1961-12-18 CANADA 1421 1421 1961-01-30 Development Counsellors International, Ltd.       NY  
13719 1988-11-30 ECIPS (Eastern Caribbean Investment Promotion Service) 1988-07-01 INTERNATIONAL 1421 1421 1961-01-30 Development Counsellors International, Ltd. New York     NY  
14440 1986-12-15 Barbados Industrial Development Corporation 1985-10-01 BARBADOS 1421 1421 1961-01-30 Development Counsellors International, Ltd.          
15131 1980-12-31 Italian Counsellors International, U.S. Representative for Mezzogiorno Office 1980-12-19 ITALY 1421 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 · Query took 162.282ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history