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

29 rows where City = "Cleveland"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_Last_Name, Registration_Date, Address_1, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

Registration_Number 7

  • Circle of the Croatian Knights 11
  • Central Council of Croation Associations - U.S. & Canada 7
  • Pannonia Enterprises, Inc. 4
  • Pannonia Enterprises, Inc. 3
  • International Merchandising Corporation 2
  • Radich, Ethel P. 1
  • Sega, Milan 1

Registrant_Name 6

  • Circle of the Croatian Knights 11
  • Central Council of Croation Associations - U.S. & Canada 7
  • Pannonia Enterprises, Inc. 7
  • International Merchandising Corporation 2
  • Radich, Ethel P. 1
  • Sega, Milan 1

State 1

  • OH 29

City 1

  • Cleveland · 29 ✖
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
3946 3946 1972-01-17 1970-12-03 Billings Lenke Pannonia Enterprises, Inc. 2227 1970-12-03 Pannonia Enterprises, Inc. 1736 East 22nd Street   Cleveland OH 44114
3947 3947 1972-01-17 1970-12-03 Cher Frank J. Pannonia Enterprises, Inc. 2227 1970-12-03 Pannonia Enterprises, Inc. 1736 East 22nd Street   Cleveland OH 44114
3948 3948 1972-01-17 1970-12-03 Gombos Zoltan Pannonia Enterprises, Inc. 2227 1970-12-03 Pannonia Enterprises, Inc. 1736 East 22nd Street   Cleveland OH 44114
3949 3949 1972-01-17 1970-12-03 Kovachy Edward M. Pannonia Enterprises, Inc. 2227 1970-12-03 Pannonia Enterprises, Inc. 1736 East 22nd Street   Cleveland OH 44114
4730 4730 1956-01-29 1955-03-09 Crnicki Stefan Circle of the Croatian Knights 878 1955-03-09 Circle of the Croatian Knights Post Office Box 6071   Cleveland OH  
4731 4731 1956-01-29 1955-03-09 Erich Rudolph Alexander Circle of the Croatian Knights 878 1955-03-09 Circle of the Croatian Knights Post Office Box 6071   Cleveland OH  
4732 4732 1956-01-29 1955-03-09 Miljak Ivan Circle of the Croatian Knights 878 1955-03-09 Circle of the Croatian Knights Post Office Box 6071   Cleveland OH  
4733 4733 1956-01-29 1955-03-09 Sega Ing Milan Circle of the Croatian Knights 878 1955-03-09 Circle of the Croatian Knights Post Office Box 6071   Cleveland OH  
4734 4734 1956-01-29 1955-03-09 Sudec Ing Eduard Circle of the Croatian Knights 878 1955-03-09 Circle of the Croatian Knights Post Office Box 6071   Cleveland OH  
4735 4735 1956-01-29 1955-03-09 Yalsic Imbro Circle of the Croatian Knights 878 1955-03-09 Circle of the Croatian Knights Post Office Box 6071   Cleveland OH  
4736 4736 1956-01-29 1955-03-09 Yelic Pasko Circle of the Croatian Knights 878 1955-03-09 Circle of the Croatian Knights Post Office Box 6071   Cleveland OH  
4737 4737 1956-01-29 1955-07-05 Coric Ivan Circle of the Croatian Knights 878 1955-03-09 Circle of the Croatian Knights Post Office Box 6071   Cleveland OH  
4738 4738 1956-01-29 1955-07-05 Duerr Vinko Circle of the Croatian Knights 878 1955-03-09 Circle of the Croatian Knights Post Office Box 6071   Cleveland OH  
5682 5682 1971-02-01 1960-04-18 Sega Milan Sega, Milan 1212 1959-03-23 Sega, Milan 1445 East 40th Street   Cleveland OH 44103
6109 6109 1976-02-04 1974-04-04 Kovachy Edward M. Pannonia Enterprises, Inc. 2456 1973-09-04 Pannonia Enterprises, Inc. 1736 East 22nd Street   Cleveland OH 44114
6110 6110 1976-02-04 1973-09-04 Billings Lenke Pannonia Enterprises, Inc. 2456 1973-09-04 Pannonia Enterprises, Inc. 1736 East 22nd Street   Cleveland OH 44114
6111 6111 1976-02-04 1973-09-04 Gombos Zoltan Pannonia Enterprises, Inc. 2456 1973-09-04 Pannonia Enterprises, Inc. 1736 East 22nd Street   Cleveland OH 44114
9475 9475 1955-03-09 1956-02-28 Horvatinovitch John Circle of the Croatian Knights 878 1955-03-09 Circle of the Croatian Knights Post Office Box 6071   Cleveland OH  
9476 9476 1955-03-09 1955-07-05 Pavicich Anthony D. Circle of the Croatian Knights 878 1955-03-09 Circle of the Croatian Knights Post Office Box 6071   Cleveland OH  
15781 15781 1960-05-06 1956-10-12 Radich Ethel P. Radich, Ethel P. 979 1956-10-12 Radich, Ethel P. 1899 West 25th Street   Cleveland OH  
16306 16306 1959-05-14 1959-03-23 Badrow Peter Central Council of Croation Associations - U.S. & Canada 1180 1958-10-06 Central Council of Croation Associations - U.S. & Canada 5703 Dibble Avenue   Cleveland OH  
16307 16307 1959-05-14 1959-03-23 Hukarevic Saban Central Council of Croation Associations - U.S. & Canada 1180 1958-10-06 Central Council of Croation Associations - U.S. & Canada 5703 Dibble Avenue   Cleveland OH  
16308 16308 1959-05-14 1959-03-23 Pavicich Anthony Central Council of Croation Associations - U.S. & Canada 1180 1958-10-06 Central Council of Croation Associations - U.S. & Canada 5703 Dibble Avenue   Cleveland OH  
16309 16309 1959-05-14 1959-03-23 Yelich Pasko Central Council of Croation Associations - U.S. & Canada 1180 1958-10-06 Central Council of Croation Associations - U.S. & Canada 5703 Dibble Avenue   Cleveland OH  
16310 16310 1959-05-14 1959-03-23 Zukic Ragib Central Council of Croation Associations - U.S. & Canada 1180 1958-10-06 Central Council of Croation Associations - U.S. & Canada 5703 Dibble Avenue   Cleveland OH  
16311 16311 1959-05-14 1958-10-06 Sega Milan Central Council of Croation Associations - U.S. & Canada 1180 1958-10-06 Central Council of Croation Associations - U.S. & Canada 5703 Dibble Avenue   Cleveland OH  
16312 16312 1959-05-14 1958-10-06 Srnec Marijan Central Council of Croation Associations - U.S. & Canada 1180 1958-10-06 Central Council of Croation Associations - U.S. & Canada 5703 Dibble Avenue   Cleveland OH  
34718 34718 2018-10-31 2017-05-31 Mellin Carolyn International Merchandising Corporation 6032 2011-04-14 International Merchandising Corporation 1360 East 9th Street Suite 100 Cleveland OH 44114
35035 35035 2016-11-01 2011-04-14 Shapard W. Allen International Merchandising Corporation 6032 2011-04-14 International Merchandising Corporation 1360 East 9th Street Suite 100 Cleveland OH 44114

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