FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where "Short_Form_Termination_Date" is on date 1987-10-31
This data as json, CSV (advanced)
Suggested facets: Zip, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 3
Registrant_Name 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34267 | 34267 | 1987-10-31 | 1985-01-28 | Chung | Min-Goo | Korea Trade Center, Miami 2758 | 1977-02-28 | Korea Trade Center, Miami | One Biscayne Tower | Suite 1620 | Miami | FL | 33131 |
34268 | 34268 | 1987-10-31 | 1981-04-20 | Montano | Charlaine | Trinidad & Tobago Tourist Board 3231 | 1981-04-20 | Trinidad & Tobago Tourist Board | 25 West 43rd Street | Suite 1508 | New York | NY | 10036 |
34269 | 34269 | 1987-10-31 | 1984-09-11 | Kim | Mahn Il | Korea Trade Center, Miami 2758 | 1977-02-28 | Korea Trade Center, Miami | One Biscayne Tower | Suite 1620 | Miami | FL | 33131 |
34270 | 34270 | 1987-10-31 | 1986-10-28 | Senn | Daniel | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
34271 | 34271 | 1987-10-31 | 1984-11-26 | Crichlow | Carol | Trinidad & Tobago Tourist Board 3231 | 1981-04-20 | Trinidad & Tobago Tourist Board | 25 West 43rd Street | Suite 1508 | New York | NY | 10036 |
34272 | 34272 | 1987-10-31 | 1984-11-26 | Forde | Janice B. | Trinidad & Tobago Tourist Board 3231 | 1981-04-20 | Trinidad & Tobago Tourist Board | 25 West 43rd Street | Suite 1508 | New York | NY | 10036 |
34273 | 34273 | 1987-10-31 | 1984-11-26 | McKoy | Hazel | Trinidad & Tobago Tourist Board 3231 | 1981-04-20 | Trinidad & Tobago Tourist Board | 25 West 43rd Street | Suite 1508 | New York | NY | 10036 |
34274 | 34274 | 1987-10-31 | 1984-11-26 | Pounder | Ann Marie | Trinidad & Tobago Tourist Board 3231 | 1981-04-20 | Trinidad & Tobago Tourist Board | 25 West 43rd Street | Suite 1508 | New York | NY | 10036 |
34275 | 34275 | 1987-10-31 | 1984-11-26 | Smith-Baptiste | Elizabeth | Trinidad & Tobago Tourist Board 3231 | 1981-04-20 | Trinidad & Tobago Tourist Board | 25 West 43rd Street | Suite 1508 | New York | NY | 10036 |
34276 | 34276 | 1987-10-31 | 1984-11-26 | Solomon | Marlene | Trinidad & Tobago Tourist Board 3231 | 1981-04-20 | Trinidad & Tobago Tourist Board | 25 West 43rd Street | Suite 1508 | New York | NY | 10036 |
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]) );