FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
35 rows where Address_2 = "Suite 1400"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Registration_Date, Address_1, Zip, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 4
Registrant_Name 4
City 4
- Cincinnati 28
- Falls Church 4
- New Orleans 2
- San Francisco 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 |
14879 | 14879 | 2002-04-30 | 2001-10-29 | Pedigo | Christopher L. | Reed Smith LLP 5465 | 2001-10-29 | Reed Smith LLP | 3110 Fairview Park Drive | Suite 1400 | Falls Church | VA | 22042-0681 |
14880 | 14880 | 2002-04-30 | 2001-10-29 | Sterne | John H. Jr., | Reed Smith LLP 5465 | 2001-10-29 | Reed Smith LLP | 3110 Fairview Park Drive | Suite 1400 | Falls Church | VA | 22042-0681 |
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 |
17973 | 17973 | 2003-05-31 | 2001-10-29 | Koch | Robbie N. | Reed Smith LLP 5465 | 2001-10-29 | Reed Smith LLP | 3110 Fairview Park Drive | Suite 1400 | Falls Church | VA | 22042-0681 |
17974 | 17974 | 2003-05-31 | 2001-10-29 | Kronmiller | Theodore G. | Reed Smith LLP 5465 | 2001-10-29 | Reed Smith LLP | 3110 Fairview Park Drive | Suite 1400 | Falls Church | VA | 22042-0681 |
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 |
27712 | 27712 | 2004-08-29 | 2004-05-13 | Doley | Harold E. III., | Lugano Group Incorporated 5608 | 2004-02-27 | Lugano Group Incorporated | 650 Poydras Street | Suite 1400 | New Orleans | LA | 70130-6116 |
27713 | 27713 | 2004-08-29 | 2004-05-13 | Mireskandari | Amir | Lugano Group Incorporated 5608 | 2004-02-27 | Lugano Group Incorporated | 650 Poydras Street | Suite 1400 | New Orleans | LA | 70130-6116 |
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 |
40869 | 40869 | 1995-12-31 | 1995-06-20 | Goldman | Patti A. | Sierra Club Legal Defense Fund, Inc. 5026 | 1995-06-20 | Sierra Club Legal Defense Fund, Inc. | 180 Montgomery Street | Suite 1400 | San Francisco | CA | 94104-4209 |
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]) );