FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where Registrant_Name = "Pillsbury, Madison & Sutro", "Registration_Date" is on date 1989-01-27, Registration_Number = 4212 and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_Termination_Date (date)
State 1
- DC · 17 ✖
Registration_Number 1
- Pillsbury, Madison & Sutro · 17 ✖
Registrant_Name 1
- Pillsbury, Madison & Sutro · 17 ✖
City 1
- Washington 17
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 |
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 |
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 |
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 |
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]) );