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