home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for FARA_All_ShortForms
List of all short form registrants (active and terminated)

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

81 rows where Registration_Number = 2414

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • NY 81

Registration_Number 1

  • Singapore Tourism Board · 81 ✖

Registrant_Name 1

  • Singapore Tourism Board 81

City 1

  • New York 81
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
865 865   2020-04-24 Ng Qi Hui Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
888 888   2023-04-26 Zaher Mariana Awad Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
890 890   2018-04-27 Ahn Debbie Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
1393 1393   2017-07-12 Wang Sze Mien Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
1995 1995   2021-10-21 Bhavani Krisna Rajan Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
2003 2003   2021-10-21 Yeo Zhi Qi Jayne Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
2006 2006   2019-10-22 Loh Rachel Yu Li Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
2085 2085   2022-11-01 Sharp Anna Naomi Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
2087 2087   2022-11-01 Yap Gregory Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
2172 2172   2018-11-15 Sorensen Ulrich Britt Hougaard Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
4638 4638 2003-01-27 1990-05-02 Hecht Debra Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
4970 4970 1980-01-31 1973-03-27 Lawrence Morgan Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
7178 7178 2017-02-17 2016-04-15 Knobloch James L. Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
8828 8828 2002-03-01 1989-08-07 Sim Peck-Hoon Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
9130 9130 2005-03-04 2003-04-17 Tseng Gabriel Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
9185 9185 2003-03-05 2000-04-26 Tan Vincent Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
10890 10890 2003-03-27 2001-05-25 Tan Randall C. Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
11597 11597 1989-03-31 1989-03-28 Victorson Dean M. Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
12184 12184 2016-03-31 2015-04-13 Banglin Jaclyn Tan Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
13033 13033 1990-04-09 1988-05-16 Koh Kay-Yew Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
13056 13056 2010-04-09 2007-10-22 Brennan Gail Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
13182 13182 1997-04-11 1990-05-02 Low Choi-Hoon Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
13769 13769 2021-04-19 2017-07-12 Banglin Jaclyn Tan Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
13773 13773 2021-04-19 2016-10-18 Yang Inez Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
14262 14262 1994-04-28 1990-05-02 Hanifa Sajid Mohd Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
14273 14273 1995-04-28 1992-06-29 Loi Hai Poh Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
14284 14284 2006-04-28 2003-04-17 Yeo Mark Kay Chuan Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
15072 15072 2015-04-30 2012-04-20 Khalsa Nirankar Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
16278 16278 2011-05-13 2010-04-15 Cortes Rose Mary Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
16708 16708 2006-05-19 2001-11-28 Eu Mark P. Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
16709 16709 2008-05-19 2007-04-23 Wong Foon Tze Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
16818 16818 1981-05-21 1979-10-18 Kuek Jacqueline Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
16883 16883 1990-05-22 1989-04-05 Curran Catherine M.C. Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
17250 17250 2015-05-27 2013-10-15 Jong Alice Ting Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
18028 18028 2007-05-31 2007-04-23 Hichour Karim Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
18097 18097 2012-05-31 2011-10-18 Shalla Kristi Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
18508 18508 1995-06-01 1992-06-30 Tseng Gabriel Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
19316 19316 2009-06-12 2007-04-23 Lim Wen Ee Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
19317 19317 2009-06-12 2007-10-22 Choo Huei Miin Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
19728 19728 2021-06-16 2021-04-19 Hazen Ryleigh Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
19729 19729 2021-06-16 2018-11-15 Choh Christina Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
19828 19828 2015-06-18 2012-04-20 Chio Wen Jie Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
19830 19830 2018-06-18 2015-10-23 Lee Michele Ching Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
21122 21122 1989-06-30 1988-07-09 Poon Alfred K.H. Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
22016 22016 2022-06-30 2018-11-15 Ferguson Charlise Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
22317 22317 2009-07-01 2007-04-23 Choo Remy Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
22350 22350 2011-07-01 2009-10-08 Rhode Thorsten Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
22929 22929 2015-07-10 2013-04-18 Barnes Tara Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
23032 23032 2019-07-12 2018-11-15 Rohrmann Nicole Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
23687 23687 2016-07-20 2013-10-15 Hong Siong Chen Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
25947 25947 1989-08-04 1989-04-05 Weiner Cindy Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
25962 25962 2011-08-04 2011-04-25 Figge Michael Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
26650 26650 2018-08-14 2015-04-13 Krulic Susan Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
26841 26841 1995-08-16 1988-02-17 Arends Adriaan M. Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
27261 27261 1989-08-23 1989-03-28 Nekoba Karen Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
28162 28162 1990-08-31 1989-08-07 Tan Soo-Yan Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
28509 28509 2007-08-31 2004-10-27 Chew Kok Chuan Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
29439 29439 1995-09-08 1990-05-02 Laura Poh-Choo Kau Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
29500 29500 2022-09-09 2021-04-19 Koh Glenn Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
29915 29915 2016-09-15 2016-04-15 Barber Joanna Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
29961 29961 2014-09-16 2012-10-19 Medina Kerry Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
30614 30614 1999-09-27 1990-07-10 Leong Charles Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
31521 31521 2011-09-30 2006-03-07 Goh Kershing Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
31715 31715 2021-09-30 2019-04-26 Renjie Wong Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
32110 32110 2019-10-01 2014-04-03 Goh Kershing Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
32891 32891 1988-10-15 1986-05-30 Yong Nelli Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
33646 33646 2018-10-25 2017-04-24 Yang Yawen Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
33672 33672 1992-10-26 1989-05-11 Liok Belinda Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
34475 34475 2003-10-31 1993-02-26 Chew Min Seng Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
34689 34689 2017-10-31 2007-04-23 Lim Divine Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
34704 34704 2017-10-31 2017-10-20 Yang Selena Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
34897 34897 1985-11-01 1980-04-18 Thai Emile Q.L. Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
36035 36035 2011-11-18 2009-10-08 Tham Ambrose Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
36775 36775 1994-11-30 1993-06-08 Ip-Magdael Judianna Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
39137 39137 2008-12-26 2007-04-23 Chapman William Dennis Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
40361 40361 1986-12-31 1979-05-14 Stell Ronald George Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
40376 40376 1986-12-31 1986-09-10 Leong Kevin Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
40381 40381 1986-12-31 1979-10-18 Leong Kok Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
40405 40405 1987-12-31 1986-05-30 Yuen K.C. Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
40442 40442 1987-12-31 1981-10-29 Low Anita Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
41888 41888 2013-12-31 2009-10-08 Tan Serene Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017

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])
);
Powered by Datasette · Queries took 671.123ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows