FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where Short_Form_Date = "1974-02-19"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, Zip, Short_Form_Termination_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11177 | 11177 | 1995-03-30 | 1974-02-19 | Gerber | Lewis B. | South Africa Foundation 2111 | 1968-11-21 | South Africa Foundation | 1001 Connecticut Avenue, N.W. | Suite 822 | Washington | DC | 20036 |
12419 | 12419 | 1976-04-01 | 1974-02-19 | Rhee | Kyu Ryong | Korea Trade Center, Seattle 2495 | 1974-02-19 | Korea Trade Center, Seattle | Bank of California Center | Suite 1245 | Seattle | WA | 98164 |
13681 | 13681 | 1974-04-18 | 1974-02-19 | Nichols | Doris Detre | Bronz & Farrell 1740 | 1964-05-22 | Bronz & Farrell | 1735 Jefferson Davis Highway | Suite 200 | Arlington | VA | 22202 |
17340 | 17340 | 1974-05-29 | 1974-02-19 | Price | Joseph H. | Leva, Hawes, Symington, Martin & Oppenheimer 2490 | 1974-01-28 | Leva, Hawes, Symington, Martin & Oppenheimer | 815 Connecticut Avenue, N.W. | Washington | DC | 20006 | |
17341 | 17341 | 1974-05-29 | 1974-02-19 | Symington | Lloyd | Leva, Hawes, Symington, Martin & Oppenheimer 2490 | 1974-01-28 | Leva, Hawes, Symington, Martin & Oppenheimer | 815 Connecticut Avenue, N.W. | Washington | DC | 20006 | |
20979 | 20979 | 1982-06-30 | 1974-02-19 | Hyman | Lester S. | Leva, Hawes, Symington, Martin & Oppenheimer 2490 | 1974-01-28 | Leva, Hawes, Symington, Martin & Oppenheimer | 815 Connecticut Avenue, N.W. | Washington | DC | 20006 | |
31246 | 31246 | 2000-09-30 | 1974-02-19 | Hinds | Richard deC. | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | 2000 Pennsylvania Avenue, NW | Washington | DC | 20006-1801 | |
33954 | 33954 | 1976-10-29 | 1974-02-19 | Pastor | Mariano A. | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
36205 | 36205 | 1974-11-22 | 1974-02-19 | Rickett | Robert R. | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | 2000 Pennsylvania Avenue, NW | Washington | DC | 20006-1801 | |
40459 | 40459 | 1988-12-31 | 1974-02-19 | Steinfels | Horst | French National Railroads, New York 335 | 1945-12-26 | French National Railroads, New York | 610 Fifth Avenue | New York | NY | 10020 |
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]) );