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

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

State 1

Registration_Number 1

  • Quebec Government Office · 398 ✖

Registrant_Name 1

City 1

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
172 172   2017-01-27 Pizziferri Michael Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
179 179   2016-01-28 Larouche Benoit Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
195 195   2022-01-29 Abigail Hunter Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
196 196   2022-01-29 Justin Margolis Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
197 197   2022-01-29 Weiner David Bruce Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
222 222   2020-01-31 Huneault Philippe Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
226 226   2020-01-31 Langlois Frederic Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
227 227   2020-01-31 Lanthier Sebastien Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
228 228   2020-01-31 Lauzon Audrey Laroche Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
229 229   2020-01-31 Martine Hebert Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
235 235   2007-02-01 Turquetil Yoann Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
238 238   2018-02-02 Briand Fortin Anne Catherine Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
239 239   2018-02-02 Dionne Martin Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
243 243   2018-02-02 Lepage Annelise Melanie Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
247 247   2018-02-02 Townrow Andrea Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
320 320   2006-02-15 Dion Jean Pierre Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
342 342   2015-02-18 Dufresne Caroline Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
343 343   2015-02-18 Gauchet Cyril Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
421 421   2009-03-02 Gagnon Laurence Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
422 422   2010-03-02 Giovanetti Isabella Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
445 445   2001-03-05 Waessa Laurent Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
483 483   2008-03-10 Le Annie Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1095 1095   2001-05-30 Lefort-Knowles Daniele Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1128 1128   2003-06-03 Pak Susan Jin Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1434 1434   2016-07-27 Brudi-Bilyk Karine Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1435 1435   2016-07-27 Marcoux Pierre Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1437 1437   2022-07-27 Beaulac Marie-Claude Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1468 1468   2019-07-28 Kempter Charline Karine Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1480 1480   2019-07-29 Berthiaume Guy Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1481 1481   2019-07-29 Bosnjak Darijo Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1482 1482   2019-07-29 Duquette Marie-Josee Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1484 1484   2019-07-29 Loubier Catherine Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1485 1485   2019-07-29 McInturf Ryan Thomas Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1486 1486   2019-07-29 Ozgoli Marc Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1487 1487   2019-07-29 Saucier Jean Pascal F Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1488 1488   2019-07-29 Soumare Annick Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1489 1489   2019-07-29 Tessier Taner Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1493 1493   2022-07-29 Beaulac Marie Claude Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1494 1494   2022-07-29 Gao Xin Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1495 1495   2022-07-29 Limoges Mario Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1496 1496   2022-07-29 Michael Anika Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1497 1497   2022-07-29 Reak Taylor Michael Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1498 1498   2022-07-29 Tetu Dominic Etienne Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1502 1502   2018-07-30 Gruver Patricia Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1503 1503   2018-07-30 Lamarche Yann Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1537 1537   2006-08-04 Dallaire Paul Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1642 1642   2014-08-27 Francoeur Marie Claude Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1650 1650   2013-08-29 Iverson-Vosters Kerith Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1737 1737   2009-09-14 Totten Mary Elizabeth Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1843 1843   2017-10-06 Jarjour Nada Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
2006 2006   2011-11-01 Rivard Nathalie Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
2167 2167   1996-11-29 Carney Jerome Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
2168 2168   1996-11-29 Isom Melissa A. Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
2169 2169   1996-11-29 Kalinowski Keith Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
2478 2478 1972-01-01 1965-10-15 Lenghan Georges C. Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
2928 2928 2019-01-01 2015-08-31 Lauzon Jean-Claude Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
2929 2929 2019-01-01 2017-09-22 Gaudreau Francois Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3015 3015 2010-01-02 2006-04-05 Turcotte Denis Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3106 3106 2005-01-04 2000-03-07 Clement Myra Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3129 3129 1978-01-05 1978-02-13 Klein Joseph L. Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3130 3130 1978-01-05 1972-04-10 Monfette Jean-Guy Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3376 3376 2013-01-09 2010-10-20 Wells Lucy Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3462 3462 2012-01-11 2001-09-04 Bolduc Frederic Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3463 3463 2013-01-11 2009-07-31 Olivier Alain Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3509 3509 2012-01-12 2010-03-02 Parisella John Edward Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3682 3682 1998-01-15 1995-03-06 Drummond Kevin Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3714 3714 2021-01-15 2018-02-02 Rose Peter Alan Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3728 3728 2021-01-15 2021-07-28 Hould Jean-Francois Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3793 3793 2009-01-16 2005-11-03 Payeur Benoit Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
4385 4385 1982-01-26 1979-01-22 Labonte Yves Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
4573 4573 2005-01-28 1999-11-12 Frederic Jean Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
4700 4700 2004-01-30 2003-08-28 Dalcourt Andre Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
4732 4732 2021-01-30 2020-01-31 Davoine Caroline Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
4823 4823 1979-01-31 1975-04-25 Fournel Armand Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
4995 4995 1995-01-31 1988-01-26 Cloutier Francoise Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
4996 4996 1995-01-31 1992-01-30 Bouvier Francois Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
4997 4997 1995-01-31 1992-01-30 Lafleur Michel Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
4998 4998 1995-01-31 1995-01-31 Dauphin Claude Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
4999 4999 1995-01-31 1993-02-02 Scowen Reed Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
5815 5815 1989-02-02 1985-02-14 Sauve Raymond J.H. Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
5817 5817 1993-02-02 1991-07-29 Dekle Michael Peter Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
5818 5818 1993-02-02 1987-11-20 Pare Leo Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
5922 5922 2003-02-03 1995-10-18 Fair E. Gordon Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
6097 6097 2009-02-06 2008-04-15 Phillips Delray Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
6436 6436 2020-02-10 2016-01-28 Kazlauskas Kirsten Constance Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
6502 6502 1990-02-12 1988-01-26 Vaughan Normand T. Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
6645 6645 1994-02-14 1991-01-18 Varin Robert Louis Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
6646 6646 1994-02-14 1992-01-30 Cardinal Laurent Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
6647 6647 1994-02-14 1992-01-30 Lavigne Rachel Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
6650 6650 1994-02-14 1991-07-29 Proulx Rejean Pierre Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
6651 6651 1994-02-14 1990-07-31 Downing Kevin R. Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
6654 6654 1994-02-14 1989-08-04 Cloutier Michel Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
7004 7004 2020-02-17 2011-11-01 Breard Annie Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
7073 7073 1999-02-19 1996-02-01 McNamara Susan Nadar Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
7179 7179 2020-02-21 2017-08-01 Hamann Louis Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
7738 7738 1985-02-28 1974-02-05 Brassard Guy Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
8724 8724 2019-03-01 2016-07-27 Girard Charles Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
9339 9339 1970-03-10 1969-03-03 Tremblay Jean-Claude Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
9341 9341 1982-03-10 1980-08-13 Pouliot Richard Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
9944 9944 2009-03-17 2008-05-30 Gauthier Matthieu Quebec Government Office 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])
);