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

65 rows where State = "OH"

✎ View and edit SQL

This data as json, CSV (advanced)

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

City 4

State 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
3582 3582 1995-01-11 1994-06-13 Bluemlein Jason Scott Oestreicher, Michael R. 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
3625 3625 1994-01-12 1993-05-26 Harrison Katrina Oestreicher, Michael R. 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
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
4344 4344 1990-01-24 1989-12-20 Shilleh Laila Oestreicher, Michael R. 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
4605 4605 1960-01-27 1959-10-16 Smith H. Hilman Provident Travel Service 1264 1959-08-31 Provident Travel Service Provident Bank 7th & Vine Streets Cincinnati OH  
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  
4758 4758 1993-01-29 1992-06-03 Abrams A. Jeffrey Samex Trading Company, Inc. 4680 1992-06-03 Samex Trading Company, Inc. 389 Library Park, South   Columbus OH 43215
4759 4759 1993-01-29 1992-06-03 Cushing Christopher T. Samex Trading Company, Inc. 4680 1992-06-03 Samex Trading Company, Inc. 389 Library Park, South   Columbus OH 43215
4760 4760 1993-01-29 1992-06-03 Degliomini Charles A. Samex Trading Company, Inc. 4680 1992-06-03 Samex Trading Company, Inc. 389 Library Park, South   Columbus OH 43215
4761 4761 1993-01-29 1992-06-03 Paul Joseph M. Samex Trading Company, Inc. 4680 1992-06-03 Samex Trading Company, Inc. 389 Library Park, South   Columbus OH 43215
4762 4762 1993-01-29 1992-06-03 Walsh Neil J. Samex Trading Company, Inc. 4680 1992-06-03 Samex Trading Company, Inc. 389 Library Park, South   Columbus OH 43215
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
5798 5798 1996-02-01 1995-06-19 Bursten Christopher L. Oestreicher, Michael R. 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
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
7481 7481 1998-02-23 1997-11-17 Collins Susan M. Oestreicher, Michael R. 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
9082 9082 1960-03-04 1959-09-04 Adams Andrew D. Brennan, Earl 1265 1959-09-04 Brennan, Earl Brock Electric Company 648 Kenmore Boulevard Akron OH  
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  
14052 14052 2000-04-24 1999-01-19 Long Kristin Oestreicher, Michael R. 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
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  
16434 16434 2001-05-15 1999-05-18 Gillespie Kelly Oestreicher, Michael R. 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
16435 16435 2001-05-15 2001-05-23 Kelley Kim Oestreicher, Michael R. 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
16437 16437 2001-05-15 2000-11-13 Hindman Marybeth Oestreicher, Michael R. 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
17356 17356 1996-05-29 1991-03-27 Prost Kenneth E. Oestreicher, Michael R. 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
17488 17488 2000-05-30 1999-08-18 Wuellner Thomas Oestreicher, Michael R. 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
17907 17907 1997-05-31 1996-11-26 Bosse Magan Oestreicher, Michael R. 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
18479 18479 1990-06-01 1990-03-07 Steins Scott Oestreicher, Michael R. 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
23062 23062 1994-07-13 1994-01-10 Mathis Deborah J. Oestreicher, Michael R. 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
23063 23063 1994-07-13 1994-02-28 Frick Dane C. Oestreicher, Michael R. 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
23117 23117 1993-07-14 1993-03-17 Brockman David Oestreicher, Michael R. 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
23119 23119 1993-07-14 1993-05-20 Kunzelman Lori A. Oestreicher, Michael R. 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
23622 23622 2000-07-19 2000-06-28 Kiser Kimberly Oestreicher, Michael R. 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
26277 26277 1997-08-08 1997-06-11 Perkins Alexander L. Oestreicher, Michael R. 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
26545 26545 1999-08-13 1999-02-17 Watson Clint Oestreicher, Michael R. 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
27783 27783 1996-08-30 1996-05-08 Kneisel Laura P. Oestreicher, Michael R. 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
28915 28915 1998-09-01 1998-03-04 Jaeger Carrie Oestreicher, Michael R. 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
30085 30085 1995-09-19 1995-09-19 Pashi Lumana Parti Lumumbiste Unifie (PALU) 5052 1995-09-19 Parti Lumumbiste Unifie (PALU) Representation U.S.A. Post Office Box 19873 Cincinnati OH 45219
31069 31069 1991-09-30 1991-07-10 Dames Michael Oestreicher, Michael R. 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
32468 32468 1999-10-08 1999-05-25 McGonagle Megan Oestreicher, Michael R. 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
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
37402 37402 1989-12-01 1989-02-16 Antony John P. Oestreicher, Michael R. 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
37404 37404 1989-12-01 1989-06-21 Norvell Sandra Oestreicher, Michael R. 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
37987 37987 1999-12-09 1999-10-26 Krcmarich Ryan Oestreicher, Michael R. 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
40633 40633 1990-12-31 1990-06-20 Stercz Joseph Reinhold Oestreicher, Michael R. 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202

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