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

17 rows where Registrant_Name = "Globe Travel Service"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 2

Registration_Number 2

City 2

Registrant_Name 1

  • Globe Travel Service · 17 ✖
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
10546 10546 1960-03-23 1948-02-16 Bellia Harry J. Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10547 10547 1960-03-23 1948-02-16 Freedman David Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10548 10548 1960-03-23 1948-02-16 Rifkin Maurice Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10549 10549 1960-03-23 1958-03-20 Kachnykewych Taras Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10550 10550 1960-03-23 1958-04-16 Freedman Jean Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10551 10551 1960-03-23 1958-04-16 Rifkin Lillian Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10552 10552 1960-03-23 1958-04-16 Rohatynskyj Peter Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10553 10553 1960-03-23 1958-04-16 Rosenberg Israel Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10554 10554 1960-03-23 1957-06-24 Adomonis John Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10555 10555 1960-03-23 1957-06-24 Biloskursky Mike Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10556 10556 1960-03-23 1957-06-24 Juodvalkis Anastasia Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10557 10557 1960-03-23 1957-06-24 Juodvalkis S.P. Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10558 10558 1960-03-23 1957-06-24 Kuczewski Thaddeus Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10559 10559 1960-03-23 1957-06-24 Lyons Norman Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
20063 20063 1960-06-23 1958-09-04 Fruehauf Marianne G. Globe Travel Service 1075 1957-10-30 Globe Travel Service 127 North Dearborn Street   Chicago IL  
20064 20064 1960-06-23 1958-09-04 Lanctot Raymond G. Globe Travel Service 1075 1957-10-30 Globe Travel Service 127 North Dearborn Street   Chicago IL  
39635 39635 1957-12-31 1957-10-30 Fruehauf Walter A. Globe Travel Service 1075 1957-10-30 Globe Travel Service 127 North Dearborn Street   Chicago IL  

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