FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
21 rows where Registration_Number = 3753 and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Last_Name, Short_Form_First_Name, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Short_Form_Termination_Date 11 ✖
- 1992-06-01 7
- 1987-11-01 3
- 1992-11-24 2
- 1996-03-26 2
- 1986-05-30 1
- 1988-05-31 1
- 1991-11-26 1
- 1992-03-31 1
- 1992-10-09 1
- 1993-03-02 1
- 1993-05-11 1
State 1
- DC · 21 ✖
Registration_Number 1
- Perkins Coie · 21 ✖
Registrant_Name 1
- Perkins Coie 21
City 1
- Washington 21
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8968 | 8968 | 1993-03-02 | 1990-05-14 | Hughes | Mary Rose | Perkins Coie 3753 | 1985-11-01 | Perkins Coie | 607 - 14th Street, N.W. | Suite 800 | Washington | DC | 20005 |
10813 | 10813 | 1996-03-26 | 1994-09-27 | Santos | Leonard E. | Perkins Coie 3753 | 1985-11-01 | Perkins Coie | 607 - 14th Street, N.W. | Suite 800 | Washington | DC | 20005 |
10815 | 10815 | 1996-03-26 | 1993-12-01 | Hume | John P. | Perkins Coie 3753 | 1985-11-01 | Perkins Coie | 607 - 14th Street, N.W. | Suite 800 | Washington | DC | 20005 |
11669 | 11669 | 1992-03-31 | 1990-06-04 | Thompson | Anthony J. | Perkins Coie 3753 | 1985-11-01 | Perkins Coie | 607 - 14th Street, N.W. | Suite 800 | Washington | DC | 20005 |
16061 | 16061 | 1993-05-11 | 1991-08-21 | Tsompanas | Paul L. | Perkins Coie 3753 | 1985-11-01 | Perkins Coie | 607 - 14th Street, N.W. | Suite 800 | Washington | DC | 20005 |
17444 | 17444 | 1986-05-30 | 1985-11-01 | Hughes | Mary Rose | Perkins Coie 3753 | 1985-11-01 | Perkins Coie | 607 - 14th Street, N.W. | Suite 800 | Washington | DC | 20005 |
17714 | 17714 | 1988-05-31 | 1985-11-01 | Boman | Marc A. | Perkins Coie 3753 | 1985-11-01 | Perkins Coie | 607 - 14th Street, N.W. | Suite 800 | Washington | DC | 20005 |
18489 | 18489 | 1992-06-01 | 1991-04-02 | McGee | Dana E. | Perkins Coie 3753 | 1985-11-01 | Perkins Coie | 607 - 14th Street, N.W. | Suite 800 | Washington | DC | 20005 |
18491 | 18491 | 1992-06-01 | 1990-05-14 | Schadler | Barbara Holly | Perkins Coie 3753 | 1985-11-01 | Perkins Coie | 607 - 14th Street, N.W. | Suite 800 | Washington | DC | 20005 |
18492 | 18492 | 1992-06-01 | 1991-07-11 | Hayward | J.T. | Perkins Coie 3753 | 1985-11-01 | Perkins Coie | 607 - 14th Street, N.W. | Suite 800 | Washington | DC | 20005 |
18493 | 18493 | 1992-06-01 | 1991-07-11 | Wahlquist | Andrew F. | Perkins Coie 3753 | 1985-11-01 | Perkins Coie | 607 - 14th Street, N.W. | Suite 800 | Washington | DC | 20005 |
18494 | 18494 | 1992-06-01 | 1990-12-26 | O'Sullivan | Lynda T. | Perkins Coie 3753 | 1985-11-01 | Perkins Coie | 607 - 14th Street, N.W. | Suite 800 | Washington | DC | 20005 |
18495 | 18495 | 1992-06-01 | 1990-12-26 | Thompson | William | Perkins Coie 3753 | 1985-11-01 | Perkins Coie | 607 - 14th Street, N.W. | Suite 800 | Washington | DC | 20005 |
18496 | 18496 | 1992-06-01 | 1990-12-26 | Wilhide | C.R. | Perkins Coie 3753 | 1985-11-01 | Perkins Coie | 607 - 14th Street, N.W. | Suite 800 | Washington | DC | 20005 |
32516 | 32516 | 1992-10-09 | 1990-05-14 | Santos | Leonard E. | Perkins Coie 3753 | 1985-11-01 | Perkins Coie | 607 - 14th Street, N.W. | Suite 800 | Washington | DC | 20005 |
34907 | 34907 | 1987-11-01 | 1985-11-01 | Bauer | Robert F. | Perkins Coie 3753 | 1985-11-01 | Perkins Coie | 607 - 14th Street, N.W. | Suite 800 | Washington | DC | 20005 |
34908 | 34908 | 1987-11-01 | 1985-11-01 | Corley | Judith L. | Perkins Coie 3753 | 1985-11-01 | Perkins Coie | 607 - 14th Street, N.W. | Suite 800 | Washington | DC | 20005 |
34909 | 34909 | 1987-11-01 | 1985-11-01 | Steingold | Stuart G. | Perkins Coie 3753 | 1985-11-01 | Perkins Coie | 607 - 14th Street, N.W. | Suite 800 | Washington | DC | 20005 |
36311 | 36311 | 1992-11-24 | 1990-05-14 | Martin | Guy R. | Perkins Coie 3753 | 1985-11-01 | Perkins Coie | 607 - 14th Street, N.W. | Suite 800 | Washington | DC | 20005 |
36312 | 36312 | 1992-11-24 | 1988-05-31 | Bond | Gene Perry | Perkins Coie 3753 | 1985-11-01 | Perkins Coie | 607 - 14th Street, N.W. | Suite 800 | Washington | DC | 20005 |
36447 | 36447 | 1991-11-26 | 1991-07-11 | Vander Myde | Paul A. | Perkins Coie 3753 | 1985-11-01 | Perkins Coie | 607 - 14th Street, N.W. | Suite 800 | 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]) );