home / fara

Menu
  • Search all tables
  • GraphQL API

fara

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

Custom SQL query returning 101 rows (hide)

 
1
select 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 from FARA_All_ShortForms where "Registrant_Name" = :p0 order by rowid limit 101

Query parameters

This data as json, CSV

rowidShort_Form_Termination_DateShort_Form_DateShort_Form_Last_NameShort_Form_First_NameRegistration_NumberRegistration_DateRegistrant_NameAddress_1Address_2CityStateZip
246   2022-01-30 Caamano Antonia 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
449   2023-02-24 Lee Edmund 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
450   2023-02-24 Young Isabelle 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
492   2022-03-03 Ford Chase Aaron 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
735   2022-04-06 Enkhbaatar Odsuren 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
836   2023-04-19 Sinkovitz Lily 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
845   2023-04-20 Scarinzi Chip 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
867   2023-04-24 Johnson Stephanie 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
1273   2020-06-22 Bloomgarden Kathy 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
1275   2020-06-22 Rabe Brianna 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
1294   2021-06-25 Manella Isabel 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
1391   2022-07-11 Mautz Hannah 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
1480   2022-07-25 Yacavone Kyra 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
1544   2021-07-30 Mason Ryan 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
1545   2021-07-30 Munjal Sonali 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
2004   2022-10-21 Berry Haven 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
2092   2020-11-02 Ayromlou Maryam 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
2093   2020-11-02 Barrett Jenny 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
2094   2020-11-02 Dickter Noah 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
2095   2020-11-02 Francum Peyton 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
2097   2020-11-02 Kim Robin 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
2099   2020-11-02 Savarese Jessica 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
2101   2020-11-02 Yi Guen 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
2144   2022-11-11 Gusain Tripti 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
2635 1986-01-01 1980-07-24 Mintz Gilda Yolles 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
2846 2007-01-01 1979-07-16 Lipton Charles 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
2847 2007-01-01 1962-08-09 Ruder William 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
2861 2007-01-01 1966-12-30 Warshaw Saul Leon 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
3055 1985-01-02 1981-02-23 Bagar Robert 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
3277 1987-01-06 1986-09-21 Bigelow Astrid 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
3482 1979-01-09 1977-09-22 Ryan Philip G. 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
3790 1987-01-15 1985-08-06 Cid Jorge Del 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
3801 1992-01-15 1987-08-07 Steinberg Peter D. 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
3944 1968-01-17 1967-06-23 Snyder John I. 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
4076 2022-01-18 2021-05-14 Gould Charles 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
4083 1968-01-19 1963-04-26 Rosen Harold Bert 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
4515 1979-01-26 1978-02-07 Gottesman Hyam 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
4678 1976-01-28 1975-12-23 Javits Marion B. 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
4754 1989-01-29 1997-04-21 Rheem Donald L. II 4315 1989-11-09 Ruder Finn, Inc. 808 - 17th Street, N.W. Suite 600 Washington DC 20006
4814 1983-01-30 1983-01-26 Hannawalt James F. 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
4928 1970-01-31 1964-06-08 Hunter Harry F. , Jr. 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
4958 1977-01-31 1973-10-31 Schneck Lucille Corrier 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
4995 1984-01-31 1982-05-11 Rothrock Judith 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
5057 1990-01-31 1987-08-10 Paris Peter Boston 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
5278 2003-01-31 1979-04-25 Peters Sharon 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
5655 1963-02-01 1962-04-27 Warshaw Saul Leon 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
5981 2001-02-02 1999-10-28 Crespo Carrie 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
6098 2023-02-03 2022-09-21 Harb Krystel 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
6160 1971-02-05 1968-10-31 Rand Larry Anthony 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
6220 1976-02-06 1973-05-22 Lindo Arthur S. 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
6373 1982-02-08 1981-02-23 Warren Suzanne L. 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
6498 1967-02-10 1966-12-30 Goff Daniel Neville 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
6817 1992-02-14 1990-10-30 Postle Bradley R. 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
6917 1974-02-15 1973-05-22 Bach Helga Rieg 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7062 1987-02-16 1985-03-14 Rosenblat Arney 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7137 2001-02-16 2000-04-27 Baumgartner Lisa 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7328 1975-02-21 1974-05-30 Simon Edwin 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7329 1979-02-21 1977-09-22 Goldberg Ann E. 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7374 1985-02-22 1983-10-12 Gorant Denise 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7504 1978-02-24 1968-09-17 O'Connor Jean 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7710 1991-02-26 1987-11-25 DeMala Pamela Sue 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7784 1987-02-27 1985-08-21 Pew Gilda B. 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7798 1998-02-27 1996-05-03 Thiney Emmanuelle A. 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7846 1967-02-28 1966-12-30 Ferris Robert D. 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7857 1969-02-28 1967-06-23 Champion Eleanor M. 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7859 1969-02-28 1966-11-21 Valverde Geogia Lee 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7862 1970-02-28 1964-02-10 Reilly Madeleine Halpin 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7880 1976-02-28 1975-09-09 Booth Margaret 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7928 1986-02-28 1963-11-08 Landman Amos 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7937 1989-02-28 1987-01-05 Marks Roberta G. 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7974 1991-02-28 1990-04-27 Stern Ava 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
7977 1991-02-28 1986-05-23 Schechter William 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
8496 2000-02-29 1999-10-28 Essen Jennifer 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
8778 1990-03-01 1989-11-09 Bowman Christopher J. 4315 1989-11-09 Ruder Finn, Inc. 808 - 17th Street, N.W. Suite 600 Washington DC 20006
8946 2023-03-01 2022-09-21 Shulak Delayna 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
9025 1989-03-03 1986-05-28 Reilly James V. 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
9139 2022-03-04 2020-12-21 Caughman Katie 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
9182 1997-03-05 1995-10-27 Dukas Richard 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
9376 1969-03-07 1966-02-10 Unger David 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
9701 1982-03-12 1981-02-23 Blane Susan Nierenberg 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
9822 1980-03-14 1971-11-23 Bagar Robert Anthony 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
9923 1975-03-15 1975-09-09 Birnbaum Jane 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
9931 1979-03-15 1978-02-16 Halprin Jerome 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
9983 2001-03-15 2000-04-27 Crownover Shannon 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
10044 1970-03-16 1966-12-30 Rubinow Ronald William 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
10667 1986-03-24 1985-03-19 Mouchly-Weiss Harriet 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
10839 1965-03-27 1963-04-26 Ansberry Louise Steinman 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
10840 1965-03-27 1964-11-12 Eckman Ralph Roland 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
10865 1986-03-27 1975-09-09 Feinsot Louise 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
10881 1992-03-27 1992-04-28 Merriam Dena 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
10938 1972-03-28 1971-11-08 Brandt John 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
11113 1971-03-30 1966-11-28 Lucas James Russel 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
11178 1996-03-30 1995-04-28 Hirsch Susan 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
11423 1971-03-31 1969-12-31 Abel Joan R. 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
11452 1975-03-31 1969-11-06 Penner Etsuko S. 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
11810 1999-03-31 1997-04-21 Johnson Krista K. 4315 1989-11-09 Ruder Finn, Inc. 808 - 17th Street, N.W. Suite 600 Washington DC 20006
11839 2000-03-31 1997-08-22 Golden-Vazquez Abigail 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
11844 2000-03-31 1999-10-28 Janashvili Lev 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
12085 2011-03-31 2000-04-27 Kalson David 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
12396 1969-04-01 1963-03-25 Nash,Jr. Leslie A. 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
12463 1986-04-01 1980-12-01 Leavitt Joan K. 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
Powered by Datasette · Queries took 71.195ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history