FARA_All_ShortForms

List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

300 rows where Registration_Number = 1481

✎ View and edit SQL

This data as json, atom, CSV (advanced)

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

State

Registration_Number

  • 1481 · 300 ✖

Registrant_Name

City

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
2513 2513 1986-01-01 1980-07-24 Mintz Gilda Yolles 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
2724 2724 2007-01-01 1979-07-16 Lipton Charles 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
2725 2725 2007-01-01 1962-08-09 Ruder William 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
2739 2739 2007-01-01 1966-12-30 Warshaw Saul Leon 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
2912 2912 1985-01-02 1981-02-23 Bagar Robert 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
3126 3126 1987-01-06 1986-09-21 Bigelow Astrid 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
3294 3294 1979-01-09 1977-09-22 Ryan Philip G. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
3582 3582 1987-01-15 1985-08-06 Cid Jorge Del 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
3593 3593 1992-01-15 1987-08-07 Steinberg Peter D. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
3701 3701 1968-01-17 1967-06-23 Snyder John I. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
3833 3833 1968-01-19 1963-04-26 Rosen Harold Bert 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
4252 4252 1979-01-26 1978-02-07 Gottesman Hyam 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
4402 4402 1976-01-28 1975-12-23 Javits Marion B. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
4532 4532 1983-01-30 1983-01-26 Hannawalt James F. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
4641 4641 1970-01-31 1964-06-08 Hunter Harry F. , Jr. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
4671 4671 1977-01-31 1973-10-31 Schneck Lucille Corrier 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
4708 4708 1984-01-31 1982-05-11 Rothrock Judith 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
4770 4770 1990-01-31 1987-08-10 Paris Peter Boston 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
4991 4991 2003-01-31 1979-04-25 Peters Sharon 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
5305 5305 1963-02-01 1962-04-27 Warshaw Saul Leon 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
5624 5624 2001-02-02 1999-10-28 Crespo Carrie 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
5791 5791 1971-02-05 1968-10-31 Rand Larry Anthony 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
5846 5846 1976-02-06 1973-05-22 Lindo Arthur S. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
5982 5982 1982-02-08 1981-02-23 Warren Suzanne L. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
6103 6103 1967-02-10 1966-12-30 Goff Daniel Neville 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
6401 6401 1992-02-14 1990-10-30 Postle Bradley R. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
6499 6499 1974-02-15 1973-05-22 Bach Helga Rieg 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
6608 6608 1987-02-16 1985-03-14 Rosenblat Arney 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
6683 6683 2001-02-16 2000-04-27 Baumgartner Lisa 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
6857 6857 1975-02-21 1974-05-30 Simon Edwin 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
6858 6858 1979-02-21 1977-09-22 Goldberg Ann E. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
6899 6899 1985-02-22 1983-10-12 Gorant Denise 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7019 7019 1978-02-24 1968-09-17 O'Connor Jean 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7220 7220 1991-02-26 1987-11-25 DeMala Pamela Sue 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7286 7286 1987-02-27 1985-08-21 Pew Gilda B. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7300 7300 1998-02-27 1996-05-03 Thiney Emmanuelle A. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7345 7345 1967-02-28 1966-12-30 Ferris Robert D. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7356 7356 1969-02-28 1967-06-23 Champion Eleanor M. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7358 7358 1969-02-28 1966-11-21 Valverde Geogia Lee 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7361 7361 1970-02-28 1964-02-10 Reilly Madeleine Halpin 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7379 7379 1976-02-28 1975-09-09 Booth Margaret 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7427 7427 1986-02-28 1963-11-08 Landman Amos 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7436 7436 1989-02-28 1987-01-05 Marks Roberta G. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7473 7473 1991-02-28 1990-04-27 Stern Ava 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7476 7476 1991-02-28 1986-05-23 Schechter William 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7908 7908 2000-02-29 1999-10-28 Essen Jennifer 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
8392 8392 1989-03-03 1986-05-28 Reilly James V. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
8546 8546 1997-03-05 1995-10-27 Dukas Richard 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
8737 8737 1969-03-07 1966-02-10 Unger David 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
9027 9027 1982-03-12 1981-02-23 Blane Susan Nierenberg 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
9147 9147 1980-03-14 1971-11-23 Bagar Robert Anthony 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
9246 9246 1975-03-15 1975-09-09 Birnbaum Jane 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
9254 9254 1979-03-15 1978-02-16 Halprin Jerome 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
9306 9306 2001-03-15 2000-04-27 Crownover Shannon 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
9357 9357 1970-03-16 1966-12-30 Rubinow Ronald William 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
9970 9970 1986-03-24 1985-03-19 Mouchly-Weiss Harriet 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
10135 10135 1965-03-27 1963-04-26 Ansberry Louise Steinman 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
10136 10136 1965-03-27 1964-11-12 Eckman Ralph Roland 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
10161 10161 1986-03-27 1975-09-09 Feinsot Louise 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
10177 10177 1992-03-27 1992-04-28 Merriam Dena 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
10228 10228 1972-03-28 1971-11-08 Brandt John 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
10399 10399 1971-03-30 1966-11-28 Lucas James Russel 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
10464 10464 1996-03-30 1995-04-28 Hirsch Susan 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
10705 10705 1971-03-31 1969-12-31 Abel Joan R. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
10734 10734 1975-03-31 1969-11-06 Penner Etsuko S. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
11121 11121 2000-03-31 1997-08-22 Golden-Vazquez Abigail 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
11126 11126 2000-03-31 1999-10-28 Janashvili Lev 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
11367 11367 2011-03-31 2000-04-27 Kalson David 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
11577 11577 1969-04-01 1963-03-25 Nash,Jr. Leslie A. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
11644 11644 1986-04-01 1980-12-01 Leavitt Joan K. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
11874 11874 1986-04-04 1985-08-08 Velasquez Rose 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
11991 11991 1999-04-06 1998-10-26 Fudukidis Alexander A. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
12012 12012 1986-04-07 1985-09-03 Meily Rene S. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
12184 12184 1998-04-09 1997-07-21 Smith Dov 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
12212 12212 1987-04-10 1987-01-05 Rothstein Richard J. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
12341 12341 1985-04-12 1981-02-23 Reimus Byron AQ. G. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
12482 12482 1968-04-15 1961-11-24 Weiner Richard 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
12522 12522 1985-04-15 1978-10-03 Byrnes Suzanne H. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
12528 12528 1986-04-15 1985-11-27 Mancini Elaine 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
12793 12793 1978-04-18 1977-04-01 Friedman Max J. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
12875 12875 1973-04-20 1971-11-23 Thompson Dede Eleanor 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
13101 13101 1967-04-24 1967-06-23 Damon Gordon G. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
13126 13126 1992-04-24 1986-06-24 Reagan Cornelia Ann 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
13169 13169 1986-04-25 1982-05-11 Ginsburg Ellin 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
13170 13170 1986-04-25 1981-06-16 Chioda Albert 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
13171 13171 1986-04-25 1983-10-12 Newby Justin Brook 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
13335 13335 1995-04-28 1991-04-26 Carter Caryn 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
13336 13336 1995-04-28 1993-05-03 Ennis Betsy 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
13347 13347 1995-04-28 1984-11-13 Peters Denis J. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
13405 13405 1994-04-29 1990-04-27 Wechselblatt Stephen 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
13561 13561 1978-04-30 1973-05-22 Ketola Hilja 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
13564 13564 1978-04-30 1977-09-27 Daspit Laurence Francis 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
13615 13615 1986-04-30 1985-08-08 Cutick Lisa 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
13619 13619 1986-04-30 1984-10-30 Wurfel Walter W. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
13621 13621 1987-04-30 1987-01-05 Seggev Michael S. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
13827 13827 1998-04-30 1985-09-03 Stahl Sandra 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
14079 14079 2011-04-30 1986-04-09 Bloomgarden Kathy 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
14250 14250 1971-05-01 1961-11-20 Paulson Alfred G. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
14301 14301 1985-05-01 1984-11-13 Gregg Anne M. 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
14310 14310 1986-05-01 1984-10-30 Birrell Jeffrey Clarke 1481 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022

Next page

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)
);
Powered by Datasette · Query took 313.202ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history