FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where "Short_Form_Date" is on date 2005-06-30
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Registration_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6592 | 6592 | 2006-02-10 | 2005-06-30 | Martin | Matthew G.T. | Covington & Burling, LLP 5621 | 2004-05-07 | Covington & Burling, LLP | 1201 Pennsylvania Avenue, N.W. | Washington | DC | 20004 | |
11984 | 11984 | 2006-03-31 | 2005-06-30 | Paabus | Ann | Orion Strategies LLC 5437 | 2001-05-30 | Orion Strategies LLC | 6331 Western Avenue, NW | Washington | DC | 20015 | |
14383 | 14383 | 2011-04-29 | 2005-06-30 | Grace | Neil D. | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
15006 | 15006 | 2009-04-30 | 2005-06-30 | Clisby | Heather | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
15033 | 15033 | 2011-04-30 | 2005-06-30 | Shelden | Sarah | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
18679 | 18679 | 2006-06-02 | 2005-06-30 | Kizer | Karin L. | Covington & Burling, LLP 5621 | 2004-05-07 | Covington & Burling, LLP | 1201 Pennsylvania Avenue, N.W. | Washington | DC | 20004 | |
20465 | 20465 | 2005-06-28 | 2005-06-30 | Blankfeld | Keren | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
25087 | 25087 | 2006-07-31 | 2005-06-30 | Herrera | Veronica | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
31364 | 31364 | 2006-09-30 | 2005-06-30 | Lasher | Mary | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
36932 | 36932 | 2005-11-30 | 2005-06-30 | Handza | Sarah | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
36948 | 36948 | 2006-11-30 | 2005-06-30 | Blevins | John | Covington & Burling, LLP 5621 | 2004-05-07 | Covington & Burling, LLP | 1201 Pennsylvania Avenue, N.W. | Washington | DC | 20004 | |
36949 | 36949 | 2006-11-30 | 2005-06-30 | Omand | H. LiIIian | Covington & Burling, LLP 5621 | 2004-05-07 | Covington & Burling, LLP | 1201 Pennsylvania Avenue, N.W. | Washington | DC | 20004 | |
36950 | 36950 | 2006-11-30 | 2005-06-30 | Stetson | David M. | Covington & Burling, LLP 5621 | 2004-05-07 | Covington & Burling, LLP | 1201 Pennsylvania Avenue, N.W. | Washington | DC | 20004 |
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]) );