FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
170 rows where Address_1 = "" and State = "NY" sorted by Registrant_Date
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 75
- Keating Group, Inc. 13
- Development Counsellors International, Ltd. 10
- International Council of Cruise Lines 4
- Taylor & Hammond, Ltd. 4
- Modern Education Services, Inc. 3
- Ritter, Sheldon 3
- Wolf Shevack, Inc. 3
- Fried, Frank, Harris, Shriver & Jacobson 2
- Hill, Holliday, Connors, Cosmopulos, Inc. 2
- Lou Hammond & Associates, Inc. 2
- Marketshare 2
- Roberts & Holland 2
- Schoenfeld Film Distribution Corporation 2
- Warren Weil Public Relations 2
- AC&R Public Relations 1
- Black Eagle International Associates, Inc. 1
- Chapoton, John E. 1
- Craig J. Spence & Associates 1
- Czechoslovak Economic Council, Inc. 1
- Desley, Robert F. 1
- Federal Reformist Party 1
- Fontayne Group, Inc. 1
- Gerardino Suazo, Federico Antonio 1
- Hannaford Company, Inc. 1
- Harshe-Rotman & Druck, Inc. 1
- Hendricks, Marshall L. 1
- Hill and Knowlton Strategies, LLC 1
- Hoppel, Mayer & Coleman 1
- International Meetings & Marketing, Inc. 1
- …
Foreign_Principal >30
- Australian Tourist Commission 3
- Swiss National Tourist Office 3
- Austrian Press & Information Service 2
- Embassy of Argentina 2
- French Government Tourist Office 2
- German Information Center 2
- Industrial Development Board of Northern Ireland 2
- Irish Tourist Board 2
- Kenya Tourist Office 2
- National Federation of Coffee Growers of Colombia 2
- Portuguese Government Trade Office 2
- Romanian National Tourist Office 2
- AER Lingus 1
- ALIA, Royal Jordanian Airline 1
- Aerlinte Eireann Teoranta Trading (AerLingus) 1
- Aeroport de Paris 1
- Aerospatiale 1
- Air Afrique 1
- Air Canada 1
- Air France 1
- Air India 1
- Ak-Pa Tekstil Ihracat Pazarlama, A.S. 1
- Alpine Tourist Commission 1
- Amsterdam Stock Exchange 1
- Autonomous University of Guadalajara 1
- Balkan Holiday, U.S., Ltd. 1
- Banco do Brasil, S.A., for the Brazilian Ministry of Finance 1
- Barbados Board of Tourism 1
- Belgian Endive Marketing Board 1
- Borman Williams for Dusseldorf Trade Fair Company 1
- …
Country/Location_Represented >30
- INTERNATIONAL 12
- CANADA 11
- JAPAN 9
- FRANCE 8
- IRELAND 8
- GERMANY, FEDERAL REPUBLIC OF 6
- ITALY 5
- ROMANIA 5
- SOUTH AFRICA 5
- AUSTRALIA 4
- BRAZIL 4
- GREAT BRITAIN 4
- INDIA 4
- ISRAEL 4
- KENYA 4
- MEXICO 4
- AUSTRIA 3
- KOREA, SOUTH 3
- SWITZERLAND 3
- TURKEY 3
- ARGENTINA 2
- BULGARIA 2
- COLOMBIA 2
- EGYPT 2
- JORDAN 2
- NETHERLANDS 2
- NIGERIA 2
- NORWAY 2
- PANAMA 2
- PORTUGAL 2
- …
State 1
- NY · 170 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
15362 | 15362 | 1946-12-24 | No foreign principal listed - listed on statement as none | 1946-12-24 | CZECHOSLOVAKIA | Czechoslovak Economic Council, Inc. 416 | 1946-12-24 | Czechoslovak Economic Council, Inc. | 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 | ||||
1961 | 1961 | 1959-02-01 | Government of Haiti | 1959-03-27 | HAITI | Rutherford, Richard Chambers 1213 | 1959-03-27 | Rutherford, Richard Chambers | 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 | ||||
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 | ||||
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 | ||||
3496 | 3496 | 1961-03-07 | Nigerian Office | 1961-03-07 | NIGERIA | Development Counsellors International, Ltd. 1421 | 1961-01-30 | Development Counsellors International, Ltd. | NY | ||||
8373 | 8373 | 1983-06-30 | Trinidad & Tobago Industrial Development Corporation | 1972-01-18 | TRINIDAD AND TOBAGO | Development Counsellors International, Ltd. 1421 | 1961-01-30 | Development Counsellors International, Ltd. | NY | ||||
9181 | 9181 | 1982-07-11 | Handelsblatt | 1984-03-16 | GERMANY, FEDERAL REPUBLIC OF | Development Counsellors International, Ltd. 1421 | 1961-01-30 | Development Counsellors International, Ltd. | NY | ||||
9482 | 9482 | 1985-07-26 | Hellenic Development Corporation | 1984-11-01 | GREECE | Development Counsellors International, Ltd. 1421 | 1961-01-30 | Development Counsellors International, Ltd. | NY | ||||
9973 | 9973 | 1979-08-01 | French Industrial Development Agency | 1979-04-09 | FRANCE | Development Counsellors International, Ltd. 1421 | 1961-01-30 | Development Counsellors International, Ltd. | NY | ||||
14326 | 14326 | 1961-11-30 | Province of Ontario | 1961-12-18 | CANADA | Development Counsellors International, Ltd. 1421 | 1961-01-30 | Development Counsellors International, Ltd. | NY | ||||
15842 | 15842 | 1980-12-31 | Italian Counsellors International, U.S. Representative for Mezzogiorno Office | 1980-12-19 | ITALY | 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 | ||||
13102 | 13102 | 1993-10-28 | Intourist | 1961-03-28 | RUSSIA | Wolf Shevack, Inc. 1436 | 1961-03-28 | Wolf Shevack, Inc. | 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 | ||||
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 | ||||
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 | ||||
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 | ||||
3715 | 3715 | 1994-03-14 | French Government Tourist Office | 1971-03-25 | FRANCE | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | NY | ||||
3840 | 3840 | 1983-03-17 | Italian Government Tourist Office | 1975-11-26 | ITALY | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | NY | ||||
4507 | 4507 | 1991-03-31 | Japan Foundation | 1981-07-30 | JAPAN | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | NY | ||||
16187 | 16187 | 1991-12-31 | Aerospatiale | 1991-10-12 | FRANCE | International Public Relations Company, Ltd. 1967 | 1966-03-14 | International Public Relations Company, Ltd. | 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 | ||||
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 | ||||
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 | ||||
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 | ||||
8327 | 8327 | 1979-06-30 | Italian Government Travel Office | 1967-10-16 | ITALY | Schoenfeld Film Distribution Corporation 2056 | 1967-10-16 | Schoenfeld Film Distribution Corporation | NY | ||||
14642 | 14642 | 1973-12-01 | South African Tourist Corporation | 1967-10-16 | SOUTH AFRICA | Schoenfeld Film Distribution Corporation 2056 | 1967-10-16 | Schoenfeld Film Distribution Corporation | NY | ||||
11460 | 11460 | 1968-09-09 | Nigerian Republic | 1968-09-09 | NIGERIA | Black Eagle International Associates, Inc. 2104 | 1968-09-09 | Black Eagle International Associates, Inc. | NY | ||||
15043 | 15043 | 1980-12-12 | Kenya Tourist Office, U.S.A. | 1979-01-16 | KENYA | AC&R Public Relations 2431 | 1973-06-12 | AC&R Public Relations | 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 | ||||
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 | ||||
3616 | 3616 | 1993-03-11 | Egyptian Tourist Authority | 1987-05-26 | EGYPT | Keating Group, Inc. 2478 | 1973-11-23 | Keating Group, Inc. | NY | ||||
3621 | 3621 | 1993-03-11 | Global Tours | 1987-05-26 | GREAT BRITAIN | Keating Group, Inc. 2478 | 1973-11-23 | Keating Group, Inc. | NY | ||||
3625 | 3625 | 1993-03-11 | Ivory Coast Department of Tourism | 1987-05-26 | COTE D'IVOIRE (IVORY COAST) | Keating Group, Inc. 2478 | 1973-11-23 | Keating Group, Inc. | NY | ||||
3629 | 3629 | 1993-03-11 | Shannon Development | 1987-05-26 | IRELAND | Keating Group, Inc. 2478 | 1973-11-23 | Keating Group, Inc. | NY | ||||
3632 | 3632 | 1993-03-11 | United Aviation Services, Inc. | 1987-05-26 | PANAMA | Keating Group, Inc. 2478 | 1973-11-23 | Keating Group, Inc. | NY | ||||
6202 | 6202 | 1990-05-01 | Dial Austria Instant Reservations, Inc. | 1987-05-26 | AUSTRIA | Keating Group, Inc. 2478 | 1973-11-23 | Keating Group, Inc. | NY | ||||
6206 | 6206 | 1990-05-01 | Trade Development Authority of India | 1987-05-26 | INDIA | Keating Group, Inc. 2478 | 1973-11-23 | Keating Group, Inc. | NY | ||||
14690 | 14690 | 1987-12-01 | Merit Hotels, Ltd. | 1987-05-26 | GREAT BRITAIN | Keating Group, Inc. 2478 | 1973-11-23 | Keating Group, Inc. | 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 | ||||
14344 | 14344 | 1976-11-30 | East African Airways | 1976-12-17 | INTERNATIONAL | Ritter, Sheldon 2666 | 1976-03-10 | Ritter, Sheldon | NY | ||||
15808 | 15808 | 1978-12-31 | Kenya Tourist Office | 1977-06-07 | KENYA | Ritter, Sheldon 2666 | 1976-03-10 | Ritter, Sheldon | NY | ||||
15887 | 15887 | 1982-12-31 | Senegal Government Tourist Bureau | 1977-06-07 | SENEGAL | Ritter, Sheldon 2666 | 1976-03-10 | Ritter, Sheldon | NY | ||||
5375 | 5375 | 1978-04-18 | Panama Mission to the United Nations | 1977-02-22 | PANAMA | Public Affairs Analysts, Inc. 2726 | 1976-10-18 | Public Affairs Analysts, Inc. | 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 | ||||
2742 | 2742 | 1982-02-24 | Air Canada | 1982-12-01 | CANADA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
4050 | 4050 | 1979-03-26 | Costa Rica | 1979-06-27 | COSTA RICA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5188 | 5188 | 1984-04-12 | Department of Industry Trade & Commerce | 1982-12-01 | CANADA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5189 | 5189 | 1984-04-12 | Embassy of Argentina | 1980-05-21 | ARGENTINA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5190 | 5190 | 1984-04-12 | Government of the Bahamas | 1982-12-01 | BAHAMAS | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5191 | 5191 | 1984-04-12 | Lebanon | 1982-12-01 | LEBANON | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5192 | 5192 | 1984-04-12 | Mexican Tourist Office | 1982-12-01 | MEXICO | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5194 | 5194 | 1984-04-12 | Public Relations Branch Revenue Canada C&E | 1982-12-01 | CANADA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5195 | 5195 | 1984-04-12 | South African Tourist Office | 1980-05-21 | SOUTH AFRICA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5196 | 5196 | 1984-04-12 | Togo Information Service | 1982-07-16 | TOGO | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5197 | 5197 | 1984-04-12 | UNICEF | 1982-12-01 | INTERNATIONAL | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5198 | 5198 | 1985-04-12 | Brunei Darussalam | 1984-11-13 | BRUNEI | 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 | ||||
5200 | 5200 | 1985-04-12 | Embassy of Romania | 1984-11-13 | ROMANIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5202 | 5202 | 1985-04-12 | Industrial Development Board of Northern Ireland | 1984-11-13 | IRELAND | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5203 | 5203 | 1986-04-12 | Amsterdam Stock Exchange | 1985-09-04 | NETHERLANDS | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5204 | 5204 | 1986-04-12 | Austrian Press & Information Service | 1985-03-18 | AUSTRIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5205 | 5205 | 1986-04-12 | Borman Williams for Dusseldorf Trade Fair Company | 1985-06-14 | GERMANY, FEDERAL REPUBLIC OF | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5207 | 5207 | 1986-04-12 | Embassy of South Africa | 1984-11-13 | SOUTH AFRICA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5212 | 5212 | 1986-04-12 | Mexican General of Communication | 1983-05-04 | MEXICO | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5213 | 5213 | 1986-04-12 | Nation Newspaper | 1985-05-24 | KENYA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5214 | 5214 | 1986-04-12 | Norseland Foods, Inc. | 1985-06-05 | NORWAY | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5216 | 5216 | 1987-04-12 | AER Lingus | 1986-05-21 | IRELAND | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5217 | 5217 | 1987-04-12 | Balkan Holiday, U.S., Ltd. | 1986-05-21 | BULGARIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5218 | 5218 | 1987-04-12 | Mexican Ministry of Tourism | 1986-07-15 | MEXICO | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5219 | 5219 | 1988-04-12 | British Tourist Authority | 1987-08-17 | GREAT BRITAIN | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5220 | 5220 | 1988-04-12 | Consulate General of Israel | 1987-10-26 | ISRAEL | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5221 | 5221 | 1988-04-12 | Revenue Canada - Customs & Excise Communications Branch | 1987-08-17 | CANADA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5850 | 5850 | 1990-04-30 | City of West Berlin | 1987-08-17 | GERMANY, FEDERAL REPUBLIC OF | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
9123 | 9123 | 1982-07-09 | Air India | 1979-06-27 | INDIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
9124 | 9124 | 1982-07-09 | Australian Tourist Commission | 1980-05-21 | AUSTRALIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
9125 | 9125 | 1982-07-09 | Canadian Consulate General | 1980-02-06 | CANADA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
9127 | 9127 | 1982-07-09 | Danish National Tourist Office | 1980-02-06 | DENMARK | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
9130 | 9130 | 1982-07-09 | German Information Center | 1980-02-06 | GERMANY, FEDERAL REPUBLIC OF | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
9131 | 9131 | 1982-07-09 | Hamburg | 1979-06-27 | GERMANY, FEDERAL REPUBLIC OF | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
9134 | 9134 | 1982-07-09 | Japan Whaling Association | 1980-05-21 | JAPAN | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
9136 | 9136 | 1982-07-09 | Norweigian-Swedish National Tourist Office | 1980-02-06 | NORWAY | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | 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 | ||||
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 |
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]) );