FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
627 rows where Address_2 = "4th Floor" and City = "New York" sorted by Short_Form_Termination_Date
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
473 | 473 | 2022-03-01 | Burt | Timothy | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
474 | 474 | 2022-03-01 | Fearnley-Marr | James | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
475 | 475 | 2022-03-01 | Varnadore | Langston | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
479 | 479 | 2011-03-02 | Nakajima | Daiki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
482 | 482 | 2023-03-02 | Mandwee | Rima | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
483 | 483 | 2023-03-02 | Mayerchak | Martin | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
491 | 491 | 2022-03-03 | Ahmed | Maie | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
495 | 495 | 2023-03-03 | Perrella | Andrew | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
503 | 503 | 2021-03-04 | Ohde | Mariko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
647 | 647 | 2023-03-24 | Mima | Osamu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
668 | 668 | 2023-03-28 | Millington | Charlotte | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
720 | 720 | 2022-04-01 | Fujioka | Yota | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
724 | 724 | 2023-04-04 | Hirano | Yuichiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
779 | 779 | 2023-04-13 | Chmara | Lauren | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1206 | 1206 | 2020-06-09 | Clark | Jennifer Lisa | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1207 | 1207 | 2020-06-09 | Maas | Andrew James | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1208 | 1208 | 2020-06-09 | Mead | Robert March | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1209 | 1209 | 2020-06-09 | Miller | Matthew Anthony | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1211 | 1211 | 2020-06-09 | Zivin | Aaron (Sparky) Lawrence | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1224 | 1224 | 2019-06-11 | Isobe | Shinichi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
1251 | 1251 | 2023-06-16 | Hiruta | Atsushi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
1268 | 1268 | 2023-06-21 | Gallagher | Paul Christian | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1269 | 1269 | 2023-06-21 | Keary | Paul | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1270 | 1270 | 2023-06-21 | Meahl | Stephen | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1271 | 1271 | 2023-06-21 | Morrell | Geoff | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1272 | 1272 | 2023-06-21 | Tamarin | Nate | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1288 | 1288 | 2021-06-24 | Fujita | Yuri | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
1371 | 1371 | 2023-07-07 | Miura | Satoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
1372 | 1372 | 2019-07-08 | Riley | Padraic D. | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1387 | 1387 | 2023-07-10 | Kato | Shoichi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
1388 | 1388 | 2023-07-10 | Uchino | Yasuaki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
1392 | 1392 | 2023-07-11 | Abe | Yukio | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
1414 | 1414 | 2023-07-17 | Charles | Cedric | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
1415 | 1415 | 2022-07-18 | Clarke | Ben Christopher | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1416 | 1416 | 2022-07-18 | Coogan | Alexandra | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1417 | 1417 | 2022-07-18 | Daugherty | Neil Abban | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1418 | 1418 | 2022-07-18 | Dey | Iain Charles | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1419 | 1419 | 2022-07-18 | Jordan | Sarah | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1420 | 1420 | 2022-07-18 | Mobed | Elizabeth | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1491 | 1491 | 2022-07-26 | Yamaguchi | Jia | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
1615 | 1615 | 2022-08-15 | Fukuoka | Kohei | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
1631 | 1631 | 2014-08-19 | Ohara | Noriko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
1689 | 1689 | 2021-08-30 | Parker | Keith | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1691 | 1691 | 2021-08-30 | Stelma | Kyle | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1694 | 1694 | 2022-08-30 | Saleh | Mona Mohammed | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1695 | 1695 | 2022-08-30 | Wiles | Rebecca Beatrice | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1696 | 1696 | 2022-08-30 | Ysewijn | Frederic | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1715 | 1715 | 2022-09-02 | Iwabuchi | Kana | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
1723 | 1723 | 2019-09-05 | Yoshida | Natsue | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
1724 | 1724 | 2021-09-05 | Cohen | Stephen E. | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1725 | 1725 | 2021-09-05 | Devlin | Luke Gregory | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1726 | 1726 | 2021-09-05 | Johns | Emily | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1727 | 1727 | 2021-09-05 | Mackreath | Melissa Jane | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1728 | 1728 | 2021-09-05 | Osborne | Michael | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1729 | 1729 | 2021-09-05 | Sindone | Jeff | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1742 | 1742 | 2022-09-07 | Horigome | Miho | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
1744 | 1744 | 2015-09-08 | Kashiba | Sakura | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
1749 | 1749 | 2021-09-09 | Okada | Takuya | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
1757 | 1757 | 2022-09-09 | Sorkin | Samuel Alexander | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1765 | 1765 | 2020-09-11 | Lutz | Lauren Kelly | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1806 | 1806 | 2022-09-19 | Watanabe | Hirokazu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
1836 | 1836 | 2020-09-24 | Yoneyama | Hiroshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
1918 | 1918 | 2022-10-07 | Schwartz | Nelson D. | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1979 | 1979 | 2022-10-17 | Kitade | Teruo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
1980 | 1980 | 2022-10-18 | La Pointe | Danielle Colette | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1994 | 1994 | 2021-10-21 | Alkadhi | Maram | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1996 | 1996 | 2021-10-21 | Cook | Laurence | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1997 | 1997 | 2021-10-21 | Falconer | Tim | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1998 | 1998 | 2021-10-21 | Hussain | Shazia | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
1999 | 1999 | 2021-10-21 | Itani | Hussein | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
2000 | 2000 | 2021-10-21 | Libbos | Amanda | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
2001 | 2001 | 2021-10-21 | Salman | Fariha | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
2002 | 2002 | 2021-10-21 | Shamma | Alexandra | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
2115 | 2115 | 2020-11-05 | Miyano | Keita | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
2140 | 2140 | 2020-11-11 | Nota | Masayuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
2180 | 2180 | 2022-11-18 | Gabrah | Theodora Hani | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
2198 | 2198 | 2019-11-19 | Suga | Mikiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
2269 | 2269 | 2021-11-29 | Hotta | Motoi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
2346 | 2346 | 2021-12-03 | Rowland | Amy | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
2359 | 2359 | 2021-12-06 | Nambu | Tomoshige | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
2400 | 2400 | 2022-12-14 | Aizawa | Yasutoki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
6599 | 6599 | 1949-02-11 | 1947-10-22 | Esmer | Ahmet Sukru | Turkish Consulate Office of Culture & Information Attache 498 | 1947-10-22 | Turkish Consulate Office of Culture & Information Attache | 821 United Nations Plaza | 4th Floor | New York | NY | 10017 |
19949 | 19949 | 1949-06-21 | 1947-10-22 | Andolsun | Feridun Kurt | Turkish Consulate Office of Culture & Information Attache 498 | 1947-10-22 | Turkish Consulate Office of Culture & Information Attache | 821 United Nations Plaza | 4th Floor | New York | NY | 10017 |
20631 | 20631 | 1950-06-30 | 1949-02-25 | Church | Joseph | Turkish Consulate Office of Culture & Information Attache 498 | 1947-10-22 | Turkish Consulate Office of Culture & Information Attache | 821 United Nations Plaza | 4th Floor | New York | NY | 10017 |
4603 | 4603 | 1951-01-27 | 1950-03-03 | Turemen | Ihsan | Turkish Consulate Office of Culture & Information Attache 498 | 1947-10-22 | Turkish Consulate Office of Culture & Information Attache | 821 United Nations Plaza | 4th Floor | New York | NY | 10017 |
13273 | 13273 | 1955-04-13 | 1947-10-22 | Atakent | Ihsan | Turkish Consulate Office of Culture & Information Attache 498 | 1947-10-22 | Turkish Consulate Office of Culture & Information Attache | 821 United Nations Plaza | 4th Floor | New York | NY | 10017 |
22740 | 22740 | 1955-07-08 | 1950-08-25 | Wolf | Daniel | Turkish Consulate Office of Culture & Information Attache 498 | 1947-10-22 | Turkish Consulate Office of Culture & Information Attache | 821 United Nations Plaza | 4th Floor | New York | NY | 10017 |
11339 | 11339 | 1956-03-31 | 1955-08-04 | Yalman | Tunc | Turkish Consulate Office of Culture & Information Attache 498 | 1947-10-22 | Turkish Consulate Office of Culture & Information Attache | 821 United Nations Plaza | 4th Floor | New York | NY | 10017 |
16991 | 16991 | 1956-05-24 | 1956-03-09 | Cohen | Edward M. | Turkish Consulate Office of Culture & Information Attache 498 | 1947-10-22 | Turkish Consulate Office of Culture & Information Attache | 821 United Nations Plaza | 4th Floor | New York | NY | 10017 |
20650 | 20650 | 1956-06-30 | 1955-08-04 | Soyal | Ali Necati | Turkish Consulate Office of Culture & Information Attache 498 | 1947-10-22 | Turkish Consulate Office of Culture & Information Attache | 821 United Nations Plaza | 4th Floor | New York | NY | 10017 |
39678 | 39678 | 1959-12-31 | 1956-11-07 | Glen | James Ramsey | Turkish Consulate Office of Culture & Information Attache 498 | 1947-10-22 | Turkish Consulate Office of Culture & Information Attache | 821 United Nations Plaza | 4th Floor | New York | NY | 10017 |
10922 | 10922 | 1960-03-28 | 1949-08-24 | Eren | Nuri | Turkish Consulate Office of Culture & Information Attache 498 | 1947-10-22 | Turkish Consulate Office of Culture & Information Attache | 821 United Nations Plaza | 4th Floor | New York | NY | 10017 |
15304 | 15304 | 1960-05-01 | 1956-11-09 | Bulut | Tarik | Turkish Consulate Office of Culture & Information Attache 498 | 1947-10-22 | Turkish Consulate Office of Culture & Information Attache | 821 United Nations Plaza | 4th Floor | New York | NY | 10017 |
27842 | 27842 | 1960-08-31 | 1956-11-07 | Gurun | Ata Ahmet | Turkish Consulate Office of Culture & Information Attache 498 | 1947-10-22 | Turkish Consulate Office of Culture & Information Attache | 821 United Nations Plaza | 4th Floor | New York | NY | 10017 |
34140 | 34140 | 1960-10-31 | 1958-10-29 | Capli | Erdogan | Turkish Consulate Office of Culture & Information Attache 498 | 1947-10-22 | Turkish Consulate Office of Culture & Information Attache | 821 United Nations Plaza | 4th Floor | New York | NY | 10017 |
34141 | 34141 | 1960-10-31 | 1956-11-07 | Fenik | Omer Faruk | Turkish Consulate Office of Culture & Information Attache 498 | 1947-10-22 | Turkish Consulate Office of Culture & Information Attache | 821 United Nations Plaza | 4th Floor | New York | NY | 10017 |
39697 | 39697 | 1960-12-31 | 1947-10-22 | Manyas | Nezih | Turkish Consulate Office of Culture & Information Attache 498 | 1947-10-22 | Turkish Consulate Office of Culture & Information Attache | 821 United Nations Plaza | 4th Floor | New York | NY | 10017 |
30583 | 30583 | 1961-09-27 | 1958-09-18 | Pirinccioglu | Fethi | Turkish Consulate Office of Culture & Information Attache 498 | 1947-10-22 | Turkish Consulate Office of Culture & Information Attache | 821 United Nations Plaza | 4th Floor | New York | NY | 10017 |
39730 | 39730 | 1962-12-31 | 1961-03-21 | Atakent | Ihsan | Turkish Consulate Office of Culture & Information Attache 498 | 1947-10-22 | Turkish Consulate Office of Culture & Information Attache | 821 United Nations Plaza | 4th Floor | New York | NY | 10017 |
39732 | 39732 | 1962-12-31 | 1961-03-21 | Ozaktas | Adnan | Turkish Consulate Office of Culture & Information Attache 498 | 1947-10-22 | Turkish Consulate Office of Culture & Information Attache | 821 United Nations Plaza | 4th Floor | New York | NY | 10017 |
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]) );