List of all short form registrants (active and terminated)

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

93 rows where Registration_Number = 2500

View and edit SQL

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

State

Registration_Number

  • 2500 · 93

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
103   2021-01-12 Hudak Cheryl 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
104   2021-01-12 Vazquez Vanessa 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
107   1998-01-13 Ginther Jeffrey William 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
420   1989-02-28 Torra Veronica 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
896   2019-05-07 Chavez Gricelda 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
905   2020-05-08 Dehn Kari 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
1151   2011-06-10 Ludington Thomas 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
1273   2012-07-07 Hodgson Christina L. 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
1957   2017-11-14 Deluca Salvatore 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
1958   2017-11-14 Obreiter Julie 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
2020   2019-11-26 LaCorazza Lauren 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
2042   2011-11-29 Taugher Daniel Rodgers 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
2043   2011-11-29 Victorin Ayanna N. 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
2205   2004-12-20 Jones Tina 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
3188 2008-01-08 2007-02-27 Rosenbaum Sarah 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
3229 2005-01-09 2004-12-20 Hahn Roseanne 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
3435 1985-01-14 1983-12-06 Cherwin Kathleen Ann 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
5987 2007-02-07 2004-12-20 Lluberes Johanna 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
6152 1984-02-10 1983-04-21 Mahedy Thomas P. 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
7250 2002-02-25 1984-10-11 Fair Myrna 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
7379 1981-02-27 1979-11-26 Schuerman Darryl 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
7738 2001-02-28 2001-08-29 Morgenthien Maureen 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
7760 2002-02-28 2001-08-29 Ball Jennifer L. 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
9769 2011-03-18 2009-09-10 Ceccarelli Daniel 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
10976 1979-03-31 1974-03-04 Somin Georgene Elizabeth 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
11029 1985-03-31 1984-05-17 Fredericks Cammele 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
11693 2017-03-31 2006-07-06 Reimers Barbara 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
12257 1993-04-06 1977-10-04 Sanguinetti M.A. 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
14095 1998-04-30 1998-01-13 Nelson William B. 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
14317 2007-04-30 2007-06-20 Kelly Denise M. 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
15237 1994-05-09 1989-02-28 Randall Lionel William 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
17080 1996-05-31 1984-06-28 Hendriks Winston K. 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
17632 1989-06-01 1988-04-21 Kwech Robert William 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
18279 1981-06-10 1980-04-17 Regan Edward J. 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
18818 2006-06-16 2006-07-06 Thomas Leah 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
18819 2010-06-16 2009-02-03 Joseph Gerod 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
18820 2010-06-16 1989-04-24 Akerman Judith V. 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
18821 2010-06-16 2008-06-16 Johnson Janeice 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
18822 2010-06-16 2006-07-06 Christoffersen Pamela 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
18823 2010-06-16 2006-07-06 Eden Barbara 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
18824 2010-06-16 2006-07-06 Hodgson Christina 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
18825 2010-06-16 2006-07-06 Mitchell Jackie 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
18826 2010-06-16 2006-07-06 Penny-Lewis Jennifer 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
18827 2010-06-16 1991-11-18 Gynell Sarah Lee 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
18828 2010-06-16 2004-12-20 Gladysz Marian 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
18829 2010-06-16 2004-12-20 Lawson Susan 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
18830 2010-06-16 2007-12-28 Pichs Ana 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
19118 1984-06-22 1977-10-18 O'Brien Brent C. 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
19487 2007-06-27 2004-12-20 Foste Donald 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
19988 1976-06-30 1974-03-30 Richardson David E. 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
20014 1978-06-30 1976-07-21 O'Brien Dorothy 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
20938 2016-06-30 2011-11-29 Foley Michael 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
21330 2007-07-01 2006-07-06 Hendriks Sylvia 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
21734 1985-07-08 1983-07-27 Hall Joseph R. 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
21939 2001-07-11 1998-01-13 SanFilippo Philip J. 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
22247 1999-07-15 1998-01-13 Anderson Kristian C. 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
22251 2000-07-15 1998-11-12 Long Lynda 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
22699 2000-07-21 1998-01-13 Eden Angel L. 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
22799 1982-07-23 1981-06-01 Cadis Lon G. 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
23306 2005-07-29 2004-12-20 Lewin Sanya 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
23673 1987-07-31 1984-10-23 Moss Jane Susan Salad 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
24696 2018-08-02 2012-07-07 Green Leslie 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
25393 1988-08-13 1985-10-21 Bush Cindy Sue 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
26408 1996-08-28 1996-08-28 McHenry Thomas R. 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
26532 2008-08-29 2004-12-20 Aiello Steven 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
26539 2017-08-29 2006-07-06 Goodwin Jahaira 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
26882 1984-08-31 1984-05-31 Gritsch Lucy 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
26911 1986-08-31 1984-08-13 Kreps Israel 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
29031 2007-09-22 2006-07-06 Thomas Annu 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
30345 2016-09-30 2011-08-03 Bolz Jennifer 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
31362 2005-10-12 2006-07-06 Kutny Kalyna 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
31556 1993-10-15 1987-04-01 Cook Kelly Sue 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
31846 1993-10-19 1983-12-06 Danko Jeanne Ellen 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
31914 2000-10-20 2001-08-29 Neary Joan S. 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
31915 2000-10-20 1985-10-21 Neary Joan S. 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
32105 1981-10-23 1979-04-20 Wenger Mary Lou 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
32314 1996-10-26 1989-04-24 Rodriguez Cynthia 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
32938 1990-10-31 1984-09-21 Hayes William C. 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
33085 2002-10-31 1998-01-13 Kanak Janice L. 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
33623 2011-11-01 2005-10-26 Himes Elizabeth 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
33679 1984-11-02 1984-10-16 Ingoglia Nancy J. 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
33756 2006-11-03 2006-07-06 McGuinness Kathleen Mahoney 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
33962 2001-11-07 1998-01-13 Dykes-Milliken Tracy 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
34734 2008-11-21 2008-06-16 Pisaturo Lisa 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
34992 2001-11-26 1993-04-07 Bertoluzzi Carol 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
34993 2001-11-26 1993-04-09 Doble Ana M. 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
36179 2013-12-03 2006-07-06 Gonzalez Manuel 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
36840 1981-12-15 1974-03-30 Wincher Susan Jean 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
36946 1984-12-16 1979-02-05 Mor Malka 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
38755 1985-12-31 1984-05-25 Detre Frank C. 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
38896 1988-12-31 1974-03-04 Bergstrom Eric J. 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
39547 1998-12-31 1991-11-18 Lavroff Barbara 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
39609 2000-12-31 1984-01-06 Leong Constance Cecilia 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801

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