FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where "Short_Form_Termination_Date" is on date 1989-01-01 and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2674 | 2674 | 1989-01-01 | 1989-03-16 | Marmorstein | Vicki E. | Coudert Brothers 3743 | 1985-10-02 | Coudert Brothers | 1627 I Street, N. W. | Suite 1200 | Washington, | DC | 20006 |
2675 | 2675 | 1989-01-01 | 1982-04-08 | Clark | Reuben | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | 2445 M Street, N.W. | Washington | DC | 20037-1420 | |
2676 | 2676 | 1989-01-01 | 1979-05-03 | Warnke | Paul C. | Clifford & Warnke 2564 | 1975-03-26 | Clifford & Warnke | 815 Connecticut Avenue, N.W. | Washington | DC | 20006 | |
2677 | 2677 | 1989-01-01 | 1983-06-20 | Juliano | Robert E. | Anderson, Hibey & Blair 3208 | 1981-03-09 | Anderson, Hibey & Blair | 1708 New Hampshire Ave., N.W. | Washington | DC | 20009 | |
2678 | 2678 | 1989-01-01 | 1987-07-13 | Dennin | Joseph F. | McKenna, Conner & Cuneo 4011 | 1987-07-13 | McKenna, Conner & Cuneo | 1575 I Street, N.W. | Washington | DC | 20005 | |
2683 | 2683 | 1989-01-01 | 1988-10-25 | Pickering | John H. | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | 2445 M Street, N.W. | Washington | DC | 20037-1420 | |
2684 | 2684 | 1989-01-01 | 1987-11-03 | Laufman | David H. | Collier Shannon Scott, PLLC 3694 | 1985-06-24 | Collier Shannon Scott, PLLC | 3050 K Street N.W. | Suite 400 | Washington | DC | 20007-5108 |
2685 | 2685 | 1989-01-01 | 1981-11-20 | Rosenthal | Douglas E. | Sutherland, Asbill & Brennan 3307 | 1981-11-20 | Sutherland, Asbill & Brennan | 1275 Pennsylvania Avenue, N.W. | Washington | DC | 20004-2404 |
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]) );