fara: FARA_All_ShortForms: 4 rows where City = "New York" and "Short_Form_Termination

List of all short form registrants (active and terminated)

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

4 rows where City = "New York" and "Short_Form_Termination_Date" is on date 1989-11-30

Search:

descending

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
36718	36718	1989-11-30	1988-04-08	Tatiner	Peter Barrie	GCI Group, Inc. 3856	1986-07-11	GCI Group, Inc.	825 Third Avenue	24th Floor	New York	NY	10022-7519
36719	36719	1989-11-30	1987-04-17	Lawrence	Kelly R.	North American Precis Syndicate 2836	1977-10-12	North American Precis Syndicate	201 East 42nd Street		New York	NY	10017
36720	36720	1989-11-30	1988-05-16	Howe	Stephen R.	Government of Ontario, Canada 2087	1968-04-11	Government of Ontario, Canada	800 Third Avenue	Suite 2800	New York	NY	10022
36722	36722	1989-11-30	1988-08-26	Cantin	Raymond	Quebec Government Office 1787	1964-09-02	Quebec Government Office	One Rockefeller Plaza	Suite 2600	New York	NY	10020-2102

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