FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
47 rows where Address_2 = "" and Registration_Number = 4777
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Foreign_Principal >30
- Swedish Travel & Tourism Council 2
- APEV Romania 1
- Barbados Investment & Development Corporation 1
- Botswana Development Corporation, Limited 1
- Costa Rican Investment and Trade Development Board 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
- Peruvian Export and Tourism Promotion Board 1
- Petro-Canada 1
- Proexport Colombia 1
- Saskatchewan Industry & Resources 1
- …
Country/Location_Represented >30
- CANADA 5
- AUSTRALIA 3
- SCOTLAND 3
- SOUTH AFRICA 3
- BELGIUM 2
- CAYMAN ISLANDS 2
- CHILE 2
- SPAIN 2
- SWEDEN 2
- SWITZERLAND 2
- AUSTRIA 1
- BARBADOS 1
- BOTSWANA 1
- COLOMBIA 1
- COSTA RICA 1
- ECUADOR 1
- FINLAND 1
- GREAT BRITAIN 1
- HONG KONG 1
- ISRAEL 1
- ITALY 1
- KOREA, SOUTH 1
- MEXICO 1
- MONACO 1
- NETHERLANDS 1
- NORTHERN IRELAND 1
- PERU 1
- ROMANIA 1
- SAINT LUCIA 1
- TAIWAN 1
- …
Registrant_Name 1
Registrant_Date (date) 1 ✖
- 1993-03-12 47
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | ||||
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 | |||||
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 | ||||
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 |
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]) );