FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
80 rows where Address_1 = "Buenos Aires"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name >30
- Pendleton & McLaughlin 6
- Arnold & Porter Kaye Scholer LLP 4
- Boykin & De Francis 2
- Central Council of Croation Associations - U.S. & Canada 2
- Circle of the Croatian Knights 2
- Garcia & Diaz 2
- Hill and Knowlton Strategies, LLC 2
- Joyce Jr., William R. 2
- Klein & Saks 2
- Mudge, Rose, Guthrie, Alexander & Ferdon 2
- O'Connor & Hannan, L.L.P. 2
- Rendon Group, Inc. 2
- TKC International, Inc. 2
- Tea Council of the U.S.A., Inc. 2
- Argentine Trade Promotion Corporation 1
- Black, Helen 1
- Bronz & Farrell 1
- Buiar Grefe International 1
- Burson-Marsteller 1
- Cannon Advertising Associates, Inc. 1
- Caples Company 1
- Citigate, Inc. 1
- Confederacion General de Trabajadores de P. Rico-Autentica 1
- Culbertson, Pendleton & Pendleton 1
- DLA Piper US LLP 1
- Daniel J. Edelman, Inc. 1
- Davis, Manafort & Freedman 1
- Deane, Michael B. 1
- Equihua, Xavier 1
- FCB New York 1
- …
Foreign_Principal_Termination_Date (date) >30 ✖
- 1975-11-28 3
- 1989-12-31 3
- 1946-01-08 2
- 1956-01-29 2
- 1959-05-14 2
- 1961-06-03 2
- 1987-07-01 2
- 1995-01-31 2
- 1942-12-17 1
- 1943-02-01 1
- 1944-12-07 1
- 1946-12-07 1
- 1947-08-08 1
- 1951-09-11 1
- 1952-03-31 1
- 1953-01-20 1
- 1955-02-01 1
- 1955-08-19 1
- 1955-09-26 1
- 1958-12-31 1
- 1962-08-10 1
- 1965-05-28 1
- 1968-09-15 1
- 1970-02-28 1
- 1971-01-15 1
- 1971-02-01 1
- 1971-06-30 1
- 1971-10-30 1
- 1971-11-12 1
- 1975-02-25 1
- …
Foreign_Principal >30
- Centro Azucarero Argentino 4
- Yacimientos Petroliferos Fiscales 3
- Aerolineas Argentinas 2
- Centro Industrial de Laboratorios Farmaceuticos Argentinos (CILFA) 2
- Government of Argentina 2
- Junta Nacional de Carnes de la Republica Argentina 2
- Sociedad Mixta Siderurgia Argentina 2
- Union Industrial de Argentina 2
- A. Saadeh 1
- AFINOA 1
- Agencia Maritima 1
- Agencia Periodistica Argentina 1
- Agency for Investment Development 1
- Agora Centro de Estudios Internacionales (ACEI) 1
- Agrupacion de Trabajadores Latinoamericanos Sindicalistas (ATLAS) 1
- Alberto Pierri 1
- Argentine Airlines, Fama Service 1
- Argentine Businessmen Delegation 1
- Argentine Government 1
- Argentine Meat Board 1
- Argentine Republic 1
- Aspitarte y Cia 1
- Association for Cultural Interchange 1
- Banco Central de la Republica Argentina 1
- Camara de la Industria Aceitera de la Republica Argentina 1
- Camara de la Industria Aceitera de la Republica of Argentina 1
- Casa Fuentes, S.A.C.I.F.I. 1
- Centro Industrial de Laboratorios Farmaceuticos Argentinos 1
- Commission Against Hunger & Proverty 1
- Compania Italo, Argentina de Electricidad 1
- …
Country/Location_Represented 3
- ARGENTINA 77
- YUGOSLAVIA 2
- CROATIA 1
State 1
- - 80
City 1
- - 80
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
828 | 828 | 1979-01-01 | Association for Cultural Interchange | 1979-12-27 | ARGENTINA | Hannaford Company, Inc. 2850 | 1977-11-29 | Hannaford Company, Inc. | Buenos Aires | ||||
1136 | 1136 | 1946-01-08 | Agencia Maritima | 1944-08-04 | ARGENTINA | Garcia & Diaz 16 | 1942-07-08 | Garcia & Diaz | Buenos Aires | ||||
1150 | 1150 | 1946-01-08 | Sud Americana de Exportacion e Importacion S.R., Ltda. | 1943-03-09 | ARGENTINA | Garcia & Diaz 16 | 1942-07-08 | Garcia & Diaz | Buenos Aires | ||||
1248 | 1248 | 1994-01-12 | Liga de Amas de Casa | 1993-12-13 | ARGENTINA | Rendon Group, Inc. 4449 | 1990-12-17 | Rendon Group, Inc. | Buenos Aires | ||||
1314 | 1314 | 1971-01-15 | Junta Nacional de Carnes de la Republica Argentina | 1971-01-15 | ARGENTINA | Boykin & De Francis 2237 | 1971-01-15 | Boykin & De Francis | Buenos Aires | ||||
1422 | 1422 | 1953-01-20 | Instituto Argentino de Promocion del Intercambio | 1947-09-23 | ARGENTINA | Instituto Argentino de Promocion del Intercambio 489 | 1947-09-23 | Instituto Argentino de Promocion del Intercambio | Buenos Aires | ||||
1600 | 1600 | 1956-01-29 | Croatia - Croatian Information Service of the Croatian Government in Exile | 1955-03-09 | YUGOSLAVIA | Circle of the Croatian Knights 878 | 1955-03-09 | Circle of the Croatian Knights | Buenos Aires | ||||
1602 | 1602 | 1956-01-29 | Hrvatski Domobran - La Defensa del Hogar Croata | 1955-10-10 | YUGOSLAVIA | Circle of the Croatian Knights 878 | 1955-03-09 | Circle of the Croatian Knights | Buenos Aires | ||||
1786 | 1786 | 1995-01-31 | Fundacion del Hemisferio | 1993-09-17 | ARGENTINA | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Buenos Aires | ||||
1789 | 1789 | 1995-01-31 | International Law Association (Argentina Branch) | 1993-11-10 | ARGENTINA | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Buenos Aires | ||||
1948 | 1948 | 1943-02-01 | Organizacione Cinematografica de Representaciones Artisticas | 1943-03-12 | ARGENTINA | Pan-American Associated Enterprises 77 | 1942-08-01 | Pan-American Associated Enterprises | Buenos Aires | ||||
1957 | 1957 | 1955-02-01 | Slovak Liberation Committee | 1951-01-30 | ARGENTINA | Slovak Liberation Committee in the U.S. 658 | 1951-01-30 | Slovak Liberation Committee in the U.S. | Buenos Aires | ||||
1979 | 1979 | 1971-02-01 | Croatian Newspaper (Croatia Hrvatska) | 1959-03-23 | CROATIA | Sega, Milan 1212 | 1959-03-23 | Sega, Milan | Buenos Aires | ||||
2054 | 2054 | 1996-02-01 | ILVA Ceramica, S.A. | 1995-09-06 | ARGENTINA | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | Buenos Aires | ||||
2781 | 2781 | 1975-02-25 | Yacimientos Petroliferos Fiscales | 1970-12-08 | ARGENTINA | Pendleton & McLaughlin 1743 | 1964-05-28 | Pendleton & McLaughlin | Buenos Aires | ||||
2909 | 2909 | 1970-02-28 | Centro Azucarero Argentino | 1969-05-07 | ARGENTINA | Deane, Michael B. 2134 | 1969-05-07 | Deane, Michael B. | Buenos Aires | ||||
2965 | 2965 | 1991-02-28 | Centro Industrial de Laboratorios Farmaceuticos Argentinos | 1990-12-01 | ARGENTINA | Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 2530 | 1974-08-12 | Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. | Buenos Aires | ||||
3311 | 3311 | 1994-03-01 | Ministry of Agricultura of Argentina | 1993-09-21 | ARGENTINA | Bronz & Farrell 1740 | 1964-05-22 | Bronz & Farrell | Buenos Aires | ||||
3860 | 3860 | 1985-03-18 | Aerolineas Argentinas | 1965-12-14 | ARGENTINA | Cannon Advertising Associates, Inc. 1945 | 1965-12-14 | Cannon Advertising Associates, Inc. | Buenos Aires | ||||
4288 | 4288 | 1952-03-31 | Argentine Airlines, Fama Service | 1950-05-19 | ARGENTINA | Caples Company 34 | 1943-03-03 | Caples Company | Buenos Aires | ||||
4421 | 4421 | 1985-03-31 | Dalmine Siderca | 1984-05-21 | ARGENTINA | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Buenos Aires | ||||
4896 | 4896 | 1986-04-01 | Aerolineas Argentinas | 1978-08-06 | ARGENTINA | Van Brunt & Company Advertising-Marketing, Inc. 1704 | 1964-04-02 | Van Brunt & Company Advertising-Marketing, Inc. | Buenos Aires | ||||
4933 | 4933 | 1994-04-01 | Argentine Meat Board | 1978-10-25 | ARGENTINA | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | Buenos Aires | ||||
5093 | 5093 | 1985-04-08 | Rodolfo Recondo, S.A. & GEASA, S.A. | 1984-07-09 | ARGENTINA | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Buenos Aires | ||||
5127 | 5127 | 1975-04-10 | Centro Azucarero Argentino | 1974-03-06 | ARGENTINA | Joyce Jr., William R. 2503 | 1974-03-06 | Joyce Jr., William R. | Buenos Aires | ||||
5416 | 5416 | 1994-04-19 | World Trade Center of Buenos Aires (Through Parter Parter International, Inc.) | 1991-05-28 | ARGENTINA | Marcella Martinez Associates, Inc. 4349 | 1990-03-09 | Marcella Martinez Associates, Inc. | Buenos Aires | ||||
5509 | 5509 | 1981-04-24 | Government of Argentina | 1976-07-26 | ARGENTINA | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | Buenos Aires | ||||
5603 | 5603 | 1997-04-26 | Alberto Pierri | 1997-04-16 | ARGENTINA | Davis, Manafort & Freedman 5173 | 1997-04-16 | Davis, Manafort & Freedman | Buenos Aires | ||||
6479 | 6479 | 1995-05-12 | Argentine Republic | 1993-08-10 | ARGENTINA | van Kloberg & Associates, Ltd. 3466 | 1983-05-09 | van Kloberg & Associates, Ltd. | Buenos Aires | ||||
6522 | 6522 | 1959-05-14 | Croatia - Hrvatska | 1959-03-23 | ARGENTINA | Central Council of Croation Associations - U.S. & Canada 1180 | 1958-10-06 | Central Council of Croation Associations - U.S. & Canada | Buenos Aires | ||||
6523 | 6523 | 1959-05-14 | Croation Liberation Movement | 1958-10-06 | ARGENTINA | Central Council of Croation Associations - U.S. & Canada 1180 | 1958-10-06 | Central Council of Croation Associations - U.S. & Canada | Buenos Aires | ||||
6715 | 6715 | 1992-05-22 | Argentine Businessmen Delegation | 1991-12-10 | ARGENTINA | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | Buenos Aires | ||||
6830 | 6830 | 1995-05-25 | Centro Industrial de Laboratorios Farmaceuticos Argentinos (CILFA) | 1992-10-08 | ARGENTINA | Rendon Group, Inc. 4449 | 1990-12-17 | Rendon Group, Inc. | Buenos Aires | ||||
6884 | 6884 | 1965-05-28 | Direccion General de Fabricaciones Militares | 1964-05-28 | ARGENTINA | Pendleton & McLaughlin 1743 | 1964-05-28 | Pendleton & McLaughlin | Buenos Aires | ||||
6982 | 6982 | 1991-05-30 | Petroquimica Rio Tecero, S.A. | 1990-07-26 | ARGENTINA | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | Buenos Aires | ||||
7139 | 7139 | 1995-05-31 | Fernando Marin Radical Party of Argentina | 1995-05-12 | ARGENTINA | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | Buenos Aires | ||||
7429 | 7429 | 1996-06-01 | Wenceslao Bunge | 1995-12-14 | ARGENTINA | Tybrett Company 5087 | 1995-12-14 | Tybrett Company | Buenos Aires | ||||
7524 | 7524 | 1961-06-03 | Hurlingham, S.A. | 1960-02-11 | ARGENTINA | Klein & Saks 1234 | 1959-06-03 | Klein & Saks | Buenos Aires | ||||
7525 | 7525 | 1961-06-03 | Materprim Argentina, S.A. | 1960-02-11 | ARGENTINA | Klein & Saks 1234 | 1959-06-03 | Klein & Saks | Buenos Aires | ||||
7734 | 7734 | 1994-06-10 | Council of Deputies of the Province of Buenos Aires | 1994-04-22 | ARGENTINA | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Buenos Aires | ||||
7833 | 7833 | 1989-06-15 | Agora Centro de Estudios Internacionales (ACEI) | 1988-10-13 | ARGENTINA | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell | Buenos Aires | ||||
8284 | 8284 | 1971-06-30 | Junta Nacional de Carnes de la Republica Argentina | 1969-06-20 | ARGENTINA | Boykin & De Francis 2146 | 1969-06-20 | Boykin & De Francis | Buenos Aires | ||||
8865 | 8865 | 1987-07-01 | Camara de la Industria Aceitera de la Republica Argentina | 1986-07-17 | ARGENTINA | Mudge, Rose, Guthrie, Alexander & Ferdon 3200 | 1981-02-18 | Mudge, Rose, Guthrie, Alexander & Ferdon | Buenos Aires | ||||
8866 | 8866 | 1987-07-01 | Camara de la Industria Aceitera de la Republica of Argentina | 1986-06-07 | ARGENTINA | Fasturn, Inc. 2944 | 1978-08-09 | Fasturn, Inc. | Buenos Aires | ||||
9142 | 9142 | 1996-07-09 | Enrique Antonini | 1996-04-12 | ARGENTINA | Shrum, Devine & Donilon 5106 | 1996-04-12 | Shrum, Devine & Donilon | Buenos Aires | ||||
9396 | 9396 | 1991-07-21 | Congresos Internacionales, S.A., for World Trade Center of Buenos Aires, | 1991-05-20 | ARGENTINA | Parter International, Inc. 4514 | 1991-05-20 | Parter International, Inc. | Buenos Aires | ||||
9824 | 9824 | 1998-07-31 | Agency for Investment Development | 1999-01-07 | ARGENTINA | Zemi Communications, L.L.C. 5120 | 1996-07-01 | Zemi Communications, L.L.C. | Buenos Aires | ||||
10195 | 10195 | 1947-08-08 | Corporacion para la Promocion del Intercambio, S.A. | 1945-08-08 | ARGENTINA | Argentine Trade Promotion Corporation 314 | 1945-08-08 | Argentine Trade Promotion Corporation | Buenos Aires | ||||
10249 | 10249 | 1962-08-10 | Sociedad Mixta Siderurgia Argentina | 1950-08-10 | ARGENTINA | Culbertson, Pendleton & Pendleton 637 | 1950-08-10 | Culbertson, Pendleton & Pendleton | Buenos Aires | ||||
10529 | 10529 | 1992-08-15 | S.A. San Miguel | 1990-08-28 | ARGENTINA | L.A. Motley & Company 3723 | 1985-08-15 | L.A. Motley & Company | Buenos Aires | ||||
10609 | 10609 | 1955-08-19 | Agencia Periodistica Argentina | 1954-08-19 | ARGENTINA | Marin, Amador A. 840 | 1954-08-19 | Marin, Amador A. | Buenos Aires | ||||
11501 | 11501 | 1951-09-11 | Olga de Wolkonsky | 1949-08-05 | ARGENTINA | Black, Helen 6 | 1942-07-06 | Black, Helen | Buenos Aires | ||||
11620 | 11620 | 1968-09-15 | Yacimientos Petroliferos Fiscales | 1964-05-28 | ARGENTINA | Pendleton & McLaughlin 1743 | 1964-05-28 | Pendleton & McLaughlin | Buenos Aires | ||||
11823 | 11823 | 1955-09-26 | Agrupacion de Trabajadores Latinoamericanos Sindicalistas (ATLAS) | 1955-09-26 | ARGENTINA | Confederacion General de Trabajadores de P. Rico-Autentica 914 | 1955-09-26 | Confederacion General de Trabajadores de P. Rico-Autentica | Buenos Aires | ||||
11861 | 11861 | 1993-09-27 | Propulsora Siderurgica | 1993-06-10 | ARGENTINA | Mudge, Rose, Guthrie, Alexander & Ferdon 3200 | 1981-02-18 | Mudge, Rose, Guthrie, Alexander & Ferdon | Buenos Aires | ||||
11988 | 11988 | 1987-09-30 | Yacimientos Petroliferos Fiscales | 1987-05-26 | ARGENTINA | Buiar Grefe International 3985 | 1987-05-26 | Buiar Grefe International | Buenos Aires | ||||
12100 | 12100 | 1999-09-30 | AFINOA | 1997-04-30 | ARGENTINA | Equihua, Xavier 5039 | 1995-08-07 | Equihua, Xavier | Buenos Aires | ||||
13097 | 13097 | 1988-10-28 | Union Industrial de Argentina | 1988-06-17 | ARGENTINA | National Strategies & Marketing Group, Inc. 4040 | 1987-09-22 | National Strategies & Marketing Group, Inc. | Buenos Aires | ||||
13152 | 13152 | 1971-10-30 | Centro Azucarero Argentino | 1971-01-06 | ARGENTINA | Orfila, Alejandro 2234 | 1971-01-06 | Orfila, Alejandro | Buenos Aires | ||||
13759 | 13759 | 1990-11-06 | Extrader, S.A. | 1990-07-02 | ARGENTINA | Sylvester Lukis & Associates, P.C. 4392 | 1990-07-02 | Sylvester Lukis & Associates, P.C. | Buenos Aires | ||||
13892 | 13892 | 1971-11-12 | Centro Azucarero Argentino | 1971-01-06 | ARGENTINA | Joyce Jr., William R. 2235 | 1971-01-06 | Joyce Jr., William R. | Buenos Aires | ||||
13985 | 13985 | 1989-11-15 | Union Industrial de Argentina | 1988-06-15 | ARGENTINA | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | Buenos Aires | ||||
14044 | 14044 | 1992-11-17 | Fernando Marin, S.A. | 1991-04-10 | ARGENTINA | FCB New York 2415 | 1973-03-28 | FCB New York | Buenos Aires | ||||
14284 | 14284 | 1975-11-28 | Argentine Government | 1964-05-28 | ARGENTINA | Pendleton & McLaughlin 1743 | 1964-05-28 | Pendleton & McLaughlin | Buenos Aires | ||||
14286 | 14286 | 1975-11-28 | Republic of Argentina | 1967-12-18 | ARGENTINA | Pendleton & McLaughlin 1743 | 1964-05-28 | Pendleton & McLaughlin | Buenos Aires | ||||
14287 | 14287 | 1975-11-28 | Sociedad Mixta Siderurgia Argentina | 1964-05-28 | ARGENTINA | Pendleton & McLaughlin 1743 | 1964-05-28 | Pendleton & McLaughlin | Buenos Aires | ||||
14802 | 14802 | 1991-12-04 | Government of Argentina | 1991-06-20 | ARGENTINA | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Buenos Aires | ||||
14851 | 14851 | 1944-12-07 | Dr. Adrian C. Escobar | 1944-12-07 | ARGENTINA | Frampton, Merle Elbert 285 | 1944-12-07 | Frampton, Merle Elbert | Buenos Aires | ||||
14854 | 14854 | 1946-12-07 | A. Saadeh | 1943-04-23 | ARGENTINA | Syrian National Party in the U.S. 32 | 1942-07-24 | Syrian National Party in the U.S. | Buenos Aires | ||||
15177 | 15177 | 1942-12-17 | Compania Italo, Argentina de Electricidad | 1942-12-17 | ARGENTINA | Sansoni, Guido 164 | 1942-12-17 | Sansoni, Guido | Buenos Aires | ||||
15211 | 15211 | 1995-12-18 | Commission Against Hunger & Proverty | 1995-12-18 | ARGENTINA | Citigate, Inc. 5089 | 1995-12-18 | Citigate, Inc. | Buenos Aires | ||||
15443 | 15443 | 1993-12-29 | Banco Central de la Republica Argentina | 1982-05-07 | ARGENTINA | Weil, Gotshal & Manges, L.L.P. 3317 | 1981-12-29 | Weil, Gotshal & Manges, L.L.P. | Buenos Aires | ||||
15469 | 15469 | 1978-12-30 | Telam, S.A. | 1976-12-29 | ARGENTINA | Nu-Line Advertising Service, Inc. 2743 | 1976-12-29 | Nu-Line Advertising Service, Inc. | Buenos Aires | ||||
15588 | 15588 | 1958-12-31 | Republic of Argentina (Through Argentine Embassy) | 1958-01-07 | ARGENTINA | LeBoeuf, Lamb & Leiby 1100 | 1958-01-07 | LeBoeuf, Lamb & Leiby | Buenos Aires | ||||
16094 | 16094 | 1989-12-31 | Aspitarte y Cia | 1984-02-01 | ARGENTINA | Tea Council of the U.S.A., Inc. 1853 | 1965-02-10 | Tea Council of the U.S.A., Inc. | Buenos Aires | ||||
16101 | 16101 | 1989-12-31 | Casa Fuentes, S.A.C.I.F.I. | 1984-02-01 | ARGENTINA | Tea Council of the U.S.A., Inc. 1853 | 1965-02-10 | Tea Council of the U.S.A., Inc. | Buenos Aires | ||||
16104 | 16104 | 1989-12-31 | Convivencia Foundation | 1989-03-09 | ARGENTINA | KRV International Group, Inc. 4177 | 1988-09-21 | KRV International Group, Inc. | Buenos Aires | ||||
16301 | 16301 | 1995-12-31 | Centro Industrial de Laboratorios Farmaceuticos Argentinos (CILFA) | 1995-06-02 | ARGENTINA | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | Buenos Aires | ||||
16442 | 16442 | 1998-12-31 | Ministerio del Interior Unidad Ejectiva de Programas Especiales (U.E.P.E.) | 1997-12-15 | ARGENTINA | Napolitano, Francisco 5219 | 1997-12-15 | Napolitano, Francisco | Buenos Aires | ||||
16489 | 16489 | 2000-12-31 | The Secretary of Intelligence of Argentina | 2000-06-15 | ARGENTINA | IKON Public Affairs 5374 | 2000-06-15 | IKON Public Affairs | Buenos Aires |
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]) );