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

17 rows where Registration_Number = 5116

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_First_Name, Short_Form_Termination_Date (date)

State 1

Registration_Number 1

  • Dentsu America, Inc. · 17 ✖

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
2869 2869 2010-01-01 2006-02-06 Shearer Ean K. Dentsu America, Inc. 5116 1996-06-24 Dentsu America, Inc. 32 Avenue of the Americas 16th Floor New York NY 10013
2870 2870 2010-01-01 2009-02-10 Kanfer Laura Dentsu America, Inc. 5116 1996-06-24 Dentsu America, Inc. 32 Avenue of the Americas 16th Floor New York NY 10013
2871 2871 2010-01-01 2009-02-10 Sheth Purvi Dentsu America, Inc. 5116 1996-06-24 Dentsu America, Inc. 32 Avenue of the Americas 16th Floor New York NY 10013
4642 4642 2006-01-27 2005-01-31 Novick Randy Dentsu America, Inc. 5116 1996-06-24 Dentsu America, Inc. 32 Avenue of the Americas 16th Floor New York NY 10013
6636 6636 2009-02-11 2009-02-10 McGuinness James Dentsu America, Inc. 5116 1996-06-24 Dentsu America, Inc. 32 Avenue of the Americas 16th Floor New York NY 10013
9065 9065 2006-03-03 1996-06-24 Pearsall Randolph Dentsu America, Inc. 5116 1996-06-24 Dentsu America, Inc. 32 Avenue of the Americas 16th Floor New York NY 10013
15761 15761 2005-05-05 2005-01-31 Masarof Madeline Dentsu America, Inc. 5116 1996-06-24 Dentsu America, Inc. 32 Avenue of the Americas 16th Floor New York NY 10013
16671 16671 2002-05-18 2001-05-11 Lucchino David L. Dentsu America, Inc. 5116 1996-06-24 Dentsu America, Inc. 32 Avenue of the Americas 16th Floor New York NY 10013
16979 16979 2004-05-23 2002-10-18 McClelland Jeff Dentsu America, Inc. 5116 1996-06-24 Dentsu America, Inc. 32 Avenue of the Americas 16th Floor New York NY 10013
27811 27811 2006-08-30 2004-07-29 Shepherd Eric Dentsu America, Inc. 5116 1996-06-24 Dentsu America, Inc. 32 Avenue of the Americas 16th Floor New York NY 10013
33576 33576 2008-10-24 2005-01-31 Rosa Jeannette Dentsu America, Inc. 5116 1996-06-24 Dentsu America, Inc. 32 Avenue of the Americas 16th Floor New York NY 10013
36128 36128 2009-11-20 2009-02-10 Blumberg Jessica Dentsu America, Inc. 5116 1996-06-24 Dentsu America, Inc. 32 Avenue of the Americas 16th Floor New York NY 10013
41159 41159 1999-12-31 1996-09-13 Watts Jessica Dentsu America, Inc. 5116 1996-06-24 Dentsu America, Inc. 32 Avenue of the Americas 16th Floor New York NY 10013
41190 41190 2000-12-31 1996-06-24 Sise Peyton Dentsu America, Inc. 5116 1996-06-24 Dentsu America, Inc. 32 Avenue of the Americas 16th Floor New York NY 10013
41357 41357 2004-12-31 1996-06-24 Bernasconi Paul Dentsu America, Inc. 5116 1996-06-24 Dentsu America, Inc. 32 Avenue of the Americas 16th Floor New York NY 10013
41358 41358 2004-12-31 1996-06-24 McClure Eric Dentsu America, Inc. 5116 1996-06-24 Dentsu America, Inc. 32 Avenue of the Americas 16th Floor New York NY 10013
41650 41650 2009-12-31 2009-02-10 Yunga Ebie Dentsu America, Inc. 5116 1996-06-24 Dentsu America, Inc. 32 Avenue of the Americas 16th Floor New York NY 10013

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