FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where "Short_Form_Termination_Date" is on date 2001-09-30 and State = "DC" sorted by Zip
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Address_1, Address_2
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31265 | 31265 | 2001-09-30 | 2000-06-02 | Pignatelli | Melissa L. | Troutman Sanders, LLP 5329 | 1999-09-24 | Troutman Sanders, LLP | 401 9th Street, N.W. | Suite 1000 | Washington | DC | 20004-2134 |
31266 | 31266 | 2001-09-30 | 2000-06-02 | Suchman | Bonnie A. | Troutman Sanders, LLP 5329 | 1999-09-24 | Troutman Sanders, LLP | 401 9th Street, N.W. | Suite 1000 | Washington | DC | 20004-2134 |
31271 | 31271 | 2001-09-30 | 1999-09-24 | Colby | Amie V. | Troutman Sanders, LLP 5329 | 1999-09-24 | Troutman Sanders, LLP | 401 9th Street, N.W. | Suite 1000 | Washington | DC | 20004-2134 |
31272 | 31272 | 2001-09-30 | 1999-09-24 | Fitzgerald | Kevin | Troutman Sanders, LLP 5329 | 1999-09-24 | Troutman Sanders, LLP | 401 9th Street, N.W. | Suite 1000 | Washington | DC | 20004-2134 |
31273 | 31273 | 2001-09-30 | 1999-09-24 | Fitzgerald | Mary Clare | Troutman Sanders, LLP 5329 | 1999-09-24 | Troutman Sanders, LLP | 401 9th Street, N.W. | Suite 1000 | Washington | DC | 20004-2134 |
31274 | 31274 | 2001-09-30 | 1999-09-24 | Jensen | Thomas Christian | Troutman Sanders, LLP 5329 | 1999-09-24 | Troutman Sanders, LLP | 401 9th Street, N.W. | Suite 1000 | Washington | DC | 20004-2134 |
31275 | 31275 | 2001-09-30 | 1999-09-24 | Marsan | William Patrick | Troutman Sanders, LLP 5329 | 1999-09-24 | Troutman Sanders, LLP | 401 9th Street, N.W. | Suite 1000 | Washington | DC | 20004-2134 |
31276 | 31276 | 2001-09-30 | 1999-09-24 | Medel | Arthur V. | Troutman Sanders, LLP 5329 | 1999-09-24 | Troutman Sanders, LLP | 401 9th Street, N.W. | Suite 1000 | Washington | DC | 20004-2134 |
31277 | 31277 | 2001-09-30 | 1999-09-24 | Pierson | Stuart F. | Troutman Sanders, LLP 5329 | 1999-09-24 | Troutman Sanders, LLP | 401 9th Street, N.W. | Suite 1000 | Washington | DC | 20004-2134 |
31278 | 31278 | 2001-09-30 | 1999-09-24 | Thompson | Dionne Elizabeth | Troutman Sanders, LLP 5329 | 1999-09-24 | Troutman Sanders, LLP | 401 9th Street, N.W. | Suite 1000 | Washington | DC | 20004-2134 |
31279 | 31279 | 2001-09-30 | 1999-09-24 | Zdebski | Charles A. | Troutman Sanders, LLP 5329 | 1999-09-24 | Troutman Sanders, LLP | 401 9th Street, N.W. | Suite 1000 | Washington | DC | 20004-2134 |
31280 | 31280 | 2001-09-30 | 1999-09-29 | Hill | Hollister | Troutman Sanders, LLP 5329 | 1999-09-24 | Troutman Sanders, LLP | 401 9th Street, N.W. | Suite 1000 | Washington | DC | 20004-2134 |
31281 | 31281 | 2001-09-30 | 1999-09-29 | Rimer | Andrea | Troutman Sanders, LLP 5329 | 1999-09-24 | Troutman Sanders, LLP | 401 9th Street, N.W. | Suite 1000 | Washington | DC | 20004-2134 |
31262 | 31262 | 2001-09-30 | 2001-02-05 | Schlagenhauf | Jeffrey L. | McGuireWoods Consulting, LLC 5408 | 2001-02-05 | McGuireWoods Consulting, LLC | 2001 K Street, NW | Suite 400 | 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]) );