FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
417 rows where Registrant_Name = "Quebec Government Office" and Registration_Number = 1787 sorted by City
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date)
State 1
- NY 417
Registration_Number 1
- Quebec Government Office · 417 ✖
Registration_Date (date) 1 ✖
- 1964-09-02 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 |
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]) );