FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
1,423 rows where State = "NY" sorted by Zip
This data as json, CSV (advanced)
Registrant_Name >30
- North American Precis Syndicate 135
- Association Films, Inc. 36
- Keating Group, Inc. 29
- Perry, Marilyn Edith 23
- Tribune Films, Inc. 21
- Hill and Knowlton Strategies, LLC 20
- International Council of Cruise Lines 18
- Public Service Audience Planners 18
- West Glen Communications 16
- Association of Japanese Textile Imports, Inc. 15
- Billig, Sher & Jones, P.C. 14
- Ruder Finn, Inc. 12
- Sterling Movies 12
- Films of the Nations, Inc. 11
- Daniel J. Edelman, Inc. 10
- Frontaura, Pablo 10
- M. Silver Associates, Inc. 10
- Bossowick, Irving 9
- Cosmo Public Relations 9
- Development Counsellors International, Ltd. 9
- Derso & Kelen 8
- Caples Company 7
- GCI Group, Inc. 7
- J. Sutherland Gould Associates 7
- Lou Hammond & Associates, Inc. 7
- Modern Education Services, Inc. 7
- Samuel E. Stavisky & Associates, Inc. 7
- Burson-Marsteller 6
- Cannon Advertising Associates, Inc. 6
- Donald N. Martin & Company, Inc. 6
- …
Foreign_Principal_Registration_Date (date) >30 ✖
- 1971-11-18 16
- 1979-06-27 14
- 1988-11-23 13
- 1987-05-26 12
- 1967-07-25 11
- 1982-12-01 10
- 1955-12-23 9
- 1964-10-29 9
- 1943-12-01 8
- 1983-05-04 8
- 1942-11-13 7
- 1946-04-22 7
- 1981-10-02 7
- 1963-02-12 6
- 1967-09-19 5
- 1973-07-24 5
- 1980-02-06 5
- 1983-06-17 5
- 1984-11-13 5
- 1942-09-09 4
- 1946-03-07 4
- 1953-06-15 4
- 1961-08-01 4
- 1967-07-19 4
- 1971-08-24 4
- 1972-12-21 4
- 1980-05-21 4
- 1985-03-18 4
- 1989-05-31 4
- 1990-11-13 4
- …
Foreign_Principal >30
- French Government Tourist Office 13
- Japan Trade Center 11
- German Information Center 10
- Israel Government Tourist Office 10
- Swiss National Tourist Office 10
- French National Railroads 9
- Israel Ministry of Tourism 9
- European Travel Commission 7
- German National Tourist Office 7
- Tourism Authority of Thailand 7
- Irish Tourist Board 6
- Spanish Library of Information 6
- 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
- JETRO, New York 5
- Lufthansa German Airlines 5
- Netherlands Foreign Investment Agency 5
- Portuguese National Tourist Office 5
- Romanian National Tourist Office 5
- Air France 4
- Australian Tourist Commission 4
- British Tourist Authority 4
- Eurailpass 4
- Government of India Tourist Office 4
- Institute of International Bankers 4
- …
Country/Location_Represented >30
- JAPAN 138
- INTERNATIONAL 85
- FRANCE 78
- ISRAEL 72
- ITALY 33
- NETHERLANDS 31
- GERMANY, FEDERAL REPUBLIC OF 28
- SPAIN 28
- CANADA 27
- SOUTH AFRICA 27
- SWITZERLAND 27
- GERMANY 21
- INDIA 21
- KOREA, SOUTH 21
- SWEDEN 21
- YUGOSLAVIA 20
- GREAT BRITAIN 19
- BRAZIL 18
- DENMARK 18
- AUSTRIA 17
- IRELAND 17
- POLAND 17
- TURKEY 17
- USSR 17
- CHINA 16
- COLOMBIA 16
- HONG KONG 15
- PAKISTAN 15
- CZECHOSLOVAKIA 14
- ROMANIA 14
- …
City 11
- - 1,205
- 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,323 ✖
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2055 | 2055 | 1996-02-01 | State of Israel | 1995-11-02 | ISRAEL | Rubenstein Associates, Inc. 4778 | 1993-03-12 | Rubenstein Associates, Inc. | New York | NY | |||
2092 | 2092 | 1967-02-02 | Japan Trade Center, Japan External Trade Organization | 1964-01-03 | JAPAN | Gotham-Vladimir Advertising, Inc. 1677 | 1964-01-03 | Gotham-Vladimir Advertising, Inc. | New York | NY | |||
2107 | 2107 | 1984-02-02 | Banco do Brasil, S.A. | 1983-08-12 | BRAZIL | T.J. Ross & Associates, Inc. 3508 | 1983-08-12 | T.J. Ross & Associates, Inc. | New York | NY | |||
2108 | 2108 | 1987-02-02 | NYK Line | 1985-08-02 | JAPAN | Rivkin, Radler, Dunne & Bayh 3711 | 1985-08-02 | Rivkin, Radler, Dunne & Bayh | New York | NY | |||
2129 | 2129 | 1961-02-03 | Japan Tourist Association | 1958-08-04 | JAPAN | Caples Company 34 | 1943-03-03 | Caples Company | New York | NY | |||
2132 | 2132 | 1961-02-03 | Scandinavian Travel Commission (Members are: Danish, Finnish, Norwegian & Swedish National Travel Offices) | 1957-08-13 | DENMARK | Caples Company 34 | 1943-03-03 | Caples Company | New York | NY | |||
2133 | 2133 | 1961-02-03 | South Africa Tourist Corporation | 1951-01-31 | SOUTH AFRICA | Caples Company 34 | 1943-03-03 | Caples Company | New York | NY | |||
2135 | 2135 | 1961-02-03 | Swiss National Travel Office | 1955-04-04 | SWITZERLAND | Caples Company 34 | 1943-03-03 | Caples Company | New York | NY | |||
2138 | 2138 | 1961-02-03 | Yugoslav State Tourist Office | 1953-02-10 | YUGOSLAVIA | Caples Company 34 | 1943-03-03 | Caples Company | New York | NY | |||
2144 | 2144 | 1966-02-03 | Government of Sierra Leone | 1964-06-16 | SIERRA LEONE | Bradley, Rosen & Kaus Advertising, Inc. 1761 | 1964-06-16 | Bradley, Rosen & Kaus Advertising, Inc. | New York | NY | |||
2145 | 2145 | 1967-02-03 | Maldive Islands | 1964-06-12 | MALDIVES | Siegel, Stanley Z. 1756 | 1964-06-12 | Siegel, Stanley Z. | New York | NY | |||
2146 | 2146 | 1967-02-03 | Maldivian Philatelic Agency, Ltd. | 1964-06-12 | MALDIVES | Siegel, Stanley Z. 1756 | 1964-06-12 | Siegel, Stanley Z. | New York | NY | |||
2165 | 2165 | 1988-02-03 | Canadian Consulate General, New York | 1980-08-04 | CANADA | Michael Klepper Associates, Inc. 3128 | 1980-08-04 | Michael Klepper Associates, Inc. | New York | NY | |||
2166 | 2166 | 1992-02-03 | Quebec Government House | 1991-11-25 | CANADA | Shearman & Sterling 4208 | 1989-01-23 | Shearman & Sterling | New York | NY | |||
2182 | 2182 | 1977-02-04 | Air France | 1975-08-04 | FRANCE | Rogers & Wells 2598 | 1975-08-04 | Rogers & Wells | New York | NY | |||
2208 | 2208 | 1963-02-05 | Dominican Development Commission | 1960-09-14 | DOMINICAN REPUBLIC | Ayarza, Alfredo Miguel 1391 | 1960-09-14 | Ayarza, Alfredo Miguel | New York | NY | |||
2222 | 2222 | 1993-02-05 | Lufthansa German Airlines | 1988-11-23 | GERMANY | West Glen Communications 4191 | 1988-11-23 | West Glen Communications | East Meadow | 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 | |||
2239 | 2239 | 1978-02-06 | Information Service of South Africa | 1971-08-24 | SOUTH AFRICA | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | New York City | NY | |||
2249 | 2249 | 2003-02-06 | Air China International Corp. | 1998-06-09 | CHINA | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | New York | NY | |||
2276 | 2276 | 1979-02-08 | Government of Japan, Japan Trade Center | 1978-08-09 | JAPAN | Malmgren, Inc. 2854 | 1978-01-04 | Malmgren, Inc. | New York | NY | |||
2331 | 2331 | 1993-02-09 | Japan Information Center | 1992-10-13 | JAPAN | Barbara Burns & Associates, Inc. 4600 | 1991-12-06 | Barbara Burns & Associates, Inc. | New York | NY | |||
2343 | 2343 | 1959-02-10 | Alitalia | 1958-10-22 | ITALY | Martial & Company, Inc. 1182 | 1958-10-22 | Martial & Company, Inc. | New York | NY | |||
2373 | 2373 | 1965-02-11 | French National Railroads | 1964-05-05 | FRANCE | Byrde, Richard & Pound 1722 | 1964-05-05 | Byrde, Richard & Pound | New York | NY | |||
2374 | 2374 | 1974-02-11 | French National Railroads | 1971-08-06 | FRANCE | Baker & Hartel, Inc. 2273 | 1971-08-06 | Baker & Hartel, Inc. | New York | NY | |||
2390 | 2390 | 1947-02-12 | Republic of Estonia | 1942-08-12 | ESTONIA | Markus, Johannes Ernst 90 | 1942-08-12 | Markus, Johannes Ernst | New York | NY | |||
2391 | 2391 | 1947-02-12 | Republic of Estonia | 1942-08-12 | USSR | Jaakson, Ernst Rudolf 91 | 1942-08-12 | Jaakson, Ernst Rudolf | New York | NY | |||
2400 | 2400 | 1987-02-12 | Israel Ministry of Tourism, N.A. | 1986-08-22 | ISRAEL | Thomas L. Richmond, Inc. 3875 | 1986-08-22 | Thomas L. Richmond, Inc. | New York | NY | |||
2412 | 2412 | 1993-02-12 | Banco do Brasil, S.A., for the Brazilian Ministry of Finance | 1985-12-26 | BRAZIL | Willkie, Farr & Gallagher 3765 | 1985-12-26 | Willkie, Farr & Gallagher | New York | NY | |||
2422 | 2422 | 1996-02-12 | Consulate General of Finland | 1976-06-30 | FINLAND | 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 | |||
2423 | 2423 | 1996-02-12 | Consulate General of Israel (formerly: Israel Information Service) | 1969-05-29 | ISRAEL | 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 | |||
2467 | 2467 | 1971-02-14 | French National Railroads | 1964-06-25 | FRANCE | Sterling Movies 1597 | 1963-02-12 | Sterling Movies | New York | NY | |||
2468 | 2468 | 1971-02-14 | German Information Center | 1963-02-12 | GREECE | Sterling Movies 1597 | 1963-02-12 | Sterling Movies | New York | NY | |||
2469 | 2469 | 1971-02-14 | Government Information Service of South Africa | 1963-02-12 | SOUTH AFRICA | Sterling Movies 1597 | 1963-02-12 | Sterling Movies | New York | NY | |||
2470 | 2470 | 1971-02-14 | Government of India Tourist Office | 1963-02-12 | INDIA | Sterling Movies 1597 | 1963-02-12 | Sterling Movies | New York | NY | |||
2471 | 2471 | 1971-02-14 | Government of the Federal Republic of Germany | 1963-02-12 | GERMANY, FEDERAL REPUBLIC OF | Sterling Movies 1597 | 1963-02-12 | Sterling Movies | New York | NY | |||
2472 | 2472 | 1971-02-14 | Israel Government Tourist Office | 1970-03-11 | ISRAEL | Sterling Movies 1597 | 1963-02-12 | Sterling Movies | New York | NY | |||
2474 | 2474 | 1971-02-14 | R.W. Schofield Associates, Inc. | 1964-06-25 | FRANCE | Sterling Movies 1597 | 1963-02-12 | Sterling Movies | New York | NY | |||
2477 | 2477 | 1971-02-14 | South African Tourist Corporation | 1963-02-12 | SOUTH AFRICA | Sterling Movies 1597 | 1963-02-12 | Sterling Movies | New York | NY | |||
2481 | 2481 | 1983-02-14 | Government of the Island of Antigua/Antigua Department of Tourism & Trade | 1979-01-17 | ANTIGUA & BARBUDA | Ross Roy/Colarossi Griswold, Inc. 2989 | 1979-01-17 | Ross Roy/Colarossi Griswold, Inc. | 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 | |||
2536 | 2536 | 1960-02-15 | Iranian Information Service of the Government of Iran (Iranian Information Center) | 1959-10-15 | IRAN | Rasponi Associates, Inc. 1287 | 1959-10-15 | Rasponi Associates, Inc. | New York | NY | |||
2540 | 2540 | 1969-02-15 | Jesus Jimenez Escobar | 1968-03-22 | CUBA | Brauer, Robert R. 1961 | 1966-02-07 | Brauer, Robert R. | New York | NY | |||
2563 | 2563 | 2003-02-15 | Islamic State of Afghanistan | 2001-02-26 | AFGHANISTAN | English, Otilie 5413 | 2001-02-26 | English, Otilie | Afghan Mission to the United Nations 360 Lexington Avenue 11th Floor New York 10017 | NY | |||
2682 | 2682 | 1979-02-20 | Romania Tourist Office | 1979-06-27 | ROMANIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
2687 | 2687 | 1991-02-20 | State of New South Wales Australia | 1961-01-30 | AUSTRALIA | Development Counsellors International, Ltd. 1421 | 1961-01-30 | Development Counsellors International, Ltd. | NY | ||||
2697 | 2697 | 1974-02-22 | Alpine Tourist Commission | 1973-03-27 | INTERNATIONAL | Wolf Shevack, Inc. 1436 | 1961-03-28 | Wolf Shevack, Inc. | NY | ||||
2705 | 2705 | 1989-02-22 | Czechoslovak Travel Bureau | 1989-02-22 | CZECHOSLOVAKIA | Aviso, Inc. 4220 | 1989-02-22 | Aviso, Inc. | New York | NY | |||
2707 | 2707 | 1992-02-22 | Government of Israel | 1992-01-09 | ISRAEL | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | New York | NY | |||
2732 | 2732 | 1994-02-23 | Sulzer Brothers, Ltd. | 1992-05-12 | SWITZERLAND | Dyer, Ellis & Joseph, P.C. 4121 | 1988-03-21 | Dyer, Ellis & Joseph, P.C. | New York | NY | |||
2742 | 2742 | 1982-02-24 | Air Canada | 1982-12-01 | CANADA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
2797 | 2797 | 1947-02-26 | Amtorg Trading Corporation | 1942-08-26 | USSR | Drucker, David 108 | 1942-08-26 | Drucker, David | New York | NY | |||
2799 | 2799 | 1947-02-26 | Artkino Pictures, Inc. | 1942-08-26 | USSR | Drucker, David 108 | 1942-08-26 | Drucker, David | New York | NY | |||
2853 | 2853 | 1965-02-26 | Licensingtorg, Moscow C/O Amtorg Trading Company | 1965-02-26 | USSR | Nadler, Ira 1861 | 1965-02-26 | Nadler, Ira | New York | NY | |||
2871 | 2871 | 1950-02-27 | Giannini Guglielmo | 1950-02-27 | ARGENTINA | Guglielmo, Giannini 615 | 1950-02-27 | Guglielmo, Giannini | New York | NY | |||
2894 | 2894 | 1952-02-28 | Pan-American Coffee Bureau | 1950-11-14 | UNITED STATES | Federal Advertising Agency, Inc. 649 | 1950-11-14 | Federal Advertising Agency, Inc. | New York | NY | |||
2896 | 2896 | 1955-02-28 | Valko Vinterbalter, Director, Yugoslav Information Center | 1955-01-04 | YUGOSLAVIA | Margold, Stella K. 864 | 1955-01-04 | Margold, Stella K. | New York | NY | |||
2897 | 2897 | 1957-02-28 | Bolivian Delegation to the United Nations | 1955-12-23 | BOLIVIA | Frontaura, Pablo 926 | 1955-12-23 | Frontaura, Pablo | New York | NY | |||
2925 | 2925 | 1978-02-28 | South African Tourist Corporation | 1971-08-13 | SOUTH AFRICA | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | New York | NY | |||
2989 | 2989 | 1993-02-28 | Government of Iran, Permanent Mission of the Republic of Iran to the U.N. | 1992-08-12 | IRAN | Sepasy, Bijan Adam 4703 | 1992-08-12 | Sepasy, Bijan Adam | New York | NY | |||
2993 | 2993 | 1994-02-28 | National Federation of Coffee Growers of Colombia | 1986-06-24 | COLOMBIA | Murray, Scheer, Montgomery, Tapia & O'Donnell 3557 | 1984-02-02 | Murray, Scheer, Montgomery, Tapia & O'Donnell | NY | ||||
3000 | 3000 | 1995-02-28 | Japan Information Center - Consulate General of Japan in New York | 1991-08-27 | JAPAN | Robin Cohn & Company 4553 | 1991-08-09 | Robin Cohn & Company | New York | NY | |||
3015 | 3015 | 1996-02-28 | Netherlands Foreign Investment Agency | 1992-05-01 | NETHERLANDS | Mathews & Clark Communications 4659 | 1992-05-01 | Mathews & Clark Communications | New York | NY | |||
3219 | 3219 | 1963-03-01 | Gosho Trading Company, Ltd. | 1963-11-18 | JAPAN | Forbes Research, Inc. 1197 | 1959-02-03 | Forbes Research, Inc. | New York | NY | |||
3221 | 3221 | 1968-03-01 | Balkantourist | 1965-02-16 | BULGARIA | M.J. Jacobs, Inc. 1856 | 1965-02-16 | M.J. Jacobs, Inc. | New York | NY | |||
3242 | 3242 | 1973-03-01 | Irish Tourist Board | 1972-01-17 | IRELAND | Berger, Olson & Beaumont, Inc. 2306 | 1972-01-17 | Berger, Olson & Beaumont, Inc. | New York | NY | |||
3247 | 3247 | 1975-03-01 | Austrian Travel Sales Organization | 1974-09-11 | AUSTRIA | Jurgen Hartmann Agency 2395 | 1972-11-30 | Jurgen Hartmann Agency | New York | NY | |||
3253 | 3253 | 1977-03-01 | Movimiento Nacional Progresista (L. Rhadames Trujillo-Martinez) | 1977-07-08 | SPAIN | Martinez, Antonio C. 2804 | 1977-07-08 | Martinez, Antonio C. | New York | NY | |||
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 | |||
3257 | 3257 | 1979-03-01 | Venezuelan Mission to the United Nations, Dr. Simon Alberto Consalvi, Ambassador to the United Nations | 1976-10-20 | VENEZUELA | F. Clifton White & Associates, Inc. 2729 | 1976-10-20 | F. Clifton White & Associates, Inc. | New York | NY | |||
3308 | 3308 | 1993-03-01 | Ministry of Culture & Tourism | 1947-10-22 | TURKEY | Turkish Consulate Office of Culture & Information Attache 498 | 1947-10-22 | Turkish Consulate Office of Culture & Information Attache | New York | NY | |||
3325 | 3325 | 2000-03-01 | Tourist Office of Spain | 1999-09-21 | SPAIN | Donald N. Martin & Company, Inc. 1381 | 1960-07-29 | Donald N. Martin & Company, Inc. | 666 Fifth Avenue New York, NY 10103 | NY | |||
3327 | 3327 | 2002-03-01 | Japan External Trade Organization (JETRO) | 1995-03-24 | JAPAN | JWI, LLC 4990 | 1995-02-06 | JWI, LLC | New York | NY | |||
3371 | 3371 | 1981-03-02 | Swiss National Tourist Office | 1975-03-25 | SWITZERLAND | Waring & LaRosa, Inc. 2566 | 1975-03-25 | Waring & LaRosa, Inc. | 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 | |||
3392 | 3392 | 1980-03-03 | Soviet Exhibition of Science, Technology & Culture (Alexander Shelnov, Deputy Director) | 1959-10-20 | USSR | Lerman, Louis 973 | 1956-08-28 | Lerman, Louis | NY | ||||
3402 | 3402 | 1993-03-03 | Republic of Azerbaijan | 1992-07-14 | AZERBAIJAN | Campbell, Falk & Selby 4700 | 1992-07-14 | Campbell, Falk & Selby | New York | NY | |||
3417 | 3417 | 1966-03-04 | Yugoslav State Tourist Office | 1961-11-29 | YUGOSLAVIA | F. Gene Gaynor Advertising 1494 | 1961-11-29 | F. Gene Gaynor Advertising | New York | NY | |||
3463 | 3463 | 1943-03-06 | Byk, Inc. | 1942-09-10 | GERMANY | Goepel, C.P. 120 | 1942-09-10 | Goepel, C.P. | New York | NY | |||
3492 | 3492 | 1958-03-07 | Indonesian Delegation to the United Nations | 1955-12-23 | INDONESIA | Frontaura, Pablo 926 | 1955-12-23 | Frontaura, Pablo | New York | NY | |||
3496 | 3496 | 1961-03-07 | Nigerian Office | 1961-03-07 | NIGERIA | Development Counsellors International, Ltd. 1421 | 1961-01-30 | Development Counsellors International, Ltd. | NY | ||||
3497 | 3497 | 1967-03-07 | Colombia National Tourist Board | 1964-11-25 | COLOMBIA | Chirurg & Cairns, Inc. 1822 | 1964-11-25 | Chirurg & Cairns, Inc. | New York | NY | |||
3521 | 3521 | 1984-03-08 | British Tourist Authority | 1983-09-09 | UNITED KINGDOM | Wertheim, Audrey D. 3519 | 1983-09-09 | Wertheim, Audrey D. | New York | NY | |||
3522 | 3522 | 1984-03-08 | International Gold Corporation, Ltd. (a New York Corporation) | 1983-09-08 | SOUTH AFRICA | Rubenstein, Wolfson & Company, Inc. 3517 | 1983-09-08 | Rubenstein, Wolfson & Company, Inc. | New York | NY | |||
3538 | 3538 | 1977-03-09 | Sullivan, Sarria & Associates, Inc., Acting for the Government of Nicaragua | 1976-06-15 | NICARAGUA | Warren Weil Public Relations 1530 | 1962-03-23 | Warren Weil Public Relations | NY | ||||
3542 | 3542 | 1984-03-09 | Norwegian-American Line | 1967-07-25 | NORWAY | International Council of Cruise Lines 2036 | 1967-07-25 | International Council of Cruise Lines | New York | NY | |||
3546 | 3546 | 1988-03-09 | Government of Ontario, Canada | 1988-03-09 | CANADA | Parsells, George Marlin 4098 | 1988-03-09 | Parsells, George Marlin | New York | NY | |||
3569 | 3569 | 1950-03-10 | Gerard De Catalogne | 1948-03-11 | HAITI | Haitian Travel Center, Inc. 516 | 1948-03-11 | Haitian Travel Center, Inc. | Lexington | NY | |||
3597 | 3597 | 1970-03-11 | Jose Raul Viera | 1969-09-17 | CUBA | Brauer, Robert R. 1961 | 1966-02-07 | Brauer, Robert R. | 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 | |||
3605 | 3605 | 1993-03-11 | ALIA, Royal Jordanian Airline | 1987-07-14 | JORDAN | Keating Group, Inc. 2478 | 1973-11-23 | Keating Group, Inc. | NY | ||||
3606 | 3606 | 1993-03-11 | Air Afrique | 1987-05-26 | SENEGAL | Keating Group, Inc. 2478 | 1973-11-23 | Keating Group, Inc. | NY | ||||
3607 | 3607 | 1993-03-11 | Air France | 1987-05-26 | FRANCE | Keating Group, Inc. 2478 | 1973-11-23 | Keating Group, Inc. | NY | ||||
3609 | 3609 | 1993-03-11 | Australian Consulate General | 1976-10-22 | AUSTRALIA | Keating Group, Inc. 2478 | 1973-11-23 | Keating Group, Inc. | New York | NY | |||
3610 | 3610 | 1993-03-11 | Australian Tourist Commission | 1987-05-26 | AUSTRALIA | Keating Group, Inc. 2478 | 1973-11-23 | Keating Group, Inc. | NY | ||||
3612 | 3612 | 1993-03-11 | Brazilian-American Chamber of Commerce | 1987-05-26 | BRAZIL | Keating Group, Inc. 2478 | 1973-11-23 | Keating Group, Inc. | NY | ||||
3613 | 3613 | 1993-03-11 | BritRail Travel International, Inc. | 1982-11-15 | GREAT BRITAIN | Keating Group, Inc. 2478 | 1973-11-23 | Keating Group, Inc. | New York | NY | |||
3616 | 3616 | 1993-03-11 | Egyptian Tourist Authority | 1987-05-26 | EGYPT | Keating Group, Inc. 2478 | 1973-11-23 | Keating Group, Inc. | NY | ||||
3618 | 3618 | 1993-03-11 | France-Tourisme | 1989-06-23 | FRANCE | Keating Group, Inc. 2478 | 1973-11-23 | Keating Group, Inc. | New York | NY | |||
3619 | 3619 | 1993-03-11 | French Alps Commission | 1991-09-24 | FRANCE | Keating Group, Inc. 2478 | 1973-11-23 | Keating Group, Inc. | New York | NY |
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]) );