FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
19 rows where Address_1 = "1700 Pennsylvania Avenue, N.W."
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_Last_Name, Registration_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3779 | 3779 | 1982-01-15 | 1981-03-17 | Heenan | Kathleen | Jerris Leonard & Associates, P.C. 3214 | 1981-03-17 | Jerris Leonard & Associates, P.C. | 1700 Pennsylvania Avenue, N.W. | Suite 550 | Washington | DC | 20006 |
5731 | 5731 | 1982-02-01 | 1981-07-27 | Berrocal | Carlos J. | Jerris Leonard & Associates, P.C. 3214 | 1981-03-17 | Jerris Leonard & Associates, P.C. | 1700 Pennsylvania Avenue, N.W. | Suite 550 | Washington | DC | 20006 |
12620 | 12620 | 1968-04-02 | 1967-03-01 | Colson | Charles W. | Gadsby, Maguire & Hannah 2008 | 1967-03-01 | Gadsby, Maguire & Hannah | 1700 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
12621 | 12621 | 1968-04-02 | 1967-03-01 | Hostetler | James S. | Gadsby, Maguire & Hannah 2008 | 1967-03-01 | Gadsby, Maguire & Hannah | 1700 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
20009 | 20009 | 1981-06-22 | 1981-03-17 | Usera | Joseph Andrew | Jerris Leonard & Associates, P.C. 3214 | 1981-03-17 | Jerris Leonard & Associates, P.C. | 1700 Pennsylvania Avenue, N.W. | Suite 550 | Washington | DC | 20006 |
22691 | 22691 | 1987-07-07 | 1984-06-08 | Dunn | H. Stewart , Jr. | Ivins, Phillips & Barker 3595 | 1984-06-08 | Ivins, Phillips & Barker | 1700 Pennsylvania Avenue, N.W. | Suite 600 | Washington | DC | 20006 |
22692 | 22692 | 1987-07-07 | 1984-06-08 | Morrison | Philip D. | Ivins, Phillips & Barker 3595 | 1984-06-08 | Ivins, Phillips & Barker | 1700 Pennsylvania Avenue, N.W. | Suite 600 | Washington | DC | 20006 |
33056 | 33056 | 1980-10-17 | 1980-03-17 | Nolan | John S. | Miller & Chevalier 3094 | 1980-03-17 | Miller & Chevalier | 1700 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
34460 | 34460 | 2002-10-31 | 2001-04-24 | Conti | Jennifer | Valis Associates 5427 | 2001-04-24 | Valis Associates | 1700 Pennsylvania Avenue, N.W. | Suite 950 | Washington | DC | 20006 |
34461 | 34461 | 2002-10-31 | 2001-04-24 | Schulze | Richard T. | Valis Associates 5427 | 2001-04-24 | Valis Associates | 1700 Pennsylvania Avenue, N.W. | Suite 950 | Washington | DC | 20006 |
34462 | 34462 | 2002-10-31 | 2001-05-02 | Valis | Wayne H. | Valis Associates 5427 | 2001-04-24 | Valis Associates | 1700 Pennsylvania Avenue, N.W. | Suite 950 | Washington | DC | 20006 |
35679 | 35679 | 1972-11-13 | 1972-03-15 | Barker | Richard B. | Ivins, Phillips & Barker 2326 | 1972-03-15 | Ivins, Phillips & Barker | 1700 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
35680 | 35680 | 1972-11-13 | 1972-03-15 | Dunn | H. Stewart , Jr. | Ivins, Phillips & Barker 2326 | 1972-03-15 | Ivins, Phillips & Barker | 1700 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
35681 | 35681 | 1972-11-13 | 1972-03-15 | Reid | John C. | Ivins, Phillips & Barker 2326 | 1972-03-15 | Ivins, Phillips & Barker | 1700 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
36537 | 36537 | 1978-11-29 | 1973-08-06 | Nolan | John S. | Miller & Chevalier 2288 | 1971-11-04 | Miller & Chevalier | 1700 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
36538 | 36538 | 1978-11-29 | 1971-11-04 | Grier | Barron K. | Miller & Chevalier 2288 | 1971-11-04 | Miller & Chevalier | 1700 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
41465 | 41465 | 2005-12-31 | 2004-12-13 | Conti | Jennifer | Valis Associates 5660 | 2004-12-13 | Valis Associates | 1700 Pennsylvania Avenue, N.W. | Suite 950 | Washington | DC | 20006 |
41466 | 41466 | 2005-12-31 | 2004-12-13 | Schulze | Richard T. | Valis Associates 5660 | 2004-12-13 | Valis Associates | 1700 Pennsylvania Avenue, N.W. | Suite 950 | Washington | DC | 20006 |
41467 | 41467 | 2005-12-31 | 2004-12-13 | Valis | Wayne H. | Valis Associates 5660 | 2004-12-13 | Valis Associates | 1700 Pennsylvania Avenue, N.W. | Suite 950 | 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]) );