List of all short form registrants (active and terminated)

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

11 rows where Registration_Number = 6113

View and edit SQL

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

State

Registration_Number

  • 6113 · 11

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
125   2020-01-21 Mengna LI 6113 6113 2012-07-06 Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) 2001 Jefferson Davis Highway Suite 608 Arlington VA 22202
150   2017-01-26 Zhao Zhenge 6113 6113 2012-07-06 Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) 2001 Jefferson Davis Highway Suite 608 Arlington VA 22202
715   2018-05-04 Kong Zhiqiang 6113 6113 2012-07-06 Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) 2001 Jefferson Davis Highway Suite 608 Arlington VA 22202
1071   2012-07-06 Zhang Chunsheng 6113 6113 2012-07-06 Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) 2001 Jefferson Davis Highway Suite 608 Arlington VA 22202
1754   2015-10-27 Han Jianbing 6113 6113 2012-07-06 Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) 2001 Jefferson Davis Highway Suite 608 Arlington VA 22202
13038 2013-04-20 2012-07-06 Yang Jin 6113 6113 2012-07-06 Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) 2001 Jefferson Davis Highway Suite 608 Arlington VA 22202
15883 2015-05-21 2012-07-06 Xu Chenbin 6113 6113 2012-07-06 Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) 2001 Jefferson Davis Highway Suite 608 Arlington VA 22202
15884 2015-05-21 2013-07-10 Wang Guoping 6113 6113 2012-07-06 Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) 2001 Jefferson Davis Highway Suite 608 Arlington VA 22202
18285 2018-06-13 2013-07-10 Chen Bin 6113 6113 2012-07-06 Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) 2001 Jefferson Davis Highway Suite 608 Arlington VA 22202
32341 2017-10-29 2015-10-27 Pei Xinya 6113 6113 2012-07-06 Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) 2001 Jefferson Davis Highway Suite 608 Arlington VA 22202
34391 2017-11-20 2015-10-27 Xie Xiaoyu 6113 6113 2012-07-06 Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) 2001 Jefferson Davis Highway Suite 608 Arlington VA 22202

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