List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

39 rows where Registration_Number = 5198

View and edit SQL

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

State

Registration_Number

  • 5198 · 39

City

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
36   2020-01-03 Rabinowitz Matthew R. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
172   2019-01-30 Fork William E. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
273   2002-02-13 Becker Stephan E. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
300   2018-02-20 Merrifield Jeffrey S. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
310   2019-02-23 Kaplan Aryeh L. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
626   2015-04-24 Moeller Elizabeth V. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
1942   2012-11-20 Laughlin Gregory H. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
2084   2019-12-03 Fischer Nancy A. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
2099   2012-12-07 Saperstein Craig J. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
2113   2019-12-09 Wall Christopher W. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
2851 2007-01-02 2005-04-27 McKamey Jana 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
3209 2016-01-09 2006-08-07 MacLean Matthew 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
3978 2015-01-23 2011-10-17 Peterson Charles H. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
4833 1998-01-31 1997-11-12 O'Neill John H. , Jr. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
4840 1999-01-31 1998-08-31 Wilkinson Naomi J. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
5136 2016-01-31 2006-08-07 Cynamon David J. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
5147 2017-01-31 2015-03-26 Wisner Graham G. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
5899 2002-02-07 2000-07-21 Fuentes Rodolfo R. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
11201 2000-03-31 1997-07-31 Conn Robert E. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
11544 2016-03-31 2015-03-26 Harris Laurence E. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
13407 2005-04-27 2002-12-17 Mirani Viraj 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
14925 1999-05-07 1998-04-09 Moore Christopher 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
15052 2008-05-09 2006-08-07 Handoo Osman 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
15476 2000-05-15 2000-05-02 Woods Andrew L. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
20695 2015-06-30 1998-04-09 Epstein Anita K. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
22384 2001-07-20 1998-08-31 Spulak Thomas J. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
24018 2019-07-31 2019-02-23 Putorti Matthew F. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
24036 2020-07-31 2019-02-23 Jean Joseph D. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
24789 1998-08-07 1998-08-31 Runyon Bradley 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
25396 2017-08-15 2015-04-24 Oresman Matthew S. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
26351 2002-08-30 2000-04-28 O'Malley Edward M. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
28151 2008-09-12 2007-06-13 Prioleau Florence W. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
31086 1999-10-12 1998-08-31 Woods Andrew L. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
31301 2001-10-15 2000-05-25 Delaney Thomas J. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
31880 2020-10-23 2018-04-19 Oresman Matthew S. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
32985 2011-10-31 2010-12-15 Laughlin Gregory H. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
33998 2008-11-13 2007-06-13 Laughlin Gregory H. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
34039 2008-11-14 2007-06-13 Lanier Joseph H. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
36057 2012-12-07 2011-11-10 Glasgow James A. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228

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)
);