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

267 rows where Registrant_Name = "DLA Piper US LLP"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State

Registration_Number

Registrant_Name

  • DLA Piper US LLP · 267 ✖

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
429 429   2015-03-12 Schaefermeier Martin 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
430 430   2015-03-12 Stern Rochelle Eva 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
461 461   2009-03-17 Phillips Steven R. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
546 546   2013-03-28 Castle Michael 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
551 551   2012-03-29 Bell Nathaniel 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
834 834   2006-05-04 Salem George Richard 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
931 931   2014-05-20 Newcomb Robert Richard 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
1074 1074   1995-06-02 Merrigan John A. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
1655 1655   2016-09-07 Simon Anthony 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
1971 1971   2018-10-26 Jebeyli Stephanie 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
2054 2054   2012-11-07 Garcia Melanie 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
2097 2097   1995-11-16 Levinson Lawrence E. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
2283 2283   2006-12-08 Bernstein Matthew 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
2730 2730 2002-01-01 2001-04-16 Berry Brian T. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
2731 2731 2002-01-01 2001-04-16 Chlopak Robert A. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
2732 2732 2002-01-01 2001-04-16 Christy Erin E. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
2733 2733 2002-01-01 2001-04-16 Schechter Peter D. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
2734 2734 2002-01-01 2001-04-16 Singer Sheri L. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
2736 2736 2003-01-01 2001-02-22 McDonald Michael K. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
2743 2743 2003-01-01 1998-12-16 MacKinnon Douglas M. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
2761 2761 2005-01-01 2000-09-05 Bernstein Matthew C. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
2762 2762 2005-01-01 1998-09-22 Zentay John Holliday 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
2920 2920 2017-01-01 2016-08-26 Migdail Evan 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
3071 3071 1991-01-04 1985-10-03 Billings Leon G. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
3111 3111 2019-01-04 2018-09-30 Kierig Anne 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
3275 3275 1993-01-08 1988-04-01 Flowe Benjamin H. , Jr. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
3985 3985 2012-01-20 2006-11-20 O'Scannlain Kevin 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
4081 4081 2002-01-22 1999-09-03 Bishop Wayne S. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
4084 4084 2009-01-22 2008-07-15 Jones Lisa L. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
4086 4086 2009-01-22 2006-07-19 Gephardt Richard 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
4087 4087 2009-01-22 2007-08-09 Borland Lydia 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
4089 4089 2009-01-22 2000-09-05 Pickup James A. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
4090 4090 2009-01-22 2008-10-10 Maksad Firas 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
4091 4091 2009-01-22 2007-11-02 Abrams Kristen Leanderson 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
5537 5537 2002-02-01 2001-02-22 Brown Jamie 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
5538 5538 2002-02-01 1999-04-28 Saint-Louis Layn 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
5544 5544 2003-02-01 2001-05-29 Dole Robert J. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
5545 5545 2003-02-01 2002-07-02 Marshall Michael 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
5547 5547 2003-02-01 1999-09-03 Harris Marshall F. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
5890 5890 2001-02-05 1999-05-04 Merrigan Edward L. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
5891 5891 2001-02-05 1999-09-03 Hawley Noelle M. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
5904 5904 2003-02-05 2001-02-22 Regan Karen 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
5905 5905 2003-02-05 2001-02-22 Robinson Sara A. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
6380 6380 2004-02-12 2003-04-03 Minor William H. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
6426 6426 1998-02-13 1995-06-02 Williams Whitney J. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
6630 6630 2005-02-15 2003-10-28 Manson Joseph L. III 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
6808 6808 1994-02-17 1989-11-06 Kramerich Leslie 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
6809 6809 1994-02-17 1991-11-25 Klein Gary 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
6877 6877 2002-02-19 2001-02-22 Snider Jonathan Seth 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
7249 7249 2002-02-25 2001-02-22 Cors Dylan D. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
7250 7250 2002-02-25 2001-02-22 Luther Paul T. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
7334 7334 2003-02-26 2002-02-27 Cortinas-Garcia Juan 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
7335 7335 2003-02-26 2002-02-27 Giesbert Vera P. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
7336 7336 2003-02-26 2002-02-27 Haefeli Jennifer A. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
7337 7337 2003-02-26 2002-03-13 Garment Leonard 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
7338 7338 2003-02-26 2001-04-16 Bruce Thomas W. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
7727 7727 2001-02-28 2000-05-15 Hibey James F. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
7728 7728 2001-02-28 2000-05-15 Saltsman Richard H. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
7862 7862 2013-02-28 2010-10-14 Baker III Charles A. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8361 8361 2007-03-01 2006-05-04 Pantaleo Peter S. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8362 8362 2007-03-01 2006-09-08 Colleli J. Anthony 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8363 8363 2007-03-01 2006-10-13 Barron Meghan 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8364 8364 2007-03-01 2006-11-20 Boggs Virginia 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8365 8365 2007-03-01 2006-11-20 Jones Lisa Langston 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8369 8369 2008-03-01 2007-06-11 Magill Alix 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8373 8373 2008-03-01 2006-11-20 Cardozo Camilo 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8374 8374 2008-03-01 2006-11-20 Salomon Claudia 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8393 8393 2010-03-01 1998-01-06 McPherson Harry C. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8396 8396 2010-03-01 2010-03-29 Jones Lisa L. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8404 8404 2013-03-01 2000-09-05 Loud Edward P. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8892 8892 2003-03-07 2002-03-13 Farrell Kelly J. Davis 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
8893 8893 2003-03-07 2001-05-29 Patel Rita 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
9603 9603 2007-03-17 2006-05-04 Murray Mark W. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
9662 9662 1988-03-18 1986-04-08 Stikas Tina M. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
9884 9884 1991-03-21 1989-05-25 Darneille Hopewell H. , III 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
9886 9886 1991-03-21 1985-12-09 McPherson Harry C. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
9959 9959 2002-03-22 2001-02-22 Thoms Greg 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
10408 10408 2013-03-28 2011-09-29 Schwanke Beth 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
10621 10621 2007-03-30 2001-03-28 Hand Lloyd 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
10625 10625 2007-03-30 2003-12-24 Escudero Maria Luisa 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
11268 11268 2001-03-31 2001-02-22 Rogers Joyce A. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
11281 11281 2001-03-31 1999-09-03 White Lisa McHenry 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
11288 11288 2001-03-31 1995-10-13 Dwyer Denis J. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
11427 11427 2007-03-31 2001-02-22 Hanley June 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
11839 11839 2004-04-01 2002-03-06 Evans William C. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
11840 11840 2004-04-01 2003-03-24 Hyland James E. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
11841 11841 2004-04-01 2000-05-15 Mietus John R. Jr. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
11843 11843 2004-04-01 2002-09-24 Lauria Thomas J. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
11845 11845 2005-04-01 1995-10-13 Freeman Rosemary B. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
11915 11915 2020-04-01 2016-11-22 Woolley Jessica S. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
12334 12334 2002-04-09 2002-02-04 Burdick Jessica A. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
13372 13372 2002-04-26 2000-09-05 Duncan Lawrence III 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
13373 13373 2004-04-26 2004-01-14 Choharis Peter 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
13522 13522 2017-04-28 2017-01-27 Leahy Wynne 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
13592 13592 2009-04-29 2007-11-02 Koloski Metodija A. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
13921 13921 1996-04-30 1995-10-13 Howerton Lorraine C. 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
14046 14046 2001-04-30 2001-02-22 Taylor Damon 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
14292 14292 2016-04-30 2015-12-07 Infante Emil 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
14293 14293 2016-04-30 2015-12-07 Samra Harout Jack 3712 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
14308 14308 2018-04-30 2018-03-06 Smotkin Richard 3712 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 · Query took 382.462ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history