FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
490 rows where Registration_Number = 1643 sorted by Short_Form_First_Name
This data as json, CSV (advanced)
Short_Form_Date (date) >30 ✖
- 1999-04-27 16
- 2002-07-31 10
- 1963-06-25 9
- 1994-08-19 9
- 1996-08-02 9
- 1995-07-28 8
- 1985-01-07 7
- 1992-08-06 7
- 1993-08-09 7
- 1995-02-06 7
- 1997-09-25 7
- 1992-02-04 6
- 1999-08-10 6
- 2000-09-18 6
- 1970-03-05 5
- 1989-08-14 5
- 1969-09-11 4
- 1973-10-12 4
- 1977-12-05 4
- 1980-12-09 4
- 1990-02-02 4
- 1993-02-03 4
- 2000-10-12 4
- 2001-07-10 4
- 2001-08-27 4
- 2002-12-11 4
- 2004-10-19 4
- 2007-07-23 4
- 1965-03-01 3
- 1966-04-25 3
- …
State 1
- NY 490
Registration_Number 1
- JETRO, New York · 490 ✖
Registrant_Name 1
- JETRO, New York 490
City 1
- New York 490
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6068 | 6068 | 1993-02-03 | 1990-02-02 | Kojima | Ainosuke | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
6242 | 6242 | 1995-02-06 | 1992-08-06 | Nishio | Akemi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
11082 | 11082 | 2004-03-29 | 2002-12-11 | Miyazato | Akihiko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
23796 | 23796 | 2007-07-22 | 2004-07-30 | Tada | Akihiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
18993 | 18993 | 1998-06-06 | 1994-08-19 | Takatori | Akinori | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10422 | 10422 | 1969-03-21 | 1966-01-27 | Kuroda | Akio | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
38978 | 38978 | 1968-12-23 | 1965-07-30 | Suzuki | Akio | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
13337 | 13337 | 2012-04-14 | 2009-05-15 | Imai | Akira | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
21277 | 21277 | 1997-06-30 | 1991-08-23 | Nakaya | Akira | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
23766 | 23766 | 1969-07-22 | 1966-02-27 | Hirose | Akira | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
29646 | 29646 | 2006-09-12 | 2003-08-08 | Miura | Akira | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
31525 | 31525 | 2011-09-30 | 2006-08-25 | Kajita | Akira | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
36294 | 36294 | 1976-11-24 | 1974-08-27 | Kashiwagi | Akira | 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 | |
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 | |
35313 | 35313 | 2021-11-05 | 2017-01-31 | Shartzer | Andrew | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
29780 | 29780 | 2018-09-14 | 2016-02-04 | Arce | Asuka | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
27366 | 27366 | 2015-08-24 | 2012-11-20 | Miyazaki | Atsufumi | 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 | |
11096 | 11096 | 2019-03-29 | 2014-09-18 | Suzuki | Atsushi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
26641 | 26641 | 2012-08-14 | 2008-08-29 | Semimoto | Atsushi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
36561 | 36561 | 1999-11-29 | 1997-02-18 | Kuromatsu | Atsushi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
24599 | 24599 | 2014-07-30 | 2011-08-16 | Takahashi | Aya | 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 | |
29594 | 29594 | 2012-09-11 | 2011-10-20 | Higashino | Dai | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth 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 | |
15960 | 15960 | 1972-05-09 | 1970-03-05 | Kobori | Daitetsu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
36403 | 36403 | 2013-11-25 | 2007-10-15 | Austin | Doreen | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
3825 | 3825 | 2007-01-15 | 2006-05-26 | Shih | Dorothy | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
17366 | 17366 | 2004-05-29 | 2001-08-27 | Mishima | Eiichi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
21261 | 21261 | 1997-06-30 | 1992-02-04 | Hasegawa | Eiichi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
12728 | 12728 | 1987-04-04 | 1985-01-07 | Takai | Eiji | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
15307 | 15307 | 1963-05-01 | 1963-06-25 | Fujise | Eijiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10940 | 10940 | 1975-03-28 | 1966-04-25 | Masaoka | Etsu Mineta | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
9385 | 9385 | 1980-03-07 | 1977-12-05 | Kuraishi | Fumiaki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
32287 | 32287 | 2019-10-04 | 2016-01-07 | Cook | Gerald | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
6462 | 6462 | 1988-02-09 | 1988-02-09 | Furuta | Hajime | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
23681 | 23681 | 2010-07-20 | 2008-09-18 | Ito | Hajime | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
24004 | 24004 | 1987-07-25 | 1983-11-14 | Hori | Hajimu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
7259 | 7259 | 2016-02-19 | 2006-07-28 | Yajima | Haruko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10366 | 10366 | 1966-03-20 | 1963-06-25 | Aoyama | Haruo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19306 | 19306 | 1999-06-12 | 1996-08-02 | Ogoshi | Harushige | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
37724 | 37724 | 1981-12-04 | 1978-10-11 | Kaizo | Hashimoto | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
36523 | 36523 | 2022-11-28 | 2019-12-26 | Tani | Hayato | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
22689 | 22689 | 1984-07-07 | 1982-10-05 | Hamaoka | Heiichi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19119 | 19119 | 2001-06-09 | 1999-04-27 | Nishiyama | Hidehiko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19766 | 19766 | 1996-06-17 | 1993-08-09 | Okada | Hideichi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
39288 | 39288 | 2000-12-29 | 1997-09-25 | Hasegawa | Hidekazu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
17901 | 17901 | 1997-05-31 | 1994-08-19 | Ito | Hideki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
30695 | 30695 | 2005-09-28 | 2004-02-24 | Yumoto | Hidemitsu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
23623 | 23623 | 2001-07-19 | 1999-04-27 | Watanabe | Hidenao | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19328 | 19328 | 2019-06-12 | 2016-07-07 | Teramura | Hidenobu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
6236 | 6236 | 1995-02-06 | 1992-02-04 | Kubota | Hideo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
33145 | 33145 | 2000-10-18 | 1997-09-25 | Yoshimi | Hideo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
21260 | 21260 | 1997-06-30 | 1990-02-02 | Okoshi | Hidetomo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
6237 | 6237 | 1995-02-06 | 1992-02-04 | Tanaka | Hidetoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
9411 | 9411 | 2001-03-07 | 1999-04-27 | Goto | Hideyuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
14282 | 14282 | 2002-04-28 | 1999-04-27 | Takahashi | Hideyuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20366 | 20366 | 1981-06-27 | 1978-10-11 | Takayuki | Hirano | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
22012 | 22012 | 2022-06-30 | 2019-09-03 | Machii | Hiroaki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
17065 | 17065 | 2019-05-24 | 2015-07-28 | Kayama | Hirobumi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19233 | 19233 | 1987-06-11 | 1985-01-07 | Kawano | Hirobumi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
30696 | 30696 | 2005-09-28 | 2004-04-20 | Aoki | Hiroe | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth 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 | |
4248 | 4248 | 1972-01-22 | 1969-09-11 | Nakaima | Hirokazu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
22182 | 22182 | 1988-07-01 | 1986-08-06 | Hayashi | Hirokazu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
22540 | 22540 | 2009-07-03 | 2006-06-14 | Mitsumata | Hiroki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
27224 | 27224 | 2006-08-22 | 2001-07-10 | Matsumoto | Hiroki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19005 | 19005 | 2014-06-06 | 2011-12-01 | Jacquemart | HirokoTachibana | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
13101 | 13101 | 2000-04-10 | 1999-04-27 | Okuyama | Hiromi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
11748 | 11748 | 1996-03-31 | 1993-08-09 | Utsumi | Hiromoto | 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 | |
3118 | 3118 | 1974-01-03 | 1970-03-05 | Tsuyama | Hiroshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
6981 | 6981 | 2012-02-15 | 2009-09-25 | Makino | Hiroshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
11081 | 11081 | 2004-03-29 | 2000-09-18 | Taoka | Hiroshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20467 | 20467 | 2005-06-28 | 2002-07-31 | Kitaoka | Hiroshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
21273 | 21273 | 1997-06-30 | 1992-08-06 | Tsukamoto | Hiroshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
24335 | 24335 | 2017-07-28 | 2014-07-01 | Maruoka | Hiroshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
27415 | 27415 | 1983-08-25 | 1980-12-09 | Tanaka | Hiroshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
23981 | 23981 | 2018-07-24 | 2016-07-19 | Tanaka | Hirotoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20048 | 20048 | 2007-06-22 | 2004-07-30 | Watanabe | Hiroyoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10636 | 10636 | 2021-03-23 | 2018-04-12 | Suzuki | Hiroyuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
16981 | 16981 | 2009-05-23 | 2004-10-19 | Akiyama | Hiroyuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
25088 | 25088 | 2006-07-31 | 2003-08-08 | Mitsuishi | Hiroyuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
25302 | 25302 | 2017-07-31 | 2014-09-23 | Kawabata | Hiroyuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
26398 | 26398 | 2010-08-10 | 2006-07-14 | Tanaka | Hiroyuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
33415 | 33415 | 1988-10-22 | 1985-01-07 | Wakabayashi | Hiroyuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
35985 | 35985 | 1983-11-17 | 1980-12-09 | Hirato | Hisao | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20571 | 20571 | 2001-06-29 | 1999-04-27 | Yoshikawa | Hisashi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
30353 | 30353 | 1975-09-24 | 1972-07-20 | Kawabata | Hisashi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
6067 | 6067 | 1993-02-03 | 1990-02-02 | Goto | Hitoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19308 | 19308 | 2003-06-12 | 2000-09-18 | Matsuda | Hitoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20570 | 20570 | 2001-06-29 | 1999-04-27 | Ito | Hitoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
22079 | 22079 | 1969-07-01 | 1966-07-27 | Ohgami | Hitoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
33643 | 33643 | 2005-10-25 | 2002-12-11 | Suzuki | Hitoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
3207 | 3207 | 2019-01-04 | 2010-08-11 | Watt | Ian | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
27019 | 27019 | 1995-08-19 | 1993-02-03 | Fujimoto | Ichiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
37640 | 37640 | 2005-12-02 | 2002-12-23 | Kato | Ikuo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
16702 | 16702 | 1996-05-19 | 1993-08-09 | Takatsuji | Ikushi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
32230 | 32230 | 2020-10-03 | 2016-03-03 | Wakamatsu | Isamu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 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]) );