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

48 rows where Registration_Number = 4121

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • DC 48

Registration_Number 1

  • Dyer, Ellis & Joseph, P.C. · 48 ✖

Registrant_Name 1

  • Dyer, Ellis & Joseph, P.C. 48

City 1

  • Washington 48
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
3413 3413 1996-01-08 1991-02-06 Smith Duncan C. , III Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3414 3414 1996-01-08 1996-02-08 Waldron Jonathan Kent Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3415 3415 1996-01-08 1995-03-13 Delgado Elizabeth Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3416 3416 1996-01-08 1995-03-13 Finch Keith Russell Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3417 3417 1996-01-08 1988-03-21 Blanton E. Alex Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3418 3418 1996-01-08 1988-03-21 Dyer Thomas M. Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3419 3419 1996-01-08 1988-03-21 Ellis James B. , II Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3420 3420 1996-01-08 1988-03-21 Joseph Michael Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3421 3421 1996-01-08 1994-04-19 Anzaldua Terri Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3422 3422 1996-01-08 1993-05-07 Brady James B. Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3423 3423 1996-01-08 1993-05-07 Schwartz Matthew Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3424 3424 1996-01-08 1992-05-12 Crick Laurie L. Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3425 3425 1996-01-08 1989-05-26 Salgado R. Anthony Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3426 3426 1996-01-08 1995-06-19 Snyder Patricia N. Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3427 3427 1996-01-08 1994-06-24 Fletcher Joseph Kennard , III Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3428 3428 1996-01-08 1994-06-24 Lyras Alexandra Georgia Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3430 3430 1996-01-08 1995-07-24 Snyder Todd David Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3431 3431 1996-01-08 1992-07-30 Bannon Brian A. Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3432 3432 1996-01-08 1992-07-30 Bowen Julia A. Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3433 3433 1996-01-08 1992-07-30 Click Joseph O. Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3434 3434 1996-01-08 1992-07-30 Esber Brett M. Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3435 3435 1996-01-08 1992-07-30 Keup Wayne A. Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3436 3436 1996-01-08 1992-07-30 Kirby Richard A. Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3437 3437 1996-01-08 1992-07-30 Rosenthal Linda K. Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3438 3438 1996-01-08 1992-07-30 Streett Emily W. Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3439 3439 1996-01-08 1988-09-02 Dean Warren L. , Jr. Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3440 3440 1996-01-08 1995-09-28 Bernstein Lara M. Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3441 3441 1996-01-08 1995-09-28 Campo Laurent M. Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3442 3442 1996-01-08 1995-09-28 Naftzger Chris J. Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3443 3443 1996-01-08 1991-10-07 Wallace Sidney A. Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3444 3444 1996-01-08 1993-10-07 Kearney John Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3445 3445 1996-01-08 1993-10-07 Lemley Jane Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3446 3446 1996-01-08 1993-10-07 Wyler Marcus Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3447 3447 1996-01-08 1994-10-18 Grasso Jeanne Marie Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3448 3448 1996-01-08 1994-10-18 Shaw Jennifer Gay Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3449 3449 1996-01-08 1989-10-25 Robbins Debra M. Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
3450 3450 1996-01-08 1993-10-28 Dillenburg Margaret Anne Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
5083 5083 1991-01-31 1988-09-02 Vine Howard A. Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
11624 11624 1990-03-31 1989-05-26 Grandy Mary Chambers Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
13703 13703 1995-04-18 1992-07-30 Kauffman Thomas R. Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
13802 13802 1994-04-20 1992-07-30 McDonough Sean C.E. Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
20532 20532 1990-06-29 1989-05-26 Wilson Tyler J. Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
24794 24794 1990-07-31 1990-04-05 Barton Frederick D. Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
27436 27436 1995-08-25 1988-03-21 Lent Norman F. , III Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
33308 33308 1993-10-21 1992-07-30 Siegel Robin J. Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
35436 35436 1995-11-08 1988-03-21 Mills Thomas L. Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
35437 35437 1995-11-08 1988-03-21 Papavizas Constantine G. Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
36485 36485 1995-11-27 1989-05-26 Tenoever Kathleen M. Dyer, Ellis & Joseph, P.C. 4121 1988-03-21 Dyer, Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037

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 466.634ms · 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