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

65 rows where State = "OH"

View and edit SQL

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

Registration_Number

State

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
3381 1995-01-11 1994-06-13 Bluemlein Jason Scott 3426 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
3417 1994-01-12 1993-05-26 Harrison Katrina 3426 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
3693 1972-01-17 1970-12-03 Billings Lenke 2227 2227 1970-12-03 Pannonia Enterprises, Inc. 1736 East 22nd Street   Cleveland OH 44114
3694 1972-01-17 1970-12-03 Cher Frank J. 2227 2227 1970-12-03 Pannonia Enterprises, Inc. 1736 East 22nd Street   Cleveland OH 44114
3695 1972-01-17 1970-12-03 Gombos Zoltan 2227 2227 1970-12-03 Pannonia Enterprises, Inc. 1736 East 22nd Street   Cleveland OH 44114
3696 1972-01-17 1970-12-03 Kovachy Edward M. 2227 2227 1970-12-03 Pannonia Enterprises, Inc. 1736 East 22nd Street   Cleveland OH 44114
4074 1990-01-24 1989-12-20 Shilleh Laila 3426 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
4323 1960-01-27 1959-10-16 Smith H. Hilman 1264 1264 1959-08-31 Provident Travel Service Provident Bank 7th & Vine Streets Cincinnati OH  
4440 1956-01-29 1955-03-09 Crnicki Stefan 878 878 1955-03-09 Circle of the Croatian Knights Post Office Box 6071   Cleveland OH  
4441 1956-01-29 1955-03-09 Erich Rudolph Alexander 878 878 1955-03-09 Circle of the Croatian Knights Post Office Box 6071   Cleveland OH  
4442 1956-01-29 1955-03-09 Miljak Ivan 878 878 1955-03-09 Circle of the Croatian Knights Post Office Box 6071   Cleveland OH  
4443 1956-01-29 1955-03-09 Sega Ing Milan 878 878 1955-03-09 Circle of the Croatian Knights Post Office Box 6071   Cleveland OH  
4444 1956-01-29 1955-03-09 Sudec Ing Eduard 878 878 1955-03-09 Circle of the Croatian Knights Post Office Box 6071   Cleveland OH  
4445 1956-01-29 1955-03-09 Yalsic Imbro 878 878 1955-03-09 Circle of the Croatian Knights Post Office Box 6071   Cleveland OH  
4446 1956-01-29 1955-03-09 Yelic Pasko 878 878 1955-03-09 Circle of the Croatian Knights Post Office Box 6071   Cleveland OH  
4447 1956-01-29 1955-07-05 Coric Ivan 878 878 1955-03-09 Circle of the Croatian Knights Post Office Box 6071   Cleveland OH  
4448 1956-01-29 1955-07-05 Duerr Vinko 878 878 1955-03-09 Circle of the Croatian Knights Post Office Box 6071   Cleveland OH  
4468 1993-01-29 1992-06-03 Abrams A. Jeffrey 4680 4680 1992-06-03 Samex Trading Company, Inc. 389 Library Park, South   Columbus OH 43215
4469 1993-01-29 1992-06-03 Cushing Christopher T. 4680 4680 1992-06-03 Samex Trading Company, Inc. 389 Library Park, South   Columbus OH 43215
4470 1993-01-29 1992-06-03 Degliomini Charles A. 4680 4680 1992-06-03 Samex Trading Company, Inc. 389 Library Park, South   Columbus OH 43215
4471 1993-01-29 1992-06-03 Paul Joseph M. 4680 4680 1992-06-03 Samex Trading Company, Inc. 389 Library Park, South   Columbus OH 43215
4472 1993-01-29 1992-06-03 Walsh Neil J. 4680 4680 1992-06-03 Samex Trading Company, Inc. 389 Library Park, South   Columbus OH 43215
5321 1971-02-01 1960-04-18 Sega Milan 1212 1212 1959-03-23 Sega, Milan 1445 East 40th Street   Cleveland OH 44103
5437 1996-02-01 1995-06-19 Bursten Christopher L. 3426 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
5731 1976-02-04 1974-04-04 Kovachy Edward M. 2456 2456 1973-09-04 Pannonia Enterprises, Inc. 1736 East 22nd Street   Cleveland OH 44114
5732 1976-02-04 1973-09-04 Billings Lenke 2456 2456 1973-09-04 Pannonia Enterprises, Inc. 1736 East 22nd Street   Cleveland OH 44114
5733 1976-02-04 1973-09-04 Gombos Zoltan 2456 2456 1973-09-04 Pannonia Enterprises, Inc. 1736 East 22nd Street   Cleveland OH 44114
6987 1998-02-23 1997-11-17 Collins Susan M. 3426 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
8436 1960-03-04 1959-09-04 Adams Andrew D. 1265 1265 1959-09-04 Brennan, Earl Brock Electric Company 648 Kenmore Boulevard Akron OH  
8808 1955-03-09 1956-02-28 Horvatinovitch John 878 878 1955-03-09 Circle of the Croatian Knights Post Office Box 6071   Cleveland OH  
8809 1955-03-09 1955-07-05 Pavicich Anthony D. 878 878 1955-03-09 Circle of the Croatian Knights Post Office Box 6071   Cleveland OH  
13114 2000-04-24 1999-01-19 Long Kristin 3426 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
14639 1960-05-06 1956-10-12 Radich Ethel P. 979 979 1956-10-12 Radich, Ethel P. 1899 West 25th Street   Cleveland OH  
15129 1959-05-14 1959-03-23 Badrow Peter 1180 1180 1958-10-06 Central Council of Croation Associations - U.S. & Canada 5703 Dibble Avenue   Cleveland OH  
15130 1959-05-14 1959-03-23 Hukarevic Saban 1180 1180 1958-10-06 Central Council of Croation Associations - U.S. & Canada 5703 Dibble Avenue   Cleveland OH  
15131 1959-05-14 1959-03-23 Pavicich Anthony 1180 1180 1958-10-06 Central Council of Croation Associations - U.S. & Canada 5703 Dibble Avenue   Cleveland OH  
15132 1959-05-14 1959-03-23 Yelich Pasko 1180 1180 1958-10-06 Central Council of Croation Associations - U.S. & Canada 5703 Dibble Avenue   Cleveland OH  
15133 1959-05-14 1959-03-23 Zukic Ragib 1180 1180 1958-10-06 Central Council of Croation Associations - U.S. & Canada 5703 Dibble Avenue   Cleveland OH  
15134 1959-05-14 1958-10-06 Sega Milan 1180 1180 1958-10-06 Central Council of Croation Associations - U.S. & Canada 5703 Dibble Avenue   Cleveland OH  
15135 1959-05-14 1958-10-06 Srnec Marijan 1180 1180 1958-10-06 Central Council of Croation Associations - U.S. & Canada 5703 Dibble Avenue   Cleveland OH  
15252 2001-05-15 1999-05-18 Gillespie Kelly 3426 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
15253 2001-05-15 2001-05-23 Kelley Kim 3426 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
15255 2001-05-15 2000-11-13 Hindman Marybeth 3426 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
16124 1996-05-29 1991-03-27 Prost Kenneth E. 3426 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
16244 2000-05-30 1999-08-18 Wuellner Thomas 3426 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
16654 1997-05-31 1996-11-26 Bosse Magan 3426 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
17163 1990-06-01 1990-03-07 Steins Scott 3426 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
21462 1994-07-13 1994-01-10 Mathis Deborah J. 3426 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
21463 1994-07-13 1994-02-28 Frick Dane C. 3426 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
21513 1993-07-14 1993-03-17 Brockman David 3426 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
21515 1993-07-14 1993-05-20 Kunzelman Lori A. 3426 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
21990 2000-07-19 2000-06-28 Kiser Kimberly 3426 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
24479 1997-08-08 1997-06-11 Perkins Alexander L. 3426 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
24722 1999-08-13 1999-02-17 Watson Clint 3426 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
25883 1996-08-30 1996-05-08 Kneisel Laura P. 3426 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
26972 1998-09-01 1998-03-04 Jaeger Carrie 3426 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
28100 1995-09-19 1995-09-19 Pashi Lumana 5052 5052 1995-09-19 Parti Lumumbiste Unifie (PALU) Representation U.S.A. Post Office Box 19873 Cincinnati OH 45219
29051 1991-09-30 1991-07-10 Dames Michael 3426 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
30346 1999-10-08 1999-05-25 McGonagle Megan 3426 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
32497 2018-10-31 2017-05-31 Mellin Carolyn 6032 6032 2011-04-14 International Merchandising Corporation 1360 East 9th Street Suite 100 Cleveland OH 44114
32771 2016-11-01 2011-04-14 Shapard W. Allen 6032 6032 2011-04-14 International Merchandising Corporation 1360 East 9th Street Suite 100 Cleveland OH 44114
34950 1989-12-01 1989-02-16 Antony John P. 3426 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
34952 1989-12-01 1989-06-21 Norvell Sandra 3426 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
35484 1999-12-09 1999-10-26 Krcmarich Ryan 3426 3426 1982-12-08 Oestreicher, Michael R. 312 Walnut Street Suite 1400 Cincinnati OH 45202
38074 1990-12-31 1990-06-20 Stercz Joseph Reinhold 3426 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)
);
Powered by Datasette · Query took 332.698ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history