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" sorted by Zip

✖
✖

✎ 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  
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  
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  
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  
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  
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  
1800 1800 1996-01-31 Institute of International Bankers 1994-09-06 INTERNATIONAL Nelson, Paul 4946 1994-09-06 Nelson, Paul New York     NY  
1801 1801 1996-01-31 Instituto Panameno De Turismo 1995-05-15 PANAMA M. Silver Associates, Inc. 3131 1980-07-15 M. Silver Associates, Inc. New York     NY  
1805 1805 1996-01-31 Toyota Motor Corporate Services of North America 1992-07-27 JAPAN Van Ness, Feldman, A Professional Corporation 4696 1992-07-27 Van Ness, Feldman, A Professional Corporation New York     NY  
1808 1808 1997-01-31 Greek National Tourist Organization 1996-07-31 GREECE Berk, Peggy 5124 1996-07-31 Berk, Peggy New York     NY  
1818 1818 1998-01-31 JETRO, New York 1996-07-31 JAPAN IBC New York, Inc. 5125 1996-07-31 IBC New York, Inc. New York     NY  
1837 1837 2002-01-31 Government of Portugal (Trade Commission) 1994-11-15 PORTUGAL Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. New York     NY  
1840 1840 2002-01-31 Nice Convention and Visitors Bureau (through Mondotels, Inc.) 1998-06-18 FRANCE Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC New York     NY  
1852 1852 2004-01-31 Niagara Falls Bridge Commission 2001-08-01 CANADA William-Lynn-James, Inc. 5272 1998-08-19 William-Lynn-James, Inc.       NY  
1858 1858 2006-01-31 Government of Japan (Japan External Trade Organization) 2005-03-17 JAPAN Alexander Strategy Group 5557 2003-04-23 Alexander Strategy Group 1221 Avenue of the Americas New York 10020-1079     NY  
1923 1923 2019-01-31 Luxembourg Trade and Investment Office 1994-03-10 LUXEMBOURG Luxcore, Ltd. 4901 1994-03-10 Luxcore, Ltd. 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  
1956 1956 1954-02-01 Swiss National Travel Office 1954-02-12 SWITZERLAND Caples Company 34 1943-03-03 Caples Company New York     NY  
1961 1961 1959-02-01 Government of Haiti 1959-03-27 HAITI Rutherford, Richard Chambers 1213 1959-03-27 Rutherford, Richard Chambers       NY  
1966 1966 1963-02-01 Vinicio Dominguez 1963-02-12 PUERTO RICO Gerardino Suazo, Federico Antonio 1599 1963-02-12 Gerardino Suazo, Federico Antonio       NY  
1980 1980 1971-02-01 Government of Israel Tourist Office 1970-01-16 ISRAEL Krosney Productions, Ltd. 2180 1970-01-16 Krosney Productions, Ltd. New York     NY  
1983 1983 1975-02-01 Chinese Information Service 1973-05-01 CHINA Communetics, Inc. 2421 1973-05-01 Communetics, Inc. New York     NY  
1991 1991 1979-02-01 Japan Trade Center 1971-12-15 JAPAN Ansberry, Louise S. 2297 1971-12-15 Ansberry, Louise S. New York     NY  
1993 1993 1979-02-01 P.N. Pertamina 1973-04-18 INDONESIA Ansberry, Louise S. 2297 1971-12-15 Ansberry, Louise S. New York     NY  
1997 1997 1980-02-01 Permanent Mission of Libya to the United Nations 1978-06-17 LIBYA Perry, Marilyn Edith 2731 1976-10-27 Perry, Marilyn Edith New York     NY  
2025 2025 1987-02-01 Republic of China/Coordination Council for North American Affairs 1986-12-23 TAIWAN Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. New York     NY  
2052 2052 1995-02-01 South African Tourism Board 1994-12-20 SOUTH AFRICA Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 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 871.671ms · 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