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

1,423 rows where State = "NY"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registrant_Name >30

  • North American Precis Syndicate 136
  • Association Films, Inc. 36
  • Keating Group, Inc. 31
  • Hill and Knowlton Strategies, LLC 25
  • Perry, Marilyn Edith 25
  • International Council of Cruise Lines 22
  • Tribune Films, Inc. 22
  • Public Service Audience Planners 18
  • West Glen Communications 16
  • Association of Japanese Textile Imports, Inc. 15
  • Billig, Sher & Jones, P.C. 15
  • Daniel J. Edelman, Inc. 12
  • M. Silver Associates, Inc. 12
  • Ruder Finn, Inc. 12
  • Sterling Movies 12
  • Development Counsellors International, Ltd. 11
  • Films of the Nations, Inc. 11
  • Frontaura, Pablo 10
  • Bossowick, Irving 9
  • Caples Company 9
  • Cosmo Public Relations 9
  • Derso & Kelen 8
  • GCI Group, Inc. 8
  • Lou Hammond & Associates, Inc. 8
  • Modern Education Services, Inc. 8
  • Burson-Marsteller 7
  • Donald N. Martin & Company, Inc. 7
  • J. Sutherland Gould Associates 7
  • Samuel E. Stavisky & Associates, Inc. 7
  • Cannon Advertising Associates, Inc. 6
  • …

Foreign_Principal >30

  • French Government Tourist Office 13
  • Japan Trade Center 13
  • German Information Center 10
  • Israel Government Tourist Office 10
  • Swiss National Tourist Office 10
  • French National Railroads 9
  • Israel Ministry of Tourism 9
  • Tourism Authority of Thailand 8
  • European Travel Commission 7
  • German National Tourist Office 7
  • Government of India Tourist Office 6
  • Irish Tourist Board 6
  • Italian Trade Commission 6
  • JETRO, New York 6
  • Spanish Library of Information 6
  • Alpine Tourist Commission 5
  • Austrian Press & Information Service 5
  • Caribbean Tourism Association 5
  • Consulate General of Israel 5
  • Consulate General of Japan 5
  • French Information Center, Inc. 5
  • Hong Kong Tourist Organization 5
  • Hong Kong Trade Development Council 5
  • Institute of International Bankers 5
  • Lufthansa German Airlines 5
  • Netherlands Foreign Investment Agency 5
  • Netherlands Information Bureau 5
  • Portuguese National Tourist Office 5
  • Romanian National Tourist Office 5
  • Air France 4
  • …

Country/Location_Represented >30

  • JAPAN 150
  • INTERNATIONAL 96
  • FRANCE 79
  • ISRAEL 74
  • ITALY 39
  • NETHERLANDS 33
  • SOUTH AFRICA 32
  • SPAIN 32
  • CANADA 30
  • GERMANY, FEDERAL REPUBLIC OF 30
  • SWITZERLAND 30
  • INDIA 23
  • SWEDEN 22
  • GERMANY 21
  • KOREA, SOUTH 21
  • AUSTRIA 20
  • DENMARK 20
  • GREAT BRITAIN 20
  • YUGOSLAVIA 20
  • IRELAND 19
  • BRAZIL 18
  • CHINA 18
  • POLAND 17
  • TURKEY 17
  • USSR 17
  • COLOMBIA 16
  • CZECHOSLOVAKIA 15
  • HONG KONG 15
  • PAKISTAN 15
  • EGYPT 14
  • …

City 11

  • - 1,305
  • New York 102
  • Staten Island 5
  • Brooklyn 2
  • New York 2
  • New York City 2
  • New York 1
  • Fresh Meadows 1
  • New York, NY 1
  • Oakland Gardens 1
  • Tarrytown 1

State 1

  • NY · 1,423 ✖
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
57 57   Austrian National Tourist Office 1947-10-03 AUSTRIA Austrian Tourist Office, Inc. 495 1947-10-03 Austrian Tourist Office, Inc. New York     NY  
127 127   Consulate General of Japan in New York 2021-03-30 JAPAN APCO Worldwide LLC 6582 2018-08-22 APCO Worldwide LLC 299 Park Avenue, Suite 19   New York NY 10171
128 128   Consulate General of Japan 2018-07-11 JAPAN Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 299 Park Avenue, 19th Floor   New York NY 10171
240 240   Enterprise Ireland 2023-01-09 IRELAND Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. 345 Park Avenue, 17th Floor   New York NY 10154
259 259   GOTURKIYE - Turkish Ministry of Culture & Tourism 2022-09-27 TURKEY Geoffrey Weill 7173 2022-09-27 Geoffrey Weill 823 United Nations Plaza   New York NY 10017
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
285 285   Government of Japan - Japan External Trade Organization 2017-04-19 JAPAN Prism Strategy, Inc. 6419 2017-04-19 Prism Strategy, Inc. 565 Fifth Avenue 4th Floor New York NY 10017
291 291   Government of Mauritius 2019-05-29 MAURITIUS McLarty Inbound, LLC 6686 2019-05-29 McLarty Inbound, LLC Mauritius Mission to the UN 211 East 43rd Street 22nd Floor New York NY 10017
333 333   Hong Kong Trade Development Council 2019-04-05 HONG KONG BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC 219 East 46th Street   New York NY 10017
334 334   Hong Kong Trade Development Council 2019-04-08 HONG KONG Jacobs Global Trade & Compliance LLC 6656 2019-04-08 Jacobs Global Trade & Compliance LLC 219 East 46th Street   New York NY 10017
362 362   Israel Ministry of Tourism 2017-12-15 ISRAEL MWW Group, LLC 6381 2016-09-30 MWW Group, LLC 800 2nd Avenue Floor 6 New York NY 10017
488 488   Ministry of Tourism of the Dominican Republic and Dominican Republic Tourism Board Office 2023-03-07 DOMINICAN REPUBLIC Patino, Brewster & Partners 7236 2023-03-07 Patino, Brewster & Partners 156 W. 56th St., Suite 2003   New York NY 10019
492 492   Mission of the Republic of the Marshall Islands to the United Nations 2011-11-30 MARSHALL ISLANDS Independent Diplomat, Inc. 5860 2008-04-03 Independent Diplomat, Inc. 800 Second Avenue, 18th Floor   New York NY 10017
533 533   OCP North America, Inc.(OCPNA) 2022-01-13 MOROCCO Cogent Strategies LLC 6927 2021-02-23 Cogent Strategies LLC 1370 Sixth Avenue 32nd Floor New York NY 10019
551 551   Pakistan Tehreek-e-Insaaf USA 2022-08-09 PAKISTAN South/North Communications LLC 6972 2021-06-10 South/North Communications LLC C/o Criscione Ravala LLP, 250 Park Avenue 7th floor   New York NY 10177
710 710   Tourism Authority of Thailand 2017-10-11 THAILAND Quinn & Co. of NY LTD. 6433 2017-05-24 Quinn & Co. of NY LTD. 61 Broadway, Suite 2810   New York NY 10006
713 713   Tourism Ireland Limited 2003-11-20 IRELAND Tourism Ireland Limited 5594 2003-11-20 Tourism Ireland Limited 345 Park Avenue, New York 10154     NY  
724 724   Turespana Tourist Office of Spain 2020-12-16 SPAIN MMGY Global, LLC 6492 2017-11-27 MMGY Global, LLC 60 East 42nd Street, Suite 5300   New York NY 10165
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
780 780 1959-01-01 Arab Information Center 1956-02-03 EGYPT Caples Company 34 1943-03-03 Caples Company New York     NY  
788 788 1963-01-01 Japan General Merchandise Exporters' Association 1962-03-07 JAPAN Forbes Research, Inc. 1197 1959-02-03 Forbes Research, Inc. New York     NY  
790 790 1963-01-01 Finnair 1961-08-01 FINLAND Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. New York     NY  
807 807 1969-01-01 Republic of Dahomey 1966-10-20 DAHOMEY Ginsburg, Feldman & Bress 540 1948-09-16 Ginsburg, Feldman & Bress New York     NY  
816 816 1973-01-01 Alitalia Airlines, Linee Aeree Italiane S.p.A. 1960-08-12 ITALY Gardner Advertising Company, Inc. 1385 1960-08-12 Gardner Advertising Company, Inc. New York     NY  
820 820 1974-01-01 Khmer Republic 1973-11-27 SOUTH AFRICA Warren Weil Public Relations 1530 1962-03-23 Warren Weil Public Relations       NY  
821 821 1975-01-01 Lebanon Tourist & Information 1973-10-18 LEBANON Barkett, Mitchell 2436 1973-06-18 Barkett, Mitchell New York     NY  
823 823 1978-01-01 Government of India Tourist Office 1977-07-13 INDIA Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. New York     NY  
826 826 1978-01-01 South African Consulate General 1977-10-12 SOUTH AFRICA North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate New York     NY  
834 834 1980-01-01 South African Mission to the United Nations 1979-12-26 SOUTH AFRICA Patrick & Associates 2984 1978-12-06 Patrick & Associates New York     NY  
842 842 1982-01-01 British-American Chamber of Commerce 1974-12-31 GREAT BRITAIN Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. New York     NY  
845 845 1982-01-01 Consulate General of Japan, New York 1979-03-05 JAPAN Philip S. Goodman, Inc. 3003 1979-03-05 Philip S. Goodman, Inc.       NY  
850 850 1982-01-01 Portuguese Government Trade Office 1981-10-21 PORTUGAL Harshe-Rotman & Druck, Inc. 3292 1981-11-21 Harshe-Rotman & Druck, Inc.       NY  
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  
868 868 1984-01-01 Hellenic Line/Hessa Line 1983-06-17 GREECE Billig, Sher & Jones, P.C. 3279 1981-10-06 Billig, Sher & Jones, P.C. New York     NY  
876 876 1986-01-01 Ceylon Tourist Board 1973-07-24 SRI LANKA Tribune Films, Inc. 1810 1964-10-29 Tribune Films, Inc. New York     NY  
891 891 1987-01-01 Japan Trade Center 1987-02-16 JAPAN Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 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  
896 896 1987-01-01 Ministry of Transport, Tourism & Communications (Spain) 1985-05-23 SPAIN Lou Hammond & Associates, Inc. 3682 1985-05-23 Lou Hammond & Associates, Inc. New York     NY  
910 910 1988-01-01 New Japan Securities International, Inc. 1986-11-26 JAPAN Wilbur F. Monroe Associates, Inc. 2888 1978-04-20 Wilbur F. Monroe Associates, Inc. New York     NY  
926 926 1990-01-01 German Federal Railroad 1981-03-16 GERMANY, FEDERAL REPUBLIC OF Herman Associates, Inc. 2578 1975-04-22 Herman Associates, Inc. New York     NY  
967 967 1996-01-01 Government of Denmark 1993-10-01 DENMARK Marston Webb & Associates, Inc. 4209 1989-01-24 Marston Webb & Associates, Inc. New York     NY  
1011 1011 2010-01-01 Government of India Tourist Office 1996-06-24 INDIA Dentsu America, Inc. 5116 1996-06-24 Dentsu America, Inc. New York     NY  
1023 1023 2016-01-01 Extenda 2014-10-06 SPAIN Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 817 Broadway Avenue, 2nd Floor   New York NY 10003
1025 1025 2016-01-01 ICEX Spain Trade and Investment 2014-10-06 SPAIN Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 405 Lexington Avenue 44th Floor New York NY 10174
1050 1050 1981-01-02 CSA, Czechoslovak Airlines 1970-01-27 CZECHOSLOVAKIA Pace Advertising Agency, Inc. 2174 1969-12-03 Pace Advertising Agency, Inc. New York     NY  
1063 1063 1945-01-04 No Foreign Principal Listed (Cuba mentioned on initial statement as country) 1945-01-04 CUBA Cuban Chamber of Commerce in the U.S., Inc. 287 1945-01-04 Cuban Chamber of Commerce in the U.S., Inc. New York     NY  
1122 1122 1960-01-07 Guillermo Lang 1959-03-27 NICARAGUA Satterlee, Browne, Cherbonnier & Dickerson 1102 1958-01-07 Satterlee, Browne, Cherbonnier & Dickerson New York     NY  
1167 1167 1964-01-09 Commerical Attache (Embassy of Ghana) 1963-06-07 GHANA Saxton Graphic Associates, Ltd. 1637 1963-06-07 Saxton Graphic Associates, Ltd. New York     NY  
1192 1192 1994-01-10 Italian Trade Commission 1992-07-17 ITALY Rogers & Wells, LLP 3428 1982-12-10 Rogers & Wells, LLP New York     NY  
1204 1204 1956-01-11 Dr. Fayez Sayegh, Arab Information Center 1955-03-25 EGYPT Margold, Stella K. 864 1955-01-04 Margold, Stella K. New York     NY  
1205 1205 1958-01-11 Arab States Delegation Office 1957-03-26 UNITED STATES Universal Research & Consultants, Inc. 1013 1957-03-26 Universal Research & Consultants, Inc. New York     NY  
1208 1208 1987-01-11 Coordination Council for North American Affairs, ROC 1982-02-26 TAIWAN Hugh C. Newton & Associates 2357 1972-07-17 Hugh C. Newton & Associates 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  
1243 1243 1991-01-12 Austrian Tourist Board 1985-08-09 AUSTRIA Doyle, Graf & Mabley, Inc. 3719 1985-08-09 Doyle, Graf & Mabley, Inc. New York     NY  
1244 1244 1991-01-12 Swissair, N.A. 1985-08-09 SWITZERLAND Doyle, Graf & Mabley, Inc. 3719 1985-08-09 Doyle, Graf & Mabley, Inc. New York     NY  
1280 1280 1972-01-14 Japan National Tourist Organization 1966-01-14 JAPAN United World Films, Inc. 1952 1966-01-14 United World Films, Inc. New York     NY  
1281 1281 1972-01-14 Province of Quebec Tourist Bureau 1966-01-14 CANADA United World Films, Inc. 1952 1966-01-14 United World Films, Inc. New York     NY  
1295 1295 1946-01-15 Dutch Central Transport Workers' Union 1942-07-15 NETHERLANDS Dutch Central Transport Workers' Union 49 1942-07-15 Dutch Central Transport Workers' Union New York     NY  
1296 1296 1946-01-15 Netherlands Information Bureau 1942-07-15 NETHERLANDS Dutch Central Transport Workers' Union 49 1942-07-15 Dutch Central Transport Workers' Union New York     NY  
1321 1321 1981-01-15 Sultanate of Brunei 1984-09-13 BRUNEI Burson-Marsteller 2469 1973-10-23 Burson-Marsteller New York     NY  
1333 1333 1990-01-15 DCA Advertising, Inc. 1989-08-01 JAPAN Orrick, Herrington & Sutcliffe 4266 1989-06-12 Orrick, Herrington & Sutcliffe New York     NY  
1347 1347 1998-01-15 Tourism Authority of Thailand 1998-08-27 THAILAND M. Silver Associates, Inc. 3131 1980-07-15 M. Silver Associates, Inc. New York     NY  
1353 1353 2006-01-15 Freedom Enterprises I, LLC 2005-08-08 AZERBAIJAN Dutko Worldwide, LLC 5693 2005-07-01 Dutko Worldwide, LLC c/o Nixon Peabody 437 Madison Avenue New York NY 10022
1402 1402 1994-01-18 Italian Trade Commission 1991-06-04 ITALY Finley, McDermott & Company 4523 1991-06-04 Finley, McDermott & Company New York     NY  
1414 1414 2014-01-19 Government of the Republic of Ecuador (Through MCSquared Group, Inc.) 2014-07-07 ECUADOR FitzGibbon Media, Inc. 6233 2014-07-07 FitzGibbon Media, Inc. 649 Morgan Avenue Suite 2G Brooklyn NY 11222
1441 1441 1970-01-21 South West Africa National United Front 1966-04-07 SOUTH AFRICA Mbaeva, Nathaniel Veiue 1975 1966-04-07 Mbaeva, Nathaniel Veiue New York     NY  
1443 1443 1977-01-21 Republic of China 1972-07-17 TAIWAN Hugh C. Newton & Associates 2357 1972-07-17 Hugh C. Newton & Associates New York     NY  
1452 1452 2005-01-21 The Government of Equatorial Guinea through Farragut Advisors EG 2005-01-21 EQUATORIAL GUINEA Annabel Hughes Communications, Inc. 5665 2005-01-21 Annabel Hughes Communications, Inc. Farragut Advisors EG 375 Park Avenue New York 10152     NY  
1475 1475 1992-01-23 Finmeccanica North America 1991-01-24 ITALY Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC New York     NY  
1486 1486 1966-01-24 Government of Israel Investment Authority 1965-10-14 ISRAEL Bikel, Ofra 1931 1965-10-14 Bikel, Ofra New York     NY  
1493 1493 1986-01-24 Italcable U.S.A., Inc. 1982-06-02 ITALY Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP New York     NY  
1494 1494 1992-01-24 Taiwan-Government Information Office of Republic of China 1989-09-07 TAIWAN GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. New York     NY  
1502 1502 1971-01-25 North German Lloyd 1967-07-25 GERMANY, FEDERAL REPUBLIC OF International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
1513 1513 1994-01-25 NOGA Commodities (Overseas), Inc., (U.S. Affiliate of Compagnie NOGA d'Importation et d'Exportation, S.A.) 1993-04-30 SWITZERLAND Arnold & Porter Kaye Scholer LLP 1750 1964-06-04 Arnold & Porter Kaye Scholer LLP 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  
1585 1585 1983-01-28 British West Indies Airlines 1983-01-28 BAHAMAS Needham & Grohmann, Inc. 3451 1983-01-28 Needham & Grohmann, Inc. New York     NY  
1587 1587 1983-01-28 Trinidad & Tobago Tourist Board 1983-01-28 TRINIDAD AND TOBAGO Needham & Grohmann, Inc. 3451 1983-01-28 Needham & Grohmann, Inc. New York     NY  
1592 1592 1988-01-28 Government of the People's Republic of Angola 1986-07-11 ANGOLA South/North Development Group, Ltd. 3854 1986-07-11 South/North Development Group, Ltd. New York     NY  
1618 1618 1952-01-30 Espana Libre 1947-01-31 MEXICO Junta de Cultura Espanola 273 1944-07-31 Junta de Cultura Espanola New York     NY  
1624 1624 1952-01-30 Spanish Confederated Societies of New York 1947-01-31 SPAIN Junta de Cultura Espanola 273 1944-07-31 Junta de Cultura Espanola       NY  
1640 1640 1987-01-30 Olympia & York Equity Corporation 1981-04-13 CANADA Roberts & Holland 3233 1981-04-13 Roberts & Holland       NY  
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  
1659 1659 1948-01-31 Jose Arce, Argentine Ambassador to the United Nations 1947-10-16 ARGENTINA Munson, Lyle Hugh 497 1947-10-16 Munson, Lyle Hugh New York     NY  
1676 1676 1961-01-31 Denmark in U.S.A. (Just Lunning, C/O Georg Jensen, Inc.) 1960-10-27 DENMARK Gramercy News, Inc. 1405 1960-10-27 Gramercy News, Inc. New York     NY  
1679 1679 1963-01-31 Iberia Airlines of Spain 1957-09-09 SPAIN James C. Seix Company, Inc. 1064 1957-09-09 James C. Seix Company, Inc. New York     NY  
1682 1682 1963-01-31 Sandys Bao, Chinese Government Procurement & Services Mission, Division of Taiwan Sugar Corporation 1962-02-15 CHINA Farrington, Robert L. 1518 1962-02-15 Farrington, Robert L. New York     NY  
1693 1693 1971-01-31 Italian State Tourist Office 1964-07-15 ITALY Donald N. Martin & Company, Inc. 1381 1960-07-29 Donald N. Martin & Company, Inc. New York     NY  
1704 1704 1979-01-31 Mitsubishi Trust & Banking Corporation 1977-11-25 JAPAN Hendricks, Marshall L. 2848 1977-11-25 Hendricks, Marshall L.       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  
1708 1708 1983-01-31 Alpine Tourist Commission 1980-07-01 AUSTRIA Graf Desley, Inc. 3118 1980-07-01 Graf Desley, Inc. New York     NY  
1715 1715 1985-01-31 Netherlands/Antilles Economic Mission 1976-05-11 NETHERLANDS ANTILLES Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.       NY  
1716 1716 1986-01-31 Ceylon (Sri Lanka) Tourist Board 1986-04-14 SRI LANKA Desley, Robert F. 3811 1986-04-14 Desley, Robert F.       NY  
1736 1736 1989-01-31 Wines of Spain 1987-06-11 SPAIN Bozell, Jacobs, Kenyon & Eckhardt, Public Relations 3778 1986-02-13 Bozell, Jacobs, Kenyon & Eckhardt, Public Relations 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  
1753 1753 1991-01-31 Aerlinte Eireann Teoranta Trading (AerLingus) 1986-04-10 IRELAND Hill, Holliday, Connors, Cosmopulos, Inc. 3810 1986-04-10 Hill, Holliday, Connors, Cosmopulos, Inc.       NY  
1761 1761 1991-01-31 Tibet House 1990-09-12 TIBET Carl Byoir & Associates 4411 1990-09-12 Carl Byoir & Associates New York     NY  
1780 1780 1994-01-31 Mitsubishi Gas Chemical America, Inc. 1992-12-23 JAPAN Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 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 313.138ms · 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