FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
39 rows where Address_1 = "1775 Pennsylvania Avenue, N.W." and City = "Washington"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Registration_Date, Short_Form_Termination_Date (date), Short_Form_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4220 | 4220 | 1994-01-21 | 1992-02-11 | Marcus | Mary Jane | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
4444 | 4444 | 1990-01-25 | 1988-07-29 | McAnaney | Kevin G. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
4445 | 4445 | 1990-01-25 | 1988-08-01 | Califano | Joseph A. , Jr. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
4446 | 4446 | 1990-01-25 | 1988-08-01 | Isaacson | Marcia R. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
4447 | 4447 | 1990-01-25 | 1988-08-01 | Tammen | Susan S. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
6069 | 6069 | 1995-02-03 | 1988-03-08 | Noellert | William A. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
6071 | 6071 | 1995-02-03 | 1991-10-07 | Griffen | Robert H. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
6661 | 6661 | 1988-02-12 | 1985-11-27 | Boyle | Jayne F. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
9950 | 9950 | 1990-03-15 | 1987-11-19 | Cichnowicz | David J. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
13838 | 13838 | 1980-04-21 | 1977-03-24 | Duncan | Wallace L. | Duncan, Weinberg, Palmer & Miller, P.C. 2763 | 1977-03-24 | Duncan, Weinberg, Palmer & Miller, P.C. | 1775 Pennsylvania Avenue, N.W. | Suite 1200 | Washington | DC | 20006 |
13839 | 13839 | 1980-04-21 | 1977-03-24 | Miller | Frederick L. , Jr. | Duncan, Weinberg, Palmer & Miller, P.C. 2763 | 1977-03-24 | Duncan, Weinberg, Palmer & Miller, P.C. | 1775 Pennsylvania Avenue, N.W. | Suite 1200 | Washington | DC | 20006 |
13840 | 13840 | 1980-04-21 | 1977-03-24 | Palmer | Fredrick D. | Duncan, Weinberg, Palmer & Miller, P.C. 2763 | 1977-03-24 | Duncan, Weinberg, Palmer & Miller, P.C. | 1775 Pennsylvania Avenue, N.W. | Suite 1200 | Washington | DC | 20006 |
13841 | 13841 | 1980-04-21 | 1977-03-24 | Pembroke | James D. | Duncan, Weinberg, Palmer & Miller, P.C. 2763 | 1977-03-24 | Duncan, Weinberg, Palmer & Miller, P.C. | 1775 Pennsylvania Avenue, N.W. | Suite 1200 | Washington | DC | 20006 |
13842 | 13842 | 1980-04-21 | 1977-03-24 | Roady | Stephen E. | Duncan, Weinberg, Palmer & Miller, P.C. 2763 | 1977-03-24 | Duncan, Weinberg, Palmer & Miller, P.C. | 1775 Pennsylvania Avenue, N.W. | Suite 1200 | Washington | DC | 20006 |
13843 | 13843 | 1980-04-21 | 1977-03-24 | Weinberg | Edward | Duncan, Weinberg, Palmer & Miller, P.C. 2763 | 1977-03-24 | Duncan, Weinberg, Palmer & Miller, P.C. | 1775 Pennsylvania Avenue, N.W. | Suite 1200 | Washington | DC | 20006 |
13844 | 13844 | 1980-04-21 | 1977-04-28 | Udall | Stewart L. | Duncan, Weinberg, Palmer & Miller, P.C. 2763 | 1977-03-24 | Duncan, Weinberg, Palmer & Miller, P.C. | 1775 Pennsylvania Avenue, N.W. | Suite 1200 | Washington | DC | 20006 |
14140 | 14140 | 1991-04-26 | 1991-01-14 | Black | Joseph A. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
16816 | 16816 | 1979-05-21 | 1978-07-21 | Houser | Robert C. , Jr. | Foley, Lardner, Hollabaugh & Jacobs 2932 | 1978-07-21 | Foley, Lardner, Hollabaugh & Jacobs | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
20137 | 20137 | 1980-06-24 | 1978-07-21 | Byrnes | John W. | Foley, Lardner, Hollabaugh & Jacobs 2932 | 1978-07-21 | Foley, Lardner, Hollabaugh & Jacobs | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
20138 | 20138 | 1980-06-24 | 1978-07-21 | Fischer | Michael D. | Foley, Lardner, Hollabaugh & Jacobs 2932 | 1978-07-21 | Foley, Lardner, Hollabaugh & Jacobs | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
20140 | 20140 | 1980-06-24 | 1978-07-21 | Klarfeld | Catherine B. | Foley, Lardner, Hollabaugh & Jacobs 2932 | 1978-07-21 | Foley, Lardner, Hollabaugh & Jacobs | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
20142 | 20142 | 1980-06-24 | 1978-07-21 | Rigler | Douglas V. | Foley, Lardner, Hollabaugh & Jacobs 2932 | 1978-07-21 | Foley, Lardner, Hollabaugh & Jacobs | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
20383 | 20383 | 1990-06-27 | 1988-07-29 | Dowley | Joseph K. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
20443 | 20443 | 1995-06-28 | 1993-08-12 | Black | Joseph H. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
22910 | 22910 | 1987-07-10 | 1986-05-02 | Kanner | Frederick W. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
22911 | 22911 | 1987-07-10 | 1986-05-02 | McDermott | Robert J. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
22912 | 22912 | 1987-07-10 | 1986-05-02 | Warnke | Gordon E. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
23738 | 23738 | 1994-07-21 | 1993-06-25 | Craythorn | Dennis | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
26684 | 26684 | 1977-08-15 | 1977-03-24 | Weill | Jay R. | Duncan, Weinberg, Palmer & Miller, P.C. 2763 | 1977-03-24 | Duncan, Weinberg, Palmer & Miller, P.C. | 1775 Pennsylvania Avenue, N.W. | Suite 1200 | Washington | DC | 20006 |
29990 | 29990 | 1992-09-17 | 1992-02-11 | Magnus | John R. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
32413 | 32413 | 1988-10-07 | 1988-03-08 | MacLaughlin | Janet | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
35114 | 35114 | 1994-11-02 | 1994-07-05 | Carlson | Amy L. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
39172 | 39172 | 1988-12-27 | 1988-02-24 | Wolff | Alan William | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
40819 | 40819 | 1995-12-31 | 1992-02-11 | Stein | Michael H. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
40876 | 40876 | 1995-12-31 | 1993-06-25 | McFadden | W. Clark , II | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
40882 | 40882 | 1995-12-31 | 1994-07-05 | Ward | Bradford L. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
40883 | 40883 | 1995-12-31 | 1994-07-05 | Wolff | Alan William | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
40934 | 40934 | 1995-12-31 | 1985-11-27 | Salmon | John J. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
40938 | 40938 | 1995-12-31 | 1993-11-30 | Magnus | John R. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 |
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]) );