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

16 rows where Registration_Number = 450

✖
✖

✎ 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

  • Universal Trading Corporation · 16 ✖

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
4739 4739 1959-01-29 1947-04-04 How Bang Universal Trading Corporation 450 1947-04-04 Universal Trading Corporation 630 Fifth Avenue   New York NY  
4740 4740 1959-01-29 1947-04-04 Lochhead Archie Universal Trading Corporation 450 1947-04-04 Universal Trading Corporation 630 Fifth Avenue   New York NY  
4741 4741 1959-01-29 1947-04-04 Morris Lawrence Universal Trading Corporation 450 1947-04-04 Universal Trading Corporation 630 Fifth Avenue   New York NY  
4742 4742 1959-01-29 1947-04-04 Spurr William John , Jr. Universal Trading Corporation 450 1947-04-04 Universal Trading Corporation 630 Fifth Avenue   New York NY  
4743 4743 1959-01-29 1953-04-27 Chen Kwang Pu Universal Trading Corporation 450 1947-04-04 Universal Trading Corporation 630 Fifth Avenue   New York NY  
4744 4744 1959-01-29 1956-04-30 Lee Robert E. Universal Trading Corporation 450 1947-04-04 Universal Trading Corporation 630 Fifth Avenue   New York NY  
4745 4745 1959-01-29 1951-12-17 Ho Pao-Hsu Universal Trading Corporation 450 1947-04-04 Universal Trading Corporation 630 Fifth Avenue   New York NY  
24407 24407 1952-07-30 1948-11-30 Liang Chin-Tung Universal Trading Corporation 450 1947-04-04 Universal Trading Corporation 630 Fifth Avenue   New York NY  
27731 27731 1955-08-30 1947-04-04 Jones Alfred B. Universal Trading Corporation 450 1947-04-04 Universal Trading Corporation 630 Fifth Avenue   New York NY  
27734 27734 1955-08-30 1952-10-13 Kiang Piao Universal Trading Corporation 450 1947-04-04 Universal Trading Corporation 630 Fifth Avenue   New York NY  
27735 27735 1955-08-30 1949-11-22 Kwok Kam Kwan Universal Trading Corporation 450 1947-04-04 Universal Trading Corporation 630 Fifth Avenue   New York NY  
37761 37761 1955-12-05 1947-04-04 Li Zen Zuh Universal Trading Corporation 450 1947-04-04 Universal Trading Corporation 630 Fifth Avenue   New York NY  
37762 37762 1955-12-05 1947-04-04 Wood Shi Chioh Universal Trading Corporation 450 1947-04-04 Universal Trading Corporation 630 Fifth Avenue   New York NY  
37763 37763 1955-12-05 1948-11-26 Liang Chi Kai Universal Trading Corporation 450 1947-04-04 Universal Trading Corporation 630 Fifth Avenue   New York NY  
37764 37764 1955-12-05 1948-11-26 Pai S.T. Universal Trading Corporation 450 1947-04-04 Universal Trading Corporation 630 Fifth Avenue   New York NY  
37765 37765 1955-12-05 1947-12-01 Ren Sz-Dah Universal Trading Corporation 450 1947-04-04 Universal Trading Corporation 630 Fifth Avenue   New York NY  

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