FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where Registrant_Name = "Cayman Islands Department of Tourism", Registration_Number = 2500 and "Short_Form_Date" is on date 2006-07-06
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_First_Name, Short_Form_Termination_Date (date), Short_Form_Date (date)
State 1
- NY 13
Registration_Number 1
- Cayman Islands Department of Tourism · 13 ✖
Registrant_Name 1
- Cayman Islands Department of Tourism · 13 ✖
City 1
- New York 13
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12203 | 12203 | 2017-03-31 | 2006-07-06 | Reimers | Barbara | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
19713 | 19713 | 2006-06-16 | 2006-07-06 | Thomas | Leah | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
19717 | 19717 | 2010-06-16 | 2006-07-06 | Christoffersen | Pamela | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
19718 | 19718 | 2010-06-16 | 2006-07-06 | Eden | Barbara | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
19719 | 19719 | 2010-06-16 | 2006-07-06 | Hodgson | Christina | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
19720 | 19720 | 2010-06-16 | 2006-07-06 | Mitchell | Jackie | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
19721 | 19721 | 2010-06-16 | 2006-07-06 | Penny-Lewis | Jennifer | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
22314 | 22314 | 2007-07-01 | 2006-07-06 | Hendriks | Sylvia | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
27725 | 27725 | 2017-08-29 | 2006-07-06 | Goodwin | Jahaira | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
30281 | 30281 | 2007-09-22 | 2006-07-06 | Thomas | Annu | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
32708 | 32708 | 2005-10-12 | 2006-07-06 | Kutny | Kalyna | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
35181 | 35181 | 2006-11-03 | 2006-07-06 | McGuinness | Kathleen Mahoney | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
37705 | 37705 | 2013-12-03 | 2006-07-06 | Gonzalez | Manuel | Cayman Islands Department of Tourism 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
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]) );