home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for 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

191 rows where Registration_Number = 3774 and State = "MO"

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

State 1

  • MO · 191 ✖

Registration_Number 1

  • Fleishman-Hillard, Inc. · 191 ✖

Registrant_Name 1

  • Fleishman-Hillard, Inc. 191

City 1

  • St. Louis 191
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
3368 3368 1999-01-07 1992-03-05 Campbell W. Douglas Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
3709 3709 2000-01-14 1999-03-05 Harrower David A. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
3902 3902 1998-01-16 1986-02-05 Sullivan Richard J. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
3903 3903 1998-01-16 1992-03-05 Anderson William K. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
3905 3905 1998-01-16 1988-09-01 Epstein Jerry A. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
3906 3906 1998-01-16 1989-09-05 Van Meter Jan R. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
3907 3907 1998-01-16 1993-09-07 Modzelewski Jack (John F.) Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
3962 3962 1989-01-17 1988-03-03 de Leon Richard Rueda Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
4102 4102 1998-01-19 1995-09-06 Gonzalez Luis A. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
4490 4490 1995-01-25 1990-05-14 Morrison Jean Anne Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
4840 4840 2004-01-30 2002-03-28 Collender Stanley E. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
5025 5025 1988-01-31 1986-09-05 White Rene L. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
5166 5166 1996-01-31 1993-10-20 Bingol Selim Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
5176 5176 1997-01-31 1994-03-04 Sharples Susan Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
5196 5196 1998-01-31 1994-09-08 Tuncata Arzu F. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
7222 7222 2000-02-18 1996-09-04 Jennings Malin Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
7304 7304 1998-02-20 1986-02-20 Pearlman Vicki E. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
7797 7797 1998-02-27 1988-01-19 Sonnenfeldt Marjorie Hecht Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8016 8016 1995-02-28 1993-03-05 Sommerfield Frank E. , Jr. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9124 9124 1994-03-04 1992-03-05 Clarkson Pamela A. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9125 9125 1994-03-04 1993-03-05 Tucker Brett Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9126 9126 1994-03-04 1992-03-18 Ampolsk Alan G. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9169 9169 1993-03-05 1991-03-07 Levy Jill Anne Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9171 9171 1993-03-05 1989-09-05 Bloch Jayne Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9172 9172 1993-03-05 1989-09-05 McCabe Ian Richard Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9173 9173 1993-03-05 1989-09-05 Smith Alan Wayne Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9174 9174 1993-03-05 1989-09-05 Turner Caren Zeldie Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9175 9175 1993-03-05 1991-09-05 de Tejada Marivi Lerdo Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9176 9176 1993-03-05 1988-10-12 Christy Valerie E. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9231 9231 1992-03-06 1991-03-07 Hamblin Koleen Carole Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9236 9236 1995-03-06 1991-03-07 Hancock Mary Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9239 9239 1995-03-06 1990-05-18 Solymossy Diana Sun Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9410 9410 1997-03-07 1993-09-07 Carpenter Cynthia L. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9732 9732 1998-03-12 1990-12-10 Woods Andrew A. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9840 9840 2001-03-14 2000-03-10 Martin Kim S. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9843 9843 2003-03-14 2003-03-07 Franco Nathalia Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
10069 10069 2000-03-16 1989-09-05 Colon William A. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
10167 10167 2000-03-17 1997-09-04 Doble Michael F. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
10168 10168 2000-03-17 1999-09-07 Klein Mara S. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
10263 10263 1998-03-18 1993-09-07 Beightol Michael H. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
10529 10529 2002-03-22 2000-09-01 Blomquist Eric Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
11041 11041 1991-03-29 1989-03-03 Tagliarino Scott A. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
11042 11042 1991-03-29 1991-03-07 Pardo Francesca Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
11048 11048 1991-03-29 1989-09-05 Moriber Jeffrey Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
11802 11802 1999-03-31 1993-03-05 Burket David Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
11837 11837 2000-03-31 1996-07-15 Glidden Julia A. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
11841 11841 2000-03-31 1999-09-07 Parker Amy M. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
12639 12639 1997-04-02 1996-03-06 Garber Jennifer Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
12641 12641 1999-04-02 1996-03-06 Blackburn Daniel Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
12642 12642 1999-04-02 1991-03-07 Nakakura Shari Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
12899 12899 1995-04-07 1987-03-06 Ouellette Jeanne Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
13100 13100 2000-04-10 1999-03-05 Guarnieri Rica M. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
13102 13102 2001-04-10 1989-03-03 Gregory John R. (Jack) Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
13222 13222 1991-04-12 1991-03-07 Krauss Beatrice Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
13481 13481 2003-04-15 2002-03-28 Sucar Liana Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
13701 13701 1995-04-18 1991-05-17 Birney Jonelle Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
13912 13912 1992-04-22 1991-09-05 Neisloss Susan Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
14045 14045 1992-04-24 1991-03-07 Chuck Charles D. Gelman Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
15437 15437 1992-05-01 1990-05-10 Gray William Brett Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
15600 15600 1997-05-02 1993-09-07 Monson Sharon M. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
15713 15713 1999-05-04 1993-03-12 Massey Donald F. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
15759 15759 1995-05-05 1991-03-07 Fletcher Nancy Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
15984 15984 1997-05-09 1996-04-09 Eisner David Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
16333 16333 1999-05-14 1989-03-03 McLean Carolyn Alexis Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
16439 16439 2002-05-15 2000-03-10 Batalla Yvette Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
16445 16445 2003-05-15 1988-10-12 Leddy Gregory Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
16619 16619 1996-05-17 1993-09-07 Rudnick Gary Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
16766 16766 1998-05-20 1995-01-24 Harmon Elisabeth Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
16835 16835 1999-05-21 1995-09-06 Barry Ellen Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
16962 16962 1996-05-23 1988-01-19 Buckmaster Thomas L. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
17045 17045 1996-05-24 1995-09-06 Riley Stephen F. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
17046 17046 1996-05-24 1994-09-08 Cabelly Robert John Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
17195 17195 1999-05-26 1996-04-09 Gustafson Robert C. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
17303 17303 1999-05-28 1993-10-20 Gossens Peter J. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
19354 19354 1997-06-13 1995-09-06 Johnson Judy A. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
19440 19440 1996-06-14 1996-04-09 Raymond Derrick Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
19545 19545 1987-06-15 1986-02-20 Size Susan A. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
19587 19587 2004-06-15 2002-09-12 Johnson C. Donald Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
19707 19707 2004-06-16 2003-09-22 McGuinness Katie Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
19767 19767 1996-06-17 1995-09-06 Jackson Nancy Izzo Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
19815 19815 1999-06-18 1997-03-22 Anthony Adam Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
19975 19975 1991-06-21 1991-04-08 Solomon Mary C. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
21103 21103 1988-06-30 1986-09-05 DesRosiers Kathleen A. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
22184 22184 1988-07-01 1986-09-05 Margaritis John P. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
22475 22475 1998-07-02 1996-04-09 Graziani Andrew Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
22724 22724 2000-07-07 1999-09-07 Feria Isabel Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
23548 23548 1991-07-18 1991-03-07 Fischer Kathleen Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
23626 23626 2004-07-19 2000-09-01 Isenhower Anne Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
23674 23674 2004-07-20 1989-09-05 Lansdale Edward R. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
23745 23745 2000-07-21 2000-03-10 Yacker Jeffrey Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
24101 24101 1996-07-26 1995-03-06 Coulter Cynthia A. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
24312 24312 1995-07-28 1994-03-04 Horner Chris Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
24313 24313 1999-07-28 1991-05-30 Soh Peter Y. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
24751 24751 1987-07-31 1987-03-06 Elwell Stephen Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
24883 24883 1996-07-31 1990-10-30 Zingman Benjamin L. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
26002 26002 2004-08-05 1988-01-19 Miller Martha Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
26003 26003 2004-08-05 1986-02-05 Graham John D. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
26004 26004 2004-08-05 1993-03-05 Boxerman Benita W. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
26005 26005 2004-08-05 1993-03-05 Garino David P. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
26006 26006 2004-08-05 1999-03-05 Licha Rissig Fleishman-Hillard, Inc. 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 · Queries took 519.583ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows