FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where City = "Washington", Registrant_Name = "Troutman Sanders, LLP", Registration_Number = 5329 and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_Last_Name
State 1
- DC · 13 ✖
Registration_Number 1
- Troutman Sanders, LLP · 13 ✖
Registrant_Name 1
- Troutman Sanders, LLP · 13 ✖
City 1
- Washington · 13 ✖
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 |
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]) );