FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
20 rows where Address_1 = "11601 Wilshire Boulevard", City = "Los Angeles" and State = "CA"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3095 | 3095 | 1992-01-02 | 1984-03-12 | Renner | Herwig | Austrian Trade Commission, Los Angeles 793 | 1953-10-21 | Austrian Trade Commission, Los Angeles | 11601 Wilshire Boulevard | Suite 2420 | Los Angeles | CA | 90025 |
7946 | 7946 | 1989-02-28 | 1986-08-28 | Parsons | Craig A. | Rifkind, Pondel & Parsons 3879 | 1986-08-28 | Rifkind, Pondel & Parsons | 11601 Wilshire Boulevard | Suite 760 | Los Angeles | CA | 90025 |
7947 | 7947 | 1989-02-28 | 1986-08-28 | Rifkind | Melvyn S. | Rifkind, Pondel & Parsons 3879 | 1986-08-28 | Rifkind, Pondel & Parsons | 11601 Wilshire Boulevard | Suite 760 | Los Angeles | CA | 90025 |
7948 | 7948 | 1989-02-28 | 1986-08-28 | Romano | Gregory F. | Rifkind, Pondel & Parsons 3879 | 1986-08-28 | Rifkind, Pondel & Parsons | 11601 Wilshire Boulevard | Suite 760 | Los Angeles | CA | 90025 |
7949 | 7949 | 1989-02-28 | 1986-08-28 | Wilkinson | Cecilia A. | Rifkind, Pondel & Parsons 3879 | 1986-08-28 | Rifkind, Pondel & Parsons | 11601 Wilshire Boulevard | Suite 760 | Los Angeles | CA | 90025 |
9911 | 9911 | 1972-03-15 | 1962-02-05 | Schulz | Susanne | Austrian Trade Commission, Los Angeles 793 | 1953-10-21 | Austrian Trade Commission, Los Angeles | 11601 Wilshire Boulevard | Suite 2420 | Los Angeles | CA | 90025 |
9913 | 9913 | 1972-03-15 | 1970-06-01 | Waldschuetz | Gerhard | Austrian Trade Commission, Los Angeles 793 | 1953-10-21 | Austrian Trade Commission, Los Angeles | 11601 Wilshire Boulevard | Suite 2420 | Los Angeles | CA | 90025 |
20711 | 20711 | 1960-06-30 | 1957-11-21 | Sander | Brigitte H. (Olan) | Austrian Trade Commission, Los Angeles 793 | 1953-10-21 | Austrian Trade Commission, Los Angeles | 11601 Wilshire Boulevard | Suite 2420 | Los Angeles | CA | 90025 |
23225 | 23225 | 1983-07-15 | 1977-05-23 | Lifka | Alexander | Austrian Trade Commission, Los Angeles 793 | 1953-10-21 | Austrian Trade Commission, Los Angeles | 11601 Wilshire Boulevard | Suite 2420 | Los Angeles | CA | 90025 |
27874 | 27874 | 1969-08-31 | 1961-05-15 | Imhof | Dr. Eckard Paul | Austrian Trade Commission, Los Angeles 793 | 1953-10-21 | Austrian Trade Commission, Los Angeles | 11601 Wilshire Boulevard | Suite 2420 | Los Angeles | CA | 90025 |
32738 | 32738 | 1992-10-13 | 1992-07-28 | Hans | Kausl | Austrian Trade Commission, Los Angeles 793 | 1953-10-21 | Austrian Trade Commission, Los Angeles | 11601 Wilshire Boulevard | Suite 2420 | Los Angeles | CA | 90025 |
35079 | 35079 | 1963-11-02 | 1964-02-13 | Koch | Dr. Fridolin | Austrian Trade Commission, Los Angeles 793 | 1953-10-21 | Austrian Trade Commission, Los Angeles | 11601 Wilshire Boulevard | Suite 2420 | Los Angeles | CA | 90025 |
36708 | 36708 | 1988-11-30 | 1986-08-28 | Landon | Barry | Rifkind, Pondel & Parsons 3879 | 1986-08-28 | Rifkind, Pondel & Parsons | 11601 Wilshire Boulevard | Suite 760 | Los Angeles | CA | 90025 |
38273 | 38273 | 1968-12-14 | 1966-09-26 | Voh | Richard F. | Austrian Trade Commission, Los Angeles 793 | 1953-10-21 | Austrian Trade Commission, Los Angeles | 11601 Wilshire Boulevard | Suite 2420 | Los Angeles | CA | 90025 |
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 |
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 |
39738 | 39738 | 1962-12-31 | 1954-05-27 | Rath | Alfred H. | Austrian Trade Commission, Los Angeles 793 | 1953-10-21 | Austrian Trade Commission, Los Angeles | 11601 Wilshire Boulevard | Suite 2420 | Los Angeles | CA | 90025 |
39747 | 39747 | 1962-12-31 | 1953-10-21 | Kriessmann | Dr. Wilhelm L. | Austrian Trade Commission, Los Angeles 793 | 1953-10-21 | Austrian Trade Commission, Los Angeles | 11601 Wilshire Boulevard | Suite 2420 | Los Angeles | CA | 90025 |
39954 | 39954 | 1973-12-31 | 1972-12-15 | Winkler | Dr. Egon | Austrian Trade Commission, Los Angeles 793 | 1953-10-21 | Austrian Trade Commission, Los Angeles | 11601 Wilshire Boulevard | Suite 2420 | Los Angeles | CA | 90025 |
40045 | 40045 | 1977-12-31 | 1976-08-31 | Duerer | Dr. Alexander M. | 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]) );