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

45 rows where Registrant_Name = "Coudert Brothers"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date, Registration_Date, Address_1, Address_2, Short_Form_Date (date), Registration_Date (date)

Registration_Number 6

  • Coudert Brothers 25
  • Coudert Brothers 8
  • Coudert Brothers 5
  • Coudert Brothers 3
  • Coudert Brothers 2
  • Coudert Brothers 2

City 3

  • Washington, 25
  • Washington 11
  • New York 9

State 2

  • DC 36
  • NY 9

Registrant_Name 1

  • Coudert Brothers · 45 ✖
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
6113 6113 1977-02-04 1973-07-02 Franklin Blake T. Coudert Brothers 2440 1973-07-02 Coudert Brothers 200 Park Avenue   New York NY 10017
6114 6114 1977-02-04 1973-07-02 Linowitz Sol M. Coudert Brothers 2440 1973-07-02 Coudert Brothers 200 Park Avenue   New York NY 10017
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
10819 10819 1999-03-26 1998-11-06 Jorjani Daniel H. Coudert Brothers 5254 1998-04-23 Coudert Brothers 1627 I Street, N.W.   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
17943 17943 2001-05-31 1998-04-23 Deaver Robin L. Coudert Brothers 5254 1998-04-23 Coudert Brothers 1627 I Street, N.W.   Washington DC 20006
17944 17944 2001-05-31 1998-04-23 Georgi Kay C. Coudert Brothers 5254 1998-04-23 Coudert Brothers 1627 I Street, N.W.   Washington DC 20006
17951 17951 2001-05-31 1998-11-06 Lieberman Edward Coudert Brothers 5254 1998-04-23 Coudert Brothers 1627 I Street, N.W.   Washington DC 20006
17956 17956 2001-05-31 1998-12-10 Lunn Mark P. Coudert Brothers 5254 1998-04-23 Coudert Brothers 1627 I Street, N.W.   Washington DC 20006
19304 19304 1998-06-12 1998-04-23 Guerin Arnaud Coudert Brothers 5254 1998-04-23 Coudert Brothers 1627 I Street, N.W.   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
25956 25956 2000-08-04 1998-11-06 Chernyak Natasha V. Coudert Brothers 5254 1998-04-23 Coudert Brothers 1627 I Street, N.W.   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
34414 34414 1998-10-31 1998-04-23 Kelly W. Michael Coudert Brothers 5254 1998-04-23 Coudert Brothers 1627 I Street, N.W.   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
36604 36604 1967-11-30 1965-05-18 Dominianni Emilio Anthony Coudert Brothers 1811 1964-11-02 Coudert Brothers 200 Park Avenue   New York NY 10017
36606 36606 1967-11-30 1964-11-02 Coudert Alexis C. Coudert Brothers 1811 1964-11-02 Coudert Brothers 200 Park Avenue   New York NY 10017
36607 36607 1967-11-30 1964-11-02 Fitzgerald Hugh F. Coudert Brothers 1811 1964-11-02 Coudert Brothers 200 Park Avenue   New York NY 10017
36608 36608 1967-11-30 1964-11-02 Hughes James E. Coudert Brothers 1811 1964-11-02 Coudert Brothers 200 Park Avenue   New York NY 10017
36609 36609 1967-11-30 1964-11-02 Rand William , Jr. Coudert Brothers 1811 1964-11-02 Coudert Brothers 200 Park Avenue   New York NY 10017
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
38363 38363 1972-12-15 1971-03-26 Franklin Blake T. Coudert Brothers 2222 1970-11-24 Coudert Brothers 1 Farragut Square, South   Washington DC 20006
38365 38365 1972-12-15 1972-06-22 Linowitz Sol M. Coudert Brothers 2222 1970-11-24 Coudert Brothers 1 Farragut Square, South   Washington DC 20006
38366 38366 1972-12-15 1970-11-24 Katz Sherman E. Coudert Brothers 2222 1970-11-24 Coudert Brothers 1 Farragut Square, South   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
38795 38795 1982-12-20 1981-10-15 Metzger Barry Coudert Brothers 3287 1981-10-07 Coudert Brothers 200 Park Avenue   New York NY 10166
38796 38796 1982-12-20 1981-10-15 Stevens Charles R. Coudert Brothers 3287 1981-10-07 Coudert Brothers 200 Park Avenue   New York NY 10166
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 380.458ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history