FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
174 rows where Country/Location_Represented = "SPAIN" sorted by Foreign_Principal_Termination_Date
This data as json, CSV (advanced)
Foreign_Principal 25
- Autonomous Community of the Basque Country 2
- Embassy of Spain 2
- Government of Catalonia 2
- Government of Spain, Embassy 2
- Tourist Office of Spain 2
- American Basque Foundation 1
- Autonomous Government of Catalonia, Department of Industry & Energy (CIDEM), Office of Foreign Investment 1
- Barcelona Turisme Convention Bureau 1
- Center for Information and Business Development (CIDEM) Generalitat of Catalonia 1
- Contrasta Global SL 1
- Delegation of Catalonia to United States of America 1
- Empresa Nacional del Uranio, S.A. (ENUSA) 1
- Expansion Exterior, S.A. 1
- Extenda 1
- Generalitat of Catalonia 1
- ICEX Spain Trade and Investment 1
- Instituto Espanol De Comercio Exterior 1
- Investment Promotion Agency of Spain - INTERES 1
- La Caixa Foundation 1
- Oversea Solution, Ltd. on behalf of the Embassy of Spain 1
- Provincial Government of Gipuzkoa 1
- Spanish Embassy 1
- Spanish Ministry of Commerce 1
- Turismo de Tenerife 1
- Xunta de Galicia 1
Registrant_Name 24
- Development Counsellors International 3
- Abernathy MacGregor Group, Inc. 2
- Ketchum Inc. NY 2
- McClure, Gerard & Neuenschwander, Inc. 2
- Myriad International Marketing, LLC 2
- American Basque Foundation, Inc. 1
- Burson-Marsteller 1
- Camara Oficial Espanola de Comercio 1
- Covington & Burling, LLP 1
- DLA Piper US LLP 1
- Delegation of Catalonia to the United States of America 1
- Donald N. Martin & Company, Inc. 1
- FGS Global (US) LLC (FKA FGH Holdings LLC) 1
- G2 Worldwide, Inc. 1
- Independent Diplomat, Inc. 1
- Instituto Galego de Promocion Economica (IGAPE), New York 1
- JWI, LLC 1
- Loge, Peter 1
- Pillsbury Winthrop Shaw Pittman, LLP 1
- Ruder Finn, Inc. 1
- S.G.R. LLC Government Relations and Lobbying 1
- Scribe Strategies & Advisors, Inc. 1
- Smith McCabe, Ltd. 1
- TKC International, Inc. 1
Registrant_Date (date) 24 ✖
- 1993-03-12 3
- 1994-09-19 2
- 2006-05-09 2
- 2018-04-30 2
- 2019-03-13 2
- 1960-07-29 1
- 1961-09-27 1
- 1972-12-27 1
- 1973-10-23 1
- 1979-12-13 1
- 1985-08-05 1
- 1992-06-26 1
- 1994-11-14 1
- 1995-02-06 1
- 1997-07-31 1
- 1997-09-12 1
- 2005-01-31 1
- 2005-02-01 1
- 2008-02-05 1
- 2008-04-03 1
- 2014-05-07 1
- 2015-07-20 1
- 2016-09-20 1
- 2021-11-15 1
City 5
- - 22
- New York 3
- Washington 3
- Beverly Hills 1
- Espana 1
Country/Location_Represented 1
- SPAIN · 30 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5755 | 5755 | 1994-04-29 | La Caixa Foundation | 1993-05-04 | SPAIN | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | Barcelona | ||||
12063 | 12063 | 1995-09-30 | Generalitat of Catalonia | 1995-06-15 | SPAIN | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | |||||
4547 | 4547 | 1996-03-31 | Autonomous Government of Catalonia, Department of Industry & Energy (CIDEM), Office of Foreign Investment | 1995-02-14 | SPAIN | Smith McCabe, Ltd. 4687 | 1992-06-26 | Smith McCabe, Ltd. | New York | NY | |||
7149 | 7149 | 1996-05-31 | Autonomous Community of the Basque Country | 1994-11-14 | SPAIN | American Basque Foundation, Inc. 4971 | 1994-11-14 | American Basque Foundation, Inc. | Victoria-Gasteiz | ||||
10026 | 10026 | 1996-08-01 | American Basque Foundation | 1994-10-05 | SPAIN | McClure, Gerard & Neuenschwander, Inc. 4947 | 1994-09-19 | McClure, Gerard & Neuenschwander, Inc. | Boise | ID | |||
10027 | 10027 | 1996-08-01 | Autonomous Community of the Basque Country | 1994-09-19 | SPAIN | McClure, Gerard & Neuenschwander, Inc. 4947 | 1994-09-19 | McClure, Gerard & Neuenschwander, Inc. | Victoria-Gasteiz | ||||
1815 | 1815 | 1998-01-31 | Empresa Nacional del Uranio, S.A. (ENUSA) | 1997-11-12 | SPAIN | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Madrid | ||||
13384 | 13384 | 1999-10-31 | Center for Information and Business Development (CIDEM) Generalitat of Catalonia | 1996-10-24 | SPAIN | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | New York | NY | |||
3325 | 3325 | 2000-03-01 | Tourist Office of Spain | 1999-09-21 | SPAIN | Donald N. Martin & Company, Inc. 1381 | 1960-07-29 | Donald N. Martin & Company, Inc. | 666 Fifth Avenue New York, NY 10103 | NY | |||
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 | |||
15415 | 15415 | 2002-12-27 | Spanish Ministry of Commerce | 1972-12-27 | SPAIN | Camara Oficial Espanola de Comercio 2400 | 1972-12-27 | Camara Oficial Espanola de Comercio | PR | ||||
3330 | 3330 | 2004-03-01 | Expansion Exterior, S.A. | 2003-06-16 | SPAIN | JWI, LLC 4990 | 1995-02-06 | JWI, LLC | Calle Orense 58 28020 Madrid | ||||
4637 | 4637 | 2004-03-31 | Xunta de Galicia | 1997-09-12 | SPAIN | Instituto Galego de Promocion Economica (IGAPE), New York 5210 | 1997-09-12 | Instituto Galego de Promocion Economica (IGAPE), New York | Santiago, Compostela | ||||
10043 | 10043 | 2006-08-01 | Government of Spain, Embassy | 2004-01-28 | SPAIN | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 2375 Pennsylvania Avenue, N.W. 20037 | DC | |||
16639 | 16639 | 2008-12-31 | Instituto Espanol De Comercio Exterior | 2005-02-01 | SPAIN | G2 Worldwide, Inc. 5667 | 2005-02-01 | G2 Worldwide, Inc. | 405 Lexington Avenue 44th Floor New York | NY | |||
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 | |||||
12226 | 12226 | 2015-09-30 | Delegation of Catalonia to United States of America | 2013-09-27 | SPAIN | Independent Diplomat, Inc. 5860 | 2008-04-03 | Independent Diplomat, Inc. | One Rockefeller Plaza, 26th Floor | New York | NY | 10020 | |
1023 | 1023 | 2016-01-01 | Extenda | 2014-10-06 | SPAIN | Ketchum Inc. NY 5758 | 2006-05-09 | Ketchum Inc. NY | 817 Broadway Avenue, 2nd Floor | New York | NY | 10003 | |
1025 | 1025 | 2016-01-01 | ICEX Spain Trade and Investment | 2014-10-06 | SPAIN | Ketchum Inc. NY 5758 | 2006-05-09 | Ketchum Inc. NY | 405 Lexington Avenue | 44th Floor | New York | NY | 10174 |
3121 | 3121 | 2017-02-28 | Government of Spain, Embassy | 2011-06-03 | SPAIN | Covington & Burling, LLP 5852 | 2008-02-05 | Covington & Burling, LLP | 2375 Pennsylvania Avenue, NW | Washington | DC | 20037 | |
16805 | 16805 | 2017-12-31 | Government of Catalonia | 2014-05-07 | SPAIN | Delegation of Catalonia to the United States of America 6220 | 2014-05-07 | Delegation of Catalonia to the United States of America | Placa Sant Jaume, 4 | 08002 Barcelona Catalunya | |||
16819 | 16819 | 2017-12-31 | Tourist Office of Spain | 2018-06-01 | SPAIN | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 8383 Wilshire Blvd. Suite 960 | Beverly Hills | CA | 90211 | |
14003 | 14003 | 2018-11-15 | Government of Catalonia | 2017-08-28 | SPAIN | S.G.R. LLC Government Relations and Lobbying 6379 | 2016-09-20 | S.G.R. LLC Government Relations and Lobbying | 1050 K Street, NW | Suite 325 | Washington | DC | 20001 |
3953 | 3953 | 2019-03-21 | Embassy of Spain | 2019-03-13 | SPAIN | Abernathy MacGregor Group, Inc. 6647 | 2019-03-13 | Abernathy MacGregor Group, Inc. | 86-90 Paul Street, London EC2A 4NE | ||||
3954 | 3954 | 2019-03-21 | Oversea Solution, Ltd. on behalf of the Embassy of Spain | 2019-03-13 | SPAIN | Abernathy MacGregor Group, Inc. 6647 | 2019-03-13 | Abernathy MacGregor Group, Inc. | |||||
13951 | 13951 | 2019-11-14 | Embassy of Spain | 2019-10-11 | SPAIN | FGS Global (US) LLC (FKA FGH Holdings LLC) 5666 | 2005-01-31 | FGS Global (US) LLC (FKA FGH Holdings LLC) | 2375 Pennsylvania Avenue, NW | Washington | DC | 20037 | |
3358 | 3358 | 2020-03-01 | Contrasta Global SL | 2020-01-24 | SPAIN | Scribe Strategies & Advisors, Inc. 6305 | 2015-07-20 | Scribe Strategies & Advisors, Inc. | Calle Progreso, 2 Pl Los Olivos | 289906-Getafe | Espana | ||
16890 | 16890 | 2020-12-31 | Turismo de Tenerife | 2019-11-26 | SPAIN | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | |||||
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 | |||
12883 | 12883 | 2022-10-20 | Provincial Government of Gipuzkoa | 2021-11-15 | SPAIN | Loge, Peter 7044 | 2021-11-15 | Loge, Peter | Paseo Ondarreta, 18 | Donostia-San Sebastian, Gipuzkoa |
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]) );