FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
68 rows where Address_1 = "Madrid"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date (date)
Registrant_Name >30
- Garcia & Diaz 5
- Casares Sanchez, Manuel 3
- Egge, George V., Jr. 3
- Spanish National Tourist Office, San Francisco 3
- Doremus & Company 2
- Kelly, Nason, Inc. 2
- McGrath, Lee Kimche 2
- Spanish National Tourist Office, Chicago 2
- Spanish National Tourist Office, Miami 2
- Spanish National Tourist Office, New York 2
- Squire Patton Boggs, LLP 2
- Aladren del Perojo, Jose Maria 1
- Aladren, Jose M. 1
- Armesto, Felipe Fernandez G. 1
- Barnett, Yingling & Shay, P.C. 1
- Brown, Charles H. 1
- Brown, Earle Palmer 1
- Burson-Marsteller 1
- Calvosa, Ulrich 1
- Carney, William Parke 1
- Circle of the Croatian Knights 1
- Clark, Charles Patrick 1
- Conant & Company Public Relations, Inc. 1
- Finley Kumble Wagner Heine Underberg Manley Myerson & Casey 1
- Garcia-Rubiera, Marcelino 1
- Garza, Lorenzo (Melon) 1
- Italian Public Relations Associates - Italpublic, S.p.A. 1
- John A. Tetley Company, Inc. 1
- Keating Group, Inc. 1
- Law Office of George E. Tolman 1
- …
Registrant_Date (date) >30 ✖
- 1942-07-08 5
- 1965-08-11 3
- 1970-12-21 3
- 1972-02-29 3
- 1942-07-30 2
- 1947-01-10 2
- 1948-09-14 2
- 1964-12-11 2
- 1969-10-09 2
- 1972-02-18 2
- 1981-12-01 2
- 1942-07-03 1
- 1942-07-07 1
- 1942-07-09 1
- 1943-01-01 1
- 1943-12-30 1
- 1945-02-16 1
- 1945-02-26 1
- 1945-03-27 1
- 1949-02-11 1
- 1949-05-09 1
- 1951-09-24 1
- 1953-03-06 1
- 1954-06-19 1
- 1955-03-09 1
- 1961-08-03 1
- 1961-09-27 1
- 1963-05-23 1
- 1964-05-28 1
- 1964-12-17 1
- …
Foreign_Principal_Termination_Date (date) >30 ✖
- 1980-12-30 6
- 1946-01-08 5
- 1964-07-31 2
- 1978-08-25 2
- 1985-09-26 2
- 1989-05-25 2
- 1942-07-09 1
- 1944-12-31 1
- 1945-03-27 1
- 1945-07-01 1
- 1945-10-25 1
- 1945-12-31 1
- 1946-12-30 1
- 1949-01-03 1
- 1950-11-09 1
- 1952-09-25 1
- 1953-03-06 1
- 1955-01-19 1
- 1955-12-01 1
- 1956-01-29 1
- 1960-09-19 1
- 1964-08-11 1
- 1965-12-31 1
- 1966-03-24 1
- 1969-03-31 1
- 1969-12-31 1
- 1972-01-25 1
- 1974-03-12 1
- 1975-12-31 1
- 1977-02-15 1
- …
Foreign_Principal >30
- Ministry of Information & Tourism 5
- Government of Spain 3
- Agencia Efe, S.A. 2
- Asociacion de Empresas RENFE/Patentes TALGO, S.A. 2
- Ministry of Commerce & Tourism 2
- Ministry of Information & Tourism of Spain 2
- Spanish State Tourist Department 2
- Agencia Logos (Logos News Agency) 1
- Agrupacion Nacional de Exportadores de Calzado (National Group of Footwear Exporters) 1
- Alfonso El Alcazar, XI 1
- Alianza Popular 1
- Amadeus Global Travel Distribution, S.A. 1
- Autotransporte Touristico Espanol, S.A. 1
- Banco Exterior de Espana 1
- Comite Para Desarrollo y Defensa de Calzado Espanol en Mercados Extranjeros (Comm. for Dev./Def. of Span. Footwear) 1
- Compania Naviera Espanola 1
- Compania Trasatlantica, Administrada por el Estado-Apartado 1
- Compania Trasmediterranea 1
- Construcciones Aeronauticas, S.A. 1
- Cooperative Espanola de Comercializacion de Productos del Campo (COES) 1
- Direccion General del Turismo (Direction General of Tourism) 1
- Drina - Official Herald of Croatian National Resistence 1
- Empresa Nacional del Uranio, S.A. (ENUSA) 1
- Excem, S.A. 1
- Franklin, S.A. 1
- Galicia Province, Spain 1
- Government of Spain, Foreign Ministry 1
- Henri Kirschen 1
- His Imperial Highness The Grand Duke Wladimir of Russia 1
- Hispanica de Petroleos, S.A. 1
- …
Country/Location_Represented 4
- SPAIN 64
- INTERNATIONAL 2
- EQUATORIAL GUINEA 1
- USSR 1
State 1
- - 68
City 1
- - 68
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1057 | 1057 | 1949-01-03 | His Imperial Highness The Grand Duke Wladimir of Russia | 1942-07-07 | USSR | Pouschine, Ivan 11 | 1942-07-07 | Pouschine, Ivan | Madrid | ||||
1140 | 1140 | 1946-01-08 | Compania Naviera Espanola | 1944-08-04 | SPAIN | Garcia & Diaz 16 | 1942-07-08 | Garcia & Diaz | Madrid | ||||
1142 | 1142 | 1946-01-08 | Compania Trasatlantica, Administrada por el Estado-Apartado | 1942-07-08 | SPAIN | Garcia & Diaz 16 | 1942-07-08 | Garcia & Diaz | Madrid | ||||
1143 | 1143 | 1946-01-08 | Compania Trasmediterranea | 1942-07-08 | SPAIN | Garcia & Diaz 16 | 1942-07-08 | Garcia & Diaz | Madrid | ||||
1147 | 1147 | 1946-01-08 | Islena Maritima, S.A. | 1943-03-09 | SPAIN | Garcia & Diaz 16 | 1942-07-08 | Garcia & Diaz | Madrid | ||||
1149 | 1149 | 1946-01-08 | Orion Compania Naviera | 1944-08-04 | SPAIN | Garcia & Diaz 16 | 1942-07-08 | Garcia & Diaz | Madrid | ||||
1409 | 1409 | 1955-01-19 | Spanish Government | 1954-06-19 | SPAIN | Armesto, Felipe Fernandez G. 837 | 1954-06-19 | Armesto, Felipe Fernandez G. | Madrid | ||||
1504 | 1504 | 1972-01-25 | Comite Para Desarrollo y Defensa de Calzado Espanol en Mercados Extranjeros (Comm. for Dev./Def. of Span. Footwear) | 1970-12-21 | SPAIN | Egge, George V., Jr. 2229 | 1970-12-21 | Egge, George V., Jr. | Madrid | ||||
1601 | 1601 | 1956-01-29 | Drina - Official Herald of Croatian National Resistence | 1955-03-09 | SPAIN | Circle of the Croatian Knights 878 | 1955-03-09 | Circle of the Croatian Knights | Madrid | ||||
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 | ||||
1826 | 1826 | 1999-01-31 | Partido del Progreso | 1998-07-15 | EQUATORIAL GUINEA | Ruddy, Frank 5266 | 1998-07-15 | Ruddy, Frank | Madrid | ||||
2543 | 2543 | 1977-02-15 | Agrupacion Nacional de Exportadores de Calzado (National Group of Footwear Exporters) | 1972-01-31 | SPAIN | Egge, George V., Jr. 2229 | 1970-12-21 | Egge, George V., Jr. | Madrid | ||||
2783 | 2783 | 1988-02-25 | Alianza Popular | 1988-02-25 | SPAIN | Rizo & Associates, Ltd. 4104 | 1988-02-25 | Rizo & Associates, Ltd. | Madrid | ||||
3472 | 3472 | 1953-03-06 | Spanish State Tourist Department | 1953-03-06 | SPAIN | Carney, William Parke 760 | 1953-03-06 | Carney, William Parke | Madrid | ||||
3624 | 3624 | 1993-03-11 | Hotel Villa Magna | 1988-12-21 | SPAIN | Keating Group, Inc. 2478 | 1973-11-23 | Keating Group, Inc. | Madrid | ||||
3653 | 3653 | 1974-03-12 | Cooperative Espanola de Comercializacion de Productos del Campo (COES) | 1964-10-06 | SPAIN | Brown, Charles H. 1470 | 1961-08-03 | Brown, Charles H. | Madrid | ||||
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 | ||||
3847 | 3847 | 1993-03-17 | International Olive Oil Council - IOOC | 1985-03-27 | INTERNATIONAL | Italian Public Relations Associates - Italpublic, S.p.A. 3676 | 1985-03-27 | Italian Public Relations Associates - Italpublic, S.p.A. | Madrid | ||||
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 | ||||
4008 | 4008 | 1966-03-24 | Ministry of Information & Tourism | 1964-12-17 | SPAIN | Spanish National Tourist Office, Dallas 1836 | 1964-12-17 | Spanish National Tourist Office, Dallas | Madrid | ||||
4073 | 4073 | 1945-03-27 | Juan Pujol | 1945-03-27 | SPAIN | Casares Sanchez, Manuel 298 | 1945-03-27 | Casares Sanchez, Manuel | Madrid | ||||
4331 | 4331 | 1969-03-31 | Hoteles Turisticas, S.A. | 1963-05-23 | SPAIN | John A. Tetley Company, Inc. 1630 | 1963-05-23 | John A. Tetley Company, Inc. | Madrid | ||||
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 | ||||
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 | ||||
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 | ||||
6159 | 6159 | 1977-05-01 | Government of Spain | 1976-05-13 | SPAIN | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | Madrid | ||||
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 | ||||
7366 | 7366 | 1977-06-01 | Ministry of Foreign Affairs | 1976-05-10 | SPAIN | O'Connor & Hannan 2691 | 1976-05-10 | O'Connor & Hannan | 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 | ||||
8316 | 8316 | 1977-06-30 | Ministry of Information & Tourism | 1964-12-11 | SPAIN | Spanish National Tourist Office, Chicago 1830 | 1964-12-11 | Spanish National Tourist Office, Chicago | Madrid | ||||
8795 | 8795 | 1945-07-01 | Direccion General del Turismo (Direction General of Tourism) | 1942-07-03 | SPAIN | Garcia-Rubiera, Marcelino 2 | 1942-07-03 | Garcia-Rubiera, Marcelino | Madrid | ||||
9113 | 9113 | 1942-07-09 | Vicesecretaria de Educacion Popular | 1942-07-09 | SPAIN | Spanish Library of Information 28 | 1942-07-09 | Spanish Library of Information | Madrid | ||||
9302 | 9302 | 1980-07-16 | Banco Exterior de Espana | 1979-11-19 | SPAIN | Barnett, Yingling & Shay, P.C. 3070 | 1979-11-19 | Barnett, Yingling & Shay, P.C. | Madrid | ||||
9657 | 9657 | 1964-07-31 | Autotransporte Touristico Espanol, S.A. | 1956-04-13 | SPAIN | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Madrid | ||||
9673 | 9673 | 1964-07-31 | Iberia Airlines of Spain | 1957-01-28 | SPAIN | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Madrid | ||||
10263 | 10263 | 1964-08-11 | Government of Spain | 1955-10-12 | SPAIN | Clark, Charles Patrick 562 | 1949-02-11 | Clark, Charles Patrick | Madrid | ||||
10335 | 10335 | 1987-08-14 | International Olive Oil Council | 1986-05-23 | INTERNATIONAL | Myers Communicounsel, Inc. 3836 | 1986-05-23 | Myers Communicounsel, 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 | ||||
10730 | 10730 | 1978-08-25 | Ministerio De Commercio Y Turismo | 1977-11-17 | SPAIN | Spanish National Tourist Office, Miami 2321 | 1972-02-29 | Spanish National Tourist Office, Miami | Madrid | ||||
10731 | 10731 | 1978-08-25 | Ministry of Information & Tourism of Spain | 1972-02-29 | SPAIN | Spanish National Tourist Office, Miami 2321 | 1972-02-29 | Spanish National Tourist Office, Miami | Madrid | ||||
11397 | 11397 | 1985-09-06 | Spain | 1982-08-04 | SPAIN | McGrath, Lee Kimche 3312 | 1981-12-01 | McGrath, Lee Kimche | Madrid | ||||
11705 | 11705 | 1960-09-19 | Juan & Pedro Pujol (Newspaper Madrid")" | 1948-04-08 | SPAIN | Casares Sanchez, Manuel 425 | 1947-01-10 | Casares Sanchez, Manuel | Madrid | ||||
11810 | 11810 | 1952-09-25 | Spanish State Tourist Office | 1951-09-24 | SPAIN | Calvosa, Ulrich 684 | 1951-09-24 | Calvosa, Ulrich | 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 | ||||
12991 | 12991 | 1945-10-25 | Henri Kirschen | 1945-02-16 | SPAIN | Law Office of George E. Tolman 290 | 1945-02-16 | Law Office of George E. Tolman | Madrid | ||||
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 | ||||
13839 | 13839 | 1950-11-09 | Lucio del Alamo Urrutia (Pyresa)(Prensa y Radio Espanola Sociedad Anonima-Madrid) | 1949-05-09 | SPAIN | Garza, Lorenzo (Melon) 569 | 1949-05-09 | Garza, Lorenzo (Melon) | Madrid | ||||
14305 | 14305 | 1979-11-29 | Union de Empresas y Entidades Siderurgicas (UNESID) (Spanish Steel Industries Association) | 1978-04-28 | SPAIN | Egge, George V., Jr. 2229 | 1970-12-21 | Egge, George V., Jr. | Madrid | ||||
14610 | 14610 | 1955-12-01 | Agencia Efe, S.A. | 1948-04-08 | SPAIN | Casares Sanchez, Manuel 425 | 1947-01-10 | Casares Sanchez, Manuel | Madrid | ||||
14767 | 14767 | 1981-12-03 | Ministry of Information & Tourism | 1972-06-05 | SPAIN | Spanish National Tourist Office, Puerto Rico 2344 | 1972-06-05 | Spanish National Tourist Office, Puerto Rico | Madrid | ||||
15458 | 15458 | 1946-12-30 | Agencia Efe, S.A. | 1943-12-30 | SPAIN | Lucientes, Francisco J. 166 | 1943-12-30 | Lucientes, Francisco J. | Madrid | ||||
15471 | 15471 | 1980-12-30 | Ministerio de Informacion y Turismo | 1965-08-11 | SPAIN | Spanish National Tourist Office, San Francisco 1914 | 1965-08-11 | Spanish National Tourist Office, San Francisco | Madrid | ||||
15472 | 15472 | 1980-12-30 | Ministry of Commerce & Tourism | 1977-10-27 | SPAIN | Spanish National Tourist Office, San Francisco 1914 | 1965-08-11 | Spanish National Tourist Office, San Francisco | Madrid | ||||
15473 | 15473 | 1980-12-30 | Ministry of Commerce & Tourism | 1977-11-22 | SPAIN | Spanish National Tourist Office, Chicago 1830 | 1964-12-11 | Spanish National Tourist Office, Chicago | Madrid | ||||
15474 | 15474 | 1980-12-30 | Ministry of Information & Tourism | 1973-10-12 | SPAIN | Spanish National Tourist Office, San Francisco 1914 | 1965-08-11 | Spanish National Tourist Office, San Francisco | Madrid | ||||
15475 | 15475 | 1980-12-30 | Ministry of Information & Tourism | 1973-11-26 | SPAIN | Spanish National Tourist Office, New York 538 | 1948-09-14 | Spanish National Tourist Office, New York | Madrid | ||||
15476 | 15476 | 1980-12-30 | Spanish State Tourist Department | 1948-09-14 | SPAIN | Spanish National Tourist Office, New York 538 | 1948-09-14 | Spanish National Tourist Office, New York | Madrid | ||||
15517 | 15517 | 1944-12-31 | Alfonso El Alcazar, XI | 1943-01-01 | SPAIN | Aladren, Jose M. 168 | 1943-01-01 | Aladren, Jose M. | Madrid | ||||
15518 | 15518 | 1945-12-31 | Agencia Logos (Logos News Agency) | 1945-02-26 | SPAIN | Aladren del Perojo, Jose Maria 293 | 1945-02-26 | Aladren del Perojo, Jose Maria | Madrid | ||||
15642 | 15642 | 1965-12-31 | Ministry of Information & Tourism, Government of Spain | 1965-05-27 | SPAIN | Conant & Company Public Relations, Inc. 1896 | 1965-05-27 | Conant & Company Public Relations, Inc. | Madrid | ||||
15672 | 15672 | 1969-12-31 | Spain Government | 1964-07-10 | SPAIN | Pendleton & McLaughlin 1743 | 1964-05-28 | Pendleton & McLaughlin | Madrid | ||||
15739 | 15739 | 1975-12-31 | Ministry of Tourism & Information (General Direction of Tourist Planning) (Spanish National Tourist Office) | 1974-10-01 | SPAIN | Robert L. Bliss, Inc. 2536 | 1974-10-01 | Robert L. Bliss, Inc. | Madrid | ||||
15789 | 15789 | 1977-12-31 | Government of Spain, Foreign Ministry | 1977-02-04 | SPAIN | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | Madrid | ||||
15804 | 15804 | 1978-12-31 | Hispanica de Petroleos, S.A. | 1971-08-13 | SPAIN | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Madrid | ||||
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 |
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]) );