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: Address_1, Zip, Short_Form_Termination_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
3570 3570 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
3613 3613 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
3934 3934 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
3935 3935 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
3936 3936 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
3937 3937 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
4332 4332 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
4593 4593 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  
4718 4718 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  
4719 4719 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  
4720 4720 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  
4721 4721 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  
4722 4722 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  
4723 4723 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  
4724 4724 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  
4725 4725 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  
4726 4726 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  
4746 4746 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
4747 4747 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
4748 4748 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
4749 4749 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
4750 4750 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
5669 5669 1971-02-01 1960-04-18 Sega Milan Sega, Milan 1212 1959-03-23 Sega, Milan 1445 East 40th Street   Cleveland OH 44103
5785 5785 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
6096 6096 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
6097 6097 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
6098 6098 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
7468 7468 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
9069 9069 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  
9462 9462 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  
9463 9463 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  
14038 14038 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
15764 15764 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  
16289 16289 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  
16290 16290 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  
16291 16291 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  
16292 16292 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  
16293 16293 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  
16294 16294 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  
16295 16295 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  
16417 16417 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
16418 16418 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
16420 16420 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
17339 17339 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
17471 17471 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
17890 17890 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
18462 18462 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
23041 23041 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
23042 23042 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
23096 23096 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
23098 23098 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
23601 23601 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
26255 26255 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
26523 26523 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
27761 27761 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
28893 28893 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
30063 30063 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
31047 31047 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
32446 32446 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
34696 34696 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
35013 35013 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
37380 37380 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
37382 37382 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
37965 37965 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
40611 40611 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])
);