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

25 rows where Registration_Number = 3743

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date, Short_Form_Termination_Date (date)

State 1

  • DC 25

Registration_Number 1

  • Coudert Brothers · 25 ✖

Registrant_Name 1

  • Coudert Brothers 25

City 1

  • Washington, 25
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
2674 2674 1989-01-01 1989-03-16 Marmorstein Vicki E. Coudert Brothers 3743 1985-10-02 Coudert Brothers 1627 I Street, N. W. Suite 1200 Washington, DC 20006
4830 4830 1991-01-30 1990-11-02 McLaughlin Peter F. Coudert Brothers 3743 1985-10-02 Coudert Brothers 1627 I Street, N. W. Suite 1200 Washington, DC 20006
6741 6741 1992-02-13 1991-11-01 Lawson Grace Coudert Brothers 3743 1985-10-02 Coudert Brothers 1627 I Street, N. W. Suite 1200 Washington, DC 20006
12633 12633 1988-04-02 1986-06-04 Dean Richard Nils Coudert Brothers 3743 1985-10-02 Coudert Brothers 1627 I Street, N. W. Suite 1200 Washington, DC 20006
13788 13788 1990-04-20 1990-01-12 Vaughan David A. Coudert Brothers 3743 1985-10-02 Coudert Brothers 1627 I Street, N. W. Suite 1200 Washington, DC 20006
14102 14102 1994-04-25 1989-06-26 Coerper Milo G. Coudert Brothers 3743 1985-10-02 Coudert Brothers 1627 I Street, N. W. Suite 1200 Washington, DC 20006
14103 14103 1994-04-25 1990-11-02 Muchmore Susan M. Coudert Brothers 3743 1985-10-02 Coudert Brothers 1627 I Street, N. W. Suite 1200 Washington, DC 20006
14104 14104 1994-04-25 1992-11-02 Dean Richard N. Coudert Brothers 3743 1985-10-02 Coudert Brothers 1627 I Street, N. W. Suite 1200 Washington, DC 20006
14105 14105 1994-04-25 1992-11-02 Herlach Mark D. Coudert Brothers 3743 1985-10-02 Coudert Brothers 1627 I Street, N. W. Suite 1200 Washington, DC 20006
21136 21136 1990-06-30 1987-05-19 Wolfson Charles Mitchell Coudert Brothers 3743 1985-10-02 Coudert Brothers 1627 I Street, N. W. Suite 1200 Washington, DC 20006
22190 22190 1989-07-01 1985-10-02 Metzger Barry Coudert Brothers 3743 1985-10-02 Coudert Brothers 1627 I Street, N. W. Suite 1200 Washington, DC 20006
24499 24499 1990-07-30 1990-01-12 Perkins Lucy F. Coudert Brothers 3743 1985-10-02 Coudert Brothers 1627 I Street, N. W. Suite 1200 Washington, DC 20006
33705 33705 1994-10-27 1990-01-12 Georgi Kay C. Coudert Brothers 3743 1985-10-02 Coudert Brothers 1627 I Street, N. W. Suite 1200 Washington, DC 20006
33712 33712 1994-10-27 1991-05-02 Rutzen Douglas B. Coudert Brothers 3743 1985-10-02 Coudert Brothers 1627 I Street, N. W. Suite 1200 Washington, DC 20006
33715 33715 1994-10-27 1989-11-03 Lipstein Robert A. Coudert Brothers 3743 1985-10-02 Coudert Brothers 1627 I Street, N. W. Suite 1200 Washington, DC 20006
33716 33716 1994-10-27 1989-11-03 Rosenthal Douglas E. Coudert Brothers 3743 1985-10-02 Coudert Brothers 1627 I Street, N. W. Suite 1200 Washington, DC 20006
35106 35106 1992-11-02 1990-01-12 Mackintosh John T. Coudert Brothers 3743 1985-10-02 Coudert Brothers 1627 I Street, N. W. Suite 1200 Washington, DC 20006
35109 35109 1992-11-02 1985-10-02 Katz Sherman E. Coudert Brothers 3743 1985-10-02 Coudert Brothers 1627 I Street, N. W. Suite 1200 Washington, DC 20006
35110 35110 1992-11-02 1991-11-01 Burkhardt Christine L. Coudert Brothers 3743 1985-10-02 Coudert Brothers 1627 I Street, N. W. Suite 1200 Washington, DC 20006
35111 35111 1992-11-02 1991-11-01 Macdonald J. Ross Coudert Brothers 3743 1985-10-02 Coudert Brothers 1627 I Street, N. W. Suite 1200 Washington, DC 20006
35582 35582 1989-11-10 1989-11-03 Chudzinski Mark Adam Coudert Brothers 3743 1985-10-02 Coudert Brothers 1627 I Street, N. W. Suite 1200 Washington, DC 20006
36677 36677 1985-11-30 1985-10-02 Quinttus Michael L.M. Coudert Brothers 3743 1985-10-02 Coudert Brothers 1627 I Street, N. W. Suite 1200 Washington, DC 20006
38620 38620 1987-12-18 1986-05-02 Lewis Deborah A. Coudert Brothers 3743 1985-10-02 Coudert Brothers 1627 I Street, N. W. Suite 1200 Washington, DC 20006
39173 39173 1989-12-27 1989-06-26 Salen Stuart A. Coudert Brothers 3743 1985-10-02 Coudert Brothers 1627 I Street, N. W. Suite 1200 Washington, DC 20006
39255 39255 1986-12-28 1985-10-02 Scott Willard Warren J. Joseph , III Coudert Brothers 3743 1985-10-02 Coudert Brothers 1627 I Street, N. W. Suite 1200 Washington, DC 20006

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