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

22 rows where Registration_Number = 2403

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • Tromson Monroe Advertising, Inc. · 22 ✖

Registrant_Name 1

City 1

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
4951 4951 1975-01-31 1974-09-30 Ross John P. , Jr. Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc. 450 Park Avenue, South   New York NY 10016
17706 17706 1987-05-31 1986-11-10 Wagner Susan Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc. 450 Park Avenue, South   New York NY 10016
23727 23727 1989-07-21 1986-05-21 Kolb Oscar F. Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc. 450 Park Avenue, South   New York NY 10016
24815 24815 1990-07-31 1989-10-13 Meresman Leila Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc. 450 Park Avenue, South   New York NY 10016
30977 30977 1986-09-30 1973-01-09 Curtin Eleanor G. Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc. 450 Park Avenue, South   New York NY 10016
30978 30978 1986-09-30 1973-01-09 McGuire John Morton Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc. 450 Park Avenue, South   New York NY 10016
30983 30983 1986-09-30 1986-05-21 Owens Brian Brashears Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc. 450 Park Avenue, South   New York NY 10016
30996 30996 1986-09-30 1977-10-03 Fields Stanley Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc. 450 Park Avenue, South   New York NY 10016
33703 33703 1989-10-27 1989-10-13 Anthony Garry Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc. 450 Park Avenue, South   New York NY 10016
34264 34264 1986-10-31 1974-09-05 Freed William H. Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc. 450 Park Avenue, South   New York NY 10016
34306 34306 1990-10-31 1986-05-21 Davidson Laura Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc. 450 Park Avenue, South   New York NY 10016
36446 36446 1986-11-26 1986-05-21 Connors Catherine Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc. 450 Park Avenue, South   New York NY 10016
36681 36681 1986-11-30 1986-11-10 Wadson Judith Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc. 450 Park Avenue, South   New York NY 10016
36691 36691 1987-11-30 1987-09-10 Huttner Gail Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc. 450 Park Avenue, South   New York NY 10016
36692 36692 1987-11-30 1987-09-10 Muchnick Jeanne Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc. 450 Park Avenue, South   New York NY 10016
40165 40165 1980-12-31 1974-09-05 Lattey Gordon Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc. 450 Park Avenue, South   New York NY 10016
40607 40607 1990-12-31 1989-02-16 Walsh Elizabeth Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc. 450 Park Avenue, South   New York NY 10016
40610 40610 1990-12-31 1990-02-28 Chu Gary Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc. 450 Park Avenue, South   New York NY 10016
40621 40621 1990-12-31 1986-06-02 Trombone Ilse Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc. 450 Park Avenue, South   New York NY 10016
40622 40622 1990-12-31 1986-06-02 Trombone Mario Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc. 450 Park Avenue, South   New York NY 10016
40623 40623 1990-12-31 1986-06-02 Youngman Michael John Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc. 450 Park Avenue, South   New York NY 10016
40643 40643 1990-12-31 1987-09-10 Coloccia Jane L. Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc. 450 Park Avenue, South   New York NY 10016

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