FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
153 rows where Country/Location_Represented = "ITALY" and State = ""
This data as json, CSV (advanced)
Registrant_Name >30
- Ruder Finn, Inc. 4
- Dowd, Redfield & Johnstone, Inc. 3
- H. Montana Publicity Enterprises, Inc. 3
- Sestito, Larry A. 3
- Alikonis, Robert John 2
- Berti, Guiseppe 2
- Cohen & Aleshire, Inc. 2
- Dickstein Shapiro, LLP 2
- Donini, Ambrogio 2
- Filangiere Society for Justice and Good Government 2
- Kelly, Nason, Inc. 2
- Levine & Company 2
- Alenia of U.S.A., Inc. 1
- Andrews Associates, Inc. 1
- Appia Group LLC 1
- Arter, Hadden & Hemmendinger 1
- Association Films, Inc. 1
- Bartucci-Samuel, Inc. 1
- Bruce Rubin Associates, Inc. 1
- CIT Travel Service, Inc. 1
- Capitoline/MS&L 1
- Cassidy & Associates, Inc. 1
- Centofanti, Vincent 1
- Cox, Oscar S. 1
- Daniels, Houlihan & Palmeter 1
- Development & Resources Corporation 1
- EMB, Ltd. 1
- Edmiston, Homer 1
- Edwards, Jack 1
- Financial Consultants, Inc. 1
- …
Foreign_Principal >30
- Agusta Group 2
- Alderisi, Francesca 2
- Assessorato Turismo Regione Siciliana 2
- Ente Nazionale Italiano per il Turismo (ENIT) 2
- Fiart Cantieri Italiani, S.p.A. 2
- Fiat, S.p.A. 2
- International Garibaldi Alliance for the Liberty of Italy 2
- Mario Montagnana 2
- Unione Industriale Pratese 2
- Aeritalia S.A.I.P.A. 1
- Aermacchi, S.p.A. 1
- Agusta Aviation Corporation 1
- Al-Litalia Air Lines 1
- Alitalia 1
- Alitalia Airlines 1
- Ansaldo, S.p.A. 1
- Assessorato Turismo Regione Siciliana della Republica of Italy 1
- Assicurazione Nazionale Imprese Assicuratrici 1
- Banca Nazionale del Lavoro 1
- Bank of Italy 1
- Carloforte, S.R.L. 1
- Casa Musicale Sonzogno, Ltd. 1
- Cassa per Opere Straordinarie di Pubblico Interesse nell' Italia Meridionale 1
- Cassa per Operere Straordinarie di Pubblico Interesse Nell' Italia Meridionale (Cassa per il Mezzogiorno) 1
- Cassa per il Messogiorno 1
- Commercial Office of the Italian Consulate General 1
- Compagnia Italiana Turismo, S.A. (CIT) 1
- Consulate General of Italy (Commerical Office of the Italian Consulate General) 1
- ENTE - Nazionale Industrie Cinematografiche (ENIC) 1
- Embassy of Italy 1
- …
State 1
- - · 87 ✖
Country/Location_Represented 1
- ITALY · 87 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7065 | 7065 | 1988-05-31 | International Olive Oil Council | 1986-11-21 | ITALY | Bartucci-Samuel, Inc. 3909 | 1986-11-21 | Bartucci-Samuel, Inc. | Rome | ||||
7138 | 7138 | 1995-05-31 | Agusta Group | 1993-09-02 | ITALY | Capitoline/MS&L 4529 | 1991-06-20 | Capitoline/MS&L | Milano | ||||
7275 | 7275 | 2018-05-31 | Alderisi, Francesca | 2018-01-24 | ITALY | Gold, Daniel 6514 | 2018-01-24 | Gold, Daniel | |||||
7356 | 7356 | 1969-06-01 | Unione Industriale Pratese | 1968-09-17 | ITALY | Daniels, Houlihan & Palmeter 2072 | 1968-01-30 | Daniels, Houlihan & Palmeter | Prato | ||||
7515 | 7515 | 1960-06-03 | Commercial Office of the Italian Consulate General | 1959-12-03 | ITALY | Cohen & Aleshire, Inc. 1302 | 1959-12-03 | Cohen & Aleshire, Inc. | Rome | ||||
7516 | 7516 | 1960-06-03 | Ente Provinciale per il Turismo, Venezia (Venice Provincial Office for Tourism) | 1959-12-03 | ITALY | Cohen & Aleshire, Inc. 1302 | 1959-12-03 | Cohen & Aleshire, Inc. | Venice | ||||
7518 | 7518 | 1960-06-03 | Government of Italy | 1957-07-30 | ITALY | Moss, Edward K. 894 | 1955-06-03 | Moss, Edward K. | Rome | ||||
7554 | 7554 | 1952-06-04 | Compagnia Italiana Turismo, S.A. (CIT) | 1947-06-04 | ITALY | CIT Travel Service, Inc. 465 | 1947-06-04 | CIT Travel Service, Inc. | Rome | ||||
7846 | 7846 | 1993-06-15 | Saiedue Trade Fair | 1986-10-03 | ITALY | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | Milano | ||||
7879 | 7879 | 1994-06-16 | Government of Italy, Senator Giulio Andreotti | 1993-05-19 | ITALY | Hughes, Hubbard & Reed 4804 | 1993-05-19 | Hughes, Hubbard & Reed | Rome | ||||
7897 | 7897 | 1993-06-17 | ISMES | 1990-11-16 | ITALY | Murphy & Demory, Ltd. 4095 | 1988-03-03 | Murphy & Demory, Ltd. | Bergamo | ||||
8004 | 8004 | 1984-06-22 | Aeritalia S.A.I.P.A. | 1982-12-02 | ITALY | Willkie, Farr & Gallagher 3425 | 1982-12-02 | Willkie, Farr & Gallagher | |||||
8152 | 8152 | 1946-06-29 | ENTE - Nazionale Industrie Cinematografiche (ENIC) | 1945-06-29 | ITALY | Montana, Vanni Buscemi 307 | 1945-06-29 | Montana, Vanni Buscemi | Rome | ||||
8159 | 8159 | 1984-06-29 | Foundation for International Culture | 1983-04-26 | ITALY | Ruder, Finn & Rotman International Partners, Ltd. 3462 | 1983-04-26 | Ruder, Finn & Rotman International Partners, Ltd. | Milano | ||||
8168 | 8168 | 1990-06-29 | Fiat U.S.A., Inc. | 1988-01-27 | ITALY | Edwards, Jack 3958 | 1987-04-09 | Edwards, Jack | Torino | ||||
8245 | 8245 | 1963-06-30 | Government of the Republic of Italy (Ente Nazionale Italiano Turismo) | 1962-11-09 | ITALY | Martial & Company, Inc. 1535 | 1962-04-10 | Martial & Company, Inc. | Rome | ||||
8318 | 8318 | 1977-06-30 | Veneziani Zonca Vernici, S.p.A. | 1975-04-21 | ITALY | Grandi, Elio E. (Emil) 2577 | 1975-04-21 | Grandi, Elio E. (Emil) | |||||
8335 | 8335 | 1980-06-30 | Montefibre, S.p.A. | 1973-11-07 | ITALY | Needham, Harper & Steers Advertising, Inc. 1748 | 1964-06-03 | Needham, Harper & Steers Advertising, Inc. | Milan | ||||
8376 | 8376 | 1983-06-30 | Unione Industriale Pratese | 1967-03-20 | ITALY | Arter, Hadden & Hemmendinger 1001 | 1957-02-21 | Arter, Hadden & Hemmendinger | Prato | ||||
8450 | 8450 | 1990-06-30 | Agusta Aviation Corporation | 1988-05-02 | ITALY | Ginn, Edington, Wade & Sanders, Inc. 4134 | 1988-05-02 | Ginn, Edington, Wade & Sanders, Inc. | Milano | ||||
8457 | 8457 | 1990-06-30 | Fiat, S.p.A. | 1986-05-22 | ITALY | Dickstein Shapiro, LLP 3028 | 1979-06-07 | Dickstein Shapiro, LLP | Torino | ||||
8944 | 8944 | 2021-07-01 | Italian Trade Agency | 2018-12-06 | ITALY | GMJ Global, LLC 6612 | 2018-12-06 | GMJ Global, LLC | Via Liszt 21, 00144 | ROMA | |||
8962 | 8962 | 1987-07-02 | Selenia Industrie Electroniche Associate, S.P.A. | 1986-10-15 | ITALY | Mazzaglia, Enzo 3897 | 1986-10-15 | Mazzaglia, Enzo | Rome | ||||
9016 | 9016 | 1985-07-05 | Pietro Beretta, S.p.A. | 1980-12-02 | ITALY | Surrey & Morse 2649 | 1976-01-05 | Surrey & Morse | |||||
9553 | 9553 | 1952-07-28 | Cassa per Operere Straordinarie di Pubblico Interesse Nell' Italia Meridionale (Cassa per il Mezzogiorno) | 1952-02-29 | ITALY | Cox, Oscar S. 341 | 1946-01-28 | Cox, Oscar S. | Rome | ||||
9569 | 9569 | 1993-07-28 | Alitalia | 1983-09-30 | ITALY | Dickstein Shapiro, LLP 3028 | 1979-06-07 | Dickstein Shapiro, LLP | Rome | ||||
9601 | 9601 | 1968-07-30 | Ente Nazionale Di Assistenza Sociale | 1965-03-19 | ITALY | Sestito, Larry A. 935 | 1956-03-19 | Sestito, Larry A. | Rome | ||||
9602 | 9602 | 1968-07-30 | Movimento Sociale Italiano | 1956-03-19 | ITALY | Sestito, Larry A. 935 | 1956-03-19 | Sestito, Larry A. | Rome | ||||
9604 | 9604 | 1968-07-30 | Pino Romualdi | 1964-09-19 | ITALY | Sestito, Larry A. 935 | 1956-03-19 | Sestito, Larry A. | Rome | ||||
9675 | 9675 | 1964-07-31 | Incres Compagnia de Navigacion, S.A. | 1955-03-31 | ITALY | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Genoa | ||||
9683 | 9683 | 1964-07-31 | Lauro Lines/Polazzo Lauro | 1955-03-31 | ITALY | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Naples | ||||
9780 | 9780 | 1990-07-31 | Mirabella | 1989-12-01 | ITALY | Levine & Company 3971 | 1987-04-29 | Levine & Company | Caserta | ||||
9916 | 9916 | 2018-07-31 | Alderisi, Francesca | 2018-01-24 | ITALY | Filangiere Society for Justice and Good Government 6513 | 2018-01-24 | Filangiere Society for Justice and Good Government | |||||
9925 | 9925 | 2018-07-31 | Nissoli, Fucsia Fitzgerald | 2018-01-24 | ITALY | Filangiere Society for Justice and Good Government 6513 | 2018-01-24 | Filangiere Society for Justice and Good Government | Palazzo Mantecitorio | Rome | |||
10540 | 10540 | 2004-08-15 | Genoa 2004 (City of Genoa) | 2003-08-20 | ITALY | Appia Group LLC 5576 | 2003-08-20 | Appia Group LLC | Palazzo Ducale Piazza Matteotti, 9 Cortile Minore - 5th Floor 16123 Genoa | ||||
10896 | 10896 | 1977-08-31 | Ministro del Turismo e dello Spettacolo | 1964-06-02 | ITALY | McCann-Erickson, Inc. 1746 | 1964-06-02 | McCann-Erickson, Inc. | Rome | ||||
10903 | 10903 | 1981-08-31 | Al-Litalia Air Lines | 1965-06-29 | ITALY | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | Rome | ||||
11035 | 11035 | 1995-08-31 | Fontana Bleu, S.p.A. | 1994-09-21 | ITALY | Paul Magliocchetti Associates, Inc. 4949 | 1994-09-21 | Paul Magliocchetti Associates, Inc. | Pinetamare | ||||
11354 | 11354 | 1993-09-03 | Agusta Group | 1990-07-18 | ITALY | Moore, Powell A. 4402 | 1990-07-18 | Moore, Powell A. | Milano | ||||
11371 | 11371 | 1942-09-05 | Casa Musicale Sonzogno, Ltd. | 1942-09-05 | ITALY | Edmiston, Homer 119 | 1942-09-05 | Edmiston, Homer | Milan | ||||
11480 | 11480 | 1965-09-10 | Embassy of Italy | 1963-10-18 | ITALY | Robert R. Nathan Associates, Inc. 352 | 1946-04-22 | Robert R. Nathan Associates, Inc. | |||||
11555 | 11555 | 1945-09-13 | International Garibaldi Alliance for the Liberty of Italy | 1945-09-13 | ITALY | Donini, Ambrogio 321 | 1945-09-13 | Donini, Ambrogio | |||||
11556 | 11556 | 1945-09-13 | Mario Montagnana | 1945-09-13 | ITALY | Donini, Ambrogio 321 | 1945-09-13 | Donini, Ambrogio | |||||
11574 | 11574 | 1945-09-14 | International Garibaldi Alliance for the Liberty of Italy | 1945-09-14 | ITALY | Berti, Guiseppe 320 | 1945-09-14 | Berti, Guiseppe | |||||
11575 | 11575 | 1945-09-14 | Mario Montagnana | 1945-09-14 | ITALY | Berti, Guiseppe 320 | 1945-09-14 | Berti, Guiseppe | |||||
11605 | 11605 | 1962-09-15 | Bank of Italy | 1959-09-15 | ITALY | EMB, Ltd. 1270 | 1959-09-15 | EMB, Ltd. | Rome | ||||
11716 | 11716 | 1991-09-19 | Banca Nazionale del Lavoro | 1990-09-25 | ITALY | Rogers & Wells, LLP 3428 | 1982-12-10 | Rogers & Wells, LLP | Rome | ||||
11867 | 11867 | 1973-09-28 | Cassa per Opere Straordinarie di Pubblico Interesse nell' Italia Meridionale | 1956-10-01 | ITALY | Development & Resources Corporation 969 | 1956-08-02 | Development & Resources Corporation | |||||
11994 | 11994 | 1988-09-30 | Fiat, S.p.A. | 1986-04-22 | ITALY | Stroock & Stroock & Lavan 3816 | 1986-04-22 | Stroock & Stroock & Lavan | |||||
12032 | 12032 | 1991-09-30 | Partido Repubblicano Italiano | 1991-10-30 | ITALY | Susan Davis International & Public Affairs 3444 | 1983-02-16 | Susan Davis International & Public Affairs | Rome | ||||
12166 | 12166 | 2006-09-30 | Per L'Italia Nel Mondo Con Tremaglia | 2006-03-14 | ITALY | Centofanti, Vincent 5738 | 2006-03-14 | Centofanti, Vincent | Via Della Stellata 5 | Rome | |||
12846 | 12846 | 1969-10-19 | Harold T. Smith International, S.A. | 1963-07-15 | ITALY | Financial Consultants, Inc. 1544 | 1962-05-21 | Financial Consultants, Inc. | Rome | ||||
12869 | 12869 | 1983-10-20 | Italian Government Travel Office (ENIT), New York | 1981-04-02 | ITALY | Peter Rothholz Associates, Inc. 2830 | 1977-09-16 | Peter Rothholz Associates, Inc. | Rome | ||||
12943 | 12943 | 1944-10-23 | Luigi F. Marini | 1942-10-23 | ITALY | Goldfinger, William 147 | 1942-10-23 | Goldfinger, William | Florence | ||||
13064 | 13064 | 1987-10-27 | Ansaldo, S.p.A. | 1985-05-03 | ITALY | Alenia of U.S.A., Inc. 3399 | 1982-08-11 | Alenia of U.S.A., Inc. | |||||
13105 | 13105 | 1994-10-28 | Italian Trade Commission | 1980-04-16 | ITALY | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | |||||
13602 | 13602 | 1993-11-01 | Fondazione Umberto Severi | 1993-05-03 | ITALY | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | Carpi (Modena) | ||||
13955 | 13955 | 1949-11-15 | Societa Nazionale Dante Alighieri | 1948-11-15 | ITALY | Silvestrelli, Carlo 545 | 1948-11-15 | Silvestrelli, Carlo | Rome | ||||
14275 | 14275 | 1979-11-27 | Industria Prodotti Chimici | 1977-06-06 | ITALY | Alikonis, Robert John 2789 | 1977-06-06 | Alikonis, Robert John | |||||
14276 | 14276 | 1979-11-27 | Rumianca, S.p.A. | 1978-05-24 | ITALY | Alikonis, Robert John 2789 | 1977-06-06 | Alikonis, Robert John | Milano | ||||
14396 | 14396 | 1989-11-30 | Siciliana Appalti Costruzioni | 1989-10-30 | ITALY | Jefferson Group, Inc. 4139 | 1988-05-11 | Jefferson Group, Inc. | Catania | ||||
14434 | 14434 | 1992-11-30 | Aermacchi, S.p.A. | 1988-06-17 | ITALY | Levine & Company 3971 | 1987-04-29 | Levine & Company | Varese | ||||
14486 | 14486 | 1999-11-30 | Mr. Pier Francesco Guarguaglini, Managing Director OTO MELARA | 1994-05-20 | ITALY | SSB Enterprises 4916 | 1994-05-20 | SSB Enterprises | La Spezia | ||||
14691 | 14691 | 1988-12-01 | Fiart Cantieri Italiani, S.p.A. | 1988-06-22 | ITALY | Andrews Associates, Inc. 4062 | 1987-11-25 | Andrews Associates, Inc. | Baia | ||||
14744 | 14744 | 1954-12-02 | Cassa per il Messogiorno | 1952-12-05 | ITALY | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | Rome | ||||
14946 | 14946 | 1992-12-10 | Ferruzzi Finanziaria, S.p.A. | 1989-08-04 | ITALY | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Milano | ||||
15012 | 15012 | 1959-12-11 | Alitalia Airlines | 1958-09-12 | ITALY | Dowd, Redfield & Johnstone, Inc. 1169 | 1958-09-12 | Dowd, Redfield & Johnstone, Inc. | Rome | ||||
15013 | 15013 | 1959-12-11 | Consulate General of Italy (Commerical Office of the Italian Consulate General) | 1959-05-21 | ITALY | Dowd, Redfield & Johnstone, Inc. 1169 | 1958-09-12 | Dowd, Redfield & Johnstone, Inc. | Rome | ||||
15014 | 15014 | 1959-12-11 | Ente Provinciale per il Turismo, Venezia (Venice Provincial Office of Tourism) | 1959-05-21 | ITALY | Dowd, Redfield & Johnstone, Inc. 1169 | 1958-09-12 | Dowd, Redfield & Johnstone, Inc. | Venice | ||||
15056 | 15056 | 2019-12-12 | Via Campioni Inigo Trav. Prima 45, Lucca, Tuscany | 2019-12-08 | ITALY | Mediastrategia srl 6764 | 2019-12-08 | Mediastrategia srl | |||||
15099 | 15099 | 1984-12-14 | Carloforte, S.R.L. | 1984-12-14 | ITALY | Bruce Rubin Associates, Inc. 3635 | 1984-12-14 | Bruce Rubin Associates, Inc. | |||||
15178 | 15178 | 1942-12-17 | Italcable | 1942-12-17 | ITALY | Sansoni, Guido 164 | 1942-12-17 | Sansoni, Guido | Rome | ||||
15257 | 15257 | 1993-12-20 | Societa Cavi Pirelli, S.p.A. | 1989-05-25 | ITALY | Cassidy & Associates, Inc. 4259 | 1989-05-25 | Cassidy & Associates, Inc. | Milano | ||||
15404 | 15404 | 1982-12-27 | Assessorato Turismo Regione Siciliana della Republica of Italy | 1982-07-14 | ITALY | H. Montana Publicity Enterprises, Inc. 3389 | 1982-07-14 | H. Montana Publicity Enterprises, Inc. | |||||
15455 | 15455 | 2022-12-29 | Ministry of Tourism (via Italian National Tourist Board) | 2022-12-28 | ITALY | Wagstaff Worldwide Public Relations, Inc. 7179 | 2022-10-07 | Wagstaff Worldwide Public Relations, Inc. | Via Marghera, 2/6 00185 Rome | ||||
15785 | 15785 | 1977-12-31 | Assessorato Turismo Regione Siciliana | 1977-03-28 | ITALY | H. Montana Publicity Enterprises, Inc. 2764 | 1977-03-28 | H. Montana Publicity Enterprises, Inc. | Palermo | ||||
15813 | 15813 | 1979-12-31 | Assessorato Turismo Regione Siciliana | 1978-09-11 | ITALY | H. Montana Publicity Enterprises, Inc. 2966 | 1978-09-11 | H. Montana Publicity Enterprises, Inc. | Palermo | ||||
15863 | 15863 | 1981-12-31 | Movimento Freudiano Internazionale | 1981-06-16 | ITALY | Ruder & Finn International Partners, Ltd. 3247 | 1981-06-16 | Ruder & Finn International Partners, Ltd. | Milan | ||||
16262 | 16262 | 1994-12-31 | ISAGRO, S.R.L. Formerly Agrimont, S.R.L. | 1991-09-30 | ITALY | Jellinek, Schwartz & Connolly, Inc. 4345 | 1990-02-23 | Jellinek, Schwartz & Connolly, Inc. | Milano | ||||
16289 | 16289 | 1995-12-31 | Assicurazione Nazionale Imprese Assicuratrici | 1995-10-06 | ITALY | Hopkins & Sutter 4362 | 1990-04-11 | Hopkins & Sutter | Milano | ||||
16317 | 16317 | 1995-12-31 | Fiart Cantieri Italiani, S.p.A. | 1986-03-07 | ITALY | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Napoli | ||||
16319 | 16319 | 1995-12-31 | Fiat, S.p.A. (combined with Fiat Washington, Inc.) | 1986-05-16 | ITALY | Gold & Liebengood, Inc. 3700 | 1985-07-09 | Gold & Liebengood, Inc. | Turin | ||||
16325 | 16325 | 1995-12-31 | Giancarlo Parretti | 1995-12-12 | ITALY | Royer & Babyak 5086 | 1995-12-12 | Royer & Babyak | Rome | ||||
16525 | 16525 | 2002-12-31 | Rome Cavalien Hilton | 2002-06-07 | ITALY | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | Via Cadlolo, 101, 00136 Rome | ||||
16825 | 16825 | 2018-12-31 | Ente Nazionale Italiano per il Turismo (ENIT) | 1965-04-19 | ITALY | Italian Government Tourist Board (ENIT), Los Angeles 1884 | 1965-04-19 | Italian Government Tourist Board (ENIT), Los Angeles | Rome | ||||
16826 | 16826 | 2018-12-31 | Ente Nazionale Italiano per il Turismo (ENIT) | 1968-06-07 | ITALY | Italian Government Travel Office, Chicago 1892 | 1968-06-07 | Italian Government Travel Office, Chicago | Rome | ||||
16836 | 16836 | 2018-12-31 | Saro Spadaro | 2018-05-24 | ITALY | Sonoran Policy Group, LLC D/B/A Stryk Global Diplomacy 6399 | 2016-12-11 | Sonoran Policy Group, LLC D/B/A Stryk Global Diplomacy | Rhirie Road | Maho Bay |
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]) );