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

19 rows where "Short_Form_Termination_Date" is on date 1986-06-30

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date, Short_Form_First_Name, Address_1, Zip, Short_Form_Termination_Date (date), Registration_Date (date)

State 5

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
21049 21049 1986-06-30 1981-01-14 Lioutyi Alexander New York Bureau of the Telegraph Agency of Russia (TASS) 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
21050 21050 1986-06-30 1974-02-20 Pfizenmayer Rickard Frank Squire, Sanders & Dempsey, L.L.P. 746 1952-12-02 Squire, Sanders & Dempsey, L.L.P. 1201 Pennsylvania Avenue, N.W. Post Office Box 407 Washington DC 20044-0407
21051 21051 1986-06-30 1982-03-04 Shalnev Alexander New York Bureau of the Telegraph Agency of Russia (TASS) 464 1947-06-03 New York Bureau of the Telegraph Agency of Russia (TASS) 50 Rockefeller Plaza   New York NY 10020
21052 21052 1986-06-30 1986-04-09 Sacklen Mats A. White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
21053 21053 1986-06-30 1986-04-18 Taguchi Kazunari East Asia Travel Association 2423 1973-05-07 East Asia Travel Association C/O Tourism Auth. of Thailand 304 Park Avenue South, 8th Floor New York NY 10010
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
21055 21055 1986-06-30 1983-06-02 Palivoda Randolph J. Government of the Province of Alberta 1720 1964-04-30 Government of the Province of Alberta Fed. & Intergovtmental Affairs 10025 Jasper Avenue, #2200 Edmonton, Alberta    
21056 21056 1986-06-30 1981-06-04 McKeown Kathleen M. China Books & Periodicals, Inc. 1350 1960-04-06 China Books & Periodicals, Inc. 2929 - 24th Street   San Francisco CA 94110
21057 21057 1986-06-30 1985-06-04 Begni Vera Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
21058 21058 1986-06-30 1985-06-04 Dieckhaus Mary Jo Gavin Anderson Doremus & Company 3378 1982-06-15 Gavin Anderson Doremus & Company 11 West 42nd Street 8th Floor New York NY 10036
21059 21059 1986-06-30 1985-06-12 Hoptman Sheri L. Japan Economic Institute of America 929 1956-01-25 Japan Economic Institute of America P.O.Box 65780   Washington DC 20035-5780
21060 21060 1986-06-30 1948-06-28 Sims Lillian Adelaide National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
21061 21061 1986-06-30 1977-07-08 Douglas William H. Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc. 420 Lexington Avenue   New York NY 10017
21062 21062 1986-06-30 1979-07-23 Sturtevant Robert S. Martin, Marshall, Jaccoma & Mitchell Advertising, Inc. 3043 1979-07-23 Martin, Marshall, Jaccoma & Mitchell Advertising, Inc. 41 Madison Avenue   New York NY 10010
21063 21063 1986-06-30 1984-09-18 Grace Manuel G. White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
21064 21064 1986-06-30 1984-09-27 Pietersz Edward A. Netherlands/Antilles Economic Mission 2477 1973-11-20 Netherlands/Antilles Economic Mission 1114 Avenue of the Americas   New York NY 10036
21065 21065 1986-06-30 1983-10-07 Hazlitt Elizabeth M. White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
21066 21066 1986-06-30 1985-11-05 Paine Peter S. , Jr. Cleary, Gottlieb, Steen & Hamilton, LLP 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21067 21067 1986-06-30 1977-11-28 Gargan Anthony P. IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154

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