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

66 rows where Registration_Number = 3718

View and edit SQL

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

State

Registration_Number

  • 3718 · 66

Registrant_Name

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
72   2019-01-09 Stavinsky Meital 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
248   2014-02-06 Galano Michael 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
319   1999-02-24 Oleynik Ronald A. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
433   2020-03-13 Smith Tim 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
658   2017-04-14 Mason Scott D. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
859   2014-05-14 Davis III James Oscar 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
860   2014-05-14 Lehman Kathryn Hazeem 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
1014   2004-06-01 Epstein Jonathan M. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
1325   2019-07-26 Reynolds Thomas M. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
1326   2019-07-26 Richardson Jodi A. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
1493   2016-08-23 Mastrangelo Paolo 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
1990   2017-10-31 Liston David 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
3409 2020-01-11 2019-07-26 Vastola Sally A. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
3410 2020-01-11 2019-10-04 Davis Tom 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
3411 2020-01-11 2019-10-04 Koch Karl 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
3412 2020-01-11 2019-10-04 Watley Shawna F. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
5923 2003-02-06 1997-01-29 Cobbs Louise B. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
5999 1999-02-07 1999-02-24 Studley Janet R. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
6761 2001-02-16 1999-02-24 McQuerry Michael 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
6914 1997-02-20 1986-01-16 Mencio George , Jr. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
7079 1995-02-23 1985-08-07 Studley Janet R. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
7545 1990-02-28 1986-01-16 Bell William G. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
7546 1990-02-28 1986-01-16 Steinberg Marty 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
7749 2002-02-28 1999-08-16 Ball Markham 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
7866 2014-02-28 2010-03-29 Lehman Kathryn 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
7987 1996-02-29 1993-12-17 Assevero Vicki 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
8056 2008-02-29 2004-06-01 Viola Beth A. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
8395 2010-03-01 2010-03-29 Galano Michael 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
8711 1992-03-06 1990-03-07 Schroeder Yvonne C. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
8713 1992-03-06 1985-08-07 Glass W. Reeder 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
8714 1992-03-06 1985-08-07 Loos Dickson R. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
9084 1992-03-11 1992-01-21 Mendez-Penate Carlos 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
9102 1998-03-11 1996-09-12 Childs Stephanie 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
13790 1986-04-30 1985-08-07 Dunaway Mac S. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
15408 2002-05-14 1999-02-24 Burkman John M. (Jack) 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
17865 2020-06-05 2020-01-27 Hekmat Farid 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
18926 2000-06-22 1993-12-17 Dalley George A. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
19068 1999-06-24 1999-02-24 Davis DeLancey W. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
19210 2020-06-26 2015-04-30 Feehery Kerry F. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
22017 2001-07-15 2001-07-18 Cutler Lynn 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
22018 2001-07-15 2001-07-18 Woodson Roderic L. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
22633 1998-07-23 1998-04-15 Dalley George A. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
23728 2005-07-31 2004-06-01 Jordan-Lynch Guillermo 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
24853 1998-08-08 1992-02-03 Maguire Amelia 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
24855 1998-08-08 1998-04-15 Dye Stuart S. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
25448 2006-08-17 2004-06-01 Adair Julie A. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
25449 2006-08-17 2003-12-05 Sciarra Vanessa P. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
25450 2006-08-17 2003-12-05 Sikorski Gerry 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
26887 2001-08-31 1999-02-24 Sikorski Gerry 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
26894 2001-08-31 2000-06-02 Marquez Jim J. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
26949 2005-08-31 2004-10-22 Gomez-Pinzon Enrique 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
27171 2019-08-31 2016-08-23 Sikorski Gerry 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
27187 2020-08-31 2015-04-30 Bock Paul S. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
27448 2014-09-01 2014-02-06 Meissner Mark 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
28740 1994-09-23 1985-08-07 Baker David H. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
28965 2014-09-26 2014-02-06 Conlin Andrew Raymond 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
28966 2014-09-26 2014-02-06 Gold Richard M. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
28967 2014-09-26 2014-02-06 Gordon Stewart 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
28968 2014-09-26 2014-02-06 Young Audrey E. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
28969 2014-09-26 2010-03-29 Roberson Joel 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
28970 2014-09-26 2010-03-29 Sikorski Gerry 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
33373 2015-11-03 2015-10-05 Jackson Janene D. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
34985 1998-11-30 1998-04-15 Fascell Dante B. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
39188 2001-12-31 2000-01-07 Railsback Thomas 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
40044 2016-12-31 2014-10-30 Carseni Joseph M. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
40224 2019-12-31 2016-08-23 Cole David S. 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006

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 404.05ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history