FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
21 rows where "Short_Form_Termination_Date" is on date 1988-08-01
This data as json, CSV (advanced)
Suggested facets: Address_1, Zip
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25549 | 25549 | 1988-08-01 | 1937-01-01 | Zaprianov | Z. | Bulgarian Tourist Office 2148 | 1969-07-18 | Bulgarian Tourist Office | 161 East 86th Street | New York | NY | 10028 | |
25550 | 25550 | 1988-08-01 | 1951-01-16 | Ruschp | Josef Sepp | Austrian Tourist Office, Inc. 495 | 1947-10-03 | Austrian Tourist Office, Inc. | 61 Broadway | #1701 | New York | NY | 10006 |
25551 | 25551 | 1988-08-01 | 1951-01-16 | Schneider | Johann Baptist | Austrian Tourist Office, Inc. 495 | 1947-10-03 | Austrian Tourist Office, Inc. | 61 Broadway | #1701 | New York | NY | 10006 |
25552 | 25552 | 1988-08-01 | 1973-03-02 | Czerny | Walther K. | Austrian Tourist Office, Inc. 495 | 1947-10-03 | Austrian Tourist Office, Inc. | 61 Broadway | #1701 | New York | NY | 10006 |
25553 | 25553 | 1988-08-01 | 1973-04-06 | Feibelmann | Alice | Austrian Tourist Office, Inc. 495 | 1947-10-03 | Austrian Tourist Office, Inc. | 61 Broadway | #1701 | New York | NY | 10006 |
25554 | 25554 | 1988-08-01 | 1973-04-06 | Morris | Dorothy L. | Austrian Tourist Office, Inc. 495 | 1947-10-03 | Austrian Tourist Office, Inc. | 61 Broadway | #1701 | New York | NY | 10006 |
25555 | 25555 | 1988-08-01 | 1948-04-08 | Nagler | Erna | Austrian Tourist Office, Inc. 495 | 1947-10-03 | Austrian Tourist Office, Inc. | 61 Broadway | #1701 | New York | NY | 10006 |
25556 | 25556 | 1988-08-01 | 1983-04-18 | Marks | Kevin | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
25557 | 25557 | 1988-08-01 | 1988-04-18 | McCandless | Robert C. | Law Offices of Robert C. McCandless 4126 | 1988-04-18 | Law Offices of Robert C. McCandless | 618 E Street, S.E. | Washington | DC | 20003 | |
25558 | 25558 | 1988-08-01 | 1968-05-27 | Hirnschrodt | Heinrich | Austrian Tourist Office, Inc. 495 | 1947-10-03 | Austrian Tourist Office, Inc. | 61 Broadway | #1701 | New York | NY | 10006 |
25559 | 25559 | 1988-08-01 | 1950-06-19 | Bloch | Henry John | Austrian Tourist Office, Inc. 495 | 1947-10-03 | Austrian Tourist Office, Inc. | 61 Broadway | #1701 | New York | NY | 10006 |
25560 | 25560 | 1988-08-01 | 1950-06-22 | Wright | Richard William | Austrian Tourist Office, Inc. 495 | 1947-10-03 | Austrian Tourist Office, Inc. | 61 Broadway | #1701 | New York | NY | 10006 |
25561 | 25561 | 1988-08-01 | 1950-08-02 | Pantz | Hubert | Austrian Tourist Office, Inc. 495 | 1947-10-03 | Austrian Tourist Office, Inc. | 61 Broadway | #1701 | New York | NY | 10006 |
25562 | 25562 | 1988-08-01 | 1957-08-02 | Mueller | William C. | Austrian Tourist Office, Inc. 495 | 1947-10-03 | Austrian Tourist Office, Inc. | 61 Broadway | #1701 | New York | NY | 10006 |
25563 | 25563 | 1988-08-01 | 1947-08-19 | Von Warton | Rosario | Austrian Tourist Office, Inc. 495 | 1947-10-03 | Austrian Tourist Office, Inc. | 61 Broadway | #1701 | New York | NY | 10006 |
25564 | 25564 | 1988-08-01 | 1962-08-20 | Imhof | Eckard Paul | Austrian Tourist Office, Inc. 495 | 1947-10-03 | Austrian Tourist Office, Inc. | 61 Broadway | #1701 | New York | NY | 10006 |
25565 | 25565 | 1988-08-01 | 1947-08-28 | Anderwald | Frank P. | Austrian Tourist Office, Inc. 495 | 1947-10-03 | Austrian Tourist Office, Inc. | 61 Broadway | #1701 | New York | NY | 10006 |
25566 | 25566 | 1988-08-01 | 1985-09-16 | Lipps | Suzanne | Fontayne Group, Inc. 3752 | 1985-10-30 | Fontayne Group, Inc. | 430 Colorado Avenue, Penthouse | Santa Monica | CA | 90401 | |
25567 | 25567 | 1988-08-01 | 1950-09-18 | Pfeifer | Friedl | Austrian Tourist Office, Inc. 495 | 1947-10-03 | Austrian Tourist Office, Inc. | 61 Broadway | #1701 | New York | NY | 10006 |
25568 | 25568 | 1988-08-01 | 1947-10-13 | Mattesich | Virginia Creed Perry | Austrian Tourist Office, Inc. 495 | 1947-10-03 | Austrian Tourist Office, Inc. | 61 Broadway | #1701 | New York | NY | 10006 |
25569 | 25569 | 1988-08-01 | 1986-10-14 | Hill | Lisa Helen | Fontayne Group, Inc. 3752 | 1985-10-30 | Fontayne Group, Inc. | 430 Colorado Avenue, Penthouse | Santa Monica | CA | 90401 |
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]) );