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

18 rows where City = "Chevy Chase" and State = "MD"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registration_Number 9

  • Rock Creek Strategic Marketing 6
  • Merex Corporation 4
  • Office of the Nagorno Karabakh Republic in the USA 2
  • DSR International, Inc. 1
  • I.S.I. Enterprises, Inc. 1
  • CMS Strategies, LLC 1
  • Washington Strategy Group 1
  • Barnett, John 1
  • Neale Creek, LLC 1

Registrant_Name 9

  • Rock Creek Strategic Marketing 6
  • Merex Corporation 4
  • Office of the Nagorno Karabakh Republic in the USA 2
  • Barnett, John 1
  • CMS Strategies, LLC 1
  • DSR International, Inc. 1
  • I.S.I. Enterprises, Inc. 1
  • Neale Creek, LLC 1
  • Washington Strategy Group 1

State 1

  • MD · 18 ✖

City 1

  • Chevy Chase · 18 ✖
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
1732 1732   2019-09-06 King Andrew N. Neale Creek, LLC 6723 2019-09-06 Neale Creek, LLC 11 E Lenox Street   Chevy Chase MD 20815
2476 2476   2008-12-29 Avetisyan Robert Office of the Nagorno Karabakh Republic in the USA 5342 1999-11-12 Office of the Nagorno Karabakh Republic in the USA 4701 Willard Avenue #1407 Chevy Chase MD 20815
4198 4198 1971-01-21 1970-08-10 Huber Helmut Merex Corporation 2183 1970-01-21 Merex Corporation 5454 Wisconsin Avenue Suite 1660 Chevy Chase MD 20015
4845 4845 2008-01-30 2007-01-25 Johnson Margaret Rock Creek Strategic Marketing 5787 2007-01-25 Rock Creek Strategic Marketing 2 Wisconsin Circle Suite 1010 Chevy Chase MD 20815
4846 4846 2008-01-30 2007-01-25 Johnson Scott Rock Creek Strategic Marketing 5787 2007-01-25 Rock Creek Strategic Marketing 2 Wisconsin Circle Suite 1010 Chevy Chase MD 20815
4847 4847 2008-01-30 2007-01-25 Lester Chris Rock Creek Strategic Marketing 5787 2007-01-25 Rock Creek Strategic Marketing 2 Wisconsin Circle Suite 1010 Chevy Chase MD 20815
4848 4848 2008-01-30 2007-01-25 Richmond Jessica Rock Creek Strategic Marketing 5787 2007-01-25 Rock Creek Strategic Marketing 2 Wisconsin Circle Suite 1010 Chevy Chase MD 20815
4849 4849 2008-01-30 2007-01-25 Ward Paul Rock Creek Strategic Marketing 5787 2007-01-25 Rock Creek Strategic Marketing 2 Wisconsin Circle Suite 1010 Chevy Chase MD 20815
6788 6788 1971-02-14 1970-09-16 Amity Richard F. Merex Corporation 2183 1970-01-21 Merex Corporation 5454 Wisconsin Avenue Suite 1660 Chevy Chase MD 20015
8423 8423 2022-02-28 2019-02-12 Barnett John Barnett, John 6637 2019-02-12 Barnett, John 3210 Woodhollow Drive   Chevy Chase MD 20815
13323 13323 1993-04-14 1990-07-16 Ledeen Michael A. I.S.I. Enterprises, Inc. 4399 1990-07-16 I.S.I. Enterprises, Inc. 7312 Western Avenue   Chevy Chase MD 20815
14388 14388 2020-04-29 2016-08-04 Rubin Joel Washington Strategy Group 6365 2016-08-04 Washington Strategy Group 4401 Walsh Street   Chevy Chase MD 20815
18818 18818 1980-06-04 1979-11-28 Cloherty Margaret Lee DSR International, Inc. 3068 1979-11-15 DSR International, Inc. 3911 Bradley Lane   Chevy Chase MD 20015
19076 19076 2007-06-08 2007-01-25 Pachner Dharma Rock Creek Strategic Marketing 5787 2007-01-25 Rock Creek Strategic Marketing 2 Wisconsin Circle Suite 1010 Chevy Chase MD 20815
29469 29469 1970-09-09 1970-01-21 Bauch Gerhard Merex Corporation 2183 1970-01-21 Merex Corporation 5454 Wisconsin Avenue Suite 1660 Chevy Chase MD 20015
29470 29470 1970-09-09 1970-02-24 Laurisch Guenter Merex Corporation 2183 1970-01-21 Merex Corporation 5454 Wisconsin Avenue Suite 1660 Chevy Chase MD 20015
34640 34640 2011-10-31 2006-12-12 Stefadouros Chrysoula CMS Strategies, LLC 5766 2006-09-12 CMS Strategies, LLC 5500 Friendship Boulevard #1511N Chevy Chase MD 20815
36997 36997 2008-11-30 1999-11-12 Barseghyan Vardan Office of the Nagorno Karabakh Republic in the USA 5342 1999-11-12 Office of the Nagorno Karabakh Republic in the USA 4701 Willard Avenue #1407 Chevy Chase MD 20815

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