FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
178 rows where Country/Location_Represented = "GERMANY" sorted by Registration_Number
This data as json, CSV (advanced)
Registrant_Name >30
- Trombone Associates, Inc. 7
- TransAtlantic Futures, Inc. 6
- West Glen Communications 3
- APCO Worldwide, Inc. 2
- Bavarian Office for Trade, Investment, Research and Technology 2
- Hanseatic Institute Inc. 2
- Pordzik, Wolfgang G. 2
- Representative of German Industry and Trade 2
- Wiggin and Dana LLP 2
- APCO Worldwide LLC 1
- Agnew, Carter, McCarthy, Inc. 1
- Audience Partners Worldwide LLC 1
- Baker & Hostetler 1
- Baker & McKenzie 1
- Baker Botts L.L.P. 1
- Bavarian Ministry for Economic Affairs, Infrastructure, Transport and Technology 1
- Bavarian U.S. Offices for Economic Development, LLC 1
- Brock Group 1
- Carlberg & Associates, Inc. 1
- Chlopak, Leonard, Schechter & Associates, Inc. 1
- Daimler-Benz Washington, Inc. 1
- Daimler-Chrysler Aerospace of North America, Inc. 1
- Delegation of German Industry and Commerce in Washington DC, LLC 1
- Deutsche Telekom, Inc. 1
- Ervin Technical Associates, Inc. 1
- Foundation for a Christian Civilization, Inc. 1
- GPC International 1
- Gibson, Dunn & Crutcher 1
- Global Communicators/ Harff Communications, Inc. 1
- Hand, Arendall, Bedsole, Greaves & Johnson 1
- …
Foreign_Principal >30
- Brita GmbH 2
- Daimler-Benz, A.G. 2
- Federal Republic of Germany 2
- German National Tourist Office 2
- Lufthansa German Airlines 2
- Panavia GmbH 2
- Baden Wurttemberg Agency for Economic Development 1
- Baden-Wuerttemberg Agency for International Economic Cooperation, GWZ 1
- Bavarian Ministry for Economic Affairs, Infrastructure, Transport and Technology 1
- Bavarian Ministry of Economic Affairs, Infrastructure, Transport and Technology 1
- Bayer, A.G. 1
- Bayern International 1
- Bayern MIT 1
- Berlin 2000 Olympia GmbH 1
- Berlin Economic Development Corporation 1
- Berlin Tourismus Marketing GmbH 1
- Bernd Linke - Breman Business International 1
- Bundesministerium der Finanzen (BMF) 1
- Bundesministerium fur Wirtschaft 1
- Bundesverband Deutscher Banken, E.V. (Association of German Banks) 1
- Bundesverband der Deutschen Industrie e.V. Federation of German Industries 1
- Charta Estates 1
- City of Kaiserslautern, FRG 1
- DAB-EUREKA 147 Project Office 1
- DIHK DEinternational GmbH 1
- Daimler-Benz Aerospace, A.G. 1
- Daimler-Chrysler Aerospace , A. C. (formerly Daimler-Benz Aerospace,A.C.) 1
- Department of Business Development City of Leipzig (Dr. M. Schimansky, Acting Head) 1
- Deutsche Bahn AG - DB US Holding Corporation 1
- Deutsche Bank Research GmbH 1
- …
Country/Location_Represented 1
- GERMANY · 78 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2222 | 2222 | 1993-02-05 | Lufthansa German Airlines | 1988-11-23 | GERMANY | West Glen Communications 4191 | 1988-11-23 | West Glen Communications | East Meadow | NY | |||
13401 | 13401 | 2001-10-31 | Federal Republic of Germany | 1988-11-23 | GERMANY | West Glen Communications 4191 | 1988-11-23 | West Glen Communications | Washington | DC | |||
14200 | 14200 | 2003-11-23 | German Information Center | 1988-11-23 | GERMANY | West Glen Communications 4191 | 1988-11-23 | West Glen Communications | NY | ||||
1479 | 1479 | 1997-01-23 | MAN Roland Druckmaschinen AG (Man Roland) | 1996-08-29 | GERMANY | Shearman & Sterling 4208 | 1989-01-23 | Shearman & Sterling | Augsburg | ||||
10563 | 10563 | 1993-08-16 | Baden Wurttemberg Agency for Economic Development | 1992-02-11 | GERMANY | Marston Webb & Associates, Inc. 4209 | 1989-01-24 | Marston Webb & Associates, Inc. | Stuttgart | ||||
250 | 250 | Federation of German Industries (Bundesverband der Deutschen Industrie, BDI) | 1989-07-21 | GERMANY | Representative of German Industry and Trade 4274 | 1989-07-21 | Representative of German Industry and Trade | Bonn | |||||
261 | 261 | German Chamber of Commerce and Industry (Deutsche Industrieund Handelskammer, DIHK) | 1989-07-21 | GERMANY | Representative of German Industry and Trade 4274 | 1989-07-21 | Representative of German Industry and Trade | Bonn | |||||
5933 | 5933 | 1993-04-30 | Bundesverband der Deutschen Industrie e.V. Federation of German Industries | 1989-09-15 | GERMANY | Baker Botts L.L.P. 4293 | 1989-09-15 | Baker Botts L.L.P. | Koln | ||||
5296 | 5296 | 1994-04-15 | MIP Instandsetzungsbetriebe GmbH | 1989-09-26 | GERMANY | Ervin Technical Associates, Inc. 4296 | 1989-09-26 | Ervin Technical Associates, Inc. | Mainz-Mombach | ||||
13358 | 13358 | 1996-10-31 | Federal Republic of Germany, Ministry of Economics | 1992-08-04 | GERMANY | Brock Group 4310 | 1989-10-23 | Brock Group | Bonn | ||||
2598 | 2598 | 1993-02-16 | Bundesministerium fur Wirtschaft | 1992-08-04 | GERMANY | TransAtlantic Futures, Inc. 4353 | 1990-03-16 | TransAtlantic Futures, Inc. | Bonn | ||||
4526 | 4526 | 1993-03-31 | Deutsche Bank, A.G. | 1990-03-16 | GERMANY | TransAtlantic Futures, Inc. 4353 | 1990-03-16 | TransAtlantic Futures, Inc. | Frankfurt | ||||
10847 | 10847 | 1993-08-30 | Deutsche Bank Research GmbH | 1992-07-15 | GERMANY | TransAtlantic Futures, Inc. 4353 | 1990-03-16 | TransAtlantic Futures, Inc. | Frankfurt | ||||
10852 | 10852 | 1993-08-30 | Thuringia Economic Development Agency | 1993-04-17 | GERMANY | TransAtlantic Futures, Inc. 4353 | 1990-03-16 | TransAtlantic Futures, Inc. | Erfurt | ||||
12047 | 12047 | 1993-09-30 | Berlin 2000 Olympia GmbH | 1993-06-29 | GERMANY | TransAtlantic Futures, Inc. 4353 | 1990-03-16 | TransAtlantic Futures, Inc. | Berlin | ||||
10013 | 10013 | 1991-08-01 | Bayer, A.G. | 1991-07-10 | GERMANY | Baker & Hostetler 4371 | 1990-04-30 | Baker & Hostetler | Wuppertal | ||||
1561 | 1561 | 1995-01-27 | Muenchener Rueckversicherungs - Gesellschaft (Munich, Reinsurance Company) | 1990-06-20 | GERMANY | Munich-American Reinsurance Company 4388 | 1990-06-20 | Munich-American Reinsurance Company | Munich | ||||
10527 | 10527 | 1991-08-15 | Daimler-Benz, A.G. | 1990-07-10 | GERMANY | Imus, Richard H. 4395 | 1990-07-10 | Imus, Richard H. | Stuttgart | ||||
8486 | 8486 | 1991-06-30 | Panavia GmbH | 1990-06-29 | GERMANY | Hand, Arendall, Bedsole, Greaves & Johnson 4396 | 1990-06-29 | Hand, Arendall, Bedsole, Greaves & Johnson | Munich | ||||
9792 | 9792 | 1991-07-31 | Panavia GmbH | 1991-03-04 | GERMANY | Moore, Powell A. 4402 | 1990-07-18 | Moore, Powell A. | Munich | ||||
13356 | 13356 | 1996-10-31 | City of Kaiserslautern, FRG | 1990-10-05 | GERMANY | Kerr, John G. 4418 | 1990-10-05 | Kerr, John G. | Kaiserslautern | ||||
145 | 145 | Deutsche Telekom, A.G. (formerly: Deutsche Bundespost Telekom) | 1990-10-09 | GERMANY | Deutsche Telekom, Inc. 4419 | 1990-10-09 | Deutsche Telekom, Inc. | Friedrich-Ebert-Allee 140 | 53113 | Bonn | |||
5864 | 5864 | 1991-04-30 | DAB-EUREKA 147 Project Office | 1990-11-14 | GERMANY | Torick, Emil L. 4435 | 1990-11-14 | Torick, Emil L. | Koln-Porz | ||||
12372 | 12372 | 1991-10-01 | Messerschmitt-Boelkow-Blohm GmbH | 1990-12-17 | GERMANY | Law Offices of Jonathan W. Cuneo 4448 | 1990-12-17 | Law Offices of Jonathan W. Cuneo | Munich | ||||
16308 | 16308 | 1995-12-31 | Daimler-Benz, A.G. | 1991-03-14 | GERMANY | Daimler-Benz Washington, Inc. 4485 | 1991-03-14 | Daimler-Benz Washington, Inc. | Stuttgart | ||||
941 | 941 | 1992-01-01 | Bundesverband Deutscher Banken, E.V. (Association of German Banks) | 1991-08-08 | GERMANY | Gibson, Dunn & Crutcher 4552 | 1991-08-08 | Gibson, Dunn & Crutcher | Koeln | ||||
7941 | 7941 | 2003-06-19 | Government of Germany, Embassy | 2003-06-06 | GERMANY | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 4645 Resevoir Road, N.W. 20007 | DC | |||
13631 | 13631 | 2008-11-01 | German Federal Ministry for the Environment, Nuclear Safety, and Nature Conservation | 2008-07-18 | GERMANY | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | Alexanderstrape 3 | 10178 | Berlin | ||
14172 | 14172 | 1994-11-22 | Intermedia Filmvertrieb | 1991-10-22 | GERMANY | JD Communikaters, Inc. 4579 | 1991-10-22 | JD Communikaters, Inc. | Hamburg | ||||
8898 | 8898 | 1993-07-01 | Munchener Ruckuersicherungs - Gesellschaft | 1992-12-18 | GERMANY | Baker & McKenzie 4591 | 1991-11-12 | Baker & McKenzie | Munich | ||||
2042 | 2042 | 1992-02-01 | Charta Estates | 1991-12-06 | GERMANY | Trombone Associates, Inc. 4601 | 1991-12-06 | Trombone Associates, Inc. | Rheingau | ||||
3379 | 3379 | 1994-03-02 | Penta Hotel - Managementgesellschaft mgH | 1991-12-06 | GERMANY | Trombone Associates, Inc. 4601 | 1991-12-06 | Trombone Associates, Inc. | Berlin | ||||
3380 | 3380 | 1994-03-02 | Transocean PassagierDienst GmbH d/b/a Transocean Tours | 1993-02-22 | GERMANY | Trombone Associates, Inc. 4601 | 1991-12-06 | Trombone Associates, Inc. | Bremen | ||||
5519 | 5519 | 1992-04-24 | Kempinski International | 1991-12-06 | GERMANY | Trombone Associates, Inc. 4601 | 1991-12-06 | Trombone Associates, Inc. | New York | NY | |||
16351 | 16351 | 1995-12-31 | Lufthansa German Airlines | 1991-12-06 | GERMANY | Trombone Associates, Inc. 4601 | 1991-12-06 | Trombone Associates, Inc. | New York | NY | |||
16455 | 16455 | 1999-12-31 | German Convention Bureau | 1991-12-06 | GERMANY | Trombone Associates, Inc. 4601 | 1991-12-06 | Trombone Associates, Inc. | East Meadow | NY | |||
16456 | 16456 | 1999-12-31 | German National Tourist Office | 1991-12-06 | GERMANY | Trombone Associates, Inc. 4601 | 1991-12-06 | Trombone Associates, Inc. | New York | NY | |||
13385 | 13385 | 1999-10-31 | Daimler-Benz Aerospace, A.G. | 1992-10-09 | GERMANY | Daimler-Chrysler Aerospace of North America, Inc. 4719 | 1992-10-09 | Daimler-Chrysler Aerospace of North America, Inc. | Munich | ||||
6831 | 6831 | 1995-05-25 | Gesellschaft fuer Wirtschaftsfoerderung Nordrhein-Westfalen mbH (Economic Development Corporation NRW) | 1993-09-27 | GERMANY | Kilgore, Donald E. 4851 | 1993-09-27 | Kilgore, Donald E. | Dusseldorf | ||||
2245 | 2245 | 1995-02-06 | Bernd Linke - Breman Business International | 1993-09-27 | GERMANY | Agnew, Carter, McCarthy, Inc. 4915 | 1993-09-27 | Agnew, Carter, McCarthy, Inc. | Bremen | ||||
11028 | 11028 | 1994-08-31 | Berlin Tourismus Marketing GmbH | 1994-08-29 | GERMANY | InterMarketing, Ltd. 4940 | 1994-08-29 | InterMarketing, Ltd. | Berlin | ||||
16418 | 16418 | 1997-12-31 | Hoechst Marion Roussel Deutschland GmbH | 1997-09-11 | GERMANY | Chlopak, Leonard, Schechter & Associates, Inc. 4953 | 1994-09-28 | Chlopak, Leonard, Schechter & Associates, Inc. | Bad Soden | ||||
8902 | 8902 | 1995-07-01 | Government of Rheinland-Pfalz | 1994-12-13 | GERMANY | Vedder, Price, Kaufman, Kammholz & Day 4980 | 1994-12-13 | Vedder, Price, Kaufman, Kammholz & Day | Mainz | ||||
10695 | 10695 | 1996-08-23 | Department of Business Development City of Leipzig (Dr. M. Schimansky, Acting Head) | 1995-07-21 | GERMANY | Carlberg & Associates, Inc. 5037 | 1995-07-21 | Carlberg & Associates, Inc. | Leipzig | ||||
16547 | 16547 | 2004-12-31 | Baden-Wuerttemberg Agency for International Economic Cooperation, GWZ | 1996-03-11 | GERMANY | Moltzan, Gunter W. 5098 | 1996-03-11 | Moltzan, Gunter W. | Stuttgart | ||||
5501 | 5501 | 2003-04-23 | Daimler-Chrysler Aerospace , A. C. (formerly Daimler-Benz Aerospace,A.C.) | 1996-08-07 | GERMANY | Pierson & Burnett, L.L.P. 5127 | 1996-08-07 | Pierson & Burnett, L.L.P. | Bremen | ||||
13806 | 13806 | 1999-11-07 | Brita GmbH | 1999-03-02 | GERMANY | Powell Tate, Inc. 5148 | 1996-12-30 | Powell Tate, Inc. | Taunusstein | ||||
9834 | 9834 | 2001-07-31 | Deutsche Post AG | 2000-04-19 | GERMANY | Pordzik, Wolfgang G. 5192 | 1997-07-14 | Pordzik, Wolfgang G. | Bonn | ||||
11057 | 11057 | 1998-08-31 | Expo 2000 - General Kommissariat | 1997-07-14 | GERMANY | Pordzik, Wolfgang G. 5192 | 1997-07-14 | Pordzik, Wolfgang G. | Berlin | ||||
13619 | 13619 | 2000-11-01 | Brita GmbH | 1999-12-10 | GERMANY | Shandwick Public Affairs, Inc. 5220 | 1997-12-17 | Shandwick Public Affairs, Inc. | Taunusstein | ||||
4596 | 4596 | 2001-03-31 | Hamburg Business Development Corporation | 1999-03-31 | GERMANY | Global Communicators/ Harff Communications, Inc. 5241 | 1998-03-05 | Global Communicators/ Harff Communications, Inc. | Hamburger Strasse 11 D 22083 | ||||
3448 | 3448 | 2008-03-04 | German Insurance Association | 2008-03-04 | GERMANY | Strategy XXI Group, Ltd. 5273 | 1998-09-01 | Strategy XXI Group, Ltd. | Head of Department Foreign Affairs | Wilhelmstrabe 43 G | Berlin | ||
16475 | 16475 | 2000-12-31 | Berlin Economic Development Corporation | 1998-12-29 | GERMANY | Southern Energy Resources, Inc. 5295 | 1998-12-29 | Southern Energy Resources, Inc. | Berlin | ||||
16528 | 16528 | 2003-12-31 | Bayern MIT | 2000-09-01 | GERMANY | Bavarian Office for Trade, Investment, Research and Technology 5381 | 2000-09-01 | Bavarian Office for Trade, Investment, Research and Technology | Am Messesee 2 D-81829 Munchen | ||||
16578 | 16578 | 2005-12-31 | Bayern International | 2004-08-24 | GERMANY | Bavarian Office for Trade, Investment, Research and Technology 5381 | 2000-09-01 | Bavarian Office for Trade, Investment, Research and Technology | Am Messess 2 | ||||
16476 | 16476 | 2000-12-31 | Bundesministerium der Finanzen (BMF) | 2000-09-22 | GERMANY | TransAtlantic Futures, Inc. 5383 | 2000-09-22 | TransAtlantic Futures, Inc. | Wilhelmslvasse 97 D- 10117 Berlin | ||||
13621 | 13621 | 2000-11-01 | gecco.net AG | 2000-10-13 | GERMANY | Hanseatic Institute Inc. 5391 | 2000-10-13 | Hanseatic Institute Inc. | 10117 Berlin | ||||
14718 | 14718 | 2000-12-01 | Telegate Inc. | 2000-10-13 | GERMANY | Hanseatic Institute Inc. 5391 | 2000-10-13 | Hanseatic Institute Inc. | 82152 Martinsvied | ||||
5521 | 5521 | 2003-04-24 | Deutsche Bank, AG, New York Branch | 2003-07-03 | GERMANY | Van Scoyoc Associates, Inc. 5401 | 2000-12-14 | Van Scoyoc Associates, Inc. | 1301 Avenue of the Americas New York 10019 | NY | |||
4613 | 4613 | 2003-03-31 | Economic Development Authority of Nordrhein-Westfalen | 2001-03-23 | GERMANY | GPC International 5421 | 2001-03-23 | GPC International | Karalleriestrasse 8-10 D-40213 Dusseldorf | ||||
12648 | 12648 | 2004-10-13 | Embassy of Germany | 2002-10-18 | GERMANY | Mindshare Interactive Campaigns, LLC 5525 | 2002-10-18 | Mindshare Interactive Campaigns, LLC | 4645 Reservoir Road N.W. 20007-1998 | DC | |||
12151 | 12151 | 2004-09-30 | Embassy of the Federal Republic of Germany | 2003-10-02 | GERMANY | Weber Shandwick, Inc. 5579 | 2003-10-02 | Weber Shandwick, Inc. | 4645 Reservoir Road, N.W. 20007-1998 | DC | |||
16673 | 16673 | 2010-12-31 | Bavarian Ministry for Economic Affairs, Infrastructure, Transport and Technology | 2004-09-29 | GERMANY | Bavarian Ministry for Economic Affairs, Infrastructure, Transport and Technology 5647 | 2004-09-29 | Bavarian Ministry for Economic Affairs, Infrastructure, Transport and Technology | Prinzregenten Strasse 28 80538 Muenchen | ||||
16680 | 16680 | 2010-12-31 | German Insurance Association (GDV) | 2010-06-28 | GERMANY | Kreab Gavin Anderson (USA), Inc. 5824 | 2007-08-09 | Kreab Gavin Anderson (USA), Inc. | WilhelmstraBe 43 G | Berlin 10117 | |||
70 | 70 | Bavarian Ministry of Economic Affairs, Infrastructure, Transport and Technology | 2011-01-07 | GERMANY | Bavarian U.S. Offices for Economic Development, LLC 6015 | 2011-01-07 | Bavarian U.S. Offices for Economic Development, LLC | Prinzregentenstrasse 28 | 80538 Munich | ||||
16706 | 16706 | 2012-12-31 | Deutsche Bahn AG - DB US Holding Corporation | 2011-12-23 | GERMANY | Strategy XXI Group, LLC 6058 | 2011-08-18 | Strategy XXI Group, LLC | DB US Holding Corporation | 120 White Plains Road | Tarrytown | NY | 10591 |
658 | 658 | Stiftung Pressischer Kulturbesitz (SPK) (through Wiggin and Dana LLP) | 2020-12-06 | GERMANY | KARV Communications, Inc. 6162 | 2013-04-08 | KARV Communications, Inc. | Von-der-Heydt-StraSe 16-18 | 10785 Berlin | ||||
16849 | 16849 | 2019-12-31 | Deutsche Zentrale fur Tourismus e.V | 2019-01-14 | GERMANY | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | Beethovenstrabe 69 | 60325 Frankfurt | |||
262 | 262 | German National Tourist Office | 2018-04-30 | GERMANY | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 122 East 42nd Street, Suite 2000 | New York | NY | 10168 | ||
2578 | 2578 | 2020-02-15 | Goethe-Institut e.V. | 2018-08-22 | GERMANY | APCO Worldwide LLC 6582 | 2018-08-22 | APCO Worldwide LLC | Dachauer StraBe 122 | 80637, Munich | |||
466 | 466 | Ministry of Economic Affairs, Innovation, Digitalization and Energy of the State of the North Rhone-Westphalia; Germany | 2019-03-13 | GERMANY | NRW.INVEST (NORTH AMERICA) LLC 6645 | 2019-03-13 | NRW.INVEST (NORTH AMERICA) LLC | Berger Allee 25 | 40213 Dusseldorf | ||||
13496 | 13496 | 2019-10-31 | Goethe-Institut e.V. through APCO Worldwide LLC | 2019-04-09 | GERMANY | Audience Partners Worldwide LLC 6657 | 2019-04-08 | Audience Partners Worldwide LLC | Dachauer Strafie 122 80637 | Munich | |||
6444 | 6444 | 2019-05-10 | IG Metall Germany | 2019-04-15 | GERMANY | Kingsley, Sara 6665 | 2019-04-15 | Kingsley, Sara | |||||
1416 | 1416 | 2018-01-19 | Deutsche Vereinigung fur eine Christliche Kultur DVCK e.V. | 2019-12-02 | GERMANY | Foundation for a Christian Civilization, Inc. 6759 | 2019-12-02 | Foundation for a Christian Civilization, Inc. | |||||
247 | 247 | Federal Republic of Germany | 2021-05-19 | GERMANY | Wiggin and Dana LLP 6878 | 2020-10-14 | Wiggin and Dana LLP | Office of the Cultural Minister, Bundeskanzleramt | Willy-Brandt-Strasse 1Berlin | Berlin | |||
659 | 659 | Stiftung Preussischer Kulturbesitz (SPK")" | 2021-05-19 | GERMANY | Wiggin and Dana LLP 6878 | 2020-10-14 | Wiggin and Dana LLP | Von-der-Heydt-Str. 16-18 Berlin | Berlin | ||||
136 | 136 | DIHK DEinternational GmbH | 2021-08-30 | GERMANY | Delegation of German Industry and Commerce in Washington DC, LLC 7002 | 2021-08-30 | Delegation of German Industry and Commerce in Washington DC, LLC | Breite Strasse 29 | Berlin | ||||
708 | 708 | The Thing GmbH | 2023-03-21 | GERMANY | Rubenstein Associates, Inc. 7247 | 2023-03-21 | Rubenstein Associates, Inc. | Franzosische Str. 20 10117 | Berlin |
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]) );