FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where City = "New York" and Foreign_Principal_Termination_Date = "" sorted by State
This data as json, CSV (advanced)
Suggested facets: Address_1, Address_2, Zip, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 15
- APCO Worldwide LLC 1
- BGR Government Affairs, LLC 1
- Finn Partners, Inc. 1
- Geoffrey Weill 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
Foreign_Principal 14
- Hong Kong Trade Development Council 2
- 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
- Pakistan Tehreek-e-Insaaf USA 1
- Tourism Authority of Thailand 1
- Turespana Tourist Office of Spain 1
Country/Location_Represented 12
State 1
- NY 15
City 1
- New York · 15 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |
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 | ||
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 | ||
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 | ||
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 | ||
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 |
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]) );