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

12 rows where Registration_Number = 628

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: Registrant_Name

State 1

  • NY 12

Registration_Number 1

  • Selvage & Lee, Inc. · 12 ✖

City 1

  • New York 12
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
4880 4880 1955-01-31 1953-01-15 Chase William Howard Selvage & Lee, Inc. 628 1950-06-19 Selvage & Lee, Inc. 500 Fifth Avenue   New York NY  
20638 20638 1951-06-30 1950-06-19 Jack William H. Selvage & Lee, Inc. 628 1950-06-19 Selvage & Lee, Inc. 500 Fifth Avenue   New York NY  
20693 20693 1958-06-30 1957-12-16 Wright J. Handly Selvage & Lee, Inc. 628 1950-06-19 Selvage & Lee, Inc. 500 Fifth Avenue   New York NY  
20701 20701 1960-06-30 1958-03-27 Green Winfield Rush Selvage & Lee, Inc. 628 1950-06-19 Selvage & Lee, Inc. 500 Fifth Avenue   New York NY  
20703 20703 1960-06-30 1950-06-19 Bledsoe Samuel B. Selvage & Lee, Inc. 628 1950-06-19 Selvage & Lee, Inc. 500 Fifth Avenue   New York NY  
20704 20704 1960-06-30 1950-06-19 Lee Morris M. , Jr. Selvage & Lee, Inc. 628 1950-06-19 Selvage & Lee, Inc. 500 Fifth Avenue   New York NY  
20705 20705 1960-06-30 1950-06-19 Selvage James P. Selvage & Lee, Inc. 628 1950-06-19 Selvage & Lee, Inc. 500 Fifth Avenue   New York NY  
20712 20712 1960-06-30 1958-12-08 Cope James Selvage & Lee, Inc. 628 1950-06-19 Selvage & Lee, Inc. 500 Fifth Avenue   New York NY  
20713 20713 1960-06-30 1957-12-16 Hewens Francis E. Selvage & Lee, Inc. 628 1950-06-19 Selvage & Lee, Inc. 500 Fifth Avenue   New York NY  
20714 20714 1960-06-30 1957-12-16 Little Stuart Selvage & Lee, Inc. 628 1950-06-19 Selvage & Lee, Inc. 500 Fifth Avenue   New York NY  
20715 20715 1960-06-30 1957-12-16 Selvage J. Preston , Jr. Selvage & Lee, Inc. 628 1950-06-19 Selvage & Lee, Inc. 500 Fifth Avenue   New York NY  
20716 20716 1960-06-30 1957-12-16 Turner Leo J. Selvage & Lee, Inc. 628 1950-06-19 Selvage & Lee, Inc. 500 Fifth Avenue   New York NY  

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