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

36 rows where "Short_Form_Termination_Date" is on date 1990-07-31

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Registration_Date, Address_2, Registration_Date (date)

State 7

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
24789 24789 1990-07-31 1990-02-23 Kast Lawrence P. Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
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
24791 24791 1990-07-31 1986-03-11 Tseng Roland China Media Services, Inc. 3793 1986-03-11 China Media Services, Inc. 9700 Reseda Boulevard   Northridge CA 91324
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
24794 24794 1990-07-31 1990-04-05 Barton Frederick D. Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
24795 24795 1990-07-31 1988-04-27 Johnston Jean Scottish Enterprise 3013 1979-04-17 Scottish Enterprise SCTR Ltd British Consulate One Broadway 7th Floor Cambridge MA 02109
24796 24796 1990-07-31 1983-04-30 Montgomery John Nixon South Africa Foundation 2111 1968-11-21 South Africa Foundation 1001 Connecticut Avenue, N.W. Suite 822 Washington DC 20036
24797 24797 1990-07-31 1988-05-04 Campbell David Paul Alan M. Porten & Associates, Inc. 4136 1988-05-04 Alan M. Porten & Associates, Inc. 8700 Georgia Avenue Suite 300 Silver Spring MD 20910
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
24803 24803 1990-07-31 1986-06-18 Avary Robert P. , Jr. Wagner, Hines & Avary, Inc. 3845 1986-06-18 Wagner, Hines & Avary, Inc. 1899 L Street, N.W. Suite 500 Washington DC 20036
24804 24804 1990-07-31 1986-06-18 Hines William J. Wagner, Hines & Avary, Inc. 3845 1986-06-18 Wagner, Hines & Avary, Inc. 1899 L Street, N.W. Suite 500 Washington DC 20036
24805 24805 1990-07-31 1986-06-18 Juliana James Wagner, Hines & Avary, Inc. 3845 1986-06-18 Wagner, Hines & Avary, Inc. 1899 L Street, N.W. Suite 500 Washington DC 20036
24806 24806 1990-07-31 1986-06-18 Wagner Paul F. Wagner, Hines & Avary, Inc. 3845 1986-06-18 Wagner, Hines & Avary, Inc. 1899 L Street, N.W. Suite 500 Washington DC 20036
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
24810 24810 1990-07-31 1989-08-31 Chopra Ram P. Government of India Tourist Office, Chicago 2398 1972-12-27 Government of India Tourist Office, Chicago 5701 North Sheridan Road   Chicago IL 60660
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
24817 24817 1990-07-31 1985-11-26 Jaxa-Debicki Andrew O'Connor & Hannan, L.L.P. 2972 1978-10-25 O'Connor & Hannan, L.L.P. 1666 K Street, N.W. Suite 500 Washington DC 20006

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