FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
22 rows where Address_1 = "1100 Connecticut Avenue, N.W." and City = "Washington"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Last_Name, Short_Form_First_Name, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11887 | 11887 | 2002-03-31 | 2001-09-07 | Powell-Tamen | Deborah | Tamen & Tamen - Attorneys at Law 5456 | 2001-09-07 | Tamen & Tamen - Attorneys at Law | 1100 Connecticut Avenue, N.W. | Suite 1000 | Washington | DC | 20036 |
11888 | 11888 | 2002-03-31 | 2001-09-07 | Tamen | Emmanuel | Tamen & Tamen - Attorneys at Law 5456 | 2001-09-07 | Tamen & Tamen - Attorneys at Law | 1100 Connecticut Avenue, N.W. | Suite 1000 | Washington | DC | 20036 |
16587 | 16587 | 1983-05-17 | 1979-09-11 | Ryan | Jerry W. | Crowell & Moring 3058 | 1979-09-11 | Crowell & Moring | 1100 Connecticut Avenue, N.W. | Washington | DC | 20036 | |
16588 | 16588 | 1983-05-17 | 1979-12-27 | Davis | Robert O. | Crowell & Moring 3058 | 1979-09-11 | Crowell & Moring | 1100 Connecticut Avenue, N.W. | Washington | DC | 20036 | |
16589 | 16589 | 1983-05-17 | 1979-12-27 | Howard | Roscoe C. , Jr. | Crowell & Moring 3058 | 1979-09-11 | Crowell & Moring | 1100 Connecticut Avenue, N.W. | Washington | DC | 20036 | |
16590 | 16590 | 1983-05-17 | 1979-12-27 | Johnson | W. Stanfield | Crowell & Moring 3058 | 1979-09-11 | Crowell & Moring | 1100 Connecticut Avenue, N.W. | Washington | DC | 20036 | |
16591 | 16591 | 1983-05-17 | 1979-12-27 | Peterson | Todd D. | Crowell & Moring 3058 | 1979-09-11 | Crowell & Moring | 1100 Connecticut Avenue, N.W. | Washington | DC | 20036 | |
16592 | 16592 | 1983-05-17 | 1979-12-27 | Swennen | Jean-Pierre | Crowell & Moring 3058 | 1979-09-11 | Crowell & Moring | 1100 Connecticut Avenue, N.W. | Washington | DC | 20036 | |
17298 | 17298 | 1993-05-28 | 1993-03-26 | Carlisle | Linda E. | McClure, Trotter & Mentz 4783 | 1993-03-26 | McClure, Trotter & Mentz | 1100 Connecticut Avenue, N.W. | Suite 600 | Washington | DC | 20036 |
18837 | 18837 | 1993-06-04 | 1993-03-26 | McClure | William P. | McClure, Trotter & Mentz 4783 | 1993-03-26 | McClure, Trotter & Mentz | 1100 Connecticut Avenue, N.W. | Suite 600 | Washington | DC | 20036 |
18838 | 18838 | 1993-06-04 | 1993-03-26 | Mentz | J. Roger | McClure, Trotter & Mentz 4783 | 1993-03-26 | McClure, Trotter & Mentz | 1100 Connecticut Avenue, N.W. | Suite 600 | Washington | DC | 20036 |
18839 | 18839 | 1993-06-04 | 1993-06-23 | Kaiser | Sheryl L. | McClure, Trotter & Mentz 4783 | 1993-03-26 | McClure, Trotter & Mentz | 1100 Connecticut Avenue, N.W. | Suite 600 | Washington | DC | 20036 |
23102 | 23102 | 1982-07-14 | 1981-06-24 | Berliner | Henry A. , Jr. | Berliner & Maloney 3251 | 1981-06-24 | Berliner & Maloney | 1100 Connecticut Avenue, N.W. | Suite 420 | Washington | DC | 20036 |
23103 | 23103 | 1982-07-14 | 1981-06-24 | Zagaris | Bruce | Berliner & Maloney 3251 | 1981-06-24 | Berliner & Maloney | 1100 Connecticut Avenue, N.W. | Suite 420 | Washington | DC | 20036 |
23353 | 23353 | 1980-07-16 | 1980-02-20 | Barnett | Robert E. | Barnett, Yingling & Shay, P.C. 3070 | 1979-11-19 | Barnett, Yingling & Shay, P.C. | 1100 Connecticut Avenue, N.W. | Suite 940 | Washington | DC | 20036 |
26318 | 26318 | 1993-08-09 | 1995-08-07 | Bunn | Robert | Maloney & Burch 4844 | 1993-08-09 | Maloney & Burch | 1100 Connecticut Avenue, N.W. | Suite 1200 | Washington | DC | 20036 |
34956 | 34956 | 1994-11-01 | 1993-03-22 | Berliner | Deborah E. | Soble & Associates 4782 | 1993-03-22 | Soble & Associates | 1100 Connecticut Avenue, N.W. | Suite 1000 | Washington | DC | 20036-4101 |
34957 | 34957 | 1994-11-01 | 1993-03-22 | Soble | Stephen M. | Soble & Associates 4782 | 1993-03-22 | Soble & Associates | 1100 Connecticut Avenue, N.W. | Suite 1000 | Washington | DC | 20036-4101 |
39410 | 39410 | 1993-12-30 | 1993-05-13 | Carlisle | Linda E. | McClure, Trotter & Mentz, Chartered 4830 | 1993-05-13 | McClure, Trotter & Mentz, Chartered | 1100 Connecticut Avenue, N.W. | Suite 600 | Washington | DC | 20036 |
39411 | 39411 | 1993-12-30 | 1993-05-13 | McClure | William P. | McClure, Trotter & Mentz, Chartered 4830 | 1993-05-13 | McClure, Trotter & Mentz, Chartered | 1100 Connecticut Avenue, N.W. | Suite 600 | Washington | DC | 20036 |
39412 | 39412 | 1993-12-30 | 1993-05-13 | Mentz | J. Roger | McClure, Trotter & Mentz, Chartered 4830 | 1993-05-13 | McClure, Trotter & Mentz, Chartered | 1100 Connecticut Avenue, N.W. | Suite 600 | Washington | DC | 20036 |
39415 | 39415 | 1993-12-30 | 1993-06-23 | Kaiser | Sheryl L. | McClure, Trotter & Mentz, Chartered 4830 | 1993-05-13 | McClure, Trotter & Mentz, Chartered | 1100 Connecticut Avenue, N.W. | Suite 600 | Washington | DC | 20036 |
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]) );