FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

41 rows where Registration_Number = 3028

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Date (date)

State 1

Registration_Number 1

  • Dickstein Shapiro, LLP · 41 ✖

Registrant_Name 1

City 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
2694 2694 1990-01-01 1989-05-24 Davidow Joel Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
2876 2876 2010-01-01 1982-06-02 Cashen Henry C. , II Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
6639 6639 2016-02-11 2013-07-30 Manchester Doreen Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
6948 6948 1991-02-15 1989-02-17 Yanagida Joy Adele Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
8885 8885 2011-03-01 2009-04-01 Hutchinson Tim Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
10535 10535 2013-03-22 1989-02-24 Kadzik Peter J. Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
12686 12686 1992-04-03 1988-05-03 Stern Samuel A. Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
13287 13287 1989-04-13 1987-06-30 Jones James R. Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
14149 14149 2002-04-26 1993-07-28 Jacobson Douglas N. Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
17312 17312 2015-05-28 2009-04-01 Hastert J. Dennis Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
17711 17711 1988-05-31 1986-05-22 Horowitz Michael J. Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
17762 17762 1992-05-31 1991-11-26 Lowther Frederick M. Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
17763 17763 1992-05-31 1991-11-26 Shapiro David I. Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
19014 19014 1983-06-07 1981-07-22 Walvick Walter J. Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
21132 21132 1990-06-30 1987-01-09 Dill John C. Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
21442 21442 2002-06-30 1994-08-05 LaFave Arthur J. , III Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
22449 22449 1990-07-02 1987-01-09 Conway Richard J. Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
22450 22450 1990-07-02 1989-02-17 Whitfield Milton Bailey Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
22451 22451 1990-07-02 1986-06-20 Garment Leonard Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
22986 22986 2014-07-11 2009-04-01 Mangas Robert J. Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
22987 22987 2014-07-11 2009-04-01 Shulman Allison Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
22988 22988 2014-07-11 2009-04-06 Zausner L. Andrew Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
22989 22989 2014-07-11 2014-04-15 Hutchinson Tim Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
22991 22991 2014-07-11 2009-07-31 Wynn Albert R. Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
22992 22992 2014-07-11 2010-08-02 McKay K. Laurie Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
24308 24308 1993-07-28 1980-04-07 Minetti G. Joseph Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
25264 25264 2015-07-31 2015-04-23 Goss Porter Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
25275 25275 2015-07-31 2014-10-03 Carrier Jennifer Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
25276 25276 2015-07-31 2014-10-03 Thompson David Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
26084 26084 1980-08-06 1979-06-07 Miller Andrew P. Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
26085 26085 1980-08-06 1979-06-07 Ratiner Leigh S. Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
26086 26086 1980-08-06 1979-06-07 Shapiro David I. Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
26087 26087 1980-08-06 1979-06-07 Wright Rebecca L. Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
26694 26694 1980-08-15 1979-06-29 Hicks Margaret Lynn Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
32732 32732 1989-10-13 1988-04-28 Libby I. Lewis Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
33194 33194 1989-10-19 1989-02-17 Henry Ronald K. Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
34998 34998 2008-11-01 1989-05-15 Miller Charles L. , Jr. Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
37340 37340 1980-12-01 1980-04-07 Littell Richard Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
38946 38946 1994-12-22 1994-08-05 Gill Kennie Lee Miller Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
38947 38947 1994-12-22 1994-08-05 Zausner L. Andrew Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403
41856 41856 2013-12-31 2010-02-02 Clifton Curt Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP 1825 Eye Street, N.W.   Washington DC 20006-5403

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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])
);