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
14 14     Mulcahy Sarah 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
18 18     Powers Shelby Lynn 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
21 21     Schmidt Michael T 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
131 131   2021-01-21 Rand Amy 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
205 205   2021-01-30 Adolph Michael Charles 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
206 206   2021-01-30 Belding Arman 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
207 207   2021-01-30 Bernard Mikael 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
208 208   2021-01-30 Bueno Alexander de la Torre 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
209 209   2021-01-30 Franklin James Nikolai 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
210 210   2021-01-30 Graziano Devon 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
211 211   2021-01-30 Heibeck Olivia 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
214 214   2021-01-30 Sanchez Nicole 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1156 1156   2020-06-26 Rahman Kamilla 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1157 1157   2020-06-26 Teahan Caitlin 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1630 1630   2021-09-10 Hart Colin M 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1631 1631   2021-09-10 Jada Amanda 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1632 1632   2021-09-10 Powers Shelby L 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1633 1633   2021-09-10 Rand Amy 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1634 1634   2021-09-10 Schmidt Michael T 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1843 1843   2020-10-09 Girouard Spencer 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1844 1844   2020-10-09 Tchoukaleff Tayler 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1845 1845   2020-10-09 Tchoukaleff Tayler 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1846 1846   2020-10-09 Zagora Anthony 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1854 1854   2020-10-12 Witt Bailey 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1861 1861   2020-10-13 Evenson Erin 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1867 1867   2020-10-13 Sadlier Lizanne 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
2417 2417 1969-01-01 1960-08-12 Claggett Charles Evans 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
2870 2870 2018-01-01 2017-09-19 Leong Lonna 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
2975 2975 1973-01-03 1960-08-12 Pellegrino Thomas John 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
3189 3189 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
3525 3525 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
3565 3565 1972-01-15 1968-10-11 Lucci Giuseppe 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
3713 3713 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
3714 3714 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
3716 3716 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
3717 3717 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
3718 3718 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
3765 3765 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
3791 3791 2017-01-17 2009-03-16 Cutin Dario O. 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
3903 3903 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
4284 4284 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
4623 4623 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
4719 4719 1972-01-31 1968-10-11 Digby Noel 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
4808 4808 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
4949 4949 1996-01-31 1993-10-20 Bingol Selim 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
4959 4959 1997-01-31 1994-03-04 Sharples Susan 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
4979 4979 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
5216 5216 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
5460 5460 1973-02-01 1972-11-13 Filice Michael 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
6340 6340 2009-02-10 2007-04-16 Edwards Samantha A. 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
6625 6625 1963-02-15 1962-09-07 Eastright Robert Earl 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
6644 6644 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
6646 6646 1973-02-15 1966-12-08 Sabatino Daniel Casper 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
6721 6721 2018-02-15 2017-06-08 Hancock Katy 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
6949 6949 2000-02-18 1996-09-04 Jennings Malin 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
7028 7028 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
7511 7511 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
7522 7522 2009-02-27 2007-04-16 Viorst Marla Rigel 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
7730 7730 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
8045 8045 2018-02-28 2017-05-16 Moroney Michael 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
8062 8062 2018-02-28 2017-11-04 Perrien Ainsley 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
8573 8573 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
8658 8658 2018-03-02 2017-09-19 Mok Martina 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
8792 8792 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
8793 8793 1994-03-04 1993-03-05 Tucker Brett 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8794 8794 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
8804 8804 2017-03-04 2013-06-14 Yang Jennifer 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
8836 8836 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
8838 8838 1993-03-05 1989-09-05 Bloch Jayne 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8839 8839 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
8840 8840 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
8841 8841 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
8842 8842 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
8843 8843 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
8898 8898 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
8903 8903 1995-03-06 1991-03-07 Hancock Mary 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8906 8906 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
9076 9076 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
9370 9370 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
9445 9445 1973-03-14 1963-03-05 Brugnatelli Bruno Ercole 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9446 9446 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
9447 9447 1973-03-14 1961-03-08 Pierce Alvin Frederick 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9448 9448 1973-03-14 1962-03-09 Cornwell William Earl 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9449 9449 1973-03-14 1962-03-09 Ewell Charles Lee 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9450 9450 1973-03-14 1962-03-09 Rice Francis Xavier 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9453 9453 1973-03-14 1965-11-05 Davidson John M. 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9454 9454 1973-03-14 1968-11-25 Dalton Peter J. 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9477 9477 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
9480 9480 2003-03-14 2003-03-07 Franco Nathalia 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9494 9494 2018-03-14 2018-03-14 Adolph Michael Charles 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9495 9495 2018-03-14 2018-03-14 Choi Michelle 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9496 9496 2018-03-14 2018-03-14 Demashkieh Diala 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9497 9497 2018-03-14 2018-03-14 Flaster Samuel Grant 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9498 9498 2018-03-14 2018-03-14 Francomano Sarah 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9499 9499 2018-03-14 2018-03-14 Isaf John K. 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9500 9500 2018-03-14 2018-03-15 Hollyer Luke 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9501 9501 2018-03-14 2018-03-15 Prior Melanie 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9502 9502 2018-03-14 2018-03-15 Thom Amy 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9623 9623 2010-03-15 2009-03-16 Licha Rissig 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9699 9699 2000-03-16 1989-09-05 Colon William A. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796

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