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

20 rows where Registrant_Name = "Ogilvy & Mather, Inc."

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

Registrant_Name 1

  • Ogilvy & Mather, Inc. · 20 ✖

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
20810 20810 1968-06-30 1964-12-03 Stowell Edward Esty Ogilvy & Mather, Inc. 1826 1964-12-03 Ogilvy & Mather, Inc. 2 East 48th Street   New York NY 10017
20818 20818 1971-06-30 1967-01-10 Canter Stanley D. Ogilvy & Mather, Inc. 1826 1964-12-03 Ogilvy & Mather, Inc. 2 East 48th Street   New York NY 10017
20819 20819 1971-06-30 1967-01-10 Fredericks Charles , Jr. Ogilvy & Mather, Inc. 1826 1964-12-03 Ogilvy & Mather, Inc. 2 East 48th Street   New York NY 10017
20820 20820 1971-06-30 1967-01-10 Herzbrun David Joseph Ogilvy & Mather, Inc. 1826 1964-12-03 Ogilvy & Mather, Inc. 2 East 48th Street   New York NY 10017
20821 20821 1971-06-30 1967-01-10 Korda Reva Ogilvy & Mather, Inc. 1826 1964-12-03 Ogilvy & Mather, Inc. 2 East 48th Street   New York NY 10017
20822 20822 1971-06-30 1967-01-10 Langhorne John , Jr. Ogilvy & Mather, Inc. 1826 1964-12-03 Ogilvy & Mather, Inc. 2 East 48th Street   New York NY 10017
20823 20823 1971-06-30 1967-01-10 Phillips William E. Ogilvy & Mather, Inc. 1826 1964-12-03 Ogilvy & Mather, Inc. 2 East 48th Street   New York NY 10017
20825 20825 1971-06-30 1965-01-25 Taylor Raymond Ogilvy & Mather, Inc. 1826 1964-12-03 Ogilvy & Mather, Inc. 2 East 48th Street   New York NY 10017
20827 20827 1971-06-30 1971-02-09 Kershaw Andrew G. Ogilvy & Mather, Inc. 1826 1964-12-03 Ogilvy & Mather, Inc. 2 East 48th Street   New York NY 10017
20833 20833 1971-06-30 1967-05-18 McCall Bruce Paul Gordon Ogilvy & Mather, Inc. 1826 1964-12-03 Ogilvy & Mather, Inc. 2 East 48th Street   New York NY 10017
20834 20834 1971-06-30 1965-06-25 Parker James M. Ogilvy & Mather, Inc. 1826 1964-12-03 Ogilvy & Mather, Inc. 2 East 48th Street   New York NY 10017
20835 20835 1971-06-30 1968-07-02 Hadley George Godard Ogilvy & Mather, Inc. 1826 1964-12-03 Ogilvy & Mather, Inc. 2 East 48th Street   New York NY 10017
20836 20836 1971-06-30 1971-08-06 Elliott John , Jr. Ogilvy & Mather, Inc. 1826 1964-12-03 Ogilvy & Mather, Inc. 2 East 48th Street   New York NY 10017
20837 20837 1971-06-30 1970-10-20 Walker John D. Ogilvy & Mather, Inc. 1826 1964-12-03 Ogilvy & Mather, Inc. 2 East 48th Street   New York NY 10017
20838 20838 1971-06-30 1968-10-21 Kullberg Gary W. Ogilvy & Mather, Inc. 1826 1964-12-03 Ogilvy & Mather, Inc. 2 East 48th Street   New York NY 10017
20839 20839 1971-06-30 1968-10-21 Schulberg Jay William Ogilvy & Mather, Inc. 1826 1964-12-03 Ogilvy & Mather, Inc. 2 East 48th Street   New York NY 10017
20840 20840 1971-06-30 1967-11-13 Keown Ian MacNeill Ogilvy & Mather, Inc. 1826 1964-12-03 Ogilvy & Mather, Inc. 2 East 48th Street   New York NY 10017
20841 20841 1971-06-30 1964-12-03 Biklen Paul Frederick Ogilvy & Mather, Inc. 1826 1964-12-03 Ogilvy & Mather, Inc. 2 East 48th Street   New York NY 10017
20842 20842 1971-06-30 1964-12-03 Ogilvy David MacKenzie Ogilvy & Mather, Inc. 1826 1964-12-03 Ogilvy & Mather, Inc. 2 East 48th Street   New York NY 10017
39863 39863 1968-12-31 1967-01-10 Detchon Elliott R. , Jr. Ogilvy & Mather, Inc. 1826 1964-12-03 Ogilvy & Mather, Inc. 2 East 48th Street   New York NY 10017

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