home / fara

Menu
  • Search all tables
  • GraphQL API

fara

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

Custom SQL query returning 101 rows (hide)

 
1
select 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 from FARA_All_ShortForms where "Registrant_Name" = :p0 order by Registrant_Name limit 101

Query parameters

This data as json, CSV

rowidShort_Form_Termination_DateShort_Form_DateShort_Form_Last_NameShort_Form_First_NameRegistration_NumberRegistration_DateRegistrant_NameAddress_1Address_2CityStateZip
167   2023-01-22 Noirbent Pauette F 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
168   2023-01-22 Ouelltte Noah 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
169   2023-01-22 Spruell Connor Mitchell 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
206   2017-01-27 Pizziferri Michael 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
210   2023-01-27 Boutin Mirellie 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
211   2023-01-27 Dion Olivia 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
213   2023-01-27 Lamy-Belzil Jeanne 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
214   2016-01-28 Larouche Benoit 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
224   2022-01-29 Abigail Hunter 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
225   2022-01-29 Justin Margolis 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
226   2022-01-29 Weiner David Bruce 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
227   2023-01-29 Baptise Piron Jean 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
228   2023-01-29 Bouziri Miriam Jane 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
229   2023-01-29 Brulotte David 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
230   2023-01-29 Cormier Mathieu 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
231   2023-01-29 Dequen Anne Cecile 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
232   2023-01-29 Iglesisas Rachel Michelle 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
233   2023-01-29 Maurice Jr Robert Emile 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
234   2023-01-29 Mussely-Bedard Guillaume 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
235   2023-01-29 Parker Flukinger Scott 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
236   2023-01-29 Partouche Greenberg Jenny 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
237   2023-01-29 Ruiz David Carlos 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
238   2023-01-29 Zanfirescu Carmen Adina 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
261   2020-01-31 Huneault Philippe 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
265   2020-01-31 Langlois Frederic 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
266   2020-01-31 Lanthier Sebastien 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
267   2020-01-31 Lauzon Audrey Laroche 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
268   2020-01-31 Martine Hebert 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
284   2007-02-01 Turquetil Yoann 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
287   2018-02-02 Briand Fortin Anne Catherine 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
293   2018-02-02 Townrow Andrea 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
396   2006-02-15 Dion Jean Pierre 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
418   2015-02-18 Dufresne Caroline 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
477   2009-03-02 Gagnon Laurence 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
478   2010-03-02 Giovanetti Isabella 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
506   2001-03-05 Waessa Laurent 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
542   2008-03-10 Le Annie 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1147   2001-05-30 Lefort-Knowles Daniele 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1186   2003-06-03 Pak Susan Jin 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1476   2023-07-24 Randall Margaret 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1493   2016-07-27 Brudi-Bilyk Karine 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1494   2016-07-27 Marcoux Pierre 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1495   2022-07-27 Beaulac Marie-Claude 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1502   2019-07-28 Kempter Charline Karine 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1518   2019-07-29 Berthiaume Guy 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1519   2019-07-29 Bosnjak Darijo 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1520   2019-07-29 Duquette Marie-Josee 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1522   2019-07-29 Loubier Catherine 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1523   2019-07-29 McInturf Ryan Thomas 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1524   2019-07-29 Ozgoli Marc 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1525   2019-07-29 Saucier Jean Pascal F 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1526   2019-07-29 Soumare Annick 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1527   2019-07-29 Tessier Taner 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1531   2022-07-29 Beaulac Marie Claude 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1532   2022-07-29 Gao Xin 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1533   2022-07-29 Limoges Mario 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1534   2022-07-29 Michael Anika 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1535   2022-07-29 Reak Taylor Michael 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1536   2022-07-29 Tetu Dominic Etienne 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1540   2018-07-30 Gruver Patricia 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1541   2018-07-30 Lamarche Yann 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1565   2006-08-04 Dallaire Paul 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1672   2014-08-27 Francoeur Marie Claude 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1679   2013-08-29 Iverson-Vosters Kerith 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1772   2009-09-14 Totten Mary Elizabeth 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
1902   2017-10-06 Jarjour Nada 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
2083   2011-11-01 Rivard Nathalie 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
2243   1996-11-29 Carney Jerome 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
2244   1996-11-29 Isom Melissa A. 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
2245   1996-11-29 Kalinowski Keith 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
2560 1972-01-01 1965-10-15 Lenghan Georges C. 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3010 2019-01-01 2015-08-31 Lauzon Jean-Claude 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3011 2019-01-01 2017-09-22 Gaudreau Francois 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3106 2010-01-02 2006-04-05 Turcotte Denis 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3197 2005-01-04 2000-03-07 Clement Myra 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3221 1978-01-05 1978-02-13 Klein Joseph L. 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3222 1978-01-05 1972-04-10 Monfette Jean-Guy 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3499 2013-01-09 2010-10-20 Wells Lucy 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3586 2012-01-11 2001-09-04 Bolduc Frederic 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3587 2013-01-11 2009-07-31 Olivier Alain 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3633 2012-01-12 2010-03-02 Parisella John Edward 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3806 1998-01-15 1995-03-06 Drummond Kevin 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3838 2021-01-15 2018-02-02 Rose Peter Alan 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3854 2021-01-15 2021-07-28 Hould Jean-Francois 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
3919 2009-01-16 2005-11-03 Payeur Benoit 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
4517 1982-01-26 1979-01-22 Labonte Yves 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
4714 2005-01-28 1999-11-12 Frederic Jean 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
4841 2004-01-30 2003-08-28 Dalcourt Andre 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
4872 2021-01-30 2020-01-31 Davoine Caroline 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
4964 1979-01-31 1975-04-25 Fournel Armand 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
5136 1995-01-31 1988-01-26 Cloutier Francoise 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
5137 1995-01-31 1992-01-30 Bouvier Francois 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
5138 1995-01-31 1992-01-30 Lafleur Michel 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
5139 1995-01-31 1995-01-31 Dauphin Claude 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
5140 1995-01-31 1993-02-02 Scowen Reed 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
5969 1989-02-02 1985-02-14 Sauve Raymond J.H. 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
5971 1993-02-02 1991-07-29 Dekle Michael Peter 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
5972 1993-02-02 1987-11-20 Pare Leo 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
6076 2003-02-03 1995-10-18 Fair E. Gordon 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
6255 2009-02-06 2008-04-15 Phillips Delray 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
6597 2020-02-10 2016-01-28 Kazlauskas Kirsten Constance 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
Powered by Datasette · Queries took 3.415ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history