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

28 rows where Registration_Date = "1982-12-08" and State = "OH"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Registration_Date (date)

State 1

Registration_Number 1

Registrant_Name 1

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