home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for FARA_All_ShortForms
List of all short form registrants (active and terminated)

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

34 rows where Registration_Number = 3274

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Termination_Date (date), Registration_Date (date)

State 1

  • DC 34

Registration_Number 1

  • Powell, Goldstein, Frazer & Murphy, L.L.P. · 34 ✖

Registrant_Name 1

  • Powell, Goldstein, Frazer & Murphy, L.L.P. 34

City 1

  • Washington 34
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
2787 2787 2000-01-01 1989-06-28 Suchman Peter O. Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
3369 3369 1999-01-07 1997-10-01 Fine Michael E. Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
3795 3795 1989-01-15 1986-04-11 Seely Carolyn T. Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
9568 9568 1993-03-10 1992-08-05 Chanin Michael H. Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
9575 9575 1996-03-10 1985-05-13 Lazarus Simon , III Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
9577 9577 1996-03-10 1987-10-13 Strommer Sysan P. Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
10526 10526 2000-03-22 1997-10-01 Eule Margo Grimm Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
11874 11874 2001-03-31 1997-10-01 Daniels Michael P. Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
12483 12483 1990-04-01 1987-04-10 Simons Lawrence E. Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
12484 12484 1990-04-01 1985-05-13 Eizenstat Stuart E. Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
12508 12508 1999-04-01 1998-10-14 Sullivan David J. Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
12987 12987 1982-04-09 1981-09-10 Eizenstat Stuart E. Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
13097 13097 1995-04-10 1985-10-24 Fullerton Lawrence Rae Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
13851 13851 1984-04-21 1981-09-01 Appelbaum Judith C. Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
14545 14545 1984-04-30 1981-09-10 Reichler Paul S. Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
15646 15646 2002-05-03 1999-01-06 Haney Mark Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
15647 15647 2002-05-03 1994-04-05 Jacobs Brenda A. Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
15648 15648 2002-05-03 2001-04-11 Lloreda Nicholas Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
15649 15649 2002-05-03 1999-04-12 Torresen Robert Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
15651 15651 2002-05-03 2000-09-22 Williams Alexander S. Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
15652 15652 2002-05-03 1997-10-01 Clark Alice Slayton Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
15653 15653 2002-05-03 1997-10-01 DiGiulian Maria Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
15654 15654 2002-05-03 2001-10-10 Hanna Christine Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
15655 15655 2002-05-03 2001-10-10 May Jordan Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
15656 15656 2002-05-03 2001-10-11 Howard Elizabeth Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
17196 17196 2000-05-26 1999-09-14 Sullivan James Casey Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
19250 19250 2001-06-11 2000-09-22 Lukas Emily Elizabeth Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
19581 19581 1999-06-15 1999-04-12 Rotondi Phillip Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
19985 19985 2001-06-21 1999-04-12 Effgen Gretchen Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
20447 20447 1996-06-28 1992-08-05 Vick M. Christine Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
23045 23045 1989-07-13 1987-10-13 Dreschel Susan Wells Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
29526 29526 1990-09-10 1987-04-10 Fine Michael Ezra Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
38164 38164 1986-12-12 1985-05-13 Gagne Clement R. , III Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004
40912 40912 1995-12-31 1993-09-22 Fowler Wyche , Jr. Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 1001 Pennsylvania Avenue, N.W. 6th Floor, South Washington DC 20004

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])
);
Powered by Datasette · Queries took 515.513ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows