FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
29 rows where State = "NY" and Zip = 10017
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Registration_Number, Registrant_Date, Address_1, Address_2, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Registrant_Name 26
- BGR Government Affairs, LLC 2
- Geoffrey Weill Associates 2
- Myriad International Marketing, LLC 2
- APCO Worldwide, Inc. 1
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- Ballard Partners 1
- Brown Legal Consulting, LLC 1
- Clark, Mark Edmond 1
- Daniel J. Edelman, Inc. 1
- Foley Hoag, LLP 1
- Geoffrey Weill 1
- Hill and Knowlton Strategies, LLC 1
- Hopps & Associates, Inc. 1
- Independent Diplomat, Inc. 1
- Jacobs Global Trade & Compliance LLC 1
- Luxcore, Ltd. 1
- M. Silver Associates, Inc. 1
- MMGY Global, LLC 1
- MWW Group, LLC 1
- McLarty Inbound, LLC 1
- Mercury Public Affairs, LLC 1
- Podesta Group, Inc. 1
- Prism Strategy, Inc. 1
- Project Associates UK Ltd. 1
- Ruder Finn, Inc. 1
- Spring O'Brien & Company, Inc. 1
Foreign_Principal 24
- Government of Mauritius 3
- China National Tourist Office 2
- Hong Kong Trade Development Council 2
- Israel Ministry of Tourism 2
- Bermuda Tourism Authority 1
- Consulate of Kazakhstan 1
- GOTURKIYE - Turkish Ministry of Culture & Tourism 1
- Government of Japan - Japan External Trade Organization 1
- Maldives Marketing and Public Relations Corporation 1
- Mission of Libya to the UN 1
- Mission of the Islamic Republic of Iran to the UN 1
- National Coalition Government of the Union of Burma (NCGUB) 1
- Netherlands Foreign Investment Agency 1
- Permanent Mission of Italy to the United Nations 1
- Permanent Mission of the Kingdom of Saudi Arabia 1
- Permanent Mission of the Republic of Maldives to the United Nations 1
- Permanent Mission of the United Arab Emirates to the United Nations 1
- Portuguese National Tourist Office 1
- Republic of Maldives 1
- Republic of Mauritius 1
- Turkish Culture & Tourism Office 1
- Turkish Culture and Tourist Office 1
- United Nations Office of the High Representative for the Least Developed Countries, Landlocked Developing Countries and Small Island Developing States (UN-OHRLLS) 1
- Visit Denmark 1
Country/Location_Represented 19
- MAURITIUS 4
- MALDIVES 3
- TURKEY 3
- CHINA 2
- HONG KONG 2
- ISRAEL 2
- BERMUDA 1
- DENMARK 1
- INTERNATIONAL 1
- IRAN 1
- ITALY 1
- JAPAN 1
- KAZAKHSTAN 1
- LIBYA 1
- MYANMAR (BURMA) 1
- NETHERLANDS 1
- PORTUGAL 1
- SAUDI ARABIA 1
- UNITED ARAB EMIRATES 1
City 3
- New York 27
- New York 1
- New York, NY 1
State 1
- NY · 29 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
259 | 259 | GOTURKIYE - Turkish Ministry of Culture & Tourism | 2022-09-27 | TURKEY | Geoffrey Weill 7173 | 2022-09-27 | Geoffrey Weill | 823 United Nations Plaza | New York | NY | 10017 | ||
285 | 285 | Government of Japan - Japan External Trade Organization | 2017-04-19 | JAPAN | Prism Strategy, Inc. 6419 | 2017-04-19 | Prism Strategy, Inc. | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
291 | 291 | Government of Mauritius | 2019-05-29 | MAURITIUS | McLarty Inbound, LLC 6686 | 2019-05-29 | McLarty Inbound, LLC | Mauritius Mission to the UN | 211 East 43rd Street 22nd Floor | New York | NY | 10017 | |
333 | 333 | Hong Kong Trade Development Council | 2019-04-05 | HONG KONG | BGR Government Affairs, LLC 5430 | 2001-05-10 | BGR Government Affairs, LLC | 219 East 46th Street | New York | NY | 10017 | ||
334 | 334 | Hong Kong Trade Development Council | 2019-04-08 | HONG KONG | Jacobs Global Trade & Compliance LLC 6656 | 2019-04-08 | Jacobs Global Trade & Compliance LLC | 219 East 46th Street | New York | NY | 10017 | ||
362 | 362 | Israel Ministry of Tourism | 2017-12-15 | ISRAEL | MWW Group, LLC 6381 | 2016-09-30 | MWW Group, LLC | 800 2nd Avenue | Floor 6 | New York | NY | 10017 | |
746 | 746 | United Nations Office of the High Representative for the Least Developed Countries, Landlocked Developing Countries and Small Island Developing States (UN-OHRLLS) | 2021-11-30 | INTERNATIONAL | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 405 East 42nd Street | New York, NY | NY | 10017 | ||
2175 | 2175 | 2010-02-03 | National Coalition Government of the Union of Burma (NCGUB) | 2008-04-03 | MYANMAR (BURMA) | Independent Diplomat, Inc. 5860 | 2008-04-03 | Independent Diplomat, Inc. | Dr. Thaung Htun, UN Representative | Burma UN Service Office, 777 UN Plaza, 6th Floor | New York | NY | 10017 |
2386 | 2386 | 2013-02-11 | Mission of the Islamic Republic of Iran to the UN | 2006-06-22 | IRAN | Clark, Mark Edmond 5755 | 2006-06-22 | Clark, Mark Edmond | 622 Third Avenue | 34th Floor | New York | NY | 10017 |
3099 | 3099 | 2013-02-28 | Permanent Mission of the Kingdom of Saudi Arabia | 2013-03-15 | SAUDI ARABIA | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 809 UN Plaza 10th Floor | New York | NY | 10017 | |
3136 | 3136 | 2019-02-28 | China National Tourist Office | 2018-04-30 | CHINA | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 370 Lexington Avenue #912 | New York | NY | 10017 | |
3348 | 3348 | 2014-03-01 | Turkish Culture and Tourist Office | 2013-03-19 | TURKEY | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 821 United Nations Plaza | New York | NY | 10017 | |
3785 | 3785 | 2010-03-15 | Mission of Libya to the UN | 2009-09-01 | LIBYA | Hopps & Associates, Inc. 5948 | 2009-09-01 | Hopps & Associates, Inc. | 309 East 48th Street | New York | NY | 10017 | |
4733 | 4733 | 2013-03-31 | Government of Mauritius | 2012-04-20 | MAURITIUS | BGR Government Affairs, LLC 5430 | 2001-05-10 | BGR Government Affairs, LLC | 211 East 43rd Street, Suite 1502 | New York | NY | 10017 | |
4816 | 4816 | 2022-03-31 | Republic of Mauritius | 2019-09-06 | MAURITIUS | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | 211 East 43rd Street | 22nd Floor | New York | NY | 10017 |
6370 | 6370 | 2022-05-06 | Permanent Mission of Italy to the United Nations | 2021-10-06 | ITALY | Project Associates UK Ltd. 7024 | 2021-10-06 | Project Associates UK Ltd. | 885 2nd Avenue, 49th Floor | New York | NY | 10017 | |
9470 | 9470 | 2016-07-25 | Israel Ministry of Tourism | 2006-10-03 | ISRAEL | Geoffrey Weill Associates 5773 | 2006-10-03 | Geoffrey Weill Associates | 800 Second Avenue | 16th Floor | New York | NY | 10017 |
12256 | 12256 | 2019-09-30 | Netherlands Foreign Investment Agency | 2019-12-08 | NETHERLANDS | Luxcore, Ltd. 4901 | 1994-03-10 | Luxcore, Ltd. | 666 Third Avenue, 19th Floor | New York | NY | 10017 | |
13484 | 13484 | 2017-10-31 | Portuguese National Tourist Office | 2018-06-01 | PORTUGAL | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 866 Second Avenue, 8th Floor | New York | NY | 10017 | |
13488 | 13488 | 2017-10-31 | Visit Denmark | 2017-04-21 | DENMARK | Geoffrey Weill Associates 6421 | 2017-04-21 | Geoffrey Weill Associates | 655 Third Avenue | Suite 810 | New York | NY | 10017 |
13909 | 13909 | 2015-11-12 | Republic of Maldives | 2015-09-17 | MALDIVES | Podesta Group, Inc. 5926 | 2009-04-01 | Podesta Group, Inc. | 800 2nd Avenue, #400E | New York | NY | 10017 | |
14774 | 14774 | 2011-12-03 | Consulate of Kazakhstan | 2011-12-03 | KAZAKHSTAN | Brown Legal Consulting, LLC 6079 | 2011-12-03 | Brown Legal Consulting, LLC | 535 Fifth Avenue, 19th Floor | New York | NY | 10017 | |
14811 | 14811 | 2013-12-04 | Permanent Mission of the United Arab Emirates to the United Nations | 2013-09-05 | UNITED ARAB EMIRATES | APCO Worldwide, Inc. 6184 | 2013-09-05 | APCO Worldwide, Inc. | 3 Dag Hammarskjold Plaza/305 E 47th St. | New York | NY | 10017 | |
15054 | 15054 | 2018-12-12 | Maldives Marketing and Public Relations Corporation | 2018-02-21 | MALDIVES | Ballard Partners 6415 | 2017-04-05 | Ballard Partners | 801 Second Avenue, Suite 202 E | New York | NY | 10017 | |
16725 | 16725 | 2012-12-31 | Turkish Culture & Tourism Office | 2010-03-12 | TURKEY | M. Silver Associates, Inc. 3131 | 1980-07-15 | M. Silver Associates, Inc. | 821 United Nations Plaza, 4th Floor | New York | NY | 10017 | |
16742 | 16742 | 2014-12-31 | China National Tourist Office | 2014-01-30 | CHINA | Spring O'Brien & Company, Inc. 5872 | 2008-06-30 | Spring O'Brien & Company, Inc. | 370 Lexington Avenue | Suite #912 | New York | NY | 10017 |
16748 | 16748 | 2014-12-31 | Government of Mauritius | 2013-05-14 | MAURITIUS | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 211 East 43rd Street | Suite 1502 | New York | NY | 10017 |
16790 | 16790 | 2016-12-31 | Permanent Mission of the Republic of Maldives to the United Nations | 2016-06-23 | MALDIVES | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 801 Second Avenue, Suite 202E | New York | NY | 10017 | |
16846 | 16846 | 2019-12-31 | Bermuda Tourism Authority | 2017-11-27 | BERMUDA | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 675 Third Avenue, 20th Floor | New York | NY | 10017 |
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]) );