FARA_All_ShortForms

List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

14,765 rows where State = "NY"

✎ View and edit SQL

This data as json, atom, CSV (advanced)

Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

Registration_Number

State

  • NY · 14,765 ✖
Link rowid Short_Form_Termination_Date Short_Form_Date Short_Form_Last_Name Short_Form_First_Name Registration_Number Registration_Date Registrant_Name Address_1 Address_2 City State Zip
4 4     Huneault Philippe 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
6 6     Lamm Carolyn Beth 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
7 7     Lamsam Larada Songkanda 6568 6568 2018-07-05 Luque PLLC 25 Broadway 9th Floor New York NY 10004
15 15   2018-01-01 Amador Diana 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
16 16   2018-01-01 Benitez Espinosa Gilda L. 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
17 17   2018-01-01 Charlier Bissacot Denise Talarico 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
18 18   2018-01-01 Cruz Monica 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
19 19   2018-01-01 Cunillera Cristina 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
20 20   2018-01-01 Di Domizio Eliana 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
21 21   2018-01-01 Elias Virginia 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
22 22   2018-01-01 Ezquerra Maria Jose 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
23 23   2018-01-01 Garrido Wendolyn 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
24 24   2018-01-01 Llanos Idalma 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
25 25   2018-01-01 Marino Evelyn 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
26 26   2018-01-01 Ruiz Maria 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
27 27   2018-01-01 Soto Lorraine 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
28 28   2018-01-01 de la Torriente Diana 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
32 32   2019-01-02 Pereira Roman Francis 2329 2329 1972-04-05 India Tourism, New York 1270 Avenue of the Americas Suite 303 New York NY 10020-1700
33 33   2019-01-02 Velayutham Senthur Kumaran 2329 2329 1972-04-05 India Tourism, New York 1270 Avenue of the Americas Suite 303 New York NY 10020-1700
38 38   2008-01-04 Bjorkner Arthur C. 4860 4860 1993-10-12 Office of the Deputy Commissioner of Maritime Affairs 39 Broadway Suite 2020 New York NY 10006
39 39   2008-01-04 Rescigno Dorothy A. 4860 4860 1993-10-12 Office of the Deputy Commissioner of Maritime Affairs 39 Broadway Suite 2020 New York NY 10006
42 42   2017-01-05 Gonda Tadashi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
44 44   2018-01-05 Prakongpan Montira 1897 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
47 47   2020-01-06 Coster John 6698 6698 2019-07-08 Teneo Strategy LLC 280 Park Avenue 4th Floor New York NY 10017
61 61   2019-01-09 Hulsey G. Scott 6604 6604 2018-10-31 Kobre & Kim LLP 800 Third Avenue   New York NY 10022
62 62   2019-01-09 Kolton Chad 6604 6604 2018-10-31 Kobre & Kim LLP 800 Third Avenue   New York NY 10022
63 63   2019-01-09 Morrell James C. 6604 6604 2018-10-31 Kobre & Kim LLP 800 Third Avenue   New York NY 10022
66 66   2019-01-09 Weems L. Wade 6604 6604 2018-10-31 Kobre & Kim LLP 800 Third Avenue   New York NY 10022
67 67   2019-01-09 West Hartley 6604 6604 2018-10-31 Kobre & Kim LLP 800 Third Avenue   New York NY 10022
68 68   2020-01-09 Furujo Tatsuya 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
79 79   2019-01-11 Meyers Hannah 6571 6571 2018-07-13 Guidepost Solutions LLC 415 Madison Avenue 11th Floor New York NY 10017
81 81   2018-01-12 Brandwein David 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
84 84   1998-01-13 Ginther Jeffrey William 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
135 135   2019-01-22 Fan Xiuyun 3318 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
138 138   2020-01-22 Beard Hannah 6785 6785 2020-01-22 Peregrine Communications Inc. 405 Lexington Avenue 9th Floor New York NY 10174
139 139   2020-01-22 Hilton Max 6785 6785 2020-01-22 Peregrine Communications Inc. 405 Lexington Avenue 9th Floor New York NY 10174
141 141   2020-01-22 Vertrano Kalli 6785 6785 2020-01-22 Peregrine Communications Inc. 405 Lexington Avenue 9th Floor New York NY 10174
142 142   2017-01-23 Gold Amrei 616 616 1950-02-28 German National Tourist Office 122 East 42nd Street Suite 2000 New York NY 10168
144 144   2017-01-23 Nuss Linda 616 616 1950-02-28 German National Tourist Office 122 East 42nd Street Suite 2000 New York NY 10168
149 149   2019-01-24 Henoch Robert 6604 6604 2018-10-31 Kobre & Kim LLP 800 Third Avenue   New York NY 10022
169 169   2019-01-25 Barnes Beaudre D. 6604 6604 2018-10-31 Kobre & Kim LLP 800 Third Avenue   New York NY 10022
173 173   2017-01-27 Pizziferri Michael 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
174 174   2017-01-27 Westfall Leslie Cecile 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
182 182   2016-01-28 Kazlauskas Kirsten Constance 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
183 183   2016-01-28 Larouche Benoit 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
184 184   2016-01-28 MacKay Elizabeth 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
189 189   2020-01-28 Hada Kunio 769 769 1953-05-26 Japan National Tourism Organization One Grand Central Place 60th East 42nd Street, Suite 448 New York NY 10165
198 198   2006-01-30 Douglas Donna Willa-Mae 430 430 1947-01-30 Bermuda Tourism Authority 675 Third Avenue 12th Floor New York NY 10017
208 208   1992-01-31 Cenzuales Giovanni 568 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
209 209   1992-01-31 Manassero Dennis 568 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
210 210   1992-01-31 Scaldaferri Maria C. 568 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
217 217   2017-01-31 Nagao Yusuke 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
218 218   2017-01-31 Shartzer Andrew 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
227 227   2020-01-31 Davoine Caroline 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
228 228   2020-01-31 Kolthoff Ishmael 430 430 1947-01-30 Bermuda Tourism Authority 675 Third Avenue 12th Floor New York NY 10017
229 229   2020-01-31 Langlois Frederic 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
230 230   2020-01-31 Lanthier Sebastien 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
231 231   2020-01-31 Lauzon Audrey Laroche 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
232 232   2020-01-31 Martine Hebert 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
233 233   2006-02-01 Tanaka Yumiko 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
234 234   2007-02-01 Turquetil Yoann 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
235 235   2017-02-01 Fukumasu Shinichi 769 769 1953-05-26 Japan National Tourism Organization One Grand Central Place 60th East 42nd Street, Suite 448 New York NY 10165
239 239   2018-02-02 Briand Fortin Anne Catherine 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
241 241   2018-02-02 Dionne Martin 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
246 246   2018-02-02 Hould Jean Francois 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
247 247   2018-02-02 Labrie Josee-Anne 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
248 248   2018-02-02 Lepage Annelise Melanie 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
251 251   2018-02-02 Rose Peter Alan 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
255 255   2018-02-02 Townrow Andrea 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
257 257   2003-02-04 Haber Leo 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
258 258   2011-02-04 Israeli Hasia 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
260 260   2015-02-04 Beck James 5875 5875 2008-06-17 BLJ Worldwide LTD 1359 Broadway Suite 1102 New York NY 10018
261 261   2016-02-04 Simonsen Kathrine 634 634 1950-07-25 VisitDenmark 655 Third Avenue 18th Floor, Suite 1810 New York NY 10017
262 262   2019-02-04 DeLelle Claire 6393 6393 2016-11-21 White & Case LLP 1221 Avenue of the Americas   New York NY 10036
264 264   2019-02-04 McLaughlin Celia 6393 6393 2016-11-21 White & Case LLP 1221 Avenue of the Americas   New York NY 10036
265 265   1988-02-05 Nardone Silverio 568 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
273 273   2020-02-06 Borg Christina 6791 6791 2020-02-06 BerlinRosen, Ltd. 15 Maiden Lane Suite 1600 New York NY 10038
274 274   2020-02-06 Brandon Laura 6791 6791 2020-02-06 BerlinRosen, Ltd. 15 Maiden Lane Suite 1600 New York NY 10038
275 275   2020-02-06 Cadambi Anjali 6791 6791 2020-02-06 BerlinRosen, Ltd. 15 Maiden Lane Suite 1600 New York NY 10038
276 276   2020-02-06 Massey Daniel 6791 6791 2020-02-06 BerlinRosen, Ltd. 15 Maiden Lane Suite 1600 New York NY 10038
277 277   2020-02-06 McDonough Alejandra Manuela 6791 6791 2020-02-06 BerlinRosen, Ltd. 15 Maiden Lane Suite 1600 New York NY 10038
278 278   2020-02-06 Mehta Shreema 6791 6791 2020-02-06 BerlinRosen, Ltd. 15 Maiden Lane Suite 1600 New York NY 10038
279 279   2020-02-06 PiSierra Zoe 6791 6791 2020-02-06 BerlinRosen, Ltd. 15 Maiden Lane Suite 1600 New York NY 10038
282 282   2013-02-07 Raposo Antonio 526 526 1948-05-13 Innovation Norway 655 Third Avenue, 18th Floor Suite 1810 New York NY 10017
309 309   2004-02-12 Orduz Juan Esteban 4909 4909 1994-04-06 Colombian Coffee Federation, Inc. 140 East 57th Street   New York NY 10022
315 315   2006-02-15 Dion Jean Pierre 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
326 326   2015-02-18 Dufresne Caroline 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
327 327   2015-02-18 Gauchet Cyril 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
346 346   2017-02-23 Masisi Keabetswe Bangu 603 603 1950-01-04 South African Tourism 500 Fifth Avenue Suite 2200 New York NY 10110-0002
351 351   2014-02-24 Cheung Winchell 2181 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
353 353   2019-02-25 Andrus Eric 6162 6162 2013-04-08 Karv Communications, Inc. 122 East 42nd Street Suite 2005 New York NY 10168
354 354   2019-02-25 Handjani Amirali 6162 6162 2013-04-08 Karv Communications, Inc. 122 East 42nd Street Suite 2005 New York NY 10168
359 359   2015-02-26 Sarcevich George 6057 6057 2011-08-16 Myrmidon Group, LLC 53 Saint Mark's Place #1 New York NY 10003
362 362   2019-02-26 Qiu Mengyun 6604 6604 2018-10-31 Kobre & Kim LLP 800 Third Avenue   New York NY 10022
364 364   2019-02-26 Wang Nan 6604 6604 2018-10-31 Kobre & Kim LLP 800 Third Avenue   New York NY 10022
365 365   2019-02-26 Weightman William 6604 6604 2018-10-31 Kobre & Kim LLP 800 Third Avenue   New York NY 10022
366 366   2019-02-26 Wu Shaun Z. 6604 6604 2018-10-31 Kobre & Kim LLP 800 Third Avenue   New York NY 10022
367 367   2019-02-26 Zheng Mengquan 6604 6604 2018-10-31 Kobre & Kim LLP 800 Third Avenue   New York NY 10022
368 368   2019-02-27 McCormack Turlough 1770 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
369 369   1989-02-28 Torra Veronica 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [FARA_All_ShortForms] (
   [Short_Form_Termination_Date] TEXT,
   [Short_Form_Date] TEXT,
   [Short_Form_Last_Name] TEXT,
   [Short_Form_First_Name] TEXT,
   [Registration_Number] INTEGER,
   [Registration_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)
);
Powered by Datasette · Query took 553.586ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history