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 77
- Perry, Marilyn Edith 21
- Association of Japanese Textile Imports, Inc. 15
- Hill and Knowlton Strategies, LLC 13
- West Glen Communications 8
- Films of the Nations, Inc. 7
- International Council of Cruise Lines 7
- Recht, Charles 6
- Tribune Films, Inc. 6
- Coudert Brothers 5
- Lou Hammond & Associates, Inc. 5
- Burson-Marsteller 4
- Doremus & Company 4
- Independent Diplomat, Inc. 4
- J. Sutherland Gould Associates 4
- KWR International, Inc. 4
- M. Silver Associates, Inc. 4
- Ruder Finn, Inc. 4
- U.S.-Cuban Sugar Council 4
- Association Films, Inc. 3
- Barkett, Mitchell 3
- Bozell & Jacobs Public Relations, Inc. 3
- Cannon Advertising Associates, Inc. 3
- Clinton E. Frank, Inc., New York 3
- Daniel J. Edelman, Inc. 3
- Development Counsellors International, Ltd. 3
- Finn Partners, Inc. 3
- Frontaura, Pablo 3
- GCI Group, Inc. 3
- Geoffrey Weill Associates 3
- …
Foreign_Principal >30
- Swiss National Tourist Office 6
- Israel Ministry of Tourism 5
- Tourism Authority of Thailand 5
- French Information Center, Inc. 4
- German National Tourist Office 4
- Romanian National Tourist Office 4
- Austrian Press & Information Service 3
- Consulate General of Japan in New York 3
- European Travel Commission 3
- French Government Tourist Office 3
- French National Railroads 3
- Government of Israel Trade Center 3
- Government of Mauritius 3
- Hong Kong Tourist Organization 3
- Hong Kong Trade Development Council 3
- Portuguese National Tourist Office 3
- British Airways, PLC 2
- Caribbean Tourism Association 2
- China National Tourist Office 2
- Danish Tourist Board 2
- Egyptian Tourist Authority 2
- Eurailpass 2
- German Convention Bureau 2
- German Federal Railroad 2
- German Information Center 2
- Information Service of South Africa 2
- Institute of International Bankers 2
- Intourist 2
- Israel Government Tourist Office 2
- Japan External Trade Organization (JETRO) New York 2
- …
Country/Location_Represented >30
- JAPAN 45
- INTERNATIONAL 36
- FRANCE 29
- ISRAEL 26
- SWITZERLAND 14
- CANADA 13
- KOREA, SOUTH 13
- CHINA 11
- TURKEY 11
- SPAIN 10
- GERMANY, FEDERAL REPUBLIC OF 9
- SOUTH AFRICA 9
- SWEDEN 9
- THAILAND 9
- CUBA 8
- GERMANY 8
- ITALY 8
- NETHERLANDS 8
- AUSTRIA 7
- CZECHOSLOVAKIA 7
- GREAT BRITAIN 7
- HONG KONG 7
- PORTUGAL 7
- USSR 7
- BANGLADESH 6
- BRAZIL 6
- EGYPT 6
- PAKISTAN 6
- INDONESIA 5
- LIBYA 5
- …
City 11
- - 404
- New York 100
- 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 · 520 ✖
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11859 | 11859 | 1993-09-27 | Government of Israel, Investment Authority | 1992-02-11 | ISRAEL | PR Consulting Group, Inc. 4614 | 1992-02-11 | PR Consulting Group, Inc. | New York | NY | |||
11878 | 11878 | 1984-09-28 | Republic of Togo | 1979-03-07 | TOGO | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | New York | NY | |||
11887 | 11887 | 1960-09-29 | South Africa Tourist Bureau | 1960-06-16 | SOUTH AFRICA | Broadcast Planning Corporation 1371 | 1960-06-16 | Broadcast Planning Corporation | New York | NY | |||
11915 | 11915 | 1965-09-30 | Chinese Government Procurement & Services Mission - Division for Taiway Sugar Corporation | 1964-11-27 | CHINA | Farrington, Robert L. 1727 | 1964-05-12 | Farrington, Robert L. | New York | NY | |||
11924 | 11924 | 1970-09-30 | F.U.S. Avionics, Inc., a Division of Messerschmitt-Bolkow- Blohm | 1969-12-09 | GERMANY, FEDERAL REPUBLIC OF | MGI Corporation 2175 | 1969-12-09 | MGI Corporation | 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 | |||
11938 | 11938 | 1976-09-30 | European Aerospace Corporation (Formerly: French Aerospace Corporation) | 1971-01-31 | FRANCE | Robert B. Meyersburg Company 2242 | 1971-01-31 | Robert B. Meyersburg Company | New York | NY | |||
11941 | 11941 | 1977-09-30 | Japan Steel Information Center | 1976-06-21 | JAPAN | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | New York | NY | |||
11958 | 11958 | 1981-09-30 | Portuguese Government Trade Office | 1980-08-05 | PORTUGAL | Thomsen Enterprises, Ltd. 3135 | 1980-08-05 | Thomsen Enterprises, Ltd. | NY | ||||
11971 | 11971 | 1985-09-30 | Paribas Asset Management, Inc. | 1985-08-07 | FRANCE | Chapoton, John E. 3717 | 1985-08-07 | Chapoton, John E. | NY | ||||
11997 | 11997 | 1988-09-30 | Kingdom Of Morocco | 1987-04-29 | MOROCCO | Levine & Company 3971 | 1987-04-29 | Levine & Company | New York | NY | |||
12003 | 12003 | 1989-09-30 | Aeroflot | 1978-10-22 | USSR | Wolf Shevack, Inc. 1436 | 1961-03-28 | Wolf Shevack, Inc. | 545 Fifth Avenue | NY | |||
12056 | 12056 | 1994-09-30 | Japan Airlines | 1988-11-23 | JAPAN | West Glen Communications 4191 | 1988-11-23 | West Glen Communications | New York | NY | |||
12065 | 12065 | 1995-09-30 | Government of Israel, Ministry of Defense, Mission to the U.S. | 1992-09-03 | ISRAEL | Mann, Richard J. 4746 | 1992-09-03 | Mann, Richard J. | New York | NY | |||
12078 | 12078 | 1996-09-30 | Government of Nigeria | 1995-06-28 | NIGERIA | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | New York | NY | |||
12165 | 12165 | 2005-09-30 | United Kingdom Trade & Investment | 2005-03-01 | GREAT BRITAIN | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 845 Third Avenue New York 10022 | NY | |||
12311 | 12311 | 1969-10-01 | Argentine Promotion Center | 1969-06-05 | ARGENTINA | Curtis J. Hoxter, Inc. 1111 | 1958-01-28 | Curtis J. Hoxter, Inc. | New York | NY | |||
12316 | 12316 | 1972-10-01 | Swiss Industries Group | 1973-01-09 | SWITZERLAND | J. Sutherland Gould Associates 1408 | 1960-11-04 | J. Sutherland Gould Associates | New York | NY | |||
12322 | 12322 | 1976-10-01 | French National Railroads | 1974-11-04 | FRANCE | Spiro & Associates, Inc. 2545 | 1974-11-04 | Spiro & Associates, Inc. | New York | NY | |||
12329 | 12329 | 1978-10-01 | Swiss National Tourist Office | 1973-07-24 | SWITZERLAND | Tribune Films, Inc. 1810 | 1964-10-29 | Tribune Films, Inc. | 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 | |||
12364 | 12364 | 1987-10-01 | SGS Control Services, Inc. | 1986-10-30 | SWITZERLAND | Goodwin Procter, LLP 3901 | 1986-10-30 | Goodwin Procter, LLP | New York | NY | |||
12373 | 12373 | 1991-10-01 | Permanent Mission of Kuwait to the United Nations | 1991-09-20 | KUWAIT | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | New York | NY | |||
12389 | 12389 | 2000-10-01 | Netherlands Foreign Investment Agency (NFIA) | 1999-11-01 | NETHERLANDS | Axelrod, Andrea G. 5339 | 1999-11-01 | Axelrod, Andrea G. | New York | NY | |||
12433 | 12433 | 1942-10-02 | French Information Center, Inc. | 1942-10-29 | FRANCE | Cartier, Pierre C. 150 | 1942-10-29 | Cartier, Pierre C. | New York | NY | |||
12440 | 12440 | 1966-10-02 | Kenya Government | 1964-07-20 | KENYA | Forer & Rein 1771 | 1964-07-20 | Forer & Rein | New York | NY | |||
12485 | 12485 | 1972-10-05 | Azad Kahmir Government | 1957-03-13 | PAKISTAN | Buch, Mohammad Yusuf 1010 | 1957-03-13 | Buch, Mohammad Yusuf | New York | NY | |||
12488 | 12488 | 1978-10-05 | Embassy of Argentina | 1979-06-27 | ARGENTINA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
12528 | 12528 | 1981-10-07 | Hamamatsu Corporation | 1980-10-07 | JAPAN | TSE Research & Development, Inc. 3154 | 1980-10-07 | TSE Research & Development, Inc. | NY | ||||
12587 | 12587 | 2004-10-10 | Israeli Ministry of Tourism | 2003-05-19 | ISRAEL | 5W Public Relations, LLC 5561 | 2003-05-19 | 5W Public Relations, LLC | 800 2nd Avenue NY 10017 | NY | |||
12594 | 12594 | 1984-10-11 | Embassy of Thailand | 1984-06-19 | THAILAND | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
12595 | 12595 | 1984-10-11 | Finnair | 1982-12-01 | FINLAND | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
12596 | 12596 | 1984-10-11 | German National Tourist Office | 1983-05-04 | GERMANY, FEDERAL REPUBLIC OF | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
12597 | 12597 | 1984-10-11 | Holland-American Cruises | 1983-05-04 | NETHERLANDS | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
12598 | 12598 | 1984-10-11 | Japanese Information Center | 1983-05-04 | JAPAN | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
12599 | 12599 | 1984-10-11 | Permanent Mission from Israel to the United Nations | 1982-12-01 | ISRAEL | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
12600 | 12600 | 1984-10-11 | Turkish Tourism & Information Office | 1983-05-04 | TURKEY | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
12601 | 12601 | 1984-10-11 | Yugoslav National Tourist Office | 1983-05-04 | YUGOSLAVIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
12615 | 12615 | 1985-10-12 | British Airways | 1985-02-15 | GREAT BRITAIN | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | 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 | ||||
12618 | 12618 | 1985-10-12 | Romanian National Tourist Office | 1985-03-18 | ROMANIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
12620 | 12620 | 1986-10-12 | Spring O'Brien | 1986-01-06 | IRELAND | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
12622 | 12622 | 1986-10-12 | Italian Wine Council | 1985-11-05 | ITALY | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
12624 | 12624 | 1987-10-12 | Brazilian National Tourist Agency | 1986-11-16 | BRAZIL | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
12625 | 12625 | 1987-10-12 | Chinese Cultural Center (Taiwan) | 1987-04-30 | TAIWAN | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
12626 | 12626 | 1987-10-12 | Egypt Tourist Authority | 1986-04-16 | EGYPT | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
12627 | 12627 | 1987-10-12 | Government of India | 1986-01-06 | INDIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
12628 | 12628 | 1987-10-12 | Government of South Korea | 1987-05-01 | KOREA, SOUTH | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
12629 | 12629 | 1987-10-12 | Korea National Tourism Corporation | 1982-07-16 | KOREA, SOUTH | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
12630 | 12630 | 1987-10-12 | Pelican Resort & Casino, St. Maarten | 1986-12-24 | BRITISH VIRGIN ISLANDS | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
12669 | 12669 | 1985-10-14 | Embassy of Canada | 1984-06-19 | CANADA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
12670 | 12670 | 1985-10-14 | Revenue Canada | 1983-05-04 | CANADA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
12691 | 12691 | 1942-10-15 | Teleradio News Agency | 1942-10-15 | FRANCE | D'Aumale, Claude 141 | 1942-10-15 | D'Aumale, Claude | New York | NY | |||
12694 | 12694 | 1951-10-15 | Indonesian Mission to the United Nations, Office of the Permanent Observer to the United Nations | 1950-08-03 | INDONESIA | Mintz, Jeanne S. 636 | 1950-08-03 | Mintz, Jeanne S. | New York | NY | |||
12696 | 12696 | 1967-10-15 | Oscar Gutierrez | 1966-09-28 | CUBA | Brauer, Robert R. 1961 | 1966-02-07 | Brauer, Robert R. | New York | NY | |||
12698 | 12698 | 1970-10-15 | French National Railroads | 1970-08-17 | FRANCE | Mutch Haberman Howard, Inc. 1842 | 1965-01-13 | Mutch Haberman Howard, Inc. | New York | NY | |||
12721 | 12721 | 1993-10-15 | Government of Libya International Communications Marketing (ICM) | 1992-11-12 | LIBYA | William Chasey 4221 | 1989-02-27 | William Chasey | New York | NY | |||
12748 | 12748 | 1945-10-16 | Polish Government Information Center | 1945-10-16 | POLAND | Rathaus, Rudolf 326 | 1945-10-16 | Rathaus, Rudolf | New York | NY | |||
12759 | 12759 | 1958-10-16 | Indonesian Permanent Mission to the United Nations | 1958-04-16 | INDONESIA | Eggleston, Arthur 1131 | 1958-04-16 | Eggleston, Arthur | New York | NY | |||
12765 | 12765 | 1980-10-16 | Republic of Korea Observer Mission to the United Nations | 1980-07-03 | KOREA, SOUTH | MacVane, John 3121 | 1980-07-03 | MacVane, John | New York | NY | |||
12766 | 12766 | 1981-10-16 | Manos del Uruguay | 1980-12-22 | URUGUAY | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | New York | NY | |||
12774 | 12774 | 1985-10-16 | Banco do Brasil, S.A., for the Brazilian Ministry of Finance | 1983-09-02 | BRAZIL | Wald, Harkrader & Ross 3241 | 1981-05-10 | Wald, Harkrader & Ross | NY | ||||
12798 | 12798 | 1987-10-17 | Government of Turkey | 1986-11-16 | TURKEY | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
12817 | 12817 | 1966-10-18 | Consulado General de Honduras | 1964-06-08 | HONDURAS | Kaplan & Cavallo 1708 | 1964-04-08 | Kaplan & Cavallo | New York | NY | |||
12819 | 12819 | 1966-10-18 | Mision Permanente de Honduras Ante las Naciones Unidas | 1964-04-29 | HONDURAS | Kaplan & Cavallo 1708 | 1964-04-08 | Kaplan & Cavallo | New York | 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 | |||
12832 | 12832 | 1993-10-18 | Republic of Namibia | 1993-06-23 | NAMIBIA | Rubenstein Associates, Inc. 4778 | 1993-03-12 | Rubenstein Associates, Inc. | New York | NY | |||
12844 | 12844 | 1964-10-19 | Leo Sorkine | 1964-10-19 | USSR | Bienstock, Natalie Anna 1804 | 1964-10-19 | Bienstock, Natalie Anna | New York | NY | |||
12861 | 12861 | 1995-10-19 | Japan Information Center (Consulate of Japan) | 1981-07-30 | JAPAN | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | New York | NY | |||
12867 | 12867 | 1976-10-20 | Swiss Tourist Office | 1974-10-27 | SWITZERLAND | Perry, Marilyn Edith 2731 | 1976-10-27 | Perry, Marilyn Edith | New York | NY | |||
12884 | 12884 | 1942-10-21 | French Information Center, Inc. | 1942-10-21 | FRANCE | Finley, Blanche 145 | 1942-10-21 | Finley, Blanche | New York | NY | |||
12903 | 12903 | 1964-10-22 | Government of Mexico | 1964-06-04 | MEXICO | Protocol Services, Ltd. 1749 | 1964-06-04 | Protocol Services, Ltd. | New York | NY | |||
12930 | 12930 | 1986-10-22 | Japan Trade Center | 1984-08-31 | JAPAN | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | New York | NY | |||
12941 | 12941 | 1942-10-23 | French Information Center, Inc. | 1942-10-23 | FRANCE | Le Branchu, Jean-Yves 148 | 1942-10-23 | Le Branchu, Jean-Yves | New York | NY | |||
12945 | 12945 | 1954-10-23 | Bank of Japan | 1954-04-23 | JAPAN | Shohan, Charles Judah 824 | 1954-04-23 | Shohan, Charles Judah | New York | NY | |||
12953 | 12953 | 1985-10-23 | Austrian Press & Information Service | 1980-02-06 | AUSTRIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
12954 | 12954 | 1985-10-23 | Autonomous University of Guadalajara | 1985-03-18 | MEXICO | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
12955 | 12955 | 1985-10-23 | Chamber of Mines of South Africa | 1985-02-15 | SOUTH AFRICA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
12956 | 12956 | 1985-10-23 | Tea Council of the U.S.A., Inc. | 1980-11-12 | INDIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
12958 | 12958 | 1986-10-23 | Lufthansa Airlines | 1979-06-27 | GERMANY, FEDERAL REPUBLIC OF | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | East Meadows | NY | |||
12969 | 12969 | 1962-10-24 | Federacion Nacional de Sociedades Negras | 1961-04-24 | CUBA | National Federation of Negro Societies of Cuba 1442 | 1961-04-24 | National Federation of Negro Societies of Cuba | New York | NY | |||
12977 | 12977 | 1968-10-24 | Caribbean Tourist Association | 1964-09-02 | UNITED STATES, MISCELLANEOUS CARIBBEAN ISLANDS | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | New York | NY | |||
12982 | 12982 | 1968-10-24 | Scandinavian Travel Commission (Denmark, Finland, Norway & Sweden) | 1964-10-12 | DENMARK | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | New York | NY | |||
13002 | 13002 | 1989-10-25 | Bahamas Tourist Office | 1988-10-12 | BAHAMAS | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13003 | 13003 | 1989-10-25 | Burson-Marsteller for the Industrial Development Board of Northern Ireland | 1988-10-03 | NORTHERN IRELAND | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13004 | 13004 | 1989-10-25 | Ceylon Tea Bureau | 1988-09-13 | SRI LANKA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13005 | 13005 | 1989-10-25 | Chinese Cultural Center | 1988-10-12 | CHINA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13006 | 13006 | 1989-10-25 | City of West Berlin | 1989-09-20 | GERMANY, FEDERAL REPUBLIC OF | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13007 | 13007 | 1989-10-25 | City of West Berlin, New York | 1988-07-25 | GERMANY, FEDERAL REPUBLIC OF | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13008 | 13008 | 1989-10-25 | Consulate General of Israel | 1988-07-25 | ISRAEL | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13009 | 13009 | 1989-10-25 | D.J. Edelman for Tourism Canada | 1988-10-12 | CANADA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13012 | 13012 | 1989-10-25 | Eurailpass | 1987-02-28 | FRANCE | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | 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 | |||
13014 | 13014 | 1989-10-25 | French Government Tourist Office | 1985-04-18 | FRANCE | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
13016 | 13016 | 1989-10-25 | Hong Kong Tourist Organization | 1988-12-08 | HONG KONG | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13017 | 13017 | 1989-10-25 | Industrial Development Board of Northern Ireland | 1988-02-09 | NORTHERN IRELAND | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
13018 | 13018 | 1989-10-25 | Israel Government Tourist Office | 1989-08-08 | ISRAEL | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13019 | 13019 | 1989-10-25 | Israel Ministry of Tourism | 1989-04-13 | ISRAEL | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13020 | 13020 | 1989-10-25 | Italian Trade Commission | 1987-10-22 | ITALY | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
13021 | 13021 | 1989-10-25 | Jamaica Tourist Board Office | 1989-04-13 | JAMAICA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | 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]) );