FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where "Short_Form_Date" is on date 1998-01-13
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date (date)
Registration_Number 5
Registrant_Name 5
City 5
- New York 7
- Washington 2
- Atlanta 1
- Brooklyn 1
- New Orleans 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
108 | 108 | 1998-01-13 | Ginther | Jeffrey William | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 | |
3669 | 3669 | 1998-01-13 | 1998-01-13 | Trachtenberg | Sam | MIS United Enterprises, Inc. 5225 | 1998-01-13 | MIS United Enterprises, Inc. | 507 Ditmas Avenue | Brooklyn | NY | 11218 | |
14732 | 14732 | 1998-04-30 | 1998-01-13 | Nelson | William B. | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
19199 | 19199 | 1998-06-10 | 1998-01-13 | O'Shea | Michael A. | Rogers & Wells, LLP 3428 | 1982-12-10 | Rogers & Wells, LLP | 607 - 14th Street N.W. | Suite 900 | Washington | DC | 20005-2011 |
19200 | 19200 | 1998-06-10 | 1998-01-13 | Essaye | Anthony F. | Rogers & Wells, LLP 3428 | 1982-12-10 | Rogers & Wells, LLP | 607 - 14th Street N.W. | Suite 900 | Washington | DC | 20005-2011 |
22972 | 22972 | 2001-07-11 | 1998-01-13 | SanFilippo | Philip J. | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
23283 | 23283 | 1999-07-15 | 1998-01-13 | Anderson | Kristian C. | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
23743 | 23743 | 2000-07-21 | 1998-01-13 | Eden | Angel L. | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
27524 | 27524 | 1998-08-27 | 1998-01-13 | Mireskandari | Amir | Lugano Group, Inc. 5207 | 1997-09-08 | Lugano Group, Inc. | 201 St. Charles Avenue | Suite 2544 | New Orleans | LA | 70170-2500 |
32745 | 32745 | 2000-10-13 | 1998-01-13 | III | William D. Bakun | JETRO, Atlanta 4069 | 1987-12-01 | JETRO, Atlanta | 5901 Peachtree Dunwoody Rd, | Suite. B485 | Atlanta | GA | 30328 |
34458 | 34458 | 2002-10-31 | 1998-01-13 | Kanak | Janice L. | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
35387 | 35387 | 2001-11-07 | 1998-01-13 | Dykes-Milliken | Tracy | 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]) );