FARA_All_ShortForms

List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

355 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 · 355 ✖
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
581 581   2020-03-30 Netto Joseph 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
583 583   2020-03-30 Schmidt Michael Thomas 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
584 584   2020-03-30 Shull Anna Marie 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
585 585   2020-03-30 Streich William Joseph Brendan 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1087 1087   2017-06-09 Ashcroft John D. 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
1088 1088   2017-06-09 Ayres David T. 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
1089 1089   2017-06-09 Day Lori Sharpe 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
1090 1090   2017-06-09 Peele Christopher L. 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
1091 1091   2017-06-09 Reyes Luis Alejandro 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
1092 1092   2017-06-09 Sullivan Michael J. 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
1129 1129   2013-06-14 Lyall Alexander 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1204 1204   2020-06-26 Rahman Kamilla 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1205 1205   2020-06-26 Shaw Steven 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1206 1206   2020-06-26 Teahan Caitlin 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1299 1299   2020-07-10 Brennan Nathan 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
1797 1797   2017-09-26 Rose Sheila 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1847 1847   2019-10-02 West Kimberly 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
2086 2086   2019-11-13 Bennett Barry 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
2134 2134   2013-11-20 Rockenbach Denise M. 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
2471 2471 1969-01-01 1960-08-12 Claggett Charles Evans 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
2922 2922 2018-01-01 2017-09-19 Leong Lonna 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
3022 3022 1973-01-03 1960-08-12 Pellegrino Thomas John 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
3233 3233 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
3367 3367 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
3560 3560 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
3598 3598 1972-01-15 1968-10-11 Lucci Giuseppe 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
3721 3721 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
3722 3722 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
3724 3724 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
3725 3725 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
3726 3726 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
3773 3773 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
3799 3799 2017-01-17 2009-03-16 Cutin Dario O. 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
3907 3907 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
4285 4285 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
4620 4620 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
4715 4715 1972-01-31 1968-10-11 Digby Noel 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
4804 4804 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
4945 4945 1996-01-31 1993-10-20 Bingol Selim 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
4955 4955 1997-01-31 1994-03-04 Sharples Susan 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
4975 4975 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
5212 5212 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
5429 5429 1973-02-01 1972-11-13 Filice Michael 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
6291 6291 2009-02-10 2007-04-16 Edwards Samantha A. 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
6570 6570 1963-02-15 1962-09-07 Eastright Robert Earl 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
6589 6589 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
6591 6591 1973-02-15 1966-12-08 Sabatino Daniel Casper 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
6666 6666 2018-02-15 2017-06-08 Hancock Katy 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
6860 6860 2000-02-18 1996-09-04 Jennings Malin 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
6936 6936 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
7404 7404 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
7415 7415 2009-02-27 2007-04-16 Viorst Marla Rigel 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
7623 7623 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
7937 7937 2018-02-28 2017-05-16 Moroney Michael 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
7954 7954 2018-02-28 2017-11-04 Perrien Ainsley 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
8410 8410 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
8486 8486 2018-03-02 2017-09-19 Mok Martina 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
8619 8619 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
8620 8620 1994-03-04 1993-03-05 Tucker Brett 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8621 8621 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
8631 8631 2017-03-04 2013-06-14 Yang Jennifer 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
8663 8663 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
8665 8665 1993-03-05 1989-09-05 Bloch Jayne 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8666 8666 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
8667 8667 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
8668 8668 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
8669 8669 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
8670 8670 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
8724 8724 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
8729 8729 1995-03-06 1991-03-07 Hancock Mary 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8732 8732 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
8902 8902 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
9190 9190 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
9265 9265 1973-03-14 1963-03-05 Brugnatelli Bruno Ercole 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9266 9266 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
9267 9267 1973-03-14 1961-03-08 Pierce Alvin Frederick 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9268 9268 1973-03-14 1962-03-09 Cornwell William Earl 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9269 9269 1973-03-14 1962-03-09 Ewell Charles Lee 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9270 9270 1973-03-14 1962-03-09 Rice Francis Xavier 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9273 9273 1973-03-14 1965-11-05 Davidson John M. 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9274 9274 1973-03-14 1968-11-25 Dalton Peter J. 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9297 9297 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
9300 9300 2003-03-14 2003-03-07 Franco Nathalia 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9314 9314 2018-03-14 2018-03-14 Adolph Michael Charles 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9315 9315 2018-03-14 2018-03-14 Choi Michelle 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9316 9316 2018-03-14 2018-03-14 Demashkieh Diala 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9317 9317 2018-03-14 2018-03-14 Flaster Samuel Grant 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9318 9318 2018-03-14 2018-03-14 Francomano Sarah 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9319 9319 2018-03-14 2018-03-14 Isaf John K. 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9320 9320 2018-03-14 2018-03-15 Hollyer Luke 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9321 9321 2018-03-14 2018-03-15 Prior Melanie 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9322 9322 2018-03-14 2018-03-15 Thom Amy 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9443 9443 2010-03-15 2009-03-16 Licha Rissig 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9514 9514 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
9612 9612 2000-03-17 1997-09-04 Doble Michael F. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9613 9613 2000-03-17 1999-09-07 Klein Mara S. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9707 9707 1998-03-18 1993-09-07 Beightol Michael H. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9972 9972 2002-03-22 2000-09-01 Blomquist Eric 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
10170 10170 1969-03-25 1960-08-12 Humphrey Champ C. 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
10171 10171 1969-03-25 1960-08-18 Spencer William Leonard 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 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)
);
Powered by Datasette · Query took 344.873ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history