FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
730 rows where Address_2 = "4th Floor" sorted by Short_Form_Termination_Date
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_1, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 19
- JETRO, New York 490
- Teneo Strategy LLC 74
- Turkish Consulate Office of Culture & Information Attache 43
- Levick Strategic Communications, LP 31
- KBS America, Inc. 13
- Public Strategies Washington, Inc. 12
- Biederman & Company, Inc. 10
- Levick Strategic Communications, LP 10
- Bangladesh Mission, Washington, D.C. 8
- Campbell-Ewald Company 8
- Golin/Harris 8
- McKinsey & Company, Inc. International 6
- Neill, Mullenholz, Shaw & Seeger 5
- Global Policy Group, Inc. 5
- 5W Public Relations, LLC 2
- Marathon Strategies LLC 2
- BG Consulting, Inc. 1
- Southfive Strategies, LLC 1
- Cogent Law Group LLP 1
Registrant_Name 18
- JETRO, New York 490
- Teneo Strategy LLC 74
- Turkish Consulate Office of Culture & Information Attache 43
- Levick Strategic Communications, LP 41
- KBS America, Inc. 13
- Public Strategies Washington, Inc. 12
- Biederman & Company, Inc. 10
- Bangladesh Mission, Washington, D.C. 8
- Campbell-Ewald Company 8
- Golin/Harris 8
- McKinsey & Company, Inc. International 6
- Global Policy Group, Inc. 5
- Neill, Mullenholz, Shaw & Seeger 5
- 5W Public Relations, LLC 2
- Marathon Strategies LLC 2
- BG Consulting, Inc. 1
- Cogent Law Group LLP 1
- Southfive Strategies, LLC 1
City 5
- New York 627
- Washington 73
- Los Angeles 21
- Detroit 8
- Alexandria 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
68 | 68 | 2020-01-06 | Coster | John | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
106 | 106 | 2023-01-12 | Ogata | Tetsuya | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
170 | 170 | 2020-01-23 | El-Erian | Mostafa Ali | Cogent Law Group LLP 6786 | 2020-01-23 | Cogent Law Group LLP | 1875 K Street, NW | 4th Floor | Washington | DC | 20006 | |
283 | 283 | 2006-02-01 | Tanaka | Yumiko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
336 | 336 | 2022-02-08 | Greenway | John Edwin | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
338 | 338 | 2022-02-08 | Sibaai | Tatiana | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
340 | 340 | 2021-02-09 | Hiramoto | Ryota | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
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 | |
2463 | 2463 | 2021-12-27 | Kwak | Wooshin | KBS America, Inc. 5684 | 2005-05-17 | KBS America, Inc. | 625 South Kingsley Drive | 4th Floor | Los Angeles | CA | 90005 | |
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 |
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]) );