FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
23 rows where Short_Form_Termination_Date = "1961-12-31"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_Last_Name, Registration_Date, Address_1, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
39699 | 39699 | 1961-12-31 | 1958-02-06 | Hayashi | Thomas T. | Japan Trade Promotion Office (JTPO) 1113 | 1958-02-06 | Japan Trade Promotion Office (JTPO) | 39 Broadway | New York | NY | 10006 | |
39700 | 39700 | 1961-12-31 | 1955-02-24 | Blake | Thomas Dawes | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | 136 Front Street | New York | NY | ||
39701 | 39701 | 1961-12-31 | 1960-02-29 | Ashbolt | Allan Campbell | Australian Broadcasting Corporation 394 | 1946-11-19 | Australian Broadcasting Corporation | 529 14th Street, N.W. | Suite 510 | Washington | DC | 20045 |
39702 | 39702 | 1961-12-31 | 1960-02-29 | Stone | David George | Australian Broadcasting Corporation 394 | 1946-11-19 | Australian Broadcasting Corporation | 529 14th Street, N.W. | Suite 510 | Washington | DC | 20045 |
39703 | 39703 | 1961-12-31 | 1955-03-01 | O'Toole | Donald Lawrence | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | 136 Front Street | New York | NY | ||
39704 | 39704 | 1961-12-31 | 1961-03-01 | Song | Willie | Korean Research & Information Office 761 | 1953-03-18 | Korean Research & Information Office | 1828 Jefferson Place, N.W. | Washington | DC | ||
39705 | 39705 | 1961-12-31 | 1946-03-07 | Ripley | Joseph Marion | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | 136 Front Street | New York | NY | ||
39706 | 39706 | 1961-12-31 | 1946-03-07 | Ross | Thomas Joseph | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | 136 Front Street | New York | NY | ||
39707 | 39707 | 1961-12-31 | 1953-03-21 | Brown | Frank G. , Jr. | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | 136 Front Street | New York | NY | ||
39708 | 39708 | 1961-12-31 | 1948-03-31 | Braga | George A. | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | 136 Front Street | New York | NY | ||
39709 | 39709 | 1961-12-31 | 1955-05-16 | Stoops | Dale Ira | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | 136 Front Street | New York | NY | ||
39710 | 39710 | 1961-12-31 | 1955-06-09 | Lantaff | William C. | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | 136 Front Street | New York | NY | ||
39711 | 39711 | 1961-12-31 | 1946-06-11 | Crosby | Laurence Alden | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | 136 Front Street | New York | NY | ||
39712 | 39712 | 1961-12-31 | 1954-06-12 | Stavisky | Samuel Elliot | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | 136 Front Street | New York | NY | ||
39713 | 39713 | 1961-12-31 | 1946-06-28 | Freda | Patricia Grace | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | 136 Front Street | New York | NY | ||
39714 | 39714 | 1961-12-31 | 1948-08-18 | Crenesse | Pierre | French Broadcasting System 479 | 1947-07-21 | French Broadcasting System | 501 Madison Avenue | New York | NY | ||
39715 | 39715 | 1961-12-31 | 1959-08-25 | Badger | Dorothy Storey | Surinam Tourist Bureau 1257 | 1959-08-25 | Surinam Tourist Bureau | 1 Rockefeller Plaza | New York | NY | 10020 | |
39716 | 39716 | 1961-12-31 | 1961-09-19 | Tyree | Earl Garland | McCann-Marschalk Company, Inc. 1477 | 1961-09-19 | McCann-Marschalk Company, Inc. | 1271 Avenue of the Americas | New York | NY | ||
39717 | 39717 | 1961-12-31 | 1947-10-07 | Froment | Frank L. | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | 136 Front Street | New York | NY | ||
39718 | 39718 | 1961-12-31 | 1946-10-08 | Nichols | John Alfred | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | 136 Front Street | New York | NY | ||
39719 | 39719 | 1961-12-31 | 1956-10-29 | Dinzl | Liselotte M. | Austrian Trade Commission, Los Angeles 793 | 1953-10-21 | Austrian Trade Commission, Los Angeles | 11601 Wilshire Boulevard | Suite 2420 | Los Angeles | CA | 90025 |
39720 | 39720 | 1961-12-31 | 1961-11-06 | Brown | Frank G. , Jr. | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | 136 Front Street | New York | NY | ||
39721 | 39721 | 1961-12-31 | 1954-12-09 | Habersatter | Gertrude Mathilde Ida | Austrian Trade Commission, Los Angeles 793 | 1953-10-21 | Austrian Trade Commission, Los Angeles | 11601 Wilshire Boulevard | Suite 2420 | Los Angeles | CA | 90025 |
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]) );