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

30 rows where Registration_Number = 991

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Registration_Date (date)

State 1

  • - 30

Registration_Number 1

  • Caribbean Tourism Organization, USA Inc. · 30 ✖

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
660 660   2012-03-27 Bramble Sylma Brown Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
1503 1503   2021-07-28 Walters Neil Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
2524 2524 1962-01-01 1961-09-05 Illenberger Theodora Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
3263 3263 1959-01-06 1958-02-03 Tilker Kay Burr Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
4912 4912 1963-01-31 1961-01-18 Craig Nicholas Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
5117 5117 1992-01-31 1971-10-27 Lee Minnette H. Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
5648 5648 1960-02-01 1959-09-10 Cobean Anne M. Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
11073 11073 2002-03-29 1992-02-28 Youngman Michael J. Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
15383 15383 1987-05-01 1975-02-16 Hawks Audrey Palmer Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
18411 18411 1973-06-01 1963-02-07 Winsch Martin J. Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
18833 18833 1990-06-04 1989-08-02 Campbell Caesar Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
20929 20929 1978-06-30 1977-05-09 Morgan Peter George Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
21939 21939 2019-06-30 2002-12-10 Riley Clyde Hugh Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
22620 22620 1962-07-06 1961-02-23 Condon Jane H. Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
24681 24681 1974-07-31 1973-10-01 Lewis Walter Terry Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
24826 24826 1991-07-31 1989-08-02 Nikels Thomas Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
25447 25447 1960-08-01 1959-09-10 Neill Jeffrey Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
25481 25481 1971-08-01 1962-12-28 Greenidge Helen Doris Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
25784 25784 1986-08-02 1982-04-26 Medhurst Joan D. Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
27036 27036 1958-08-20 1958-02-03 Perry Marilyn Edith Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
29488 29488 2011-09-09 2006-01-19 Lindsay Keith O'Neil Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
29983 29983 1987-09-17 1985-08-06 Utter Ellen D. Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
30180 30180 1973-09-21 1971-10-28 Hiller Herbert Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
30192 30192 1981-09-21 1979-07-19 Crooks Winston D'Arcey Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
30819 30819 1960-09-30 1956-12-31 Karwick Doris Lee Fletcher Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
31071 31071 1991-09-30 1991-08-06 Rust Richard P. Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
31773 31773 1958-10-01 1958-08-22 Miller Helga Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
32442 32442 1976-10-08 1975-01-26 Pepperdine James Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
39261 39261 1990-12-28 1988-02-03 Wilson Markly Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
41100 41100 1998-12-31 1989-08-02 Brown Sylma Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    

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