FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
83 rows where Registration_Number = 2415
This data as json, CSV (advanced)
State 1
- NY 24
Registration_Number 1
- FCB New York · 24 ✖
Registrant_Name 1
- FCB New York 24
City 1
- New York 24
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29999 | 29999 | 2010-09-17 | 2009-08-06 | Loell | Keith | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
31107 | 31107 | 1994-09-30 | 1989-01-19 | Hoynes | Mike | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
31114 | 31114 | 1994-09-30 | 1978-11-02 | Hoynes | Michael | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
31612 | 31612 | 2017-09-30 | 2009-08-06 | Tarakajian | Peter Jeffrey | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
32038 | 32038 | 2010-10-01 | 2009-08-06 | Rosengarten | Ilana | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
32332 | 32332 | 1993-10-05 | 1974-04-17 | Reed | J. Walter | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
32333 | 32333 | 1993-10-05 | 1990-11-07 | O'Hearn | Denny | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
32334 | 32334 | 1993-10-05 | 1990-11-07 | Bertram | John | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
32531 | 32531 | 2015-10-09 | 2014-12-15 | Burns | Molly | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
34883 | 34883 | 1981-11-01 | 1981-09-25 | Smith | Andre | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
35625 | 35625 | 1999-11-11 | 1997-11-28 | Glover | Kelly | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
35810 | 35810 | 1976-11-15 | 1976-11-05 | Lindenmeyr | Carel | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
37986 | 37986 | 1997-12-09 | 1996-09-30 | Kirk | Marilyn | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
38059 | 38059 | 2005-12-10 | 2000-10-10 | Spitz | Jonathan | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
38437 | 38437 | 2013-12-15 | 1989-01-19 | Rosenbit | Scott | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
38439 | 38439 | 2014-12-15 | 1985-09-30 | Beck | Nancy | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
38440 | 38440 | 2014-12-15 | 1990-11-07 | Freedman | Meryl | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
38441 | 38441 | 2014-12-15 | 1990-11-07 | McKee | Catherine | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
39269 | 39269 | 1998-12-28 | 1998-09-23 | Palladino | Marisa | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
39428 | 39428 | 1998-12-30 | 1997-11-28 | McKeone | Kelly | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
40223 | 40223 | 1982-12-31 | 1978-04-25 | Cohen | Maxine | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
40794 | 40794 | 1994-12-31 | 1993-10-05 | Zoller | Kurt | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
40953 | 40953 | 1996-12-31 | 1989-01-19 | Davidian | David | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
41381 | 41381 | 2005-12-31 | 1989-01-19 | Budner | David | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 |
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]) );