FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where Short_Form_Termination_Date = "1952-05-14"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date (date), Registration_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16290 | 16290 | 1952-05-14 | 1951-08-16 | O'Halloran | Doris G. | Federal Advertising Agency, Inc. 649 | 1950-11-14 | Federal Advertising Agency, Inc. | 270 Park Avenue | New York | NY | ||
16291 | 16291 | 1952-05-14 | 1951-08-16 | Lancaster | Orin L. | Federal Advertising Agency, Inc. 649 | 1950-11-14 | Federal Advertising Agency, Inc. | 270 Park Avenue | New York | NY | ||
16292 | 16292 | 1952-05-14 | 1951-08-16 | Rech | William L. | 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 |
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]) );