FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
52 rows where City = "" and "Registrant_Date" is on date 1993-03-12
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Address_2
Foreign_Principal_Registration_Date (date) >30 ✖
- 1999-01-08 7
- 1999-11-18 3
- 2001-03-19 3
- 1993-03-12 2
- 2000-05-09 2
- 2001-10-11 2
- 2001-12-07 2
- 2004-10-25 2
- 2005-04-29 2
- 2006-11-02 2
- 2007-05-04 2
- 1993-05-11 1
- 1993-06-23 1
- 1993-12-17 1
- 1994-10-06 1
- 1995-05-01 1
- 1995-11-02 1
- 1996-06-28 1
- 2000-12-18 1
- 2002-04-29 1
- 2002-10-04 1
- 2002-10-30 1
- 2003-05-02 1
- 2005-10-26 1
- 2010-04-29 1
- 2011-05-10 1
- 2012-05-01 1
- 2013-07-02 1
- 2013-07-03 1
- 2014-05-08 1
- …
Foreign_Principal >30
- State of Israel 2
- Swedish Travel & Tourism Council 2
- APEV Romania 1
- Barbados Investment & Development Corporation 1
- Barcelona Turisme Convention Bureau 1
- Botswana Development Corporation, Limited 1
- Consulate of the State of Israel in New York 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
- Inkombank 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
- Media Most 1
- Netherlands Foreign Investment Agency 1
- Northern Ireland Tourist Board 1
- …
Country/Location_Represented >30
- CANADA 6
- ISRAEL 4
- AUSTRALIA 3
- SOUTH AFRICA 3
- SPAIN 3
- CAYMAN ISLANDS 2
- CHILE 2
- GREAT BRITAIN 2
- RUSSIA 2
- SCOTLAND 2
- SWEDEN 2
- BARBADOS 1
- BELGIUM 1
- BOTSWANA 1
- CHINA 1
- COSTA RICA 1
- ECUADOR 1
- FINLAND 1
- HONG KONG 1
- ITALY 1
- KOREA, SOUTH 1
- MEXICO 1
- NAMIBIA 1
- NETHERLANDS 1
- NORTHERN IRELAND 1
- PERU 1
- ROMANIA 1
- SAINT LUCIA 1
- SWITZERLAND 1
- TAIWAN 1
- …
Registrant_Name 2
City 1
- - · 52 ✖
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 | |||||
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 | |||||
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 | |||
2055 | 2055 | 1996-02-01 | State of Israel | 1995-11-02 | ISRAEL | Rubenstein Associates, Inc. 4778 | 1993-03-12 | Rubenstein Associates, Inc. | 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 | ||||
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 | ||||
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 | ||||
5267 | 5267 | 1995-04-14 | State of Israel | 1993-03-12 | ISRAEL | Rubenstein Associates, Inc. 4778 | 1993-03-12 | Rubenstein Associates, Inc. | New York | NY | |||
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 | ||||
7201 | 7201 | 2005-05-31 | Consulate of the State of Israel in New York | 2000-12-18 | ISRAEL | Rubenstein Associates, Inc. 4778 | 1993-03-12 | Rubenstein Associates, Inc. | 800 Second Avenue New York 10017 | NY | |||
7643 | 7643 | 1996-06-06 | Inkombank | 1994-10-06 | RUSSIA | Rubenstein Associates, Inc. 4778 | 1993-03-12 | Rubenstein Associates, Inc. | Moscow | ||||
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 | ||||
11290 | 11290 | 2001-09-01 | Media Most | 1995-05-01 | RUSSIA | Rubenstein Associates, Inc. 4778 | 1993-03-12 | Rubenstein Associates, Inc. | Moscow | ||||
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 | |||
12832 | 12832 | 1993-10-18 | Republic of Namibia | 1993-06-23 | NAMIBIA | Rubenstein Associates, Inc. 4778 | 1993-03-12 | Rubenstein Associates, Inc. | New York | NY | |||
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 | |||
13625 | 13625 | 2002-11-01 | State Council Information Office of China | 2002-10-04 | CHINA | Rubenstein Associates, Inc. 4778 | 1993-03-12 | Rubenstein Associates, Inc. | Beijing | ||||
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 | |||||
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
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]) );