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

✎ 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
3356 3356 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
3697 3697 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
3890 3890 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
3891 3891 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
3893 3893 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
3894 3894 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
3895 3895 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
3950 3950 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
4090 4090 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
4478 4478 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
4828 4828 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
5013 5013 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
5154 5154 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
5164 5164 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
5184 5184 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
7209 7209 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
7291 7291 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
7784 7784 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
8003 8003 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
9111 9111 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
9112 9112 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
9113 9113 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
9156 9156 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
9158 9158 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
9159 9159 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
9160 9160 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
9161 9161 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
9162 9162 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
9163 9163 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
9218 9218 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
9223 9223 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
9226 9226 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
9397 9397 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
9719 9719 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
9827 9827 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
9830 9830 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
10056 10056 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
10154 10154 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
10155 10155 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
10250 10250 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
10516 10516 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
11028 11028 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
11029 11029 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
11035 11035 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
11789 11789 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
11824 11824 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
11828 11828 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
12625 12625 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
12627 12627 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
12628 12628 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
12885 12885 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
13086 13086 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
13088 13088 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
13208 13208 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
13467 13467 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
13687 13687 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
13898 13898 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
14031 14031 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
15422 15422 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
15584 15584 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
15697 15697 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
15743 15743 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
15967 15967 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
16316 16316 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
16422 16422 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
16428 16428 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
16602 16602 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
16749 16749 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
16818 16818 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
16945 16945 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
17028 17028 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
17029 17029 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
17178 17178 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
17286 17286 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
19337 19337 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
19423 19423 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
19527 19527 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
19569 19569 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
19689 19689 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
19749 19749 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
19797 19797 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
19957 19957 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
21085 21085 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
22163 22163 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
22454 22454 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
22703 22703 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
23527 23527 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
23605 23605 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
23653 23653 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
23724 23724 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
24079 24079 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
24290 24290 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
24291 24291 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
24729 24729 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
24861 24861 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
25980 25980 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
25981 25981 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
25982 25982 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
25983 25983 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
25984 25984 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 286.304ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history