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 Foreign_Principal_Termination_Date
This data as json, CSV (advanced)
Registrant_Name >30
- Ruder Finn, Inc. 3
- Trombone Associates, Inc. 3
- APCO Worldwide, Inc. 2
- Bavarian Office for Trade, Investment, Research and Technology 2
- Burson-Marsteller 2
- Daniel J. Edelman, Inc. 2
- German-American Chamber of Commerce of Chicago 2
- Haight, Gardner, Poor & Havens 2
- Hanseatic Institute Inc. 2
- Hill and Knowlton Strategies, LLC 2
- Mayer, Brown & Platt 2
- Pordzik, Wolfgang G. 2
- Squire Patton Boggs, LLP 2
- West Glen Communications 2
- APCO Worldwide LLC 1
- Agnew, Carter, McCarthy, Inc. 1
- Audience Partners Worldwide LLC 1
- Barnes, Richardson & Colburn 1
- Bavarian Ministry for Economic Affairs, Infrastructure, Transport and Technology 1
- Bergner Bockorny, Inc. 1
- Brock Group 1
- Carlberg & Associates, Inc. 1
- Chlopak, Leonard, Schechter & Associates, Inc. 1
- Civic Service, Inc. 1
- Collier Shannon Scott, PLLC 1
- DDC Productions, Inc. 1
- Daimler-Benz Washington, Inc. 1
- Daimler-Chrysler Aerospace of North America, Inc. 1
- Fleishman-Hillard, Inc. 1
- Foundation for a Christian Civilization, Inc. 1
- …
Foreign_Principal >30
- Berlin Economic Development Corporation 2
- Brita GmbH 2
- Deutsche Bundespost Telekom 2
- Deutsche Lufthansa, A.G. 2
- Federal Republic of Germany, Ministry of Economics 2
- German Information Center 2
- AEG Electromcom GmbH (Siemens) 1
- Allianz Aktiengesellschaft 1
- Baden-Wuerttemberg Agency for International Economic Cooperation, GWZ 1
- Bavarian Ministry for Economic Affairs, Infrastructure, Transport and Technology 1
- Bavarian Ministry of Economics 1
- Bayer Inc., Subsidiary of Bayer, A.G., (formerly: Miles, Inc., Subsidiary of Bayer, A.G.) 1
- Bayern International 1
- Bayern MIT 1
- Bernd Linke - Breman Business International 1
- Boehringer Ingelheim GmbH 1
- Boehringer Ingelheim Zentrale, GmbH 1
- Bundesministerium der Finanzen (BMF) 1
- Business Location Germany 1
- City of Heidelberg, Germany 1
- City of Kaiserslautern, FRG 1
- Cologne International Trade Fairs Formerly: Messe - und Ausstellungs GmbH 1
- Consortium of German States' Economic Development Organizations 1
- Daimler-Benz Aerospace, A.G. 1
- Daimler-Benz, A.G. 1
- Daimler-Chrysler Aerospace , A. C. (formerly Daimler-Benz Aerospace,A.C.) 1
- Degussa, A.G. 1
- Degussa, A.G. (Through Burson-Marsteller, Washington) 1
- Department of Business Development City of Leipzig (Dr. M. Schimansky, Acting Head) 1
- Deutsche Aerospace GmbH Consolidated - Messerschmitt-Boelkow-Blohm GmbH & Others 1
- …
City 4
- - 73
- Berlin 3
- Heidelberg 1
- Tarrytown 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 | ||||
2999 | 2999 | 1995-02-28 | Degussa, A.G. (Through Burson-Marsteller, Washington) | 1994-05-03 | GERMANY | Gold & Liebengood, Inc. 3700 | 1985-07-09 | Gold & Liebengood, Inc. | Frankfurt | ||||
4535 | 4535 | 1995-03-31 | Cologne International Trade Fairs Formerly: Messe - und Ausstellungs GmbH | 1972-12-21 | GERMANY | German-American Chamber of Commerce of Chicago 1878 | 1965-04-06 | German-American Chamber of Commerce of Chicago | Cologne | ||||
4536 | 4536 | 1995-03-31 | Deutscher Industrie - und Handelstag (DIHT) | 1965-06-03 | GERMANY | German-American Chamber of Commerce of Chicago 1878 | 1965-04-06 | German-American Chamber of Commerce of Chicago | Bonn | ||||
6788 | 6788 | 1995-05-24 | Degussa, A.G. | 1992-03-23 | GERMANY | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | Frankfurt | ||||
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 | ||||
7422 | 7422 | 1995-06-01 | Deutsche Bundespost Telekom | 1987-12-16 | GERMANY | Wilkinson, Barker, Knauer & Quinn 4075 | 1987-12-16 | Wilkinson, Barker, Knauer & Quinn | |||||
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 | ||||
9105 | 9105 | 1995-07-08 | State of Lower Saxony | 1990-01-01 | GERMANY | P.W. Anderson & Partners, Inc. 3806 | 1986-04-04 | P.W. Anderson & Partners, Inc. | Saxony | ||||
14133 | 14133 | 1995-11-21 | Deutsche Aerospace GmbH Consolidated - Messerschmitt-Boelkow-Blohm GmbH & Others | 1990-02-01 | GERMANY | Haight, Gardner, Poor & Havens 3108 | 1980-05-21 | Haight, Gardner, Poor & Havens | Ottobrunn | ||||
14134 | 14134 | 1995-11-21 | Elbe Space & Technology Dresden GmbH & Company (ESD) & Subsidiaries Including But Not Limited To STIR | 1995-03-16 | GERMANY | Haight, Gardner, Poor & Havens 3108 | 1980-05-21 | Haight, Gardner, Poor & Havens | Bremen | ||||
15357 | 15357 | 1995-12-23 | Deutsche Lufthansa, A.G. | 1994-02-15 | GERMANY | Galland, Kharasch, Morse & Garfinkle, P.C. 4006 | 1987-06-23 | Galland, Kharasch, Morse & Garfinkle, P.C. | Cologne | ||||
16293 | 16293 | 1995-12-31 | Boehringer Ingelheim Zentrale, GmbH | 1987-04-03 | GERMANY | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | |||||
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 | ||||
16310 | 16310 | 1995-12-31 | Deutsche Bundespost Telekom | 1994-11-07 | GERMANY | Mayer, Brown & Platt 3076 | 1979-12-13 | Mayer, Brown & Platt | Bonn | ||||
16311 | 16311 | 1995-12-31 | Deutsche Lufthansa, A.G. | 1994-02-14 | GERMANY | Mayer, Brown & Platt 3076 | 1979-12-13 | Mayer, Brown & Platt | Cologne | ||||
16316 | 16316 | 1995-12-31 | Federal Republic of Germany, Ministry of Economics | 1992-08-04 | GERMANY | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | |||||
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 | |||
16366 | 16366 | 1995-12-31 | Scheidt & Bachmann, GmbH | 1993-07-02 | GERMANY | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Gladbach | ||||
16367 | 16367 | 1995-12-31 | Schnell-Bruter-Kernkraftwerksgesellschaft, MbH (SBK) | 1993-08-03 | GERMANY | Shaw, Pittman, Potts & Trowbridge 2580 | 1975-02-21 | Shaw, Pittman, Potts & Trowbridge | Essen | ||||
2688 | 2688 | 1996-02-20 | Berlin Economic Development Corporation | 1987-11-12 | GERMANY | J.R. Bechtle & Company 4057 | 1987-11-12 | J.R. Bechtle & Company | Berlin | ||||
8551 | 8551 | 1996-06-30 | Winag Corporation | 1996-10-25 | GERMANY | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | Passau | ||||
10533 | 10533 | 1996-08-15 | Bavarian Ministry of Economics | 1978-05-08 | GERMANY | Kallman, Gerald G. 2897 | 1978-05-08 | Kallman, Gerald G. | Munich | ||||
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 | ||||
11042 | 11042 | 1996-08-31 | German-American Chamber of Commerce | 1996-10-23 | GERMANY | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | New York | NY | |||
12072 | 12072 | 1996-09-30 | Consortium of German States' Economic Development Organizations | 1995-10-18 | GERMANY | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | Erfurt | ||||
13356 | 13356 | 1996-10-31 | City of Kaiserslautern, FRG | 1990-10-05 | GERMANY | Kerr, John G. 4418 | 1990-10-05 | Kerr, John G. | Kaiserslautern | ||||
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 | ||||
1479 | 1479 | 1997-01-23 | MAN Roland Druckmaschinen AG (Man Roland) | 1996-08-29 | GERMANY | Shearman & Sterling 4208 | 1989-01-23 | Shearman & Sterling | Augsburg | ||||
3488 | 3488 | 1997-03-06 | Siemens, A.G. | 1987-06-22 | GERMANY | Collier Shannon Scott, PLLC 3694 | 1985-06-24 | Collier Shannon Scott, PLLC | Munich | ||||
11734 | 11734 | 1997-09-20 | Friendship in Freedom Association | 1988-06-20 | GERMANY | Bergner Bockorny, Inc. 3801 | 1986-03-20 | Bergner Bockorny, Inc. | Hamburg | ||||
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 | ||||
1133 | 1133 | 1998-01-07 | Thyssen Rheinstahl Technik (TRT) | 1984-01-27 | GERMANY | Gerich, Walter Raymond 3495 | 1983-07-07 | Gerich, Walter Raymond | Dusselforg | ||||
2340 | 2340 | 1998-02-09 | Bayer Inc., Subsidiary of Bayer, A.G., (formerly: Miles, Inc., Subsidiary of Bayer, A.G.) | 1989-08-08 | GERMANY | Barnes, Richardson & Colburn 2751 | 1977-02-10 | Barnes, Richardson & Colburn | West Haven | CT | |||
8560 | 8560 | 1998-06-30 | AEG Electromcom GmbH (Siemens) | 1992-07-28 | GERMANY | Civic Service, Inc. 3385 | 1982-06-28 | Civic Service, Inc. | Konstanz | ||||
11057 | 11057 | 1998-08-31 | Expo 2000 - General Kommissariat | 1997-07-14 | GERMANY | Pordzik, Wolfgang G. 5192 | 1997-07-14 | Pordzik, Wolfgang G. | Berlin | ||||
13375 | 13375 | 1998-10-31 | Business Location Germany | 1997-05-05 | GERMANY | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | Chicago | IL | |||
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 | ||||
13806 | 13806 | 1999-11-07 | Brita GmbH | 1999-03-02 | GERMANY | Powell Tate, Inc. 5148 | 1996-12-30 | Powell Tate, Inc. | Taunusstein | ||||
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 | |||
9187 | 9187 | 2000-07-11 | Boehringer Ingelheim GmbH | 1999-02-23 | GERMANY | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | |||||
13392 | 13392 | 2000-10-31 | Deutscher Industrie - und Handelstag (German National Chamber of Commerce) | 1975-03-14 | GERMANY | German-American Chamber of Commerce of the Western U.S. 2563 | 1975-03-14 | German-American Chamber of Commerce of the Western U.S. | |||||
13619 | 13619 | 2000-11-01 | Brita GmbH | 1999-12-10 | GERMANY | Shandwick Public Affairs, Inc. 5220 | 1997-12-17 | Shandwick Public Affairs, Inc. | Taunusstein | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
9834 | 9834 | 2001-07-31 | Deutsche Post AG | 2000-04-19 | GERMANY | Pordzik, Wolfgang G. 5192 | 1997-07-14 | Pordzik, Wolfgang G. | Bonn | ||||
13399 | 13399 | 2001-10-31 | Deutsche Post | 2001-03-27 | GERMANY | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Zentrale Heinrich-von-Stephan-Strase 1 53105 Bonn | ||||
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 | |||
14498 | 14498 | 2002-11-30 | Allianz Aktiengesellschaft | 2001-07-18 | GERMANY | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Koenig instrasse 28 D-80802 Munich | ||||
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 | ||||
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 | ||||
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 | |||
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 | |||
14200 | 14200 | 2003-11-23 | German Information Center | 1988-11-23 | GERMANY | West Glen Communications 4191 | 1988-11-23 | West Glen Communications | NY | ||||
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 | ||||
7993 | 7993 | 2004-06-21 | German Information Center | 1984-12-20 | GERMANY | DDC Productions, Inc. 2974 | 1978-11-01 | DDC Productions, Inc. | New York | NY | |||
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 | |||
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 | |||
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 | ||||
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 | ||||
4675 | 4675 | 2007-03-31 | Free and Hanseatic City of Hamburg | 2007-05-02 | GERMANY | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | |||||
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 | ||
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 | ||
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 | ||||
16675 | 16675 | 2010-12-31 | City of Heidelberg, Germany | 2009-10-27 | GERMANY | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Rathaus/Town Hall/Mairie | Postfach 10 55 20, D-69045 | Heidelberg | ||
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 | |||
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 |
4957 | 4957 | 2014-04-01 | Deutsche Bahn AG | 2011-12-21 | GERMANY | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | Potsdamer Platz 2 | Berlin | |||
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. | |||||
6444 | 6444 | 2019-05-10 | IG Metall Germany | 2019-04-15 | GERMANY | Kingsley, Sara 6665 | 2019-04-15 | Kingsley, Sara | |||||
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 | |||
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 | |||
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 |
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]) );