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

388 rows where Registration_Number = 1787

✎ View and edit SQL

This data as json, CSV (advanced)

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

State

Registration_Number

  • 1787 · 388 ✖

Registrant_Name

City

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
168 168   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   2016-01-28 Larouche Benoit 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
228 228   2020-01-31 Huneault Philippe 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
232 232   2020-01-31 Langlois Frederic 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
233 233   2020-01-31 Lanthier Sebastien 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
234 234   2020-01-31 Lauzon Audrey Laroche 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
235 235   2020-01-31 Martine Hebert 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
240 240   2007-02-01 Turquetil Yoann 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
243 243   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
244 244   2018-02-02 Dionne Martin 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
252 252   2018-02-02 Townrow Andrea 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
311 311   2006-02-15 Dion Jean Pierre 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
321 321   2015-02-18 Dufresne Caroline 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
322 322   2015-02-18 Gauchet Cyril 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
391 391   2009-03-02 Gagnon Laurence 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
392 392   2010-03-02 Giovanetti Isabella 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
410 410   2001-03-05 Waessa Laurent 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
438 438   2008-03-10 Le Annie 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1008 1008   2001-05-30 Lefort-Knowles Daniele 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1031 1031   2003-06-03 Pak Susan Jin 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1316 1316   2016-07-27 Brudi-Bilyk Karine 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1317 1317   2016-07-27 Marcoux Pierre 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1322 1322   2019-07-28 Kempter Charline Karine 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1328 1328   2019-07-29 Berthiaume Guy 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1329 1329   2019-07-29 Bosnjak Darijo 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1330 1330   2019-07-29 Duquette Marie-Josee 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1332 1332   2019-07-29 Loubier Catherine 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1333 1333   2019-07-29 McInturf Ryan Thomas 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1334 1334   2019-07-29 Ozgoli Marc 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1335 1335   2019-07-29 Saucier Jean Pascal F 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1336 1336   2019-07-29 Soumare Annick 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1337 1337   2019-07-29 Tessier Taner 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1346 1346   2018-07-30 Gruver Patricia 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1347 1347   2018-07-30 Lamarche Yann 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1391 1391   2006-08-04 Dallaire Paul 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1513 1513   2014-08-27 Francoeur Marie Claude 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1523 1523   2013-08-29 Iverson-Vosters Kerith 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1645 1645   2009-09-14 Totten Mary Elizabeth 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1812 1812   2017-10-06 Jarjour Nada 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1992 1992   2011-11-01 Rivard Nathalie 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
2147 2147   1996-11-29 Carney Jerome 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
2148 2148   1996-11-29 Isom Melissa A. 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
2149 2149   1996-11-29 Kalinowski Keith 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
2434 2434 1972-01-01 1965-10-15 Lenghan Georges C. 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
2884 2884 2019-01-01 2015-08-31 Lauzon Jean-Claude 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
2885 2885 2019-01-01 2017-09-22 Gaudreau Francois 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
2968 2968 2010-01-02 2006-04-05 Turcotte Denis 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3056 3056 2005-01-04 2000-03-07 Clement Myra 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3079 3079 1978-01-05 1978-02-13 Klein Joseph L. 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3080 3080 1978-01-05 1972-04-10 Monfette Jean-Guy 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3322 3322 2013-01-09 2010-10-20 Wells Lucy 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3407 3407 2012-01-11 2001-09-04 Bolduc Frederic 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3408 3408 2013-01-11 2009-07-31 Olivier Alain 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3454 3454 2012-01-12 2010-03-02 Parisella John Edward 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3623 3623 1998-01-15 1995-03-06 Drummond Kevin 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3655 3655 2021-01-15 2018-02-02 Rose Peter Alan 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3669 3669 2021-01-15 2021-07-28 Hould Jean-Francois 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3734 3734 2009-01-16 2005-11-03 Payeur Benoit 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
4315 4315 1982-01-26 1979-01-22 Labonte Yves 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
4503 4503 2005-01-28 1999-11-12 Frederic Jean 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
4628 4628 2004-01-30 2003-08-28 Dalcourt Andre 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
4660 4660 2021-01-30 2020-01-31 Davoine Caroline 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
4751 4751 1979-01-31 1975-04-25 Fournel Armand 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
4923 4923 1995-01-31 1988-01-26 Cloutier Francoise 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
4924 4924 1995-01-31 1992-01-30 Bouvier Francois 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
4925 4925 1995-01-31 1992-01-30 Lafleur Michel 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
4926 4926 1995-01-31 1995-01-31 Dauphin Claude 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
4927 4927 1995-01-31 1993-02-02 Scowen Reed 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
5733 5733 1989-02-02 1985-02-14 Sauve Raymond J.H. 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
5735 5735 1993-02-02 1991-07-29 Dekle Michael Peter 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
5736 5736 1993-02-02 1987-11-20 Pare Leo 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
5840 5840 2003-02-03 1995-10-18 Fair E. Gordon 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
6011 6011 2009-02-06 2008-04-15 Phillips Delray 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
6347 6347 2020-02-10 2016-01-28 Kazlauskas Kirsten Constance 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
6412 6412 1990-02-12 1988-01-26 Vaughan Normand T. 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
6555 6555 1994-02-14 1991-01-18 Varin Robert Louis 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
6556 6556 1994-02-14 1992-01-30 Cardinal Laurent 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
6557 6557 1994-02-14 1992-01-30 Lavigne Rachel 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
6560 6560 1994-02-14 1991-07-29 Proulx Rejean Pierre 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
6561 6561 1994-02-14 1990-07-31 Downing Kevin R. 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
6564 6564 1994-02-14 1989-08-04 Cloutier Michel 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
6913 6913 2020-02-17 2011-11-01 Breard Annie 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
6977 6977 1999-02-19 1996-02-01 McNamara Susan Nadar 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
7084 7084 2020-02-21 2017-08-01 Hamann Louis 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
7638 7638 1985-02-28 1974-02-05 Brassard Guy 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
8608 8608 2019-03-01 2016-07-27 Girard Charles 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
9209 9209 1970-03-10 1969-03-03 Tremblay Jean-Claude 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
9211 9211 1982-03-10 1980-08-13 Pouliot Richard 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
9805 9805 2009-03-17 2008-05-30 Gauthier Matthieu 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
9963 9963 2004-03-19 1999-08-20 Deacy Susan 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
9965 9965 2008-03-19 2004-08-27 Fortier Bruno 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
10172 10172 2019-03-22 2018-08-01 Allonas Aline 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
10289 10289 1972-03-24 1971-04-20 Lussier Paul 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
10290 10290 1972-03-24 1971-04-20 Renault Fernand 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
10743 10743 1974-03-30 1970-09-16 Ives Edward J. 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
10808 10808 2000-03-30 1996-11-29 Dorr John 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
10812 10812 2003-03-30 2002-02-04 Alberro Frederic 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
11037 11037 1970-03-31 1964-09-02 Wright Noel Nithsdale 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
11077 11077 1976-03-31 1975-02-05 Lajoie Pierre R. 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])
);