home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for 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

417 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 1

  • NY 417

Registration_Number 1

  • Quebec Government Office · 417 ✖

Registrant_Name 1

  • Quebec Government Office 417

City 1

  • New York 417
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
167 167   2023-01-22 Noirbent Pauette F Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
168 168   2023-01-22 Ouelltte Noah Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
169 169   2023-01-22 Spruell Connor Mitchell Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
206 206   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
210 210   2023-01-27 Boutin Mirellie Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
211 211   2023-01-27 Dion Olivia Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
213 213   2023-01-27 Lamy-Belzil Jeanne Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
214 214   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
224 224   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
225 225   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
226 226   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
227 227   2023-01-29 Baptise Piron Jean Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
228 228   2023-01-29 Bouziri Miriam Jane Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
229 229   2023-01-29 Brulotte David Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
230 230   2023-01-29 Cormier Mathieu Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
231 231   2023-01-29 Dequen Anne Cecile Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
232 232   2023-01-29 Iglesisas Rachel Michelle Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
233 233   2023-01-29 Maurice Jr Robert Emile Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
234 234   2023-01-29 Mussely-Bedard Guillaume Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
235 235   2023-01-29 Parker Flukinger Scott Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
236 236   2023-01-29 Partouche Greenberg Jenny Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
237 237   2023-01-29 Ruiz David Carlos Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
238 238   2023-01-29 Zanfirescu Carmen Adina Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
261 261   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
265 265   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
266 266   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
267 267   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
268 268   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
284 284   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
287 287   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
293 293   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
396 396   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
418 418   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
477 477   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
478 478   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
506 506   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
542 542   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
1147 1147   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
1186 1186   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
1476 1476   2023-07-24 Randall Margaret Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1493 1493   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
1494 1494   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
1495 1495   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
1502 1502   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
1518 1518   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
1519 1519   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
1520 1520   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
1522 1522   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
1523 1523   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
1524 1524   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
1525 1525   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
1526 1526   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
1527 1527   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
1531 1531   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
1532 1532   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
1533 1533   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
1534 1534   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
1535 1535   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
1536 1536   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
1540 1540   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
1541 1541   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
1565 1565   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
1672 1672   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
1679 1679   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
1772 1772   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
1902 1902   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
2083 2083   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
2243 2243   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
2244 2244   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
2245 2245   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
2560 2560 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
3010 3010 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
3011 3011 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
3106 3106 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
3197 3197 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
3221 3221 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
3222 3222 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
3499 3499 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
3586 3586 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
3587 3587 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
3633 3633 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
3806 3806 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
3838 3838 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
3854 3854 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
3919 3919 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
4517 4517 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
4714 4714 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
4841 4841 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
4872 4872 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
4964 4964 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
5136 5136 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
5137 5137 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
5138 5138 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
5139 5139 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
5140 5140 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
5969 5969 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
5971 5971 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
5972 5972 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
6076 6076 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
6255 6255 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

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 · Queries took 524.487ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows