FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
1,034 rows where Address_1 = "New York" sorted by Registration_Number descending
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 59
- Perry, Marilyn Edith 25
- Tribune Films, Inc. 22
- Hill and Knowlton Strategies, LLC 18
- International Council of Cruise Lines 18
- Keating Group, Inc. 18
- Association Films, Inc. 16
- Public Service Audience Planners 16
- Association of Japanese Textile Imports, Inc. 15
- Billig, Sher & Jones, P.C. 15
- West Glen Communications 13
- Sterling Movies 12
- Films of the Nations, Inc. 11
- Frontaura, Pablo 10
- Bossowick, Irving 9
- Caples Company 9
- M. Silver Associates, Inc. 9
- Cosmo Public Relations 8
- Derso & Kelen 8
- Daniel J. Edelman, Inc. 7
- J. Sutherland Gould Associates 7
- Burson-Marsteller 6
- Cannon Advertising Associates, Inc. 6
- Europican Marketing, Inc. 6
- GCI Group, Inc. 6
- Herman Associates, Inc. 6
- Kelly, Nason, Inc. 6
- Ruder Finn, Inc. 6
- Samuel E. Stavisky & Associates, Inc. 6
- Coudert Brothers 5
- …
Foreign_Principal >30
- Japan Trade Center 12
- French Government Tourist Office 11
- Israel Government Tourist Office 10
- French National Railroads 9
- German Information Center 8
- Swiss National Tourist Office 7
- European Travel Commission 6
- Government of India Tourist Office 6
- Spanish Library of Information 6
- French Information Center, Inc. 5
- German National Tourist Office 5
- Hong Kong Tourist Organization 5
- Institute of International Bankers 5
- Israel Ministry of Tourism 5
- Netherlands Information Bureau 5
- Alpine Tourist Commission 4
- Austrian National Tourist Office 4
- Caribbean Tourism Association 4
- Consulate General of Israel 4
- Consulate General of Japan 4
- Irish Tourist Board 4
- Italian Trade Commission 4
- JETRO, New York 4
- Pan-American Coffee Bureau 4
- Polish Research & Information Service 4
- Tourism Authority of Thailand 4
- Austrian Press & Information Service 3
- British Tourist Authority 3
- Chinese Information Service 3
- Eurailpass 3
- …
Country/Location_Represented >30
- JAPAN 120
- INTERNATIONAL 73
- FRANCE 63
- ISRAEL 63
- ITALY 28
- NETHERLANDS 28
- SWITZERLAND 24
- SOUTH AFRICA 23
- SPAIN 23
- GERMANY, FEDERAL REPUBLIC OF 20
- SWEDEN 20
- YUGOSLAVIA 19
- DENMARK 18
- INDIA 18
- AUSTRIA 17
- CANADA 17
- POLAND 15
- BRAZIL 14
- COLOMBIA 14
- GERMANY 13
- HONG KONG 13
- CHINA 12
- CUBA 11
- CZECHOSLOVAKIA 11
- EGYPT 11
- INDONESIA 11
- KOREA, SOUTH 11
- GREECE 10
- NORWAY 10
- FINLAND 9
- …
City 1
- - 1,034
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
9469 | 9469 | 1999-07-25 | Korean Overseas Information Service thru Korean Cultural Service | 1999-06-29 | KOREA, SOUTH | Alcalde & Fay 5317 | 1999-06-29 | Alcalde & Fay | New York | NY | |||
8737 | 8737 | 2016-06-30 | JETRO, New York | 1998-12-02 | JAPAN | Global Policy Group, Inc. 5290 | 1998-12-02 | Global Policy Group, Inc. | New York | NY | |||
7855 | 7855 | 1999-06-15 | Government of Bosnia and Herzegovina, Agent to the International Court of Justice | 1999-01-07 | BOSNIA & HERZEGOVINA | Washington International Group, Inc. 5267 | 1998-07-27 | Washington International Group, Inc. | New York | NY | |||
4592 | 4592 | 2001-03-31 | Croatian National Tourist Office, Inc. | 2000-11-03 | CROATIA | Global Communicators/ Harff Communications, Inc. 5241 | 1998-03-05 | Global Communicators/ Harff Communications, Inc. | New York | NY | |||
8145 | 8145 | 2002-06-28 | Japan External Trade Organization | 1998-02-04 | JAPAN | Afridi, Angell & Pelletreau LLP 5231 | 1998-02-04 | Afridi, Angell & Pelletreau LLP | New York | NY | |||
13389 | 13389 | 1999-10-31 | Most in Sweden Agency | 1997-10-22 | SWEDEN | Levin Public Relations & Marketing, Inc. 5217 | 1997-10-22 | Levin Public Relations & Marketing, Inc. | New York | NY | |||
13139 | 13139 | 1997-10-29 | Friends of Sinn Fein, Inc. | 1997-08-29 | IRELAND | MWW/Strategic Communications, Inc. 5209 | 1997-08-29 | MWW/Strategic Communications, Inc. | New York | NY | |||
14477 | 14477 | 1997-11-30 | Scandinavian Tourism, Inc. | 1997-03-03 | INTERNATIONAL | Biederman, Kelly & Shaffer, Inc. 5159 | 1997-03-03 | Biederman, Kelly & Shaffer, Inc. | 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 | |||
1808 | 1808 | 1997-01-31 | Greek National Tourist Organization | 1996-07-31 | GREECE | Berk, Peggy 5124 | 1996-07-31 | Berk, Peggy | 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 | |||
4578 | 4578 | 1999-03-31 | Republic of the Seychelles Islands, President France Albert Rene | 1995-09-08 | SEYCHELLES | Norquist, Grover Glenn 5061 | 1995-09-08 | Norquist, Grover Glenn | New York | NY | |||
5992 | 5992 | 2001-04-30 | Hong Kong Trade Development Council | 1995-06-26 | HONG KONG | Arter & Hadden, LLP 5031 | 1995-06-26 | Arter & Hadden, LLP | New York | 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 | |||
1800 | 1800 | 1996-01-31 | Institute of International Bankers | 1994-09-06 | INTERNATIONAL | Nelson, Paul 4946 | 1994-09-06 | Nelson, Paul | New York | NY | |||
8544 | 8544 | 1996-06-30 | Government of Nigeria | 1995-08-22 | NIGERIA | Symms, Lehn & Associates, Inc. 4880 | 1993-12-21 | Symms, Lehn & Associates, Inc. | New York | NY | |||
16396 | 16396 | 1996-12-31 | Malta National Tourist Office | 1993-12-06 | MALTA | Gillies & Zaiser, Inc. 4872 | 1993-12-06 | Gillies & Zaiser, Inc. | New York | NY | |||
8548 | 8548 | 1996-06-30 | Mathew Dontzin (for Sheikh Khalid bin Mahfouz) (formerly: Lawrence G. Smith for K. bin-Mahfouz) | 1992-12-11 | SAUDI ARABIA | Abernathy/MacGregor Group, Inc. 4834 | 1992-12-11 | Abernathy/MacGregor Group, Inc. | New York | NY | |||
5602 | 5602 | 1995-04-26 | Middle East Airlines, Air Liban, S.A.L. | 1993-07-07 | INTERNATIONAL | C&O Resources, Inc. 4827 | 1993-07-07 | C&O Resources, Inc. | New York | NY | |||
8530 | 8530 | 1995-06-30 | Australian Meat & Livestock Corporation | 1993-06-18 | AUSTRALIA | Brouillard Communications 4819 | 1993-06-18 | Brouillard Communications | New York | NY | |||
14490 | 14490 | 2000-11-30 | Consulate General of Switzerland | 1993-05-19 | SWITZERLAND | Gibney, Anthony & Flaherty, L.L.P. 4805 | 1993-05-19 | Gibney, Anthony & Flaherty, L.L.P. | New York | NY | |||
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 | |||
5267 | 5267 | 1995-04-14 | State of Israel | 1993-03-12 | ISRAEL | Rubenstein Associates, Inc. 4778 | 1993-03-12 | Rubenstein Associates, Inc. | 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 | |||
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 | |||
9821 | 9821 | 1997-07-31 | Barbados Investment & Development Corporation | 1999-01-08 | BARBADOS | Development Counsellors International 4777 | 1993-03-12 | Development Counsellors International | New York | NY | |||
10856 | 10856 | 1998-08-30 | Costa Rican Investment and Trade Development Board | 1999-01-08 | COSTA RICA | Development Counsellors International 4777 | 1993-03-12 | Development Counsellors International | New York | NY | |||
11066 | 11066 | 1999-08-31 | South African Tourism Board | 1993-03-12 | SOUTH AFRICA | Development Counsellors International 4777 | 1993-03-12 | Development Counsellors International | 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 | |||
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 | |||
10022 | 10022 | 1992-08-01 | Government of Iran, United Nations Mission | 1992-07-30 | IRAN | Forum on American-Iranian Relations Foundation 4702 | 1992-07-30 | Forum on American-Iranian Relations Foundation | New York | 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 | |||
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 | |||
16237 | 16237 | 1992-12-31 | Jiewon Park | 1992-07-09 | KOREA, SOUTH | David E. Morey 4688 | 1992-07-09 | David E. Morey | New York | NY | |||
4547 | 4547 | 1996-03-31 | Autonomous Government of Catalonia, Department of Industry & Energy (CIDEM), Office of Foreign Investment | 1995-02-14 | SPAIN | Smith McCabe, Ltd. 4687 | 1992-06-26 | Smith McCabe, Ltd. | New York | NY | |||
4566 | 4566 | 1998-03-31 | Japan External Trade Organization (JETRO) | 1997-12-05 | JAPAN | Smith McCabe, Ltd. 4687 | 1992-06-26 | Smith McCabe, Ltd. | New York | NY | |||
8584 | 8584 | 1999-06-30 | Permanent Mission of Ukraine to the United Nations | 1992-06-08 | UKRAINE | Foundation in Support of Diplomatic Missions of Ukraine, Inc 4683 | 1992-06-08 | Foundation in Support of Diplomatic Missions of Ukraine, Inc | New York | NY | |||
6338 | 6338 | 1993-05-05 | Belgian Tourist Office | 1992-06-02 | BELGIUM | Al Paul Lefton Company, Inc. 4678 | 1992-06-02 | Al Paul Lefton Company, Inc. | 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 | |||
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 | |||
5519 | 5519 | 1992-04-24 | Kempinski International | 1991-12-06 | GERMANY | Trombone Associates, Inc. 4601 | 1991-12-06 | Trombone Associates, Inc. | New York | NY | |||
16351 | 16351 | 1995-12-31 | Lufthansa German Airlines | 1991-12-06 | GERMANY | Trombone Associates, Inc. 4601 | 1991-12-06 | Trombone Associates, Inc. | New York | NY | |||
16456 | 16456 | 1999-12-31 | German National Tourist Office | 1991-12-06 | GERMANY | Trombone Associates, Inc. 4601 | 1991-12-06 | Trombone Associates, 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 | |||
5260 | 5260 | 1992-04-14 | Consulate General of Denmark | 1991-09-27 | DENMARK | Pragma Corporation 4571 | 1991-09-27 | Pragma Corporation | New York | NY | |||
8033 | 8033 | 1992-06-23 | Japan Information Center | 1991-09-17 | JAPAN | Omega Group 4564 | 1991-09-17 | Omega Group | New York | NY | |||
6306 | 6306 | 1996-05-03 | Government of Hong Kong | 1993-05-11 | HONG KONG | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | New York | NY | |||
6412 | 6412 | 1992-05-08 | Government of Israel | 1992-01-09 | ISRAEL | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 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 | |||
10306 | 10306 | 1992-08-12 | Mission of Islamic Republic of Iran to the United Nations | 1991-09-03 | IRAN | Bijan Adam Sepasy - Access U.S.A., Inc. 4560 | 1991-09-03 | Bijan Adam Sepasy - Access U.S.A., Inc. | New York | 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 | |||
13336 | 13336 | 1994-10-31 | Turkish Ministry of Tourism & Information | 1991-06-04 | TURKEY | Merkley Newman Harty 4525 | 1991-06-04 | Merkley Newman Harty | 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 | |||
14956 | 14956 | 1993-12-10 | Capital Cities/ABC Video Enterprises, Inc. | 1991-11-26 | JAPAN | NHK Cosmomedia America, Inc. 4490 | 1991-03-26 | NHK Cosmomedia America, Inc. | New York | NY | |||
14967 | 14967 | 1993-12-10 | Itochu International, Inc. (Formerly: C. Itoh & Company (America), Inc.) | 1991-03-26 | JAPAN | NHK Cosmomedia America, Inc. 4490 | 1991-03-26 | NHK Cosmomedia America, Inc. | New York | NY | |||
8097 | 8097 | 1997-06-25 | Netherlands Foreign Investment Agency | 1990-12-28 | NETHERLANDS | Ogilvy, Adams & Rinehart, Inc. 4455 | 1990-12-28 | Ogilvy, Adams & Rinehart, Inc. | New York | NY | |||
16264 | 16264 | 1994-12-31 | Israel Ministry of Tourism | 1990-12-27 | ISRAEL | Conn Communications 4454 | 1990-12-27 | Conn Communications | New York | NY | |||
7092 | 7092 | 1991-05-31 | Asahi Chemical Industry America, Inc. | 1990-12-07 | JAPAN | Cosmo Public Relations 4434 | 1990-11-13 | Cosmo Public Relations | New York | NY | |||
7095 | 7095 | 1991-05-31 | Chugai Pharma U.S.A., Inc. | 1990-11-13 | JAPAN | Cosmo Public Relations 4434 | 1990-11-13 | Cosmo Public Relations | New York | NY | |||
7110 | 7110 | 1991-05-31 | Kyowa Hakko U.S.A., Inc. | 1990-11-13 | JAPAN | Cosmo Public Relations 4434 | 1990-11-13 | Cosmo Public Relations | New York | NY | |||
7112 | 7112 | 1991-05-31 | Meiji Seika (U.S.A.), Inc. | 1990-11-29 | JAPAN | Cosmo Public Relations 4434 | 1990-11-13 | Cosmo Public Relations | New York | NY | |||
7115 | 7115 | 1991-05-31 | Sankyo U.S.A. Corporation | 1990-11-13 | JAPAN | Cosmo Public Relations 4434 | 1990-11-13 | Cosmo Public Relations | New York | NY | |||
7123 | 7123 | 1991-05-31 | Teijin America, Inc. | 1990-11-29 | JAPAN | Cosmo Public Relations 4434 | 1990-11-13 | Cosmo Public Relations | New York | NY | |||
7124 | 7124 | 1991-05-31 | Toray Industries (America), Inc. | 1990-12-17 | JAPAN | Cosmo Public Relations 4434 | 1990-11-13 | Cosmo Public Relations | New York | NY | |||
7131 | 7131 | 1991-05-31 | Zeria U.S.A., Inc. | 1990-12-17 | JAPAN | Cosmo Public Relations 4434 | 1990-11-13 | Cosmo Public Relations | New York | NY | |||
5264 | 5264 | 1993-04-14 | Curacao Tourist Board | 1990-11-13 | CURACAO | Alden Advertising Agency, Inc. 4433 | 1990-11-13 | Alden Advertising Agency, Inc. | New York | NY | |||
5947 | 5947 | 1995-04-30 | Investimentos Comercio e Turismo de Portugal (ICEP) Formerly: Govt. of Portugal/Portuguese Natl. Tourist Office | 1994-10-21 | PORTUGAL | Harron & Associates 4431 | 1990-08-07 | Harron & Associates | New York | NY | |||
16172 | 16172 | 1990-12-31 | Portuguese Trade Commission | 1990-08-07 | PORTUGAL | Harron & Associates 4431 | 1990-08-07 | Harron & Associates | New York | NY | |||
7495 | 7495 | 1993-06-02 | Jiewon Park | 1992-01-30 | KOREA, SOUTH | Gowran International, Ltd. 4417 | 1990-10-03 | Gowran International, Ltd. | New York | 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 | |||
13134 | 13134 | 1993-10-29 | National Commercial Bank | 1991-08-21 | SAUDI ARABIA | Carl Byoir & Associates 4411 | 1990-09-12 | Carl Byoir & Associates | New York | NY | |||
8994 | 8994 | 1991-07-03 | U.S.A.-North Europe Rate Agreement (USANERA) | 1990-09-05 | GREAT BRITAIN | Levy, Howard A. 4409 | 1990-09-05 | Levy, Howard A. | New York | NY | |||
13270 | 13270 | 1990-10-31 | Government of the People's Republic of Angola | 1990-07-03 | ANGOLA | Wise Communications 4393 | 1990-07-03 | Wise Communications | New York | NY | |||
10238 | 10238 | 1993-08-09 | Portuguese National Tourist Office | 1990-06-06 | PORTUGAL | Davisworks 4384 | 1990-06-06 | Davisworks | New York | NY | |||
14488 | 14488 | 2000-11-30 | Barbados Industrial Development Corporation | 1990-05-17 | BARBADOS | W.D.B. Advertising 4376 | 1990-05-17 | W.D.B. Advertising | New York | NY | |||
16259 | 16259 | 1994-12-31 | Government of Israel, Ministry of Defense Mission to the U.S. | 1989-12-06 | ISRAEL | Dater, Elliot 4322 | 1989-12-06 | Dater, Elliot | New York | NY | |||
4012 | 4012 | 1993-03-24 | Government of the People's Republic of Angola | 1989-11-30 | ANGOLA | Tuba, Paulo 4318 | 1989-11-30 | Tuba, Paulo | 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 | |||
8896 | 8896 | 1993-07-01 | Ameribrom, Inc. | 1991-04-30 | ISRAEL | Cassidy & Associates, Inc. 4259 | 1989-05-25 | Cassidy & Associates, Inc. | New York | NY | |||
14916 | 14916 | 1992-12-09 | Government of Guyana | 1992-07-07 | GUYANA | Prince, Leslie F. 4238 | 1989-04-17 | Prince, Leslie F. | New York | NY | |||
15495 | 15495 | 1992-12-30 | Jamaica Tourist Board | 1990-05-31 | JAMAICA | Peter Martin Associates, Inc. 4236 | 1989-04-05 | Peter Martin Associates, 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 | |||
2705 | 2705 | 1989-02-22 | Czechoslovak Travel Bureau | 1989-02-22 | CZECHOSLOVAKIA | Aviso, Inc. 4220 | 1989-02-22 | Aviso, Inc. | New York | NY | |||
16180 | 16180 | 1990-12-31 | Statoil North America, Inc. | 1989-09-22 | NORWAY | Washington Policy & Analysis 4211 | 1989-01-27 | Washington Policy & Analysis | 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 | |||
8496 | 8496 | 1992-06-30 | Australian Trade Commission | 1989-01-24 | AUSTRALIA | Marston Webb & Associates, Inc. 4209 | 1989-01-24 | Marston Webb & Associates, Inc. | New York | NY | |||
9381 | 9381 | 1994-07-20 | Government of South Africa | 1992-10-02 | SOUTH AFRICA | Marston Webb & Associates, Inc. 4209 | 1989-01-24 | Marston Webb & 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 | |||
6752 | 6752 | 1997-05-23 | Barbados Board of Tourism | 1988-11-23 | BARBADOS | West Glen Communications 4191 | 1988-11-23 | West Glen Communications | New York | NY | |||
7077 | 7077 | 1990-05-31 | Czechoslovak Travel Bureau | 1988-11-23 | CZECHOSLOVAKIA | West Glen Communications 4191 | 1988-11-23 | West Glen Communications | New York | NY | |||
7082 | 7082 | 1990-05-31 | Norwegian Tourist Board | 1988-11-23 | NORWAY | West Glen Communications 4191 | 1988-11-23 | West Glen Communications | New York | NY | |||
8465 | 8465 | 1990-06-30 | Scandinavian Tourist Board | 1988-11-23 | INTERNATIONAL | West Glen Communications 4191 | 1988-11-23 | West Glen Communications | New York | NY | |||
8515 | 8515 | 1994-06-30 | Belgian Tourist Office | 1993-08-30 | BELGIUM | West Glen Communications 4191 | 1988-11-23 | West Glen Communications | New York | NY | |||
9803 | 9803 | 1994-07-31 | Finnish Tourist Board | 1988-11-23 | FINLAND | West Glen Communications 4191 | 1988-11-23 | West Glen Communications | New York | 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 | |||
13368 | 13368 | 1997-10-31 | Israeli Government Tourist Office | 1988-11-23 | ISRAEL | West Glen Communications 4191 | 1988-11-23 | West Glen Communications | New York | NY | |||
13906 | 13906 | 1992-11-12 | Danish Tourist Board | 1988-11-23 | DENMARK | West Glen Communications 4191 | 1988-11-23 | West Glen Communications | New York | NY | |||
13908 | 13908 | 1992-11-12 | Swedish Tourist Board | 1988-11-23 | SWEDEN | West Glen Communications 4191 | 1988-11-23 | West Glen Communications | New York | NY | |||
14448 | 14448 | 1994-11-30 | Iceland Tourist Board | 1988-11-23 | ICELAND | West Glen Communications 4191 | 1988-11-23 | West Glen Communications | 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]) );