List of all short form registrants (active and terminated)

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

33 rows where Registration_Number = 3988

View and edit SQL

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

State

Registration_Number

  • 3988 · 33

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
354   2019-03-01 Flowers Lewis C. 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
1617   2019-10-08 Su Shelley 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
1853   2017-11-09 Boswell Joshua 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
1854   2017-11-09 MacFarlane Ryan 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
2130   2013-12-13 Yu Evan Tzyy-yih 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
2237   2016-12-29 Bacigalupo Patricia Wu 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
2238   2016-12-29 Clemans Kathryn 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
2720 2016-01-01 2011-06-02 Boswell Joshua 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
2861 2018-01-02 2016-12-29 Beukman Willem Danie 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
3234 1992-01-10 1989-05-05 Covell Barbara J. 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
3892 2016-01-21 2015-12-14 Geisler Daniel 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
5999 2018-02-08 2012-12-04 Huang Tracy T. 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
8852 2018-03-07 2017-11-09 Davies Paul John 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
11009 1991-03-31 1987-05-28 Palmer Claire A. (Nee Rickard) 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
14554 1990-05-01 1987-06-23 Halperin Robert M. 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
16328 2002-05-28 1990-03-15 Keene Thomas C. 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
16329 2002-05-28 1991-03-26 Maguire Sioban 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
17512 2012-06-01 2011-06-02 Ji Ke 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
18594 2000-06-16 1996-09-19 Wilson Christopher S. 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
19322 1993-06-28 1992-06-29 Ravesteijn Elizabeth H. 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
21107 2006-07-01 2001-07-16 Geisler Dan 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
23065 2009-07-29 2009-01-16 Shastry Mira 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
24237 1991-08-01 1988-04-19 Baughman Laura M. 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
26700 1989-08-31 1987-05-28 Polonsky Ehud 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
27510 2015-09-01 1987-05-28 Cooper Doral S. 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
30091 2016-09-30 2015-12-14 Smith James B. 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
33371 2019-11-01 2017-11-09 Jennings Franklin Clark 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
34758 2002-11-28 1993-04-08 Clemans Kathryn Heather Barbara 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
35348 2018-11-30 2017-05-05 Zhang Yizhi Jing Jing 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
36594 2010-12-15 2006-06-29 Davies Paul 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
36596 2010-12-15 2009-12-16 Schmitz Michael E. 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
37235 2012-12-24 2008-07-08 Tein Andrew 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
37602 2019-12-30 1991-11-19 Coyle (Morris) Melissa D. 3988 3988 1987-05-28 Crowell & Moring International, Ltd. 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595

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