FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
19 rows where Foreign_Principal_Termination_Date = "" and State = "NY" sorted by Address_1
This data as json, CSV (advanced)
Suggested facets: Address_1, Address_2, Zip, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 19
- APCO Worldwide LLC 1
- Austrian Tourist Office, Inc. 1
- BGR Government Affairs, LLC 1
- Cogent Strategies LLC 1
- Finn Partners, Inc. 1
- Geoffrey Weill 1
- Hill and Knowlton Strategies, LLC 1
- Independent Diplomat, Inc. 1
- Jacobs Global Trade & Compliance LLC 1
- MMGY Global, LLC 1
- MWW Group, LLC 1
- McLarty Inbound, LLC 1
- Mercury Public Affairs, LLC 1
- Myriad International Marketing, LLC 1
- Patino, Brewster & Partners 1
- Prism Strategy, Inc. 1
- Quinn & Co. of NY LTD. 1
- South/North Communications LLC 1
- Tourism Ireland Limited 1
Foreign_Principal 18
- Hong Kong Trade Development Council 2
- Austrian National Tourist Office 1
- Consulate General of Japan 1
- Consulate General of Japan in New York 1
- Enterprise Ireland 1
- GOTURKIYE - Turkish Ministry of Culture & Tourism 1
- German National Tourist Office 1
- Government of Japan - Japan External Trade Organization 1
- Government of Mauritius 1
- Israel Ministry of Tourism 1
- Ministry of Tourism of the Dominican Republic and Dominican Republic Tourism Board Office 1
- Mission of the Republic of the Marshall Islands to the United Nations 1
- OCP North America, Inc.(OCPNA) 1
- Pakistan Tehreek-e-Insaaf USA 1
- Tourism Authority of Thailand 1
- Tourism Ireland Limited 1
- Turespana Tourist Office of Spain 1
- United Nations Office of the High Representative for the Least Developed Countries, Landlocked Developing Countries and Small Island Developing States (UN-OHRLLS) 1
Country/Location_Represented 15
- JAPAN 3
- HONG KONG 2
- IRELAND 2
- AUSTRIA 1
- DOMINICAN REPUBLIC 1
- GERMANY 1
- INTERNATIONAL 1
- ISRAEL 1
- MARSHALL ISLANDS 1
- MAURITIUS 1
- MOROCCO 1
- PAKISTAN 1
- SPAIN 1
- THAILAND 1
- TURKEY 1
City 4
- New York 15
- - 2
- New York 1
- New York, NY 1
State 1
- NY · 19 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
262 | 262 | German National Tourist Office | 2018-04-30 | GERMANY | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 122 East 42nd Street, Suite 2000 | New York | NY | 10168 | ||
533 | 533 | OCP North America, Inc.(OCPNA) | 2022-01-13 | MOROCCO | Cogent Strategies LLC 6927 | 2021-02-23 | Cogent Strategies LLC | 1370 Sixth Avenue | 32nd Floor | New York | NY | 10019 | |
488 | 488 | Ministry of Tourism of the Dominican Republic and Dominican Republic Tourism Board Office | 2023-03-07 | DOMINICAN REPUBLIC | Patino, Brewster & Partners 7236 | 2023-03-07 | Patino, Brewster & Partners | 156 W. 56th St., Suite 2003 | New York | NY | 10019 | ||
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 | ||
128 | 128 | Consulate General of Japan | 2018-07-11 | JAPAN | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 299 Park Avenue, 19th Floor | New York | NY | 10171 | ||
127 | 127 | Consulate General of Japan in New York | 2021-03-30 | JAPAN | APCO Worldwide LLC 6582 | 2018-08-22 | APCO Worldwide LLC | 299 Park Avenue, Suite 19 | New York | NY | 10171 | ||
713 | 713 | Tourism Ireland Limited | 2003-11-20 | IRELAND | Tourism Ireland Limited 5594 | 2003-11-20 | Tourism Ireland Limited | 345 Park Avenue, New York 10154 | NY | ||||
240 | 240 | Enterprise Ireland | 2023-01-09 | IRELAND | Finn Partners, Inc. 6212 | 2014-03-10 | Finn Partners, Inc. | 345 Park Avenue, 17th Floor | New York | NY | 10154 | ||
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 | ||
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 | |
724 | 724 | Turespana Tourist Office of Spain | 2020-12-16 | SPAIN | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 60 East 42nd Street, Suite 5300 | New York | NY | 10165 | ||
710 | 710 | Tourism Authority of Thailand | 2017-10-11 | THAILAND | Quinn & Co. of NY LTD. 6433 | 2017-05-24 | Quinn & Co. of NY LTD. | 61 Broadway, Suite 2810 | New York | NY | 10006 | ||
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 | |
492 | 492 | Mission of the Republic of the Marshall Islands to the United Nations | 2011-11-30 | MARSHALL ISLANDS | Independent Diplomat, Inc. 5860 | 2008-04-03 | Independent Diplomat, Inc. | 800 Second Avenue, 18th Floor | New York | NY | 10017 | ||
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 | ||
551 | 551 | Pakistan Tehreek-e-Insaaf USA | 2022-08-09 | PAKISTAN | South/North Communications LLC 6972 | 2021-06-10 | South/North Communications LLC | C/o Criscione Ravala LLP, 250 Park Avenue 7th floor | New York | NY | 10177 | ||
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 | |
57 | 57 | Austrian National Tourist Office | 1947-10-03 | AUSTRIA | Austrian Tourist Office, Inc. 495 | 1947-10-03 | Austrian Tourist Office, 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]) );