FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
18 rows where Registrant_Name = "Federal Advertising Agency, Inc." and "Short_Form_Date" is on date 1950-11-14
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
State 1
- NY 18
Registration_Number 1
Registrant_Name 1
- Federal Advertising Agency, Inc. · 18 ✖
City 1
- New York 18
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3212 | 3212 | 1951-01-05 | 1950-11-14 | Whiston | Michael W. | Federal Advertising Agency, Inc. 649 | 1950-11-14 | Federal Advertising Agency, Inc. | 270 Park Avenue | New York | NY | ||
6884 | 6884 | 1951-02-15 | 1950-11-14 | McMahon | Thomas Patrick | Federal Advertising Agency, Inc. 649 | 1950-11-14 | Federal Advertising Agency, Inc. | 270 Park Avenue | New York | NY | ||
6885 | 6885 | 1951-02-15 | 1950-11-14 | Morse | Herbert A. | Federal Advertising Agency, Inc. 649 | 1950-11-14 | Federal Advertising Agency, Inc. | 270 Park Avenue | New York | NY | ||
13352 | 13352 | 1951-04-15 | 1950-11-14 | Hurd | Kenneth Badger | Federal Advertising Agency, Inc. 649 | 1950-11-14 | Federal Advertising Agency, Inc. | 270 Park Avenue | New York | NY | ||
16293 | 16293 | 1952-05-14 | 1950-11-14 | Barton | Francis C. , Jr. | Federal Advertising Agency, Inc. 649 | 1950-11-14 | Federal Advertising Agency, Inc. | 270 Park Avenue | New York | NY | ||
16294 | 16294 | 1952-05-14 | 1950-11-14 | Boyd | Douglas | Federal Advertising Agency, Inc. 649 | 1950-11-14 | Federal Advertising Agency, Inc. | 270 Park Avenue | New York | NY | ||
16295 | 16295 | 1952-05-14 | 1950-11-14 | Dunn | Tristram | Federal Advertising Agency, Inc. 649 | 1950-11-14 | Federal Advertising Agency, Inc. | 270 Park Avenue | New York | NY | ||
16296 | 16296 | 1952-05-14 | 1950-11-14 | Faulk | Gunnard H. | Federal Advertising Agency, Inc. 649 | 1950-11-14 | Federal Advertising Agency, Inc. | 270 Park Avenue | New York | NY | ||
16297 | 16297 | 1952-05-14 | 1950-11-14 | Finley | George Francis Titus | Federal Advertising Agency, Inc. 649 | 1950-11-14 | Federal Advertising Agency, Inc. | 270 Park Avenue | New York | NY | ||
16298 | 16298 | 1952-05-14 | 1950-11-14 | Herman | Alice Hausman | Federal Advertising Agency, Inc. 649 | 1950-11-14 | Federal Advertising Agency, Inc. | 270 Park Avenue | New York | NY | ||
16299 | 16299 | 1952-05-14 | 1950-11-14 | Hermes | Frank , Jr. | Federal Advertising Agency, Inc. 649 | 1950-11-14 | Federal Advertising Agency, Inc. | 270 Park Avenue | New York | NY | ||
16300 | 16300 | 1952-05-14 | 1950-11-14 | Hyde | Gordon E. | Federal Advertising Agency, Inc. 649 | 1950-11-14 | Federal Advertising Agency, Inc. | 270 Park Avenue | New York | NY | ||
16301 | 16301 | 1952-05-14 | 1950-11-14 | Miller | Mathia | Federal Advertising Agency, Inc. 649 | 1950-11-14 | Federal Advertising Agency, Inc. | 270 Park Avenue | New York | NY | ||
16302 | 16302 | 1952-05-14 | 1950-11-14 | Plumb | Kenneth W. | Federal Advertising Agency, Inc. 649 | 1950-11-14 | Federal Advertising Agency, Inc. | 270 Park Avenue | New York | NY | ||
16303 | 16303 | 1952-05-14 | 1950-11-14 | Singer | Jules B. | Federal Advertising Agency, Inc. 649 | 1950-11-14 | Federal Advertising Agency, Inc. | 270 Park Avenue | New York | NY | ||
16304 | 16304 | 1952-05-14 | 1950-11-14 | Staples | Samuel Granville | Federal Advertising Agency, Inc. 649 | 1950-11-14 | Federal Advertising Agency, Inc. | 270 Park Avenue | New York | NY | ||
16305 | 16305 | 1952-05-14 | 1950-11-14 | Tax | Harry | Federal Advertising Agency, Inc. 649 | 1950-11-14 | Federal Advertising Agency, Inc. | 270 Park Avenue | New York | NY | ||
39515 | 39515 | 1950-12-31 | 1950-11-14 | Leopold | Joseph | Federal Advertising Agency, Inc. 649 | 1950-11-14 | Federal Advertising Agency, Inc. | 270 Park Avenue | New York | NY |
Advanced export
JSON shape: default, array, newline-delimited
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]) );