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

13 rows where Registration_Number = 3428

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • DC 13

Registration_Number 1

  • Rogers & Wells, LLP · 13 ✖

Registrant_Name 1

  • Rogers & Wells, LLP 13

City 1

  • Washington 13
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
6811 6811 1986-02-14 1984-08-07 Schweitzer Melvin L. Rogers & Wells, LLP 3428 1982-12-10 Rogers & Wells, LLP 607 - 14th Street N.W. Suite 900 Washington DC 20005-2011
19199 19199 1998-06-10 1998-01-13 O'Shea Michael A. Rogers & Wells, LLP 3428 1982-12-10 Rogers & Wells, LLP 607 - 14th Street N.W. Suite 900 Washington DC 20005-2011
19200 19200 1998-06-10 1998-01-13 Essaye Anthony F. Rogers & Wells, LLP 3428 1982-12-10 Rogers & Wells, LLP 607 - 14th Street N.W. Suite 900 Washington DC 20005-2011
19201 19201 1998-06-10 1993-02-17 Morris William Rogers & Wells, LLP 3428 1982-12-10 Rogers & Wells, LLP 607 - 14th Street N.W. Suite 900 Washington DC 20005-2011
19202 19202 1998-06-10 1995-02-24 Stilwell Amy L. Rogers & Wells, LLP 3428 1982-12-10 Rogers & Wells, LLP 607 - 14th Street N.W. Suite 900 Washington DC 20005-2011
19203 19203 1998-06-10 1992-05-13 Trainer Ryan T. Rogers & Wells, LLP 3428 1982-12-10 Rogers & Wells, LLP 607 - 14th Street N.W. Suite 900 Washington DC 20005-2011
19204 19204 1998-06-10 1992-07-17 Baughman Laura M. Rogers & Wells, LLP 3428 1982-12-10 Rogers & Wells, LLP 607 - 14th Street N.W. Suite 900 Washington DC 20005-2011
19205 19205 1998-06-10 1992-07-17 Covell Barbara J. Rogers & Wells, LLP 3428 1982-12-10 Rogers & Wells, LLP 607 - 14th Street N.W. Suite 900 Washington DC 20005-2011
19206 19206 1998-06-10 1992-07-17 Ferrin Richard Rogers & Wells, LLP 3428 1982-12-10 Rogers & Wells, LLP 607 - 14th Street N.W. Suite 900 Washington DC 20005-2011
20035 20035 1994-06-22 1993-07-08 Osborne Elizabeth Tabb Rogers & Wells, LLP 3428 1982-12-10 Rogers & Wells, LLP 607 - 14th Street N.W. Suite 900 Washington DC 20005-2011
30082 30082 1991-09-19 1982-12-10 Essaye Anthony F. Rogers & Wells, LLP 3428 1982-12-10 Rogers & Wells, LLP 607 - 14th Street N.W. Suite 900 Washington DC 20005-2011
30083 30083 1991-09-19 1982-12-10 Rossides Eugene T. Rogers & Wells, LLP 3428 1982-12-10 Rogers & Wells, LLP 607 - 14th Street N.W. Suite 900 Washington DC 20005-2011
40638 40638 1990-12-31 1984-08-07 Morris William Rogers & Wells, LLP 3428 1982-12-10 Rogers & Wells, LLP 607 - 14th Street N.W. Suite 900 Washington DC 20005-2011

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