FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where City = "Washington", "Short_Form_Date" is on date 1984-04-17 and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Address_1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3784 | 3784 | 1985-01-15 | 1984-04-17 | Gattuso | James L. | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | 1201 Pennsylvania Avenue, N.W. | Post Office Box 407 | Washington | DC | 20044-0407 |
7290 | 7290 | 1987-02-20 | 1984-04-17 | Foley | Martha Christine | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | 1201 Pennsylvania Avenue, N.W. | Post Office Box 407 | Washington | DC | 20044-0407 |
13976 | 13976 | 1987-04-23 | 1984-04-17 | Boyd | Jan | Henry J. Kaufman & Associates, Inc. 3573 | 1984-04-17 | Henry J. Kaufman & Associates, Inc. | 2233 Wisconsin Avenue, N.W. | Washington | DC | 20007 | |
13977 | 13977 | 1987-04-23 | 1984-04-17 | Duncan | Mary | Henry J. Kaufman & Associates, Inc. 3573 | 1984-04-17 | Henry J. Kaufman & Associates, Inc. | 2233 Wisconsin Avenue, N.W. | Washington | DC | 20007 | |
13978 | 13978 | 1987-04-23 | 1984-04-17 | Genn | Pamela | Henry J. Kaufman & Associates, Inc. 3573 | 1984-04-17 | Henry J. Kaufman & Associates, Inc. | 2233 Wisconsin Avenue, N.W. | Washington | DC | 20007 | |
13979 | 13979 | 1987-04-23 | 1984-04-17 | Karu | Stuart E. | Henry J. Kaufman & Associates, Inc. 3573 | 1984-04-17 | Henry J. Kaufman & Associates, Inc. | 2233 Wisconsin Avenue, N.W. | Washington | DC | 20007 | |
13980 | 13980 | 1987-04-23 | 1984-04-17 | Sabatino | Philip N. | Henry J. Kaufman & Associates, Inc. 3573 | 1984-04-17 | Henry J. Kaufman & Associates, Inc. | 2233 Wisconsin Avenue, N.W. | Washington | DC | 20007 | |
13981 | 13981 | 1987-04-23 | 1984-04-17 | Sellers | Fred | Henry J. Kaufman & Associates, Inc. 3573 | 1984-04-17 | Henry J. Kaufman & Associates, Inc. | 2233 Wisconsin Avenue, N.W. | Washington | DC | 20007 | |
13982 | 13982 | 1987-04-23 | 1984-04-17 | Vilsack | Roger | Henry J. Kaufman & Associates, Inc. 3573 | 1984-04-17 | Henry J. Kaufman & Associates, Inc. | 2233 Wisconsin Avenue, N.W. | Washington | DC | 20007 | |
14034 | 14034 | 1987-04-24 | 1984-04-17 | Kitchen | R. David | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | 1201 Pennsylvania Avenue, N.W. | Post Office Box 407 | Washington | DC | 20044-0407 |
23898 | 23898 | 1992-07-23 | 1984-04-17 | Murphy | James P. | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | 1201 Pennsylvania Avenue, N.W. | Post Office Box 407 | Washington | DC | 20044-0407 |
24192 | 24192 | 1993-07-27 | 1984-04-17 | Sykes | Alan O. | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
30673 | 30673 | 1984-09-28 | 1984-04-17 | Haslem | James Robert | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | 1201 Pennsylvania Avenue, N.W. | Post Office Box 407 | Washington | DC | 20044-0407 |
35096 | 35096 | 1984-11-02 | 1984-04-17 | Corcoran | Janet Claire | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | 1201 Pennsylvania Avenue, N.W. | Post Office Box 407 | Washington | DC | 20044-0407 |
35748 | 35748 | 1985-11-14 | 1984-04-17 | Coward | Nicholas F. | Baker & McKenzie 3574 | 1984-04-17 | Baker & McKenzie | 815 Connecticut Avenue, N.W. | Washington | DC | 20006 | |
35749 | 35749 | 1985-11-14 | 1984-04-17 | MacDonald | David R. | Baker & McKenzie 3574 | 1984-04-17 | Baker & McKenzie | 815 Connecticut Avenue, N.W. | 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]) );