FARA_All_ShortForms

Table actions
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,986 rows where State = "NY"

✎ 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,986 ✖
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
1 1     Antognelli Guy 2327 2327 1972-03-21 Monaco Government Tourist Office 565 Fifth Avenue 23rd Floor New York NY 10017
2 2     Chantharangkun Natthinee 1897 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
7 7     Hang Tang Chung 2003 2003 1967-02-02 Singapore Economic Development Board 55 East 59th Street Suite 21 B, 21st Floor New York NY 10022
9 9     Jang Choong Sik 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11 11     Kho Dong Hyun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
12 12     Kim Chulmin 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
13 13     Lee Seok Hwan 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
14 14     Lee Yungsun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
23 23     Seo Jiwon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
30 30     Youngtae Kim 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
31 31   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
32 32   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
33 33   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
34 34   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
35 35   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
36 36   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
37 37   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
38 38   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
39 39   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
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
49 49   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
50 50   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
53 53   2018-01-05 Prakongpan Montira 1897 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
56 56   2020-01-06 Coster John 6698 6698 2019-07-08 Teneo Strategy LLC 280 Park Avenue 4th Floor New York NY 10017
72 72   2020-01-09 Furujo Tatsuya 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
85 85   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
86 86   2021-01-12 Belz Anne 6826 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
87 87   2021-01-12 Borkhoche Angela 6826 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
88 88   2021-01-12 Campbell Katherine 6826 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
89 89   2021-01-12 Hudak Cheryl 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
90 90   2021-01-12 Vazquez Vanessa 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
91 91   2021-01-12 Yamlikha Sana 6826 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
92 92   2021-01-12 van der Meijden Annabel 6826 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
93 93   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
96 96   2021-01-13 Rermruk Soothawee 1897 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
121 121   2021-01-18 Akram Mohammad 6908 6908 2021-01-18 PTI SCAD NA 50-54 Polk Avenue   Hempstead NY 11550
122 122   2021-01-18 Khan Adbul Hafeez 6908 6908 2021-01-18 PTI SCAD NA 50-54 Polk Avenue   Hempstead NY 11550
123 123   2021-01-18 Khan Qamar Zaman 6908 6908 2021-01-18 PTI SCAD NA 50-54 Polk Avenue   Hempstead NY 11550
135 135   2021-01-21 Goto Chikako 769 769 1953-05-26 Japan National Tourism Organization One Grand Central Place 60th East 42nd Street, Suite 448 New York NY 10165
141 141   2020-01-22 Beard Hannah 6785 6785 2020-01-22 Peregrine Communications Inc. 405 Lexington Avenue 9th Floor New York NY 10174
142 142   2020-01-22 Hilton Max 6785 6785 2020-01-22 Peregrine Communications Inc. 405 Lexington Avenue 9th Floor New York NY 10174
143 143   2020-01-22 Vertrano Kalli 6785 6785 2020-01-22 Peregrine Communications Inc. 405 Lexington Avenue 9th Floor New York NY 10174
145 145   2017-01-23 Gold Amrei 616 616 1950-02-28 German National Tourist Office 122 East 42nd Street Suite 2000 New York NY 10168
146 146   2017-01-23 Nuss Linda 616 616 1950-02-28 German National Tourist Office 122 East 42nd Street Suite 2000 New York NY 10168
163 163   2021-01-25 Breach Brian McLane 6916 6916 2021-01-25 ADLAB, LLC 3 WTC - 175 Greenwich Street 31st Floor New York NY 10007
164 164   2021-01-25 Lawhead Nicholas Anthony 6916 6916 2021-01-25 ADLAB, LLC 3 WTC - 175 Greenwich Street 31st Floor New York NY 10007
172 172   2021-01-26 Jackson Robert 6918 6918 2021-01-26 Horizon Client Access, Inc. 110 Lafayette Street Suite 603 New York NY 10013
176 176   2017-01-27 Pizziferri Michael 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
185 185   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
187 187   2021-01-28 Balough Rebecca 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
188 188   2021-01-28 Clark Matthew 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
189 189   2021-01-28 Dilyard Katharine 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
190 190   2021-01-28 Frangos Constantine 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
191 191   2021-01-28 Isola Meredith 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
193 193   2021-01-28 Marshall Monica 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
194 194   2021-01-28 Matos Christopher 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
195 195   2021-01-28 McCaffrey Evan 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
196 196   2021-01-28 Nardeo Nira 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
197 197   2021-01-28 Naylor McKenzie 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
198 198   2021-01-28 Nolan John 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
199 199   2021-01-28 Stout Samantha 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
200 200   2021-01-28 Totade Tejas 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
206 206   2006-01-30 Douglas Donna Willa-Mae 430 430 1947-01-30 Bermuda Tourism Authority 675 Third Avenue 12th Floor New York NY 10017
211 211   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
215 215   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
216 216   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
217 217   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
226 226   2021-01-30 Mabie Margaret Elizabeth 6920 6920 2021-01-30 Marsh Law Firm PLLC 31 Hudson Yards 11th Floor New York NY 10001
227 227   2021-01-30 Marsh James Ryan 6920 6920 2021-01-30 Marsh Law Firm PLLC 31 Hudson Yards 11th Floor New York NY 10001
229 229   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
230 230   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
231 231   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
238 238   2017-01-31 Shartzer Andrew 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
243 243   2020-01-31 Davoine Caroline 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
244 244   2020-01-31 Huneault Philippe 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
248 248   2020-01-31 Langlois Frederic 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
249 249   2020-01-31 Lanthier Sebastien 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
250 250   2020-01-31 Lauzon Audrey Laroche 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
251 251   2020-01-31 Martine Hebert 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
255 255   2006-02-01 Tanaka Yumiko 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
256 256   2007-02-01 Turquetil Yoann 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
259 259   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
260 260   2018-02-02 Dionne Martin 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
264 264   2018-02-02 Lepage Annelise Melanie 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
267 267   2018-02-02 Rose Peter Alan 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
269 269   2018-02-02 Townrow Andrea 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
272 272   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
273 273   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
275 275   2015-02-04 Beck James 5875 5875 2008-06-17 BLJ Worldwide LTD 1359 Broadway Suite 1102 New York NY 10018
276 276   2019-02-04 DeLelle Claire 6393 6393 2016-11-21 White & Case LLP 1221 Avenue of the Americas   New York NY 10036
277 277   2019-02-04 Erb Nicole 6393 6393 2016-11-21 White & Case LLP 1221 Avenue of the Americas   New York NY 10036
278 278   2019-02-04 McLaughlin Celia 6393 6393 2016-11-21 White & Case LLP 1221 Avenue of the Americas   New York NY 10036
288 288   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
298 298   2013-02-07 Raposo Antonio 526 526 1948-05-13 Innovation Norway WeWork Bryant Park 54 W 40t Street New York NY 10018
302 302   2021-02-09 Hiramoto Ryota 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
304 304   2021-02-09 Wawro Leah 5860 5860 2008-04-03 Independent Diplomat, Inc. 45 East 20th Street 6th Floor New York NY 10003
323 323   2021-02-11 Alcaraz Sydney 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
325 325   2004-02-12 Orduz Juan Esteban 4909 4909 1994-04-06 Colombian Coffee Federation, Inc. 140 East 57th Street   New York NY 10022
335 335   2006-02-15 Dion Jean Pierre 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102

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)
);