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,433 rows where City = "New York"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registration_Number

State

  • NY 14,433

City

  • New York · 14,433 ✖
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     Antognelli Guy 2327 2327 1972-03-21 Monaco Government Tourist Office 565 Fifth Avenue 23rd Floor New York NY 10017
8 8     Chantharangkun Natthinee 1897 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
28 28   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
29 29   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
30 30   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
31 31   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
32 32   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
33 33   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
34 34   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
35 35   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
36 36   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
37 37   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
38 38   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
41 41   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
42 42   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
46 46   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
47 47   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
49 49   2017-01-05 Gonda Tadashi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
51 51   2018-01-05 Prakongpan Montira 1897 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
54 54   2020-01-06 Coster John 6698 6698 2019-07-08 Teneo Strategy LLC 280 Park Avenue 4th Floor New York NY 10017
70 70   2020-01-09 Furujo Tatsuya 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
80 80   2019-01-11 Meyers Hannah 6571 6571 2018-07-13 Guidepost Solutions LLC 415 Madison Avenue 11th Floor New York NY 10017
82 82   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
83 83   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
125 125   2020-01-22 Beard Hannah 6785 6785 2020-01-22 Peregrine Communications Inc. 405 Lexington Avenue 9th Floor New York NY 10174
126 126   2020-01-22 Hilton Max 6785 6785 2020-01-22 Peregrine Communications Inc. 405 Lexington Avenue 9th Floor New York NY 10174
128 128   2020-01-22 Vertrano Kalli 6785 6785 2020-01-22 Peregrine Communications Inc. 405 Lexington Avenue 9th Floor New York NY 10174
129 129   2017-01-23 Gold Amrei 616 616 1950-02-28 German National Tourist Office 122 East 42nd Street Suite 2000 New York NY 10168
130 130   2017-01-23 Nuss Linda 616 616 1950-02-28 German National Tourist Office 122 East 42nd Street Suite 2000 New York NY 10168
134 134   2019-01-24 Henoch Robert 6604 6604 2018-10-31 Kobre & Kim LLP 800 Third Avenue   New York NY 10022
154 154   2017-01-27 Pizziferri Michael 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
155 155   2017-01-27 Westfall Leslie Cecile 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
164 164   2016-01-28 Kazlauskas Kirsten Constance 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
165 165   2016-01-28 Larouche Benoit 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
169 169   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
175 175   2006-01-30 Douglas Donna Willa-Mae 430 430 1947-01-30 Bermuda Tourism Authority 675 Third Avenue 12th Floor New York NY 10017
181 181   2020-01-30 Cunillera Cristina De Jesus 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
185 185   2020-01-30 Pagliery Patricia 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
186 186   2020-01-30 Reich Allegra 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
187 187   2020-01-30 Sepulveda Mayerly 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
188 188   2020-01-30 Sepulveda Mayerly 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
190 190   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
191 191   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
192 192   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
199 199   2017-01-31 Nagao Yusuke 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
200 200   2017-01-31 Shartzer Andrew 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
205 205   2020-01-31 Davoine Caroline 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
206 206   2020-01-31 Huneault Philippe 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
210 210   2020-01-31 Langlois Frederic 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
211 211   2020-01-31 Lanthier Sebastien 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
212 212   2020-01-31 Lauzon Audrey Laroche 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
213 213   2020-01-31 Martine Hebert 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
217 217   2006-02-01 Tanaka Yumiko 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
218 218   2007-02-01 Turquetil Yoann 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
219 219   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
222 222   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
223 223   2018-02-02 Dionne Martin 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
227 227   2018-02-02 Labrie Josee-Anne 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
228 228   2018-02-02 Lepage Annelise Melanie 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
231 231   2018-02-02 Rose Peter Alan 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
233 233   2018-02-02 Townrow Andrea 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
235 235   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
236 236   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
238 238   2015-02-04 Beck James 5875 5875 2008-06-17 BLJ Worldwide LTD 1359 Broadway Suite 1102 New York NY 10018
239 239   2016-02-04 Simonsen Kathrine 634 634 1950-07-25 VisitDenmark 655 Third Avenue 18th Floor, Suite 1810 New York NY 10017
240 240   2019-02-04 DeLelle Claire 6393 6393 2016-11-21 White & Case LLP 1221 Avenue of the Americas   New York NY 10036
242 242   2019-02-04 McLaughlin Celia 6393 6393 2016-11-21 White & Case LLP 1221 Avenue of the Americas   New York NY 10036
247 247   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
257 257   2013-02-07 Raposo Antonio 526 526 1948-05-13 Innovation Norway WeWork Bryant Park 54 W 40t Street New York NY 10018
280 280   2004-02-12 Orduz Juan Esteban 4909 4909 1994-04-06 Colombian Coffee Federation, Inc. 140 East 57th Street   New York NY 10022
285 285   2020-02-13 Eynon Edward 6793 6793 2020-02-13 BurgherGray LLP 1350 Broadway Suite 406 New York NY 10018
286 286   2020-02-13 Parikh Gaurav Pradeep 6793 6793 2020-02-13 BurgherGray LLP 1350 Broadway Suite 406 New York NY 10018
291 291   2006-02-15 Dion Jean Pierre 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
300 300   2015-02-18 Dufresne Caroline 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
301 301   2015-02-18 Gauchet Cyril 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
322 322   2017-02-23 Masisi Keabetswe Bangu 603 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
326 326   2014-02-24 Cheung Winchell 2181 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
342 342   2019-02-25 Andrus Eric 6162 6162 2013-04-08 Karv Communications, Inc. 122 East 42nd Street Suite 2005 New York NY 10168
345 345   2015-02-26 Sarcevich George 6057 6057 2011-08-16 Myrmidon Group, LLC 53 Saint Mark's Place #1 New York NY 10003
354 354   2019-02-27 McCormack Turlough 1770 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
355 355   2020-02-27 Grassinger Daniel 6015 6015 2011-01-07 Bavarian U.S. Offices for Economic Development, LLC 80 Pine Street 24th Floor New York NY 10005
356 356   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
363 363   2020-02-28 McWilliams Sean 1770 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
364 364   2017-03-01 Mister James E. 6015 6015 2011-01-07 Bavarian U.S. Offices for Economic Development, LLC 80 Pine Street 24th Floor New York NY 10005
368 368   2009-03-02 Gagnon Laurence 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
369 369   2010-03-02 Giovanetti Isabella 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
370 370   2011-03-02 Nakajima Daiki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
375 375   2004-03-03 Castro Mary Rosetta 430 430 1947-01-30 Bermuda Tourism Authority 675 Third Avenue 12th Floor New York NY 10017
380 380   2016-03-03 Wakamatsu Isamu 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
384 384   2020-03-04 Baumann Terri 6797 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
385 385   2020-03-04 Dickson Madeline 6797 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
386 386   2020-03-04 Fairchild Elizabeth 6797 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
387 387   2020-03-04 Harrison Melissa 6797 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
388 388   2020-03-04 Mackenzie Kimberly 6797 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
389 389   2020-03-04 Merritt Matthew 6797 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
390 390   2020-03-04 Pope Kristie 6797 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
391 391   2020-03-04 Redmond Hillary 6797 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
392 392   2020-03-04 Vardaro Valerie 6797 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
393 393   2001-03-05 Waessa Laurent 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
394 394   2012-03-05 Dempsey Amanda Jane 430 430 1947-01-30 Bermuda Tourism Authority 675 Third Avenue 12th Floor New York NY 10017

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 559.478ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history