FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
115 rows where Country/Location_Represented = "SPAIN" and State = "" sorted by Foreign_Principal_Termination_Date
This data as json, CSV (advanced)
Registrant_Name >30
- Abernathy MacGregor Group, Inc. 2
- Development Counsellors International 2
- Doremus & Company 2
- Finley Kumble Wagner Heine Underberg Manley Myerson & Casey 2
- Hill and Knowlton Strategies, LLC 2
- McGrath, Lee Kimche 2
- Ruder Finn, Inc. 2
- Squire Patton Boggs, LLP 2
- American Basque Foundation, Inc. 1
- Barnes, Richardson & Colburn 1
- Brown, Earle Palmer 1
- Burson-Marsteller 1
- Delegation of Catalonia to the United States of America 1
- Euzkaldunak, Inc. 1
- Friedersdorf, Max L. 1
- Instituto Galego de Promocion Economica (IGAPE), New York 1
- JWI, LLC 1
- Keating Group, Inc. 1
- Loge, Peter 1
- McClure, Gerard & Neuenschwander, Inc. 1
- Modern Education Services, Inc. 1
- Morgan, Lewis & Bockius, L.L.P. 1
- Myriad International Marketing, LLC 1
- O'Connor & Hannan, L.L.P. 1
- PRS International Consulting, Inc. 1
- Pillsbury Winthrop Shaw Pittman, LLP 1
- Rizo & Associates, Ltd. 1
- Sawyer Miller Group 1
- Scribe Strategies & Advisors, Inc. 1
- Spanish National Tourist Office, St. Augustine 1
- …
Foreign_Principal >30
- Asociacion de Empresas RENFE/Patentes TALGO, S.A. 2
- Autonomous Community of the Basque Country 2
- Government of Catalonia 2
- Alianza Popular 1
- Amadeus Global Travel Distribution, S.A. 1
- Asociacion Nacional de Armadores de Buques Congeladores 1
- Banco de Santander, S.A.D.C. 1
- Barcelona Turisme Convention Bureau 1
- Basque Government 1
- Construcciones Aeronauticas, S.A. 1
- Contrasta Global SL 1
- Department of Environment the Government of Catalonia, Spain 1
- Embassy of Spain 1
- Empresa Nacional del Uranio, S.A. (ENUSA) 1
- Excem, S.A. 1
- Expansion Exterior, S.A. 1
- Franklin, S.A. 1
- Galicia Province, Spain 1
- Generalitat of Catalonia 1
- Generalitat of Cataluyna 1
- Gobierno Vasco, the Government of the Autonomous Basque Community of Spain 1
- Government of Spain 1
- Hotel Villa Magna 1
- Industrias Quimicas y Tartaricas 1
- Intemsa 1
- Investment Promotion Agency of Spain - INTERES 1
- La Caixa Foundation 1
- Menendez, Garcia y Cia., Ltd. 1
- Ministry of Information & Tourism of Spain 1
- Ministry of Transportation, Tourism and Communications, Government of Spain 1
- …
State 1
- - · 44 ✖
Country/Location_Represented 1
- SPAIN · 44 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14306 | 14306 | 1982-11-29 | Spanish National Tourist Office | 1982-04-07 | SPAIN | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | |||||
4407 | 4407 | 1983-03-31 | Ministry of Transportation, Tourism and Communications, Government of Spain | 1981-12-01 | SPAIN | McGrath, Lee Kimche 3312 | 1981-12-01 | McGrath, Lee Kimche | Madrid | ||||
3266 | 3266 | 1984-03-01 | Industrias Quimicas y Tartaricas | 1983-01-28 | SPAIN | Barnes, Richardson & Colburn 2751 | 1977-02-10 | Barnes, Richardson & Colburn | Gerona | ||||
3815 | 3815 | 1984-03-16 | Construcciones Aeronauticas, S.A. | 1983-08-16 | SPAIN | Stafford, Burke & Hecker, Inc. 3510 | 1983-08-16 | Stafford, Burke & Hecker, Inc. | Madrid | ||||
7391 | 7391 | 1984-06-01 | Excem, S.A. | 1983-11-10 | SPAIN | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | Madrid | ||||
9137 | 9137 | 1984-07-09 | Generalitat of Cataluyna | 1983-07-15 | SPAIN | PRS International Consulting, Inc. 3498 | 1983-07-15 | PRS International Consulting, Inc. | Barcelona | ||||
11397 | 11397 | 1985-09-06 | Spain | 1982-08-04 | SPAIN | McGrath, Lee Kimche 3312 | 1981-12-01 | McGrath, Lee Kimche | Madrid | ||||
11829 | 11829 | 1985-09-26 | Government of Spain | 1977-05-27 | SPAIN | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | Madrid | ||||
11832 | 11832 | 1985-09-26 | Intemsa | 1977-05-13 | SPAIN | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | Madrid | ||||
15172 | 15172 | 1985-12-16 | Asociacion Nacional de Armadores de Buques Congeladores | 1982-07-21 | SPAIN | Finley Kumble Wagner Heine Underberg Manley Myerson & Casey 2799 | 1977-06-29 | Finley Kumble Wagner Heine Underberg Manley Myerson & Casey | Vigo | ||||
6558 | 6558 | 1986-05-15 | Government of Catalonia | 1986-04-25 | SPAIN | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | |||||
15994 | 15994 | 1987-12-31 | Asociacion de Empresas RENFE/Patentes TALGO, S.A. | 1987-05-21 | SPAIN | Finley Kumble Wagner Heine Underberg Manley Myerson & Casey 2799 | 1977-06-29 | Finley Kumble Wagner Heine Underberg Manley Myerson & Casey | Madrid | ||||
2783 | 2783 | 1988-02-25 | Alianza Popular | 1988-02-25 | SPAIN | Rizo & Associates, Ltd. 4104 | 1988-02-25 | Rizo & Associates, Ltd. | Madrid | ||||
4174 | 4174 | 1989-03-30 | Spanish Trade Commission | 1987-03-27 | SPAIN | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | |||||
6825 | 6825 | 1989-05-25 | Menendez, Garcia y Cia., Ltd. | 1982-03-26 | SPAIN | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Madrid | ||||
6826 | 6826 | 1989-05-25 | Por Larranaga, Fabrica de Tabacos, S.A. | 1982-03-26 | SPAIN | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Madrid | ||||
7937 | 7937 | 1989-06-19 | Basque Government | 1988-11-21 | SPAIN | Euzkaldunak, Inc. 4189 | 1988-11-21 | Euzkaldunak, Inc. | Gasteiz | ||||
12632 | 12632 | 1989-10-12 | Banco de Santander, S.A.D.C. | 1988-10-12 | SPAIN | Morgan, Lewis & Bockius, L.L.P. 3794 | 1986-03-12 | Morgan, Lewis & Bockius, L.L.P. | Santander | ||||
13826 | 13826 | 1989-11-08 | Amadeus Global Travel Distribution, S.A. | 1989-05-08 | SPAIN | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | Madrid | ||||
5854 | 5854 | 1990-04-30 | Franklin, S.A. | 1991-10-30 | SPAIN | Susan Davis International & Public Affairs 3444 | 1983-02-16 | Susan Davis International & Public Affairs | Madrid | ||||
10010 | 10010 | 1990-08-01 | Gobierno Vasco, the Government of the Autonomous Basque Community of Spain | 1988-04-04 | SPAIN | Wexler, Reynolds, Fuller, Harrison & Schule, Inc. 3306 | 1981-11-20 | Wexler, Reynolds, Fuller, Harrison & Schule, Inc. | Alava | ||||
13947 | 13947 | 1990-11-14 | Sociedad Para la Promocion y Reconversion Industrial, S.A. | 1990-05-24 | SPAIN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Gran Via | ||||
3931 | 3931 | 1991-03-21 | Asociacion de Empresas RENFE/Patentes TALGO, S.A. | 1988-03-21 | SPAIN | Washington, Perito & Dubuc 4107 | 1988-03-21 | Washington, Perito & Dubuc | Madrid | ||||
10020 | 10020 | 1991-08-01 | Montecinca, S.A. | 1990-12-04 | SPAIN | Friedersdorf, Max L. 4444 | 1990-12-05 | Friedersdorf, Max L. | Barcelona | ||||
5146 | 5146 | 1992-04-10 | Sociedad Estatal para la Ejecucion de Programas y Actuaciones Commemorativas del Quinto Centerario del etc. | 1991-06-10 | SPAIN | Sawyer Miller Group 3777 | 1986-02-12 | Sawyer Miller Group | Madrid | ||||
3624 | 3624 | 1993-03-11 | Hotel Villa Magna | 1988-12-21 | SPAIN | Keating Group, Inc. 2478 | 1973-11-23 | Keating Group, Inc. | Madrid | ||||
10604 | 10604 | 1993-08-18 | Ministry of Information & Tourism of Spain | 1972-02-29 | SPAIN | Spanish National Tourist Office, St. Augustine 2322 | 1972-02-29 | Spanish National Tourist Office, St. Augustine | Madrid | ||||
10615 | 10615 | 1993-08-19 | Galicia Province, Spain | 1993-02-24 | SPAIN | Brown, Earle Palmer 4770 | 1993-02-24 | Brown, Earle Palmer | Madrid | ||||
14959 | 14959 | 1993-12-10 | Department of Environment the Government of Catalonia, Spain | 1992-05-07 | SPAIN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Barcelona | ||||
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. | |||||
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 | ||||
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 | ||||
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 | ||||
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 | |||||
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 | |||
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. | |||||
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]) );