FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

60 rows where Registration_Number = 4990

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • JWI, LLC · 60 ✖

Registrant_Name 1

City 1

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
319 319   1995-02-06 Waterman Charles E. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
320 320   1995-02-06 Wyman Samuel H. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
1440 1440   2017-07-20 Augustyn Joseph JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
1441 1441   2017-07-20 Karchmer Clifford JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
2844 2844 2007-01-01 2003-05-05 Blacklin Scott JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
3807 3807 1999-01-15 1998-04-24 Merkel David JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
5979 5979 1999-02-02 1998-09-25 Gawronski Shannon C. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
7742 7742 2016-02-26 2011-03-18 Shaiyen Hubert S. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
8077 8077 1997-02-28 1996-06-05 Rabinowitz Levi JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
8197 8197 2006-02-28 2003-05-05 Perry Mark JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
8805 8805 1996-03-01 1995-03-23 Dalley George A. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
8808 8808 1996-03-01 1995-08-16 Childs Stephanie JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
8826 8826 2002-03-01 1997-04-23 O'Neill Daniel J. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
9978 9978 1997-03-15 1995-05-27 Mutch William D. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
11879 11879 2002-03-31 2001-02-16 Klass Richard L. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
12228 12228 2018-03-31 2017-07-20 Schumacher Lauren JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
12231 12231 2018-03-31 2015-10-05 Thompson Stephen Mark JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
12232 12232 2018-03-31 2012-10-15 McLean Matthew JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
12505 12505 1997-04-01 1996-05-14 Evans Thomas B. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
13469 13469 1997-04-15 1996-01-18 Christianson Geryld B. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
14667 14667 1995-04-30 1995-04-05 Peck Edward L. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
14823 14823 2000-04-30 1998-05-12 Kim Melissa Schrader JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
15601 15601 1997-05-02 1996-11-14 Sarmiento Jessamyn D. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
16430 16430 1998-05-15 1997-07-02 Nugent David Scott Cases JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
17096 17096 2007-05-25 2003-09-25 Knobloch Jason JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
19584 19584 2002-06-15 1995-02-06 Wrobleski Ann Barbara JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
22259 22259 1997-07-01 1997-05-12 III John J. Rhodes JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
23669 23669 1997-07-20 1995-02-06 Boghossian Hovag H. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
25621 25621 1997-08-01 1997-07-02 Armstrong Philip C. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
25740 25740 2017-08-01 1995-02-06 Hoskinson Samuel M. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
25747 25747 2017-08-01 2014-06-23 Maday James JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
25749 25749 2017-08-01 2017-07-20 Lanzilao Elisabetta JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
26198 26198 2015-08-07 2013-04-29 Gregory Megan JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
26279 26279 1998-08-08 1995-02-06 Lamar Stephen E. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
27603 27603 2009-08-28 2004-01-29 Jenkins Kempton B. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
27604 27604 2009-08-28 2005-03-02 Smith Maureen R. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
28273 28273 1996-08-31 1995-02-06 Smith Gene M. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
28288 28288 1996-08-31 1995-06-02 Sarmiento Jessamyn D. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
28290 28290 1996-08-31 1995-08-07 Brandon Harry JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
28428 28428 2003-08-31 2003-05-05 Janka Leslie A. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
28914 28914 1997-09-01 1995-07-07 DuBeau James G. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
29169 29169 1998-09-04 1998-01-05 Kosztolnik Heather JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
29170 29170 1998-09-04 1997-03-21 Moxon Heather Kosztolnik JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
29889 29889 2001-09-15 2001-03-29 Callwood Kevin JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
32529 32529 2015-10-09 2011-01-10 Jackson Douglas JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
33640 33640 1997-10-25 1995-02-06 Ellis Steven G. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
34109 34109 2015-10-30 2010-12-30 Kurz Jonathan L. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
34392 34392 1997-10-31 1995-05-11 Carlstrom Robert E. , Jr. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
34393 34393 1997-10-31 1995-05-11 Donnelly Thomas R. , Jr. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
34394 34394 1997-10-31 1995-05-11 Roberts William Art JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
34411 34411 1998-10-31 1995-02-06 Bircher John E. , III JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
35878 35878 1995-11-15 1995-02-06 Robinson Michael W. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
35893 35893 2001-11-15 1999-03-26 Merkel Claire Sechler JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
36036 36036 2016-11-18 2012-12-31 McDonald Jackson C. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
36780 36780 1995-11-30 1995-02-06 Bell Cheryl Lee JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
36781 36781 1995-11-30 1995-02-06 Neill Denis M. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
36782 36782 1995-11-30 1995-03-06 Hertel Dennis M. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
36785 36785 1995-11-30 1995-04-11 Pines Robert H. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
37046 37046 2014-11-30 1998-01-07 Yates Kenneth A. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
38405 38405 1998-12-15 1995-02-06 Downen Robert L. JWI, LLC 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037

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