FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
30 rows where Registration_Number = 1350
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30927 | 30927 | 1978-09-30 | 1974-06-06 | Bulmer | Gary | China Books & Periodicals, Inc. 1350 | 1960-04-06 | China Books & Periodicals, Inc. | 2929 - 24th Street | San Francisco | CA | 94110 | |
30940 | 30940 | 1980-09-30 | 1979-12-05 | Andrews | Alice C. | China Books & Periodicals, Inc. 1350 | 1960-04-06 | China Books & Periodicals, Inc. | 2929 - 24th Street | San Francisco | CA | 94110 | |
34881 | 34881 | 1979-11-01 | 1977-06-24 | Misheloff | Ruth | China Books & Periodicals, Inc. 1350 | 1960-04-06 | China Books & Periodicals, Inc. | 2929 - 24th Street | San Francisco | CA | 94110 | |
35203 | 35203 | 1976-11-04 | 1973-05-17 | Foung | Casey | China Books & Periodicals, Inc. 1350 | 1960-04-06 | China Books & Periodicals, Inc. | 2929 - 24th Street | San Francisco | CA | 94110 | |
35663 | 35663 | 1992-11-12 | 1991-05-15 | Bramblett | William R. | China Books & Periodicals, Inc. 1350 | 1960-04-06 | China Books & Periodicals, Inc. | 2929 - 24th Street | San Francisco | CA | 94110 | |
36296 | 36296 | 1978-11-24 | 1976-12-02 | Goff | Gary | China Books & Periodicals, Inc. 1350 | 1960-04-06 | China Books & Periodicals, Inc. | 2929 - 24th Street | San Francisco | CA | 94110 | |
36695 | 36695 | 1988-11-30 | 1973-02-08 | Noyes | Harry H. | China Books & Periodicals, Inc. 1350 | 1960-04-06 | China Books & Periodicals, Inc. | 2929 - 24th Street | San Francisco | CA | 94110 | |
39783 | 39783 | 1964-12-31 | 1963-11-22 | Koss | Harry | China Books & Periodicals, Inc. 1350 | 1960-04-06 | China Books & Periodicals, Inc. | 2929 - 24th Street | San Francisco | CA | 94110 | |
39976 | 39976 | 1975-12-31 | 1972-05-09 | Shimasaki | David S. | China Books & Periodicals, Inc. 1350 | 1960-04-06 | China Books & Periodicals, Inc. | 2929 - 24th Street | San Francisco | CA | 94110 | |
40227 | 40227 | 1982-12-31 | 1982-05-20 | Caplan | Michael | China Books & Periodicals, Inc. 1350 | 1960-04-06 | China Books & Periodicals, Inc. | 2929 - 24th Street | San Francisco | CA | 94110 |
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]) );