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

39 rows where Registration_Number = 5198

Search:

descending

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
67	67		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
212	212		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
323	323		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
353	353		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
365	365		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
366	366		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
764	764		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
776	776		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
2070	2070		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
2224	2224		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
2239	2239		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
2253	2253		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
2976	2976	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
3332	3332	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
4088	4088	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
4933	4933	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
4940	4940	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
5236	5236	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
5247	5247	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
5984	5984	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
11183	11183	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
11525	11525	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
13357	13357	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
14821	14821	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
14947	14947	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
15370	15370	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
20531	20531	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
22185	22185	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
23815	23815	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
24552	24552	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
25139	25139	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
26073	26073	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
27857	27857	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
30758	30758	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
30973	30973	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
32641	32641	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
33623	33623	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
33664	33664	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
35623	35623	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

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