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

24 rows where Registrant_Name = "Washington Group", Registration_Number = 5711 and State = "DC"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • Washington Group · 24 ✖

Registrant_Name 1

  • Washington Group · 24 ✖

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