FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where City = "Washington" and Short_Form_Termination_Date = "2007-01-01"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Registration_Date, Address_2, Zip, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2841 | 2841 | 2007-01-01 | 1997-03-04 | Gardner | Barbara K. | Leventhal, Senter & Lerman, PLLC 5161 | 1997-03-04 | Leventhal, Senter & Lerman, PLLC | 2000 K Street, N.W. | Suite 600 | Washington | DC | 20006-1809 |
2844 | 2844 | 2007-01-01 | 2003-05-05 | Blacklin | Scott | JWI, LLC 4990 | 1995-02-06 | JWI, LLC | 700 New Hampshire Avenue, NW | Watergate South, Suite 1019 | Washington | DC | 20037 |
2845 | 2845 | 2007-01-01 | 2003-07-01 | Barber, III | Robert J. | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
2849 | 2849 | 2007-01-01 | 1985-09-13 | Tompkins | Joseph B. , Jr. | Sidley Austin LLP 3731 | 1985-09-13 | Sidley Austin LLP | 1501 K Street, N.W. | 8th Floor | Washington | DC | 20005 |
2850 | 2850 | 2007-01-01 | 2006-09-19 | Davenport | Rory | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
2852 | 2852 | 2007-01-01 | 2006-10-10 | Medina | Carla | CLS Strategies 5774 | 2006-10-06 | CLS Strategies | 1850 M Street, NW | Suite 900 | Washington | DC | 20036 |
2853 | 2853 | 2007-01-01 | 2006-10-20 | Nelson | Reid | Capitol Links LLC 5761 | 2006-06-27 | Capitol Links LLC | 1300 Pennsylvania Avenue, NW | Suite 700 | Washington | DC | 20004 |
2854 | 2854 | 2007-01-01 | 2001-10-23 | McCabe | Ian | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
2855 | 2855 | 2007-01-01 | 2003-10-30 | Masters | Rich | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
2856 | 2856 | 2007-01-01 | 2006-10-31 | Begala | Chris | Capitol Links LLC 5761 | 2006-06-27 | Capitol Links LLC | 1300 Pennsylvania Avenue, NW | Suite 700 | Washington | DC | 20004 |
2857 | 2857 | 2007-01-01 | 2005-11-01 | Goldberg | Donald F. | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
2859 | 2859 | 2007-01-01 | 2006-12-19 | Martin | Charles | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
2860 | 2860 | 2007-01-01 | 2006-12-19 | Michael | Kathleen Connors | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | 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]) );