FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
27 rows where "Short_Form_Termination_Date" is on date 1998-12-31 and State = "DC"
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41066 | 41066 | 1998-12-31 | 1996-01-03 | Bechky | Perry S. | Shearman & Sterling 4208 | 1989-01-23 | Shearman & Sterling | 801 Pennsylvania Avenue, N.W. | Suite 900 | Washington | DC | 20004-2604 |
41067 | 41067 | 1998-12-31 | 1996-01-03 | Martin | Thomas S. | Shearman & Sterling 4208 | 1989-01-23 | Shearman & Sterling | 801 Pennsylvania Avenue, N.W. | Suite 900 | Washington | DC | 20004-2604 |
41069 | 41069 | 1998-12-31 | 1990-01-18 | Raffaelli | John D. | Washington Group 4332 | 1990-01-18 | Washington Group | 1401 K Street, N.W. | Suite 400 | Washington | DC | 20005 |
41070 | 41070 | 1998-12-31 | 1992-01-22 | Ackerman | Wendy E. | Shearman & Sterling 4208 | 1989-01-23 | Shearman & Sterling | 801 Pennsylvania Avenue, N.W. | Suite 900 | Washington | DC | 20004-2604 |
41071 | 41071 | 1998-12-31 | 1994-01-25 | O'Hanlon | G. John | Washington Group 4332 | 1990-01-18 | Washington Group | 1401 K Street, N.W. | Suite 400 | Washington | DC | 20005 |
41072 | 41072 | 1998-12-31 | 1994-01-25 | Saunders | Tonya | Washington Group 4332 | 1990-01-18 | Washington Group | 1401 K Street, N.W. | Suite 400 | Washington | DC | 20005 |
41073 | 41073 | 1998-12-31 | 1994-01-25 | Springer | David E. | Washington Group 4332 | 1990-01-18 | Washington Group | 1401 K Street, N.W. | Suite 400 | Washington | DC | 20005 |
41074 | 41074 | 1998-12-31 | 1996-01-29 | Chapman | Michael J. | Shearman & Sterling 4208 | 1989-01-23 | Shearman & Sterling | 801 Pennsylvania Avenue, N.W. | Suite 900 | Washington | DC | 20004-2604 |
41075 | 41075 | 1998-12-31 | 1998-01-30 | Barrett | Laurence I. | Powell Tate, Inc. 5148 | 1996-12-30 | Powell Tate, Inc. | 700 - 13th Street, N.W. | Suite 1000 | Washington | DC | 20005 |
41076 | 41076 | 1998-12-31 | 1998-02-04 | Valat | Thierry | Afridi, Angell & Pelletreau LLP 5231 | 1998-02-04 | Afridi, Angell & Pelletreau LLP | 1025 Connecticut Avenue, N.W. | Suite 904 | Washington | DC | 20036 |
41081 | 41081 | 1998-12-31 | 1994-04-08 | Reed | Morgan William , III | Washington Group 4332 | 1990-01-18 | Washington Group | 1401 K Street, N.W. | Suite 400 | Washington | DC | 20005 |
41082 | 41082 | 1998-12-31 | 1990-04-09 | Winton | Jeffrey M. | Shearman & Sterling 4208 | 1989-01-23 | Shearman & Sterling | 801 Pennsylvania Avenue, N.W. | Suite 900 | Washington | DC | 20004-2604 |
41083 | 41083 | 1998-12-31 | 1998-04-10 | Fong | Albert Kwok-Keung | Shandwick Public Affairs, Inc. 5220 | 1997-12-17 | Shandwick Public Affairs, Inc. | 700 13th Street, N.W. | Suite 1000 | Washington | DC | 20005 |
41084 | 41084 | 1998-12-31 | 1998-04-10 | Sinderson | Brian Norman | Shandwick Public Affairs, Inc. 5220 | 1997-12-17 | Shandwick Public Affairs, Inc. | 700 13th Street, N.W. | Suite 1000 | Washington | DC | 20005 |
41085 | 41085 | 1998-12-31 | 1998-04-10 | Townsel | Melody Annette | Shandwick Public Affairs, Inc. 5220 | 1997-12-17 | Shandwick Public Affairs, Inc. | 700 13th Street, N.W. | Suite 1000 | Washington | DC | 20005 |
41086 | 41086 | 1998-12-31 | 1997-04-11 | Blair | Robert A. | Manatt, Phelps & Phillips 5171 | 1997-04-11 | Manatt, Phelps & Phillips | 700 12th Street, N.W. | Suite 1100 | Washington | DC | 20005 |
41087 | 41087 | 1998-12-31 | 1998-04-16 | Brecht | Adam Erich Burton | Shandwick Public Affairs, Inc. 5220 | 1997-12-17 | Shandwick Public Affairs, Inc. | 700 13th Street, N.W. | Suite 1000 | Washington | DC | 20005 |
41090 | 41090 | 1998-12-31 | 1989-05-12 | Herzstein | Robert E. | Shearman & Sterling 4208 | 1989-01-23 | Shearman & Sterling | 801 Pennsylvania Avenue, N.W. | Suite 900 | Washington | DC | 20004-2604 |
41091 | 41091 | 1998-12-31 | 1995-05-25 | Wilner | Thomas B. | Shearman & Sterling 4208 | 1989-01-23 | Shearman & Sterling | 801 Pennsylvania Avenue, N.W. | Suite 900 | Washington | DC | 20004-2604 |
41101 | 41101 | 1998-12-31 | 1994-08-10 | Allen | Kevin D. | Washington Group 4332 | 1990-01-18 | Washington Group | 1401 K Street, N.W. | Suite 400 | Washington | DC | 20005 |
41102 | 41102 | 1998-12-31 | 1997-08-13 | Greenberg | Marco | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
41108 | 41108 | 1998-12-31 | 1997-10-07 | Itzkowitz | Adam | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
41109 | 41109 | 1998-12-31 | 1998-10-09 | Blount | John | Washington Group 4332 | 1990-01-18 | Washington Group | 1401 K Street, N.W. | Suite 400 | Washington | DC | 20005 |
41110 | 41110 | 1998-12-31 | 1998-10-09 | Lewis | Rita M. | Washington Group 4332 | 1990-01-18 | Washington Group | 1401 K Street, N.W. | Suite 400 | Washington | DC | 20005 |
41112 | 41112 | 1998-12-31 | 1996-10-24 | Powell | Cynthia A. | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41115 | 41115 | 1998-12-31 | 1996-12-19 | MacKinnon | Doug | Barbour Griffith & Rogers 5146 | 1996-12-19 | Barbour Griffith & Rogers | 1275 Pennsylvania Avenue, NW | 10th Floor | Washington | DC | 20004 |
41117 | 41117 | 1998-12-31 | 1996-12-30 | Cramer | Jerome | Powell Tate, Inc. 5148 | 1996-12-30 | Powell Tate, Inc. | 700 - 13th Street, N.W. | Suite 1000 | 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]) );