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

25 rows where Registration_Number = 3318

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • China National Tourist Office · 25 ✖

Registrant_Name 1

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
204 204   2023-01-26 Ma Yunfei China National Tourist Office 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
1488 1488   2021-07-26 Lu Kailin China National Tourist Office 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
3209 3209 2020-01-04 2019-01-22 Fan Xiuyun China National Tourist Office 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
5177 5177 1997-01-31 1995-03-06 Wu Bo China National Tourist Office 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
6206 6206 2016-02-05 2013-01-11 Hui Ma China National Tourist Office 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
12860 12860 2022-04-06 2019-12-31 Yang Liu China National Tourist Office 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
14547 14547 1985-04-30 1982-01-22 Shen Shuyu China National Tourist Office 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
14551 14551 1985-04-30 1983-02-24 Lei Shan Ru China National Tourist Office 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
14552 14552 1985-04-30 1983-02-24 Li Deng Qi China National Tourist Office 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
22185 22185 1988-07-01 1987-10-01 Du Rongzheng China National Tourist Office 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
22932 22932 2018-07-10 2018-01-31 He Li China National Tourist Office 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
24183 24183 1991-07-27 1987-09-01 Zhou Yanjun China National Tourist Office 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
28617 28617 2016-08-31 2013-06-25 Xue Yaping China National Tourist Office 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
28840 28840 1987-09-01 1982-01-22 Liu Zihan China National Tourist Office 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
28894 28894 1990-09-01 1987-09-01 Meng Yibo China National Tourist Office 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
32445 32445 1982-10-08 1982-01-22 Li Tieying China National Tourist Office 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
33036 33036 2018-10-16 2014-06-23 Pan Xiaopeng China National Tourist Office 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
33680 33680 2000-10-26 1998-06-01 Yang Liuyin China National Tourist Office 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
34384 34384 1997-10-31 1995-03-06 Kong Lingyu China National Tourist Office 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
34385 34385 1997-10-31 1995-03-06 Wang Jianhao China National Tourist Office 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
34997 34997 2007-11-01 2004-08-23 Zhu Shan Zhong China National Tourist Office 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
35448 35448 2002-11-08 2002-09-11 Sun Yan Jun China National Tourist Office 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
36008 36008 2011-11-17 2008-05-12 Zhang Xinhong China National Tourist Office 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
38473 38473 2022-12-15 2018-05-09 Kuang Lin China National Tourist Office 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
42116 42116 2017-12-31 2017-02-13 Wang Yanjie China National Tourist Office 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 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])
);