List of all short form registrants (active and terminated)

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

23 rows where Registration_Number = 3318

View and edit SQL

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

State

Registration_Number

  • 3318 · 23

Registrant_Name

City

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
742   2018-05-09 Kuang Lin 3318 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
2259   2019-12-31 Yang Liu 3318 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
2954 2020-01-04 2019-01-22 Fan Xiuyun 3318 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
4813 1997-01-31 1995-03-06 Wu Bo 3318 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
5783 2016-02-05 2013-01-11 Hui Ma 3318 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
13739 1985-04-30 1982-01-22 Shen Shuyu 3318 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
13743 1985-04-30 1983-02-24 Lei Shan Ru 3318 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
13744 1985-04-30 1983-02-24 Li Deng Qi 3318 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
20982 1988-07-01 1987-10-01 Du Rongzheng 3318 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
21674 2018-07-10 2018-01-31 He Li 3318 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
22891 1991-07-27 1987-09-01 Zhou Yanjun 3318 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
27178 2016-08-31 2013-06-25 Xue Yaping 3318 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
27375 1987-09-01 1982-01-22 Liu Zihan 3318 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
27429 1990-09-01 1987-09-01 Meng Yibo 3318 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
30857 1982-10-08 1982-01-22 Li Tieying 3318 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
31421 2018-10-16 2014-06-23 Pan Xiaopeng 3318 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
32042 2000-10-26 1998-06-01 Yang Liuyin 3318 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
32737 1997-10-31 1995-03-06 Kong Lingyu 3318 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
32738 1997-10-31 1995-03-06 Wang Jianhao 3318 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
33327 2007-11-01 2004-08-23 Zhu Shan Zhong 3318 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
33739 2002-11-08 2002-09-11 Sun Yan Jun 3318 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
34285 2011-11-17 2008-05-12 Zhang Xinhong 3318 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
40246 2017-12-31 2017-02-13 Wang Yanjie 3318 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)
);