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

10 rows where Registration_Number = 6172

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Registration_Date (date)

State 1

  • DC 10

Registration_Number 1

  • Peck, Madigan, Jones & Stewart, Inc. · 10 ✖

Registrant_Name 1

  • Peck, Madigan, Jones & Stewart, Inc. 10

City 1

  • Washington 10
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
8302 8302 2017-02-28 2017-01-27 Heimbach James T. Peck, Madigan, Jones & Stewart, Inc. 6172 2013-06-10 Peck, Madigan, Jones & Stewart, Inc. 1300 Connecticut Avenue, NW Suite 600 Washington DC 20036
8306 8306 2017-02-28 2013-06-10 Gonzalez John Michael Peck, Madigan, Jones & Stewart, Inc. 6172 2013-06-10 Peck, Madigan, Jones & Stewart, Inc. 1300 Connecticut Avenue, NW Suite 600 Washington DC 20036
8307 8307 2017-02-28 2013-06-10 Jones Joseph Jonathon Peck, Madigan, Jones & Stewart, Inc. 6172 2013-06-10 Peck, Madigan, Jones & Stewart, Inc. 1300 Connecticut Avenue, NW Suite 600 Washington DC 20036
8308 8308 2017-02-28 2013-06-10 Madigan Peter T. Peck, Madigan, Jones & Stewart, Inc. 6172 2013-06-10 Peck, Madigan, Jones & Stewart, Inc. 1300 Connecticut Avenue, NW Suite 600 Washington DC 20036
8309 8309 2017-02-28 2013-06-10 Shapiro Jeffrey A. Peck, Madigan, Jones & Stewart, Inc. 6172 2013-06-10 Peck, Madigan, Jones & Stewart, Inc. 1300 Connecticut Avenue, NW Suite 600 Washington DC 20036
8318 8318 2017-02-28 2014-10-27 Olson Jennifer Smith Peck, Madigan, Jones & Stewart, Inc. 6172 2013-06-10 Peck, Madigan, Jones & Stewart, Inc. 1300 Connecticut Avenue, NW Suite 600 Washington DC 20036
18190 18190 2017-05-31 2013-06-10 Farrell Megan Peck, Madigan, Jones & Stewart, Inc. 6172 2013-06-10 Peck, Madigan, Jones & Stewart, Inc. 1300 Connecticut Avenue, NW Suite 600 Washington DC 20036
21841 21841 2015-06-30 2014-07-24 Cantor Andrew Peck, Madigan, Jones & Stewart, Inc. 6172 2013-06-10 Peck, Madigan, Jones & Stewart, Inc. 1300 Connecticut Avenue, NW Suite 600 Washington DC 20036
21842 21842 2015-06-30 2014-07-24 Murphy Sheila H. Peck, Madigan, Jones & Stewart, Inc. 6172 2013-06-10 Peck, Madigan, Jones & Stewart, Inc. 1300 Connecticut Avenue, NW Suite 600 Washington DC 20036
34672 34672 2016-10-31 2013-06-10 McCarthy Justin Peck, Madigan, Jones & Stewart, Inc. 6172 2013-06-10 Peck, Madigan, Jones & Stewart, Inc. 1300 Connecticut Avenue, NW Suite 600 Washington DC 20036

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 606.176ms · 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