FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
417 rows where City = "New York" and Registration_Number = 1787 sorted by Short_Form_Date descending
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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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 | |
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 |
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 | |
33039 | 33039 | 2020-10-16 | 2019-07-29 | Banuelos | Molly Wynn | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
33040 | 33040 | 2020-10-16 | 2019-07-29 | Wynn Banuelos | Molly | 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 | |
10538 | 10538 | 2019-03-22 | 2018-08-01 | Allonas | Aline | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
31700 | 31700 | 2020-09-30 | 2018-08-01 | LeBlanc | Donald | 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 | |
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 | |
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 |
25350 | 25350 | 2019-07-31 | 2018-02-02 | Hould | Jean Francois | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
25826 | 25826 | 2020-08-02 | 2018-02-02 | Labrie | Josee-Anne | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
28711 | 28711 | 2022-08-31 | 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 |
30103 | 30103 | 2022-09-19 | 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 |
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 | |
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 |
7356 | 7356 | 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 |
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 | |
23440 | 23440 | 2020-07-17 | 2017-01-27 | Westfall | Leslie Cecile | 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 | |
8915 | 8915 | 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 |
14309 | 14309 | 2017-04-28 | 2016-07-27 | Malin | Daniel | 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 | |
6597 | 6597 | 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 |
15533 | 15533 | 2019-05-01 | 2016-01-28 | Dignard | Daniel | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
23630 | 23630 | 2019-07-19 | 2016-01-28 | MacKay | Elizabeth | 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 |
33733 | 33733 | 2017-10-27 | 2015-08-31 | Cerny | Sophie | 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 | |
21817 | 21817 | 2015-06-30 | 2015-02-18 | Carpentier | Lucie | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
28602 | 28602 | 2015-08-31 | 2015-02-18 | Fallecker | Stephane | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
31724 | 31724 | 2022-09-30 | 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 |
38907 | 38907 | 2017-12-21 | 2015-02-18 | Pin | Liliane Sophie | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
28621 | 28621 | 2016-08-31 | 2014-08-28 | Duguay | Philip | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
39274 | 39274 | 2014-12-28 | 2014-08-28 | Poirier | Dominique | 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 | |
17378 | 17378 | 2015-05-29 | 2014-08-27 | Johnson | Timothy | 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 | |
16000 | 16000 | 2014-05-09 | 2013-08-29 | Issaoui-Mansouri | Kheira | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
19004 | 19004 | 2014-06-06 | 2013-08-29 | Beaulieu | Isabelle | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
23077 | 23077 | 2014-07-13 | 2013-08-29 | Moreau | Melanie | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
36520 | 36520 | 2016-11-28 | 2013-08-29 | Bonnard | Marianne | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
41882 | 41882 | 2013-12-31 | 2013-08-29 | Boisclair | Andre | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
41883 | 41883 | 2013-12-31 | 2013-08-29 | Saintonge | Jean | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
25259 | 25259 | 2015-07-31 | 2013-02-27 | Paquette | Daniel | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
21812 | 21812 | 2014-06-30 | 2012-08-07 | Imbeau | Sebastien | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
15493 | 15493 | 2013-05-01 | 2012-08-03 | Francoeur | Marie Claude | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
25266 | 25266 | 2015-07-31 | 2012-05-23 | Rose | Peter Alan | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
17520 | 17520 | 2014-05-30 | 2012-05-14 | Boyer | Joane | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
15059 | 15059 | 2014-04-30 | 2012-02-15 | Hould | Jean-Francois | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
17320 | 17320 | 2019-05-28 | 2012-02-01 | Tremblay | Frederic | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
28632 | 28632 | 2017-08-31 | 2011-12-20 | Marquis | Eric | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
15951 | 15951 | 2014-05-08 | 2011-12-19 | Bosquez Foti | Rafael | 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 |
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]) );