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

8 rows where Registration_Number = 1246

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_First_Name, Short_Form_Termination_Date (date)

State 1

Registration_Number 1

  • Cosmos Parcels Express Corp./Rumanian Export Parcels Corp. · 8 ✖

City 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
8663 8663 1969-03-01 1959-07-10 Reiner Sidney Cosmos Parcels Express Corp./Rumanian Export Parcels Corp. 1246 1959-07-10 Cosmos Parcels Express Corp./Rumanian Export Parcels Corp. 40 East 49th Street   New York NY 10017
12399 12399 1969-04-01 1962-11-07 Caplan Julius Cosmos Parcels Express Corp./Rumanian Export Parcels Corp. 1246 1959-07-10 Cosmos Parcels Express Corp./Rumanian Export Parcels Corp. 40 East 49th Street   New York NY 10017
14035 14035 1987-04-24 1959-07-10 Reiner Gabriel Cosmos Parcels Express Corp./Rumanian Export Parcels Corp. 1246 1959-07-10 Cosmos Parcels Express Corp./Rumanian Export Parcels Corp. 40 East 49th Street   New York NY 10017
14036 14036 1987-04-24 1973-09-02 Richmond Curt Cosmos Parcels Express Corp./Rumanian Export Parcels Corp. 1246 1959-07-10 Cosmos Parcels Express Corp./Rumanian Export Parcels Corp. 40 East 49th Street   New York NY 10017
14037 14037 1987-04-24 1974-09-21 Reiner Carol Cosmos Parcels Express Corp./Rumanian Export Parcels Corp. 1246 1959-07-10 Cosmos Parcels Express Corp./Rumanian Export Parcels Corp. 40 East 49th Street   New York NY 10017
15303 15303 1960-05-01 1959-07-10 Hildebrandt David Cosmos Parcels Express Corp./Rumanian Export Parcels Corp. 1246 1959-07-10 Cosmos Parcels Express Corp./Rumanian Export Parcels Corp. 40 East 49th Street   New York NY 10017
30113 30113 1974-09-20 1969-05-21 Reiner Carol Cosmos Parcels Express Corp./Rumanian Export Parcels Corp. 1246 1959-07-10 Cosmos Parcels Express Corp./Rumanian Export Parcels Corp. 40 East 49th Street   New York NY 10017
36038 36038 1959-11-19 1959-07-10 Eisenman David Cosmos Parcels Express Corp./Rumanian Export Parcels Corp. 1246 1959-07-10 Cosmos Parcels Express Corp./Rumanian Export Parcels Corp. 40 East 49th Street   New York NY 10017

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])
);