FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
65 rows where State = "OH"
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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
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]) );