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

19 rows where Registration_Number = 5345

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_Last_Name, Short_Form_First_Name, Short_Form_Date (date)

State 1

  • DC 19

Registration_Number 1

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

Registrant_Name 1

  • Dyer Ellis & Joseph, P.C. 19

City 1

  • Washington 19
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
2802 2802 2001-01-01 1999-12-01 Smith III Duncan C. Dyer Ellis & Joseph, P.C. 5345 1999-12-01 Dyer Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. 11th Floor Washington DC 20037
5272 5272 2003-01-31 2002-02-27 Graykowski John E. Dyer Ellis & Joseph, P.C. 5345 1999-12-01 Dyer Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. 11th Floor Washington DC 20037
21454 21454 2003-06-30 2000-01-27 Click Joseph O. Dyer Ellis & Joseph, P.C. 5345 1999-12-01 Dyer Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. 11th Floor Washington DC 20037
21455 21455 2003-06-30 2003-01-29 Dyer Andrew W. Jr., Dyer Ellis & Joseph, P.C. 5345 1999-12-01 Dyer Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. 11th Floor Washington DC 20037
21456 21456 2003-06-30 2003-01-29 Freeman Alan M. Dyer Ellis & Joseph, P.C. 5345 1999-12-01 Dyer Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. 11th Floor Washington DC 20037
21457 21457 2003-06-30 2003-01-29 Joseph Michael Dyer Ellis & Joseph, P.C. 5345 1999-12-01 Dyer Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. 11th Floor Washington DC 20037
21459 21459 2003-06-30 2002-02-27 Blanton E. Alex Dyer Ellis & Joseph, P.C. 5345 1999-12-01 Dyer Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. 11th Floor Washington DC 20037
21460 21460 2003-06-30 2002-02-27 Mitchell Sarah Heckel Dyer Ellis & Joseph, P.C. 5345 1999-12-01 Dyer Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. 11th Floor Washington DC 20037
21470 21470 2003-06-30 2000-07-28 Cheplo Thomas Z. Dyer Ellis & Joseph, P.C. 5345 1999-12-01 Dyer Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. 11th Floor Washington DC 20037
21471 21471 2003-06-30 2002-07-30 Shehadeh Kirim K. Dyer Ellis & Joseph, P.C. 5345 1999-12-01 Dyer Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. 11th Floor Washington DC 20037
21472 21472 2003-06-30 2002-07-30 Smith III Duncan C. Dyer Ellis & Joseph, P.C. 5345 1999-12-01 Dyer Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. 11th Floor Washington DC 20037
21479 21479 2003-06-30 1999-12-01 Drewry James S.W. Dyer Ellis & Joseph, P.C. 5345 1999-12-01 Dyer Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. 11th Floor Washington DC 20037
21480 21480 2003-06-30 1999-12-01 Esber Brett M. Dyer Ellis & Joseph, P.C. 5345 1999-12-01 Dyer Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. 11th Floor Washington DC 20037
21481 21481 2003-06-30 1999-12-01 Naftzger J. Christopher Dyer Ellis & Joseph, P.C. 5345 1999-12-01 Dyer Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. 11th Floor Washington DC 20037
21482 21482 2003-06-30 1999-12-01 Southwick Jennifer M. Dyer Ellis & Joseph, P.C. 5345 1999-12-01 Dyer Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. 11th Floor Washington DC 20037
21483 21483 2003-06-30 1999-12-01 Waldron Jonathan K. Dyer Ellis & Joseph, P.C. 5345 1999-12-01 Dyer Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. 11th Floor Washington DC 20037
31300 31300 2002-09-30 2002-07-30 Vernaza Luis J. Dyer Ellis & Joseph, P.C. 5345 1999-12-01 Dyer Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. 11th Floor Washington DC 20037
41258 41258 2002-12-31 2003-01-29 Barrett Jane F. Dyer Ellis & Joseph, P.C. 5345 1999-12-01 Dyer Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. 11th Floor Washington DC 20037
41290 41290 2002-12-31 1999-12-01 Dyer Thomas M. Dyer Ellis & Joseph, P.C. 5345 1999-12-01 Dyer Ellis & Joseph, P.C. 600 New Hampshire Avenue, N.W. 11th Floor 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 695.882ms · 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