FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
30 rows where Address_1 = "1667 K Street, N.W."
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Registration_Date, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3278 | 3278 | 1992-01-06 | 1990-02-27 | Levy | Steven A. | Pillsbury, Madison & Sutro 4212 | 1989-01-27 | Pillsbury, Madison & Sutro | 1667 K Street, N.W. | Suite 1100 | Washington | DC | 20006 |
4629 | 4629 | 1992-01-27 | 1992-01-27 | Lowell | Frederick K. | Pillsbury, Madison & Sutro 4212 | 1989-01-27 | Pillsbury, Madison & Sutro | 1667 K Street, N.W. | Suite 1100 | Washington | DC | 20006 |
5048 | 5048 | 1990-01-31 | 1989-01-27 | Ott | Judith A. | Pillsbury, Madison & Sutro 4212 | 1989-01-27 | Pillsbury, Madison & Sutro | 1667 K Street, N.W. | Suite 1100 | Washington | DC | 20006 |
5767 | 5767 | 1991-02-01 | 1989-01-27 | Jang | Sudeok | Pillsbury, Madison & Sutro 4212 | 1989-01-27 | Pillsbury, Madison & Sutro | 1667 K Street, N.W. | Suite 1100 | Washington | DC | 20006 |
13864 | 13864 | 1993-04-21 | 1989-09-14 | Hart | Karen Elizabeth | Hart Marketing Resources 4286 | 1989-09-07 | Hart Marketing Resources | 1667 K Street, N.W. | Suite 700 | Washington | DC | 20006 |
13865 | 13865 | 1993-04-21 | 1989-09-14 | Matter | Mohsen W. | Hart Marketing Resources 4286 | 1989-09-07 | Hart Marketing Resources | 1667 K Street, N.W. | Suite 700 | Washington | DC | 20006 |
15434 | 15434 | 1991-05-01 | 1990-11-05 | Corvin | Tammy E. | Pillsbury, Madison & Sutro 4212 | 1989-01-27 | Pillsbury, Madison & Sutro | 1667 K Street, N.W. | Suite 1100 | Washington | DC | 20006 |
16758 | 16758 | 1991-05-20 | 1990-11-14 | Birrell | Jeffrey Clarke | Edward Aycoth & Company, Inc. 4436 | 1990-11-14 | Edward Aycoth & Company, Inc. | 1667 K Street, N.W. | Suite 340 | Washington | DC | 20006 |
16954 | 16954 | 1988-05-23 | 1987-11-23 | Harbert | Michael R. | Carmen, Carmen & Hugel, Inc. 4066 | 1987-11-23 | Carmen, Carmen & Hugel, Inc. | 1667 K Street, N.W. | Suite 70 | Washington | DC | 20006 |
17288 | 17288 | 1991-05-28 | 1991-02-04 | Larson | Ceri Hillary | Edward Aycoth & Company, Inc. 4436 | 1990-11-14 | Edward Aycoth & Company, Inc. | 1667 K Street, N.W. | Suite 340 | Washington | DC | 20006 |
20305 | 20305 | 1992-06-26 | 1989-01-27 | Mendelson | Keith J. | Pillsbury, Madison & Sutro 4212 | 1989-01-27 | Pillsbury, Madison & Sutro | 1667 K Street, N.W. | Suite 1100 | Washington | DC | 20006 |
20306 | 20306 | 1992-06-26 | 1989-01-27 | Morse | Ann | Pillsbury, Madison & Sutro 4212 | 1989-01-27 | Pillsbury, Madison & Sutro | 1667 K Street, N.W. | Suite 1100 | Washington | DC | 20006 |
20307 | 20307 | 1992-06-26 | 1990-02-27 | Morse | Ann R. | Pillsbury, Madison & Sutro 4212 | 1989-01-27 | Pillsbury, Madison & Sutro | 1667 K Street, N.W. | Suite 1100 | Washington | DC | 20006 |
20308 | 20308 | 1992-06-26 | 1990-02-27 | Pepin | Alfred L. | Pillsbury, Madison & Sutro 4212 | 1989-01-27 | Pillsbury, Madison & Sutro | 1667 K Street, N.W. | Suite 1100 | Washington | DC | 20006 |
20309 | 20309 | 1992-06-26 | 1990-02-27 | Trimble | Thomas B. | Pillsbury, Madison & Sutro 4212 | 1989-01-27 | Pillsbury, Madison & Sutro | 1667 K Street, N.W. | Suite 1100 | Washington | DC | 20006 |
20310 | 20310 | 1992-06-26 | 1990-02-27 | deKieffer | Donald E. | Pillsbury, Madison & Sutro 4212 | 1989-01-27 | Pillsbury, Madison & Sutro | 1667 K Street, N.W. | Suite 1100 | Washington | DC | 20006 |
20311 | 20311 | 1992-06-26 | 1990-11-05 | Horgan | James K. | Pillsbury, Madison & Sutro 4212 | 1989-01-27 | Pillsbury, Madison & Sutro | 1667 K Street, N.W. | Suite 1100 | Washington | DC | 20006 |
20312 | 20312 | 1992-06-26 | 1990-11-05 | Xenopoulos | Damon E. | Pillsbury, Madison & Sutro 4212 | 1989-01-27 | Pillsbury, Madison & Sutro | 1667 K Street, N.W. | Suite 1100 | Washington | DC | 20006 |
22206 | 22206 | 1991-07-01 | 1990-02-27 | Coghlan | Sangme | Pillsbury, Madison & Sutro 4212 | 1989-01-27 | Pillsbury, Madison & Sutro | 1667 K Street, N.W. | Suite 1100 | Washington | DC | 20006 |
24016 | 24016 | 1990-07-25 | 1989-10-19 | MacKay | Margaret | Pillsbury, Madison & Sutro 4212 | 1989-01-27 | Pillsbury, Madison & Sutro | 1667 K Street, N.W. | Suite 1100 | Washington | DC | 20006 |
27008 | 27008 | 1991-08-19 | 1991-01-04 | Yui | Ellen Moulton | Edward Aycoth & Company, Inc. 4436 | 1990-11-14 | Edward Aycoth & Company, Inc. | 1667 K Street, N.W. | Suite 340 | Washington | DC | 20006 |
27701 | 27701 | 1985-08-29 | 1982-11-30 | Christensen | Larry E. | Buchanan & Ingersoll, Professional Corporation 3423 | 1982-11-30 | Buchanan & Ingersoll, Professional Corporation | 1667 K Street, N.W. | Suite 900 | Washington | DC | 20006 |
27702 | 27702 | 1985-08-29 | 1982-11-30 | Maguire | Edward | Buchanan & Ingersoll, Professional Corporation 3423 | 1982-11-30 | Buchanan & Ingersoll, Professional Corporation | 1667 K Street, N.W. | Suite 900 | Washington | DC | 20006 |
30196 | 30196 | 1989-09-21 | 1989-01-27 | Frank | Susan M. | Pillsbury, Madison & Sutro 4212 | 1989-01-27 | Pillsbury, Madison & Sutro | 1667 K Street, N.W. | Suite 1100 | Washington | DC | 20006 |
33017 | 33017 | 1989-10-16 | 1989-01-27 | Cobble | Beverly K. | Pillsbury, Madison & Sutro 4212 | 1989-01-27 | Pillsbury, Madison & Sutro | 1667 K Street, N.W. | Suite 1100 | Washington | DC | 20006 |
36211 | 36211 | 1988-11-22 | 1987-11-23 | Carmen | David M. | Carmen, Carmen & Hugel, Inc. 4066 | 1987-11-23 | Carmen, Carmen & Hugel, Inc. | 1667 K Street, N.W. | Suite 70 | Washington | DC | 20006 |
40669 | 40669 | 1991-12-31 | 1991-02-04 | III | John Hudson | Edward Aycoth & Company, Inc. 4436 | 1990-11-14 | Edward Aycoth & Company, Inc. | 1667 K Street, N.W. | Suite 340 | Washington | DC | 20006 |
40723 | 40723 | 1991-12-31 | 1990-11-14 | Aycoth | John Edward | Edward Aycoth & Company, Inc. 4436 | 1990-11-14 | Edward Aycoth & Company, Inc. | 1667 K Street, N.W. | Suite 340 | Washington | DC | 20006 |
40724 | 40724 | 1991-12-31 | 1990-11-14 | Fiske | David Holland | Edward Aycoth & Company, Inc. 4436 | 1990-11-14 | Edward Aycoth & Company, Inc. | 1667 K Street, N.W. | Suite 340 | Washington | DC | 20006 |
40725 | 40725 | 1991-12-31 | 1990-11-14 | Walker | Reid Allen | Edward Aycoth & Company, Inc. 4436 | 1990-11-14 | Edward Aycoth & Company, Inc. | 1667 K Street, N.W. | Suite 340 | 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]) );