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

11 rows where Registration_Number = 5188

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • NY 11

Registration_Number 1

  • Dilenschneider Group · 11 ✖

Registrant_Name 1

  • Dilenschneider Group 11

City 1

  • New York 11
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
22261 22261 1997-07-01 1997-06-27 Borough David L. Dilenschneider Group 5188 1997-06-27 Dilenschneider Group 200 Park Avenue 26th Floor New York NY 10166
22262 22262 1997-07-01 1997-06-27 Brophy Charles G. Dilenschneider Group 5188 1997-06-27 Dilenschneider Group 200 Park Avenue 26th Floor New York NY 10166
22263 22263 1997-07-01 1997-06-27 Connelly Kathleen F. Dilenschneider Group 5188 1997-06-27 Dilenschneider Group 200 Park Avenue 26th Floor New York NY 10166
22264 22264 1997-07-01 1997-06-27 Dedmon Jonathan Emmett Dilenschneider Group 5188 1997-06-27 Dilenschneider Group 200 Park Avenue 26th Floor New York NY 10166
22265 22265 1997-07-01 1997-06-27 Dilenschneider Robert L. Dilenschneider Group 5188 1997-06-27 Dilenschneider Group 200 Park Avenue 26th Floor New York NY 10166
22266 22266 1997-07-01 1997-06-27 Kelley Shila S. Dilenschneider Group 5188 1997-06-27 Dilenschneider Group 200 Park Avenue 26th Floor New York NY 10166
22267 22267 1997-07-01 1997-06-27 Komendantov Andrew Dilenschneider Group 5188 1997-06-27 Dilenschneider Group 200 Park Avenue 26th Floor New York NY 10166
22268 22268 1997-07-01 1997-06-27 Kosmicki Richard J. Dilenschneider Group 5188 1997-06-27 Dilenschneider Group 200 Park Avenue 26th Floor New York NY 10166
22269 22269 1997-07-01 1997-06-27 Lucznikowska Valerie Dilenschneider Group 5188 1997-06-27 Dilenschneider Group 200 Park Avenue 26th Floor New York NY 10166
22270 22270 1997-07-01 1997-06-27 Rosenthal James Edward Dilenschneider Group 5188 1997-06-27 Dilenschneider Group 200 Park Avenue 26th Floor New York NY 10166
22271 22271 1997-07-01 1997-06-27 Wentz R.A. Dilenschneider Group 5188 1997-06-27 Dilenschneider Group 200 Park Avenue 26th Floor New York NY 10166

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