home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for FARA_All_ForeignPrincipals
List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

154 rows where Country/Location_Represented = "SWEDEN"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Address_2, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

Registrant_Name >30

  • Swedish Industries Fund, Inc. 20
  • Swedish Information Service 14
  • Modern Education Services, Inc. 8
  • Hill and Knowlton Strategies, LLC 5
  • Edlow International Company 4
  • Films of the Nations, Inc. 4
  • Hogan Lovells US LLP 4
  • Swedish-American Chamber of Commerce, Inc. 3
  • Arnold & Porter Kaye Scholer LLP 2
  • Burson-Marsteller 2
  • Covington & Burling 2
  • Curtis J. Hoxter, Inc. 2
  • Development Counsellors International 2
  • International Business-Government Counsellors, Inc. 2
  • Lindstrom, Talbot 2
  • Murden & Company, Inc. 2
  • Planned Television Arts 2
  • Public Service Audience Planners 2
  • Ruder Finn, Inc. 2
  • Sveriges Television AB (Swedish Broadcasting Corporation) 2
  • VisitSweden 2
  • Winthrop, Stimson, Putnam & Roberts, Washington Office 2
  • APCO Associates 1
  • Akin, Gump, Strauss, Hauer & Feld, LLP 1
  • Alden Films, Business Education Films, Films of the Nations 1
  • Aranow, Brodsky, Bohlinger, Einhorn & Dann 1
  • Atlantic Travel Bureau 1
  • Bengt Allan Svensson 1
  • Broadcast Planning Corporation 1
  • Brown Nelson & Associates, Inc. 1
  • …

Foreign_Principal >30

  • Swedish Tourist Board 4
  • ASEA 3
  • Swedish Information Service 3
  • Swedish National Travel Office 3
  • Swedish Shipowners' Association 3
  • AB Volvo 2
  • Aktiebolaget Atomenergi 2
  • Embassy of Sweden 2
  • Government of Sweden 2
  • Statskonsult International, A.B. 2
  • Sveriges Radio Aktiebolag 2
  • Swedish American Line 2
  • Swedish Government 2
  • Swedish Institute for Cultural Relations 2
  • Swedish National Tourist Office 2
  • Swedish Travel & Tourism Council 2
  • Swedish Travel Information Bureau, Inc. 2
  • 'V.S. VisitSweden AB'. 1
  • A.B. Bofors Nobelkrut 1
  • A.B. Elektrolux 1
  • A.B. Gasaccumulator 1
  • A.B. Ljungstroms Angturbin 1
  • A.B. Separator 1
  • A.B. Svenska Amerikalinjen 1
  • A.B. Svenska Kullager Fabriken 1
  • A.B. Svenska Ostasiastiska Kompaniet (Swedish East Asiatic Company 1
  • A.B. Tirfing S.S. Line 1
  • A.B. Wasa Spisbrodsfabrik 1
  • A.B. de Lavals Angturbin 1
  • AB Bofors 1
  • …

State 7

  • - 124
  • NY 22
  • DC 3
  • CA 2
  • CO 1
  • MA 1
  • WA 1

City 4

  • - 151
  • Stockholm 1
  • Seattle 1
  • Stockholm 1

Country/Location_Represented 1

  • SWEDEN · 154 ✖
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
3 3   'V.S. VisitSweden AB'. 1996-07-31 SWEDEN VisitSweden 4885 1994-01-26 VisitSweden Stockholm        
322 322   H&M Hennes & Mauritz AB 2022-03-19 SWEDEN Marshall, Randi 7100 2022-03-19 Marshall, Randi Master Samuelsgatan 46A   Stockholm    
660 660   Swedish Defence University 2023-04-17 SWEDEN Bengt Allan Svensson 7259 2023-04-17 Bengt Allan Svensson Drottning Kristinas Vag 37, Box 27805   Stockholm    
804 804 1969-01-01 ASEA 1967-11-24 SWEDEN Edlow International Company 1683 1964-01-20 Edlow International Company Vasteras        
836 836 1981-01-01 ASEA-ATOM 1969-04-30 SWEDEN Edlow International Company 1683 1964-01-20 Edlow International Company Vasteras        
853 853 1982-01-01 Swedish Institute for Cultural Relations 1973-10-16 SWEDEN Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc.          
898 898 1987-01-01 Nobel Foundation 1983-02-18 SWEDEN Arnold & Porter Kaye Scholer LLP 1750 1964-06-04 Arnold & Porter Kaye Scholer LLP Stockholm        
1291 1291 1994-01-14 World Trade 1990-11-16 SWEDEN Mark A. Siegel & Associates, Inc. 4200 1989-01-06 Mark A. Siegel & Associates, Inc. Malmoe        
1319 1319 1981-01-15 Central Administration of Swedish Telecommunications 1979-01-15 SWEDEN Leighton, Conklin, Lemov, Jacobs & Buckley 3082 1980-01-15 Leighton, Conklin, Lemov, Jacobs & Buckley Farsta        
1582 1582 1976-01-28 Government of Sweden 1966-06-28 SWEDEN Curtis J. Hoxter, Inc. 1111 1958-01-28 Curtis J. Hoxter, Inc. Stockholm        
1584 1584 1976-01-28 Press Department, Foreign Office of Sweden 1963-02-07 SWEDEN Curtis J. Hoxter, Inc. 1111 1958-01-28 Curtis J. Hoxter, Inc. Stockholm        
1648 1648 1999-01-30 Swedish Travel & Tourism Council 1993-12-17 SWEDEN Development Counsellors International 4777 1993-03-12 Development Counsellors International New York     NY  
1696 1696 1973-01-31 Aktiebolaget Atomenergi 1964-01-20 SWEDEN Edlow International Company 1683 1964-01-20 Edlow International Company Stockholm        
1813 1813 1998-01-31 Barseback Kraft AB 1997-11-12 SWEDEN Pillsbury Winthrop Shaw Pittman, LLP 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP LODDEKOPINGE        
2001 2001 1982-02-01 City of Gothenburg 1980-05-08 SWEDEN Nelson, David A. 3104 1980-05-08 Nelson, David A.          
2134 2134 1961-02-03 Swedish American Line 1955-01-27 SWEDEN Caples Company 34 1943-03-03 Caples Company Gothenburg        
2287 2287 1983-02-08 Swissair, Swiss Air Transport Company 1957-07-09 SWEDEN Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. New York        
2692 2692 1991-02-21 Jernkontoret (Swedish Steelproducers' Association) 1986-08-21 SWEDEN Winthrop, Stimson, Putnam & Roberts, Washington Office 3873 1986-08-21 Winthrop, Stimson, Putnam & Roberts, Washington Office Stockholm        
2698 2698 1979-02-22 Asea-Atom 1979-02-22 SWEDEN Newman & Holtzinger, P.C. 2895 1978-05-04 Newman & Holtzinger, P.C. Vasteras        
2778 2778 1960-02-25 Swedish National Travel Office 1960-06-16 SWEDEN Broadcast Planning Corporation 1371 1960-06-16 Broadcast Planning Corporation Stockholm        
2923 2923 1977-02-28 Kungl Posttyrelsen (General Directorate of Posts) (Swedish Post Office) 1972-08-30 SWEDEN Robbins, Phillip F. 2374 1972-08-30 Robbins, Phillip F. Stockholm        
3231 3231 1972-03-01 Embassy of Sweden 1958-10-09 SWEDEN Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron          
3263 3263 1984-03-01 Allmanna Svenska Elektriska Aktiebdayet (ASEA) 1973-10-23 SWEDEN Burson-Marsteller 2469 1973-10-23 Burson-Marsteller Vasteras        
3464 3464 1943-03-06 Consul General of Sweden 1943-03-06 SWEDEN Danielson, Walter G. 180 1943-03-06 Danielson, Walter G. San Francisco     CA  
3725 3725 1994-03-14 Scandinavian Airlines Systems 1994-03-14 SWEDEN InterVISTAS-ga2 Consulting, Inc. 4902 1994-03-14 InterVISTAS-ga2 Consulting, Inc. Stockholm        
3816 3816 1988-03-16 Uddeholms, A.B. 1987-04-03 SWEDEN Winthrop, Stimson, Putnam & Roberts, Washington Office 3873 1986-08-21 Winthrop, Stimson, Putnam & Roberts, Washington Office Hagfors        
3828 3828 1946-03-17 Swedish Seamens' Union (Svenska Sjofoksforbundet) 1943-09-17 SWEDEN Swedish Seamens' Union 209 1943-09-17 Swedish Seamens' Union Goteborg        
3944 3944 1994-03-21 Studsvik Nuclear, A.B. (SKB) 1992-10-19 SWEDEN Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Nykoping        
4117 4117 1988-03-28 AB Volvo 1987-03-18 SWEDEN Ruder Finn, Inc. 1481 1961-09-27 Ruder Finn, Inc.          
4413 4413 1983-03-31 Swedish National Tourist Office 1974-08-13 SWEDEN Public Service Audience Planners 2452 1979-08-23 Public Service Audience Planners New York     NY  
4457 4457 1989-03-31 ASEA, A.B 1986-02-10 SWEDEN APCO Associates 3597 1984-06-20 APCO Associates Vasteras        
4458 4458 1989-03-31 Asea, A.B. 1986-02-03 SWEDEN Arnold & Porter Kaye Scholer LLP 1750 1964-06-04 Arnold & Porter Kaye Scholer LLP Vasteras        
4587 4587 2000-03-31 Sveriges Radio Aktiebolag 1989-06-14 SWEDEN Sveriges Television AB (Swedish Broadcasting Corporation) 1676 1964-01-02 Sveriges Television AB (Swedish Broadcasting Corporation) Stockholm        
4652 4652 2006-03-31 Government of Sweden 2006-05-31 SWEDEN White & Case, LLP 2759 1977-03-09 White & Case, LLP Box 240 Stockholm 101 24      
5135 5135 1980-04-10 Swedish Tourist Traffic Association 1973-04-05 SWEDEN Scandinavian National Tourist Office 2372 1972-08-24 Scandinavian National Tourist Office Stockholm        
5394 5394 1946-04-19 Aktiebolaget Nordring 1942-10-19 SWEDEN Shands, Richard E. 144 1942-10-19 Shands, Richard E. Stockholm        
5620 5620 1990-04-27 KABI 1990-05-04 SWEDEN Ruder Finn, Inc. 1481 1961-09-27 Ruder Finn, Inc. Stockholm        
6149 6149 1970-05-01 Swedish Broadcasting Corporation 1969-11-18 SWEDEN Planned Television Arts 2171 1969-11-18 Planned Television Arts Stockholm        
6150 6150 1970-05-01 Swedish Information Service 1969-11-18 SWEDEN Planned Television Arts 2171 1969-11-18 Planned Television Arts New York     NY  
6472 6472 1992-05-12 Tetra Pak, Inc. 1990-12-13 SWEDEN Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Washington     DC  
7074 7074 1989-05-31 Scand-Video-Group 1989-03-20 SWEDEN Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc. Boras        
7415 7415 1993-06-01 ASEA Hagglund 1985-03-20 SWEDEN Fierce, Donald L. 3541 1983-12-13 Fierce, Donald L. Yonkers     NY  
7490 7490 1993-06-02 AB Bofors 1989-01-10 SWEDEN Ginn, Edington, Wade & Sanders, Inc. 4134 1988-05-02 Ginn, Edington, Wade & Sanders, Inc. Bofors        
7618 7618 1946-06-06 Swedish Travel Information Bureau 1945-06-08 SWEDEN College Film Center 304 1945-06-08 College Film Center New York     NY  
7695 7695 1966-06-09 American-Swedish News Exchange 1966-04-25 SWEDEN Sturges and Associates 1976 1966-04-25 Sturges and Associates          
7720 7720 1981-06-10 Regional Government of Vastmanland Basair, A.B. 1981-12-31 SWEDEN Flack, Douglas J. 3185 1980-12-31 Flack, Douglas J. Vasteras        
7748 7748 1990-06-11 Swedish Tourist Board 1988-07-11 SWEDEN Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.          
7799 7799 1989-06-14 Sveriges Radio Aktiebolag 1964-01-02 SWEDEN Sveriges Television AB (Swedish Broadcasting Corporation) 1676 1964-01-02 Sveriges Television AB (Swedish Broadcasting Corporation) Stockholm        
8006 8006 1988-06-22 European Art School, A.B./E.A.S.A. 1986-07-10 SWEDEN Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc.          
8028 8028 1983-06-23 Statskonsult International, A.B. 1983-06-15 SWEDEN International Business-Government Counsellors, Inc. 3484 1983-06-15 International Business-Government Counsellors, Inc.          
8063 8063 1990-06-24 AB SKF, Inc. 1989-10-17 SWEDEN Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP Goteborg        
8185 8185 1946-06-30 Stockholms Superfosfat Fabriks A.B. (Stockholm's Superphosphate Company) 1945-03-02 SWEDEN Swedish Industries Fund, Inc. 69 1942-07-28 Swedish Industries Fund, Inc.          
8186 8186 1946-06-30 A.B. Bofors Nobelkrut 1942-07-28 SWEDEN Swedish Industries Fund, Inc. 69 1942-07-28 Swedish Industries Fund, Inc.          
8187 8187 1946-06-30 A.B. Elektrolux 1942-07-28 SWEDEN Swedish Industries Fund, Inc. 69 1942-07-28 Swedish Industries Fund, Inc.          
8188 8188 1946-06-30 A.B. Gasaccumulator 1945-03-02 SWEDEN Swedish Industries Fund, Inc. 69 1942-07-28 Swedish Industries Fund, Inc.          
8189 8189 1946-06-30 A.B. Ljungstroms Angturbin 1942-07-28 SWEDEN Swedish Industries Fund, Inc. 69 1942-07-28 Swedish Industries Fund, Inc.          
8190 8190 1946-06-30 A.B. Separator 1942-07-28 SWEDEN Swedish Industries Fund, Inc. 69 1942-07-28 Swedish Industries Fund, Inc.          
8191 8191 1946-06-30 A.B. Svenska Amerikalinjen 1942-07-28 SWEDEN Swedish Industries Fund, Inc. 69 1942-07-28 Swedish Industries Fund, Inc.          
8192 8192 1946-06-30 A.B. Svenska Kullager Fabriken 1942-07-28 SWEDEN Swedish Industries Fund, Inc. 69 1942-07-28 Swedish Industries Fund, Inc.          
8193 8193 1946-06-30 A.B. Svenska Ostasiastiska Kompaniet (Swedish East Asiatic Company 1945-03-02 SWEDEN Swedish Industries Fund, Inc. 69 1942-07-28 Swedish Industries Fund, Inc.          
8194 8194 1946-06-30 A.B. Tirfing S.S. Line 1945-03-02 SWEDEN Swedish Industries Fund, Inc. 69 1942-07-28 Swedish Industries Fund, Inc.          
8195 8195 1946-06-30 A.B. de Lavals Angturbin 1942-07-28 SWEDEN Swedish Industries Fund, Inc. 69 1942-07-28 Swedish Industries Fund, Inc.          
8196 8196 1946-06-30 Axel Axelson Johnson 1942-07-28 SWEDEN Swedish Industries Fund, Inc. 69 1942-07-28 Swedish Industries Fund, Inc.          
8197 8197 1946-06-30 Brostrom-Koncernen 1942-07-28 SWEDEN Swedish Industries Fund, Inc. 69 1942-07-28 Swedish Industries Fund, Inc.          
8198 8198 1946-06-30 Elektriska Svetsnings A.B. 1942-07-28 SWEDEN Swedish Industries Fund, Inc. 69 1942-07-28 Swedish Industries Fund, Inc.          
8199 8199 1946-06-30 Kooperativa Forbundet 1942-07-28 SWEDEN Swedish Industries Fund, Inc. 69 1942-07-28 Swedish Industries Fund, Inc.          
8201 8201 1946-06-30 Sandvikens Jernverks A.B. 1942-07-28 SWEDEN Swedish Industries Fund, Inc. 69 1942-07-28 Swedish Industries Fund, Inc.          
8202 8202 1946-06-30 Stora Kopparbergs Company 1945-03-02 SWEDEN Swedish Industries Fund, Inc. 69 1942-07-28 Swedish Industries Fund, Inc.          
8203 8203 1946-06-30 Svenska Cellulosa-Aktiebolaget 1942-07-28 SWEDEN Swedish Industries Fund, Inc. 69 1942-07-28 Swedish Industries Fund, Inc.          
8204 8204 1946-06-30 Swedish-America-Mexico Line 1945-03-02 SWEDEN Swedish Industries Fund, Inc. 69 1942-07-28 Swedish Industries Fund, Inc.          
8205 8205 1946-06-30 Telefon A.B. L.M. Ericsson 1942-07-28 SWEDEN Swedish Industries Fund, Inc. 69 1942-07-28 Swedish Industries Fund, Inc.          
8231 8231 1957-06-30 Swedish Travel Information Bureau, Inc. 1946-04-22 SWEDEN Films of the Nations, Inc. 353 1946-04-22 Films of the Nations, Inc. New York     NY  
8259 8259 1968-06-30 American-Swedish News Exchange, Inc. 1965-08-06 SWEDEN Murden & Company, Inc. 1510 1962-01-17 Murden & Company, Inc. New York     NY  
8266 8266 1968-06-30 Embassy of Sweden 1963-03-15 SWEDEN Murden & Company, Inc. 1510 1962-01-17 Murden & Company, Inc. Washington     DC  
8310 8310 1976-06-30 Swedish Information Service 1972-05-09 SWEDEN Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc.          
8311 8311 1976-06-30 Swedish Institute for Cultural Relations 1966-10-31 SWEDEN Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc.          
8312 8312 1976-06-30 Swedish National Travel Office 1968-08-12 SWEDEN Alden Films, Business Education Films, Films of the Nations 2100 1968-08-12 Alden Films, Business Education Films, Films of the Nations New York     NY  
8529 8529 1995-06-30 Swedish Shipowners' Association 1994-12-05 SWEDEN Lorentzon, Ola 4975 1994-12-05 Lorentzon, Ola Gothenburg        
8533 8533 1995-06-30 COBE Laboratories, Inc. 1994-12-16 SWEDEN Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Lakewood     CO  
8661 8661 2006-06-30 Swedish Travel & Tourism Council 2005-04-29 SWEDEN Development Counsellors International 4777 1993-03-12 Development Counsellors International Sveriges Rese - Och Turistrad AB Box 3030 Stockholm        
8835 8835 1971-07-01 Swedish Government 1942-07-06 SWEDEN Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. Stockholm        
9353 9353 1944-07-19 Swedish Industries Fund 1943-01-19 SWEDEN Franzen, Knut Gosta 174 1943-01-19 Franzen, Knut Gosta New York     NY  
9583 9583 1983-07-29 Statskonsult International, A.B. 1983-06-15 SWEDEN International Business-Government Counsellors, Inc. 3332 1982-02-12 International Business-Government Counsellors, Inc.          
9585 9585 1986-07-29 AB Volvo 1986-08-11 SWEDEN Volvo North American Corporation 3864 1986-07-29 Volvo North American Corporation Gothenburg        
9605 9605 1968-07-30 Swedish National Travel Office 1967-06-07 SWEDEN Films of the Nations Distributors, Inc. 2028 1967-06-07 Films of the Nations Distributors, Inc. New York     NY  
9684 9684 1964-07-31 Linjebuss International, A.B. 1956-04-13 SWEDEN Kelly, Nason, Inc. 71 1942-07-30 Kelly, Nason, Inc. Stockholm        
10095 10095 1966-08-03 Swedish Institute 1962-01-30 SWEDEN Creativision, Inc. 1515 1962-01-30 Creativision, Inc. Stockholm        
10267 10267 1975-08-11 Panhellenic Liberation Movement (Denies acting as an agent of any foreign principal, but assisted above and others) 1975-08-11 SWEDEN United Hellenic Front 2601 1975-08-11 United Hellenic Front Stockholm        
10286 10286 1960-08-12 Rudolf Buhler & Company, A.B.1 1957-06-14 SWEDEN Atlantic Travel Bureau 1038 1957-06-14 Atlantic Travel Bureau          
10693 10693 1992-08-23 Swedish Information Service 1977-04-07 SWEDEN Public Service Audience Planners 2452 1979-08-23 Public Service Audience Planners New York     NY  
10743 10743 1993-08-25 Rederi, A.B., Soya (Wallenius Lines) 1988-02-12 SWEDEN Galland, Kharasch, Morse & Garfinkle, P.C. 4006 1987-06-23 Galland, Kharasch, Morse & Garfinkle, P.C. Stockholm        
10788 10788 1964-08-28 A.B. Wasa Spisbrodsfabrik 1946-07-11 SWEDEN Charles W. Hoyt Company, Inc. 361 1946-06-10 Charles W. Hoyt Company, Inc.          
10811 10811 1999-08-28 Argonaut, A.B. 1994-03-31 SWEDEN Brown Nelson & Associates, Inc. 4615 1992-02-12 Brown Nelson & Associates, Inc. Stockholm        
10822 10822 1972-08-29 ABL&P Widengren 1969-08-05 SWEDEN Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. Vingaker        
10823 10823 1972-08-29 Port of Gothenburg 1969-08-05 SWEDEN Swedish-American Chamber of Commerce, Inc. 13 1942-07-06 Swedish-American Chamber of Commerce, Inc. Gothenburg        
11158 11158 2017-08-31 Andra AP-fonden (AP2) Swedish National Pension Fund 2016-05-16 SWEDEN Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Ostra Hamngatan 26-26 P.O. Box 11155 SE-404 24 Goteborg      
11161 11161 2017-08-31 Fjarde AP-fonden (AP4) Swedish National Pension Fund 2016-05-16 SWEDEN Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Regeringsgatan 30-32 P.O. Box 3069 SE-103 61 Stockholm      
11162 11162 2017-08-31 Forsta AP-fonden (AP1) Swedish National Pension Fund 2016-05-16 SWEDEN Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Regeringsgatan 28 P.O. Box 16294 SE-103 25 Stockholm      
11166 11166 2017-08-31 Tredje AP-fonden (AP3) Swedish National Pension Fund 2016-05-16 SWEDEN Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Vasagatan 7 P.O. Box 1176 SE - 111 91 Stockholm      
11321 11321 1975-09-02 Swedish-American Line 1967-07-25 SWEDEN International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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])
);
Powered by Datasette · Queries took 230.043ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows