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

129 rows where Registration_Number = 2244

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: Registrant_Name, State

Registration_Number 1

  • Hogan Lovells US LLP · 129 ✖

City 1

  • Washington 129
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
509 509   2018-03-05 Zapien Eduardo Ivan Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
691 691   2016-03-30 Monts III William L. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
811 811   2020-04-16 Kroll Chase Robert Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
1063 1063   2016-05-20 Cutler Aaron Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
1407 1407   2014-07-15 Coleman Jr Norman B. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
1698 1698   2015-08-31 Fridman Adam Judah Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
1835 1835   2007-09-24 Goldfield H.P. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
3910 3910 2004-01-16 2003-01-24 Eckert Julie Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
4329 4329 2015-01-23 2014-12-17 Simpson Charles Kyle Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
5975 5975 1995-02-02 1993-06-11 Washington Eric T. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
7202 7202 1988-02-18 1977-09-16 Rothkopf Arthur J. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
7205 7205 1991-02-18 1990-09-14 Batla Raymond J. , Jr. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8047 8047 1996-02-28 1996-02-16 Jensen Sten A. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8060 8060 1996-02-28 1993-09-14 Mishkin Barbara Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8061 8061 1996-02-28 1993-09-14 Warnke Christine Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8067 8067 1996-02-28 1994-11-16 Maruyama Warren H. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8069 8069 1996-02-28 1994-12-21 Kenney Robert J. , Jr. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8071 8071 1997-02-28 1994-01-05 Bell Joseph C. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8073 8073 1997-02-28 1996-02-16 Miller George W. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8074 8074 1997-02-28 1988-03-29 Gilbert Gerald E. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8076 8076 1997-02-28 1993-05-18 Granese Nancy Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8081 8081 1997-02-28 1994-09-23 Howie Irene E. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8082 8082 1997-02-28 1996-09-30 Lehr Dennis J. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8085 8085 1997-02-28 1994-11-30 Ellett E. Tazewell Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8087 8087 1998-02-28 1994-01-24 Archibald Jeanne S. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8100 8100 1999-02-28 1996-02-16 Chetverikov Sergey B. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8107 8107 1999-02-28 1997-09-30 Farquhar Michele C. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8132 8132 2001-02-28 1993-06-23 Roggensack Margaret Ellen Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8149 8149 2001-02-28 1989-11-22 Leibowitz Lewis E. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8151 8151 2002-02-28 2001-04-04 Virtue Paul W. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8152 8152 2002-02-28 2001-05-09 Haft William S. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8153 8153 2002-02-28 1997-06-17 Weymouth T. Clark Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8161 8161 2003-02-28 1992-03-18 Kamarck Lynn Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8167 8167 2003-02-28 1993-09-14 Stanton John S. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8180 8180 2005-02-28 2004-04-19 Pena H.R. Bert Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8185 8185 2005-02-28 2003-07-14 Leverett Flynt Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8192 8192 2006-02-28 2004-01-09 Paemen Hugo Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8229 8229 2009-02-28 2004-01-09 Yeutter Clayton Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8326 8326 2018-02-28 2015-03-06 Jacobson Jack N. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8331 8331 2018-02-28 2014-05-30 Carneal George U. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8332 8332 2018-02-28 2014-05-30 Kyle Robert D. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8355 8355 2019-02-28 2016-03-16 Oakley Bruce D. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8356 8356 2019-02-28 2016-04-08 Stetson Catherine E. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8361 8361 2019-02-28 2018-09-28 Taylor Robert S. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8409 8409 2021-02-28 2020-02-08 Bell Michael J. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8488 8488 2000-02-29 1993-06-03 Barnes Michael D. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8494 8494 2000-02-29 1999-09-28 Lasker Helene Clarke Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8503 8503 2004-02-29 2003-01-24 Goldfield H.P. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8504 8504 2004-02-29 2002-02-13 Porter John Edward Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8559 8559 2008-02-29 1999-09-28 Gilliland C. Michael Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8583 8583 2016-02-29 2001-05-09 Michel Robert H. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8584 8584 2016-02-29 1987-05-29 McConnell Mark S. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8586 8586 2020-02-29 2007-03-30 Smith Kathleen M. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8594 8594 2020-02-29 2018-09-26 Kyle Robert Dixon Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8846 8846 2007-03-01 2006-02-02 Kuntamukkala Ajay Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
9954 9954 1991-03-15 1990-03-22 Punke Michael W. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
10242 10242 1993-03-18 1990-03-22 Miller Randy E. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
10243 10243 1993-03-18 1988-03-29 Rogers Paul G. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
10245 10245 1993-03-18 1992-09-24 Warnke Christine Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
10247 10247 1993-03-18 1987-11-13 Stanton John S. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
10253 10253 1994-03-18 1971-03-18 Sonosky Jerome N. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
10255 10255 1994-03-18 1989-05-15 Raher Patrick M. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
10310 10310 1993-03-19 1976-01-26 Fulbright J. William Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
10752 10752 1991-03-25 1990-03-27 Boswell Donna A. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
10962 10962 1995-03-28 1994-01-24 Whitener Michael L. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
10964 10964 1995-03-28 1993-09-14 Rogers Paul G. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
10965 10965 1995-03-28 1992-09-28 Farber Kenneth W. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
10966 10966 1995-03-28 1993-12-20 Wicks Glenn P. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
11509 11509 1982-03-31 1976-03-08 Montgomery Robert E. , Jr. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
12485 12485 1990-04-01 1987-07-10 Gibbons Clifford S. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
12489 12489 1991-04-01 1989-11-22 Lee John Y. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
15666 15666 2013-05-03 2012-08-24 Bayko Emil Thomas Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
16845 16845 2018-05-21 2001-04-19 Calamaro Raymond S. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
17644 17644 1978-05-31 1976-03-08 Holton A. Linwood , Jr. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
17729 17729 1990-05-31 1987-08-10 Taylor Chester D. , Jr. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
18159 18159 2016-05-31 2016-03-31 Kaplan H. Deen Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
18995 18995 2003-06-06 2003-01-24 Hook Brian Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
24842 24842 1991-07-31 1989-11-17 Rothkopf Arthur J. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
26921 26921 1987-08-18 1971-03-18 McDermott Edward A. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
28153 28153 1990-08-31 1988-03-29 Lawrence C. Stephen Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
28262 28262 1995-08-31 1988-03-29 Christian,II Alphonso Augustine Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
28277 28277 1996-08-31 1990-02-16 Fahrenkopf Frank J. , Jr. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
28282 28282 1996-08-31 1994-03-22 Dubitsky Alexander A. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
28303 28303 1997-08-31 1992-03-18 House W. Michael Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
28308 28308 1997-08-31 1992-05-28 Pena Humberto R. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
28310 28310 1997-08-31 1997-06-17 Leitch David G. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
28311 28311 1997-08-31 1997-06-17 Peters Mary Elizabeth Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
28358 28358 2000-08-31 1990-03-27 Winnik Joel S. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
28361 28361 2000-08-31 1999-07-09 Warnke Christine Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
28362 28362 2000-08-31 1999-07-14 Munk Jeffrey W. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
28366 28366 2000-08-31 1998-09-30 Archibald Jeanne S. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
28394 28394 2001-08-31 2001-07-27 Giancarlo Angela Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
28395 28395 2001-08-31 2001-07-27 Klein Douglas Abraham Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
28396 28396 2001-08-31 2001-07-27 Sieradzki David L. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
28397 28397 2001-08-31 2001-07-31 Bultena Lance D. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
28406 28406 2002-08-31 1988-03-29 Elliott Robert J. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
28420 28420 2002-08-31 1997-10-27 Lehr Dennis J. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
28429 28429 2003-08-31 2001-05-11 Warnke Christine Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
28468 28468 2006-08-31 1988-03-29 Carneal George U. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
28515 28515 2008-08-31 2004-01-09 Lewis Craig A. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109

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