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

347 rows where City = "St. Louis"

✎ View and edit SQL

This data as json, atom, 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 · 347 ✖
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
1019 1019   2017-06-09 Ashcroft John D. 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
1020 1020   2017-06-09 Ayres David T. 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
1021 1021   2017-06-09 Day Lori Sharpe 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
1022 1022   2017-06-09 Peele Christopher L. 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
1023 1023   2017-06-09 Reyes Luis Alejandro 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
1024 1024   2017-06-09 Sullivan Michael J. 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
1049 1049   2013-06-14 Lyall Alexander 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1637 1637   2017-09-26 Rose Sheila 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1714 1714   2019-10-02 West Kimberly 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
1990 1990   2019-11-13 Bennett Barry 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
2043 2043   2013-11-20 Rockenbach Denise M. 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
2425 2425 1969-01-01 1960-08-12 Claggett Charles Evans 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
2875 2875 2018-01-01 2017-09-19 Leong Lonna 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
2974 2974 1973-01-03 1960-08-12 Pellegrino Thomas John 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
3184 3184 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
3318 3318 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
3508 3508 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
3544 3544 1972-01-15 1968-10-11 Lucci Giuseppe 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
3667 3667 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
3668 3668 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
3670 3670 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
3671 3671 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
3672 3672 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
3719 3719 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
3745 3745 2017-01-17 2009-03-16 Cutin Dario O. 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
3852 3852 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
4227 4227 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
4558 4558 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
4649 4649 1972-01-31 1968-10-11 Digby Noel 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
4738 4738 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
4879 4879 1996-01-31 1993-10-20 Bingol Selim 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
4889 4889 1997-01-31 1994-03-04 Sharples Susan 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
4909 4909 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
5146 5146 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
5344 5344 1973-02-01 1972-11-13 Filice Michael 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
6199 6199 2009-02-10 2007-04-16 Edwards Samantha A. 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
6476 6476 1963-02-15 1962-09-07 Eastright Robert Earl 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
6495 6495 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
6497 6497 1973-02-15 1966-12-08 Sabatino Daniel Casper 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
6572 6572 2018-02-15 2017-06-08 Hancock Katy 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
6761 6761 2000-02-18 1996-09-04 Jennings Malin 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
6833 6833 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
7299 7299 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
7310 7310 2009-02-27 2007-04-16 Viorst Marla Rigel 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
7515 7515 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
7823 7823 2018-02-28 2017-05-16 Moroney Michael 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
7840 7840 2018-02-28 2017-11-04 Perrien Ainsley 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
8283 8283 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
8357 8357 2018-03-02 2017-09-19 Mok Martina 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
8489 8489 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
8490 8490 1994-03-04 1993-03-05 Tucker Brett 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8491 8491 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
8501 8501 2017-03-04 2013-06-14 Yang Jennifer 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
8533 8533 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
8535 8535 1993-03-05 1989-09-05 Bloch Jayne 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8536 8536 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
8537 8537 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
8538 8538 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
8539 8539 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
8540 8540 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
8594 8594 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
8599 8599 1995-03-06 1991-03-07 Hancock Mary 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8602 8602 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
8771 8771 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
9058 9058 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
9133 9133 1973-03-14 1963-03-05 Brugnatelli Bruno Ercole 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9134 9134 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
9135 9135 1973-03-14 1961-03-08 Pierce Alvin Frederick 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9136 9136 1973-03-14 1962-03-09 Cornwell William Earl 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9137 9137 1973-03-14 1962-03-09 Ewell Charles Lee 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9138 9138 1973-03-14 1962-03-09 Rice Francis Xavier 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9141 9141 1973-03-14 1965-11-05 Davidson John M. 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9142 9142 1973-03-14 1968-11-25 Dalton Peter J. 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9165 9165 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
9168 9168 2003-03-14 2003-03-07 Franco Nathalia 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9182 9182 2018-03-14 2018-03-14 Adolph Michael Charles 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9183 9183 2018-03-14 2018-03-14 Choi Michelle 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9184 9184 2018-03-14 2018-03-14 Demashkieh Diala 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9185 9185 2018-03-14 2018-03-14 Flaster Samuel Grant 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9186 9186 2018-03-14 2018-03-14 Francomano Sarah 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9187 9187 2018-03-14 2018-03-14 Isaf John K. 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9188 9188 2018-03-14 2018-03-15 Hollyer Luke 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9189 9189 2018-03-14 2018-03-15 Prior Melanie 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9190 9190 2018-03-14 2018-03-15 Thom Amy 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9311 9311 2010-03-15 2009-03-16 Licha Rissig 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9382 9382 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
9480 9480 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
9481 9481 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
9575 9575 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
9839 9839 2002-03-22 2000-09-01 Blomquist Eric 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
10035 10035 1969-03-25 1960-08-12 Humphrey Champ C. 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
10036 10036 1969-03-25 1960-08-18 Spencer William Leonard 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
10328 10328 1991-03-29 1989-03-03 Tagliarino Scott A. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
10329 10329 1991-03-29 1991-03-07 Pardo Francesca 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
10335 10335 1991-03-29 1989-09-05 Moriber Jeffrey 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
10682 10682 1966-03-31 1961-03-08 DeHavilland Robert Paul 1385 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
10837 10837 1987-03-31 1983-01-11 Falk William J. 3436 3436 1983-01-11 Thompson & Mitchell 1 Mercantile Center Suite 3400 St. Louis MO 63101
11084 11084 1999-03-31 1993-03-05 Burket David 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
11119 11119 2000-03-31 1996-07-15 Glidden Julia A. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
11123 11123 2000-03-31 1999-09-07 Parker Amy M. 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)
);
Powered by Datasette · Query took 289.466ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history