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 1990-05-22
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16666 | 16666 | 1994-05-18 | 1990-05-22 | Park | Dong Woo | Korea International Trade Association, Inc. 2686 | 1976-04-23 | Korea International Trade Association, Inc. | 460 Park Avenue | Suite 400 | New York | NY | 10022 |
17896 | 17896 | 1997-05-31 | 1990-05-22 | Frisch | Daniel J. | Ropes & Gray 4251 | 1989-05-12 | Ropes & Gray | 1301 K Street, N.W. | Suite 800 East | Washington | DC | 20005 |
26023 | 26023 | 2004-08-05 | 1990-05-22 | Miller | Martha L. | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
31053 | 31053 | 1990-09-30 | 1990-05-22 | Puckett | Richard Eugene | Democratic Renaissance Movement of Angola (D.R.M.A.) 4359 | 1990-03-27 | Democratic Renaissance Movement of Angola (D.R.M.A.) | 9883 Good Luck Road, West | Apartment 7 | Lanham | MD | 20706 |
31311 | 31311 | 2003-09-30 | 1990-05-22 | Braganza | Christine | VisitBritain 579 | 1949-07-07 | VisitBritain | 885 Second Avenue | 28th Floor | New York | NY | 10017 |
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]) );