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

39 rows where Registrant_Name = "Washington Group"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registration_Number 2

  • Washington Group 24
  • Washington Group 15

State 1

  • DC 39

Registrant_Name 1

  • Washington Group · 39 ✖

City 1

  • Washington 39
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
3823 3823 2006-01-15 2005-09-30 Raffaelli John D. Washington Group 5711 2005-09-30 Washington Group 1401 K Street, NW Suite 1000 Washington DC 20005-3422
5366 5366 2006-01-31 2005-09-30 Crane David Washington Group 5711 2005-09-30 Washington Group 1401 K Street, NW Suite 1000 Washington DC 20005-3422
5392 5392 2007-01-31 2005-09-30 Marken Anthony Washington Group 5711 2005-09-30 Washington Group 1401 K Street, NW Suite 1000 Washington DC 20005-3422
5393 5393 2007-01-31 2005-09-30 Sullivan Richard Washington Group 5711 2005-09-30 Washington Group 1401 K Street, NW Suite 1000 Washington DC 20005-3422
5799 5799 1996-02-01 1991-10-02 Spees Richard L. Washington Group 4332 1990-01-18 Washington Group 1401 K Street, N.W. Suite 400 Washington DC 20005
7786 7786 1990-02-27 1990-02-23 Fielek Henrietta Stella Washington Group 4332 1990-01-18 Washington Group 1401 K Street, N.W. Suite 400 Washington DC 20005
7988 7988 1992-02-28 1990-02-06 Copeland James M. , Jr. Washington Group 4332 1990-01-18 Washington Group 1401 K Street, N.W. Suite 400 Washington DC 20005
9067 9067 2008-03-03 2007-06-05 Boyd Moses Washington Group 5711 2005-09-30 Washington Group 1401 K Street, NW Suite 1000 Washington DC 20005-3422
12034 12034 2009-03-31 2008-02-25 O'Hanlon John Washington Group 5711 2005-09-30 Washington Group 1401 K Street, NW Suite 1000 Washington DC 20005-3422
12049 12049 2009-03-31 2005-09-30 Allen Kevin D. Washington Group 5711 2005-09-30 Washington Group 1401 K Street, NW Suite 1000 Washington DC 20005-3422
12050 12050 2009-03-31 2005-09-30 Edwards Melissa Washington Group 5711 2005-09-30 Washington Group 1401 K Street, NW Suite 1000 Washington DC 20005-3422
12051 12051 2009-03-31 2005-09-30 Farmer Kimberley Washington Group 5711 2005-09-30 Washington Group 1401 K Street, NW Suite 1000 Washington DC 20005-3422
12052 12052 2009-03-31 2005-09-30 Lobo Paul Washington Group 5711 2005-09-30 Washington Group 1401 K Street, NW Suite 1000 Washington DC 20005-3422
12053 12053 2009-03-31 2005-09-30 Noone James Washington Group 5711 2005-09-30 Washington Group 1401 K Street, NW Suite 1000 Washington DC 20005-3422
12054 12054 2009-03-31 2005-09-30 Saunders (Speed) Tonya Washington Group 5711 2005-09-30 Washington Group 1401 K Street, NW Suite 1000 Washington DC 20005-3422
12055 12055 2009-03-31 2005-09-30 West Fowler Washington Group 5711 2005-09-30 Washington Group 1401 K Street, NW Suite 1000 Washington DC 20005-3422
24876 24876 1996-07-31 1995-02-28 Rogers Edwina Washington Group 4332 1990-01-18 Washington Group 1401 K Street, N.W. Suite 400 Washington DC 20005
24882 24882 1996-07-31 1991-10-02 Smith G. Wayne Washington Group 4332 1990-01-18 Washington Group 1401 K Street, N.W. Suite 400 Washington DC 20005
26463 26463 2006-08-11 2005-09-30 Gilbert Meredith Washington Group 5711 2005-09-30 Washington Group 1401 K Street, NW Suite 1000 Washington DC 20005-3422
31414 31414 2008-09-30 2005-09-30 Mitrovich Marissa Washington Group 5711 2005-09-30 Washington Group 1401 K Street, NW Suite 1000 Washington DC 20005-3422
31415 31415 2008-09-30 2005-09-30 Molinari Susan Washington Group 5711 2005-09-30 Washington Group 1401 K Street, NW Suite 1000 Washington DC 20005-3422
32711 32711 2007-10-12 2005-09-30 Sporidis Harry Washington Group 5711 2005-09-30 Washington Group 1401 K Street, NW Suite 1000 Washington DC 20005-3422
34091 34091 2006-10-30 2005-09-30 Karalekas Steven (Spike) Washington Group 5711 2005-09-30 Washington Group 1401 K Street, NW Suite 1000 Washington DC 20005-3422
35105 35105 1990-11-02 1990-03-07 Allison Edward E. Washington Group 4332 1990-01-18 Washington Group 1401 K Street, N.W. Suite 400 Washington DC 20005
35599 35599 2008-11-10 2005-09-30 Patrone III Eugene F. Washington Group 5711 2005-09-30 Washington Group 1401 K Street, NW Suite 1000 Washington DC 20005-3422
35628 35628 2008-11-11 2007-04-16 Shogren Brett Allen Washington Group 5711 2005-09-30 Washington Group 1401 K Street, NW Suite 1000 Washington DC 20005-3422
35630 35630 2008-11-11 2005-09-30 Bonilla Carlos Washington Group 5711 2005-09-30 Washington Group 1401 K Street, NW Suite 1000 Washington DC 20005-3422
39444 39444 2006-12-30 2005-09-30 Burke William Washington Group 5711 2005-09-30 Washington Group 1401 K Street, NW Suite 1000 Washington DC 20005-3422
40602 40602 1990-12-31 1990-01-18 Halsey Steven Craig Washington Group 4332 1990-01-18 Washington Group 1401 K Street, N.W. Suite 400 Washington DC 20005
41069 41069 1998-12-31 1990-01-18 Raffaelli John D. Washington Group 4332 1990-01-18 Washington Group 1401 K Street, N.W. Suite 400 Washington DC 20005
41071 41071 1998-12-31 1994-01-25 O'Hanlon G. John Washington Group 4332 1990-01-18 Washington Group 1401 K Street, N.W. Suite 400 Washington DC 20005
41072 41072 1998-12-31 1994-01-25 Saunders Tonya Washington Group 4332 1990-01-18 Washington Group 1401 K Street, N.W. Suite 400 Washington DC 20005
41073 41073 1998-12-31 1994-01-25 Springer David E. Washington Group 4332 1990-01-18 Washington Group 1401 K Street, N.W. Suite 400 Washington DC 20005
41081 41081 1998-12-31 1994-04-08 Reed Morgan William , III Washington Group 4332 1990-01-18 Washington Group 1401 K Street, N.W. Suite 400 Washington DC 20005
41101 41101 1998-12-31 1994-08-10 Allen Kevin D. Washington Group 4332 1990-01-18 Washington Group 1401 K Street, N.W. Suite 400 Washington DC 20005
41109 41109 1998-12-31 1998-10-09 Blount John Washington Group 4332 1990-01-18 Washington Group 1401 K Street, N.W. Suite 400 Washington DC 20005
41110 41110 1998-12-31 1998-10-09 Lewis Rita M. Washington Group 4332 1990-01-18 Washington Group 1401 K Street, N.W. Suite 400 Washington DC 20005
41497 41497 2006-12-31 2006-04-25 Kulkarni Kathy Washington Group 5711 2005-09-30 Washington Group 1401 K Street, NW Suite 1000 Washington DC 20005-3422
41577 41577 2007-12-31 2005-09-30 Lewis Rita M. Washington Group 5711 2005-09-30 Washington Group 1401 K Street, NW Suite 1000 Washington DC 20005-3422

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