FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
44 rows where Address_1 = "1701 Pennsylvania Avenue, N.W."
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Registration_Date, Address_2, Zip, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2564 | 2564 | 1974-01-01 | 1973-07-10 | Semer | Milton P. | Rose, Schmidt, Hasley, & DiSalle 2275 | 1971-08-24 | Rose, Schmidt, Hasley, & DiSalle | 1701 Pennsylvania Avenue, N.W. | Suite 1040 | Washington | DC | 20006-5808 |
2566 | 2566 | 1974-01-01 | 1971-08-24 | Bamberger | Craig S. | Rose, Schmidt, Hasley, & DiSalle 2275 | 1971-08-24 | Rose, Schmidt, Hasley, & DiSalle | 1701 Pennsylvania Avenue, N.W. | Suite 1040 | Washington | DC | 20006-5808 |
2567 | 2567 | 1974-01-01 | 1971-08-24 | Sibal | Abner W. | Rose, Schmidt, Hasley, & DiSalle 2275 | 1971-08-24 | Rose, Schmidt, Hasley, & DiSalle | 1701 Pennsylvania Avenue, N.W. | Suite 1040 | Washington | DC | 20006-5808 |
9564 | 9564 | 1987-03-10 | 1978-05-04 | Lenzini | Paul A. | Rose, Schmidt, Hasley, & DiSalle 2275 | 1971-08-24 | Rose, Schmidt, Hasley, & DiSalle | 1701 Pennsylvania Avenue, N.W. | Suite 1040 | Washington | DC | 20006-5808 |
10058 | 10058 | 1987-03-16 | 1978-09-25 | Hostetler | James S. | Rose, Schmidt, Hasley, & DiSalle 2275 | 1971-08-24 | Rose, Schmidt, Hasley, & DiSalle | 1701 Pennsylvania Avenue, N.W. | Suite 1040 | Washington | DC | 20006-5808 |
10436 | 10436 | 1989-03-21 | 1987-07-17 | Moore | Jonathon R. | Windels, Marx, Davies & Ives 4014 | 1987-07-17 | Windels, Marx, Davies & Ives | 1701 Pennsylvania Avenue, N.W. | Suite 940 | Washington | DC | 20006 |
10437 | 10437 | 1989-03-21 | 1987-07-21 | Lury | Richard R. | Windels, Marx, Davies & Ives 4014 | 1987-07-17 | Windels, Marx, Davies & Ives | 1701 Pennsylvania Avenue, N.W. | Suite 940 | Washington | DC | 20006 |
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 |
10447 | 10447 | 1989-03-21 | 1987-10-01 | Cohen | Mark A. | Windels, Marx, Davies & Ives 4014 | 1987-07-17 | Windels, Marx, Davies & Ives | 1701 Pennsylvania Avenue, N.W. | Suite 940 | Washington | DC | 20006 |
13907 | 13907 | 1988-04-22 | 1937-01-01 | Riordan | John H. | Rose, Schmidt, Hasley, & DiSalle 2275 | 1971-08-24 | Rose, Schmidt, Hasley, & DiSalle | 1701 Pennsylvania Avenue, N.W. | Suite 1040 | Washington | DC | 20006-5808 |
15380 | 15380 | 1986-05-01 | 1980-10-06 | Hufbauer | Gary C. | Rose, Schmidt, Hasley, & DiSalle 2275 | 1971-08-24 | Rose, Schmidt, Hasley, & DiSalle | 1701 Pennsylvania Avenue, N.W. | Suite 1040 | Washington | DC | 20006-5808 |
15392 | 15392 | 1988-05-01 | 1981-10-06 | Wellford | W. Harrison | Wellford, Wegman & Hoff 3278 | 1981-10-06 | Wellford, Wegman & Hoff | 1701 Pennsylvania Avenue, N.W. | Suite 1000 | Washington | DC | 20006 |
17015 | 17015 | 1989-05-24 | 1988-04-27 | Russell | William A. , Jr. | William Russell & Associates, Inc. 4135 | 1988-04-27 | William Russell & Associates, Inc. | 1701 Pennsylvania Avenue, N.W. | Suite 1000 | Washington | DC | 20006 |
17423 | 17423 | 1978-05-30 | 1971-09-10 | Paul | Norman S. | Rose, Schmidt, Hasley, & DiSalle 2275 | 1971-08-24 | Rose, Schmidt, Hasley, & DiSalle | 1701 Pennsylvania Avenue, N.W. | Suite 1040 | Washington | DC | 20006-5808 |
21027 | 21027 | 1984-06-30 | 1971-08-24 | Smith | W.N. Harrell | Rose, Schmidt, Hasley, & DiSalle 2275 | 1971-08-24 | Rose, Schmidt, Hasley, & DiSalle | 1701 Pennsylvania Avenue, N.W. | Suite 1040 | Washington | DC | 20006-5808 |
21078 | 21078 | 1988-06-30 | 1937-01-01 | III | Edgar F. Heiskell | Rose, Schmidt, Hasley, & DiSalle 2275 | 1971-08-24 | Rose, Schmidt, Hasley, & DiSalle | 1701 Pennsylvania Avenue, N.W. | Suite 1040 | Washington | DC | 20006-5808 |
21151 | 21151 | 1991-06-30 | 1979-05-02 | Kenney | William J. | Rose, Schmidt, Hasley, & DiSalle 2275 | 1971-08-24 | Rose, Schmidt, Hasley, & DiSalle | 1701 Pennsylvania Avenue, N.W. | Suite 1040 | Washington | DC | 20006-5808 |
21161 | 21161 | 1991-06-30 | 1971-08-24 | Sears | John P. | Rose, Schmidt, Hasley, & DiSalle 2275 | 1971-08-24 | Rose, Schmidt, Hasley, & DiSalle | 1701 Pennsylvania Avenue, N.W. | Suite 1040 | Washington | DC | 20006-5808 |
22205 | 22205 | 1991-07-01 | 1986-02-16 | Kushnick | Michael G. | Rose, Schmidt, Hasley, & DiSalle 2275 | 1971-08-24 | Rose, Schmidt, Hasley, & DiSalle | 1701 Pennsylvania Avenue, N.W. | Suite 1040 | Washington | DC | 20006-5808 |
22210 | 22210 | 1991-07-01 | 1977-08-10 | Sturtevant | Albert D. | Rose, Schmidt, Hasley, & DiSalle 2275 | 1971-08-24 | Rose, Schmidt, Hasley, & DiSalle | 1701 Pennsylvania Avenue, N.W. | Suite 1040 | Washington | DC | 20006-5808 |
25856 | 25856 | 1971-08-03 | 1970-01-26 | De Concini | Dino | Paul R. Gibson & Associates 2149 | 1969-07-25 | Paul R. Gibson & Associates | 1701 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
25857 | 25857 | 1971-08-03 | 1971-02-19 | Wright | Hamilton , Jr. | Paul R. Gibson & Associates 2149 | 1969-07-25 | Paul R. Gibson & Associates | 1701 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
25858 | 25858 | 1971-08-03 | 1969-06-25 | De Seife | Rodolphe J.A. | Paul R. Gibson & Associates 2149 | 1969-07-25 | Paul R. Gibson & Associates | 1701 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
28177 | 28177 | 1990-08-31 | 1989-09-14 | Tucker | William | Tucker & Associates 4292 | 1989-09-14 | Tucker & Associates | 1701 Pennsylvania Avenue, N.W. | Suite 1000 | Washington | DC | 20006 |
33193 | 33193 | 1989-10-19 | 1990-01-17 | Yelverton | William , Jr. | Tucker & Associates 4292 | 1989-09-14 | Tucker & Associates | 1701 Pennsylvania Avenue, N.W. | Suite 1000 | Washington | DC | 20006 |
33195 | 33195 | 1989-10-19 | 1989-09-27 | Greenberg | Mark | Tucker & Associates 4292 | 1989-09-14 | Tucker & Associates | 1701 Pennsylvania Avenue, N.W. | Suite 1000 | Washington | DC | 20006 |
33196 | 33196 | 1989-10-19 | 1989-09-27 | Wahlquist | Andrew | Tucker & Associates 4292 | 1989-09-14 | Tucker & Associates | 1701 Pennsylvania Avenue, N.W. | Suite 1000 | Washington | DC | 20006 |
35337 | 35337 | 1992-11-06 | 1992-05-14 | Simmons | G. Lindsay | Jackson & Kelly 4540 | 1991-07-10 | Jackson & Kelly | 1701 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
35848 | 35848 | 1988-11-15 | 1982-01-05 | Lambert | David P. | Wellford, Wegman & Hoff 3278 | 1981-10-06 | Wellford, Wegman & Hoff | 1701 Pennsylvania Avenue, N.W. | Suite 1000 | Washington | DC | 20006 |
35850 | 35850 | 1988-11-15 | 1982-04-14 | Tucker | William | Wellford, Wegman & Hoff 3278 | 1981-10-06 | Wellford, Wegman & Hoff | 1701 Pennsylvania Avenue, N.W. | Suite 1000 | Washington | DC | 20006 |
35852 | 35852 | 1988-11-15 | 1986-05-07 | Belsky | Adam C. | Wellford, Wegman & Hoff 3278 | 1981-10-06 | Wellford, Wegman & Hoff | 1701 Pennsylvania Avenue, N.W. | Suite 1000 | Washington | DC | 20006 |
35855 | 35855 | 1988-11-15 | 1981-10-08 | Gold | Peter F. | Wellford, Wegman & Hoff 3278 | 1981-10-06 | Wellford, Wegman & Hoff | 1701 Pennsylvania Avenue, N.W. | Suite 1000 | Washington | DC | 20006 |
35856 | 35856 | 1988-11-15 | 1981-10-08 | Hoff | Paul S. | Wellford, Wegman & Hoff 3278 | 1981-10-06 | Wellford, Wegman & Hoff | 1701 Pennsylvania Avenue, N.W. | Suite 1000 | Washington | DC | 20006 |
35857 | 35857 | 1988-11-15 | 1981-10-08 | Krulwich | Andrew S. | Wellford, Wegman & Hoff 3278 | 1981-10-06 | Wellford, Wegman & Hoff | 1701 Pennsylvania Avenue, N.W. | Suite 1000 | Washington | DC | 20006 |
35858 | 35858 | 1988-11-15 | 1981-10-08 | Wegman | Richard A. | Wellford, Wegman & Hoff 3278 | 1981-10-06 | Wellford, Wegman & Hoff | 1701 Pennsylvania Avenue, N.W. | Suite 1000 | Washington | DC | 20006 |
37283 | 37283 | 1970-12-01 | 1969-06-25 | Gibson | Paul R. | Paul R. Gibson & Associates 2149 | 1969-07-25 | Paul R. Gibson & Associates | 1701 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
39317 | 39317 | 1977-12-30 | 1977-10-05 | Darling | Charles M. , IV | Baker & Botts 2833 | 1977-10-05 | Baker & Botts | 1701 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
39318 | 39318 | 1977-12-30 | 1977-10-05 | Gooch | R. Gordon | Baker & Botts 2833 | 1977-10-05 | Baker & Botts | 1701 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
39319 | 39319 | 1977-12-30 | 1977-10-05 | Kiely | Bruce F. | Baker & Botts 2833 | 1977-10-05 | Baker & Botts | 1701 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
39320 | 39320 | 1977-12-30 | 1977-10-05 | McManus | Randolph Q. | Baker & Botts 2833 | 1977-10-05 | Baker & Botts | 1701 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
39321 | 39321 | 1977-12-30 | 1977-10-05 | Neaher | Virginia A. | Baker & Botts 2833 | 1977-10-05 | Baker & Botts | 1701 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
40384 | 40384 | 1986-12-31 | 1983-10-29 | Reuss | Henry S. | Rose, Schmidt, Hasley, & DiSalle 2275 | 1971-08-24 | Rose, Schmidt, Hasley, & DiSalle | 1701 Pennsylvania Avenue, N.W. | Suite 1040 | Washington | DC | 20006-5808 |
40644 | 40644 | 1990-12-31 | 1989-09-14 | Gilmore | Rick | Tucker & Associates 4292 | 1989-09-14 | Tucker & Associates | 1701 Pennsylvania Avenue, N.W. | Suite 1000 | Washington | DC | 20006 |
41621 | 41621 | 2008-12-31 | 2005-03-25 | Romero | Raul R. | ACG, LLC 5677 | 2005-03-25 | ACG, LLC | 1701 Pennsylvania Avenue, N.W. | Suite 300 | 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]) );