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

96 rows where Country/Location_Represented = "INTERNATIONAL" and State = "NY"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registrant_Name >30

  • International Council of Cruise Lines 13
  • Billig, Sher & Jones, P.C. 10
  • North American Precis Syndicate 8
  • Tribune Films, Inc. 7
  • Dow, Lohnes & Albertson, L.L.P. 3
  • Barkett, Mitchell 2
  • DLA Piper US LLP 2
  • Development Counsellors International, Ltd. 2
  • Fergo Graff, Inc. 2
  • Hill and Knowlton Strategies, LLC 2
  • Modern Education Services, Inc. 2
  • Wolf Shevack, Inc. 2
  • Africa - African Travel Association, Inc. (Africa Travel Association) 1
  • Association Films, Inc. 1
  • Biederman, Kelly & Shaffer, Inc. 1
  • Blue Crab Strategies LLC 1
  • C&O Resources, Inc. 1
  • Caples Company 1
  • Caribbean Tourism Organization, USA Inc. 1
  • Cleary, Gottlieb, Steen & Hamilton, LLP 1
  • DWJ Associates, Inc. 1
  • Donald N. Martin & Company, Inc. 1
  • Doyle, Graf & Mabley, Inc. 1
  • Eric A. Friedheim Company 1
  • Ernest Wittenberg Associates, Inc. 1
  • European Travel Commission 1
  • GCI Group, Inc. 1
  • Hogan Lovells US LLP 1
  • J.M. Mathes, Inc. 1
  • Kelley, Drye & Warren 1
  • …

Foreign_Principal >30

  • European Travel Commission 7
  • Caribbean Tourism Association 5
  • Institute of International Bankers 5
  • Alpine Tourist Commission 4
  • 8900" Lines Agreement" 2
  • Eurailpass 2
  • United Nations Industrial Development Organization 2
  • A.J. Lazarus for Eurailpass 1
  • Africa Travel Association 1
  • Airbus Industrie of North America (Through Arthur Schmidt & Associates, Inc.) 1
  • Airbus Industries of N.A. 1
  • Bahama Cruise Line, Inc. 1
  • Barber Blue Sea Line 1
  • Beyond Oil and Gas Alliance (through Blue Crab Strategies LLC) 1
  • Beyond Oil and Gas Alliance (through Climate Emergency Collaboration Group, a project of Rockefeller Philanthropy Advisors) 1
  • Caribbean Tourism Development 1
  • Cisneros Group of Companies Highgate Properties, Inc. 1
  • Clipper Line 1
  • Committee of Foreign-Owned Banks 1
  • Conference of European Railroad Representatives 1
  • Costa Line, Inc. 1
  • Cunard Line 1
  • Danube Countries Promotion Group 1
  • ECIPS (Eastern Caribbean Investment Promotion Service) 1
  • East African Airways 1
  • East Asia Travel Association 1
  • Eastern European Travel Board 1
  • EurailPass 1
  • European Travel Commission, New York 1
  • Flagship Cruises, Ltd. 1
  • …

City 5

  • - 90
  • New York 3
  • New York 1
  • Brooklyn 1
  • New York, NY 1

State 1

  • NY · 96 ✖

Country/Location_Represented 1

  • INTERNATIONAL · 96 ✖
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
746 746   United Nations Office of the High Representative for the Least Developed Countries, Landlocked Developing Countries and Small Island Developing States (UN-OHRLLS) 2021-11-30 INTERNATIONAL Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 405 East 42nd Street   New York, NY NY 10017
856 856 1982-01-01 United Nations Industrial Development Organization 1980-02-29 INTERNATIONAL Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.       NY  
862 862 1983-01-01 Permanent Observer Mission of the League of Arab States to the United Nations 1980-02-08 INTERNATIONAL Perry, Marilyn Edith 2731 1976-10-27 Perry, Marilyn Edith New York     NY  
895 895 1987-01-01 Middle East Institute 1981-07-30 INTERNATIONAL Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc. New York     NY  
1242 1242 1991-01-12 Alpine Tourist Commission 1985-08-09 INTERNATIONAL Doyle, Graf & Mabley, Inc. 3719 1985-08-09 Doyle, Graf & Mabley, Inc. New York     NY  
1521 1521 1996-01-25 Costa Line, Inc. 1969-01-25 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
1522 1522 1996-01-25 Cunard Line 1967-07-25 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
1525 1525 1996-01-25 Royal Caribbean Cruise Line, Inc. 1971-01-08 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines       NY  
1707 1707 1983-01-31 United Nations Children's Fund (UNICEF) 1982-12-30 INTERNATIONAL Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC New York     NY  
1747 1747 1990-01-31 Scandinavian Tourist Boards 1990-03-21 INTERNATIONAL Promotional Concept Group, Inc. 3383 1982-06-16 Promotional Concept Group, Inc. New York     NY  
1800 1800 1996-01-31 Institute of International Bankers 1994-09-06 INTERNATIONAL Nelson, Paul 4946 1994-09-06 Nelson, Paul New York     NY  
1955 1955 1953-02-01 Sir Gladwyn Jebb, United Nations, New York 1952-09-19 INTERNATIONAL National Lecture Management, Inc. 638 1950-08-16 National Lecture Management, Inc. New York     NY  
2229 2229 2000-02-05 United Nations Industrial Development Organization 1999-10-04 INTERNATIONAL DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP United Office of New York One United Nations Plaza, Room DC1-1110 New York     NY  
2493 2493 1994-02-14 Regency Cruises, Inc. 1993-08-23 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
2697 2697 1974-02-22 Alpine Tourist Commission 1973-03-27 INTERNATIONAL Wolf Shevack, Inc. 1436 1961-03-28 Wolf Shevack, Inc.       NY  
3122 3122 2017-02-28 Libertas Foundation, Inc. 2017-02-23 INTERNATIONAL Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1719 East 12th Street   Brooklyn NY 11229
3254 3254 1979-03-01 Airbus Industrie of North America (Through Arthur Schmidt & Associates, Inc.) 1978-07-28 INTERNATIONAL Ernest Wittenberg Associates, Inc. 2936 1978-07-28 Ernest Wittenberg Associates, Inc. New York     NY  
3376 3376 1994-03-02 Caribbean Tourism Association 1956-12-31 INTERNATIONAL Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. New York     NY  
3601 3601 1983-03-11 United Nations Development Programme Division of Information 1974-11-12 INTERNATIONAL Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc. New York     NY  
3898 3898 1952-03-20 Representative in America of European Travel Commission 1949-09-27 INTERNATIONAL J.M. Mathes, Inc. 590 1949-09-21 J.M. Mathes, Inc. New York     NY  
4707 4707 2011-03-31 European Travel Commission 1949-06-06 INTERNATIONAL European Travel Commission 574 1949-06-30 European Travel Commission New York     NY  
5197 5197 1984-04-12 UNICEF 1982-12-01 INTERNATIONAL North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
5199 5199 1985-04-12 East Asia Travel Association 1984-11-13 INTERNATIONAL North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
5586 5586 1995-04-25 Institute of International Bankers 1994-07-15 INTERNATIONAL O'Connor & Hannan, L.L.P. 2972 1978-10-25 O'Connor & Hannan, L.L.P. New York     NY  
5602 5602 1995-04-26 Middle East Airlines, Air Liban, S.A.L. 1993-07-07 INTERNATIONAL C&O Resources, Inc. 4827 1993-07-07 C&O Resources, Inc. New York     NY  
5795 5795 1972-04-30 European Travel Commission 1964-04-02 INTERNATIONAL Van Brunt & Company Advertising-Marketing, Inc. 1704 1964-04-02 Van Brunt & Company Advertising-Marketing, Inc. New York     NY  
5878 5878 1992-04-30 Eurailpass 1992-01-03 INTERNATIONAL North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate New York     NY  
6007 6007 2002-04-30 Organization of Eastern Caribbean States (OECS) 1998-09-15 INTERNATIONAL Prince, Leslie F. 4238 1989-04-17 Prince, Leslie F. United Nations Plaza     NY  
6782 6782 1994-05-24 Holland-American Line 1967-07-25 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
7035 7035 1968-05-31 Alpine Tourist Commission 1964-10-29 INTERNATIONAL Tribune Films, Inc. 1810 1964-10-29 Tribune Films, Inc. New York     NY  
7037 7037 1968-05-31 European Travel Commission 1964-10-29 INTERNATIONAL Tribune Films, Inc. 1810 1964-10-29 Tribune Films, Inc. New York     NY  
7171 7171 1999-05-31 Cisneros Group of Companies Highgate Properties, Inc. 1999-02-23 INTERNATIONAL GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. New York     NY  
7229 7229 2010-05-31 Caribbean Tourism Development 2009-05-15 INTERNATIONAL Lou Hammond & Associates, Inc. 5935 2009-05-15 Lou Hammond & Associates, Inc. 80 Broadway Street 2nd Floor New York NY 10004
7374 7374 1979-06-01 Olympic Airways 1973-11-26 INTERNATIONAL Tribune Films, Inc. 1810 1964-10-29 Tribune Films, Inc. New York     NY  
7561 7561 1986-06-04 8900" Lines Agreement" 1981-10-02 INTERNATIONAL Billig, Sher & Jones, P.C. 3279 1981-10-06 Billig, Sher & Jones, P.C. New York     NY  
7564 7564 1986-06-04 Barber Blue Sea Line 1983-06-17 INTERNATIONAL Billig, Sher & Jones, P.C. 3279 1981-10-06 Billig, Sher & Jones, P.C. New York     NY  
7570 7570 1986-06-04 Israel-U.S. North Atlantic Ports Westbound Freight Conference 1981-10-02 INTERNATIONAL Billig, Sher & Jones, P.C. 3279 1981-10-06 Billig, Sher & Jones, P.C. New York     NY  
7576 7576 1986-06-04 New Zealand-U.S. Atlantic & Gulf Shipping Lines Rate Agreement 1981-10-02 INTERNATIONAL Billig, Sher & Jones, P.C. 3279 1981-10-06 Billig, Sher & Jones, P.C. New York     NY  
7577 7577 1986-06-04 North Atlantic-Israel Freight Conference 1981-10-02 INTERNATIONAL Billig, Sher & Jones, P.C. 3279 1981-10-06 Billig, Sher & Jones, P.C. New York     NY  
7578 7578 1986-06-04 North Atlantic-Mediterranean Freight Conference 1981-10-02 INTERNATIONAL Billig, Sher & Jones, P.C. 3279 1981-10-06 Billig, Sher & Jones, P.C. New York     NY  
7579 7579 1986-06-04 U.S. Atlantic & Gulf Ports-Eastern Mediterranean & North Africa Freight Conference 1985-11-06 INTERNATIONAL Billig, Sher & Jones, P.C. 3279 1981-10-06 Billig, Sher & Jones, P.C. New York     NY  
7580 7580 1986-06-04 U.S. Atlantic & Gulf-Australia-New Zealand Conference 1981-10-02 INTERNATIONAL Billig, Sher & Jones, P.C. 3279 1981-10-06 Billig, Sher & Jones, P.C. New York     NY  
7581 7581 1986-06-04 U.S. North Atlantic-Spain Rate Agreement 1981-10-06 INTERNATIONAL Billig, Sher & Jones, P.C. 3279 1981-10-06 Billig, Sher & Jones, P.C. New York     NY  
7582 7582 1986-06-04 U.S. South Atlantic-Spanish, Portuguese, Moroccan & Mediterranean Rate Agreement 1981-10-02 INTERNATIONAL Billig, Sher & Jones, P.C. 3279 1981-10-06 Billig, Sher & Jones, P.C. New York     NY  
8272 8272 1968-06-30 Informal Committee of 14 European & Other Foreign Cruise Ship Lines 1965-04-26 INTERNATIONAL Murden & Company, Inc. 1510 1962-01-17 Murden & Company, Inc. New York     NY  
8294 8294 1974-06-30 Hapag-Lloyd, A.G. 1971-01-25 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines       NY  
8465 8465 1990-06-30 Scandinavian Tourist Board 1988-11-23 INTERNATIONAL West Glen Communications 4191 1988-11-23 West Glen Communications New York     NY  
8796 8796 1945-07-01 London-Polish Governments Information Center 1945-10-08 INTERNATIONAL New Europe, Inc. 323 1945-10-08 New Europe, Inc. New York     NY  
9389 9389 1943-07-21 International Mercantile Marine Officers' Association 1942-07-21 INTERNATIONAL Olaussen, Alf M. 58 1942-07-21 Olaussen, Alf M. Manhattan     NY  
9400 9400 1993-07-21 Caribbean Tourism Association 1981-07-06 INTERNATIONAL Robinsons, Inc. 3110 1980-06-03 Robinsons, Inc. New York     NY  
9652 9652 1959-07-31 European Travel Commission 1953-07-20 INTERNATIONAL Caples Company 34 1943-03-03 Caples Company New York     NY  
9703 9703 1969-07-31 Conference of European Railroad Representatives 1965-01-13 INTERNATIONAL Mutch Haberman Howard, Inc. 1842 1965-01-13 Mutch Haberman Howard, Inc. New York     NY  
9802 9802 1993-07-31 Institute of International Bankers 1992-03-02 INTERNATIONAL Kelley, Drye & Warren 3681 1985-05-23 Kelley, Drye & Warren New York     NY  
9943 9943 2022-07-31 Beyond Oil and Gas Alliance (through Blue Crab Strategies LLC) 2021-11-04 INTERNATIONAL New Heights Communications LLC 7035 2021-11-04 New Heights Communications LLC 6 West 48th Street 10th Floor New York NY 10036
9969 9969 1976-08-01 Scandivavian Travel Commission 1964-10-29 INTERNATIONAL Tribune Films, Inc. 1810 1964-10-29 Tribune Films, Inc. New York     NY  
10691 10691 1992-08-23 SAS Scandinavian Airlines 1974-12-16 INTERNATIONAL Public Service Audience Planners 2452 1979-08-23 Public Service Audience Planners Jamaica     NY  
10704 10704 1976-08-24 Scandinavian National Tourist Offices 1973-11-26 INTERNATIONAL Tribune Films, Inc. 1810 1964-10-29 Tribune Films, Inc. New York     NY  
10909 10909 1981-08-31 Caribbean Tourism Association 1975-07-17 INTERNATIONAL Association Films, Inc. 1814 1964-11-06 Association Films, Inc. New York     NY  
11194 11194 2022-08-31 Beyond Oil and Gas Alliance (through Climate Emergency Collaboration Group, a project of Rockefeller Philanthropy Advisors) 2021-10-18 INTERNATIONAL Blue Crab Strategies LLC 7027 2021-10-18 Blue Crab Strategies LLC 6 West 48th Street 10th Floor   New York NY 10036
11231 11231 1978-09-01 Danube Countries Promotion Group 1975-05-02 INTERNATIONAL Fergo Graff, Inc. 2511 1974-04-19 Fergo Graff, Inc. New York     NY  
11254 11254 1987-09-01 8900" Lines Agreement" 1986-07-03 INTERNATIONAL Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. New York     NY  
11266 11266 1987-09-01 U.S. Atlantic & Gulf Ports/East Mediterranean & North Africa Freight Conference 1986-07-03 INTERNATIONAL Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. New York     NY  
11267 11267 1987-09-01 U.S. Atlantic & Gulf/Australia/New Zealand Conference 1986-07-03 INTERNATIONAL Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. New York     NY  
11747 11747 1987-09-21 Airbus Industries of N.A. 1985-08-21 INTERNATIONAL DWJ Associates, Inc. 2947 1978-08-18 DWJ Associates, Inc. New York     NY  
11775 11775 1975-09-23 Incres Line 1967-07-25 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
11932 11932 1974-09-30 Committee of Foreign-Owned Banks 1969-09-15 INTERNATIONAL Shaw, Pittman, Potts & Trowbridge 1226 1959-05-12 Shaw, Pittman, Potts & Trowbridge New York     NY  
12330 12330 1978-10-01 Trans Mediterranean Airways 1973-10-18 INTERNATIONAL Barkett, Mitchell 2436 1973-06-18 Barkett, Mitchell Jamaica     NY  
12616 12616 1985-10-12 Caribbean Tourism Association 1985-04-18 INTERNATIONAL North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
12831 12831 1991-10-18 International Council of Cruise Lines (ICCL") (Formerly: International Committee of Passenger Lines)" 1985-11-04 INTERNATIONAL Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP New York     NY  
13013 13013 1989-10-25 European Travel Commission, New York 1988-07-25 INTERNATIONAL North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate New York     NY  
13151 13151 1964-10-30 World Coffee Promotion Committee 1962-10-29 INTERNATIONAL Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau New York     NY  
13193 13193 1945-10-31 Various individuals abroad who have received contributions from the Party 1945-12-13 INTERNATIONAL Socialist Workers' Party 332 1945-12-13 Socialist Workers' Party New York     NY  
13257 13257 1989-10-31 Caribbean Tourism Association 1983-08-03 INTERNATIONAL Tribune Films, Inc. 1810 1964-10-29 Tribune Films, Inc. New York     NY  
13553 13553 1982-11-01 Gulf Air 1977-11-22 INTERNATIONAL Barkett, Mitchell 2436 1973-06-18 Barkett, Mitchell New York     NY  
13582 13582 1991-11-01 A.J. Lazarus for Eurailpass 1991-07-11 INTERNATIONAL North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate New York     NY  
13588 13588 1991-11-01 Eurailpass 1990-12-21 INTERNATIONAL North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate New York     NY  
13735 13735 1990-11-05 EurailPass 1990-06-21 INTERNATIONAL North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate New York     NY  
13988 13988 1993-11-15 Institute of International Bankers 1991-11-25 INTERNATIONAL DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP New York     NY  
14117 14117 1990-11-21 Bahama Cruise Line, Inc. 1982-03-04 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
14344 14344 1976-11-30 East African Airways 1976-12-17 INTERNATIONAL Ritter, Sheldon 2666 1976-03-10 Ritter, Sheldon       NY  
14377 14377 1988-11-30 ECIPS (Eastern Caribbean Investment Promotion Service) 1988-07-01 INTERNATIONAL Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd. New York     NY  
14477 14477 1997-11-30 Scandinavian Tourism, Inc. 1997-03-03 INTERNATIONAL Biederman, Kelly & Shaffer, Inc. 5159 1997-03-03 Biederman, Kelly & Shaffer, Inc. New York     NY  
14639 14639 1973-12-01 German-Atlantic Line 1969-01-25 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
14710 14710 1995-12-01 Sun Line 1969-03-01 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines       NY  
15092 15092 1976-12-14 Eastern European Travel Board 1975-05-02 INTERNATIONAL Fergo Graff, Inc. 2511 1974-04-19 Fergo Graff, Inc. New York     NY  
15532 15532 1952-12-31 European Travel Commission 1952-01-23 INTERNATIONAL Eric A. Friedheim Company 711 1952-01-23 Eric A. Friedheim Company New York     NY  
15594 15594 1959-12-31 Pan-American Coffee Bureau 1950-06-19 INTERNATIONAL Selvage & Lee, Inc. 628 1950-06-19 Selvage & Lee, Inc. New York     NY  
15667 15667 1969-12-31 Clipper Line 1967-07-25 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
15722 15722 1974-12-31 Alpine Tourist Commission 1973-07-24 INTERNATIONAL Tribune Films, Inc. 1810 1964-10-29 Tribune Films, Inc. New York     NY  
15800 15800 1978-12-31 Flagship Cruises, Ltd. 1975-05-02 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines       NY  
15850 15850 1980-12-31 Scandinavian National Tourist Office 1973-06-18 INTERNATIONAL Wolf Shevack, Inc. 1436 1961-03-28 Wolf Shevack, Inc.       NY  
15876 15876 1982-12-31 European Travel Commission 1979-06-19 INTERNATIONAL Wilkinson, Cragun & Barker 3032 1979-06-19 Wilkinson, Cragun & Barker       NY  
16061 16061 1988-12-31 Home Lines 1967-07-25 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
16337 16337 1995-12-31 Institute of International Bankers 1994-05-20 INTERNATIONAL Cleary, Gottlieb, Steen & Hamilton, LLP 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP New York     NY  
16532 16532 2003-12-31 European Travel Commission 1960-07-29 INTERNATIONAL Donald N. Martin & Company, Inc. 1381 1960-07-29 Donald N. Martin & Company, Inc. New York     NY  
16762 16762 2015-12-31 Africa Travel Association 2009-12-22 INTERNATIONAL Africa - African Travel Association, Inc. (Africa Travel Association) 5967 2009-12-22 Africa - African Travel Association, Inc. (Africa Travel Association) 166 Madison Avenue, Fifth Floor   New York NY 10016

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 140.243ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history