FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
5 rows where "Short_Form_Date" is on date 1980-10-28
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3619 | 3619 | 1984-01-12 | 1980-10-28 | Pilkington | David Alan | New Zealand Milk Products, Inc. 2463 | 1973-10-01 | New Zealand Milk Products, Inc. | 1269 North McDowell Boulevard | Petaluma | CA | 94952 | |
7895 | 7895 | 1981-02-28 | 1980-10-28 | Young | Jing-Chuan | Far East Trade Service, Inc., Chicago 2911 | 1978-06-08 | Far East Trade Service, Inc., Chicago | 225 North Michigan Avenue | Suite 1888 | Chicago | IL | 60601 |
14528 | 14528 | 1981-04-30 | 1980-10-28 | Richard | Louise J. | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
23358 | 23358 | 1984-07-16 | 1980-10-28 | Chen | Eugene I-Jen | Far East Trade Service, Inc., Chicago 2911 | 1978-06-08 | Far East Trade Service, Inc., Chicago | 225 North Michigan Avenue | Suite 1888 | Chicago | IL | 60601 |
38863 | 38863 | 1984-12-21 | 1980-10-28 | Queenin | Bert E. | New Zealand Tourist & Publicity Office 2328 | 1972-03-27 | New Zealand Tourist & Publicity Office | 630 Fifth Avenue | Suite 530 | New York | NY | 10111 |
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]) );