List of all short form registrants (active and terminated)

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

29 rows where Registration_Number = 991

View and edit SQL

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

State

Registration_Number

  • 991 · 29

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
495   2012-03-27 Bramble Sylma Brown 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 80 Broad Street Suite 3302 New York NY 10004
2299 1962-01-01 1961-09-05 Illenberger Theodora 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 80 Broad Street Suite 3302 New York NY 10004
3015 1959-01-06 1958-02-03 Tilker Kay Burr 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 80 Broad Street Suite 3302 New York NY 10004
4554 1963-01-31 1961-01-18 Craig Nicholas 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 80 Broad Street Suite 3302 New York NY 10004
4759 1992-01-31 1971-10-27 Lee Minnette H. 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 80 Broad Street Suite 3302 New York NY 10004
5247 1960-02-01 1959-09-10 Cobean Anne M. 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 80 Broad Street Suite 3302 New York NY 10004
10448 2002-03-29 1992-02-28 Youngman Michael J. 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 80 Broad Street Suite 3302 New York NY 10004
14516 1987-05-01 1975-02-16 Hawks Audrey Palmer 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 80 Broad Street Suite 3302 New York NY 10004
17368 1973-06-01 1963-02-07 Winsch Martin J. 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 80 Broad Street Suite 3302 New York NY 10004
17764 1990-06-04 1989-08-02 Campbell Caesar 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 80 Broad Street Suite 3302 New York NY 10004
19804 1978-06-30 1977-05-09 Morgan Peter George 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 80 Broad Street Suite 3302 New York NY 10004
20805 2019-06-30 2002-12-10 Riley Clyde Hugh 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 80 Broad Street Suite 3302 New York NY 10004
21372 1962-07-06 1961-02-23 Condon Jane H. 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 80 Broad Street Suite 3302 New York NY 10004
23349 1974-07-31 1973-10-01 Lewis Walter Terry 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 80 Broad Street Suite 3302 New York NY 10004
23494 1991-07-31 1989-08-02 Nikels Thomas 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 80 Broad Street Suite 3302 New York NY 10004
24081 1960-08-01 1959-09-10 Neill Jeffrey 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 80 Broad Street Suite 3302 New York NY 10004
24115 1971-08-01 1962-12-28 Greenidge Helen Doris 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 80 Broad Street Suite 3302 New York NY 10004
24406 1986-08-02 1982-04-26 Medhurst Joan D. 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 80 Broad Street Suite 3302 New York NY 10004
25621 1958-08-20 1958-02-03 Perry Marilyn Edith 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 80 Broad Street Suite 3302 New York NY 10004
28007 2011-09-09 2006-01-19 Lindsay Keith O'Neil 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 80 Broad Street Suite 3302 New York NY 10004
28479 1987-09-17 1985-08-06 Utter Ellen D. 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 80 Broad Street Suite 3302 New York NY 10004
28666 1973-09-21 1971-10-28 Hiller Herbert 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 80 Broad Street Suite 3302 New York NY 10004
28678 1981-09-21 1979-07-19 Crooks Winston D'Arcey 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 80 Broad Street Suite 3302 New York NY 10004
29294 1960-09-30 1956-12-31 Karwick Doris Lee Fletcher 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 80 Broad Street Suite 3302 New York NY 10004
29546 1991-09-30 1991-08-06 Rust Richard P. 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 80 Broad Street Suite 3302 New York NY 10004
30199 1958-10-01 1958-08-22 Miller Helga 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 80 Broad Street Suite 3302 New York NY 10004
30845 1976-10-08 1975-01-26 Pepperdine James 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 80 Broad Street Suite 3302 New York NY 10004
37392 1990-12-28 1988-02-03 Wilson Markly 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 80 Broad Street Suite 3302 New York NY 10004
39226 1998-12-31 1989-08-02 Brown Sylma 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 80 Broad Street Suite 3302 New York NY 10004

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