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

8 rows where City = "Burke"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

City 1

  • Burke · 8 ✖
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
72 72   2023-01-06 Dempsey Allison Hope Kurdish Protection Action Committee 7213 2023-01-06 Kurdish Protection Action Committee 6062 Burnside Landing Drive   Burke VA 22015
73 73   2023-01-06 Qanbar Entifadh Kamal Kurdish Protection Action Committee 7213 2023-01-06 Kurdish Protection Action Committee 6062 Burnside Landing Drive   Burke VA 22015
4627 4627 1989-01-27 1987-07-22 Campbell John G. John G. Campbell Consultants, Inc. 4015 1987-07-22 John G. Campbell Consultants, Inc. 9418 Wooded Glen Avenue   Burke VA 22015
6435 6435 2022-02-08 2018-05-08 Atef Ahmed Southern Transitional Council (US), Ltd. 6552 2018-05-08 Southern Transitional Council (US), Ltd. 6107 Harvester Court   Burke VA 22015
19019 19019 1994-06-07 1994-03-15 Campbell John G. John G. Campbell, Inc. 4903 1994-03-15 John G. Campbell, Inc. 9300-D Old Keene Mill Road   Burke VA 22015
21982 21982 2021-06-30 2018-05-08 Mused Abdulsalam K. Southern Transitional Council (US), Ltd. 6552 2018-05-08 Southern Transitional Council (US), Ltd. 6107 Harvester Court   Burke VA 22015
21983 21983 2021-06-30 2018-05-08 Muthana Ahmed A. Southern Transitional Council (US), Ltd. 6552 2018-05-08 Southern Transitional Council (US), Ltd. 6107 Harvester Court   Burke VA 22015
25319 25319 2018-07-31 2017-05-10 Lubin Marcus DLM Group, LLC 6428 2017-05-10 DLM Group, LLC 9616 Burke View Avenue   Burke VA 22015

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