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

83 rows where Registration_Number = 2415

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date)

State 1

Registration_Number 1

  • FCB New York · 83 ✖

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
2588 2588 1980-01-01 1979-04-17 Glanz Marcia FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
2601 2601 1982-01-01 1981-09-25 Kreps David FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
2832 2832 2004-01-01 1990-11-07 Curtis David FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
3268 3268 1976-01-06 1973-03-28 Von Nardroff Elfrida FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
3707 3707 1994-01-14 1992-04-07 Reilly Joan FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
5734 5734 1982-02-01 1981-09-25 Jellicoe Nicholas FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
6074 6074 2001-02-03 1993-10-05 Peters Tammy B. FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
6330 6330 1997-02-07 1989-01-19 Vale Maggi FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
6345 6345 2017-02-07 2014-12-15 Wikoff Gregory FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
6916 6916 1974-02-15 1973-03-28 Sprague Jeremy D. FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
6922 6922 1978-02-15 1973-03-28 Conway Barbara FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
6923 6923 1978-02-15 1973-03-28 Lowe William H. , Jr. FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
6924 6924 1979-02-15 1978-04-25 Ward John FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
7984 7984 1991-02-28 1990-11-07 Landi Mike FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
9072 9072 2010-03-03 2009-08-06 Amorelli Mark Edward FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
9984 9984 2001-03-15 1981-09-25 Foster William FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
10060 10060 1990-03-16 1989-01-19 Wigdor Robert FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
10067 10067 2000-03-16 1989-01-19 Gulisano Sam FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
11066 11066 1996-03-29 1993-10-05 Smalls Diedre FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
11508 11508 1981-03-31 1977-12-07 Williams Theodore N. FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
12223 12223 2018-03-31 2018-03-20 Cocchiaro Alec FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
12235 12235 2018-03-31 2014-12-15 Resch Gary FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
12872 12872 1992-04-07 1973-03-28 Gromer Frank FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
12873 12873 1992-04-07 1973-03-28 Hofmann Charles B. FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
12874 12874 1992-04-07 1973-03-28 Kroll Robert FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
12875 12875 1992-04-07 1973-03-28 Strelecki A. Richard FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
12876 12876 1992-04-07 1979-04-17 Barrett Stephen FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
12877 12877 1992-04-07 1976-05-28 Schachter Roslyn FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
12878 12878 1992-04-07 1979-09-24 Meyerson Robert FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
12879 12879 1992-04-07 1981-09-25 Blumberg Arnold FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
12880 12880 1992-04-07 1981-09-25 Maude Rosemary FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
12881 12881 1992-04-07 1981-09-25 Meyer Edward FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
12882 12882 1992-04-07 1981-09-25 Pollack Peter John Michael FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
12883 12883 1992-04-07 1981-09-25 Thomas Richard FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
12884 12884 1992-04-07 1978-11-02 Hoff Ronald Gordon FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
12885 12885 1992-04-07 1978-11-02 Jones Abbott FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
12886 12886 1992-04-07 1978-11-02 Rosenstein Edward FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
12887 12887 1992-04-07 1977-12-07 Fields Stanley FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
13095 13095 1992-04-10 1990-11-07 Panayotopoulou Natasha FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
13324 13324 1993-04-14 1990-11-07 Gottfried Judy FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
13444 13444 1991-04-15 1990-11-07 Gross Scott FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
14050 14050 1997-04-24 1990-11-07 Styles Mike FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
14209 14209 2000-04-27 1989-01-19 Catena Joe FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
15494 15494 2013-05-01 2009-08-06 Bhajan Babita FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
15593 15593 1989-05-02 1989-01-19 Venezia Christina FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
15615 15615 1976-05-03 1973-03-28 MacPherson Orison FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
16527 16527 2003-05-16 1997-11-28 VanKampen Catherine FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
16598 16598 1990-05-17 1989-01-19 Smith Debbie FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
17626 17626 1974-05-31 1973-03-28 Fishman Erwin FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
20431 20431 1991-06-28 1989-01-19 Austin Robert FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
20543 20543 1991-06-29 1989-01-19 Becker Kate FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
22302 22302 2003-07-01 2002-10-08 Anderson Nancy FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
22683 22683 1978-07-07 1974-11-18 Lipsky Bernard FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
23723 23723 1989-07-21 1989-01-19 Kosanke Jay FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
26276 26276 1996-08-08 1990-11-07 Ploetz John FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
26324 26324 2008-08-09 2002-10-08 Emerson Michael FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
27333 27333 1989-08-24 1989-01-19 Zara Tom FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
28425 28425 2003-08-31 1989-01-19 Prugno Pat FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
28427 28427 2003-08-31 1999-04-02 Driska Kristen FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
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

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