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

273 rows where City = "Washington" and Registration_Number = 3712

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • DC 273

Registration_Number 1

  • DLA Piper US LLP · 273 ✖

Registrant_Name 1

  • DLA Piper US LLP 273

City 1

  • Washington · 273 ✖
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
586 586   2009-03-17 Phillips Steven R. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
669 669   2012-03-29 Bell Nathaniel DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
2804 2804 2002-01-01 2001-04-16 Berry Brian T. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
2805 2805 2002-01-01 2001-04-16 Chlopak Robert A. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
2806 2806 2002-01-01 2001-04-16 Christy Erin E. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
2807 2807 2002-01-01 2001-04-16 Schechter Peter D. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
2808 2808 2002-01-01 2001-04-16 Singer Sheri L. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
2810 2810 2003-01-01 2001-02-22 McDonald Michael K. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
2817 2817 2003-01-01 1998-12-16 MacKinnon Douglas M. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
2835 2835 2005-01-01 2000-09-05 Bernstein Matthew C. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
2836 2836 2005-01-01 1998-09-22 Zentay John Holliday DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
2994 2994 2017-01-01 2016-08-26 Migdail Evan DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
3168 3168 1991-01-04 1985-10-03 Billings Leon G. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
3208 3208 2019-01-04 2018-09-30 Kierig Anne DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
3410 3410 1993-01-08 1988-04-01 Flowe Benjamin H. , Jr. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
4182 4182 2012-01-20 2006-11-20 O'Scannlain Kevin DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
4280 4280 2002-01-22 1999-09-03 Bishop Wayne S. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
4283 4283 2009-01-22 2008-07-15 Jones Lisa L. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
4285 4285 2009-01-22 2006-07-19 Gephardt Richard DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
4286 4286 2009-01-22 2007-08-09 Borland Lydia DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
4288 4288 2009-01-22 2000-09-05 Pickup James A. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
4289 4289 2009-01-22 2008-10-10 Maksad Firas DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
4290 4290 2009-01-22 2007-11-02 Abrams Kristen Leanderson DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
5810 5810 2002-02-01 2001-02-22 Brown Jamie DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
5811 5811 2002-02-01 1999-04-28 Saint-Louis Layn DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
5817 5817 2003-02-01 2001-05-29 Dole Robert J. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
5818 5818 2003-02-01 2002-07-02 Marshall Michael DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
5820 5820 2003-02-01 1999-09-03 Harris Marshall F. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
6182 6182 2001-02-05 1999-05-04 Merrigan Edward L. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
6183 6183 2001-02-05 1999-09-03 Hawley Noelle M. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
6196 6196 2003-02-05 2001-02-22 Regan Karen DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
6197 6197 2003-02-05 2001-02-22 Robinson Sara A. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
6697 6697 2004-02-12 2003-04-03 Minor William H. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
6744 6744 1998-02-13 1995-06-02 Williams Whitney J. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
6964 6964 2005-02-15 2003-10-28 Manson Joseph L. III DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
7173 7173 1994-02-17 1989-11-06 Kramerich Leslie DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
7174 7174 1994-02-17 1991-11-25 Klein Gary DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
7252 7252 2002-02-19 2001-02-22 Snider Jonathan Seth DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
7642 7642 2002-02-25 2001-02-22 Cors Dylan D. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
7643 7643 2002-02-25 2001-02-22 Luther Paul T. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
7729 7729 2003-02-26 2002-02-27 Cortinas-Garcia Juan DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
7730 7730 2003-02-26 2002-02-27 Giesbert Vera P. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
7731 7731 2003-02-26 2002-02-27 Haefeli Jennifer A. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
7732 7732 2003-02-26 2002-03-13 Garment Leonard DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
7733 7733 2003-02-26 2001-04-16 Bruce Thomas W. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8130 8130 2001-02-28 2000-05-15 Hibey James F. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8131 8131 2001-02-28 2000-05-15 Saltsman Richard H. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8265 8265 2013-02-28 2010-10-14 Baker III Charles A. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8412 8412 2021-02-28 2020-03-11 Penhoet Braden DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8414 8414 2021-02-28 1995-06-02 Merrigan John A. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8419 8419 2021-02-28 2006-12-08 Bernstein Matthew DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8436 8436 2023-02-28 2023-02-22 Audia Benedetta DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8437 8437 2023-02-28 2023-02-22 Frimpong Naana DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8438 8438 2023-02-28 2014-05-20 Newcomb Robert Richard DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8439 8439 2023-02-28 2021-08-10 Peyman David DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8592 8592 2020-02-29 2016-09-07 Simon Anthony DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8847 8847 2007-03-01 2006-05-04 Pantaleo Peter S. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8848 8848 2007-03-01 2006-09-08 Colleli J. Anthony DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8849 8849 2007-03-01 2006-10-13 Barron Meghan DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8850 8850 2007-03-01 2006-11-20 Boggs Virginia DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8851 8851 2007-03-01 2006-11-20 Jones Lisa Langston DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8855 8855 2008-03-01 2007-06-11 Magill Alix DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8859 8859 2008-03-01 2006-11-20 Cardozo Camilo DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8860 8860 2008-03-01 2006-11-20 Salomon Claudia DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8879 8879 2010-03-01 1998-01-06 McPherson Harry C. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8882 8882 2010-03-01 2010-03-29 Jones Lisa L. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8890 8890 2013-03-01 2000-09-05 Loud Edward P. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
9412 9412 2003-03-07 2002-03-13 Farrell Kelly J. Davis DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
9413 9413 2003-03-07 2001-05-29 Patel Rita DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
10170 10170 2007-03-17 2006-05-04 Murray Mark W. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
10230 10230 1988-03-18 1986-04-08 Stikas Tina M. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
10453 10453 1991-03-21 1989-05-25 Darneille Hopewell H. , III DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
10455 10455 1991-03-21 1985-12-09 McPherson Harry C. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
10528 10528 2002-03-22 2001-02-22 Thoms Greg DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
10990 10990 2013-03-28 2011-09-29 Schwanke Beth DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
11207 11207 2007-03-30 2001-03-28 Hand Lloyd DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
11211 11211 2007-03-30 2003-12-24 Escudero Maria Luisa DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
11856 11856 2001-03-31 2001-02-22 Rogers Joyce A. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
11869 11869 2001-03-31 1999-09-03 White Lisa McHenry DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
11876 11876 2001-03-31 1995-10-13 Dwyer Denis J. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
12015 12015 2007-03-31 2001-02-22 Hanley June DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
12518 12518 2004-04-01 2002-03-06 Evans William C. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
12519 12519 2004-04-01 2003-03-24 Hyland James E. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
12520 12520 2004-04-01 2000-05-15 Mietus John R. Jr. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
12522 12522 2004-04-01 2002-09-24 Lauria Thomas J. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
12524 12524 2005-04-01 1995-10-13 Freeman Rosemary B. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
12606 12606 2020-04-01 2016-11-22 Woolley Jessica S. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
13050 13050 2002-04-09 2002-02-04 Burdick Jessica A. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
14150 14150 2002-04-26 2000-09-05 Duncan Lawrence III DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
14151 14151 2004-04-26 2004-01-14 Choharis Peter DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
14305 14305 2017-04-28 2017-01-27 Leahy Wynne DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
14377 14377 2009-04-29 2007-11-02 Koloski Metodija A. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
14713 14713 1996-04-30 1995-10-13 Howerton Lorraine C. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
14838 14838 2001-04-30 2001-02-22 Taylor Damon DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
15085 15085 2016-04-30 2015-12-07 Infante Emil DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
15086 15086 2016-04-30 2015-12-07 Samra Harout Jack DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
15101 15101 2018-04-30 2018-03-06 Smotkin Richard DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
15124 15124 2018-04-30 2015-03-31 Boyd Thomas DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
15851 15851 2004-05-07 2001-02-22 Scott Lela R. DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
15942 15942 2001-05-08 2001-03-28 Richards Ann DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004

Next page

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