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

34 rows where Registration_Number = 3988

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • DC 34

Registration_Number 1

  • Crowell & Moring International, LLC · 34 ✖

Registrant_Name 1

  • Crowell & Moring International, LLC 34

City 1

  • Washington 34
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
1311 1311   2023-06-28 Smith Spencer Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
2125 2125   2017-11-09 MacFarlane Ryan Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
2388 2388   2013-12-13 Yu Evan Tzyy-yih Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
2478 2478   2016-12-29 Bacigalupo Patricia Wu Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
2479 2479   2016-12-29 Clemans Kathryn Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
2951 2951 2016-01-01 2011-06-02 Boswell Joshua Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
3025 3025 2023-01-01 2019-04-18 Flowers Lewis C. Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
3109 3109 2018-01-02 2016-12-29 Beukman Willem Danie Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
3526 3526 1992-01-10 1989-05-05 Covell Barbara J. Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
4235 4235 2016-01-21 2015-12-14 Geisler Daniel Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
6433 6433 2018-02-08 2012-12-04 Huang Tracy T. Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
9419 9419 2018-03-07 2017-11-09 Davies Paul John Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
11641 11641 1991-03-31 1987-05-28 Palmer Claire A. (Nee Rickard) Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
15424 15424 1990-05-01 1987-06-23 Halperin Robert M. Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
15571 15571 2023-05-01 2019-10-08 Su Shelley Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
17305 17305 2002-05-28 1990-03-15 Keene Thomas C. Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
17306 17306 2002-05-28 1991-03-26 Maguire Sioban Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
18552 18552 2012-06-01 2011-06-02 Ji Ke Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
18608 18608 2021-06-01 2017-11-09 Boswell Joshua Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
19692 19692 2000-06-16 1996-09-19 Wilson Christopher S. Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
20441 20441 1993-06-28 1992-06-29 Ravesteijn Elizabeth H. Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
22309 22309 2006-07-01 2001-07-16 Geisler Dan Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
24388 24388 2009-07-29 2009-01-16 Shastry Mira Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
25597 25597 1991-08-01 1988-04-19 Baughman Laura M. Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
28141 28141 1989-08-31 1987-05-28 Polonsky Ehud Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
28977 28977 2015-09-01 1987-05-28 Cooper Doral S. Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
31609 31609 2016-09-30 2015-12-14 Smith James B. Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
35045 35045 2019-11-01 2017-11-09 Jennings Franklin Clark Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
36517 36517 2002-11-28 1993-04-08 Clemans Kathryn Heather Barbara Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
37108 37108 2018-11-30 2017-05-05 Zhang Yizhi Jing Jing Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
38434 38434 2010-12-15 2006-06-29 Davies Paul Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
38436 38436 2010-12-15 2009-12-16 Schmitz Michael E. Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
39098 39098 2012-12-24 2008-07-08 Tein Andrew Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
39465 39465 2019-12-30 1991-11-19 Coyle (Morris) Melissa D. Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 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])
);
Powered by Datasette · Queries took 637.918ms · 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