FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where "Short_Form_Date" is on date 1987-08-27
This data as json, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6657 | 6657 | 1988-02-12 | 1987-08-27 | Klinger | Sherry Nadine | Klinger Group 4004 | 1987-07-07 | Klinger Group | 18653 Ventura Boulevard | Suite 390 | Tarzana | CA | 91356 |
10444 | 10444 | 1989-03-21 | 1987-08-27 | Samuel | Steven A. | Windels, Marx, Davies & Ives 4014 | 1987-07-17 | Windels, Marx, Davies & Ives | 1701 Pennsylvania Avenue, N.W. | Suite 940 | Washington | DC | 20006 |
11700 | 11700 | 1993-03-31 | 1987-08-27 | Campbell | Frank W. | International Liaison, Inc. 4032 | 1987-08-27 | International Liaison, Inc. | 3413 Chantarene Drive | Pensacola | FL | 32507 | |
32906 | 32906 | 1991-10-15 | 1987-08-27 | Haydon | Charles | Dublirer, Haydon, Straci & Victor 3961 | 1987-04-15 | Dublirer, Haydon, Straci & Victor | 17 Battery Place | New York | NY | 10004 | |
40704 | 40704 | 1991-12-31 | 1987-08-27 | Cady | Donald H. | Doremus, Porter & Novelli 4031 | 1987-08-27 | Doremus, Porter & Novelli | 1001 - 30th Street, N.W. | Washington | DC | 20007 | |
40705 | 40705 | 1991-12-31 | 1987-08-27 | Devine | John P. | Doremus, Porter & Novelli 4031 | 1987-08-27 | Doremus, Porter & Novelli | 1001 - 30th Street, N.W. | Washington | DC | 20007 | |
40706 | 40706 | 1991-12-31 | 1987-08-27 | Druckenmiller | Robert | Doremus, Porter & Novelli 4031 | 1987-08-27 | Doremus, Porter & Novelli | 1001 - 30th Street, N.W. | Washington | DC | 20007 | |
40707 | 40707 | 1991-12-31 | 1987-08-27 | Gould | Robert J. | Doremus, Porter & Novelli 4031 | 1987-08-27 | Doremus, Porter & Novelli | 1001 - 30th Street, N.W. | Washington | DC | 20007 | |
40708 | 40708 | 1991-12-31 | 1987-08-27 | Nichols | David A. | Doremus, Porter & Novelli 4031 | 1987-08-27 | Doremus, Porter & Novelli | 1001 - 30th Street, N.W. | Washington | DC | 20007 | |
40709 | 40709 | 1991-12-31 | 1987-08-27 | Pederson | Wayne | Doremus, Porter & Novelli 4031 | 1987-08-27 | Doremus, Porter & Novelli | 1001 - 30th Street, N.W. | Washington | DC | 20007 | |
40710 | 40710 | 1991-12-31 | 1987-08-27 | Porter | John H. | Doremus, Porter & Novelli 4031 | 1987-08-27 | Doremus, Porter & Novelli | 1001 - 30th Street, N.W. | Washington | DC | 20007 | |
40711 | 40711 | 1991-12-31 | 1987-08-27 | Rose | Merrill | Doremus, Porter & Novelli 4031 | 1987-08-27 | Doremus, Porter & Novelli | 1001 - 30th Street, N.W. | Washington | DC | 20007 | |
40712 | 40712 | 1991-12-31 | 1987-08-27 | Snyder | Danny | Doremus, Porter & Novelli 4031 | 1987-08-27 | Doremus, Porter & Novelli | 1001 - 30th Street, N.W. | Washington | DC | 20007 |
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]) );