FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where Registration_Number = 5116
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Termination_Date (date), Short_Form_Date (date)
State 1
- NY 17
Registration_Number 1
- Dentsu America, Inc. · 17 ✖
Registrant_Name 1
City 1
- New York 17
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
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]) );