FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

36 rows where Registration_Number = 1897

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date, Short_Form_Date (date), Registration_Date (date)

State 1

Registration_Number 1

  • Tourism Authority of Thailand, New York · 36 ✖

City 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
110 110   2021-01-13 Rermruk Soothawee Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
203 203   2022-01-26 Pongjaroen Prin Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
1484 1484   2020-07-26 Chantharangkun Natthinee Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
1530 1530   2021-07-29 Sawangcharoen Santi Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
2449 2449   2011-12-23 Buddhani Achiraya Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
2450 2450   2011-12-23 Harnpanpongse Pintida Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
2451 2451   2011-12-23 Intrachooto Chad Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
2568 2568 1975-01-01 1970-02-12 Wangpaichitr Seree Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
2679 2679 1989-01-01 1985-07-17 Pongsakitch Chaiyasith Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
3018 3018 2022-01-01 2018-01-05 Prakongpan Montira Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
3022 3022 2022-01-01 2014-08-01 Potipiroon Ratchanida Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
4513 4513 1970-01-26 1969-07-31 Satrabhaya Minavat Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
5421 5421 2009-01-31 2006-09-19 Shinaprayoon Bangornrat Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
5436 5436 2010-01-31 2009-08-17 Wanapinyosak Srisuda Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
5513 5513 2017-01-31 2015-01-29 Waraphaskul Srimala Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
5599 5599 2021-01-31 2017-07-19 Kiatlapnachai Charinya Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
5830 5830 2005-02-01 2002-09-24 Buddhani Sethaphan Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
9220 9220 1980-03-06 1976-01-07 Phromyothi Yibbhan Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
18175 18175 2016-05-31 2011-12-23 Hasenfus Kedsarin Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
20861 20861 1973-06-30 1973-02-15 Abhijatapong Patpong Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
21264 21264 1997-06-30 1993-02-26 Suranant Chalermsak Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
21349 21349 2000-06-30 1997-01-30 Boonchim Manit Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
22253 22253 1996-07-01 1992-03-23 Svetasreni Suraphon Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
25160 25160 2009-07-31 2006-09-19 Tapen Teerasil Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
25186 25186 2013-07-31 2010-05-17 Saisaengchan Pichaya Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
25628 25628 2001-08-01 1999-07-14 Pinpradab Suwalai Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
26540 26540 1993-08-13 1991-10-09 Varamisra Somprasong Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
28622 28622 2017-08-31 2014-02-26 Seeharach Siriwan Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
30855 30855 1965-09-30 1965-06-01 Chaovanagavi Bhurivat Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
30856 30856 1965-09-30 1965-06-01 Ramkomut Amara Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
30872 30872 1967-09-30 1965-10-19 Srinava Visit Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
31555 31555 2013-09-30 2011-12-23 Trairatana Sugunya Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
34018 34018 1968-10-30 1968-02-12 Thammapimuk Phairot Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
38860 38860 1976-12-21 1973-12-13 Sirisinha Staporn Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
39276 39276 1969-12-29 1967-08-25 Dejakaisaya Nuanta Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
40721 40721 1991-12-31 1991-10-09 Wangsai Paisan Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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])
);