FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where "Short_Form_Date" is on date 1983-05-25
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 5
Registrant_Name 5
City 4
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3793 | 3793 | 1988-01-15 | 1983-05-25 | Chung | Bong Ik | Small Business Corporation - USA Office 3477 | 1983-05-25 | Small Business Corporation - USA Office | 120 Sylvan Avenue | Suite 301 | Englewood Cliffs | NJ | 07632 |
6518 | 6518 | 1986-02-10 | 1983-05-25 | Xiong | Xia Ser | Bee Moua 3311 | 1981-11-27 | Bee Moua | 301 James Street | Grayling | MI | 49738 | |
21054 | 21054 | 1986-06-30 | 1983-05-25 | Martin | Kenneth S. | One NorthEast 3476 | 1983-05-25 | One NorthEast | Meadows Corporate Center | 2850 West Golf Road, Suite 401 | Rolling Meadows | IL | 60008-4033 |
22913 | 22913 | 1989-07-10 | 1983-05-25 | Park | Young Joon | Small Business Corporation - USA Office 3477 | 1983-05-25 | Small Business Corporation - USA Office | 120 Sylvan Avenue | Suite 301 | Englewood Cliffs | NJ | 07632 |
27326 | 27326 | 1984-08-24 | 1983-05-25 | Brown | Douglas Arthur | One NorthEast 3476 | 1983-05-25 | One NorthEast | Meadows Corporate Center | 2850 West Golf Road, Suite 401 | Rolling Meadows | IL | 60008-4033 |
33241 | 33241 | 1988-10-20 | 1983-05-25 | Yang | Gnia Yee | Bee Moua 3311 | 1981-11-27 | Bee Moua | 301 James Street | Grayling | MI | 49738 | |
33242 | 33242 | 1988-10-20 | 1983-05-25 | Yang | Tong Neng | Bee Moua 3311 | 1981-11-27 | Bee Moua | 301 James Street | Grayling | MI | 49738 | |
36443 | 36443 | 1984-11-26 | 1983-05-25 | Hammond | Lou Rena | Taylor & Hammond, Ltd. 2977 | 1978-11-09 | Taylor & Hammond, Ltd. | 39 East 51st Street | New York | NY | 10022 | |
38393 | 38393 | 1985-12-15 | 1983-05-25 | Maguire | Robert A. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );