FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
20 rows where City = "Washington", "Short_Form_Termination_Date" is on date 2009-03-31 and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_1, Zip, Short_Form_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12034 | 12034 | 2009-03-31 | 2008-02-25 | O'Hanlon | John | Washington Group 5711 | 2005-09-30 | Washington Group | 1401 K Street, NW | Suite 1000 | Washington | DC | 20005-3422 |
12035 | 12035 | 2009-03-31 | 1987-04-24 | Brown | Robert M. , Jr. | Jones Day 3427 | 1982-12-10 | Jones Day | 51 Louisiana Avenue, N.W. | Washington | DC | 20001-2113 | |
12036 | 12036 | 2009-03-31 | 2008-04-29 | Rutledge | Colleen Theresa | Sidley Austin LLP 3731 | 1985-09-13 | Sidley Austin LLP | 1501 K Street, N.W. | 8th Floor | Washington | DC | 20005 |
12037 | 12037 | 2009-03-31 | 2006-05-10 | McNicholas | Edward R. | Sidley Austin LLP 3731 | 1985-09-13 | Sidley Austin LLP | 1501 K Street, N.W. | 8th Floor | Washington | DC | 20005 |
12038 | 12038 | 2009-03-31 | 2006-05-10 | Stillabower | Erika L. | Sidley Austin LLP 3731 | 1985-09-13 | Sidley Austin LLP | 1501 K Street, N.W. | 8th Floor | Washington | DC | 20005 |
12039 | 12039 | 2009-03-31 | 2006-05-10 | Tatel | Jennifer | Sidley Austin LLP 3731 | 1985-09-13 | Sidley Austin LLP | 1501 K Street, N.W. | 8th Floor | Washington | DC | 20005 |
12040 | 12040 | 2009-03-31 | 2008-05-14 | Ford | Wallace | GoodWorks International, LLC 5414 | 2001-03-02 | GoodWorks International, LLC | 1700 K Street NW | Suite 430 | Washington | DC | 20006-3806 |
12041 | 12041 | 2009-03-31 | 2009-05-26 | Varma | Amanda | Steptoe & Johnson, LLP 5848 | 2008-01-25 | Steptoe & Johnson, LLP | 1330 Connecticut Avenue, NW | Washington | DC | 20036 | |
12042 | 12042 | 2009-03-31 | 2008-06-13 | Johnston | Hunter | Steptoe & Johnson, LLP 5848 | 2008-01-25 | Steptoe & Johnson, LLP | 1330 Connecticut Avenue, NW | Washington | DC | 20036 | |
12047 | 12047 | 2009-03-31 | 2008-08-28 | West | Phil | Steptoe & Johnson, LLP 5848 | 2008-01-25 | Steptoe & Johnson, LLP | 1330 Connecticut Avenue, NW | Washington | DC | 20036 | |
12048 | 12048 | 2009-03-31 | 2008-09-26 | Busch | Madison H. | McGuireWoods Consulting, LLC 5408 | 2001-02-05 | McGuireWoods Consulting, LLC | 2001 K Street, NW | Suite 400 | Washington | DC | 20006 |
12049 | 12049 | 2009-03-31 | 2005-09-30 | Allen | Kevin D. | Washington Group 5711 | 2005-09-30 | Washington Group | 1401 K Street, NW | Suite 1000 | Washington | DC | 20005-3422 |
12050 | 12050 | 2009-03-31 | 2005-09-30 | Edwards | Melissa | Washington Group 5711 | 2005-09-30 | Washington Group | 1401 K Street, NW | Suite 1000 | Washington | DC | 20005-3422 |
12051 | 12051 | 2009-03-31 | 2005-09-30 | Farmer | Kimberley | Washington Group 5711 | 2005-09-30 | Washington Group | 1401 K Street, NW | Suite 1000 | Washington | DC | 20005-3422 |
12052 | 12052 | 2009-03-31 | 2005-09-30 | Lobo | Paul | Washington Group 5711 | 2005-09-30 | Washington Group | 1401 K Street, NW | Suite 1000 | Washington | DC | 20005-3422 |
12053 | 12053 | 2009-03-31 | 2005-09-30 | Noone | James | Washington Group 5711 | 2005-09-30 | Washington Group | 1401 K Street, NW | Suite 1000 | Washington | DC | 20005-3422 |
12054 | 12054 | 2009-03-31 | 2005-09-30 | Saunders (Speed) | Tonya | Washington Group 5711 | 2005-09-30 | Washington Group | 1401 K Street, NW | Suite 1000 | Washington | DC | 20005-3422 |
12055 | 12055 | 2009-03-31 | 2005-09-30 | West | Fowler | Washington Group 5711 | 2005-09-30 | Washington Group | 1401 K Street, NW | Suite 1000 | Washington | DC | 20005-3422 |
12059 | 12059 | 2009-03-31 | 2008-10-30 | Raul | Alan Charles | Sidley Austin LLP 3731 | 1985-09-13 | Sidley Austin LLP | 1501 K Street, N.W. | 8th Floor | Washington | DC | 20005 |
12063 | 12063 | 2009-03-31 | 2008-11-05 | Strenio, Jr. | Andrew J. | Sidley Austin LLP 3731 | 1985-09-13 | Sidley Austin LLP | 1501 K Street, N.W. | 8th Floor | Washington | DC | 20005 |
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]) );