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

28 rows where Registration_Number = 3869

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • DC 28

Registration_Number 1

  • Winston & Strawn · 28 ✖

Registrant_Name 1

  • Winston & Strawn 28

City 1

  • Washington 28
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
6624 6624 1991-02-11 1988-07-05 Maeder Edward C Winston & Strawn 3869 1986-08-13 Winston & Strawn 1400 L Street, N.W.   Washington DC 20005-3502
6625 6625 1991-02-11 1988-07-05 Schmidt Patrick L. Winston & Strawn 3869 1986-08-13 Winston & Strawn 1400 L Street, N.W.   Washington DC 20005-3502
6626 6626 1991-02-11 1986-08-13 Meltzer Richard Winston & Strawn 3869 1986-08-13 Winston & Strawn 1400 L Street, N.W.   Washington DC 20005-3502
9722 9722 1993-03-12 1992-01-08 Levine Edward L. Winston & Strawn 3869 1986-08-13 Winston & Strawn 1400 L Street, N.W.   Washington DC 20005-3502
9725 9725 1993-03-12 1987-09-11 Fiduccia Paul C. Winston & Strawn 3869 1986-08-13 Winston & Strawn 1400 L Street, N.W.   Washington DC 20005-3502
23432 23432 1992-07-17 1986-08-13 Engman Lewis A. Winston & Strawn 3869 1986-08-13 Winston & Strawn 1400 L Street, N.W.   Washington DC 20005-3502
25547 25547 1987-08-01 1986-08-13 Reilly John R. Winston & Strawn 3869 1986-08-13 Winston & Strawn 1400 L Street, N.W.   Washington DC 20005-3502
26542 26542 1999-08-13 1994-01-05 Hirschhorn Eric L. Winston & Strawn 3869 1986-08-13 Winston & Strawn 1400 L Street, N.W.   Washington DC 20005-3502
26543 26543 1999-08-13 1994-01-05 Kinney Charles L. Winston & Strawn 3869 1986-08-13 Winston & Strawn 1400 L Street, N.W.   Washington DC 20005-3502
26544 26544 1999-08-13 1994-02-09 Anthony Beryl F. , Jr. Winston & Strawn 3869 1986-08-13 Winston & Strawn 1400 L Street, N.W.   Washington DC 20005-3502
26546 26546 1999-08-13 1996-03-05 Hiebert Peter N. Winston & Strawn 3869 1986-08-13 Winston & Strawn 1400 L Street, N.W.   Washington DC 20005-3502
26547 26547 1999-08-13 1996-03-05 Pavia Francisco J. Winston & Strawn 3869 1986-08-13 Winston & Strawn 1400 L Street, N.W.   Washington DC 20005-3502
26548 26548 1999-08-13 1994-04-07 Waits John A. Winston & Strawn 3869 1986-08-13 Winston & Strawn 1400 L Street, N.W.   Washington DC 20005-3502
26549 26549 1999-08-13 1997-04-24 Napier John L. Winston & Strawn 3869 1986-08-13 Winston & Strawn 1400 L Street, N.W.   Washington DC 20005-3502
26550 26550 1999-08-13 1997-04-24 Pitts James T. Winston & Strawn 3869 1986-08-13 Winston & Strawn 1400 L Street, N.W.   Washington DC 20005-3502
26551 26551 1999-08-13 1993-05-05 Williams John E. Winston & Strawn 3869 1986-08-13 Winston & Strawn 1400 L Street, N.W.   Washington DC 20005-3502
26552 26552 1999-08-13 1997-05-05 O'Leary Joseph E. Winston & Strawn 3869 1986-08-13 Winston & Strawn 1400 L Street, N.W.   Washington DC 20005-3502
26553 26553 1999-08-13 1995-05-18 Schmidt Patrick L. Winston & Strawn 3869 1986-08-13 Winston & Strawn 1400 L Street, N.W.   Washington DC 20005-3502
26554 26554 1999-08-13 1994-06-24 Curtiss James R. Winston & Strawn 3869 1986-08-13 Winston & Strawn 1400 L Street, N.W.   Washington DC 20005-3502
26555 26555 1999-08-13 1994-06-24 Kirtland John C. Winston & Strawn 3869 1986-08-13 Winston & Strawn 1400 L Street, N.W.   Washington DC 20005-3502
28866 28866 1987-09-01 1986-08-13 Berlin Kenneth Winston & Strawn 3869 1986-08-13 Winston & Strawn 1400 L Street, N.W.   Washington DC 20005-3502
28867 28867 1987-09-01 1986-08-13 Bousquet Paul E. Winston & Strawn 3869 1986-08-13 Winston & Strawn 1400 L Street, N.W.   Washington DC 20005-3502
28868 28868 1987-09-01 1986-08-13 Gerwin Edward F. , Jr. Winston & Strawn 3869 1986-08-13 Winston & Strawn 1400 L Street, N.W.   Washington DC 20005-3502
29679 29679 1993-09-13 1992-01-08 Bostrom Robert E. Winston & Strawn 3869 1986-08-13 Winston & Strawn 1400 L Street, N.W.   Washington DC 20005-3502
29680 29680 1993-09-13 1992-01-08 Pitts James T. Winston & Strawn 3869 1986-08-13 Winston & Strawn 1400 L Street, N.W.   Washington DC 20005-3502
29681 29681 1993-09-13 1992-01-08 Richardson Douglas C. Winston & Strawn 3869 1986-08-13 Winston & Strawn 1400 L Street, N.W.   Washington DC 20005-3502
29682 29682 1993-09-13 1989-03-10 Gerwin Edward F. , Jr. Winston & Strawn 3869 1986-08-13 Winston & Strawn 1400 L Street, N.W.   Washington DC 20005-3502
29683 29683 1993-09-13 1989-03-10 Reilly John R. Winston & Strawn 3869 1986-08-13 Winston & Strawn 1400 L Street, N.W.   Washington DC 20005-3502

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