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

372 rows where City = "St. Louis"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registration_Number

State

City

  • St. Louis · 372 ✖
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
130 130   2021-01-21 Rand Amy 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
216 216   2021-01-30 Adolph Michael Charles 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
217 217   2021-01-30 Belding Arman 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
218 218   2021-01-30 Bernard Mikael 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
219 219   2021-01-30 Bueno Alexander de la Torre 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
220 220   2021-01-30 Franklin James Nikolai 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
221 221   2021-01-30 Graziano Devon 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
222 222   2021-01-30 Heibeck Olivia 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
225 225   2021-01-30 Sanchez Nicole 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
966 966   2017-06-09 Ashcroft John D. 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
967 967   2017-06-09 Ayres David T. 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
968 968   2017-06-09 Day Lori Sharpe 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
969 969   2017-06-09 Peele Christopher L. 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
970 970   2017-06-09 Reyes Luis Alejandro 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
971 971   2017-06-09 Sullivan Michael J. 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
1062 1062   2020-06-26 Rahman Kamilla 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1063 1063   2020-06-26 Shaw Steven 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1064 1064   2020-06-26 Teahan Caitlin 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1138 1138   2020-07-10 Brennan Nathan 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
1563 1563   2019-10-02 West Kimberly 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
1613 1613   2020-10-09 Girouard Spencer 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1614 1614   2020-10-09 Tchoukaleff Tayler 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1615 1615   2020-10-09 Tchoukaleff Tayler 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1616 1616   2020-10-09 Zagora Anthony 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1625 1625   2020-10-12 Witt Bailey 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1629 1629   2020-10-13 Evenson Erin 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1635 1635   2020-10-13 Sadlier Lizanne 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1853 1853   2019-11-13 Bennett Barry 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
2266 2266 1969-01-01 1960-08-12 Claggett Charles Evans 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
2719 2719 2018-01-01 2017-09-19 Leong Lonna 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
2821 2821 1973-01-03 1960-08-12 Pellegrino Thomas John 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
3035 3035 1999-01-07 1992-03-05 Campbell W. Douglas 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
3170 3170 2020-01-09 2017-06-09 Reilly Michelle T. 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
3369 3369 2000-01-14 1999-03-05 Harrower David A. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
3407 3407 1972-01-15 1968-10-11 Lucci Giuseppe 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
3550 3550 1998-01-16 1986-02-05 Sullivan Richard J. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
3551 3551 1998-01-16 1992-03-05 Anderson William K. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
3553 3553 1998-01-16 1988-09-01 Epstein Jerry A. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
3554 3554 1998-01-16 1989-09-05 Van Meter Jan R. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
3555 3555 1998-01-16 1993-09-07 Modzelewski Jack (John F.) 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
3602 3602 1989-01-17 1988-03-03 de Leon Richard Rueda 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
3628 3628 2017-01-17 2009-03-16 Cutin Dario O. 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
3740 3740 1998-01-19 1995-09-06 Gonzalez Luis A. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
4120 4120 1995-01-25 1990-05-14 Morrison Jean Anne 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
4457 4457 2004-01-30 2002-03-28 Collender Stanley E. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
4552 4552 1972-01-31 1968-10-11 Digby Noel 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
4641 4641 1988-01-31 1986-09-05 White Rene L. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
4782 4782 1996-01-31 1993-10-20 Bingol Selim 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
4792 4792 1997-01-31 1994-03-04 Sharples Susan 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
4812 4812 1998-01-31 1994-09-08 Tuncata Arzu F. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
5049 5049 2010-01-31 2007-07-27 Fears Gary 5821 5821 2007-07-27 Avatar Enterprises, Inc. 10349 Watson Road Suite 100 St. Louis MO 63127
5281 5281 1973-02-01 1972-11-13 Filice Michael 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
6154 6154 2009-02-10 2007-04-16 Edwards Samantha A. 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
6435 6435 1963-02-15 1962-09-07 Eastright Robert Earl 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
6454 6454 1973-02-15 1971-03-29 Vecchio Pasquale G. Del 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
6456 6456 1973-02-15 1966-12-08 Sabatino Daniel Casper 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
6531 6531 2018-02-15 2017-06-08 Hancock Katy 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
6748 6748 2000-02-18 1996-09-04 Jennings Malin 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
6826 6826 1998-02-20 1986-02-20 Pearlman Vicki E. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
7306 7306 1998-02-27 1988-01-19 Sonnenfeldt Marjorie Hecht 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
7317 7317 2009-02-27 2007-04-16 Viorst Marla Rigel 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
7525 7525 1995-02-28 1993-03-05 Sommerfield Frank E. , Jr. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
7839 7839 2018-02-28 2017-05-16 Moroney Michael 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
7856 7856 2018-02-28 2017-11-04 Perrien Ainsley 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
8355 8355 2010-03-01 2009-10-29 Dulle Jr. Oliver A. 5959 5959 2009-10-29 Oliver A. Dulle Jr. & Company, Inc. 8000 Maryland Avenue Suite 1320 St. Louis MO 63105
8432 8432 2018-03-02 2017-09-19 Mok Martina 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
8565 8565 1994-03-04 1992-03-05 Clarkson Pamela A. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8566 8566 1994-03-04 1993-03-05 Tucker Brett 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8567 8567 1994-03-04 1992-03-18 Ampolsk Alan G. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8577 8577 2017-03-04 2013-06-14 Yang Jennifer 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
8609 8609 1993-03-05 1991-03-07 Levy Jill Anne 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8611 8611 1993-03-05 1989-09-05 Bloch Jayne 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8612 8612 1993-03-05 1989-09-05 McCabe Ian Richard 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8613 8613 1993-03-05 1989-09-05 Smith Alan Wayne 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8614 8614 1993-03-05 1989-09-05 Turner Caren Zeldie 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8615 8615 1993-03-05 1991-09-05 de Tejada Marivi Lerdo 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8616 8616 1993-03-05 1988-10-12 Christy Valerie E. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8670 8670 1992-03-06 1991-03-07 Hamblin Koleen Carole 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8675 8675 1995-03-06 1991-03-07 Hancock Mary 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8678 8678 1995-03-06 1990-05-18 Solymossy Diana Sun 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8848 8848 1997-03-07 1993-09-07 Carpenter Cynthia L. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9136 9136 1998-03-12 1990-12-10 Woods Andrew A. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9211 9211 1973-03-14 1963-03-05 Brugnatelli Bruno Ercole 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9212 9212 1973-03-14 1963-03-05 Buffington Louis Dell , III 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9213 9213 1973-03-14 1961-03-08 Pierce Alvin Frederick 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9214 9214 1973-03-14 1962-03-09 Cornwell William Earl 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9215 9215 1973-03-14 1962-03-09 Ewell Charles Lee 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9216 9216 1973-03-14 1962-03-09 Rice Francis Xavier 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9219 9219 1973-03-14 1965-11-05 Davidson John M. 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9220 9220 1973-03-14 1968-11-25 Dalton Peter J. 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9243 9243 2001-03-14 2000-03-10 Martin Kim S. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9246 9246 2003-03-14 2003-03-07 Franco Nathalia 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9260 9260 2018-03-14 2018-03-14 Adolph Michael Charles 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9261 9261 2018-03-14 2018-03-14 Choi Michelle 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9262 9262 2018-03-14 2018-03-14 Demashkieh Diala 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9263 9263 2018-03-14 2018-03-14 Flaster Samuel Grant 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9264 9264 2018-03-14 2018-03-14 Francomano Sarah 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9265 9265 2018-03-14 2018-03-14 Isaf John K. 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9266 9266 2018-03-14 2018-03-15 Hollyer Luke 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9267 9267 2018-03-14 2018-03-15 Prior Melanie 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102

Next page

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