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

11 rows where Registration_Number = 1302

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Last_Name, Short_Form_First_Name, Short_Form_Date (date)

These facets timed out: City

State 1

Registration_Number 1

  • Cohen & Aleshire, Inc. · 11 ✖

Registrant_Name 1

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
11356 11356 1960-03-31 1960-02-17 Dowd John C. Cohen & Aleshire, Inc. 1302 1959-12-03 Cohen & Aleshire, Inc. 41 East 42nd Street   New York NY  
18712 18712 1960-06-03 1960-02-17 Theodoli Filippo M. Cohen & Aleshire, Inc. 1302 1959-12-03 Cohen & Aleshire, Inc. 41 East 42nd Street   New York NY  
18721 18721 1960-06-03 1959-12-03 Aleshire Edward Cohen & Aleshire, Inc. 1302 1959-12-03 Cohen & Aleshire, Inc. 41 East 42nd Street   New York NY  
18722 18722 1960-06-03 1959-12-03 Cohen Harry B. , Jr. Cohen & Aleshire, Inc. 1302 1959-12-03 Cohen & Aleshire, Inc. 41 East 42nd Street   New York NY  
18723 18723 1960-06-03 1959-12-03 Cohen Harry B. , Sr. Cohen & Aleshire, Inc. 1302 1959-12-03 Cohen & Aleshire, Inc. 41 East 42nd Street   New York NY  
18724 18724 1960-06-03 1959-12-03 Fileppo Oscar Cohen & Aleshire, Inc. 1302 1959-12-03 Cohen & Aleshire, Inc. 41 East 42nd Street   New York NY  
18725 18725 1960-06-03 1959-12-03 Irwin William Cohen & Aleshire, Inc. 1302 1959-12-03 Cohen & Aleshire, Inc. 41 East 42nd Street   New York NY  
18726 18726 1960-06-03 1959-12-03 Ludwig Walreth Cohen & Aleshire, Inc. 1302 1959-12-03 Cohen & Aleshire, Inc. 41 East 42nd Street   New York NY  
18727 18727 1960-06-03 1959-12-03 Miller Richard Cohen & Aleshire, Inc. 1302 1959-12-03 Cohen & Aleshire, Inc. 41 East 42nd Street   New York NY  
18728 18728 1960-06-03 1959-12-03 Muller Richard Cohen & Aleshire, Inc. 1302 1959-12-03 Cohen & Aleshire, Inc. 41 East 42nd Street   New York NY  
18729 18729 1960-06-03 1959-12-03 Pellegrino Thomas John Cohen & Aleshire, Inc. 1302 1959-12-03 Cohen & Aleshire, Inc. 41 East 42nd Street   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])
);