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

24 rows where "Short_Form_Termination_Date" is on date 1990-07-31 and State = "NY"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Last_Name, Address_1, Address_2, Short_Form_Termination_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
24782 24782 1990-07-31 1986-01-21 Shao Quentin C.H. 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
24783 24783 1990-07-31 1981-01-27 Wolff Lester L. Baron/Canning & Company, Inc. 2270 1971-07-23 Baron/Canning & Company, Inc. 555 Madison Avenue 12th Floor New York NY 10022
24784 24784 1990-07-31 1981-02-04 Wright Daniel R. Baron/Canning & Company, Inc. 2270 1971-07-23 Baron/Canning & Company, Inc. 555 Madison Avenue 12th Floor New York NY 10022
24785 24785 1990-07-31 1985-02-04 Fortune Terence J. Paul, Weiss, Rifkind, Wharton & Garrison 3647 1985-02-04 Paul, Weiss, Rifkind, Wharton & Garrison 1285 Avenue of the Americas   New York NY 10019
24786 24786 1990-07-31 1985-02-04 Montgomery Robert E. , Jr. Paul, Weiss, Rifkind, Wharton & Garrison 3647 1985-02-04 Paul, Weiss, Rifkind, Wharton & Garrison 1285 Avenue of the Americas   New York NY 10019
24787 24787 1990-07-31 1987-02-12 Luck Robert Austrian Trade Commission, New York 625 1950-05-11 Austrian Trade Commission, New York 150 East 52nd Street 32nd Floor New York NY 10022
24788 24788 1990-07-31 1989-02-21 Morgan Lance Ian IPG DXTRA, Inc 3911 1986-12-01 IPG DXTRA, Inc 909 Third Ave.   New York NY 10022
24790 24790 1990-07-31 1987-03-08 Nadhan Leela S. India Tourism, New York 2329 1972-04-05 India Tourism, New York 1270 Avenue of the Americas Suite 303 New York NY 10020-1700
24792 24792 1990-07-31 1990-03-29 Gibbons Micahel Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. 250 Hudson Street   New York NY 10013
24793 24793 1990-07-31 1989-04-04 Zoebeli Urs Christian Alpine Tourist Office 2052 1967-09-27 Alpine Tourist Office C/O Austrian Tourist Office, Inc. 608 Fifth Avenue New York NY 10020
24798 24798 1990-07-31 1976-05-13 Halpern Seymour Baron/Canning & Company, Inc. 2270 1971-07-23 Baron/Canning & Company, Inc. 555 Madison Avenue 12th Floor New York NY 10022
24799 24799 1990-07-31 1985-05-14 Sorensen Theodore C. Paul, Weiss, Rifkind, Wharton & Garrison 3647 1985-02-04 Paul, Weiss, Rifkind, Wharton & Garrison 1285 Avenue of the Americas   New York NY 10019
24800 24800 1990-07-31 1976-06-12 Goldstein Nathan W. Baron/Canning & Company, Inc. 2270 1971-07-23 Baron/Canning & Company, Inc. 555 Madison Avenue 12th Floor New York NY 10022
24801 24801 1990-07-31 1976-06-12 Taubkin Irvin S. Baron/Canning & Company, Inc. 2270 1971-07-23 Baron/Canning & Company, Inc. 555 Madison Avenue 12th Floor New York NY 10022
24802 24802 1990-07-31 1987-06-16 Zoebeli Urs Christian Switzerland Tourism 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
24807 24807 1990-07-31 1986-06-26 Mann Susan O. Paul, Weiss, Rifkind, Wharton & Garrison 3647 1985-02-04 Paul, Weiss, Rifkind, Wharton & Garrison 1285 Avenue of the Americas   New York NY 10019
24808 24808 1990-07-31 1972-07-28 Canning Jessie M. Baron/Canning & Company, Inc. 2270 1971-07-23 Baron/Canning & Company, Inc. 555 Madison Avenue 12th Floor New York NY 10022
24809 24809 1990-07-31 1976-08-09 Berman Jason S. Baron/Canning & Company, Inc. 2270 1971-07-23 Baron/Canning & Company, Inc. 555 Madison Avenue 12th Floor New York NY 10022
24811 24811 1990-07-31 1985-09-17 Nimetz Matthew Paul, Weiss, Rifkind, Wharton & Garrison 3647 1985-02-04 Paul, Weiss, Rifkind, Wharton & Garrison 1285 Avenue of the Americas   New York NY 10019
24812 24812 1990-07-31 1978-09-22 McLaughlin John Baron/Canning & Company, Inc. 2270 1971-07-23 Baron/Canning & Company, Inc. 555 Madison Avenue 12th Floor New York NY 10022
24813 24813 1990-07-31 1978-09-28 Shattil Arlene Baron/Canning & Company, Inc. 2270 1971-07-23 Baron/Canning & Company, Inc. 555 Madison Avenue 12th Floor New York NY 10022
24814 24814 1990-07-31 1981-10-07 Brady John J. , III Baron/Canning & Company, Inc. 2270 1971-07-23 Baron/Canning & Company, Inc. 555 Madison Avenue 12th Floor New York NY 10022
24815 24815 1990-07-31 1989-10-13 Meresman Leila Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc. 450 Park Avenue, South   New York NY 10016
24816 24816 1990-07-31 1982-11-01 Luessenhop Elizabeth Baron/Canning & Company, Inc. 2270 1971-07-23 Baron/Canning & Company, Inc. 555 Madison Avenue 12th Floor New York NY 10022

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