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 = 4539

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • NY 19

Registration_Number 1

  • Paul, Weiss, Rifkind, Wharton & Garrison · 19 ✖

Registrant_Name 1

  • Paul, Weiss, Rifkind, Wharton & Garrison 19

City 1

  • New York 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
3134 3134 1992-01-03 1991-07-24 Golinski Pamela Paul, Weiss, Rifkind, Wharton & Garrison 4539 1991-07-09 Paul, Weiss, Rifkind, Wharton & Garrison 1285 Avenue of the Americas   New York NY 10019-6064
3137 3137 2000-01-03 1995-03-06 Kwon Soon-Yub Paul, Weiss, Rifkind, Wharton & Garrison 4539 1991-07-09 Paul, Weiss, Rifkind, Wharton & Garrison 1285 Avenue of the Americas   New York NY 10019-6064
5254 5254 2002-01-31 1997-01-17 Weiler David Joseph Paul, Weiss, Rifkind, Wharton & Garrison 4539 1991-07-09 Paul, Weiss, Rifkind, Wharton & Garrison 1285 Avenue of the Americas   New York NY 10019-6064
5255 5255 2002-01-31 1999-02-26 Lakhdhir David K. Paul, Weiss, Rifkind, Wharton & Garrison 4539 1991-07-09 Paul, Weiss, Rifkind, Wharton & Garrison 1285 Avenue of the Americas   New York NY 10019-6064
5256 5256 2002-01-31 1999-02-26 Sarro Dale M. Paul, Weiss, Rifkind, Wharton & Garrison 4539 1991-07-09 Paul, Weiss, Rifkind, Wharton & Garrison 1285 Avenue of the Americas   New York NY 10019-6064
5257 5257 2002-01-31 1999-02-26 Yu Tong Paul, Weiss, Rifkind, Wharton & Garrison 4539 1991-07-09 Paul, Weiss, Rifkind, Wharton & Garrison 1285 Avenue of the Americas   New York NY 10019-6064
5258 5258 2002-01-31 2000-02-29 Nicol Jesse A. Paul, Weiss, Rifkind, Wharton & Garrison 4539 1991-07-09 Paul, Weiss, Rifkind, Wharton & Garrison 1285 Avenue of the Americas   New York NY 10019-6064
5259 5259 2002-01-31 1998-03-10 Rabie Aseel M. Paul, Weiss, Rifkind, Wharton & Garrison 4539 1991-07-09 Paul, Weiss, Rifkind, Wharton & Garrison 1285 Avenue of the Americas   New York NY 10019-6064
5261 5261 2002-01-31 1991-07-09 Kleinfeld George D. Paul, Weiss, Rifkind, Wharton & Garrison 4539 1991-07-09 Paul, Weiss, Rifkind, Wharton & Garrison 1285 Avenue of the Americas   New York NY 10019-6064
5262 5262 2002-01-31 1991-07-09 Montgomery Robert E. , Jr. Paul, Weiss, Rifkind, Wharton & Garrison 4539 1991-07-09 Paul, Weiss, Rifkind, Wharton & Garrison 1285 Avenue of the Americas   New York NY 10019-6064
6470 6470 1993-02-09 1992-10-09 Kraiem Ruben Paul, Weiss, Rifkind, Wharton & Garrison 4539 1991-07-09 Paul, Weiss, Rifkind, Wharton & Garrison 1285 Avenue of the Americas   New York NY 10019-6064
6471 6471 1993-02-09 1992-10-13 Harrison Norman J. Paul, Weiss, Rifkind, Wharton & Garrison 4539 1991-07-09 Paul, Weiss, Rifkind, Wharton & Garrison 1285 Avenue of the Americas   New York NY 10019-6064
6743 6743 1998-02-13 1998-03-10 Gwak Dong-Yeol Paul, Weiss, Rifkind, Wharton & Garrison 4539 1991-07-09 Paul, Weiss, Rifkind, Wharton & Garrison 1285 Avenue of the Americas   New York NY 10019-6064
7536 7536 1994-02-24 1991-07-09 Parker Robert P. Paul, Weiss, Rifkind, Wharton & Garrison 4539 1991-07-09 Paul, Weiss, Rifkind, Wharton & Garrison 1285 Avenue of the Americas   New York NY 10019-6064
11659 11659 1992-03-31 1992-02-07 Bloom Jane L. Paul, Weiss, Rifkind, Wharton & Garrison 4539 1991-07-09 Paul, Weiss, Rifkind, Wharton & Garrison 1285 Avenue of the Americas   New York NY 10019-6064
11681 11681 1992-03-31 1991-10-17 Hankey Blair Gilbert Paul, Weiss, Rifkind, Wharton & Garrison 4539 1991-07-09 Paul, Weiss, Rifkind, Wharton & Garrison 1285 Avenue of the Americas   New York NY 10019-6064
17888 17888 1997-05-31 1997-03-25 Yoon Shinwon E. Paul, Weiss, Rifkind, Wharton & Garrison 4539 1991-07-09 Paul, Weiss, Rifkind, Wharton & Garrison 1285 Avenue of the Americas   New York NY 10019-6064
41221 41221 2001-12-31 1994-02-23 Sorensen Theodore C. Paul, Weiss, Rifkind, Wharton & Garrison 4539 1991-07-09 Paul, Weiss, Rifkind, Wharton & Garrison 1285 Avenue of the Americas   New York NY 10019-6064
41236 41236 2001-12-31 1991-07-24 Fortune Terence J. Paul, Weiss, Rifkind, Wharton & Garrison 4539 1991-07-09 Paul, Weiss, Rifkind, Wharton & Garrison 1285 Avenue of the Americas   New York NY 10019-6064

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