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

23 rows where "Short_Form_Termination_Date" is on date 1991-12-31 and State = "NY"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Registration_Date, Zip, Short_Form_Date (date)

State 1

City 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
40656 40656 1991-12-31 1985-01-16 Wirth Henry H. Frankl, Wolfe J. 3173 1980-12-01 Frankl, Wolfe J. Berlin Economic Develop. Corp. 767 Third Avenue New York NY 10017
40665 40665 1991-12-31 1988-01-26 Arnold R. Arthur Netherlands Chamber of Commerce in the U.S., Inc. 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
40666 40666 1991-12-31 1991-01-31 Davison Jaymi GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. 825 Third Avenue 24th Floor New York NY 10022-7519
40667 40667 1991-12-31 1991-01-31 Perez Maria Isabel GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. 825 Third Avenue 24th Floor New York NY 10022-7519
40668 40668 1991-12-31 1991-01-31 Siegmann Robert J. GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. 825 Third Avenue 24th Floor New York NY 10022-7519
40670 40670 1991-12-31 1982-02-11 de Boer Kurt W. Frankl, Wolfe J. 3173 1980-12-01 Frankl, Wolfe J. Berlin Economic Develop. Corp. 767 Third Avenue New York NY 10017
40671 40671 1991-12-31 1982-02-16 Bechtle J.R. Frankl, Wolfe J. 3173 1980-12-01 Frankl, Wolfe J. Berlin Economic Develop. Corp. 767 Third Avenue New York NY 10017
40673 40673 1991-12-31 1991-02-20 Levy David E. International Public Relations Company, Ltd. 1967 1966-03-14 International Public Relations Company, Ltd. 352 Park Avenue, South Suite 705 New York NY 10010
40674 40674 1991-12-31 1991-02-20 Porwick Julie Grey Entertainment & Media, Inc. 4473 1991-02-20 Grey Entertainment & Media, Inc. 875 Third Avenue   New York NY 10022
40675 40675 1991-12-31 1981-03-10 Hernandez Eitel Curacao Tourist Board, New York 3209 1981-03-10 Curacao Tourist Board, New York 475 Park Avenue, South Suite 2000 New York NY 10016
40676 40676 1991-12-31 1986-03-11 Connolly John P. Friends of Fianna Fail, Inc. 3596 1984-06-08 Friends of Fianna Fail, Inc. C/O Richardson Mahon Casey & Rooney, LLP 1270 Avenue of the Americas #2911 New York NY 10020
40679 40679 1991-12-31 1990-04-09 Obeidat Thamer A. White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
40683 40683 1991-12-31 1991-04-23 Rokit David J. International Public Relations Company, Ltd. 1967 1966-03-14 International Public Relations Company, Ltd. 352 Park Avenue, South Suite 705 New York NY 10010
40684 40684 1991-12-31 1980-04-28 Phillips William E. Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 2530 1974-08-12 Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 309 West 49th Street Worldwide Plaza New York NY 10019-7399
40690 40690 1991-12-31 1986-07-11 Velasquez Rose GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. 825 Third Avenue 24th Floor New York NY 10022-7519
40699 40699 1991-12-31 1971-08-13 Connick Andrew J. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
40700 40700 1991-12-31 1985-08-13 Rasmussen John D. New Zealand Tourist & Publicity Office 2328 1972-03-27 New Zealand Tourist & Publicity Office 630 Fifth Avenue Suite 530 New York NY 10111
40701 40701 1991-12-31 1990-08-17 Astoriano Michael Saatchi & Saatchi North America, Inc. 3605 1984-07-24 Saatchi & Saatchi North America, Inc. Saatchi & Saatchi Building 375 Hudson Street, 10th Floor New York NY 10014-3620
40702 40702 1991-12-31 1985-08-23 Winchester Maxwell E. New Zealand Tourist & Publicity Office 2328 1972-03-27 New Zealand Tourist & Publicity Office 630 Fifth Avenue Suite 530 New York NY 10111
40718 40718 1991-12-31 1989-10-04 Kambolin Anatoly E. Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation 15 West 36th Street 6th Floor New York NY 10018
40719 40719 1991-12-31 1988-10-07 Chauvet Isabelle White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
40721 40721 1991-12-31 1991-10-09 Wangsai Paisan Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
40731 40731 1991-12-31 1984-12-14 Spiller Hans-Juergen Frankl, Wolfe J. 3173 1980-12-01 Frankl, Wolfe J. Berlin Economic Develop. Corp. 767 Third Avenue New York NY 10017

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