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

34 rows where "Short_Form_Termination_Date" is on date 1992-03-31

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Address_1, Zip, Short_Form_Termination_Date (date), Short_Form_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
11655 11655 1992-03-31 1988-01-05 Hirahara Patricia Diane Productions by Hirahara 4099 1988-03-08 Productions by Hirahara Post Office Box 4581   Anaheim CA 92803
11656 11656 1992-03-31 1983-01-10 Lieberman Edward H. Cole Corette & Abrutyn, P.C. 2968 1978-10-18 Cole Corette & Abrutyn, P.C. 805 - 15th Street, N.W, Suite 900 Washington DC 20005
11657 11657 1992-03-31 1989-01-19 Park Chang Do Korea Trade Center, Dallas 2652 1976-01-16 Korea Trade Center, Dallas 12720 Hillcrest Road Suite 390 Dallas TX 75230-2040
11658 11658 1992-03-31 1992-01-31 Spagnol Franco Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
11659 11659 1992-03-31 1992-02-07 Bloom Jane L. Paul, Weiss, Rifkind, Wharton & Garrison 4539 1991-07-09 Paul, Weiss, Rifkind, Wharton & Garrison 1285 Avenue of the Americas   New York NY 10019-6064
11660 11660 1992-03-31 1991-02-25 Valero Rob Burson-Marsteller 2469 1973-10-23 Burson-Marsteller 1110 Vermont Avenue, NW, 12th Floor   Washington DC 20005-3544
11661 11661 1992-03-31 1992-03-03 Isaacs Van J. Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
11662 11662 1992-03-31 1989-03-09 Yang Hyo Sik Korea Trade Center, Chicago 2648 1975-12-31 Korea Trade Center, Chicago 111 East Wacker Drive Suite 2229 Chicago IL 60601
11663 11663 1992-03-31 1991-04-11 Rieck Christopher IPG DXTRA, Inc 3911 1986-12-01 IPG DXTRA, Inc 909 Third Ave.   New York NY 10022
11664 11664 1992-03-31 1989-04-18 Johnston Laura K. GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. 825 Third Avenue 24th Floor New York NY 10022-7519
11665 11665 1992-03-31 1991-05-08 Campbell James S. Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering 2445 M Street, N.W.   Washington DC 20037-1420
11666 11666 1992-03-31 1991-05-08 Hammond Robert A. , III Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering 2445 M Street, N.W.   Washington DC 20037-1420
11667 11667 1992-03-31 1991-05-08 Lovett James Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering 2445 M Street, N.W.   Washington DC 20037-1420
11668 11668 1992-03-31 1991-05-08 Mathernova Katarina Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering 2445 M Street, N.W.   Washington DC 20037-1420
11669 11669 1992-03-31 1990-06-04 Thompson Anthony J. Perkins Coie 3753 1985-11-01 Perkins Coie 607 - 14th Street, N.W. Suite 800 Washington DC 20005
11670 11670 1992-03-31 1986-07-23 Shibuya Hironobu Dentsu Burson-Marsteller, Inc. 3861 1986-07-23 Dentsu Burson-Marsteller, Inc. 230 Park Avenue, South   New York NY 10003-1566
11671 11671 1992-03-31 1984-07-24 Caro Hector L. 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
11672 11672 1992-03-31 1991-07-29 Lowen Theodore W. Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
11673 11673 1992-03-31 1991-08-08 Wallison Peter J. Gibson, Dunn & Crutcher 4552 1991-08-08 Gibson, Dunn & Crutcher 1050 Connecticut Avenue, N.W.   Washington DC 20036
11674 11674 1992-03-31 1991-08-09 McCormick Mary Lou Gold & Liebengood, Inc. 3700 1985-07-09 Gold & Liebengood, Inc. 1455 Pennsylvania Avenue, N.W. Suite 950 Washington DC 20004
11675 11675 1992-03-31 1991-08-13 Lebow Cynthia C. Gibson, Dunn & Crutcher 4552 1991-08-08 Gibson, Dunn & Crutcher 1050 Connecticut Avenue, N.W.   Washington DC 20036
11676 11676 1992-03-31 1989-08-14 Kirimura Mitsuhiko JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
11677 11677 1992-03-31 1984-08-17 van Zyl Albertus South African Tourism 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
11678 11678 1992-03-31 1990-09-05 Windolph John M. Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
11679 11679 1992-03-31 1975-09-25 Inzerillo Josephine Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
11680 11680 1992-03-31 1990-09-28 Fossom Bonnie Jean Ehrig & Associates, Inc. 2603 1975-09-02 Ehrig & Associates, Inc. Post Office Box 9940   Seattle WA 98109
11681 11681 1992-03-31 1991-10-17 Hankey Blair Gilbert Paul, Weiss, Rifkind, Wharton & Garrison 4539 1991-07-09 Paul, Weiss, Rifkind, Wharton & Garrison 1285 Avenue of the Americas   New York NY 10019-6064
11682 11682 1992-03-31 1990-10-18 Yoon Heui-Ro KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11683 11683 1992-03-31 1991-11-08 Chin Stephen C. Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering 2445 M Street, N.W.   Washington DC 20037-1420
11684 11684 1992-03-31 1991-11-08 Greenwald John D. Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering 2445 M Street, N.W.   Washington DC 20037-1420
11685 11685 1992-03-31 1991-11-12 Cutler Lloyd N. Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering 2445 M Street, N.W.   Washington DC 20037-1420
11686 11686 1992-03-31 1981-11-19 Crawford Charles , III Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
11687 11687 1992-03-31 1990-12-07 Herget Grace Japan National Tourism Organization 769 1953-05-26 Japan National Tourism Organization 250 Park Avenue Suite. 1900   New York NY 10177
11688 11688 1992-03-31 1987-12-23 Riley Stephen F. Riley & Fox, Inc. 3813 1986-04-11 Riley & Fox, Inc. 1101 - 17th Street, N.W. Suite 606 Washington DC 20036

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