FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
398 rows where Registration_Number = 1787
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date)
State 1
- NY 398
Registration_Number 1
- Quebec Government Office · 398 ✖
Registrant_Name 1
City 1
- New York 398
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 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );