FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where Short_Form_Termination_Date = "1981-02-27"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Registration_Date, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 6
Registrant_Name 6
City 4
- Washington 5
- New York 4
- Los Angeles 1
- Staten Island 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7768 | 7768 | 1981-02-27 | 1981-01-30 | Jessar | Jon | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
7769 | 7769 | 1981-02-27 | 1978-07-10 | Bilitz | Walter | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
7770 | 7770 | 1981-02-27 | 1978-07-15 | Kawakami | Tsutomu | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
7771 | 7771 | 1981-02-27 | 1978-08-03 | Baumbusch | Peter L. | Gibson, Dunn & Crutcher 2938 | 1978-08-03 | Gibson, Dunn & Crutcher | 1776 G Street, N.W. | Washington | DC | 20006 | |
7772 | 7772 | 1981-02-27 | 1978-08-03 | Parsky | Gerald L. | Gibson, Dunn & Crutcher 2938 | 1978-08-03 | Gibson, Dunn & Crutcher | 1776 G Street, N.W. | Washington | DC | 20006 | |
7773 | 7773 | 1981-02-27 | 1974-11-26 | Slizewski | Andrew J. | Hapag-Lloyd (America), Inc. 1088 | 1957-11-14 | Hapag-Lloyd (America), Inc. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
7774 | 7774 | 1981-02-27 | 1979-11-26 | Schuerman | Darryl | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
7775 | 7775 | 1981-02-27 | 1979-12-07 | Bonanno | Anthony | Gibson, Dunn & Crutcher 2938 | 1978-08-03 | Gibson, Dunn & Crutcher | 1776 G Street, N.W. | Washington | DC | 20006 | |
7776 | 7776 | 1981-02-27 | 1979-12-07 | Callister | Daniel Q. | Gibson, Dunn & Crutcher 2938 | 1978-08-03 | Gibson, Dunn & Crutcher | 1776 G Street, N.W. | Washington | DC | 20006 | |
7777 | 7777 | 1981-02-27 | 1976-12-17 | Anderson | Gavin | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
7778 | 7778 | 1981-02-27 | 1977-12-21 | Gray | Robert Keith | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );