FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
19 rows where Registration_Number = 1421 and State = ""
This data as json, CSV (advanced)
Suggested facets: Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 18
- Grand Duchy of Luxembourg 2
- Acapulco Cultural & Convention Center 1
- Bahamas Agricultural & Industrial Corporation 1
- Barbados Industrial Development Corporation 1
- Chamber of Foreign Trade 1
- Glenrothes Development Corporation 1
- Greater Niagara Chamber of Commerce 1
- Grenada Industrial Development Corporation 1
- ICD Austria (Industrial Cooperation & Development, Inc.) 1
- Industrial Enterprises, Inc. 1
- Luxembourg Board of Economic Development 1
- Newfoundland Department of Industrial Development 1
- Nova Scotia Department of Trade & Industry 1
- Ontario Department of Economics & Development 1
- St. Lucia National Development Corporation 1
- Swedish Tourist Board 1
- Thailand Board of Investment 1
- Trinidad & Tobago Industrial Development Corporation 1
Country/Location_Represented 13
- CANADA 5
- LUXEMBOURG 3
- AUSTRIA 1
- BAHAMAS 1
- BARBADOS 1
- GERMANY, FEDERAL REPUBLIC OF 1
- GRENADA 1
- MEXICO 1
- SAINT LUCIA 1
- SCOTLAND 1
- SWEDEN 1
- THAILAND 1
- TRINIDAD AND TOBAGO 1
State 1
- - · 19 ✖
Registrant_Name 1
City 1
- - 19
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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. | |||||
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. | |||||
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. | |||||
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. | |||||
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. | |||||
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 | ||||
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. | |||||
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. |
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]) );